APPS.FII_AR_RISK_PKG dependencies on FII_UTIL

Line 500: fii_util.put_timestamp;

496: if g_debug_flag = 'Y' then
497: edw_log.put_names('FII_AR_RISK_INDICATOR_F.log','FII_AR_RISK_INDICATOR_F.out',l_dir);
498:
499:
500: fii_util.put_timestamp;
501: edw_log.put_line('Initialization');
502: fii_util.start_timer;
503: end if;
504: Init;

Line 502: fii_util.start_timer;

498:
499:
500: fii_util.put_timestamp;
501: edw_log.put_line('Initialization');
502: fii_util.start_timer;
503: end if;
504: Init;
505: Drop_table('FII_AR_OLTP_OPEN_INV');
506: if g_debug_flag = 'Y' then

Line 507: fii_util.stop_timer;

503: end if;
504: Init;
505: Drop_table('FII_AR_OLTP_OPEN_INV');
506: if g_debug_flag = 'Y' then
507: fii_util.stop_timer;
508: fii_util.print_timer('Duration');
509:
510: fii_util.put_timestamp;
511: edw_log.put_line('Summarzing OE backlog information');

Line 508: fii_util.print_timer('Duration');

504: Init;
505: Drop_table('FII_AR_OLTP_OPEN_INV');
506: if g_debug_flag = 'Y' then
507: fii_util.stop_timer;
508: fii_util.print_timer('Duration');
509:
510: fii_util.put_timestamp;
511: edw_log.put_line('Summarzing OE backlog information');
512: fii_util.start_timer;

Line 510: fii_util.put_timestamp;

506: if g_debug_flag = 'Y' then
507: fii_util.stop_timer;
508: fii_util.print_timer('Duration');
509:
510: fii_util.put_timestamp;
511: edw_log.put_line('Summarzing OE backlog information');
512: fii_util.start_timer;
513: end if;
514: -- DEBUG

Line 512: fii_util.start_timer;

508: fii_util.print_timer('Duration');
509:
510: fii_util.put_timestamp;
511: edw_log.put_line('Summarzing OE backlog information');
512: fii_util.start_timer;
513: end if;
514: -- DEBUG
515: isc_edw_backlog_sum1_f_c.Populate(l_errbuf, l_retcode);
516: if g_debug_flag = 'Y' then

Line 517: fii_util.stop_timer;

513: end if;
514: -- DEBUG
515: isc_edw_backlog_sum1_f_c.Populate(l_errbuf, l_retcode);
516: if g_debug_flag = 'Y' then
517: fii_util.stop_timer;
518: fii_util.print_timer('Duration');
519:
520:
521: edw_log.put_line('');

Line 518: fii_util.print_timer('Duration');

514: -- DEBUG
515: isc_edw_backlog_sum1_f_c.Populate(l_errbuf, l_retcode);
516: if g_debug_flag = 'Y' then
517: fii_util.stop_timer;
518: fii_util.print_timer('Duration');
519:
520:
521: edw_log.put_line('');
522: edw_log.put_line('Extracting Open Invoice Installments');

Line 523: fii_util.start_timer;

519:
520:
521: edw_log.put_line('');
522: edw_log.put_line('Extracting Open Invoice Installments');
523: fii_util.start_timer;
524: end if;
525: Extract_OLTP_OPEN_INV;
526: if g_debug_flag = 'Y' then
527: fii_util.stop_timer;

Line 527: fii_util.stop_timer;

523: fii_util.start_timer;
524: end if;
525: Extract_OLTP_OPEN_INV;
526: if g_debug_flag = 'Y' then
527: fii_util.stop_timer;
528: fii_util.print_timer('Duration');
529:
530: edw_log.put_line('');
531: edw_log.put_line('Summarizing into AR Risk Summary Table');

Line 528: fii_util.print_timer('Duration');

524: end if;
525: Extract_OLTP_OPEN_INV;
526: if g_debug_flag = 'Y' then
527: fii_util.stop_timer;
528: fii_util.print_timer('Duration');
529:
530: edw_log.put_line('');
531: edw_log.put_line('Summarizing into AR Risk Summary Table');
532: fii_util.start_timer;

Line 532: fii_util.start_timer;

528: fii_util.print_timer('Duration');
529:
530: edw_log.put_line('');
531: edw_log.put_line('Summarizing into AR Risk Summary Table');
532: fii_util.start_timer;
533: end if;
534: Populate_RISK_INDICATOR;
535: if g_debug_flag = 'Y' then
536: fii_util.stop_timer;

Line 536: fii_util.stop_timer;

532: fii_util.start_timer;
533: end if;
534: Populate_RISK_INDICATOR;
535: if g_debug_flag = 'Y' then
536: fii_util.stop_timer;
537: fii_util.print_timer('Duration');
538: end if;
539:
540: Drop_table('FII_AR_OLTP_OPEN_INV');

Line 537: fii_util.print_timer('Duration');

533: end if;
534: Populate_RISK_INDICATOR;
535: if g_debug_flag = 'Y' then
536: fii_util.stop_timer;
537: fii_util.print_timer('Duration');
538: end if;
539:
540: Drop_table('FII_AR_OLTP_OPEN_INV');
541: