[Home] [Help]
158: 28/11/2005 Harshita for Bug 4762433, File Version 120.4
159: Issue :
160: a) lv_source_name was declared with length 15 and assigned the value
161: 'Purchasing India' which is of length 16 .
162: b) Who column information missing in the insert to the table JAI_RCV_REP_ACCRUAL_T.
163: Fix :
164: a) Modified the size of the variable lv_source_name from 15 to 20.
165: Changes made in the post_entries and regime_tax_accounting_interim procedures.
166: b) Added the who columns in the insert of JAI_RCV_REP_ACCRUAL_T.
162: b) Who column information missing in the insert to the table JAI_RCV_REP_ACCRUAL_T.
163: Fix :
164: a) Modified the size of the variable lv_source_name from 15 to 20.
165: Changes made in the post_entries and regime_tax_accounting_interim procedures.
166: b) Added the who columns in the insert of JAI_RCV_REP_ACCRUAL_T.
167: Change made in the post_entries procedures.
168: Future Dependency due to this Bug
169: ---------------------------------
170: None
244:
245: 01-Feb-2010 Bug 9319913 File version 120.21.12010000.8 / 120.28
246: Issue - Tax amount gets rounded in the accrual reconciliation report.
247: Fix - Removed the round() function for the accrual amount when inserting into table
248: jai_rcv_rep_accrual_t.
249:
250: 09-may-2011 vkaranam for bug#10167393
251: Issue: VALUE AND TAXES AS PER CORRECTION OF QTY IS NOT UPDATED IN SYSTEM
252: Fix:
2556:
2557:
2558: cursor c_ja_in_temp_po_accrual (cp_transaction_id number) is
2559: select count(1)
2560: from JAI_RCV_REP_ACCRUAL_T
2561: where transaction_id = cp_transaction_id;
2562:
2563: ln_ja_in_temp_po_accrual number;
2564:
2963: ptr_jv(2).non_rnd_entered_cr := ln_credit;
2964: ptr_jv(2).account_name := gv_ap_accrual;/*6488406*/
2965: ptr_jv(2).summary_jv_flag := 'Y';
2966: /*Bug 5527885 End*/
2967: /* Inserting into JAI_RCV_REP_ACCRUAL_T if no record is already inserted */
2968: p_codepath := jai_general_pkg.plot_codepath(18, p_codepath); /* 18 */
2969: open c_ja_in_temp_po_accrual(p_transaction_id);
2970: fetch c_ja_in_temp_po_accrual into ln_ja_in_temp_po_accrual;
2971: close c_ja_in_temp_po_accrual;
2971: close c_ja_in_temp_po_accrual;
2972:
2973: if nvl(ln_ja_in_temp_po_accrual, 0) = 0 then
2974: p_codepath := jai_general_pkg.plot_codepath(19, p_codepath); /* 19 */
2975: insert into JAI_RCV_REP_ACCRUAL_T
2976: (
2977: transaction_id,
2978: accrual_amount,
2979: -- Harshita, added the 4 parameters below for Bug 4762433