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.HR_H2PI_PERSON_UPLOAD dependencies on HR_H2PI_PERIODS_OF_SERVICE

Line 265: DELETE FROM hr_h2pi_periods_of_service

261: DELETE FROM hr_h2pi_assignments
262: WHERE client_id = p_from_client_id
263: AND status = 'C';
264:
265: DELETE FROM hr_h2pi_periods_of_service
266: WHERE client_id = p_from_client_id
267: AND status = 'C';
268:
269: DELETE FROM hr_h2pi_locations

Line 406: FROM hr_h2pi_periods_of_service

402: WHERE (status IS NULL OR status <> 'C')
403: AND client_id = p_bg_id
404: UNION
405: SELECT DISTINCT person_id
406: FROM hr_h2pi_periods_of_service
407: WHERE (status IS NULL OR status <> 'C')
408: AND client_id = p_bg_id
409: UNION
410: SELECT DISTINCT person_id

Line 499: FROM HR_H2PI_PERIODS_OF_SERVICE

495: date_start eff_date,
496: 5 ord,
497: 'upload_period_of_service' fn_name,
498: DECODE(last_upd_date, g_eot, 1, 2) sub_order
499: FROM HR_H2PI_PERIODS_OF_SERVICE
500: WHERE (status IS NULL OR status <> 'C')
501: AND person_id = p_per_id
502: AND client_id = p_from_client_id
503: UNION

Line 876: FROM hr_h2pi_periods_of_service pos

872: p_to_id => l_assignment_id);
873: BEGIN
874: SELECT pos.period_of_service_id
875: INTO l_ud_period_of_service_id
876: FROM hr_h2pi_periods_of_service pos
877: WHERE pos.person_id = v_ud_per.person_id
878: AND pos.client_id = p_from_client_id
879: AND pos.date_start = v_ud_per.effective_start_date;
880:

Line 883: FROM hr_h2pi_periods_of_service_v pos

879: AND pos.date_start = v_ud_per.effective_start_date;
880:
881: SELECT pos.period_of_service_id
882: INTO l_period_of_service_id
883: FROM hr_h2pi_periods_of_service_v pos
884: WHERE pos.person_id = l_person_id
885: AND pos.date_start = l_esd;
886:
887: hr_h2pi_map.create_id_mapping

Line 1113: FROM hr_h2pi_periods_of_service pos

1109: BEGIN
1110: hr_utility.set_location(l_proc, 150);
1111: SELECT pos.period_of_service_id
1112: INTO l_ud_period_of_service_id
1113: FROM hr_h2pi_periods_of_service pos
1114: WHERE pos.person_id = v_ud_per.person_id
1115: AND pos.client_id = p_from_client_id
1116: AND pos.date_start = v_ud_per.effective_start_date ;
1117:

Line 1120: FROM hr_h2pi_periods_of_service_v pos

1116: AND pos.date_start = v_ud_per.effective_start_date ;
1117:
1118: SELECT pos.period_of_service_id
1119: INTO l_period_of_service_id
1120: FROM hr_h2pi_periods_of_service_v pos
1121: WHERE pos.person_id = l_person_id
1122: AND pos.date_start = l_esd ;
1123:
1124: hr_h2pi_map.create_id_mapping

Line 1181: FROM hr_h2pi_periods_of_service pos

1177:
1178: CURSOR csr_ud_periods_of_service(p_per_id NUMBER,
1179: p_esd DATE) IS
1180: SELECT *
1181: FROM hr_h2pi_periods_of_service pos
1182: WHERE pos.person_id = p_per_id
1183: AND pos.client_id = p_from_client_id
1184: AND pos.actual_termination_date = p_esd - 1;
1185:

Line 1197: v_ud_pos hr_h2pi_periods_of_service%ROWTYPE;

1193: l_proc VARCHAR2(72) := g_package||'terminate_person';
1194:
1195: l_encoded_message VARCHAR2(200);
1196:
1197: v_ud_pos hr_h2pi_periods_of_service%ROWTYPE;
1198:
1199: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
1200: l_ovn per_periods_of_service.object_version_number%TYPE;
1201: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

Line 1652: v_ud_pos hr_h2pi_periods_of_service%ROWTYPE;

1648: l_proc VARCHAR2(72) := g_package||'upload_assignment';
1649:
1650: v_ud_asg hr_h2pi_assignments%ROWTYPE;
1651: v_ed_asg hr_h2pi_assignments_v%ROWTYPE;
1652: v_ud_pos hr_h2pi_periods_of_service%ROWTYPE;
1653:
1654: l_person_id per_all_people_f.person_id%TYPE;
1655: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1656: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;

Line 2405: FROM hr_h2pi_periods_of_service pos

2401: p_effective_start_date DATE) IS
2402:
2403: CURSOR csr_ud_periods_of_service(p_pos_id NUMBER) IS
2404: SELECT *
2405: FROM hr_h2pi_periods_of_service pos
2406: WHERE pos.period_of_service_id = p_pos_id
2407: AND pos.client_id = p_from_client_id;
2408:
2409: CURSOR csr_ed_periods_of_service(p_pos_id NUMBER) IS

Line 2418: v_ud_pos hr_h2pi_periods_of_service%ROWTYPE;

2414: l_proc VARCHAR2(72) := g_package||'upload_period_of_service';
2415:
2416: l_encoded_message VARCHAR2(200);
2417:
2418: v_ud_pos hr_h2pi_periods_of_service%ROWTYPE;
2419: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
2420: l_ovn per_periods_of_service.object_version_number%TYPE;
2421: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
2422: l_final_process_date per_periods_of_service.final_process_date%TYPE;

Line 2450: UPDATE hr_h2pi_periods_of_service pos

2446: -- ,p_projected_termination_date => v_ud_pos.projected_termination_date
2447: );
2448:
2449: hr_utility.set_location(l_proc, 40);
2450: UPDATE hr_h2pi_periods_of_service pos
2451: SET status = 'C'
2452: WHERE pos.period_of_service_id = v_ud_pos.period_of_service_id
2453: AND pos.client_id = p_from_client_id;
2454:

Line 2466: p_table_name => 'HR_H2PI_PERIODS_OF_SERVICE',

2462: hr_utility.set_location(l_proc, 70);
2463: l_encoded_message := fnd_message.get_encoded;
2464: hr_h2pi_error.data_error
2465: (p_from_id => v_ud_pos.period_of_service_id,
2466: p_table_name => 'HR_H2PI_PERIODS_OF_SERVICE',
2467: p_message_level => 'FATAL',
2468: p_message_text => l_encoded_message);
2469: COMMIT;
2470: RAISE;