[Home] [Help]
149: -- Vpedarla Bug:6784251 Modified the cursor
150: -- Vpedarla Bug:7257708 Modified the cursor. corrected the mistake done for bug: 6784251
151: CURSOR cur_bckt_end_date IS
152: SELECT MIN(trunc(mpsd.next_date))
153: FROM msc_period_start_dates mpsd,
154: msc_trading_partners mtp
155: WHERE
156: mtp.calendar_code = mpsd.calendar_code
157: AND mtp.calendar_exception_set_id = mpsd.exception_set_id
167: -- AND mpsd.period_sequence_num = (SELECT mod((mpsd2.period_sequence_num + G_period_bucket - 1) , 12 ) Bug: 9719725
168: AND to_char(mpsd.period_start_date,'MON-YYYY') = (select to_CHAR(ADD_MONTHS(G_week_bckt_cutoff_dt,G_period_bucket),'MON-YYYY') from dual);
169: --Added above line and commented below as part of Bug # 13374085 to display no of period buckets eqaul to the value entered for period buckets
170: /* AND mod(mpsd.period_sequence_num,12) = (SELECT mod((mpsd2.period_sequence_num + G_period_bucket - 1) , 12 )
171: FROM msc_period_start_dates mpsd2
172: WHERE mpsd2.period_start_date = trunc(G_week_bckt_cutoff_dt)
173: AND mpsd2.calendar_code = mpsd.calendar_code
174: AND mpsd2.exception_set_id = mpsd.exception_set_id
175: -- AND mpsd2.sr_instance_id = mtp.sr_instance_id) + G_period_bucket); -- bug:6784251 Vpedarla
2034: -- vpedarla Bug: 8363786 end
2035:
2036: gmp_debug_message(' l_bckt_end_date ' || to_CHAR(l_bckt_end_date, 'DD-MON-YYY HH24:MI:SS') );
2037:
2038: /* nsinghi: since the next_date column in msc_period_start_dates already give end_date + 1,
2039: so no need to add 1. */
2040: -- g_num_of_buckets := (l_bckt_end_date + 1) - (l_bckt_start_date - 1);
2041:
2042: -- Rajesh Patangya, We have to see if the end date is coming as null