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_WEB_RECEIPTS_WF dependencies on WF_ENGINE

Line 419: RaiseAbortedEvent(WF_ENGINE.GetItemAttrNumber(p_item_type,

415:
416: ----------------------------------------------------------
417: l_debug_info := 'Raise Aborted event';
418: ----------------------------------------------------------
419: RaiseAbortedEvent(WF_ENGINE.GetItemAttrNumber(p_item_type,
420: p_item_key,
421: 'EXPENSE_REPORT_ID'));
422:
423: p_result := 'COMPLETE';

Line 444: l_textNameArr Wf_Engine.NameTabTyp;

440: p_item_key IN VARCHAR2) IS
441: ------------------------------------------------------------------------
442: l_debug_info VARCHAR2(200);
443:
444: l_textNameArr Wf_Engine.NameTabTyp;
445: l_numNameArr Wf_Engine.NameTabTyp;
446: l_textValArr Wf_Engine.TextTabTyp;
447: l_numValArr Wf_Engine.NumTabTyp;
448: iText NUMBER :=0;

Line 445: l_numNameArr Wf_Engine.NameTabTyp;

441: ------------------------------------------------------------------------
442: l_debug_info VARCHAR2(200);
443:
444: l_textNameArr Wf_Engine.NameTabTyp;
445: l_numNameArr Wf_Engine.NameTabTyp;
446: l_textValArr Wf_Engine.TextTabTyp;
447: l_numValArr Wf_Engine.NumTabTyp;
448: iText NUMBER :=0;
449: iNum NUMBER :=0;

Line 446: l_textValArr Wf_Engine.TextTabTyp;

442: l_debug_info VARCHAR2(200);
443:
444: l_textNameArr Wf_Engine.NameTabTyp;
445: l_numNameArr Wf_Engine.NameTabTyp;
446: l_textValArr Wf_Engine.TextTabTyp;
447: l_numValArr Wf_Engine.NumTabTyp;
448: iText NUMBER :=0;
449: iNum NUMBER :=0;
450:

Line 447: l_numValArr Wf_Engine.NumTabTyp;

443:
444: l_textNameArr Wf_Engine.NameTabTyp;
445: l_numNameArr Wf_Engine.NameTabTyp;
446: l_textValArr Wf_Engine.TextTabTyp;
447: l_numValArr Wf_Engine.NumTabTyp;
448: iText NUMBER :=0;
449: iNum NUMBER :=0;
450:
451: l_org_id number;

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

531:
532: ----------------------------------------------------------
533: l_debug_info := 'Set the Preparer as the Owner of Receipts Mgmt Workflow Process.';
534: ----------------------------------------------------------
535: WF_ENGINE.SetItemOwner(p_item_type, p_item_key, l_preparer_name);
536:
537: ----------------------------------------------------------
538: l_debug_info := 'Set Item User Key to Invoice Number for easier query ';
539: ----------------------------------------------------------

Line 540: WF_ENGINE.SetItemUserKey(p_item_type,

536:
537: ----------------------------------------------------------
538: l_debug_info := 'Set Item User Key to Invoice Number for easier query ';
539: ----------------------------------------------------------
540: WF_ENGINE.SetItemUserKey(p_item_type,
541: p_item_key,
542: l_invoice_num);
543:
544: --------------------------------------------------------

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

600:
601: ----------------------------------------------------------
602: l_debug_info := 'Set EXPENSE_REPORT_SUBMIT_DATE Item Attribute';
603: ----------------------------------------------------------
604: WF_ENGINE.SetItemAttrDate(p_item_type, p_item_key, 'EXPENSE_REPORT_SUBMIT_DATE', l_report_submitted_date);
605:
606: ----------------------------------------------------------
607: l_debug_info := 'Check Notification Rule';
608: ----------------------------------------------------------

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

688:
689: -----------------------------------------------------
690: l_debug_info := 'Set all number item attributes';
691: -----------------------------------------------------
692: WF_ENGINE.SetItemAttrNumberArray(p_item_type, p_item_key, l_numNameArr, l_numValArr);
693:
694: -----------------------------------------------------
695: l_debug_info := 'Set all text item attributes';
696: -----------------------------------------------------

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

693:
694: -----------------------------------------------------
695: l_debug_info := 'Set all text item attributes';
696: -----------------------------------------------------
697: WF_ENGINE.SetItemAttrTextArray(p_item_type, p_item_key, l_textNameArr, l_textValArr);
698:
699:
700: if (l_is_notif_rule_setup = 'Y') then
701:

Line 1049: WF_ENGINE.AbortProcess(p_item_type,

1045: l_debug_info := 'Abort event process and use the item key as the result';
1046: ----------------------------------------------------------
1047: begin
1048:
1049: WF_ENGINE.AbortProcess(p_item_type,
1050: l_found_item_key,
1051: null,
1052: wf_engine.eng_force);
1053:

Line 1052: wf_engine.eng_force);

1048:
1049: WF_ENGINE.AbortProcess(p_item_type,
1050: l_found_item_key,
1051: null,
1052: wf_engine.eng_force);
1053:
1054: exception
1055: when others then null;
1056: end;

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

1188:
1189: ------------------------------------------------------------
1190: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
1191: ------------------------------------------------------------
1192: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1193: p_item_key,
1194: 'EXPENSE_REPORT_ID');
1195:
1196: ------------------------------------------------------------

Line 1277: l_receipts_status := WF_ENGINE.GetActivityAttrText(p_item_type,

1273:
1274: -------------------------------------------------------------------
1275: l_debug_info := 'Retrieve Activity Attr Receipts Status';
1276: -------------------------------------------------------------------
1277: l_receipts_status := WF_ENGINE.GetActivityAttrText(p_item_type,
1278: p_item_key,
1279: p_actid,
1280: 'RECEIPTS_STATUS');
1281:

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

1281:
1282: ------------------------------------------------------------
1283: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
1284: ------------------------------------------------------------
1285: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1286: p_item_key,
1287: 'EXPENSE_REPORT_ID');
1288:
1289: ------------------------------------------------------------

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

1326: DAYS_OVERDUE is the diff between notif sent date and date the
1327: the expense report receipts package became overdue
1328: notif sent date - (report submission date + NOTIF_RULE_DAYS_OVERDUE)
1329: */
1330: l_report_submitted_date := WF_ENGINE.GetItemAttrDate(p_item_type,
1331: p_item_key,
1332: 'EXPENSE_REPORT_SUBMIT_DATE');
1333:
1334: l_notif_rule_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,

Line 1334: l_notif_rule_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,

1330: l_report_submitted_date := WF_ENGINE.GetItemAttrDate(p_item_type,
1331: p_item_key,
1332: 'EXPENSE_REPORT_SUBMIT_DATE');
1333:
1334: l_notif_rule_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
1335: p_item_key,
1336: 'NOTIF_RULE_DAYS_OVERDUE');
1337:
1338: l_days_overdue := trunc(sysdate) - (trunc(l_report_submitted_date) + l_notif_rule_days_overdue);

