APPS.ISC_FS_TASK_BAC_AGE_ETL_PKG dependencies on ISC_FS_TASK_BAC_DATES_C

Line 177: from isc_fs_task_bac_dates_c;

173: l_stmt_id := 10;
174: if p_mode = 'incremental_load' then
175: select max(aging_date)
176: into l_max_aging_date
177: from isc_fs_task_bac_dates_c;
178: else
179: l_max_aging_date := l_collect_to_date_trunc-1;
180: end if;
181:

Line 184: update isc_fs_task_bac_dates_c

180: end if;
181:
182: l_stmt_id := 20;
183: if trunc(l_max_aging_date) = l_collect_to_date_trunc then
184: update isc_fs_task_bac_dates_c
185: set aging_date = l_collect_to_date
186: , last_update_date = sysdate
187: , last_updated_by = g_user_id
188: , last_update_login = g_login_id

Line 203: -- truncate the isc_fs_task_bac_dates_c fact table

199: return 0;
200:
201: end if;
202:
203: -- truncate the isc_fs_task_bac_dates_c fact table
204: l_stmt_id := 30;
205: if truncate_table
206: ( p_isc_schema
207: , 'ISC_FS_TASK_BAC_DATES_C'

Line 207: , 'ISC_FS_TASK_BAC_DATES_C'

203: -- truncate the isc_fs_task_bac_dates_c fact table
204: l_stmt_id := 30;
205: if truncate_table
206: ( p_isc_schema
207: , 'ISC_FS_TASK_BAC_DATES_C'
208: , x_error_message ) <> 0 then
209: logger( l_proc_name, l_stmt_id, x_error_message );
210: return -1;
211: end if;

Line 219: into isc_fs_task_bac_dates_c

215: -- insert into task current backlog age dates tables
216: l_stmt_id := 40;
217:
218: insert
219: into isc_fs_task_bac_dates_c
220: ( aging_date
221: , record_type_id
222: , xtd_end_date_flag
223: , week_start_date

Line 424: , 'ISC_FS_TASK_BAC_DATES_C'

420: -- gather stats for staging table
421: l_stmt_id := 50;
422: if gather_statistics
423: ( p_isc_schema
424: , 'ISC_FS_TASK_BAC_DATES_C'
425: , x_error_message ) <> 0 then
426: logger( l_proc_name, l_stmt_id, x_error_message );
427: return -1;
428: end if;

Line 560: isc_fs_task_bac_dates_c;

556: , g_program_login_id
557: , g_program_application_id
558: , g_request_id
559: from
560: isc_fs_task_bac_dates_c;
561:
562: l_temp_rowcount := sql%rowcount;
563:
564: bis_collection_utilities_log( l_temp_rowcount || ' rows inserted into task backlog age dates base summary table', 1 );

Line 704: where report_date not in (select trunc(aging_date) from isc_fs_task_bac_dates_c);

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:
708: bis_collection_utilities_log( l_temp_rowcount || ' rows deleted from task backlog age dates base summary table', 1 );

Line 742: isc_fs_task_bac_dates_c c

738: , g_program_login_id
739: , g_program_application_id
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;