APPS.IBE_WORKFLOW_PVT dependencies on NLS_SESSION_PARAMETERS

Line 9864: FROM nls_session_parameters

9860: --check whether the session language/territory is the same as the
9861: --user's preference
9862: SELECT DISTINCT value
9863: INTO l_sess_lang
9864: FROM nls_session_parameters
9865: WHERE parameter = 'NLS_LANGUAGE';
9866:
9867: SELECT DISTINCT value
9868: INTO l_sess_terr

Line 9869: FROM nls_session_parameters

9865: WHERE parameter = 'NLS_LANGUAGE';
9866:
9867: SELECT DISTINCT value
9868: INTO l_sess_terr
9869: FROM nls_session_parameters
9870: WHERE parameter = 'NLS_TERRITORY';
9871:
9872: IF (l_sess_lang <> l_lang_pref) THEN
9873: --need to create an adhoc user

Line 9964: FROM nls_session_parameters

9960: 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);
9961:
9962: SELECT DISTINCT value
9963: INTO l_sess_lang
9964: FROM nls_session_parameters
9965: WHERE parameter = 'NLS_LANGUAGE';
9966:
9967: SELECT DISTINCT value
9968: INTO l_sess_terr

Line 9969: FROM nls_session_parameters

9965: WHERE parameter = 'NLS_LANGUAGE';
9966:
9967: SELECT DISTINCT value
9968: INTO l_sess_terr
9969: FROM nls_session_parameters
9970: WHERE parameter = 'NLS_TERRITORY';
9971:
9972: FOR i IN 1..p_wf_users_tbl.COUNT LOOP
9973: l_wf_role_usrs := l_wf_role_usrs ||','|| p_wf_users_tbl(i);