Line 1343: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'DAYS_OVERDUE', l_days_overdue);

1339:
1340: ----------------------------------------------------------
1341: l_debug_info := 'Set DAYS_OVERDUE Item Attribute';
1342: ----------------------------------------------------------
1343: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'DAYS_OVERDUE', l_days_overdue);
1344:
1345: ------------------------------------------------------------
1346: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
1347: ------------------------------------------------------------

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

1344:
1345: ------------------------------------------------------------
1346: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
1347: ------------------------------------------------------------
1348: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1349: p_item_key,
1350: 'EXPENSE_REPORT_ID');
1351:
1352: ------------------------------------------------------------

Line 1431: l_missing_decl_reqd := WF_ENGINE.GetItemAttrText(p_item_type,

1427:
1428: ----------------------------------------------------------
1429: l_debug_info := 'Check if Missing Declaration is required';
1430: ----------------------------------------------------------
1431: l_missing_decl_reqd := WF_ENGINE.GetItemAttrText(p_item_type,
1432: p_item_key,
1433: 'NOTIF_RULE_MISSING_DECL_REQD');
1434:
1435: if (nvl(l_missing_decl_reqd, C_NOT_REQUIRED) = C_REQUIRED) then

Line 1476: l_notif_received := WF_ENGINE.GetItemAttrText(p_item_type,

1472:
1473: ----------------------------------------------------------
1474: l_debug_info := 'Check if Notify Receipts Received is enabled';
1475: ----------------------------------------------------------
1476: l_notif_received := WF_ENGINE.GetItemAttrText(p_item_type,
1477: p_item_key,
1478: 'NOTIF_RULE_NOTIF_RECEIVED');
1479:
1480: ----------------------------------------------------------

Line 1483: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,

1479:
1480: ----------------------------------------------------------
1481: l_debug_info := 'Check if Days Overdue';
1482: ----------------------------------------------------------
1483: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
1484: p_item_key,
1485: 'DAYS_OVERDUE');
1486:
1487:

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

1525:
1526: ------------------------------------------------------------
1527: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
1528: ------------------------------------------------------------
1529: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1530: p_item_key,
1531: 'EXPENSE_REPORT_ID');
1532:
1533: ------------------------------------------------------------

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

