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
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
291: SELECT to_number(aii.reference_key1) report_header_id,
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
299: AND aii.invoice_id = aili.invoice_id
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
582: INDEX BY BINARY_INTEGER;
583:
1121: IF g_debug_switch = 'Y' THEN
1122: fnd_file.put_line(fnd_file.log, l_debug_info);
1123: END IF;
1124:
1125: SELECT AP_INVOICES_INTERFACE_S.nextval
1126: INTO l_invoice_rec.invoice_id
1127: FROM DUAL;
1128:
1129:
1555:
1556:
1557:
1558: ----------------------------------------------------------
1559: l_debug_info := 'Insert into AP Invoices Interface table';
1560: ----------------------------------------------------------
1561: IF g_debug_switch = 'Y' THEN
1562: fnd_file.put_line(fnd_file.log, l_debug_info);
1563: END IF;
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
1833: DELETE FROM ap_interface_rejections
1837: FROM ap_invoice_lines_interface
1838: WHERE invoice_id = l_invoice_id_list(i));
1839:
1840: FORALL i IN l_invoice_id_list.FIRST .. l_invoice_id_list.LAST
1841: DELETE FROM ap_invoices_interface
1842: WHERE invoice_id = l_invoice_id_list(i);
1843:
1844: FORALL i IN l_invoice_id_list.FIRST .. l_invoice_id_list.LAST
1845: DELETE FROM ap_invoice_lines_interface
2144: PROCEDURE InsertInvoiceInterface(p_invoice_rec InvoiceInfoRecType,
2145: p_vendor_rec VendorInfoRecType) IS
2146: ------------------------------------------------------------------------
2147: BEGIN
2148: INSERT INTO AP_INVOICES_INTERFACE
2149: (INVOICE_ID,
2150: APPLICATION_ID,
2151: PRODUCT_TABLE,
2152: REFERENCE_KEY1,