APPS.ISC_MAINT_WO_CST_ETL_PKG dependencies on FND_DATE

Line 396: l_refresh_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period(g_object_name));

392: l_refresh_date date;
393:
394: begin
395:
396: l_refresh_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period(g_object_name));
397: if l_refresh_date = g_global_start_date then
398: x_error_message := 'Incremental Load can only be run after a completed initial or incremental load';
399: return -1;
400: end if;

Line 463: bis_collection_utilities.log( 'From ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );

459:
460: l_collect_from_date := g_global_start_date;
461: l_collect_to_date := sysdate;
462:
463: bis_collection_utilities.log( 'From ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
464: bis_collection_utilities.log( 'To ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
465:
466: -- get the isc schema name
467: l_stmt_id := 20;

Line 464: bis_collection_utilities.log( 'To ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );

460: l_collect_from_date := g_global_start_date;
461: l_collect_to_date := sysdate;
462:
463: bis_collection_utilities.log( 'From ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
464: bis_collection_utilities.log( 'To ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
465:
466: -- get the isc schema name
467: l_stmt_id := 20;
468: if get_schema_name

Line 767: bis_collection_utilities.log( 'From: ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );

763: end if;
764: l_collect_from_date := l_collect_to_date + 1/86400;
765: l_collect_to_date := sysdate;
766:
767: bis_collection_utilities.log( 'From: ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
768: bis_collection_utilities.log( 'To: ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
769:
770: -- get the isc schema name
771: l_stmt_id := 20;

Line 768: bis_collection_utilities.log( 'To: ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );

764: l_collect_from_date := l_collect_to_date + 1/86400;
765: l_collect_to_date := sysdate;
766:
767: bis_collection_utilities.log( 'From: ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
768: bis_collection_utilities.log( 'To: ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
769:
770: -- get the isc schema name
771: l_stmt_id := 20;
772: if get_schema_name