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_ITEMS

Line 35: l_item_key wf_items.item_key%TYPE;

31: p_item_key IN VARCHAR2) RETURN VARCHAR2 IS
32: ------------------------------------------------------------------------
33: l_debug_info VARCHAR2(200);
34:
35: l_item_key wf_items.item_key%TYPE;
36:
37: BEGIN
38:
39:

Line 194: from wf_items

190: BEGIN
191:
192: select 'Y'
193: into l_event_key_exists
194: from wf_items
195: where item_type = C_APWRECPT
196: and item_key = p_event_key
197: and rownum = 1;
198:

Line 214: l_event_key wf_items.item_key%type;

210: p_expense_report_id IN NUMBER) IS
211: ------------------------------------------------------------------------
212: l_debug_info VARCHAR2(200);
213:
214: l_event_key wf_items.item_key%type;
215:
216: BEGIN
217:
218: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseOverdueEvent');

Line 255: l_event_key wf_items.item_key%type;

251: p_expense_report_id IN NUMBER) IS
252: ------------------------------------------------------------------------
253: l_debug_info VARCHAR2(200);
254:
255: l_event_key wf_items.item_key%type;
256:
257: BEGIN
258:
259: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseMissingEvent');

Line 296: l_event_key wf_items.item_key%type;

292: p_expense_report_id IN NUMBER) IS
293: ------------------------------------------------------------------------
294: l_debug_info VARCHAR2(200);
295:
296: l_event_key wf_items.item_key%type;
297:
298: BEGIN
299:
300: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseReceivedEvent');

Line 337: l_event_key wf_items.item_key%type;

333: p_expense_report_id IN NUMBER) IS
334: ------------------------------------------------------------------------
335: l_debug_info VARCHAR2(200);
336:
337: l_event_key wf_items.item_key%type;
338:
339: BEGIN
340:
341: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseAbortedEvent');

Line 811: l_item_key wf_items.item_key%TYPE;

807:
808: l_status wf_item_activity_statuses.ACTIVITY_STATUS%TYPE;
809: l_result wf_item_activity_statuses.ACTIVITY_RESULT_CODE%TYPE;
810:
811: l_item_key wf_items.item_key%TYPE;
812: l_found_item_key wf_items.item_key%TYPE;
813:
814: BEGIN
815:

Line 812: l_found_item_key wf_items.item_key%TYPE;

808: l_status wf_item_activity_statuses.ACTIVITY_STATUS%TYPE;
809: l_result wf_item_activity_statuses.ACTIVITY_RESULT_CODE%TYPE;
810:
811: l_item_key wf_items.item_key%TYPE;
812: l_found_item_key wf_items.item_key%TYPE;
813:
814: BEGIN
815:
816: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CheckOverdueExists');

Line 837: from wf_items

833: l_debug_info := 'Check for at least one Overdue process';
834: ----------------------------------------------------------
835: select item_key
836: into l_found_item_key
837: from wf_items
838: where item_type = p_item_type
839: and item_key like l_item_key
840: and end_date is null
841: and rownum = 1;

Line 880: l_item_key wf_items.item_key%TYPE;

876:
877: l_status wf_item_activity_statuses.ACTIVITY_STATUS%TYPE;
878: l_result wf_item_activity_statuses.ACTIVITY_RESULT_CODE%TYPE;
879:
880: l_item_key wf_items.item_key%TYPE;
881: l_found_item_key wf_items.item_key%TYPE;
882:
883: BEGIN
884:

Line 881: l_found_item_key wf_items.item_key%TYPE;

877: l_status wf_item_activity_statuses.ACTIVITY_STATUS%TYPE;
878: l_result wf_item_activity_statuses.ACTIVITY_RESULT_CODE%TYPE;
879:
880: l_item_key wf_items.item_key%TYPE;
881: l_found_item_key wf_items.item_key%TYPE;
882:
883: BEGIN
884:
885: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CheckMissingExists');

Line 906: from wf_items

902: l_debug_info := 'Check for at least one Missing process';
903: ----------------------------------------------------------
904: select item_key
905: into l_found_item_key
906: from wf_items
907: where item_type = p_item_type
908: and item_key like l_item_key
909: and end_date is null
910: and rownum = 1;

