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_STATUSES

Line 150: FROM pa_candidates, pa_project_statuses

146: AND assignment_id = p_assignment_id;
147: ELSE
148: SELECT project_system_status_code
149: INTO l_old_project_system_status
150: FROM pa_candidates, pa_project_statuses
151: WHERE resource_id = p_resource_id
152: AND assignment_id = p_assignment_id
153: AND status_code = project_status_code
154: AND status_type = 'CANDIDATE';

Line 158: FROM pa_project_statuses

154: AND status_type = 'CANDIDATE';
155:
156: SELECT project_system_status_code
157: INTO l_new_project_system_status
158: FROM pa_project_statuses
159: WHERE project_status_code = p_status_code
160: AND status_type = 'CANDIDATE';
161:
162: IF l_old_project_system_status = 'CANDIDATE_SYSTEM_QUALIFIED' AND

Line 385: FROM pa_project_statuses

381: RAISE FND_API.G_EXC_ERROR;
382: ELSE
383: SELECT project_system_status_code
384: INTO l_system_status_code
385: FROM pa_project_statuses
386: WHERE project_status_code = l_status_code;
387: END IF;
388:
389: IF l_is_cand_on_asmt = 'N' THEN

Line 436: FROM PA_PROJECT_STATUSES

432: END IF;
433:
434: SELECT ENABLE_WF_FLAG, WORKFLOW_ITEM_TYPE, WORKFLOW_PROCESS, PROJECT_STATUS_NAME
435: INTO l_enable_wf_flag, l_wf_item_type, l_wf_process, l_status_name
436: FROM PA_PROJECT_STATUSES
437: WHERE status_type = 'CANDIDATE'
438: AND project_status_code = l_status_code;
439:
440: --dbms_output.put_line ( 'l_enable_wf_flag ' || l_enable_wf_flag );

Line 665: FROM PA_PROJECT_STATUSES

661: IF p_status_code IS NOT NULL THEN
662: BEGIN
663: SELECT 'Y'
664: INTO l_exists
665: FROM PA_PROJECT_STATUSES
666: WHERE project_status_code = p_status_code
667: AND project_system_status_code = 'CANDIDATE_DECLINED';
668: EXCEPTION
669: WHEN NO_DATA_FOUND THEN

Line 700: FROM PA_PROJECT_STATUSES

696: -- Get project_status_code for system_status_code CANDIADTE_ASSIGNED.
697:
698: SELECT project_status_code
699: INTO l_project_status_code
700: FROM PA_PROJECT_STATUSES
701: WHERE project_system_status_code = 'CANDIDATE_ASSIGNED'
702: AND status_type = 'CANDIDATE'; -- Bug 4773033 CANDIDATE ROUTINES JOIN FOR PROJECT STATUSES
703: -- AND ROWNUM=1;
704:

Line 753: FROM PA_PROJECT_STATUSES

749: FOR c2 in remain_candidates_csr LOOP
750: -- Get the original project_system_status_code for remaining candidates.
751: SELECT project_system_status_code
752: INTO l_project_system_status_code
753: FROM PA_PROJECT_STATUSES
754: WHERE project_status_code = c2.status_code;
755:
756: -- Update records only for the remaining active candidate.
757: IF(Is_Active_Candidate(l_project_system_status_code)='Y') THEN

Line 806: FROM pa_candidates cand, pa_project_statuses ps

802:
803: -- Get the original project_system_status_code for the assigned candidate.
804: SELECT ps.project_system_status_code
805: INTO l_old_system_status_code
806: FROM pa_candidates cand, pa_project_statuses ps
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:

Line 1000: FROM pa_project_statuses

996: l_system_status_code := null;
997: ELSE
998: SELECT project_system_status_code
999: INTO l_system_status_code
1000: FROM pa_project_statuses
1001: WHERE project_status_code = l_status_code
1002: AND status_type = 'CANDIDATE';
1003: END IF;
1004:

Line 1057: FROM pa_project_statuses

1053: l_system_status_code := null;
1054: ELSE
1055: SELECT project_system_status_code
1056: INTO l_system_status_code
1057: FROM pa_project_statuses
1058: WHERE project_status_code = l_status_code
1059: AND status_type = 'CANDIDATE';
1060: END IF;
1061:

Line 1067: FROM pa_project_statuses

