APPS.BIL_BI_OPDTL_F_PKG dependencies on FND_DATE

Line 115: l_date_disp := fnd_date.date_to_displaydt (l_date);

111: IF (l_date IS NULL) THEN
112: l_date:= to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'), 'mm/dd/yyyy');
113: END IF;
114:
115: l_date_disp := fnd_date.date_to_displaydt (l_date);
116: return l_date_disp;
117:
118: Exception
119: WHEN OTHERS THEN

Line 152: l_date_disp := fnd_date.date_to_displaydt (l_date);

148:
149: IF (l_date IS NULL) THEN
150: l_date:= to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'), 'mm/dd/yyyy');
151: END IF;
152: l_date_disp := fnd_date.date_to_displaydt (l_date);
153: return l_date_disp;
154:
155: Exception
156: WHEN OTHERS THEN

Line 283: to_char(fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F'))

279: p_module => g_pkg || l_proc || ' begin',
280: p_msg => 'Start of Procedure '|| l_proc);
281: END IF;
282: l_start_date :=
283: to_char(fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F'))
284: ,'YYYY/MM/DD HH24:MI:SS');
285:
286: -- Find the last collection time and use it as the start date for
287: -- this time period.

Line 424: l_failure_date := fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_failure_period('BIL_BI_OPDTL_F'));

420: Init(p_object_name => 'BIL_BI_OPDTL_F');
421:
422: /*ctoba ER 4160374 - uptake of BIS API */
423:
424: l_failure_date := fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_failure_period('BIL_BI_OPDTL_F'));
425:
426:
427:
428:

Line 551: fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F'));

547: END IF;
548: END IF;
549: ELSE
550: G_Start_date :=
551: fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F'));
552: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
553: bil_bi_util_collection_pkg.writeLog(
554: p_log_level => fnd_log.LEVEL_EVENT,
555: p_module => g_pkg || l_proc ,

Line 589: l_max_date := fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F'));

585: SELECT COUNT(1) into l_fact_count FROM BIL_BI_OPDTL_F where rownum < 2;
586:
587: /* resume should called wrap up which should have set last_refresh_period */
588:
589: l_max_date := fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F'));
590: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
591: bil_bi_util_collection_pkg.writeLog(
592: p_log_level => fnd_log.LEVEL_EVENT,
593: p_module => g_pkg || l_proc ,

Line 1359: l_start_date := fnd_date.displaydt_to_date(get_first_success_period('BIL_BI_OPDTL_F'));

1355: p_module => g_pkg || l_proc || ' begin',
1356: p_msg => 'Start of Procedure '|| l_proc);
1357: END IF;
1358:
1359: l_start_date := fnd_date.displaydt_to_date(get_first_success_period('BIL_BI_OPDTL_F'));
1360:
1361: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1362: bil_bi_util_collection_pkg.writeLog(
1363: p_log_level => fnd_log.LEVEL_EVENT,