29: BEGIN <
30:
31: jxdate := to_char(xdate, 'J');
32:
33: if not fa_cache_pkg.fazccp(p_cal, fiscal_year_name, jxdate,
34: pro_month,
35: fiscalyr, dummy, p_log_level_rec => p_log_level_rec) then
36:
37: -- get retirement period number in fazccp
135: if p_log_level_rec.statement_level then
136: fa_debug_pkg.add(l_calling_fn, 'in fagpdi 3', '', p_log_level_rec => p_log_level_rec);
137: end if;
138:
139: if not fa_cache_pkg.fazccp(period_type, fiscal_year_name,
140: ret_p_jdate,
141: ret_pd, fiscal_year, dummy, p_log_level_rec => p_log_level_rec) then
142:
143: -- get retirement period number in fazccp
856: --I added code for following month convention also.
857:
858: --Bug11886090: Honor retirement prorate convention if CALCULATE tracking method w/o sum-up
859: if (( h_group_asset_id is not null )
860: or (nvl(fa_cache_pkg.fazcdrd_record.rule_name,'ZZ') = 'ENERGY PERIOD END BALANCE' )) /* Added condition for ER 12600386 */
861: and
862: not(nvl(h_tracking_method, 'NULL') = 'CALCULATE' and
863: nvl(h_member_rollup_flag, 'N') = 'N') then
864: