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_CS_MNGRSC_CT

Line 478: INSERT INTO hri_cs_mngrsc_ct

474: FOR i IN 1..g_chn_row_count LOOP
475:
476: BEGIN
477:
478: INSERT INTO hri_cs_mngrsc_ct
479: (mgrs_mngrsc_pk
480: ,mgrs_person_fk
481: ,mgrs_assignment_fk
482: ,mgrs_date_start

Line 648: INSERT INTO hri_cs_mngrsc_ct

644:
645: IF (g_chn_row_count > 0) THEN
646:
647: FORALL i IN 1..g_chn_row_count
648: INSERT INTO hri_cs_mngrsc_ct
649: (mgrs_mngrsc_pk
650: ,mgrs_person_fk
651: ,mgrs_assignment_fk
652: ,mgrs_date_start

Line 920: DELETE FROM hri_cs_mngrsc_ct chn

916:
917: debug(sql%rowcount || ' supervisor hierarchy records deleted.');
918:
919: -- Delete lookup chain updates after the date of refresh
920: DELETE FROM hri_cs_mngrsc_ct chn
921: WHERE chn.rowid IN
922: (SELECT chn2.rowid
923: FROM hri_eq_sprvsr_hrchy_chgs evt,
924: hri_cs_mngrsc_ct chn2

Line 924: hri_cs_mngrsc_ct chn2

920: DELETE FROM hri_cs_mngrsc_ct chn
921: WHERE chn.rowid IN
922: (SELECT chn2.rowid
923: FROM hri_eq_sprvsr_hrchy_chgs evt,
924: hri_cs_mngrsc_ct chn2
925: WHERE evt.person_id = chn2.mgrs_person_fk
926: AND evt.person_id BETWEEN p_start_person_id
927: AND p_end_person_id
928: AND evt.erlst_evnt_effective_date <= chn2.mgrs_date_start);

Line 961: UPDATE hri_cs_mngrsc_ct chn

957: debug(sql%rowcount || ' supervisor hierarchy records end dated.');
958:
959: -- Set end dates to the day before the earliest effective change date
960: -- for latest lookup chains of supervisor in event queue
961: UPDATE hri_cs_mngrsc_ct chn
962: SET chn.mgrs_date_end =
963: (SELECT (evt.erlst_evnt_effective_date - 1)
964: FROM hri_eq_sprvsr_hrchy_chgs evt
965: WHERE evt.person_id = chn.mgrs_person_fk

Line 973: hri_cs_mngrsc_ct chn2

969: WHERE chn.mgrs_mngrsc_pk IN
970: (SELECT
971: chn2.mgrs_mngrsc_pk
972: FROM hri_eq_sprvsr_hrchy_chgs evt,
973: hri_cs_mngrsc_ct chn2
974: WHERE evt.person_id = chn2.mgrs_person_fk
975: AND evt.person_id BETWEEN p_start_person_id
976: AND p_end_person_id
977: AND evt.erlst_evnt_effective_date BETWEEN chn.mgrs_date_start

Line 1117: SELECT hri_cs_mngrsc_ct_s.nextval

1113: l_chain_id NUMBER;
1114:
1115: BEGIN
1116:
1117: SELECT hri_cs_mngrsc_ct_s.nextval
1118: INTO l_chain_id
1119: FROM dual;
1120:
1121: RETURN l_chain_id;

Line 2067: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_MNGRSC_CT_WHO DISABLE');

2063: END IF;
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

Line 2083: p_table_name => 'HRI_CS_MNGRSC_CT',

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');
2086: hri_utl_ddl.log_and_drop_indexes
2087: (p_application_short_name => 'HRI',

Line 2085: p_index_excptn_lst => 'HRI_CS_MNGRSC_CT_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');
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,

Line 2095: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_CS_MNGRSC_CT';

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);
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:

Line 2178: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_MNGRSC_CT_WHO ENABLE');

2174: END IF;
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

Line 2189: p_table_name => 'HRI_CS_MNGRSC_CT',

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
2192: (p_application_short_name => 'HRI',
2193: p_table_name => 'HRI_MDP_MGRH_TRANSFERS_CT',