DBA Data[Home] [Help]

APPS.PA_SEARCH_PVT dependencies on PA_RESOURCE_UTILS

Line 1168: resource_organization_name = pa_resource_utils.get_organization_name(resource_organization_id),

1164: UPDATE pa_search_results_temp
1165: SET availability = l_availability_tbl(k),
1166: potential_availability = l_pot_availability_tbl(k),
1167: --resource_organization_name = pa_expenditures_utils.GetOrgTlName(resource_organization_id), 4778073
1168: resource_organization_name = pa_resource_utils.get_organization_name(resource_organization_id),
1169: candidate_score = PA_CANDIDATE_UTILS.Get_Candidate_Score(
1170: resource_id,
1171: l_person_id_tbl(k),
1172: p_search_criteria.assignment_id,

Line 1199: resource_organization_name = pa_resource_utils.get_organization_name(resource_organization_id),

1195: UPDATE pa_search_results_temp
1196: SET availability = l_availability_tbl(k),
1197: potential_availability = l_pot_availability_tbl(k),
1198: --resource_organization_name = pa_expenditures_utils.GetOrgTlName(resource_organization_id), 4778073
1199: resource_organization_name = pa_resource_utils.get_organization_name(resource_organization_id),
1200: candidate_score = PA_CANDIDATE_UTILS.Get_Candidate_Score(
1201: resource_id,
1202: l_person_id_tbl(k),
1203: p_search_criteria.assignment_id,

Line 1247: resource_organization_name = pa_resource_utils.get_organization_name(resource_organization_id),

1243: UPDATE pa_search_results_temp
1244: SET availability = 0,
1245: potential_availability = 0,
1246: --resource_organization_name = pa_expenditures_utils.GetOrgTlName(resource_organization_id), 4778073
1247: resource_organization_name = pa_resource_utils.get_organization_name(resource_organization_id),
1248: candidate_score = PA_CANDIDATE_UTILS.Get_Candidate_Score(
1249: resource_id,
1250: person_id,
1251: p_search_criteria.assignment_id,

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

1380: --for only requirements that passed the mandatory competence match if restrict to
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