APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 404: ap_invoice_distributions_all for the matched invoices so that the tax distributions will

400: Issue - If excise tax is unclaimed after running "Mass Addtions Create" program, the
401: unclaimed amount does not flow to assets when "Mass Additions Create" is run
402: again.
403: Fix - Added code in process_deferred_cenvat_claim procedure to update related flags in
404: ap_invoice_distributions_all for the matched invoices so that the tax distributions will
405: be picked up by the "Mass Additions Create" program.
406:
407: 40 23-Oct-2009 Bug 9032251 File version 120.11.12000000.12 / 120.25.12010000.10 / 120.34
408: Issue - If the receipt line has excise and vat taxes, and excise is unclaimed after

Line 1081: ln_invoice_id ap_invoice_distributions_all.invoice_id%TYPE;

1077: -- lv_process_flag JAI_RCV_TRANSACTIONS.PROCESS_STATUS%TYPE;
1078: -- lv_process_message JAI_RCV_TRANSACTIONS.process_message%TYPE;
1079:
1080: /*Bug 8648138 - Start*/
1081: ln_invoice_id ap_invoice_distributions_all.invoice_id%TYPE;
1082:
1083: CURSOR get_invoice (cp_transaction_id NUMBER) IS
1084: SELECT DISTINCT invoice_id
1085: FROM ap_invoice_distributions_all

Line 1085: FROM ap_invoice_distributions_all

1081: ln_invoice_id ap_invoice_distributions_all.invoice_id%TYPE;
1082:
1083: CURSOR get_invoice (cp_transaction_id NUMBER) IS
1084: SELECT DISTINCT invoice_id
1085: FROM ap_invoice_distributions_all
1086: WHERE rcv_transaction_id = cp_transaction_id;
1087: /*Bug 8648138 - End*/
1088:
1089: BEGIN

Line 1463: UPDATE ap_invoice_distributions_all aida

1459: ln_invoice_id := r_invoice.invoice_id;
1460:
1461: IF ln_invoice_id IS NOT NULL THEN
1462:
1463: UPDATE ap_invoice_distributions_all aida
1464: SET assets_addition_flag = 'U',
1465: assets_tracking_flag = 'Y',
1466: charge_applicable_to_dist_id = (select invoice_distribution_id from ap_invoice_distributions_all
1467: where line_type_lookup_code in ('ITEM', 'ACCRUAL')

Line 1466: charge_applicable_to_dist_id = (select invoice_distribution_id from ap_invoice_distributions_all

1462:
1463: UPDATE ap_invoice_distributions_all aida
1464: SET assets_addition_flag = 'U',
1465: assets_tracking_flag = 'Y',
1466: charge_applicable_to_dist_id = (select invoice_distribution_id from ap_invoice_distributions_all
1467: where line_type_lookup_code in ('ITEM', 'ACCRUAL')
1468: and po_distribution_id = aida.po_distribution_id and invoice_id = ln_invoice_id)
1469: /*Added by nprashar for bug# 11659328 ,Removed code added by bug # 10628363, as the fix is functionally not correct , the only change
1470: required was to add an invoice_id condition*/