APPS.AP_WEB_RECEIPT_MANAGEMENT_UTIL dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 58: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,

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

Line 59: AP_EXPENSE_REPORT_HEADERS_ALL aerh2

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

Line 246: from AP_EXPENSE_REPORT_HEADERS_ALL aerh

242: p_event IN VARCHAR2) IS
243:
244: CURSOR header_cur IS
245: select aerh.*
246: from AP_EXPENSE_REPORT_HEADERS_ALL aerh
247: where aerh.report_header_id = p_report_header_id
248: FOR UPDATE OF REPORT_HEADER_ID NOWAIT;
249:
250: CURSOR split_cc_cur IS

Line 252: from AP_EXPENSE_REPORT_HEADERS_ALL aerh

248: FOR UPDATE OF REPORT_HEADER_ID NOWAIT;
249:
250: CURSOR split_cc_cur IS
251: select aerh.report_header_id
252: from AP_EXPENSE_REPORT_HEADERS_ALL aerh
253: where aerh.BOTHPAY_PARENT_ID = p_report_header_id
254: and holding_report_header_id is not null;
255:
256: CURSOR orig_cc_cur(l_report_header_id IN NUMBER) IS

Line 258: from AP_EXPENSE_REPORT_HEADERS_ALL aerh

254: and holding_report_header_id is not null;
255:
256: CURSOR orig_cc_cur(l_report_header_id IN NUMBER) IS
257: select aerh.report_header_id
258: from AP_EXPENSE_REPORT_HEADERS_ALL aerh
259: where aerh.report_header_id = l_report_header_id
260: and holding_report_header_id is not null
261: and NOT EXISTS (select 1
262: from ap_expense_report_lines_all aerl

Line 293: UPDATE ap_expense_report_headers_all

289:
290: l_new_status := get_receipt_status(p_report_header_id, p_event);
291:
292: IF (header_rec.report_header_id IS NOT NULL) THEN
293: UPDATE ap_expense_report_headers_all
294: SET receipts_status = l_new_status
295: WHERE CURRENT OF header_cur;
296: END IF;
297:

Line 340: UPDATE AP_EXPENSE_REPORT_HEADERS_ALL

336: END LOOP;
337: END IF;
338: ELSIF (p_event = C_EVENT_SHORTPAY) THEN
339: IF l_new_status = C_STATUS_NOT_REQUIRED THEN
340: UPDATE AP_EXPENSE_REPORT_HEADERS_ALL
341: SET receipts_received_date = null
342: WHERE CURRENT OF header_cur;
343: END IF;
344:

Line 347: UPDATE AP_EXPENSE_REPORT_HEADERS_ALL

343: END IF;
344:
345: ELSIF (p_event = C_EVENT_MR_SHORTPAY) THEN
346:
347: UPDATE AP_EXPENSE_REPORT_HEADERS_ALL
348: SET receipts_received_date = null, report_filing_number = null
349: WHERE CURRENT OF header_cur;
350:
351: ELSIF (p_event = C_EVENT_PV_SHORTPAY) THEN