eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WFAPPROVAL_PKG dependencies on WF_ENGINE

Line 140: l_check_PO_match := WF_ENGINE.GetItemAttrText(itemtype,

136:
137: BEGIN
138:
139: --check 'Approve PO Matched' flag here
140: l_check_PO_match := WF_ENGINE.GetItemAttrText(itemtype,
141: itemkey,
142: 'APINV_AAPO');
143:
144: --we need to get the org_id until I can change the raise event

Line 153: WF_ENGINE.SETITEMATTRNumber(itemtype,

149: FROM ap_invoices_all
150: WHERE invoice_id = substr(itemkey, 1, instr(itemkey,'_')-1);
151:
152: -- lets go ahead and set the wf attribute
153: WF_ENGINE.SETITEMATTRNumber(itemtype,
154: itemkey,
155: 'APINV_AOI',
156: l_org_id);
157:

Line 172: resultout := wf_engine.eng_completed||':'||'Y';

168: AND invoice_id = substr(itemkey, 1, instr(itemkey,'_')-1);
169:
170:
171: IF nvl(l_po_count,0) = 0 THEN
172: resultout := wf_engine.eng_completed||':'||'Y';
173: --update invoice status
174: UPDATE AP_INVOICES
175: SET wfapproval_status = 'NOT REQUIRED'
176: WHERE invoice_id = substr(itemkey, 1, instr(itemkey,'_')-1)

Line 179: resultout := wf_engine.eng_completed||':'||'N';

175: SET wfapproval_status = 'NOT REQUIRED'
176: WHERE invoice_id = substr(itemkey, 1, instr(itemkey,'_')-1)
177: AND wfapproval_status <> 'MANUALLY APPROVED';
178: ELSE
179: resultout := wf_engine.eng_completed||':'||'N';
180: END IF;
181: ELSE
182: resultout := wf_engine.eng_completed||':'||'N';
183: END IF;

Line 182: resultout := wf_engine.eng_completed||':'||'N';

178: ELSE
179: resultout := wf_engine.eng_completed||':'||'N';
180: END IF;
181: ELSE
182: resultout := wf_engine.eng_completed||':'||'N';
183: END IF;
184:
185: WF_ENGINE.SETITEMATTRText(itemtype,
186: itemkey,

Line 185: WF_ENGINE.SETITEMATTRText(itemtype,

181: ELSE
182: resultout := wf_engine.eng_completed||':'||'N';
183: END IF;
184:
185: WF_ENGINE.SETITEMATTRText(itemtype,
186: itemkey,
187: 'APINV_ADB',
188: l_debug);
189: EXCEPTION

Line 246: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

242: APP_EXCEPTION.RAISE_EXCEPTION;
243:
244: END IF;
245:
246: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
247: itemkey,
248: 'APINV_AOI');
249:
250: l_invoice_id := substr(itemkey, 1, instr(itemkey,'_')-1);

Line 259: resultout := wf_engine.eng_completed||':'||'N';

255: -- bug 4961253 added user_id condition.
256: IF l_next_approver.person_id is null
257: AND l_next_approver.user_id is null THEN /*no approver on the list*/
258:
259: resultout := wf_engine.eng_completed||':'||'N';
260:
261: --check for prior approvers
262: SELECT count(*)
263: INTO l_count

Line 306: WF_ENGINE.SetItemAttrText(itemtype,

302: l_name,
303: l_display_name);
304:
305:
306: WF_ENGINE.SetItemAttrText(itemtype,
307: itemkey,
308: 'APINV_ANA',
309: l_display_name);
310:

Line 311: WF_ENGINE.SetItemAttrNumber(itemtype,

307: itemkey,
308: 'APINV_ANA',
309: l_display_name);
310:
311: WF_ENGINE.SetItemAttrNumber(itemtype,
312: itemkey,
313: 'APINV_ANAI',
314: l_orig_sys_id); --bug4961253
315:

Line 316: WF_ENGINE.SetItemAttrText(itemtype,

312: itemkey,
313: 'APINV_ANAI',
314: l_orig_sys_id); --bug4961253
315:
316: WF_ENGINE.SetItemAttrText(itemtype,
317: itemkey,
318: 'APINV_ARN',
319: l_role);
320:

Line 321: WF_ENGINE.SetItemAttrText(itemtype,

317: itemkey,
318: 'APINV_ARN',
319: l_role);
320:
321: WF_ENGINE.SetItemAttrText(itemtype,
322: itemkey,
323: 'APINV_AAN',
324: l_display_name);
325:

Line 330: resultout := wf_engine.eng_completed||':'||'Y';

326:
327: --call set attributes so that notification tokens will be correct
328: set_attribute_values(itemtype,itemkey);
329:
330: resultout := wf_engine.eng_completed||':'||'Y';
331:
332: insert_history(itemtype,itemkey);
333: END IF;
334: WF_ENGINE.SETITEMATTRText(itemtype,

Line 334: WF_ENGINE.SETITEMATTRText(itemtype,

330: resultout := wf_engine.eng_completed||':'||'Y';
331:
332: insert_history(itemtype,itemkey);
333: END IF;
334: WF_ENGINE.SETITEMATTRText(itemtype,
335: itemkey,
336: 'APINV_ADB',
337: l_debug_info);
338:

Line 375: l_approver := WF_ENGINE.GetItemAttrText(itemtype,

371:
372: BEGIN
373: --Get attribute values to update the history table
374:
375: l_approver := WF_ENGINE.GetItemAttrText(itemtype,
376: itemkey,
377: 'APINV_ANA');
378:
379: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 379: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,

375: l_approver := WF_ENGINE.GetItemAttrText(itemtype,
376: itemkey,
377: 'APINV_ANA');
378:
379: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,
380: itemkey,
381: 'APINV_ANAI');
382:
383: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 383: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,

379: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,
380: itemkey,
381: 'APINV_ANAI');
382:
383: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
384: itemkey,
385: 'APINV_AII');
386:
387: l_comments := WF_ENGINE.GetItemAttrText(itemtype,

Line 387: l_comments := WF_ENGINE.GetItemAttrText(itemtype,

383: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
384: itemkey,
385: 'APINV_AII');
386:
387: l_comments := WF_ENGINE.GetItemAttrText(itemtype,
388: itemkey,
389: 'APINV_AC');
390:
391: l_hist_id := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 391: l_hist_id := WF_ENGINE.GetItemAttrNumber(itemtype,

387: l_comments := WF_ENGINE.GetItemAttrText(itemtype,
388: itemkey,
389: 'APINV_AC');
390:
391: l_hist_id := WF_ENGINE.GetItemAttrNumber(itemtype,
392: itemkey,
393: 'APINV_AHI');
394:
395: --Bug 2685695

Line 396: l_result := WF_ENGINE.GetActivityAttrText(itemtype,

392: itemkey,
393: 'APINV_AHI');
394:
395: --Bug 2685695
396: l_result := WF_ENGINE.GetActivityAttrText(itemtype,
397: itemkey,
398: actid,
399: 'APINV_RSLT');
400:

Line 401: l_amount := WF_ENGINE.GetItemAttrNumber(itemtype,

397: itemkey,
398: actid,
399: 'APINV_RSLT');
400:
401: l_amount := WF_ENGINE.GetItemAttrNumber(itemtype,
402: itemkey,
403: 'APINV_AIA');
404:
405: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 405: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

401: l_amount := WF_ENGINE.GetItemAttrNumber(itemtype,
402: itemkey,
403: 'APINV_AIA');
404:
405: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
406: itemkey,
407: 'APINV_AOI');
408:
409: --Now set the environment

Line 413: WF_ENGINE.SetItemAttrText(itemtype,

409: --Now set the environment
410: fnd_client_info.set_org_context(l_org_id);
411:
412:
413: WF_ENGINE.SetItemAttrText(itemtype,
414: itemkey,
415: 'APINV_APC',
416: l_comments);
417:

Line 495: l_approver := WF_ENGINE.GetItemAttrText(itemtype,

491:
492: BEGIN
493: --Get attribute values to create record in the history table
494:
495: l_approver := WF_ENGINE.GetItemAttrText(itemtype,
496: itemkey,
497: 'APINV_ANA');
498:
499: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 499: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,

495: l_approver := WF_ENGINE.GetItemAttrText(itemtype,
496: itemkey,
497: 'APINV_ANA');
498:
499: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,
500: itemkey,
501: 'APINV_ANAI');
502:
503: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 503: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,

499: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,
500: itemkey,
501: 'APINV_ANAI');
502:
503: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
504: itemkey,
505: 'APINV_AII');
506:
507: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 507: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,

503: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
504: itemkey,
505: 'APINV_AII');
506:
507: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,
508: itemkey,
509: 'APINV_AI');
510:
511: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 511: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,

507: l_iteration := WF_ENGINE.GetItemAttrNumber(itemtype,
508: itemkey,
509: 'APINV_AI');
510:
511: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,
512: itemkey,
513: 'APINV_AOI');
514:
515: l_amount := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 515: l_amount := WF_ENGINE.GetItemAttrNumber(itemtype,

511: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,
512: itemkey,
513: 'APINV_AOI');
514:
515: l_amount := WF_ENGINE.GetItemAttrNumber(itemtype,
516: itemkey,
517: 'APINV_AIA');
518:
519:

