APPS.GHR_SF52_API dependencies on GHR_PA_REQUESTS_PKG

Line 675: l_approving_official_work_titl := ghr_pa_requests_pkg.get_position_work_title

671: l_employee_id := user_emp_name.employee_id;
672: end loop;
673: if l_employee_id is not null then
674: -- get the working title of the approver -- would be as of today
675: l_approving_official_work_titl := ghr_pa_requests_pkg.get_position_work_title
676: (p_person_id => l_employee_id
677: );
678: End if;
679: Else

Line 708: l_sf50_approving_ofcl_work_tit := ghr_pa_requests_pkg.get_position_work_title

704: l_employee_id := user_emp_name.employee_id;
705: end loop;
706: if l_employee_id is not null then
707: -- get the working title of the approver -- would be as of today
708: l_sf50_approving_ofcl_work_tit := ghr_pa_requests_pkg.get_position_work_title
709: (p_person_id => l_employee_id
710: --p_effective_date => l_effective_date
711: );
712: End if;

Line 792: p_from_other_pay_amount => nvl(ghr_pa_requests_pkg2.get_cop

788: p_from_grade_or_level => p_from_grade_or_level,
789: p_from_locality_adj => p_from_locality_adj,
790: p_from_occ_code => p_from_occ_code,
791: -- Bug 2353506
792: p_from_other_pay_amount => nvl(ghr_pa_requests_pkg2.get_cop
793: (p_employee_assignment_id, p_effective_date),
794: p_from_other_pay_amount),
795: -- End Bug 2353506
796: p_from_pay_basis => p_from_pay_basis,

Line 1062: ghr_pa_requests_pkg.get_roles

1058: -- 3)Derive all parmeters required to insert routing_history records.
1059: -- Roles , Action_taken (and sequence Number if necessary)
1060:
1061: if p_1_user_name_acted_on is not null then
1062: ghr_pa_requests_pkg.get_roles
1063: (l_pa_request_id,
1064: p_routing_group_id,
1065: p_1_user_name_acted_on,
1066: l_initiator_flag,

Line 2675: l_approving_official_work_titl := ghr_pa_requests_pkg.get_position_work_title

2671: l_employee_id := user_emp_name.employee_id;
2672: end loop;
2673: if l_employee_id is not null then
2674: -- get the working title of the approver -- would it be as of today
2675: l_approving_official_work_titl := ghr_pa_requests_pkg.get_position_work_title
2676: (p_person_id => l_employee_id,
2677: p_effective_date => l_effective_date
2678: );
2679: End if;

Line 2717: l_sf50_approving_ofcl_work_tit := ghr_pa_requests_pkg.get_position_work_title

2713: l_employee_id := user_emp_name.employee_id;
2714: end loop;
2715: if l_employee_id is not null then
2716: -- get the working title of the approver -- would be as of today
2717: l_sf50_approving_ofcl_work_tit := ghr_pa_requests_pkg.get_position_work_title
2718: (p_person_id => l_employee_id
2719: );
2720: End if;
2721: End if;

Line 2742: -- ghr_pa_requests_pkg2.get_cop function

2738: -- Bug 2542417
2739: -- In some cases like Mass actions/Cancellation actions the assignment id and
2740: -- and effective_date are not available to fetch the capped other pay
2741: -- Below code fetches the effective_date and assignment id to be passed to
2742: -- ghr_pa_requests_pkg2.get_cop function
2743:
2744: for c_par in c_get_det_for_cop loop
2745: hr_utility.set_location('c_par.employee_assignment_id : '
2746: ||c_par.employee_assignment_id, 8);

Line 2749: l_from_cop := nvl(ghr_pa_requests_pkg2.get_cop

2745: hr_utility.set_location('c_par.employee_assignment_id : '
2746: ||c_par.employee_assignment_id, 8);
2747: hr_utility.set_location('c_par.effective_date : '
2748: ||c_par.effective_date, 8);
2749: l_from_cop := nvl(ghr_pa_requests_pkg2.get_cop
2750: (nvl(p_employee_assignment_id,c_par.employee_assignment_id)
2751: ,c_par.effective_date)
2752: ,p_from_other_pay_amount);
2753: end loop;

Line 3266: ghr_pa_requests_pkg.get_roles

3262: -- RP
3263: and p_u_user_name_acted_on <> hr_api.g_varchar2 then
3264: hr_utility.set_location(l_proc, 12);
3265:
3266: ghr_pa_requests_pkg.get_roles
3267: (p_pa_request_id,
3268: p_routing_group_id,
3269: p_u_user_name_acted_on,
3270: l_initiator_flag,

Line 4404: ghr_pa_requests_pkg.get_roles

4400: */
4401:
4402:
4403: If l_user_name is not null then
4404: ghr_pa_requests_pkg.get_roles
4405: (p_pa_request_id,
4406: l_routing_group_id,
4407: l_user_name,
4408: l_initiator_flag,