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 FND_API

Line 424: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NOT NULL AND p_search_criteria.assignment_id <> FND_API.G_MISS_NUM) THEN

420: --use this select statement if assignment id is part of the criteria. Do not need
421: --separate select statements based on whether or not country or role is part of the criteria in
422: --this case because the assignment_id unique index will be used to access the assignment
423: --record.
424: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NOT NULL AND p_search_criteria.assignment_id <> FND_API.G_MISS_NUM) THEN
425:
426: OPEN l_search_results FOR
427: SELECT asgn.assignment_id
428: , asgn.assignment_name

Line 472: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)

468: -- CASE 2: no assignment_id,
469: -- but role, staffing_priority_code, country are passed in
470: -- use this select statement for a requirement search if assignment id is not part
471: -- of the criteria and the country, staffing priority and role are part of the criteria.
472: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
473: AND (p_search_criteria.territory_code IS NOT NULL AND p_search_criteria.territory_code <> FND_API.G_MISS_CHAR)
474: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM)
475: AND (p_search_criteria.staffing_priority_code IS NOT NULL AND p_search_criteria.staffing_priority_code <> FND_API.G_MISS_CHAR) THEN
476:

Line 473: AND (p_search_criteria.territory_code IS NOT NULL AND p_search_criteria.territory_code <> FND_API.G_MISS_CHAR)

469: -- but role, staffing_priority_code, country are passed in
470: -- use this select statement for a requirement search if assignment id is not part
471: -- of the criteria and the country, staffing priority and role are part of the criteria.
472: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
473: AND (p_search_criteria.territory_code IS NOT NULL AND p_search_criteria.territory_code <> FND_API.G_MISS_CHAR)
474: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM)
475: AND (p_search_criteria.staffing_priority_code IS NOT NULL AND p_search_criteria.staffing_priority_code <> FND_API.G_MISS_CHAR) THEN
476:
477: OPEN l_search_results FOR

Line 474: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM)

470: -- use this select statement for a requirement search if assignment id is not part
471: -- of the criteria and the country, staffing priority and role are part of the criteria.
472: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
473: AND (p_search_criteria.territory_code IS NOT NULL AND p_search_criteria.territory_code <> FND_API.G_MISS_CHAR)
474: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM)
475: AND (p_search_criteria.staffing_priority_code IS NOT NULL AND p_search_criteria.staffing_priority_code <> FND_API.G_MISS_CHAR) THEN
476:
477: OPEN l_search_results FOR
478: SELECT asgn.assignment_id

Line 475: AND (p_search_criteria.staffing_priority_code IS NOT NULL AND p_search_criteria.staffing_priority_code <> FND_API.G_MISS_CHAR) THEN

471: -- of the criteria and the country, staffing priority and role are part of the criteria.
472: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
473: AND (p_search_criteria.territory_code IS NOT NULL AND p_search_criteria.territory_code <> FND_API.G_MISS_CHAR)
474: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM)
475: AND (p_search_criteria.staffing_priority_code IS NOT NULL AND p_search_criteria.staffing_priority_code <> FND_API.G_MISS_CHAR) THEN
476:
477: OPEN l_search_results FOR
478: SELECT asgn.assignment_id
479: , asgn.assignment_name

Line 523: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)

519: -- but role, staffing_priority_code are passed in
520: -- use this select statement for a requirement search if assignment id
521: -- and country are not part of the criteria, but role and staffing priority
522: -- are part of the criteria.
523: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
524: AND (p_search_criteria.territory_code IS NULL OR p_search_criteria.territory_code = FND_API.G_MISS_CHAR)
525: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM)
526: AND (p_search_criteria.staffing_priority_code IS NOT NULL AND p_search_criteria.staffing_priority_code <> FND_API.G_MISS_CHAR) THEN
527:

Line 524: AND (p_search_criteria.territory_code IS NULL OR p_search_criteria.territory_code = FND_API.G_MISS_CHAR)

520: -- use this select statement for a requirement search if assignment id
521: -- and country are not part of the criteria, but role and staffing priority
522: -- are part of the criteria.
523: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
524: AND (p_search_criteria.territory_code IS NULL OR p_search_criteria.territory_code = FND_API.G_MISS_CHAR)
525: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM)
526: AND (p_search_criteria.staffing_priority_code IS NOT NULL AND p_search_criteria.staffing_priority_code <> FND_API.G_MISS_CHAR) THEN
527:
528: OPEN l_search_results FOR

Line 525: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM)

521: -- and country are not part of the criteria, but role and staffing priority
522: -- are part of the criteria.
523: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
524: AND (p_search_criteria.territory_code IS NULL OR p_search_criteria.territory_code = FND_API.G_MISS_CHAR)
525: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM)
526: AND (p_search_criteria.staffing_priority_code IS NOT NULL AND p_search_criteria.staffing_priority_code <> FND_API.G_MISS_CHAR) THEN
527:
528: OPEN l_search_results FOR
529: SELECT asgn.assignment_id

Line 526: AND (p_search_criteria.staffing_priority_code IS NOT NULL AND p_search_criteria.staffing_priority_code <> FND_API.G_MISS_CHAR) THEN

522: -- are part of the criteria.
523: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
524: AND (p_search_criteria.territory_code IS NULL OR p_search_criteria.territory_code = FND_API.G_MISS_CHAR)
525: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM)
526: AND (p_search_criteria.staffing_priority_code IS NOT NULL AND p_search_criteria.staffing_priority_code <> FND_API.G_MISS_CHAR) THEN
527:
528: OPEN l_search_results FOR
529: SELECT asgn.assignment_id
530: , asgn.assignment_name

Line 574: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)

570: -- but role is passed in
571: -- use this select statement for a requirement search if assignment id
572: -- and staffing priority are not part of the criteria,
573: -- but role is part of the criteria.
574: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
575: AND (p_search_criteria.staffing_priority_code IS NULL OR p_search_criteria.staffing_priority_code = FND_API.G_MISS_CHAR)
576: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM) THEN
577:
578: OPEN l_search_results FOR

Line 575: AND (p_search_criteria.staffing_priority_code IS NULL OR p_search_criteria.staffing_priority_code = FND_API.G_MISS_CHAR)

571: -- use this select statement for a requirement search if assignment id
572: -- and staffing priority are not part of the criteria,
573: -- but role is part of the criteria.
574: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
575: AND (p_search_criteria.staffing_priority_code IS NULL OR p_search_criteria.staffing_priority_code = FND_API.G_MISS_CHAR)
576: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM) THEN
577:
578: OPEN l_search_results FOR
579: SELECT asgn.assignment_id

Line 576: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM) THEN

572: -- and staffing priority are not part of the criteria,
573: -- but role is part of the criteria.
574: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
575: AND (p_search_criteria.staffing_priority_code IS NULL OR p_search_criteria.staffing_priority_code = FND_API.G_MISS_CHAR)
576: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM) THEN
577:
578: OPEN l_search_results FOR
579: SELECT asgn.assignment_id
580: , asgn.assignment_name

Line 621: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM) AND (p_search_criteria.role_id IS NULL OR p_search_criteria.role_id = FND_API.G_MISS_NUM) THEN

617:
618: -- CASE 5: no assignment_id, no role
619: -- use this select statement for a requirement search if assignment_id and
620: -- role are not part of the criteria.
621: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM) AND (p_search_criteria.role_id IS NULL OR p_search_criteria.role_id = FND_API.G_MISS_NUM) THEN
622:
623: OPEN l_search_results FOR
624: SELECT asgn.assignment_id
625: , asgn.assignment_name

Line 1385: WHERE ((mandatory_competence_count=mandatory_competence_match AND p_search_criteria.restrict_res_comp = FND_API.G_TRUE)

1381: --resource's competencies is true, or for all requirements if restrict to resource's
1382: --competencies is false.
1383: UPDATE pa_search_results_temp
1384: SET candidate_in_req_flag = decode(p_search_criteria.resource_source_id, NULL, NULL,PA_CANDIDATE_UTILS.Check_Resource_Is_Candidate(PA_RESOURCE_UTILS.Get_Resource_Id(p_search_criteria.resource_source_id), assignment_id))
1385: WHERE ((mandatory_competence_count=mandatory_competence_match AND p_search_criteria.restrict_res_comp = FND_API.G_TRUE)
1386: OR p_search_criteria.restrict_res_comp = FND_API.G_FALSE);
1387:
1388: END IF; --l_assignment_id_tbl.COUNT > 0
1389:

Line 1386: OR p_search_criteria.restrict_res_comp = FND_API.G_FALSE);

1382: --competencies is false.
1383: UPDATE pa_search_results_temp
1384: SET candidate_in_req_flag = decode(p_search_criteria.resource_source_id, NULL, NULL,PA_CANDIDATE_UTILS.Check_Resource_Is_Candidate(PA_RESOURCE_UTILS.Get_Resource_Id(p_search_criteria.resource_source_id), assignment_id))
1385: WHERE ((mandatory_competence_count=mandatory_competence_match AND p_search_criteria.restrict_res_comp = FND_API.G_TRUE)
1386: OR p_search_criteria.restrict_res_comp = FND_API.G_FALSE);
1387:
1388: END IF; --l_assignment_id_tbl.COUNT > 0
1389:
1390: END IF; -- search mode check

Line 1396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ; -- 4537865

1392:
1393: EXCEPTION
1394:
1395: WHEN OTHERS THEN
1396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ; -- 4537865
1397: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_SEARCH_PVT.Run_Search'
1398: , p_procedure_name => PA_DEBUG.G_Err_Stack);
1399: RAISE;
1400:

Line 1723: p_commit => FND_API.G_TRUE,

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:
1727: IF p_debug_mode = 'Y' THEN

Line 1724: p_validate_only => FND_API.G_FALSE,

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:
1727: IF p_debug_mode = 'Y' THEN
1728: fnd_file.put_line(FND_FILE.LOG,'done with run_search API');