APPS.HRI_OPL_SUP_STATUS_HST dependencies on HRI_CL_WKR_SUP_STATUS_CT

Line 186: INTO HRI_CL_WKR_SUP_STATUS_CT

182: -- we can determine if a person is a subordinate or not on that date (there
183: -- won't be a per_system_status record for subordinate on that date)
184: --
185: INSERT /*+ APPEND */
186: INTO HRI_CL_WKR_SUP_STATUS_CT
187: (person_id
188: ,effective_start_date
189: ,effective_end_date
190: ,supervisor_flag

Line 410: INTO hri_cl_wkr_sup_status_ct

406: l_user_id := fnd_global.user_id;
407: l_current_time := SYSDATE;
408: --
409: INSERT /*+ APPEND */
410: INTO hri_cl_wkr_sup_status_ct
411: (person_id
412: ,effective_start_date
413: ,effective_end_date
414: ,supervisor_flag

Line 1224: DELETE HRI_CL_WKR_SUP_STATUS_CT

1220: --
1221: dbg('Inside delete_old_supervisor_status');
1222: --
1223: --
1224: DELETE HRI_CL_WKR_SUP_STATUS_CT
1225: WHERE person_id in (SELECT person_id
1226: FROM hri_eq_sprvsr_hstry_chgs
1227: );
1228: --

Line 1329: p_object_name => 'HRI_CL_WKR_SUP_STATUS_CT');

1325: --
1326: -- Disable/drop objects (indexes and triggers)
1327: --
1328: disable_objects(p_schema => l_schema,
1329: p_object_name => 'HRI_CL_WKR_SUP_STATUS_CT');
1330: --
1331: dbg('Disabled/dropped objects: ' || to_char(sysdate,'HH24:MI:SS'));
1332: --
1333: -- Empty out supervisor hierarchy history table

Line 1335: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_CL_WKR_SUP_STATUS_CT';

1331: dbg('Disabled/dropped objects: ' || to_char(sysdate,'HH24:MI:SS'));
1332: --
1333: -- Empty out supervisor hierarchy history table
1334: --
1335: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_CL_WKR_SUP_STATUS_CT';
1336: EXECUTE IMMEDIATE(l_sql_stmt);
1337: --
1338: -- Write timing information to log
1339: --

Line 1349: p_object_name => 'HRI_CL_WKR_SUP_STATUS_CT');

1345: --
1346: -- Re-enable/recreate objects
1347: --
1348: enable_objects(p_schema => l_schema,
1349: p_object_name => 'HRI_CL_WKR_SUP_STATUS_CT');
1350: dbg('Re-enabled/recreated objects: ' || to_char(sysdate,'HH24:MI:SS'));
1351: --
1352: END IF;
1353: --

Line 1541: hri_bpl_conc_log.record_process_start('HRI_CL_WKR_SUP_STATUS_CT');

1537: -- Profile HRI:DBI Force Shared HR Processes
1538: --
1539: BEGIN
1540: --
1541: hri_bpl_conc_log.record_process_start('HRI_CL_WKR_SUP_STATUS_CT');
1542: --
1543: l_is_hr_installed := hr_general.chk_product_installed(800);
1544: l_frc_shrd_hr_prfl_val := nvl(fnd_profile.value('HRI_DBI_FORCE_SHARED_HR'),'N');
1545: --

Line 1648: hri_bpl_conc_log.record_process_start('HRI_CL_WKR_SUP_STATUS_CT');

1644: -- Profile HRI:DBI Force Shared HR Processes
1645: --
1646: BEGIN
1647: --
1648: hri_bpl_conc_log.record_process_start('HRI_CL_WKR_SUP_STATUS_CT');
1649: --
1650: -- If Full HR has not been installed or if profile HRI:DBI Force Shared HR
1651: -- Processes has been set, then the force the process to run in
1652: -- full refresh mode and from SYSDATE

Line 1691: bis_collection_utilities.get_last_refresh_dates('HRI_CL_WKR_SUP_STATUS_CT'

1687: --
1688: --
1689: -- get the last run dates
1690: --
1691: bis_collection_utilities.get_last_refresh_dates('HRI_CL_WKR_SUP_STATUS_CT'
1692: ,l_bis_start_date
1693: ,l_bis_end_date
1694: ,l_period_from
1695: ,l_period_to);

Line 1779: hri_bpl_conc_log.record_process_start('HRI_CL_WKR_SUP_STATUS_CT');

1775: BEGIN
1776: --
1777: dbg('Inside run_request');
1778: --
1779: hri_bpl_conc_log.record_process_start('HRI_CL_WKR_SUP_STATUS_CT');
1780: --
1781: -- Determine if the process needs to be run in Foundation HR mode
1782: --
1783: l_is_hr_installed := hr_general.chk_product_installed(800);

Line 1856: p_process_table_name => 'HRI_CL_WKR_SUP_STATUS_CT');

1852: --
1853: IF (p_full_refresh IS NULL) THEN
1854: l_full_refresh := hri_oltp_conc_param.get_parameter_value
1855: (p_parameter_name => 'FULL_REFRESH',
1856: p_process_table_name => 'HRI_CL_WKR_SUP_STATUS_CT');
1857: IF (l_full_refresh = 'Y') THEN
1858: l_start_date := hri_oltp_conc_param.get_date_parameter_value
1859: (p_parameter_name => 'FULL_REFRESH_FROM_DATE',
1860: p_process_table_name => 'HRI_CL_WKR_SUP_STATUS_CT');

Line 1860: p_process_table_name => 'HRI_CL_WKR_SUP_STATUS_CT');

1856: p_process_table_name => 'HRI_CL_WKR_SUP_STATUS_CT');
1857: IF (l_full_refresh = 'Y') THEN
1858: l_start_date := hri_oltp_conc_param.get_date_parameter_value
1859: (p_parameter_name => 'FULL_REFRESH_FROM_DATE',
1860: p_process_table_name => 'HRI_CL_WKR_SUP_STATUS_CT');
1861: ELSE
1862: l_start_date := fnd_date.canonical_to_date(p_start_date);
1863: END IF;
1864: ELSE