APPS.OKC_ASYNC_PVT dependencies on NLS_SESSION_PARAMETERS

Line 122: from NLS_SESSION_PARAMETERS

118: p_recipient := NVL( wf_engine.GetItemAttrText(p_wf_name,p_key,'P_RESOLVER'),
119: NVL(wf_engine.GetItemAttrText(p_wf_name,p_key,'P_S_RECIPIENT'),
120: wf_engine.GetItemAttrText(p_wf_name,p_key,'P_E_RECIPIENT')));
121: select value into L_NLS_LANGUAGE
122: from NLS_SESSION_PARAMETERS
123: where PARAMETER='NLS_LANGUAGE';
124: select value into L_NLS_TERRITORY
125: from NLS_SESSION_PARAMETERS
126: where PARAMETER='NLS_TERRITORY';

Line 125: from NLS_SESSION_PARAMETERS

121: select value into L_NLS_LANGUAGE
122: from NLS_SESSION_PARAMETERS
123: where PARAMETER='NLS_LANGUAGE';
124: select value into L_NLS_TERRITORY
125: from NLS_SESSION_PARAMETERS
126: where PARAMETER='NLS_TERRITORY';
127: open nls_csr;
128: fetch nls_csr into l_nls_language, l_nls_territory, l_ntf_pref;
129: close nls_csr;

Line 478: from NLS_SESSION_PARAMETERS

474: l_nls_territory varchar2(100);
475: l1 varchar2(100);
476: cursor c1(p varchar2) is
477: select ''''||value||''''
478: from NLS_SESSION_PARAMETERS
479: where PARAMETER=p;
480: l_version number;
481: --
482: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'set_env';