APPS.HRI_OPL_SUP_STATUS_HST dependencies on HRI_UTL_DDL

Line 114: hri_utl_ddl.log_and_drop_indexes

110: run_sql_stmt_noerr('ALTER TRIGGER ' || p_object_name || '_WHO DISABLE');
111: --
112: -- Disable all the indexes on the table
113: --
114: hri_utl_ddl.log_and_drop_indexes
115: (p_application_short_name => 'HRI'
116: ,p_table_name => p_object_name
117: ,p_table_owner => p_schema
118: );

Line 139: hri_utl_ddl.recreate_indexes

135: run_sql_stmt_noerr('ALTER TRIGGER ' || p_object_name || '_WHO ENABLE');
136: --
137: -- Recreate indexes
138: --
139: hri_utl_ddl.recreate_indexes
140: (p_application_short_name => 'HRI'
141: ,p_table_name => p_object_name
142: ,p_table_owner => p_schema
143: );

Line 1362: hri_utl_ddl.log_and_drop_indexes

1358: -- Disable/drop objects (indexes and triggers)
1359: --
1360: run_sql_stmt_noerr('ALTER TRIGGER HRI_CL_WKR_SUP_STATUS_ASG_WHO DISABLE');
1361: --
1362: hri_utl_ddl.log_and_drop_indexes
1363: (p_application_short_name => 'HRI'
1364: ,p_table_name => 'HRI_CL_WKR_SUP_STATUS_ASG_CT'
1365: ,p_table_owner => l_schema);
1366: --

Line 1386: hri_utl_ddl.recreate_indexes

1382: -- Re-enable/recreate objects
1383: --
1384: run_sql_stmt_noerr('ALTER TRIGGER HRI_CL_WKR_SUP_STATUS_ASG_WHO ENABLE');
1385: --
1386: hri_utl_ddl.recreate_indexes
1387: (p_application_short_name => 'HRI'
1388: ,p_table_name => 'HRI_CL_WKR_SUP_STATUS_ASG_CT'
1389: ,p_table_owner => l_schema);
1390: --