APPS.BIL_BI_PURGE_OBJ_PKG dependencies on BIL_BI_PIPELINE_STG

Line 99: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_STG');

95:
96: WHEN 'PIPELINE_F' THEN
97: -- Truncate Pipeline Summary Objects
98: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_F');
99: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_STG');
100: -- asolaiy added for 8.0.
101: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPEC_F');
102: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_DENLOG_TMP');
103: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_DENLOG_STG');

Line 129: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_STG');

125: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || 'FST_DTL_F');
126:
127: -- Truncate Pipeline Summary Objects
128: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_F');
129: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_STG');
130: -- asolaiy added for 8.0.
131: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPEC_F');
132: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_DENLOG_TMP');
133: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_DENLOG_STG');

Line 428: FROM bil_bi_pipeline_stg;

424:
425: -- Delete records from Staging Table where Snap Dt less than End Date
426: SELECT COUNT(1)
427: INTO l_cnt
428: FROM bil_bi_pipeline_stg;
429:
430: IF l_cnt > 0 THEN
431: DELETE FROM bil_bi_pipeline_stg
432: WHERE snap_date <= g_end_date;

Line 431: DELETE FROM bil_bi_pipeline_stg

427: INTO l_cnt
428: FROM bil_bi_pipeline_stg;
429:
430: IF l_cnt > 0 THEN
431: DELETE FROM bil_bi_pipeline_stg
432: WHERE snap_date <= g_end_date;
433: END IF;
434:
435: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN