311: edw_log.put_names('FII_AP_OP_IND_SMMARY.log','FII_AP_OP_IND_SUMMARY.out',l_dir);
312: end if;
313:
314: if g_debug_flag = 'Y' then
315: fii_util.put_timestamp;
316: end if;
317:
318: -- --------------------------------------------------------
319: -- Find the schema owner and tablespace
332: if g_debug_flag = 'Y' then
333: edw_log.put_line('Getting current quarter start date');
334: end if;
335: if g_debug_flag = 'Y' then
336: fii_util.start_timer;
337: end if;
338: g_cur_qtr_start_date := FII_TIME_WH_API.get_curr_eqtr_start;
339: g_today := FII_TIME_WH_API.today;
340:
338: g_cur_qtr_start_date := FII_TIME_WH_API.get_curr_eqtr_start;
339: g_today := FII_TIME_WH_API.today;
340:
341: if g_debug_flag = 'Y' then
342: fii_util.stop_timer;
343: fii_util.print_timer('Duration');
344:
345: fii_util.start_timer;
346: end if;
339: g_today := FII_TIME_WH_API.today;
340:
341: if g_debug_flag = 'Y' then
342: fii_util.stop_timer;
343: fii_util.print_timer('Duration');
344:
345: fii_util.start_timer;
346: end if;
347: CREATE_FII_AP_OP_IND_SUM_TEMP;
341: if g_debug_flag = 'Y' then
342: fii_util.stop_timer;
343: fii_util.print_timer('Duration');
344:
345: fii_util.start_timer;
346: end if;
347: CREATE_FII_AP_OP_IND_SUM_TEMP;
348: if g_debug_flag = 'Y' then
349: fii_util.stop_timer;
345: fii_util.start_timer;
346: end if;
347: CREATE_FII_AP_OP_IND_SUM_TEMP;
348: if g_debug_flag = 'Y' then
349: fii_util.stop_timer;
350: fii_util.print_timer('Duration');
351:
352: fii_util.start_timer;
353: end if;
346: end if;
347: CREATE_FII_AP_OP_IND_SUM_TEMP;
348: if g_debug_flag = 'Y' then
349: fii_util.stop_timer;
350: fii_util.print_timer('Duration');
351:
352: fii_util.start_timer;
353: end if;
354:
348: if g_debug_flag = 'Y' then
349: fii_util.stop_timer;
350: fii_util.print_timer('Duration');
351:
352: fii_util.start_timer;
353: end if;
354:
355: POPULATE_FII_AP_OP_IND_SUMMARY;
356: if g_debug_flag = 'Y' then
353: end if;
354:
355: POPULATE_FII_AP_OP_IND_SUMMARY;
356: if g_debug_flag = 'Y' then
357: fii_util.stop_timer;
358: fii_util.print_timer('Duration');
359: end if;
360:
361: EXCEPTION
354:
355: POPULATE_FII_AP_OP_IND_SUMMARY;
356: if g_debug_flag = 'Y' then
357: fii_util.stop_timer;
358: fii_util.print_timer('Duration');
359: end if;
360:
361: EXCEPTION
362: WHEN OTHERS THEN