APPS.BIL_BI_PURGE_OBJ_PKG dependencies on BIL_BI_PROCESSED_FST_ID

Line 87: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PROCESSED_FST_ID');

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');
89:
90: -- Delete references from BIS_REFRESH_LOG table
91: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || p_obj_name );

Line 122: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PROCESSED_FST_ID');

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:
124: -- Delete references from BIS_REFRESH_LOG table
125: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || 'FST_DTL_F');
126:

Line 725: DELETE FROM bil_bi_processed_fst_id

721: END;
722:
723: g_row_num := SQL%ROWCOUNT;
724:
725: DELETE FROM bil_bi_processed_fst_id
726: WHERE forecast_id in ( SELECT intrnl.forecast_id f
727: FROM as_internal_forecasts intrnl,
728: gl_periods gl
729: WHERE gl.period_name = intrnl.period_name