[Home] [Help]
44: ln_total_rg_amount number;
45: r_last_record JAI_CMN_RG_PERIOD_BALS%rowtype;
46:
47: /* rallamse bug#4336482 */
48: p_consolidate_till DATE; -- DEFAULT fnd_date.canonical_to_date(pv_consolidate_till) File.Sql.35 by Brathod
49: /* End of Bug# 4336482 */
50:
51: lc_end_date date ; -- := to_date('31-MAR-2003', 'dd-mon-yyyy') File.Sql.35 by Brathod
52:
147: /*Bug 5989740 bduvarag end*/
148: BEGIN
149:
150: lc_end_date := to_date(' 31/03/2003', 'dd/mm/yyyy'); -- File.Sql.35 by Brathod
151: p_consolidate_till := fnd_date.canonical_to_date(pv_consolidate_till); -- File.Sql.35 by Brathod
152:
153: /*--------------------------------------------------------------------------------------------------------------------------------
154: Change History for Filename - jai_cmn_rg_period_bals_pkg.sql
155: S.No dd/mm/yyyy Author and Details
162: 2 28/04/2005 rallamse for Bug#4336482, Version 116.1
163: For SEED there is a change in concurrent "JAINRGPB" to use FND_STANDARD_DATE with STANDARD_DATE format
164: Procedure ja_in_rg_period_balance_pkg.consolidate_balances signature modified by converting p_consolidate_till of DATE datatype
165: to pv_consolidate_till of varchar2 datatype. The varchar2 values are converted to DATE fromat
166: using fnd_date.canonical_to_date function.
167:
168:
169: 3. 26-FEB-2007 SSAWANT , File version 120.2
170: Forward porting the change in 11.5 bug 5060037 to R12 bug no 5241875.