1 Package ghr_par_extra_info_api as
2 /* $Header: ghreiapi.pkh 120.9.12000000.1 2007/01/18 14:10:48 appldev noship $ */
3 /*#
4 * This package contains the procedures for creating, updating, and deleting
5 * Extra Information for a Request for Personnel Action (RPA) request.
6 * @rep:scope public
7 * @rep:product per
8 * @rep:displayname Request for Personnel Action Extra Information
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |-----------------------< create_pa_request_extra_info >-------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API creates Extra Information for a given Request for Personnel Action
18 * (RPA).
19 *
20 * This API creates US Federal Extra Information types for a given Request for
21 * Personnel Action (RPA) which is determined by the Nature of Action Code
22 * (NOAC) entered on the RPA.
23 *
24 * <p><b>Licensing</b><br>
25 * This API is licensed for use with Human Resources.
26 *
27 * <p><b>Prerequisites</b><br>
28 * Request for Personnel Action (RPA) must exist. Request for Personnel Action
29 * (RPA) Information Type must already exist.
30 *
31 * <p><b>Post Success</b><br>
32 * The API creates the Request for Personnel Action (RPA) Extra Information
33 * record in the database.
34 *
35 * <p><b>Post Failure</b><br>
36 * The API does not create the Request for Personnel Action (RPA) Extra
37 * Information and raises an error.
38 * @param p_validate If true, then validation alone will be performed and the
39 * database will remain unchanged. If false and all validation checks pass,
40 * then the database will be modified.
41 * @param p_pa_request_id The Extra Information applies to this Request for
42 * Personnel Action (RPA).
43 * @param p_information_type Extra Information applies to this Information
44 * Type.
45 * @param p_rei_attribute_category Determines context of the rei_attribute
46 * descriptive flexfield in parameters.
47 * @param p_rei_attribute1 Descriptive flexfield
48 * @param p_rei_attribute2 Descriptive flexfield
49 * @param p_rei_attribute3 Descriptive flexfield
50 * @param p_rei_attribute4 Descriptive flexfield
51 * @param p_rei_attribute5 Descriptive flexfield
52 * @param p_rei_attribute6 Descriptive flexfield
53 * @param p_rei_attribute7 Descriptive flexfield
54 * @param p_rei_attribute8 Descriptive flexfield
55 * @param p_rei_attribute9 Descriptive flexfield
56 * @param p_rei_attribute10 Descriptive flexfield
57 * @param p_rei_attribute11 Descriptive flexfield
58 * @param p_rei_attribute12 Descriptive flexfield
59 * @param p_rei_attribute13 Descriptive flexfield
60 * @param p_rei_attribute14 Descriptive flexfield
61 * @param p_rei_attribute15 Descriptive flexfield
62 * @param p_rei_attribute16 Descriptive flexfield
63 * @param p_rei_attribute17 Descriptive flexfield
64 * @param p_rei_attribute18 Descriptive flexfield
65 * @param p_rei_attribute19 Descriptive flexfield
66 * @param p_rei_attribute20 Descriptive flexfield
67 * @param p_rei_information_category Determines context of the rei_attribute
68 * developer descriptive flexfield in parameters.
69 * @param p_rei_information1 Developer descriptive flexfield
70 * @param p_rei_information2 Developer descriptive flexfield
71 * @param p_rei_information3 Developer descriptive flexfield
72 * @param p_rei_information4 Developer descriptive flexfield
73 * @param p_rei_information5 Developer descriptive flexfield
74 * @param p_rei_information6 Developer descriptive flexfield
75 * @param p_rei_information7 Developer descriptive flexfield
76 * @param p_rei_information8 Developer descriptive flexfield
77 * @param p_rei_information9 Developer descriptive flexfield
78 * @param p_rei_information10 Developer descriptive flexfield
79 * @param p_rei_information11 Developer descriptive flexfield
80 * @param p_rei_information12 Developer descriptive flexfield
81 * @param p_rei_information13 Developer descriptive flexfield
82 * @param p_rei_information14 Developer descriptive flexfield
83 * @param p_rei_information15 Developer descriptive flexfield
84 * @param p_rei_information16 Developer descriptive flexfield
85 * @param p_rei_information17 Developer descriptive flexfield
86 * @param p_rei_information18 Developer descriptive flexfield
87 * @param p_rei_information19 Developer descriptive flexfield
88 * @param p_rei_information20 Developer descriptive flexfield
89 * @param p_rei_information21 Developer descriptive flexfield
90 * @param p_rei_information22 Developer descriptive flexfield
91 * @param p_rei_information23 Developer descriptive flexfield
92 * @param p_rei_information24 Developer descriptive flexfield
93 * @param p_rei_information25 Developer descriptive flexfield
94 * @param p_rei_information26 Developer descriptive flexfield
95 * @param p_rei_information27 Developer descriptive flexfield
96 * @param p_rei_information28 Developer descriptive flexfield
97 * @param p_rei_information29 Developer descriptive flexfield
98 * @param p_rei_information30 Developer descriptive flexfield
99 * @param p_pa_request_extra_info_id If p_validate is false, this parameter
100 * uniquely identifies the Request for Personnel Action (RPA) Extra Information
101 * created. If p_validate is true, sets null.
102 * @param p_object_version_number If p_validate is false will be set to the
103 * version number of the created Request for Personnel Action (RPA) id. If
104 * p_validate is true, then the value will be null.
105 * @param p_ben_ei_validate If true, then validate the US Fed Benefits EIT
106 * changes, otherwise if false, do not validate the US Fed Benefits
107 * EIT changes.
108 * @rep:displayname Create Request for Personnel Action Extra Information
109 * @rep:category BUSINESS_ENTITY GHR_REQ_FOR_PERSONNEL_ACTION
110 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
111 * @rep:scope public
112 * @rep:lifecycle active
113 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
114 */
115 --
116 -- {End Of Comments}
117 --
118 procedure create_pa_request_extra_info
119 (p_validate in boolean default false
120 ,p_pa_request_id in number
121 ,p_information_type in varchar2
122 ,p_rei_attribute_category in varchar2 default null
123 ,p_rei_attribute1 in varchar2 default null
124 ,p_rei_attribute2 in varchar2 default null
125 ,p_rei_attribute3 in varchar2 default null
126 ,p_rei_attribute4 in varchar2 default null
127 ,p_rei_attribute5 in varchar2 default null
128 ,p_rei_attribute6 in varchar2 default null
129 ,p_rei_attribute7 in varchar2 default null
130 ,p_rei_attribute8 in varchar2 default null
131 ,p_rei_attribute9 in varchar2 default null
132 ,p_rei_attribute10 in varchar2 default null
133 ,p_rei_attribute11 in varchar2 default null
134 ,p_rei_attribute12 in varchar2 default null
135 ,p_rei_attribute13 in varchar2 default null
136 ,p_rei_attribute14 in varchar2 default null
137 ,p_rei_attribute15 in varchar2 default null
138 ,p_rei_attribute16 in varchar2 default null
139 ,p_rei_attribute17 in varchar2 default null
140 ,p_rei_attribute18 in varchar2 default null
141 ,p_rei_attribute19 in varchar2 default null
142 ,p_rei_attribute20 in varchar2 default null
143 ,p_rei_information_category in varchar2 default null
144 ,p_rei_information1 in varchar2 default null
145 ,p_rei_information2 in varchar2 default null
146 ,p_rei_information3 in varchar2 default null
147 ,p_rei_information4 in varchar2 default null
148 ,p_rei_information5 in varchar2 default null
149 ,p_rei_information6 in varchar2 default null
150 ,p_rei_information7 in varchar2 default null
151 ,p_rei_information8 in varchar2 default null
152 ,p_rei_information9 in varchar2 default null
153 ,p_rei_information10 in varchar2 default null
154 ,p_rei_information11 in varchar2 default null
155 ,p_rei_information12 in varchar2 default null
156 ,p_rei_information13 in varchar2 default null
157 ,p_rei_information14 in varchar2 default null
158 ,p_rei_information15 in varchar2 default null
159 ,p_rei_information16 in varchar2 default null
160 ,p_rei_information17 in varchar2 default null
161 ,p_rei_information18 in varchar2 default null
162 ,p_rei_information19 in varchar2 default null
163 ,p_rei_information20 in varchar2 default null
164 ,p_rei_information21 in varchar2 default null
165 ,p_rei_information22 in varchar2 default null
166 ,p_rei_information23 in varchar2 default null
167 ,p_rei_information24 in varchar2 default null
168 ,p_rei_information25 in varchar2 default null
169 ,p_rei_information26 in varchar2 default null
170 ,p_rei_information27 in varchar2 default null
171 ,p_rei_information28 in varchar2 default null
172 ,p_rei_information29 in varchar2 default null
173 ,p_rei_information30 in varchar2 default null
174 ,p_pa_request_extra_info_id out NOCOPY number
175 ,p_object_version_number out NOCOPY number
176 ,p_ben_ei_validate in varchar2 default 'FALSE'
177 );
178 --
179 -- ----------------------------------------------------------------------------
180 -- |-----------------------< update_pa_request_extra_info >-------------------|
181 -- ----------------------------------------------------------------------------
182 --
183 -- {Start Of Comments}
184 /*#
185 * This API updates Extra Information for a given Request for Personnel Action
186 * (RPA).
187 *
188 * This API updates Extra Information for a given Request for Personnel Action
189 * (RPA) as identified by the parameters p_pa_request_extra_info_id and
190 * p_object_version_number.
191 *
192 * <p><b>Licensing</b><br>
193 * This API is licensed for use with Human Resources.
194 *
195 * <p><b>Prerequisites</b><br>
196 * The Request for Personnel Action (RPA) Extra Information must exist. The
197 * Request for Personnel Action (RPA) Extra Information is identified by the
198 * parameters p_pa_request_extra_info_id and p_object_version_number.
199 *
200 * <p><b>Post Success</b><br>
201 * The API updates the Request for Personnel Action (RPA) Extra Information
202 * record in the database.
203 *
204 * <p><b>Post Failure</b><br>
205 * The API does not update the Request for Personnel Action (RPA) Extra
206 * Information record and an error is raised.
207 * @param p_validate If true, then validation alone will be performed and the
208 * database will remain unchanged. If false and all validation checks pass,
209 * then the database will be modified.
210 * @param p_pa_request_extra_info_id Uniquely identifies the Request for
211 * Personnel Action (RPA) Extra Information record.
212 * @param p_object_version_number Pass in the current version number of the
213 * Personnel Action Request id to be updated. When the API completes if
214 * p_validate is false, will be set to the new version number of the updated
215 * Personnel Action Request id. If p_validate is true will be set to the same
216 * value which was passed in.
217 * @param p_rei_attribute_category Determines context of the rei_attribute
218 * descriptive flexfield in parameters
219 * @param p_rei_attribute1 Descriptive flexfield
220 * @param p_rei_attribute2 Descriptive flexfield
221 * @param p_rei_attribute3 Descriptive flexfield
222 * @param p_rei_attribute4 Descriptive flexfield
223 * @param p_rei_attribute5 Descriptive flexfield
224 * @param p_rei_attribute6 Descriptive flexfield
225 * @param p_rei_attribute7 Descriptive flexfield
226 * @param p_rei_attribute8 Descriptive flexfield
227 * @param p_rei_attribute9 Descriptive flexfield
228 * @param p_rei_attribute10 Descriptive flexfield
229 * @param p_rei_attribute11 Descriptive flexfield
230 * @param p_rei_attribute12 Descriptive flexfield
231 * @param p_rei_attribute13 Descriptive flexfield
232 * @param p_rei_attribute14 Descriptive flexfield
233 * @param p_rei_attribute15 Descriptive flexfield
234 * @param p_rei_attribute16 Descriptive flexfield
235 * @param p_rei_attribute17 Descriptive flexfield
236 * @param p_rei_attribute18 Descriptive flexfield
237 * @param p_rei_attribute19 Descriptive flexfield
238 * @param p_rei_attribute20 Descriptive flexfield
239 * @param p_rei_information_category Determines context of the rei_attribute
240 * developer descriptive flexfield in parameters
241 * @param p_rei_information1 Developer descriptive flexfield
242 * @param p_rei_information2 Developer descriptive flexfield
243 * @param p_rei_information3 Developer descriptive flexfield
244 * @param p_rei_information4 Developer descriptive flexfield
245 * @param p_rei_information5 Developer descriptive flexfield
246 * @param p_rei_information6 Developer descriptive flexfield
247 * @param p_rei_information7 Developer descriptive flexfield
248 * @param p_rei_information8 Developer descriptive flexfield
249 * @param p_rei_information9 Developer descriptive flexfield
250 * @param p_rei_information10 Developer descriptive flexfield
251 * @param p_rei_information11 Developer descriptive flexfield
252 * @param p_rei_information12 Developer descriptive flexfield
253 * @param p_rei_information13 Developer descriptive flexfield
254 * @param p_rei_information14 Developer descriptive flexfield
255 * @param p_rei_information15 Developer descriptive flexfield
256 * @param p_rei_information16 Developer descriptive flexfield
257 * @param p_rei_information17 Developer descriptive flexfield
258 * @param p_rei_information18 Developer descriptive flexfield
259 * @param p_rei_information19 Developer descriptive flexfield
260 * @param p_rei_information20 Developer descriptive flexfield
261 * @param p_rei_information21 Developer descriptive flexfield
262 * @param p_rei_information22 Developer descriptive flexfield
263 * @param p_rei_information23 Developer descriptive flexfield
264 * @param p_rei_information24 Developer descriptive flexfield
265 * @param p_rei_information25 Developer descriptive flexfield
266 * @param p_rei_information26 Developer descriptive flexfield
267 * @param p_rei_information27 Developer descriptive flexfield
268 * @param p_rei_information28 Developer descriptive flexfield
269 * @param p_rei_information29 Developer descriptive flexfield
270 * @param p_rei_information30 Developer descriptive flexfield
271 * @param p_ben_ei_validate If true, then validate the US Fed Benefits EIT
272 * changes, otherwise if false, do not validate the US Fed Benefits
273 * EIT changes.
274 * @rep:displayname Update Request for Personnel Action Extra Information
275 * @rep:category BUSINESS_ENTITY GHR_REQ_FOR_PERSONNEL_ACTION
276 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
277 * @rep:scope public
278 * @rep:lifecycle active
279 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
280 */
281 --
282 -- {End Of Comments}
283 --
284 procedure update_pa_request_extra_info
285 (p_validate in boolean default false
286 ,p_pa_request_extra_info_id in number
287 ,p_object_version_number in out NOCOPY number
288 ,p_rei_attribute_category in varchar2 default hr_api.g_varchar2
289 ,p_rei_attribute1 in varchar2 default hr_api.g_varchar2
290 ,p_rei_attribute2 in varchar2 default hr_api.g_varchar2
291 ,p_rei_attribute3 in varchar2 default hr_api.g_varchar2
292 ,p_rei_attribute4 in varchar2 default hr_api.g_varchar2
293 ,p_rei_attribute5 in varchar2 default hr_api.g_varchar2
294 ,p_rei_attribute6 in varchar2 default hr_api.g_varchar2
295 ,p_rei_attribute7 in varchar2 default hr_api.g_varchar2
296 ,p_rei_attribute8 in varchar2 default hr_api.g_varchar2
297 ,p_rei_attribute9 in varchar2 default hr_api.g_varchar2
298 ,p_rei_attribute10 in varchar2 default hr_api.g_varchar2
299 ,p_rei_attribute11 in varchar2 default hr_api.g_varchar2
300 ,p_rei_attribute12 in varchar2 default hr_api.g_varchar2
301 ,p_rei_attribute13 in varchar2 default hr_api.g_varchar2
302 ,p_rei_attribute14 in varchar2 default hr_api.g_varchar2
306 ,p_rei_attribute18 in varchar2 default hr_api.g_varchar2
303 ,p_rei_attribute15 in varchar2 default hr_api.g_varchar2
304 ,p_rei_attribute16 in varchar2 default hr_api.g_varchar2
305 ,p_rei_attribute17 in varchar2 default hr_api.g_varchar2
307 ,p_rei_attribute19 in varchar2 default hr_api.g_varchar2
308 ,p_rei_attribute20 in varchar2 default hr_api.g_varchar2
309 ,p_rei_information_category in varchar2 default hr_api.g_varchar2
310 ,p_rei_information1 in varchar2 default hr_api.g_varchar2
311 ,p_rei_information2 in varchar2 default hr_api.g_varchar2
312 ,p_rei_information3 in varchar2 default hr_api.g_varchar2
313 ,p_rei_information4 in varchar2 default hr_api.g_varchar2
314 ,p_rei_information5 in varchar2 default hr_api.g_varchar2
315 ,p_rei_information6 in varchar2 default hr_api.g_varchar2
316 ,p_rei_information7 in varchar2 default hr_api.g_varchar2
317 ,p_rei_information8 in varchar2 default hr_api.g_varchar2
318 ,p_rei_information9 in varchar2 default hr_api.g_varchar2
319 ,p_rei_information10 in varchar2 default hr_api.g_varchar2
320 ,p_rei_information11 in varchar2 default hr_api.g_varchar2
321 ,p_rei_information12 in varchar2 default hr_api.g_varchar2
322 ,p_rei_information13 in varchar2 default hr_api.g_varchar2
323 ,p_rei_information14 in varchar2 default hr_api.g_varchar2
324 ,p_rei_information15 in varchar2 default hr_api.g_varchar2
325 ,p_rei_information16 in varchar2 default hr_api.g_varchar2
326 ,p_rei_information17 in varchar2 default hr_api.g_varchar2
327 ,p_rei_information18 in varchar2 default hr_api.g_varchar2
328 ,p_rei_information19 in varchar2 default hr_api.g_varchar2
329 ,p_rei_information20 in varchar2 default hr_api.g_varchar2
330 ,p_rei_information21 in varchar2 default hr_api.g_varchar2
331 ,p_rei_information22 in varchar2 default hr_api.g_varchar2
332 ,p_rei_information23 in varchar2 default hr_api.g_varchar2
333 ,p_rei_information24 in varchar2 default hr_api.g_varchar2
334 ,p_rei_information25 in varchar2 default hr_api.g_varchar2
335 ,p_rei_information26 in varchar2 default hr_api.g_varchar2
336 ,p_rei_information27 in varchar2 default hr_api.g_varchar2
337 ,p_rei_information28 in varchar2 default hr_api.g_varchar2
338 ,p_rei_information29 in varchar2 default hr_api.g_varchar2
339 ,p_rei_information30 in varchar2 default hr_api.g_varchar2
340 ,p_ben_ei_validate in varchar2 default 'FALSE'
341 );
342 --
343 -- ----------------------------------------------------------------------------
344 -- |-----------------------< delete_pa_request_extra_info >-------------------|
345 -- ----------------------------------------------------------------------------
346 --
347 -- {Start Of Comments}
348 /*#
349 * This API deletes Extra Information for a given Request for Personnel Action
350 * (RPA).
351 *
352 * This API deletes Extra Information for a given Request for Personnel Action
353 * (RPA) as identified by the parameters p_pa_request_extra_info_id and
354 *
355 * <p><b>Licensing</b><br>
356 * This API is licensed for use with Human Resources.
357 *
358 * <p><b>Prerequisites</b><br>
359 * The Request for Personnel Action (RPA) Extra Information must exist. The
360 * Request for Personnel Action (RPA) Extra Information is identified by the
361 * parameters p_pa_request_extra_info_id and p_object_version_number.
362 *
363 * <p><b>Post Success</b><br>
364 * The Request for Personnel Action (RPA) Extra Information record is deleted.
365 *
366 * <p><b>Post Failure</b><br>
367 * The API does not delete the Request for Personnel Action (RPA) Extra
368 * Information and an error is raised.
369 * @param p_validate If true, then validation alone will be performed and the
370 * database will remain unchanged. If false and all validation checks pass,
371 * then the database will be modified.
372 * @param p_pa_request_extra_info_id Uniquely identifies the Request for
373 * Personnel Action (RPA) Extra Information record.
374 * @param p_object_version_number Current version number of the Personnel
375 * Action Request Extra Information record to be deleted.
376 * @rep:displayname Delete Request for Personnel Action Extra Information
377 * @rep:category BUSINESS_ENTITY GHR_REQ_FOR_PERSONNEL_ACTION
378 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
379 * @rep:scope public
380 * @rep:lifecycle active
381 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
382 */
383 --
384 -- {End Of Comments}
385 --
386 procedure delete_pa_request_extra_info
387 (p_validate in boolean default false
388 ,p_pa_request_extra_info_id in number
389 ,p_object_version_number in number
390 );
391 --
392 end ghr_par_extra_info_api;