DBA Data[Home] [Help]

APPS.AP_WORKFLOW_PKG dependencies on MO_GLOBAL

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

271: itemkey,
272: 'INTERNAL_REP_PERSON_ID',
273: l_next_approver.person_id);
274: --Now set the environment
275: MO_GLOBAL.INIT ('SQLAP');
276: MO_GLOBAL.set_policy_context('S',l_org_id);
277:
278: l_hist_rec.HISTORY_TYPE := 'HOLDAPPROVAL';
279: l_hist_rec.INVOICE_ID := l_invoice_id;

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

272: 'INTERNAL_REP_PERSON_ID',
273: l_next_approver.person_id);
274: --Now set the environment
275: MO_GLOBAL.INIT ('SQLAP');
276: MO_GLOBAL.set_policy_context('S',l_org_id);
277:
278: l_hist_rec.HISTORY_TYPE := 'HOLDAPPROVAL';
279: l_hist_rec.INVOICE_ID := l_invoice_id;
280: l_hist_rec.ITERATION := l_iteration;

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

427: -- bug 8940578
428:
429:
430: --Now set the environment
431: MO_GLOBAL.INIT ('SQLAP');
432: MO_GLOBAL.set_policy_context('S',l_org_id);
433:
434: l_hist_rec.HISTORY_TYPE := 'HOLDAPPROVAL';
435: l_hist_rec.INVOICE_ID := l_invoice_id;

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

428:
429:
430: --Now set the environment
431: MO_GLOBAL.INIT ('SQLAP');
432: MO_GLOBAL.set_policy_context('S',l_org_id);
433:
434: l_hist_rec.HISTORY_TYPE := 'HOLDAPPROVAL';
435: l_hist_rec.INVOICE_ID := l_invoice_id;
436: l_hist_rec.ITERATION := l_iteration;

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

525: --Bug9069200
526: l_comments := WF_ENGINE.GetItemAttrText(itemtype,
527: itemkey,'WF_NOTE');
528: --Now set the environment
529: MO_GLOBAL.INIT ('SQLAP');
530: MO_GLOBAL.set_policy_context('S',l_org_id);
531:
532: l_hist_rec.HISTORY_TYPE := 'HOLDAPPROVAL';
533: l_hist_rec.INVOICE_ID := l_invoice_id;

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

526: l_comments := WF_ENGINE.GetItemAttrText(itemtype,
527: itemkey,'WF_NOTE');
528: --Now set the environment
529: MO_GLOBAL.INIT ('SQLAP');
530: MO_GLOBAL.set_policy_context('S',l_org_id);
531:
532: l_hist_rec.HISTORY_TYPE := 'HOLDAPPROVAL';
533: l_hist_rec.INVOICE_ID := l_invoice_id;
534: l_hist_rec.ITERATION := l_iteration;

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

636: 'WF_NOTE');
637: -- bug 8940578
638:
639: --Now set the environment
640: MO_GLOBAL.INIT ('SQLAP');
641: MO_GLOBAL.set_policy_context('S',l_org_id);
642:
643: l_hist_rec.HISTORY_TYPE := 'HOLDAPPROVAL';
644: l_hist_rec.INVOICE_ID := l_invoice_id;

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

637: -- bug 8940578
638:
639: --Now set the environment
640: MO_GLOBAL.INIT ('SQLAP');
641: MO_GLOBAL.set_policy_context('S',l_org_id);
642:
643: l_hist_rec.HISTORY_TYPE := 'HOLDAPPROVAL';
644: l_hist_rec.INVOICE_ID := l_invoice_id;
645: l_hist_rec.ITERATION := l_iteration;

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

733: --Bug9069200
734: l_comments := WF_ENGINE.GetItemAttrText(itemtype,
735: itemkey,'WF_NOTE');
736: --Now set the environment
737: MO_GLOBAL.INIT ('SQLAP');
738: MO_GLOBAL.set_policy_context('S',l_org_id);
739:
740: l_hist_rec.HISTORY_TYPE := 'HOLDAPPROVAL';
741: l_hist_rec.INVOICE_ID := l_invoice_id;

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

734: l_comments := WF_ENGINE.GetItemAttrText(itemtype,
735: itemkey,'WF_NOTE');
736: --Now set the environment
737: MO_GLOBAL.INIT ('SQLAP');
738: MO_GLOBAL.set_policy_context('S',l_org_id);
739:
740: l_hist_rec.HISTORY_TYPE := 'HOLDAPPROVAL';
741: l_hist_rec.INVOICE_ID := l_invoice_id;
742: l_hist_rec.ITERATION := l_iteration;

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

