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 416: 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

412: --use this select statement if assignment id is part of the criteria. Do not need
413: --separate select statements based on whether or not country or role is part of the criteria in
414: --this case because the assignment_id unique index will be used to access the assignment
415: --record.
416: 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
417:
418: OPEN l_search_results FOR
419: SELECT asgn.assignment_id
420: , asgn.assignment_name

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

460: -- CASE 2: no assignment_id,
461: -- but role, staffing_priority_code, country are passed in
462: -- use this select statement for a requirement search if assignment id is not part
463: -- of the criteria and the country, staffing priority and role are part of the criteria.
464: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
465: AND (p_search_criteria.territory_code IS NOT NULL AND p_search_criteria.territory_code <> FND_API.G_MISS_CHAR)
466: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM)
467: AND (p_search_criteria.staffing_priority_code IS NOT NULL AND p_search_criteria.staffing_priority_code <> FND_API.G_MISS_CHAR) THEN
468:

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

461: -- but role, staffing_priority_code, country are passed in
462: -- use this select statement for a requirement search if assignment id is not part
463: -- of the criteria and the country, staffing priority and role are part of the criteria.
464: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
465: AND (p_search_criteria.territory_code IS NOT NULL AND p_search_criteria.territory_code <> FND_API.G_MISS_CHAR)
466: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM)
467: AND (p_search_criteria.staffing_priority_code IS NOT NULL AND p_search_criteria.staffing_priority_code <> FND_API.G_MISS_CHAR) THEN
468:
469: OPEN l_search_results FOR

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

462: -- use this select statement for a requirement search if assignment id is not part
463: -- of the criteria and the country, staffing priority and role are part of the criteria.
464: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
465: AND (p_search_criteria.territory_code IS NOT NULL AND p_search_criteria.territory_code <> FND_API.G_MISS_CHAR)
466: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM)
467: AND (p_search_criteria.staffing_priority_code IS NOT NULL AND p_search_criteria.staffing_priority_code <> FND_API.G_MISS_CHAR) THEN
468:
469: OPEN l_search_results FOR
470: SELECT asgn.assignment_id

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

463: -- of the criteria and the country, staffing priority and role are part of the criteria.
464: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
465: AND (p_search_criteria.territory_code IS NOT NULL AND p_search_criteria.territory_code <> FND_API.G_MISS_CHAR)
466: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM)
467: AND (p_search_criteria.staffing_priority_code IS NOT NULL AND p_search_criteria.staffing_priority_code <> FND_API.G_MISS_CHAR) THEN
468:
469: OPEN l_search_results FOR
470: SELECT asgn.assignment_id
471: , asgn.assignment_name

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

511: -- but role, staffing_priority_code are passed in
512: -- use this select statement for a requirement search if assignment id
513: -- and country are not part of the criteria, but role and staffing priority
514: -- are part of the criteria.
515: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
516: AND (p_search_criteria.territory_code IS NULL OR p_search_criteria.territory_code = FND_API.G_MISS_CHAR)
517: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM)
518: AND (p_search_criteria.staffing_priority_code IS NOT NULL AND p_search_criteria.staffing_priority_code <> FND_API.G_MISS_CHAR) THEN
519:

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

512: -- use this select statement for a requirement search if assignment id
513: -- and country are not part of the criteria, but role and staffing priority
514: -- are part of the criteria.
515: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
516: AND (p_search_criteria.territory_code IS NULL OR p_search_criteria.territory_code = FND_API.G_MISS_CHAR)
517: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM)
518: AND (p_search_criteria.staffing_priority_code IS NOT NULL AND p_search_criteria.staffing_priority_code <> FND_API.G_MISS_CHAR) THEN
519:
520: OPEN l_search_results FOR

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

