DBA Data[Home] [Help]

APPS.ISC_MAINT_ASSET_DT_ETL_PKG dependencies on FND_DATE

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

90: , x_error_message out nocopy varchar2 )
91: return number as
92: l_refresh_date date;
93: begin
94: l_refresh_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period(g_object_name));
95: if l_refresh_date = g_global_start_date then
96: x_error_message := 'Incremental Load can only be run after a completed initial or incremental load';
97: x_error_message := x_error_message || ' Refresh Date is '|| l_refresh_date;
98: x_error_message := x_error_message || ' global start date is '|| g_global_start_date ;

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

751: l_rowcount := sql%rowcount;
752: commit;
753:
754:
755: bis_collection_utilities.log( 'From: ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
756: bis_collection_utilities.log( 'To: ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
757: bis_collection_utilities.log( l_rowcount || ' rows merged into base summary', 1 );
758:
759: l_stmt_id := 40;

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

752: commit;
753:
754:
755: bis_collection_utilities.log( 'From: ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
756: bis_collection_utilities.log( 'To: ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
757: bis_collection_utilities.log( l_rowcount || ' rows merged into base summary', 1 );
758:
759: l_stmt_id := 40;
760: