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_SEARCH_PVT dependencies on PA_PROJECT_STATUSES

Line 113: TYPE status_code_tbl IS TABLE OF pa_project_statuses.project_status_code%TYPE

109: TYPE assignment_end_date_tbl IS TABLE OF pa_project_assignments.end_date%TYPE
110: INDEX BY BINARY_INTEGER;
111: l_assignment_end_date_tbl assignment_end_date_tbl;
112:
113: TYPE status_code_tbl IS TABLE OF pa_project_statuses.project_status_code%TYPE
114: INDEX BY BINARY_INTEGER;
115: l_status_code_tbl status_code_tbl;
116:
117: TYPE project_id_tbl IS TABLE OF pa_projects_all.project_id%TYPE

Line 437: , pa_project_statuses ps

433: , pa_org_hierarchy_denorm ohd
434: , pa_projects_all proj
435: , pa_locations loc
436: , fnd_territories_vl ter
437: , pa_project_statuses ps
438: , pa_advertised_open_req_v aor
439: WHERE asgn.assignment_id = p_search_criteria.assignment_id
440: AND asgn.min_resource_job_level <= p_search_criteria.min_job_level
441: AND asgn.max_resource_job_level >= p_search_criteria.min_job_level

Line 488: , pa_project_statuses ps

484: , pa_org_hierarchy_denorm ohd
485: , pa_projects_all proj
486: , pa_locations loc
487: , fnd_territories_vl ter
488: , pa_project_statuses ps
489: , pa_advertised_open_req_v aor
490: WHERE asgn.min_resource_job_level <= p_search_criteria.min_job_level
491: AND asgn.max_resource_job_level >= p_search_criteria.min_job_level
492: AND asgn.project_role_id = p_search_criteria.role_id

Line 539: , pa_project_statuses ps

535: , pa_org_hierarchy_denorm ohd
536: , pa_projects_all proj
537: , pa_locations loc
538: , fnd_territories_vl ter
539: , pa_project_statuses ps
540: , pa_advertised_open_req_v aor
541: WHERE asgn.min_resource_job_level <= p_search_criteria.min_job_level
542: AND asgn.max_resource_job_level >= p_search_criteria.min_job_level
543: AND asgn.project_role_id = p_search_criteria.role_id

Line 589: , pa_project_statuses ps

585: , pa_org_hierarchy_denorm ohd
586: , pa_projects_all proj
587: , pa_locations loc
588: , fnd_territories_vl ter
589: , pa_project_statuses ps
590: , pa_advertised_open_req_v aor
591: WHERE asgn.min_resource_job_level <= p_search_criteria.min_job_level
592: AND asgn.max_resource_job_level >= p_search_criteria.min_job_level
593: AND asgn.project_role_id = p_search_criteria.role_id

Line 634: , pa_project_statuses ps

630: , pa_org_hierarchy_denorm ohd
631: , pa_projects_all proj
632: , pa_locations loc
633: , fnd_territories_vl ter
634: , pa_project_statuses ps
635: , pa_advertised_open_req_v aor
636: WHERE asgn.min_resource_job_level <= p_search_criteria.min_job_level
637: AND asgn.max_resource_job_level >= p_search_criteria.min_job_level
638: AND asgn.start_date >= p_search_criteria.start_date

Line 1356: p_status_code pa_project_statuses.project_status_code%TYPE)

1352: END Run_Search;
1353:
1354:
1355: FUNCTION Show_Req_In_Search(p_assignment_id pa_project_assignments.assignment_id%TYPE,
1356: p_status_code pa_project_statuses.project_status_code%TYPE)
1357: RETURN VARCHAR2 IS
1358:
1359: l_show_in_search VARCHAR2(1);
1360:

Line 1361: TYPE status_code_tbl IS TABLE OF pa_project_statuses.project_status_code%TYPE

1357: RETURN VARCHAR2 IS
1358:
1359: l_show_in_search VARCHAR2(1);
1360:
1361: TYPE status_code_tbl IS TABLE OF pa_project_statuses.project_status_code%TYPE
1362: INDEX BY BINARY_INTEGER;
1363: l_status_code_tbl status_code_tbl;
1364:
1365: BEGIN

Line 1441: pa_project_statuses ps

1437: asgn.ENABLE_AUTO_CAND_NOM_FLAG,
1438: proj.enable_automated_search
1439: FROM pa_project_assignments asgn,
1440: pa_projects_all proj,
1441: pa_project_statuses ps
1442: WHERE proj.project_id = p_project_id
1443: AND proj.project_id = asgn.project_id
1444: AND trunc(asgn.start_date) BETWEEN decode(p_req_start_date_days, NULL, asgn.start_date, trunc(SYSDATE)) AND decode(p_req_start_date_days, NULL, asgn.start_date, trunc(SYSDATE) + p_req_start_date_days)
1445: AND asgn.assignment_type='OPEN_ASSIGNMENT'

Line 1468: pa_project_statuses ps

1464: asgn.ENABLE_AUTO_CAND_NOM_FLAG,
1465: proj.enable_automated_search
1466: FROM pa_project_assignments asgn,
1467: pa_projects_all proj,
1468: pa_project_statuses ps
1469: WHERE proj.segment1 BETWEEN nvl(p_project_number_from, proj.segment1) AND nvl(p_project_number_to, proj.segment1)
1470: -- AND trunc(proj.start_date) BETWEEN decode(p_proj_start_date_days, NULL, proj.start_date, trunc(SYSDATE)) AND decode(p_proj_start_date_days, NULL, proj.start_date, trunc(SYSDATE) + p_proj_start_date_days)
1471: -- Changed for Bug 5299668
1472: AND trunc(nvl(proj.start_date, SYSDATE)) BETWEEN

Line 1506: l_status_code pa_project_statuses.project_status_code%TYPE;

1502: l_system_nom_candidate_text fnd_new_messages.message_text%TYPE;
1503: l_candidates_nom_in_cycle NUMBER := 0;
1504: l_req_enable_auto_cand_nom pa_project_assignments.ENABLE_AUTO_CAND_NOM_FLAG%TYPE;
1505: l_proj_enable_automated_search pa_projects_all.enable_automated_search%TYPE;
1506: l_status_code pa_project_statuses.project_status_code%TYPE;
1507: l_cand_system_status_code pa_project_statuses.project_system_status_code%TYPE;
1508:
1509: BEGIN
1510:

Line 1507: l_cand_system_status_code pa_project_statuses.project_system_status_code%TYPE;

1503: l_candidates_nom_in_cycle NUMBER := 0;
1504: l_req_enable_auto_cand_nom pa_project_assignments.ENABLE_AUTO_CAND_NOM_FLAG%TYPE;
1505: l_proj_enable_automated_search pa_projects_all.enable_automated_search%TYPE;
1506: l_status_code pa_project_statuses.project_status_code%TYPE;
1507: l_cand_system_status_code pa_project_statuses.project_system_status_code%TYPE;
1508:
1509: BEGIN
1510:
1511: IF p_debug_mode = 'Y' THEN

Line 1731: pa_project_statuses ps

1727: END IF;
1728:
1729: SELECT candidate_id BULK COLLECT INTO l_candidate_id_tbl
1730: FROM pa_candidates cand,
1731: pa_project_statuses ps
1732: WHERE assignment_id = PA_SEARCH_GLOB.g_search_criteria.assignment_id
1733: AND cand.status_code = ps.project_status_code
1734: AND ps.status_type = 'CANDIDATE'
1735: AND ps.project_system_status_code = l_cand_system_status_code