APPS.BIL_BI_PURGE_OBJ_PKG dependencies on BIL_BI_OPDTL_STG

Line 75: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_STG');

71: CASE p_obj_name
72: WHEN 'OPDTL_F' THEN
73: -- Truncate Opportunity Detail Summary Objects
74: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_F');
75: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_STG');
76: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');
77:
78: -- Delete references from BIS_REFRESH_LOG table
79: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || p_obj_name );

Line 114: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_STG');

110: WHEN 'ALL' THEN
111:
112: -- Truncate Opportunity Detail Summary Objects
113: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_F');
114: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_STG');
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

Line 319: FROM bil_bi_opdtl_stg;

315: -- Delete records from Staging Table where Eff Dt/Cre Dt/Cnv Dt less than End Date
316:
317: SELECT COUNT(1)
318: INTO l_cnt
319: FROM bil_bi_opdtl_stg;
320:
321: IF l_cnt > 0 THEN
322: DELETE FROM bil_bi_opdtl_stg
323: WHERE opty_creation_date <= g_end_date

Line 322: DELETE FROM bil_bi_opdtl_stg

318: INTO l_cnt
319: FROM bil_bi_opdtl_stg;
320:
321: IF l_cnt > 0 THEN
322: DELETE FROM bil_bi_opdtl_stg
323: WHERE opty_creation_date <= g_end_date
324: AND effective_date <= g_end_date
325: AND (opty_ld_conversion_date <= g_end_date
326: OR opty_ld_conversion_date IS NULL)