[Home] [Help]
431: l_inv_job_grade_warning boolean;
432: l_temp_ovn number := P_OBJECT_VERSION_NUMBER;
433: cursor csr_asg is
434: select assignment_id,paf.object_version_number
435: from per_all_assignments_f paf,
436: per_all_vacancies pav
437: where paf.vacancy_id = p_vacancy_id
438: and paf.vacancy_id = pav.vacancy_id
439: and paf.assignment_type = 'A';
682: when nvl(p_recruiter_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.recruiter_id
683: else p_recruiter_id
684: end;
685: --
686: /*update per_all_assignments_f asg
687: set asg.organization_id = nvl(l_organization_id, asg.organization_id)
688: ,asg.job_id = nvl(l_job_id, asg.job_id)
689: ,asg.grade_id = nvl(l_grade_id, asg.grade_id)
690: ,asg.people_group_id = nvl(l_people_group_id, asg.people_group_id)
696: per_vac_shd.g_old_rec.organization_id||'.'||per_vac_shd.g_old_rec.job_id,
697: nvl(l_position_id, asg.position_id),
698: l_position_id) */
699:
700: update per_all_assignments_f asg
701: set asg.organization_id = nvl(l_organization_id,asg.organization_id)
702: ,asg.job_id = l_job_id
703: ,asg.grade_id = l_grade_id
704: ,asg.people_group_id = l_people_group_id
708: ,asg.position_id = l_position_id
709: where asg.assignment_type = 'A'
710: and asg.vacancy_id = p_vacancy_id
711: and exists ( select 1
712: from per_all_assignments_f f2
713: where asg.assignment_id = f2.assignment_id
714: and f2.effective_end_date = hr_api.g_eot )
715: and not exists ( select 1
716: from per_all_assignments_f f2
712: from per_all_assignments_f f2
713: where asg.assignment_id = f2.assignment_id
714: and f2.effective_end_date = hr_api.g_eot )
715: and not exists ( select 1
716: from per_all_assignments_f f2
717: where asg.assignment_id = f2.assignment_id
718: and f2.assignment_status_type_id in ( select assignment_status_type_id
719: from per_assignment_status_types
720: where per_system_status in ('ACCEPTED')));