8: IS
9: l_proc varchar2(30) := 'initialize_record';
10: BEGIN
11: hr_utility.set_location('Entering:'||l_proc,5);
12: g_ghr_cpdf_temp.academic_discipline := NULL;
13: g_ghr_cpdf_temp.agency_code := NULL;
14: g_ghr_cpdf_temp.annuitant_indicator := NULL;
15: g_ghr_cpdf_temp.award_amount := NULL;
16: g_ghr_cpdf_temp.bargaining_unit_status := NULL;
9: l_proc varchar2(30) := 'initialize_record';
10: BEGIN
11: hr_utility.set_location('Entering:'||l_proc,5);
12: g_ghr_cpdf_temp.academic_discipline := NULL;
13: g_ghr_cpdf_temp.agency_code := NULL;
14: g_ghr_cpdf_temp.annuitant_indicator := NULL;
15: g_ghr_cpdf_temp.award_amount := NULL;
16: g_ghr_cpdf_temp.bargaining_unit_status := NULL;
17: g_ghr_cpdf_temp.benefit_amount := NULL;
10: BEGIN
11: hr_utility.set_location('Entering:'||l_proc,5);
12: g_ghr_cpdf_temp.academic_discipline := NULL;
13: g_ghr_cpdf_temp.agency_code := NULL;
14: g_ghr_cpdf_temp.annuitant_indicator := NULL;
15: g_ghr_cpdf_temp.award_amount := NULL;
16: g_ghr_cpdf_temp.bargaining_unit_status := NULL;
17: g_ghr_cpdf_temp.benefit_amount := NULL;
18: g_ghr_cpdf_temp.citizenship := NULL;
11: hr_utility.set_location('Entering:'||l_proc,5);
12: g_ghr_cpdf_temp.academic_discipline := NULL;
13: g_ghr_cpdf_temp.agency_code := NULL;
14: g_ghr_cpdf_temp.annuitant_indicator := NULL;
15: g_ghr_cpdf_temp.award_amount := NULL;
16: g_ghr_cpdf_temp.bargaining_unit_status := NULL;
17: g_ghr_cpdf_temp.benefit_amount := NULL;
18: g_ghr_cpdf_temp.citizenship := NULL;
19: g_ghr_cpdf_temp.creditable_military_service := NULL;
12: g_ghr_cpdf_temp.academic_discipline := NULL;
13: g_ghr_cpdf_temp.agency_code := NULL;
14: g_ghr_cpdf_temp.annuitant_indicator := NULL;
15: g_ghr_cpdf_temp.award_amount := NULL;
16: g_ghr_cpdf_temp.bargaining_unit_status := NULL;
17: g_ghr_cpdf_temp.benefit_amount := NULL;
18: g_ghr_cpdf_temp.citizenship := NULL;
19: g_ghr_cpdf_temp.creditable_military_service := NULL;
20: g_ghr_cpdf_temp.current_appointment_auth1 := NULL;
13: g_ghr_cpdf_temp.agency_code := NULL;
14: g_ghr_cpdf_temp.annuitant_indicator := NULL;
15: g_ghr_cpdf_temp.award_amount := NULL;
16: g_ghr_cpdf_temp.bargaining_unit_status := NULL;
17: g_ghr_cpdf_temp.benefit_amount := NULL;
18: g_ghr_cpdf_temp.citizenship := NULL;
19: g_ghr_cpdf_temp.creditable_military_service := NULL;
20: g_ghr_cpdf_temp.current_appointment_auth1 := NULL;
21: g_ghr_cpdf_temp.current_appointment_auth2 := NULL;
14: g_ghr_cpdf_temp.annuitant_indicator := NULL;
15: g_ghr_cpdf_temp.award_amount := NULL;
16: g_ghr_cpdf_temp.bargaining_unit_status := NULL;
17: g_ghr_cpdf_temp.benefit_amount := NULL;
18: g_ghr_cpdf_temp.citizenship := NULL;
19: g_ghr_cpdf_temp.creditable_military_service := NULL;
20: g_ghr_cpdf_temp.current_appointment_auth1 := NULL;
21: g_ghr_cpdf_temp.current_appointment_auth2 := NULL;
22: g_ghr_cpdf_temp.to_duty_station_code := NULL;
15: g_ghr_cpdf_temp.award_amount := NULL;
16: g_ghr_cpdf_temp.bargaining_unit_status := NULL;
17: g_ghr_cpdf_temp.benefit_amount := NULL;
18: g_ghr_cpdf_temp.citizenship := NULL;
19: g_ghr_cpdf_temp.creditable_military_service := NULL;
20: g_ghr_cpdf_temp.current_appointment_auth1 := NULL;
21: g_ghr_cpdf_temp.current_appointment_auth2 := NULL;
22: g_ghr_cpdf_temp.to_duty_station_code := NULL;
23: g_ghr_cpdf_temp.education_level := NULL;
16: g_ghr_cpdf_temp.bargaining_unit_status := NULL;
17: g_ghr_cpdf_temp.benefit_amount := NULL;
18: g_ghr_cpdf_temp.citizenship := NULL;
19: g_ghr_cpdf_temp.creditable_military_service := NULL;
20: g_ghr_cpdf_temp.current_appointment_auth1 := NULL;
21: g_ghr_cpdf_temp.current_appointment_auth2 := NULL;
22: g_ghr_cpdf_temp.to_duty_station_code := NULL;
23: g_ghr_cpdf_temp.education_level := NULL;
24: g_ghr_cpdf_temp.effective_date := NULL;
17: g_ghr_cpdf_temp.benefit_amount := NULL;
18: g_ghr_cpdf_temp.citizenship := NULL;
19: g_ghr_cpdf_temp.creditable_military_service := NULL;
20: g_ghr_cpdf_temp.current_appointment_auth1 := NULL;
21: g_ghr_cpdf_temp.current_appointment_auth2 := NULL;
22: g_ghr_cpdf_temp.to_duty_station_code := NULL;
23: g_ghr_cpdf_temp.education_level := NULL;
24: g_ghr_cpdf_temp.effective_date := NULL;
25: g_ghr_cpdf_temp.employee_date_of_birth := NULL;
18: g_ghr_cpdf_temp.citizenship := NULL;
19: g_ghr_cpdf_temp.creditable_military_service := NULL;
20: g_ghr_cpdf_temp.current_appointment_auth1 := NULL;
21: g_ghr_cpdf_temp.current_appointment_auth2 := NULL;
22: g_ghr_cpdf_temp.to_duty_station_code := NULL;
23: g_ghr_cpdf_temp.education_level := NULL;
24: g_ghr_cpdf_temp.effective_date := NULL;
25: g_ghr_cpdf_temp.employee_date_of_birth := NULL;
26: g_ghr_cpdf_temp.employee_first_name := NULL;
19: g_ghr_cpdf_temp.creditable_military_service := NULL;
20: g_ghr_cpdf_temp.current_appointment_auth1 := NULL;
21: g_ghr_cpdf_temp.current_appointment_auth2 := NULL;
22: g_ghr_cpdf_temp.to_duty_station_code := NULL;
23: g_ghr_cpdf_temp.education_level := NULL;
24: g_ghr_cpdf_temp.effective_date := NULL;
25: g_ghr_cpdf_temp.employee_date_of_birth := NULL;
26: g_ghr_cpdf_temp.employee_first_name := NULL;
27: g_ghr_cpdf_temp.employee_last_name := NULL;
20: g_ghr_cpdf_temp.current_appointment_auth1 := NULL;
21: g_ghr_cpdf_temp.current_appointment_auth2 := NULL;
22: g_ghr_cpdf_temp.to_duty_station_code := NULL;
23: g_ghr_cpdf_temp.education_level := NULL;
24: g_ghr_cpdf_temp.effective_date := NULL;
25: g_ghr_cpdf_temp.employee_date_of_birth := NULL;
26: g_ghr_cpdf_temp.employee_first_name := NULL;
27: g_ghr_cpdf_temp.employee_last_name := NULL;
28: g_ghr_cpdf_temp.employee_middle_names := NULL;
21: g_ghr_cpdf_temp.current_appointment_auth2 := NULL;
22: g_ghr_cpdf_temp.to_duty_station_code := NULL;
23: g_ghr_cpdf_temp.education_level := NULL;
24: g_ghr_cpdf_temp.effective_date := NULL;
25: g_ghr_cpdf_temp.employee_date_of_birth := NULL;
26: g_ghr_cpdf_temp.employee_first_name := NULL;
27: g_ghr_cpdf_temp.employee_last_name := NULL;
28: g_ghr_cpdf_temp.employee_middle_names := NULL;
29: g_ghr_cpdf_temp.from_national_identifier := NULL;
22: g_ghr_cpdf_temp.to_duty_station_code := NULL;
23: g_ghr_cpdf_temp.education_level := NULL;
24: g_ghr_cpdf_temp.effective_date := NULL;
25: g_ghr_cpdf_temp.employee_date_of_birth := NULL;
26: g_ghr_cpdf_temp.employee_first_name := NULL;
27: g_ghr_cpdf_temp.employee_last_name := NULL;
28: g_ghr_cpdf_temp.employee_middle_names := NULL;
29: g_ghr_cpdf_temp.from_national_identifier := NULL;
30: g_ghr_cpdf_temp.fegli := NULL;
23: g_ghr_cpdf_temp.education_level := NULL;
24: g_ghr_cpdf_temp.effective_date := NULL;
25: g_ghr_cpdf_temp.employee_date_of_birth := NULL;
26: g_ghr_cpdf_temp.employee_first_name := NULL;
27: g_ghr_cpdf_temp.employee_last_name := NULL;
28: g_ghr_cpdf_temp.employee_middle_names := NULL;
29: g_ghr_cpdf_temp.from_national_identifier := NULL;
30: g_ghr_cpdf_temp.fegli := NULL;
31: g_ghr_cpdf_temp.fers_coverage := NULL;
24: g_ghr_cpdf_temp.effective_date := NULL;
25: g_ghr_cpdf_temp.employee_date_of_birth := NULL;
26: g_ghr_cpdf_temp.employee_first_name := NULL;
27: g_ghr_cpdf_temp.employee_last_name := NULL;
28: g_ghr_cpdf_temp.employee_middle_names := NULL;
29: g_ghr_cpdf_temp.from_national_identifier := NULL;
30: g_ghr_cpdf_temp.fegli := NULL;
31: g_ghr_cpdf_temp.fers_coverage := NULL;
32: g_ghr_cpdf_temp.first_action_la_code1 := NULL;
25: g_ghr_cpdf_temp.employee_date_of_birth := NULL;
26: g_ghr_cpdf_temp.employee_first_name := NULL;
27: g_ghr_cpdf_temp.employee_last_name := NULL;
28: g_ghr_cpdf_temp.employee_middle_names := NULL;
29: g_ghr_cpdf_temp.from_national_identifier := NULL;
30: g_ghr_cpdf_temp.fegli := NULL;
31: g_ghr_cpdf_temp.fers_coverage := NULL;
32: g_ghr_cpdf_temp.first_action_la_code1 := NULL;
33: g_ghr_cpdf_temp.first_action_la_code2 := NULL;
26: g_ghr_cpdf_temp.employee_first_name := NULL;
27: g_ghr_cpdf_temp.employee_last_name := NULL;
28: g_ghr_cpdf_temp.employee_middle_names := NULL;
29: g_ghr_cpdf_temp.from_national_identifier := NULL;
30: g_ghr_cpdf_temp.fegli := NULL;
31: g_ghr_cpdf_temp.fers_coverage := NULL;
32: g_ghr_cpdf_temp.first_action_la_code1 := NULL;
33: g_ghr_cpdf_temp.first_action_la_code2 := NULL;
34: g_ghr_cpdf_temp.first_noa_code := NULL;
27: g_ghr_cpdf_temp.employee_last_name := NULL;
28: g_ghr_cpdf_temp.employee_middle_names := NULL;
29: g_ghr_cpdf_temp.from_national_identifier := NULL;
30: g_ghr_cpdf_temp.fegli := NULL;
31: g_ghr_cpdf_temp.fers_coverage := NULL;
32: g_ghr_cpdf_temp.first_action_la_code1 := NULL;
33: g_ghr_cpdf_temp.first_action_la_code2 := NULL;
34: g_ghr_cpdf_temp.first_noa_code := NULL;
35: g_ghr_cpdf_temp.flsa_category := NULL;
28: g_ghr_cpdf_temp.employee_middle_names := NULL;
29: g_ghr_cpdf_temp.from_national_identifier := NULL;
30: g_ghr_cpdf_temp.fegli := NULL;
31: g_ghr_cpdf_temp.fers_coverage := NULL;
32: g_ghr_cpdf_temp.first_action_la_code1 := NULL;
33: g_ghr_cpdf_temp.first_action_la_code2 := NULL;
34: g_ghr_cpdf_temp.first_noa_code := NULL;
35: g_ghr_cpdf_temp.flsa_category := NULL;
36: g_ghr_cpdf_temp.from_basic_pay := NULL;
29: g_ghr_cpdf_temp.from_national_identifier := NULL;
30: g_ghr_cpdf_temp.fegli := NULL;
31: g_ghr_cpdf_temp.fers_coverage := NULL;
32: g_ghr_cpdf_temp.first_action_la_code1 := NULL;
33: g_ghr_cpdf_temp.first_action_la_code2 := NULL;
34: g_ghr_cpdf_temp.first_noa_code := NULL;
35: g_ghr_cpdf_temp.flsa_category := NULL;
36: g_ghr_cpdf_temp.from_basic_pay := NULL;
37: g_ghr_cpdf_temp.from_duty_station_code := NULL;
30: g_ghr_cpdf_temp.fegli := NULL;
31: g_ghr_cpdf_temp.fers_coverage := NULL;
32: g_ghr_cpdf_temp.first_action_la_code1 := NULL;
33: g_ghr_cpdf_temp.first_action_la_code2 := NULL;
34: g_ghr_cpdf_temp.first_noa_code := NULL;
35: g_ghr_cpdf_temp.flsa_category := NULL;
36: g_ghr_cpdf_temp.from_basic_pay := NULL;
37: g_ghr_cpdf_temp.from_duty_station_code := NULL;
38: g_ghr_cpdf_temp.from_grade_or_level := NULL;
31: g_ghr_cpdf_temp.fers_coverage := NULL;
32: g_ghr_cpdf_temp.first_action_la_code1 := NULL;
33: g_ghr_cpdf_temp.first_action_la_code2 := NULL;
34: g_ghr_cpdf_temp.first_noa_code := NULL;
35: g_ghr_cpdf_temp.flsa_category := NULL;
36: g_ghr_cpdf_temp.from_basic_pay := NULL;
37: g_ghr_cpdf_temp.from_duty_station_code := NULL;
38: g_ghr_cpdf_temp.from_grade_or_level := NULL;
39: g_ghr_cpdf_temp.from_locality_adj := NULL;
32: g_ghr_cpdf_temp.first_action_la_code1 := NULL;
33: g_ghr_cpdf_temp.first_action_la_code2 := NULL;
34: g_ghr_cpdf_temp.first_noa_code := NULL;
35: g_ghr_cpdf_temp.flsa_category := NULL;
36: g_ghr_cpdf_temp.from_basic_pay := NULL;
37: g_ghr_cpdf_temp.from_duty_station_code := NULL;
38: g_ghr_cpdf_temp.from_grade_or_level := NULL;
39: g_ghr_cpdf_temp.from_locality_adj := NULL;
40: g_ghr_cpdf_temp.from_occ_code := NULL;
33: g_ghr_cpdf_temp.first_action_la_code2 := NULL;
34: g_ghr_cpdf_temp.first_noa_code := NULL;
35: g_ghr_cpdf_temp.flsa_category := NULL;
36: g_ghr_cpdf_temp.from_basic_pay := NULL;
37: g_ghr_cpdf_temp.from_duty_station_code := NULL;
38: g_ghr_cpdf_temp.from_grade_or_level := NULL;
39: g_ghr_cpdf_temp.from_locality_adj := NULL;
40: g_ghr_cpdf_temp.from_occ_code := NULL;
41: g_ghr_cpdf_temp.from_pay_table_id := NULL;
34: g_ghr_cpdf_temp.first_noa_code := NULL;
35: g_ghr_cpdf_temp.flsa_category := NULL;
36: g_ghr_cpdf_temp.from_basic_pay := NULL;
37: g_ghr_cpdf_temp.from_duty_station_code := NULL;
38: g_ghr_cpdf_temp.from_grade_or_level := NULL;
39: g_ghr_cpdf_temp.from_locality_adj := NULL;
40: g_ghr_cpdf_temp.from_occ_code := NULL;
41: g_ghr_cpdf_temp.from_pay_table_id := NULL;
42: g_ghr_cpdf_temp.from_pay_basis := NULL;
35: g_ghr_cpdf_temp.flsa_category := NULL;
36: g_ghr_cpdf_temp.from_basic_pay := NULL;
37: g_ghr_cpdf_temp.from_duty_station_code := NULL;
38: g_ghr_cpdf_temp.from_grade_or_level := NULL;
39: g_ghr_cpdf_temp.from_locality_adj := NULL;
40: g_ghr_cpdf_temp.from_occ_code := NULL;
41: g_ghr_cpdf_temp.from_pay_table_id := NULL;
42: g_ghr_cpdf_temp.from_pay_basis := NULL;
43: g_ghr_cpdf_temp.from_pay_plan := NULL;
36: g_ghr_cpdf_temp.from_basic_pay := NULL;
37: g_ghr_cpdf_temp.from_duty_station_code := NULL;
38: g_ghr_cpdf_temp.from_grade_or_level := NULL;
39: g_ghr_cpdf_temp.from_locality_adj := NULL;
40: g_ghr_cpdf_temp.from_occ_code := NULL;
41: g_ghr_cpdf_temp.from_pay_table_id := NULL;
42: g_ghr_cpdf_temp.from_pay_basis := NULL;
43: g_ghr_cpdf_temp.from_pay_plan := NULL;
44: g_ghr_cpdf_temp.from_pay_rate_determinant := NULL;
37: g_ghr_cpdf_temp.from_duty_station_code := NULL;
38: g_ghr_cpdf_temp.from_grade_or_level := NULL;
39: g_ghr_cpdf_temp.from_locality_adj := NULL;
40: g_ghr_cpdf_temp.from_occ_code := NULL;
41: g_ghr_cpdf_temp.from_pay_table_id := NULL;
42: g_ghr_cpdf_temp.from_pay_basis := NULL;
43: g_ghr_cpdf_temp.from_pay_plan := NULL;
44: g_ghr_cpdf_temp.from_pay_rate_determinant := NULL;
45: g_ghr_cpdf_temp.from_retirement_coverage := NULL;
38: g_ghr_cpdf_temp.from_grade_or_level := NULL;
39: g_ghr_cpdf_temp.from_locality_adj := NULL;
40: g_ghr_cpdf_temp.from_occ_code := NULL;
41: g_ghr_cpdf_temp.from_pay_table_id := NULL;
42: g_ghr_cpdf_temp.from_pay_basis := NULL;
43: g_ghr_cpdf_temp.from_pay_plan := NULL;
44: g_ghr_cpdf_temp.from_pay_rate_determinant := NULL;
45: g_ghr_cpdf_temp.from_retirement_coverage := NULL;
46: g_ghr_cpdf_temp.from_step_or_rate := NULL;
39: g_ghr_cpdf_temp.from_locality_adj := NULL;
40: g_ghr_cpdf_temp.from_occ_code := NULL;
41: g_ghr_cpdf_temp.from_pay_table_id := NULL;
42: g_ghr_cpdf_temp.from_pay_basis := NULL;
43: g_ghr_cpdf_temp.from_pay_plan := NULL;
44: g_ghr_cpdf_temp.from_pay_rate_determinant := NULL;
45: g_ghr_cpdf_temp.from_retirement_coverage := NULL;
46: g_ghr_cpdf_temp.from_step_or_rate := NULL;
47: g_ghr_cpdf_temp.from_total_salary := NULL;
40: g_ghr_cpdf_temp.from_occ_code := NULL;
41: g_ghr_cpdf_temp.from_pay_table_id := NULL;
42: g_ghr_cpdf_temp.from_pay_basis := NULL;
43: g_ghr_cpdf_temp.from_pay_plan := NULL;
44: g_ghr_cpdf_temp.from_pay_rate_determinant := NULL;
45: g_ghr_cpdf_temp.from_retirement_coverage := NULL;
46: g_ghr_cpdf_temp.from_step_or_rate := NULL;
47: g_ghr_cpdf_temp.from_total_salary := NULL;
48: g_ghr_cpdf_temp.from_work_schedule := NULL;
41: g_ghr_cpdf_temp.from_pay_table_id := NULL;
42: g_ghr_cpdf_temp.from_pay_basis := NULL;
43: g_ghr_cpdf_temp.from_pay_plan := NULL;
44: g_ghr_cpdf_temp.from_pay_rate_determinant := NULL;
45: g_ghr_cpdf_temp.from_retirement_coverage := NULL;
46: g_ghr_cpdf_temp.from_step_or_rate := NULL;
47: g_ghr_cpdf_temp.from_total_salary := NULL;
48: g_ghr_cpdf_temp.from_work_schedule := NULL;
49: g_ghr_cpdf_temp.frozen_service := NULL;
42: g_ghr_cpdf_temp.from_pay_basis := NULL;
43: g_ghr_cpdf_temp.from_pay_plan := NULL;
44: g_ghr_cpdf_temp.from_pay_rate_determinant := NULL;
45: g_ghr_cpdf_temp.from_retirement_coverage := NULL;
46: g_ghr_cpdf_temp.from_step_or_rate := NULL;
47: g_ghr_cpdf_temp.from_total_salary := NULL;
48: g_ghr_cpdf_temp.from_work_schedule := NULL;
49: g_ghr_cpdf_temp.frozen_service := NULL;
50: g_ghr_cpdf_temp.functional_class := NULL;
43: g_ghr_cpdf_temp.from_pay_plan := NULL;
44: g_ghr_cpdf_temp.from_pay_rate_determinant := NULL;
45: g_ghr_cpdf_temp.from_retirement_coverage := NULL;
46: g_ghr_cpdf_temp.from_step_or_rate := NULL;
47: g_ghr_cpdf_temp.from_total_salary := NULL;
48: g_ghr_cpdf_temp.from_work_schedule := NULL;
49: g_ghr_cpdf_temp.frozen_service := NULL;
50: g_ghr_cpdf_temp.functional_class := NULL;
51: g_ghr_cpdf_temp.handicap_code := NULL;
44: g_ghr_cpdf_temp.from_pay_rate_determinant := NULL;
45: g_ghr_cpdf_temp.from_retirement_coverage := NULL;
46: g_ghr_cpdf_temp.from_step_or_rate := NULL;
47: g_ghr_cpdf_temp.from_total_salary := NULL;
48: g_ghr_cpdf_temp.from_work_schedule := NULL;
49: g_ghr_cpdf_temp.frozen_service := NULL;
50: g_ghr_cpdf_temp.functional_class := NULL;
51: g_ghr_cpdf_temp.handicap_code := NULL;
52: g_ghr_cpdf_temp.health_plan := NULL;
45: g_ghr_cpdf_temp.from_retirement_coverage := NULL;
46: g_ghr_cpdf_temp.from_step_or_rate := NULL;
47: g_ghr_cpdf_temp.from_total_salary := NULL;
48: g_ghr_cpdf_temp.from_work_schedule := NULL;
49: g_ghr_cpdf_temp.frozen_service := NULL;
50: g_ghr_cpdf_temp.functional_class := NULL;
51: g_ghr_cpdf_temp.handicap_code := NULL;
52: g_ghr_cpdf_temp.health_plan := NULL;
53: g_ghr_cpdf_temp.individual_group_award := NULL;
46: g_ghr_cpdf_temp.from_step_or_rate := NULL;
47: g_ghr_cpdf_temp.from_total_salary := NULL;
48: g_ghr_cpdf_temp.from_work_schedule := NULL;
49: g_ghr_cpdf_temp.frozen_service := NULL;
50: g_ghr_cpdf_temp.functional_class := NULL;
51: g_ghr_cpdf_temp.handicap_code := NULL;
52: g_ghr_cpdf_temp.health_plan := NULL;
53: g_ghr_cpdf_temp.individual_group_award := NULL;
54: g_ghr_cpdf_temp.organizational_component := NULL;
47: g_ghr_cpdf_temp.from_total_salary := NULL;
48: g_ghr_cpdf_temp.from_work_schedule := NULL;
49: g_ghr_cpdf_temp.frozen_service := NULL;
50: g_ghr_cpdf_temp.functional_class := NULL;
51: g_ghr_cpdf_temp.handicap_code := NULL;
52: g_ghr_cpdf_temp.health_plan := NULL;
53: g_ghr_cpdf_temp.individual_group_award := NULL;
54: g_ghr_cpdf_temp.organizational_component := NULL;
55: g_ghr_cpdf_temp.pay_status := NULL;
48: g_ghr_cpdf_temp.from_work_schedule := NULL;
49: g_ghr_cpdf_temp.frozen_service := NULL;
50: g_ghr_cpdf_temp.functional_class := NULL;
51: g_ghr_cpdf_temp.handicap_code := NULL;
52: g_ghr_cpdf_temp.health_plan := NULL;
53: g_ghr_cpdf_temp.individual_group_award := NULL;
54: g_ghr_cpdf_temp.organizational_component := NULL;
55: g_ghr_cpdf_temp.pay_status := NULL;
56: g_ghr_cpdf_temp.personnel_office_id := NULL;
49: g_ghr_cpdf_temp.frozen_service := NULL;
50: g_ghr_cpdf_temp.functional_class := NULL;
51: g_ghr_cpdf_temp.handicap_code := NULL;
52: g_ghr_cpdf_temp.health_plan := NULL;
53: g_ghr_cpdf_temp.individual_group_award := NULL;
54: g_ghr_cpdf_temp.organizational_component := NULL;
55: g_ghr_cpdf_temp.pay_status := NULL;
56: g_ghr_cpdf_temp.personnel_office_id := NULL;
57: g_ghr_cpdf_temp.position_occupied := NULL;
50: g_ghr_cpdf_temp.functional_class := NULL;
51: g_ghr_cpdf_temp.handicap_code := NULL;
52: g_ghr_cpdf_temp.health_plan := NULL;
53: g_ghr_cpdf_temp.individual_group_award := NULL;
54: g_ghr_cpdf_temp.organizational_component := NULL;
55: g_ghr_cpdf_temp.pay_status := NULL;
56: g_ghr_cpdf_temp.personnel_office_id := NULL;
57: g_ghr_cpdf_temp.position_occupied := NULL;
58: g_ghr_cpdf_temp.race_national_origin := NULL;
51: g_ghr_cpdf_temp.handicap_code := NULL;
52: g_ghr_cpdf_temp.health_plan := NULL;
53: g_ghr_cpdf_temp.individual_group_award := NULL;
54: g_ghr_cpdf_temp.organizational_component := NULL;
55: g_ghr_cpdf_temp.pay_status := NULL;
56: g_ghr_cpdf_temp.personnel_office_id := NULL;
57: g_ghr_cpdf_temp.position_occupied := NULL;
58: g_ghr_cpdf_temp.race_national_origin := NULL;
59: g_ghr_cpdf_temp.rating_of_record := NULL;
52: g_ghr_cpdf_temp.health_plan := NULL;
53: g_ghr_cpdf_temp.individual_group_award := NULL;
54: g_ghr_cpdf_temp.organizational_component := NULL;
55: g_ghr_cpdf_temp.pay_status := NULL;
56: g_ghr_cpdf_temp.personnel_office_id := NULL;
57: g_ghr_cpdf_temp.position_occupied := NULL;
58: g_ghr_cpdf_temp.race_national_origin := NULL;
59: g_ghr_cpdf_temp.rating_of_record := NULL;
60: g_ghr_cpdf_temp.rating_of_record_level := NULL;
53: g_ghr_cpdf_temp.individual_group_award := NULL;
54: g_ghr_cpdf_temp.organizational_component := NULL;
55: g_ghr_cpdf_temp.pay_status := NULL;
56: g_ghr_cpdf_temp.personnel_office_id := NULL;
57: g_ghr_cpdf_temp.position_occupied := NULL;
58: g_ghr_cpdf_temp.race_national_origin := NULL;
59: g_ghr_cpdf_temp.rating_of_record := NULL;
60: g_ghr_cpdf_temp.rating_of_record_level := NULL;
61: g_ghr_cpdf_temp.rating_of_record_pattern := NULL;
54: g_ghr_cpdf_temp.organizational_component := NULL;
55: g_ghr_cpdf_temp.pay_status := NULL;
56: g_ghr_cpdf_temp.personnel_office_id := NULL;
57: g_ghr_cpdf_temp.position_occupied := NULL;
58: g_ghr_cpdf_temp.race_national_origin := NULL;
59: g_ghr_cpdf_temp.rating_of_record := NULL;
60: g_ghr_cpdf_temp.rating_of_record_level := NULL;
61: g_ghr_cpdf_temp.rating_of_record_pattern := NULL;
62: g_ghr_cpdf_temp.rating_of_record_period_ends := NULL;
55: g_ghr_cpdf_temp.pay_status := NULL;
56: g_ghr_cpdf_temp.personnel_office_id := NULL;
57: g_ghr_cpdf_temp.position_occupied := NULL;
58: g_ghr_cpdf_temp.race_national_origin := NULL;
59: g_ghr_cpdf_temp.rating_of_record := NULL;
60: g_ghr_cpdf_temp.rating_of_record_level := NULL;
61: g_ghr_cpdf_temp.rating_of_record_pattern := NULL;
62: g_ghr_cpdf_temp.rating_of_record_period_ends := NULL;
63: g_ghr_cpdf_temp.retained_grade_or_level := NULL;
56: g_ghr_cpdf_temp.personnel_office_id := NULL;
57: g_ghr_cpdf_temp.position_occupied := NULL;
58: g_ghr_cpdf_temp.race_national_origin := NULL;
59: g_ghr_cpdf_temp.rating_of_record := NULL;
60: g_ghr_cpdf_temp.rating_of_record_level := NULL;
61: g_ghr_cpdf_temp.rating_of_record_pattern := NULL;
62: g_ghr_cpdf_temp.rating_of_record_period_ends := NULL;
63: g_ghr_cpdf_temp.retained_grade_or_level := NULL;
64: g_ghr_cpdf_temp.retained_pay_plan := NULL;
57: g_ghr_cpdf_temp.position_occupied := NULL;
58: g_ghr_cpdf_temp.race_national_origin := NULL;
59: g_ghr_cpdf_temp.rating_of_record := NULL;
60: g_ghr_cpdf_temp.rating_of_record_level := NULL;
61: g_ghr_cpdf_temp.rating_of_record_pattern := NULL;
62: g_ghr_cpdf_temp.rating_of_record_period_ends := NULL;
63: g_ghr_cpdf_temp.retained_grade_or_level := NULL;
64: g_ghr_cpdf_temp.retained_pay_plan := NULL;
65: g_ghr_cpdf_temp.retained_step_or_rate := NULL;
58: g_ghr_cpdf_temp.race_national_origin := NULL;
59: g_ghr_cpdf_temp.rating_of_record := NULL;
60: g_ghr_cpdf_temp.rating_of_record_level := NULL;
61: g_ghr_cpdf_temp.rating_of_record_pattern := NULL;
62: g_ghr_cpdf_temp.rating_of_record_period_ends := NULL;
63: g_ghr_cpdf_temp.retained_grade_or_level := NULL;
64: g_ghr_cpdf_temp.retained_pay_plan := NULL;
65: g_ghr_cpdf_temp.retained_step_or_rate := NULL;
66: g_ghr_cpdf_temp.retirement_plan := NULL;
59: g_ghr_cpdf_temp.rating_of_record := NULL;
60: g_ghr_cpdf_temp.rating_of_record_level := NULL;
61: g_ghr_cpdf_temp.rating_of_record_pattern := NULL;
62: g_ghr_cpdf_temp.rating_of_record_period_ends := NULL;
63: g_ghr_cpdf_temp.retained_grade_or_level := NULL;
64: g_ghr_cpdf_temp.retained_pay_plan := NULL;
65: g_ghr_cpdf_temp.retained_step_or_rate := NULL;
66: g_ghr_cpdf_temp.retirement_plan := NULL;
67: g_ghr_cpdf_temp.second_noa_code := NULL;
60: g_ghr_cpdf_temp.rating_of_record_level := NULL;
61: g_ghr_cpdf_temp.rating_of_record_pattern := NULL;
62: g_ghr_cpdf_temp.rating_of_record_period_ends := NULL;
63: g_ghr_cpdf_temp.retained_grade_or_level := NULL;
64: g_ghr_cpdf_temp.retained_pay_plan := NULL;
65: g_ghr_cpdf_temp.retained_step_or_rate := NULL;
66: g_ghr_cpdf_temp.retirement_plan := NULL;
67: g_ghr_cpdf_temp.second_noa_code := NULL;
68: g_ghr_cpdf_temp.service_comp_date := NULL;
61: g_ghr_cpdf_temp.rating_of_record_pattern := NULL;
62: g_ghr_cpdf_temp.rating_of_record_period_ends := NULL;
63: g_ghr_cpdf_temp.retained_grade_or_level := NULL;
64: g_ghr_cpdf_temp.retained_pay_plan := NULL;
65: g_ghr_cpdf_temp.retained_step_or_rate := NULL;
66: g_ghr_cpdf_temp.retirement_plan := NULL;
67: g_ghr_cpdf_temp.second_noa_code := NULL;
68: g_ghr_cpdf_temp.service_comp_date := NULL;
69: g_ghr_cpdf_temp.sex := NULL;
62: g_ghr_cpdf_temp.rating_of_record_period_ends := NULL;
63: g_ghr_cpdf_temp.retained_grade_or_level := NULL;
64: g_ghr_cpdf_temp.retained_pay_plan := NULL;
65: g_ghr_cpdf_temp.retained_step_or_rate := NULL;
66: g_ghr_cpdf_temp.retirement_plan := NULL;
67: g_ghr_cpdf_temp.second_noa_code := NULL;
68: g_ghr_cpdf_temp.service_comp_date := NULL;
69: g_ghr_cpdf_temp.sex := NULL;
70: g_ghr_cpdf_temp.supervisory_status := NULL;
63: g_ghr_cpdf_temp.retained_grade_or_level := NULL;
64: g_ghr_cpdf_temp.retained_pay_plan := NULL;
65: g_ghr_cpdf_temp.retained_step_or_rate := NULL;
66: g_ghr_cpdf_temp.retirement_plan := NULL;
67: g_ghr_cpdf_temp.second_noa_code := NULL;
68: g_ghr_cpdf_temp.service_comp_date := NULL;
69: g_ghr_cpdf_temp.sex := NULL;
70: g_ghr_cpdf_temp.supervisory_status := NULL;
71: g_ghr_cpdf_temp.tenure := NULL;
64: g_ghr_cpdf_temp.retained_pay_plan := NULL;
65: g_ghr_cpdf_temp.retained_step_or_rate := NULL;
66: g_ghr_cpdf_temp.retirement_plan := NULL;
67: g_ghr_cpdf_temp.second_noa_code := NULL;
68: g_ghr_cpdf_temp.service_comp_date := NULL;
69: g_ghr_cpdf_temp.sex := NULL;
70: g_ghr_cpdf_temp.supervisory_status := NULL;
71: g_ghr_cpdf_temp.tenure := NULL;
72: g_ghr_cpdf_temp.to_basic_pay := NULL;
65: g_ghr_cpdf_temp.retained_step_or_rate := NULL;
66: g_ghr_cpdf_temp.retirement_plan := NULL;
67: g_ghr_cpdf_temp.second_noa_code := NULL;
68: g_ghr_cpdf_temp.service_comp_date := NULL;
69: g_ghr_cpdf_temp.sex := NULL;
70: g_ghr_cpdf_temp.supervisory_status := NULL;
71: g_ghr_cpdf_temp.tenure := NULL;
72: g_ghr_cpdf_temp.to_basic_pay := NULL;
73: g_ghr_cpdf_temp.to_grade_or_level := NULL;
66: g_ghr_cpdf_temp.retirement_plan := NULL;
67: g_ghr_cpdf_temp.second_noa_code := NULL;
68: g_ghr_cpdf_temp.service_comp_date := NULL;
69: g_ghr_cpdf_temp.sex := NULL;
70: g_ghr_cpdf_temp.supervisory_status := NULL;
71: g_ghr_cpdf_temp.tenure := NULL;
72: g_ghr_cpdf_temp.to_basic_pay := NULL;
73: g_ghr_cpdf_temp.to_grade_or_level := NULL;
74: g_ghr_cpdf_temp.to_locality_adj := NULL;
67: g_ghr_cpdf_temp.second_noa_code := NULL;
68: g_ghr_cpdf_temp.service_comp_date := NULL;
69: g_ghr_cpdf_temp.sex := NULL;
70: g_ghr_cpdf_temp.supervisory_status := NULL;
71: g_ghr_cpdf_temp.tenure := NULL;
72: g_ghr_cpdf_temp.to_basic_pay := NULL;
73: g_ghr_cpdf_temp.to_grade_or_level := NULL;
74: g_ghr_cpdf_temp.to_locality_adj := NULL;
75: g_ghr_cpdf_temp.to_national_identifier := NULL;
68: g_ghr_cpdf_temp.service_comp_date := NULL;
69: g_ghr_cpdf_temp.sex := NULL;
70: g_ghr_cpdf_temp.supervisory_status := NULL;
71: g_ghr_cpdf_temp.tenure := NULL;
72: g_ghr_cpdf_temp.to_basic_pay := NULL;
73: g_ghr_cpdf_temp.to_grade_or_level := NULL;
74: g_ghr_cpdf_temp.to_locality_adj := NULL;
75: g_ghr_cpdf_temp.to_national_identifier := NULL;
76: g_ghr_cpdf_temp.to_occ_code := NULL;
69: g_ghr_cpdf_temp.sex := NULL;
70: g_ghr_cpdf_temp.supervisory_status := NULL;
71: g_ghr_cpdf_temp.tenure := NULL;
72: g_ghr_cpdf_temp.to_basic_pay := NULL;
73: g_ghr_cpdf_temp.to_grade_or_level := NULL;
74: g_ghr_cpdf_temp.to_locality_adj := NULL;
75: g_ghr_cpdf_temp.to_national_identifier := NULL;
76: g_ghr_cpdf_temp.to_occ_code := NULL;
77: g_ghr_cpdf_temp.to_pay_basis := NULL;
70: g_ghr_cpdf_temp.supervisory_status := NULL;
71: g_ghr_cpdf_temp.tenure := NULL;
72: g_ghr_cpdf_temp.to_basic_pay := NULL;
73: g_ghr_cpdf_temp.to_grade_or_level := NULL;
74: g_ghr_cpdf_temp.to_locality_adj := NULL;
75: g_ghr_cpdf_temp.to_national_identifier := NULL;
76: g_ghr_cpdf_temp.to_occ_code := NULL;
77: g_ghr_cpdf_temp.to_pay_basis := NULL;
78: g_ghr_cpdf_temp.to_pay_plan := NULL;
71: g_ghr_cpdf_temp.tenure := NULL;
72: g_ghr_cpdf_temp.to_basic_pay := NULL;
73: g_ghr_cpdf_temp.to_grade_or_level := NULL;
74: g_ghr_cpdf_temp.to_locality_adj := NULL;
75: g_ghr_cpdf_temp.to_national_identifier := NULL;
76: g_ghr_cpdf_temp.to_occ_code := NULL;
77: g_ghr_cpdf_temp.to_pay_basis := NULL;
78: g_ghr_cpdf_temp.to_pay_plan := NULL;
79: g_ghr_cpdf_temp.to_pay_rate_determinant := NULL;
72: g_ghr_cpdf_temp.to_basic_pay := NULL;
73: g_ghr_cpdf_temp.to_grade_or_level := NULL;
74: g_ghr_cpdf_temp.to_locality_adj := NULL;
75: g_ghr_cpdf_temp.to_national_identifier := NULL;
76: g_ghr_cpdf_temp.to_occ_code := NULL;
77: g_ghr_cpdf_temp.to_pay_basis := NULL;
78: g_ghr_cpdf_temp.to_pay_plan := NULL;
79: g_ghr_cpdf_temp.to_pay_rate_determinant := NULL;
80: g_ghr_cpdf_temp.to_pay_table_id := NULL;
73: g_ghr_cpdf_temp.to_grade_or_level := NULL;
74: g_ghr_cpdf_temp.to_locality_adj := NULL;
75: g_ghr_cpdf_temp.to_national_identifier := NULL;
76: g_ghr_cpdf_temp.to_occ_code := NULL;
77: g_ghr_cpdf_temp.to_pay_basis := NULL;
78: g_ghr_cpdf_temp.to_pay_plan := NULL;
79: g_ghr_cpdf_temp.to_pay_rate_determinant := NULL;
80: g_ghr_cpdf_temp.to_pay_table_id := NULL;
81: g_ghr_cpdf_temp.to_retention_allowance := NULL;
74: g_ghr_cpdf_temp.to_locality_adj := NULL;
75: g_ghr_cpdf_temp.to_national_identifier := NULL;
76: g_ghr_cpdf_temp.to_occ_code := NULL;
77: g_ghr_cpdf_temp.to_pay_basis := NULL;
78: g_ghr_cpdf_temp.to_pay_plan := NULL;
79: g_ghr_cpdf_temp.to_pay_rate_determinant := NULL;
80: g_ghr_cpdf_temp.to_pay_table_id := NULL;
81: g_ghr_cpdf_temp.to_retention_allowance := NULL;
82: g_ghr_cpdf_temp.to_staffing_differential := NULL;
75: g_ghr_cpdf_temp.to_national_identifier := NULL;
76: g_ghr_cpdf_temp.to_occ_code := NULL;
77: g_ghr_cpdf_temp.to_pay_basis := NULL;
78: g_ghr_cpdf_temp.to_pay_plan := NULL;
79: g_ghr_cpdf_temp.to_pay_rate_determinant := NULL;
80: g_ghr_cpdf_temp.to_pay_table_id := NULL;
81: g_ghr_cpdf_temp.to_retention_allowance := NULL;
82: g_ghr_cpdf_temp.to_staffing_differential := NULL;
83: g_ghr_cpdf_temp.to_step_or_rate := NULL;
76: g_ghr_cpdf_temp.to_occ_code := NULL;
77: g_ghr_cpdf_temp.to_pay_basis := NULL;
78: g_ghr_cpdf_temp.to_pay_plan := NULL;
79: g_ghr_cpdf_temp.to_pay_rate_determinant := NULL;
80: g_ghr_cpdf_temp.to_pay_table_id := NULL;
81: g_ghr_cpdf_temp.to_retention_allowance := NULL;
82: g_ghr_cpdf_temp.to_staffing_differential := NULL;
83: g_ghr_cpdf_temp.to_step_or_rate := NULL;
84: g_ghr_cpdf_temp.to_supervisory_differential := NULL;
77: g_ghr_cpdf_temp.to_pay_basis := NULL;
78: g_ghr_cpdf_temp.to_pay_plan := NULL;
79: g_ghr_cpdf_temp.to_pay_rate_determinant := NULL;
80: g_ghr_cpdf_temp.to_pay_table_id := NULL;
81: g_ghr_cpdf_temp.to_retention_allowance := NULL;
82: g_ghr_cpdf_temp.to_staffing_differential := NULL;
83: g_ghr_cpdf_temp.to_step_or_rate := NULL;
84: g_ghr_cpdf_temp.to_supervisory_differential := NULL;
85: g_ghr_cpdf_temp.to_total_salary := NULL;
78: g_ghr_cpdf_temp.to_pay_plan := NULL;
79: g_ghr_cpdf_temp.to_pay_rate_determinant := NULL;
80: g_ghr_cpdf_temp.to_pay_table_id := NULL;
81: g_ghr_cpdf_temp.to_retention_allowance := NULL;
82: g_ghr_cpdf_temp.to_staffing_differential := NULL;
83: g_ghr_cpdf_temp.to_step_or_rate := NULL;
84: g_ghr_cpdf_temp.to_supervisory_differential := NULL;
85: g_ghr_cpdf_temp.to_total_salary := NULL;
86: g_ghr_cpdf_temp.to_work_schedule := NULL;
79: g_ghr_cpdf_temp.to_pay_rate_determinant := NULL;
80: g_ghr_cpdf_temp.to_pay_table_id := NULL;
81: g_ghr_cpdf_temp.to_retention_allowance := NULL;
82: g_ghr_cpdf_temp.to_staffing_differential := NULL;
83: g_ghr_cpdf_temp.to_step_or_rate := NULL;
84: g_ghr_cpdf_temp.to_supervisory_differential := NULL;
85: g_ghr_cpdf_temp.to_total_salary := NULL;
86: g_ghr_cpdf_temp.to_work_schedule := NULL;
87: g_ghr_cpdf_temp.veterans_preference := NULL;
80: g_ghr_cpdf_temp.to_pay_table_id := NULL;
81: g_ghr_cpdf_temp.to_retention_allowance := NULL;
82: g_ghr_cpdf_temp.to_staffing_differential := NULL;
83: g_ghr_cpdf_temp.to_step_or_rate := NULL;
84: g_ghr_cpdf_temp.to_supervisory_differential := NULL;
85: g_ghr_cpdf_temp.to_total_salary := NULL;
86: g_ghr_cpdf_temp.to_work_schedule := NULL;
87: g_ghr_cpdf_temp.veterans_preference := NULL;
88: g_ghr_cpdf_temp.veterans_status := NULL;
81: g_ghr_cpdf_temp.to_retention_allowance := NULL;
82: g_ghr_cpdf_temp.to_staffing_differential := NULL;
83: g_ghr_cpdf_temp.to_step_or_rate := NULL;
84: g_ghr_cpdf_temp.to_supervisory_differential := NULL;
85: g_ghr_cpdf_temp.to_total_salary := NULL;
86: g_ghr_cpdf_temp.to_work_schedule := NULL;
87: g_ghr_cpdf_temp.veterans_preference := NULL;
88: g_ghr_cpdf_temp.veterans_status := NULL;
89: g_ghr_cpdf_temp.year_degree_attained := NULL;
82: g_ghr_cpdf_temp.to_staffing_differential := NULL;
83: g_ghr_cpdf_temp.to_step_or_rate := NULL;
84: g_ghr_cpdf_temp.to_supervisory_differential := NULL;
85: g_ghr_cpdf_temp.to_total_salary := NULL;
86: g_ghr_cpdf_temp.to_work_schedule := NULL;
87: g_ghr_cpdf_temp.veterans_preference := NULL;
88: g_ghr_cpdf_temp.veterans_status := NULL;
89: g_ghr_cpdf_temp.year_degree_attained := NULL;
90:
83: g_ghr_cpdf_temp.to_step_or_rate := NULL;
84: g_ghr_cpdf_temp.to_supervisory_differential := NULL;
85: g_ghr_cpdf_temp.to_total_salary := NULL;
86: g_ghr_cpdf_temp.to_work_schedule := NULL;
87: g_ghr_cpdf_temp.veterans_preference := NULL;
88: g_ghr_cpdf_temp.veterans_status := NULL;
89: g_ghr_cpdf_temp.year_degree_attained := NULL;
90:
91: g_duty_station_id := NULL;
84: g_ghr_cpdf_temp.to_supervisory_differential := NULL;
85: g_ghr_cpdf_temp.to_total_salary := NULL;
86: g_ghr_cpdf_temp.to_work_schedule := NULL;
87: g_ghr_cpdf_temp.veterans_preference := NULL;
88: g_ghr_cpdf_temp.veterans_status := NULL;
89: g_ghr_cpdf_temp.year_degree_attained := NULL;
90:
91: g_duty_station_id := NULL;
92: g_ghr_cpdf_temp.SCD_retirement := NULL;
85: g_ghr_cpdf_temp.to_total_salary := NULL;
86: g_ghr_cpdf_temp.to_work_schedule := NULL;
87: g_ghr_cpdf_temp.veterans_preference := NULL;
88: g_ghr_cpdf_temp.veterans_status := NULL;
89: g_ghr_cpdf_temp.year_degree_attained := NULL;
90:
91: g_duty_station_id := NULL;
92: g_ghr_cpdf_temp.SCD_retirement := NULL;
93: g_ghr_cpdf_temp.SCD_rif := NULL;
88: g_ghr_cpdf_temp.veterans_status := NULL;
89: g_ghr_cpdf_temp.year_degree_attained := NULL;
90:
91: g_duty_station_id := NULL;
92: g_ghr_cpdf_temp.SCD_retirement := NULL;
93: g_ghr_cpdf_temp.SCD_rif := NULL;
94: g_ghr_cpdf_temp.position_title := NULL;
95: g_ghr_cpdf_temp.name_title := NULL;
96:
89: g_ghr_cpdf_temp.year_degree_attained := NULL;
90:
91: g_duty_station_id := NULL;
92: g_ghr_cpdf_temp.SCD_retirement := NULL;
93: g_ghr_cpdf_temp.SCD_rif := NULL;
94: g_ghr_cpdf_temp.position_title := NULL;
95: g_ghr_cpdf_temp.name_title := NULL;
96:
97: END initialize_record;
90:
91: g_duty_station_id := NULL;
92: g_ghr_cpdf_temp.SCD_retirement := NULL;
93: g_ghr_cpdf_temp.SCD_rif := NULL;
94: g_ghr_cpdf_temp.position_title := NULL;
95: g_ghr_cpdf_temp.name_title := NULL;
96:
97: END initialize_record;
98:
91: g_duty_station_id := NULL;
92: g_ghr_cpdf_temp.SCD_retirement := NULL;
93: g_ghr_cpdf_temp.SCD_rif := NULL;
94: g_ghr_cpdf_temp.position_title := NULL;
95: g_ghr_cpdf_temp.name_title := NULL;
96:
97: END initialize_record;
98:
99: PROCEDURE cleanup_table
100: IS
101: l_proc varchar2(30) := 'cleanup_table';
102: BEGIN
103: hr_utility.set_location('Entering:'||l_proc,5);
104: DELETE FROM ghr_cpdf_temp
105: WHERE report_type = 'STATUS'
106: AND session_id = userenv('SESSIONID')
107: ;
108: END cleanup_table;
162: PROCEDURE get_from_history_asgnei
163: (
164: p_sr_assignment_id IN NUMBER
165: ,p_sr_report_date IN DATE
166: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
167: )
168: IS
169: l_proc varchar2(30) := 'get_from_history_asgnei';
170: l_ASGNEI_DATA PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;
181: p_information_type => 'GHR_US_ASG_SF52',
182: p_date_effective => p_sr_report_date,
183: p_asg_ei_data => l_ASGNEI_DATA
184: );
185: p_sr_ghr_cpdf_temp.annuitant_indicator := l_ASGNEI_DATA.AEI_INFORMATION5;
186: p_sr_ghr_cpdf_temp.to_step_or_rate := l_ASGNEI_DATA.AEI_INFORMATION3;
187: p_sr_ghr_cpdf_temp.to_pay_rate_determinant := l_ASGNEI_DATA.AEI_INFORMATION6;
188: p_sr_ghr_cpdf_temp.tenure := l_ASGNEI_DATA.AEI_INFORMATION4;
189: p_sr_ghr_cpdf_temp.to_work_schedule := l_ASGNEI_DATA.AEI_INFORMATION7;
182: p_date_effective => p_sr_report_date,
183: p_asg_ei_data => l_ASGNEI_DATA
184: );
185: p_sr_ghr_cpdf_temp.annuitant_indicator := l_ASGNEI_DATA.AEI_INFORMATION5;
186: p_sr_ghr_cpdf_temp.to_step_or_rate := l_ASGNEI_DATA.AEI_INFORMATION3;
187: p_sr_ghr_cpdf_temp.to_pay_rate_determinant := l_ASGNEI_DATA.AEI_INFORMATION6;
188: p_sr_ghr_cpdf_temp.tenure := l_ASGNEI_DATA.AEI_INFORMATION4;
189: p_sr_ghr_cpdf_temp.to_work_schedule := l_ASGNEI_DATA.AEI_INFORMATION7;
190: -- FWFA Changes Get pay table id also
183: p_asg_ei_data => l_ASGNEI_DATA
184: );
185: p_sr_ghr_cpdf_temp.annuitant_indicator := l_ASGNEI_DATA.AEI_INFORMATION5;
186: p_sr_ghr_cpdf_temp.to_step_or_rate := l_ASGNEI_DATA.AEI_INFORMATION3;
187: p_sr_ghr_cpdf_temp.to_pay_rate_determinant := l_ASGNEI_DATA.AEI_INFORMATION6;
188: p_sr_ghr_cpdf_temp.tenure := l_ASGNEI_DATA.AEI_INFORMATION4;
189: p_sr_ghr_cpdf_temp.to_work_schedule := l_ASGNEI_DATA.AEI_INFORMATION7;
190: -- FWFA Changes Get pay table id also
191: p_sr_ghr_cpdf_temp.to_pay_table_id := l_ASGNEI_DATA.AEI_INFORMATION9;
184: );
185: p_sr_ghr_cpdf_temp.annuitant_indicator := l_ASGNEI_DATA.AEI_INFORMATION5;
186: p_sr_ghr_cpdf_temp.to_step_or_rate := l_ASGNEI_DATA.AEI_INFORMATION3;
187: p_sr_ghr_cpdf_temp.to_pay_rate_determinant := l_ASGNEI_DATA.AEI_INFORMATION6;
188: p_sr_ghr_cpdf_temp.tenure := l_ASGNEI_DATA.AEI_INFORMATION4;
189: p_sr_ghr_cpdf_temp.to_work_schedule := l_ASGNEI_DATA.AEI_INFORMATION7;
190: -- FWFA Changes Get pay table id also
191: p_sr_ghr_cpdf_temp.to_pay_table_id := l_ASGNEI_DATA.AEI_INFORMATION9;
192: -- FWFA Changes
185: p_sr_ghr_cpdf_temp.annuitant_indicator := l_ASGNEI_DATA.AEI_INFORMATION5;
186: p_sr_ghr_cpdf_temp.to_step_or_rate := l_ASGNEI_DATA.AEI_INFORMATION3;
187: p_sr_ghr_cpdf_temp.to_pay_rate_determinant := l_ASGNEI_DATA.AEI_INFORMATION6;
188: p_sr_ghr_cpdf_temp.tenure := l_ASGNEI_DATA.AEI_INFORMATION4;
189: p_sr_ghr_cpdf_temp.to_work_schedule := l_ASGNEI_DATA.AEI_INFORMATION7;
190: -- FWFA Changes Get pay table id also
191: p_sr_ghr_cpdf_temp.to_pay_table_id := l_ASGNEI_DATA.AEI_INFORMATION9;
192: -- FWFA Changes
193:
187: p_sr_ghr_cpdf_temp.to_pay_rate_determinant := l_ASGNEI_DATA.AEI_INFORMATION6;
188: p_sr_ghr_cpdf_temp.tenure := l_ASGNEI_DATA.AEI_INFORMATION4;
189: p_sr_ghr_cpdf_temp.to_work_schedule := l_ASGNEI_DATA.AEI_INFORMATION7;
190: -- FWFA Changes Get pay table id also
191: p_sr_ghr_cpdf_temp.to_pay_table_id := l_ASGNEI_DATA.AEI_INFORMATION9;
192: -- FWFA Changes
193:
194: END get_from_history_asgnei;
195:
197: PROCEDURE get_from_history_people
198: (
199: p_sr_person_id IN NUMBER
200: ,p_sr_report_date IN DATE
201: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
202: )
203: IS
204: l_proc varchar2(30) := 'get_from_history_people';
205: CURSOR PEOPLE_CUR IS
220: FETCH PEOPLE_CUR INTO l_PEOPLE_REC;
221:
222: IF PEOPLE_CUR%FOUND
223: THEN
224: p_sr_ghr_cpdf_temp.sex := l_PEOPLE_REC.SEX;
225: p_sr_ghr_cpdf_temp.employee_date_of_birth := l_PEOPLE_REC.DATE_OF_BIRTH;
226: p_sr_ghr_cpdf_temp.to_national_identifier :=
227: SUBSTR(l_PEOPLE_REC.NATIONAL_IDENTIFIER,1,3) ||
228: SUBSTR(l_PEOPLE_REC.NATIONAL_IDENTIFIER,5,2) ||
221:
222: IF PEOPLE_CUR%FOUND
223: THEN
224: p_sr_ghr_cpdf_temp.sex := l_PEOPLE_REC.SEX;
225: p_sr_ghr_cpdf_temp.employee_date_of_birth := l_PEOPLE_REC.DATE_OF_BIRTH;
226: p_sr_ghr_cpdf_temp.to_national_identifier :=
227: SUBSTR(l_PEOPLE_REC.NATIONAL_IDENTIFIER,1,3) ||
228: SUBSTR(l_PEOPLE_REC.NATIONAL_IDENTIFIER,5,2) ||
229: SUBSTR(l_PEOPLE_REC.NATIONAL_IDENTIFIER,8,4);
222: IF PEOPLE_CUR%FOUND
223: THEN
224: p_sr_ghr_cpdf_temp.sex := l_PEOPLE_REC.SEX;
225: p_sr_ghr_cpdf_temp.employee_date_of_birth := l_PEOPLE_REC.DATE_OF_BIRTH;
226: p_sr_ghr_cpdf_temp.to_national_identifier :=
227: SUBSTR(l_PEOPLE_REC.NATIONAL_IDENTIFIER,1,3) ||
228: SUBSTR(l_PEOPLE_REC.NATIONAL_IDENTIFIER,5,2) ||
229: SUBSTR(l_PEOPLE_REC.NATIONAL_IDENTIFIER,8,4);
230: END IF;
236: PROCEDURE get_from_history_ancrit
237: (
238: p_sr_person_id IN NUMBER
239: ,p_sr_report_date IN DATE
240: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
241: )
242: IS
243: l_proc varchar2(30) := 'get_from_history_ancrit';
244: l_ANCRIT_REC ghr_api.special_information_type;
257: g_message_name := 'Special Info: Education Dtls';
258: -- End Bug# 4168162
259: ghr_api.return_education_details(p_person_id => p_sr_person_id,
260: p_effective_date => p_sr_report_date,
261: p_education_level => p_sr_ghr_cpdf_temp.education_level,
262: p_academic_discipline => p_sr_ghr_cpdf_temp.academic_discipline,
263: p_year_degree_attained => p_sr_ghr_cpdf_temp.year_degree_attained);
264:
265: -- Begin Bug# 4168162
258: -- End Bug# 4168162
259: ghr_api.return_education_details(p_person_id => p_sr_person_id,
260: p_effective_date => p_sr_report_date,
261: p_education_level => p_sr_ghr_cpdf_temp.education_level,
262: p_academic_discipline => p_sr_ghr_cpdf_temp.academic_discipline,
263: p_year_degree_attained => p_sr_ghr_cpdf_temp.year_degree_attained);
264:
265: -- Begin Bug# 4168162
266: g_message_name := 'Special Info: Perf Appraisal';
259: ghr_api.return_education_details(p_person_id => p_sr_person_id,
260: p_effective_date => p_sr_report_date,
261: p_education_level => p_sr_ghr_cpdf_temp.education_level,
262: p_academic_discipline => p_sr_ghr_cpdf_temp.academic_discipline,
263: p_year_degree_attained => p_sr_ghr_cpdf_temp.year_degree_attained);
264:
265: -- Begin Bug# 4168162
266: g_message_name := 'Special Info: Perf Appraisal';
267: -- End Bug# 4168162
266: g_message_name := 'Special Info: Perf Appraisal';
267: -- End Bug# 4168162
268: ghr_cpdf_dynrpt.get_per_sit_perf_appraisal(p_sr_person_id
269: ,p_sr_report_date
270: ,p_sr_ghr_cpdf_temp.rating_of_record_level
271: ,p_sr_ghr_cpdf_temp.rating_of_record_pattern
272: ,p_sr_ghr_cpdf_temp.rating_of_record_period_ends);
273:
274: /***** Commented 2003405
267: -- End Bug# 4168162
268: ghr_cpdf_dynrpt.get_per_sit_perf_appraisal(p_sr_person_id
269: ,p_sr_report_date
270: ,p_sr_ghr_cpdf_temp.rating_of_record_level
271: ,p_sr_ghr_cpdf_temp.rating_of_record_pattern
272: ,p_sr_ghr_cpdf_temp.rating_of_record_period_ends);
273:
274: /***** Commented 2003405
275: ghr_api.return_special_information(p_person_id => p_sr_person_id,
268: ghr_cpdf_dynrpt.get_per_sit_perf_appraisal(p_sr_person_id
269: ,p_sr_report_date
270: ,p_sr_ghr_cpdf_temp.rating_of_record_level
271: ,p_sr_ghr_cpdf_temp.rating_of_record_pattern
272: ,p_sr_ghr_cpdf_temp.rating_of_record_period_ends);
273:
274: /***** Commented 2003405
275: ghr_api.return_special_information(p_person_id => p_sr_person_id,
276: p_structure_name => 'US Fed Perf Appraisal',
277: p_effective_date => p_sr_report_date,
278: p_special_info => l_ancrit_rec);
279:
280: IF l_ancrit_rec.object_version_number IS NOT NULL THEN
281: p_sr_ghr_cpdf_temp.rating_of_record_level := l_ANCRIT_REC.SEGMENT5;
282: p_sr_ghr_cpdf_temp.rating_of_record_pattern := l_ANCRIT_REC.SEGMENT4;
283: p_sr_ghr_cpdf_temp.rating_of_record_period_ends := fnd_date.canonical_to_date(l_ANCRIT_REC.SEGMENT6);
284: ELSE -- Generate entry in PROCESS_LOG
285: OPEN c_per;
278: p_special_info => l_ancrit_rec);
279:
280: IF l_ancrit_rec.object_version_number IS NOT NULL THEN
281: p_sr_ghr_cpdf_temp.rating_of_record_level := l_ANCRIT_REC.SEGMENT5;
282: p_sr_ghr_cpdf_temp.rating_of_record_pattern := l_ANCRIT_REC.SEGMENT4;
283: p_sr_ghr_cpdf_temp.rating_of_record_period_ends := fnd_date.canonical_to_date(l_ANCRIT_REC.SEGMENT6);
284: ELSE -- Generate entry in PROCESS_LOG
285: OPEN c_per;
286: FETCH c_per INTO l_emp_number;
279:
280: IF l_ancrit_rec.object_version_number IS NOT NULL THEN
281: p_sr_ghr_cpdf_temp.rating_of_record_level := l_ANCRIT_REC.SEGMENT5;
282: p_sr_ghr_cpdf_temp.rating_of_record_pattern := l_ANCRIT_REC.SEGMENT4;
283: p_sr_ghr_cpdf_temp.rating_of_record_period_ends := fnd_date.canonical_to_date(l_ANCRIT_REC.SEGMENT6);
284: ELSE -- Generate entry in PROCESS_LOG
285: OPEN c_per;
286: FETCH c_per INTO l_emp_number;
287: CLOSE c_per;
297: PROCEDURE get_from_history_peopei
298: (
299: p_sr_person_id IN NUMBER
300: ,p_sr_report_date IN DATE
301: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
302: )
303: IS
304: l_proc varchar2(30) := 'get_from_history_peopei';
305: l_PEOPEI_DATA PER_PEOPLE_EXTRA_INFO%ROWTYPE;
319: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
320: p_date_effective => p_sr_report_date,
321: p_per_ei_data => l_PEOPEI_DATA
322: );
323: p_sr_ghr_cpdf_temp.creditable_military_service := SUBSTR(l_PEOPEI_DATA.PEI_INFORMATION5,1,4);
324:
325: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
326: -- Begin Bug# 4168162
327: g_message_name := 'Person EIT: Separation, Retire';
331: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
332: p_date_effective => p_sr_report_date,
333: p_per_ei_data => l_PEOPEI_DATA
334: );
335: p_sr_ghr_cpdf_temp.frozen_service := SUBSTR(l_PEOPEI_DATA.PEI_INFORMATION5,1,4);
336: p_sr_ghr_cpdf_temp.fers_coverage := l_PEOPEI_DATA.PEI_INFORMATION3;
337:
338:
339: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
332: p_date_effective => p_sr_report_date,
333: p_per_ei_data => l_PEOPEI_DATA
334: );
335: p_sr_ghr_cpdf_temp.frozen_service := SUBSTR(l_PEOPEI_DATA.PEI_INFORMATION5,1,4);
336: p_sr_ghr_cpdf_temp.fers_coverage := l_PEOPEI_DATA.PEI_INFORMATION3;
337:
338:
339: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
340: -- Begin Bug# 4168162
346: p_date_effective => p_sr_report_date,
347: p_per_ei_data => l_PEOPEI_DATA
348: );
349:
350: p_sr_ghr_cpdf_temp.veterans_preference := l_PEOPEI_DATA.PEI_INFORMATION4;
351: p_sr_ghr_cpdf_temp.veterans_status := l_PEOPEI_DATA.PEI_INFORMATION6;
352: p_sr_ghr_cpdf_temp.citizenship := l_PEOPEI_DATA.PEI_INFORMATION3;
353:
354:
347: p_per_ei_data => l_PEOPEI_DATA
348: );
349:
350: p_sr_ghr_cpdf_temp.veterans_preference := l_PEOPEI_DATA.PEI_INFORMATION4;
351: p_sr_ghr_cpdf_temp.veterans_status := l_PEOPEI_DATA.PEI_INFORMATION6;
352: p_sr_ghr_cpdf_temp.citizenship := l_PEOPEI_DATA.PEI_INFORMATION3;
353:
354:
355: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
348: );
349:
350: p_sr_ghr_cpdf_temp.veterans_preference := l_PEOPEI_DATA.PEI_INFORMATION4;
351: p_sr_ghr_cpdf_temp.veterans_status := l_PEOPEI_DATA.PEI_INFORMATION6;
352: p_sr_ghr_cpdf_temp.citizenship := l_PEOPEI_DATA.PEI_INFORMATION3;
353:
354:
355: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
356: -- Begin Bug# 4168162
361: p_information_type => 'GHR_US_PER_GROUP1',
362: p_date_effective => p_sr_report_date,
363: p_per_ei_data => l_PEOPEI_DATA
364: );
365: p_sr_ghr_cpdf_temp.current_appointment_auth1 := l_PEOPEI_DATA.PEI_INFORMATION8;
366: p_sr_ghr_cpdf_temp.current_appointment_auth2 := l_PEOPEI_DATA.PEI_INFORMATION9;
367: p_sr_ghr_cpdf_temp.race_national_origin := l_PEOPEI_DATA.PEI_INFORMATION5;
368: p_sr_ghr_cpdf_temp.handicap_code := l_PEOPEI_DATA.PEI_INFORMATION11;
369: l_type_of_employment := l_PEOPEI_DATA.PEI_INFORMATION4;
362: p_date_effective => p_sr_report_date,
363: p_per_ei_data => l_PEOPEI_DATA
364: );
365: p_sr_ghr_cpdf_temp.current_appointment_auth1 := l_PEOPEI_DATA.PEI_INFORMATION8;
366: p_sr_ghr_cpdf_temp.current_appointment_auth2 := l_PEOPEI_DATA.PEI_INFORMATION9;
367: p_sr_ghr_cpdf_temp.race_national_origin := l_PEOPEI_DATA.PEI_INFORMATION5;
368: p_sr_ghr_cpdf_temp.handicap_code := l_PEOPEI_DATA.PEI_INFORMATION11;
369: l_type_of_employment := l_PEOPEI_DATA.PEI_INFORMATION4;
370:
363: p_per_ei_data => l_PEOPEI_DATA
364: );
365: p_sr_ghr_cpdf_temp.current_appointment_auth1 := l_PEOPEI_DATA.PEI_INFORMATION8;
366: p_sr_ghr_cpdf_temp.current_appointment_auth2 := l_PEOPEI_DATA.PEI_INFORMATION9;
367: p_sr_ghr_cpdf_temp.race_national_origin := l_PEOPEI_DATA.PEI_INFORMATION5;
368: p_sr_ghr_cpdf_temp.handicap_code := l_PEOPEI_DATA.PEI_INFORMATION11;
369: l_type_of_employment := l_PEOPEI_DATA.PEI_INFORMATION4;
370:
371: -- bug 749190 Use FUNCTION ghr_pc_basic_pay.get_retained_grade_details instead of
364: );
365: p_sr_ghr_cpdf_temp.current_appointment_auth1 := l_PEOPEI_DATA.PEI_INFORMATION8;
366: p_sr_ghr_cpdf_temp.current_appointment_auth2 := l_PEOPEI_DATA.PEI_INFORMATION9;
367: p_sr_ghr_cpdf_temp.race_national_origin := l_PEOPEI_DATA.PEI_INFORMATION5;
368: p_sr_ghr_cpdf_temp.handicap_code := l_PEOPEI_DATA.PEI_INFORMATION11;
369: l_type_of_employment := l_PEOPEI_DATA.PEI_INFORMATION4;
370:
371: -- bug 749190 Use FUNCTION ghr_pc_basic_pay.get_retained_grade_details instead of
372: -- GHR_HISTORY_FETCH.fetch_peopleei
370:
371: -- bug 749190 Use FUNCTION ghr_pc_basic_pay.get_retained_grade_details instead of
372: -- GHR_HISTORY_FETCH.fetch_peopleei
373: -- do not woory if it didn't return anything!
374: IF p_sr_ghr_cpdf_temp.to_pay_rate_determinant IN ('A','B','E','F','U','V') THEN
375: BEGIN
376: -- Begin Bug# 4168162
377: g_message_name := 'Person EIT: RG Details';
378: -- End Bug# 4168162
381: p_effective_date => p_sr_report_date
382: );
383: --- added for bug 3834462 Madhuri, store Retained Pay Basis value
384: --- Start of fix
385: p_sr_ghr_cpdf_temp.to_pay_basis := l_retained_grade_rec.pay_basis;
386: -- End of Bug fix
387: p_sr_ghr_cpdf_temp.retained_pay_plan := l_retained_grade_rec.pay_plan;
388: p_sr_ghr_cpdf_temp.retained_grade_or_level := l_retained_grade_rec.grade_or_level;
389: p_sr_ghr_cpdf_temp.retained_step_or_rate := l_retained_grade_rec.step_or_rate;
383: --- added for bug 3834462 Madhuri, store Retained Pay Basis value
384: --- Start of fix
385: p_sr_ghr_cpdf_temp.to_pay_basis := l_retained_grade_rec.pay_basis;
386: -- End of Bug fix
387: p_sr_ghr_cpdf_temp.retained_pay_plan := l_retained_grade_rec.pay_plan;
388: p_sr_ghr_cpdf_temp.retained_grade_or_level := l_retained_grade_rec.grade_or_level;
389: p_sr_ghr_cpdf_temp.retained_step_or_rate := l_retained_grade_rec.step_or_rate;
390: g_retained_pay_table_id := l_retained_grade_rec.user_table_id;
391: EXCEPTION
384: --- Start of fix
385: p_sr_ghr_cpdf_temp.to_pay_basis := l_retained_grade_rec.pay_basis;
386: -- End of Bug fix
387: p_sr_ghr_cpdf_temp.retained_pay_plan := l_retained_grade_rec.pay_plan;
388: p_sr_ghr_cpdf_temp.retained_grade_or_level := l_retained_grade_rec.grade_or_level;
389: p_sr_ghr_cpdf_temp.retained_step_or_rate := l_retained_grade_rec.step_or_rate;
390: g_retained_pay_table_id := l_retained_grade_rec.user_table_id;
391: EXCEPTION
392: WHEN ghr_pay_calc.pay_calc_message THEN
385: p_sr_ghr_cpdf_temp.to_pay_basis := l_retained_grade_rec.pay_basis;
386: -- End of Bug fix
387: p_sr_ghr_cpdf_temp.retained_pay_plan := l_retained_grade_rec.pay_plan;
388: p_sr_ghr_cpdf_temp.retained_grade_or_level := l_retained_grade_rec.grade_or_level;
389: p_sr_ghr_cpdf_temp.retained_step_or_rate := l_retained_grade_rec.step_or_rate;
390: g_retained_pay_table_id := l_retained_grade_rec.user_table_id;
391: EXCEPTION
392: WHEN ghr_pay_calc.pay_calc_message THEN
393: --l_message_name := 'Person EIT - Retained Grade';
407: p_date_effective => p_sr_report_date,
408: p_per_ei_data => l_PEOPEI_DATA
409: );
410: -- SVC may be changed w/ resolution of type/length conversion
411: p_sr_ghr_cpdf_temp.service_comp_date :=
412: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);
413:
414: -- SCD RIF and Retirement dates
415: p_sr_ghr_cpdf_temp.SCD_rif :=
411: p_sr_ghr_cpdf_temp.service_comp_date :=
412: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);
413:
414: -- SCD RIF and Retirement dates
415: p_sr_ghr_cpdf_temp.SCD_rif :=
416: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION5);
417: p_sr_ghr_cpdf_temp.SCD_retirement :=
418: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION7);
419: -- EHRI changes
413:
414: -- SCD RIF and Retirement dates
415: p_sr_ghr_cpdf_temp.SCD_rif :=
416: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION5);
417: p_sr_ghr_cpdf_temp.SCD_retirement :=
418: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION7);
419: -- EHRI changes
420:
421: -- CPDF EDITS FOR CREDITABLE MILITARY SERVICE
420:
421: -- CPDF EDITS FOR CREDITABLE MILITARY SERVICE
422: -- October date specified per requirements
423: -- Suggested Fix for 4060669
424: /* IF NVL(p_sr_ghr_cpdf_temp.annuitant_indicator,'9') <> '9' OR
425: g_appointment_date < to_date('1986/10/01','YYYY/MM/DD')
426: THEN
427: p_sr_ghr_cpdf_temp.creditable_military_service := ' ';
428: END IF;
423: -- Suggested Fix for 4060669
424: /* IF NVL(p_sr_ghr_cpdf_temp.annuitant_indicator,'9') <> '9' OR
425: g_appointment_date < to_date('1986/10/01','YYYY/MM/DD')
426: THEN
427: p_sr_ghr_cpdf_temp.creditable_military_service := ' ';
428: END IF;
429:
430: IF (SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,1,1) < '0' OR
431: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,2,1) < '0' OR
426: THEN
427: p_sr_ghr_cpdf_temp.creditable_military_service := ' ';
428: END IF;
429:
430: IF (SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,1,1) < '0' OR
431: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,2,1) < '0' OR
432: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,3,1) < '0' OR
433: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,4,1) < '0' OR
434: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,1,1) > '9' OR
427: p_sr_ghr_cpdf_temp.creditable_military_service := ' ';
428: END IF;
429:
430: IF (SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,1,1) < '0' OR
431: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,2,1) < '0' OR
432: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,3,1) < '0' OR
433: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,4,1) < '0' OR
434: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,1,1) > '9' OR
435: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,2,1) > '9' OR
428: END IF;
429:
430: IF (SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,1,1) < '0' OR
431: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,2,1) < '0' OR
432: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,3,1) < '0' OR
433: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,4,1) < '0' OR
434: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,1,1) > '9' OR
435: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,2,1) > '9' OR
436: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,3,1) > '9' OR
429:
430: IF (SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,1,1) < '0' OR
431: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,2,1) < '0' OR
432: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,3,1) < '0' OR
433: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,4,1) < '0' OR
434: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,1,1) > '9' OR
435: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,2,1) > '9' OR
436: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,3,1) > '9' OR
437: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,4,1) > '9' ) AND
430: IF (SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,1,1) < '0' OR
431: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,2,1) < '0' OR
432: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,3,1) < '0' OR
433: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,4,1) < '0' OR
434: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,1,1) > '9' OR
435: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,2,1) > '9' OR
436: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,3,1) > '9' OR
437: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,4,1) > '9' ) AND
438: p_sr_ghr_cpdf_temp.creditable_military_service IS NOT NULL AND
431: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,2,1) < '0' OR
432: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,3,1) < '0' OR
433: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,4,1) < '0' OR
434: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,1,1) > '9' OR
435: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,2,1) > '9' OR
436: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,3,1) > '9' OR
437: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,4,1) > '9' ) AND
438: p_sr_ghr_cpdf_temp.creditable_military_service IS NOT NULL AND
439: p_sr_ghr_cpdf_temp.creditable_military_service <> ' '
432: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,3,1) < '0' OR
433: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,4,1) < '0' OR
434: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,1,1) > '9' OR
435: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,2,1) > '9' OR
436: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,3,1) > '9' OR
437: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,4,1) > '9' ) AND
438: p_sr_ghr_cpdf_temp.creditable_military_service IS NOT NULL AND
439: p_sr_ghr_cpdf_temp.creditable_military_service <> ' '
440: THEN
433: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,4,1) < '0' OR
434: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,1,1) > '9' OR
435: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,2,1) > '9' OR
436: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,3,1) > '9' OR
437: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,4,1) > '9' ) AND
438: p_sr_ghr_cpdf_temp.creditable_military_service IS NOT NULL AND
439: p_sr_ghr_cpdf_temp.creditable_military_service <> ' '
440: THEN
441: p_sr_ghr_cpdf_temp.creditable_military_service := '0000';
434: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,1,1) > '9' OR
435: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,2,1) > '9' OR
436: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,3,1) > '9' OR
437: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,4,1) > '9' ) AND
438: p_sr_ghr_cpdf_temp.creditable_military_service IS NOT NULL AND
439: p_sr_ghr_cpdf_temp.creditable_military_service <> ' '
440: THEN
441: p_sr_ghr_cpdf_temp.creditable_military_service := '0000';
442: END IF;*/
435: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,2,1) > '9' OR
436: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,3,1) > '9' OR
437: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,4,1) > '9' ) AND
438: p_sr_ghr_cpdf_temp.creditable_military_service IS NOT NULL AND
439: p_sr_ghr_cpdf_temp.creditable_military_service <> ' '
440: THEN
441: p_sr_ghr_cpdf_temp.creditable_military_service := '0000';
442: END IF;*/
443:
437: SUBSTR(p_sr_ghr_cpdf_temp.creditable_military_service,4,1) > '9' ) AND
438: p_sr_ghr_cpdf_temp.creditable_military_service IS NOT NULL AND
439: p_sr_ghr_cpdf_temp.creditable_military_service <> ' '
440: THEN
441: p_sr_ghr_cpdf_temp.creditable_military_service := '0000';
442: END IF;*/
443:
444: -- Modified with the requirements specified in the bug 12394245
445: IF NVL(p_sr_ghr_cpdf_temp.annuitant_indicator,'9') NOT IN ('2','3','9') OR
441: p_sr_ghr_cpdf_temp.creditable_military_service := '0000';
442: END IF;*/
443:
444: -- Modified with the requirements specified in the bug 12394245
445: IF NVL(p_sr_ghr_cpdf_temp.annuitant_indicator,'9') NOT IN ('2','3','9') OR
446: g_appointment_date < to_date('1986/10/01','YYYY/MM/DD') THEN
447: p_sr_ghr_cpdf_temp.creditable_military_service := NULL;
448: ELSIF NVL(p_sr_ghr_cpdf_temp.annuitant_indicator,'9') IN ('2','3','9') AND
449: g_appointment_date >= to_date('1986/10/01','YYYY/MM/DD') AND
443:
444: -- Modified with the requirements specified in the bug 12394245
445: IF NVL(p_sr_ghr_cpdf_temp.annuitant_indicator,'9') NOT IN ('2','3','9') OR
446: g_appointment_date < to_date('1986/10/01','YYYY/MM/DD') THEN
447: p_sr_ghr_cpdf_temp.creditable_military_service := NULL;
448: ELSIF NVL(p_sr_ghr_cpdf_temp.annuitant_indicator,'9') IN ('2','3','9') AND
449: g_appointment_date >= to_date('1986/10/01','YYYY/MM/DD') AND
450: p_sr_ghr_cpdf_temp.creditable_military_service IS NULL THEN
451: p_sr_ghr_cpdf_temp.creditable_military_service := '000000';
444: -- Modified with the requirements specified in the bug 12394245
445: IF NVL(p_sr_ghr_cpdf_temp.annuitant_indicator,'9') NOT IN ('2','3','9') OR
446: g_appointment_date < to_date('1986/10/01','YYYY/MM/DD') THEN
447: p_sr_ghr_cpdf_temp.creditable_military_service := NULL;
448: ELSIF NVL(p_sr_ghr_cpdf_temp.annuitant_indicator,'9') IN ('2','3','9') AND
449: g_appointment_date >= to_date('1986/10/01','YYYY/MM/DD') AND
450: p_sr_ghr_cpdf_temp.creditable_military_service IS NULL THEN
451: p_sr_ghr_cpdf_temp.creditable_military_service := '000000';
452: END IF;
446: g_appointment_date < to_date('1986/10/01','YYYY/MM/DD') THEN
447: p_sr_ghr_cpdf_temp.creditable_military_service := NULL;
448: ELSIF NVL(p_sr_ghr_cpdf_temp.annuitant_indicator,'9') IN ('2','3','9') AND
449: g_appointment_date >= to_date('1986/10/01','YYYY/MM/DD') AND
450: p_sr_ghr_cpdf_temp.creditable_military_service IS NULL THEN
451: p_sr_ghr_cpdf_temp.creditable_military_service := '000000';
452: END IF;
453:
454:
447: p_sr_ghr_cpdf_temp.creditable_military_service := NULL;
448: ELSIF NVL(p_sr_ghr_cpdf_temp.annuitant_indicator,'9') IN ('2','3','9') AND
449: g_appointment_date >= to_date('1986/10/01','YYYY/MM/DD') AND
450: p_sr_ghr_cpdf_temp.creditable_military_service IS NULL THEN
451: p_sr_ghr_cpdf_temp.creditable_military_service := '000000';
452: END IF;
453:
454:
455: -- CPDF EDITS FOR FROZEN SERVICE
454:
455: -- CPDF EDITS FOR FROZEN SERVICE
456: -- October date specified per requirements
457: -- use retirement plan, not fers coverage per raj/john
458: /* IF p_sr_ghr_cpdf_temp.retirement_plan NOT IN('K','L','M','N','C','E') OR
459: g_appointment_date < to_date('1986/10/01','YYYY/MM/DD')
460: THEN
461: p_sr_ghr_cpdf_temp.frozen_service := ' ';
462: END IF;*/
457: -- use retirement plan, not fers coverage per raj/john
458: /* IF p_sr_ghr_cpdf_temp.retirement_plan NOT IN('K','L','M','N','C','E') OR
459: g_appointment_date < to_date('1986/10/01','YYYY/MM/DD')
460: THEN
461: p_sr_ghr_cpdf_temp.frozen_service := ' ';
462: END IF;*/
463:
464: --Bug # 12535772 Frozen service will be displayed when retirement Plan is K,L,M,N or Retirement Plan in C, E
465: -- and Hire Date is later than 01-July-1987
463:
464: --Bug # 12535772 Frozen service will be displayed when retirement Plan is K,L,M,N or Retirement Plan in C, E
465: -- and Hire Date is later than 01-July-1987
466: --Bug# 15941036 added Retirement codes KR,LR,MR,NR
467: IF p_sr_ghr_cpdf_temp.retirement_plan IN ('K','L','M','N','KR','LR','MR','NR') OR (p_sr_ghr_cpdf_temp.retirement_plan IN ('C','E')
468: AND g_appointment_date >= to_date('1987/07/01','YYYY/MM/DD')) THEN
469: IF p_sr_ghr_cpdf_temp.frozen_service is NULL THEN
470: p_sr_ghr_cpdf_temp.frozen_service := '000000';
471: END IF;
465: -- and Hire Date is later than 01-July-1987
466: --Bug# 15941036 added Retirement codes KR,LR,MR,NR
467: IF p_sr_ghr_cpdf_temp.retirement_plan IN ('K','L','M','N','KR','LR','MR','NR') OR (p_sr_ghr_cpdf_temp.retirement_plan IN ('C','E')
468: AND g_appointment_date >= to_date('1987/07/01','YYYY/MM/DD')) THEN
469: IF p_sr_ghr_cpdf_temp.frozen_service is NULL THEN
470: p_sr_ghr_cpdf_temp.frozen_service := '000000';
471: END IF;
472: ELSE
473: p_sr_ghr_cpdf_temp.frozen_service := ' ';
466: --Bug# 15941036 added Retirement codes KR,LR,MR,NR
467: IF p_sr_ghr_cpdf_temp.retirement_plan IN ('K','L','M','N','KR','LR','MR','NR') OR (p_sr_ghr_cpdf_temp.retirement_plan IN ('C','E')
468: AND g_appointment_date >= to_date('1987/07/01','YYYY/MM/DD')) THEN
469: IF p_sr_ghr_cpdf_temp.frozen_service is NULL THEN
470: p_sr_ghr_cpdf_temp.frozen_service := '000000';
471: END IF;
472: ELSE
473: p_sr_ghr_cpdf_temp.frozen_service := ' ';
474: END IF;
469: IF p_sr_ghr_cpdf_temp.frozen_service is NULL THEN
470: p_sr_ghr_cpdf_temp.frozen_service := '000000';
471: END IF;
472: ELSE
473: p_sr_ghr_cpdf_temp.frozen_service := ' ';
474: END IF;
475:
476:
477: -- CPDF EDITS FOR FERS COVERAGE
476:
477: -- CPDF EDITS FOR FERS COVERAGE
478: -- use retirement plan, not fers coverage per raj/john
479: --Bug# 15941036 added Retirement codes KR,LR,MR,NR
480: IF p_sr_ghr_cpdf_temp.retirement_plan NOT IN('K','L','M','N','KR','LR','MR','NR')
481: THEN
482: p_sr_ghr_cpdf_temp.fers_coverage := ' ';
483: END IF;
484:
478: -- use retirement plan, not fers coverage per raj/john
479: --Bug# 15941036 added Retirement codes KR,LR,MR,NR
480: IF p_sr_ghr_cpdf_temp.retirement_plan NOT IN('K','L','M','N','KR','LR','MR','NR')
481: THEN
482: p_sr_ghr_cpdf_temp.fers_coverage := ' ';
483: END IF;
484:
485: -- CPDF EDITS FOR RETAINED ...
486: IF p_sr_ghr_cpdf_temp.to_pay_rate_determinant
482: p_sr_ghr_cpdf_temp.fers_coverage := ' ';
483: END IF;
484:
485: -- CPDF EDITS FOR RETAINED ...
486: IF p_sr_ghr_cpdf_temp.to_pay_rate_determinant
487: NOT IN ('A','B','E','F','U','V')
488: THEN
489: p_sr_ghr_cpdf_temp.retained_pay_plan := NULL;
490: p_sr_ghr_cpdf_temp.retained_grade_or_level := NULL;
485: -- CPDF EDITS FOR RETAINED ...
486: IF p_sr_ghr_cpdf_temp.to_pay_rate_determinant
487: NOT IN ('A','B','E','F','U','V')
488: THEN
489: p_sr_ghr_cpdf_temp.retained_pay_plan := NULL;
490: p_sr_ghr_cpdf_temp.retained_grade_or_level := NULL;
491: p_sr_ghr_cpdf_temp.retained_step_or_rate := NULL;
492: -- Bug 3834462 fix Madhuri
493: -- NULL this out incase the PRD is not in above list,
486: IF p_sr_ghr_cpdf_temp.to_pay_rate_determinant
487: NOT IN ('A','B','E','F','U','V')
488: THEN
489: p_sr_ghr_cpdf_temp.retained_pay_plan := NULL;
490: p_sr_ghr_cpdf_temp.retained_grade_or_level := NULL;
491: p_sr_ghr_cpdf_temp.retained_step_or_rate := NULL;
492: -- Bug 3834462 fix Madhuri
493: -- NULL this out incase the PRD is not in above list,
494: -- pay basis can be picked now from valid grade info instead of the retained grade details.
487: NOT IN ('A','B','E','F','U','V')
488: THEN
489: p_sr_ghr_cpdf_temp.retained_pay_plan := NULL;
490: p_sr_ghr_cpdf_temp.retained_grade_or_level := NULL;
491: p_sr_ghr_cpdf_temp.retained_step_or_rate := NULL;
492: -- Bug 3834462 fix Madhuri
493: -- NULL this out incase the PRD is not in above list,
494: -- pay basis can be picked now from valid grade info instead of the retained grade details.
495: p_sr_ghr_cpdf_temp.to_pay_basis := NULL;
491: p_sr_ghr_cpdf_temp.retained_step_or_rate := NULL;
492: -- Bug 3834462 fix Madhuri
493: -- NULL this out incase the PRD is not in above list,
494: -- pay basis can be picked now from valid grade info instead of the retained grade details.
495: p_sr_ghr_cpdf_temp.to_pay_basis := NULL;
496: END IF;
497:
498: -- CPDF EDITS FOR PAY_STATUS
499:
502:
503: IF l_type_of_employment
504: IN ('1','2','3','4','5','6','7','C','D','E','G','H','J','W')
505: THEN
506: p_sr_ghr_cpdf_temp.pay_status := 'P';
507: ELSIF l_type_of_employment = 'F'
508: THEN
509: p_sr_ghr_cpdf_temp.pay_status := 'N';
510: ELSE
505: THEN
506: p_sr_ghr_cpdf_temp.pay_status := 'P';
507: ELSIF l_type_of_employment = 'F'
508: THEN
509: p_sr_ghr_cpdf_temp.pay_status := 'N';
510: ELSE
511: p_sr_ghr_cpdf_temp.pay_status := l_type_of_employment;
512: END IF;
513:
507: ELSIF l_type_of_employment = 'F'
508: THEN
509: p_sr_ghr_cpdf_temp.pay_status := 'N';
510: ELSE
511: p_sr_ghr_cpdf_temp.pay_status := l_type_of_employment;
512: END IF;
513:
514: -- Fetching Race and ethnicity category
515: l_PEOPEI_DATA :=NULL;
521: p_information_type => 'GHR_US_PER_ETHNICITY_RACE',
522: p_date_effective => p_sr_report_date,
523: p_per_ei_data => l_PEOPEI_DATA
524: );
525: p_sr_ghr_cpdf_temp.race_ethnic_info := NULL;
526: -- Populate Race only if atleast one data segment is entered.
527: IF l_PEOPEI_DATA.pei_information3 IS NOT NULL OR
528: l_PEOPEI_DATA.pei_information4 IS NOT NULL OR
529: l_PEOPEI_DATA.pei_information5 IS NOT NULL OR
529: l_PEOPEI_DATA.pei_information5 IS NOT NULL OR
530: l_PEOPEI_DATA.pei_information6 IS NOT NULL OR
531: l_PEOPEI_DATA.pei_information7 IS NOT NULL OR
532: l_PEOPEI_DATA.pei_information8 IS NOT NULL THEN
533: p_sr_ghr_cpdf_temp.race_ethnic_info := NVL(l_PEOPEI_DATA.pei_information3,'0') || NVL(l_PEOPEI_DATA.pei_information4,'0') || NVL(l_PEOPEI_DATA.pei_information5,'0') ||
534: NVL(l_PEOPEI_DATA.pei_information6,'0') || NVL(l_PEOPEI_DATA.pei_information7,'0') || NVL(l_PEOPEI_DATA.pei_information8,'0');
535: END IF;
536: -- End Bug 4714292 EHRI Reports Changes for EOY 05
537:
540: PROCEDURE get_from_history_posiei
541: (
542: p_sr_position_id IN NUMBER
543: ,p_sr_report_date IN DATE
544: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
545: )
546: IS
547: l_proc varchar2(30) := 'get_from_history_posiei';
548: l_POSIEI_DATA PER_POSITION_EXTRA_INFO%ROWTYPE;
559: p_information_type => 'GHR_US_POS_GRP1',
560: p_date_effective => p_sr_report_date,
561: p_pos_ei_data => l_POSIEI_DATA
562: );
563: p_sr_ghr_cpdf_temp.organizational_component := l_POSIEI_DATA.POEI_INFORMATION5;
564: p_sr_ghr_cpdf_temp.personnel_office_id := l_POSIEI_DATA.POEI_INFORMATION3;
565: p_sr_ghr_cpdf_temp.functional_class := l_POSIEI_DATA.POEI_INFORMATION11;
566: p_sr_ghr_cpdf_temp.supervisory_status := l_POSIEI_DATA.POEI_INFORMATION16;
567: p_sr_ghr_cpdf_temp.flsa_category := l_POSIEI_DATA.POEI_INFORMATION7;
560: p_date_effective => p_sr_report_date,
561: p_pos_ei_data => l_POSIEI_DATA
562: );
563: p_sr_ghr_cpdf_temp.organizational_component := l_POSIEI_DATA.POEI_INFORMATION5;
564: p_sr_ghr_cpdf_temp.personnel_office_id := l_POSIEI_DATA.POEI_INFORMATION3;
565: p_sr_ghr_cpdf_temp.functional_class := l_POSIEI_DATA.POEI_INFORMATION11;
566: p_sr_ghr_cpdf_temp.supervisory_status := l_POSIEI_DATA.POEI_INFORMATION16;
567: p_sr_ghr_cpdf_temp.flsa_category := l_POSIEI_DATA.POEI_INFORMATION7;
568: p_sr_ghr_cpdf_temp.bargaining_unit_status := l_POSIEI_DATA.POEI_INFORMATION8;
561: p_pos_ei_data => l_POSIEI_DATA
562: );
563: p_sr_ghr_cpdf_temp.organizational_component := l_POSIEI_DATA.POEI_INFORMATION5;
564: p_sr_ghr_cpdf_temp.personnel_office_id := l_POSIEI_DATA.POEI_INFORMATION3;
565: p_sr_ghr_cpdf_temp.functional_class := l_POSIEI_DATA.POEI_INFORMATION11;
566: p_sr_ghr_cpdf_temp.supervisory_status := l_POSIEI_DATA.POEI_INFORMATION16;
567: p_sr_ghr_cpdf_temp.flsa_category := l_POSIEI_DATA.POEI_INFORMATION7;
568: p_sr_ghr_cpdf_temp.bargaining_unit_status := l_POSIEI_DATA.POEI_INFORMATION8;
569:
562: );
563: p_sr_ghr_cpdf_temp.organizational_component := l_POSIEI_DATA.POEI_INFORMATION5;
564: p_sr_ghr_cpdf_temp.personnel_office_id := l_POSIEI_DATA.POEI_INFORMATION3;
565: p_sr_ghr_cpdf_temp.functional_class := l_POSIEI_DATA.POEI_INFORMATION11;
566: p_sr_ghr_cpdf_temp.supervisory_status := l_POSIEI_DATA.POEI_INFORMATION16;
567: p_sr_ghr_cpdf_temp.flsa_category := l_POSIEI_DATA.POEI_INFORMATION7;
568: p_sr_ghr_cpdf_temp.bargaining_unit_status := l_POSIEI_DATA.POEI_INFORMATION8;
569:
570:
563: p_sr_ghr_cpdf_temp.organizational_component := l_POSIEI_DATA.POEI_INFORMATION5;
564: p_sr_ghr_cpdf_temp.personnel_office_id := l_POSIEI_DATA.POEI_INFORMATION3;
565: p_sr_ghr_cpdf_temp.functional_class := l_POSIEI_DATA.POEI_INFORMATION11;
566: p_sr_ghr_cpdf_temp.supervisory_status := l_POSIEI_DATA.POEI_INFORMATION16;
567: p_sr_ghr_cpdf_temp.flsa_category := l_POSIEI_DATA.POEI_INFORMATION7;
568: p_sr_ghr_cpdf_temp.bargaining_unit_status := l_POSIEI_DATA.POEI_INFORMATION8;
569:
570:
571: l_POSIEI_DATA := l_POSIEI_DATA_INIT;
564: p_sr_ghr_cpdf_temp.personnel_office_id := l_POSIEI_DATA.POEI_INFORMATION3;
565: p_sr_ghr_cpdf_temp.functional_class := l_POSIEI_DATA.POEI_INFORMATION11;
566: p_sr_ghr_cpdf_temp.supervisory_status := l_POSIEI_DATA.POEI_INFORMATION16;
567: p_sr_ghr_cpdf_temp.flsa_category := l_POSIEI_DATA.POEI_INFORMATION7;
568: p_sr_ghr_cpdf_temp.bargaining_unit_status := l_POSIEI_DATA.POEI_INFORMATION8;
569:
570:
571: l_POSIEI_DATA := l_POSIEI_DATA_INIT;
572: -- Begin Bug# 4168162
578: p_date_effective => p_sr_report_date,
579: p_pos_ei_data => l_POSIEI_DATA
580: );
581: -- Added this condition for Bug 3834462 Fix (Madhuri)
582: IF p_sr_ghr_cpdf_temp.to_pay_basis is NULL THEN
583: p_sr_ghr_cpdf_temp.to_pay_basis := l_POSIEI_DATA.POEI_INFORMATION6;
584: END IF;
585: -- Added this condition for Bug 3834462 Fix (Madhuri)
586: if (l_POSIEI_DATA.POEI_INFORMATION5 is not null) then
579: p_pos_ei_data => l_POSIEI_DATA
580: );
581: -- Added this condition for Bug 3834462 Fix (Madhuri)
582: IF p_sr_ghr_cpdf_temp.to_pay_basis is NULL THEN
583: p_sr_ghr_cpdf_temp.to_pay_basis := l_POSIEI_DATA.POEI_INFORMATION6;
584: END IF;
585: -- Added this condition for Bug 3834462 Fix (Madhuri)
586: if (l_POSIEI_DATA.POEI_INFORMATION5 is not null) then
587: p_sr_ghr_cpdf_temp.to_pay_table_id := l_POSIEI_DATA.POEI_INFORMATION5;
583: p_sr_ghr_cpdf_temp.to_pay_basis := l_POSIEI_DATA.POEI_INFORMATION6;
584: END IF;
585: -- Added this condition for Bug 3834462 Fix (Madhuri)
586: if (l_POSIEI_DATA.POEI_INFORMATION5 is not null) then
587: p_sr_ghr_cpdf_temp.to_pay_table_id := l_POSIEI_DATA.POEI_INFORMATION5;
588: end if;
589:
590: l_POSIEI_DATA := l_POSIEI_DATA_INIT;
591: -- Begin Bug# 4168162
596: p_information_type => 'GHR_US_POS_GRP2',
597: p_date_effective => p_sr_report_date,
598: p_pos_ei_data => l_POSIEI_DATA
599: );
600: p_sr_ghr_cpdf_temp.position_occupied := l_POSIEI_DATA.POEI_INFORMATION3;
601:
602: -- CPDF EDITS FOR PAY TABLE ID
603: IF p_sr_ghr_cpdf_temp.to_pay_rate_determinant NOT IN ('5','6','E','F','M')
604: THEN
599: );
600: p_sr_ghr_cpdf_temp.position_occupied := l_POSIEI_DATA.POEI_INFORMATION3;
601:
602: -- CPDF EDITS FOR PAY TABLE ID
603: IF p_sr_ghr_cpdf_temp.to_pay_rate_determinant NOT IN ('5','6','E','F','M')
604: THEN
605: p_sr_ghr_cpdf_temp.to_pay_table_id := ' ';
606: END IF;
607:
601:
602: -- CPDF EDITS FOR PAY TABLE ID
603: IF p_sr_ghr_cpdf_temp.to_pay_rate_determinant NOT IN ('5','6','E','F','M')
604: THEN
605: p_sr_ghr_cpdf_temp.to_pay_table_id := ' ';
606: END IF;
607:
608: END get_from_history_posiei;
609:
610: PROCEDURE get_from_history_gradef
611: (
612: p_sr_grade_id IN NUMBER
613: ,p_sr_report_date IN DATE
614: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
615: )
616: IS
617: -- start_date_active and end_date_active on the PER_GRADE_DEFINITIONS
618: -- table WAS NOT considered as a query criteria because all rows on
638: -- Pay Plan to be changed w/ resolution of type/length conversion
639:
640: IF GRADEFCUR%FOUND
641: THEN
642: p_sr_ghr_cpdf_temp.to_pay_plan := substr(l_GRADEFREC.SEGMENT1,1,2);
643: p_sr_ghr_cpdf_temp.to_grade_or_level := l_GRADEFREC.SEGMENT2;
644: END IF;
645:
646: CLOSE GRADEFCUR;
639:
640: IF GRADEFCUR%FOUND
641: THEN
642: p_sr_ghr_cpdf_temp.to_pay_plan := substr(l_GRADEFREC.SEGMENT1,1,2);
643: p_sr_ghr_cpdf_temp.to_grade_or_level := l_GRADEFREC.SEGMENT2;
644: END IF;
645:
646: CLOSE GRADEFCUR;
647: END get_from_history_gradef;
649: PROCEDURE get_from_history_jobdef
650: (
651: p_sr_job_id IN NUMBER
652: ,p_sr_report_date IN DATE
653: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
654: )
655: IS
656: l_proc varchar2(30) := 'get_from_history_jobdef';
657: CURSOR JOBDEF_CUR IS
672: FETCH JOBDEF_CUR INTO l_JOBDEF_REC;
673:
674: IF JOBDEF_CUR%FOUND
675: THEN
676: p_sr_ghr_cpdf_temp.to_occ_code := l_JOBDEF_REC.SEGMENT1;
677: END IF;
678:
679: CLOSE JOBDEF_CUR;
680:
683: PROCEDURE get_from_history_dutsta
684: (
685: p_sr_location_id IN NUMBER
686: ,p_sr_report_date IN DATE
687: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
688: )
689: IS
690: l_proc varchar2(30) := 'get_from_history_dutsta';
691:
712: FETCH DUTSTACUR INTO l_DUTSTAREC;
713:
714: IF DUTSTACUR%FOUND
715: THEN
716: p_sr_ghr_cpdf_temp.to_duty_station_code := l_DUTSTAREC.DUTY_STATION_CODE;
717: g_duty_station_id := l_DUTSTAREC.DUTY_STATION_ID;
718: END IF;
719:
720: CLOSE DUTSTACUR;
723: PROCEDURE get_from_history_payele
724: (
725: p_sr_assignment_id IN NUMBER
726: ,p_sr_report_date IN DATE
727: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
728: )
729: IS
730: l_proc varchar2(30) := 'get_from_history_payele';
731: l_scrn_ent_val_init PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE%TYPE;
744: p_assignment_id => p_sr_assignment_id,
745: p_date_effective => p_sr_report_date,
746: p_screen_entry_value => l_scrn_ent_val
747: );
748: p_sr_ghr_cpdf_temp.retirement_plan := l_scrn_ent_val;
749:
750: l_scrn_ent_val := l_scrn_ent_val_init;
751: -- Begin Bug# 4168162
752: g_message_name := 'Fetch Element: FEGLI';
757: p_assignment_id => p_sr_assignment_id,
758: p_date_effective => p_sr_report_date,
759: p_screen_entry_value => l_scrn_ent_val
760: );
761: p_sr_ghr_cpdf_temp.fegli := l_scrn_ent_val;
762:
763:
764: -- Start Bug 1635449
765: l_scrn_ent_val := l_scrn_ent_val_init;
771: p_input_value_name => 'Health Plan',
772: p_assignment_id => p_sr_assignment_id,
773: p_date_effective => p_sr_report_date,
774: p_screen_entry_value => l_scrn_ent_val);
775: p_sr_ghr_cpdf_temp.health_plan := SUBSTR(LTRIM(l_scrn_ent_val), 1 ,2);
776: l_scrn_ent_val := l_scrn_ent_val_init;
777: -- Begin Bug# 4168162
778: g_message_name := 'Fetch Element: HB Pre tax Enrl';
779: -- End Bug# 4168162
783: p_assignment_id => p_sr_assignment_id,
784: p_date_effective => p_sr_report_date,
785: p_screen_entry_value => l_scrn_ent_val
786: );
787: IF l_scrn_ent_val is NULL and p_sr_ghr_cpdf_temp.health_plan is NULL THEN
788: l_scrn_ent_val := l_scrn_ent_val_init;
789: -- Begin Bug# 4168162
790: g_message_name := ' Fetch Element: HB plan';
791: -- End Bug# 4168162
794: p_input_value_name => 'Health Plan',
795: p_assignment_id => p_sr_assignment_id,
796: p_date_effective => p_sr_report_date,
797: p_screen_entry_value => l_scrn_ent_val);
798: p_sr_ghr_cpdf_temp.health_plan := SUBSTR(LTRIM(l_scrn_ent_val), 1 ,2);
799: l_scrn_ent_val := l_scrn_ent_val_init;
800: -- Begin Bug# 4168162
801: g_message_name := ' Fetch Element: HB Enrollment';
802: -- End Bug# 4168162
807: p_date_effective => p_sr_report_date,
808: p_screen_entry_value => l_scrn_ent_val
809: );
810: END IF;
811: p_sr_ghr_cpdf_temp.health_plan := NVL(p_sr_ghr_cpdf_temp.health_plan, ' ') ||
812: SUBSTR(LTRIM(l_scrn_ent_val), 1, 1);
813: -- End Bug 1635449
814: -- Changes for Payroll Integration
815: -- Name Bug Date Comments
827: p_assignment_id => p_sr_assignment_id,
828: p_date_effective => p_sr_report_date,
829: p_screen_entry_value => l_scrn_ent_val
830: );
831: p_sr_ghr_cpdf_temp.to_basic_pay := to_number(l_scrn_ent_val);
832:
833: l_scrn_ent_val := l_scrn_ent_val_init;
834:
835: -- Changes for Payroll Integration
849: p_assignment_id => p_sr_assignment_id,
850: p_date_effective => p_sr_report_date,
851: p_screen_entry_value => l_scrn_ent_val
852: );
853: p_sr_ghr_cpdf_temp.to_locality_adj := to_number(l_scrn_ent_val);
854:
855: l_scrn_ent_val := l_scrn_ent_val_init;
856: -- Begin Bug# 4168162
857: g_message_name := 'Fetch Element: Staffing Diff';
862: p_assignment_id => p_sr_assignment_id,
863: p_date_effective => p_sr_report_date,
864: p_screen_entry_value => l_scrn_ent_val
865: );
866: p_sr_ghr_cpdf_temp.to_staffing_differential := to_number(l_scrn_ent_val);
867:
868: l_scrn_ent_val := l_scrn_ent_val_init;
869: -- Begin Bug# 4168162
870: g_message_name := 'Fetch Element:Supervisory Diff';
875: p_assignment_id => p_sr_assignment_id,
876: p_date_effective => p_sr_report_date,
877: p_screen_entry_value => l_scrn_ent_val
878: );
879: p_sr_ghr_cpdf_temp.to_supervisory_differential := to_number(l_scrn_ent_val);
880:
881: l_scrn_ent_val := l_scrn_ent_val_init;
882: -- Begin Bug# 4168162
883: g_message_name := 'Fetch Element:Retention Allow';
888: p_assignment_id => p_sr_assignment_id,
889: p_date_effective => p_sr_report_date,
890: p_screen_entry_value => l_scrn_ent_val
891: );
892: p_sr_ghr_cpdf_temp.to_retention_allowance := to_number(l_scrn_ent_val);
893:
894: END get_from_history_payele;
895:
896: PROCEDURE calc_is_foreign_duty_station
924: -- a determination of whether a duty station is foreign or domestic
925: -- has been hard-coded. at the time this proc was written, there
926: -- was talk that a future release of GHR would represent this value
927: -- as a flexfield (i.e., no need to calculate). furthermore,
928: -- the ghr_cpdf_temp.from_duty_station_code will be used as
929: -- a temporary storage for this value
930:
931:
932: IF (l_STATE_CNTRY_CODE >= '01' AND
934: l_STATE_CNTRY_CODE IN ('GQ','RQ','AQ','FM','JQ',
935: 'CQ','MQ','RM','HQ','PS',
936: 'BQ','WQ','VQ')
937: THEN
938: g_ghr_cpdf_temp.from_duty_station_code := 'N';
939: ELSE
940: g_ghr_cpdf_temp.from_duty_station_code := 'Y';
941: END IF;
942:
936: 'BQ','WQ','VQ')
937: THEN
938: g_ghr_cpdf_temp.from_duty_station_code := 'N';
939: ELSE
940: g_ghr_cpdf_temp.from_duty_station_code := 'Y';
941: END IF;
942:
943: END calc_is_foreign_duty_station;
944:
953: hr_utility.set_location('Entering:'||l_proc,5);
954: -- Bug#3231946 Added reference to parameters as the function definition is changed
955:
956: l_locality_pay_area := ghr_cpdf_dynrpt.get_loc_pay_area_code(p_duty_station_id => g_duty_station_id,
957: p_effective_date => g_ghr_cpdf_temp.effective_date);
958: l_equivalent_pay_plan := ghr_cpdf_dynrpt.get_equivalent_pay_plan(
959: NVL(g_ghr_cpdf_temp.retained_pay_plan, g_ghr_cpdf_temp.to_pay_plan));
960:
961: IF (l_locality_pay_area = '99')
955:
956: l_locality_pay_area := ghr_cpdf_dynrpt.get_loc_pay_area_code(p_duty_station_id => g_duty_station_id,
957: p_effective_date => g_ghr_cpdf_temp.effective_date);
958: l_equivalent_pay_plan := ghr_cpdf_dynrpt.get_equivalent_pay_plan(
959: NVL(g_ghr_cpdf_temp.retained_pay_plan, g_ghr_cpdf_temp.to_pay_plan));
960:
961: IF (l_locality_pay_area = '99')
962: THEN
963: g_ghr_cpdf_temp.from_locality_adj := NULL;
959: NVL(g_ghr_cpdf_temp.retained_pay_plan, g_ghr_cpdf_temp.to_pay_plan));
960:
961: IF (l_locality_pay_area = '99')
962: THEN
963: g_ghr_cpdf_temp.from_locality_adj := NULL;
964: g_ghr_cpdf_temp.to_locality_adj := NULL;
965: ELSIF l_equivalent_pay_plan = 'FW'
966: THEN
967: g_ghr_cpdf_temp.from_locality_adj := NULL;
960:
961: IF (l_locality_pay_area = '99')
962: THEN
963: g_ghr_cpdf_temp.from_locality_adj := NULL;
964: g_ghr_cpdf_temp.to_locality_adj := NULL;
965: ELSIF l_equivalent_pay_plan = 'FW'
966: THEN
967: g_ghr_cpdf_temp.from_locality_adj := NULL;
968: g_ghr_cpdf_temp.to_locality_adj := NULL;
963: g_ghr_cpdf_temp.from_locality_adj := NULL;
964: g_ghr_cpdf_temp.to_locality_adj := NULL;
965: ELSIF l_equivalent_pay_plan = 'FW'
966: THEN
967: g_ghr_cpdf_temp.from_locality_adj := NULL;
968: g_ghr_cpdf_temp.to_locality_adj := NULL;
969: END IF;
970:
971: -- Bug 4542476
964: g_ghr_cpdf_temp.to_locality_adj := NULL;
965: ELSIF l_equivalent_pay_plan = 'FW'
966: THEN
967: g_ghr_cpdf_temp.from_locality_adj := NULL;
968: g_ghr_cpdf_temp.to_locality_adj := NULL;
969: END IF;
970:
971: -- Bug 4542476
972: IF g_ghr_cpdf_temp.to_locality_adj = 0 THEN
968: g_ghr_cpdf_temp.to_locality_adj := NULL;
969: END IF;
970:
971: -- Bug 4542476
972: IF g_ghr_cpdf_temp.to_locality_adj = 0 THEN
973: IF l_equivalent_pay_plan = 'GS' AND l_locality_pay_area = 'ZZ' THEN
974: g_ghr_cpdf_temp.to_locality_adj := NULL;
975: ELSIF l_equivalent_pay_plan = 'GS' AND NVL(l_locality_pay_area,'-1') <> 'ZZ' THEN
976: g_ghr_cpdf_temp.to_locality_adj := 0;
970:
971: -- Bug 4542476
972: IF g_ghr_cpdf_temp.to_locality_adj = 0 THEN
973: IF l_equivalent_pay_plan = 'GS' AND l_locality_pay_area = 'ZZ' THEN
974: g_ghr_cpdf_temp.to_locality_adj := NULL;
975: ELSIF l_equivalent_pay_plan = 'GS' AND NVL(l_locality_pay_area,'-1') <> 'ZZ' THEN
976: g_ghr_cpdf_temp.to_locality_adj := 0;
977: ELSE
978: g_ghr_cpdf_temp.to_locality_adj := NULL;
972: IF g_ghr_cpdf_temp.to_locality_adj = 0 THEN
973: IF l_equivalent_pay_plan = 'GS' AND l_locality_pay_area = 'ZZ' THEN
974: g_ghr_cpdf_temp.to_locality_adj := NULL;
975: ELSIF l_equivalent_pay_plan = 'GS' AND NVL(l_locality_pay_area,'-1') <> 'ZZ' THEN
976: g_ghr_cpdf_temp.to_locality_adj := 0;
977: ELSE
978: g_ghr_cpdf_temp.to_locality_adj := NULL;
979: END IF;
980: END IF;
974: g_ghr_cpdf_temp.to_locality_adj := NULL;
975: ELSIF l_equivalent_pay_plan = 'GS' AND NVL(l_locality_pay_area,'-1') <> 'ZZ' THEN
976: g_ghr_cpdf_temp.to_locality_adj := 0;
977: ELSE
978: g_ghr_cpdf_temp.to_locality_adj := NULL;
979: END IF;
980: END IF;
981: -- End Bug 4542476
982:
979: END IF;
980: END IF;
981: -- End Bug 4542476
982:
983: INSERT INTO ghr_cpdf_temp (
984: report_type
985: ,session_id
986: ,academic_discipline
987: ,agency_code
1079: )
1080: values (
1081: 'STATUS'
1082: ,userenv('SESSIONID')
1083: ,g_ghr_cpdf_temp.academic_discipline
1084: ,g_ghr_cpdf_temp.agency_code
1085: ,g_ghr_cpdf_temp.annuitant_indicator
1086: ,g_ghr_cpdf_temp.award_amount
1087: ,g_ghr_cpdf_temp.bargaining_unit_status
1080: values (
1081: 'STATUS'
1082: ,userenv('SESSIONID')
1083: ,g_ghr_cpdf_temp.academic_discipline
1084: ,g_ghr_cpdf_temp.agency_code
1085: ,g_ghr_cpdf_temp.annuitant_indicator
1086: ,g_ghr_cpdf_temp.award_amount
1087: ,g_ghr_cpdf_temp.bargaining_unit_status
1088: ,g_ghr_cpdf_temp.benefit_amount
1081: 'STATUS'
1082: ,userenv('SESSIONID')
1083: ,g_ghr_cpdf_temp.academic_discipline
1084: ,g_ghr_cpdf_temp.agency_code
1085: ,g_ghr_cpdf_temp.annuitant_indicator
1086: ,g_ghr_cpdf_temp.award_amount
1087: ,g_ghr_cpdf_temp.bargaining_unit_status
1088: ,g_ghr_cpdf_temp.benefit_amount
1089: ,g_ghr_cpdf_temp.citizenship
1082: ,userenv('SESSIONID')
1083: ,g_ghr_cpdf_temp.academic_discipline
1084: ,g_ghr_cpdf_temp.agency_code
1085: ,g_ghr_cpdf_temp.annuitant_indicator
1086: ,g_ghr_cpdf_temp.award_amount
1087: ,g_ghr_cpdf_temp.bargaining_unit_status
1088: ,g_ghr_cpdf_temp.benefit_amount
1089: ,g_ghr_cpdf_temp.citizenship
1090: ,g_ghr_cpdf_temp.creditable_military_service
1083: ,g_ghr_cpdf_temp.academic_discipline
1084: ,g_ghr_cpdf_temp.agency_code
1085: ,g_ghr_cpdf_temp.annuitant_indicator
1086: ,g_ghr_cpdf_temp.award_amount
1087: ,g_ghr_cpdf_temp.bargaining_unit_status
1088: ,g_ghr_cpdf_temp.benefit_amount
1089: ,g_ghr_cpdf_temp.citizenship
1090: ,g_ghr_cpdf_temp.creditable_military_service
1091: ,g_ghr_cpdf_temp.current_appointment_auth1
1084: ,g_ghr_cpdf_temp.agency_code
1085: ,g_ghr_cpdf_temp.annuitant_indicator
1086: ,g_ghr_cpdf_temp.award_amount
1087: ,g_ghr_cpdf_temp.bargaining_unit_status
1088: ,g_ghr_cpdf_temp.benefit_amount
1089: ,g_ghr_cpdf_temp.citizenship
1090: ,g_ghr_cpdf_temp.creditable_military_service
1091: ,g_ghr_cpdf_temp.current_appointment_auth1
1092: ,g_ghr_cpdf_temp.current_appointment_auth2
1085: ,g_ghr_cpdf_temp.annuitant_indicator
1086: ,g_ghr_cpdf_temp.award_amount
1087: ,g_ghr_cpdf_temp.bargaining_unit_status
1088: ,g_ghr_cpdf_temp.benefit_amount
1089: ,g_ghr_cpdf_temp.citizenship
1090: ,g_ghr_cpdf_temp.creditable_military_service
1091: ,g_ghr_cpdf_temp.current_appointment_auth1
1092: ,g_ghr_cpdf_temp.current_appointment_auth2
1093: ,g_ghr_cpdf_temp.to_duty_station_code
1086: ,g_ghr_cpdf_temp.award_amount
1087: ,g_ghr_cpdf_temp.bargaining_unit_status
1088: ,g_ghr_cpdf_temp.benefit_amount
1089: ,g_ghr_cpdf_temp.citizenship
1090: ,g_ghr_cpdf_temp.creditable_military_service
1091: ,g_ghr_cpdf_temp.current_appointment_auth1
1092: ,g_ghr_cpdf_temp.current_appointment_auth2
1093: ,g_ghr_cpdf_temp.to_duty_station_code
1094: ,g_ghr_cpdf_temp.education_level
1087: ,g_ghr_cpdf_temp.bargaining_unit_status
1088: ,g_ghr_cpdf_temp.benefit_amount
1089: ,g_ghr_cpdf_temp.citizenship
1090: ,g_ghr_cpdf_temp.creditable_military_service
1091: ,g_ghr_cpdf_temp.current_appointment_auth1
1092: ,g_ghr_cpdf_temp.current_appointment_auth2
1093: ,g_ghr_cpdf_temp.to_duty_station_code
1094: ,g_ghr_cpdf_temp.education_level
1095: ,g_ghr_cpdf_temp.effective_date
1088: ,g_ghr_cpdf_temp.benefit_amount
1089: ,g_ghr_cpdf_temp.citizenship
1090: ,g_ghr_cpdf_temp.creditable_military_service
1091: ,g_ghr_cpdf_temp.current_appointment_auth1
1092: ,g_ghr_cpdf_temp.current_appointment_auth2
1093: ,g_ghr_cpdf_temp.to_duty_station_code
1094: ,g_ghr_cpdf_temp.education_level
1095: ,g_ghr_cpdf_temp.effective_date
1096: ,g_ghr_cpdf_temp.employee_date_of_birth
1089: ,g_ghr_cpdf_temp.citizenship
1090: ,g_ghr_cpdf_temp.creditable_military_service
1091: ,g_ghr_cpdf_temp.current_appointment_auth1
1092: ,g_ghr_cpdf_temp.current_appointment_auth2
1093: ,g_ghr_cpdf_temp.to_duty_station_code
1094: ,g_ghr_cpdf_temp.education_level
1095: ,g_ghr_cpdf_temp.effective_date
1096: ,g_ghr_cpdf_temp.employee_date_of_birth
1097: ,g_ghr_cpdf_temp.employee_first_name
1090: ,g_ghr_cpdf_temp.creditable_military_service
1091: ,g_ghr_cpdf_temp.current_appointment_auth1
1092: ,g_ghr_cpdf_temp.current_appointment_auth2
1093: ,g_ghr_cpdf_temp.to_duty_station_code
1094: ,g_ghr_cpdf_temp.education_level
1095: ,g_ghr_cpdf_temp.effective_date
1096: ,g_ghr_cpdf_temp.employee_date_of_birth
1097: ,g_ghr_cpdf_temp.employee_first_name
1098: ,g_ghr_cpdf_temp.employee_last_name
1091: ,g_ghr_cpdf_temp.current_appointment_auth1
1092: ,g_ghr_cpdf_temp.current_appointment_auth2
1093: ,g_ghr_cpdf_temp.to_duty_station_code
1094: ,g_ghr_cpdf_temp.education_level
1095: ,g_ghr_cpdf_temp.effective_date
1096: ,g_ghr_cpdf_temp.employee_date_of_birth
1097: ,g_ghr_cpdf_temp.employee_first_name
1098: ,g_ghr_cpdf_temp.employee_last_name
1099: ,g_ghr_cpdf_temp.employee_middle_names
1092: ,g_ghr_cpdf_temp.current_appointment_auth2
1093: ,g_ghr_cpdf_temp.to_duty_station_code
1094: ,g_ghr_cpdf_temp.education_level
1095: ,g_ghr_cpdf_temp.effective_date
1096: ,g_ghr_cpdf_temp.employee_date_of_birth
1097: ,g_ghr_cpdf_temp.employee_first_name
1098: ,g_ghr_cpdf_temp.employee_last_name
1099: ,g_ghr_cpdf_temp.employee_middle_names
1100: ,g_ghr_cpdf_temp.from_national_identifier
1093: ,g_ghr_cpdf_temp.to_duty_station_code
1094: ,g_ghr_cpdf_temp.education_level
1095: ,g_ghr_cpdf_temp.effective_date
1096: ,g_ghr_cpdf_temp.employee_date_of_birth
1097: ,g_ghr_cpdf_temp.employee_first_name
1098: ,g_ghr_cpdf_temp.employee_last_name
1099: ,g_ghr_cpdf_temp.employee_middle_names
1100: ,g_ghr_cpdf_temp.from_national_identifier
1101: ,g_ghr_cpdf_temp.fegli
1094: ,g_ghr_cpdf_temp.education_level
1095: ,g_ghr_cpdf_temp.effective_date
1096: ,g_ghr_cpdf_temp.employee_date_of_birth
1097: ,g_ghr_cpdf_temp.employee_first_name
1098: ,g_ghr_cpdf_temp.employee_last_name
1099: ,g_ghr_cpdf_temp.employee_middle_names
1100: ,g_ghr_cpdf_temp.from_national_identifier
1101: ,g_ghr_cpdf_temp.fegli
1102: ,g_ghr_cpdf_temp.fers_coverage
1095: ,g_ghr_cpdf_temp.effective_date
1096: ,g_ghr_cpdf_temp.employee_date_of_birth
1097: ,g_ghr_cpdf_temp.employee_first_name
1098: ,g_ghr_cpdf_temp.employee_last_name
1099: ,g_ghr_cpdf_temp.employee_middle_names
1100: ,g_ghr_cpdf_temp.from_national_identifier
1101: ,g_ghr_cpdf_temp.fegli
1102: ,g_ghr_cpdf_temp.fers_coverage
1103: ,g_ghr_cpdf_temp.first_action_la_code1
1096: ,g_ghr_cpdf_temp.employee_date_of_birth
1097: ,g_ghr_cpdf_temp.employee_first_name
1098: ,g_ghr_cpdf_temp.employee_last_name
1099: ,g_ghr_cpdf_temp.employee_middle_names
1100: ,g_ghr_cpdf_temp.from_national_identifier
1101: ,g_ghr_cpdf_temp.fegli
1102: ,g_ghr_cpdf_temp.fers_coverage
1103: ,g_ghr_cpdf_temp.first_action_la_code1
1104: ,g_ghr_cpdf_temp.first_action_la_code2
1097: ,g_ghr_cpdf_temp.employee_first_name
1098: ,g_ghr_cpdf_temp.employee_last_name
1099: ,g_ghr_cpdf_temp.employee_middle_names
1100: ,g_ghr_cpdf_temp.from_national_identifier
1101: ,g_ghr_cpdf_temp.fegli
1102: ,g_ghr_cpdf_temp.fers_coverage
1103: ,g_ghr_cpdf_temp.first_action_la_code1
1104: ,g_ghr_cpdf_temp.first_action_la_code2
1105: ,g_ghr_cpdf_temp.first_noa_code
1098: ,g_ghr_cpdf_temp.employee_last_name
1099: ,g_ghr_cpdf_temp.employee_middle_names
1100: ,g_ghr_cpdf_temp.from_national_identifier
1101: ,g_ghr_cpdf_temp.fegli
1102: ,g_ghr_cpdf_temp.fers_coverage
1103: ,g_ghr_cpdf_temp.first_action_la_code1
1104: ,g_ghr_cpdf_temp.first_action_la_code2
1105: ,g_ghr_cpdf_temp.first_noa_code
1106: ,g_ghr_cpdf_temp.flsa_category
1099: ,g_ghr_cpdf_temp.employee_middle_names
1100: ,g_ghr_cpdf_temp.from_national_identifier
1101: ,g_ghr_cpdf_temp.fegli
1102: ,g_ghr_cpdf_temp.fers_coverage
1103: ,g_ghr_cpdf_temp.first_action_la_code1
1104: ,g_ghr_cpdf_temp.first_action_la_code2
1105: ,g_ghr_cpdf_temp.first_noa_code
1106: ,g_ghr_cpdf_temp.flsa_category
1107: ,g_ghr_cpdf_temp.from_basic_pay
1100: ,g_ghr_cpdf_temp.from_national_identifier
1101: ,g_ghr_cpdf_temp.fegli
1102: ,g_ghr_cpdf_temp.fers_coverage
1103: ,g_ghr_cpdf_temp.first_action_la_code1
1104: ,g_ghr_cpdf_temp.first_action_la_code2
1105: ,g_ghr_cpdf_temp.first_noa_code
1106: ,g_ghr_cpdf_temp.flsa_category
1107: ,g_ghr_cpdf_temp.from_basic_pay
1108: ,g_ghr_cpdf_temp.from_duty_station_code
1101: ,g_ghr_cpdf_temp.fegli
1102: ,g_ghr_cpdf_temp.fers_coverage
1103: ,g_ghr_cpdf_temp.first_action_la_code1
1104: ,g_ghr_cpdf_temp.first_action_la_code2
1105: ,g_ghr_cpdf_temp.first_noa_code
1106: ,g_ghr_cpdf_temp.flsa_category
1107: ,g_ghr_cpdf_temp.from_basic_pay
1108: ,g_ghr_cpdf_temp.from_duty_station_code
1109: ,g_ghr_cpdf_temp.from_grade_or_level
1102: ,g_ghr_cpdf_temp.fers_coverage
1103: ,g_ghr_cpdf_temp.first_action_la_code1
1104: ,g_ghr_cpdf_temp.first_action_la_code2
1105: ,g_ghr_cpdf_temp.first_noa_code
1106: ,g_ghr_cpdf_temp.flsa_category
1107: ,g_ghr_cpdf_temp.from_basic_pay
1108: ,g_ghr_cpdf_temp.from_duty_station_code
1109: ,g_ghr_cpdf_temp.from_grade_or_level
1110: ,g_ghr_cpdf_temp.from_locality_adj
1103: ,g_ghr_cpdf_temp.first_action_la_code1
1104: ,g_ghr_cpdf_temp.first_action_la_code2
1105: ,g_ghr_cpdf_temp.first_noa_code
1106: ,g_ghr_cpdf_temp.flsa_category
1107: ,g_ghr_cpdf_temp.from_basic_pay
1108: ,g_ghr_cpdf_temp.from_duty_station_code
1109: ,g_ghr_cpdf_temp.from_grade_or_level
1110: ,g_ghr_cpdf_temp.from_locality_adj
1111: ,g_ghr_cpdf_temp.from_occ_code
1104: ,g_ghr_cpdf_temp.first_action_la_code2
1105: ,g_ghr_cpdf_temp.first_noa_code
1106: ,g_ghr_cpdf_temp.flsa_category
1107: ,g_ghr_cpdf_temp.from_basic_pay
1108: ,g_ghr_cpdf_temp.from_duty_station_code
1109: ,g_ghr_cpdf_temp.from_grade_or_level
1110: ,g_ghr_cpdf_temp.from_locality_adj
1111: ,g_ghr_cpdf_temp.from_occ_code
1112: ,g_ghr_cpdf_temp.from_pay_table_id
1105: ,g_ghr_cpdf_temp.first_noa_code
1106: ,g_ghr_cpdf_temp.flsa_category
1107: ,g_ghr_cpdf_temp.from_basic_pay
1108: ,g_ghr_cpdf_temp.from_duty_station_code
1109: ,g_ghr_cpdf_temp.from_grade_or_level
1110: ,g_ghr_cpdf_temp.from_locality_adj
1111: ,g_ghr_cpdf_temp.from_occ_code
1112: ,g_ghr_cpdf_temp.from_pay_table_id
1113: ,g_ghr_cpdf_temp.from_pay_basis
1106: ,g_ghr_cpdf_temp.flsa_category
1107: ,g_ghr_cpdf_temp.from_basic_pay
1108: ,g_ghr_cpdf_temp.from_duty_station_code
1109: ,g_ghr_cpdf_temp.from_grade_or_level
1110: ,g_ghr_cpdf_temp.from_locality_adj
1111: ,g_ghr_cpdf_temp.from_occ_code
1112: ,g_ghr_cpdf_temp.from_pay_table_id
1113: ,g_ghr_cpdf_temp.from_pay_basis
1114: ,g_ghr_cpdf_temp.from_pay_plan
1107: ,g_ghr_cpdf_temp.from_basic_pay
1108: ,g_ghr_cpdf_temp.from_duty_station_code
1109: ,g_ghr_cpdf_temp.from_grade_or_level
1110: ,g_ghr_cpdf_temp.from_locality_adj
1111: ,g_ghr_cpdf_temp.from_occ_code
1112: ,g_ghr_cpdf_temp.from_pay_table_id
1113: ,g_ghr_cpdf_temp.from_pay_basis
1114: ,g_ghr_cpdf_temp.from_pay_plan
1115: ,g_ghr_cpdf_temp.from_pay_rate_determinant
1108: ,g_ghr_cpdf_temp.from_duty_station_code
1109: ,g_ghr_cpdf_temp.from_grade_or_level
1110: ,g_ghr_cpdf_temp.from_locality_adj
1111: ,g_ghr_cpdf_temp.from_occ_code
1112: ,g_ghr_cpdf_temp.from_pay_table_id
1113: ,g_ghr_cpdf_temp.from_pay_basis
1114: ,g_ghr_cpdf_temp.from_pay_plan
1115: ,g_ghr_cpdf_temp.from_pay_rate_determinant
1116: ,g_ghr_cpdf_temp.from_retirement_coverage
1109: ,g_ghr_cpdf_temp.from_grade_or_level
1110: ,g_ghr_cpdf_temp.from_locality_adj
1111: ,g_ghr_cpdf_temp.from_occ_code
1112: ,g_ghr_cpdf_temp.from_pay_table_id
1113: ,g_ghr_cpdf_temp.from_pay_basis
1114: ,g_ghr_cpdf_temp.from_pay_plan
1115: ,g_ghr_cpdf_temp.from_pay_rate_determinant
1116: ,g_ghr_cpdf_temp.from_retirement_coverage
1117: ,g_ghr_cpdf_temp.from_step_or_rate
1110: ,g_ghr_cpdf_temp.from_locality_adj
1111: ,g_ghr_cpdf_temp.from_occ_code
1112: ,g_ghr_cpdf_temp.from_pay_table_id
1113: ,g_ghr_cpdf_temp.from_pay_basis
1114: ,g_ghr_cpdf_temp.from_pay_plan
1115: ,g_ghr_cpdf_temp.from_pay_rate_determinant
1116: ,g_ghr_cpdf_temp.from_retirement_coverage
1117: ,g_ghr_cpdf_temp.from_step_or_rate
1118: ,g_ghr_cpdf_temp.from_total_salary
1111: ,g_ghr_cpdf_temp.from_occ_code
1112: ,g_ghr_cpdf_temp.from_pay_table_id
1113: ,g_ghr_cpdf_temp.from_pay_basis
1114: ,g_ghr_cpdf_temp.from_pay_plan
1115: ,g_ghr_cpdf_temp.from_pay_rate_determinant
1116: ,g_ghr_cpdf_temp.from_retirement_coverage
1117: ,g_ghr_cpdf_temp.from_step_or_rate
1118: ,g_ghr_cpdf_temp.from_total_salary
1119: ,g_ghr_cpdf_temp.from_work_schedule
1112: ,g_ghr_cpdf_temp.from_pay_table_id
1113: ,g_ghr_cpdf_temp.from_pay_basis
1114: ,g_ghr_cpdf_temp.from_pay_plan
1115: ,g_ghr_cpdf_temp.from_pay_rate_determinant
1116: ,g_ghr_cpdf_temp.from_retirement_coverage
1117: ,g_ghr_cpdf_temp.from_step_or_rate
1118: ,g_ghr_cpdf_temp.from_total_salary
1119: ,g_ghr_cpdf_temp.from_work_schedule
1120: ,g_ghr_cpdf_temp.frozen_service
1113: ,g_ghr_cpdf_temp.from_pay_basis
1114: ,g_ghr_cpdf_temp.from_pay_plan
1115: ,g_ghr_cpdf_temp.from_pay_rate_determinant
1116: ,g_ghr_cpdf_temp.from_retirement_coverage
1117: ,g_ghr_cpdf_temp.from_step_or_rate
1118: ,g_ghr_cpdf_temp.from_total_salary
1119: ,g_ghr_cpdf_temp.from_work_schedule
1120: ,g_ghr_cpdf_temp.frozen_service
1121: ,g_ghr_cpdf_temp.functional_class
1114: ,g_ghr_cpdf_temp.from_pay_plan
1115: ,g_ghr_cpdf_temp.from_pay_rate_determinant
1116: ,g_ghr_cpdf_temp.from_retirement_coverage
1117: ,g_ghr_cpdf_temp.from_step_or_rate
1118: ,g_ghr_cpdf_temp.from_total_salary
1119: ,g_ghr_cpdf_temp.from_work_schedule
1120: ,g_ghr_cpdf_temp.frozen_service
1121: ,g_ghr_cpdf_temp.functional_class
1122: ,g_ghr_cpdf_temp.handicap_code
1115: ,g_ghr_cpdf_temp.from_pay_rate_determinant
1116: ,g_ghr_cpdf_temp.from_retirement_coverage
1117: ,g_ghr_cpdf_temp.from_step_or_rate
1118: ,g_ghr_cpdf_temp.from_total_salary
1119: ,g_ghr_cpdf_temp.from_work_schedule
1120: ,g_ghr_cpdf_temp.frozen_service
1121: ,g_ghr_cpdf_temp.functional_class
1122: ,g_ghr_cpdf_temp.handicap_code
1123: ,g_ghr_cpdf_temp.health_plan
1116: ,g_ghr_cpdf_temp.from_retirement_coverage
1117: ,g_ghr_cpdf_temp.from_step_or_rate
1118: ,g_ghr_cpdf_temp.from_total_salary
1119: ,g_ghr_cpdf_temp.from_work_schedule
1120: ,g_ghr_cpdf_temp.frozen_service
1121: ,g_ghr_cpdf_temp.functional_class
1122: ,g_ghr_cpdf_temp.handicap_code
1123: ,g_ghr_cpdf_temp.health_plan
1124: ,g_ghr_cpdf_temp.individual_group_award
1117: ,g_ghr_cpdf_temp.from_step_or_rate
1118: ,g_ghr_cpdf_temp.from_total_salary
1119: ,g_ghr_cpdf_temp.from_work_schedule
1120: ,g_ghr_cpdf_temp.frozen_service
1121: ,g_ghr_cpdf_temp.functional_class
1122: ,g_ghr_cpdf_temp.handicap_code
1123: ,g_ghr_cpdf_temp.health_plan
1124: ,g_ghr_cpdf_temp.individual_group_award
1125: ,g_ghr_cpdf_temp.organizational_component
1118: ,g_ghr_cpdf_temp.from_total_salary
1119: ,g_ghr_cpdf_temp.from_work_schedule
1120: ,g_ghr_cpdf_temp.frozen_service
1121: ,g_ghr_cpdf_temp.functional_class
1122: ,g_ghr_cpdf_temp.handicap_code
1123: ,g_ghr_cpdf_temp.health_plan
1124: ,g_ghr_cpdf_temp.individual_group_award
1125: ,g_ghr_cpdf_temp.organizational_component
1126: ,g_ghr_cpdf_temp.pay_status
1119: ,g_ghr_cpdf_temp.from_work_schedule
1120: ,g_ghr_cpdf_temp.frozen_service
1121: ,g_ghr_cpdf_temp.functional_class
1122: ,g_ghr_cpdf_temp.handicap_code
1123: ,g_ghr_cpdf_temp.health_plan
1124: ,g_ghr_cpdf_temp.individual_group_award
1125: ,g_ghr_cpdf_temp.organizational_component
1126: ,g_ghr_cpdf_temp.pay_status
1127: ,g_ghr_cpdf_temp.personnel_office_id
1120: ,g_ghr_cpdf_temp.frozen_service
1121: ,g_ghr_cpdf_temp.functional_class
1122: ,g_ghr_cpdf_temp.handicap_code
1123: ,g_ghr_cpdf_temp.health_plan
1124: ,g_ghr_cpdf_temp.individual_group_award
1125: ,g_ghr_cpdf_temp.organizational_component
1126: ,g_ghr_cpdf_temp.pay_status
1127: ,g_ghr_cpdf_temp.personnel_office_id
1128: ,g_ghr_cpdf_temp.position_occupied
1121: ,g_ghr_cpdf_temp.functional_class
1122: ,g_ghr_cpdf_temp.handicap_code
1123: ,g_ghr_cpdf_temp.health_plan
1124: ,g_ghr_cpdf_temp.individual_group_award
1125: ,g_ghr_cpdf_temp.organizational_component
1126: ,g_ghr_cpdf_temp.pay_status
1127: ,g_ghr_cpdf_temp.personnel_office_id
1128: ,g_ghr_cpdf_temp.position_occupied
1129: ,g_ghr_cpdf_temp.race_national_origin
1122: ,g_ghr_cpdf_temp.handicap_code
1123: ,g_ghr_cpdf_temp.health_plan
1124: ,g_ghr_cpdf_temp.individual_group_award
1125: ,g_ghr_cpdf_temp.organizational_component
1126: ,g_ghr_cpdf_temp.pay_status
1127: ,g_ghr_cpdf_temp.personnel_office_id
1128: ,g_ghr_cpdf_temp.position_occupied
1129: ,g_ghr_cpdf_temp.race_national_origin
1130: ,g_ghr_cpdf_temp.rating_of_record
1123: ,g_ghr_cpdf_temp.health_plan
1124: ,g_ghr_cpdf_temp.individual_group_award
1125: ,g_ghr_cpdf_temp.organizational_component
1126: ,g_ghr_cpdf_temp.pay_status
1127: ,g_ghr_cpdf_temp.personnel_office_id
1128: ,g_ghr_cpdf_temp.position_occupied
1129: ,g_ghr_cpdf_temp.race_national_origin
1130: ,g_ghr_cpdf_temp.rating_of_record
1131: ,g_ghr_cpdf_temp.rating_of_record_level
1124: ,g_ghr_cpdf_temp.individual_group_award
1125: ,g_ghr_cpdf_temp.organizational_component
1126: ,g_ghr_cpdf_temp.pay_status
1127: ,g_ghr_cpdf_temp.personnel_office_id
1128: ,g_ghr_cpdf_temp.position_occupied
1129: ,g_ghr_cpdf_temp.race_national_origin
1130: ,g_ghr_cpdf_temp.rating_of_record
1131: ,g_ghr_cpdf_temp.rating_of_record_level
1132: ,g_ghr_cpdf_temp.rating_of_record_pattern
1125: ,g_ghr_cpdf_temp.organizational_component
1126: ,g_ghr_cpdf_temp.pay_status
1127: ,g_ghr_cpdf_temp.personnel_office_id
1128: ,g_ghr_cpdf_temp.position_occupied
1129: ,g_ghr_cpdf_temp.race_national_origin
1130: ,g_ghr_cpdf_temp.rating_of_record
1131: ,g_ghr_cpdf_temp.rating_of_record_level
1132: ,g_ghr_cpdf_temp.rating_of_record_pattern
1133: ,g_ghr_cpdf_temp.rating_of_record_period_ends
1126: ,g_ghr_cpdf_temp.pay_status
1127: ,g_ghr_cpdf_temp.personnel_office_id
1128: ,g_ghr_cpdf_temp.position_occupied
1129: ,g_ghr_cpdf_temp.race_national_origin
1130: ,g_ghr_cpdf_temp.rating_of_record
1131: ,g_ghr_cpdf_temp.rating_of_record_level
1132: ,g_ghr_cpdf_temp.rating_of_record_pattern
1133: ,g_ghr_cpdf_temp.rating_of_record_period_ends
1134: ,g_ghr_cpdf_temp.retained_grade_or_level
1127: ,g_ghr_cpdf_temp.personnel_office_id
1128: ,g_ghr_cpdf_temp.position_occupied
1129: ,g_ghr_cpdf_temp.race_national_origin
1130: ,g_ghr_cpdf_temp.rating_of_record
1131: ,g_ghr_cpdf_temp.rating_of_record_level
1132: ,g_ghr_cpdf_temp.rating_of_record_pattern
1133: ,g_ghr_cpdf_temp.rating_of_record_period_ends
1134: ,g_ghr_cpdf_temp.retained_grade_or_level
1135: ,g_ghr_cpdf_temp.retained_pay_plan
1128: ,g_ghr_cpdf_temp.position_occupied
1129: ,g_ghr_cpdf_temp.race_national_origin
1130: ,g_ghr_cpdf_temp.rating_of_record
1131: ,g_ghr_cpdf_temp.rating_of_record_level
1132: ,g_ghr_cpdf_temp.rating_of_record_pattern
1133: ,g_ghr_cpdf_temp.rating_of_record_period_ends
1134: ,g_ghr_cpdf_temp.retained_grade_or_level
1135: ,g_ghr_cpdf_temp.retained_pay_plan
1136: ,g_ghr_cpdf_temp.retained_step_or_rate
1129: ,g_ghr_cpdf_temp.race_national_origin
1130: ,g_ghr_cpdf_temp.rating_of_record
1131: ,g_ghr_cpdf_temp.rating_of_record_level
1132: ,g_ghr_cpdf_temp.rating_of_record_pattern
1133: ,g_ghr_cpdf_temp.rating_of_record_period_ends
1134: ,g_ghr_cpdf_temp.retained_grade_or_level
1135: ,g_ghr_cpdf_temp.retained_pay_plan
1136: ,g_ghr_cpdf_temp.retained_step_or_rate
1137: ,g_ghr_cpdf_temp.retirement_plan
1130: ,g_ghr_cpdf_temp.rating_of_record
1131: ,g_ghr_cpdf_temp.rating_of_record_level
1132: ,g_ghr_cpdf_temp.rating_of_record_pattern
1133: ,g_ghr_cpdf_temp.rating_of_record_period_ends
1134: ,g_ghr_cpdf_temp.retained_grade_or_level
1135: ,g_ghr_cpdf_temp.retained_pay_plan
1136: ,g_ghr_cpdf_temp.retained_step_or_rate
1137: ,g_ghr_cpdf_temp.retirement_plan
1138: ,g_ghr_cpdf_temp.second_noa_code
1131: ,g_ghr_cpdf_temp.rating_of_record_level
1132: ,g_ghr_cpdf_temp.rating_of_record_pattern
1133: ,g_ghr_cpdf_temp.rating_of_record_period_ends
1134: ,g_ghr_cpdf_temp.retained_grade_or_level
1135: ,g_ghr_cpdf_temp.retained_pay_plan
1136: ,g_ghr_cpdf_temp.retained_step_or_rate
1137: ,g_ghr_cpdf_temp.retirement_plan
1138: ,g_ghr_cpdf_temp.second_noa_code
1139: ,g_ghr_cpdf_temp.service_comp_date
1132: ,g_ghr_cpdf_temp.rating_of_record_pattern
1133: ,g_ghr_cpdf_temp.rating_of_record_period_ends
1134: ,g_ghr_cpdf_temp.retained_grade_or_level
1135: ,g_ghr_cpdf_temp.retained_pay_plan
1136: ,g_ghr_cpdf_temp.retained_step_or_rate
1137: ,g_ghr_cpdf_temp.retirement_plan
1138: ,g_ghr_cpdf_temp.second_noa_code
1139: ,g_ghr_cpdf_temp.service_comp_date
1140: ,g_ghr_cpdf_temp.sex
1133: ,g_ghr_cpdf_temp.rating_of_record_period_ends
1134: ,g_ghr_cpdf_temp.retained_grade_or_level
1135: ,g_ghr_cpdf_temp.retained_pay_plan
1136: ,g_ghr_cpdf_temp.retained_step_or_rate
1137: ,g_ghr_cpdf_temp.retirement_plan
1138: ,g_ghr_cpdf_temp.second_noa_code
1139: ,g_ghr_cpdf_temp.service_comp_date
1140: ,g_ghr_cpdf_temp.sex
1141: ,g_ghr_cpdf_temp.supervisory_status
1134: ,g_ghr_cpdf_temp.retained_grade_or_level
1135: ,g_ghr_cpdf_temp.retained_pay_plan
1136: ,g_ghr_cpdf_temp.retained_step_or_rate
1137: ,g_ghr_cpdf_temp.retirement_plan
1138: ,g_ghr_cpdf_temp.second_noa_code
1139: ,g_ghr_cpdf_temp.service_comp_date
1140: ,g_ghr_cpdf_temp.sex
1141: ,g_ghr_cpdf_temp.supervisory_status
1142: ,g_ghr_cpdf_temp.tenure
1135: ,g_ghr_cpdf_temp.retained_pay_plan
1136: ,g_ghr_cpdf_temp.retained_step_or_rate
1137: ,g_ghr_cpdf_temp.retirement_plan
1138: ,g_ghr_cpdf_temp.second_noa_code
1139: ,g_ghr_cpdf_temp.service_comp_date
1140: ,g_ghr_cpdf_temp.sex
1141: ,g_ghr_cpdf_temp.supervisory_status
1142: ,g_ghr_cpdf_temp.tenure
1143: ,g_ghr_cpdf_temp.to_basic_pay
1136: ,g_ghr_cpdf_temp.retained_step_or_rate
1137: ,g_ghr_cpdf_temp.retirement_plan
1138: ,g_ghr_cpdf_temp.second_noa_code
1139: ,g_ghr_cpdf_temp.service_comp_date
1140: ,g_ghr_cpdf_temp.sex
1141: ,g_ghr_cpdf_temp.supervisory_status
1142: ,g_ghr_cpdf_temp.tenure
1143: ,g_ghr_cpdf_temp.to_basic_pay
1144: ,g_ghr_cpdf_temp.to_grade_or_level
1137: ,g_ghr_cpdf_temp.retirement_plan
1138: ,g_ghr_cpdf_temp.second_noa_code
1139: ,g_ghr_cpdf_temp.service_comp_date
1140: ,g_ghr_cpdf_temp.sex
1141: ,g_ghr_cpdf_temp.supervisory_status
1142: ,g_ghr_cpdf_temp.tenure
1143: ,g_ghr_cpdf_temp.to_basic_pay
1144: ,g_ghr_cpdf_temp.to_grade_or_level
1145: ,g_ghr_cpdf_temp.to_locality_adj
1138: ,g_ghr_cpdf_temp.second_noa_code
1139: ,g_ghr_cpdf_temp.service_comp_date
1140: ,g_ghr_cpdf_temp.sex
1141: ,g_ghr_cpdf_temp.supervisory_status
1142: ,g_ghr_cpdf_temp.tenure
1143: ,g_ghr_cpdf_temp.to_basic_pay
1144: ,g_ghr_cpdf_temp.to_grade_or_level
1145: ,g_ghr_cpdf_temp.to_locality_adj
1146: ,g_ghr_cpdf_temp.to_national_identifier
1139: ,g_ghr_cpdf_temp.service_comp_date
1140: ,g_ghr_cpdf_temp.sex
1141: ,g_ghr_cpdf_temp.supervisory_status
1142: ,g_ghr_cpdf_temp.tenure
1143: ,g_ghr_cpdf_temp.to_basic_pay
1144: ,g_ghr_cpdf_temp.to_grade_or_level
1145: ,g_ghr_cpdf_temp.to_locality_adj
1146: ,g_ghr_cpdf_temp.to_national_identifier
1147: ,g_ghr_cpdf_temp.to_occ_code
1140: ,g_ghr_cpdf_temp.sex
1141: ,g_ghr_cpdf_temp.supervisory_status
1142: ,g_ghr_cpdf_temp.tenure
1143: ,g_ghr_cpdf_temp.to_basic_pay
1144: ,g_ghr_cpdf_temp.to_grade_or_level
1145: ,g_ghr_cpdf_temp.to_locality_adj
1146: ,g_ghr_cpdf_temp.to_national_identifier
1147: ,g_ghr_cpdf_temp.to_occ_code
1148: ,g_ghr_cpdf_temp.to_pay_basis
1141: ,g_ghr_cpdf_temp.supervisory_status
1142: ,g_ghr_cpdf_temp.tenure
1143: ,g_ghr_cpdf_temp.to_basic_pay
1144: ,g_ghr_cpdf_temp.to_grade_or_level
1145: ,g_ghr_cpdf_temp.to_locality_adj
1146: ,g_ghr_cpdf_temp.to_national_identifier
1147: ,g_ghr_cpdf_temp.to_occ_code
1148: ,g_ghr_cpdf_temp.to_pay_basis
1149: ,g_ghr_cpdf_temp.to_pay_plan
1142: ,g_ghr_cpdf_temp.tenure
1143: ,g_ghr_cpdf_temp.to_basic_pay
1144: ,g_ghr_cpdf_temp.to_grade_or_level
1145: ,g_ghr_cpdf_temp.to_locality_adj
1146: ,g_ghr_cpdf_temp.to_national_identifier
1147: ,g_ghr_cpdf_temp.to_occ_code
1148: ,g_ghr_cpdf_temp.to_pay_basis
1149: ,g_ghr_cpdf_temp.to_pay_plan
1150: ,g_ghr_cpdf_temp.to_pay_rate_determinant
1143: ,g_ghr_cpdf_temp.to_basic_pay
1144: ,g_ghr_cpdf_temp.to_grade_or_level
1145: ,g_ghr_cpdf_temp.to_locality_adj
1146: ,g_ghr_cpdf_temp.to_national_identifier
1147: ,g_ghr_cpdf_temp.to_occ_code
1148: ,g_ghr_cpdf_temp.to_pay_basis
1149: ,g_ghr_cpdf_temp.to_pay_plan
1150: ,g_ghr_cpdf_temp.to_pay_rate_determinant
1151: ,g_ghr_cpdf_temp.to_pay_table_id
1144: ,g_ghr_cpdf_temp.to_grade_or_level
1145: ,g_ghr_cpdf_temp.to_locality_adj
1146: ,g_ghr_cpdf_temp.to_national_identifier
1147: ,g_ghr_cpdf_temp.to_occ_code
1148: ,g_ghr_cpdf_temp.to_pay_basis
1149: ,g_ghr_cpdf_temp.to_pay_plan
1150: ,g_ghr_cpdf_temp.to_pay_rate_determinant
1151: ,g_ghr_cpdf_temp.to_pay_table_id
1152: ,g_ghr_cpdf_temp.to_retention_allowance
1145: ,g_ghr_cpdf_temp.to_locality_adj
1146: ,g_ghr_cpdf_temp.to_national_identifier
1147: ,g_ghr_cpdf_temp.to_occ_code
1148: ,g_ghr_cpdf_temp.to_pay_basis
1149: ,g_ghr_cpdf_temp.to_pay_plan
1150: ,g_ghr_cpdf_temp.to_pay_rate_determinant
1151: ,g_ghr_cpdf_temp.to_pay_table_id
1152: ,g_ghr_cpdf_temp.to_retention_allowance
1153: ,g_ghr_cpdf_temp.to_staffing_differential
1146: ,g_ghr_cpdf_temp.to_national_identifier
1147: ,g_ghr_cpdf_temp.to_occ_code
1148: ,g_ghr_cpdf_temp.to_pay_basis
1149: ,g_ghr_cpdf_temp.to_pay_plan
1150: ,g_ghr_cpdf_temp.to_pay_rate_determinant
1151: ,g_ghr_cpdf_temp.to_pay_table_id
1152: ,g_ghr_cpdf_temp.to_retention_allowance
1153: ,g_ghr_cpdf_temp.to_staffing_differential
1154: ,g_ghr_cpdf_temp.to_step_or_rate
1147: ,g_ghr_cpdf_temp.to_occ_code
1148: ,g_ghr_cpdf_temp.to_pay_basis
1149: ,g_ghr_cpdf_temp.to_pay_plan
1150: ,g_ghr_cpdf_temp.to_pay_rate_determinant
1151: ,g_ghr_cpdf_temp.to_pay_table_id
1152: ,g_ghr_cpdf_temp.to_retention_allowance
1153: ,g_ghr_cpdf_temp.to_staffing_differential
1154: ,g_ghr_cpdf_temp.to_step_or_rate
1155: ,g_ghr_cpdf_temp.to_supervisory_differential
1148: ,g_ghr_cpdf_temp.to_pay_basis
1149: ,g_ghr_cpdf_temp.to_pay_plan
1150: ,g_ghr_cpdf_temp.to_pay_rate_determinant
1151: ,g_ghr_cpdf_temp.to_pay_table_id
1152: ,g_ghr_cpdf_temp.to_retention_allowance
1153: ,g_ghr_cpdf_temp.to_staffing_differential
1154: ,g_ghr_cpdf_temp.to_step_or_rate
1155: ,g_ghr_cpdf_temp.to_supervisory_differential
1156: ,g_ghr_cpdf_temp.to_total_salary
1149: ,g_ghr_cpdf_temp.to_pay_plan
1150: ,g_ghr_cpdf_temp.to_pay_rate_determinant
1151: ,g_ghr_cpdf_temp.to_pay_table_id
1152: ,g_ghr_cpdf_temp.to_retention_allowance
1153: ,g_ghr_cpdf_temp.to_staffing_differential
1154: ,g_ghr_cpdf_temp.to_step_or_rate
1155: ,g_ghr_cpdf_temp.to_supervisory_differential
1156: ,g_ghr_cpdf_temp.to_total_salary
1157: ,g_ghr_cpdf_temp.to_work_schedule
1150: ,g_ghr_cpdf_temp.to_pay_rate_determinant
1151: ,g_ghr_cpdf_temp.to_pay_table_id
1152: ,g_ghr_cpdf_temp.to_retention_allowance
1153: ,g_ghr_cpdf_temp.to_staffing_differential
1154: ,g_ghr_cpdf_temp.to_step_or_rate
1155: ,g_ghr_cpdf_temp.to_supervisory_differential
1156: ,g_ghr_cpdf_temp.to_total_salary
1157: ,g_ghr_cpdf_temp.to_work_schedule
1158: ,g_ghr_cpdf_temp.veterans_preference
1151: ,g_ghr_cpdf_temp.to_pay_table_id
1152: ,g_ghr_cpdf_temp.to_retention_allowance
1153: ,g_ghr_cpdf_temp.to_staffing_differential
1154: ,g_ghr_cpdf_temp.to_step_or_rate
1155: ,g_ghr_cpdf_temp.to_supervisory_differential
1156: ,g_ghr_cpdf_temp.to_total_salary
1157: ,g_ghr_cpdf_temp.to_work_schedule
1158: ,g_ghr_cpdf_temp.veterans_preference
1159: ,g_ghr_cpdf_temp.veterans_status
1152: ,g_ghr_cpdf_temp.to_retention_allowance
1153: ,g_ghr_cpdf_temp.to_staffing_differential
1154: ,g_ghr_cpdf_temp.to_step_or_rate
1155: ,g_ghr_cpdf_temp.to_supervisory_differential
1156: ,g_ghr_cpdf_temp.to_total_salary
1157: ,g_ghr_cpdf_temp.to_work_schedule
1158: ,g_ghr_cpdf_temp.veterans_preference
1159: ,g_ghr_cpdf_temp.veterans_status
1160: ,g_ghr_cpdf_temp.year_degree_attained,
1153: ,g_ghr_cpdf_temp.to_staffing_differential
1154: ,g_ghr_cpdf_temp.to_step_or_rate
1155: ,g_ghr_cpdf_temp.to_supervisory_differential
1156: ,g_ghr_cpdf_temp.to_total_salary
1157: ,g_ghr_cpdf_temp.to_work_schedule
1158: ,g_ghr_cpdf_temp.veterans_preference
1159: ,g_ghr_cpdf_temp.veterans_status
1160: ,g_ghr_cpdf_temp.year_degree_attained,
1161: -- p_ghr_cpdf_temp_rec.employee_first_name,
1154: ,g_ghr_cpdf_temp.to_step_or_rate
1155: ,g_ghr_cpdf_temp.to_supervisory_differential
1156: ,g_ghr_cpdf_temp.to_total_salary
1157: ,g_ghr_cpdf_temp.to_work_schedule
1158: ,g_ghr_cpdf_temp.veterans_preference
1159: ,g_ghr_cpdf_temp.veterans_status
1160: ,g_ghr_cpdf_temp.year_degree_attained,
1161: -- p_ghr_cpdf_temp_rec.employee_first_name,
1162: -- p_ghr_cpdf_temp_rec.employee_middle_names,
1155: ,g_ghr_cpdf_temp.to_supervisory_differential
1156: ,g_ghr_cpdf_temp.to_total_salary
1157: ,g_ghr_cpdf_temp.to_work_schedule
1158: ,g_ghr_cpdf_temp.veterans_preference
1159: ,g_ghr_cpdf_temp.veterans_status
1160: ,g_ghr_cpdf_temp.year_degree_attained,
1161: -- p_ghr_cpdf_temp_rec.employee_first_name,
1162: -- p_ghr_cpdf_temp_rec.employee_middle_names,
1163: g_ghr_cpdf_temp.name_title,
1156: ,g_ghr_cpdf_temp.to_total_salary
1157: ,g_ghr_cpdf_temp.to_work_schedule
1158: ,g_ghr_cpdf_temp.veterans_preference
1159: ,g_ghr_cpdf_temp.veterans_status
1160: ,g_ghr_cpdf_temp.year_degree_attained,
1161: -- p_ghr_cpdf_temp_rec.employee_first_name,
1162: -- p_ghr_cpdf_temp_rec.employee_middle_names,
1163: g_ghr_cpdf_temp.name_title,
1164: g_ghr_cpdf_temp.position_title,
1157: ,g_ghr_cpdf_temp.to_work_schedule
1158: ,g_ghr_cpdf_temp.veterans_preference
1159: ,g_ghr_cpdf_temp.veterans_status
1160: ,g_ghr_cpdf_temp.year_degree_attained,
1161: -- p_ghr_cpdf_temp_rec.employee_first_name,
1162: -- p_ghr_cpdf_temp_rec.employee_middle_names,
1163: g_ghr_cpdf_temp.name_title,
1164: g_ghr_cpdf_temp.position_title,
1165: g_ghr_cpdf_temp.award_dollars,
1158: ,g_ghr_cpdf_temp.veterans_preference
1159: ,g_ghr_cpdf_temp.veterans_status
1160: ,g_ghr_cpdf_temp.year_degree_attained,
1161: -- p_ghr_cpdf_temp_rec.employee_first_name,
1162: -- p_ghr_cpdf_temp_rec.employee_middle_names,
1163: g_ghr_cpdf_temp.name_title,
1164: g_ghr_cpdf_temp.position_title,
1165: g_ghr_cpdf_temp.award_dollars,
1166: g_ghr_cpdf_temp.award_hours,
1159: ,g_ghr_cpdf_temp.veterans_status
1160: ,g_ghr_cpdf_temp.year_degree_attained,
1161: -- p_ghr_cpdf_temp_rec.employee_first_name,
1162: -- p_ghr_cpdf_temp_rec.employee_middle_names,
1163: g_ghr_cpdf_temp.name_title,
1164: g_ghr_cpdf_temp.position_title,
1165: g_ghr_cpdf_temp.award_dollars,
1166: g_ghr_cpdf_temp.award_hours,
1167: g_ghr_cpdf_temp.award_percentage,
1160: ,g_ghr_cpdf_temp.year_degree_attained,
1161: -- p_ghr_cpdf_temp_rec.employee_first_name,
1162: -- p_ghr_cpdf_temp_rec.employee_middle_names,
1163: g_ghr_cpdf_temp.name_title,
1164: g_ghr_cpdf_temp.position_title,
1165: g_ghr_cpdf_temp.award_dollars,
1166: g_ghr_cpdf_temp.award_hours,
1167: g_ghr_cpdf_temp.award_percentage,
1168: g_ghr_cpdf_temp.SCD_retirement,
1161: -- p_ghr_cpdf_temp_rec.employee_first_name,
1162: -- p_ghr_cpdf_temp_rec.employee_middle_names,
1163: g_ghr_cpdf_temp.name_title,
1164: g_ghr_cpdf_temp.position_title,
1165: g_ghr_cpdf_temp.award_dollars,
1166: g_ghr_cpdf_temp.award_hours,
1167: g_ghr_cpdf_temp.award_percentage,
1168: g_ghr_cpdf_temp.SCD_retirement,
1169: g_ghr_cpdf_temp.SCD_rif,
1162: -- p_ghr_cpdf_temp_rec.employee_middle_names,
1163: g_ghr_cpdf_temp.name_title,
1164: g_ghr_cpdf_temp.position_title,
1165: g_ghr_cpdf_temp.award_dollars,
1166: g_ghr_cpdf_temp.award_hours,
1167: g_ghr_cpdf_temp.award_percentage,
1168: g_ghr_cpdf_temp.SCD_retirement,
1169: g_ghr_cpdf_temp.SCD_rif,
1170: g_ghr_cpdf_temp.race_ethnic_info
1163: g_ghr_cpdf_temp.name_title,
1164: g_ghr_cpdf_temp.position_title,
1165: g_ghr_cpdf_temp.award_dollars,
1166: g_ghr_cpdf_temp.award_hours,
1167: g_ghr_cpdf_temp.award_percentage,
1168: g_ghr_cpdf_temp.SCD_retirement,
1169: g_ghr_cpdf_temp.SCD_rif,
1170: g_ghr_cpdf_temp.race_ethnic_info
1171: -- 1,sysdate,1,sysdate,1
1164: g_ghr_cpdf_temp.position_title,
1165: g_ghr_cpdf_temp.award_dollars,
1166: g_ghr_cpdf_temp.award_hours,
1167: g_ghr_cpdf_temp.award_percentage,
1168: g_ghr_cpdf_temp.SCD_retirement,
1169: g_ghr_cpdf_temp.SCD_rif,
1170: g_ghr_cpdf_temp.race_ethnic_info
1171: -- 1,sysdate,1,sysdate,1
1172: );
1165: g_ghr_cpdf_temp.award_dollars,
1166: g_ghr_cpdf_temp.award_hours,
1167: g_ghr_cpdf_temp.award_percentage,
1168: g_ghr_cpdf_temp.SCD_retirement,
1169: g_ghr_cpdf_temp.SCD_rif,
1170: g_ghr_cpdf_temp.race_ethnic_info
1171: -- 1,sysdate,1,sysdate,1
1172: );
1173: END insert_row;
1166: g_ghr_cpdf_temp.award_hours,
1167: g_ghr_cpdf_temp.award_percentage,
1168: g_ghr_cpdf_temp.SCD_retirement,
1169: g_ghr_cpdf_temp.SCD_rif,
1170: g_ghr_cpdf_temp.race_ethnic_info
1171: -- 1,sysdate,1,sysdate,1
1172: );
1173: END insert_row;
1174:
1179: hr_utility.set_location('Entering:'||l_proc,5);
1180:
1181: -- bug 743502 moved the checking of agency code matching the parameter passed in to
1182: -- to as soon as possible, not here at the end!
1183: DELETE FROM ghr_cpdf_temp
1184: WHERE (report_type='STATUS')
1185: AND (
1186: -- *** SUPPRESS NON APPROPRIATED EMPLOYEES / COMMISSIONED OFFICERS
1187: ( to_pay_plan IN ('NA','NL','NS','CC') )
1244: END IF;
1245: CLOSE GET_SUFFIX;
1246: END get_suffix_lname;
1247:
1248: PROCEDURE populate_ghr_cpdf_temp (p_agency IN VARCHAR2,
1249: p_report_date IN DATE)
1250: IS
1251: l_proc varchar2(30) := 'populate_ghr_cpdf_temp';
1252: CURSOR assignments_f_cur is
1247:
1248: PROCEDURE populate_ghr_cpdf_temp (p_agency IN VARCHAR2,
1249: p_report_date IN DATE)
1250: IS
1251: l_proc varchar2(30) := 'populate_ghr_cpdf_temp';
1252: CURSOR assignments_f_cur is
1253: SELECT asg.assignment_id,
1254: asg.person_id,
1255: asg.position_id,
1354: g_position_id := l_assignments_f_rec.position_id;
1355: g_grade_id := l_assignments_f_rec.grade_id;
1356: g_job_id := l_assignments_f_rec.job_id;
1357: g_location_id := l_assignments_f_rec.location_id;
1358: g_ghr_cpdf_temp.agency_code := l_assignments_f_rec.agency_code;
1359: -- added for EHRI reports
1360: l_business_group_id := l_assignments_f_rec.business_group_id;
1361: -- added for EHRI reports
1362:
1375: get_suffix_lname(per_det.last_name,
1376: p_report_date,
1377: l_suffix,
1378: l_last_name);
1379: g_ghr_cpdf_temp.employee_last_name := l_last_name;
1380: g_ghr_cpdf_temp.employee_first_name := per_det.first_name;
1381: g_ghr_cpdf_temp.employee_middle_names := per_det.middle_names;
1382: g_ghr_cpdf_temp.name_title := l_suffix;
1383: --End Bug# 4648811
1376: p_report_date,
1377: l_suffix,
1378: l_last_name);
1379: g_ghr_cpdf_temp.employee_last_name := l_last_name;
1380: g_ghr_cpdf_temp.employee_first_name := per_det.first_name;
1381: g_ghr_cpdf_temp.employee_middle_names := per_det.middle_names;
1382: g_ghr_cpdf_temp.name_title := l_suffix;
1383: --End Bug# 4648811
1384: END LOOP;
1377: l_suffix,
1378: l_last_name);
1379: g_ghr_cpdf_temp.employee_last_name := l_last_name;
1380: g_ghr_cpdf_temp.employee_first_name := per_det.first_name;
1381: g_ghr_cpdf_temp.employee_middle_names := per_det.middle_names;
1382: g_ghr_cpdf_temp.name_title := l_suffix;
1383: --End Bug# 4648811
1384: END LOOP;
1385:
1378: l_last_name);
1379: g_ghr_cpdf_temp.employee_last_name := l_last_name;
1380: g_ghr_cpdf_temp.employee_first_name := per_det.first_name;
1381: g_ghr_cpdf_temp.employee_middle_names := per_det.middle_names;
1382: g_ghr_cpdf_temp.name_title := l_suffix;
1383: --End Bug# 4648811
1384: END LOOP;
1385:
1386:
1389: g_message_name := 'Fetch Position title';
1390: --l_message_name :='get_position_title_pos';
1391: -- End Bug# 4168162
1392:
1393: g_ghr_cpdf_temp.position_title := ghr_api.get_position_title_pos(
1394: p_position_id => g_position_id,
1395: p_business_group_id => l_business_group_id,
1396: p_effective_date => g_report_date);
1397:
1402: p_date_effective => nvl(g_report_date,trunc(sysdate)),
1403: p_per_ei_data => ll_per_ei_data
1404: );
1405:
1406: g_ghr_cpdf_temp.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);
1407: g_ghr_cpdf_temp.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);
1408: */
1409: --
1410: -- Bug 3671043 Handling Exceptions (madhuri)
1403: p_per_ei_data => ll_per_ei_data
1404: );
1405:
1406: g_ghr_cpdf_temp.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);
1407: g_ghr_cpdf_temp.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);
1408: */
1409: --
1410: -- Bug 3671043 Handling Exceptions (madhuri)
1411: -- Begin Bug# 4168162
1423: get_from_history_asgnei
1424: (
1425: p_sr_assignment_id => g_assignment_id
1426: ,p_sr_report_date => g_report_date
1427: ,p_sr_ghr_cpdf_temp => g_ghr_cpdf_temp
1428: );
1429: -- FWFA Change Get pay table id
1430: -- Bug#5063289 Fetch the First 4 characters of Pay table name.
1431: FOR pay_table_rec IN c_pay_table_name(g_ghr_cpdf_temp.to_pay_table_id)
1427: ,p_sr_ghr_cpdf_temp => g_ghr_cpdf_temp
1428: );
1429: -- FWFA Change Get pay table id
1430: -- Bug#5063289 Fetch the First 4 characters of Pay table name.
1431: FOR pay_table_rec IN c_pay_table_name(g_ghr_cpdf_temp.to_pay_table_id)
1432: LOOP
1433: l_calc_pay_table_id := pay_table_rec.user_table_name;
1434: END LOOP;
1435:
1439: get_from_history_payele
1440: (
1441: p_sr_assignment_id => g_assignment_id
1442: ,p_sr_report_date => g_report_date
1443: ,p_sr_ghr_cpdf_temp => g_ghr_cpdf_temp
1444: );
1445:
1446: -- Begin Bug# 4168162
1447: g_message_name := 'Fetch Person Details';
1450: get_from_history_people
1451: (
1452: p_sr_person_id => g_person_id
1453: ,p_sr_report_date => g_report_date
1454: ,p_sr_ghr_cpdf_temp => g_ghr_cpdf_temp
1455: ); -- g_ghr_cpdf_temp.to_national_identifier
1456:
1457: -- Begin Bug# 4168162
1458: --l_message_name := 'get_from_history_ancrit';
1451: (
1452: p_sr_person_id => g_person_id
1453: ,p_sr_report_date => g_report_date
1454: ,p_sr_ghr_cpdf_temp => g_ghr_cpdf_temp
1455: ); -- g_ghr_cpdf_temp.to_national_identifier
1456:
1457: -- Begin Bug# 4168162
1458: --l_message_name := 'get_from_history_ancrit';
1459: -- End Bug# 4168162
1460: get_from_history_ancrit
1461: (
1462: p_sr_person_id => g_person_id
1463: ,p_sr_report_date => g_report_date
1464: ,p_sr_ghr_cpdf_temp => g_ghr_cpdf_temp
1465: );
1466:
1467: -- Begin Bug# 4168162
1468: --l_message_name := 'get_from_history_peopei';
1470: get_from_history_peopei
1471: (
1472: p_sr_person_id => g_person_id
1473: ,p_sr_report_date => g_report_date
1474: ,p_sr_ghr_cpdf_temp => g_ghr_cpdf_temp
1475: );
1476:
1477: IF g_position_id IS NOT NULL
1478: THEN
1482: get_from_history_posiei
1483: (
1484: p_sr_position_id => g_position_id
1485: ,p_sr_report_date => g_report_date
1486: ,p_sr_ghr_cpdf_temp => g_ghr_cpdf_temp
1487: );
1488: END IF;
1489:
1490:
1497: get_from_history_gradef
1498: (
1499: p_sr_grade_id => g_grade_id
1500: ,p_sr_report_date => g_report_date
1501: ,p_sr_ghr_cpdf_temp => g_ghr_cpdf_temp
1502: );
1503: END IF;
1504:
1505: IF g_job_id IS NOT NULL
1511: get_from_history_jobdef
1512: (
1513: p_sr_job_id => g_job_id
1514: ,p_sr_report_date => g_report_date
1515: ,p_sr_ghr_cpdf_temp => g_ghr_cpdf_temp
1516: );
1517: END IF;
1518:
1519: IF g_location_id IS NOT NULL
1524: get_from_history_dutsta
1525: (
1526: p_sr_location_id => g_location_id
1527: ,p_sr_report_date => g_report_date
1528: ,p_sr_ghr_cpdf_temp => g_ghr_cpdf_temp
1529: );
1530: END IF;
1531:
1532:
1530: END IF;
1531:
1532:
1533: -- If Ethnicity is reported, RNO should be null
1534: IF g_ghr_cpdf_temp.race_ethnic_info IS NOT NULL THEN
1535: g_ghr_cpdf_temp.race_national_origin := NULL;
1536: END IF;
1537:
1538: -- FWFA Change Override pay table id with that retrieved from Assignment
1531:
1532:
1533: -- If Ethnicity is reported, RNO should be null
1534: IF g_ghr_cpdf_temp.race_ethnic_info IS NOT NULL THEN
1535: g_ghr_cpdf_temp.race_national_origin := NULL;
1536: END IF;
1537:
1538: -- FWFA Change Override pay table id with that retrieved from Assignment
1539:
1537:
1538: -- FWFA Change Override pay table id with that retrieved from Assignment
1539:
1540: IF l_calc_pay_table_id IS NOT NULL THEN
1541: IF pp_gs_equivalent(g_ghr_cpdf_temp.to_pay_plan) AND
1542: g_ghr_cpdf_temp.to_pay_rate_determinant IN ('5','6','E','F') THEN
1543: g_ghr_cpdf_temp.to_pay_table_id := l_calc_pay_table_id;
1544: ELSE
1545: g_ghr_cpdf_temp.to_pay_table_id := NULL;
1538: -- FWFA Change Override pay table id with that retrieved from Assignment
1539:
1540: IF l_calc_pay_table_id IS NOT NULL THEN
1541: IF pp_gs_equivalent(g_ghr_cpdf_temp.to_pay_plan) AND
1542: g_ghr_cpdf_temp.to_pay_rate_determinant IN ('5','6','E','F') THEN
1543: g_ghr_cpdf_temp.to_pay_table_id := l_calc_pay_table_id;
1544: ELSE
1545: g_ghr_cpdf_temp.to_pay_table_id := NULL;
1546: END IF;
1539:
1540: IF l_calc_pay_table_id IS NOT NULL THEN
1541: IF pp_gs_equivalent(g_ghr_cpdf_temp.to_pay_plan) AND
1542: g_ghr_cpdf_temp.to_pay_rate_determinant IN ('5','6','E','F') THEN
1543: g_ghr_cpdf_temp.to_pay_table_id := l_calc_pay_table_id;
1544: ELSE
1545: g_ghr_cpdf_temp.to_pay_table_id := NULL;
1546: END IF;
1547: ELSE
1541: IF pp_gs_equivalent(g_ghr_cpdf_temp.to_pay_plan) AND
1542: g_ghr_cpdf_temp.to_pay_rate_determinant IN ('5','6','E','F') THEN
1543: g_ghr_cpdf_temp.to_pay_table_id := l_calc_pay_table_id;
1544: ELSE
1545: g_ghr_cpdf_temp.to_pay_table_id := NULL;
1546: END IF;
1547: ELSE
1548: IF g_ghr_cpdf_temp.to_pay_rate_determinant IN ('5','6') AND
1549: pp_gs_equivalent(g_ghr_cpdf_temp.to_pay_plan) THEN
1544: ELSE
1545: g_ghr_cpdf_temp.to_pay_table_id := NULL;
1546: END IF;
1547: ELSE
1548: IF g_ghr_cpdf_temp.to_pay_rate_determinant IN ('5','6') AND
1549: pp_gs_equivalent(g_ghr_cpdf_temp.to_pay_plan) THEN
1550: FOR pay_table_rec IN c_pay_table_name(g_ghr_cpdf_temp.to_pay_table_id)
1551: LOOP
1552: g_ghr_cpdf_temp.to_pay_table_id := pay_table_rec.user_table_name;
1545: g_ghr_cpdf_temp.to_pay_table_id := NULL;
1546: END IF;
1547: ELSE
1548: IF g_ghr_cpdf_temp.to_pay_rate_determinant IN ('5','6') AND
1549: pp_gs_equivalent(g_ghr_cpdf_temp.to_pay_plan) THEN
1550: FOR pay_table_rec IN c_pay_table_name(g_ghr_cpdf_temp.to_pay_table_id)
1551: LOOP
1552: g_ghr_cpdf_temp.to_pay_table_id := pay_table_rec.user_table_name;
1553: END LOOP;
1546: END IF;
1547: ELSE
1548: IF g_ghr_cpdf_temp.to_pay_rate_determinant IN ('5','6') AND
1549: pp_gs_equivalent(g_ghr_cpdf_temp.to_pay_plan) THEN
1550: FOR pay_table_rec IN c_pay_table_name(g_ghr_cpdf_temp.to_pay_table_id)
1551: LOOP
1552: g_ghr_cpdf_temp.to_pay_table_id := pay_table_rec.user_table_name;
1553: END LOOP;
1554: ELSIF g_ghr_cpdf_temp.to_pay_rate_determinant in ('E','F') AND
1548: IF g_ghr_cpdf_temp.to_pay_rate_determinant IN ('5','6') AND
1549: pp_gs_equivalent(g_ghr_cpdf_temp.to_pay_plan) THEN
1550: FOR pay_table_rec IN c_pay_table_name(g_ghr_cpdf_temp.to_pay_table_id)
1551: LOOP
1552: g_ghr_cpdf_temp.to_pay_table_id := pay_table_rec.user_table_name;
1553: END LOOP;
1554: ELSIF g_ghr_cpdf_temp.to_pay_rate_determinant in ('E','F') AND
1555: pp_gs_equivalent(g_ghr_cpdf_temp.retained_pay_plan) THEN
1556: FOR pay_table_rec IN c_pay_table_name(g_retained_pay_table_id)
1550: FOR pay_table_rec IN c_pay_table_name(g_ghr_cpdf_temp.to_pay_table_id)
1551: LOOP
1552: g_ghr_cpdf_temp.to_pay_table_id := pay_table_rec.user_table_name;
1553: END LOOP;
1554: ELSIF g_ghr_cpdf_temp.to_pay_rate_determinant in ('E','F') AND
1555: pp_gs_equivalent(g_ghr_cpdf_temp.retained_pay_plan) THEN
1556: FOR pay_table_rec IN c_pay_table_name(g_retained_pay_table_id)
1557: LOOP
1558: g_ghr_cpdf_temp.to_pay_table_id := pay_table_rec.user_table_name;
1551: LOOP
1552: g_ghr_cpdf_temp.to_pay_table_id := pay_table_rec.user_table_name;
1553: END LOOP;
1554: ELSIF g_ghr_cpdf_temp.to_pay_rate_determinant in ('E','F') AND
1555: pp_gs_equivalent(g_ghr_cpdf_temp.retained_pay_plan) THEN
1556: FOR pay_table_rec IN c_pay_table_name(g_retained_pay_table_id)
1557: LOOP
1558: g_ghr_cpdf_temp.to_pay_table_id := pay_table_rec.user_table_name;
1559: END LOOP;
1554: ELSIF g_ghr_cpdf_temp.to_pay_rate_determinant in ('E','F') AND
1555: pp_gs_equivalent(g_ghr_cpdf_temp.retained_pay_plan) THEN
1556: FOR pay_table_rec IN c_pay_table_name(g_retained_pay_table_id)
1557: LOOP
1558: g_ghr_cpdf_temp.to_pay_table_id := pay_table_rec.user_table_name;
1559: END LOOP;
1560: ELSE
1561: g_ghr_cpdf_temp.to_pay_table_id := NULL;
1562: END IF;
1557: LOOP
1558: g_ghr_cpdf_temp.to_pay_table_id := pay_table_rec.user_table_name;
1559: END LOOP;
1560: ELSE
1561: g_ghr_cpdf_temp.to_pay_table_id := NULL;
1562: END IF;
1563: END IF;
1564:
1565: g_message_name := NULL;
1641:
1642: -- purge per design doc
1643: purge_suppression;
1644:
1645: END populate_ghr_cpdf_temp;
1646:
1647: END ghr_cpdf_statrpt;