DBA Data[Home] [Help]

APPS.HRI_OPL_ORGH_CT dependencies on HRI_UTL_DDL

Line 714: hri_utl_ddl.log_and_drop_indexes

710: /* Disable WHO trigger */
711: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_ORGH_CT_WHO DISABLE');
712:
713: /* Drop all the indexes on the table */
714: hri_utl_ddl.log_and_drop_indexes
715: (p_application_short_name => 'HRI',
716: p_table_name => 'HRI_CS_ORGH_CT',
717: p_table_owner => l_schema);
718:

Line 731: hri_utl_ddl.recreate_indexes

727: output('Re-populated organization hierarchy table: ' ||
728: to_char(sysdate,'HH24:MI:SS'));
729:
730: /* Recreate indexes */
731: hri_utl_ddl.recreate_indexes
732: (p_application_short_name => 'HRI',
733: p_table_name => 'HRI_CS_ORGH_CT',
734: p_table_owner => l_schema);
735:

Line 782: hri_utl_ddl.log_and_drop_indexes

778: /* Disable WHO trigger */
779: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_ORGANZTN_CT_WHO DISABLE');
780:
781: /* Drop all the indexes on the table */
782: hri_utl_ddl.log_and_drop_indexes
783: (p_application_short_name => 'HRI',
784: p_table_name => 'HRI_CS_ORGANZTN_CT',
785: p_table_owner => l_schema);
786:

Line 820: hri_utl_ddl.recreate_indexes

816: output('Re-populated org with workers table: ' ||
817: to_char(sysdate,'HH24:MI:SS'));
818:
819: /* Recreate indexes */
820: hri_utl_ddl.recreate_indexes
821: (p_application_short_name => 'HRI',
822: p_table_name => 'HRI_CS_ORGANZTN_CT',
823: p_table_owner => l_schema);
824: