[Home] [Help]
269: --End Bug# 14055214
270: End if;
271:
272: hr_utility.set_location(l_proc,35);
273: ghr_mass_actions_pkg.get_noa_id_desc
274: (p_noa_code => l_pa_request_rec.first_noa_code,
275: p_effective_date => l_pa_request_rec.effective_date,
276: p_noa_id => l_pa_request_rec.first_noa_id,
277: p_noa_desc => l_pa_request_rec.first_noa_desc
279:
280: --Begin Bug# 14055214
281: hr_utility.set_location ('Mass action type '|| p_mass_action_type,233);
282: IF p_mass_action_type = 'MASS_NOA_SEL' AND l_pa_request_rec.first_noa_code IN ('460','472','772','773') THEN
283: ghr_mass_actions_pkg.replace_insertion_values
284: (p_desc => l_pa_request_rec.first_noa_desc,
285: p_information1 => to_char(fnd_date.canonical_to_date(l_pa_request_rec.first_noa_information1),'DD-MON-RRRR'),
286: p_desc_out => l_desc_out
287: );
293: -- First NOA Code has insertion values. The insertion value will be
294: -- the To Agency Code the employee is transferring to.
295: -- Bug#4256022 Passed the parameter l_desc_out and reassigned its value to
296: -- l_pa_request_rec.first_noa_desc to avoid NOCOPY related problems..
297: ghr_mass_actions_pkg.replace_insertion_values
298: (p_desc => l_pa_request_rec.first_noa_desc,
299: p_information1 => l_pa_request_rec.first_noa_information1,
300: p_desc_out => l_desc_out
301: );
506: IF (ghr_pay_calc.get_lpa_percentage (l_pa_request_rec.duty_station_id, l_pa_request_rec.effective_date)
507: <> ghr_pay_calc.get_lpa_percentage (l_target_duty_station_id, l_pa_request_rec.effective_date)) THEN
508: l_pa_request_rec.first_noa_code := '894';
509: --Begin Bug# 14805985 to get the noa description
510: ghr_mass_actions_pkg.get_noa_id_desc
511: (p_noa_code => l_pa_request_rec.first_noa_code,
512: p_effective_date => l_pa_request_rec.effective_date,
513: p_noa_id => l_pa_request_rec.first_noa_id,
514: p_noa_desc => l_pa_request_rec.first_noa_desc
720: ,'GHR_US_WORK_SCHEDULE'
721: ,l_pa_request_rec.work_schedule
722: );
723:
724: ghr_mass_actions_pkg.get_personnel_officer_name
725: (p_personnel_office_id => l_personnel_office_id,
726: p_person_full_name => l_personnel_officer_name,
727: p_approving_off_work_title => l_approving_off_work_title);
728:
941:
942:
943: -- Having got the l_1_pa_routing_history_id and l_1_prh_object_version_number
944: -- from the above procedure, use it in the ghr_prh_upd.upd to update the groupbox_id
945: -- ( use ghr_mass_actions_pkg.get_personnel_off_groupbox to get the groupbox_id and
946: -- the routing_group_id)
947: -- Also update the ghr_pa_requests with the routing_group_id passed out
948: -- ghr_par_upd.upd
949: -- If the groupbox_id is null, then rollback to create_52_for_mass_changes and then nake an
950: -- entry in the ghr_process_log -- (not sure about this part)
951:
952: BEGIN
953:
954: ghr_mass_actions_pkg.get_personnel_off_groupbox(
955: nvl(l_pa_request_rec.from_position_id,
956: l_pa_request_rec.to_position_id),
957: l_pa_request_rec.effective_date,
958: l_groupbox_id, -- Out put parameters
1226:
1227: -- get remark_id remark_desc, remark_code_information1, ...
1228: hr_utility.set_location('Entering ' || l_proc,5);
1229:
1230: ghr_mass_actions_pkg.get_remark_id_desc
1231: (p_remark_code => p_remark_code,
1232: p_effective_date => trunc(nvl(p_pa_request_rec.effective_date,sysdate)),
1233: p_remark_id => l_remark_id,
1234: p_remark_desc => l_description
1253: l_remark_code_information2 := l_retained_grade_rec.pay_plan;
1254: -- l_remark_code_information3 := l_retained_grade_rec.grade_or_level;
1255: -- Bug#4256022 Passed parameter l_description_out to the procedure call
1256: -- and reassigned it back to l_description to avoid NOCOPY related problems..
1257: ghr_mass_actions_pkg.replace_insertion_values
1258: (p_desc => l_description,
1259: p_information1 => l_remark_code_information1,
1260: p_information2 => l_remark_code_information2,
1261: p_information3 => l_remark_code_information3,