[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);
149: ,p_org_comp OUT NOCOPY VARCHAR2) IS
150: --
151: l_pos_ei_grp1_data per_position_extra_info%ROWTYPE;
152: BEGIN
153: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id
154: ,p_information_type => 'GHR_US_POS_GRP1'
155: ,p_date_effective => p_effective_date
156: ,p_pos_ei_data => l_pos_ei_grp1_data);
157:
491: -- bug 711711
492: -- if RNO or Handicap code was not filled then get them from HR Person EI
493: IF l_race_national_origin IS NULL
494: OR l_handicap_code IS NULL THEN
495: ghr_history_fetch.fetch_peopleei(
496: p_person_id => p_person_id,
497: p_information_type => 'GHR_US_PER_GROUP1',
498: p_date_effective => p_effective_date,
499: p_per_ei_data => l_per_ei_grp1_data);
509:
510: IF p_race_ethnic_info IS NULL THEN
511: -- Fetching Race and ethnicity category
512: l_per_ei_grp1_data := NULL; -- Bug 4724337
513: ghr_history_fetch.fetch_peopleei
514: (p_person_id => p_person_id,
515: p_information_type => 'GHR_US_PER_ETHNICITY_RACE',
516: p_date_effective => p_effective_date,
517: p_per_ei_data => l_per_ei_grp1_data
636: -- This means we wills tive give values for 5__ NOAC's even though the guide says
637: -- they are not needed?
638: --
639: IF p_from_position_id IS NOT NULL THEN
640: GHR_HISTORY_FETCH.fetch_asgei_prior_root_sf50(p_assignment_id => p_employee_assignment_id
641: ,p_information_type => 'GHR_US_ASG_SF52'
642: ,p_altered_pa_request_id => l_pa_request_id
643: ,p_noa_id_corrected => l_noa_id
644: ,p_date_effective => p_effective_date
647: p_from_work_schedule := l_asgei_data.aei_information7;
648: p_from_pay_rate_determinant := l_asgei_data.aei_information6;
649: --
650: -- Now lets go get the location id which gives us the duty station
651: GHR_HISTORY_FETCH.fetch_asgn_prior_root_sf50(p_assignment_id => p_employee_assignment_id
652: ,p_altered_pa_request_id => l_pa_request_id
653: ,p_noa_id_corrected => l_noa_id
654: ,p_date_effective => p_effective_date
655: ,p_assignment_data => l_asgn_data);
2197: IF (l_ghr_cpdf_temp_rec.SCD_rif IS NULL
2198: and l_ghr_cpdf_temp_rec.SCD_retirement IS NULL) THEN
2199:
2200: BEGIN
2201: ghr_history_fetch.fetch_peopleei
2202: (p_person_id => l_ghr_pa_requests_rec.person_id,
2203: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
2204: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2205: p_per_ei_data => ll_per_ei_data
2321: /* IF ( (l_ghr_pa_requests_rec.first_noa_code='002' and
2322: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') in ('280','292','293'))
2323: OR l_ghr_pa_requests_rec.first_noa_code in ('280','292','293')
2324: ) THEN
2325: ghr_history_fetch.fetch_peopleei
2326: (p_person_id => l_ghr_pa_requests_rec.person_id,
2327: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
2328: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2329: p_per_ei_data => ll_per_ei_data
2340: OR l_ghr_pa_requests_rec.first_noa_code in ('702','703','713','721','781','782','790','800',
2341: '850','855','867','868','891','892','893','895','899')
2342: ) THEN
2343:
2344: ghr_history_fetch.fetch_peopleei
2345: (p_person_id => l_ghr_pa_requests_rec.person_id,
2346: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
2347: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2348: p_per_ei_data => ll_per_ei_data
2350:
2351: l_ghr_cpdf_temp_rec.creditable_military_service:= SUBSTR(ll_per_ei_data.pei_information5,1,4);
2352: ll_per_ei_data :=NULL;
2353:
2354: ghr_history_fetch.fetch_peopleei
2355: (p_person_id => l_ghr_pa_requests_rec.person_id,
2356: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
2357: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2358: p_per_ei_data => ll_per_ei_data