1 PACKAGE PA_CANDIDATE_UTILS AS
2 -- $Header: PARCANUS.pls 120.1 2005/08/19 16:49:19 mwasowic noship $
3
4 TYPE requirements_tbl IS TABLE OF NUMBER index by binary_integer;
5
6 FUNCTION Get_Active_Candidates_Number(p_assignment_id IN NUMBER)
7 RETURN NUMBER;
8
9 FUNCTION Get_Requirements_Of_Candidate (p_resource_id IN NUMBER)
10 RETURN requirements_tbl;
11
12 FUNCTION Get_Resource_Id(p_person_id IN NUMBER)
13 RETURN NUMBER;
14
15 FUNCTION Check_Resource_Is_Candidate(p_resource_id IN NUMBER,
16 p_assignment_id IN NUMBER)
17 RETURN VARCHAR2;
18
19 PROCEDURE Reverse_Candidate_Status
20 (p_assignment_id IN NUMBER,
21 p_resource_id IN NUMBER,
22 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
23 x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
24
25 FUNCTION Get_Candidate_Score(p_resource_id IN NUMBER,
26 p_person_id IN NUMBER,
27 p_assignment_id IN NUMBER,
28 p_project_id IN NUMBER,
29 p_competence_match_count IN VARCHAR2,
30 p_competence_match IN NUMBER,
31 p_competence_count IN NUMBER,
32 p_availability IN NUMBER,
33 p_resource_job_level IN NUMBER,
34 p_min_job_level IN NUMBER,
35 p_max_job_level IN NUMBER,
36 p_comp_match_weighting IN NUMBER,
37 p_avail_match_weighting IN NUMBER,
38 p_job_level_match_weighting IN NUMBER)
39 RETURN NUMBER;
40
41 FUNCTION Get_Nominator_Name(p_nominated_by_person_id IN NUMBER)
42 RETURN VARCHAR2;
43
44 FUNCTION Get_Candidate_Nominations (p_resource_id IN NUMBER)
45 RETURN NUMBER;
46
47 FUNCTION Get_Candidate_Qualifieds (p_resource_id IN NUMBER)
48 RETURN NUMBER;
49
50 PROCEDURE Update_No_Of_Active_Candidates
51 (p_assignment_id IN NUMBER,
52 x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
53
54 end PA_CANDIDATE_UTILS ;