APPS.FV_DC_ASSIGN_FINANCE_CHRG dependencies on FV_INVOICE_FINANCE_CHRGS

Line 1370: INSERT INTO fv_invoice_finance_chrgs_all

1366: AND fcgd.start_date <= sysdate
1367: AND decode(fcgd.end_date,null,sysdate,fcgd.end_date) >= sysdate
1368: ) LOOP
1369: BEGIN
1370: INSERT INTO fv_invoice_finance_chrgs_all
1371: (
1372: customer_trx_id,
1373: customer_id,
1374: charge_id,

Line 1412: l_location := l_module_name||'.insert_fv_invoice_finance_chrgs';

1408: EXCEPTION
1409: WHEN OTHERS THEN
1410: p_retcode := g_FAILURE;
1411: p_errbuf := SQLERRM;
1412: l_location := l_module_name||'.insert_fv_invoice_finance_chrgs';
1413: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1414: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
1415: END;
1416: END LOOP;

Line 1690: fv_invoice_finance_chrgs fifc,

1686: fifc.finance_charge_group_dtl_id,
1687: NVL(fcc.prorate_charge, 'N') prorate_charge,
1688: fcc.invoice_suffix
1689: FROM ar_payment_schedules aps,
1690: fv_invoice_finance_chrgs fifc,
1691: fv_finance_charge_controls fcc,
1692: fv_finance_charge_history fch,
1693: ra_customer_trx rct,
1694: ra_cust_trx_types rctt,

Line 2431: INSERT INTO fv_invoice_finance_chrgs

2427: END;
2428: END IF;
2429: IF (p_retcode = g_SUCCESS) THEN
2430: BEGIN
2431: INSERT INTO fv_invoice_finance_chrgs
2432: (
2433: customer_id,
2434: customer_trx_id,
2435: charge_id,

Line 2496: FROM fv_invoice_finance_chrgs fifc

2492: FROM fv_finance_charge_controls
2493: WHERE set_of_books_id = g_set_of_books_id)*/
2494:
2495: AND NOT EXISTS (SELECT 'x'
2496: FROM fv_invoice_finance_chrgs fifc
2497: WHERE ract.customer_trx_id = fifc.customer_trx_id
2498: AND ract.bill_to_customer_id=fifc.customer_id
2499: AND fcgd.assessed_charge_id = fifc.charge_id
2500: AND set_of_books_id = g_set_of_books_id);

Line 2505: l_location := l_module_name||'.insert_fv_invoice_finance_chrgs';

2501: EXCEPTION
2502: WHEN OTHERS THEN
2503: p_retcode := g_FAILURE;
2504: p_errbuf := SQLERRM;
2505: l_location := l_module_name||'.insert_fv_invoice_finance_chrgs';
2506: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
2507: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
2508: END;
2509: END IF;

Line 2543: l_location := l_module_name||'.insert_fv_invoice_finance_chrgs';

2539: EXCEPTION
2540: WHEN OTHERS THEN
2541: p_retcode := g_FAILURE;
2542: p_errbuf := SQLERRM;
2543: l_location := l_module_name||'.insert_fv_invoice_finance_chrgs';
2544: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
2545: fv_utility.log_mesg(fnd_log.level_unexpected, l_module_name||'.final_exception', p_errbuf);
2546: ROLLBACK;
2547: END assign_finance_charge;