1570:
1571: ------------------------------------------------------------
1572: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
1573: ------------------------------------------------------------
1574: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1575: p_item_key,
1576: 'EXPENSE_REPORT_ID');
1577:
1578: ------------------------------------------------------------

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

1703:
1704: ------------------------------------------------------------
1705: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
1706: ------------------------------------------------------------
1707: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1708: p_item_key,
1709: 'EXPENSE_REPORT_ID');
1710:
1711: ----------------------------------------------------------

Line 1716: WF_ENGINE.CompleteActivityInternalName(C_APEXP,

1712: l_debug_info := 'Complete Missing or Policy Shortpay Process';
1713: ----------------------------------------------------------
1714: begin
1715:
1716: WF_ENGINE.CompleteActivityInternalName(C_APEXP,
1717: l_report_header_id,
1718: p_activity,
1719: p_result);
1720:

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

1885:
1886: -------------------------------------------------------------------
1887: l_debug_info := 'Check AP_EXPENSE_PARAMS.NOTE_LANGUAGE_CODE';
1888: -------------------------------------------------------------------
1889: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1890: p_item_key,
1891: 'ORG_ID');
1892: begin
1893: select note_language_code

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

1922:
1923: ------------------------------------------------------------
1924: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
1925: ------------------------------------------------------------
1926: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1927: p_item_key,
1928: 'EXPENSE_REPORT_ID');
1929:
1930: -------------------------------------------------------------------

Line 1933: l_result_type := WF_ENGINE.GetActivityAttrText(p_item_type,

1929:
1930: -------------------------------------------------------------------
1931: l_debug_info := 'Retrieve Activity Attr Result Type';
1932: -------------------------------------------------------------------
1933: l_result_type := WF_ENGINE.GetActivityAttrText(p_item_type,
1934: p_item_key,
1935: p_actid,
1936: 'RESULT_TYPE');
1937: -- bug 6361555

Line 1982: l_result_code := WF_ENGINE.GetActivityAttrText(p_item_type,

1978:
1979: -------------------------------------------------------------------
1980: l_debug_info := 'Retrieve Activity Attr Result Code';
1981: -------------------------------------------------------------------
1982: l_result_code := WF_ENGINE.GetActivityAttrText(p_item_type,
1983: p_item_key,
1984: p_actid,
1985: 'RESULT_CODE');
1986:

Line 1990: l_response := WF_ENGINE.GetActivityAttrText(p_item_type,

1986:
1987: -------------------------------------------------------------------
1988: l_debug_info := 'Retrieve Activity Attr Response';
1989: -------------------------------------------------------------------
1990: l_response := WF_ENGINE.GetActivityAttrText(p_item_type,
1991: p_item_key,
1992: p_actid,
1993: 'RESPONSE');
1994:

Line 2019: WF_ENGINE.SetItemAttrText(p_item_type,

2015: l_debug_info := 'clear Item Attribute PREPARER_RESPONSE';
2016: -- this assumes preparer response, if we need to change this
2017: -- later then change Activity Attr RESPONSE to pass item attr
2018: ---------------------------------------------------------
2019: WF_ENGINE.SetItemAttrText(p_item_type,
2020: p_item_key,
2021: 'PREPARER_RESPONSE',
2022: '');
2023:

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

2025:
2026: -------------------------------------------------------------------
2027: l_debug_info := 'Retrieve Activity Attr FND Message';
2028: -------------------------------------------------------------------
2029: l_fnd_message := WF_ENGINE.GetActivityAttrText(p_item_type,
2030: p_item_key,
2031: p_actid,
2032: 'FND_MESSAGE');
2033:

Line 2036: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,

2032: 'FND_MESSAGE');
2033:
2034: if (l_fnd_message in ('APWRECPT_OVERDUE_SENT','APWRECPT_MISSING_SENT')) then
2035:
2036: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
2037: p_item_key,
2038: 'DAYS_OVERDUE');
2039:
2040: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);

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

2088: BEGIN
2089:
2090: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CallbackFunction');
2091:
2092: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2093: p_item_key,
2094: 'ORG_ID');
2095:
2096: if (l_org_id is null) then

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

2094: 'ORG_ID');
2095:
2096: if (l_org_id is null) then
2097: -- EXPENSE_REPORT_ID item attribute should exist
2098: l_expense_report_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2099: p_item_key,
2100: 'EXPENSE_REPORT_ID');
2101:
2102: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN

Line 2106: WF_ENGINE.SetItemAttrNumber(p_item_type,

2102: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN
2103: l_org_id := NULL;
2104: END IF;
2105:
2106: WF_ENGINE.SetItemAttrNumber(p_item_type,
2107: p_item_key,
2108: 'ORG_ID',
2109: l_org_id);
2110: end if;