APPS.OKC_CHANGE_CONTRACT_PVT dependencies on NLS_SESSION_PARAMETERS

Line 575: from NLS_SESSION_PARAMETERS

571: aname => 'RESP_APPL_ID',
572: avalue => fnd_global.RESP_APPL_id);
573: end;
574: select value into L_NLS_VALUE
575: from NLS_SESSION_PARAMETERS
576: where PARAMETER='NLS_LANGUAGE';
577: begin
578: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
579: itemkey => L_KEY,

Line 593: from NLS_SESSION_PARAMETERS

589: aname => 'NLS_LANGUAGE',
590: avalue => L_NLS_VALUE);
591: end;
592: select value into L_NLS_VALUE
593: from NLS_SESSION_PARAMETERS
594: where PARAMETER='NLS_DATE_FORMAT';
595: begin
596: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
597: itemkey => L_KEY,

Line 611: from NLS_SESSION_PARAMETERS

607: aname => 'NLS_DATE_FORMAT',
608: avalue => L_NLS_VALUE);
609: end;
610: select value into L_NLS_VALUE
611: from NLS_SESSION_PARAMETERS
612: where PARAMETER='NLS_DATE_LANGUAGE';
613: begin
614: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
615: itemkey => L_KEY,

Line 629: from NLS_SESSION_PARAMETERS

625: aname => 'NLS_DATE_LANGUAGE',
626: avalue => L_NLS_VALUE);
627: end;
628: select '"'||value||'"' into L_NLS_VALUE
629: from NLS_SESSION_PARAMETERS
630: where PARAMETER='NLS_NUMERIC_CHARACTERS';
631: begin
632: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
633: itemkey => L_KEY,