513: -- and country are not part of the criteria, but role and staffing priority
514: -- are part of the criteria.
515: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
516: AND (p_search_criteria.territory_code IS NULL OR p_search_criteria.territory_code = FND_API.G_MISS_CHAR)
517: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM)
518: AND (p_search_criteria.staffing_priority_code IS NOT NULL AND p_search_criteria.staffing_priority_code <> FND_API.G_MISS_CHAR) THEN
519:
520: OPEN l_search_results FOR
521: SELECT asgn.assignment_id

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

514: -- are part of the criteria.
515: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
516: AND (p_search_criteria.territory_code IS NULL OR p_search_criteria.territory_code = FND_API.G_MISS_CHAR)
517: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM)
518: AND (p_search_criteria.staffing_priority_code IS NOT NULL AND p_search_criteria.staffing_priority_code <> FND_API.G_MISS_CHAR) THEN
519:
520: OPEN l_search_results FOR
521: SELECT asgn.assignment_id
522: , asgn.assignment_name

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

562: -- but role is passed in
563: -- use this select statement for a requirement search if assignment id
564: -- and staffing priority are not part of the criteria,
565: -- but role is part of the criteria.
566: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
567: AND (p_search_criteria.staffing_priority_code IS NULL OR p_search_criteria.staffing_priority_code = FND_API.G_MISS_CHAR)
568: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM) THEN
569:
570: OPEN l_search_results FOR

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

563: -- use this select statement for a requirement search if assignment id
564: -- and staffing priority are not part of the criteria,
565: -- but role is part of the criteria.
566: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
567: AND (p_search_criteria.staffing_priority_code IS NULL OR p_search_criteria.staffing_priority_code = FND_API.G_MISS_CHAR)
568: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM) THEN
569:
570: OPEN l_search_results FOR
571: SELECT asgn.assignment_id

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

564: -- and staffing priority are not part of the criteria,
565: -- but role is part of the criteria.
566: ELSIF p_search_mode = 'REQUIREMENT' AND (p_search_criteria.assignment_id IS NULL OR p_search_criteria.assignment_id = FND_API.G_MISS_NUM)
567: AND (p_search_criteria.staffing_priority_code IS NULL OR p_search_criteria.staffing_priority_code = FND_API.G_MISS_CHAR)
568: AND (p_search_criteria.role_id IS NOT NULL AND p_search_criteria.role_id <> FND_API.G_MISS_NUM) THEN
569:
570: OPEN l_search_results FOR
571: SELECT asgn.assignment_id
572: , asgn.assignment_name

Line 613: 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

609:
610: -- CASE 5: no assignment_id, no role
611: -- use this select statement for a requirement search if assignment_id and
612: -- role are not part of the criteria.
613: 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
614:
615: OPEN l_search_results FOR
616: SELECT asgn.assignment_id
617: , asgn.assignment_name

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

1331: --resource's competencies is true, or for all requirements if restrict to resource's
1332: --competencies is false.
1333: UPDATE pa_search_results_temp
1334: 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))
1335: WHERE ((mandatory_competence_count=mandatory_competence_match AND p_search_criteria.restrict_res_comp = FND_API.G_TRUE)
1336: OR p_search_criteria.restrict_res_comp = FND_API.G_FALSE);
1337:
1338: END IF; --l_assignment_id_tbl.COUNT > 0
1339:

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

1332: --competencies is false.
1333: UPDATE pa_search_results_temp
1334: 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))
1335: WHERE ((mandatory_competence_count=mandatory_competence_match AND p_search_criteria.restrict_res_comp = FND_API.G_TRUE)
1336: OR p_search_criteria.restrict_res_comp = FND_API.G_FALSE);
1337:
1338: END IF; --l_assignment_id_tbl.COUNT > 0
1339:
1340: END IF; -- search mode check

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

1342:
1343: EXCEPTION
1344:
1345: WHEN OTHERS THEN
1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ; -- 4537865
1347: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_SEARCH_PVT.Run_Search'
1348: , p_procedure_name => PA_DEBUG.G_Err_Stack);
1349: RAISE;
1350:

Line 1672: p_commit => FND_API.G_TRUE,

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

Line 1673: p_validate_only => FND_API.G_FALSE,

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