APPS.HRI_OPL_SUPH_HST dependencies on HRI_UTL_DDL

Line 2076: hri_utl_ddl.log_and_drop_indexes

2072: -- ********************
2073: IF (g_full_refresh = 'Y') THEN
2074:
2075: -- Drop all the indexes on the table (except the unique index)
2076: hri_utl_ddl.log_and_drop_indexes
2077: (p_application_short_name => 'HRI',
2078: p_table_name => 'HRI_CS_SUPH',
2079: p_table_owner => l_schema,
2080: p_index_excptn_lst => 'HRI_CS_SUPH_U1');

Line 2081: hri_utl_ddl.log_and_drop_indexes

2077: (p_application_short_name => 'HRI',
2078: p_table_name => 'HRI_CS_SUPH',
2079: p_table_owner => l_schema,
2080: p_index_excptn_lst => 'HRI_CS_SUPH_U1');
2081: hri_utl_ddl.log_and_drop_indexes
2082: (p_application_short_name => 'HRI',
2083: p_table_name => 'HRI_CS_MNGRSC_CT',
2084: p_table_owner => l_schema,
2085: p_index_excptn_lst => 'HRI_CS_MNGRSC_CT_U1');

Line 2086: hri_utl_ddl.log_and_drop_indexes

2082: (p_application_short_name => 'HRI',
2083: p_table_name => 'HRI_CS_MNGRSC_CT',
2084: p_table_owner => l_schema,
2085: p_index_excptn_lst => 'HRI_CS_MNGRSC_CT_U1');
2086: hri_utl_ddl.log_and_drop_indexes
2087: (p_application_short_name => 'HRI',
2088: p_table_name => 'HRI_MDP_MGRH_TRANSFERS_CT',
2089: p_table_owner => l_schema,
2090: p_index_excptn_lst => 'HRI_MDP_MGRH_TRANSFERS_CT_U1');

Line 2183: hri_utl_ddl.recreate_indexes

2179: run_sql_stmt_noerr('ALTER TRIGGER HRI_MDP_MGRH_TRANSFERS_CT_WHO ENABLE');
2180:
2181: -- Recreate indexes if they were dropped (full refresh)
2182: IF (g_full_refresh = 'Y') THEN
2183: hri_utl_ddl.recreate_indexes
2184: (p_application_short_name => 'HRI',
2185: p_table_name => 'HRI_CS_SUPH',
2186: p_table_owner => l_schema);
2187: hri_utl_ddl.recreate_indexes

Line 2187: hri_utl_ddl.recreate_indexes

2183: hri_utl_ddl.recreate_indexes
2184: (p_application_short_name => 'HRI',
2185: p_table_name => 'HRI_CS_SUPH',
2186: p_table_owner => l_schema);
2187: hri_utl_ddl.recreate_indexes
2188: (p_application_short_name => 'HRI',
2189: p_table_name => 'HRI_CS_MNGRSC_CT',
2190: p_table_owner => l_schema);
2191: hri_utl_ddl.recreate_indexes

Line 2191: hri_utl_ddl.recreate_indexes

2187: hri_utl_ddl.recreate_indexes
2188: (p_application_short_name => 'HRI',
2189: p_table_name => 'HRI_CS_MNGRSC_CT',
2190: p_table_owner => l_schema);
2191: hri_utl_ddl.recreate_indexes
2192: (p_application_short_name => 'HRI',
2193: p_table_name => 'HRI_MDP_MGRH_TRANSFERS_CT',
2194: p_table_owner => l_schema);
2195: END IF;