APPS.OKE_CONTRACT_APPROVAL_PVT dependencies on NLS_SESSION_PARAMETERS

Line 453: from NLS_SESSION_PARAMETERS

449: aname => 'SECURITY_GROUP_ID',
450: avalue => fnd_global.SECURITY_GROUP_id);
451: end;
452: select value into L_NLS_VALUE
453: from NLS_SESSION_PARAMETERS
454: where PARAMETER='NLS_LANGUAGE';
455: begin
456: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
457: itemkey => L_KEY,

Line 471: from NLS_SESSION_PARAMETERS

467: aname => 'NLS_LANGUAGE',
468: avalue => L_NLS_VALUE);
469: end;
470: select value into L_NLS_VALUE
471: from NLS_SESSION_PARAMETERS
472: where PARAMETER='NLS_DATE_FORMAT';
473: begin
474: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
475: itemkey => L_KEY,

Line 489: from NLS_SESSION_PARAMETERS

485: aname => 'NLS_DATE_FORMAT',
486: avalue => L_NLS_VALUE);
487: end;
488: select value into L_NLS_VALUE
489: from NLS_SESSION_PARAMETERS
490: where PARAMETER='NLS_DATE_LANGUAGE';
491: begin
492: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
493: itemkey => L_KEY,

Line 507: from NLS_SESSION_PARAMETERS

503: aname => 'NLS_DATE_LANGUAGE',
504: avalue => L_NLS_VALUE);
505: end;
506: select '"'||value||'"' into L_NLS_VALUE
507: from NLS_SESSION_PARAMETERS
508: where PARAMETER='NLS_NUMERIC_CHARACTERS';
509: begin
510: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
511: itemkey => L_KEY,

Line 969: from NLS_SESSION_PARAMETERS

965: aname => 'SECURITY_GROUP_ID',
966: avalue => fnd_global.SECURITY_GROUP_id);
967: end;
968: select value into L_NLS_VALUE
969: from NLS_SESSION_PARAMETERS
970: where PARAMETER='NLS_LANGUAGE';
971: begin
972: wf_engine.SetItemAttrText (itemtype => l_wf_name_active,
973: itemkey => L_KEY,

Line 987: from NLS_SESSION_PARAMETERS

983: aname => 'NLS_LANGUAGE',
984: avalue => L_NLS_VALUE);
985: end;
986: select value into L_NLS_VALUE
987: from NLS_SESSION_PARAMETERS
988: where PARAMETER='NLS_DATE_FORMAT';
989: begin
990: wf_engine.SetItemAttrText (itemtype => l_wf_name_active,
991: itemkey => L_KEY,

Line 1005: from NLS_SESSION_PARAMETERS

1001: aname => 'NLS_DATE_FORMAT',
1002: avalue => L_NLS_VALUE);
1003: end;
1004: select value into L_NLS_VALUE
1005: from NLS_SESSION_PARAMETERS
1006: where PARAMETER='NLS_DATE_LANGUAGE';
1007: begin
1008: wf_engine.SetItemAttrText (itemtype => l_wf_name_active,
1009: itemkey => L_KEY,

Line 1023: from NLS_SESSION_PARAMETERS

1019: aname => 'NLS_DATE_LANGUAGE',
1020: avalue => L_NLS_VALUE);
1021: end;
1022: select '"'||value||'"' into L_NLS_VALUE
1023: from NLS_SESSION_PARAMETERS
1024: where PARAMETER='NLS_NUMERIC_CHARACTERS';
1025: begin
1026: wf_engine.SetItemAttrText (itemtype => l_wf_name_active,
1027: itemkey => L_KEY,

Line 1104: from NLS_SESSION_PARAMETERS

1100: L_NLS_VALUE13 varchar2(40) := wf_engine.GetItemAttrText(p_item_type,p_item_key,'NLS_DATE_LANGUAGE');
1101: L_NLS_VALUE14 varchar2(40) := wf_engine.GetItemAttrText(p_item_type,p_item_key,'NLS_NUMERIC_CHARACTERS');
1102: cursor c1(p varchar2) is
1103: select value
1104: from NLS_SESSION_PARAMETERS
1105: where PARAMETER=p;
1106: begin
1107: open c1('NLS_LANGUAGE');
1108: fetch c1 into L_NLS_VALUE1;