eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ISC_FS_TASK_BAC_AGE_ETL_PKG dependencies on ISC_FS_TASK_BAC_DATES_F

Line 17: g_object_name constant varchar2(30) := 'ISC_FS_TASK_BAC_DATES_F';

13: g_error constant varchar2(10) := '-1';
14: g_warning constant varchar2(10) := '1';
15: g_bis_setup_exception exception;
16: g_global_start_date date;
17: g_object_name constant varchar2(30) := 'ISC_FS_TASK_BAC_DATES_F';
18: g_max_date constant date := to_date('4712/01/01','yyyy/mm/dd');
19:
20: procedure bis_collection_utilities_log
21: ( m varchar2, indent number default null )

Line 517: -- truncate the isc_fs_task_bac_dates_f fact table

513: logger( l_proc_name, l_stmt_id, l_error_message );
514: raise l_exception;
515: end if;
516:
517: -- truncate the isc_fs_task_bac_dates_f fact table
518: l_stmt_id := 40;
519: if truncate_table
520: ( l_isc_schema
521: , 'ISC_FS_TASK_BAC_DATES_F'

Line 521: , 'ISC_FS_TASK_BAC_DATES_F'

517: -- truncate the isc_fs_task_bac_dates_f fact table
518: l_stmt_id := 40;
519: if truncate_table
520: ( l_isc_schema
521: , 'ISC_FS_TASK_BAC_DATES_F'
522: , l_error_message ) <> 0 then
523: logger( l_proc_name, l_stmt_id, l_error_message );
524: raise l_exception;
525: end if;

Line 529: -- insert into isc_fs_task_bac_dates_f fact table

525: end if;
526:
527: bis_collection_utilities_log( 'Task backlog age dates base summary table truncated', 1 );
528:
529: -- insert into isc_fs_task_bac_dates_f fact table
530: l_stmt_id := 50;
531: insert /*+ append f */
532: into isc_fs_task_bac_dates_f f
533: ( report_date

Line 532: into isc_fs_task_bac_dates_f f

528:
529: -- insert into isc_fs_task_bac_dates_f fact table
530: l_stmt_id := 50;
531: insert /*+ append f */
532: into isc_fs_task_bac_dates_f f
533: ( report_date
534: , aging_date
535: , xtd_end_date_flag
536: , creation_date

Line 693: delete from isc_fs_task_bac_dates_f

689: end if;
690:
691: -- delete the "current" row for last aging as was probably a partitial day ( 692: l_stmt_id := 40;
693: delete from isc_fs_task_bac_dates_f
694: where report_date = (select max(report_date) from isc_fs_task_bac_dates_f)
695: and aging_date <> l_collect_to_date;
696:
697: if sql%rowcount > 0 then

Line 694: where report_date = (select max(report_date) from isc_fs_task_bac_dates_f)

690:
691: -- delete the "current" row for last aging as was probably a partitial day ( 692: l_stmt_id := 40;
693: delete from isc_fs_task_bac_dates_f
694: where report_date = (select max(report_date) from isc_fs_task_bac_dates_f)
695: and aging_date <> l_collect_to_date;
696:
697: if sql%rowcount > 0 then
698: bis_collection_utilities_log( 'Previous current as at date row deleted from task backlog age dates base summary table', 1 );

Line 701: -- cleanup isc_fs_task_bac_dates_f, remove old rows that are not for period ends

697: if sql%rowcount > 0 then
698: bis_collection_utilities_log( 'Previous current as at date row deleted from task backlog age dates base summary table', 1 );
699: end if;
700:
701: -- cleanup isc_fs_task_bac_dates_f, remove old rows that are not for period ends
702: l_stmt_id := 50;
703: delete from isc_fs_task_bac_dates_f
704: where report_date not in (select trunc(aging_date) from isc_fs_task_bac_dates_c);
705:

Line 703: delete from isc_fs_task_bac_dates_f

699: end if;
700:
701: -- cleanup isc_fs_task_bac_dates_f, remove old rows that are not for period ends
702: l_stmt_id := 50;
703: delete from isc_fs_task_bac_dates_f
704: where report_date not in (select trunc(aging_date) from isc_fs_task_bac_dates_c);
705:
706: l_temp_rowcount := sql%rowcount;
707:

Line 711: -- insert into isc_fs_task_bac_dates_f fact table

707:
708: bis_collection_utilities_log( l_temp_rowcount || ' rows deleted from task backlog age dates base summary table', 1 );
709: l_rowcount := l_rowcount + l_temp_rowcount;
710:
711: -- insert into isc_fs_task_bac_dates_f fact table
712: l_stmt_id := 60;
713: insert
714: into isc_fs_task_bac_dates_f
715: ( report_date

Line 714: into isc_fs_task_bac_dates_f

710:
711: -- insert into isc_fs_task_bac_dates_f fact table
712: l_stmt_id := 60;
713: insert
714: into isc_fs_task_bac_dates_f
715: ( report_date
716: , aging_date
717: , xtd_end_date_flag
718: , created_by

Line 744: trunc(aging_date) not in (select report_date from isc_fs_task_bac_dates_f);

740: , g_request_id
741: from
742: isc_fs_task_bac_dates_c c
743: where
744: trunc(aging_date) not in (select report_date from isc_fs_task_bac_dates_f);
745:
746: l_temp_rowcount := sql%rowcount;
747:
748: bis_collection_utilities_log( l_temp_rowcount || ' rows inserted into task backlog age dates base summary table', 1 );