[Home] [Help]
PACKAGE: APPS.PA_CANDIDATE_PUB
Source
1 PACKAGE PA_CANDIDATE_PUB AS
2 -- $Header: PARCANPS.pls 120.3.12010000.2 2008/08/15 18:16:03 skkoppul ship $
3
4 G_ASSIGNMENT_ID NUMBER := 0;
5
6 FUNCTION Get_Number_Of_Candidates(p_project_status_code IN VARCHAR2)
7 RETURN NUMBER;
8
9 FUNCTION Get_Number_Of_Candidates(p_assignment_id IN NUMBER)
10 RETURN NUMBER;
11
12 FUNCTION Resource_Is_Candidate(p_resource_id IN NUMBER,
13 p_assignment_id IN NUMBER)
14 RETURN VARCHAR2;
15
16 FUNCTION Is_Cand_On_Another_Assignment
17 (p_resource_id IN NUMBER,
18 p_assignment_id IN NUMBER,
19 p_assignment_start_date IN DATE,
20 p_assignment_end_date IN DATE)
21 RETURN VARCHAR2;
22
23 FUNCTION Is_Cand_On_Assignment(p_resource_id IN NUMBER,
24 p_assignment_id IN NUMBER,
25 p_status_code IN VARCHAR2 DEFAULT NULL)
26 RETURN VARCHAR2;
27
28 PROCEDURE Add_Candidate
29 (p_assignment_id IN NUMBER,
30 p_resource_name IN VARCHAR2,
31 p_resource_id IN NUMBER DEFAULT NULL,
32 p_status_code IN VARCHAR2 DEFAULT NULL,
33 p_nomination_comments IN VARCHAR2,
34 p_person_id IN NUMBER DEFAULT NULL,
35 p_privilege_name IN VARCHAR2 DEFAULT NULL,
36 p_project_super_user IN VARCHAR2 DEFAULT 'N',
37 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- Added for Bug 5130421: PJR Enhancements for Public APIs
38 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
39 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
40 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
41
42 PROCEDURE Update_No_Of_Active_Candidates(
43 p_assignment_id IN NUMBER,
44 p_old_system_status_code IN VARCHAR2,
45 p_new_system_status_code IN VARCHAR2,
46 x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
47
48
49 PROCEDURE Update_Remaining_Candidates
50 (p_assignment_id IN NUMBER,
51 p_resource_id IN NUMBER,
52 p_status_code IN VARCHAR2,
53 p_change_reason_code IN VARCHAR2,
54 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
55 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
56 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
57 x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
58
59 PROCEDURE Add_Candidate_Log
60 (p_candidate_id IN NUMBER,
61 p_status_code IN VARCHAR2,
62 p_change_reason_code IN VARCHAR2,
63 p_review_comments IN VARCHAR2,
64 p_cand_record_version_number IN NUMBER,
65 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- Added for Bug 5130421: PJR Enhancements for Public APIs
66 x_cand_record_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
67 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
68 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
69 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
70
71 PROCEDURE Update_Candidate
72 (p_candidate_id IN NUMBER,
73 p_status_code IN VARCHAR2,
74 p_ranking IN NUMBER,
75 p_change_reason_code IN VARCHAR2,
76 p_record_version_number IN NUMBER,
77 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
78 p_validate_status IN VARCHAR2 := FND_API.G_TRUE,
79 x_record_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
80 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
81 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
82 x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
83
84 FUNCTION Is_Active_Candidate(p_system_status_code IN VARCHAR2)
85 RETURN VARCHAR2;
86
87
88 FUNCTION Get_Competence_Match
89 ( p_person_id IN NUMBER
90 , p_assignment_id IN NUMBER
91 )
92 RETURN VARCHAR2;
93
94 FUNCTION Check_Availability(p_resource_id IN NUMBER,
95 p_assignment_id IN NUMBER,
96 p_project_id IN NUMBER)
97 RETURN NUMBER;
98
99 PROCEDURE Check_Candidacy
100 (p_assignment_id IN NUMBER,
101 p_resource_count IN NUMBER,
102 p_resource_list IN VARCHAR2,
103 x_resource_list OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
104 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
105 x_invalid_candidates OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
106 x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
107
108 Procedure Start_Workflow(p_wf_item_type IN VARCHAR2,
109 p_wf_process IN VARCHAR2,
110 p_assignment_id IN NUMBER,
111 p_candidate_number IN NUMBER,
112 p_resource_id IN NUMBER,
113 p_status_name IN VARCHAR2,
114 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
115 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
116 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
117
118 PROCEDURE Delete_Candidates
119 (p_assignment_id IN NUMBER,
120 p_status_code IN VARCHAR2 DEFAULT NULL,
121 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
122 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
123 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
124
125 PROCEDURE Withdraw_Candidate
126 (p_candidate_id IN NUMBER,
127 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
128 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
129 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
130
131
132 PROCEDURE Copy_Candidates(p_old_requirement_id IN NUMBER,
133 p_new_requirement_id IN NUMBER,
134 p_new_start_date IN DATE,
135 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
136 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
137 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
138
139 PROCEDURE Decline_Candidates(p_assignment_id IN NUMBER,
140 p_launch_wf IN VARCHAR2 DEFAULT 'Y',
141 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
142 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
143 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
144
145 --Added for Bug 6144224
146 PROCEDURE Get_NF_Recipient (itemtype IN VARCHAR2
147 , itemkey IN VARCHAR2
148 , actid IN NUMBER
149 , funcmode IN VARCHAR2
150 , resultout OUT NOCOPY VARCHAR2 );
151
152 FUNCTION Get_Review_Change_Reason(p_candidate_id IN NUMBER)
153 RETURN VARCHAR2;
154
155 end PA_CANDIDATE_PUB ;