DBA Data[Home] [Help]

APPS.AP_WORKFLOW_PKG dependencies on MO_GLOBAL

Line 267: MO_GLOBAL.INIT ('SQLAP');

263: itemkey,
264: 'INTERNAL_REP_PERSON_ID',
265: l_next_approver.person_id);
266: --Now set the environment
267: MO_GLOBAL.INIT ('SQLAP');
268: MO_GLOBAL.set_policy_context('S',l_org_id);
269:
270: l_hist_rec.HISTORY_TYPE := 'HOLDAPPROVAL';
271: l_hist_rec.INVOICE_ID := l_invoice_id;

Line 268: MO_GLOBAL.set_policy_context('S',l_org_id);

264: 'INTERNAL_REP_PERSON_ID',
265: l_next_approver.person_id);
266: --Now set the environment
267: MO_GLOBAL.INIT ('SQLAP');
268: MO_GLOBAL.set_policy_context('S',l_org_id);
269:
270: l_hist_rec.HISTORY_TYPE := 'HOLDAPPROVAL';
271: l_hist_rec.INVOICE_ID := l_invoice_id;
272: l_hist_rec.ITERATION := l_iteration;

Line 417: MO_GLOBAL.INIT ('SQLAP');

413: 'INTERNAL_REP_DISPLAY_NAME');
414:
415:
416: --Now set the environment
417: MO_GLOBAL.INIT ('SQLAP');
418: MO_GLOBAL.set_policy_context('S',l_org_id);
419:
420: l_hist_rec.HISTORY_TYPE := 'HOLDAPPROVAL';
421: l_hist_rec.INVOICE_ID := l_invoice_id;

Line 418: MO_GLOBAL.set_policy_context('S',l_org_id);

414:
415:
416: --Now set the environment
417: MO_GLOBAL.INIT ('SQLAP');
418: MO_GLOBAL.set_policy_context('S',l_org_id);
419:
420: l_hist_rec.HISTORY_TYPE := 'HOLDAPPROVAL';
421: l_hist_rec.INVOICE_ID := l_invoice_id;
422: l_hist_rec.ITERATION := l_iteration;

Line 510: MO_GLOBAL.INIT ('SQLAP');

506: l_display_name := WF_ENGINE.getItemAttrText(itemtype, itemkey,
507: 'INTERNAL_REP_DISPLAY_NAME');
508:
509: --Now set the environment
510: MO_GLOBAL.INIT ('SQLAP');
511: MO_GLOBAL.set_policy_context('S',l_org_id);
512:
513: l_hist_rec.HISTORY_TYPE := 'HOLDAPPROVAL';
514: l_hist_rec.INVOICE_ID := l_invoice_id;

Line 511: MO_GLOBAL.set_policy_context('S',l_org_id);

507: 'INTERNAL_REP_DISPLAY_NAME');
508:
509: --Now set the environment
510: MO_GLOBAL.INIT ('SQLAP');
511: MO_GLOBAL.set_policy_context('S',l_org_id);
512:
513: l_hist_rec.HISTORY_TYPE := 'HOLDAPPROVAL';
514: l_hist_rec.INVOICE_ID := l_invoice_id;
515: l_hist_rec.ITERATION := l_iteration;

Line 614: MO_GLOBAL.INIT ('SQLAP');

610: l_display_name := WF_ENGINE.getItemAttrText(itemtype, itemkey,
611: 'INTERNAL_REP_DISPLAY_NAME');
612:
613: --Now set the environment
614: MO_GLOBAL.INIT ('SQLAP');
615: MO_GLOBAL.set_policy_context('S',l_org_id);
616:
617: l_hist_rec.HISTORY_TYPE := 'HOLDAPPROVAL';
618: l_hist_rec.INVOICE_ID := l_invoice_id;

Line 615: MO_GLOBAL.set_policy_context('S',l_org_id);

611: 'INTERNAL_REP_DISPLAY_NAME');
612:
613: --Now set the environment
614: MO_GLOBAL.INIT ('SQLAP');
615: MO_GLOBAL.set_policy_context('S',l_org_id);
616:
617: l_hist_rec.HISTORY_TYPE := 'HOLDAPPROVAL';
618: l_hist_rec.INVOICE_ID := l_invoice_id;
619: l_hist_rec.ITERATION := l_iteration;

