APPS.ISC_FS_TASK_ACT_BAC_ETL_PKG dependencies on ISC_FS_TASK_ACTIVITY_F

Line 224: -- truncate the isc_fs_task_activity_f fact table

220: logger( l_proc_name, l_stmt_id, l_error_message );
221: raise l_exception;
222: end if;
223:
224: -- truncate the isc_fs_task_activity_f fact table
225: l_stmt_id := 40;
226: if truncate_table
227: ( l_isc_schema
228: , 'ISC_FS_TASK_ACTIVITY_F'

Line 228: , 'ISC_FS_TASK_ACTIVITY_F'

224: -- truncate the isc_fs_task_activity_f fact table
225: l_stmt_id := 40;
226: if truncate_table
227: ( l_isc_schema
228: , 'ISC_FS_TASK_ACTIVITY_F'
229: , l_error_message ) <> 0 then
230: logger( l_proc_name, l_stmt_id, l_error_message );
231: raise l_exception;
232: end if;

Line 252: parallel(isc_fs_task_activity_f)

248: -- insert into base fact tables
249: l_stmt_id := 60;
250:
251: insert /*+ append
252: parallel(isc_fs_task_activity_f)
253: parallel(isc_fs_task_backlog_f)
254: */
255: ALL
256: when 1 in (first_opened, reopened, closed) then

Line 257: into isc_fs_task_activity_f

253: parallel(isc_fs_task_backlog_f)
254: */
255: ALL
256: when 1 in (first_opened, reopened, closed) then
257: into isc_fs_task_activity_f
258: ( task_id
259: , task_audit_id
260: , activity_date
261: , first_opened

Line 1321: update isc_fs_task_activity_f

1317:
1318: for i in c_updated loop
1319:
1320: l_stmt_id := 94;
1321: update isc_fs_task_activity_f
1322: set
1323: source_object_type_code = i.source_object_type_code
1324: , task_type_id = i.task_type_id
1325: , task_type_rule = i.task_type_rule

Line 1464: -- insert the activity rows into isc_fs_task_activity_f

1460:
1461: bis_collection_utilities_log( 'Inserting activity', 1 );
1462:
1463: --
1464: -- insert the activity rows into isc_fs_task_activity_f
1465: --
1466: l_stmt_id := 120;
1467: insert into isc_fs_task_activity_f
1468: ( task_id

Line 1467: insert into isc_fs_task_activity_f

1463: --
1464: -- insert the activity rows into isc_fs_task_activity_f
1465: --
1466: l_stmt_id := 120;
1467: insert into isc_fs_task_activity_f
1468: ( task_id
1469: , task_audit_id
1470: , activity_date
1471: , first_opened