APPS.AP_CREDIT_CARD_INVOICE_PKG dependencies on AP_INVOICE_LINES_INTERFACE

Line 22: -- Insert the records into AP_INVOICE_LINES_INTERFACE and AP_INVOICES_INTERFACE

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

Line 31: -- those records inserted into AP_INVOICE_LINES_INTERFACE.

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(

Line 173: l_debugInfo := 'Getting next sequence from AP_INVOICE_LINES_INTERFACE_S';

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

Line 196: l_debugInfo := 'Inserting into AP_INVOICE_LINES_INTERFACE';

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,

Line 372: delete from ap_invoice_lines_interface

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;
374: */
375:
376: FOR i in l_rejection_list.FIRST .. l_rejection_list.LAST LOOP

Line 639: INSERT INTO AP_INVOICE_LINES_INTERFACE

635: IF l_clearingCCID is null THEN
636: raise no_data_found;
637: END IF;
638:
639: INSERT INTO AP_INVOICE_LINES_INTERFACE
640: (INVOICE_ID,
641: INVOICE_LINE_ID,
642: LINE_TYPE_LOOKUP_CODE,
643: ACCOUNTING_DATE,

Line 652: AP_INVOICE_LINES_INTERFACE_S.nextval,

648: CC_REVERSAL_FLAG,
649: TAX_CLASSIFICATION_CODE,
650: AMOUNT_INCLUDES_TAX_FLAG)
651: SELECT p_invoiceId,
652: AP_INVOICE_LINES_INTERFACE_S.nextval,
653: 'MISCELLANEOUS',
654: p_gl_date,
655: -l_cCardLineAmt,
656: DECODE(nvl(gcc.account_type, 'x'),