eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CANDIDATE_PUB dependencies on PA_PROJECT_ASSIGNMENTS

Line 106: FROM PA_PROJECT_ASSIGNMENTS

102: END IF;
103:
104: SELECT 'Y'
105: INTO l_exists
106: FROM PA_PROJECT_ASSIGNMENTS
107: WHERE resource_id = p_resource_id
108: AND assignment_id <> p_assignment_id
109: AND nvl(start_date,sysdate) <= nvl(p_assignment_end_date,sysdate)
110: AND nvl(end_date,sysdate) >= nvl(p_assignment_start_date,sysdate)

Line 270: FROM pa_project_assignments

266: -- Check if assignment Id is valid
267: BEGIN
268: SELECT start_date
269: INTO l_asmt_start_date
270: FROM pa_project_assignments
271: WHERE assignment_id=p_assignment_id;
272: EXCEPTION
273: WHEN NO_DATA_FOUND THEN
274: pa_utils.add_message

Line 519: -- Update No_Of_Active_Candidates in PA_PROJECT_ASSIGNMENTS

515: END IF;
516: END IF;
517:
518:
519: -- Update No_Of_Active_Candidates in PA_PROJECT_ASSIGNMENTS
520: Update_No_Of_Active_Candidates(
521: p_assignment_id => p_assignment_id,
522: p_old_system_status_code => NULL,
523: p_new_system_status_code => l_system_status_code,

Line 574: pa_project_assignments by calling from other procedures which

570:
571: /* --------------------------------------------------------------------
572: PROCEDURE: update_no_of_active_candidates
573: PURPOSE: This procedure will update no_of_active_candidates column of
574: pa_project_assignments by calling from other procedures which
575: update candidate status like Add_Candidate, Add_Candidate_Log,
576: Update_Candidate.
577: -------------------------------------------------------------------- */
578: PROCEDURE Update_No_Of_Active_Candidates(

Line 594: FROM pa_project_assignments

590:
591: -- get original no_of_active_candidates and record_version_number for the passed assignment_id
592: SELECT no_of_active_candidates, record_version_number
593: INTO l_no_of_active_candidates, l_record_version_number
594: FROM pa_project_assignments
595: WHERE assignment_id = p_assignment_id;
596:
597: -- if original no_of_active_candidates is null, set to 0 so that we can increase or
598: -- decrease the value with ease.

Line 605: -- If so, increase the value of no_of_active_candidates in pa_project_assignments table.

601: END IF;
602:
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,

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 888: -- Get original record_version_number of pa_project_assignments

884: END IF;
885:
886: END LOOP;
887:
888: -- Get original record_version_number of pa_project_assignments
889: -- for the passed assignment_id
890: SELECT record_version_number
891: INTO l_record_version_number
892: FROM pa_project_assignments

Line 892: FROM pa_project_assignments

888: -- Get original record_version_number of pa_project_assignments
889: -- for the passed assignment_id
890: SELECT record_version_number
891: INTO l_record_version_number
892: FROM pa_project_assignments
893: WHERE assignment_id = p_assignment_id;
894:
895: -- Since there are no more active candidates, update the
896: -- No_Of_Active_Candidate in pa_project_assignments to 0

Line 896: -- No_Of_Active_Candidate in pa_project_assignments to 0

892: FROM pa_project_assignments
893: WHERE assignment_id = p_assignment_id;
894:
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,

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 919: -- Update No_Of_Active_Candidates in PA_PROJECT_ASSIGNMENTS

915: WHERE cand.assignment_id = p_assignment_id
916: AND cand.resource_id = p_resource_id
917: AND ps.project_status_code = cand.status_code;
918:
919: -- Update No_Of_Active_Candidates in PA_PROJECT_ASSIGNMENTS
920: Update_No_Of_Active_Candidates(
921: p_assignment_id => p_assignment_id,
922: p_old_system_status_code => l_old_system_status_code,
923: p_new_system_status_code => 'CANDIDATE_ASSIGNED',

Line 1221: -- Update No_Of_Active_Candidates in PA_PROJECT_ASSIGNMENTS

1217: AND status_type = 'CANDIDATE';
1218: END IF;
1219:
1220:
1221: -- Update No_Of_Active_Candidates in PA_PROJECT_ASSIGNMENTS
1222: Update_No_Of_Active_Candidates(
1223: p_assignment_id => l_assignment_id,
1224: p_old_system_status_code => l_old_system_status_code,
1225: p_new_system_status_code => l_system_status_code,

Line 1672: -- Update No_Of_Active_Candidates in PA_PROJECT_ASSIGNMENTS

1668: sysdate,
1669: FND_GLOBAL.user_id
1670: );
1671:
1672: -- Update No_Of_Active_Candidates in PA_PROJECT_ASSIGNMENTS
1673: Update_No_Of_Active_Candidates(
1674: p_assignment_id => l_assignment_id,
1675: p_old_system_status_code => l_old_system_status_code,
1676: p_new_system_status_code => l_system_status_code,

Line 2013: FROM pa_project_assignments ppa

2009: ppa.status_code,
2010: ppa.apprvl_status_code,
2011: ppa.pending_approval_flag,
2012: ppa.assignment_type
2013: FROM pa_project_assignments ppa
2014: WHERE assignment_id = p_assignment_id;
2015:
2016: CURSOR l_stus_csr (c_status_code IN VARCHAR2) IS
2017: SELECT ps.wf_success_status_code,

Line 2815: FROM pa_project_assignments asmt,

2811: INTO l_no_of_active_candidates,
2812: l_record_version_number,
2813: l_system_status_code,
2814: l_assignment_id
2815: FROM pa_project_assignments asmt,
2816: pa_candidates cand,
2817: pa_project_statuses ps
2818: WHERE asmt.assignment_id = cand.assignment_id
2819: AND candidate_id = p_candidate_id

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 3000: FROM pa_project_assignments

2996:
2997: -- get no_of_active_candidates from the previous requirement
2998: SELECT no_of_active_candidates
2999: INTO l_no_of_active_candidates
3000: FROM pa_project_assignments
3001: WHERE assignment_id = p_old_requirement_id;
3002:
3003: -- get record_version_number for the passed new requirement id
3004:

Line 3007: FROM pa_project_assignments

3003: -- get record_version_number for the passed new requirement id
3004:
3005: SELECT record_version_number
3006: INTO l_record_version_number
3007: FROM pa_project_assignments
3008: WHERE assignment_id = p_new_requirement_id;
3009:
3010: IF l_no_of_active_candidates is not null AND
3011: l_no_of_active_candidates > 0 THEN

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 3210: FROM pa_project_assignments

3206: END LOOP;
3207:
3208: SELECT record_version_number
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,

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: