APPS.AP_CREDIT_CARD_INVOICE_PKG dependencies on AP_CREDIT_CARD_TRXNS

Line 24: -- AP_CREDIT_CARD_TRXNS.

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'

Line 27: -- the AP_CREDIT_CARD_TRXNS_ALL need to be updated with COMPANY_PREPAID_FLAG set to

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.

Line 216: l_debugInfo := 'Update AP_CREDIT_CARD_TRXNS_ALL.COMPANY_PREPAID_INVOICE_ID';

212: ----------------------------------------------------------------------
213: FND_FILE.PUT_LINE( FND_FILE.LOG, ' processing transaction id: ' || l_card_trxn_id );
214:
215: ----------------------------------------------------------------------
216: l_debugInfo := 'Update AP_CREDIT_CARD_TRXNS_ALL.COMPANY_PREPAID_INVOICE_ID';
217: ----------------------------------------------------------------------
218: l_result := AP_WEB_DB_CCARD_PKG.SetCCTrxnInvoiceId(
219: l_card_trxn_id,
220: l_invoice_id );

Line 356: update ap_credit_card_trxns_all

352:
353: /*
354: Rejected invoice should be purged from the interface table
355: */
356: update ap_credit_card_trxns_all
357: set company_prepaid_invoice_id = null
358: where company_prepaid_invoice_id = l_invoice_id_temp -- Bug 6687752
359: and card_program_id = p_cardProgramID;
360: