APPS.HRI_APL_MV_REFRESH dependencies on HRI_UTL_DDL

Line 42: hri_utl_ddl.log_and_drop_indexes

38: IF l_mode = 'BEFORE' THEN
39:
40: -- Log and drop indexes before MV refresh
41: bis_bia_rsg_custom_api_mgmnt.log('Before dropping indexes');
42: hri_utl_ddl.log_and_drop_indexes
43: (p_application_short_name => l_schema_name,
44: p_table_name => l_object_name,
45: p_table_owner => l_schema_name,
46: p_index_excptn_lst => null);

Line 53: hri_utl_ddl.recreate_indexes

49: ELSIF (l_mode = 'AFTER') THEN
50:
51: -- Recreate indexes after MV refresh
52: bis_bia_rsg_custom_api_mgmnt.log('Before recreating indexes');
53: hri_utl_ddl.recreate_indexes
54: (p_application_short_name => l_schema_name,
55: p_table_name => l_object_name,
56: p_table_owner => l_schema_name);
57: bis_bia_rsg_custom_api_mgmnt.log('Recreated indexes');