[Home] [Help]
89: TYPE resource_job_level_tbl IS TABLE OF pa_resources_denorm.resource_job_level%TYPE
90: INDEX BY BINARY_INTEGER;
91: l_resource_job_level_tbl resource_job_level_tbl;
92:
93: TYPE assignment_id_tbl IS TABLE OF pa_project_assignments.assignment_id%TYPE
94: INDEX BY BINARY_INTEGER;
95: l_assignment_id_tbl assignment_id_tbl;
96:
97: TYPE assignment_name_tbl IS TABLE OF pa_project_assignments.assignment_name%TYPE
93: TYPE assignment_id_tbl IS TABLE OF pa_project_assignments.assignment_id%TYPE
94: INDEX BY BINARY_INTEGER;
95: l_assignment_id_tbl assignment_id_tbl;
96:
97: TYPE assignment_name_tbl IS TABLE OF pa_project_assignments.assignment_name%TYPE
98: INDEX BY BINARY_INTEGER;
99: l_assignment_name_tbl assignment_name_tbl;
100:
101: TYPE assignment_number_tbl IS TABLE OF pa_project_assignments.assignment_number%TYPE
97: TYPE assignment_name_tbl IS TABLE OF pa_project_assignments.assignment_name%TYPE
98: INDEX BY BINARY_INTEGER;
99: l_assignment_name_tbl assignment_name_tbl;
100:
101: TYPE assignment_number_tbl IS TABLE OF pa_project_assignments.assignment_number%TYPE
102: INDEX BY BINARY_INTEGER;
103: l_assignment_number_tbl assignment_number_tbl;
104:
105: TYPE assignment_start_date_tbl IS TABLE OF pa_project_assignments.start_date%TYPE
101: TYPE assignment_number_tbl IS TABLE OF pa_project_assignments.assignment_number%TYPE
102: INDEX BY BINARY_INTEGER;
103: l_assignment_number_tbl assignment_number_tbl;
104:
105: TYPE assignment_start_date_tbl IS TABLE OF pa_project_assignments.start_date%TYPE
106: INDEX BY BINARY_INTEGER;
107: l_assignment_start_date_tbl assignment_start_date_tbl;
108:
109: TYPE assignment_end_date_tbl IS TABLE OF pa_project_assignments.end_date%TYPE
105: TYPE assignment_start_date_tbl IS TABLE OF pa_project_assignments.start_date%TYPE
106: INDEX BY BINARY_INTEGER;
107: l_assignment_start_date_tbl assignment_start_date_tbl;
108:
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
436: , loc.country_code
437: , ter.territory_short_name
438: , loc.region
439: , loc.city
440: FROM pa_project_assignments asgn
441: , pa_org_hierarchy_denorm ohd
442: , pa_projects_all proj
443: , pa_locations loc
444: , fnd_territories_vl ter
487: , loc.country_code
488: , ter.territory_short_name
489: , loc.region
490: , loc.city
491: FROM pa_project_assignments asgn
492: , pa_org_hierarchy_denorm ohd
493: , pa_projects_all proj
494: , pa_locations loc
495: , fnd_territories_vl ter
538: , loc.country_code
539: , ter.territory_short_name
540: , loc.region
541: , loc.city
542: FROM pa_project_assignments asgn
543: , pa_org_hierarchy_denorm ohd
544: , pa_projects_all proj
545: , pa_locations loc
546: , fnd_territories_vl ter
588: , loc.country_code
589: , ter.territory_short_name
590: , loc.region
591: , loc.city
592: FROM pa_project_assignments asgn
593: , pa_org_hierarchy_denorm ohd
594: , pa_projects_all proj
595: , pa_locations loc
596: , fnd_territories_vl ter
633: , loc.country_code
634: , ter.territory_short_name
635: , loc.region
636: , loc.city
637: FROM pa_project_assignments asgn
638: , pa_org_hierarchy_denorm ohd
639: , pa_projects_all proj
640: , pa_locations loc
641: , fnd_territories_vl ter
1401:
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);
1485: asgn.AVAILABILITY_MATCH_WEIGHTING,
1486: asgn.JOB_LEVEL_MATCH_WEIGHTING,
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
1512: asgn.AVAILABILITY_MATCH_WEIGHTING,
1513: asgn.JOB_LEVEL_MATCH_WEIGHTING,
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)
1550: l_is_resource_candidate VARCHAR2(1);
1551: l_nomination_comments fnd_new_messages.message_text%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
1935: fnd_file.put_line(FND_FILE.LOG,'about to update last_auto_search_date for assignment id = '||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1936: END IF;
1937:
1938: --stamp the date/time on the run on the requirement record
1939: UPDATE PA_PROJECT_ASSIGNMENTS
1940: SET last_auto_search_date = SYSDATE
1941: WHERE assignment_id = PA_SEARCH_GLOB.g_search_criteria.assignment_id;
1942:
1943: IF p_debug_mode = 'Y' THEN