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