APPS.OKC_CONTRACT_APPROVAL_PVT dependencies on NLS_SESSION_PARAMETERS

Line 731: from NLS_SESSION_PARAMETERS

727: aname => 'SECURITY_GROUP_ID',
728: avalue => NVL(p_security_group_id,fnd_global.SECURITY_GROUP_id));
729: end;
730: select value into L_NLS_VALUE
731: from NLS_SESSION_PARAMETERS
732: where PARAMETER='NLS_LANGUAGE';
733: begin
734: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
735: itemkey => L_KEY,

Line 749: from NLS_SESSION_PARAMETERS

745: aname => 'NLS_LANGUAGE',
746: avalue => L_NLS_VALUE);
747: end;
748: select value into L_NLS_VALUE
749: from NLS_SESSION_PARAMETERS
750: where PARAMETER='NLS_DATE_FORMAT';
751: begin
752: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
753: itemkey => L_KEY,

Line 767: from NLS_SESSION_PARAMETERS

763: aname => 'NLS_DATE_FORMAT',
764: avalue => L_NLS_VALUE);
765: end;
766: select value into L_NLS_VALUE
767: from NLS_SESSION_PARAMETERS
768: where PARAMETER='NLS_DATE_LANGUAGE';
769: begin
770: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
771: itemkey => L_KEY,

Line 785: from NLS_SESSION_PARAMETERS

781: aname => 'NLS_DATE_LANGUAGE',
782: avalue => L_NLS_VALUE);
783: end;
784: select '"'||value||'"' into L_NLS_VALUE
785: from NLS_SESSION_PARAMETERS
786: where PARAMETER='NLS_NUMERIC_CHARACTERS';
787: begin
788: wf_engine.SetItemAttrText (itemtype => L_WF_NAME,
789: itemkey => L_KEY,

Line 1360: from NLS_SESSION_PARAMETERS

1356: aname => 'SECURITY_GROUP_ID',
1357: avalue => fnd_global.SECURITY_GROUP_id);
1358: end;
1359: select value into L_NLS_VALUE
1360: from NLS_SESSION_PARAMETERS
1361: where PARAMETER='NLS_LANGUAGE';
1362: begin
1363: wf_engine.SetItemAttrText (itemtype => l_wf_name_active,
1364: itemkey => L_KEY,

Line 1378: from NLS_SESSION_PARAMETERS

1374: aname => 'NLS_LANGUAGE',
1375: avalue => L_NLS_VALUE);
1376: end;
1377: select value into L_NLS_VALUE
1378: from NLS_SESSION_PARAMETERS
1379: where PARAMETER='NLS_DATE_FORMAT';
1380: begin
1381: wf_engine.SetItemAttrText (itemtype => l_wf_name_active,
1382: itemkey => L_KEY,

Line 1396: from NLS_SESSION_PARAMETERS

1392: aname => 'NLS_DATE_FORMAT',
1393: avalue => L_NLS_VALUE);
1394: end;
1395: select value into L_NLS_VALUE
1396: from NLS_SESSION_PARAMETERS
1397: where PARAMETER='NLS_DATE_LANGUAGE';
1398: begin
1399: wf_engine.SetItemAttrText (itemtype => l_wf_name_active,
1400: itemkey => L_KEY,

Line 1414: from NLS_SESSION_PARAMETERS

1410: aname => 'NLS_DATE_LANGUAGE',
1411: avalue => L_NLS_VALUE);
1412: end;
1413: select '"'||value||'"' into L_NLS_VALUE
1414: from NLS_SESSION_PARAMETERS
1415: where PARAMETER='NLS_NUMERIC_CHARACTERS';
1416: begin
1417: wf_engine.SetItemAttrText (itemtype => l_wf_name_active,
1418: itemkey => L_KEY,

Line 1582: from NLS_SESSION_PARAMETERS

1578: L_NLS_VALUE13 varchar2(40) := wf_engine.GetItemAttrText(p_item_type,p_item_key,'NLS_DATE_LANGUAGE');
1579: L_NLS_VALUE14 varchar2(40) := wf_engine.GetItemAttrText(p_item_type,p_item_key,'NLS_NUMERIC_CHARACTERS');
1580: cursor c1(p varchar2) is
1581: select value
1582: from NLS_SESSION_PARAMETERS
1583: where PARAMETER=p;
1584: begin
1585: open c1('NLS_LANGUAGE');
1586: fetch c1 into L_NLS_VALUE1;