Line 557: WF_ENGINE.SetItemAttrNumber(itemtype,

553: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1),
554: l_org_id,
555: l_amount);
556:
557: WF_ENGINE.SetItemAttrNumber(itemtype,
558: itemkey,
559: 'APINV_AHI',
560: l_hist_id);
561:

Line 643: l_employee_id := WF_ENGINE.GetItemAttrNumber(itemtype,

639:
640: BEGIN
641:
642: /*Get the current approver's manager*/
643: l_employee_id := WF_ENGINE.GetItemAttrNumber(itemtype,
644: itemkey,
645: 'APINV_ANAI');
646:
647: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 647: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,

643: l_employee_id := WF_ENGINE.GetItemAttrNumber(itemtype,
644: itemkey,
645: 'APINV_ANAI');
646:
647: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype,
648: itemkey,
649: 'APINV_AOI');
650:
651: --Now set the environment

Line 665: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,

661: l_manager_id,
662: l_name,
663: l_display_name);
664:
665: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
666: itemkey,
667: 'APINV_AII');
668:
669: l_hist_id := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 669: l_hist_id := WF_ENGINE.GetItemAttrNumber(itemtype,

665: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
666: itemkey,
667: 'APINV_AII');
668:
669: l_hist_id := WF_ENGINE.GetItemAttrNumber(itemtype,
670: itemkey,
671: 'APINV_AHI');
672:
673: l_esc_approver.user_id := NULL;

