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 102: FROM PA_PROJECT_ASSIGNMENTS

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

Line 249: FROM pa_project_assignments

245: -- Check if assignment Id is valid
246: BEGIN
247: SELECT start_date
248: INTO l_asmt_start_date
249: FROM pa_project_assignments
250: WHERE assignment_id=p_assignment_id;
251: EXCEPTION
252: WHEN NO_DATA_FOUND THEN
253: pa_utils.add_message

Line 464: -- Update No_Of_Active_Candidates in PA_PROJECT_ASSIGNMENTS

460: END IF;
461: END IF;
462:
463:
464: -- Update No_Of_Active_Candidates in PA_PROJECT_ASSIGNMENTS
465: Update_No_Of_Active_Candidates(
466: p_assignment_id => p_assignment_id,
467: p_old_system_status_code => NULL,
468: p_new_system_status_code => l_system_status_code,

Line 519: pa_project_assignments by calling from other procedures which

515:
516: /* --------------------------------------------------------------------
517: PROCEDURE: update_no_of_active_candidates
518: PURPOSE: This procedure will update no_of_active_candidates column of
519: pa_project_assignments by calling from other procedures which
520: update candidate status like Add_Candidate, Add_Candidate_Log,
521: Update_Candidate.
522: -------------------------------------------------------------------- */
523: PROCEDURE Update_No_Of_Active_Candidates(

Line 539: FROM pa_project_assignments

535:
536: -- get original no_of_active_candidates and record_version_number for the passed assignment_id
537: SELECT no_of_active_candidates, record_version_number
538: INTO l_no_of_active_candidates, l_record_version_number
539: FROM pa_project_assignments
540: WHERE assignment_id = p_assignment_id;
541:
542: -- if original no_of_active_candidates is null, set to 0 so that we can increase or
543: -- decrease the value with ease.

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

546: END IF;
547:
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,

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

776: END IF;
777:
778: END LOOP;
779:
780: -- Get original record_version_number of pa_project_assignments
781: -- for the passed assignment_id
782: SELECT record_version_number
783: INTO l_record_version_number
784: FROM pa_project_assignments

Line 784: FROM pa_project_assignments

780: -- Get original record_version_number of pa_project_assignments
781: -- for the passed assignment_id
782: SELECT record_version_number
783: INTO l_record_version_number
784: FROM pa_project_assignments
785: WHERE assignment_id = p_assignment_id;
786:
787: -- Since there are no more active candidates, update the
788: -- No_Of_Active_Candidate in pa_project_assignments to 0

Line 788: -- No_Of_Active_Candidate in pa_project_assignments to 0

784: FROM pa_project_assignments
785: WHERE assignment_id = p_assignment_id;
786:
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,

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

807: WHERE cand.assignment_id = p_assignment_id
808: AND cand.resource_id = p_resource_id
809: AND ps.project_status_code = cand.status_code;
810:
811: -- Update No_Of_Active_Candidates in PA_PROJECT_ASSIGNMENTS
812: Update_No_Of_Active_Candidates(
813: p_assignment_id => p_assignment_id,
814: p_old_system_status_code => l_old_system_status_code,
815: p_new_system_status_code => 'CANDIDATE_ASSIGNED',

Line 1073: -- Update No_Of_Active_Candidates in PA_PROJECT_ASSIGNMENTS

1069: AND status_type = 'CANDIDATE';
1070: END IF;
1071:
1072:
1073: -- Update No_Of_Active_Candidates in PA_PROJECT_ASSIGNMENTS
1074: Update_No_Of_Active_Candidates(
1075: p_assignment_id => l_assignment_id,
1076: p_old_system_status_code => l_old_system_status_code,
1077: p_new_system_status_code => l_system_status_code,

Line 1418: -- Update No_Of_Active_Candidates in PA_PROJECT_ASSIGNMENTS

1414: sysdate,
1415: FND_GLOBAL.user_id
1416: );
1417:
1418: -- Update No_Of_Active_Candidates in PA_PROJECT_ASSIGNMENTS
1419: Update_No_Of_Active_Candidates(
1420: p_assignment_id => l_assignment_id,
1421: p_old_system_status_code => l_old_system_status_code,
1422: p_new_system_status_code => l_system_status_code,

Line 1759: FROM pa_project_assignments ppa

1755: ppa.status_code,
1756: ppa.apprvl_status_code,
1757: ppa.pending_approval_flag,
1758: ppa.assignment_type
1759: FROM pa_project_assignments ppa
1760: WHERE assignment_id = p_assignment_id;
1761:
1762: CURSOR l_stus_csr (c_status_code IN VARCHAR2) IS
1763: SELECT ps.wf_success_status_code,

Line 2552: FROM pa_project_assignments asmt,

2548: INTO l_no_of_active_candidates,
2549: l_record_version_number,
2550: l_system_status_code,
2551: l_assignment_id
2552: FROM pa_project_assignments asmt,
2553: pa_candidates cand,
2554: pa_project_statuses ps
2555: WHERE asmt.assignment_id = cand.assignment_id
2556: AND candidate_id = p_candidate_id

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

2733:
2734: -- get no_of_active_candidates from the previous requirement
2735: SELECT no_of_active_candidates
2736: INTO l_no_of_active_candidates
2737: FROM pa_project_assignments
2738: WHERE assignment_id = p_old_requirement_id;
2739:
2740: -- get record_version_number for the passed new requirement id
2741:

Line 2744: FROM pa_project_assignments

2740: -- get record_version_number for the passed new requirement id
2741:
2742: SELECT record_version_number
2743: INTO l_record_version_number
2744: FROM pa_project_assignments
2745: WHERE assignment_id = p_new_requirement_id;
2746:
2747: IF l_no_of_active_candidates is not null AND
2748: l_no_of_active_candidates > 0 THEN

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

2943: END LOOP;
2944:
2945: SELECT record_version_number
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,

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: