[Home] [Help]
1143: UPDATE pa_search_results_temp
1144: SET availability = l_availability_tbl(k),
1145: potential_availability = l_pot_availability_tbl(k),
1146: --resource_organization_name = pa_expenditures_utils.GetOrgTlName(resource_organization_id), 4778073
1147: resource_organization_name = pa_resource_utils.get_organization_name(resource_organization_id),
1148: candidate_score = PA_CANDIDATE_UTILS.Get_Candidate_Score(
1149: resource_id,
1150: l_person_id_tbl(k),
1151: p_search_criteria.assignment_id,
1191: UPDATE pa_search_results_temp
1192: SET availability = 0,
1193: potential_availability = 0,
1194: --resource_organization_name = pa_expenditures_utils.GetOrgTlName(resource_organization_id), 4778073
1195: resource_organization_name = pa_resource_utils.get_organization_name(resource_organization_id),
1196: candidate_score = PA_CANDIDATE_UTILS.Get_Candidate_Score(
1197: resource_id,
1198: person_id,
1199: p_search_criteria.assignment_id,
1330: --for only requirements that passed the mandatory competence match if restrict to
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