APPS.OKC_REPORT_PVT dependencies on DBMS_SESSION

Line 989: -- 2. dbms_session.set_nls

985: -- PURPOSE
986: -- should be called from FROMS application
987: --
988: -- 1. apps_initialize
989: -- 2. dbms_session.set_nls
990: -- 3. exec
991: -- 4. besides it sets okc_tree_index.set_root_id(p_kid)
992: -- SQL statements use okc_tree_index.get_root_id as Contact Id
993: --

Line 1024: sys.dbms_session.set_nls('NLS_LANGUAGE',p_nlsl);

1020: open nls_csr('NLS_LANGUAGE');
1021: fetch nls_csr into l_value;
1022: close nls_csr;
1023: if (l_value<>p_nlsl) then
1024: sys.dbms_session.set_nls('NLS_LANGUAGE',p_nlsl);
1025: end if;
1026: open nls_csr('NLS_TERRITORY');
1027: fetch nls_csr into l_value;
1028: close nls_csr;

Line 1030: sys.dbms_session.set_nls('NLS_TERRITORY',p_nlst);

1026: open nls_csr('NLS_TERRITORY');
1027: fetch nls_csr into l_value;
1028: close nls_csr;
1029: if (l_value<>p_nlst) then
1030: sys.dbms_session.set_nls('NLS_TERRITORY',p_nlst);
1031: end if;
1032: fnd_profile.put('OKC_WEB_REPORT',p_xid);
1033: set_env(p_kid);
1034: exception