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 445: , pa_project_statuses ps

441: , pa_org_hierarchy_denorm ohd
442: , pa_projects_all proj
443: , pa_locations loc
444: , fnd_territories_vl ter
445: , pa_project_statuses ps
446: , pa_advertised_open_req_v aor
447: WHERE asgn.assignment_id = p_search_criteria.assignment_id
448: AND asgn.min_resource_job_level <= p_search_criteria.min_job_level
449: AND asgn.max_resource_job_level >= p_search_criteria.min_job_level

Line 496: , pa_project_statuses ps

492: , pa_org_hierarchy_denorm ohd
493: , pa_projects_all proj
494: , pa_locations loc
495: , fnd_territories_vl ter
496: , pa_project_statuses ps
497: , pa_advertised_open_req_v aor
498: WHERE asgn.min_resource_job_level <= p_search_criteria.min_job_level
499: AND asgn.max_resource_job_level >= p_search_criteria.min_job_level
500: AND asgn.project_role_id = p_search_criteria.role_id

Line 547: , pa_project_statuses ps

543: , pa_org_hierarchy_denorm ohd
544: , pa_projects_all proj
545: , pa_locations loc
546: , fnd_territories_vl ter
547: , pa_project_statuses ps
548: , pa_advertised_open_req_v aor
549: WHERE asgn.min_resource_job_level <= p_search_criteria.min_job_level
550: AND asgn.max_resource_job_level >= p_search_criteria.min_job_level
551: AND asgn.project_role_id = p_search_criteria.role_id

Line 597: , pa_project_statuses ps

593: , pa_org_hierarchy_denorm ohd
594: , pa_projects_all proj
595: , pa_locations loc
596: , fnd_territories_vl ter
597: , pa_project_statuses ps
598: , pa_advertised_open_req_v aor
599: WHERE asgn.min_resource_job_level <= p_search_criteria.min_job_level
600: AND asgn.max_resource_job_level >= p_search_criteria.min_job_level
601: AND asgn.project_role_id = p_search_criteria.role_id

Line 642: , pa_project_statuses ps

638: , pa_org_hierarchy_denorm ohd
639: , pa_projects_all proj
640: , pa_locations loc
641: , fnd_territories_vl ter
642: , pa_project_statuses ps
643: , pa_advertised_open_req_v aor
644: WHERE asgn.min_resource_job_level <= p_search_criteria.min_job_level
645: AND asgn.max_resource_job_level >= p_search_criteria.min_job_level
646: AND asgn.start_date >= p_search_criteria.start_date

Line 1406: p_status_code pa_project_statuses.project_status_code%TYPE)

1402: END Run_Search;
1403:
1404:
1405: FUNCTION Show_Req_In_Search(p_assignment_id pa_project_assignments.assignment_id%TYPE,
1406: p_status_code pa_project_statuses.project_status_code%TYPE)
1407: RETURN VARCHAR2 IS
1408:
1409: l_show_in_search VARCHAR2(1);
1410:

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

1407: RETURN VARCHAR2 IS
1408:
1409: l_show_in_search VARCHAR2(1);
1410:
1411: TYPE status_code_tbl IS TABLE OF pa_project_statuses.project_status_code%TYPE
1412: INDEX BY BINARY_INTEGER;
1413: l_status_code_tbl status_code_tbl;
1414:
1415: BEGIN

Line 1491: pa_project_statuses ps

1487: asgn.ENABLE_AUTO_CAND_NOM_FLAG,
1488: proj.enable_automated_search
1489: FROM pa_project_assignments asgn,
1490: pa_projects_all proj,
1491: pa_project_statuses ps
1492: WHERE proj.project_id = p_project_id
1493: AND proj.project_id = asgn.project_id
1494: 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)
1495: AND asgn.assignment_type='OPEN_ASSIGNMENT'

Line 1518: pa_project_statuses ps

1514: asgn.ENABLE_AUTO_CAND_NOM_FLAG,
1515: proj.enable_automated_search
1516: FROM pa_project_assignments asgn,
1517: pa_projects_all proj,
1518: pa_project_statuses ps
1519: WHERE proj.segment1 BETWEEN nvl(p_project_number_from, proj.segment1) AND nvl(p_project_number_to, proj.segment1)
1520: -- 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)
1521: -- Changed for Bug 5299668
1522: AND trunc(nvl(proj.start_date, SYSDATE)) BETWEEN

Line 1556: l_status_code pa_project_statuses.project_status_code%TYPE;

1552: l_system_nom_candidate_text fnd_new_messages.message_text%TYPE;
1553: l_candidates_nom_in_cycle NUMBER := 0;
1554: l_req_enable_auto_cand_nom pa_project_assignments.ENABLE_AUTO_CAND_NOM_FLAG%TYPE;
1555: l_proj_enable_automated_search pa_projects_all.enable_automated_search%TYPE;
1556: l_status_code pa_project_statuses.project_status_code%TYPE;
1557: l_cand_system_status_code pa_project_statuses.project_system_status_code%TYPE;
1558: l_candidate_in_rec PA_RES_MANAGEMENT_AMG_PUB.CANDIDATE_IN_REC_TYPE; -- Added for bug 9187892
1559:
1560: BEGIN

Line 1557: l_cand_system_status_code pa_project_statuses.project_system_status_code%TYPE;

1553: l_candidates_nom_in_cycle NUMBER := 0;
1554: l_req_enable_auto_cand_nom pa_project_assignments.ENABLE_AUTO_CAND_NOM_FLAG%TYPE;
1555: l_proj_enable_automated_search pa_projects_all.enable_automated_search%TYPE;
1556: l_status_code pa_project_statuses.project_status_code%TYPE;
1557: l_cand_system_status_code pa_project_statuses.project_system_status_code%TYPE;
1558: l_candidate_in_rec PA_RES_MANAGEMENT_AMG_PUB.CANDIDATE_IN_REC_TYPE; -- Added for bug 9187892
1559:
1560: BEGIN
1561:

Line 1782: pa_project_statuses ps

1778: END IF;
1779:
1780: SELECT candidate_id BULK COLLECT INTO l_candidate_id_tbl
1781: FROM pa_candidates cand,
1782: pa_project_statuses ps
1783: WHERE assignment_id = PA_SEARCH_GLOB.g_search_criteria.assignment_id
1784: AND cand.status_code = ps.project_status_code
1785: AND ps.status_type = 'CANDIDATE'
1786: AND ps.project_system_status_code = l_cand_system_status_code