APPS.ISC_DEPOT_MARGIN_ETL_PKG dependencies on ISC_DR_COSTS_F

Line 20: g_costs_object_name constant varchar2(30) := 'ISC_DR_COSTS_F';

16: g_program_application_id number;
17: g_request_id number;
18:
19: g_charges_object_name constant varchar2(30) := 'ISC_DR_CHARGES_F';
20: g_costs_object_name constant varchar2(30) := 'ISC_DR_COSTS_F';
21:
22: -- Common Procedures Definitions
23:
24: -- err_mesg

Line 736: where fact_name = 'ISC_DR_COSTS_F';

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:
740: l_stmnt_id := 30;

Line 751: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_COSTS_F';

747:
748: bis_collection_utilities.log( 'Truncated table ISC_DR_COSTS_CONV_TMP', 1 );
749:
750: l_stmnt_id := 50;
751: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_COSTS_F';
752:
753: bis_collection_utilities.log( 'Truncated table ISC_DR_COSTS_F', 1 );
754:
755: l_stmnt_id := 60;

Line 753: bis_collection_utilities.log( 'Truncated table ISC_DR_COSTS_F', 1 );

749:
750: l_stmnt_id := 50;
751: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_COSTS_F';
752:
753: bis_collection_utilities.log( 'Truncated table ISC_DR_COSTS_F', 1 );
754:
755: l_stmnt_id := 60;
756: if isc_depot_backlog_etl_pkg.get_last_run_date
757: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'

Line 792: insert /*+ append parallel(isc_dr_costs_f) */

788: l_stmnt_id := 90;
789: commit;
790:
791: l_stmnt_id := 100;
792: insert /*+ append parallel(isc_dr_costs_f) */
793: into isc_dr_costs_f
794: ( repair_line_id
795: , material_cost_g
796: , labor_cost_g

Line 793: into isc_dr_costs_f

789: commit;
790:
791: l_stmnt_id := 100;
792: insert /*+ append parallel(isc_dr_costs_f) */
793: into isc_dr_costs_f
794: ( repair_line_id
795: , material_cost_g
796: , labor_cost_g
797: , expense_cost_g

Line 837: bis_collection_utilities.log( 'Inserted ' || l_rowcount || ' rows into ISC_DR_COSTS_F' , 1 );

833: and stg.date_closed = rates.date_closed
834: group by stg.repair_line_id;
835:
836: l_rowcount := sql%rowcount;
837: bis_collection_utilities.log( 'Inserted ' || l_rowcount || ' rows into ISC_DR_COSTS_F' , 1 );
838:
839: l_stmnt_id := 110;
840: commit;
841:

Line 858: ( 'ISC_DR_COSTS_F'

854: , program_application_id
855: , request_id
856: )
857: values
858: ( 'ISC_DR_COSTS_F'
859: , l_ro_last_run_date
860: , g_user_id
861: , sysdate
862: , sysdate

Line 1253: ( p_fact_name => 'ISC_DR_COSTS_F'

1249: bis_collection_utilities.log( 'Repair Order From Date: ' || fnd_date.date_to_displaydt(l_ro_last_run_date), 1 );
1250:
1251: l_stmnt_id := 50;
1252: if isc_depot_backlog_etl_pkg.get_last_run_date
1253: ( p_fact_name => 'ISC_DR_COSTS_F'
1254: , x_run_date => l_costs_last_run_date
1255: , x_message => l_message
1256: ) <> c_ok then
1257: raise l_exception;

Line 1286: isc_dr_costs_f fact

1282: end if;
1283:
1284: l_stmnt_id := 80;
1285: merge into
1286: isc_dr_costs_f fact
1287: using
1288: ( select
1289: stg.repair_line_id repair_line_id
1290: , nvl(sum( stg.material_cost_b * rates.g_conv_rate ), 0) material_cost_g

Line 1367: bis_collection_utilities.log( 'Merged ' || l_rowcount || ' rows into ISC_DR_COSTS_F' , 1 );

1363: , costs.request_id
1364: );
1365:
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

Line 1379: where fact_name = 'ISC_DR_COSTS_F';

1375: , program_id = g_program_id
1376: , program_login_id = g_program_login_id
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;