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 893: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

889:
890: ------------------------------------------------------------
891: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
892: ------------------------------------------------------------
893: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
894: p_item_key,
895: 'EXPENSE_REPORT_ID');
896:
897: -------------------------------------------------------------------

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

896:
897: -------------------------------------------------------------------
898: l_debug_info := 'Retrieve Activity Attr FND Message';
899: -------------------------------------------------------------------
900: l_fnd_message := WF_ENGINE.GetActivityAttrText(p_item_type,
901: p_item_key,
902: p_actid,
903: 'FND_MESSAGE');
904:

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

907: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
908:
909: if (l_fnd_message = 'APWRECPT_HELD_ALL_NOTE') then
910:
911: l_holding_invoice_num := WF_ENGINE.GetItemAttrText(p_item_type,
912: p_item_key,
913: 'HOLDING_EXPENSE_REPORT');
914:
915: FND_MESSAGE.SET_TOKEN('HOLDING_EXPENSE_REPORT', l_holding_invoice_num);

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

963: BEGIN
964:
965: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start CallbackFunction');
966:
967: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
968: p_item_key,
969: 'ORG_ID');
970:
971: if (l_org_id is null) then

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

969: 'ORG_ID');
970:
971: if (l_org_id is null) then
972: -- EXPENSE_REPORT_ID item attribute should exist
973: l_expense_report_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
974: p_item_key,
975: 'EXPENSE_REPORT_ID');
976:
977: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN

Line 981: WF_ENGINE.SetItemAttrNumber(p_item_type,

977: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN
978: l_org_id := NULL;
979: END IF;
980:
981: WF_ENGINE.SetItemAttrNumber(p_item_type,
982: p_item_key,
983: 'ORG_ID',
984: l_org_id);
985: end if;