DBA Data[Home] [Help]

APPS.ISC_DEPOT_MARGIN_ETL_PKG dependencies on FND_DATE

Line 485: bis_collection_utilities.log( 'Global Start Date: ' || fnd_date.date_to_displaydt(g_global_start_date), 1 );

481: ) <> c_ok then
482: raise l_exception;
483: end if;
484:
485: bis_collection_utilities.log( 'Global Start Date: ' || fnd_date.date_to_displaydt(g_global_start_date), 1 );
486: bis_collection_utilities.log( 'Primary Global Currency: ' || g_global_curr_code, 1 );
487: bis_collection_utilities.log( 'Primary Global Currency Rate Type: ' || g_global_rate_type, 1 );
488: bis_collection_utilities.log( 'Secondary Global Currency: ' || g_global_sec_curr_code, 1 );
489: bis_collection_utilities.log( 'Secondary Global Currency Rate Type: ' || g_global_sec_rate_type, 1 );

Line 517: bis_collection_utilities.log( 'Repair Order To Date: ' || fnd_date.date_to_displaydt(l_ro_last_run_date), 1 );

513: l_message := 'Please launch the Intial Load Request Set for the Depot Repair Management page.';
514: raise l_exception;
515: end if;
516:
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) */

Line 727: bis_collection_utilities.log( 'Global Start Date: ' || fnd_date.date_to_displaydt(g_global_start_date), 1 );

723: ) <> c_ok then
724: raise l_exception;
725: end if;
726:
727: bis_collection_utilities.log( 'Global Start Date: ' || fnd_date.date_to_displaydt(g_global_start_date), 1 );
728: bis_collection_utilities.log( 'Primary Global Currency: ' || g_global_curr_code, 1 );
729: bis_collection_utilities.log( 'Primary Global Currency Rate Type: ' || g_global_rate_type, 1 );
730: bis_collection_utilities.log( 'Secondary Global Currency: ' || g_global_sec_curr_code, 1 );
731: bis_collection_utilities.log( 'Secondary Global Currency Rate Type: ' || g_global_sec_rate_type, 1 );

Line 769: bis_collection_utilities.log( 'Repair Order To Date: ' || fnd_date.date_to_displaydt(l_ro_last_run_date), 1 );

765: l_message := 'Please launch the Intial Load Request Set for the Depot Repair Management page.';
766: raise l_exception;
767: end if;
768:
769: bis_collection_utilities.log( 'Repair Order To Date: ' || fnd_date.date_to_displaydt(l_ro_last_run_date), 1 );
770: l_to_date := sysdate;
771:
772: l_stmnt_id := 70;
773: if load_costs_staging

Line 954: bis_collection_utilities.log( 'Global Start Date: ' || fnd_date.date_to_displaydt(g_global_start_date), 1 );

950: ) <> c_ok then
951: raise l_exception;
952: end if;
953:
954: bis_collection_utilities.log( 'Global Start Date: ' || fnd_date.date_to_displaydt(g_global_start_date), 1 );
955: bis_collection_utilities.log( 'Primary Global Currency: ' || g_global_curr_code, 1 );
956: bis_collection_utilities.log( 'Primary Global Currency Rate Type: ' || g_global_rate_type, 1 );
957: bis_collection_utilities.log( 'Secondary Global Currency: ' || g_global_sec_curr_code, 1 );
958: bis_collection_utilities.log( 'Secondary Global Currency Rate Type: ' || g_global_sec_rate_type, 1 );

Line 974: bis_collection_utilities.log( 'Repair Order From Date: ' || fnd_date.date_to_displaydt(l_ro_last_run_date), 1 );

970: l_message := 'Please run the Intial Load Request Set for the Depot Repair Management page.';
971: raise l_exception;
972: end if;
973:
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'

Line 990: bis_collection_utilities.log( 'Charges From Date: ' || fnd_date.date_to_displaydt(l_charges_last_run_date), 1 );

986: l_message := 'Please run the Intial Load Request Set for the Depot Repair Management page.';
987: raise l_exception;
988: end if;
989:
990: bis_collection_utilities.log( 'Charges From Date: ' || fnd_date.date_to_displaydt(l_charges_last_run_date), 1 );
991:
992: l_to_date := sysdate;
993:
994: l_stmnt_id := 40;

Line 1219: bis_collection_utilities.log( 'Global Start Date: ' || fnd_date.date_to_displaydt(g_global_start_date), 1 );

1215: ) <> c_ok then
1216: raise l_exception;
1217: end if;
1218:
1219: bis_collection_utilities.log( 'Global Start Date: ' || fnd_date.date_to_displaydt(g_global_start_date), 1 );
1220: bis_collection_utilities.log( 'Primary Global Currency: ' || g_global_curr_code, 1 );
1221: bis_collection_utilities.log( 'Primary Global Currency Rate Type: ' || g_global_rate_type, 1 );
1222: bis_collection_utilities.log( 'Secondary Global Currency: ' || g_global_sec_curr_code, 1 );
1223: bis_collection_utilities.log( 'Secondary Global Currency Rate Type: ' || g_global_sec_rate_type, 1 );

Line 1249: bis_collection_utilities.log( 'Repair Order From Date: ' || fnd_date.date_to_displaydt(l_ro_last_run_date), 1 );

1245: l_message := 'Please run the Intial Load Request Set for the Depot Repair Management page.';
1246: raise l_exception;
1247: end if;
1248:
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'

Line 1265: bis_collection_utilities.log( 'Cost From Date: ' || fnd_date.date_to_displaydt(l_costs_last_run_date), 1 );

1261: l_message := 'Please run the Intial Load Request Set for the Depot Repair Management page.';
1262: raise l_exception;
1263: end if;
1264:
1265: bis_collection_utilities.log( 'Cost From Date: ' || fnd_date.date_to_displaydt(l_costs_last_run_date), 1 );
1266: l_to_date := sysdate;
1267:
1268: l_stmnt_id := 60;
1269: if load_costs_staging