890: itemkey,
891: 'NOTF_ITERATION');
892:
893: --Now set the environment
894: MO_GLOBAL.INIT ('SQLAP');
895: MO_GLOBAL.set_policy_context('S',l_org_id);
896:
897: l_curr_calling_sequence := 'ap_workflow_pkg.process_accept_ext';
898: l_success := ap_etax_pkg.calling_etax(

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

891: 'NOTF_ITERATION');
892:
893: --Now set the environment
894: MO_GLOBAL.INIT ('SQLAP');
895: MO_GLOBAL.set_policy_context('S',l_org_id);
896:
897: l_curr_calling_sequence := 'ap_workflow_pkg.process_accept_ext';
898: l_success := ap_etax_pkg.calling_etax(
899: p_invoice_id => l_invoice_id,

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

1065: itemkey,
1066: 'NOTF_ITERATION');
1067:
1068: --Now set the environment
1069: MO_GLOBAL.INIT ('SQLAP');
1070: MO_GLOBAL.set_policy_context('S',l_org_id);
1071:
1072: l_hist_rec.HISTORY_TYPE := 'HOLDNEGOTIATION';
1073: l_hist_rec.INVOICE_ID := l_invoice_id;

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

1066: 'NOTF_ITERATION');
1067:
1068: --Now set the environment
1069: MO_GLOBAL.INIT ('SQLAP');
1070: MO_GLOBAL.set_policy_context('S',l_org_id);
1071:
1072: l_hist_rec.HISTORY_TYPE := 'HOLDNEGOTIATION';
1073: l_hist_rec.INVOICE_ID := l_invoice_id;
1074: l_hist_rec.ITERATION := l_iteration;

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

1205: 'NOTF_ITERATION');
1206:
1207:
1208: --Now set the environment
1209: MO_GLOBAL.INIT ('SQLAP');
1210: MO_GLOBAL.set_policy_context('S',l_org_id);
1211:
1212: l_curr_calling_sequence := 'ap_workflow_pkg.process_accept_ext';
1213: l_success := ap_etax_pkg.calling_etax(

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

1206:
1207:
1208: --Now set the environment
1209: MO_GLOBAL.INIT ('SQLAP');
1210: MO_GLOBAL.set_policy_context('S',l_org_id);
1211:
1212: l_curr_calling_sequence := 'ap_workflow_pkg.process_accept_ext';
1213: l_success := ap_etax_pkg.calling_etax(
1214: p_invoice_id => l_invoice_id,

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

3911: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
3912: itemkey,
3913: 'ORG_ID');
3914:
3915: MO_GLOBAL.INIT ('SQLAP');
3916: MO_GLOBAL.set_policy_context('S',l_org_id);
3917:
3918:
3919: l_approver_name := WF_ENGINE.GetItemAttrText(itemtype,

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

3912: itemkey,
3913: 'ORG_ID');
3914:
3915: MO_GLOBAL.INIT ('SQLAP');
3916: MO_GLOBAL.set_policy_context('S',l_org_id);
3917:
3918:
3919: l_approver_name := WF_ENGINE.GetItemAttrText(itemtype,
3920: itemkey,

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

4086: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4087: itemkey,
4088: 'ORG_ID');
4089:
4090: MO_GLOBAL.INIT ('SQLAP');
4091: MO_GLOBAL.set_policy_context('S',l_org_id);
4092:
4093:
4094: l_approver_name := WF_ENGINE.GetItemAttrText(itemtype,

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

4087: itemkey,
4088: 'ORG_ID');
4089:
4090: MO_GLOBAL.INIT ('SQLAP');
4091: MO_GLOBAL.set_policy_context('S',l_org_id);
4092:
4093:
4094: l_approver_name := WF_ENGINE.GetItemAttrText(itemtype,
4095: itemkey,

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

4268: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4269: itemkey,
4270: 'ORG_ID');
4271:
4272: MO_GLOBAL.INIT ('SQLAP');
4273: MO_GLOBAL.set_policy_context('S',l_org_id);
4274:
4275:
4276: l_approver_name := WF_ENGINE.GetItemAttrText(itemtype,

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

4269: itemkey,
4270: 'ORG_ID');
4271:
4272: MO_GLOBAL.INIT ('SQLAP');
4273: MO_GLOBAL.set_policy_context('S',l_org_id);
4274:
4275:
4276: l_approver_name := WF_ENGINE.GetItemAttrText(itemtype,
4277: itemkey,

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

4623: 'SUPPLIER_DISPLAY_NAME'));
4624:
4625: END IF;
4626: WF_ENGINE.startProcess('APINVHNE', l_new_child_itemkey);
4627: MO_GLOBAL.INIT ('SQLAP');
4628: MO_GLOBAL.set_policy_context('S',l_org_id);
4629:
4630: -- Complete the previous negotiation process if any.
4631:

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

4624:
4625: END IF;
4626: WF_ENGINE.startProcess('APINVHNE', l_new_child_itemkey);
4627: MO_GLOBAL.INIT ('SQLAP');
4628: MO_GLOBAL.set_policy_context('S',l_org_id);
4629:
4630: -- Complete the previous negotiation process if any.
4631:
4632: IF childkey IS NOT NULL THEN

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

4895: l_invoice_id := substr(itemkey, 1, instr(itemkey,'_')-1);
4896: l_iteration := substr(itemkey, instr(itemkey,'_')+1, length(itemkey));
4897:
4898: --Now set the environment
4899: MO_GLOBAL.INIT ('SQLAP');
4900: MO_GLOBAL.set_policy_context('S',l_org_id);
4901:
4902: --IF l_complete = ame_util.booleanTrue THEN /*no approver on the list*/
4903: IF l_next_approvers.count < 1 THEN

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

