[Home] [Help]
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
240: account for the Non Recoverable Item In RMA order having VAT taxes.
241: Called procedure jai_cmn_rgm_recording_pkg.insert_vat_repository_entry to insert records in the jai_rgm_trx_records
242: table to reverse the VAT settlement entries for the non recoverable Items in the RMA Order.
243: 23. 05-may-2010 vkaranam for bug#9662961
244: Issue:
245: RTV accounting entries for VAT is hitting the final recovery account due to which the VAT settlement
1912: lv_category_name VARCHAR2(100); -- := 'Receiving India';
1913: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
1914: lv_reference_10 gl_interface.reference10%TYPE;
1915: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_claim';
1916: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'jai_rgm_trx_records';
1917: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'repository_id';
1918: lv_destination VARCHAR2(10) ; -- := 'G';
1919:
1920: ln_code_combination_id NUMBER;
1923: lv_reference_25 gl_interface.reference25%TYPE;
1924: lv_code_path JAI_RCV_TRANSACTIONS.codepath%TYPE;
1925: lv_process_status VARCHAR2(2);
1926: lv_process_message VARCHAR2(1000);
1927: ln_repository_id jai_rgm_trx_records.repository_id%TYPE;
1928: r_claim_schedule c_claim_schedule%ROWTYPE;
1929: lv_codepath JAI_RCV_TRANSACTIONS.codepath%TYPE;
1930: ln_interim_recovery_account NUMBER;
1931: r_vat_invoice c_vat_invoice%ROWTYPE;
1947: lv_source_name := 'Purchasing India';
1948: lv_category_name := 'Receiving India';
1949: ld_accounting_date := TRUNC(SYSDATE);
1950: lv_reference_23 := 'jai_rgm_claim_pkg.process_claim';
1951: lv_reference_24 := 'jai_rgm_trx_records';
1952: lv_reference_26 := 'repository_id';
1953: lv_destination := 'G';
1954: /* End of File.Sql.35 by Brathod */
1955: