[Home] [Help]
120: l_position_type VARCHAR2(150);
121: --
122: BEGIN
123: -- first get the Position Type on Position Group 2
124: ghr_history_fetch.fetch_positionei(
125: p_position_id => p_position_id,
126: p_information_type => 'GHR_US_POS_GRP2',
127: p_date_effective => p_effective_date,
128: p_pos_ei_data => l_pos_ei_grp2_data);
148: ,p_org_comp OUT NOCOPY VARCHAR2) IS
149: --
150: l_pos_ei_grp1_data per_position_extra_info%ROWTYPE;
151: BEGIN
152: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id
153: ,p_information_type => 'GHR_US_POS_GRP1'
154: ,p_date_effective => p_effective_date
155: ,p_pos_ei_data => l_pos_ei_grp1_data);
156:
490: -- bug 711711
491: -- if RNO or Handicap code was not filled then get them from HR Person EI
492: IF l_race_national_origin IS NULL
493: OR l_handicap_code IS NULL THEN
494: ghr_history_fetch.fetch_peopleei(
495: p_person_id => p_person_id,
496: p_information_type => 'GHR_US_PER_GROUP1',
497: p_date_effective => p_effective_date,
498: p_per_ei_data => l_per_ei_grp1_data);
508:
509: IF p_race_ethnic_info IS NULL THEN
510: -- Fetching Race and ethnicity category
511: l_per_ei_grp1_data := NULL; -- Bug 4724337
512: ghr_history_fetch.fetch_peopleei
513: (p_person_id => p_person_id,
514: p_information_type => 'GHR_US_PER_ETHNICITY_RACE',
515: p_date_effective => p_effective_date,
516: p_per_ei_data => l_per_ei_grp1_data
590: -- This means we wills tive give values for 5__ NOAC's even though the guide says
591: -- they are not needed?
592: --
593: IF p_from_position_id IS NOT NULL THEN
594: GHR_HISTORY_FETCH.fetch_asgei_prior_root_sf50(p_assignment_id => p_employee_assignment_id
595: ,p_information_type => 'GHR_US_ASG_SF52'
596: ,p_altered_pa_request_id => l_pa_request_id
597: ,p_noa_id_corrected => l_noa_id
598: ,p_date_effective => p_effective_date
601: p_from_work_schedule := l_asgei_data.aei_information7;
602: p_from_pay_rate_determinant := l_asgei_data.aei_information6;
603: --
604: -- Now lets go get the location id which gives us the duty station
605: GHR_HISTORY_FETCH.fetch_asgn_prior_root_sf50(p_assignment_id => p_employee_assignment_id
606: ,p_altered_pa_request_id => l_pa_request_id
607: ,p_noa_id_corrected => l_noa_id
608: ,p_date_effective => p_effective_date
609: ,p_assignment_data => l_asgn_data);
2057: IF (l_ghr_cpdf_temp_rec.SCD_rif IS NULL
2058: and l_ghr_cpdf_temp_rec.SCD_retirement IS NULL) THEN
2059:
2060: BEGIN
2061: ghr_history_fetch.fetch_peopleei
2062: (p_person_id => l_ghr_pa_requests_rec.person_id,
2063: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
2064: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2065: p_per_ei_data => ll_per_ei_data
2178: /* IF ( (l_ghr_pa_requests_rec.first_noa_code='002' and
2179: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') in ('280','292','293'))
2180: OR l_ghr_pa_requests_rec.first_noa_code in ('280','292','293')
2181: ) THEN
2182: ghr_history_fetch.fetch_peopleei
2183: (p_person_id => l_ghr_pa_requests_rec.person_id,
2184: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
2185: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2186: p_per_ei_data => ll_per_ei_data
2197: OR l_ghr_pa_requests_rec.first_noa_code in ('702','703','713','721','781','782','790','800',
2198: '850','855','867','868','891','892','893','895','899')
2199: ) THEN
2200:
2201: ghr_history_fetch.fetch_peopleei
2202: (p_person_id => l_ghr_pa_requests_rec.person_id,
2203: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
2204: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2205: p_per_ei_data => ll_per_ei_data
2207:
2208: l_ghr_cpdf_temp_rec.creditable_military_service:= SUBSTR(ll_per_ei_data.pei_information5,1,4);
2209: ll_per_ei_data :=NULL;
2210:
2211: ghr_history_fetch.fetch_peopleei
2212: (p_person_id => l_ghr_pa_requests_rec.person_id,
2213: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
2214: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2215: p_per_ei_data => ll_per_ei_data