1 Package hr_collective_agreement_api as
2 /* $Header: hrcagapi.pkh 120.3.12010000.2 2008/08/06 08:35:07 ubhat ship $ */
3 /*#
4 * This package contains APIs which maintain collective agreements.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Collective Agreement
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |----------------------------< attach_plan_years >-------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- Description:
15 --
16 -- This procedure will attach plan years to the plan created for the
17 -- collective agreement.
18 --
19 -- Prerequisites:
20 -- This is a private function and can only be called from the api.
21 --
22 -- In Parameters:
23 --
24 -- effective date
25 -- business group id
26 -- plan id
27 --
28 -- Post Success:
29 -- Plan Years attached to plan.
30 --
31 -- Post Failure:
32 -- If the process fails a error message will be raised.
33 --
34 -- Developer Implementation Notes:
35 -- None.
36 --
37 -- Access Status:
38 -- Internal Development Use Only.
39 --
40 -- ----------------------------------------------------------------------------
41 --
42 PROCEDURE attach_plan_years
43 (p_effective_date IN DATE
44 ,p_business_group_id IN NUMBER
45 ,p_pl_id IN NUMBER);
46 --
47 -- ----------------------------------------------------------------------------
48 -- |-----------------------< create_collective_agreement >--------------------|
49 -- ----------------------------------------------------------------------------
50 --
51 -- {Start Of Comments}
52 /*#
53 * This API creates a collective agreement.
54 *
55 * A collective agreement is a set of terms and conditions of employment which
56 * have been collectively agreed, usually through a process of negotiation, by
57 * the parties which participate in the employment relationship. This normally
58 * means that representatives of trades unions, employers and potentially
59 * employees have formed a tri-partite body to specifically agree the terms of
60 * employment. Collective agreements may be formed at various levels; they may
61 * span multiple industries, or particular industries, or a specific industrial
62 * sector, or they may even be specific to a particular employer or type of
63 * employee within an industry. As such an employee or employer may be 'covered
64 * by' multiple collective agreements at any one time.
65 *
66 * <p><b>Licensing</b><br>
67 * This API is licensed for use with Human Resources.
68 *
69 * <p><b>Prerequisites</b><br>
70 * The organizations and their signatories which are parties bound by this
71 * collective agreement must exist on the effective date.
72 *
73 * <p><b>Post Success</b><br>
74 * The collective agreement is created.
75 *
76 * <p><b>Post Failure</b><br>
77 * The collective agreement is not created and an error is raised.
78 * @param p_validate If true, then validation alone will be performed and the
79 * database will remain unchanged. If false and all validation checks pass,
80 * then the database will be modified.
81 * @param p_collective_agreement_id If p_validate is false, then this uniquely
82 * identifies the collective agreement created. If p_validate is true, then set
83 * to null.
84 * @param p_effective_date Reference date for validating lookup values are
85 * applicable during the start to end active date range. This date does not
86 * determine when the changes take effect.
87 * @param p_business_group_id The business group of the record.
88 * @param p_object_version_number If p_validate is false, then set to the
89 * version number of the created collective agreement. If p_validate is true,
90 * then the value will be null.
91 * @param p_name The name of the collective agreement.
92 * @param p_status Indicates whether the collective agreement is active or not.
93 * Valid values are defined by the 'CAGR_STATUS' lookup type.
94 * @param p_cag_number The reference number of the collective agreement.
95 * @param p_description This description of the collective agreement in terms
96 * of its purpose and the groups of people it covers.
97 * @param p_end_date The date until which the collective agreement is in
98 * effect.
99 * @param p_employer_organization_id Uniquely identifies the employer
100 * organization which agreed and is bound by this agreement.
101 * @param p_employer_signatory The person who signed the agreement on behalf of
102 * the employer.
103 * @param p_bargaining_organization_id Uniquely identifies the bargaining
104 * organization (trade union) which agreed and is bound by this agreement.
105 * @param p_bargaining_unit_signatory The name of the person who signed the
106 * agreement on behalf of bargaining unit.
107 * @param p_jurisdiction The jurisdiction of the collective agreement.
108 * @param p_authorizing_body The name of the public or official body which
109 * authorized the agreement.
110 * @param p_authorized_date The date the collective agreement was authorized by
111 * the authorizing body.
112 * @param p_cag_information_category This context value determines which
113 * Flexfield Structure to use with the Developer Descriptive flexfield
114 * segments.
115 * @param p_cag_information1 Developer Descriptive flexfield segment.
116 * @param p_cag_information2 Developer Descriptive flexfield segment.
117 * @param p_cag_information3 Developer Descriptive flexfield segment.
118 * @param p_cag_information4 Developer Descriptive flexfield segment.
119 * @param p_cag_information5 Developer Descriptive flexfield segment.
120 * @param p_cag_information6 Developer Descriptive flexfield segment.
121 * @param p_cag_information7 Developer Descriptive flexfield segment.
122 * @param p_cag_information8 Developer Descriptive flexfield segment.
123 * @param p_cag_information9 Developer Descriptive flexfield segment.
124 * @param p_cag_information10 Developer Descriptive flexfield segment.
125 * @param p_cag_information11 Developer Descriptive flexfield segment.
126 * @param p_cag_information12 Developer Descriptive flexfield segment.
127 * @param p_cag_information13 Developer Descriptive flexfield segment.
128 * @param p_cag_information14 Developer Descriptive flexfield segment.
129 * @param p_cag_information15 Developer Descriptive flexfield segment.
130 * @param p_cag_information16 Developer Descriptive flexfield segment.
131 * @param p_cag_information17 Developer Descriptive flexfield segment.
132 * @param p_cag_information18 Developer Descriptive flexfield segment.
133 * @param p_cag_information19 Developer Descriptive flexfield segment.
134 * @param p_cag_information20 Developer Descriptive flexfield segment.
135 * @param p_attribute_category This context value determines which flexfield
136 * structure to use with the descriptive flexfield segments.
137 * @param p_attribute1 Descriptive flexfield segment.
138 * @param p_attribute2 Descriptive flexfield segment.
139 * @param p_attribute3 Descriptive flexfield segment.
140 * @param p_attribute4 Descriptive flexfield segment.
141 * @param p_attribute5 Descriptive flexfield segment.
142 * @param p_attribute6 Descriptive flexfield segment.
143 * @param p_attribute7 Descriptive flexfield segment.
144 * @param p_attribute8 Descriptive flexfield segment.
145 * @param p_attribute9 Descriptive flexfield segment.
146 * @param p_attribute10 Descriptive flexfield segment.
147 * @param p_attribute11 Descriptive flexfield segment.
148 * @param p_attribute12 Descriptive flexfield segment.
149 * @param p_attribute13 Descriptive flexfield segment.
150 * @param p_attribute14 Descriptive flexfield segment.
151 * @param p_attribute15 Descriptive flexfield segment.
152 * @param p_attribute16 Descriptive flexfield segment.
153 * @param p_attribute17 Descriptive flexfield segment.
154 * @param p_attribute18 Descriptive flexfield segment.
155 * @param p_attribute19 Descriptive flexfield segment.
156 * @param p_attribute20 Descriptive flexfield segment.
157 * @rep:displayname Create Collective Agreement
158 * @rep:category BUSINESS_ENTITY PER_COLLECTIVE_AGREEMENT
159 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
160 * @rep:scope public
161 * @rep:lifecycle active
162 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
163 */
164 --
165 -- {End Of Comments}
166 --
167 procedure create_collective_agreement
168 (p_validate in boolean default false
169 ,p_collective_agreement_id out nocopy number
170 ,p_effective_date in date
171 ,p_business_group_id in number
172 ,p_object_version_number out nocopy number
173 ,p_name in varchar2
174 ,p_status in varchar2
175 ,p_cag_number in number default null
176 ,p_description in varchar2 default null
177 ,p_end_date in date default null
178 ,p_employer_organization_id in number default null
179 ,p_employer_signatory in varchar2 default null
180 ,p_bargaining_organization_id in number default null
181 ,p_bargaining_unit_signatory in varchar2 default null
182 ,p_jurisdiction in varchar2 default null
183 ,p_authorizing_body in varchar2 default null
184 ,p_authorized_date in date default null
185 ,p_cag_information_category in varchar2 default null
186 ,p_cag_information1 in varchar2 default null
187 ,p_cag_information2 in varchar2 default null
188 ,p_cag_information3 in varchar2 default null
189 ,p_cag_information4 in varchar2 default null
190 ,p_cag_information5 in varchar2 default null
191 ,p_cag_information6 in varchar2 default null
192 ,p_cag_information7 in varchar2 default null
193 ,p_cag_information8 in varchar2 default null
194 ,p_cag_information9 in varchar2 default null
195 ,p_cag_information10 in varchar2 default null
196 ,p_cag_information11 in varchar2 default null
197 ,p_cag_information12 in varchar2 default null
198 ,p_cag_information13 in varchar2 default null
199 ,p_cag_information14 in varchar2 default null
200 ,p_cag_information15 in varchar2 default null
201 ,p_cag_information16 in varchar2 default null
202 ,p_cag_information17 in varchar2 default null
203 ,p_cag_information18 in varchar2 default null
204 ,p_cag_information19 in varchar2 default null
205 ,p_cag_information20 in varchar2 default null
206 ,p_attribute_category in varchar2 default null
207 ,p_attribute1 in varchar2 default null
208 ,p_attribute2 in varchar2 default null
209 ,p_attribute3 in varchar2 default null
210 ,p_attribute4 in varchar2 default null
211 ,p_attribute5 in varchar2 default null
212 ,p_attribute6 in varchar2 default null
213 ,p_attribute7 in varchar2 default null
214 ,p_attribute8 in varchar2 default null
215 ,p_attribute9 in varchar2 default null
216 ,p_attribute10 in varchar2 default null
217 ,p_attribute11 in varchar2 default null
218 ,p_attribute12 in varchar2 default null
219 ,p_attribute13 in varchar2 default null
220 ,p_attribute14 in varchar2 default null
221 ,p_attribute15 in varchar2 default null
222 ,p_attribute16 in varchar2 default null
223 ,p_attribute17 in varchar2 default null
224 ,p_attribute18 in varchar2 default null
225 ,p_attribute19 in varchar2 default null
226 ,p_attribute20 in varchar2 default null
227 );
228 /*
229 (
230 p_validate in boolean default false
231 ,p_collective_agreement_id out nocopy number
232 ,p_effective_date in date
233 ,p_business_group_id in number default null
234 ,p_object_version_number out nocopy number
235 ,p_name in varchar2 default null
236 ,p_status in varchar2 default null
237 ,p_cag_number in number default null
238 ,p_description in varchar2 default null
239 ,p_end_date in date default null
240 ,p_employer_organization_id in number default null
241 ,p_employer_signatory in varchar2 default null
242 ,p_bargaining_organization_id in number default null
243 ,p_bargaining_unit_signatory in varchar2 default null
244 ,p_jurisdiction in varchar2 default null
245 ,p_authorizing_body in varchar2 default null
246 ,p_authorized_date in date default null
247 ,p_cag_information_category in varchar2 default null
248 ,p_cag_information1 in varchar2 default null
249 ,p_cag_information2 in varchar2 default null
250 ,p_cag_information3 in varchar2 default null
251 ,p_cag_information4 in varchar2 default null
252 ,p_cag_information5 in varchar2 default null
253 ,p_cag_information6 in varchar2 default null
254 ,p_cag_information7 in varchar2 default null
255 ,p_cag_information8 in varchar2 default null
256 ,p_cag_information9 in varchar2 default null
257 ,p_cag_information10 in varchar2 default null
258 ,p_cag_information11 in varchar2 default null
259 ,p_cag_information12 in varchar2 default null
260 ,p_cag_information13 in varchar2 default null
261 ,p_cag_information14 in varchar2 default null
262 ,p_cag_information15 in varchar2 default null
263 ,p_cag_information16 in varchar2 default null
264 ,p_cag_information17 in varchar2 default null
265 ,p_cag_information18 in varchar2 default null
266 ,p_cag_information19 in varchar2 default null
267 ,p_cag_information20 in varchar2 default null
268 ,p_attribute_category in varchar2 default null
269 ,p_attribute1 in varchar2 default null
270 ,p_attribute2 in varchar2 default null
271 ,p_attribute3 in varchar2 default null
272 ,p_attribute4 in varchar2 default null
273 ,p_attribute5 in varchar2 default null
274 ,p_attribute6 in varchar2 default null
275 ,p_attribute7 in varchar2 default null
276 ,p_attribute8 in varchar2 default null
277 ,p_attribute9 in varchar2 default null
278 ,p_attribute10 in varchar2 default null
279 ,p_attribute11 in varchar2 default null
280 ,p_attribute12 in varchar2 default null
281 ,p_attribute13 in varchar2 default null
282 ,p_attribute14 in varchar2 default null
283 ,p_attribute15 in varchar2 default null
284 ,p_attribute16 in varchar2 default null
285 ,p_attribute17 in varchar2 default null
286 ,p_attribute18 in varchar2 default null
287 ,p_attribute19 in varchar2 default null
288 ,p_attribute20 in varchar2 default null
289 ); */
290 --
291 -- ----------------------------------------------------------------------------
292 -- |-----------------------< update_collective_agreement >--------------------|
293 -- ----------------------------------------------------------------------------
294 --
295 -- {Start Of Comments}
296 /*#
297 * This API updates a collective agreement.
298 *
299 * A collective agreement is a set of terms and conditions of employment which
300 * have been collectively agreed, usually through a process of negotiation, by
301 * the parties which participate in the employment relationship. This normally
302 * means that representatives of trades unions, employers and potentially
303 * employees have formed a tri-partite body to specifically agree the terms of
304 * employment. Collective agreements may be formed at various levels; they may
308 * by' multiple collective agreements at any one time.
305 * span multiple industries, or particular industries, or a specific industrial
306 * sector, or they may even be specific to a particular employer or type of
307 * employee within an industry. As such an employee or employer may be 'covered
309 *
310 * <p><b>Licensing</b><br>
311 * This API is licensed for use with Human Resources.
312 *
313 * <p><b>Prerequisites</b><br>
314 * The collective agreement to be updated must exist.
315 *
316 * <p><b>Post Success</b><br>
317 * The collective agreement is updated.
318 *
319 * <p><b>Post Failure</b><br>
320 * The collective agreement is not updated and an error is raised.
321 * @param p_validate If true, then validation alone will be performed and the
322 * database will remain unchanged. If false and all validation checks pass,
323 * then the database will be modified.
324 * @param p_collective_agreement_id Uniquely identifies the collective
325 * agreement to be updated.
326 * @param p_business_group_id Business Group of Record
327 * @param p_object_version_number Pass in the current version number of the
328 * collective agreement to be updated. When the API completes if p_validate is
329 * false, will be set to the new version number of the updated collective
330 * agreement. If p_validate is true will be set to the same value which was
331 * passed in.
332 * @param p_name The name of the collective agreement.
333 * @param p_status Indicates whether the collective agreement is active or not.
334 * Valid values are defined by the 'CAGR_STATUS' lookup type.
335 * @param p_cag_number The number of the collective agreement.
336 * @param p_description This description of the collective agreement in terms
337 * of its purpose and the groups of people it covers.
338 * @param p_start_date The date upon which the collective agreement comes into
339 * effect.
340 * @param p_end_date The date until which the collective agreement is in
341 * effect.
342 * @param p_employer_organization_id Uniquely identifies the employer
343 * organization which agreed and is bound by this agreement.
344 * @param p_employer_signatory The person who signed the agreement on behalf of
345 * the employer.
346 * @param p_bargaining_organization_id Uniquely identifies the bargaining
347 * organization (trade union) which is agreed and bound by this agreement.
348 * @param p_bargaining_unit_signatory The name of the person who signed the
349 * agreement on behalf of the bargaining unit.
350 * @param p_jurisdiction The jurisdiction of the collective agreement.
351 * @param p_authorizing_body The name of the public or official body which
352 * authorized the agreement.
353 * @param p_authorized_date The date the collective agreement was authorized by
354 * the authorizing body.
355 * @param p_cag_information_category This context value determines which
356 * Flexfield Structure to use with the Developer Descriptive flexfield
357 * segments.
358 * @param p_cag_information1 Developer Descriptive flexfield segment.
359 * @param p_cag_information2 Developer Descriptive flexfield segment.
360 * @param p_cag_information3 Developer Descriptive flexfield segment.
361 * @param p_cag_information4 Developer Descriptive flexfield segment.
362 * @param p_cag_information5 Developer Descriptive flexfield segment.
363 * @param p_cag_information6 Developer Descriptive flexfield segment.
364 * @param p_cag_information7 Developer Descriptive flexfield segment.
365 * @param p_cag_information8 Developer Descriptive flexfield segment.
366 * @param p_cag_information9 Developer Descriptive flexfield segment.
367 * @param p_cag_information10 Developer Descriptive flexfield segment.
368 * @param p_cag_information11 Developer Descriptive flexfield segment.
369 * @param p_cag_information12 Developer Descriptive flexfield segment.
370 * @param p_cag_information13 Developer Descriptive flexfield segment.
371 * @param p_cag_information14 Developer Descriptive flexfield segment.
372 * @param p_cag_information15 Developer Descriptive flexfield segment.
373 * @param p_cag_information16 Developer Descriptive flexfield segment.
374 * @param p_cag_information17 Developer Descriptive flexfield segment.
375 * @param p_cag_information18 Developer Descriptive flexfield segment.
376 * @param p_cag_information19 Developer Descriptive flexfield segment.
377 * @param p_cag_information20 Developer Descriptive flexfield segment.
378 * @param p_attribute_category This context value determines which flexfield
379 * structure to use with the descriptive flexfield segments.
380 * @param p_attribute1 Descriptive flexfield segment.
381 * @param p_attribute2 Descriptive flexfield segment.
382 * @param p_attribute3 Descriptive flexfield segment.
383 * @param p_attribute4 Descriptive flexfield segment.
384 * @param p_attribute5 Descriptive flexfield segment.
385 * @param p_attribute6 Descriptive flexfield segment.
386 * @param p_attribute7 Descriptive flexfield segment.
387 * @param p_attribute8 Descriptive flexfield segment.
388 * @param p_attribute9 Descriptive flexfield segment.
389 * @param p_attribute10 Descriptive flexfield segment.
390 * @param p_attribute11 Descriptive flexfield segment.
391 * @param p_attribute12 Descriptive flexfield segment.
392 * @param p_attribute13 Descriptive flexfield segment.
393 * @param p_attribute14 Descriptive flexfield segment.
394 * @param p_attribute15 Descriptive flexfield segment.
395 * @param p_attribute16 Descriptive flexfield segment.
396 * @param p_attribute17 Descriptive flexfield segment.
397 * @param p_attribute18 Descriptive flexfield segment.
398 * @param p_attribute19 Descriptive flexfield segment.
399 * @param p_attribute20 Descriptive flexfield segment.
403 * @rep:scope public
400 * @rep:displayname Update Collective Agreement
401 * @rep:category BUSINESS_ENTITY PER_COLLECTIVE_AGREEMENT
402 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
404 * @rep:lifecycle active
405 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
406 */
407 --
408 -- {End Of Comments}
409 --
410 procedure update_collective_agreement
411 (
412 p_validate in boolean default false
413 ,p_collective_agreement_id in number
414 ,p_business_group_id in number default hr_api.g_number
415 ,p_object_version_number in out nocopy number
416 ,p_name in varchar2 default hr_api.g_varchar2
417 ,p_status in varchar2 default hr_api.g_varchar2
418 ,p_cag_number in number default hr_api.g_number
419 ,p_description in varchar2 default hr_api.g_varchar2
420 ,p_start_date in date default hr_api.g_date
421 ,p_end_date in date default hr_api.g_date
422 ,p_employer_organization_id in number default hr_api.g_number
423 ,p_employer_signatory in varchar2 default hr_api.g_varchar2
424 ,p_bargaining_organization_id in number default hr_api.g_number
425 ,p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2
426 ,p_jurisdiction in varchar2 default hr_api.g_varchar2
427 ,p_authorizing_body in varchar2 default hr_api.g_varchar2
428 ,p_authorized_date in date default hr_api.g_date
429 ,p_cag_information_category in varchar2 default hr_api.g_varchar2
430 ,p_cag_information1 in varchar2 default hr_api.g_varchar2
431 ,p_cag_information2 in varchar2 default hr_api.g_varchar2
432 ,p_cag_information3 in varchar2 default hr_api.g_varchar2
433 ,p_cag_information4 in varchar2 default hr_api.g_varchar2
434 ,p_cag_information5 in varchar2 default hr_api.g_varchar2
435 ,p_cag_information6 in varchar2 default hr_api.g_varchar2
436 ,p_cag_information7 in varchar2 default hr_api.g_varchar2
437 ,p_cag_information8 in varchar2 default hr_api.g_varchar2
438 ,p_cag_information9 in varchar2 default hr_api.g_varchar2
439 ,p_cag_information10 in varchar2 default hr_api.g_varchar2
440 ,p_cag_information11 in varchar2 default hr_api.g_varchar2
441 ,p_cag_information12 in varchar2 default hr_api.g_varchar2
442 ,p_cag_information13 in varchar2 default hr_api.g_varchar2
443 ,p_cag_information14 in varchar2 default hr_api.g_varchar2
444 ,p_cag_information15 in varchar2 default hr_api.g_varchar2
445 ,p_cag_information16 in varchar2 default hr_api.g_varchar2
446 ,p_cag_information17 in varchar2 default hr_api.g_varchar2
447 ,p_cag_information18 in varchar2 default hr_api.g_varchar2
448 ,p_cag_information19 in varchar2 default hr_api.g_varchar2
449 ,p_cag_information20 in varchar2 default hr_api.g_varchar2
450 ,p_attribute_category in varchar2 default hr_api.g_varchar2
451 ,p_attribute1 in varchar2 default hr_api.g_varchar2
452 ,p_attribute2 in varchar2 default hr_api.g_varchar2
453 ,p_attribute3 in varchar2 default hr_api.g_varchar2
454 ,p_attribute4 in varchar2 default hr_api.g_varchar2
455 ,p_attribute5 in varchar2 default hr_api.g_varchar2
456 ,p_attribute6 in varchar2 default hr_api.g_varchar2
457 ,p_attribute7 in varchar2 default hr_api.g_varchar2
458 ,p_attribute8 in varchar2 default hr_api.g_varchar2
459 ,p_attribute9 in varchar2 default hr_api.g_varchar2
460 ,p_attribute10 in varchar2 default hr_api.g_varchar2
461 ,p_attribute11 in varchar2 default hr_api.g_varchar2
462 ,p_attribute12 in varchar2 default hr_api.g_varchar2
463 ,p_attribute13 in varchar2 default hr_api.g_varchar2
464 ,p_attribute14 in varchar2 default hr_api.g_varchar2
465 ,p_attribute15 in varchar2 default hr_api.g_varchar2
466 ,p_attribute16 in varchar2 default hr_api.g_varchar2
467 ,p_attribute17 in varchar2 default hr_api.g_varchar2
468 ,p_attribute18 in varchar2 default hr_api.g_varchar2
469 ,p_attribute19 in varchar2 default hr_api.g_varchar2
470 ,p_attribute20 in varchar2 default hr_api.g_varchar2
471 );
472 --
473 -- ----------------------------------------------------------------------------
474 -- |-----------------------< delete_collective_agreement >--------------------|
475 -- ----------------------------------------------------------------------------
476 --
477 -- {Start Of Comments}
478 /*#
479 * This API deletes a collective agreement.
480 *
481 * A collective agreement is a set of terms and conditions of employment which
482 * have been collectively agreed, usually through a process of negotiation, by
483 * the parties which participate in the employment relationship. This normally
484 * means that representatives of trades unions, employers and potentially
485 * employees have formed a tri-partite body to specifically agree the terms of
486 * employment. Collective agreements may be formed at various levels; they may
487 * span multiple industries, or particular industries, or a specific industrial
488 * sector, or they may even be specific to a particular employer or type of
489 * employee within an industry. As such an employee or employer may be 'covered
490 * by' multiple collective agreements at any one time.
491 *
492 * <p><b>Licensing</b><br>
493 * This API is licensed for use with Human Resources.
494 *
495 * <p><b>Prerequisites</b><br>
496 * The collective agreement to be deleted must exist.
497 *
498 * <p><b>Post Success</b><br>
499 * The collective agreement is deleted.
500 *
501 * <p><b>Post Failure</b><br>
502 * The collective agreement is not deleted and an error is raised.
503 * @param p_validate If true, then validation alone will be performed and the
504 * database will remain unchanged. If false and all validation checks pass,
505 * then the database will be modified.
506 * @param p_collective_agreement_id Uniquely identifies the collective
507 * agreement to be deleted.
508 * @param p_object_version_number Current version number of the collective
509 * agreement to be deleted.
510 * @rep:displayname Delete Collective Agreement
511 * @rep:category BUSINESS_ENTITY PER_COLLECTIVE_AGREEMENT
512 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
513 * @rep:scope public
514 * @rep:lifecycle active
515 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
516 */
517 --
518 -- {End Of Comments}
519 --
520 procedure delete_collective_agreement
521 (
522 p_validate in boolean default false
523 ,p_collective_agreement_id in number
524 ,p_object_version_number in out nocopy number
525 );
526 --
527 -- ----------------------------------------------------------------------------
528 -- |----------------------------------< lck >---------------------------------|
529 -- ----------------------------------------------------------------------------
530 -- {Start Of Comments}
531 --
532 -- Description:
533 --
534 -- Prerequisites:
535 --
536 --
537 -- In Parameters:
538 -- Name Reqd Type Description
539 -- p_collective_agreement_id Yes number PK of record
540 -- p_object_version_number Yes number OVN of record
541 --
542 -- Post Success:
543 --
544 -- Name Type Description
545 --
546 -- Post Failure:
547 --
548 -- Access Status:
549 -- Public.
550 --
551 -- {End Of Comments}
552 --
553 procedure lck
554 (
555 p_collective_agreement_id in number
556 ,p_object_version_number in number
557 );
558 --
559 end hr_collective_agreement_api;