APPS.BIL_BI_PURGE_OBJ_PKG dependencies on BIL_BI_FST_DTL_F

Line 84: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_F');

80:
81: WHEN 'FST_DTL_F' THEN
82:
83: -- Truncate Forecast Summary Objects
84: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_F');
85: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_STG');
86: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_NEW_FST_ID');
87: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PROCESSED_FST_ID');
88: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');

Line 119: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_F');

115: -- Delete references from BIS_REFRESH_LOG table
116: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || 'OPDTL_F');
117:
118: -- Truncate Forecast Summary Objects
119: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_F');
120: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_STG');
121: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_NEW_FST_ID');
122: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PROCESSED_FST_ID');
123:

Line 611: DELETE bil_bi_fst_dtl_f sumry

607: FROM fii_time_ent_year
608: WHERE start_date <= g_end_date
609: AND end_date >= g_end_date;
610:
611: DELETE bil_bi_fst_dtl_f sumry
612: WHERE forecast_time_id <= l_end_dt_ent_year_id
613: AND forecast_period_type_id = 128;
614:
615: WHEN 'FII_TIME_ENT_QTR' THEN

Line 622: DELETE bil_bi_fst_dtl_f sumry

618: FROM fii_time_ent_qtr
619: WHERE start_date <= g_end_date
620: AND end_date >= g_end_date;
621:
622: DELETE bil_bi_fst_dtl_f sumry
623: WHERE forecast_time_id <= l_end_dt_ent_qtr_id
624: AND forecast_period_type_id = 64;
625:
626: WHEN 'FII_TIME_ENT_PERIOD' THEN

Line 634: DELETE bil_bi_fst_dtl_f sumry

630: FROM fii_time_ent_period
631: WHERE start_date <= g_end_date
632: AND end_date >= g_end_date;
633:
634: DELETE bil_bi_fst_dtl_f sumry
635: WHERE forecast_time_id <= l_end_dt_ent_per_id
636: AND forecast_period_type_id = 32;
637:
638: WHEN 'FII_TIME_WEEK' THEN

Line 645: DELETE bil_bi_fst_dtl_f sumry

641: FROM fii_time_week
642: WHERE start_date <= g_end_date
643: AND end_date >= g_end_date;
644:
645: DELETE bil_bi_fst_dtl_f sumry
646: WHERE forecast_time_id <= l_end_dt_week_id
647: AND forecast_period_type_id = 16;
648: ELSE
649: NULL;

Line 690: DELETE bil_bi_fst_dtl_f sumry

686: END IF;
687:
688: -- Delete records from Summary Table where Forecast Dt less than
689: -- input End Date
690: DELETE bil_bi_fst_dtl_f sumry
691: WHERE ((forecast_time_id <= l_end_dt_week_id
692: AND forecast_period_type_id = 16)
693: OR (forecast_time_id <= l_end_dt_ent_per_id
694: AND forecast_period_type_id = 32)

Line 742: bil_bi_util_collection_pkg.analyze_table(p_tbl_name => 'BIL_BI_FST_DTL_F',

738: END IF;
739: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');
740: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_STG');
741: -- Analyze the Tables
742: bil_bi_util_collection_pkg.analyze_table(p_tbl_name => 'BIL_BI_FST_DTL_F',
743: p_cascade => TRUE,
744: p_est_pct => 10 ,
745: p_granularity => 'GLOBAL');
746: bil_bi_util_collection_pkg.analyze_table(p_tbl_name => 'BIL_BI_FST_DTL_STG',