Line 978: l_item_key wf_items.item_key%type;

974: p_result OUT NOCOPY VARCHAR2) IS
975: ------------------------------------------------------------------------
976: l_debug_info VARCHAR2(200);
977:
978: l_item_key wf_items.item_key%type;
979:
980: BEGIN
981:
982: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start AbortMissing');

Line 1010: l_item_key wf_items.item_key%type;

1006: p_event_key IN VARCHAR2) IS
1007: ------------------------------------------------------------------------
1008: l_debug_info VARCHAR2(200);
1009:
1010: l_item_key wf_items.item_key%type;
1011: l_found_item_key wf_items.item_key%type;
1012:
1013: l_status wf_item_activity_statuses.ACTIVITY_STATUS%TYPE;
1014: l_result wf_item_activity_statuses.ACTIVITY_RESULT_CODE%TYPE;

Line 1011: l_found_item_key wf_items.item_key%type;

1007: ------------------------------------------------------------------------
1008: l_debug_info VARCHAR2(200);
1009:
1010: l_item_key wf_items.item_key%type;
1011: l_found_item_key wf_items.item_key%type;
1012:
1013: l_status wf_item_activity_statuses.ACTIVITY_STATUS%TYPE;
1014: l_result wf_item_activity_statuses.ACTIVITY_RESULT_CODE%TYPE;
1015:

Line 1019: from wf_items

1015:
1016: -- cursor for receipt events
1017: CURSOR c_receipt_events is
1018: select item_key
1019: from wf_items
1020: where item_type = p_item_type
1021: and item_key like l_item_key
1022: and end_date is null;
1023:

Line 1584: wf_items wf

1580: ------------------------------------------------------------
1581: select 'Y'
1582: into l_is_shortpay
1583: from ap_expense_report_headers_all aerh,
1584: wf_items wf
1585: where aerh.report_header_id = l_report_header_id
1586: and aerh.shortpay_parent_id is not null
1587: and wf.item_type = C_APEXP
1588: and wf.item_key = to_char(aerh.report_header_id) -- Bug 6841589 (sodash) to solve the invalid number exception

Line 2243: (select 1 from wf_items where aerh.RECEIPTS_STATUS = C_REQUIRED and item_type = 'APWRECPT' and item_key like to_char(aerh.report_header_id)||':receipts.overdue%' and end_date is null and rownum=1)

2239: or
2240: (aerh.RECEIPTS_STATUS = C_MISSING and rs.NOTIFY_DOCUMENT_REQUIRED_CODE = C_REQUIRED and trunc(sysdate) - (trunc(aerh.report_submitted_date) + rs.NOTIFY_RCT_OVERDUE_DAYS) > 0)
2241: )
2242: and not exists
2243: (select 1 from wf_items where aerh.RECEIPTS_STATUS = C_REQUIRED and item_type = 'APWRECPT' and item_key like to_char(aerh.report_header_id)||':receipts.overdue%' and end_date is null and rownum=1)
2244: and not exists
2245: (select 1 from wf_items where aerh.RECEIPTS_STATUS = C_MISSING and item_type = 'APWRECPT' and item_key like to_char(aerh.report_header_id)||':receipts.missing%' and end_date is null and rownum=1);
2246:
2247:

Line 2245: (select 1 from wf_items where aerh.RECEIPTS_STATUS = C_MISSING and item_type = 'APWRECPT' and item_key like to_char(aerh.report_header_id)||':receipts.missing%' and end_date is null and rownum=1);

2241: )
2242: and not exists
2243: (select 1 from wf_items where aerh.RECEIPTS_STATUS = C_REQUIRED and item_type = 'APWRECPT' and item_key like to_char(aerh.report_header_id)||':receipts.overdue%' and end_date is null and rownum=1)
2244: and not exists
2245: (select 1 from wf_items where aerh.RECEIPTS_STATUS = C_MISSING and item_type = 'APWRECPT' and item_key like to_char(aerh.report_header_id)||':receipts.missing%' and end_date is null and rownum=1);
2246:
2247:
2248: /*
2249: Criteria for this cursor is: