159: if g_debug_flag = 'Y' then
160: edw_log.put_names('FII_AP_TR_BKLG_SUMMARY.log','FII_AP_TR_BKLG_SUMMARY.out',l_dir);
161:
162:
163: fii_util.put_timestamp;
164: end if;
165:
166: -- --------------------------------------------------------
167: -- Find the schema owner and tablespace
178: AND owner = g_fii_schema;
179:
180: if g_debug_flag = 'Y' then
181: edw_log.put_line('Getting current quarter start date and end date');
182: fii_util.start_timer;
183: end if;
184: g_cur_qtr_start_date := FII_TIME_WH_API.get_curr_eqtr_start;
185: g_cur_qtr_end_date := FII_TIME_WH_API.get_curr_eqtr_end;
186: g_today := FII_TIME_WH_API.today;
184: g_cur_qtr_start_date := FII_TIME_WH_API.get_curr_eqtr_start;
185: g_cur_qtr_end_date := FII_TIME_WH_API.get_curr_eqtr_end;
186: g_today := FII_TIME_WH_API.today;
187: if g_debug_flag = 'Y' then
188: fii_util.stop_timer;
189: fii_util.print_timer('Duration');
190:
191: fii_util.start_timer;
192: end if;
185: g_cur_qtr_end_date := FII_TIME_WH_API.get_curr_eqtr_end;
186: g_today := FII_TIME_WH_API.today;
187: if g_debug_flag = 'Y' then
188: fii_util.stop_timer;
189: fii_util.print_timer('Duration');
190:
191: fii_util.start_timer;
192: end if;
193: POPULATE_FII_AP_DISC_SUMMARY;
187: if g_debug_flag = 'Y' then
188: fii_util.stop_timer;
189: fii_util.print_timer('Duration');
190:
191: fii_util.start_timer;
192: end if;
193: POPULATE_FII_AP_DISC_SUMMARY;
194: if g_debug_flag = 'Y' then
195: fii_util.stop_timer;
191: fii_util.start_timer;
192: end if;
193: POPULATE_FII_AP_DISC_SUMMARY;
194: if g_debug_flag = 'Y' then
195: fii_util.stop_timer;
196: fii_util.print_timer('Duration');
197: end if;
198:
199: EXCEPTION
192: end if;
193: POPULATE_FII_AP_DISC_SUMMARY;
194: if g_debug_flag = 'Y' then
195: fii_util.stop_timer;
196: fii_util.print_timer('Duration');
197: end if;
198:
199: EXCEPTION
200: WHEN OTHERS THEN