Line 706: MO_GLOBAL.INIT ('SQLAP');

702:
703: l_display_name := WF_ENGINE.getItemAttrText(itemtype, itemkey,
704: 'INTERNAL_REP_DISPLAY_NAME');
705: --Now set the environment
706: MO_GLOBAL.INIT ('SQLAP');
707: MO_GLOBAL.set_policy_context('S',l_org_id);
708:
709: l_hist_rec.HISTORY_TYPE := 'HOLDAPPROVAL';
710: l_hist_rec.INVOICE_ID := l_invoice_id;

Line 707: MO_GLOBAL.set_policy_context('S',l_org_id);

703: l_display_name := WF_ENGINE.getItemAttrText(itemtype, itemkey,
704: 'INTERNAL_REP_DISPLAY_NAME');
705: --Now set the environment
706: MO_GLOBAL.INIT ('SQLAP');
707: MO_GLOBAL.set_policy_context('S',l_org_id);
708:
709: l_hist_rec.HISTORY_TYPE := 'HOLDAPPROVAL';
710: l_hist_rec.INVOICE_ID := l_invoice_id;
711: l_hist_rec.ITERATION := l_iteration;

Line 862: MO_GLOBAL.INIT ('SQLAP');

858: itemkey,
859: 'NOTF_ITERATION');
860:
861: --Now set the environment
862: MO_GLOBAL.INIT ('SQLAP');
863: MO_GLOBAL.set_policy_context('S',l_org_id);
864:
865: l_curr_calling_sequence := 'ap_workflow_pkg.process_accept_ext';
866: l_success := ap_etax_pkg.calling_etax(

Line 863: MO_GLOBAL.set_policy_context('S',l_org_id);

859: 'NOTF_ITERATION');
860:
861: --Now set the environment
862: MO_GLOBAL.INIT ('SQLAP');
863: MO_GLOBAL.set_policy_context('S',l_org_id);
864:
865: l_curr_calling_sequence := 'ap_workflow_pkg.process_accept_ext';
866: l_success := ap_etax_pkg.calling_etax(
867: p_invoice_id => l_invoice_id,

Line 1037: MO_GLOBAL.INIT ('SQLAP');

1033: itemkey,
1034: 'NOTF_ITERATION');
1035:
1036: --Now set the environment
1037: MO_GLOBAL.INIT ('SQLAP');
1038: MO_GLOBAL.set_policy_context('S',l_org_id);
1039:
1040: l_hist_rec.HISTORY_TYPE := 'HOLDNEGOTIATION';
1041: l_hist_rec.INVOICE_ID := l_invoice_id;

Line 1038: MO_GLOBAL.set_policy_context('S',l_org_id);

1034: 'NOTF_ITERATION');
1035:
1036: --Now set the environment
1037: MO_GLOBAL.INIT ('SQLAP');
1038: MO_GLOBAL.set_policy_context('S',l_org_id);
1039:
1040: l_hist_rec.HISTORY_TYPE := 'HOLDNEGOTIATION';
1041: l_hist_rec.INVOICE_ID := l_invoice_id;
1042: l_hist_rec.ITERATION := l_iteration;

Line 1177: MO_GLOBAL.INIT ('SQLAP');

