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_SUP_STATUS_HST dependencies on HRI_EQ_SPRVSR_HSTRY_CHGS

Line 507: hri_eq_sprvsr_hstry_chgs eq

503: (select pos.person_id,
504: pos.date_start,
505: pos.actual_termination_date
506: from per_periods_of_service pos,
507: hri_eq_sprvsr_hstry_chgs eq
508: where eq.person_id=pos.person_id
509: UNION ALL
510: select pop.person_id,
511: pop.date_start,

Line 514: hri_eq_sprvsr_hstry_chgs eq

510: select pop.person_id,
511: pop.date_start,
512: pop.actual_termination_date
513: from per_periods_of_placement pop,
514: hri_eq_sprvsr_hstry_chgs eq
515: WHERE eq.person_id=pop.person_id
516: )pos,
517: (--
518: -- This gets all supervisors whose subordinates have had events that

Line 533: hri_eq_sprvsr_hstry_chgs eq

529: evt.supervisor_id
530: END event_supervisor_id,
531: evt.effective_change_date effective_date
532: FROM hri_mb_asgn_events_ct evt,
533: hri_eq_sprvsr_hstry_chgs eq
534: WHERE (
535: (--
536: -- get only those asg records which have had a
537: -- change in supervisor

Line 563: hri_eq_sprvsr_hstry_chgs eq

559: --
560: SELECT evt.supervisor_prv_id event_supervisor_id,
561: evt.effective_change_date effective_date
562: FROM hri_mb_asgn_events_ct evt,
563: hri_eq_sprvsr_hstry_chgs eq
564: WHERE (
565: (
566: (supervisor_change_ind = 1
567: OR worker_term_ind = 1

Line 586: hri_eq_sprvsr_hstry_chgs eq

582: SELECT pos.person_id,
583: GREATEST(hri_bpl_parameter.get_bis_global_start_date
584: ,pos.date_start)
585: FROM per_periods_of_service pos,
586: hri_eq_sprvsr_hstry_chgs eq
587: WHERE eq.person_id=pos.person_id
588: UNION
589: --
590: -- Gets all active placements

Line 596: hri_eq_sprvsr_hstry_chgs eq

592: SELECT pop.person_id,
593: GREATEST(hri_bpl_parameter.get_bis_global_start_date
594: ,pop.date_start)
595: FROM per_periods_of_placement pop,
596: hri_eq_sprvsr_hstry_chgs eq
597: WHERE eq.person_id=pop.person_id
598: ) leaf_date
599: WHERE leaf_date.event_supervisor_id = asg.supervisor_id (+)
600: AND leaf_date.event_supervisor_id = pos.person_id

Line 953: hri_eq_sprvsr_hstry_chgs eq

949: (select pos.person_id,
950: pos.date_start,
951: pos.actual_termination_date
952: from per_periods_of_service pos,
953: hri_eq_sprvsr_hstry_chgs eq
954: where eq.person_id=pos.person_id
955: UNION ALL
956: select pop.person_id,
957: pop.date_start,

Line 960: hri_eq_sprvsr_hstry_chgs eq

956: select pop.person_id,
957: pop.date_start,
958: pop.actual_termination_date
959: from per_periods_of_placement pop,
960: hri_eq_sprvsr_hstry_chgs eq
961: WHERE eq.person_id=pop.person_id
962: )pos,
963: (--
964: -- This gets all supervisors whose subordinates have had events that

Line 970: hri_eq_sprvsr_hstry_chgs eq

966: --
967: SELECT evt.supervisor_id event_supervisor_id,
968: evt.effective_change_date effective_date
969: FROM hri_mb_asgn_events_ct evt,
970: hri_eq_sprvsr_hstry_chgs eq
971: WHERE (worker_hire_ind = 1
972: OR post_hire_asgn_start_ind = 1
973: OR supervisor_change_ind = 1
974: OR asg_rtrspctv_strt_event_ind = 1)

Line 986: hri_eq_sprvsr_hstry_chgs eq

982: --
983: SELECT evt.supervisor_prv_id event_supervisor_id,
984: evt.effective_change_date effective_date
985: FROM hri_mb_asgn_events_ct evt,
986: hri_eq_sprvsr_hstry_chgs eq
987: WHERE (supervisor_change_ind = 1
988: OR worker_term_ind = 1
989: OR pre_sprtn_asgn_end_ind = 1)
990: AND evt.supervisor_prv_id <> -1

Line 1000: hri_eq_sprvsr_hstry_chgs eq

996: SELECT pos.person_id,
997: GREATEST(hri_bpl_parameter.get_bis_global_start_date
998: ,pos.date_start)
999: FROM per_periods_of_service pos,
1000: hri_eq_sprvsr_hstry_chgs eq
1001: WHERE eq.person_id=pos.person_id
1002: UNION
1003: --
1004: -- Gets all active placements

Line 1010: hri_eq_sprvsr_hstry_chgs eq

1006: SELECT pop.person_id,
1007: GREATEST(hri_bpl_parameter.get_bis_global_start_date
1008: ,pop.date_start)
1009: FROM per_periods_of_placement pop,
1010: hri_eq_sprvsr_hstry_chgs eq
1011: WHERE eq.person_id=pop.person_id
1012: ) leaf_date
1013: WHERE leaf_date.event_supervisor_id = asg.supervisor_id (+)
1014: AND leaf_date.event_supervisor_id = pos.person_id

Line 1044: -- This procedure populates the person_id column in hri_eq_sprvsr_hstry_chgs

1040: --
1041: end collect_asg_incremental_data;
1042: --
1043: -- ---------------------------------------------------------------------------
1044: -- This procedure populates the person_id column in hri_eq_sprvsr_hstry_chgs
1045: -- by using the value of assignment_id
1046: -- ---------------------------------------------------------------------------
1047: --
1048: PROCEDURE update_event_queue IS

Line 1054: UPDATE hri_eq_sprvsr_hstry_chgs eq

1050: BEGIN
1051: --
1052: dbg('Inside update_event_queue');
1053: --
1054: UPDATE hri_eq_sprvsr_hstry_chgs eq
1055: SET person_id = (SELECT person_id
1056: FROM per_all_assignments_f asg
1057: WHERE eq.assignment_id=asg.assignment_id
1058: AND rownum=1

Line 1108: INSERT /+ APPEND / INTO hri_eq_sprvsr_hstry_chgs

1104: --
1105: -- Insert previous supervisors
1106: -- NOTE - THIS MUST BE CALLED BEFORE hri_mb_asgn_events_ct IS REFRESHED
1107: --
1108: INSERT /*+ APPEND */ INTO hri_eq_sprvsr_hstry_chgs
1109: (person_id
1110: ,erlst_evnt_effective_date
1111: ,source_code)
1112: SELECT DISTINCT

Line 1117: hri_eq_sprvsr_hstry_chgs eq

1113: evt.supervisor_id
1114: ,eq.erlst_evnt_effective_date
1115: ,'DERIVED'
1116: FROM
1117: hri_eq_sprvsr_hstry_chgs eq
1118: ,hri_mb_asgn_events_ct evt
1119: WHERE eq.assignment_id = evt.assignment_id
1120: AND evt.effective_change_end_date >= eq.erlst_evnt_effective_date
1121: AND eq.source_code IS NULL

Line 1124: FROM hri_eq_sprvsr_hstry_chgs eq2

1120: AND evt.effective_change_end_date >= eq.erlst_evnt_effective_date
1121: AND eq.source_code IS NULL
1122: AND NOT EXISTS
1123: (SELECT null
1124: FROM hri_eq_sprvsr_hstry_chgs eq2
1125: WHERE eq2.person_id = evt.supervisor_id);
1126: --
1127: dbg(sql%rowcount||' old supervisors found and added to the change list.');
1128: --

Line 1134: INSERT /+ APPEND / INTO hri_eq_sprvsr_hstry_chgs

1130: dbg('Case B');
1131: --
1132: -- Insert current supervisors
1133: --
1134: INSERT /*+ APPEND */ INTO hri_eq_sprvsr_hstry_chgs
1135: (person_id
1136: ,erlst_evnt_effective_date
1137: ,source_code)
1138: SELECT DISTINCT

Line 1143: hri_eq_sprvsr_hstry_chgs eq

1139: asg.supervisor_id
1140: ,eq.erlst_evnt_effective_date
1141: ,'DERIVED'
1142: FROM
1143: hri_eq_sprvsr_hstry_chgs eq
1144: ,per_all_assignments_f asg
1145: WHERE eq.assignment_id = asg.assignment_id
1146: AND asg.effective_start_date >= eq.erlst_evnt_effective_date
1147: AND eq.source_code IS NULL

Line 1150: FROM hri_eq_sprvsr_hstry_chgs eq2

1146: AND asg.effective_start_date >= eq.erlst_evnt_effective_date
1147: AND eq.source_code IS NULL
1148: AND NOT EXISTS
1149: (SELECT null
1150: FROM hri_eq_sprvsr_hstry_chgs eq2
1151: WHERE eq2.person_id = asg.supervisor_id);
1152: --
1153: dbg(sql%rowcount||' new supervisors found and added to the change list.');
1154: --

Line 1161: DELETE FROM hri_eq_sprvsr_hstry_chgs eq

1157: --
1158: -- Delete original records where there is no hire or termination
1159: -- after the event date
1160: --
1161: DELETE FROM hri_eq_sprvsr_hstry_chgs eq
1162: WHERE eq.source_code IS NULL
1163: AND eq.person_id IN
1164: (SELECT
1165: pps.person_id

Line 1167: hri_eq_sprvsr_hstry_chgs eq2

1163: AND eq.person_id IN
1164: (SELECT
1165: pps.person_id
1166: FROM
1167: hri_eq_sprvsr_hstry_chgs eq2
1168: ,per_periods_of_service pps
1169: WHERE eq2.person_id = pps.person_id
1170: AND pps.date_start <> eq2.erlst_evnt_effective_date
1171: AND pps.actual_termination_date IS NULL);

Line 1175: DELETE FROM hri_eq_sprvsr_hstry_chgs eq

1171: AND pps.actual_termination_date IS NULL);
1172: --
1173: dbg(sql%rowcount||' redundant employee assignment changes removed');
1174: --
1175: DELETE FROM hri_eq_sprvsr_hstry_chgs eq
1176: WHERE eq.source_code IS NULL
1177: AND eq.person_id IN
1178: (SELECT
1179: ppp.person_id

Line 1181: hri_eq_sprvsr_hstry_chgs eq2

1177: AND eq.person_id IN
1178: (SELECT
1179: ppp.person_id
1180: FROM
1181: hri_eq_sprvsr_hstry_chgs eq2
1182: ,per_periods_of_placement ppp
1183: WHERE eq2.person_id = ppp.person_id
1184: AND ppp.date_start <> eq2.erlst_evnt_effective_date
1185: AND ppp.actual_termination_date IS NULL);

Line 1226: FROM hri_eq_sprvsr_hstry_chgs

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: --
1229: --
1230: dbg('Exiting delete_old_supervisor_status');

Line 1264: FROM hri_eq_sprvsr_hstry_chgs

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: --
1267: --
1268: dbg('Exiting delete_asg_supervisor_status');

Line 1401: HRI_OPL_EVENT_CAPTURE.purge_queue('HRI_EQ_SPRVSR_HSTRY_CHGS');

1397: END IF;
1398: --
1399: -- Purge the events queue
1400: --
1401: HRI_OPL_EVENT_CAPTURE.purge_queue('HRI_EQ_SPRVSR_HSTRY_CHGS');
1402: --
1403: -- Write timing information to log
1404: dbg('Gathered stats: ' || to_char(sysdate,'HH24:MI:SS'));
1405: --

Line 1496: HRI_OPL_EVENT_CAPTURE.purge_queue('HRI_EQ_SPRVSR_HSTRY_CHGS');

1492: END IF;
1493: --
1494: -- Purge the events queue
1495: --
1496: HRI_OPL_EVENT_CAPTURE.purge_queue('HRI_EQ_SPRVSR_HSTRY_CHGS');
1497: --
1498: -- Write timing information to log
1499: --
1500: dbg('Incremental supervisor status history collection completed successfully at ' ||