APPS.ISC_DEPOT_MARGIN_ETL_PKG dependencies on ISC_DR_CHARGES_F

Line 19: g_charges_object_name constant varchar2(30) := 'ISC_DR_CHARGES_F';

15: g_program_login_id number;
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:

Line 494: where fact_name = 'ISC_DR_CHARGES_F';

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

Line 499: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.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:
501: bis_collection_utilities.log( 'Truncated table ISC_DR_CHARGES_F', 1 );
502:
503: l_stmnt_id := 40;

Line 501: bis_collection_utilities.log( 'Truncated table ISC_DR_CHARGES_F', 1 );

497:
498: l_stmnt_id := 30;
499: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_CHARGES_F';
500:
501: bis_collection_utilities.log( 'Truncated table ISC_DR_CHARGES_F', 1 );
502:
503: l_stmnt_id := 40;
504: if isc_depot_backlog_etl_pkg.get_last_run_date
505: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'

Line 521: insert /*+ append parallel(isc_dr_charges_f) */

517: bis_collection_utilities.log( 'Repair Order To Date: ' || fnd_date.date_to_displaydt(l_ro_last_run_date), 1 );
518: l_to_date := sysdate;
519:
520: l_stmnt_id := 50;
521: insert /*+ append parallel(isc_dr_charges_f) */
522: into isc_dr_charges_f
523: ( repair_line_id
524: , material_charges_g
525: , labor_charges_g

Line 522: into isc_dr_charges_f

518: l_to_date := sysdate;
519:
520: l_stmnt_id := 50;
521: insert /*+ append parallel(isc_dr_charges_f) */
522: into isc_dr_charges_f
523: ( repair_line_id
524: , material_charges_g
525: , labor_charges_g
526: , expense_charges_g

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

605: and rof.ro_creation_date >= g_global_start_date
606: group by rof.repair_line_id;
607:
608: l_rowcount := sql%rowcount;
609: bis_collection_utilities.log( 'Inserted ' || l_rowcount || ' rows into ISC_DR_CHARGES_F' , 1 );
610:
611: l_stmnt_id := 60;
612: commit;
613:

Line 629: ( 'ISC_DR_CHARGES_F'

625: , program_application_id
626: , request_id
627: )
628: values
629: ( 'ISC_DR_CHARGES_F'
630: , l_ro_last_run_date
631: , g_user_id
632: , sysdate
633: , sysdate

Line 978: ( p_fact_name => 'ISC_DR_CHARGES_F'

974: bis_collection_utilities.log( 'Repair Order From Date: ' || fnd_date.date_to_displaydt(l_ro_last_run_date), 1 );
975:
976: l_stmnt_id := 30;
977: if isc_depot_backlog_etl_pkg.get_last_run_date
978: ( p_fact_name => 'ISC_DR_CHARGES_F'
979: , x_run_date => l_charges_last_run_date
980: , x_message => l_message
981: ) <> c_ok then
982: raise l_exception;

Line 995: merge into isc_dr_charges_f fact

991:
992: l_to_date := sysdate;
993:
994: l_stmnt_id := 40;
995: merge into isc_dr_charges_f fact
996: using
997: ( select rof.repair_line_id repair_line_id
998: , sum( case
999: when cbtc.billing_category = 'M' then

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

1115: , charges.request_id
1116: );
1117:
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

Line 1132: where fact_name = 'ISC_DR_CHARGES_F';

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