APPS.ISC_DEPOT_MTTR_ETL_PKG dependencies on ISC_DR_INC

Line 69: from isc_dr_inc

65: bis_collection_utilities.log( 'Global Start Date: ' || fnd_date.date_to_displaydt(g_global_start_date), 1 );
66:
67: l_stmt_id := 20;
68: delete
69: from isc_dr_inc
70: where fact_name = 'ISC_DR_MTTR_F';
71:
72: bis_collection_utilities.log( 'Deleted from table ISC_DR_INC', 1 );
73:

Line 72: bis_collection_utilities.log( 'Deleted from table ISC_DR_INC', 1 );

68: delete
69: from isc_dr_inc
70: where fact_name = 'ISC_DR_MTTR_F';
71:
72: bis_collection_utilities.log( 'Deleted from table ISC_DR_INC', 1 );
73:
74: l_stmt_id := 30;
75: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_MTTR_F';
76:

Line 311: isc_dr_inc

307: l_stmt_id := 110;
308: -- Insertion into the incremental log table
309:
310: insert into
311: isc_dr_inc
312: ( fact_name
313: , last_run_date
314: , created_by
315: , creation_date

Line 338: bis_collection_utilities.log( 'Inserted into table ISC_DR_INC', 1 );

334: , l_program_application_id
335: , l_request_id
336: );
337:
338: bis_collection_utilities.log( 'Inserted into table ISC_DR_INC', 1 );
339:
340: l_stmt_id := 120;
341: commit;
342:

Line 747: update isc_dr_inc

743: bis_collection_utilities.log( 'Merged ' || l_temp_rowcount || ' rows into ISC_DR_MTTR_F' , 1 );
744: l_rowcount := l_rowcount + l_temp_rowcount;
745:
746: l_stmt_id := 70;
747: update isc_dr_inc
748: set last_run_date = l_last_run_date
749: , last_update_date = sysdate
750: , last_updated_by = l_user_id
751: , last_update_login = l_login_id

Line 758: bis_collection_utilities.log( 'Updated into table ISC_DR_INC', 1 );

754: , program_application_id = l_program_application_id
755: , request_id = l_request_id
756: WHERE fact_name = 'ISC_DR_MTTR_F' ;
757:
758: bis_collection_utilities.log( 'Updated into table ISC_DR_INC', 1 );
759:
760: l_stmt_id := 80;
761: commit;
762: