APPS.AP_CREDIT_CARD_INVOICE_PKG dependencies on AP_CREDIT_CARD_TRXNS_ALL

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 360: update ap_credit_card_trxns_all

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

Line 384: update ap_credit_card_trxns_all

380: fnd_file.put_line(fnd_file.log, l_debugInfo);
381: END LOOP;
382:
383: Else -- Bug 8365869 start
384: update ap_credit_card_trxns_all
385: set company_prepaid_invoice_id = l_invoice_id
386: where company_prepaid_invoice_id = l_invoice_id_temp -- Bug 8365869 update the company_prepaid_invoice_id as invoice_id in ap_invoices_all
387: and card_program_id = p_cardProgramID;
388: -- Bug 8365869 end

Line 606: ap_credit_card_trxns_all cc,

602: erh.employee_id,
603: erl.vat_code,
604: erl.amount_includes_tax_flag
605: FROM ap_expense_report_lines_all erl,
606: ap_credit_card_trxns_all cc,
607: ap_expense_report_headers_all erh
608: WHERE erl.report_header_id = erh.report_header_id
609: AND nvl(erl.itemization_parent_id,0) <> -1 /* Itemization Project */
610: AND cc.trx_id = erl.credit_card_trx_id -- is a credit card transaction