APPS.ISC_DEPOT_MARGIN_ETL_PKG dependencies on ISC_DR_INC

Line 493: from isc_dr_inc

489: bis_collection_utilities.log( 'Secondary Global Currency Rate Type: ' || g_global_sec_rate_type, 1 );
490:
491: l_stmnt_id := 20;
492: delete
493: from isc_dr_inc
494: where fact_name = 'ISC_DR_CHARGES_F';
495:
496: bis_collection_utilities.log( 'Deleted from table ISC_DR_INC', 1 );
497:

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

492: delete
493: from isc_dr_inc
494: where fact_name = 'ISC_DR_CHARGES_F';
495:
496: bis_collection_utilities.log( 'Deleted from table ISC_DR_INC', 1 );
497:
498: l_stmnt_id := 30;
499: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_CHARGES_F';
500:

Line 615: insert into isc_dr_inc

611: l_stmnt_id := 60;
612: commit;
613:
614: l_stmnt_id := 70;
615: insert into isc_dr_inc
616: ( fact_name
617: , last_run_date
618: , created_by
619: , creation_date

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

638: , g_program_application_id
639: , g_request_id
640: );
641:
642: bis_collection_utilities.log( 'Inserted into table ISC_DR_INC', 1 );
643:
644: l_stmnt_id := 80;
645: commit;
646:

Line 735: from isc_dr_inc

731: bis_collection_utilities.log( 'Secondary Global Currency Rate Type: ' || g_global_sec_rate_type, 1 );
732:
733: l_stmnt_id := 20;
734: delete
735: from isc_dr_inc
736: where fact_name = 'ISC_DR_COSTS_F';
737:
738: bis_collection_utilities.log( 'Deleted from table ISC_DR_INC', 1 );
739:

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

734: delete
735: from isc_dr_inc
736: where fact_name = 'ISC_DR_COSTS_F';
737:
738: bis_collection_utilities.log( 'Deleted from table ISC_DR_INC', 1 );
739:
740: l_stmnt_id := 30;
741: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_COSTS_STG';
742:

Line 844: isc_dr_inc

840: commit;
841:
842: l_stmnt_id := 120;
843: insert into
844: isc_dr_inc
845: ( fact_name
846: , last_run_date
847: , created_by
848: , creation_date

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

867: , g_program_application_id
868: , g_request_id
869: );
870:
871: bis_collection_utilities.log( 'Inserted into table ISC_DR_INC', 1 );
872:
873: l_stmnt_id := 130;
874: commit;
875:

Line 1122: update isc_dr_inc

1118: l_rowcount := sql%rowcount;
1119: bis_collection_utilities.log( 'Merged ' || l_rowcount || ' rows into ISC_DR_CHARGES_F' , 1 );
1120:
1121: l_stmnt_id := 50;
1122: update isc_dr_inc
1123: set
1124: last_run_date = l_ro_last_run_date
1125: , last_update_date = sysdate
1126: , last_updated_by = g_user_id

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

1130: , program_application_id = g_program_application_id
1131: , request_id = g_request_id
1132: where fact_name = 'ISC_DR_CHARGES_F';
1133:
1134: bis_collection_utilities.log( 'Updated into table ISC_DR_INC', 1 );
1135:
1136: l_stmnt_id := 60;
1137: commit;
1138:

Line 1370: update isc_dr_inc

1366: l_rowcount := sql%rowcount;
1367: bis_collection_utilities.log( 'Merged ' || l_rowcount || ' rows into ISC_DR_COSTS_F' , 1 );
1368:
1369: l_stmnt_id := 90;
1370: update isc_dr_inc
1371: set last_run_date = l_ro_last_run_date
1372: , last_update_date = sysdate
1373: , last_updated_by = g_user_id
1374: , last_update_login = g_login_id

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

1377: , program_application_id = g_program_application_id
1378: , request_id = g_request_id
1379: where fact_name = 'ISC_DR_COSTS_F';
1380:
1381: bis_collection_utilities.log( 'Updated into table ISC_DR_INC', 1 );
1382:
1383: l_stmnt_id := 100;
1384: commit;
1385: