1 Package pqh_situations_api as
2 /* $Header: pqlosapi.pkh 120.1 2005/10/02 02:26:58 aroussel $ */
3 /*#
4 * This package contains APIs to validate, create, update and delete seniority
5 * situations.
6 * @rep:scope public
7 * @rep:product per
8 * @rep:displayname Situation for France
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |-----------------------------< create_situation >-------------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API validates the inputs and creates a new seniority situation.
18 *
19 * Seniority situation defines the seniority entitlements for a selected
20 * section of employees. Based on the entitlements defined as seniority
21 * situations for a type of length of service, the effective length of service
22 * is computed.
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 * It can be created only for an existing business group on the effective date.
29 *
30 * <p><b>Post Success</b><br>
31 * A situation is created in the database.
32 *
33 * <p><b>Post Failure</b><br>
34 * A situation is not created in the database and an error is raised
35 * @param p_validate If true, then validation alone will be performed and the
36 * database will remain unchanged. If false and all validation checks pass,
37 * then the database will be modified.
38 * @param p_effective_date Specifies the reference date for validating lookup
39 * values, applicable within the active date range. This date does not
40 * determine when the changes take effect.
41 * @param p_situation Situation corresponding to situation type. If the
42 * situation type is ABSENCE, then valid values are in 'ABSENCE_CATEGORY'
43 * lookup type. If the situation is ASSIGNMENT, then valid values are in
44 * 'PER_ASS_SYS_STATUS'. If the situation is MILITARY, then valid values are in
45 * legislation specific lookup types like FR_MILITARY_SERVICE_STATUS. If the
46 * situation is EMPLOYMENT, then valid values are in 'PREV_EMP_TYPE' lookup
47 * type
48 * @param p_effective_start_date Effective start date of the situation
49 * @param p_business_group_id It is the business group identifier for which
50 * this Situation is being created. It is a mandatory parameter
51 * @param p_situation_type It is the type of the situation. Valid values are
52 * identified by lookup type 'FR_PQH_SITUATION_TYPE'.
53 * @param p_length_of_service Identifies the type of seniority for which the
54 * situation is applicable. Valid values are identified by lookup type
55 * 'FR_PQH_LENGTH_OF_SERVICE_TYPE'
56 * @param p_effective_end_date Effective end date of the situation. It is
57 * generally set to null
58 * @param p_employee_type Agent type for which the situation is applicable.
59 * Valid values are identified by lookup type 'FR_PQH_EMP_TYPE'.
60 * @param p_entitlement_flag Flag which decides the entitlement for the
61 * situation
62 * @param p_worktime_proportional Indicates whether the entitlement is
63 * proportional to work time or not. Value can be not null only if
64 * entitlement_flag is set to Y.
65 * @param p_entitlement_value The entitlement value. Value can be not null only
66 * if entitlement_flag is set to Y.
67 * @param p_information_category This context value determines which flexfield
68 * structure to use with the developer descriptive flexfield segments.
69 * @param p_information1 Developer descriptive flexfield segment.
70 * @param p_information2 Developer descriptive flexfield segment.
71 * @param p_information3 Developer descriptive flexfield segment.
72 * @param p_information4 Developer descriptive flexfield segment.
73 * @param p_information5 Developer descriptive flexfield segment.
74 * @param p_information6 Developer descriptive flexfield segment.
75 * @param p_information7 Developer descriptive flexfield segment.
76 * @param p_information8 Developer descriptive flexfield segment.
77 * @param p_information9 Developer descriptive flexfield segment.
78 * @param p_information10 Developer descriptive flexfield segment.
79 * @param p_information11 Developer descriptive flexfield segment.
80 * @param p_information12 Developer descriptive flexfield segment.
81 * @param p_information13 Developer descriptive flexfield segment.
82 * @param p_information14 Developer descriptive flexfield segment.
83 * @param p_information15 Developer descriptive flexfield segment.
84 * @param p_information16 Developer descriptive flexfield segment.
85 * @param p_information17 Developer descriptive flexfield segment.
86 * @param p_information18 Developer descriptive flexfield segment.
87 * @param p_information19 Developer descriptive flexfield segment.
88 * @param p_information20 Developer descriptive flexfield segment.
89 * @param p_information21 Developer descriptive flexfield segment.
90 * @param p_information22 Developer descriptive flexfield segment.
91 * @param p_information23 Developer descriptive flexfield segment.
92 * @param p_information24 Developer descriptive flexfield segment.
93 * @param p_information25 Developer descriptive flexfield segment.
94 * @param p_information26 Developer descriptive flexfield segment.
95 * @param p_information27 Developer descriptive flexfield segment.
96 * @param p_information28 Developer descriptive flexfield segment.
97 * @param p_information29 Developer descriptive flexfield segment.
98 * @param p_information30 Developer descriptive flexfield segment.
99 * @param p_attribute_category This context value determines which flexfield
100 * structure to use with the descriptive flexfield segments.
101 * @param p_attribute1 Descriptive flexfield segment.
102 * @param p_attribute2 Descriptive flexfield segment.
103 * @param p_attribute3 Descriptive flexfield segment.
104 * @param p_attribute4 Descriptive flexfield segment.
105 * @param p_attribute5 Descriptive flexfield segment.
106 * @param p_attribute6 Descriptive flexfield segment.
107 * @param p_attribute7 Descriptive flexfield segment.
108 * @param p_attribute8 Descriptive flexfield segment.
109 * @param p_attribute9 Descriptive flexfield segment.
110 * @param p_attribute10 Descriptive flexfield segment.
111 * @param p_attribute11 Descriptive flexfield segment.
112 * @param p_attribute12 Descriptive flexfield segment.
113 * @param p_attribute13 Descriptive flexfield segment.
114 * @param p_attribute14 Descriptive flexfield segment.
115 * @param p_attribute15 Descriptive flexfield segment.
116 * @param p_attribute16 Descriptive flexfield segment.
117 * @param p_attribute17 Descriptive flexfield segment.
118 * @param p_attribute18 Descriptive flexfield segment.
119 * @param p_attribute19 Descriptive flexfield segment.
120 * @param p_attribute20 Descriptive flexfield segment.
121 * @param p_attribute21 Descriptive flexfield segment.
122 * @param p_attribute22 Descriptive flexfield segment.
123 * @param p_attribute23 Descriptive flexfield segment.
124 * @param p_attribute24 Descriptive flexfield segment.
125 * @param p_attribute25 Descriptive flexfield segment.
126 * @param p_attribute26 Descriptive flexfield segment.
127 * @param p_attribute27 Descriptive flexfield segment.
128 * @param p_attribute28 Descriptive flexfield segment.
129 * @param p_attribute29 Descriptive flexfield segment.
130 * @param p_attribute30 Descriptive flexfield segment.
131 * @param p_situation_id The process returns the unique situation identifier
132 * generated for the new record as primary key
133 * @param p_object_version_number If p_validate is false, the process returns
134 * the version number of the created situation. If p_validate is true, it
135 * returns null.
136 * @rep:displayname Create Situation
137 * @rep:category BUSINESS_ENTITY PQH_EMEA_SENIORITY_SITUATION
138 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
139 * @rep:scope public
140 * @rep:lifecycle active
141 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
142 */
143 --
144 -- {End Of Comments}
145 --
146 procedure create_situation
147 (p_validate in boolean default false
148 ,p_effective_date in date
149 ,p_situation in varchar2
150 ,p_effective_start_date in date
151 ,p_business_group_id in number
152 ,p_situation_type in varchar2
153 ,p_length_of_service in varchar2
154 ,p_effective_end_date in date default null
155 ,p_employee_type in varchar2 default null
156 ,p_entitlement_flag in varchar2 default null
157 ,p_worktime_proportional in varchar2 default null
158 ,p_entitlement_value in number default null
159 ,p_information_category in varchar2 default null
160 ,p_information1 in varchar2 default null
161 ,p_information2 in varchar2 default null
162 ,p_information3 in varchar2 default null
163 ,p_information4 in varchar2 default null
164 ,p_information5 in varchar2 default null
165 ,p_information6 in varchar2 default null
166 ,p_information7 in varchar2 default null
167 ,p_information8 in varchar2 default null
168 ,p_information9 in varchar2 default null
169 ,p_information10 in varchar2 default null
170 ,p_information11 in varchar2 default null
171 ,p_information12 in varchar2 default null
172 ,p_information13 in varchar2 default null
173 ,p_information14 in varchar2 default null
174 ,p_information15 in varchar2 default null
175 ,p_information16 in varchar2 default null
176 ,p_information17 in varchar2 default null
177 ,p_information18 in varchar2 default null
178 ,p_information19 in varchar2 default null
179 ,p_information20 in varchar2 default null
180 ,p_information21 in varchar2 default null
181 ,p_information22 in varchar2 default null
182 ,p_information23 in varchar2 default null
183 ,p_information24 in varchar2 default null
184 ,p_information25 in varchar2 default null
185 ,p_information26 in varchar2 default null
186 ,p_information27 in varchar2 default null
187 ,p_information28 in varchar2 default null
188 ,p_information29 in varchar2 default null
189 ,p_information30 in varchar2 default null
190 ,p_attribute_category in varchar2 default null
191 ,p_attribute1 in varchar2 default null
192 ,p_attribute2 in varchar2 default null
193 ,p_attribute3 in varchar2 default null
194 ,p_attribute4 in varchar2 default null
195 ,p_attribute5 in varchar2 default null
196 ,p_attribute6 in varchar2 default null
197 ,p_attribute7 in varchar2 default null
198 ,p_attribute8 in varchar2 default null
199 ,p_attribute9 in varchar2 default null
200 ,p_attribute10 in varchar2 default null
201 ,p_attribute11 in varchar2 default null
202 ,p_attribute12 in varchar2 default null
203 ,p_attribute13 in varchar2 default null
204 ,p_attribute14 in varchar2 default null
205 ,p_attribute15 in varchar2 default null
206 ,p_attribute16 in varchar2 default null
207 ,p_attribute17 in varchar2 default null
208 ,p_attribute18 in varchar2 default null
209 ,p_attribute19 in varchar2 default null
210 ,p_attribute20 in varchar2 default null
211 ,p_attribute21 in varchar2 default null
212 ,p_attribute22 in varchar2 default null
213 ,p_attribute23 in varchar2 default null
214 ,p_attribute24 in varchar2 default null
215 ,p_attribute25 in varchar2 default null
216 ,p_attribute26 in varchar2 default null
217 ,p_attribute27 in varchar2 default null
218 ,p_attribute28 in varchar2 default null
219 ,p_attribute29 in varchar2 default null
220 ,p_attribute30 in varchar2 default null
221 ,p_situation_id out nocopy number
222 ,p_object_version_number out nocopy number
223 );
224 --
225 -- ----------------------------------------------------------------------------
226 -- |-----------------------------< update_situation >-------------------------|
227 -- ----------------------------------------------------------------------------
228 --
229 -- {Start Of Comments}
230 /*#
231 * This API validates the changes made to the existing seniority situation and
232 * updates it in the database.
233 *
234 * It validates the combination of situation, situation type, length of service
235 * and employee type for uniqueness. The record is updated in PQH_SITUATIONS
236 * table.
237 *
238 * <p><b>Licensing</b><br>
239 * This API is licensed for use with Human Resources.
240 *
241 * <p><b>Prerequisites</b><br>
242 * Record should exist with the specified object version number.
243 *
244 * <p><b>Post Success</b><br>
245 * The existing situation record is updated in the database.
246 *
247 * <p><b>Post Failure</b><br>
248 * The existing situation is not changed in the database and an error is raised
249 * @param p_validate If true, then validation alone will be performed and the
250 * database will remain unchanged. If false and all validation checks pass,
251 * then the database will be modified.
252 * @param p_effective_date Specifies the reference date for validating lookup
253 * values, applicable within the active date range. This date does not
254 * determine when the changes take effect.
255 * @param p_situation_id Unique situation identifier generated for the new
256 * record as primary key
257 * @param p_object_version_number Passes the current version number of the
258 * seniority situation to be updated. When the API completes if p_validate is
259 * false, the process returns the new version number of the updated seniority
260 * situation. If p_validate, it returns the same value which was passed in.
261 * @param p_situation Situation corresponding to situation type. If the
262 * situation type is ABSENCE, then valid values are in 'ABSENCE_CATEGORY'
263 * lookup type. If the situation is ASSIGNMENT, then valid values are in
264 * 'PER_ASS_SYS_STATUS'. If the situation is MILITARY, then valid values are in
265 * legislation specific lookup types like FR_MILITARY_SERVICE_STATUS. If the
266 * situation is EMPLOYMENT, then valid values are in 'PREV_EMP_TYPE' lookup
267 * type
268 * @param p_effective_start_date Effective start date of the situation
269 * @param p_business_group_id Business group identifier for which this
270 * situation is being created. It is a mandatory parameter
271 * @param p_situation_type It is the type of the Situation. Valid values are
272 * identified by lookup type 'FR_PQH_SITUATION_TYPE'.
273 * @param p_length_of_service Identifies the type of seniority for which the
274 * situation is applicable. Valid values are identified by lookup type
275 * 'FR_PQH_LENGTH_OF_SERVICE_TYPE'
276 * @param p_effective_end_date Effective end date of the situation. It is
277 * generally set to null
278 * @param p_employee_type Agent type for which the situation is applicable.
279 * Valid values are identified by lookup type 'FR_PQH_EMP_TYPE'.
280 * @param p_entitlement_flag Flag which decides the entitlement for the
281 * situation
282 * @param p_worktime_proportional Indicates whether the entitlement is
283 * proportional to work time or not. Value can be not null only if
284 * entitlement_flag is set to Y.
285 * @param p_entitlement_value The entitlement value. Value can be not null only
286 * if entitlement_flag is set to Y.
287 * @param p_information_category This context value determines which flexfield
288 * structure to use with the developer descriptive flexfield segments.
289 * @param p_information1 Developer descriptive flexfield segment.
290 * @param p_information2 Developer descriptive flexfield segment.
291 * @param p_information3 Developer descriptive flexfield segment.
292 * @param p_information4 Developer descriptive flexfield segment.
293 * @param p_information5 Developer descriptive flexfield segment.
294 * @param p_information6 Developer descriptive flexfield segment.
295 * @param p_information7 Developer descriptive flexfield segment.
296 * @param p_information8 Developer descriptive flexfield segment.
297 * @param p_information9 Developer descriptive flexfield segment.
298 * @param p_information10 Developer descriptive flexfield segment.
299 * @param p_information11 Developer descriptive flexfield segment.
300 * @param p_information12 Developer descriptive flexfield segment.
301 * @param p_information13 Developer descriptive flexfield segment.
302 * @param p_information14 Developer descriptive flexfield segment.
303 * @param p_information15 Developer descriptive flexfield segment.
304 * @param p_information16 Developer descriptive flexfield segment.
305 * @param p_information17 Developer descriptive flexfield segment.
306 * @param p_information18 Developer descriptive flexfield segment.
307 * @param p_information19 Developer descriptive flexfield segment.
308 * @param p_information20 Developer descriptive flexfield segment.
309 * @param p_information21 Developer descriptive flexfield segment.
310 * @param p_information22 Developer descriptive flexfield segment.
311 * @param p_information23 Developer descriptive flexfield segment.
312 * @param p_information24 Developer descriptive flexfield segment.
313 * @param p_information25 Developer descriptive flexfield segment.
317 * @param p_information29 Developer descriptive flexfield segment.
314 * @param p_information26 Developer descriptive flexfield segment.
315 * @param p_information27 Developer descriptive flexfield segment.
316 * @param p_information28 Developer descriptive flexfield segment.
318 * @param p_information30 Developer descriptive flexfield segment.
319 * @param p_attribute_category This context value determines which flexfield
320 * structure to use with the descriptive flexfield segments.
321 * @param p_attribute1 Descriptive flexfield segment.
322 * @param p_attribute2 Descriptive flexfield segment.
323 * @param p_attribute3 Descriptive flexfield segment.
324 * @param p_attribute4 Descriptive flexfield segment.
325 * @param p_attribute5 Descriptive flexfield segment.
326 * @param p_attribute6 Descriptive flexfield segment.
327 * @param p_attribute7 Descriptive flexfield segment.
328 * @param p_attribute8 Descriptive flexfield segment.
329 * @param p_attribute9 Descriptive flexfield segment.
330 * @param p_attribute10 Descriptive flexfield segment.
331 * @param p_attribute11 Descriptive flexfield segment.
332 * @param p_attribute12 Descriptive flexfield segment.
333 * @param p_attribute13 Descriptive flexfield segment.
334 * @param p_attribute14 Descriptive flexfield segment.
335 * @param p_attribute15 Descriptive flexfield segment.
336 * @param p_attribute16 Descriptive flexfield segment.
337 * @param p_attribute17 Descriptive flexfield segment.
338 * @param p_attribute18 Descriptive flexfield segment.
339 * @param p_attribute19 Descriptive flexfield segment.
340 * @param p_attribute20 Descriptive flexfield segment.
341 * @param p_attribute21 Descriptive flexfield segment.
342 * @param p_attribute22 Descriptive flexfield segment.
343 * @param p_attribute23 Descriptive flexfield segment.
344 * @param p_attribute24 Descriptive flexfield segment.
345 * @param p_attribute25 Descriptive flexfield segment.
346 * @param p_attribute26 Descriptive flexfield segment.
347 * @param p_attribute27 Descriptive flexfield segment.
348 * @param p_attribute28 Descriptive flexfield segment.
349 * @param p_attribute29 Descriptive flexfield segment.
350 * @param p_attribute30 Descriptive flexfield segment.
351 * @rep:displayname Update Situation
352 * @rep:category BUSINESS_ENTITY PQH_EMEA_SENIORITY_SITUATION
353 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
354 * @rep:scope public
355 * @rep:lifecycle active
356 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
357 */
358 --
359 -- {End Of Comments}
360 --
361 procedure update_situation
362 (p_validate in boolean default false
363 ,p_effective_date in date
364 ,p_situation_id in number
365 ,p_object_version_number in out nocopy number
366 ,p_situation in varchar2 default hr_api.g_varchar2
367 ,p_effective_start_date in date default hr_api.g_date
368 ,p_business_group_id in number default hr_api.g_number
369 ,p_situation_type in varchar2 default hr_api.g_varchar2
370 ,p_length_of_service in varchar2 default hr_api.g_varchar2
371 ,p_effective_end_date in date default hr_api.g_date
372 ,p_employee_type in varchar2 default hr_api.g_varchar2
373 ,p_entitlement_flag in varchar2 default hr_api.g_varchar2
374 ,p_worktime_proportional in varchar2 default hr_api.g_varchar2
375 ,p_entitlement_value in number default hr_api.g_number
376 ,p_information_category in varchar2 default hr_api.g_varchar2
377 ,p_information1 in varchar2 default hr_api.g_varchar2
378 ,p_information2 in varchar2 default hr_api.g_varchar2
379 ,p_information3 in varchar2 default hr_api.g_varchar2
380 ,p_information4 in varchar2 default hr_api.g_varchar2
381 ,p_information5 in varchar2 default hr_api.g_varchar2
382 ,p_information6 in varchar2 default hr_api.g_varchar2
383 ,p_information7 in varchar2 default hr_api.g_varchar2
384 ,p_information8 in varchar2 default hr_api.g_varchar2
385 ,p_information9 in varchar2 default hr_api.g_varchar2
386 ,p_information10 in varchar2 default hr_api.g_varchar2
387 ,p_information11 in varchar2 default hr_api.g_varchar2
388 ,p_information12 in varchar2 default hr_api.g_varchar2
389 ,p_information13 in varchar2 default hr_api.g_varchar2
390 ,p_information14 in varchar2 default hr_api.g_varchar2
391 ,p_information15 in varchar2 default hr_api.g_varchar2
392 ,p_information16 in varchar2 default hr_api.g_varchar2
393 ,p_information17 in varchar2 default hr_api.g_varchar2
394 ,p_information18 in varchar2 default hr_api.g_varchar2
395 ,p_information19 in varchar2 default hr_api.g_varchar2
396 ,p_information20 in varchar2 default hr_api.g_varchar2
397 ,p_information21 in varchar2 default hr_api.g_varchar2
398 ,p_information22 in varchar2 default hr_api.g_varchar2
399 ,p_information23 in varchar2 default hr_api.g_varchar2
400 ,p_information24 in varchar2 default hr_api.g_varchar2
401 ,p_information25 in varchar2 default hr_api.g_varchar2
402 ,p_information26 in varchar2 default hr_api.g_varchar2
403 ,p_information27 in varchar2 default hr_api.g_varchar2
404 ,p_information28 in varchar2 default hr_api.g_varchar2
405 ,p_information29 in varchar2 default hr_api.g_varchar2
406 ,p_information30 in varchar2 default hr_api.g_varchar2
407 ,p_attribute_category in varchar2 default hr_api.g_varchar2
408 ,p_attribute1 in varchar2 default hr_api.g_varchar2
409 ,p_attribute2 in varchar2 default hr_api.g_varchar2
410 ,p_attribute3 in varchar2 default hr_api.g_varchar2
411 ,p_attribute4 in varchar2 default hr_api.g_varchar2
412 ,p_attribute5 in varchar2 default hr_api.g_varchar2
413 ,p_attribute6 in varchar2 default hr_api.g_varchar2
414 ,p_attribute7 in varchar2 default hr_api.g_varchar2
415 ,p_attribute8 in varchar2 default hr_api.g_varchar2
416 ,p_attribute9 in varchar2 default hr_api.g_varchar2
417 ,p_attribute10 in varchar2 default hr_api.g_varchar2
418 ,p_attribute11 in varchar2 default hr_api.g_varchar2
419 ,p_attribute12 in varchar2 default hr_api.g_varchar2
420 ,p_attribute13 in varchar2 default hr_api.g_varchar2
421 ,p_attribute14 in varchar2 default hr_api.g_varchar2
422 ,p_attribute15 in varchar2 default hr_api.g_varchar2
423 ,p_attribute16 in varchar2 default hr_api.g_varchar2
424 ,p_attribute17 in varchar2 default hr_api.g_varchar2
425 ,p_attribute18 in varchar2 default hr_api.g_varchar2
426 ,p_attribute19 in varchar2 default hr_api.g_varchar2
427 ,p_attribute20 in varchar2 default hr_api.g_varchar2
428 ,p_attribute21 in varchar2 default hr_api.g_varchar2
429 ,p_attribute22 in varchar2 default hr_api.g_varchar2
430 ,p_attribute23 in varchar2 default hr_api.g_varchar2
431 ,p_attribute24 in varchar2 default hr_api.g_varchar2
432 ,p_attribute25 in varchar2 default hr_api.g_varchar2
433 ,p_attribute26 in varchar2 default hr_api.g_varchar2
434 ,p_attribute27 in varchar2 default hr_api.g_varchar2
435 ,p_attribute28 in varchar2 default hr_api.g_varchar2
436 ,p_attribute29 in varchar2 default hr_api.g_varchar2
437 ,p_attribute30 in varchar2 default hr_api.g_varchar2
438 );
439 --
440 -- ----------------------------------------------------------------------------
441 -- |-----------------------------< delete_situation >-------------------------|
442 -- ----------------------------------------------------------------------------
443 --
444 -- {Start Of Comments}
445 /*#
446 * This API deletes a seniority situation record from the database.
447 *
448 * The record is deleted from PQH_SITUATIONS table.
449 *
450 * <p><b>Licensing</b><br>
451 * This API is licensed for use with Human Resources.
452 *
453 * <p><b>Prerequisites</b><br>
454 * This record should exist with the specified object version number.
455 *
456 * <p><b>Post Success</b><br>
457 * The seniority situation record is deleted from the database.
458 *
459 * <p><b>Post Failure</b><br>
460 * The seniority situation record is not deleted from the database and an error
461 * is raised
462 * @param p_validate If true, then validation alone will be performed and the
463 * database will remain unchanged. If false and all validation checks pass,
464 * then the database will be modified.
465 * @param p_situation_id Unique situation identifier generated for the new
466 * record as primary key
467 * @param p_object_version_number Current version number of the situation to be
468 * deleted
469 * @rep:displayname Delete Situation
470 * @rep:category BUSINESS_ENTITY PQH_EMEA_SENIORITY_SITUATION
471 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
472 * @rep:scope public
473 * @rep:lifecycle active
474 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
475 */
476 --
477 -- {End Of Comments}
478 --
479 procedure delete_situation
480 (p_validate in boolean default false
481 ,p_situation_id in number
482 ,p_object_version_number in number
483 );
484
485 --
486 end pqh_situations_api;