[Home] [Help]
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
118: INDEX BY BINARY_INTEGER;
119: l_project_id_tbl project_id_tbl;
120:
121: TYPE project_name_tbl IS TABLE OF pa_projects_all.name%TYPE
117: TYPE project_id_tbl IS TABLE OF pa_projects_all.project_id%TYPE
118: INDEX BY BINARY_INTEGER;
119: l_project_id_tbl project_id_tbl;
120:
121: TYPE project_name_tbl IS TABLE OF pa_projects_all.name%TYPE
122: INDEX BY BINARY_INTEGER;
123: l_project_name_tbl project_name_tbl;
124:
125: TYPE project_number_tbl IS TABLE OF pa_projects_all.segment1%TYPE
121: TYPE project_name_tbl IS TABLE OF pa_projects_all.name%TYPE
122: INDEX BY BINARY_INTEGER;
123: l_project_name_tbl project_name_tbl;
124:
125: TYPE project_number_tbl IS TABLE OF pa_projects_all.segment1%TYPE
126: INDEX BY BINARY_INTEGER;
127: l_project_number_tbl project_number_tbl;
128:
129: --define the variable type
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
445: , pa_project_statuses ps
446: , pa_advertised_open_req_v aor
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
496: , pa_project_statuses ps
497: , pa_advertised_open_req_v aor
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
547: , pa_project_statuses ps
548: , pa_advertised_open_req_v aor
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
597: , pa_project_statuses ps
598: , pa_advertised_open_req_v aor
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
642: , pa_project_statuses ps
643: , pa_advertised_open_req_v aor
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
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)
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)
1521: -- Changed for Bug 5299668
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
1559: