DBA Data[Home] [Help]

APPS.PA_CANDIDATE_UTILS dependencies on PA_CANDIDATE_PUB

Line 128: PA_DEBUG.init_err_stack('PA_CANDIDATE_PUB.Reverse_Candidate_Status');

124:
125: BEGIN
126:
127: -- Initialize the Error Stack
128: PA_DEBUG.init_err_stack('PA_CANDIDATE_PUB.Reverse_Candidate_Status');
129:
130: -- initialize return_status to success
131: x_return_status := FND_API.G_RET_STS_SUCCESS;
132: x_error_message_code := NULL;

Line 157: PA_CANDIDATE_PUB.Update_Candidate

153: WHERE project_system_status_code = 'CANDIDATE_PENDING_REVIEW'
154: AND PREDEFINED_FLAG = 'Y' -- Added for bug 5222893
155: AND status_type = 'CANDIDATE'; -- Bug 4773033 CANDIDATE ROUTINES JOIN FOR PROJECT STATUSES
156:
157: PA_CANDIDATE_PUB.Update_Candidate
158: (p_candidate_id => l_candidate_id,
159: p_status_code => l_project_status_code,
160: p_ranking => l_candidate_ranking,
161: p_change_reason_code => null,

Line 294: l_comp_match_count := PA_CANDIDATE_PUB.Get_Competence_Match(p_person_id,

290: --obtain competence match and count
291: IF p_competence_count IS NULL OR p_competence_match IS NULL THEN
292:
293: IF p_competence_match_count IS NULL THEN
294: l_comp_match_count := PA_CANDIDATE_PUB.Get_Competence_Match(p_person_id,
295: p_assignment_id);
296: ELSE
297: l_comp_match_count := p_competence_match_count;
298: END IF;

Line 314: l_availability := nvl(PA_CANDIDATE_PUB.Check_Availability(p_resource_id,

310: END IF;
311:
312: --obtain availability
313: IF p_availability IS NULL THEN
314: l_availability := nvl(PA_CANDIDATE_PUB.Check_Availability(p_resource_id,
315: p_assignment_id,
316: p_project_id),
317: 0);
318: