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_SUPH

Line 408: INSERT INTO hri_cs_suph

404: -- Trap unique constraint errors
405: BEGIN
406:
407: -- Perform single row insert
408: INSERT INTO hri_cs_suph
409: (sup_person_id
410: ,sup_assignment_id
411: ,sup_level
412: ,sup_business_group_id

Line 588: INSERT INTO hri_cs_suph

584: IF (g_suph_row_count > 0) THEN
585:
586: -- insert chunk of rows
587: FORALL i IN 1..g_suph_row_count
588: INSERT INTO hri_cs_suph
589: (sup_person_id
590: ,sup_assignment_id
591: ,sup_level
592: ,sup_business_group_id

Line 907: DELETE FROM hri_cs_suph sph

903:
904: BEGIN
905:
906: -- Delete chain updates after the date of refresh
907: DELETE FROM hri_cs_suph sph
908: WHERE sph.rowid IN
909: (SELECT sph2.rowid
910: FROM hri_eq_sprvsr_hrchy_chgs evt,
911: hri_cs_suph sph2

Line 911: hri_cs_suph sph2

907: DELETE FROM hri_cs_suph sph
908: WHERE sph.rowid IN
909: (SELECT sph2.rowid
910: FROM hri_eq_sprvsr_hrchy_chgs evt,
911: hri_cs_suph sph2
912: WHERE evt.person_id = sph2.sub_person_id
913: AND evt.person_id BETWEEN p_start_person_id
914: AND p_end_person_id
915: AND evt.erlst_evnt_effective_date <= sph2.effective_start_date);

Line 934: UPDATE hri_cs_suph sph

930: debug(sql%rowcount || ' supervisor chain lookup records deleted.');
931:
932: -- Set end dates to the day before the earliest effective change date
933: -- for latest chains of supervisor in event queue
934: UPDATE hri_cs_suph sph
935: SET effective_end_date =
936: (SELECT (evt.erlst_evnt_effective_date - 1)
937: FROM hri_eq_sprvsr_hrchy_chgs evt
938: WHERE evt.person_id = sph.sub_person_id

Line 950: hri_cs_suph sph2

946: sph2.sub_person_id,
947: sph2.sup_person_id,
948: sph2.effective_start_date
949: FROM hri_eq_sprvsr_hrchy_chgs evt,
950: hri_cs_suph sph2
951: WHERE evt.person_id = sph2.sub_person_id
952: AND evt.person_id BETWEEN p_start_person_id
953: AND p_end_person_id
954: AND evt.erlst_evnt_effective_date BETWEEN sph2.effective_start_date

Line 1049: ,hri_cs_suph sph

1045: ,GREATEST(evt.erlst_evnt_effective_date,sph.effective_start_date)
1046: ,'DERIVED'
1047: FROM
1048: hri_eq_sprvsr_hrchy_chgs evt
1049: ,hri_cs_suph sph
1050: WHERE sph.sup_person_id = evt.person_id
1051: AND sph.sub_relative_level > 0
1052: AND sph.effective_end_date >= evt.erlst_evnt_effective_date;
1053:

Line 2040: hri_bpl_conc_log.flush_process_info('HRI_CS_SUPH');

2036: bulk_insert_rows;
2037: END IF;
2038:
2039: -- Flush log messages
2040: hri_bpl_conc_log.flush_process_info('HRI_CS_SUPH');
2041:
2042: END process_range;
2043:
2044: -- ----------------------------------------------------------------------------

Line 2066: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_SUPH_WHO DISABLE');

2062: null;
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: -- ********************

Line 2078: p_table_name => 'HRI_CS_SUPH',

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

Line 2080: p_index_excptn_lst => 'HRI_CS_SUPH_U1');

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');
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,

Line 2093: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_CS_SUPH';

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

Line 2177: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_SUPH_WHO ENABLE');

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

Line 2185: p_table_name => 'HRI_CS_SUPH',

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
2188: (p_application_short_name => 'HRI',
2189: p_table_name => 'HRI_CS_MNGRSC_CT',

Line 2203: hri_bpl_conc_log.record_process_start('HRI_CS_SUPH');

2199:
2200: IF (p_mthd_action_id > -1) THEN
2201:
2202: -- Log process end
2203: hri_bpl_conc_log.record_process_start('HRI_CS_SUPH');
2204: hri_bpl_conc_log.log_process_end(
2205: p_status => TRUE
2206: ,p_period_from => TRUNC(g_refresh_start_date)
2207: ,p_period_to => TRUNC(SYSDATE)

Line 2306: DELETE FROM hri_cs_suph

2302: BEGIN
2303:
2304: debug('Start');
2305:
2306: DELETE FROM hri_cs_suph
2307: WHERE sub_person_id = p_person_id;
2308:
2309: g_suph_row_count := 0;
2310: g_chn_row_count := 0;