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 88: pa_project_statuses pps

84: --Bug 8295734: For active candidate project_system_status_code should not be CANDIDATE_ASSIGNED
85: SELECT 'Y'
86: INTO l_exists
87: FROM pa_candidates pc,
88: pa_project_statuses pps
89: WHERE pc.resource_id = p_resource_id
90: AND pc.assignment_id <> p_assignment_id
91: AND pc.status_code = pps.project_status_code
92: AND pps.project_system_status_code not in ('CANDIDATE_DECLINED','CANDIDATE_WITHDRAWN','CANDIDATE_ASSIGNED')

Line 154: FROM pa_candidates, pa_project_statuses

150: AND assignment_id = p_assignment_id;
151: ELSE
152: SELECT project_system_status_code
153: INTO l_old_project_system_status
154: FROM pa_candidates, pa_project_statuses
155: WHERE resource_id = p_resource_id
156: AND assignment_id = p_assignment_id
157: AND status_code = project_status_code
158: AND status_type = 'CANDIDATE';

Line 162: FROM pa_project_statuses

158: AND status_type = 'CANDIDATE';
159:
160: SELECT project_system_status_code
161: INTO l_new_project_system_status
162: FROM pa_project_statuses
163: WHERE project_status_code = p_status_code
164: AND status_type = 'CANDIDATE';
165:
166: IF l_old_project_system_status = 'CANDIDATE_SYSTEM_QUALIFIED' AND

Line 406: FROM pa_project_statuses

402: RAISE FND_API.G_EXC_ERROR;
403: ELSE
404: SELECT project_system_status_code
405: INTO l_system_status_code
406: FROM pa_project_statuses
407: WHERE project_status_code = l_status_code;
408: END IF;
409:
410: IF l_is_cand_on_asmt = 'N' THEN

Line 491: FROM PA_PROJECT_STATUSES

487: END IF;
488:
489: SELECT ENABLE_WF_FLAG, WORKFLOW_ITEM_TYPE, WORKFLOW_PROCESS, PROJECT_STATUS_NAME
490: INTO l_enable_wf_flag, l_wf_item_type, l_wf_process, l_status_name
491: FROM PA_PROJECT_STATUSES
492: WHERE status_type = 'CANDIDATE'
493: AND project_status_code = l_status_code;
494:
495: --dbms_output.put_line ( 'l_enable_wf_flag ' || l_enable_wf_flag );

Line 739: FROM PA_PROJECT_STATUSES

735: IF p_status_code IS NOT NULL THEN
736: BEGIN
737: SELECT 'Y'
738: INTO l_exists
739: FROM PA_PROJECT_STATUSES
740: WHERE project_status_code = p_status_code
741: AND project_system_status_code = 'CANDIDATE_DECLINED';
742: EXCEPTION
743: WHEN NO_DATA_FOUND THEN

Line 774: FROM PA_PROJECT_STATUSES

770: -- Get project_status_code for system_status_code CANDIADTE_ASSIGNED.
771:
772: SELECT project_status_code
773: INTO l_project_status_code
774: FROM PA_PROJECT_STATUSES
775: WHERE project_system_status_code = 'CANDIDATE_ASSIGNED'
776: AND status_type = 'CANDIDATE'; -- Bug 4773033 CANDIDATE ROUTINES JOIN FOR PROJECT STATUSES
777: -- AND ROWNUM=1;
778:

Line 844: FROM PA_PROJECT_STATUSES

840: FOR c2 in remain_candidates_csr LOOP
841: -- Get the original project_system_status_code for remaining candidates.
842: SELECT project_system_status_code
843: INTO l_project_system_status_code
844: FROM PA_PROJECT_STATUSES
845: WHERE project_status_code = c2.status_code;
846:
847: -- Update records only for the remaining active candidate.
848: IF(Is_Active_Candidate(l_project_system_status_code)='Y') THEN

Line 914: FROM pa_candidates cand, pa_project_statuses ps

910:
911: -- Get the original project_system_status_code for the assigned candidate.
912: SELECT ps.project_system_status_code
913: INTO l_old_system_status_code
914: FROM pa_candidates cand, pa_project_statuses ps
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:

Line 1127: FROM pa_project_statuses

1123: l_system_status_code := null;
1124: ELSE
1125: SELECT project_system_status_code
1126: INTO l_system_status_code
1127: FROM pa_project_statuses
1128: WHERE project_status_code = l_status_code
1129: AND status_type = 'CANDIDATE';
1130: END IF;
1131:

Line 1205: FROM pa_project_statuses

1201: l_system_status_code := null;
1202: ELSE
1203: SELECT project_system_status_code
1204: INTO l_system_status_code
1205: FROM pa_project_statuses
1206: WHERE project_status_code = l_status_code
1207: AND status_type = 'CANDIDATE';
1208: END IF;
1209:

Line 1215: FROM pa_project_statuses

1211: l_old_system_status_code := null;
1212: ELSE
1213: SELECT project_system_status_code
1214: INTO l_old_system_status_code
1215: FROM pa_project_statuses
1216: WHERE project_status_code = l_old_status_code
1217: AND status_type = 'CANDIDATE';
1218: END IF;
1219:

Line 1309: FROM PA_PROJECT_STATUSES

1305: IF l_system_status_code <> l_old_system_status_code THEN
1306:
1307: SELECT ENABLE_WF_FLAG, WORKFLOW_ITEM_TYPE, WORKFLOW_PROCESS, PROJECT_STATUS_NAME
1308: INTO l_enable_wf_flag, l_wf_item_type, l_wf_process, l_status_name
1309: FROM PA_PROJECT_STATUSES
1310: WHERE status_type = 'CANDIDATE'
1311: AND project_status_code = l_status_code;
1312:
1313: IF l_enable_wf_flag = 'Y' AND l_wf_item_type IS NOT NULL AND

Line 1382: NO_OF_ACTIVE_CANDIDATES column in PA_PROJECT_STATUSES, if an

1378: PURPOSE: This Procedure will update candidate p_candidate_id's
1379: status or ranking.
1380: If the status changes, we will create a log entry in the
1381: PA_CANDIDATES_LOG table. we will also update the
1382: NO_OF_ACTIVE_CANDIDATES column in PA_PROJECT_STATUSES, if an
1383: active candidate goes inactive or vice versa
1384: Since no comment is passed, we will create the log with an empty
1385: log message. This API will be called from the Candidate List Page,
1386: where the status,change reason or ranking can be updated.

Line 1502: FROM pa_project_statuses

1498: l_system_status_code := null;
1499: ELSE
1500: SELECT project_system_status_code
1501: INTO l_system_status_code
1502: FROM pa_project_statuses
1503: WHERE project_status_code = l_status_code
1504: AND status_type = 'CANDIDATE';
1505: END IF;
1506:

Line 1512: FROM pa_project_statuses

1508: l_old_system_status_code := null;
1509: ELSE
1510: SELECT project_system_status_code
1511: INTO l_old_system_status_code
1512: FROM pa_project_statuses
1513: WHERE project_status_code = l_old_status_code
1514: AND status_type = 'CANDIDATE';
1515: END IF;
1516:

Line 1687: FROM PA_PROJECT_STATUSES

1683: END IF;
1684:
1685: SELECT ENABLE_WF_FLAG, WORKFLOW_ITEM_TYPE, WORKFLOW_PROCESS, PROJECT_STATUS_NAME
1686: INTO l_enable_wf_flag, l_wf_item_type, l_wf_process, l_status_name
1687: FROM PA_PROJECT_STATUSES
1688: WHERE status_type = 'CANDIDATE'
1689: AND project_status_code = l_status_code;
1690:
1691: -- Check is the status change needs a workflow to be started

Line 2020: FROM pa_project_statuses ps

2016: CURSOR l_stus_csr (c_status_code IN VARCHAR2) IS
2017: SELECT ps.wf_success_status_code,
2018: ps.wf_failure_status_code,
2019: ps.project_status_name
2020: FROM pa_project_statuses ps
2021: WHERE project_status_code = c_status_code;
2022:
2023: CURSOR l_resource_csr(l_resource_id IN NUMBER, p_start_date IN DATE) IS
2024: SELECT res.resource_name,

Line 2817: pa_project_statuses ps

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

Line 3097: pa_project_statuses status

3093: l_candidate_id_tbl,
3094: l_resource_id_tbl,
3095: l_record_version_number_tbl
3096: FROM pa_candidates cand,
3097: pa_project_statuses status
3098: WHERE cand.assignment_id = p_assignment_id
3099: AND cand.status_code = status.project_status_code
3100: AND status.project_system_status_code IN ('CANDIDATE_PENDING_REVIEW',
3101: 'CANDIDATE_UNDER_REVIEW', 'CANDIDATE_SYSTEM_NOMINATED', 'CANDIDATE_SUITABLE')

Line 3135: FROM pa_project_statuses

3131: INTO l_decline_status_name,
3132: l_enable_wf_flag,
3133: l_wf_item_type,
3134: l_wf_process
3135: FROM pa_project_statuses
3136: WHERE project_status_code = l_decline_status_code
3137: AND status_type = 'CANDIDATE';
3138:
3139: l_reviewer_person_id := Get_Person_Id;