APPS.IBE_WORKFLOW_PVT dependencies on NLS_SESSION_PARAMETERS

Line 9959: FROM nls_session_parameters

9955: --check whether the session language/territory is the same as the
9956: --user's preference
9957: SELECT DISTINCT value
9958: INTO l_sess_lang
9959: FROM nls_session_parameters
9960: WHERE parameter = 'NLS_LANGUAGE';
9961:
9962: SELECT DISTINCT value
9963: INTO l_sess_terr

Line 9964: FROM nls_session_parameters

9960: WHERE parameter = 'NLS_LANGUAGE';
9961:
9962: SELECT DISTINCT value
9963: INTO l_sess_terr
9964: FROM nls_session_parameters
9965: WHERE parameter = 'NLS_TERRITORY';
9966:
9967: IF (l_sess_lang <> l_lang_pref) THEN
9968: --need to create an adhoc user

Line 10059: FROM nls_session_parameters

10055: l_adhoc_role_display := substrb(('IBE'||FND_GLOBAL.User_ID||to_char(sysdate,'MMDDYYHH24MISS')||p_wf_users_tbl(1)||p_quote_header_id),1,320);
10056:
10057: SELECT DISTINCT value
10058: INTO l_sess_lang
10059: FROM nls_session_parameters
10060: WHERE parameter = 'NLS_LANGUAGE';
10061:
10062: SELECT DISTINCT value
10063: INTO l_sess_terr

Line 10064: FROM nls_session_parameters

10060: WHERE parameter = 'NLS_LANGUAGE';
10061:
10062: SELECT DISTINCT value
10063: INTO l_sess_terr
10064: FROM nls_session_parameters
10065: WHERE parameter = 'NLS_TERRITORY';
10066:
10067: FOR i IN 1..p_wf_users_tbl.COUNT LOOP
10068: l_wf_role_usrs := l_wf_role_usrs ||','|| p_wf_users_tbl(i);