1 Package PER_VACANCY_API AUTHID CURRENT_USER as
2 /* $Header: pevacapi.pkh 120.2 2010/12/24 11:47:10 avarri ship $ */
3 /*#
4 * This package contains HR Vacancy APIs.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Vacancy
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------------< create_vacancy >--------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a vacancy.
17 *
18 * Use this API to create a new vacancy and record details such as the
19 * organization, job, recruiter, and budget values.
20 *
21 * <p><b>Licensing</b><br>
22 * This API is licensed for use with Human Resources and iRecruitment.
23 *
24 * <p><b>Prerequisites</b><br>
25 * The requisition that this vacancy will belong to must already have been
26 * created.
27 *
28 * <p><b>Post Success</b><br>
29 * The vacancy will have been created.
30 *
31 * <p><b>Post Failure</b><br>
32 * The vacancy will not be created and an error will be raised.
33 * @param p_validate If true, then validation alone will be performed and the
34 * database will remain unchanged. If false and all validation checks pass,
35 * then the database will be modified.
36 * @param p_effective_date Reference date for validating lookup values are
37 * applicable during the start to end active date range. This date does not
38 * determine when the changes take effect.
39 * @param p_requisition_id Uniquely identifies the requisition associated with
40 * this vacancy.
41 * @param p_date_from Start date of the vacancy.
42 * @param p_name The name of the vacancy.
43 * @param p_security_method The security method of the vacancy. Valid values
44 * are defined by the 'IRC_SECURITY_METHOD' lookup type.
45 * @param p_business_group_id Uniquely identifies the business group under
46 * which the vacancy is created.
47 * @param p_position_id Uniquely identifies the position that this vacancy will
48 * fill.
49 * @param p_job_id Uniquely identifies the job that this vacancy will fill.
50 * @param p_grade_id Uniquely identifies the grade of the position.
51 * @param p_organization_id Uniquely identifies the organization of the
52 * position.
53 * @param p_people_group_id Uniquely identifies the people group of the
54 * position.
55 * @param p_location_id Uniquely identifies the location of the position.
56 * @param p_recruiter_id Uniquely identifies the person who is recruiting for
57 * this position.
58 * @param p_date_to End date of the vacancy.
59 * @param p_description Description of the vacancy.
60 * @param p_number_of_openings Number of openings available for this vacancy.
61 * @param p_status Status of the vacancy. Valid values are defined by the
62 * 'VACANCY_STATUS' lookup type.
63 * @param p_budget_measurement_type Budget measurement unit of measure. Valid
64 * values are defined by the 'BUDGET_MEASUREMENT_TYPE' lookup.
65 * @param p_budget_measurement_value Budget measurement value.
66 * @param p_vacancy_category Category of the vacancy. Valid values are defined
67 * by the 'VACANCY_CATEGORY' lookup type.
68 * @param p_manager_id Uniquely identifies the person who is the manager of the
69 * position.
70 * @param p_attribute_category This context value determines which flexfield
71 * structure to use with the descriptive flexfield segments.
72 * @param p_attribute1 Descriptive flexfield segment.
73 * @param p_attribute2 Descriptive flexfield segment.
74 * @param p_attribute3 Descriptive flexfield segment.
75 * @param p_attribute4 Descriptive flexfield segment.
76 * @param p_attribute5 Descriptive flexfield segment.
77 * @param p_attribute6 Descriptive flexfield segment.
78 * @param p_attribute7 Descriptive flexfield segment.
79 * @param p_attribute8 Descriptive flexfield segment.
80 * @param p_attribute9 Descriptive flexfield segment.
84 * @param p_attribute13 Descriptive flexfield segment.
81 * @param p_attribute10 Descriptive flexfield segment.
82 * @param p_attribute11 Descriptive flexfield segment.
83 * @param p_attribute12 Descriptive flexfield segment.
85 * @param p_attribute14 Descriptive flexfield segment.
86 * @param p_attribute15 Descriptive flexfield segment.
87 * @param p_attribute16 Descriptive flexfield segment.
88 * @param p_attribute17 Descriptive flexfield segment.
89 * @param p_attribute18 Descriptive flexfield segment.
90 * @param p_attribute19 Descriptive flexfield segment.
91 * @param p_attribute20 Descriptive flexfield segment.
92 * @param p_attribute21 Descriptive flexfield segment.
93 * @param p_attribute22 Descriptive flexfield segment.
94 * @param p_attribute23 Descriptive flexfield segment.
95 * @param p_attribute24 Descriptive flexfield segment.
96 * @param p_attribute25 Descriptive flexfield segment.
97 * @param p_attribute26 Descriptive flexfield segment.
98 * @param p_attribute27 Descriptive flexfield segment.
99 * @param p_attribute28 Descriptive flexfield segment.
100 * @param p_attribute29 Descriptive flexfield segment.
101 * @param p_attribute30 Descriptive flexfield segment.
102 * @param p_vacancy_region_type Indicates the vacancy region region type.
103 * @param p_object_version_number If p_validate is false, then set to the
104 * version number of the created vacancy. If p_validate is true, then the value
105 * will be null.
106 * @param p_vacancy_id If p_validate is false, then this uniquely identifies
107 * the vacancy created. If p_validate is true, then this is set to null.
108 * @param p_inv_pos_grade_warning If set to true, this serves as a warning that
109 * the position is not valid for the grade.
110 * @param p_inv_job_grade_warning If set to true, this serves as a warning that
111 * the job is not valid for the grade.
112 * @param p_assessment_id New parameter, available on the latest version of
113 * this API.
114 * @param p_primary_posting_id New parameter, available on the latest version
115 * of this API.
116 * @rep:displayname Create Vacancy
117 * @rep:category BUSINESS_ENTITY PER_VACANCY
118 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
119 * @rep:scope public
120 * @rep:lifecycle active
121 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
122 */
123 --
124 -- {End Of Comments}
125 --
126 procedure create_vacancy
127 (
128 P_VALIDATE in boolean default false
129 , P_EFFECTIVE_DATE in date default null
130 , P_REQUISITION_ID in number
131 , P_DATE_FROM in date
132 , P_NAME in varchar2
133 , P_SECURITY_METHOD in varchar2 default 'B'
134 , P_BUSINESS_GROUP_ID in number
135 , P_POSITION_ID in number default null
136 , P_JOB_ID in number default null
137 , P_GRADE_ID in number default null
138 , P_ORGANIZATION_ID in number default null
139 , P_PEOPLE_GROUP_ID in number default null
140 , P_LOCATION_ID in number default null
141 , P_RECRUITER_ID in number default null
142 , P_DATE_TO in date default null
143 , P_DESCRIPTION in varchar2 default null
144 , P_NUMBER_OF_OPENINGS in number default null
145 , P_STATUS in varchar2 default null
146 , P_BUDGET_MEASUREMENT_TYPE in varchar2 default null
147 , P_BUDGET_MEASUREMENT_VALUE in number default null
148 , P_VACANCY_CATEGORY in varchar2 default null
149 , P_MANAGER_ID in number default null
150 , P_PRIMARY_POSTING_ID in number default null
151 , P_ASSESSMENT_ID in number default null
152 , P_ATTRIBUTE_CATEGORY in varchar2 default null
153 , P_ATTRIBUTE1 in varchar2 default null
154 , P_ATTRIBUTE2 in varchar2 default null
155 , P_ATTRIBUTE3 in varchar2 default null
156 , P_ATTRIBUTE4 in varchar2 default null
157 , P_ATTRIBUTE5 in varchar2 default null
158 , P_ATTRIBUTE6 in varchar2 default null
159 , P_ATTRIBUTE7 in varchar2 default null
160 , P_ATTRIBUTE8 in varchar2 default null
161 , P_ATTRIBUTE9 in varchar2 default null
162 , P_ATTRIBUTE10 in varchar2 default null
163 , P_ATTRIBUTE11 in varchar2 default null
164 , P_ATTRIBUTE12 in varchar2 default null
165 , P_ATTRIBUTE13 in varchar2 default null
166 , P_ATTRIBUTE14 in varchar2 default null
167 , P_ATTRIBUTE15 in varchar2 default null
168 , P_ATTRIBUTE16 in varchar2 default null
169 , P_ATTRIBUTE17 in varchar2 default null
170 , P_ATTRIBUTE18 in varchar2 default null
171 , P_ATTRIBUTE19 in varchar2 default null
172 , P_ATTRIBUTE20 in varchar2 default null
173 , P_ATTRIBUTE21 in varchar2 default null
174 , P_ATTRIBUTE22 in varchar2 default null
175 , P_ATTRIBUTE23 in varchar2 default null
176 , P_ATTRIBUTE24 in varchar2 default null
177 , P_ATTRIBUTE25 in varchar2 default null
178 , P_ATTRIBUTE26 in varchar2 default null
179 , P_ATTRIBUTE27 in varchar2 default null
180 , P_ATTRIBUTE28 in varchar2 default null
181 , P_ATTRIBUTE29 in varchar2 default null
182 , P_ATTRIBUTE30 in varchar2 default null
183 , P_VACANCY_REGION_TYPE in varchar2 default null
184 , P_OBJECT_VERSION_NUMBER out nocopy number
185 , P_VACANCY_ID out nocopy number
189 --
186 , p_inv_pos_grade_warning out nocopy boolean
187 , p_inv_job_grade_warning out nocopy boolean
188 );
190 -- ----------------------------------------------------------------------------
191 -- |------------------------------< update_vacancy >--------------------------|
192 -- ----------------------------------------------------------------------------
193 --
194 -- {Start Of Comments}
195 /*#
196 * This API updates a vacancy.
197 *
198 * Use this API to update a vacancy and update details such as the
199 * organization, job, recruiter and budget values.
200 *
201 * <p><b>Licensing</b><br>
202 * This API is licensed for use with Human Resources and iRecruitment.
203 *
204 * <p><b>Prerequisites</b><br>
205 * The vacancy must have already been created.
206 *
207 * <p><b>Post Success</b><br>
208 * The vacancy will have been updated.
209 *
210 * <p><b>Post Failure</b><br>
211 * The vacancy will not be updated and an error will be raised.
212 * @param p_validate If true, then validation alone will be performed and the
213 * database will remain unchanged. If false and all validation checks pass,
214 * then the database will be modified.
215 * @param p_effective_date Reference date for validating lookup values are
216 * applicable during the start to end active date range. This date does not
217 * determine when the changes take effect.
218 * @param p_vacancy_id Uniquely identifies the vacancy being updated.
219 * @param p_object_version_number Pass in the current version number of the
220 * vacancy to be updated. When the API completes if p_validate is false, will
221 * be set to the new version number of the updated vacancy. If p_validate is
222 * true will be set to the same value which was passed in.
223 * @param p_date_from Start date of the vacancy.
224 * @param p_position_id Uniquely identifies the position that this vacancy will
225 * fill.
226 * @param p_job_id Uniquely identifies the job that this vacancy will fill.
227 * @param p_grade_id Uniquely identifies the grade of the position.
228 * @param p_organization_id Uniquely identifies the organization of the
229 * position.
230 * @param p_people_group_id Uniquely identifies the people group of the
231 * position.
232 * @param p_location_id Uniquely identifies the location of the position.
233 * @param p_recruiter_id Uniquely identifies the person who is recruiting for
234 * this position.
235 * @param p_date_to End date of the vacancy.
236 * @param p_security_method The security method of the vacancy. Valid values
237 * are defined by the 'IRC_SECURITY_METHOD' lookup type.
238 * @param p_description Description of the vacancy.
239 * @param p_number_of_openings Number of openings available for this vacancy.
240 * @param p_status Status of the vacancy. Valid values are defined by the
241 * 'VACANCY_STATUS' lookup type.
242 * @param p_budget_measurement_type Budget measurement unit of measure. Valid
243 * values are defined by the 'BUDGET_MEASUREMENT_TYPE' lookup.
244 * @param p_budget_measurement_value Budget measurement value.
245 * @param p_vacancy_category Category of the vacancy. Valid values are defined
246 * by the 'VACANCY_CATEGORY' lookup type.
247 * @param p_manager_id Uniquely identifies the person who is the manager of the
248 * position.
249 * @param p_attribute_category This context value determines which flexfield
250 * structure to use with the descriptive flexfield segments.
251 * @param p_attribute1 Descriptive flexfield segment.
252 * @param p_attribute2 Descriptive flexfield segment.
253 * @param p_attribute3 Descriptive flexfield segment.
254 * @param p_attribute4 Descriptive flexfield segment.
255 * @param p_attribute5 Descriptive flexfield segment.
256 * @param p_attribute6 Descriptive flexfield segment.
257 * @param p_attribute7 Descriptive flexfield segment.
258 * @param p_attribute8 Descriptive flexfield segment.
259 * @param p_attribute9 Descriptive flexfield segment.
260 * @param p_attribute10 Descriptive flexfield segment.
261 * @param p_attribute11 Descriptive flexfield segment.
262 * @param p_attribute12 Descriptive flexfield segment.
263 * @param p_attribute13 Descriptive flexfield segment.
264 * @param p_attribute14 Descriptive flexfield segment.
265 * @param p_attribute15 Descriptive flexfield segment.
266 * @param p_attribute16 Descriptive flexfield segment.
267 * @param p_attribute17 Descriptive flexfield segment.
268 * @param p_attribute18 Descriptive flexfield segment.
269 * @param p_attribute19 Descriptive flexfield segment.
270 * @param p_attribute20 Descriptive flexfield segment.
271 * @param p_attribute21 Descriptive flexfield segment.
272 * @param p_attribute22 Descriptive flexfield segment.
273 * @param p_attribute23 Descriptive flexfield segment.
274 * @param p_attribute24 Descriptive flexfield segment.
275 * @param p_attribute25 Descriptive flexfield segment.
276 * @param p_attribute26 Descriptive flexfield segment.
277 * @param p_attribute27 Descriptive flexfield segment.
278 * @param p_attribute28 Descriptive flexfield segment.
279 * @param p_attribute29 Descriptive flexfield segment.
280 * @param p_attribute30 Descriptive flexfield segment.
281 * @param p_assignment_changed If set to true, this serves as a warning that
282 * the process has changed assignments to reflect the new vacancy criteria.
283 * @param p_inv_pos_grade_warning If set to true, this serves as a warning that
284 * the position is not valid for the grade.
285 * @param p_inv_job_grade_warning If set to true, this serves as a warning that
286 * the job is not valid for the grade.
287 * @param p_assessment_id New parameter, available on the latest version of
288 * this API.
289 * @param p_primary_posting_id New parameter, available on the latest version
290 * of this API.
291 * @rep:displayname Update Vacancy
292 * @rep:category BUSINESS_ENTITY PER_VACANCY
296 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
293 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
294 * @rep:scope public
295 * @rep:lifecycle active
297 */
298 --
299 -- {End Of Comments}
300 --
301 procedure update_vacancy
302 (
303 P_VALIDATE in boolean default false
304 , P_EFFECTIVE_DATE in date default null
305 , P_VACANCY_ID in number
306 , P_OBJECT_VERSION_NUMBER in out nocopy number
307 , P_DATE_FROM in date default hr_api.g_date
308 , P_POSITION_ID in number default hr_api.g_number
309 , P_JOB_ID in number default hr_api.g_number
310 , P_GRADE_ID in number default hr_api.g_number
311 , P_ORGANIZATION_ID in number default hr_api.g_number
312 , P_PEOPLE_GROUP_ID in number default hr_api.g_number
313 , P_LOCATION_ID in number default hr_api.g_number
314 , P_RECRUITER_ID in number default hr_api.g_number
315 , P_DATE_TO in date default hr_api.g_date
316 , P_SECURITY_METHOD in varchar2 default hr_api.g_varchar2
317 , P_DESCRIPTION in varchar2 default hr_api.g_varchar2
318 , P_NUMBER_OF_OPENINGS in number default hr_api.g_number
319 , P_STATUS in varchar2 default hr_api.g_varchar2
320 , P_BUDGET_MEASUREMENT_TYPE in varchar2 default hr_api.g_varchar2
321 , P_BUDGET_MEASUREMENT_VALUE in number default hr_api.g_number
322 , P_VACANCY_CATEGORY in varchar2 default hr_api.g_varchar2
323 , P_MANAGER_ID in number default hr_api.g_number
324 , P_PRIMARY_POSTING_ID in number default hr_api.g_number
325 , P_ASSESSMENT_ID in number default hr_api.g_number
326 , P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
327 , P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
328 , P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
329 , P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
330 , P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
331 , P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
332 , P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
333 , P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
334 , P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
335 , P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
336 , P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
337 , P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
338 , P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
339 , P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
340 , P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
341 , P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
342 , P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
343 , P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
344 , P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
345 , P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
346 , P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
347 , P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
348 , P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
349 , P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
350 , P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
351 , P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
352 , P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
353 , P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
354 , P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
355 , P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
356 , P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2
357 , P_vacancy_region_type in varchar2 default hr_api.g_varchar2
358 , P_ASSIGNMENT_CHANGED out nocopy boolean
359 ,p_inv_pos_grade_warning out nocopy boolean
360 ,p_inv_job_grade_warning out nocopy boolean
361 );
362 --
363 -- ----------------------------------------------------------------------------
364 -- |------------------------------< delete_vacancy >--------------------------|
365 -- ----------------------------------------------------------------------------
366 --
367 -- {Start Of Comments}
368 /*#
369 * This API deletes a vacancy within a requisition.
370 *
371 *
372 * <p><b>Licensing</b><br>
373 * This API is licensed for use with Human Resources and iRecruitment.
374 *
375 * <p><b>Prerequisites</b><br>
376 * The vacancy must exist.
377 *
378 * <p><b>Post Success</b><br>
379 * The vacancy is deleted.
380 *
381 * <p><b>Post Failure</b><br>
382 * The vacancy is not deleted and an error is raised.
383 * @param p_validate If true, then validation alone will be performed and the
384 * database will remain unchanged. If false and all validation checks pass,
385 * then the database will be modified.
386 * @param p_object_version_number Current version number of the Vacancy to be
387 * deleted.
388 * @param p_vacancy_id Uniquely identifies the vacancy being deleted.
389 * @rep:displayname Delete Vacancy
390 * @rep:category BUSINESS_ENTITY PER_VACANCY
391 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
392 * @rep:scope public
393 * @rep:lifecycle active
394 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
395 */
396 --
397 -- {End Of Comments}
398 --
399 procedure delete_vacancy
400 (
401 P_VALIDATE in boolean default false
402 , P_OBJECT_VERSION_NUMBER in number
403 , P_VACANCY_ID in number
404 );
405 --
406 end PER_VACANCY_API;