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 PER_PERIODS_OF_SERVICE

Line 714: l_ud_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;

710: v_ud_per hr_h2pi_employees%ROWTYPE;
711:
712: l_ud_person_id per_all_people_f.person_id%TYPE;
713: l_ud_assignment_id per_all_assignments_f.assignment_id%TYPE;
714: l_ud_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
715:
716: l_person_id per_all_people_f.person_id%TYPE;
717: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
718: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;

Line 718: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;

714: l_ud_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
715:
716: l_person_id per_all_people_f.person_id%TYPE;
717: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
718: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
719: l_person_type per_person_types.system_person_type%TYPE;
720: l_ovn per_all_people_f.object_version_number%TYPE;
721: l_asg_ovn per_all_people_f.object_version_number%TYPE;
722: l_esd per_all_people_f.effective_start_date%TYPE;

Line 888: (p_table_name => 'PER_PERIODS_OF_SERVICE',

884: WHERE pos.person_id = l_person_id
885: AND pos.date_start = l_esd;
886:
887: hr_h2pi_map.create_id_mapping
888: (p_table_name => 'PER_PERIODS_OF_SERVICE',
889: p_from_id => l_ud_period_of_service_id,
890: p_to_id => l_period_of_service_id);
891: EXCEPTION
892: WHEN NO_DATA_FOUND THEN NULL;

Line 1125: (p_table_name => 'PER_PERIODS_OF_SERVICE',

1121: WHERE pos.person_id = l_person_id
1122: AND pos.date_start = l_esd ;
1123:
1124: hr_h2pi_map.create_id_mapping
1125: (p_table_name => 'PER_PERIODS_OF_SERVICE',
1126: p_from_id => l_ud_period_of_service_id,
1127: p_to_id => l_period_of_service_id);
1128: EXCEPTION
1129: WHEN NO_DATA_FOUND THEN NULL;

Line 1190: FROM per_periods_of_service pos

1186: CURSOR csr_ed_periods_of_service(p_pos_id NUMBER) IS
1187: SELECT pos.object_version_number,
1188: pos.actual_termination_date,
1189: pos.final_process_date
1190: FROM per_periods_of_service pos
1191: WHERE pos.period_of_service_id = p_pos_id;
1192:
1193: l_proc VARCHAR2(72) := g_package||'terminate_person';
1194:

Line 1199: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;

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;
1202: l_final_process_date per_periods_of_service.final_process_date%TYPE;
1203:

Line 1200: l_ovn per_periods_of_service.object_version_number%TYPE;

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;
1202: l_final_process_date per_periods_of_service.final_process_date%TYPE;
1203:
1204: l_supervisor_warning BOOLEAN;

Line 1201: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

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;
1202: l_final_process_date per_periods_of_service.final_process_date%TYPE;
1203:
1204: l_supervisor_warning BOOLEAN;
1205: l_event_warning BOOLEAN;

Line 1202: l_final_process_date per_periods_of_service.final_process_date%TYPE;

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;
1202: l_final_process_date per_periods_of_service.final_process_date%TYPE;
1203:
1204: l_supervisor_warning BOOLEAN;
1205: l_event_warning BOOLEAN;
1206: l_interview_warning BOOLEAN;

Line 1224: (p_table_name => 'PER_PERIODS_OF_SERVICE',

1220: FETCH csr_ud_periods_of_service INTO v_ud_pos;
1221: CLOSE csr_ud_periods_of_service;
1222:
1223: l_period_of_service_id := hr_h2pi_map.get_to_id
1224: (p_table_name => 'PER_PERIODS_OF_SERVICE',
1225: p_from_id => v_ud_pos.period_of_service_id,
1226: p_report_error => TRUE);
1227:
1228: OPEN csr_ed_periods_of_service(l_period_of_service_id);

Line 1609: per_periods_of_service pos

1605: SELECT pos.object_version_number,
1606: pos.period_of_service_id
1607: FROM per_all_assignments_f asg,
1608: per_all_people_f per,
1609: per_periods_of_service pos
1610: WHERE asg.assignment_id = p_asg_id
1611: AND p_esd BETWEEN asg.effective_start_date
1612: AND asg.effective_end_date
1613: AND asg.person_id = per.person_id

Line 1656: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;

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;
1657: l_ovn per_all_people_f.object_version_number%TYPE;
1658: l_pos_ovn per_all_people_f.object_version_number%TYPE;
1659: l_esd per_all_people_f.effective_start_date%TYPE;
1660: l_eed per_all_people_f.effective_end_date%TYPE;

Line 1699: l_final_process_date per_periods_of_service.final_process_date%TYPE;

1695: l_location_id per_all_assignments_f.location_id%TYPE;
1696: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1697: l_gre_id NUMBER(15);
1698:
1699: l_final_process_date per_periods_of_service.final_process_date%TYPE;
1700:
1701: l_temp_id NUMBER(15);
1702: l_ud_emp_fed_tax_rule_id hr_h2pi_federal_tax_rules.emp_fed_tax_rule_id%TYPE;
1703: l_ud_emp_state_tax_rule_id hr_h2pi_state_tax_rules.emp_state_tax_rule_id%TYPE;

Line 2411: FROM per_periods_of_service pos

2407: AND pos.client_id = p_from_client_id;
2408:
2409: CURSOR csr_ed_periods_of_service(p_pos_id NUMBER) IS
2410: SELECT pos.object_version_number
2411: FROM per_periods_of_service pos
2412: WHERE pos.period_of_service_id = p_pos_id;
2413:
2414: l_proc VARCHAR2(72) := g_package||'upload_period_of_service';
2415:

Line 2419: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;

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;
2423: BEGIN

Line 2420: l_ovn per_periods_of_service.object_version_number%TYPE;

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;
2423: BEGIN
2424: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2421: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

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;
2423: BEGIN
2424: hr_utility.set_location('Entering:'|| l_proc, 10);
2425:

Line 2422: l_final_process_date per_periods_of_service.final_process_date%TYPE;

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;
2423: BEGIN
2424: hr_utility.set_location('Entering:'|| l_proc, 10);
2425:
2426: OPEN csr_ud_periods_of_service(p_period_of_service_id);

Line 2430: (p_table_name => 'PER_PERIODS_OF_SERVICE',

2426: OPEN csr_ud_periods_of_service(p_period_of_service_id);
2427: FETCH csr_ud_periods_of_service INTO v_ud_pos;
2428:
2429: l_period_of_service_id := hr_h2pi_map.get_to_id
2430: (p_table_name => 'PER_PERIODS_OF_SERVICE',
2431: p_from_id => v_ud_pos.period_of_service_id,
2432: p_report_error => TRUE);
2433:
2434: OPEN csr_ed_periods_of_service(l_period_of_service_id);