APPS.ISC_DEPOT_BACKLOG_ETL_PKG dependencies on ISC_DR_INC

Line 137: from isc_dr_inc

133: l_stmt_id := 0;
134:
135: select last_run_date
136: into x_run_date
137: from isc_dr_inc
138: where fact_name = p_fact_name;
139:
140: return c_ok;
141:

Line 302: from isc_dr_inc

298: bis_collection_utilities.log( 'Global Start Date: ' || fnd_date.date_to_displaydt(g_global_start_date), 1 );
299:
300: l_stmnt_id := 20;
301: delete
302: from isc_dr_inc
303: where fact_name = 'ISC_DR_REPAIR_ORDERS_F';
304:
305: bis_collection_utilities.log( 'Deleted from table ISC_DR_INC', 1 );
306:

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

301: delete
302: from isc_dr_inc
303: where fact_name = 'ISC_DR_REPAIR_ORDERS_F';
304:
305: bis_collection_utilities.log( 'Deleted from table ISC_DR_INC', 1 );
306:
307: l_stmnt_id := 30;
308: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_REPAIR_ORDERS_F';
309:

Line 413: insert into isc_dr_inc

409: l_rowcount := sql%rowcount;
410: bis_collection_utilities.log( 'Inserted ' || l_rowcount || ' rows into ISC_DR_REPAIR_ORDERS_F' , 1 );
411:
412: l_stmnt_id := 70;
413: insert into isc_dr_inc
414: ( fact_name
415: , last_run_date
416: , created_by
417: , creation_date

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

436: , l_program_application_id
437: , l_request_id
438: );
439:
440: bis_collection_utilities.log( 'Inserted into table ISC_DR_INC', 1 );
441:
442: l_stmnt_id := 80;
443: commit;
444:

Line 699: update isc_dr_inc

695: l_rowcount := sql%rowcount;
696: bis_collection_utilities.log( 'Merged ' || l_rowcount || ' rows into ISC_DR_REPAIR_ORDERS_F' , 1 );
697:
698: l_stmnt_id := 50;
699: update isc_dr_inc
700: set
701: last_run_date = l_run_date
702: , last_update_date = sysdate
703: , last_updated_by = l_user_id

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

707: , program_application_id = l_program_application_id
708: , request_id = l_request_id
709: where fact_name = 'ISC_DR_REPAIR_ORDERS_F';
710:
711: bis_collection_utilities.log( 'Updated into table ISC_DR_INC', 1 );
712:
713: l_stmnt_id := 60;
714: commit;
715: