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_SEARCH_GLOB

Line 7: , p_search_criteria IN PA_SEARCH_GLOB.Search_Criteria_Rec_Type

3: --
4:
5: PROCEDURE Run_Search (
6: p_search_mode IN VARCHAR2
7: , p_search_criteria IN PA_SEARCH_GLOB.Search_Criteria_Rec_Type
8: , p_competence_criteria IN PA_SEARCH_GLOB.Competence_Criteria_Tbl_Type
9: , p_commit IN VARCHAR2
10: , p_validate_only IN VARCHAR2
11: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 8: , p_competence_criteria IN PA_SEARCH_GLOB.Competence_Criteria_Tbl_Type

4:
5: PROCEDURE Run_Search (
6: p_search_mode IN VARCHAR2
7: , p_search_criteria IN PA_SEARCH_GLOB.Search_Criteria_Rec_Type
8: , p_competence_criteria IN PA_SEARCH_GLOB.Competence_Criteria_Tbl_Type
9: , p_commit IN VARCHAR2
10: , p_validate_only IN VARCHAR2
11: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
12: ) IS

Line 789: -- PA_SEARCH_GLOB.get_min_prof_level(pct.competence_id)),

785: -- AND pce.proficiency_level_id =
786: -- prl.rating_level_id(+)
787: -- AND decode(prl.step_value, NULL,
788: -- decode(pct.rating_level, NULL, -999,
789: -- PA_SEARCH_GLOB.get_min_prof_level(pct.competence_id)),
790: -- prl.step_value) >=
791: -- nvl(pct.rating_level, nvl(prl.step_value , -999))
792: -- )
793: -- WHERE person_id = l_person_id_tbl(i);

Line 817: AND PA_SEARCH_GLOB.g_search_criteria.start_date between

813: AND pce.person_id = l_person_id_tbl(i)
814: AND pce.proficiency_level_id =
815: prl.rating_level_id(+)
816: /*code added for bug 2932045*/
817: AND PA_SEARCH_GLOB.g_search_criteria.start_date between
818: NVL(pce.EFFECTIVE_DATE_FROM,PA_SEARCH_GLOB.g_search_criteria.start_date)
819: and nvl(pce.EFFECTIVE_DATE_TO,PA_SEARCH_GLOB.g_search_criteria.start_date)
820: /*code addition ends for bug 2932045*/
821: AND decode(prl.step_value, NULL,

Line 818: NVL(pce.EFFECTIVE_DATE_FROM,PA_SEARCH_GLOB.g_search_criteria.start_date)

814: AND pce.proficiency_level_id =
815: prl.rating_level_id(+)
816: /*code added for bug 2932045*/
817: AND PA_SEARCH_GLOB.g_search_criteria.start_date between
818: NVL(pce.EFFECTIVE_DATE_FROM,PA_SEARCH_GLOB.g_search_criteria.start_date)
819: and nvl(pce.EFFECTIVE_DATE_TO,PA_SEARCH_GLOB.g_search_criteria.start_date)
820: /*code addition ends for bug 2932045*/
821: AND decode(prl.step_value, NULL,
822: decode(pct.rating_level, NULL, -999,

Line 819: and nvl(pce.EFFECTIVE_DATE_TO,PA_SEARCH_GLOB.g_search_criteria.start_date)

815: prl.rating_level_id(+)
816: /*code added for bug 2932045*/
817: AND PA_SEARCH_GLOB.g_search_criteria.start_date between
818: NVL(pce.EFFECTIVE_DATE_FROM,PA_SEARCH_GLOB.g_search_criteria.start_date)
819: and nvl(pce.EFFECTIVE_DATE_TO,PA_SEARCH_GLOB.g_search_criteria.start_date)
820: /*code addition ends for bug 2932045*/
821: AND decode(prl.step_value, NULL,
822: decode(pct.rating_level, NULL, -999,
823: PA_SEARCH_GLOB.get_min_prof_level(pct.competence_id)),

Line 823: PA_SEARCH_GLOB.get_min_prof_level(pct.competence_id)),

819: and nvl(pce.EFFECTIVE_DATE_TO,PA_SEARCH_GLOB.g_search_criteria.start_date)
820: /*code addition ends for bug 2932045*/
821: AND decode(prl.step_value, NULL,
822: decode(pct.rating_level, NULL, -999,
823: PA_SEARCH_GLOB.get_min_prof_level(pct.competence_id)),
824: prl.step_value) >=
825: nvl(pct.rating_level, nvl(prl.step_value , -999))
826: )
827: WHERE person_id = l_person_id_tbl(i);

Line 866: AND PA_SEARCH_GLOB.g_search_criteria.start_date between

862: WHERE pce.person_id = l_person_id_tbl(i)
863: AND pce.competence_id = pc.competence_id
864: /*code added for bug 2932045*/
865:
866: AND PA_SEARCH_GLOB.g_search_criteria.start_date between
867: NVL(pce.EFFECTIVE_DATE_FROM,PA_SEARCH_GLOB.g_search_criteria.start_date)
868: and nvl(pce.EFFECTIVE_DATE_TO,PA_SEARCH_GLOB.g_search_criteria.start_date)
869: /*code addition end for bug 2932045*/
870: AND pc.name like

Line 867: NVL(pce.EFFECTIVE_DATE_FROM,PA_SEARCH_GLOB.g_search_criteria.start_date)

863: AND pce.competence_id = pc.competence_id
864: /*code added for bug 2932045*/
865:
866: AND PA_SEARCH_GLOB.g_search_criteria.start_date between
867: NVL(pce.EFFECTIVE_DATE_FROM,PA_SEARCH_GLOB.g_search_criteria.start_date)
868: and nvl(pce.EFFECTIVE_DATE_TO,PA_SEARCH_GLOB.g_search_criteria.start_date)
869: /*code addition end for bug 2932045*/
870: AND pc.name like
871: (replace(pct.competence_name, '...') || '%')

Line 868: and nvl(pce.EFFECTIVE_DATE_TO,PA_SEARCH_GLOB.g_search_criteria.start_date)

864: /*code added for bug 2932045*/
865:
866: AND PA_SEARCH_GLOB.g_search_criteria.start_date between
867: NVL(pce.EFFECTIVE_DATE_FROM,PA_SEARCH_GLOB.g_search_criteria.start_date)
868: and nvl(pce.EFFECTIVE_DATE_TO,PA_SEARCH_GLOB.g_search_criteria.start_date)
869: /*code addition end for bug 2932045*/
870: AND pc.name like
871: (replace(pct.competence_name, '...') || '%')
872: AND pce.proficiency_level_id =

Line 876: PA_SEARCH_GLOB.get_min_prof_level(pce.competence_id)),

872: AND pce.proficiency_level_id =
873: prl.rating_level_id(+)
874: AND decode(prl.step_value, NULL,
875: decode(pct.rating_level, NULL, -999,
876: PA_SEARCH_GLOB.get_min_prof_level(pce.competence_id)),
877: prl.step_value) >=
878: nvl(pct.rating_level, nvl(prl.step_value , -999))
879: )
880: )

Line 1323: AND decode(prl2.step_value, NULL, decode(prl.step_value, NULL, -999, PA_SEARCH_GLOB.get_min_prof_level(pce2.competence_id)), prl2.step_value) >= nvl(prl.step_value, nvl(prl2.step_value , -999)))

1319: AND pce.proficiency_level_id = prl.rating_level_id(+)
1320: AND pce.competence_id = pce2.competence_id
1321: AND pce2.person_id = p_search_criteria.resource_source_id
1322: AND pce2.proficiency_level_id = prl2.rating_level_id(+)
1323: AND decode(prl2.step_value, NULL, decode(prl.step_value, NULL, -999, PA_SEARCH_GLOB.get_min_prof_level(pce2.competence_id)), prl2.step_value) >= nvl(prl.step_value, nvl(prl2.step_value , -999)))
1324: WHERE assignment_id = l_assignment_id_tbl(i);
1325:
1326: END IF; --resource source id is not null
1327:

Line 1538: FETCH get_auto_search_criteria INTO PA_SEARCH_GLOB.g_search_criteria.assignment_id,

1534: fnd_file.put_line(FND_FILE.LOG,'Looping through requirements');
1535: fnd_file.put_line(FND_FILE.LOG,'about to fetch from cursor');
1536: END IF;
1537:
1538: FETCH get_auto_search_criteria INTO PA_SEARCH_GLOB.g_search_criteria.assignment_id,
1539: PA_SEARCH_GLOB.g_search_criteria.project_id,
1540: PA_SEARCH_GLOB.g_search_criteria.min_job_level,
1541: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
1542: PA_SEARCH_GLOB.g_search_criteria.start_date,

Line 1539: PA_SEARCH_GLOB.g_search_criteria.project_id,

1535: fnd_file.put_line(FND_FILE.LOG,'about to fetch from cursor');
1536: END IF;
1537:
1538: FETCH get_auto_search_criteria INTO PA_SEARCH_GLOB.g_search_criteria.assignment_id,
1539: PA_SEARCH_GLOB.g_search_criteria.project_id,
1540: PA_SEARCH_GLOB.g_search_criteria.min_job_level,
1541: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
1542: PA_SEARCH_GLOB.g_search_criteria.start_date,
1543: PA_SEARCH_GLOB.g_search_criteria.end_date,

Line 1540: PA_SEARCH_GLOB.g_search_criteria.min_job_level,

1536: END IF;
1537:
1538: FETCH get_auto_search_criteria INTO PA_SEARCH_GLOB.g_search_criteria.assignment_id,
1539: PA_SEARCH_GLOB.g_search_criteria.project_id,
1540: PA_SEARCH_GLOB.g_search_criteria.min_job_level,
1541: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
1542: PA_SEARCH_GLOB.g_search_criteria.start_date,
1543: PA_SEARCH_GLOB.g_search_criteria.end_date,
1544: PA_SEARCH_GLOB.g_search_criteria.min_availability,

Line 1541: PA_SEARCH_GLOB.g_search_criteria.max_job_level,

1537:
1538: FETCH get_auto_search_criteria INTO PA_SEARCH_GLOB.g_search_criteria.assignment_id,
1539: PA_SEARCH_GLOB.g_search_criteria.project_id,
1540: PA_SEARCH_GLOB.g_search_criteria.min_job_level,
1541: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
1542: PA_SEARCH_GLOB.g_search_criteria.start_date,
1543: PA_SEARCH_GLOB.g_search_criteria.end_date,
1544: PA_SEARCH_GLOB.g_search_criteria.min_availability,
1545: PA_SEARCH_GLOB.g_search_criteria.territory_code,

Line 1542: PA_SEARCH_GLOB.g_search_criteria.start_date,

1538: FETCH get_auto_search_criteria INTO PA_SEARCH_GLOB.g_search_criteria.assignment_id,
1539: PA_SEARCH_GLOB.g_search_criteria.project_id,
1540: PA_SEARCH_GLOB.g_search_criteria.min_job_level,
1541: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
1542: PA_SEARCH_GLOB.g_search_criteria.start_date,
1543: PA_SEARCH_GLOB.g_search_criteria.end_date,
1544: PA_SEARCH_GLOB.g_search_criteria.min_availability,
1545: PA_SEARCH_GLOB.g_search_criteria.territory_code,
1546: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,

Line 1543: PA_SEARCH_GLOB.g_search_criteria.end_date,

1539: PA_SEARCH_GLOB.g_search_criteria.project_id,
1540: PA_SEARCH_GLOB.g_search_criteria.min_job_level,
1541: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
1542: PA_SEARCH_GLOB.g_search_criteria.start_date,
1543: PA_SEARCH_GLOB.g_search_criteria.end_date,
1544: PA_SEARCH_GLOB.g_search_criteria.min_availability,
1545: PA_SEARCH_GLOB.g_search_criteria.territory_code,
1546: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
1547: PA_SEARCH_GLOB.g_search_criteria.organization_id,

Line 1544: PA_SEARCH_GLOB.g_search_criteria.min_availability,

1540: PA_SEARCH_GLOB.g_search_criteria.min_job_level,
1541: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
1542: PA_SEARCH_GLOB.g_search_criteria.start_date,
1543: PA_SEARCH_GLOB.g_search_criteria.end_date,
1544: PA_SEARCH_GLOB.g_search_criteria.min_availability,
1545: PA_SEARCH_GLOB.g_search_criteria.territory_code,
1546: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
1547: PA_SEARCH_GLOB.g_search_criteria.organization_id,
1548: l_min_candidate_score,

Line 1545: PA_SEARCH_GLOB.g_search_criteria.territory_code,

1541: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
1542: PA_SEARCH_GLOB.g_search_criteria.start_date,
1543: PA_SEARCH_GLOB.g_search_criteria.end_date,
1544: PA_SEARCH_GLOB.g_search_criteria.min_availability,
1545: PA_SEARCH_GLOB.g_search_criteria.territory_code,
1546: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
1547: PA_SEARCH_GLOB.g_search_criteria.organization_id,
1548: l_min_candidate_score,
1549: PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING,

Line 1546: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,

1542: PA_SEARCH_GLOB.g_search_criteria.start_date,
1543: PA_SEARCH_GLOB.g_search_criteria.end_date,
1544: PA_SEARCH_GLOB.g_search_criteria.min_availability,
1545: PA_SEARCH_GLOB.g_search_criteria.territory_code,
1546: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
1547: PA_SEARCH_GLOB.g_search_criteria.organization_id,
1548: l_min_candidate_score,
1549: PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING,
1550: PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING,

Line 1547: PA_SEARCH_GLOB.g_search_criteria.organization_id,

1543: PA_SEARCH_GLOB.g_search_criteria.end_date,
1544: PA_SEARCH_GLOB.g_search_criteria.min_availability,
1545: PA_SEARCH_GLOB.g_search_criteria.territory_code,
1546: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
1547: PA_SEARCH_GLOB.g_search_criteria.organization_id,
1548: l_min_candidate_score,
1549: PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING,
1550: PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING,
1551: PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING,

Line 1549: PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING,

1545: PA_SEARCH_GLOB.g_search_criteria.territory_code,
1546: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
1547: PA_SEARCH_GLOB.g_search_criteria.organization_id,
1548: l_min_candidate_score,
1549: PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING,
1550: PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING,
1551: PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING,
1552: l_req_enable_auto_cand_nom,
1553: l_proj_enable_automated_search

Line 1550: PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING,

1546: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
1547: PA_SEARCH_GLOB.g_search_criteria.organization_id,
1548: l_min_candidate_score,
1549: PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING,
1550: PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING,
1551: PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING,
1552: l_req_enable_auto_cand_nom,
1553: l_proj_enable_automated_search
1554: ;

Line 1551: PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING,

1547: PA_SEARCH_GLOB.g_search_criteria.organization_id,
1548: l_min_candidate_score,
1549: PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING,
1550: PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING,
1551: PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING,
1552: l_req_enable_auto_cand_nom,
1553: l_proj_enable_automated_search
1554: ;
1555:

Line 1561: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);

1557:
1558: IF p_debug_mode = 'Y' THEN
1559: fnd_file.put_line(FND_FILE.LOG,'record fetched from cursor');
1560: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');
1561: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1562: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1563: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_job_level='||PA_SEARCH_GLOB.g_search_criteria.min_job_level);
1564: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.max_job_level='||PA_SEARCH_GLOB.g_search_criteria.max_job_level);
1565: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);

Line 1562: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);

1558: IF p_debug_mode = 'Y' THEN
1559: fnd_file.put_line(FND_FILE.LOG,'record fetched from cursor');
1560: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');
1561: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1562: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1563: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_job_level='||PA_SEARCH_GLOB.g_search_criteria.min_job_level);
1564: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.max_job_level='||PA_SEARCH_GLOB.g_search_criteria.max_job_level);
1565: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1566: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);

Line 1563: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_job_level='||PA_SEARCH_GLOB.g_search_criteria.min_job_level);

1559: fnd_file.put_line(FND_FILE.LOG,'record fetched from cursor');
1560: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');
1561: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1562: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1563: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_job_level='||PA_SEARCH_GLOB.g_search_criteria.min_job_level);
1564: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.max_job_level='||PA_SEARCH_GLOB.g_search_criteria.max_job_level);
1565: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1566: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1567: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);

Line 1564: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.max_job_level='||PA_SEARCH_GLOB.g_search_criteria.max_job_level);

1560: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');
1561: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1562: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1563: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_job_level='||PA_SEARCH_GLOB.g_search_criteria.min_job_level);
1564: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.max_job_level='||PA_SEARCH_GLOB.g_search_criteria.max_job_level);
1565: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1566: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1567: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1568: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);

Line 1565: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);

1561: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1562: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1563: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_job_level='||PA_SEARCH_GLOB.g_search_criteria.min_job_level);
1564: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.max_job_level='||PA_SEARCH_GLOB.g_search_criteria.max_job_level);
1565: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1566: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1567: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1568: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1569: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id='||PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id);

Line 1566: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);

1562: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1563: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_job_level='||PA_SEARCH_GLOB.g_search_criteria.min_job_level);
1564: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.max_job_level='||PA_SEARCH_GLOB.g_search_criteria.max_job_level);
1565: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1566: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1567: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1568: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1569: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id='||PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id);
1570: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);

Line 1567: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);

1563: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_job_level='||PA_SEARCH_GLOB.g_search_criteria.min_job_level);
1564: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.max_job_level='||PA_SEARCH_GLOB.g_search_criteria.max_job_level);
1565: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1566: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1567: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1568: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1569: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id='||PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id);
1570: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1571: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);

Line 1568: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);

1564: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.max_job_level='||PA_SEARCH_GLOB.g_search_criteria.max_job_level);
1565: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1566: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1567: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1568: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1569: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id='||PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id);
1570: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1571: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1572: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING);

Line 1569: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id='||PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id);

1565: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1566: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1567: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1568: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1569: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id='||PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id);
1570: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1571: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1572: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING);
1573: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING);

Line 1570: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);

1566: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1567: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1568: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1569: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id='||PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id);
1570: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1571: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1572: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING);
1573: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING);
1574: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING);

Line 1572: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING);

1568: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1569: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id='||PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id);
1570: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1571: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1572: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING);
1573: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING);
1574: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING);
1575: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);
1576: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);

Line 1573: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING);

1569: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id='||PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id);
1570: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1571: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1572: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING);
1573: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING);
1574: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING);
1575: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);
1576: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);
1577: fnd_file.put_line(FND_FILE.LOG,'about to call get_competencies API');

Line 1574: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING);

1570: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1571: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1572: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING);
1573: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING);
1574: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING='||PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING);
1575: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);
1576: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);
1577: fnd_file.put_line(FND_FILE.LOG,'about to call get_competencies API');
1578: END IF;

Line 1580: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := 'N';

1576: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);
1577: fnd_file.put_line(FND_FILE.LOG,'about to call get_competencies API');
1578: END IF;
1579:
1580: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := 'N';
1581: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := 'N';
1582: PA_SEARCH_GLOB.g_search_criteria.travel_domestically := 'N';
1583: PA_SEARCH_GLOB.g_search_criteria.travel_internationally := 'N';
1584:

Line 1581: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := 'N';

1577: fnd_file.put_line(FND_FILE.LOG,'about to call get_competencies API');
1578: END IF;
1579:
1580: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := 'N';
1581: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := 'N';
1582: PA_SEARCH_GLOB.g_search_criteria.travel_domestically := 'N';
1583: PA_SEARCH_GLOB.g_search_criteria.travel_internationally := 'N';
1584:
1585: -- Assign Provisional Availability to the global record.

Line 1582: PA_SEARCH_GLOB.g_search_criteria.travel_domestically := 'N';

1578: END IF;
1579:
1580: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := 'N';
1581: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := 'N';
1582: PA_SEARCH_GLOB.g_search_criteria.travel_domestically := 'N';
1583: PA_SEARCH_GLOB.g_search_criteria.travel_internationally := 'N';
1584:
1585: -- Assign Provisional Availability to the global record.
1586: PA_SEARCH_GLOB.g_search_criteria.provisional_availability := 'N';

Line 1583: PA_SEARCH_GLOB.g_search_criteria.travel_internationally := 'N';

1579:
1580: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := 'N';
1581: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := 'N';
1582: PA_SEARCH_GLOB.g_search_criteria.travel_domestically := 'N';
1583: PA_SEARCH_GLOB.g_search_criteria.travel_internationally := 'N';
1584:
1585: -- Assign Provisional Availability to the global record.
1586: PA_SEARCH_GLOB.g_search_criteria.provisional_availability := 'N';
1587:

Line 1586: PA_SEARCH_GLOB.g_search_criteria.provisional_availability := 'N';

1582: PA_SEARCH_GLOB.g_search_criteria.travel_domestically := 'N';
1583: PA_SEARCH_GLOB.g_search_criteria.travel_internationally := 'N';
1584:
1585: -- Assign Provisional Availability to the global record.
1586: PA_SEARCH_GLOB.g_search_criteria.provisional_availability := 'N';
1587:
1588: -- Make sure that the Requirement is not end-dated
1589:
1590: IF PA_SEARCH_GLOB.g_search_criteria.start_date < SYSDATE AND

Line 1590: IF PA_SEARCH_GLOB.g_search_criteria.start_date < SYSDATE AND

1586: PA_SEARCH_GLOB.g_search_criteria.provisional_availability := 'N';
1587:
1588: -- Make sure that the Requirement is not end-dated
1589:
1590: IF PA_SEARCH_GLOB.g_search_criteria.start_date < SYSDATE AND
1591: PA_SEARCH_GLOB.g_search_criteria.end_date < SYSDATE THEN
1592: IF p_debug_mode = 'Y' THEN
1593: fnd_file.put_line(FND_FILE.LOG,'Ignoring Assignment ID '||PA_SEARCH_GLOB.g_search_criteria.assignment_id ||' because it has been end-dated');
1594: END IF;

Line 1591: PA_SEARCH_GLOB.g_search_criteria.end_date < SYSDATE THEN

1587:
1588: -- Make sure that the Requirement is not end-dated
1589:
1590: IF PA_SEARCH_GLOB.g_search_criteria.start_date < SYSDATE AND
1591: PA_SEARCH_GLOB.g_search_criteria.end_date < SYSDATE THEN
1592: IF p_debug_mode = 'Y' THEN
1593: fnd_file.put_line(FND_FILE.LOG,'Ignoring Assignment ID '||PA_SEARCH_GLOB.g_search_criteria.assignment_id ||' because it has been end-dated');
1594: END IF;
1595:

Line 1593: fnd_file.put_line(FND_FILE.LOG,'Ignoring Assignment ID '||PA_SEARCH_GLOB.g_search_criteria.assignment_id ||' because it has been end-dated');

1589:
1590: IF PA_SEARCH_GLOB.g_search_criteria.start_date < SYSDATE AND
1591: PA_SEARCH_GLOB.g_search_criteria.end_date < SYSDATE THEN
1592: IF p_debug_mode = 'Y' THEN
1593: fnd_file.put_line(FND_FILE.LOG,'Ignoring Assignment ID '||PA_SEARCH_GLOB.g_search_criteria.assignment_id ||' because it has been end-dated');
1594: END IF;
1595:
1596: ELSE -- Only Process non-end-dated assignments
1597:

Line 1600: PA_SEARCH_GLOB.g_competence_criteria.delete; -- Added for Bug 3098252

1596: ELSE -- Only Process non-end-dated assignments
1597:
1598: --get the competencies for the requirement
1599: l_competency_tbl.delete; -- Added for Bug 3098252
1600: PA_SEARCH_GLOB.g_competence_criteria.delete; -- Added for Bug 3098252
1601:
1602: PA_HR_COMPETENCE_UTILS.get_competencies(p_object_name => 'OPEN_ASSIGNMENT',
1603: p_object_id => PA_SEARCH_GLOB.g_search_criteria.assignment_id,
1604: x_competency_tbl => l_competency_tbl,

Line 1603: p_object_id => PA_SEARCH_GLOB.g_search_criteria.assignment_id,

1599: l_competency_tbl.delete; -- Added for Bug 3098252
1600: PA_SEARCH_GLOB.g_competence_criteria.delete; -- Added for Bug 3098252
1601:
1602: PA_HR_COMPETENCE_UTILS.get_competencies(p_object_name => 'OPEN_ASSIGNMENT',
1603: p_object_id => PA_SEARCH_GLOB.g_search_criteria.assignment_id,
1604: x_competency_tbl => l_competency_tbl,
1605: x_no_of_competencies => l_no_of_competencies,
1606: x_error_message_code => l_error_msg_code,
1607: x_return_status => l_return_status);

Line 1629: PA_SEARCH_GLOB.g_competence_criteria(i).competence_id := l_competency_tbl(i).competence_id;

1625: IF p_debug_mode = 'Y' THEN
1626: fnd_file.put_line(FND_FILE.LOG,'in competencies loop');
1627: END IF;
1628:
1629: PA_SEARCH_GLOB.g_competence_criteria(i).competence_id := l_competency_tbl(i).competence_id;
1630: PA_SEARCH_GLOB.g_competence_criteria(i).competence_alias := l_competency_tbl(i).competence_alias;
1631: PA_SEARCH_GLOB.g_competence_criteria(i).mandatory_flag := l_competency_tbl(i).mandatory;
1632: PA_SEARCH_GLOB.g_competence_criteria(i).competence_name := NULL;
1633:

Line 1630: PA_SEARCH_GLOB.g_competence_criteria(i).competence_alias := l_competency_tbl(i).competence_alias;

1626: fnd_file.put_line(FND_FILE.LOG,'in competencies loop');
1627: END IF;
1628:
1629: PA_SEARCH_GLOB.g_competence_criteria(i).competence_id := l_competency_tbl(i).competence_id;
1630: PA_SEARCH_GLOB.g_competence_criteria(i).competence_alias := l_competency_tbl(i).competence_alias;
1631: PA_SEARCH_GLOB.g_competence_criteria(i).mandatory_flag := l_competency_tbl(i).mandatory;
1632: PA_SEARCH_GLOB.g_competence_criteria(i).competence_name := NULL;
1633:
1634: --get the rating level given the id if id is not null

Line 1631: PA_SEARCH_GLOB.g_competence_criteria(i).mandatory_flag := l_competency_tbl(i).mandatory;

1627: END IF;
1628:
1629: PA_SEARCH_GLOB.g_competence_criteria(i).competence_id := l_competency_tbl(i).competence_id;
1630: PA_SEARCH_GLOB.g_competence_criteria(i).competence_alias := l_competency_tbl(i).competence_alias;
1631: PA_SEARCH_GLOB.g_competence_criteria(i).mandatory_flag := l_competency_tbl(i).mandatory;
1632: PA_SEARCH_GLOB.g_competence_criteria(i).competence_name := NULL;
1633:
1634: --get the rating level given the id if id is not null
1635: --and store in global comp table.

Line 1632: PA_SEARCH_GLOB.g_competence_criteria(i).competence_name := NULL;

1628:
1629: PA_SEARCH_GLOB.g_competence_criteria(i).competence_id := l_competency_tbl(i).competence_id;
1630: PA_SEARCH_GLOB.g_competence_criteria(i).competence_alias := l_competency_tbl(i).competence_alias;
1631: PA_SEARCH_GLOB.g_competence_criteria(i).mandatory_flag := l_competency_tbl(i).mandatory;
1632: PA_SEARCH_GLOB.g_competence_criteria(i).competence_name := NULL;
1633:
1634: --get the rating level given the id if id is not null
1635: --and store in global comp table.
1636: IF l_competency_tbl(i).rating_level_id IS NOT NULL THEN

Line 1642: SELECT step_value INTO PA_SEARCH_GLOB.g_competence_criteria(i).rating_level

1638: IF p_debug_mode = 'Y' THEN
1639: fnd_file.put_line(FND_FILE.LOG,'about to get the rating level');
1640: END IF;
1641:
1642: SELECT step_value INTO PA_SEARCH_GLOB.g_competence_criteria(i).rating_level
1643: FROM per_rating_levels
1644: WHERE rating_level_id = l_competency_tbl(i).rating_level_id;
1645:
1646: IF p_debug_mode = 'Y' THEN

Line 1650: PA_SEARCH_GLOB.g_competence_criteria(i).rating_level := NULL;

1646: IF p_debug_mode = 'Y' THEN
1647: fnd_file.put_line(FND_FILE.LOG,'got the rating level');
1648: END IF;
1649: ELSE
1650: PA_SEARCH_GLOB.g_competence_criteria(i).rating_level := NULL;
1651: END IF;
1652:
1653: END LOOP;
1654:

Line 1670: p_search_criteria => PA_SEARCH_GLOB.g_search_criteria,

1666: fnd_file.put_line(FND_FILE.LOG,'about to call run search API');
1667: END IF;
1668:
1669: Run_Search(p_search_mode => 'RESOURCE',
1670: p_search_criteria => PA_SEARCH_GLOB.g_search_criteria,
1671: p_competence_criteria => PA_SEARCH_GLOB.g_competence_criteria,
1672: p_commit => FND_API.G_TRUE,
1673: p_validate_only => FND_API.G_FALSE,
1674: x_return_status => l_return_status);

Line 1671: p_competence_criteria => PA_SEARCH_GLOB.g_competence_criteria,

1667: END IF;
1668:
1669: Run_Search(p_search_mode => 'RESOURCE',
1670: p_search_criteria => PA_SEARCH_GLOB.g_search_criteria,
1671: p_competence_criteria => PA_SEARCH_GLOB.g_competence_criteria,
1672: p_commit => FND_API.G_TRUE,
1673: p_validate_only => FND_API.G_FALSE,
1674: x_return_status => l_return_status);
1675:

Line 1704: (p_assignment_id => PA_SEARCH_GLOB.g_search_criteria.assignment_id,

1700: fnd_file.put_line(FND_FILE.LOG,'about to call API to delete qualified candidates');
1701: END IF;
1702:
1703: PA_CANDIDATE_PUB.Delete_Candidates
1704: (p_assignment_id => PA_SEARCH_GLOB.g_search_criteria.assignment_id,
1705: p_status_code => '114',
1706: x_return_status => l_return_status,
1707: x_msg_count => l_msg_count,
1708: x_msg_data => l_msg_data);

Line 1732: WHERE assignment_id = PA_SEARCH_GLOB.g_search_criteria.assignment_id

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
1736: AND resource_id NOT IN

Line 1828: fnd_file.put_line(FND_FILE.LOG,'nominate resource '||l_resource_id_tbl(i)||' for assignment '||PA_SEARCH_GLOB.g_search_criteria.assignment_id|| ' on project '||PA_SEARCH_GLOB.g_search_criteria.project_id);

1824:
1825: --nominate the resource
1826: IF p_debug_mode = 'Y' THEN
1827: fnd_file.put_line(FND_FILE.LOG,'about to call Add_candidate API');
1828: fnd_file.put_line(FND_FILE.LOG,'nominate resource '||l_resource_id_tbl(i)||' for assignment '||PA_SEARCH_GLOB.g_search_criteria.assignment_id|| ' on project '||PA_SEARCH_GLOB.g_search_criteria.project_id);
1829: END IF;
1830:
1831: --add candidate API will
1832: --when I nominate as candidate:

Line 1842: p_assignment_id => PA_SEARCH_GLOB.g_search_criteria.assignment_id,

1838: -- do nothing if resource is already a qualified candidate
1839: -- else nominate as qualified candidate
1840:
1841: PA_CANDIDATE_PUB.Add_Candidate(
1842: p_assignment_id => PA_SEARCH_GLOB.g_search_criteria.assignment_id,
1843: p_resource_name => NULL,
1844: p_resource_id => l_resource_id_tbl(i),
1845: p_status_code => l_status_code, --**need to change to the system nominated status code when it is entered in SEED.
1846: p_nomination_comments => l_nomination_comments,

Line 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);

1863:
1864: END IF;
1865:
1866: IF p_debug_mode = 'Y' THEN
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

Line 1873: WHERE assignment_id = PA_SEARCH_GLOB.g_search_criteria.assignment_id;

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
1876: fnd_file.put_line(FND_FILE.LOG,'after updating last_auto_search_date for assignment id = '||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1877: END IF;

Line 1876: fnd_file.put_line(FND_FILE.LOG,'after updating last_auto_search_date for assignment id = '||PA_SEARCH_GLOB.g_search_criteria.assignment_id);

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
1876: fnd_file.put_line(FND_FILE.LOG,'after updating last_auto_search_date for assignment id = '||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1877: END IF;
1878:
1879: IF l_candidates_nom_in_cycle > 100 THEN
1880: