APPS.BIL_BI_PURGE_OBJ_PKG dependencies on BIL_BI_OPDTL_F

Line 74: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_F');

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

Line 113: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_F');

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

Line 339: DELETE FROM bil_bi_opdtl_f

335:
336:
337: -- Delete records from Sumry Table where Eff Dt/Cre Dt/Cnv Dt less than End Date
338:
339: DELETE FROM bil_bi_opdtl_f
340: WHERE opty_creation_time_id <= g_end_date_timeid
341: AND opty_close_time_id <= g_end_date_timeid
342: AND (opty_ld_conversion_time_id <= g_end_date_timeid
343: OR opty_ld_conversion_time_id IS NULL)

Line 357: bil_bi_util_collection_pkg.analyze_table(p_tbl_name => 'BIL_BI_OPDTL_F',

353:
354: COMMIT;
355:
356: -- Analyze the Tables
357: bil_bi_util_collection_pkg.analyze_table(p_tbl_name => 'BIL_BI_OPDTL_F',
358: p_cascade => TRUE,
359: p_est_pct => 10 ,
360: p_granularity => 'GLOBAL');
361: g_status := TRUE;