APPS.HRI_OPL_SUP_STATUS_HST dependencies on HRI_CL_WKR_SUP_STATUS_ASG_CT

Line 662: INTO HRI_CL_WKR_SUP_STATUS_ASG_CT

658: -- we can determine if a person is a subordinate or not on that date (there
659: -- won't be a per_system_status record for subordinate on that date)
660: --
661: INSERT /*+ APPEND */
662: INTO HRI_CL_WKR_SUP_STATUS_ASG_CT
663: (person_id
664: ,effective_start_date
665: ,effective_end_date
666: ,supervisor_flag

Line 857: INTO hri_cl_wkr_sup_status_asg_ct

853: l_user_id := fnd_global.user_id;
854: l_current_time := SYSDATE;
855: --
856: INSERT /*+ APPEND */
857: INTO hri_cl_wkr_sup_status_asg_ct
858: (person_id
859: ,effective_start_date
860: ,effective_end_date
861: ,supervisor_flag

Line 1262: DELETE HRI_CL_WKR_SUP_STATUS_ASG_CT

1258: --
1259: dbg('Inside delete_asg_supervisor_status');
1260: --
1261: --
1262: DELETE HRI_CL_WKR_SUP_STATUS_ASG_CT
1263: WHERE person_id in (SELECT person_id
1264: FROM hri_eq_sprvsr_hstry_chgs
1265: );
1266: --

Line 1364: ,p_table_name => 'HRI_CL_WKR_SUP_STATUS_ASG_CT'

1360: run_sql_stmt_noerr('ALTER TRIGGER HRI_CL_WKR_SUP_STATUS_ASG_WHO DISABLE');
1361: --
1362: hri_utl_ddl.log_and_drop_indexes
1363: (p_application_short_name => 'HRI'
1364: ,p_table_name => 'HRI_CL_WKR_SUP_STATUS_ASG_CT'
1365: ,p_table_owner => l_schema);
1366: --
1367: dbg('Disabled/dropped objects: ' || to_char(sysdate,'HH24:MI:SS'));
1368: --

Line 1371: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_CL_WKR_SUP_STATUS_ASG_CT';

1367: dbg('Disabled/dropped objects: ' || to_char(sysdate,'HH24:MI:SS'));
1368: --
1369: -- Empty out supervisor hierarchy history table
1370: --
1371: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_CL_WKR_SUP_STATUS_ASG_CT';
1372: EXECUTE IMMEDIATE(l_sql_stmt);
1373: --
1374: -- Write timing information to log
1375: --

Line 1388: ,p_table_name => 'HRI_CL_WKR_SUP_STATUS_ASG_CT'

1384: run_sql_stmt_noerr('ALTER TRIGGER HRI_CL_WKR_SUP_STATUS_ASG_WHO ENABLE');
1385: --
1386: hri_utl_ddl.recreate_indexes
1387: (p_application_short_name => 'HRI'
1388: ,p_table_name => 'HRI_CL_WKR_SUP_STATUS_ASG_CT'
1389: ,p_table_owner => l_schema);
1390: --
1391: dbg('Re-enabled/recreated objects: ' || to_char(sysdate,'HH24:MI:SS'));
1392: --

Line 1395: fnd_stats.gather_table_stats(l_schema, 'HRI_CL_WKR_SUP_STATUS_ASG_CT');

1391: dbg('Re-enabled/recreated objects: ' || to_char(sysdate,'HH24:MI:SS'));
1392: --
1393: -- Gather index stats
1394: --
1395: fnd_stats.gather_table_stats(l_schema, 'HRI_CL_WKR_SUP_STATUS_ASG_CT');
1396: --
1397: END IF;
1398: --
1399: -- Purge the events queue