APPS.PA_CANDIDATE_PUB dependencies on PA_PROJECT_ASSIGNMENTS_PKG

Line 607: pa_project_assignments_pkg.Update_row(

603: -- if this has been called from 'Add_Candidate', p_old_system_status_code won't be passed.
604: -- In that case, just check if the new_system_status_code is one of the active status.
605: -- If so, increase the value of no_of_active_candidates in pa_project_assignments table.
606: IF (p_old_system_status_code IS NULL AND is_active_candidate(p_new_system_status_code)='Y') THEN
607: pa_project_assignments_pkg.Update_row(
608: p_assignment_id => p_assignment_id,
609: p_no_of_active_candidates => l_no_of_active_candidates+1,
610: p_record_version_number => l_record_version_number,
611: x_return_status => l_return_status );

Line 620: pa_project_assignments_pkg.Update_row(

616:
617: -- If the status has been changed from active to non-active, decrement no_of_active_candidates
618: IF (is_active_candidate(p_old_system_status_code)='Y'
619: AND is_active_candidate(p_new_system_status_code)='N') THEN
620: pa_project_assignments_pkg.Update_row(
621: p_assignment_id => p_assignment_id,
622: p_no_of_active_candidates => l_no_of_active_candidates-1,
623: p_record_version_number => l_record_version_number,
624: x_return_status => l_return_status );

Line 629: pa_project_assignments_pkg.Update_row(

625:
626: -- If the status has been changed from non-active to active, increment no_of_active_candidates
627: ELSIF (is_active_candidate(p_old_system_status_code)='N'
628: AND is_active_candidate(p_new_system_status_code)='Y') THEN
629: pa_project_assignments_pkg.Update_row(
630: p_assignment_id => p_assignment_id,
631: p_no_of_active_candidates => l_no_of_active_candidates+1,
632: p_record_version_number => l_record_version_number,
633: x_return_status => l_return_status );

Line 899: pa_project_assignments_pkg.Update_row(

895: -- Since there are no more active candidates, update the
896: -- No_Of_Active_Candidate in pa_project_assignments to 0
897: -- for assignment p_assignment_id
898:
899: pa_project_assignments_pkg.Update_row(
900: p_assignment_id => p_assignment_id,
901: p_no_of_active_candidates => 0,
902: p_record_version_number => l_record_version_number,
903: x_return_status => l_return_status );

Line 2830: pa_project_assignments_pkg.Update_row(

2826: DELETE FROM pa_candidates
2827: WHERE candidate_id = p_candidate_id;
2828:
2829: IF (is_active_candidate(l_system_status_code)='Y') THEN
2830: pa_project_assignments_pkg.Update_row(
2831: p_assignment_id => l_assignment_id,
2832: p_no_of_active_candidates => l_no_of_active_candidates-1,
2833: p_record_version_number => l_record_version_number,
2834: x_return_status => l_return_status );

Line 3013: pa_project_assignments_pkg.Update_row(

3009:
3010: IF l_no_of_active_candidates is not null AND
3011: l_no_of_active_candidates > 0 THEN
3012:
3013: pa_project_assignments_pkg.Update_row(
3014: p_assignment_id => p_new_requirement_id,
3015: p_no_of_active_candidates => l_no_of_active_candidates,
3016: p_record_version_number => l_record_version_number,
3017: x_return_status => l_return_status );

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

3209: INTO l_asmt_record_version_number
3210: FROM pa_project_assignments
3211: WHERE assignment_id = p_assignment_id;
3212:
3213: pa_project_assignments_pkg.Update_row(p_assignment_id => p_assignment_id,
3214: p_no_of_active_candidates => 0,
3215: p_record_version_number => l_asmt_record_version_number,
3216: x_return_status => l_return_status );
3217: