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 797: -- PA_SEARCH_GLOB.get_min_prof_level(pct.competence_id)),

793: -- AND pce.proficiency_level_id =
794: -- prl.rating_level_id(+)
795: -- AND decode(prl.step_value, NULL,
796: -- decode(pct.rating_level, NULL, -999,
797: -- PA_SEARCH_GLOB.get_min_prof_level(pct.competence_id)),
798: -- prl.step_value) >=
799: -- nvl(pct.rating_level, nvl(prl.step_value , -999))
800: -- )
801: -- WHERE person_id = l_person_id_tbl(i);

Line 826: AND PA_SEARCH_GLOB.g_search_criteria.start_date between

822: AND pce.person_id = l_person_id_tbl(i)
823: AND pce.proficiency_level_id =
824: prl.rating_level_id(+)
825: /*code added for bug 2932045*/
826: AND PA_SEARCH_GLOB.g_search_criteria.start_date between
827: NVL(pce.EFFECTIVE_DATE_FROM,PA_SEARCH_GLOB.g_search_criteria.start_date)
828: and nvl(pce.EFFECTIVE_DATE_TO,PA_SEARCH_GLOB.g_search_criteria.start_date)
829: /*code addition ends for bug 2932045*/
830: AND decode(prl.step_value, NULL,

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

823: AND pce.proficiency_level_id =
824: prl.rating_level_id(+)
825: /*code added for bug 2932045*/
826: AND PA_SEARCH_GLOB.g_search_criteria.start_date between
827: NVL(pce.EFFECTIVE_DATE_FROM,PA_SEARCH_GLOB.g_search_criteria.start_date)
828: and nvl(pce.EFFECTIVE_DATE_TO,PA_SEARCH_GLOB.g_search_criteria.start_date)
829: /*code addition ends for bug 2932045*/
830: AND decode(prl.step_value, NULL,
831: decode(pct.rating_level, NULL, -999,

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

824: prl.rating_level_id(+)
825: /*code added for bug 2932045*/
826: AND PA_SEARCH_GLOB.g_search_criteria.start_date between
827: NVL(pce.EFFECTIVE_DATE_FROM,PA_SEARCH_GLOB.g_search_criteria.start_date)
828: and nvl(pce.EFFECTIVE_DATE_TO,PA_SEARCH_GLOB.g_search_criteria.start_date)
829: /*code addition ends for bug 2932045*/
830: AND decode(prl.step_value, NULL,
831: decode(pct.rating_level, NULL, -999,
832: PA_SEARCH_GLOB.get_min_prof_level(pct.competence_id)),

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

828: and nvl(pce.EFFECTIVE_DATE_TO,PA_SEARCH_GLOB.g_search_criteria.start_date)
829: /*code addition ends for bug 2932045*/
830: AND decode(prl.step_value, NULL,
831: decode(pct.rating_level, NULL, -999,
832: PA_SEARCH_GLOB.get_min_prof_level(pct.competence_id)),
833: prl.step_value) >=
834: nvl(pct.rating_level, nvl(prl.step_value , -999))
835: )
836: WHERE person_id = l_person_id_tbl(i);

Line 882: AND PA_SEARCH_GLOB.g_search_criteria.start_date between

878: WHERE pce.person_id = l_person_id_tbl(i)
879: AND pce.competence_id = pc.competence_id
880: /*code added for bug 2932045*/
881:
882: AND PA_SEARCH_GLOB.g_search_criteria.start_date between
883: NVL(pce.EFFECTIVE_DATE_FROM,PA_SEARCH_GLOB.g_search_criteria.start_date)
884: and nvl(pce.EFFECTIVE_DATE_TO,PA_SEARCH_GLOB.g_search_criteria.start_date)
885: /*code addition end for bug 2932045*/
886: AND pc.name like

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

879: AND pce.competence_id = pc.competence_id
880: /*code added for bug 2932045*/
881:
882: AND PA_SEARCH_GLOB.g_search_criteria.start_date between
883: NVL(pce.EFFECTIVE_DATE_FROM,PA_SEARCH_GLOB.g_search_criteria.start_date)
884: and nvl(pce.EFFECTIVE_DATE_TO,PA_SEARCH_GLOB.g_search_criteria.start_date)
885: /*code addition end for bug 2932045*/
886: AND pc.name like
887: (replace(pct.competence_name, '...') || '%')

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

880: /*code added for bug 2932045*/
881:
882: AND PA_SEARCH_GLOB.g_search_criteria.start_date between
883: NVL(pce.EFFECTIVE_DATE_FROM,PA_SEARCH_GLOB.g_search_criteria.start_date)
884: and nvl(pce.EFFECTIVE_DATE_TO,PA_SEARCH_GLOB.g_search_criteria.start_date)
885: /*code addition end for bug 2932045*/
886: AND pc.name like
887: (replace(pct.competence_name, '...') || '%')
888: AND pce.proficiency_level_id =

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

888: AND pce.proficiency_level_id =
889: prl.rating_level_id(+)
890: AND decode(prl.step_value, NULL,
891: decode(pct.rating_level, NULL, -999,
892: PA_SEARCH_GLOB.get_min_prof_level(pce.competence_id)),
893: prl.step_value) >=
894: nvl(pct.rating_level, nvl(prl.step_value , -999))
895: )
896: )

Line 1373: 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)))

1369: AND pce.proficiency_level_id = prl.rating_level_id(+)
1370: AND pce.competence_id = pce2.competence_id
1371: AND pce2.person_id = p_search_criteria.resource_source_id
1372: AND pce2.proficiency_level_id = prl2.rating_level_id(+)
1373: 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)))
1374: WHERE assignment_id = l_assignment_id_tbl(i);
1375:
1376: END IF; --resource source id is not null
1377:

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

1585: fnd_file.put_line(FND_FILE.LOG,'Looping through requirements');
1586: fnd_file.put_line(FND_FILE.LOG,'about to fetch from cursor');
1587: END IF;
1588:
1589: FETCH get_auto_search_criteria INTO PA_SEARCH_GLOB.g_search_criteria.assignment_id,
1590: PA_SEARCH_GLOB.g_search_criteria.project_id,
1591: PA_SEARCH_GLOB.g_search_criteria.min_job_level,
1592: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
1593: PA_SEARCH_GLOB.g_search_criteria.start_date,

Line 1590: PA_SEARCH_GLOB.g_search_criteria.project_id,

1586: fnd_file.put_line(FND_FILE.LOG,'about to fetch from cursor');
1587: END IF;
1588:
1589: FETCH get_auto_search_criteria INTO PA_SEARCH_GLOB.g_search_criteria.assignment_id,
1590: PA_SEARCH_GLOB.g_search_criteria.project_id,
1591: PA_SEARCH_GLOB.g_search_criteria.min_job_level,
1592: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
1593: PA_SEARCH_GLOB.g_search_criteria.start_date,
1594: PA_SEARCH_GLOB.g_search_criteria.end_date,

Line 1591: PA_SEARCH_GLOB.g_search_criteria.min_job_level,

1587: END IF;
1588:
1589: FETCH get_auto_search_criteria INTO PA_SEARCH_GLOB.g_search_criteria.assignment_id,
1590: PA_SEARCH_GLOB.g_search_criteria.project_id,
1591: PA_SEARCH_GLOB.g_search_criteria.min_job_level,
1592: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
1593: PA_SEARCH_GLOB.g_search_criteria.start_date,
1594: PA_SEARCH_GLOB.g_search_criteria.end_date,
1595: PA_SEARCH_GLOB.g_search_criteria.min_availability,

Line 1592: PA_SEARCH_GLOB.g_search_criteria.max_job_level,

1588:
1589: FETCH get_auto_search_criteria INTO PA_SEARCH_GLOB.g_search_criteria.assignment_id,
1590: PA_SEARCH_GLOB.g_search_criteria.project_id,
1591: PA_SEARCH_GLOB.g_search_criteria.min_job_level,
1592: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
1593: PA_SEARCH_GLOB.g_search_criteria.start_date,
1594: PA_SEARCH_GLOB.g_search_criteria.end_date,
1595: PA_SEARCH_GLOB.g_search_criteria.min_availability,
1596: PA_SEARCH_GLOB.g_search_criteria.territory_code,

Line 1593: PA_SEARCH_GLOB.g_search_criteria.start_date,

1589: FETCH get_auto_search_criteria INTO PA_SEARCH_GLOB.g_search_criteria.assignment_id,
1590: PA_SEARCH_GLOB.g_search_criteria.project_id,
1591: PA_SEARCH_GLOB.g_search_criteria.min_job_level,
1592: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
1593: PA_SEARCH_GLOB.g_search_criteria.start_date,
1594: PA_SEARCH_GLOB.g_search_criteria.end_date,
1595: PA_SEARCH_GLOB.g_search_criteria.min_availability,
1596: PA_SEARCH_GLOB.g_search_criteria.territory_code,
1597: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,

Line 1594: PA_SEARCH_GLOB.g_search_criteria.end_date,

1590: PA_SEARCH_GLOB.g_search_criteria.project_id,
1591: PA_SEARCH_GLOB.g_search_criteria.min_job_level,
1592: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
1593: PA_SEARCH_GLOB.g_search_criteria.start_date,
1594: PA_SEARCH_GLOB.g_search_criteria.end_date,
1595: PA_SEARCH_GLOB.g_search_criteria.min_availability,
1596: PA_SEARCH_GLOB.g_search_criteria.territory_code,
1597: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
1598: PA_SEARCH_GLOB.g_search_criteria.organization_id,

Line 1595: PA_SEARCH_GLOB.g_search_criteria.min_availability,

1591: PA_SEARCH_GLOB.g_search_criteria.min_job_level,
1592: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
1593: PA_SEARCH_GLOB.g_search_criteria.start_date,
1594: PA_SEARCH_GLOB.g_search_criteria.end_date,
1595: PA_SEARCH_GLOB.g_search_criteria.min_availability,
1596: PA_SEARCH_GLOB.g_search_criteria.territory_code,
1597: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
1598: PA_SEARCH_GLOB.g_search_criteria.organization_id,
1599: l_min_candidate_score,

Line 1596: PA_SEARCH_GLOB.g_search_criteria.territory_code,

1592: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
1593: PA_SEARCH_GLOB.g_search_criteria.start_date,
1594: PA_SEARCH_GLOB.g_search_criteria.end_date,
1595: PA_SEARCH_GLOB.g_search_criteria.min_availability,
1596: PA_SEARCH_GLOB.g_search_criteria.territory_code,
1597: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
1598: PA_SEARCH_GLOB.g_search_criteria.organization_id,
1599: l_min_candidate_score,
1600: PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING,

Line 1597: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,

1593: PA_SEARCH_GLOB.g_search_criteria.start_date,
1594: PA_SEARCH_GLOB.g_search_criteria.end_date,
1595: PA_SEARCH_GLOB.g_search_criteria.min_availability,
1596: PA_SEARCH_GLOB.g_search_criteria.territory_code,
1597: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
1598: PA_SEARCH_GLOB.g_search_criteria.organization_id,
1599: l_min_candidate_score,
1600: PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING,
1601: PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING,

Line 1598: PA_SEARCH_GLOB.g_search_criteria.organization_id,

1594: PA_SEARCH_GLOB.g_search_criteria.end_date,
1595: PA_SEARCH_GLOB.g_search_criteria.min_availability,
1596: PA_SEARCH_GLOB.g_search_criteria.territory_code,
1597: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
1598: PA_SEARCH_GLOB.g_search_criteria.organization_id,
1599: l_min_candidate_score,
1600: PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING,
1601: PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING,
1602: PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING,

Line 1600: PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING,

1596: PA_SEARCH_GLOB.g_search_criteria.territory_code,
1597: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
1598: PA_SEARCH_GLOB.g_search_criteria.organization_id,
1599: l_min_candidate_score,
1600: PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING,
1601: PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING,
1602: PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING,
1603: l_req_enable_auto_cand_nom,
1604: l_proj_enable_automated_search

Line 1601: PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING,

1597: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
1598: PA_SEARCH_GLOB.g_search_criteria.organization_id,
1599: l_min_candidate_score,
1600: PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING,
1601: PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING,
1602: PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING,
1603: l_req_enable_auto_cand_nom,
1604: l_proj_enable_automated_search
1605: ;

Line 1602: PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING,

1598: PA_SEARCH_GLOB.g_search_criteria.organization_id,
1599: l_min_candidate_score,
1600: PA_SEARCH_GLOB.g_search_criteria.COMPETENCE_MATCH_WEIGHTING,
1601: PA_SEARCH_GLOB.g_search_criteria.AVAILABILITY_MATCH_WEIGHTING,
1602: PA_SEARCH_GLOB.g_search_criteria.JOB_LEVEL_MATCH_WEIGHTING,
1603: l_req_enable_auto_cand_nom,
1604: l_proj_enable_automated_search
1605: ;
1606:

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

1608:
1609: IF p_debug_mode = 'Y' THEN
1610: fnd_file.put_line(FND_FILE.LOG,'record fetched from cursor');
1611: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');
1612: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1613: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1614: 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);
1615: 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);
1616: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);

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

1609: IF p_debug_mode = 'Y' THEN
1610: fnd_file.put_line(FND_FILE.LOG,'record fetched from cursor');
1611: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');
1612: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1613: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1614: 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);
1615: 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);
1616: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1617: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);

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

1610: fnd_file.put_line(FND_FILE.LOG,'record fetched from cursor');
1611: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');
1612: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1613: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1614: 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);
1615: 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);
1616: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1617: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1618: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);

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

1611: fnd_file.put_line(FND_FILE.LOG,'fetch from cursor complete');
1612: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1613: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1614: 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);
1615: 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);
1616: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1617: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1618: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1619: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);

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

1612: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.assignment_id='||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1613: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1614: 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);
1615: 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);
1616: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1617: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1618: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1619: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1620: 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 1617: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);

1613: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.project_id='||PA_SEARCH_GLOB.g_search_criteria.project_id);
1614: 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);
1615: 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);
1616: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1617: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1618: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1619: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1620: 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);
1621: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);

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

1614: 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);
1615: 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);
1616: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1617: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1618: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1619: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1620: 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);
1621: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1622: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);

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

1615: 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);
1616: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1617: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1618: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1619: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1620: 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);
1621: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1622: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1623: 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 1620: 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);

1616: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.start_date='||PA_SEARCH_GLOB.g_search_criteria.start_date);
1617: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1618: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1619: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1620: 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);
1621: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1622: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1623: 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);
1624: 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 1621: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);

1617: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.end_date='||PA_SEARCH_GLOB.g_search_criteria.end_date);
1618: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.min_availability='||PA_SEARCH_GLOB.g_search_criteria.min_availability);
1619: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1620: 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);
1621: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1622: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1623: 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);
1624: 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);
1625: 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 1623: 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);

1619: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.territory_code='||PA_SEARCH_GLOB.g_search_criteria.territory_code);
1620: 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);
1621: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1622: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1623: 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);
1624: 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);
1625: 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);
1626: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);
1627: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);

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

1620: 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);
1621: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1622: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1623: 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);
1624: 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);
1625: 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);
1626: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);
1627: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);
1628: fnd_file.put_line(FND_FILE.LOG,'about to call get_competencies API');

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

1621: fnd_file.put_line(FND_FILE.LOG,'PA_SEARCH_GLOB.g_search_criteria.organization_id='||PA_SEARCH_GLOB.g_search_criteria.organization_id);
1622: fnd_file.put_line(FND_FILE.LOG,'l_min_candidate_score='||l_min_candidate_score);
1623: 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);
1624: 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);
1625: 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);
1626: fnd_file.put_line(FND_FILE.LOG,'l_req_enable_auto_cand_nom='||l_req_enable_auto_cand_nom);
1627: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);
1628: fnd_file.put_line(FND_FILE.LOG,'about to call get_competencies API');
1629: END IF;

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

1627: fnd_file.put_line(FND_FILE.LOG,'l_proj_enable_automated_search='||l_proj_enable_automated_search);
1628: fnd_file.put_line(FND_FILE.LOG,'about to call get_competencies API');
1629: END IF;
1630:
1631: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := 'N';
1632: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := 'N';
1633: PA_SEARCH_GLOB.g_search_criteria.travel_domestically := 'N';
1634: PA_SEARCH_GLOB.g_search_criteria.travel_internationally := 'N';
1635:

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

1628: fnd_file.put_line(FND_FILE.LOG,'about to call get_competencies API');
1629: END IF;
1630:
1631: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := 'N';
1632: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := 'N';
1633: PA_SEARCH_GLOB.g_search_criteria.travel_domestically := 'N';
1634: PA_SEARCH_GLOB.g_search_criteria.travel_internationally := 'N';
1635:
1636: -- Assign Provisional Availability to the global record.

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

1629: END IF;
1630:
1631: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := 'N';
1632: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := 'N';
1633: PA_SEARCH_GLOB.g_search_criteria.travel_domestically := 'N';
1634: PA_SEARCH_GLOB.g_search_criteria.travel_internationally := 'N';
1635:
1636: -- Assign Provisional Availability to the global record.
1637: PA_SEARCH_GLOB.g_search_criteria.provisional_availability := 'N';

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

1630:
1631: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := 'N';
1632: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := 'N';
1633: PA_SEARCH_GLOB.g_search_criteria.travel_domestically := 'N';
1634: PA_SEARCH_GLOB.g_search_criteria.travel_internationally := 'N';
1635:
1636: -- Assign Provisional Availability to the global record.
1637: PA_SEARCH_GLOB.g_search_criteria.provisional_availability := 'N';
1638:

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

1633: PA_SEARCH_GLOB.g_search_criteria.travel_domestically := 'N';
1634: PA_SEARCH_GLOB.g_search_criteria.travel_internationally := 'N';
1635:
1636: -- Assign Provisional Availability to the global record.
1637: PA_SEARCH_GLOB.g_search_criteria.provisional_availability := 'N';
1638:
1639: -- Make sure that the Requirement is not end-dated
1640:
1641: IF PA_SEARCH_GLOB.g_search_criteria.start_date < SYSDATE AND

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

1637: PA_SEARCH_GLOB.g_search_criteria.provisional_availability := 'N';
1638:
1639: -- Make sure that the Requirement is not end-dated
1640:
1641: IF PA_SEARCH_GLOB.g_search_criteria.start_date < SYSDATE AND
1642: PA_SEARCH_GLOB.g_search_criteria.end_date < SYSDATE THEN
1643: IF p_debug_mode = 'Y' THEN
1644: fnd_file.put_line(FND_FILE.LOG,'Ignoring Assignment ID '||PA_SEARCH_GLOB.g_search_criteria.assignment_id ||' because it has been end-dated');
1645: END IF;

Line 1642: PA_SEARCH_GLOB.g_search_criteria.end_date < SYSDATE THEN

1638:
1639: -- Make sure that the Requirement is not end-dated
1640:
1641: IF PA_SEARCH_GLOB.g_search_criteria.start_date < SYSDATE AND
1642: PA_SEARCH_GLOB.g_search_criteria.end_date < SYSDATE THEN
1643: IF p_debug_mode = 'Y' THEN
1644: fnd_file.put_line(FND_FILE.LOG,'Ignoring Assignment ID '||PA_SEARCH_GLOB.g_search_criteria.assignment_id ||' because it has been end-dated');
1645: END IF;
1646:

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

1640:
1641: IF PA_SEARCH_GLOB.g_search_criteria.start_date < SYSDATE AND
1642: PA_SEARCH_GLOB.g_search_criteria.end_date < SYSDATE THEN
1643: IF p_debug_mode = 'Y' THEN
1644: fnd_file.put_line(FND_FILE.LOG,'Ignoring Assignment ID '||PA_SEARCH_GLOB.g_search_criteria.assignment_id ||' because it has been end-dated');
1645: END IF;
1646:
1647: ELSE -- Only Process non-end-dated assignments
1648:

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

1647: ELSE -- Only Process non-end-dated assignments
1648:
1649: --get the competencies for the requirement
1650: l_competency_tbl.delete; -- Added for Bug 3098252
1651: PA_SEARCH_GLOB.g_competence_criteria.delete; -- Added for Bug 3098252
1652:
1653: PA_HR_COMPETENCE_UTILS.get_competencies(p_object_name => 'OPEN_ASSIGNMENT',
1654: p_object_id => PA_SEARCH_GLOB.g_search_criteria.assignment_id,
1655: x_competency_tbl => l_competency_tbl,

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

1650: l_competency_tbl.delete; -- Added for Bug 3098252
1651: PA_SEARCH_GLOB.g_competence_criteria.delete; -- Added for Bug 3098252
1652:
1653: PA_HR_COMPETENCE_UTILS.get_competencies(p_object_name => 'OPEN_ASSIGNMENT',
1654: p_object_id => PA_SEARCH_GLOB.g_search_criteria.assignment_id,
1655: x_competency_tbl => l_competency_tbl,
1656: x_no_of_competencies => l_no_of_competencies,
1657: x_error_message_code => l_error_msg_code,
1658: x_return_status => l_return_status);

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

1676: IF p_debug_mode = 'Y' THEN
1677: fnd_file.put_line(FND_FILE.LOG,'in competencies loop');
1678: END IF;
1679:
1680: PA_SEARCH_GLOB.g_competence_criteria(i).competence_id := l_competency_tbl(i).competence_id;
1681: PA_SEARCH_GLOB.g_competence_criteria(i).competence_alias := l_competency_tbl(i).competence_alias;
1682: PA_SEARCH_GLOB.g_competence_criteria(i).mandatory_flag := l_competency_tbl(i).mandatory;
1683: PA_SEARCH_GLOB.g_competence_criteria(i).competence_name := NULL;
1684:

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

1677: fnd_file.put_line(FND_FILE.LOG,'in competencies loop');
1678: END IF;
1679:
1680: PA_SEARCH_GLOB.g_competence_criteria(i).competence_id := l_competency_tbl(i).competence_id;
1681: PA_SEARCH_GLOB.g_competence_criteria(i).competence_alias := l_competency_tbl(i).competence_alias;
1682: PA_SEARCH_GLOB.g_competence_criteria(i).mandatory_flag := l_competency_tbl(i).mandatory;
1683: PA_SEARCH_GLOB.g_competence_criteria(i).competence_name := NULL;
1684:
1685: --get the rating level given the id if id is not null

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

1678: END IF;
1679:
1680: PA_SEARCH_GLOB.g_competence_criteria(i).competence_id := l_competency_tbl(i).competence_id;
1681: PA_SEARCH_GLOB.g_competence_criteria(i).competence_alias := l_competency_tbl(i).competence_alias;
1682: PA_SEARCH_GLOB.g_competence_criteria(i).mandatory_flag := l_competency_tbl(i).mandatory;
1683: PA_SEARCH_GLOB.g_competence_criteria(i).competence_name := NULL;
1684:
1685: --get the rating level given the id if id is not null
1686: --and store in global comp table.

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

1679:
1680: PA_SEARCH_GLOB.g_competence_criteria(i).competence_id := l_competency_tbl(i).competence_id;
1681: PA_SEARCH_GLOB.g_competence_criteria(i).competence_alias := l_competency_tbl(i).competence_alias;
1682: PA_SEARCH_GLOB.g_competence_criteria(i).mandatory_flag := l_competency_tbl(i).mandatory;
1683: PA_SEARCH_GLOB.g_competence_criteria(i).competence_name := NULL;
1684:
1685: --get the rating level given the id if id is not null
1686: --and store in global comp table.
1687: IF l_competency_tbl(i).rating_level_id IS NOT NULL THEN

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

1689: IF p_debug_mode = 'Y' THEN
1690: fnd_file.put_line(FND_FILE.LOG,'about to get the rating level');
1691: END IF;
1692:
1693: SELECT step_value INTO PA_SEARCH_GLOB.g_competence_criteria(i).rating_level
1694: FROM per_rating_levels
1695: WHERE rating_level_id = l_competency_tbl(i).rating_level_id;
1696:
1697: IF p_debug_mode = 'Y' THEN

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

1697: IF p_debug_mode = 'Y' THEN
1698: fnd_file.put_line(FND_FILE.LOG,'got the rating level');
1699: END IF;
1700: ELSE
1701: PA_SEARCH_GLOB.g_competence_criteria(i).rating_level := NULL;
1702: END IF;
1703:
1704: END LOOP;
1705:

Line 1721: p_search_criteria => PA_SEARCH_GLOB.g_search_criteria,

1717: fnd_file.put_line(FND_FILE.LOG,'about to call run search API');
1718: END IF;
1719:
1720: Run_Search(p_search_mode => 'RESOURCE',
1721: p_search_criteria => PA_SEARCH_GLOB.g_search_criteria,
1722: p_competence_criteria => PA_SEARCH_GLOB.g_competence_criteria,
1723: p_commit => FND_API.G_TRUE,
1724: p_validate_only => FND_API.G_FALSE,
1725: x_return_status => l_return_status);

Line 1722: p_competence_criteria => PA_SEARCH_GLOB.g_competence_criteria,

1718: END IF;
1719:
1720: Run_Search(p_search_mode => 'RESOURCE',
1721: p_search_criteria => PA_SEARCH_GLOB.g_search_criteria,
1722: p_competence_criteria => PA_SEARCH_GLOB.g_competence_criteria,
1723: p_commit => FND_API.G_TRUE,
1724: p_validate_only => FND_API.G_FALSE,
1725: x_return_status => l_return_status);
1726:

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

1751: fnd_file.put_line(FND_FILE.LOG,'about to call API to delete qualified candidates');
1752: END IF;
1753:
1754: PA_CANDIDATE_PUB.Delete_Candidates
1755: (p_assignment_id => PA_SEARCH_GLOB.g_search_criteria.assignment_id,
1756: p_status_code => '114',
1757: x_return_status => l_return_status,
1758: x_msg_count => l_msg_count,
1759: x_msg_data => l_msg_data);

Line 1783: WHERE assignment_id = PA_SEARCH_GLOB.g_search_criteria.assignment_id

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

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

1875:
1876: --nominate the resource
1877: IF p_debug_mode = 'Y' THEN
1878: fnd_file.put_line(FND_FILE.LOG,'about to call Add_candidate API');
1879: 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);
1880: END IF;
1881:
1882: --add candidate API will
1883: --when I nominate as candidate:

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

1889: -- do nothing if resource is already a qualified candidate
1890: -- else nominate as qualified candidate
1891:
1892: PA_CANDIDATE_PUB.Add_Candidate(
1893: p_assignment_id => PA_SEARCH_GLOB.g_search_criteria.assignment_id,
1894: p_resource_name => NULL,
1895: p_resource_id => l_resource_id_tbl(i),
1896: p_status_code => l_status_code, --**need to change to the system nominated status code when it is entered in SEED.
1897: p_nomination_comments => l_nomination_comments,

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

1931:
1932: END IF;
1933:
1934: IF p_debug_mode = 'Y' THEN
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

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

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

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

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
1944: fnd_file.put_line(FND_FILE.LOG,'after updating last_auto_search_date for assignment id = '||PA_SEARCH_GLOB.g_search_criteria.assignment_id);
1945: END IF;
1946:
1947: IF l_candidates_nom_in_cycle > 100 THEN
1948: