[Home] [Help]
PACKAGE BODY: APPS.PQH_COPY_ENTITY_ATTRIBS_API
Source
1 Package Body pqh_copy_entity_attribs_api as
2 /* $Header: pqceaapi.pkb 115.5 2003/09/28 21:34:35 scnair ship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' pqh_copy_entity_attribs_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_copy_entity_attrib >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_copy_entity_attrib
13 (p_validate in boolean default false
14 ,p_copy_entity_attrib_id out nocopy number
15 ,p_copy_entity_txn_id in number default null
16 ,p_row_type_cd in varchar2 default null
17 ,p_information_category in varchar2 default null
18 ,p_information1 in varchar2 default null
19 ,p_information2 in varchar2 default null
20 ,p_information3 in varchar2 default null
21 ,p_information4 in varchar2 default null
22 ,p_information5 in varchar2 default null
23 ,p_information6 in varchar2 default null
24 ,p_information7 in varchar2 default null
25 ,p_information8 in varchar2 default null
26 ,p_information9 in varchar2 default null
27 ,p_information10 in varchar2 default null
28 ,p_information11 in varchar2 default null
29 ,p_information12 in varchar2 default null
30 ,p_information13 in varchar2 default null
31 ,p_information14 in varchar2 default null
32 ,p_information15 in varchar2 default null
33 ,p_information16 in varchar2 default null
34 ,p_information17 in varchar2 default null
35 ,p_information18 in varchar2 default null
36 ,p_information19 in varchar2 default null
37 ,p_information20 in varchar2 default null
38 ,p_information21 in varchar2 default null
39 ,p_information22 in varchar2 default null
40 ,p_information23 in varchar2 default null
41 ,p_information24 in varchar2 default null
42 ,p_information25 in varchar2 default null
43 ,p_information26 in varchar2 default null
44 ,p_information27 in varchar2 default null
45 ,p_information28 in varchar2 default null
46 ,p_information29 in varchar2 default null
47 ,p_information30 in varchar2 default null
48 ,p_check_information1 in varchar2 default null
49 ,p_check_information2 in varchar2 default null
50 ,p_check_information3 in varchar2 default null
51 ,p_object_version_number out nocopy number
52 ,p_effective_date in date
53 ) is
54 --
55 -- Declare cursors and local variables
56 --
57 l_copy_entity_attrib_id pqh_copy_entity_attribs.copy_entity_attrib_id%TYPE;
58 l_proc varchar2(72) := g_package||'create_copy_entity_attrib';
59 l_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;
60 --
61 begin
62 --
63 hr_utility.set_location('Entering:'|| l_proc, 10);
64 --
65 -- Issue a savepoint if operating in validation only mode
66 --
67 savepoint create_copy_entity_attrib;
68 --
69 hr_utility.set_location(l_proc, 20);
70 --
71 -- Process Logic
72 --
73 begin
74 --
75 -- Start of API User Hook for the before hook of create_copy_entity_attribs
76 --
77 pqh_copy_entity_attribs_bk1.create_copy_entity_attrib_b
78 (
79 p_copy_entity_txn_id => p_copy_entity_txn_id
80 ,p_row_type_cd => p_row_type_cd
81 ,p_information_category => p_information_category
82 ,p_information1 => p_information1
83 ,p_information2 => p_information2
84 ,p_information3 => p_information3
85 ,p_information4 => p_information4
86 ,p_information5 => p_information5
87 ,p_information6 => p_information6
88 ,p_information7 => p_information7
89 ,p_information8 => p_information8
90 ,p_information9 => p_information9
91 ,p_information10 => p_information10
92 ,p_information11 => p_information11
93 ,p_information12 => p_information12
94 ,p_information13 => p_information13
95 ,p_information14 => p_information14
96 ,p_information15 => p_information15
97 ,p_information16 => p_information16
98 ,p_information17 => p_information17
99 ,p_information18 => p_information18
100 ,p_information19 => p_information19
101 ,p_information20 => p_information20
102 ,p_information21 => p_information21
103 ,p_information22 => p_information22
104 ,p_information23 => p_information23
105 ,p_information24 => p_information24
106 ,p_information25 => p_information25
107 ,p_information26 => p_information26
108 ,p_information27 => p_information27
109 ,p_information28 => p_information28
110 ,p_information29 => p_information29
111 ,p_information30 => p_information30
112 ,p_check_information1 => p_check_information1
113 ,p_check_information2 => p_check_information2
114 ,p_check_information3 => p_check_information3
115 ,p_effective_date => trunc(p_effective_date)
116 );
117 exception
118 when hr_api.cannot_find_prog_unit then
119 hr_api.cannot_find_prog_unit_error
120 (
121 p_module_name => 'CREATE_COPY_ENTITY_ATTRIB'
122 ,p_hook_type => 'BP'
123 );
124 --
125 -- End of API User Hook for the before hook of create_copy_entity_attribs
126 --
127 end;
128 --
129 pqh_cea_ins.ins
130 (
131 p_copy_entity_attrib_id => l_copy_entity_attrib_id
132 ,p_copy_entity_txn_id => p_copy_entity_txn_id
133 ,p_row_type_cd => p_row_type_cd
134 ,p_information_category => p_information_category
135 ,p_information1 => p_information1
136 ,p_information2 => p_information2
137 ,p_information3 => p_information3
138 ,p_information4 => p_information4
139 ,p_information5 => p_information5
140 ,p_information6 => p_information6
141 ,p_information7 => p_information7
142 ,p_information8 => p_information8
143 ,p_information9 => p_information9
144 ,p_information10 => p_information10
145 ,p_information11 => p_information11
146 ,p_information12 => p_information12
147 ,p_information13 => p_information13
148 ,p_information14 => p_information14
149 ,p_information15 => p_information15
150 ,p_information16 => p_information16
151 ,p_information17 => p_information17
152 ,p_information18 => p_information18
153 ,p_information19 => p_information19
154 ,p_information20 => p_information20
155 ,p_information21 => p_information21
156 ,p_information22 => p_information22
157 ,p_information23 => p_information23
158 ,p_information24 => p_information24
159 ,p_information25 => p_information25
160 ,p_information26 => p_information26
161 ,p_information27 => p_information27
162 ,p_information28 => p_information28
163 ,p_information29 => p_information29
164 ,p_information30 => p_information30
165 ,p_check_information1 => p_check_information1
166 ,p_check_information2 => p_check_information2
167 ,p_check_information3 => p_check_information3
168 ,p_object_version_number => l_object_version_number
169 ,p_effective_date => trunc(p_effective_date)
170 );
171 --
172 begin
173 --
174 -- Start of API User Hook for the after hook of create_copy_entity_attribs
175 --
176 pqh_copy_entity_attribs_bk1.create_copy_entity_attrib_a
177 (
178 p_copy_entity_attrib_id => l_copy_entity_attrib_id
179 ,p_copy_entity_txn_id => p_copy_entity_txn_id
180 ,p_row_type_cd => p_row_type_cd
181 ,p_information_category => p_information_category
182 ,p_information1 => p_information1
183 ,p_information2 => p_information2
184 ,p_information3 => p_information3
185 ,p_information4 => p_information4
186 ,p_information5 => p_information5
187 ,p_information6 => p_information6
188 ,p_information7 => p_information7
189 ,p_information8 => p_information8
190 ,p_information9 => p_information9
191 ,p_information10 => p_information10
192 ,p_information11 => p_information11
193 ,p_information12 => p_information12
194 ,p_information13 => p_information13
195 ,p_information14 => p_information14
196 ,p_information15 => p_information15
197 ,p_information16 => p_information16
198 ,p_information17 => p_information17
199 ,p_information18 => p_information18
200 ,p_information19 => p_information19
201 ,p_information20 => p_information20
202 ,p_information21 => p_information21
203 ,p_information22 => p_information22
204 ,p_information23 => p_information23
205 ,p_information24 => p_information24
206 ,p_information25 => p_information25
207 ,p_information26 => p_information26
208 ,p_information27 => p_information27
209 ,p_information28 => p_information28
210 ,p_information29 => p_information29
211 ,p_information30 => p_information30
212 ,p_check_information1 => p_check_information1
213 ,p_check_information2 => p_check_information2
214 ,p_check_information3 => p_check_information3
215 ,p_object_version_number => l_object_version_number
216 ,p_effective_date => trunc(p_effective_date)
217 );
218 exception
219 when hr_api.cannot_find_prog_unit then
220 hr_api.cannot_find_prog_unit_error
221 (p_module_name => 'CREATE_COPY_ENTITY_ATTRIB'
222 ,p_hook_type => 'AP'
223 );
224 --
225 -- End of API User Hook for the after hook of create_copy_entity_attribs
226 --
227 end;
228 --
229 hr_utility.set_location(l_proc, 60);
230 --
231 -- When in validation only mode raise the Validate_Enabled exception
232 --
233 if p_validate then
234 raise hr_api.validate_enabled;
235 end if;
236 --
237 -- Set all output arguments
238 --
239 p_copy_entity_attrib_id := l_copy_entity_attrib_id;
240 p_object_version_number := l_object_version_number;
241 --
242 hr_utility.set_location(' Leaving:'||l_proc, 70);
243 --
244 exception
245 --
246 when hr_api.validate_enabled then
247 --
248 -- As the Validate_Enabled exception has been raised
249 -- we must rollback to the savepoint
250 --
251 ROLLBACK TO create_copy_entity_attrib;
252 --
253 -- Only set output warning arguments
254 -- (Any key or derived arguments must be set to null
255 -- when validation only mode is being used.)
256 --
257 p_copy_entity_attrib_id := null;
258 p_object_version_number := null;
259 hr_utility.set_location(' Leaving:'||l_proc, 80);
260 --
261 when others then
262 p_copy_entity_attrib_id := null;
263 p_object_version_number := null;
264 --
265 -- A validation or unexpected error has occured
266 --
267 ROLLBACK TO create_copy_entity_attrib;
268 raise;
269 --
270 end create_copy_entity_attrib;
271 -- ----------------------------------------------------------------------------
272 -- |------------------------< update_copy_entity_attrib >--- ------------------|
273 -- ----------------------------------------------------------------------------
274 --
275 procedure update_copy_entity_attrib
276 (p_validate in boolean default false
277 ,p_copy_entity_attrib_id in number
278 ,p_copy_entity_txn_id in number default hr_api.g_number
279 ,p_row_type_cd in varchar2 default hr_api.g_varchar2
280 ,p_information_category in varchar2 default hr_api.g_varchar2
281 ,p_information1 in varchar2 default hr_api.g_varchar2
282 ,p_information2 in varchar2 default hr_api.g_varchar2
283 ,p_information3 in varchar2 default hr_api.g_varchar2
284 ,p_information4 in varchar2 default hr_api.g_varchar2
285 ,p_information5 in varchar2 default hr_api.g_varchar2
286 ,p_information6 in varchar2 default hr_api.g_varchar2
287 ,p_information7 in varchar2 default hr_api.g_varchar2
288 ,p_information8 in varchar2 default hr_api.g_varchar2
289 ,p_information9 in varchar2 default hr_api.g_varchar2
290 ,p_information10 in varchar2 default hr_api.g_varchar2
291 ,p_information11 in varchar2 default hr_api.g_varchar2
292 ,p_information12 in varchar2 default hr_api.g_varchar2
293 ,p_information13 in varchar2 default hr_api.g_varchar2
294 ,p_information14 in varchar2 default hr_api.g_varchar2
295 ,p_information15 in varchar2 default hr_api.g_varchar2
296 ,p_information16 in varchar2 default hr_api.g_varchar2
297 ,p_information17 in varchar2 default hr_api.g_varchar2
298 ,p_information18 in varchar2 default hr_api.g_varchar2
299 ,p_information19 in varchar2 default hr_api.g_varchar2
300 ,p_information20 in varchar2 default hr_api.g_varchar2
301 ,p_information21 in varchar2 default hr_api.g_varchar2
302 ,p_information22 in varchar2 default hr_api.g_varchar2
303 ,p_information23 in varchar2 default hr_api.g_varchar2
304 ,p_information24 in varchar2 default hr_api.g_varchar2
305 ,p_information25 in varchar2 default hr_api.g_varchar2
306 ,p_information26 in varchar2 default hr_api.g_varchar2
307 ,p_information27 in varchar2 default hr_api.g_varchar2
308 ,p_information28 in varchar2 default hr_api.g_varchar2
309 ,p_information29 in varchar2 default hr_api.g_varchar2
310 ,p_information30 in varchar2 default hr_api.g_varchar2
311 ,p_check_information1 in varchar2 default hr_api.g_varchar2
312 ,p_check_information2 in varchar2 default hr_api.g_varchar2
313 ,p_check_information3 in varchar2 default hr_api.g_varchar2
314 ,p_object_version_number in out nocopy number
315 ,p_effective_date in date
316 ) is
317 --
318 -- Declare cursors and local variables
319 --
320 l_proc varchar2(72) := g_package||'update_copy_entity_attrib';
321 l_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;
322 --
323 begin
324 --
325 hr_utility.set_location('Entering:'|| l_proc, 10);
326 --
327 -- Issue a savepoint if operating in validation only mode
328 --
329 savepoint update_copy_entity_attrib;
330 --
331 hr_utility.set_location(l_proc, 20);
332 --
333 -- Process Logic
334 --
335 l_object_version_number := p_object_version_number;
336 --
337 begin
338 --
339 -- Start of API User Hook for the before hook of update_copy_entity_attribs
340 --
341 pqh_copy_entity_attribs_bk2.update_copy_entity_attrib_b
342 (
343 p_copy_entity_attrib_id => p_copy_entity_attrib_id
344 ,p_copy_entity_txn_id => p_copy_entity_txn_id
345 ,p_row_type_cd => p_row_type_cd
346 ,p_information_category => p_information_category
347 ,p_information1 => p_information1
348 ,p_information2 => p_information2
349 ,p_information3 => p_information3
350 ,p_information4 => p_information4
351 ,p_information5 => p_information5
352 ,p_information6 => p_information6
353 ,p_information7 => p_information7
354 ,p_information8 => p_information8
355 ,p_information9 => p_information9
356 ,p_information10 => p_information10
357 ,p_information11 => p_information11
358 ,p_information12 => p_information12
359 ,p_information13 => p_information13
360 ,p_information14 => p_information14
361 ,p_information15 => p_information15
362 ,p_information16 => p_information16
363 ,p_information17 => p_information17
364 ,p_information18 => p_information18
365 ,p_information19 => p_information19
366 ,p_information20 => p_information20
367 ,p_information21 => p_information21
368 ,p_information22 => p_information22
369 ,p_information23 => p_information23
370 ,p_information24 => p_information24
371 ,p_information25 => p_information25
372 ,p_information26 => p_information26
373 ,p_information27 => p_information27
374 ,p_information28 => p_information28
375 ,p_information29 => p_information29
376 ,p_information30 => p_information30
377 ,p_check_information1 => p_check_information1
378 ,p_check_information2 => p_check_information2
379 ,p_check_information3 => p_check_information3
380 ,p_object_version_number => p_object_version_number
381 ,p_effective_date => trunc(p_effective_date)
382 );
383 exception
384 when hr_api.cannot_find_prog_unit then
385 hr_api.cannot_find_prog_unit_error
386 (p_module_name => 'UPDATE_COPY_ENTITY_ATTRIB'
387 ,p_hook_type => 'BP'
388 );
389 --
390 -- End of API User Hook for the before hook of update_copy_entity_attrib
391 --
392 end;
393 --
394 pqh_cea_upd.upd
395 (
396 p_copy_entity_attrib_id => p_copy_entity_attrib_id
397 ,p_copy_entity_txn_id => p_copy_entity_txn_id
398 ,p_row_type_cd => p_row_type_cd
399 ,p_information_category => p_information_category
400 ,p_information1 => p_information1
401 ,p_information2 => p_information2
402 ,p_information3 => p_information3
403 ,p_information4 => p_information4
404 ,p_information5 => p_information5
405 ,p_information6 => p_information6
406 ,p_information7 => p_information7
407 ,p_information8 => p_information8
408 ,p_information9 => p_information9
409 ,p_information10 => p_information10
410 ,p_information11 => p_information11
411 ,p_information12 => p_information12
412 ,p_information13 => p_information13
413 ,p_information14 => p_information14
414 ,p_information15 => p_information15
415 ,p_information16 => p_information16
416 ,p_information17 => p_information17
417 ,p_information18 => p_information18
418 ,p_information19 => p_information19
419 ,p_information20 => p_information20
420 ,p_information21 => p_information21
421 ,p_information22 => p_information22
422 ,p_information23 => p_information23
423 ,p_information24 => p_information24
424 ,p_information25 => p_information25
425 ,p_information26 => p_information26
426 ,p_information27 => p_information27
427 ,p_information28 => p_information28
428 ,p_information29 => p_information29
429 ,p_information30 => p_information30
430 ,p_check_information1 => p_check_information1
431 ,p_check_information2 => p_check_information2
432 ,p_check_information3 => p_check_information3
433 ,p_object_version_number => l_object_version_number
434 ,p_effective_date => trunc(p_effective_date)
435 );
436 --
437 begin
438 --
439 -- Start of API User Hook for the after hook of update_copy_entity_attribs
440 --
441 pqh_copy_entity_attribs_bk2.update_copy_entity_attrib_a
442 (
443 p_copy_entity_attrib_id => p_copy_entity_attrib_id
444 ,p_copy_entity_txn_id => p_copy_entity_txn_id
445 ,p_row_type_cd => p_row_type_cd
446 ,p_information_category => p_information_category
447 ,p_information1 => p_information1
448 ,p_information2 => p_information2
449 ,p_information3 => p_information3
450 ,p_information4 => p_information4
451 ,p_information5 => p_information5
452 ,p_information6 => p_information6
453 ,p_information7 => p_information7
454 ,p_information8 => p_information8
455 ,p_information9 => p_information9
456 ,p_information10 => p_information10
457 ,p_information11 => p_information11
458 ,p_information12 => p_information12
459 ,p_information13 => p_information13
460 ,p_information14 => p_information14
461 ,p_information15 => p_information15
462 ,p_information16 => p_information16
463 ,p_information17 => p_information17
464 ,p_information18 => p_information18
465 ,p_information19 => p_information19
466 ,p_information20 => p_information20
467 ,p_information21 => p_information21
468 ,p_information22 => p_information22
469 ,p_information23 => p_information23
470 ,p_information24 => p_information24
471 ,p_information25 => p_information25
472 ,p_information26 => p_information26
473 ,p_information27 => p_information27
474 ,p_information28 => p_information28
475 ,p_information29 => p_information29
476 ,p_information30 => p_information30
477 ,p_check_information1 => p_check_information1
478 ,p_check_information2 => p_check_information2
479 ,p_check_information3 => p_check_information3
480 ,p_object_version_number => l_object_version_number
481 ,p_effective_date => trunc(p_effective_date)
482 );
483 exception
484 when hr_api.cannot_find_prog_unit then
485 hr_api.cannot_find_prog_unit_error
486 (p_module_name => 'UPDATE_COPY_ENTITY_ATTRIB'
487 ,p_hook_type => 'AP'
488 );
489 --
490 -- End of API User Hook for the after hook of update_copy_entity_attribs
491 --
492 end;
493 --
494 hr_utility.set_location(l_proc, 60);
495 --
496 -- When in validation only mode raise the Validate_Enabled exception
497 --
498 if p_validate then
499 raise hr_api.validate_enabled;
500 end if;
501 --
502 -- Set all output arguments
503 --
504 p_object_version_number := l_object_version_number;
505 --
506 hr_utility.set_location(' Leaving:'||l_proc, 70);
507 --
508 exception
509 --
510 when hr_api.validate_enabled then
511 --
512 -- As the Validate_Enabled exception has been raised
513 -- we must rollback to the savepoint
514 --
515 ROLLBACK TO update_copy_entity_attrib;
516 --
517 -- Only set output warning arguments
518 -- (Any key or derived arguments must be set to null
519 -- when validation only mode is being used.)
520 --
521 hr_utility.set_location(' Leaving:'||l_proc, 80);
522 --
523 when others then
524 p_object_version_number := l_object_version_number;
525 --
526 -- A validation or unexpected error has occured
527 --
528 ROLLBACK TO update_copy_entity_attrib;
529 raise;
530 --
531 end update_copy_entity_attrib;
532 -- ----------------------------------------------------------------------------
533 -- |------------------------< delete_copy_entity_attrib >----------------------|
534 -- ----------------------------------------------------------------------------
535 --
536 procedure delete_copy_entity_attrib
537 (p_validate in boolean default false
538 ,p_copy_entity_attrib_id in number
539 ,p_object_version_number in number
540 ,p_effective_date in date
541 ) is
542 --
543 -- Declare cursors and local variables
544 --
545 l_proc varchar2(72) := g_package||'delete_copy_entity_attrib';
546 l_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;
547 --
548 begin
549 --
550 hr_utility.set_location('Entering:'|| l_proc, 10);
551 --
552 -- Issue a savepoint if operating in validation only mode
553 --
554 savepoint delete_copy_entity_attrib;
555 --
556 hr_utility.set_location(l_proc, 20);
557 --
558 -- Process Logic
559 --
560 l_object_version_number := p_object_version_number;
561 --
562 --
563 begin
564 --
565 -- Start of API User Hook for the before hook of delete_copy_entity_attribs
566 --
567 pqh_copy_entity_attribs_bk3.delete_copy_entity_attrib_b
568 (
569 p_copy_entity_attrib_id => p_copy_entity_attrib_id
570 ,p_object_version_number => p_object_version_number
571 ,p_effective_date => trunc(p_effective_date)
572 );
573 exception
574 when hr_api.cannot_find_prog_unit then
575 hr_api.cannot_find_prog_unit_error
576 (p_module_name => 'DELETE_COPY_ENTITY_ATTRIB'
577 ,p_hook_type => 'BP'
578 );
579 --
580 -- End of API User Hook for the before hook of delete_copy_entity_attribs
581 --
582 end;
583 --
584 pqh_cea_del.del
585 (
586 p_copy_entity_attrib_id => p_copy_entity_attrib_id
587 ,p_object_version_number => l_object_version_number
588 ,p_effective_date => p_effective_date
589 );
590 --
591 begin
592 --
593 -- Start of API User Hook for the after hook of delete_copy_entity_attribs
594 --
595 pqh_copy_entity_attribs_bk3.delete_copy_entity_attrib_a
596 (
597 p_copy_entity_attrib_id => p_copy_entity_attrib_id
598 ,p_object_version_number => l_object_version_number
599 ,p_effective_date => trunc(p_effective_date)
600 );
601 exception
602 when hr_api.cannot_find_prog_unit then
603 hr_api.cannot_find_prog_unit_error
604 (p_module_name => 'DELETE_COPY_ENTITY_ATTRIB'
605 ,p_hook_type => 'AP'
606 );
607 --
608 -- End of API User Hook for the after hook of delete_copy_entity_attribs
609 --
610 end;
611 --
612 hr_utility.set_location(l_proc, 60);
613 --
614 -- When in validation only mode raise the Validate_Enabled exception
615 --
616 if p_validate then
617 raise hr_api.validate_enabled;
618 end if;
619 --
620 hr_utility.set_location(' Leaving:'||l_proc, 70);
621 --
622 exception
623 --
624 when hr_api.validate_enabled then
625 --
626 -- As the Validate_Enabled exception has been raised
627 -- we must rollback to the savepoint
628 --
629 ROLLBACK TO delete_copy_entity_attrib;
630 --
631 -- Only set output warning arguments
632 -- (Any key or derived arguments must be set to null
633 -- when validation only mode is being used.)
634 --
635 --
636 when others then
637 --
638 -- A validation or unexpected error has occured
639 --
640 ROLLBACK TO delete_copy_entity_attrib;
641 raise;
642 --
643 end delete_copy_entity_attrib;
644 --
645 -- ----------------------------------------------------------------------------
646 -- |-------------------------------< lck >------------------------------------|
647 -- ----------------------------------------------------------------------------
648 --
649 procedure lck
650 (
651 p_copy_entity_attrib_id in number
652 ,p_object_version_number in number
653 ) is
654 --
655 --
656 -- Declare cursors and local variables
657 --
658 l_proc varchar2(72) := g_package||'lck';
659 --
660 begin
661 --
662 hr_utility.set_location('Entering:'|| l_proc, 10);
663 --
664 pqh_cea_shd.lck
665 (
666 p_copy_entity_attrib_id => p_copy_entity_attrib_id
667 ,p_object_version_number => p_object_version_number
668 );
669 --
670 hr_utility.set_location(' Leaving:'||l_proc, 70);
671 --
672 end lck;
673 --
674 end pqh_copy_entity_attribs_api;