APPS.AP_WEB_EXPORT_ER dependencies on AP_INTERFACE_REJECTIONS

Line 286: FROM ap_interface_rejections air, ap_invoices_interface aii

282: CURSOR c_rejected_invoices(l_request_id IN NUMBER) IS
283: SELECT to_number(aii.reference_key1) report_header_id,
284: reject_lookup_code,
285: aii.invoice_id
286: FROM ap_interface_rejections air, ap_invoices_interface aii
287: WHERE air.parent_table = 'AP_INVOICES_INTERFACE'
288: AND air.parent_id = aii.invoice_id
289: AND aii.request_id = l_request_id
290: UNION ALL

Line 294: FROM ap_interface_rejections air,

290: UNION ALL
291: SELECT to_number(aii.reference_key1) report_header_id,
292: reject_lookup_code,
293: aii.invoice_id
294: FROM ap_interface_rejections air,
295: ap_invoices_interface aii,
296: ap_invoice_lines_interface aili
297: WHERE air.parent_table = 'AP_INVOICE_LINES_INTERFACE'
298: AND air.parent_id = aili.invoice_line_id

Line 577: TYPE RejectCodeType IS TABLE OF ap_interface_rejections.reject_lookup_code%TYPE

573: l_sys_apply_advances_flag ap_system_parameters.apply_advances_default%TYPE;
574:
575: TYPE ReportHeaderIdType IS TABLE OF ap_expense_report_headers.report_header_id%TYPE
576: INDEX BY BINARY_INTEGER;
577: TYPE RejectCodeType IS TABLE OF ap_interface_rejections.reject_lookup_code%TYPE
578: INDEX BY BINARY_INTEGER;
579: TYPE InvoiceIdType IS TABLE OF ap_invoices_interface.invoice_id%TYPE
580: INDEX BY BINARY_INTEGER;
581: TYPE AdvAppliedType IS TABLE OF ap_expense_report_headers.maximum_amount_to_apply%TYPE

Line 1828: DELETE FROM ap_interface_rejections

1824: WHERE report_header_id = l_report_header_id_list(i)
1825: and nvl(vouchno,0) = 0;
1826:
1827: FORALL i IN l_invoice_id_list.FIRST .. l_invoice_id_list.LAST
1828: DELETE FROM ap_interface_rejections
1829: WHERE parent_table = 'AP_INVOICES_INTERFACE'
1830: AND parent_id = l_invoice_id_list(i);
1831:
1832: FORALL i IN l_invoice_id_list.FIRST .. l_invoice_id_list.LAST

Line 1833: DELETE FROM ap_interface_rejections

1829: WHERE parent_table = 'AP_INVOICES_INTERFACE'
1830: AND parent_id = l_invoice_id_list(i);
1831:
1832: FORALL i IN l_invoice_id_list.FIRST .. l_invoice_id_list.LAST
1833: DELETE FROM ap_interface_rejections
1834: WHERE parent_table = 'AP_INVOICE_LINES_INTERFACE'
1835: AND parent_id IN
1836: (SELECT invoice_line_id
1837: FROM ap_invoice_lines_interface