APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 235: Fix - Added code in process_deferred_cenvat_claim procedure to update related flags in ap_invoice_distributions_all

231:
232: 21 09-AUG-2009 Bug 8648138
233: Issue - If VAT is unclaimed after running "Mass Addtions Create" program, the unclaimed amount does not
234: flow to assets when "Mass Additions Create" is run again.
235: Fix - Added code in process_deferred_cenvat_claim procedure to update related flags in ap_invoice_distributions_all
236: for the matched invoices so that the tax distributions will be picked up by the "Mass Additions Create" program.
237:
238: 22. 20-AUG-2009 JMEENA for bug#8302581
239: Modified procedure do_rma_accounting and added code to debit the Liability account and credit Interim Liabality

Line 2535: ln_invoice_id ap_invoice_distributions_all.invoice_id%TYPE;

2531: ln_process_special_amount NUMBER;
2532: ln_apportion_factor NUMBER;
2533:
2534: /*Bug 8648138*/
2535: ln_invoice_id ap_invoice_distributions_all.invoice_id%TYPE;
2536:
2537: CURSOR get_invoice(cp_transaction_id NUMBER) IS
2538: SELECT DISTINCT invoice_id
2539: FROM ap_invoice_distributions_all

Line 2539: FROM ap_invoice_distributions_all

2535: ln_invoice_id ap_invoice_distributions_all.invoice_id%TYPE;
2536:
2537: CURSOR get_invoice(cp_transaction_id NUMBER) IS
2538: SELECT DISTINCT invoice_id
2539: FROM ap_invoice_distributions_all
2540: WHERE rcv_transaction_id = cp_transaction_id;
2541: /*Bug 8648138*/
2542: /*Added by Wenqiong for bug 14743050 begin*/
2543: CURSOR c_receive_correct_qty(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

Line 2803: UPDATE ap_invoice_distributions_all aida

2799: ln_invoice_id := r_invoice.invoice_id;
2800:
2801: IF ln_invoice_id IS NOT NULL THEN
2802:
2803: UPDATE ap_invoice_distributions_all aida
2804: SET assets_addition_flag = 'U',
2805: assets_tracking_flag = 'Y',
2806: charge_applicable_to_dist_id = (select invoice_distribution_id from ap_invoice_distributions_all
2807: where line_type_lookup_code in ('ITEM', 'ACCRUAL')

Line 2806: charge_applicable_to_dist_id = (select invoice_distribution_id from ap_invoice_distributions_all

2802:
2803: UPDATE ap_invoice_distributions_all aida
2804: SET assets_addition_flag = 'U',
2805: assets_tracking_flag = 'Y',
2806: charge_applicable_to_dist_id = (select invoice_distribution_id from ap_invoice_distributions_all
2807: where line_type_lookup_code in ('ITEM', 'ACCRUAL')
2808: and po_distribution_id = aida.po_distribution_id and invoice_id = ln_invoice_id)
2809: /*Added by nprashar for bug # 11659328*/
2810: WHERE invoice_id = ln_invoice_id