DBA Data[Home] [Help]

APPS.AP_WEB_HOLDS_WF dependencies on WF_ENGINE

Line 303: RaiseReleasedEvent(WF_ENGINE.GetItemAttrNumber(p_item_type,

299:
300: ----------------------------------------------------------
301: l_debug_info := 'Raise Released event';
302: ----------------------------------------------------------
303: RaiseReleasedEvent(WF_ENGINE.GetItemAttrNumber(p_item_type,
304: p_item_key,
305: 'EXPENSE_REPORT_ID'));
306:
307: p_result := 'COMPLETE';

Line 328: l_textNameArr Wf_Engine.NameTabTyp;

324: p_item_key IN VARCHAR2) IS
325: ------------------------------------------------------------------------
326: l_debug_info VARCHAR2(200);
327:
328: l_textNameArr Wf_Engine.NameTabTyp;
329: l_numNameArr Wf_Engine.NameTabTyp;
330: l_textValArr Wf_Engine.TextTabTyp;
331: l_numValArr Wf_Engine.NumTabTyp;
332: iText NUMBER :=0;

Line 329: l_numNameArr Wf_Engine.NameTabTyp;

325: ------------------------------------------------------------------------
326: l_debug_info VARCHAR2(200);
327:
328: l_textNameArr Wf_Engine.NameTabTyp;
329: l_numNameArr Wf_Engine.NameTabTyp;
330: l_textValArr Wf_Engine.TextTabTyp;
331: l_numValArr Wf_Engine.NumTabTyp;
332: iText NUMBER :=0;
333: iNum NUMBER :=0;

Line 330: l_textValArr Wf_Engine.TextTabTyp;

326: l_debug_info VARCHAR2(200);
327:
328: l_textNameArr Wf_Engine.NameTabTyp;
329: l_numNameArr Wf_Engine.NameTabTyp;
330: l_textValArr Wf_Engine.TextTabTyp;
331: l_numValArr Wf_Engine.NumTabTyp;
332: iText NUMBER :=0;
333: iNum NUMBER :=0;
334:

Line 331: l_numValArr Wf_Engine.NumTabTyp;

327:
328: l_textNameArr Wf_Engine.NameTabTyp;
329: l_numNameArr Wf_Engine.NameTabTyp;
330: l_textValArr Wf_Engine.TextTabTyp;
331: l_numValArr Wf_Engine.NumTabTyp;
332: iText NUMBER :=0;
333: iNum NUMBER :=0;
334:
335: l_org_id number;

Line 461: WF_ENGINE.SetItemOwner(p_item_type, p_item_key, l_preparer_name);

457:
458: ----------------------------------------------------------
459: l_debug_info := 'Set the Preparer as the Owner of Receipts Mgmt Workflow Process.';
460: ----------------------------------------------------------
461: WF_ENGINE.SetItemOwner(p_item_type, p_item_key, l_preparer_name);
462:
463: ----------------------------------------------------------
464: l_debug_info := 'Set Item User Key to Invoice Number for easier query ';
465: ----------------------------------------------------------

Line 466: WF_ENGINE.SetItemUserKey(p_item_type,

462:
463: ----------------------------------------------------------
464: l_debug_info := 'Set Item User Key to Invoice Number for easier query ';
465: ----------------------------------------------------------
466: WF_ENGINE.SetItemUserKey(p_item_type,
467: p_item_key,
468: l_invoice_num);
469:
470: --------------------------------------------------------

Line 530: WF_ENGINE.SetItemAttrDate(p_item_type, p_item_key, 'EXPENSE_REPORT_SUBMIT_DATE', l_report_submitted_date);

526:
527: ----------------------------------------------------------
528: l_debug_info := 'Set EXPENSE_REPORT_SUBMIT_DATE Item Attribute';
529: ----------------------------------------------------------
530: WF_ENGINE.SetItemAttrDate(p_item_type, p_item_key, 'EXPENSE_REPORT_SUBMIT_DATE', l_report_submitted_date);
531:
532: ----------------------------------------------------------
533: l_debug_info := 'Set PREPARER_ROLE Item Attribute';
534: ----------------------------------------------------------

Line 543: WF_ENGINE.SetItemAttrNumberArray(p_item_type, p_item_key, l_numNameArr, l_numValArr);

539:
540: -----------------------------------------------------
541: l_debug_info := 'Set all number item attributes';
542: -----------------------------------------------------
543: WF_ENGINE.SetItemAttrNumberArray(p_item_type, p_item_key, l_numNameArr, l_numValArr);
544:
545: -----------------------------------------------------
546: l_debug_info := 'Set all text item attributes';
547: -----------------------------------------------------

Line 548: WF_ENGINE.SetItemAttrTextArray(p_item_type, p_item_key, l_textNameArr, l_textValArr);

544:
545: -----------------------------------------------------
546: l_debug_info := 'Set all text item attributes';
547: -----------------------------------------------------
548: WF_ENGINE.SetItemAttrTextArray(p_item_type, p_item_key, l_textNameArr, l_textValArr);
549:
550:
551: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'end Init');
552:

Line 653: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

649:
650: ------------------------------------------------------------
651: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
652: ------------------------------------------------------------
653: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
654: p_item_key,
655: 'EXPENSE_REPORT_ID');
656:
657: ----------------------------------------------------------

