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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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(
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,
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;
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;
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(
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,
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,
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,
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,
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,
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,
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,
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:
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
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
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';
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: /*
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
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: /*
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
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',
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,
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,
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,
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,
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,