Line 703: WF_ENGINE.SetItemAttrText(itemtype,

699: WHERE APPROVAL_HISTORY_ID = l_hist_id;
700:
701: WF_DIRECTORY.GetRoleName('PER',l_manager_id,l_role,l_role_display);
702:
703: WF_ENGINE.SetItemAttrText(itemtype,
704: itemkey,
705: 'APINV_ANA',
706: l_display_name);
707:

Line 708: WF_ENGINE.SetItemAttrNumber(itemtype,

704: itemkey,
705: 'APINV_ANA',
706: l_display_name);
707:
708: WF_ENGINE.SetItemAttrNumber(itemtype,
709: itemkey,
710: 'APINV_ANAI',
711: l_manager_id);
712:

Line 713: WF_ENGINE.SetItemAttrText(itemtype,

709: itemkey,
710: 'APINV_ANAI',
711: l_manager_id);
712:
713: WF_ENGINE.SetItemAttrText(itemtype,
714: itemkey,
715: 'APINV_ARN',
716: l_role);
717:

Line 767: WF_ENGINE.SETITEMATTRNumber(itemtype,

763: FROM ap_invoices_all
764: WHERE invoice_id = substr(itemkey, 1, instr(itemkey,'_')-1);
765:
766: -- lets go ahead and set the wf attribute again
767: WF_ENGINE.SETITEMATTRNumber(itemtype,
768: itemkey,
769: 'APINV_AOI',
770: l_org_id);
771:

Line 847: WF_ENGINE.SetItemAttrText(itemtype,

843: and trunc(sysdate) between effective_start_date --bug3815124
844: and nvl(effective_end_date,trunc(sysdate));
845:
846: --Bug 2785396 Set requester name
847: WF_ENGINE.SetItemAttrText(itemtype,
848: itemkey,
849: 'APINV_ARQN',
850: l_requester_name);
851: ELSE

Line 858: WF_ENGINE.SetItemAttrText(itemtype,

854:
855:
856: --Set attribute values in WF
857:
858: WF_ENGINE.SetItemAttrText(itemtype,
859: itemkey,
860: 'APINV_APON',
861: l_po_num);
862:

Line 863: WF_ENGINE.SetItemAttrText(itemtype,

859: itemkey,
860: 'APINV_APON',
861: l_po_num);
862:
863: WF_ENGINE.SetItemAttrText(itemtype,
864: itemkey,
865: 'APINV_AIDE',
866: l_description);
867:

Line 868: WF_ENGINE.SetItemAttrText(itemtype,

864: itemkey,
865: 'APINV_AIDE',
866: l_description);
867:
868: WF_ENGINE.SetItemAttrText(itemtype,
869: itemkey,
870: 'APINV_AIC',
871: l_currency);
872:

Line 873: WF_ENGINE.SetItemAttrText(itemtype,

869: itemkey,
870: 'APINV_AIC',
871: l_currency);
872:
873: WF_ENGINE.SetItemAttrText(itemtype,
874: itemkey,
875: 'APINV_AS',
876: l_vendor_name);
877:

Line 878: WF_ENGINE.SetItemAttrText(itemtype,

874: itemkey,
875: 'APINV_AS',
876: l_vendor_name);
877:
878: WF_ENGINE.SetItemAttrText(itemtype,
879: itemkey,
880: 'APINV_ASSI',
881: l_vendor_site_code);
882:

Line 883: WF_ENGINE.SetItemAttrNumber(itemtype,

879: itemkey,
880: 'APINV_ASSI',
881: l_vendor_site_code);
882:
883: WF_ENGINE.SetItemAttrNumber(itemtype,
884: itemkey,
885: 'APINV_AI',
886: l_iteration);
887:

Line 888: WF_ENGINE.SetItemAttrNumber(itemtype,

884: itemkey,
885: 'APINV_AI',
886: l_iteration);
887:
888: WF_ENGINE.SetItemAttrNumber(itemtype,
889: itemkey,
890: 'APINV_AIA',
891: l_amount);
892:

Line 893: WF_ENGINE.SetItemAttrNumber(itemtype,

889: itemkey,
890: 'APINV_AIA',
891: l_amount);
892:
893: WF_ENGINE.SetItemAttrNumber(itemtype,
894: itemkey,
895: 'APINV_AOI',
896: l_org_id);
897:

Line 898: WF_ENGINE.SetItemAttrNumber(itemtype,

894: itemkey,
895: 'APINV_AOI',
896: l_org_id);
897:
898: WF_ENGINE.SetItemAttrNumber(itemtype,
899: itemkey,
900: 'APINV_AII',
901: l_invoice_id);
902:

Line 903: WF_ENGINE.SetItemAttrText(itemtype,

899: itemkey,
900: 'APINV_AII',
901: l_invoice_id);
902:
903: WF_ENGINE.SetItemAttrText(itemtype,
904: itemkey,
905: 'APINV_AIN',
906: l_invoice_num);
907:

Line 908: WF_ENGINE.SetItemAttrDate(itemtype,

904: itemkey,
905: 'APINV_AIN',
906: l_invoice_num);
907:
908: WF_ENGINE.SetItemAttrDate(itemtype,
909: itemkey,
910: 'APINV_AID',
911: l_invoice_date);
912:

Line 914: l_prev_com := WF_ENGINE.GetItemAttrText(itemtype,

910: 'APINV_AID',
911: l_invoice_date);
912:
913: --set previous comments
914: l_prev_com := WF_ENGINE.GetItemAttrText(itemtype,
915: itemkey,
916: 'APINV_AC');
917:
918: WF_ENGINE.SetItemAttrText(itemtype,

Line 918: WF_ENGINE.SetItemAttrText(itemtype,

914: l_prev_com := WF_ENGINE.GetItemAttrText(itemtype,
915: itemkey,
916: 'APINV_AC');
917:
918: WF_ENGINE.SetItemAttrText(itemtype,
919: itemkey,
920: 'APINV_APC',
921: l_prev_com);
922:

Line 923: WF_ENGINE.SetItemAttrText(itemtype,

919: itemkey,
920: 'APINV_APC',
921: l_prev_com);
922:
923: WF_ENGINE.SetItemAttrText(itemtype,
924: itemkey,
925: 'APINV_AC',
926: '');
927:

Line 933: WF_ENGINE.SetItemAttrText(itemtype,

929: --set display amount
930: l_dsp_format := fnd_currency.get_format_mask(l_currency,30);
931: l_dsp_amount := to_char(l_amount,l_dsp_format);
932:
933: WF_ENGINE.SetItemAttrText(itemtype,
934: itemkey,
935: 'APINV_AIAD',
936: l_dsp_amount);
937: