DBA Data[Home] [Help]

APPS.AP_WEB_PCARD_WORKFLOW_PKG dependencies on MO_GLOBAL

Line 110: Mo_global.init('SQLAP');

106: FND_GLOBAL.Resp_ID,
107: FND_GLOBAL.User_ID,
108: FND_GLOBAL.Security_Group_ID);*/
109: /*Setting the MOAC Access*/
110: Mo_global.init('SQLAP');
111: if p_org_id is not null then
112: Mo_Global.set_policy_context('S',p_org_id);
113: else
114: Mo_Global.set_policy_context('M',null);

Line 112: Mo_Global.set_policy_context('S',p_org_id);

108: FND_GLOBAL.Security_Group_ID);*/
109: /*Setting the MOAC Access*/
110: Mo_global.init('SQLAP');
111: if p_org_id is not null then
112: Mo_Global.set_policy_context('S',p_org_id);
113: else
114: Mo_Global.set_policy_context('M',null);
115: end if;
116:

Line 114: Mo_Global.set_policy_context('M',null);

110: Mo_global.init('SQLAP');
111: if p_org_id is not null then
112: Mo_Global.set_policy_context('S',p_org_id);
113: else
114: Mo_Global.set_policy_context('M',null);
115: end if;
116:
117: OPEN Emp_Verification_Workflows;
118:

Line 387: Mo_global.init('SQLAP');

383: FND_GLOBAL.Resp_ID,
384: FND_GLOBAL.User_ID,
385: FND_GLOBAL.Security_Group_ID)*/
386: /*MOAC Changes to be done*/
387: Mo_global.init('SQLAP');
388: if p_org_id is not null then
389: Mo_Global.set_policy_context('S',p_org_id);
390: else
391: Mo_Global.set_policy_context('M',null);

Line 389: Mo_Global.set_policy_context('S',p_org_id);

385: FND_GLOBAL.Security_Group_ID)*/
386: /*MOAC Changes to be done*/
387: Mo_global.init('SQLAP');
388: if p_org_id is not null then
389: Mo_Global.set_policy_context('S',p_org_id);
390: else
391: Mo_Global.set_policy_context('M',null);
392: end if;
393:

Line 391: Mo_Global.set_policy_context('M',null);

387: Mo_global.init('SQLAP');
388: if p_org_id is not null then
389: Mo_Global.set_policy_context('S',p_org_id);
390: else
391: Mo_Global.set_policy_context('M',null);
392: end if;
393:
394: OPEN Manager_Approval_Workflows;
395:

Line 734: Mo_Global.set_policy_context('S', l_org_id);

730: WHERE fl.employee_verification_id = p_employee_verification_id
731: OR (fd.feed_line_id = fl.feed_line_id AND
732: fd.employee_verification_id = p_employee_verification_id);
733: if (l_org_id is not null) then
734: Mo_Global.set_policy_context('S', l_org_id);
735: else
736: raise NO_DATA_FOUND;
737: end if;
738:

Line 759: Mo_Global.set_policy_context('S', l_org_id);

755: FROM ap_expense_feed_dists_all fd
756: WHERE fd.manager_approval_id = p_manager_approval_id;
757:
758: if (l_org_id is not null) then
759: Mo_Global.set_policy_context('S', l_org_id);
760: else
761: raise NO_DATA_FOUND;
762: end if;
763:

Line 853: Mo_Global.set_policy_context('S', l_org_id);

849: -- EmpVfyPCardSetOrgContext(l_emp_verification_id);
850: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,
851: p_item_key,
852: 'ORG_ID');
853: Mo_Global.set_policy_context('S', l_org_id);
854: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);
855:
856:
857: -------------------------------------------

Line 913: Mo_Global.set_policy_context('S', l_org_id);

909: --EmpVfyPCardSetOrgContext(l_emp_verification_id);
910: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,
911: p_item_key,
912: 'ORG_ID');
913: Mo_Global.set_policy_context('S', l_org_id);
914: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);
915: BEGIN
916: --bug5058949
917: --Performance fix

Line 989: Mo_Global.set_policy_context('S', l_org_id);

985: --EmpVfyPCardSetOrgContext(l_emp_verification_id);
986: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,
987: p_item_key,
988: 'ORG_ID');
989: Mo_Global.set_policy_context('S', l_org_id);
990: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);
991:
992:
993: SELECT count(*)

Line 1085: Mo_Global.set_policy_context('S', l_org_id);

1081: l_org_id:=WF_ENGINE.GetItemAttrNumber(p_item_type,
1082: p_item_key,
1083: 'ORG_ID');
1084:
1085: Mo_Global.set_policy_context('S', l_org_id);
1086:
1087: l_status_lookup_code := WF_ENGINE.GetItemAttrNumber(p_item_type,
1088: p_item_key,
1089: 'STATUS_LOOKUP_CODE');

Line 1316: Mo_Global.set_policy_context('S', l_org_id);

1312: --MgrAprvlPCardSetOrgContext(l_manager_approval_id);
1313: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,
1314: p_item_key,
1315: 'ORG_ID');
1316: Mo_Global.set_policy_context('S', l_org_id);
1317: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);
1318:
1319:
1320: BEGIN

Line 1374: Mo_Global.set_policy_context('S', l_org_id);

1370: --MgrAprvlPCardSetOrgContext(l_manager_approval_id);
1371: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,
1372: p_item_key,
1373: 'ORG_ID');
1374: Mo_Global.set_policy_context('S', l_org_id);
1375: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);
1376:
1377: BEGIN
1378: UPDATE ap_expense_feed_dists

Line 1469: Mo_Global.set_policy_context('S', l_org_id);

1465: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'MANAGER_APPROVAL_ID',l_manager_approval_id);
1466: l_org_id:= WF_ENGINE.GetItemAttrNumber(p_item_type,
1467: p_item_key,
1468: 'ORG_ID');
1469: Mo_Global.set_policy_context('S', l_org_id);
1470: WF_ENGINE.SetItemAttrNumber(p_item_type,p_item_key,'ORG_ID',l_org_id);
1471:
1472: --------------------------------------------
1473: l_debug_info := 'Open Expense Lines Cursor';