APPS.GHR_PROCESS_SF52 dependencies on GHR_PA_REQUESTS_PKG2

Line 2784: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

2780: hr_utility.set_location('l_rec ' || l_rec.first_noa_code,3);
2781:
2782: l_sf52_rec := l_rec;
2783: --Bug # 9329643
2784: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
2785: (p_person_id => l_sf52_rec.person_id,
2786: p_effective_date => l_sf52_rec.effective_date);
2787:
2788: Begin

Line 3093: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

3089: */
3090: hr_utility.set_location( l_proc, 20);
3091:
3092: --Bug # 9329643
3093: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
3094: (p_person_id => l_sf52.person_id,
3095: p_effective_date => l_sf52.effective_date);
3096: l_log_text := 'Request Number : ' || p_sf52.request_number || l_new_line ||
3097: 'PA_REQUEST_ID : ' || to_char(p_sf52.pa_request_id) ||

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

3908: ,p_work_schedule => l_dummy_varchar
3909:
3910: );
3911:
3912: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop(l_assignment_id,
3913: nvl(p_effective_date, trunc(sysdate)));
3914:
3915: if (p_derive_to_cols) then
3916: p_sf52_data.to_organization_id := l_organization_id;

Line 3967: p_sf52_data.from_position_org_line1 := ghr_pa_requests_pkg2.get_agency_code_from(

3963: -- p_sf52_data.from_staffing_diff_percentage := l_staffing_diff_percentage;
3964: -- p_sf52_data.from_organization_id := l_organization_id;
3965: END IF;
3966: if (l_noa_family_code = 'APP') then
3967: p_sf52_data.from_position_org_line1 := ghr_pa_requests_pkg2.get_agency_code_from(
3968: p_pa_request_id => p_sf52_data.pa_request_id,
3969: p_noa_id => l_first_noa_id);
3970: else
3971: p_sf52_data.from_position_org_line1 := l_position_org_line1;

Line 3997: ghr_pa_requests_pkg2.get_agency_code_to(

3993: return;
3994: end if;
3995: if (l_first_noa_code = '352') then
3996: p_sf52_data.to_position_org_line1 :=
3997: ghr_pa_requests_pkg2.get_agency_code_to(
3998: p_pa_request_id => p_sf52_data.pa_request_id,
3999: p_noa_id => l_first_noa_id);
4000: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
4001: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then

Line 4003: ghr_pa_requests_pkg2.get_agency_code_to(

3999: p_noa_id => l_first_noa_id);
4000: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
4001: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then
4002: p_sf52_data.to_position_org_line1 :=
4003: ghr_pa_requests_pkg2.get_agency_code_to(
4004: p_pa_request_id => p_sf52_data.pa_request_id,
4005: p_noa_id => l_second_noa_id);
4006: end if;
4007:

Line 4077: ghr_pa_requests_pkg2.get_agency_code_to(

4073: p_sf52_data.to_pay_basis := l_pay_basis;
4074: p_sf52_data.to_pay_plan := l_pay_plan;
4075: if (l_first_noa_code = '352') then
4076: p_sf52_data.to_position_org_line1 :=
4077: ghr_pa_requests_pkg2.get_agency_code_to(
4078: p_pa_request_id => p_sf52_data.pa_request_id,
4079: p_noa_id => l_first_noa_id);
4080: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
4081: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then

Line 4083: ghr_pa_requests_pkg2.get_agency_code_to(

4079: p_noa_id => l_first_noa_id);
4080: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
4081: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then
4082: p_sf52_data.to_position_org_line1 :=
4083: ghr_pa_requests_pkg2.get_agency_code_to(
4084: p_pa_request_id => p_sf52_data.pa_request_id,
4085: p_noa_id => l_second_noa_id);
4086: else
4087: p_sf52_data.to_position_org_line1 := l_position_org_line1;

Line 4329: ghr_pa_requests_pkg2.get_agency_code_to(

4325: || p_sf52_data.to_pay_basis ,1);
4326:
4327: if (l_first_noa_code = '352') then
4328: p_sf52_data.to_position_org_line1 :=
4329: ghr_pa_requests_pkg2.get_agency_code_to(
4330: p_pa_request_id => p_sf52_data.pa_request_id,
4331: p_noa_id => l_first_noa_id);
4332: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
4333: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then

Line 4335: ghr_pa_requests_pkg2.get_agency_code_to(

4331: p_noa_id => l_first_noa_id);
4332: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
4333: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then
4334: p_sf52_data.to_position_org_line1 :=
4335: ghr_pa_requests_pkg2.get_agency_code_to(
4336: p_pa_request_id => p_sf52_data.pa_request_id,
4337: p_noa_id => l_second_noa_id);
4338: else
4339: p_sf52_data.to_position_org_line1 := l_position_org_line1;