APPS.BIL_BI_PIPELINE_F_PKG dependencies on BIL_BI_OPDTL_F

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 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 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:

Line 2540: bil_bi_opdtl_f fact,

2536: null prvyr_open_amt_qtr_s,
2537: null prvyr_open_amt_yr_s
2538:
2539: FROM
2540: bil_bi_opdtl_f fact,
2541: fii_time_day time
2542: WHERE
2543: fact.OPTY_CLOSE_TIME_ID = time.report_date_julian
2544: and forecast_rollup_flag = 'Y'

Line 2709: p_msg => 'Inserted '|| g_row_num ||' into BIL_BI_PIPEC_F table from BIL_BI_OPDTL_F for date'

2705: bil_bi_util_collection_pkg.writeLog
2706: (
2707: p_log_level => fnd_log.LEVEL_EVENT,
2708: p_module => g_pkg || l_proc ,
2709: p_msg => 'Inserted '|| g_row_num ||' into BIL_BI_PIPEC_F table from BIL_BI_OPDTL_F for date'
2710: || l_date
2711: );
2712: END IF;
2713: