APPS.BIL_BI_PIPELINE_F_PKG dependencies on FND_DATE

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

770: p_msg => 'Start of Procedure '|| l_proc);
771: END IF;
772:
773: l_last_fact_run :=
774: trunc(fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F')));
775:
776:
777: SELECT end_date+1
778: INTO l_curr_collect_start

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

901: IF (l_date IS NULL) THEN
902: l_date:= to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'), 'mm/dd/yyyy');
903: END IF;
904:
905: l_date_disp := fnd_date.date_to_displaydt (l_date);
906:
907: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
908: bil_bi_util_collection_pkg.writeLog(
909: p_log_level => fnd_log.LEVEL_PROCEDURE,

Line 1337: l_first_fact_run := fnd_date.displaydt_to_date(get_first_success_period('BIL_BI_OPDTL_F'));

1333:
1334: l_curr_coll_start := get_start_curr_coll;
1335:
1336:
1337: l_first_fact_run := fnd_date.displaydt_to_date(get_first_success_period('BIL_BI_OPDTL_F'));
1338:
1339:
1340: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1341: bil_bi_util_collection_pkg.writeLog

Line 1681: trunc(fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_PIPEC_F')));

1677:
1678: -- resume during gap fill is handled by reading l_last_run after resume
1679:
1680: l_last_run :=
1681: trunc(fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_PIPEC_F')));
1682: l_last_fact_run :=
1683: trunc(fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F')));
1684:
1685: l_date := l_last_fact_run; -- fact could be run on previous day or the same day

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

1679:
1680: l_last_run :=
1681: trunc(fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_PIPEC_F')));
1682: l_last_fact_run :=
1683: trunc(fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F')));
1684:
1685: l_date := l_last_fact_run; -- fact could be run on previous day or the same day
1686:
1687: