APPS.ISC_FS_TASK_ETL_PKG dependencies on FND_DATE

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

157: l_refresh_date date;
158:
159: begin
160:
161: l_refresh_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period(g_object_name));
162: if l_refresh_date = g_global_start_date then
163: x_error_message := 'Incremental Load can only be run after a completed initial or incremental load';
164: return -1;
165: end if;

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

283:
284: l_collect_from_date := g_global_start_date;
285: l_collect_to_date := sysdate;
286:
287: bis_collection_utilities_log( 'From ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
288: bis_collection_utilities_log( 'To ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
289:
290: -- check MTTR/FTFR district rule
291: l_stmt_id := 20;

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

284: l_collect_from_date := g_global_start_date;
285: l_collect_to_date := sysdate;
286:
287: bis_collection_utilities_log( 'From ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
288: bis_collection_utilities_log( 'To ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
289:
290: -- check MTTR/FTFR district rule
291: l_stmt_id := 20;
292: if check_district_rule

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

1445: end if;
1446: l_collect_from_date := l_collect_to_date + 1/86400;
1447: l_collect_to_date := sysdate;
1448:
1449: bis_collection_utilities_log( 'From: ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
1450: bis_collection_utilities_log( 'To: ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
1451:
1452: -- check MTTR/FTFR district rule
1453: l_stmt_id := 20;

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

1446: l_collect_from_date := l_collect_to_date + 1/86400;
1447: l_collect_to_date := sysdate;
1448:
1449: bis_collection_utilities_log( 'From: ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
1450: bis_collection_utilities_log( 'To: ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
1451:
1452: -- check MTTR/FTFR district rule
1453: l_stmt_id := 20;
1454: if check_district_rule