APPS.GHR_PAY_CALC dependencies on GHR_PA_REQUESTS_PKG

Line 1996: l_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family(p_second_noa_code);

1992: ,p_sf52_data_result => l_ghr_pa_request_rec
1993: ,p_called_from => 'FROM_PAYCAL');
1994:
1995: l_position_id := NVL(p_position_id,l_ghr_pa_request_rec.to_position_id);
1996: l_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family(p_second_noa_code);
1997: l_noa_code := p_second_noa_code;
1998: l_second_noa_code := NULL;
1999: l_first_action_la_code1 := NVL(p_first_action_la_code1 ,l_ghr_pa_request_rec.first_action_la_code1);
2000: l_pay_rate_determinant := NVL(p_pay_rate_determinant ,l_ghr_pa_request_rec.pay_rate_determinant);

Line 2280: l_second_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family(p_second_noa_code);

2276: -- 892/893 892/893 Run Pac Calc twice!!
2277: --
2278: -- Firstly if no second NOA then nothing to worry about!!
2279: IF l_second_noa_code IS NOT NULL THEN
2280: l_second_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family(p_second_noa_code);
2281: --
2282: IF l_second_noa_family_code IN ('APP','CHG_DUTY_STATION','CONV_APP','EXT_NTE','POS_CHG'
2283: ,'REALIGNMENT','REASSIGNMENT', 'RETURN_TO_DUTY')
2284: AND (l_noa_code IN ('892','893')

Line 2351: l_pay_calc_data.personnel_system_indicator := ghr_pa_requests_pkg.get_personnel_system_indicator

2347: --
2348: validate_in_data(l_pay_calc_data);
2349: --
2350: -- Bug#5482191 Fetch the PSI Value
2351: l_pay_calc_data.personnel_system_indicator := ghr_pa_requests_pkg.get_personnel_system_indicator
2352: (l_pay_calc_data.position_id,l_pay_calc_data.effective_date); -- MSL Percentage Changes Madhuri
2353: -- Bug#4758111 PRD 2 Processing.
2354: --- if nvl(ghr_msl_pkg.g_ses_msl_process,'N') <> 'Y' then
2355: if p_open_range_out_basic_pay is null then

Line 2480: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop(l_assignment_id,

2476: LOOP
2477: l_assignment_id := asg_rec.assignment_id;
2478: exit;
2479: END LOOP;
2480: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop(l_assignment_id,
2481: l_pay_calc_data.effective_date);
2482:
2483: -- Bug#5349609 If capped other pay is null, get the other pay value.
2484: IF l_capped_other_pay is NULL THEN

Line 3533: ghr_pa_requests_pkg.get_SF52_asg_ddf_details

3529: END LOOP;
3530:
3531: -- Get Assignment extra info records
3532: IF l_assignment_id IS NOT NULL THEN
3533: ghr_pa_requests_pkg.get_SF52_asg_ddf_details
3534: (p_assignment_id => l_assignment_id
3535: ,p_date_effective => p_effective_date
3536: ,p_tenure => l_dummy
3537: ,p_annuitant_indicator => l_dummy

Line 3547: ghr_pa_requests_pkg.temp_step_true(p_pa_request_id) THEN

3543: -- If PRD In 'A','B','E','F','U','V'
3544: IF l_prd IN ('A','B','E','F','U','V') THEN
3545: -- If PRD in 'A','B','E','F' and having temporary promotion step, get from position extra info
3546: IF l_prd IN ('A','B','E','F') AND
3547: ghr_pa_requests_pkg.temp_step_true(p_pa_request_id) THEN
3548: ghr_history_fetch.fetch_positionei(
3549: p_position_id => l_from_position_id,
3550: p_information_type => 'GHR_US_POS_VALID_GRADE',
3551: p_date_effective => nvl(p_effective_date,trunc(sysdate)),

Line 3555: l_from_pay_basis := ghr_pa_requests_pkg.get_upd34_pay_basis

3551: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
3552: p_pos_ei_data => l_pos_ei_grade_data);
3553: l_from_pay_basis := l_pos_ei_grade_data.poei_information6;
3554: ELSE
3555: l_from_pay_basis := ghr_pa_requests_pkg.get_upd34_pay_basis
3556: (p_person_id => p_person_id
3557: ,p_position_id => l_from_position_id
3558: ,p_prd => l_prd
3559: ,p_noa_code => null

Line 4616: l_from_pos_ind := ghr_pa_requests_pkg.get_personnel_system_indicator(l_from_position_id,p_pay_calc_data.effective_date);

4612: loop
4613: l_equivalent_pay_plan := c_equi_pay_plan.equivalent_pay_plan;
4614: end loop;
4615:
4616: l_from_pos_ind := ghr_pa_requests_pkg.get_personnel_system_indicator(l_from_position_id,p_pay_calc_data.effective_date);
4617:
4618: hr_utility.set_location('l_from_pos_ind'||l_from_pos_ind,1000);
4619:
4620: hr_utility.set_location('l_from_pay_plan'||l_from_pay_plan,1000);

Line 4626: l_to_pos_ind := ghr_pa_requests_pkg.get_personnel_system_indicator(nvl(p_pay_calc_data.position_id,l_from_position_id),p_pay_calc_data.effective_date);

4622:
4623: hr_utility.set_location('l_pay_plan'||l_pay_plan,1000);
4624: hr_utility.set_location('p_pay_calc_data.pay_rate_determinant'||p_pay_calc_data.pay_rate_determinant,1000);
4625:
4626: l_to_pos_ind := ghr_pa_requests_pkg.get_personnel_system_indicator(nvl(p_pay_calc_data.position_id,l_from_position_id),p_pay_calc_data.effective_date);
4627: --Bug # 9258929
4628:
4629: -- Bug# 4866952 Added the new pay calculation method for Pay Adjustment actions
4630: -- Processed after 01-MAY-2005

Line 5369: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator(p_position_id,p_effective_date);

5365: WHERE utb.user_table_name = p_user_table_name;
5366:
5367: BEGIN
5368: hr_utility.set_location('Entering ...'|| l_proc,100);
5369: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator(p_position_id,p_effective_date);
5370:
5371: hr_utility.set_location('personnel system ...'|| l_psi,101);
5372:
5373: IF l_psi <> '00' THEN --for NSPS