APPS.PA_CANDIDATE_PUB dependencies on PA_PROJECT_ASSIGNMENTS_PKG

Line 552: pa_project_assignments_pkg.Update_row(

548: -- if this has been called from 'Add_Candidate', p_old_system_status_code won't be passed.
549: -- In that case, just check if the new_system_status_code is one of the active status.
550: -- If so, increase the value of no_of_active_candidates in pa_project_assignments table.
551: IF (p_old_system_status_code IS NULL AND is_active_candidate(p_new_system_status_code)='Y') THEN
552: pa_project_assignments_pkg.Update_row(
553: p_assignment_id => p_assignment_id,
554: p_no_of_active_candidates => l_no_of_active_candidates+1,
555: p_record_version_number => l_record_version_number,
556: x_return_status => l_return_status );

Line 565: pa_project_assignments_pkg.Update_row(

561:
562: -- If the status has been changed from active to non-active, decrement no_of_active_candidates
563: IF (is_active_candidate(p_old_system_status_code)='Y'
564: AND is_active_candidate(p_new_system_status_code)='N') THEN
565: pa_project_assignments_pkg.Update_row(
566: p_assignment_id => p_assignment_id,
567: p_no_of_active_candidates => l_no_of_active_candidates-1,
568: p_record_version_number => l_record_version_number,
569: x_return_status => l_return_status );

Line 574: pa_project_assignments_pkg.Update_row(

570:
571: -- If the status has been changed from non-active to active, increment no_of_active_candidates
572: ELSIF (is_active_candidate(p_old_system_status_code)='N'
573: AND is_active_candidate(p_new_system_status_code)='Y') THEN
574: pa_project_assignments_pkg.Update_row(
575: p_assignment_id => p_assignment_id,
576: p_no_of_active_candidates => l_no_of_active_candidates+1,
577: p_record_version_number => l_record_version_number,
578: x_return_status => l_return_status );

Line 791: pa_project_assignments_pkg.Update_row(

787: -- Since there are no more active candidates, update the
788: -- No_Of_Active_Candidate in pa_project_assignments to 0
789: -- for assignment p_assignment_id
790:
791: pa_project_assignments_pkg.Update_row(
792: p_assignment_id => p_assignment_id,
793: p_no_of_active_candidates => 0,
794: p_record_version_number => l_record_version_number,
795: x_return_status => l_return_status );

Line 2567: pa_project_assignments_pkg.Update_row(

2563: DELETE FROM pa_candidates
2564: WHERE candidate_id = p_candidate_id;
2565:
2566: IF (is_active_candidate(l_system_status_code)='Y') THEN
2567: pa_project_assignments_pkg.Update_row(
2568: p_assignment_id => l_assignment_id,
2569: p_no_of_active_candidates => l_no_of_active_candidates-1,
2570: p_record_version_number => l_record_version_number,
2571: x_return_status => l_return_status );

Line 2750: pa_project_assignments_pkg.Update_row(

2746:
2747: IF l_no_of_active_candidates is not null AND
2748: l_no_of_active_candidates > 0 THEN
2749:
2750: pa_project_assignments_pkg.Update_row(
2751: p_assignment_id => p_new_requirement_id,
2752: p_no_of_active_candidates => l_no_of_active_candidates,
2753: p_record_version_number => l_record_version_number,
2754: x_return_status => l_return_status );

Line 2950: pa_project_assignments_pkg.Update_row(p_assignment_id => p_assignment_id,

2946: INTO l_asmt_record_version_number
2947: FROM pa_project_assignments
2948: WHERE assignment_id = p_assignment_id;
2949:
2950: pa_project_assignments_pkg.Update_row(p_assignment_id => p_assignment_id,
2951: p_no_of_active_candidates => 0,
2952: p_record_version_number => l_asmt_record_version_number,
2953: x_return_status => l_return_status );
2954: