[Home] [Help]
18: -- Returns:
19: -- none
20: --
21: -- Desc:
22: -- Insert the records into AP_INVOICE_LINES_INTERFACE and AP_INVOICES_INTERFACE
23: -- to create invoice for caredit card isser for payment of records in
24: -- AP_CREDIT_CARD_TRXNS.
25: --
26: -- After being inserted into invoice open interface, the corresponding records in
26: -- After being inserted into invoice open interface, the corresponding records in
27: -- the AP_CREDIT_CARD_TRXNS_ALL need to be updated with COMPANY_PREPAID_FLAG set to
28: -- 'Y'
29: --
30: -- Single record is inserted into AP_INVOICES_INTERFACE and serves as a header to
31: -- those records inserted into AP_INVOICE_LINES_INTERFACE.
32: --
33: -- InvoiceId of the newly created Invoice is returned back.
34: ---------------------------------------------------------------------------------
158: l_sum := l_sum + l_billed_amt;
159:
160: IF ( l_count = 1 ) THEN
161: --------------------------------------------------------------------
162: l_debugInfo := 'Getting next sequence from AP_INVOICES_INTERFACE_S';
163: --------------------------------------------------------------------
164: l_result := AP_WEB_DB_AP_INT_PKG.GetNextInvoiceId(
165: l_invoice_id );
166:
304: IF (FND_PROFILE.VALUE('UNIQUE:SEQ_NUMBERS') = 'N') THEN
305: l_doc_cat_code := NULL;
306: END IF;
307: ------------------------------------------------------------------------
308: l_debugInfo := 'Inserting into AP_INVOICES_INTERFACE';
309: fnd_file.put_line(fnd_file.log, l_debugInfo);
310: ------------------------------------------------------------------------
311: l_result := AP_WEB_DB_AP_INT_PKG.InsertInvoiceInterface(
312: l_invoice_id,
365: /*
366: delete from ap_interface_rejections
367: where parent_id = l_invoice_id;
368:
369: delete from ap_invoices_interface
370: where invoice_id = l_invoice_id;
371:
372: delete from ap_invoice_lines_interface
373: where invoice_id = l_invoice_id;