1173: 'NOTF_ITERATION');
1174:
1175:
1176: --Now set the environment
1177: MO_GLOBAL.INIT ('SQLAP');
1178: MO_GLOBAL.set_policy_context('S',l_org_id);
1179:
1180: l_curr_calling_sequence := 'ap_workflow_pkg.process_accept_ext';
1181: l_success := ap_etax_pkg.calling_etax(

Line 1178: MO_GLOBAL.set_policy_context('S',l_org_id);

1174:
1175:
1176: --Now set the environment
1177: MO_GLOBAL.INIT ('SQLAP');
1178: MO_GLOBAL.set_policy_context('S',l_org_id);
1179:
1180: l_curr_calling_sequence := 'ap_workflow_pkg.process_accept_ext';
1181: l_success := ap_etax_pkg.calling_etax(
1182: p_invoice_id => l_invoice_id,

Line 3788: MO_GLOBAL.INIT ('SQLAP');

3784: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
3785: itemkey,
3786: 'ORG_ID');
3787:
3788: MO_GLOBAL.INIT ('SQLAP');
3789: MO_GLOBAL.set_policy_context('S',l_org_id);
3790:
3791:
3792: l_approver_name := WF_ENGINE.GetItemAttrText(itemtype,

Line 3789: MO_GLOBAL.set_policy_context('S',l_org_id);

3785: itemkey,
3786: 'ORG_ID');
3787:
3788: MO_GLOBAL.INIT ('SQLAP');
3789: MO_GLOBAL.set_policy_context('S',l_org_id);
3790:
3791:
3792: l_approver_name := WF_ENGINE.GetItemAttrText(itemtype,
3793: itemkey,

Line 3963: MO_GLOBAL.INIT ('SQLAP');

3959: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
3960: itemkey,
3961: 'ORG_ID');
3962:
3963: MO_GLOBAL.INIT ('SQLAP');
3964: MO_GLOBAL.set_policy_context('S',l_org_id);
3965:
3966:
3967: l_approver_name := WF_ENGINE.GetItemAttrText(itemtype,

Line 3964: MO_GLOBAL.set_policy_context('S',l_org_id);

3960: itemkey,
3961: 'ORG_ID');
3962:
3963: MO_GLOBAL.INIT ('SQLAP');
3964: MO_GLOBAL.set_policy_context('S',l_org_id);
3965:
3966:
3967: l_approver_name := WF_ENGINE.GetItemAttrText(itemtype,
3968: itemkey,

Line 4145: MO_GLOBAL.INIT ('SQLAP');

4141: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4142: itemkey,
4143: 'ORG_ID');
4144:
4145: MO_GLOBAL.INIT ('SQLAP');
4146: MO_GLOBAL.set_policy_context('S',l_org_id);
4147:
4148:
4149: l_approver_name := WF_ENGINE.GetItemAttrText(itemtype,

Line 4146: MO_GLOBAL.set_policy_context('S',l_org_id);

4142: itemkey,
4143: 'ORG_ID');
4144:
4145: MO_GLOBAL.INIT ('SQLAP');
4146: MO_GLOBAL.set_policy_context('S',l_org_id);
4147:
4148:
4149: l_approver_name := WF_ENGINE.GetItemAttrText(itemtype,
4150: itemkey,

Line 4495: MO_GLOBAL.INIT ('SQLAP');

4491: 'SUPPLIER_DISPLAY_NAME'));
4492:
4493: END IF;
4494: WF_ENGINE.startProcess('APINVHNE', l_new_child_itemkey);
4495: MO_GLOBAL.INIT ('SQLAP');
4496: MO_GLOBAL.set_policy_context('S',l_org_id);
4497:
4498: -- Complete the previous negotiation process if any.
4499:

Line 4496: MO_GLOBAL.set_policy_context('S',l_org_id);

4492:
4493: END IF;
4494: WF_ENGINE.startProcess('APINVHNE', l_new_child_itemkey);
4495: MO_GLOBAL.INIT ('SQLAP');
4496: MO_GLOBAL.set_policy_context('S',l_org_id);
4497:
4498: -- Complete the previous negotiation process if any.
4499:
4500: IF childkey IS NOT NULL THEN

Line 4764: MO_GLOBAL.INIT ('SQLAP');

4760: l_invoice_id := substr(itemkey, 1, instr(itemkey,'_')-1);
4761: l_iteration := substr(itemkey, instr(itemkey,'_')+1, length(itemkey));
4762:
4763: --Now set the environment
4764: MO_GLOBAL.INIT ('SQLAP');
4765: MO_GLOBAL.set_policy_context('S',l_org_id);
4766:
4767: --IF l_complete = ame_util.booleanTrue THEN /*no approver on the list*/
4768: IF l_next_approvers.count < 1 THEN

Line 4765: MO_GLOBAL.set_policy_context('S',l_org_id);

4761: l_iteration := substr(itemkey, instr(itemkey,'_')+1, length(itemkey));
4762:
4763: --Now set the environment
4764: MO_GLOBAL.INIT ('SQLAP');
4765: MO_GLOBAL.set_policy_context('S',l_org_id);
4766:
4767: --IF l_complete = ame_util.booleanTrue THEN /*no approver on the list*/
4768: IF l_next_approvers.count < 1 THEN
4769: resultout := wf_engine.eng_completed||':'||'FINISH';

