DBA Data[Home] [Help]

APPS.ISC_DEPOT_MTTR_ETL_PKG dependencies on FND_DATE

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

61: ) <> c_ok then
62: raise l_exception;
63: end if;
64:
65: bis_collection_utilities.log( 'Global Start Date: ' || fnd_date.date_to_displaydt(g_global_start_date), 1 );
66:
67: l_stmt_id := 20;
68: delete
69: from isc_dr_inc

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

89: l_message := 'Please launch the Intial Load Request Set for the Depot Repair Management page.';
90: raise l_exception;
91: end if;
92:
93: bis_collection_utilities.log( 'Repair Order To Date: ' || fnd_date.date_to_displaydt(l_run_date), 1 );
94:
95: l_to_date := sysdate;
96:
97: l_stmt_id := 50;

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

435: ) <> c_ok then
436: raise l_exception;
437: end if;
438:
439: bis_collection_utilities.log( 'Global Start Date: ' || fnd_date.date_to_displaydt(g_global_start_date), 1 );
440:
441: l_stmt_id := 20;
442: if isc_depot_backlog_etl_pkg.get_last_run_date
443: ( p_fact_name => 'ISC_DR_MTTR_F'

Line 455: bis_collection_utilities.log( 'MTTR From Date: ' || fnd_date.date_to_displaydt(l_run_date), 1 );

451: l_message := 'Please run the Intial Load Request Set for the Depot Repair Management page.';
452: raise l_exception;
453: end if;
454:
455: bis_collection_utilities.log( 'MTTR From Date: ' || fnd_date.date_to_displaydt(l_run_date), 1 );
456:
457: l_stmt_id := 30;
458: if isc_depot_backlog_etl_pkg.get_last_run_date
459: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'

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

467: l_message := 'Please run the Intial Load Request Set for the Depot Repair Management page.';
468: raise l_exception;
469: end if;
470:
471: bis_collection_utilities.log( 'Repair Order From Date: ' || fnd_date.date_to_displaydt(l_last_run_date), 1 );
472:
473: l_to_date := sysdate;
474:
475: l_stmt_id := 40;