APPS.ISC_FS_TASK_ACT_BAC_ETL_PKG dependencies on FND_DATE

Line 138: l_refresh_date := fnd_date.displaydt_to_date

134: l_refresh_date date;
135:
136: begin
137:
138: l_refresh_date := fnd_date.displaydt_to_date
139: ( bis_collection_utilities.get_last_refresh_period
140: ( nvl(p_object_name,g_object_name) )
141: );
142: if l_refresh_date = g_global_start_date then

Line 212: bis_collection_utilities_log( 'From ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );

208: logger( l_proc_name, l_stmt_id, l_error_message );
209: raise l_exception;
210: end if;
211:
212: bis_collection_utilities_log( 'From ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
213: bis_collection_utilities_log( 'To ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
214:
215: -- get the isc schema name
216: l_stmt_id := 30;

Line 213: bis_collection_utilities_log( 'To ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );

209: raise l_exception;
210: end if;
211:
212: bis_collection_utilities_log( 'From ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
213: bis_collection_utilities_log( 'To ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
214:
215: -- get the isc schema name
216: l_stmt_id := 30;
217: if get_schema_name

Line 744: bis_collection_utilities_log( 'From: ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );

740: logger( l_proc_name, l_stmt_id, l_error_message );
741: raise l_exception;
742: end if;
743:
744: bis_collection_utilities_log( 'From: ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
745: bis_collection_utilities_log( 'To: ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
746:
747: if l_collect_from_date >= l_collect_to_date then
748:

Line 745: bis_collection_utilities_log( 'To: ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );

741: raise l_exception;
742: end if;
743:
744: bis_collection_utilities_log( 'From: ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
745: bis_collection_utilities_log( 'To: ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
746:
747: if l_collect_from_date >= l_collect_to_date then
748:
749: bis_collection_utilities_log( 'Nothing to process', 2 );