416: --Bug# 14456039
417: FOR l_cur_rpa_dtl IN cur_rpa_dtl(p_pa_request_id) LOOP
418: l_rpa_position_id := l_cur_rpa_dtl.from_position_id;
419: END LOOP;
420: l_pos_agency_code := ghr_api.get_position_agency_code_pos
421: (p_position_id => l_rpa_position_id
422: ,p_business_group_id => fnd_profile.value ('PER_BUSINESS_GROUP_ID')
423: ,p_effective_date => p_effective_date
424: );
741: OR p_mnoa_flsa_category IS NOT NULL THEN
742: IF p_mnoa_job_id IS NOT NULL THEN
743: hr_utility.set_location ('OCC CODE CHECK', 35);
744:
745: l_mnoa_occ_series := ghr_api.get_job_occ_series_job
746: (p_job_id => p_mnoa_job_id
747: ,p_business_group_id => l_business_group_id);
748: l_occ_series := ghr_pa_requests_pkg.get_occ_series(l_position_id,l_effective_date,l_business_group_id);
749: l_fetch_occ_data := TRUE;
2062: ELSE*/
2063: l_duty_station_id := p_duty_station_id;
2064: --END IF;
2065: --Bug# 14810769
2066: l_sub_element_code := ghr_api.get_position_agency_code_pos
2067: (l_position_id,l_business_group_id);
2068:
2069: l_position_title := ghr_api.get_position_title_pos
2070: (p_position_id => l_position_id
2065: --Bug# 14810769
2066: l_sub_element_code := ghr_api.get_position_agency_code_pos
2067: (l_position_id,l_business_group_id);
2068:
2069: l_position_title := ghr_api.get_position_title_pos
2070: (p_position_id => l_position_id
2071: , p_business_group_id => l_business_group_id);
2072:
2073: l_position_number := ghr_api.get_position_desc_no_pos
2069: l_position_title := ghr_api.get_position_title_pos
2070: (p_position_id => l_position_id
2071: , p_business_group_id => l_business_group_id);
2072:
2073: l_position_number := ghr_api.get_position_desc_no_pos
2074: (p_position_id => l_position_id
2075: , p_business_group_id => l_business_group_id);
2076:
2077: l_position_seq_no := ghr_api.get_position_sequence_no_pos
2073: l_position_number := ghr_api.get_position_desc_no_pos
2074: (p_position_id => l_position_id
2075: , p_business_group_id => l_business_group_id);
2076:
2077: l_position_seq_no := ghr_api.get_position_sequence_no_pos
2078: (p_position_id => l_position_id
2079: , p_business_group_id => l_business_group_id);
2080:
2081: ghr_history_fetch.fetch_positionei
2248: IF l_new_pos_grp1_rec.position_extra_info_id IS NOT NULL
2249: AND (l_target_flsa_category IS NOT NULL
2250: OR l_target_barg_unit_status IS NOT NULL
2251: OR l_target_functional_class IS NOT NULL) THEN --Bug# 14410401
2252: ghr_api.g_api_dml := TRUE;
2253:
2254: BEGIN
2255: ghr_position_extra_info_api.update_position_extra_info
2256: (p_position_extra_info_id => l_new_pos_grp1_rec.position_extra_info_id
2276:
2277: RAISE mnoa_error;
2278: END;
2279:
2280: ghr_api.g_api_dml := FALSE;
2281: END IF;
2282: ELSIF l_noa_code = '792' THEN
2283: hr_utility.set_location ('Bargaining unit for NOA: 792 '
2284: || l_target_barg_unit_status, 139);
2285:
2286: IF l_vac_barg_unit_status
2287: <> nvl (l_target_barg_unit_status, l_vac_barg_unit_status) THEN
2288: IF l_new_pos_grp1_rec.position_extra_info_id IS NOT NULL THEN
2289: ghr_api.g_api_dml := TRUE;
2290:
2291: BEGIN
2292: ghr_position_extra_info_api.update_position_extra_info
2293: (p_position_extra_info_id => l_new_pos_grp1_rec.position_extra_info_id
2311:
2312: RAISE mnoa_error;
2313: END;
2314:
2315: ghr_api.g_api_dml := FALSE;
2316: END IF;
2317: END IF;
2318:
2319: IF l_target_duty_station_id IS NOT NULL THEN