DBA Data[Home] [Help]

APPS.GHR_MASS_SEL_NOA dependencies on HR_API

Line 279: IF nvl (to_number (l_per_ei_data.pei_information5), hr_api.g_number)

275: , p_information_type => 'GHR_US_PER_MASS_ACTIONS'
276: , p_date_effective => l_eff_date
277: , p_per_ei_data => l_per_ei_data);
278:
279: IF nvl (to_number (l_per_ei_data.pei_information5), hr_api.g_number)
280: <> nvl (p_mass_salary_id, hr_api.g_number) THEN
281: p_sel_flag := 'Y';
282: p_comments := NULL;
283: ELSE

Line 280: <> nvl (p_mass_salary_id, hr_api.g_number) THEN

276: , p_date_effective => l_eff_date
277: , p_per_ei_data => l_per_ei_data);
278:
279: IF nvl (to_number (l_per_ei_data.pei_information5), hr_api.g_number)
280: <> nvl (p_mass_salary_id, hr_api.g_number) THEN
281: p_sel_flag := 'Y';
282: p_comments := NULL;
283: ELSE
284: p_sel_flag := l_per_ei_data.pei_information3;

Line 289: AND nvl (to_number (l_per_ei_data.pei_information5), hr_api.g_number)

285: p_comments := l_per_ei_data.pei_information4;
286: END IF;
287:
288: IF p_sel_flag IS NOT NULL
289: AND nvl (to_number (l_per_ei_data.pei_information5), hr_api.g_number)
290: <> nvl (p_mass_salary_id, hr_api.g_number) THEN
291: FOR chk_history_rec IN chk_history
292: (p_person_id => p_person_id
293: , eff_date => l_eff_date) LOOP

Line 290: <> nvl (p_mass_salary_id, hr_api.g_number) THEN

286: END IF;
287:
288: IF p_sel_flag IS NOT NULL
289: AND nvl (to_number (l_per_ei_data.pei_information5), hr_api.g_number)
290: <> nvl (p_mass_salary_id, hr_api.g_number) THEN
291: FOR chk_history_rec IN chk_history
292: (p_person_id => p_person_id
293: , eff_date => l_eff_date) LOOP
294: IF chk_history_rec.info11 = p_mass_salary_id THEN

Line 420: l_pos_agency_code := ghr_api.get_position_agency_code_pos

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: );

Line 745: l_mnoa_occ_series := ghr_api.get_job_occ_series_job

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;

Line 2066: l_sub_element_code := ghr_api.get_position_agency_code_pos

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

Line 2069: l_position_title := ghr_api.get_position_title_pos

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

Line 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

Line 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

Line 2252: ghr_api.g_api_dml := TRUE;

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

Line 2280: ghr_api.g_api_dml := FALSE;

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);

Line 2289: ghr_api.g_api_dml := TRUE;

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

Line 2315: ghr_api.g_api_dml := FALSE;

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