[Home] [Help]
PACKAGE: APPS.PA_CANDIDATE_PUB
Source
1 PACKAGE PA_CANDIDATE_PUB AUTHID CURRENT_USER AS
2 -- $Header: PARCANPS.pls 120.3.12010000.4 2010/03/31 09:59:47 nisinha 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 -- Added for bug 8339510
39 -- start for bug#9468526 , Added default null values
40 p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
41 p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
42 p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
43 p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
44 p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
45 p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
46 p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
47 p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
48 p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
49 p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
50 p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
51 p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
52 p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
53 p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
54 p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
55 p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
56 -- start for bug#9468526 , Added default null values
57 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
58 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
59 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
60
61 PROCEDURE Update_No_Of_Active_Candidates(
62 p_assignment_id IN NUMBER,
63 p_old_system_status_code IN VARCHAR2,
64 p_new_system_status_code IN VARCHAR2,
65 x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
66
67
68 PROCEDURE Update_Remaining_Candidates
69 (p_assignment_id IN NUMBER,
70 p_resource_id IN NUMBER,
71 p_status_code IN VARCHAR2,
72 p_change_reason_code IN VARCHAR2,
73 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74 -- Added for bug 8339510
75 -- start for bug#9468526 , Added default null values
76 p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
77 p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
78 p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
79 p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
80 p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
81 p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
82 p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
83 p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
84 p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
85 p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
86 p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
87 p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
88 p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
89 p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
90 p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
91 p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
92 -- start for bug#9468526 , Added default null values
93 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
94 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
95 x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
96
97 PROCEDURE Add_Candidate_Log
98 (p_candidate_id IN NUMBER,
99 p_status_code IN VARCHAR2,
100 p_change_reason_code IN VARCHAR2,
101 p_review_comments IN VARCHAR2,
102 p_cand_record_version_number IN NUMBER,
103 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- Added for Bug 5130421: PJR Enhancements for Public APIs
104 x_cand_record_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
105 -- Added for bug 8339510
106 -- start for bug#9468526 , Added default null values
107 p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
108 p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
109 p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
110 p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
111 p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
112 p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
113 p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
114 p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
115 p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
116 p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
117 p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
118 p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
119 p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
120 p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
121 p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
122 p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
123 -- start for bug#9468526 , Added default null values
124 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
125 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
126 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
127
128 PROCEDURE Update_Candidate
129 (p_candidate_id IN NUMBER,
130 p_status_code IN VARCHAR2,
131 p_ranking IN NUMBER,
132 p_change_reason_code IN VARCHAR2,
133 p_record_version_number IN NUMBER,
134 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
135 p_validate_status IN VARCHAR2 := FND_API.G_TRUE,
136 -- Added for bug 8339510
137 -- start for bug#9468526 , Added default null values
138 p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
139 p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
140 p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
141 p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
142 p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
143 p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
144 p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
145 p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
146 p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
147 p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
148 p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
149 p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
150 p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
151 p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
152 p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
153 p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
154 -- start for bug#9468526 , Added default null values
155 x_record_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
156 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
157 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
158 x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
159
160 FUNCTION Is_Active_Candidate(p_system_status_code IN VARCHAR2)
161 RETURN VARCHAR2;
162
163
164 FUNCTION Get_Competence_Match
165 ( p_person_id IN NUMBER
166 , p_assignment_id IN NUMBER
167 )
168 RETURN VARCHAR2;
169
170 FUNCTION Check_Availability(p_resource_id IN NUMBER,
171 p_assignment_id IN NUMBER,
172 p_project_id IN NUMBER)
173 RETURN NUMBER;
174
175 PROCEDURE Check_Candidacy
176 (p_assignment_id IN NUMBER,
177 p_resource_count IN NUMBER,
178 p_resource_list IN VARCHAR2,
179 x_resource_list OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
180 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
181 x_invalid_candidates OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
182 x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
183
184 Procedure Start_Workflow(p_wf_item_type IN VARCHAR2,
185 p_wf_process IN VARCHAR2,
186 p_assignment_id IN NUMBER,
187 p_candidate_number IN NUMBER,
188 p_resource_id IN NUMBER,
189 p_status_name IN VARCHAR2,
190 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
191 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
192 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
193
194 PROCEDURE Delete_Candidates
195 (p_assignment_id IN NUMBER,
196 p_status_code IN VARCHAR2 DEFAULT NULL,
197 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
198 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
199 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
200
201 PROCEDURE Withdraw_Candidate
202 (p_candidate_id IN NUMBER,
203 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
204 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
205 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
206
207
208 PROCEDURE Copy_Candidates(p_old_requirement_id IN NUMBER,
209 p_new_requirement_id IN NUMBER,
210 p_new_start_date IN DATE,
211 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
212 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
213 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
214
215 PROCEDURE Decline_Candidates(p_assignment_id IN NUMBER,
216 p_launch_wf IN VARCHAR2 DEFAULT 'Y',
217 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
218 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
219 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
220
221 --Added for Bug 6144224
222 PROCEDURE Get_NF_Recipient (itemtype IN VARCHAR2
223 , itemkey IN VARCHAR2
224 , actid IN NUMBER
225 , funcmode IN VARCHAR2
226 , resultout OUT NOCOPY VARCHAR2 );
227
228 FUNCTION Get_Review_Change_Reason(p_candidate_id IN NUMBER)
229 RETURN VARCHAR2;
230
231 end PA_CANDIDATE_PUB ;