eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_OPL_SUPH_HST dependencies on HRI_MDP_MGRH_TRANSFERS_CT

Line 517: INSERT INTO hri_mdp_mgrh_transfers_ct

513: FOR i IN 1..g_trn_row_count LOOP
514:
515: BEGIN
516:
517: INSERT INTO hri_mdp_mgrh_transfers_ct
518: (mgr_sup_person_fk
519: ,per_person_fk
520: ,asg_assgnmnt_fk
521: ,per_person_trn_fk

Line 679: INSERT INTO hri_mdp_mgrh_transfers_ct

675: -- Insert manager hierarchy transfers
676: IF (g_trn_row_count > 0) THEN
677:
678: FORALL i IN 1..g_trn_row_count
679: INSERT INTO hri_mdp_mgrh_transfers_ct
680: (mgr_sup_person_fk
681: ,per_person_fk
682: ,asg_assgnmnt_fk
683: ,per_person_trn_fk

Line 2068: run_sql_stmt_noerr('ALTER TRIGGER HRI_MDP_MGRH_TRANSFERS_CT_WHO DISABLE');

2064:
2065: -- Disable WHO trigger
2066: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_SUPH_WHO DISABLE');
2067: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_MNGRSC_CT_WHO DISABLE');
2068: run_sql_stmt_noerr('ALTER TRIGGER HRI_MDP_MGRH_TRANSFERS_CT_WHO DISABLE');
2069:
2070: -- ********************
2071: -- Full Refresh Section
2072: -- ********************

Line 2088: p_table_name => 'HRI_MDP_MGRH_TRANSFERS_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');
2091:
2092: -- Empty out supervisor hierarchy history table

Line 2090: p_index_excptn_lst => 'HRI_MDP_MGRH_TRANSFERS_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');
2091:
2092: -- Empty out supervisor hierarchy history table
2093: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_CS_SUPH';
2094: EXECUTE IMMEDIATE(l_sql_stmt);

Line 2097: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_MDP_MGRH_TRANSFERS_CT';

2093: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_CS_SUPH';
2094: EXECUTE IMMEDIATE(l_sql_stmt);
2095: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_CS_MNGRSC_CT';
2096: EXECUTE IMMEDIATE(l_sql_stmt);
2097: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_MDP_MGRH_TRANSFERS_CT';
2098: EXECUTE IMMEDIATE(l_sql_stmt);
2099:
2100: -- Insert chain lookup
2101: g_chn_row_count := 0;

Line 2179: run_sql_stmt_noerr('ALTER TRIGGER HRI_MDP_MGRH_TRANSFERS_CT_WHO ENABLE');

2175:
2176: -- Enable WHO trigger
2177: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_SUPH_WHO ENABLE');
2178: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_MNGRSC_CT_WHO ENABLE');
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

Line 2193: p_table_name => 'HRI_MDP_MGRH_TRANSFERS_CT',

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;
2196:
2197: -- As the supervisor hierarchy has been rebuilt, purge the events queue