[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
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: ---------------------------------------------------------------------------------
35: PROCEDURE createCreditCardInvoice(
169: END IF;
170: END IF;
171:
172: --------------------------------------------------------------------
173: l_debugInfo := 'Getting next sequence from AP_INVOICE_LINES_INTERFACE_S';
174: --------------------------------------------------------------------
175: l_result := AP_WEB_DB_AP_INT_PKG.GetNextInvoiceLineId(
176: l_invoice_line_id );
177: IF ( l_result <> TRUE ) THEN
192: l_description := substr(l_description,1, length(l_description) -1);
193: END IF;
194:
195: ---------------------------------------------------------------------
196: l_debugInfo := 'Inserting into AP_INVOICE_LINES_INTERFACE';
197: ---------------------------------------------------------------------
198: l_result := AP_WEB_DB_AP_INT_PKG.InsertInvoiceLinesInterface(
199: l_invoice_id,
200: l_invoice_line_id,
364:
365: delete from ap_invoices_interface
366: where invoice_id = l_invoice_id;
367:
368: delete from ap_invoice_lines_interface
369: where invoice_id = l_invoice_id;
370: */
371:
372: FOR i in l_rejection_list.FIRST .. l_rejection_list.LAST LOOP
598: IF l_clearingCCID is null THEN
599: raise no_data_found;
600: END IF;
601:
602: INSERT INTO AP_INVOICE_LINES_INTERFACE
603: (INVOICE_ID,
604: INVOICE_LINE_ID,
605: LINE_TYPE_LOOKUP_CODE,
606: ACCOUNTING_DATE,
609: DIST_CODE_COMBINATION_ID,
610: ORG_ID,
611: CC_REVERSAL_FLAG)
612: SELECT p_invoiceId,
613: AP_INVOICE_LINES_INTERFACE_S.nextval,
614: 'MISCELLANEOUS',
615: p_gl_date,
616: -l_cCardLineAmt,
617: DECODE(nvl(gcc.account_type, 'x'),