4896: l_iteration := substr(itemkey, instr(itemkey,'_')+1, length(itemkey));
4897:
4898: --Now set the environment
4899: MO_GLOBAL.INIT ('SQLAP');
4900: MO_GLOBAL.set_policy_context('S',l_org_id);
4901:
4902: --IF l_complete = ame_util.booleanTrue THEN /*no approver on the list*/
4903: IF l_next_approvers.count < 1 THEN
4904: resultout := wf_engine.eng_completed||':'||'FINISH';

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

5174: 'DOCUMENT_APPROVER');
5175:
5176:
5177: --Now set the environment
5178: MO_GLOBAL.INIT ('SQLAP');
5179: MO_GLOBAL.set_policy_context('S',l_org_id);
5180:
5181: -- see if we have an TCA/WF Directory api for this select
5182: /*

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

5175:
5176:
5177: --Now set the environment
5178: MO_GLOBAL.INIT ('SQLAP');
5179: MO_GLOBAL.set_policy_context('S',l_org_id);
5180:
5181: -- see if we have an TCA/WF Directory api for this select
5182: /*
5183: SELECT supervisor_id

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

5390: itemkey,
5391: 'NOTF_ITERATION');
5392:
5393: --Now set the environment
5394: MO_GLOBAL.INIT ('SQLAP');
5395: MO_GLOBAL.set_policy_context('S',l_org_id);
5396:
5397: --amy see if we have an TCA/WF Directory api for this select
5398: /*

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

5391: 'NOTF_ITERATION');
5392:
5393: --Now set the environment
5394: MO_GLOBAL.INIT ('SQLAP');
5395: MO_GLOBAL.set_policy_context('S',l_org_id);
5396:
5397: --amy see if we have an TCA/WF Directory api for this select
5398: /*
5399: SELECT supervisor_id

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

5818: 'SUPPLIER_ROLE'));
5819:
5820: END IF;
5821: WF_ENGINE.startProcess('APINVNEG', l_new_child_itemkey);
5822: MO_GLOBAL.INIT ('SQLAP');
5823: MO_GLOBAL.set_policy_context('S',l_org_id);
5824:
5825: IF childkey IS NOT NULL THEN
5826: l_notf_receipient_type := WF_ENGINE.GetItemAttrText('APINVNEG',

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

5819:
5820: END IF;
5821: WF_ENGINE.startProcess('APINVNEG', l_new_child_itemkey);
5822: MO_GLOBAL.INIT ('SQLAP');
5823: MO_GLOBAL.set_policy_context('S',l_org_id);
5824:
5825: IF childkey IS NOT NULL THEN
5826: l_notf_receipient_type := WF_ENGINE.GetItemAttrText('APINVNEG',
5827: childkey,

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

7995: l_status:='DELEGATED';
7996:
7997: --fnd_client_info.set_org_context(l_org_id);
7998: --Now set the environment
7999: MO_GLOBAL.INIT ('SQLAP');
8000: MO_GLOBAL.set_policy_context('S',l_org_id);
8001:
8002:
8003: /*insert_history( l_invoice_id,

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

7996:
7997: --fnd_client_info.set_org_context(l_org_id);
7998: --Now set the environment
7999: MO_GLOBAL.INIT ('SQLAP');
8000: MO_GLOBAL.set_policy_context('S',l_org_id);
8001:
8002:
8003: /*insert_history( l_invoice_id,
8004: l_iteration,

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

8361: l_status:='DELEGATED';
8362:
8363: --fnd_client_info.set_org_context(l_org_id);
8364: --Now set the environment
8365: MO_GLOBAL.INIT ('SQLAP');
8366: MO_GLOBAL.set_policy_context('S',l_org_id);
8367:
8368:
8369: /*insert_history( l_invoice_id,

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

8362:
8363: --fnd_client_info.set_org_context(l_org_id);
8364: --Now set the environment
8365: MO_GLOBAL.INIT ('SQLAP');
8366: MO_GLOBAL.set_policy_context('S',l_org_id);
8367:
8368:
8369: /*insert_history( l_invoice_id,
8370: l_iteration,

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

8877:
8878:
8879:
8880: --Defaulting the org id
8881: MO_GLOBAL.INIT ('SQLAP');
8882: MO_GLOBAL.set_policy_context('S',l_org_id);
8883: --Checking if the mode is TRANSFER
8884: IF ( funcmode = 'TRANSFER' ) THEN
8885: l_transfer_to_role :=WF_ENGINE.context_new_role; --Obtaining the forwardees role

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

8878:
8879:
8880: --Defaulting the org id
8881: MO_GLOBAL.INIT ('SQLAP');
8882: MO_GLOBAL.set_policy_context('S',l_org_id);
8883: --Checking if the mode is TRANSFER
8884: IF ( funcmode = 'TRANSFER' ) THEN
8885: l_transfer_to_role :=WF_ENGINE.context_new_role; --Obtaining the forwardees role
8886: l_original_recipient := WF_ENGINE.context_original_recipient; -- Obtaining the forwarder's role