[Home] [Help]
695: l_employee_id := user_emp_name.employee_id;
696: end loop;
697: if l_employee_id is not null then
698: -- get the working title of the approver -- would be as of today
699: l_approving_official_work_titl := ghr_pa_requests_pkg.get_position_work_title
700: (p_person_id => l_employee_id
701: );
702: End if;
703: Else
728: l_employee_id := user_emp_name.employee_id;
729: end loop;
730: if l_employee_id is not null then
731: -- get the working title of the approver -- would be as of today
732: l_sf50_approving_ofcl_work_tit := ghr_pa_requests_pkg.get_position_work_title
733: (p_person_id => l_employee_id
734: --p_effective_date => l_effective_date
735: );
736: End if;
812: p_from_grade_or_level => p_from_grade_or_level,
813: p_from_locality_adj => p_from_locality_adj,
814: p_from_occ_code => p_from_occ_code,
815: -- Bug 2353506
816: p_from_other_pay_amount => nvl(ghr_pa_requests_pkg2.get_cop
817: (p_employee_assignment_id, p_effective_date),
818: p_from_other_pay_amount),
819: -- End Bug 2353506
820: p_from_pay_basis => p_from_pay_basis,
1118: -- 3)Derive all parmeters required to insert routing_history records.
1119: -- Roles , Action_taken (and sequence Number if necessary)
1120:
1121: if p_1_user_name_acted_on is not null then
1122: ghr_pa_requests_pkg.get_roles
1123: (l_pa_request_id,
1124: p_routing_group_id,
1125: p_1_user_name_acted_on,
1126: l_initiator_flag,
2815: l_employee_id := user_emp_name.employee_id;
2816: end loop;
2817: if l_employee_id is not null then
2818: -- get the working title of the approver -- would it be as of today
2819: l_approving_official_work_titl := ghr_pa_requests_pkg.get_position_work_title
2820: (p_person_id => l_employee_id,
2821: p_effective_date => l_effective_date
2822: );
2823: End if;
2857: l_employee_id := user_emp_name.employee_id;
2858: end loop;
2859: if l_employee_id is not null then
2860: -- get the working title of the approver -- would be as of today
2861: l_sf50_approving_ofcl_work_tit := ghr_pa_requests_pkg.get_position_work_title
2862: (p_person_id => l_employee_id
2863: );
2864: End if;
2865: End if;
2882: -- Bug 2542417
2883: -- In some cases like Mass actions/Cancellation actions the assignment id and
2884: -- and effective_date are not available to fetch the capped other pay
2885: -- Below code fetches the effective_date and assignment id to be passed to
2886: -- ghr_pa_requests_pkg2.get_cop function
2887:
2888: for c_par in c_get_det_for_cop loop
2889: hr_utility.set_location('c_par.employee_assignment_id : '
2890: ||c_par.employee_assignment_id, 8);
2889: hr_utility.set_location('c_par.employee_assignment_id : '
2890: ||c_par.employee_assignment_id, 8);
2891: hr_utility.set_location('c_par.effective_date : '
2892: ||c_par.effective_date, 8);
2893: l_from_cop := nvl(ghr_pa_requests_pkg2.get_cop
2894: (nvl(p_employee_assignment_id,c_par.employee_assignment_id)
2895: ,c_par.effective_date)
2896: ,p_from_other_pay_amount);
2897: end loop;
3441: -- RP
3442: and p_u_user_name_acted_on <> hr_api.g_varchar2 then
3443: hr_utility.set_location(l_proc, 12);
3444:
3445: ghr_pa_requests_pkg.get_roles
3446: (p_pa_request_id,
3447: p_routing_group_id,
3448: p_u_user_name_acted_on,
3449: l_initiator_flag,
4643: */
4644:
4645:
4646: If l_user_name is not null then
4647: ghr_pa_requests_pkg.get_roles
4648: (p_pa_request_id,
4649: l_routing_group_id,
4650: l_user_name,
4651: l_initiator_flag,
5249: BEGIN
5250: l_remk_desc:= NULL;
5251: l_pa_remark_id := NULL;
5252: l_rem_ovn := NULL;
5253: l_detail_job := SUBSTR(ghr_pa_requests_pkg.get_lookup_meaning(800,'GHR_US_OCC_SERIES',l_detail_job_id),1,80);
5254: ghr_mass_actions_pkg.get_remark_id_desc
5255: (p_remark_code => 'ZK8',--Bug# 9928813
5256: p_effective_date => p_effective_date,
5257: p_remark_id => l_remark_id,