1063: l_old_system_status_code := null;
1064: ELSE
1065: SELECT project_system_status_code
1066: INTO l_old_system_status_code
1067: FROM pa_project_statuses
1068: WHERE project_status_code = l_old_status_code
1069: AND status_type = 'CANDIDATE';
1070: END IF;
1071:

Line 1127: FROM PA_PROJECT_STATUSES

1123: IF l_system_status_code <> l_old_system_status_code THEN
1124:
1125: SELECT ENABLE_WF_FLAG, WORKFLOW_ITEM_TYPE, WORKFLOW_PROCESS, PROJECT_STATUS_NAME
1126: INTO l_enable_wf_flag, l_wf_item_type, l_wf_process, l_status_name
1127: FROM PA_PROJECT_STATUSES
1128: WHERE status_type = 'CANDIDATE'
1129: AND project_status_code = l_status_code;
1130:
1131: IF l_enable_wf_flag = 'Y' AND l_wf_item_type IS NOT NULL AND

Line 1200: NO_OF_ACTIVE_CANDIDATES column in PA_PROJECT_STATUSES, if an

1196: PURPOSE: This Procedure will update candidate p_candidate_id's
1197: status or ranking.
1198: If the status changes, we will create a log entry in the
1199: PA_CANDIDATES_LOG table. we will also update the
1200: NO_OF_ACTIVE_CANDIDATES column in PA_PROJECT_STATUSES, if an
1201: active candidate goes inactive or vice versa
1202: Since no comment is passed, we will create the log with an empty
1203: log message. This API will be called from the Candidate List Page,
1204: where the status,change reason or ranking can be updated.

Line 1301: FROM pa_project_statuses

1297: l_system_status_code := null;
1298: ELSE
1299: SELECT project_system_status_code
1300: INTO l_system_status_code
1301: FROM pa_project_statuses
1302: WHERE project_status_code = l_status_code
1303: AND status_type = 'CANDIDATE';
1304: END IF;
1305:

Line 1311: FROM pa_project_statuses

1307: l_old_system_status_code := null;
1308: ELSE
1309: SELECT project_system_status_code
1310: INTO l_old_system_status_code
1311: FROM pa_project_statuses
1312: WHERE project_status_code = l_old_status_code
1313: AND status_type = 'CANDIDATE';
1314: END IF;
1315:

Line 1433: FROM PA_PROJECT_STATUSES

1429: END IF;
1430:
1431: SELECT ENABLE_WF_FLAG, WORKFLOW_ITEM_TYPE, WORKFLOW_PROCESS, PROJECT_STATUS_NAME
1432: INTO l_enable_wf_flag, l_wf_item_type, l_wf_process, l_status_name
1433: FROM PA_PROJECT_STATUSES
1434: WHERE status_type = 'CANDIDATE'
1435: AND project_status_code = l_status_code;
1436:
1437: -- Check is the status change needs a workflow to be started

Line 1766: FROM pa_project_statuses ps

1762: CURSOR l_stus_csr (c_status_code IN VARCHAR2) IS
1763: SELECT ps.wf_success_status_code,
1764: ps.wf_failure_status_code,
1765: ps.project_status_name
1766: FROM pa_project_statuses ps
1767: WHERE project_status_code = c_status_code;
1768:
1769: CURSOR l_resource_csr(l_resource_id IN NUMBER, p_start_date IN DATE) IS
1770: SELECT res.resource_name,

Line 2554: pa_project_statuses ps

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
2557: AND cand.status_code = ps.project_status_code
2558: AND ps.status_type = 'CANDIDATE';

Line 2834: pa_project_statuses status

2830: l_candidate_id_tbl,
2831: l_resource_id_tbl,
2832: l_record_version_number_tbl
2833: FROM pa_candidates cand,
2834: pa_project_statuses status
2835: WHERE cand.assignment_id = p_assignment_id
2836: AND cand.status_code = status.project_status_code
2837: AND status.project_system_status_code IN ('CANDIDATE_PENDING_REVIEW',
2838: 'CANDIDATE_UNDER_REVIEW', 'CANDIDATE_SYSTEM_NOMINATED', 'CANDIDATE_SUITABLE')

Line 2872: FROM pa_project_statuses

2868: INTO l_decline_status_name,
2869: l_enable_wf_flag,
2870: l_wf_item_type,
2871: l_wf_process
2872: FROM pa_project_statuses
2873: WHERE project_status_code = l_decline_status_code
2874: AND status_type = 'CANDIDATE';
2875:
2876: l_reviewer_person_id := Get_Person_Id;