DBA Data[Home] [Help]

APPS.BSC_UPDATE_DIM dependencies on BSC_UPDATE_BASE_V2

Line 791: h_proj_tbl_name := BSC_UPDATE_BASE_V2.Get_Base_Proj_Tbl_Name(h_system_table);

787: BEGIN BSC_UPDATE_UTIL.Execute_Immediate(h_sql); EXCEPTION WHEN OTHERS THEN NULL; END;
788:
789: -- ENH_B_TABLES_PERF: with the new strategy the B table may have a projection table.
790: -- We need to delete rows from the projection table too.
791: h_proj_tbl_name := BSC_UPDATE_BASE_V2.Get_Base_Proj_Tbl_Name(h_system_table);
792: IF h_proj_tbl_name IS NOT NULL THEN
793: h_sql := 'DELETE FROM '||h_proj_tbl_name||
794: ' WHERE '||h_condition;
795: --Fix bug#5060236 B table may not exists, GDB may have fail in the middle

Line 868: h_proj_tbl_name := BSC_UPDATE_BASE_V2.Get_Base_Proj_Tbl_Name(h_table_name);

864: BEGIN BSC_UPDATE_UTIL.Execute_Immediate(h_sql); EXCEPTION WHEN OTHERS THEN NULL; END;
865:
866: -- ENH_B_TABLES_PERF: with the new strategy the B table may have a projection table.
867: -- We need to delete rows from the projection table too
868: h_proj_tbl_name := BSC_UPDATE_BASE_V2.Get_Base_Proj_Tbl_Name(h_table_name);
869: IF h_proj_tbl_name IS NOT NULL THEN
870: h_sql := 'DELETE FROM '||h_proj_tbl_name||
871: ' WHERE '||x_condition;
872: --Fix bug#5060236 B table may not exists, GDB may have fail in the middle