[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
428: , loc.country_code
429: , ter.territory_short_name
430: , loc.region
431: , loc.city
432: FROM pa_project_assignments asgn
433: , pa_org_hierarchy_denorm ohd
434: , pa_projects_all proj
435: , pa_locations loc
436: , fnd_territories_vl ter
479: , loc.country_code
480: , ter.territory_short_name
481: , loc.region
482: , loc.city
483: FROM pa_project_assignments asgn
484: , pa_org_hierarchy_denorm ohd
485: , pa_projects_all proj
486: , pa_locations loc
487: , fnd_territories_vl ter
530: , loc.country_code
531: , ter.territory_short_name
532: , loc.region
533: , loc.city
534: FROM pa_project_assignments asgn
535: , pa_org_hierarchy_denorm ohd
536: , pa_projects_all proj
537: , pa_locations loc
538: , fnd_territories_vl ter
580: , loc.country_code
581: , ter.territory_short_name
582: , loc.region
583: , loc.city
584: FROM pa_project_assignments asgn
585: , pa_org_hierarchy_denorm ohd
586: , pa_projects_all proj
587: , pa_locations loc
588: , fnd_territories_vl ter
625: , loc.country_code
626: , ter.territory_short_name
627: , loc.region
628: , loc.city
629: FROM pa_project_assignments asgn
630: , pa_org_hierarchy_denorm ohd
631: , pa_projects_all proj
632: , pa_locations loc
633: , fnd_territories_vl ter
1351:
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);
1435: asgn.AVAILABILITY_MATCH_WEIGHTING,
1436: asgn.JOB_LEVEL_MATCH_WEIGHTING,
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
1462: asgn.AVAILABILITY_MATCH_WEIGHTING,
1463: asgn.JOB_LEVEL_MATCH_WEIGHTING,
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)
1500: l_is_resource_candidate VARCHAR2(1);
1501: l_nomination_comments fnd_new_messages.message_text%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:
1867: 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);
1868: END IF;
1869:
1870: --stamp the date/time on the run on the requirement record
1871: UPDATE PA_PROJECT_ASSIGNMENTS
1872: SET last_auto_search_date = SYSDATE
1873: WHERE assignment_id = PA_SEARCH_GLOB.g_search_criteria.assignment_id;
1874:
1875: IF p_debug_mode = 'Y' THEN