DBA Data[Home] [Help]

APPS.HRI_OPL_WRKFC_EVENTS dependencies on HRI_UTL_DDL

Line 2461: hri_utl_ddl.log_and_drop_indexes

2457:
2458: ELSE
2459:
2460: -- Drop all the indexes on the table
2461: hri_utl_ddl.log_and_drop_indexes
2462: (p_application_short_name => 'HRI',
2463: p_table_name => 'HRI_MB_WRKFC_EVT_CT',
2464: p_table_owner => l_schema,
2465: p_index_excptn_lst => 'HRI_MB_WRKFC_EVT_CT_U1');

Line 2468: hri_utl_ddl.log_and_drop_indexes

2464: p_table_owner => l_schema,
2465: p_index_excptn_lst => 'HRI_MB_WRKFC_EVT_CT_U1');
2466:
2467: -- Drop all the indexes on the table
2468: hri_utl_ddl.log_and_drop_indexes
2469: (p_application_short_name => 'HRI',
2470: p_table_name => 'HRI_MDS_WRKFC_MNTH_CT',
2471: p_table_owner => l_schema);
2472:

Line 2538: hri_utl_ddl.recreate_indexes

2534: END IF;
2535:
2536: -- Recreate indexes
2537: IF (g_full_refresh = 'Y') THEN
2538: hri_utl_ddl.recreate_indexes
2539: (p_application_short_name => 'HRI',
2540: p_table_name => 'HRI_MB_WRKFC_EVT_CT',
2541: p_table_owner => l_schema);
2542: hri_utl_ddl.recreate_indexes

Line 2542: hri_utl_ddl.recreate_indexes

2538: hri_utl_ddl.recreate_indexes
2539: (p_application_short_name => 'HRI',
2540: p_table_name => 'HRI_MB_WRKFC_EVT_CT',
2541: p_table_owner => l_schema);
2542: hri_utl_ddl.recreate_indexes
2543: (p_application_short_name => 'HRI',
2544: p_table_name => 'HRI_MDS_WRKFC_MNTH_CT',
2545: p_table_owner => l_schema);
2546: END IF;