DBA Data[Home] [Help]

APPS.OKE_CONTRACT_APPROVAL_PVT dependencies on FND_GLOBAL

Line 142: p_user_id => fnd_global.user_id,

138: RAISE OKE_API.G_EXCEPTION_ERROR;
139: END IF;
140: --
141: /* if k_accesible( p_contract_id => p_contract_id,
142: p_user_id => fnd_global.user_id,
143: p_level => 'U'
144: ) = OKE_API.G_FALSE
145: then
146: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

Line 396: avalue => fnd_global.user_id);

392: begin
393: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
394: itemkey => L_KEY,
395: aname => 'USER_ID',
396: avalue => fnd_global.user_id);
397: exception
398: when others then
399: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
400: itemkey => L_KEY,

Line 405: avalue => fnd_global.user_id);

401: aname => 'USER_ID');
402: wf_engine.SetItemAttrNumber(itemtype => L_WF_NAME,
403: itemkey => L_KEY,
404: aname => 'USER_ID',
405: avalue => fnd_global.user_id);
406: end;
407: begin
408: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
409: itemkey => L_KEY,

Line 411: avalue => fnd_global.resp_id);

407: begin
408: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
409: itemkey => L_KEY,
410: aname => 'RESP_ID',
411: avalue => fnd_global.resp_id);
412: exception
413: when others then
414: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
415: itemkey => L_KEY,

Line 420: avalue => fnd_global.resp_id);

416: aname => 'RESP_ID');
417: wf_engine.SetItemAttrNumber(itemtype => L_WF_NAME,
418: itemkey => L_KEY,
419: aname => 'RESP_ID',
420: avalue => fnd_global.resp_id);
421: end;
422: begin
423: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
424: itemkey => L_KEY,

Line 426: avalue => fnd_global.RESP_APPL_id);

422: begin
423: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
424: itemkey => L_KEY,
425: aname => 'RESP_APPL_ID',
426: avalue => fnd_global.RESP_APPL_id);
427: exception
428: when others then
429: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
430: itemkey => L_KEY,

Line 435: avalue => fnd_global.RESP_APPL_id);

431: aname => 'RESP_APPL_ID');
432: wf_engine.SetItemAttrNumber(itemtype => L_WF_NAME,
433: itemkey => L_KEY,
434: aname => 'RESP_APPL_ID',
435: avalue => fnd_global.RESP_APPL_id);
436: end;
437: begin
438: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
439: itemkey => L_KEY,

Line 441: avalue => fnd_global.SECURITY_GROUP_id);

437: begin
438: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,
439: itemkey => L_KEY,
440: aname => 'SECURITY_GROUP_ID',
441: avalue => fnd_global.SECURITY_GROUP_id);
442: exception
443: when others then
444: wf_engine.AddItemAttr (itemtype => L_WF_NAME,
445: itemkey => L_KEY,

Line 450: avalue => fnd_global.SECURITY_GROUP_id);

446: aname => 'SECURITY_GROUP_ID');
447: wf_engine.SetItemAttrNumber(itemtype => L_WF_NAME,
448: itemkey => L_KEY,
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';

Line 526: owner => fnd_global.user_name);

522: avalue => L_NLS_VALUE);
523: end;
524: wf_engine.SetItemOwner ( itemtype => L_WF_NAME,
525: itemkey => L_KEY,
526: owner => fnd_global.user_name);
527: wf_engine.StartProcess( itemtype => L_WF_NAME,
528: itemkey => L_KEY);
529: if (p_do_commit = OKE_API.G_TRUE) then
530: commit;

Line 682: and orig_system_id=fnd_global.user_id

678: /*
679: select display_name
680: from wf_roles
681: where orig_system = 'FND_USR'
682: and orig_system_id=fnd_global.user_id
683: -- changed to boost perf
684: */
685: select user_name display_name from fnd_user where user_id=fnd_global.user_id and EMPLOYEE_ID is null
686: union all

Line 685: select user_name display_name from fnd_user where user_id=fnd_global.user_id and EMPLOYEE_ID is null

681: where orig_system = 'FND_USR'
682: and orig_system_id=fnd_global.user_id
683: -- changed to boost perf
684: */
685: select user_name display_name from fnd_user where user_id=fnd_global.user_id and EMPLOYEE_ID is null
686: union all
687: select
688: PER.FULL_NAME display_name
689: from

Line 695: and USR.USER_ID = fnd_global.user_id

691: FND_USER USR
692: where trunc(SYSDATE)
693: between PER.EFFECTIVE_START_DATE and PER.EFFECTIVE_END_DATE
694: and PER.PERSON_ID = USR.EMPLOYEE_ID
695: and USR.USER_ID = fnd_global.user_id
696: ;
697: --
698: L_INITIATOR_NAME varchar2(100);
699: L_FINAL_APPROVER_UNAME varchar2(100);

Line 717: p_user_id => fnd_global.user_id,

713: RAISE OKE_API.G_EXCEPTION_ERROR;
714: END IF;
715: --
716: /* if k_accesible( p_contract_id => p_contract_id,
717: p_user_id => fnd_global.user_id,
718: p_level => 'U'
719: ) = OKE_API.G_FALSE
720: then
721: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

Line 912: avalue => fnd_global.user_id);

908: begin
909: wf_engine.SetItemAttrNumber (itemtype => l_wf_name_active,
910: itemkey => L_KEY,
911: aname => 'USER_ID',
912: avalue => fnd_global.user_id);
913: exception
914: when others then
915: wf_engine.AddItemAttr (itemtype => l_wf_name_active,
916: itemkey => L_KEY,

Line 921: avalue => fnd_global.user_id);

917: aname => 'USER_ID');
918: wf_engine.SetItemAttrNumber(itemtype => l_wf_name_active,
919: itemkey => L_KEY,
920: aname => 'USER_ID',
921: avalue => fnd_global.user_id);
922: end;
923: begin
924: wf_engine.SetItemAttrNumber (itemtype => l_wf_name_active,
925: itemkey => L_KEY,

Line 927: avalue => fnd_global.resp_id);

923: begin
924: wf_engine.SetItemAttrNumber (itemtype => l_wf_name_active,
925: itemkey => L_KEY,
926: aname => 'RESP_ID',
927: avalue => fnd_global.resp_id);
928: exception
929: when others then
930: wf_engine.AddItemAttr (itemtype => l_wf_name_active,
931: itemkey => L_KEY,

Line 936: avalue => fnd_global.resp_id);

932: aname => 'RESP_ID');
933: wf_engine.SetItemAttrNumber(itemtype => l_wf_name_active,
934: itemkey => L_KEY,
935: aname => 'RESP_ID',
936: avalue => fnd_global.resp_id);
937: end;
938: begin
939: wf_engine.SetItemAttrNumber (itemtype => l_wf_name_active,
940: itemkey => L_KEY,

Line 942: avalue => fnd_global.RESP_APPL_id);

938: begin
939: wf_engine.SetItemAttrNumber (itemtype => l_wf_name_active,
940: itemkey => L_KEY,
941: aname => 'RESP_APPL_ID',
942: avalue => fnd_global.RESP_APPL_id);
943: exception
944: when others then
945: wf_engine.AddItemAttr (itemtype => l_wf_name_active,
946: itemkey => L_KEY,

Line 951: avalue => fnd_global.RESP_APPL_id);

947: aname => 'RESP_APPL_ID');
948: wf_engine.SetItemAttrNumber(itemtype => l_wf_name_active,
949: itemkey => L_KEY,
950: aname => 'RESP_APPL_ID',
951: avalue => fnd_global.RESP_APPL_id);
952: end;
953: begin
954: wf_engine.SetItemAttrNumber (itemtype => l_wf_name_active,
955: itemkey => L_KEY,

Line 957: avalue => fnd_global.SECURITY_GROUP_id);

953: begin
954: wf_engine.SetItemAttrNumber (itemtype => l_wf_name_active,
955: itemkey => L_KEY,
956: aname => 'SECURITY_GROUP_ID',
957: avalue => fnd_global.SECURITY_GROUP_id);
958: exception
959: when others then
960: wf_engine.AddItemAttr (itemtype => l_wf_name_active,
961: itemkey => L_KEY,

Line 966: avalue => fnd_global.SECURITY_GROUP_id);

962: aname => 'SECURITY_GROUP_ID');
963: wf_engine.SetItemAttrNumber(itemtype => l_wf_name_active,
964: itemkey => L_KEY,
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';

Line 1045: owner => fnd_global.user_name);

1041: -- start
1042: --
1043: wf_engine.SetItemOwner ( itemtype => l_wf_name_active,
1044: itemkey => L_KEY,
1045: owner => fnd_global.user_name);
1046: wf_engine.StartProcess( itemtype => l_wf_name_active,
1047: itemkey => L_KEY);
1048:
1049: end if;--+ abort process exists

Line 1126: fnd_global.set_nls_context

1122: (L_NLS_VALUE12 = L_NLS_VALUE2) and
1123: (L_NLS_VALUE13 = L_NLS_VALUE3) and
1124: (L_NLS_VALUE14 = L_NLS_VALUE4)
1125: ) then
1126: fnd_global.set_nls_context
1127: (
1128: P_NLS_LANGUAGE => L_NLS_VALUE11,
1129: P_NLS_DATE_FORMAT => L_NLS_VALUE12,
1130: P_NLS_DATE_LANGUAGE => L_NLS_VALUE13,

Line 1133: fnd_global.apps_initialize

1129: P_NLS_DATE_FORMAT => L_NLS_VALUE12,
1130: P_NLS_DATE_LANGUAGE => L_NLS_VALUE13,
1131: P_NLS_NUMERIC_CHARACTERS => L_NLS_VALUE14);
1132: end if;
1133: fnd_global.apps_initialize
1134: (
1135: user_id =>
1136: wf_engine.GetItemAttrNumber(p_item_type,p_item_key,'USER_ID'),
1137: resp_id =>