Line 5010: MO_GLOBAL.INIT ('SQLAP');

5006: 'DOCUMENT_APPROVER');
5007:
5008:
5009: --Now set the environment
5010: MO_GLOBAL.INIT ('SQLAP');
5011: MO_GLOBAL.set_policy_context('S',l_org_id);
5012:
5013: -- see if we have an TCA/WF Directory api for this select
5014: /*

Line 5011: MO_GLOBAL.set_policy_context('S',l_org_id);

5007:
5008:
5009: --Now set the environment
5010: MO_GLOBAL.INIT ('SQLAP');
5011: MO_GLOBAL.set_policy_context('S',l_org_id);
5012:
5013: -- see if we have an TCA/WF Directory api for this select
5014: /*
5015: SELECT supervisor_id

Line 5190: MO_GLOBAL.INIT ('SQLAP');

5186: itemkey,
5187: 'NOTF_ITERATION');
5188:
5189: --Now set the environment
5190: MO_GLOBAL.INIT ('SQLAP');
5191: MO_GLOBAL.set_policy_context('S',l_org_id);
5192:
5193: --amy see if we have an TCA/WF Directory api for this select
5194: /*

Line 5191: MO_GLOBAL.set_policy_context('S',l_org_id);

5187: 'NOTF_ITERATION');
5188:
5189: --Now set the environment
5190: MO_GLOBAL.INIT ('SQLAP');
5191: MO_GLOBAL.set_policy_context('S',l_org_id);
5192:
5193: --amy see if we have an TCA/WF Directory api for this select
5194: /*
5195: SELECT supervisor_id

Line 5581: MO_GLOBAL.INIT ('SQLAP');

5577: 'SUPPLIER_ROLE'));
5578:
5579: END IF;
5580: WF_ENGINE.startProcess('APINVNEG', l_new_child_itemkey);
5581: MO_GLOBAL.INIT ('SQLAP');
5582: MO_GLOBAL.set_policy_context('S',l_org_id);
5583:
5584: IF childkey IS NOT NULL THEN
5585: l_notf_receipient_type := WF_ENGINE.GetItemAttrText('APINVNEG',

Line 5582: MO_GLOBAL.set_policy_context('S',l_org_id);

5578:
5579: END IF;
5580: WF_ENGINE.startProcess('APINVNEG', l_new_child_itemkey);
5581: MO_GLOBAL.INIT ('SQLAP');
5582: MO_GLOBAL.set_policy_context('S',l_org_id);
5583:
5584: IF childkey IS NOT NULL THEN
5585: l_notf_receipient_type := WF_ENGINE.GetItemAttrText('APINVNEG',
5586: childkey,

Line 7628: MO_GLOBAL.INIT ('SQLAP');

7624: l_status:='DELEGATED';
7625:
7626: --fnd_client_info.set_org_context(l_org_id);
7627: --Now set the environment
7628: MO_GLOBAL.INIT ('SQLAP');
7629: MO_GLOBAL.set_policy_context('S',l_org_id);
7630:
7631:
7632: /*insert_history( l_invoice_id,

Line 7629: MO_GLOBAL.set_policy_context('S',l_org_id);

7625:
7626: --fnd_client_info.set_org_context(l_org_id);
7627: --Now set the environment
7628: MO_GLOBAL.INIT ('SQLAP');
7629: MO_GLOBAL.set_policy_context('S',l_org_id);
7630:
7631:
7632: /*insert_history( l_invoice_id,
7633: l_iteration,

Line 7986: MO_GLOBAL.INIT ('SQLAP');

7982: l_status:='DELEGATED';
7983:
7984: --fnd_client_info.set_org_context(l_org_id);
7985: --Now set the environment
7986: MO_GLOBAL.INIT ('SQLAP');
7987: MO_GLOBAL.set_policy_context('S',l_org_id);
7988:
7989:
7990: /*insert_history( l_invoice_id,

Line 7987: MO_GLOBAL.set_policy_context('S',l_org_id);

7983:
7984: --fnd_client_info.set_org_context(l_org_id);
7985: --Now set the environment
7986: MO_GLOBAL.INIT ('SQLAP');
7987: MO_GLOBAL.set_policy_context('S',l_org_id);
7988:
7989:
7990: /*insert_history( l_invoice_id,
7991: l_iteration,