Line 754: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

750:
751: ------------------------------------------------------------
752: l_debug_info := 'Retrieve ORG_ID Item Attribute';
753: ------------------------------------------------------------
754: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
755: p_item_key,
756: 'ORG_ID');
757:
758: ------------------------------------------------------------

Line 761: l_report_submitted_date := WF_ENGINE.GetItemAttrDate(p_item_type,

757:
758: ------------------------------------------------------------
759: l_debug_info := 'Retrieve EXPENSE_REPORT_SUBMIT_DATE Item Attribute';
760: ------------------------------------------------------------
761: l_report_submitted_date := WF_ENGINE.GetItemAttrDate(p_item_type,
762: p_item_key,
763: 'EXPENSE_REPORT_SUBMIT_DATE');
764:
765: ----------------------------------------------------------

Line 862: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

858:
859: -------------------------------------------------------------------
860: l_debug_info := 'Check AP_EXPENSE_PARAMS.NOTE_LANGUAGE_CODE';
861: -------------------------------------------------------------------
862: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
863: p_item_key,
864: 'ORG_ID');
865: begin
866: select note_language_code

Line 899: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

895:
896: ------------------------------------------------------------
897: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
898: ------------------------------------------------------------
899: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
900: p_item_key,
901: 'EXPENSE_REPORT_ID');
902:
903: -------------------------------------------------------------------

Line 906: l_fnd_message := WF_ENGINE.GetActivityAttrText(p_item_type,

902:
903: -------------------------------------------------------------------
904: l_debug_info := 'Retrieve Activity Attr FND Message';
905: -------------------------------------------------------------------
906: l_fnd_message := WF_ENGINE.GetActivityAttrText(p_item_type,
907: p_item_key,
908: p_actid,
909: 'FND_MESSAGE');
910:

Line 917: l_holding_invoice_num := WF_ENGINE.GetItemAttrText(p_item_type,

913: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
914:
915: if (l_fnd_message = 'APWRECPT_HELD_ALL_NOTE') then
916:
917: l_holding_invoice_num := WF_ENGINE.GetItemAttrText(p_item_type,
918: p_item_key,
919: 'HOLDING_EXPENSE_REPORT');
920:
921: FND_MESSAGE.SET_TOKEN('HOLDING_EXPENSE_REPORT', l_holding_invoice_num);

Line 973: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

969: BEGIN
970:
971: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start CallbackFunction');
972:
973: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
974: p_item_key,
975: 'ORG_ID');
976:
977: if (l_org_id is null) then

Line 979: l_expense_report_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

975: 'ORG_ID');
976:
977: if (l_org_id is null) then
978: -- EXPENSE_REPORT_ID item attribute should exist
979: l_expense_report_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
980: p_item_key,
981: 'EXPENSE_REPORT_ID');
982:
983: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN

Line 987: WF_ENGINE.SetItemAttrNumber(p_item_type,

983: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN
984: l_org_id := NULL;
985: END IF;
986:
987: WF_ENGINE.SetItemAttrNumber(p_item_type,
988: p_item_key,
989: 'ORG_ID',
990: l_org_id);
991: end if;