Friday, March 12, 2010
How to set context and profile values from backend in R12 Oracle apps
FUNCTION set_context( i_user_name IN VARCHAR2
,i_resp_name IN VARCHAR2
,i_org_id IN NUMBER)
RETURN VARCHAR2
IS
v_user_id NUMBER;
v_resp_id NUMBER;
v_resp_appl_id NUMBER;
v_lang VARCHAR2(100);
v_session_lang VARCHAR2(100):=fnd_global.current_language;
v_return VARCHAR2(10):='T';
v_nls_lang VARCHAR2(100);
v_org_id NUMBER:=i_org_id;
/* Cursor to get the user id information based on the input user name */
CURSOR cur_user
IS
SELECT user_id
FROM fnd_user
WHERE user_name = i_user_name;
/* Cursor to get the responsibility information */
CURSOR cur_resp
IS
SELECT responsibility_id
,application_id
,language
FROM fnd_responsibility_tl
WHERE responsibility_name = i_resp_name;
/* Cursor to get the nls language information for setting the language context */
CURSOR cur_lang(p_lang_code VARCHAR2)
IS
SELECT nls_language
FROM fnd_languages
WHERE language_code = p_lang_code;
BEGIN
/* To get the user id details */
OPEN cur_user;
FETCH cur_user INTO v_user_id;
IF cur_user%NOTFOUND
THEN
v_return:='F';
END IF; --IF cur_user%NOTFOUND
CLOSE cur_user;
/* To get the responsibility and responsibility application id */
OPEN cur_resp;
FETCH cur_resp INTO v_resp_id, v_resp_appl_id,v_lang;
IF cur_resp%NOTFOUND
THEN
v_return:='F';
END IF; --IF cur_resp%NOTFOUND
CLOSE cur_resp;
/* Setting the oracle applications context for the particular session */
fnd_global.apps_initialize ( user_id => v_user_id
,resp_id => v_resp_id
,resp_appl_id => v_resp_appl_id);
/* Setting the org context for the particular session */
mo_global.set_policy_context('S',v_org_id);
/* setting the nls context for the particular session */
IF v_session_lang != v_lang
THEN
OPEN cur_lang(v_lang);
FETCH cur_lang INTO v_nls_lang;
CLOSE cur_lang;
fnd_global.set_nls_context(v_nls_lang);
END IF; --IF v_session_lang != v_lang
RETURN v_return;
EXCEPTION
WHEN OTHERS THEN
RETURN 'F';
END set_context;
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
Disclaimer
The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.
9 Responses to “How to set context and profile values from backend in R12 Oracle apps”
February 19, 2016 at 2:23 AM
Very Helpfull Thanks
December 4, 2017 at 10:26 PM
Nice it seems to be good post... It will get readers engagement on the article since readers engagement plays an vital role in every blog.i am expecting more updated posts from your hands.
iOS App Development Company
Android App Development Company
Mobile App Development Company
April 1, 2021 at 11:48 PM
Considering all the moving parts, this was a project management masterpiece
user experience consulting
June 17, 2021 at 4:18 AM
Regardless of whether you need assistance generating traffic to some big advanced site or just easy methods to use
SF design studios
July 14, 2021 at 2:45 AM
The blog is absolutely fantastic! Lot of great information which can be helpful about benefits of developing website. Keep updating the blogs.
home services app development
October 7, 2021 at 12:50 AM
Thanks friends, for providing such enlightening data.
digital agencies San Francisco
October 7, 2021 at 12:53 AM
I agree. You have made the nice blogs with the great info in the contents.
Bay Area web design companies
March 11, 2022 at 8:44 AM
It looks great to know about the backend process for this, Try to use it for the OTT apps to make more effective
July 28, 2022 at 2:09 PM
Я давно пытаюсь привести себя в порядок, но если вижу разные вкусности, не могу сдержаться. Я долго искала средство для похудения, подруга посоветовала onetwoslim капли https://one-two-slim-kapli.ru/ (Вантуслим). Они мне нравятся, они снижают аппетит и сжигают жир, я даже ем запрещенные продукты, но отныне в умеренных количествах, и это сейчас крайне важно. Я не набираю лишних нагрузок, а наоборот, постепенно теряю лишнее.
Post a Comment