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 42: l_item_key wf_items.item_key%TYPE;

38: p_item_key IN VARCHAR2) RETURN VARCHAR2 IS
39: ------------------------------------------------------------------------
40: l_debug_info VARCHAR2(200);
41:
42: l_item_key wf_items.item_key%TYPE;
43:
44: BEGIN
45:
46:

Line 201: from wf_items

197: BEGIN
198:
199: select 'Y'
200: into l_event_key_exists
201: from wf_items
202: where item_type = C_APWRECPT
203: and item_key = p_event_key
204: and rownum = 1;
205:

Line 221: l_event_key wf_items.item_key%type;

217: p_expense_report_id IN NUMBER) IS
218: ------------------------------------------------------------------------
219: l_debug_info VARCHAR2(200);
220:
221: l_event_key wf_items.item_key%type;
222:
223: BEGIN
224:
225: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseOverdueEvent');

Line 262: l_event_key wf_items.item_key%type;

258: p_expense_report_id IN NUMBER) IS
259: ------------------------------------------------------------------------
260: l_debug_info VARCHAR2(200);
261:
262: l_event_key wf_items.item_key%type;
263:
264: BEGIN
265:
266: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseMissingEvent');

Line 303: l_event_key wf_items.item_key%type;

299: p_expense_report_id IN NUMBER) IS
300: ------------------------------------------------------------------------
301: l_debug_info VARCHAR2(200);
302:
303: l_event_key wf_items.item_key%type;
304:
305: BEGIN
306:
307: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseReceivedEvent');

Line 344: l_event_key wf_items.item_key%type;

340: p_expense_report_id IN NUMBER) IS
341: ------------------------------------------------------------------------
342: l_debug_info VARCHAR2(200);
343:
344: l_event_key wf_items.item_key%type;
345:
346: BEGIN
347:
348: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseAbortedEvent');

Line 423: l_event_key wf_items.item_key%type;

419: p_result OUT NOCOPY VARCHAR2) IS
420: ------------------------------------------------------------------------
421: l_debug_info VARCHAR2(200);
422: l_receipt_type VARCHAR2(50);
423: l_event_key wf_items.item_key%type;
424: l_report_header_id NUMBER;
425:
426: BEGIN
427:

Line 937: l_item_key wf_items.item_key%TYPE;

933:
934: l_status wf_item_activity_statuses.ACTIVITY_STATUS%TYPE;
935: l_result wf_item_activity_statuses.ACTIVITY_RESULT_CODE%TYPE;
936:
937: l_item_key wf_items.item_key%TYPE;
938: l_found_item_key wf_items.item_key%TYPE;
939:
940: BEGIN
941:

Line 938: l_found_item_key wf_items.item_key%TYPE;

934: l_status wf_item_activity_statuses.ACTIVITY_STATUS%TYPE;
935: l_result wf_item_activity_statuses.ACTIVITY_RESULT_CODE%TYPE;
936:
937: l_item_key wf_items.item_key%TYPE;
938: l_found_item_key wf_items.item_key%TYPE;
939:
940: BEGIN
941:
942: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CheckOverdueExists');

Line 963: from wf_items

959: l_debug_info := 'Check for at least one Overdue process';
960: ----------------------------------------------------------
961: select item_key
962: into l_found_item_key
963: from wf_items
964: where item_type = p_item_type
965: and item_key like l_item_key
966: and end_date is null
967: and rownum = 1;

Line 1006: l_item_key wf_items.item_key%TYPE;

1002:
1003: l_status wf_item_activity_statuses.ACTIVITY_STATUS%TYPE;
1004: l_result wf_item_activity_statuses.ACTIVITY_RESULT_CODE%TYPE;
1005:
1006: l_item_key wf_items.item_key%TYPE;
1007: l_found_item_key wf_items.item_key%TYPE;
1008:
1009: BEGIN
1010:

Line 1007: l_found_item_key wf_items.item_key%TYPE;

1003: l_status wf_item_activity_statuses.ACTIVITY_STATUS%TYPE;
1004: l_result wf_item_activity_statuses.ACTIVITY_RESULT_CODE%TYPE;
1005:
1006: l_item_key wf_items.item_key%TYPE;
1007: l_found_item_key wf_items.item_key%TYPE;
1008:
1009: BEGIN
1010:
1011: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CheckMissingExists');

Line 1032: from wf_items

1028: l_debug_info := 'Check for at least one Missing process';
1029: ----------------------------------------------------------
1030: select item_key
1031: into l_found_item_key
1032: from wf_items
1033: where item_type = p_item_type
1034: and item_key like l_item_key
1035: and end_date is null
1036: and rownum = 1;

Line 1129: l_item_key wf_items.item_key%type;

1125: p_result OUT NOCOPY VARCHAR2) IS
1126: ------------------------------------------------------------------------
1127: l_debug_info VARCHAR2(200);
1128:
1129: l_item_key wf_items.item_key%type;
1130:
1131: BEGIN
1132:
1133: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start AbortMissing');

Line 1161: l_item_key wf_items.item_key%type;

1157: p_event_key IN VARCHAR2) IS
1158: ------------------------------------------------------------------------
1159: l_debug_info VARCHAR2(200);
1160:
1161: l_item_key wf_items.item_key%type;
1162: l_found_item_key wf_items.item_key%type;
1163:
1164: l_status wf_item_activity_statuses.ACTIVITY_STATUS%TYPE;
1165: l_result wf_item_activity_statuses.ACTIVITY_RESULT_CODE%TYPE;

Line 1162: l_found_item_key wf_items.item_key%type;

1158: ------------------------------------------------------------------------
1159: l_debug_info VARCHAR2(200);
1160:
1161: l_item_key wf_items.item_key%type;
1162: l_found_item_key wf_items.item_key%type;
1163:
1164: l_status wf_item_activity_statuses.ACTIVITY_STATUS%TYPE;
1165: l_result wf_item_activity_statuses.ACTIVITY_RESULT_CODE%TYPE;
1166:

Line 1170: from wf_items

1166:
1167: -- cursor for receipt events
1168: CURSOR c_receipt_events is
1169: select item_key
1170: from wf_items
1171: where item_type = p_item_type
1172: and item_key like l_item_key
1173: and end_date is null;
1174:

Line 1769: wf_items wf

1765: ------------------------------------------------------------
1766: select 'Y'
1767: into l_is_shortpay
1768: from ap_expense_report_headers_all aerh,
1769: wf_items wf
1770: where aerh.report_header_id = l_report_header_id
1771: and aerh.shortpay_parent_id is not null
1772: and wf.item_type = C_APEXP
1773: and wf.item_key = to_char(aerh.report_header_id) -- Bug 6841589 (sodash) to solve the invalid number exception

Line 2425: l_event_key wf_items.item_key%type;

2421: p_overdue_event IN VARCHAR2) IS
2422: ------------------------------------------------------------------------
2423: l_debug_info VARCHAR2(200);
2424:
2425: l_event_key wf_items.item_key%type;
2426:
2427: BEGIN
2428:
2429: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseOverdueEvent');

Line 2471: l_event_key wf_items.item_key%type;

2467: p_missing_event IN VARCHAR2) IS
2468: ------------------------------------------------------------------------
2469: l_debug_info VARCHAR2(200);
2470:
2471: l_event_key wf_items.item_key%type;
2472:
2473: BEGIN
2474:
2475: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseMissingEvent');

Line 2509: SELECT 'Y' INTO l_ret_value FROM wf_items

2505: FUNCTION CheckActiveWFExists(p_report_header_id IN NUMBER, p_item_key IN VARCHAR2) RETURN VARCHAR2 IS
2506: l_ret_value VARCHAR2(1);
2507: BEGIN
2508:
2509: SELECT 'Y' INTO l_ret_value FROM wf_items
2510: WHERE item_key like to_char(p_report_header_id)||p_item_key
2511: AND end_date is null;
2512:
2513: RETURN l_ret_value;

Line 2618: (select 1 from wf_items where aerh.RECEIPTS_STATUS = C_REQUIRED and item_type = 'APWRECPT'

2614: and
2615: (
2616: ((aerh.RECEIPTS_STATUS = C_REQUIRED and sysdate - (aerh.report_submitted_date + rs.NOTIFY_RCT_OVERDUE_DAYS) > 0)
2617: and not exists
2618: (select 1 from wf_items where aerh.RECEIPTS_STATUS = C_REQUIRED and item_type = 'APWRECPT'
2619: and (item_key like to_char(aerh.report_header_id)||':receipts.overdue.original%'
2620: OR item_key like to_char(aerh.report_header_id)||':receipts.overdue.both%')
2621: and end_date is null and rownum=1)
2622: )

Line 2627: (select 1 from wf_items where aerh.RECEIPTS_STATUS = C_MISSING and item_type = 'APWRECPT'

2623: or
2624: ((aerh.RECEIPTS_STATUS = C_MISSING and nvl(aerh.IMAGE_RECEIPTS_STATUS, C_NOT_REQUIRED) in (C_NOT_REQUIRED, C_MISSING, C_WAIVED, C_RECEIVED)
2625: and sysdate - (aerh.report_submitted_date + rs.NOTIFY_RCT_OVERDUE_DAYS) > 0)
2626: and not exists
2627: (select 1 from wf_items where aerh.RECEIPTS_STATUS = C_MISSING and item_type = 'APWRECPT'
2628: and (item_key like to_char(aerh.report_header_id)||':receipts.missing.original%'
2629: OR item_key like to_char(aerh.report_header_id)||':receipts.missing.both%')
2630: and end_date is null and rownum=1)
2631: )

Line 2638: from wf_items

2634: and sysdate - (aerh.report_submitted_date + rs.NOTIFY_IMG_RCT_OVERDUE_DAYS) > 0)
2635: and (aerh.RECEIPTS_STATUS <> AP_WEB_RECEIPTS_WF.C_RECEIVED and (nvl(aerh.workflow_approved_flag, 'N') <> 'P' OR aerh.expense_status_code <> 'INVOICED'))
2636: and not exists
2637: (select 1
2638: from wf_items
2639: where decode(aerh.IMAGE_RECEIPTS_STATUS, 'PENDING_IMAGE_SUBMISSION', C_REQUIRED, aerh.IMAGE_RECEIPTS_STATUS) = C_REQUIRED
2640: and item_type = 'APWRECPT'
2641: and (item_key like to_char(aerh.report_header_id)||':receipts.overdue.image%'
2642: OR item_key like to_char(aerh.report_header_id)||':receipts.overdue.both%')

Line 2652: from wf_items

2648: and sysdate - (aerh.report_submitted_date + rs.NOTIFY_IMG_RCT_OVERDUE_DAYS) > 0)
2649: and (aerh.RECEIPTS_STATUS <> AP_WEB_RECEIPTS_WF.C_RECEIVED and (nvl(aerh.workflow_approved_flag, 'N') <> 'P' OR aerh.expense_status_code <> 'INVOICED'))
2650: and not exists
2651: (select 1
2652: from wf_items
2653: where aerh.IMAGE_RECEIPTS_STATUS = C_MISSING and item_type = 'APWRECPT'
2654: and (item_key like to_char(aerh.report_header_id)||':receipts.missing.image%'
2655: OR item_key like to_char(aerh.report_header_id)||':receipts.missing.both%')
2656: and end_date is null

Line 2683: (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)

2679: or
2680: (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)
2681: )
2682: and not exists
2683: (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)
2684: and not exists
2685: (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)
2686:
2687: UNION

Line 2685: (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)

2681: )
2682: and not exists
2683: (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)
2684: and not exists
2685: (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)
2686:
2687: UNION
2688:
2689: select aerh.report_header_id,

Line 2711: (select 1 from wf_items where aerh.IMAGE_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)

2707: or
2708: (aerh.IMAGE_RECEIPTS_STATUS = C_MISSING and rs.NOTIFY_DOCUMENT_REQUIRED_CODE = C_REQUIRED and trunc(sysdate) - (trunc(aerh.report_submitted_date) + rs.NOTIFY_IMG_RCT_OVERDUE_DAYS) > 0)
2709: )
2710: and not exists
2711: (select 1 from wf_items where aerh.IMAGE_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)
2712: and not exists
2713: (select 1 from wf_items where aerh.IMAGE_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);
2714:
2715: */

Line 2713: (select 1 from wf_items where aerh.IMAGE_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);

2709: )
2710: and not exists
2711: (select 1 from wf_items where aerh.IMAGE_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)
2712: and not exists
2713: (select 1 from wf_items where aerh.IMAGE_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);
2714:
2715: */
2716: /*
2717: Criteria for this cursor is:

Line 2974: from wf_items

2970: l_event_key_exists varchar2(1);
2971: BEGIN
2972: select 'Y'
2973: into l_event_key_exists
2974: from wf_items
2975: where item_type = C_APWRECPT
2976: and item_key like p_report_header_id||'%'
2977: and rownum = 1;
2978:

Line 3489: l_item_key wf_items.item_key%TYPE;

3485: l_expense_report_id number;
3486: l_receipt_rule AP_AUD_RULE_SETS%ROWTYPE;
3487: l_report_submitted_date date;
3488: l_AMEEnabled VARCHAR2(1);
3489: l_item_key wf_items.item_key%TYPE;
3490: C_WF_Version NUMBER := 0;
3491: l_wf_appr_flag VARCHAR2(1);
3492:
3493:

Line 3742: l_event_key wf_items.item_key%type;

3738: p_expense_report_id IN NUMBER,
3739: p_receipt_type IN VARCHAR2) IS
3740: l_debug_info VARCHAR2(200);
3741:
3742: l_event_key wf_items.item_key%type;
3743: BEGIN
3744: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start RaiseReceivedEvent');
3745:
3746: ----------------------------------------------------------

Line 3785: l_event_key wf_items.item_key%type;

3781: p_funmode IN VARCHAR2,
3782: p_result OUT NOCOPY VARCHAR2) IS
3783: l_receipts_status VARCHAR2(30);
3784: l_report_header_id NUMBER;
3785: l_event_key wf_items.item_key%type;
3786: BEGIN
3787: IF (p_funmode = 'RUN') THEN
3788: l_receipts_status := WF_ENGINE.GetActivityAttrText(p_item_type,
3789: p_item_key,