APPS.ISC_MAINT_REQ_WO_ETL_PKG dependencies on FND_DATE

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

116: l_refresh_date date;
117:
118: begin
119:
120: l_refresh_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period(g_object_name));
121: if l_refresh_date = g_global_start_date then
122: x_error_message := 'Incremental Load can only be run after a completed initial or incremental load';
123: return -1;
124: end if;

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

179:
180: l_collect_from_date := g_global_start_date;
181: l_collect_to_date := sysdate;
182:
183: bis_collection_utilities.log( 'From ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
184: bis_collection_utilities.log( 'To ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
185:
186: -- get the isc schema name
187: l_stmt_id := 20;

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

180: l_collect_from_date := g_global_start_date;
181: l_collect_to_date := sysdate;
182:
183: bis_collection_utilities.log( 'From ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
184: bis_collection_utilities.log( 'To ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
185:
186: -- get the isc schema name
187: l_stmt_id := 20;
188: if get_schema_name

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

495: end if;
496: l_collect_from_date := l_collect_to_date + 1/86400;
497: l_collect_to_date := sysdate;
498:
499: bis_collection_utilities.log( 'From: ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
500: bis_collection_utilities.log( 'To: ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
501:
502: -- get the isc schema name
503: l_stmt_id := 20;

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

496: l_collect_from_date := l_collect_to_date + 1/86400;
497: l_collect_to_date := sysdate;
498:
499: bis_collection_utilities.log( 'From: ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
500: bis_collection_utilities.log( 'To: ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
501:
502: -- get the isc schema name
503: l_stmt_id := 20;
504: if get_schema_name