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_RECEIPT_MANAGEMENT_UTIL dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 61: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,

57: CURSOR header_cur IS
58: select aerh.receipts_status,
59: aerh.receipts_received_date,
60: aerh2.receipts_status parent_receipts_status
61: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,
62: AP_EXPENSE_REPORT_HEADERS_ALL aerh2
63: where aerh.report_header_id = p_report_header_id
64: and aerh2.report_header_id(+) = aerh.shortpay_parent_id;
65:

Line 62: AP_EXPENSE_REPORT_HEADERS_ALL aerh2

58: select aerh.receipts_status,
59: aerh.receipts_received_date,
60: aerh2.receipts_status parent_receipts_status
61: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,
62: AP_EXPENSE_REPORT_HEADERS_ALL aerh2
63: where aerh.report_header_id = p_report_header_id
64: and aerh2.report_header_id(+) = aerh.shortpay_parent_id;
65:
66: header_rec header_cur%ROWTYPE;

Line 225: FROM ap_expense_report_headers_all WHERE report_header_id = p_report_header_id;

221:
222: BEGIN
223:
224: SELECT receipts_status INTO l_receipts_status
225: FROM ap_expense_report_headers_all WHERE report_header_id = p_report_header_id;
226:
227: IF l_receipts_status = C_STATUS_RECEIVED THEN
228: RETURN C_STATUS_RECEIVED;
229: END IF;

Line 296: from AP_EXPENSE_REPORT_HEADERS_ALL aerh

292: p_event IN VARCHAR2) IS
293:
294: CURSOR header_cur IS
295: select aerh.*
296: from AP_EXPENSE_REPORT_HEADERS_ALL aerh
297: where aerh.report_header_id = p_report_header_id
298: FOR UPDATE OF REPORT_HEADER_ID NOWAIT;
299:
300: CURSOR split_cc_cur IS

Line 302: from AP_EXPENSE_REPORT_HEADERS_ALL aerh

298: FOR UPDATE OF REPORT_HEADER_ID NOWAIT;
299:
300: CURSOR split_cc_cur IS
301: select aerh.report_header_id
302: from AP_EXPENSE_REPORT_HEADERS_ALL aerh
303: where aerh.BOTHPAY_PARENT_ID = p_report_header_id
304: and holding_report_header_id is not null;
305:
306: CURSOR orig_cc_cur(l_report_header_id IN NUMBER) IS

Line 308: from AP_EXPENSE_REPORT_HEADERS_ALL aerh

304: and holding_report_header_id is not null;
305:
306: CURSOR orig_cc_cur(l_report_header_id IN NUMBER) IS
307: select aerh.report_header_id
308: from AP_EXPENSE_REPORT_HEADERS_ALL aerh
309: where aerh.report_header_id = l_report_header_id
310: and holding_report_header_id is not null
311: and NOT EXISTS (select 1
312: from ap_expense_report_lines_all aerl

Line 349: UPDATE ap_expense_report_headers_all

345:
346: IF (header_rec.report_header_id IS NOT NULL) THEN
347: IF (p_event = C_EVENT_MIR_SHORTPAY) THEN
348: l_line_status := get_line_receipt_status(p_report_header_id);
349: UPDATE ap_expense_report_headers_all
350: SET image_receipts_status = l_new_status,
351: receipts_status = l_line_status
352: WHERE CURRENT OF header_cur;
353: ELSIF (p_event = C_EVENT_MBR_SHORTPAY) THEN

Line 354: UPDATE ap_expense_report_headers_all

350: SET image_receipts_status = l_new_status,
351: receipts_status = l_line_status
352: WHERE CURRENT OF header_cur;
353: ELSIF (p_event = C_EVENT_MBR_SHORTPAY) THEN
354: UPDATE ap_expense_report_headers_all
355: SET image_receipts_status = l_new_status,
356: receipts_status = l_new_status
357: WHERE CURRENT OF header_cur;
358: ELSE

Line 360: UPDATE ap_expense_report_headers_all

356: receipts_status = l_new_status
357: WHERE CURRENT OF header_cur;
358: ELSE
359: l_line_status := get_image_receipt_status(p_report_header_id, p_event);
360: UPDATE ap_expense_report_headers_all
361: SET receipts_status = l_new_status,
362: image_receipts_status = l_line_status
363: WHERE CURRENT OF header_cur;
364: END IF;

Line 408: UPDATE AP_EXPENSE_REPORT_HEADERS_ALL

404: END LOOP;
405: END IF;
406: ELSIF (p_event = C_EVENT_SHORTPAY) THEN
407: IF l_new_status = C_STATUS_NOT_REQUIRED THEN
408: UPDATE AP_EXPENSE_REPORT_HEADERS_ALL
409: SET receipts_received_date = null
410: WHERE CURRENT OF header_cur;
411: END IF;
412:

Line 415: UPDATE AP_EXPENSE_REPORT_HEADERS_ALL

411: END IF;
412:
413: ELSIF (p_event = C_EVENT_MR_SHORTPAY) THEN
414:
415: UPDATE AP_EXPENSE_REPORT_HEADERS_ALL
416: SET receipts_received_date = null, report_filing_number = null
417: WHERE CURRENT OF header_cur;
418:
419: ELSIF (p_event = C_EVENT_MIR_SHORTPAY) THEN

Line 421: UPDATE AP_EXPENSE_REPORT_HEADERS_ALL

417: WHERE CURRENT OF header_cur;
418:
419: ELSIF (p_event = C_EVENT_MIR_SHORTPAY) THEN
420:
421: UPDATE AP_EXPENSE_REPORT_HEADERS_ALL
422: SET image_receipts_received_date = null
423: WHERE CURRENT OF header_cur;
424:
425: ELSIF (p_event = C_EVENT_MBR_SHORTPAY) THEN

Line 427: UPDATE AP_EXPENSE_REPORT_HEADERS_ALL

423: WHERE CURRENT OF header_cur;
424:
425: ELSIF (p_event = C_EVENT_MBR_SHORTPAY) THEN
426:
427: UPDATE AP_EXPENSE_REPORT_HEADERS_ALL
428: SET image_receipts_received_date = null, receipts_received_date = null, report_filing_number = null
429: WHERE CURRENT OF header_cur;
430:
431: ELSIF (p_event = C_EVENT_PV_SHORTPAY) THEN

Line 445: UPDATE ap_expense_report_headers_all

441: AND (header_rec.receipts_status <> 'NOT_REQUIRED' OR header_rec.image_receipts_status <> 'NOT_REQUIRED')) THEN
442: AP_WEB_RECEIPTS_WF.RaiseAbortedEvent(p_report_header_id);
443: l_temp_org_status := get_receipt_status(p_report_header_id, C_EVENT_NONE);
444: l_temp_img_status := get_image_receipt_status(p_report_header_id, C_EVENT_NONE);
445: UPDATE ap_expense_report_headers_all
446: SET receipts_status = l_temp_org_status,
447: image_receipts_status = l_temp_img_status
448: WHERE report_header_id = p_report_header_id;
449: ELSIF header_rec.receipts_status = 'RECEIVED' THEN

Line 526: FROM ap_expense_report_headers_all WHERE report_header_id = p_report_header_id;

522:
523: BEGIN
524:
525: SELECT receipts_status, image_receipts_status INTO l_receipts_status, l_header_status
526: FROM ap_expense_report_headers_all WHERE report_header_id = p_report_header_id;
527:
528: IF l_header_status = C_STATUS_NOT_REQUIRED THEN
529: return C_STATUS_NOT_REQUIRED;
530: ELSIF l_header_status = C_STATUS_RECEIVED THEN

Line 630: from ap_expense_report_headers_all aerh,

626: l_debug_info := 'Check if Missing or Policy Shortpay';
627: ------------------------------------------------------------
628: select 'Y'
629: into l_is_shortpay
630: from ap_expense_report_headers_all aerh,
631: wf_items wf
632: where aerh.report_header_id = p_report_header_id
633: and aerh.shortpay_parent_id is not null
634: and wf.item_type = 'APEXP'