1 Package PER_REQUISITIONS_API as
2 /* $Header: pereqapi.pkh 120.1 2005/10/02 02:23:47 aroussel $ */
3 /*#
4 * This package contains APIs to create, update and delete vacancy
5 * requisitions.
6 * @rep:scope public
7 * @rep:product per
8 * @rep:displayname Requisition
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |----------------------------< create_requisition >------------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API creates a requisition.
18 *
19 * Use this API to create a requisition for one or more vacancies. You can
20 * record the dates of the requisition and the person who initiates it.
21 *
22 * <p><b>Licensing</b><br>
23 * This API is licensed for use with Human Resources and iRecruitment.
24 *
25 * <p><b>Prerequisites</b><br>
26 * The business group for which the requisition will be created within must
27 * already exist.
28 *
29 * <p><b>Post Success</b><br>
30 * The requisition will have been created.
31 *
32 * <p><b>Post Failure</b><br>
33 * The requisition will not be created and an error will be raised.
34 * @param p_validate If true, then validation alone will be performed and the
35 * database will remain unchanged. If false and all validation checks pass,
36 * then the database will be modified.
37 * @param p_business_group_id Uniquely identifies the business group under
38 * which the requisition is created.
39 * @param p_date_from Start date of the requisition.
40 * @param p_name The name of the requisition.
41 * @param p_person_id Uniquely identifies the person who initiated the
42 * requisition.
43 * @param p_comments Comment text.
44 * @param p_date_to End Date of the requisition.
45 * @param p_description Description of the requisition.
46 * @param p_attribute_category This context value determines which flexfield
47 * structure to use with the descriptive flexfield segments.
48 * @param p_attribute1 Descriptive flexfield segment.
49 * @param p_attribute2 Descriptive flexfield segment.
50 * @param p_attribute3 Descriptive flexfield segment.
51 * @param p_attribute4 Descriptive flexfield segment.
52 * @param p_attribute5 Descriptive flexfield segment.
53 * @param p_attribute6 Descriptive flexfield segment.
54 * @param p_attribute7 Descriptive flexfield segment.
55 * @param p_attribute8 Descriptive flexfield segment.
56 * @param p_attribute9 Descriptive flexfield segment.
57 * @param p_attribute10 Descriptive flexfield segment.
58 * @param p_attribute11 Descriptive flexfield segment.
59 * @param p_attribute12 Descriptive flexfield segment.
60 * @param p_attribute13 Descriptive flexfield segment.
61 * @param p_attribute14 Descriptive flexfield segment.
62 * @param p_attribute15 Descriptive flexfield segment.
63 * @param p_attribute16 Descriptive flexfield segment.
64 * @param p_attribute17 Descriptive flexfield segment.
65 * @param p_attribute18 Descriptive flexfield segment.
66 * @param p_attribute19 Descriptive flexfield segment.
67 * @param p_attribute20 Descriptive flexfield segment.
68 * @param p_attribute21 Descriptive flexfield segment.
69 * @param p_attribute22 Descriptive flexfield segment.
70 * @param p_attribute23 Descriptive flexfield segment.
71 * @param p_attribute24 Descriptive flexfield segment.
72 * @param p_attribute25 Descriptive flexfield segment.
73 * @param p_attribute26 Descriptive flexfield segment.
74 * @param p_attribute27 Descriptive flexfield segment.
75 * @param p_attribute28 Descriptive flexfield segment.
76 * @param p_attribute29 Descriptive flexfield segment.
77 * @param p_attribute30 Descriptive flexfield segment.
78 * @param p_requisition_id If p_validate is false, then this uniquely
79 * identifies the requisition created. If p_validate is true, then this is set
80 * to null.
81 * @param p_object_version_number If p_validate is false, then set to the
82 * version number of the created requisition. If p_validate is true, then the
83 * value will be null.
84 * @rep:displayname Create Requisition
85 * @rep:category BUSINESS_ENTITY PER_VACANCY_REQUISITION
86 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
87 * @rep:scope public
88 * @rep:lifecycle active
89 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
90 */
91 --
92 -- {End Of Comments}
93 --
94 procedure create_requisition
95 (p_validate in boolean default false
96 ,p_business_group_id in number
97 ,p_date_from in date
98 ,p_name in varchar2
99 ,p_person_id in number default null
100 ,p_comments in varchar2 default null
101 ,p_date_to in date default null
102 ,p_description in varchar2 default null
103 ,p_attribute_category in varchar2 default null
104 ,p_attribute1 in varchar2 default null
105 ,p_attribute2 in varchar2 default null
106 ,p_attribute3 in varchar2 default null
107 ,p_attribute4 in varchar2 default null
108 ,p_attribute5 in varchar2 default null
109 ,p_attribute6 in varchar2 default null
110 ,p_attribute7 in varchar2 default null
111 ,p_attribute8 in varchar2 default null
112 ,p_attribute9 in varchar2 default null
113 ,p_attribute10 in varchar2 default null
114 ,p_attribute11 in varchar2 default null
115 ,p_attribute12 in varchar2 default null
116 ,p_attribute13 in varchar2 default null
117 ,p_attribute14 in varchar2 default null
118 ,p_attribute15 in varchar2 default null
119 ,p_attribute16 in varchar2 default null
120 ,p_attribute17 in varchar2 default null
121 ,p_attribute18 in varchar2 default null
122 ,p_attribute19 in varchar2 default null
123 ,p_attribute20 in varchar2 default null
124 ,p_attribute21 in varchar2 default null
125 ,p_attribute22 in varchar2 default null
126 ,p_attribute23 in varchar2 default null
127 ,p_attribute24 in varchar2 default null
128 ,p_attribute25 in varchar2 default null
129 ,p_attribute26 in varchar2 default null
130 ,p_attribute27 in varchar2 default null
131 ,p_attribute28 in varchar2 default null
132 ,p_attribute29 in varchar2 default null
133 ,p_attribute30 in varchar2 default null
134 ,p_requisition_id out nocopy number
135 ,p_object_version_number out nocopy number
136 );
137 --
138 -- ----------------------------------------------------------------------------
139 -- |----------------------------< update_requisition >------------------------|
140 -- ----------------------------------------------------------------------------
141 --
142 -- {Start Of Comments}
143 /*#
144 * This API updates a requisition.
145 *
146 * Use this API to update the details of a requisition. You can also update the
147 * dates of the requisition and the person who initiated it.
148 *
149 * <p><b>Licensing</b><br>
150 * This API is licensed for use with Human Resources and iRecruitment.
151 *
152 * <p><b>Prerequisites</b><br>
153 * The requisition that will be updated must already have been created.
154 *
155 * <p><b>Post Success</b><br>
156 * The requisition will have been updated.
157 *
158 * <p><b>Post Failure</b><br>
159 * The requisition will not be updated and an error will be raised.
160 * @param p_validate If true, then validation alone will be performed and the
161 * database will remain unchanged. If false and all validation checks pass,
162 * then the database will be modified.
163 * @param p_requisition_id Uniquely identifies the requisition being updated.
164 * @param p_object_version_number Pass in the current version number of the
165 * requisition to be updated. When the API completes if p_validate is false,
166 * will be set to the new version number of the updated requisition. If
167 * p_validate is true will be set to the same value which was passed in.
168 * @param p_date_from Start date of the requisition.
169 * @param p_person_id Uniquely identifies the person who initiated the
170 * requisition.
171 * @param p_comments Comment text.
172 * @param p_date_to End Date of the requisition.
173 * @param p_description Description of the requisition.
174 * @param p_attribute_category This context value determines which flexfield
175 * structure to use with the descriptive flexfield segments.
176 * @param p_attribute1 Descriptive flexfield segment.
177 * @param p_attribute2 Descriptive flexfield segment.
178 * @param p_attribute3 Descriptive flexfield segment.
179 * @param p_attribute4 Descriptive flexfield segment.
180 * @param p_attribute5 Descriptive flexfield segment.
181 * @param p_attribute6 Descriptive flexfield segment.
182 * @param p_attribute7 Descriptive flexfield segment.
183 * @param p_attribute8 Descriptive flexfield segment.
184 * @param p_attribute9 Descriptive flexfield segment.
185 * @param p_attribute10 Descriptive flexfield segment.
186 * @param p_attribute11 Descriptive flexfield segment.
187 * @param p_attribute12 Descriptive flexfield segment.
188 * @param p_attribute13 Descriptive flexfield segment.
189 * @param p_attribute14 Descriptive flexfield segment.
190 * @param p_attribute15 Descriptive flexfield segment.
191 * @param p_attribute16 Descriptive flexfield segment.
192 * @param p_attribute17 Descriptive flexfield segment.
193 * @param p_attribute18 Descriptive flexfield segment.
194 * @param p_attribute19 Descriptive flexfield segment.
195 * @param p_attribute20 Descriptive flexfield segment.
196 * @param p_attribute21 Descriptive flexfield segment.
197 * @param p_attribute22 Descriptive flexfield segment.
198 * @param p_attribute23 Descriptive flexfield segment.
199 * @param p_attribute24 Descriptive flexfield segment.
200 * @param p_attribute25 Descriptive flexfield segment.
201 * @param p_attribute26 Descriptive flexfield segment.
202 * @param p_attribute27 Descriptive flexfield segment.
203 * @param p_attribute28 Descriptive flexfield segment.
204 * @param p_attribute29 Descriptive flexfield segment.
205 * @param p_attribute30 Descriptive flexfield segment.
206 * @rep:displayname Update Requisition
207 * @rep:category BUSINESS_ENTITY PER_VACANCY_REQUISITION
208 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
209 * @rep:scope public
210 * @rep:lifecycle active
211 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
212 */
213 --
214 -- {End Of Comments}
215 --
216 procedure update_requisition
217 (p_validate in boolean default false
218 ,p_requisition_id in number
219 ,p_object_version_number in out nocopy number
220 ,p_date_from in date default hr_api.g_date
221 ,p_person_id in number default hr_api.g_number
222 ,p_comments in varchar2 default hr_api.g_varchar2
223 ,p_date_to in date default hr_api.g_date
224 ,p_description in varchar2 default hr_api.g_varchar2
225 ,p_attribute_category in varchar2 default hr_api.g_varchar2
226 ,p_attribute1 in varchar2 default hr_api.g_varchar2
227 ,p_attribute2 in varchar2 default hr_api.g_varchar2
228 ,p_attribute3 in varchar2 default hr_api.g_varchar2
229 ,p_attribute4 in varchar2 default hr_api.g_varchar2
230 ,p_attribute5 in varchar2 default hr_api.g_varchar2
231 ,p_attribute6 in varchar2 default hr_api.g_varchar2
232 ,p_attribute7 in varchar2 default hr_api.g_varchar2
233 ,p_attribute8 in varchar2 default hr_api.g_varchar2
234 ,p_attribute9 in varchar2 default hr_api.g_varchar2
235 ,p_attribute10 in varchar2 default hr_api.g_varchar2
236 ,p_attribute11 in varchar2 default hr_api.g_varchar2
237 ,p_attribute12 in varchar2 default hr_api.g_varchar2
238 ,p_attribute13 in varchar2 default hr_api.g_varchar2
239 ,p_attribute14 in varchar2 default hr_api.g_varchar2
240 ,p_attribute15 in varchar2 default hr_api.g_varchar2
241 ,p_attribute16 in varchar2 default hr_api.g_varchar2
242 ,p_attribute17 in varchar2 default hr_api.g_varchar2
243 ,p_attribute18 in varchar2 default hr_api.g_varchar2
244 ,p_attribute19 in varchar2 default hr_api.g_varchar2
245 ,p_attribute20 in varchar2 default hr_api.g_varchar2
246 ,p_attribute21 in varchar2 default hr_api.g_varchar2
247 ,p_attribute22 in varchar2 default hr_api.g_varchar2
248 ,p_attribute23 in varchar2 default hr_api.g_varchar2
249 ,p_attribute24 in varchar2 default hr_api.g_varchar2
250 ,p_attribute25 in varchar2 default hr_api.g_varchar2
251 ,p_attribute26 in varchar2 default hr_api.g_varchar2
252 ,p_attribute27 in varchar2 default hr_api.g_varchar2
253 ,p_attribute28 in varchar2 default hr_api.g_varchar2
254 ,p_attribute29 in varchar2 default hr_api.g_varchar2
255 ,p_attribute30 in varchar2 default hr_api.g_varchar2
256 );
257 --
258 -- ----------------------------------------------------------------------------
259 -- |----------------------------< delete_requisition >------------------------|
260 -- ----------------------------------------------------------------------------
261 --
262 -- {Start Of Comments}
263 /*#
264 * This API deletes a requisition.
265 *
266 *
267 * <p><b>Licensing</b><br>
268 * This API is licensed for use with Human Resources and iRecruitment.
269 *
270 * <p><b>Prerequisites</b><br>
271 * The requisition to be deleted must exist.
272 *
273 * <p><b>Post Success</b><br>
274 * The requisition is deleted.
275 *
276 * <p><b>Post Failure</b><br>
277 * The requisition is not deleted and an error will be raised.
278 * @param p_validate If true, then validation alone will be performed and the
279 * database will remain unchanged. If false and all validation checks pass,
280 * then the database will be modified.
281 * @param p_requisition_id Uniquely identifies the requisition being deleted.
282 * @param p_object_version_number Current version number of the Requisition to
283 * be deleted.
284 * @rep:displayname Delete Requisition
285 * @rep:category BUSINESS_ENTITY PER_VACANCY_REQUISITION
286 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
287 * @rep:scope public
288 * @rep:lifecycle active
289 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
290 */
291 --
292 -- {End Of Comments}
293 --
294 procedure delete_requisition
295 (p_validate in boolean default false
296 ,p_requisition_id in number
297 ,p_object_version_number in number
298 );
299 --
300 end PER_REQUISITIONS_API;