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