[Home] [Help]
PACKAGE BODY: APPS.PQH_CORPS_DEFINITIONS_API
Source
1 Package body pqh_corps_definitions_api as
2 /* $Header: pqcpdapi.pkb 115.4 2003/11/13 07:05:05 kgowripe noship $ */
3 g_package varchar2(33) := 'pqh_corps_definitions_api.';
4 --
5 -- ----------------------------------------------------------------------------
6 -- |------------------------< create_corps_definition >------------------------|
7 -- ----------------------------------------------------------------------------
8 -- {Start Of Comments}
9 --
10 -- Description:
11 --
12 -- Prerequisites:
13 --
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 -- p_validate YES boolean Commit or Rollback
18 -- p_effective_date YES date
19 -- p_business_group_id NO number
20 -- p_name NO varchar2
21 -- p_status_cd NO varchar2
22 -- p_retirement_age NO number
23 -- p_category_cd NO varchar2
24 -- p_starting_grade_step_id NO number
25 -- p_type_of_ps NO varchar2
26 -- p_task_desc NO varchar2
27 -- p_secondment_threshold NO number
28 -- p_normal_hours NO number3
29 -- p_normal_hours_frequency NO varchar2
30 -- p_minimum_hours NO number
31 -- p_minimum_hours_frequency NO varchar2
32 -- p_attribute1 NO varchar2
33 -- p_attribute2 NO varchar2
34 -- p_attribute3 NO varchar2
35 -- p_attribute4 NO varchar2
36 -- p_attribute5 NO varchar2
37 -- p_attribute6 NO varchar2
38 -- p_attribute7 NO varchar2
39 -- p_attribute8 NO varchar2
40 -- p_attribute9 NO varchar2
41 -- p_attribute10 NO varchar2
42 -- p_attribute11 NO varchar2
43 -- p_attribute12 NO varchar2
44 -- p_attribute13 NO varchar2
45 -- p_attribute14 NO varchar2
46 -- p_attribute15 NO varchar2
47 -- p_attribute16 NO varchar2
48 -- p_attribute17 NO varchar2
49 -- p_attribute18 NO varchar2
50 -- p_attribute19 NO varchar2
51 -- p_attribute20 NO varchar2
52 -- p_attribute21 NO varchar2
53 -- p_attribute22 NO varchar2
54 -- p_attribute23 NO varchar2
55 -- p_attribute24 NO varchar2
56 -- p_attribute25 NO varchar2
57 -- p_attribute26 NO varchar2
58 -- p_attribute27 NO varchar2
59 -- p_attribute28 NO varchar2
60 -- p_attribute29 NO varchar2
61 -- p_attribute30 NO varchar2
62 -- p_attribute_category NO varchar2
63 -- p_primary_prof_field_id NO number
64 -- p_starting_grade_id NO number
65 -- p_ben_pgm_id NO number
66 -- p_probation_period NO number
67 -- p_probation_units NO varchar2
68
69 -- Post Success:
70 --
71 -- Out Parameters:
72 -- Name Reqd Type Description
73 -- p_object_version_number Yes number OVN of record
74 -- p_corps_definition_id Yes number
75 --
76 -- Post Failure:
77 --
78 -- Access Status:
79 -- Public.
80 --
81 -- {End Of Comments}
82 --
83 procedure create_corps_definition
84 (
85 p_validate in boolean default false
86 ,p_effective_date in date
87 ,p_corps_definition_id out nocopy number
88 ,p_business_group_id in number
89 ,p_name in varchar2
90 ,p_status_cd in varchar2
91 ,p_retirement_age in number default null
92 ,p_category_cd in varchar2
93 ,p_corps_type_cd in varchar2
94 ,p_date_from in date
95 ,p_date_to in date default null
96 ,p_recruitment_end_date in date default null
97 ,p_starting_grade_step_id in number default null
98 ,p_type_of_ps in varchar2 default null
99 ,p_task_desc in varchar2 default null
100 ,p_secondment_threshold in number default null
101 ,p_normal_hours in number default null
102 ,p_normal_hours_frequency in varchar2 default null
103 ,p_minimum_hours in number default null
104 ,p_minimum_hours_frequency in varchar2 default null
105 ,p_attribute1 in varchar2 default null
106 ,p_attribute2 in varchar2 default null
107 ,p_attribute3 in varchar2 default null
108 ,p_attribute4 in varchar2 default null
109 ,p_attribute5 in varchar2 default null
110 ,p_attribute6 in varchar2 default null
111 ,p_attribute7 in varchar2 default null
112 ,p_attribute8 in varchar2 default null
113 ,p_attribute9 in varchar2 default null
114 ,p_attribute10 in varchar2 default null
115 ,p_attribute11 in varchar2 default null
116 ,p_attribute12 in varchar2 default null
117 ,p_attribute13 in varchar2 default null
118 ,p_attribute14 in varchar2 default null
119 ,p_attribute15 in varchar2 default null
120 ,p_attribute16 in varchar2 default null
121 ,p_attribute17 in varchar2 default null
122 ,p_attribute18 in varchar2 default null
123 ,p_attribute19 in varchar2 default null
124 ,p_attribute20 in varchar2 default null
125 ,p_attribute21 in varchar2 default null
126 ,p_attribute22 in varchar2 default null
127 ,p_attribute23 in varchar2 default null
128 ,p_attribute24 in varchar2 default null
129 ,p_attribute25 in varchar2 default null
130 ,p_attribute26 in varchar2 default null
131 ,p_attribute27 in varchar2 default null
132 ,p_attribute28 in varchar2 default null
133 ,p_attribute29 in varchar2 default null
134 ,p_attribute30 in varchar2 default null
135 ,p_attribute_category in varchar2 default null
136 ,p_object_version_number out nocopy number
137 ,p_primary_prof_field_id in number default null
138 ,p_starting_grade_id in number default null
139 ,p_ben_pgm_id in number default null
140 ,p_probation_period in number default null
141 ,p_probation_units in varchar2 default null
142 ) is
143 --
144 -- Declare cursors and local variables
145 --
146 l_corps_definition_id pqh_corps_definitions.corps_definition_id%TYPE;
147 l_proc varchar2(72) := g_package||'create_corps_definition';
148 l_object_version_number pqh_corps_definitions.object_version_number%TYPE;
149 --
150 begin
151 --
152 hr_utility.set_location('Entering:'|| l_proc, 10);
153 --
154 -- Issue a savepoint if operating in validation only mode
155 --
156 savepoint create_corps_definition;
157 --
158 hr_utility.set_location(l_proc, 20);
159 --
160 -- Process Logic
161 --
162 begin
163 --
167 p_effective_date => trunc(p_effective_date)
164 -- Start of API User Hook for the before hook of create_corps_definition
165 pqh_corps_definitions_bk1.create_corps_definition_b
166 (
168 ,p_business_group_id => p_business_group_id
169 ,p_name => p_name
170 ,p_status_cd => p_status_cd
171 ,p_retirement_age => p_retirement_age
172 ,p_category_cd => p_category_cd
173 ,p_corps_type_cd => p_corps_type_cd
174 ,p_date_from => p_date_from
175 ,p_date_to => p_date_to
176 ,p_recruitment_end_date => p_recruitment_end_date
177 ,p_starting_grade_step_id => p_starting_grade_step_id
178 ,p_type_of_ps => p_type_of_ps
179 ,p_task_desc => p_task_desc
180 ,p_secondment_threshold => p_secondment_threshold
181 ,p_normal_hours => p_normal_hours
182 ,p_normal_hours_frequency => p_normal_hours_frequency
183 ,p_minimum_hours => p_minimum_hours
184 ,p_minimum_hours_frequency => p_minimum_hours_frequency
185 ,p_attribute1 => p_attribute1
186 ,p_attribute2 => p_attribute2
187 ,p_attribute3 => p_attribute3
188 ,p_attribute4 => p_attribute4
189 ,p_attribute5 => p_attribute5
190 ,p_attribute6 => p_attribute6
191 ,p_attribute7 => p_attribute7
192 ,p_attribute8 => p_attribute8
193 ,p_attribute9 => p_attribute9
194 ,p_attribute10 => p_attribute10
195 ,p_attribute11 => p_attribute11
196 ,p_attribute12 => p_attribute12
197 ,p_attribute13 => p_attribute13
198 ,p_attribute14 => p_attribute14
199 ,p_attribute15 => p_attribute15
200 ,p_attribute16 => p_attribute16
201 ,p_attribute17 => p_attribute17
202 ,p_attribute18 => p_attribute18
203 ,p_attribute19 => p_attribute19
204 ,p_attribute20 => p_attribute20
205 ,p_attribute21 => p_attribute21
206 ,p_attribute22 => p_attribute22
207 ,p_attribute23 => p_attribute23
208 ,p_attribute24 => p_attribute24
209 ,p_attribute25 => p_attribute25
210 ,p_attribute26 => p_attribute26
211 ,p_attribute27 => p_attribute27
212 ,p_attribute28 => p_attribute28
213 ,p_attribute29 => p_attribute29
214 ,p_attribute30 => p_attribute30
215 ,p_attribute_category => p_attribute_category
216 ,p_primary_prof_field_id => p_primary_prof_field_id
217 ,p_starting_grade_id => p_starting_grade_id
218 ,p_ben_pgm_id => p_ben_pgm_id
219 ,p_probation_period => p_probation_period
220 ,p_probation_units => p_probation_units
221 );
222 exception
223 when hr_api.cannot_find_prog_unit then
224 hr_api.cannot_find_prog_unit_error
225 (
226 p_module_name => 'create_corps_definition'
227 ,p_hook_type => 'BP'
228 );
229 --
230 -- End of API User Hook for the before hook of create_corps_definition
231 --
232 end;
233
234 pqh_cpd_ins.ins
235 (
236 p_effective_date => trunc(p_effective_date)
237 ,p_corps_definition_id => l_corps_definition_id
238 ,p_object_version_number => l_object_version_number
239 ,p_business_group_id => p_business_group_id
240 ,p_name => p_name
241 ,p_status_cd => p_status_cd
242 ,p_retirement_age => p_retirement_age
243 ,p_category_cd => p_category_cd
244 ,p_corps_type_cd => p_corps_type_cd
245 ,p_date_from => p_date_from
246 ,p_date_to => p_date_to
247 ,p_recruitment_end_date => p_recruitment_end_date
248 ,p_starting_grade_step_id => p_starting_grade_step_id
249 ,p_type_of_ps => p_type_of_ps
250 ,p_task_desc => p_task_desc
251 ,p_secondment_threshold => p_secondment_threshold
252 ,p_normal_hours => p_normal_hours
253 ,p_normal_hours_frequency => p_normal_hours_frequency
254 ,p_minimum_hours => p_minimum_hours
255 ,p_minimum_hours_frequency => p_minimum_hours_frequency
256 ,p_attribute1 => p_attribute1
257 ,p_attribute2 => p_attribute2
258 ,p_attribute3 => p_attribute3
259 ,p_attribute4 => p_attribute4
260 ,p_attribute5 => p_attribute5
261 ,p_attribute6 => p_attribute6
262 ,p_attribute7 => p_attribute7
263 ,p_attribute8 => p_attribute8
264 ,p_attribute9 => p_attribute9
265 ,p_attribute10 => p_attribute10
266 ,p_attribute11 => p_attribute11
267 ,p_attribute12 => p_attribute12
268 ,p_attribute13 => p_attribute13
269 ,p_attribute14 => p_attribute14
270 ,p_attribute15 => p_attribute15
271 ,p_attribute16 => p_attribute16
272 ,p_attribute17 => p_attribute17
276 ,p_attribute21 => p_attribute21
273 ,p_attribute18 => p_attribute18
274 ,p_attribute19 => p_attribute19
275 ,p_attribute20 => p_attribute20
277 ,p_attribute22 => p_attribute22
278 ,p_attribute23 => p_attribute23
279 ,p_attribute24 => p_attribute24
280 ,p_attribute25 => p_attribute25
281 ,p_attribute26 => p_attribute26
282 ,p_attribute27 => p_attribute27
283 ,p_attribute28 => p_attribute28
284 ,p_attribute29 => p_attribute29
285 ,p_attribute30 => p_attribute30
286 ,p_attribute_category => p_attribute_category
287 ,p_primary_prof_field_id => p_primary_prof_field_id
288 ,p_starting_grade_id => p_starting_grade_id
289 ,p_ben_pgm_id => p_ben_pgm_id
290 ,p_probation_period => p_probation_period
291 ,p_probation_units => p_probation_units
292 );
293
294 begin
295 --
296 -- Start of API User Hook for the afetr hook of create_corps_definition
297 pqh_corps_definitions_bk1.create_corps_definition_a
298 (
299 p_effective_date => trunc(p_effective_date)
300 ,p_business_group_id => p_business_group_id
301 ,p_name => p_name
302 ,p_status_cd => p_status_cd
303 ,p_retirement_age => p_retirement_age
304 ,p_category_cd => p_category_cd
305 ,p_corps_type_cd => p_corps_type_cd
306 ,p_date_from => p_date_from
307 ,p_date_to => p_date_to
308 ,p_recruitment_end_date => p_recruitment_end_date
309 ,p_starting_grade_step_id => p_starting_grade_step_id
310 ,p_type_of_ps => p_type_of_ps
311 ,p_task_desc => p_task_desc
312 ,p_secondment_threshold => p_secondment_threshold
313 ,p_normal_hours => p_normal_hours
314 ,p_normal_hours_frequency => p_normal_hours_frequency
315 ,p_minimum_hours => p_minimum_hours
316 ,p_minimum_hours_frequency => p_minimum_hours_frequency
317 ,p_attribute1 => p_attribute1
318 ,p_attribute2 => p_attribute2
319 ,p_attribute3 => p_attribute3
320 ,p_attribute4 => p_attribute4
321 ,p_attribute5 => p_attribute5
322 ,p_attribute6 => p_attribute6
323 ,p_attribute7 => p_attribute7
324 ,p_attribute8 => p_attribute8
325 ,p_attribute9 => p_attribute9
326 ,p_attribute10 => p_attribute10
327 ,p_attribute11 => p_attribute11
328 ,p_attribute12 => p_attribute12
329 ,p_attribute13 => p_attribute13
330 ,p_attribute14 => p_attribute14
331 ,p_attribute15 => p_attribute15
332 ,p_attribute16 => p_attribute16
333 ,p_attribute17 => p_attribute17
334 ,p_attribute18 => p_attribute18
335 ,p_attribute19 => p_attribute19
336 ,p_attribute20 => p_attribute20
337 ,p_attribute21 => p_attribute21
338 ,p_attribute22 => p_attribute22
339 ,p_attribute23 => p_attribute23
340 ,p_attribute24 => p_attribute24
341 ,p_attribute25 => p_attribute25
342 ,p_attribute26 => p_attribute26
343 ,p_attribute27 => p_attribute27
344 ,p_attribute28 => p_attribute28
345 ,p_attribute29 => p_attribute29
346 ,p_attribute30 => p_attribute30
347 ,p_attribute_category => p_attribute_category
348 ,p_primary_prof_field_id => p_primary_prof_field_id
349 ,p_starting_grade_id => p_starting_grade_id
350 ,p_ben_pgm_id => p_ben_pgm_id
351 ,p_probation_period => p_probation_period
352 ,p_probation_units => p_probation_units
353 );
354 exception
355 when hr_api.cannot_find_prog_unit then
356 hr_api.cannot_find_prog_unit_error
357 (
358 p_module_name => 'create_corps_definition'
359 ,p_hook_type => 'AP'
360 );
361 --
362 -- End of API User Hook for the after hook of create_corps_definition
363 --
364 end;
365
366 --
367 hr_utility.set_location(l_proc, 60);
368 --
369 -- When in validation only mode raise the Validate_Enabled exception
370 --
371 if p_validate then
372 raise hr_api.validate_enabled;
373 end if;
374 --
375 -- Set all output arguments
376 --
377 p_corps_definition_id := l_corps_definition_id;
378 p_object_version_number := l_object_version_number;
379 --
380 hr_utility.set_location(' Leaving:'||l_proc, 70);
381 --
382 exception
383 --
384 when hr_api.validate_enabled then
385 --
386 -- As the Validate_Enabled exception has been raised
387 -- we must rollback to the savepoint
388 --
389 ROLLBACK TO create_corps_definition;
390 --
391 -- Only set output warning arguments
392 -- (Any key or derived arguments must be set to null
393 -- when validation only mode is being used.)
394 --
395 p_corps_definition_id := null;
399 when others then
396 p_object_version_number := null;
397 hr_utility.set_location(' Leaving:'||l_proc, 80);
398 --
400 p_corps_definition_id := null;
401 p_object_version_number := null;
402 --
403 -- A validation or unexpected error has occured
404 --
405 ROLLBACK TO create_corps_definition;
406 raise;
407 --
408 end create_corps_definition;
409
410 -- ----------------------------------------------------------------------------
411 -- |------------------------< update_corps_definition >------------------------|
412 -- ----------------------------------------------------------------------------
413 -- {Start Of Comments}
414 --
415 -- Description:
416 --
417 -- Prerequisites:
418 --
419 --
420 -- In Parameters:
421 --
422 -- Name Reqd Type Description
423 -- p_validate YES boolean Commit or Rollback
424 -- p_corps_definition_id YES number PK of record
425 -- p_effective_date YES date
426 -- p_business_group_id NO number
427 -- p_name NO varchar2
428 -- p_status_cd NO varchar2
429 -- p_retirement_age NO number
430 -- p_category_cd NO varchar2
431 -- p_starting_grade_step_id NO number
432 -- p_type_of_ps NO varchar2
433 -- p_task_desc NO varchar2
434 -- p_secondment_threshold NO number
435 -- p_normal_hours NO number3
436 -- p_normal_hours_frequency NO varchar2
437 -- p_minimum_hours NO number
438 -- p_minimum_hours_frequency NO varchar2
439 -- p_attribute1 NO varchar2
440 -- p_attribute2 NO varchar2
441 -- p_attribute3 NO varchar2
442 -- p_attribute4 NO varchar2
443 -- p_attribute5 NO varchar2
444 -- p_attribute6 NO varchar2
445 -- p_attribute7 NO varchar2
446 -- p_attribute8 NO varchar2
447 -- p_attribute9 NO varchar2
448 -- p_attribute10 NO varchar2
449 -- p_attribute11 NO varchar2
450 -- p_attribute12 NO varchar2
451 -- p_attribute13 NO varchar2
452 -- p_attribute14 NO varchar2
453 -- p_attribute15 NO varchar2
454 -- p_attribute16 NO varchar2
455 -- p_attribute17 NO varchar2
456 -- p_attribute18 NO varchar2
457 -- p_attribute19 NO varchar2
458 -- p_attribute20 NO varchar2
459 -- p_attribute21 NO varchar2
460 -- p_attribute22 NO varchar2
461 -- p_attribute23 NO varchar2
462 -- p_attribute24 NO varchar2
463 -- p_attribute25 NO varchar2
464 -- p_attribute26 NO varchar2
465 -- p_attribute27 NO varchar2
466 -- p_attribute28 NO varchar2
467 -- p_attribute29 NO varchar2
468 -- p_attribute30 NO varchar2
469 -- p_attribute_category NO varchar2
470 -- p_primary_prof_field_id NO number
471 -- p_starting_grade_id NO number
472 -- p_ben_pgm_id NO number
473 -- p_probation_period NO number
474 -- p_probation_units NO varchar2
475 --
476 -- Post Success:
477 --
478 -- Name Type Description
479 -- p_object_version_number Yes number OVN of record
480 --
481 -- Post Failure:
482 --
483 -- Access Status:
484 -- Public.
485 --
486 -- {End Of Comments}
487 --
488 procedure update_corps_definition
489 (
490 p_validate in boolean default false
491 ,p_effective_date in date
492 ,p_corps_definition_id in number
493 ,p_business_group_id in number default hr_api.g_number
494 ,p_name in varchar2 default hr_api.g_varchar2
495 ,p_status_cd in varchar2 default hr_api.g_varchar2
496 ,p_retirement_age in number default hr_api.g_number
497 ,p_category_cd in varchar2 default hr_api.g_varchar2
498 ,p_starting_grade_step_id in number default hr_api.g_number
499 ,p_type_of_ps in varchar2 default hr_api.g_varchar2
500 ,p_corps_type_cd in varchar2 default hr_api.g_varchar2
501 ,p_date_from in date default hr_api.g_date
502 ,p_date_to in date default hr_api.g_date
503 ,p_recruitment_end_date in date default hr_api.g_date
504 ,p_task_desc in varchar2 default hr_api.g_varchar2
505 ,p_secondment_threshold in number default hr_api.g_number
506 ,p_normal_hours in number default hr_api.g_number
507 ,p_normal_hours_frequency in varchar2 default hr_api.g_varchar2
508 ,p_minimum_hours in number default hr_api.g_number
509 ,p_minimum_hours_frequency in varchar2 default hr_api.g_varchar2
510 ,p_attribute1 in varchar2 default hr_api.g_varchar2
511 ,p_attribute2 in varchar2 default hr_api.g_varchar2
512 ,p_attribute3 in varchar2 default hr_api.g_varchar2
516 ,p_attribute7 in varchar2 default hr_api.g_varchar2
513 ,p_attribute4 in varchar2 default hr_api.g_varchar2
514 ,p_attribute5 in varchar2 default hr_api.g_varchar2
515 ,p_attribute6 in varchar2 default hr_api.g_varchar2
517 ,p_attribute8 in varchar2 default hr_api.g_varchar2
518 ,p_attribute9 in varchar2 default hr_api.g_varchar2
519 ,p_attribute10 in varchar2 default hr_api.g_varchar2
520 ,p_attribute11 in varchar2 default hr_api.g_varchar2
521 ,p_attribute12 in varchar2 default hr_api.g_varchar2
522 ,p_attribute13 in varchar2 default hr_api.g_varchar2
523 ,p_attribute14 in varchar2 default hr_api.g_varchar2
524 ,p_attribute15 in varchar2 default hr_api.g_varchar2
525 ,p_attribute16 in varchar2 default hr_api.g_varchar2
526 ,p_attribute17 in varchar2 default hr_api.g_varchar2
527 ,p_attribute18 in varchar2 default hr_api.g_varchar2
528 ,p_attribute19 in varchar2 default hr_api.g_varchar2
529 ,p_attribute20 in varchar2 default hr_api.g_varchar2
530 ,p_attribute21 in varchar2 default hr_api.g_varchar2
531 ,p_attribute22 in varchar2 default hr_api.g_varchar2
532 ,p_attribute23 in varchar2 default hr_api.g_varchar2
533 ,p_attribute24 in varchar2 default hr_api.g_varchar2
534 ,p_attribute25 in varchar2 default hr_api.g_varchar2
535 ,p_attribute26 in varchar2 default hr_api.g_varchar2
536 ,p_attribute27 in varchar2 default hr_api.g_varchar2
537 ,p_attribute28 in varchar2 default hr_api.g_varchar2
538 ,p_attribute29 in varchar2 default hr_api.g_varchar2
539 ,p_attribute30 in varchar2 default hr_api.g_varchar2
540 ,p_attribute_category in varchar2 default hr_api.g_varchar2
541 ,p_object_version_number in out nocopy number
542 ,p_primary_prof_field_id in number default hr_api.g_number
543 ,p_starting_grade_id in number default hr_api.g_number
544 ,p_ben_pgm_id in number default hr_api.g_number
545 ,p_probation_period in number default hr_api.g_number
546 ,p_probation_units in varchar2 default hr_api.g_varchar2
547 ) is
548 --
549 -- Declare cursors and local variables
550 --
551 l_proc varchar2(72) := g_package||'update_corps_definition';
552 l_object_version_number pqh_corps_definitions.object_version_number%TYPE;
553 --
554 begin
555 --
556 hr_utility.set_location('Entering:'|| l_proc, 10);
557 --
558 -- Issue a savepoint if operating in validation only mode
559 --
560 savepoint update_corps_definition;
561 --
562 hr_utility.set_location(l_proc, 20);
563 --
564 -- Process Logic
565 l_object_version_number := p_object_version_number;
566 --
567 begin
568 --
569 -- Start of API User Hook for the before hook of update_corps_definition
570 pqh_corps_definitions_bk2.update_corps_definition_b
571 (
572 p_effective_date => trunc(p_effective_date)
573 ,p_corps_definition_id => p_corps_definition_id
574 ,p_business_group_id => p_business_group_id
575 ,p_object_version_number => p_object_version_number
576 ,p_name => p_name
577 ,p_status_cd => p_status_cd
578 ,p_retirement_age => p_retirement_age
579 ,p_category_cd => p_category_cd
580 ,p_starting_grade_step_id => p_starting_grade_step_id
581 ,p_corps_type_cd => p_corps_type_cd
582 ,p_date_from => p_date_from
583 ,p_date_to => p_date_to
584 ,p_recruitment_end_date => p_recruitment_end_date
585 ,p_type_of_ps => p_type_of_ps
586 ,p_task_desc => p_task_desc
587 ,p_secondment_threshold => p_secondment_threshold
588 ,p_normal_hours => p_normal_hours
589 ,p_normal_hours_frequency => p_normal_hours_frequency
590 ,p_minimum_hours => p_minimum_hours
591 ,p_minimum_hours_frequency => p_minimum_hours_frequency
592 ,p_attribute1 => p_attribute1
593 ,p_attribute2 => p_attribute2
594 ,p_attribute3 => p_attribute3
595 ,p_attribute4 => p_attribute4
596 ,p_attribute5 => p_attribute5
597 ,p_attribute6 => p_attribute6
598 ,p_attribute7 => p_attribute7
599 ,p_attribute8 => p_attribute8
600 ,p_attribute9 => p_attribute9
601 ,p_attribute10 => p_attribute10
602 ,p_attribute11 => p_attribute11
603 ,p_attribute12 => p_attribute12
604 ,p_attribute13 => p_attribute13
605 ,p_attribute14 => p_attribute14
606 ,p_attribute15 => p_attribute15
607 ,p_attribute16 => p_attribute16
608 ,p_attribute17 => p_attribute17
609 ,p_attribute18 => p_attribute18
610 ,p_attribute19 => p_attribute19
611 ,p_attribute20 => p_attribute20
612 ,p_attribute21 => p_attribute21
613 ,p_attribute22 => p_attribute22
614 ,p_attribute23 => p_attribute23
615 ,p_attribute24 => p_attribute24
616 ,p_attribute25 => p_attribute25
617 ,p_attribute26 => p_attribute26
618 ,p_attribute27 => p_attribute27
619 ,p_attribute28 => p_attribute28
620 ,p_attribute29 => p_attribute29
621 ,p_attribute30 => p_attribute30
622 ,p_attribute_category => p_attribute_category
623 ,p_primary_prof_field_id => p_primary_prof_field_id
624 ,p_starting_grade_id => p_starting_grade_id
625 ,p_ben_pgm_id => p_ben_pgm_id
626 ,p_probation_period => p_probation_period
627 ,p_probation_units => p_probation_units
628 );
629 exception
630 when hr_api.cannot_find_prog_unit then
631 hr_api.cannot_find_prog_unit_error
632 (
633 p_module_name => 'update_corps_definition'
634 ,p_hook_type => 'BP'
635 );
636 --
637 -- End of API User Hook for the before hook of update_corps_definition
638 --
639 end;
640 pqh_cpd_upd.upd
641 (
642 p_effective_date => trunc(p_effective_date)
643 ,p_corps_definition_id => p_corps_definition_id
644 ,p_object_version_number => l_object_version_number
645 ,p_business_group_id => p_business_group_id
646 ,p_name => p_name
647 ,p_status_cd => p_status_cd
648 ,p_retirement_age => p_retirement_age
649 ,p_category_cd => p_category_cd
650 ,p_starting_grade_step_id => p_starting_grade_step_id
651 ,p_corps_type_cd => p_corps_type_cd
652 ,p_date_from => p_date_from
653 ,p_date_to => p_date_to
654 ,p_recruitment_end_date => p_recruitment_end_date
655 ,p_type_of_ps => p_type_of_ps
656 ,p_task_desc => p_task_desc
657 ,p_secondment_threshold => p_secondment_threshold
658 ,p_normal_hours => p_normal_hours
659 ,p_normal_hours_frequency => p_normal_hours_frequency
660 ,p_minimum_hours => p_minimum_hours
661 ,p_minimum_hours_frequency => p_minimum_hours_frequency
662 ,p_attribute1 => p_attribute1
663 ,p_attribute2 => p_attribute2
664 ,p_attribute3 => p_attribute3
665 ,p_attribute4 => p_attribute4
666 ,p_attribute5 => p_attribute5
667 ,p_attribute6 => p_attribute6
668 ,p_attribute7 => p_attribute7
669 ,p_attribute8 => p_attribute8
670 ,p_attribute9 => p_attribute9
671 ,p_attribute10 => p_attribute10
672 ,p_attribute11 => p_attribute11
673 ,p_attribute12 => p_attribute12
674 ,p_attribute13 => p_attribute13
675 ,p_attribute14 => p_attribute14
676 ,p_attribute15 => p_attribute15
677 ,p_attribute16 => p_attribute16
678 ,p_attribute17 => p_attribute17
679 ,p_attribute18 => p_attribute18
680 ,p_attribute19 => p_attribute19
681 ,p_attribute20 => p_attribute20
682 ,p_attribute21 => p_attribute21
683 ,p_attribute22 => p_attribute22
684 ,p_attribute23 => p_attribute23
685 ,p_attribute24 => p_attribute24
686 ,p_attribute25 => p_attribute25
690 ,p_attribute29 => p_attribute29
687 ,p_attribute26 => p_attribute26
688 ,p_attribute27 => p_attribute27
689 ,p_attribute28 => p_attribute28
691 ,p_attribute30 => p_attribute30
692 ,p_attribute_category => p_attribute_category
693 ,p_primary_prof_field_id => p_primary_prof_field_id
694 ,p_starting_grade_id => p_starting_grade_id
695 ,p_ben_pgm_id => p_ben_pgm_id
696 ,p_probation_period => p_probation_period
697 ,p_probation_units => p_probation_units
698 );
699
700 begin
701 --
702 -- Start of API User Hook for the afetr hook of update_corps_definition
703 pqh_corps_definitions_bk2.update_corps_definition_a
704 (
705 p_effective_date => trunc(p_effective_date)
706 ,p_corps_definition_id => p_corps_definition_id
707 ,p_business_group_id => p_business_group_id
708 ,p_object_version_number => l_object_version_number
709 ,p_name => p_name
710 ,p_status_cd => p_status_cd
711 ,p_retirement_age => p_retirement_age
712 ,p_category_cd => p_category_cd
713 ,p_corps_type_cd => p_corps_type_cd
714 ,p_date_from => p_date_from
715 ,p_date_to => p_date_to
716 ,p_recruitment_end_date => p_recruitment_end_date
717 ,p_starting_grade_step_id => p_starting_grade_step_id
718 ,p_type_of_ps => p_type_of_ps
719 ,p_task_desc => p_task_desc
720 ,p_secondment_threshold => p_secondment_threshold
721 ,p_normal_hours => p_normal_hours
722 ,p_normal_hours_frequency => p_normal_hours_frequency
723 ,p_minimum_hours => p_minimum_hours
724 ,p_minimum_hours_frequency => p_minimum_hours_frequency
725 ,p_attribute1 => p_attribute1
726 ,p_attribute2 => p_attribute2
727 ,p_attribute3 => p_attribute3
728 ,p_attribute4 => p_attribute4
729 ,p_attribute5 => p_attribute5
730 ,p_attribute6 => p_attribute6
731 ,p_attribute7 => p_attribute7
732 ,p_attribute8 => p_attribute8
733 ,p_attribute9 => p_attribute9
734 ,p_attribute10 => p_attribute10
735 ,p_attribute11 => p_attribute11
736 ,p_attribute12 => p_attribute12
737 ,p_attribute13 => p_attribute13
738 ,p_attribute14 => p_attribute14
739 ,p_attribute15 => p_attribute15
740 ,p_attribute16 => p_attribute16
741 ,p_attribute17 => p_attribute17
742 ,p_attribute18 => p_attribute18
743 ,p_attribute19 => p_attribute19
744 ,p_attribute20 => p_attribute20
745 ,p_attribute21 => p_attribute21
746 ,p_attribute22 => p_attribute22
747 ,p_attribute23 => p_attribute23
748 ,p_attribute24 => p_attribute24
749 ,p_attribute25 => p_attribute25
750 ,p_attribute26 => p_attribute26
751 ,p_attribute27 => p_attribute27
752 ,p_attribute28 => p_attribute28
753 ,p_attribute29 => p_attribute29
754 ,p_attribute30 => p_attribute30
755 ,p_attribute_category => p_attribute_category
756 ,p_primary_prof_field_id => p_primary_prof_field_id
757 ,p_starting_grade_id => p_starting_grade_id
758 ,p_ben_pgm_id => p_ben_pgm_id
759 ,p_probation_period => p_probation_period
760 ,p_probation_units => p_probation_units
761 );
762 exception
763 when hr_api.cannot_find_prog_unit then
764 hr_api.cannot_find_prog_unit_error
765 (
766 p_module_name => 'update_corps_definition'
767 ,p_hook_type => 'AP'
768 );
769 --
770 -- End of API User Hook for the after hook of update_corps_definition
771 --
772 end;
773
774 --
775 hr_utility.set_location(l_proc, 60);
776 --
777 -- When in validation only mode raise the Validate_Enabled exception
778 --
779 if p_validate then
780 raise hr_api.validate_enabled;
781 end if;
782 --
783 -- Set all output arguments
784 --
785 p_object_version_number := l_object_version_number;
786 --
787 hr_utility.set_location(' Leaving:'||l_proc, 70);
788 --
789 exception
790 --
791 when hr_api.validate_enabled then
792 --
793 -- As the Validate_Enabled exception has been raised
794 -- we must rollback to the savepoint
795 --
796 ROLLBACK TO update_corps_definition;
797 --
798 -- Only set output warning arguments
799 -- (Any key or derived arguments must be set to null
800 -- when validation only mode is being used.)
801 --
802 hr_utility.set_location(' Leaving:'||l_proc, 80);
803 --
804 when others then
805 p_object_version_number := l_object_version_number;
806 --
807 -- A validation or unexpected error has occured
808 --
809 ROLLBACK TO update_corps_definition;
813 --
810 raise;
811 --
812 end;
814 -- ----------------------------------------------------------------------------
815 -- |------------------------< delete_corps_definition >------------------------|
816 -- ----------------------------------------------------------------------------
817 -- {Start Of Comments}
818 --
819 -- Description:
820 --
821 -- Prerequisites:
822 --
823 --
824 -- In Parameters:
825 -- Name Reqd Type Description
826 --
827 -- p_validate Yes boolean Commit or Rollback.
828 -- p_corps_definition_id Yes number PK of record
829 -- p_effective_date Yes date Session Date.
830 -- p_object_version_number Yes number OVN of record
831
832 -- Post Success:
833 --
834 -- Name Type Description
835 --
836 -- Post Failure:
837 --
838 -- Access Status:
839 -- Public.
840 --
841 -- {End Of Comments}
842 --
843 procedure delete_corps_definition
844 (
845 p_validate in boolean default false
846 ,p_corps_definition_id in number
847 ,p_object_version_number in number
848 ) is
849 --
850 -- Declare cursors and local variables
851 --
852 l_proc varchar2(72) := g_package||'delete_corps_definition';
853 l_object_version_number pqh_corps_definitions.object_version_number%TYPE;
854 --
855 begin
856 --
857 hr_utility.set_location('Entering:'|| l_proc, 10);
858 --
859 -- Issue a savepoint if operating in validation only mode
860 --
861 savepoint delete_corps_definition;
862 --
863 hr_utility.set_location(l_proc, 20);
864 --
865 -- Process Logic
866 --
867 l_object_version_number := p_object_version_number;
868 --
869 --
870 begin
871 --
872 -- Start of API User Hook for the before hook of delete_corps_definition
873 --
874 pqh_corps_definitions_bk3.delete_corps_definition_b
875 (
876 p_corps_definition_id => p_corps_definition_id
877 ,p_object_version_number => p_object_version_number
878 );
879 exception
880 when hr_api.cannot_find_prog_unit then
881 hr_api.cannot_find_prog_unit_error
882 (p_module_name => 'delete_corps_definition'
883 ,p_hook_type => 'BP'
884 );
885 --
886 -- End of API User Hook for the before hook of delete_corps_definition
887 --
888 end;
889 --
890 PQH_CPD_del.del
891 (
892 p_corps_definition_id => p_corps_definition_id
893 ,p_object_version_number => l_object_version_number
894 );
895 --
896 begin
897 --
898 -- Start of API User Hook for the after hook of delete_corps_definition
899 --
900 pqh_corps_definitions_bk3.delete_corps_definition_a
901 (
902 p_corps_definition_id => p_corps_definition_id
903 ,p_object_version_number => l_object_version_number
904 );
905 exception
906 when hr_api.cannot_find_prog_unit then
907 hr_api.cannot_find_prog_unit_error
908 (p_module_name => 'delete_corps_definition'
909 ,p_hook_type => 'AP'
910 );
911 --
912 -- End of API User Hook for the after hook of delete_corps_definition
913 --
914 end;
915 --
916 hr_utility.set_location(l_proc, 60);
917 --
918 -- When in validation only mode raise the Validate_Enabled exception
919 --
920 if p_validate then
921 raise hr_api.validate_enabled;
922 end if;
923 --
924 hr_utility.set_location(' Leaving:'||l_proc, 70);
925 --
926 exception
927 --
928 when hr_api.validate_enabled then
929 --
930 -- As the Validate_Enabled exception has been raised
931 -- we must rollback to the savepoint
932 --
933 ROLLBACK TO delete_corps_definition;
934 --
935 -- Only set output warning arguments
936 -- (Any key or derived arguments must be set to null
937 -- when validation only mode is being used.)
938 --
939 --
940 when others then
941 --
942 -- A validation or unexpected error has occured
943 --
944 ROLLBACK TO delete_corps_definition;
945 raise;
946 --
947 end delete_corps_definition;
948
949 --
950 --
951 -- ----------------------------------------------------------------------------
952 -- |-------------------------------< lck >------------------------------------|
953 -- ----------------------------------------------------------------------------
954 --
955 procedure lck
956 (
957 p_corps_definition_id in number
958 ,p_object_version_number in number
959 ) is
960 --
961 --
962 -- Declare cursors and local variables
963 --
964 l_proc varchar2(72) := g_package||'lck';
965 --
966 begin
967 --
968 hr_utility.set_location('Entering:'|| l_proc, 10);
969 --
970 PQH_CPD_shd.lck
971 (
972 p_corps_definition_id => p_corps_definition_id
973 ,p_object_version_number => p_object_version_number
974 );
975 --
976 hr_utility.set_location(' Leaving:'||l_proc, 70);
977 --
978 end lck;
979 --
980 end pqh_corps_definitions_api;