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 AP_EXPENSE_REPORT_HEADERS_ALL

Line 145: from ap_expense_report_headers_all

141: l_debug_info := 'Get Expense Report data';
142: ----------------------------------------------------------
143: select report_submitted_date
144: into l_report_submitted_date
145: from ap_expense_report_headers_all
146: where report_header_id = l_expense_report_id;
147:
148: ------------------------------------------------------------
149: l_debug_info := 'Check if Notif Rules Setup';

Line 364: update ap_expense_report_headers_all

360: ----------------------------------------------------------
361: l_debug_info := 'Update Receipts Status if not Received or Waived';
362: ----------------------------------------------------------
363: begin
364: update ap_expense_report_headers_all
365: set receipts_status = ''
366: where report_header_id = p_expense_report_id
367: and nvl(receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) not in (AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED)
368: and receipts_received_date is null;

Line 370: update ap_expense_report_headers_all

366: where report_header_id = p_expense_report_id
367: and nvl(receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) not in (AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED)
368: and receipts_received_date is null;
369:
370: update ap_expense_report_headers_all
371: set image_receipts_status = ''
372: where report_header_id = p_expense_report_id
373: and nvl(image_receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) not in (AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED)
374: and image_receipts_received_date is null;

Line 384: update ap_expense_report_headers_all

380: l_debug_info := 'Reset Held Reports';
381: ----------------------------------------------------------
382: -- Bug 4075804
383: begin
384: update ap_expense_report_headers_all
385: set expense_status_code = C_PENDING_HOLDS,
386: holding_report_header_id = null,
387: expense_last_status_date = sysdate
388: where holding_report_header_id = p_expense_report_id

Line 450: update ap_expense_report_headers_all

446: p_actid,
447: 'ABORT_RECEIPT_TYPE');
448: IF (NOT EventKeyExists(l_event_key)) THEN
449: IF (l_receipt_type = 'ORIGINAL') THEN
450: update ap_expense_report_headers_all
451: set receipts_status = ''
452: where report_header_id = l_report_header_id
453: and nvl(receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) not in (AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED)
454: and receipts_received_date is null;

Line 456: update ap_expense_report_headers_all

452: where report_header_id = l_report_header_id
453: and nvl(receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) not in (AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED)
454: and receipts_received_date is null;
455: ELSE
456: update ap_expense_report_headers_all
457: set image_receipts_status = ''
458: where report_header_id = l_report_header_id
459: and nvl(image_receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) not in (AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED)
460: and image_receipts_received_date is null;

Line 464: update ap_expense_report_headers_all

460: and image_receipts_received_date is null;
461: END IF;
462:
463: begin
464: update ap_expense_report_headers_all
465: set expense_status_code = C_PENDING_HOLDS,
466: holding_report_header_id = null,
467: expense_last_status_date = sysdate
468: where holding_report_header_id = l_report_header_id

Line 570: from ap_expense_report_headers_all

566: l_total,
567: l_purpose,
568: l_report_submitted_date,
569: l_missing_img_just
570: from ap_expense_report_headers_all
571: where report_header_id = l_expense_report_id;
572:
573: ----------------------------------------------------------
574: l_debug_info := 'Get Preparer Id using Created By';

Line 1087: FROM ap_expense_report_headers_all WHERE report_header_id = l_expense_report_id;

1083: l_expense_report_id := ParseItemKey(p_item_type, p_item_key);
1084:
1085: SELECT receipts_status, image_receipts_status, expense_status_code, workflow_approved_flag
1086: INTO l_receipts_status, l_image_receipts_status, l_expense_status_code, l_workflow_flag
1087: FROM ap_expense_report_headers_all WHERE report_header_id = l_expense_report_id;
1088:
1089: IF (l_receipts_status = AP_WEB_RECEIPTS_WF.C_RECEIVED OR l_receipts_status = AP_WEB_RECEIPTS_WF.C_WAIVED OR
1090: l_receipts_status = AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED OR l_expense_status_code = 'REJECTED' OR l_expense_status_code = 'RETURNED' OR
1091: l_expense_status_code = 'WITHDRAWN') THEN

Line 1325: from ap_expense_report_headers_all

1321: l_debug_info := 'Retrieve current Receipt Status';
1322: ------------------------------------------------------------
1323: select receipts_status
1324: into l_receipts_status
1325: from ap_expense_report_headers_all
1326: where report_header_id = p_report_header_id;
1327:
1328: return l_receipts_status;
1329:

Line 1403: from ap_expense_report_headers_all

1399: l_debug_info := 'Lock current Receipt Status';
1400: ------------------------------------------------------------
1401: select receipts_status
1402: into l_orig_receipts_status
1403: from ap_expense_report_headers_all
1404: where report_header_id = p_report_header_id
1405: for update of receipts_status nowait;
1406:
1407: ------------------------------------------------------------

Line 1410: update ap_expense_report_headers_all

1406:
1407: ------------------------------------------------------------
1408: l_debug_info := 'Update current Receipt Status';
1409: ------------------------------------------------------------
1410: update ap_expense_report_headers_all
1411: set receipts_status = p_receipts_status
1412: where report_header_id = p_report_header_id;
1413:
1414: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetReceiptsStatus');

Line 1768: from ap_expense_report_headers_all aerh,

1764: l_debug_info := 'Check if Missing or Policy Shortpay';
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

Line 2059: l_received_date ap_expense_report_headers_all.receipts_received_date%type;

2055: l_created_by number;
2056: --l_preparer_id number;
2057:
2058: l_org_id ap_expense_params_all.org_id%type;
2059: l_received_date ap_expense_report_headers_all.receipts_received_date%type;
2060: BEGIN
2061:
2062: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start StoreNote');
2063:

Line 2134: from ap_expense_report_headers_all

2130: -- bug 6361555
2131: begin
2132: select created_by
2133: into l_created_by
2134: from ap_expense_report_headers_all
2135: where report_header_id = l_report_header_id;
2136: exception
2137: when others then
2138: null;

Line 2276: FROM ap_expense_report_headers_all WHERE report_header_id = l_report_header_id;

2272: elsif (l_fnd_message = 'APWRECPT_RECEIVED_SENT') THEN
2273: BEGIN
2274: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2275: SELECT trunc(receipts_received_date) INTO l_received_date
2276: FROM ap_expense_report_headers_all WHERE report_header_id = l_report_header_id;
2277: FND_MESSAGE.SET_TOKEN('RECEIVED_DATE', to_char(l_received_date));
2278: EXCEPTION
2279: WHEN OTHERS THEN
2280: NULL;

Line 2286: FROM ap_expense_report_headers_all WHERE report_header_id = l_report_header_id;

2282: elsif (l_fnd_message = 'APWRECPT_IMG_RECEIVED_SENT') THEN
2283: BEGIN
2284: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2285: SELECT trunc(image_receipts_received_date) INTO l_received_date
2286: FROM ap_expense_report_headers_all WHERE report_header_id = l_report_header_id;
2287: FND_MESSAGE.SET_TOKEN('RECEIVED_DATE', to_char(l_received_date));
2288: EXCEPTION
2289: WHEN OTHERS THEN
2290: NULL;

Line 2451: UPDATE AP_EXPENSE_REPORT_HEADERS_ALL

2447:
2448: end if;
2449:
2450: -- Supervisor Notifications
2451: UPDATE AP_EXPENSE_REPORT_HEADERS_ALL
2452: SET OVERDUE_REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
2453: WHERE REPORT_HEADER_ID = p_expense_report_id;
2454:
2455: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseOverdueEvent');

Line 2752: from ap_expense_report_headers_all

2748: SELECT DISTINCT supervisor_id FROM
2749: (SELECT emp.supervisor_id
2750: FROM per_employees_x emp
2751: WHERE emp.employee_id in (select distinct employee_id
2752: from ap_expense_report_headers_all
2753: where overdue_request_id = FND_GLOBAL.CONC_REQUEST_ID)
2754: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
2755: UNION ALL
2756: SELECT emp.supervisor_id

Line 2759: from ap_expense_report_headers_all

2755: UNION ALL
2756: SELECT emp.supervisor_id
2757: FROM per_cont_workers_current_x emp
2758: WHERE emp.person_id in (select distinct employee_id
2759: from ap_expense_report_headers_all
2760: where overdue_request_id = FND_GLOBAL.CONC_REQUEST_ID)
2761: );
2762:
2763:

Line 3030: from ap_expense_report_headers_all where report_header_id = l_expense_report_id;

3026: Wf_Core.Raise('InvalidExpenseReportId');
3027: end if;
3028:
3029: select nvl(receipts_status,'N'), nvl(image_receipts_status,'N') into l_receipts_status, l_image_receipts_status
3030: from ap_expense_report_headers_all where report_header_id = l_expense_report_id;
3031:
3032: IF (l_receipts_status = 'RECEIVED') THEN
3033: l_receipts_status := 'Y';
3034: ELSE

Line 3106: from ap_expense_report_headers_all

3102: l_debug_info := 'Retrieve current Receipt Status';
3103: ------------------------------------------------------------
3104: select image_receipts_status
3105: into l_receipts_status
3106: from ap_expense_report_headers_all
3107: where report_header_id = p_report_header_id;
3108:
3109: return l_receipts_status;
3110:

Line 3139: from ap_expense_report_headers_all

3135: l_debug_info := 'Lock current Receipt Status';
3136: ------------------------------------------------------------
3137: select image_receipts_status
3138: into l_image_receipts_status
3139: from ap_expense_report_headers_all
3140: where report_header_id = p_report_header_id
3141: for update of receipts_status nowait;
3142:
3143: ------------------------------------------------------------

Line 3146: update ap_expense_report_headers_all

3142:
3143: ------------------------------------------------------------
3144: l_debug_info := 'Update current Receipt Status';
3145: ------------------------------------------------------------
3146: update ap_expense_report_headers_all
3147: set image_receipts_status = p_receipts_status
3148: where report_header_id = p_report_header_id;
3149:
3150: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetImageReceiptsStatus');

Line 3518: from ap_expense_report_headers_all

3514: IF (l_receipt_rule.rule_set_id is null OR nvl(l_receipt_rule.allow_recpt_decl,'N') = 'N') THEN
3515: p_result := 'COMPLETE:Y';
3516: ELSE
3517: select nvl(workflow_approved_flag, 1) into l_wf_appr_flag
3518: from ap_expense_report_headers_all
3519: where report_header_id = l_expense_report_id;
3520:
3521: IF (l_wf_appr_flag IN ('A','P','Y')) THEN
3522: p_result := 'COMPLETE:Y';

Line 3524: update ap_expense_report_headers_all set

3520:
3521: IF (l_wf_appr_flag IN ('A','P','Y')) THEN
3522: p_result := 'COMPLETE:Y';
3523: ELSE
3524: update ap_expense_report_headers_all set
3525: expense_status_code = 'RETURNED',
3526: report_submitted_date = null,last_update_date = sysdate
3527: where report_header_id = l_expense_report_id;
3528:

Line 3612: FROM ap_expense_report_headers_all

3608: end if;
3609:
3610: SELECT nvl(receipts_status, 'NOT_REQUIRED'), nvl(image_receipts_status, 'NOT_REQUIRED')
3611: INTO l_receipts_status, l_image_receipts_status
3612: FROM ap_expense_report_headers_all
3613: WHERE report_header_id = l_expense_report_id;
3614:
3615: IF (l_image_receipts_status <> 'NOT_REQUIRED' AND l_receipts_status = 'NOT_REQUIRED') THEN
3616: SetReceiptsStatus(l_expense_report_id, 'REQUIRED');

Line 3669: FROM ap_expense_report_headers_all WHERE report_header_id = l_expense_report_id;

3665: p_result := 'COMPLETE:'||l_result;
3666:
3667: /*l_expense_report_id := ParseItemKey(p_item_type, p_item_key);
3668: SELECT receipts_status, image_receipts_status INTO l_receipts_status, l_image_receipts_status
3669: FROM ap_expense_report_headers_all WHERE report_header_id = l_expense_report_id;
3670:
3671: IF (l_receipts_status = 'RECEIVED' AND l_image_receipts_status = 'RECEIVED') THEN
3672: p_result := 'COMPLETE:BOTH';
3673: ELSIF(l_receipts_status = 'RECEIVED') THEN

Line 3832: FROM ap_expense_report_headers_all

3828: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
3829: p_item_key,
3830: 'EXPENSE_REPORT_ID');
3831: SELECT nvl(workflow_approved_flag, 1) INTO l_wf_status_code
3832: FROM ap_expense_report_headers_all
3833: WHERE report_header_id = l_report_header_id;
3834:
3835: IF (l_wf_status_code = AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_RETURNED) THEN
3836: p_result := 'COMPLETE:Y';