1 Package pqh_cer_shd as
2 /* $Header: pqcerrhi.pkh 120.0 2005/05/29 01:41:31 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Global Record Type Specification |
6 -- ----------------------------------------------------------------------------
7 --
8 Type g_rec_type Is Record
9 (
10 copy_entity_result_id number(15),
11 copy_entity_txn_id number(15),
12 result_type_cd varchar2(30),
13 number_of_copies number(15),
14 status varchar2(255),
15 src_copy_entity_result_id number,
16 information_category varchar2(30),
17 information1 varchar2(2000),
18 information2 varchar2(255),
19 information3 varchar2(255),
20 information4 varchar2(255),
21 information5 varchar2(255),
22 information6 varchar2(255),
23 information7 varchar2(255),
24 information8 varchar2(255),
25 information9 varchar2(255),
26 information10 varchar2(255),
27 information11 varchar2(255),
28 information12 varchar2(255),
29 information13 varchar2(255),
30 information14 varchar2(255),
31 information15 varchar2(255),
32 information16 varchar2(255),
33 information17 varchar2(255),
34 information18 varchar2(255),
35 information19 varchar2(255),
36 information20 varchar2(255),
37 information21 varchar2(255),
38 information22 varchar2(255),
39 information23 varchar2(255),
40 information24 varchar2(255),
41 information25 varchar2(255),
42 information26 varchar2(255),
43 information27 varchar2(255),
44 information28 varchar2(255),
45 information29 varchar2(255),
46 information30 varchar2(255),
47 information31 varchar2(255),
48 information32 varchar2(255),
49 information33 varchar2(255),
50 information34 varchar2(255),
51 information35 varchar2(255),
52 information36 varchar2(255),
53 information37 varchar2(255),
54 information38 varchar2(255),
55 information39 varchar2(255),
56 information40 varchar2(255),
57 information41 varchar2(255),
58 information42 varchar2(255),
59 information43 varchar2(255),
60 information44 varchar2(255),
61 information45 varchar2(255),
62 information46 varchar2(255),
63 information47 varchar2(255),
64 information48 varchar2(255),
65 information49 varchar2(255),
66 information50 varchar2(255),
67 information51 varchar2(255),
68 information52 varchar2(2000),
69 information53 varchar2(255),
70 information54 varchar2(255),
71 information55 varchar2(255),
72 information56 varchar2(255),
73 information57 varchar2(255),
74 information58 varchar2(255),
75 information59 varchar2(255),
76 information60 varchar2(255),
77 information61 varchar2(255),
78 information62 varchar2(255),
79 information63 varchar2(255),
80 information64 varchar2(255),
81 information65 varchar2(255),
82 information66 varchar2(255),
83 information67 varchar2(255),
84 information68 varchar2(255),
85 information69 varchar2(255),
86 information70 varchar2(255),
87 information71 varchar2(255),
88 information72 varchar2(255),
89 information73 varchar2(255),
90 information74 varchar2(255),
91 information75 varchar2(255),
92 information76 varchar2(255),
93 information77 varchar2(255),
94 information78 varchar2(255),
95 information79 varchar2(255),
96 information80 varchar2(255),
97 information81 varchar2(255),
98 information82 varchar2(255),
99 information83 varchar2(255),
100 information84 varchar2(255),
101 information85 varchar2(255),
102 information86 varchar2(255),
103 information87 varchar2(255),
104 information88 varchar2(255),
105 information89 varchar2(255),
106 information90 varchar2(255),
107 information91 varchar2(255),
108 information92 varchar2(255),
109 information93 varchar2(255),
110 information94 varchar2(255),
111 information95 varchar2(255),
112 information96 varchar2(255),
113 information97 varchar2(255),
114 information98 varchar2(2000),
115 information99 varchar2(255),
116 information100 varchar2(255),
117 information101 varchar2(255),
118 information102 varchar2(255),
119 information103 varchar2(255),
120 information104 varchar2(255),
121 information105 varchar2(255),
122 information106 varchar2(255),
123 information107 varchar2(255),
124 information108 varchar2(255),
125 information109 varchar2(255),
126 information110 varchar2(255),
127 information111 varchar2(255),
128 information112 varchar2(255),
129 information113 varchar2(255),
130 information114 varchar2(255),
131 information115 varchar2(255),
132 information116 varchar2(255),
133 information117 varchar2(255),
134 information118 varchar2(255),
135 information119 varchar2(255),
136 information120 varchar2(255),
137 information121 varchar2(255),
138 information122 varchar2(255),
139 information123 varchar2(255),
140 information124 varchar2(255),
141 information125 varchar2(255),
142 information126 varchar2(255),
143 information127 varchar2(255),
144 information128 varchar2(255),
145 information129 varchar2(255),
146 information130 varchar2(255),
147 information131 varchar2(255),
148 information132 varchar2(255),
149 information133 varchar2(255),
150 information134 varchar2(255),
151 information135 varchar2(255),
152 information136 varchar2(255),
153 information137 varchar2(255),
154 information138 varchar2(255),
155 information139 varchar2(255),
156 information140 varchar2(255),
157 information141 varchar2(255),
158 information142 varchar2(255),
159 information143 varchar2(255),
160 information144 varchar2(255),
161 information145 varchar2(255),
162 information146 varchar2(255),
163 information147 varchar2(255),
164 information148 varchar2(255),
165 information149 varchar2(255),
166 information150 varchar2(255),
167 information151 varchar2(255),
168 information152 varchar2(255),
169 information153 varchar2(255),
170 information154 varchar2(255),
171 information155 varchar2(255),
172 information156 varchar2(255),
173 information157 varchar2(255),
174 information158 varchar2(255),
175 information159 varchar2(255),
176 information160 varchar2(255),
177 information161 varchar2(255),
178 information162 varchar2(255),
179 information163 varchar2(255),
180 information164 varchar2(255),
181 information165 varchar2(255),
182 information166 varchar2(255),
183 information167 varchar2(255),
184 information168 varchar2(255),
185 information169 varchar2(255),
186 information170 varchar2(255),
187 information171 varchar2(255),
188 information172 varchar2(255),
189 information173 varchar2(255),
190 information174 varchar2(255),
191 information175 varchar2(255),
192 information176 varchar2(255),
193 information177 varchar2(255),
194 information178 varchar2(255),
195 information179 varchar2(255),
196 information180 varchar2(255),
197 information181 varchar2(2000),
198 information182 varchar2(2000),
199 information183 varchar2(2000),
200 information184 varchar2(2000),
201 information185 varchar2(2000),
202 information186 varchar2(2000),
203 information187 varchar2(2000),
204 information188 varchar2(2000),
205 information189 varchar2(2000),
206 information190 varchar2(2000),
207 mirror_entity_result_id number(15),
208 mirror_src_entity_result_id number(15),
209 parent_entity_result_id number(15),
210 table_route_id number(15),
211 long_attribute1 long,
212 object_version_number number(9)
213 );
214 --
215 -- ----------------------------------------------------------------------------
216 -- | Global Definitions - Internal Development Use Only |
217 -- ----------------------------------------------------------------------------
218 --
219 g_old_rec g_rec_type; -- Global record definition
220 --
221 -- ----------------------------------------------------------------------------
222 -- |---------------------------< constraint_error >---------------------------|
223 -- ----------------------------------------------------------------------------
224 -- {Start Of Comments}
225 --
226 -- Description:
227 -- This procedure is called when a constraint has been violated (i.e.
228 -- The exception hr_api.check_integrity_violated,
229 -- hr_api.parent_integrity_violated, hr_api.child_integrity_violated or
230 -- hr_api.unique_integrity_violated has been raised).
231 -- The exceptions can only be raised as follows:
232 -- 1) A check constraint can only be violated during an INSERT or UPDATE
233 -- dml operation.
234 -- 2) A parent integrity constraint can only be violated during an
235 -- INSERT or UPDATE dml operation.
236 -- 3) A child integrity constraint can only be violated during an
237 -- DELETE dml operation.
238 -- 4) A unique integrity constraint can only be violated during INSERT or
239 -- UPDATE dml operation.
240 --
241 -- Prerequisites:
242 -- 1) Either hr_api.check_integrity_violated,
243 -- hr_api.parent_integrity_violated, hr_api.child_integrity_violated or
244 -- hr_api.unique_integrity_violated has been raised with the subsequent
245 -- stripping of the constraint name from the generated error message
246 -- text.
247 -- 2) Standalone validation test which corresponds with a constraint error.
248 --
249 -- In Parameter:
250 -- p_constraint_name is in upper format and is just the constraint name
251 -- (e.g. not prefixed by brackets, schema owner etc).
252 --
253 -- Post Success:
254 -- Development dependant.
255 --
256 -- Post Failure:
257 -- Developement dependant.
258 --
259 -- Developer Implementation Notes:
260 -- For each constraint being checked the hr system package failure message
261 -- has been generated as a template only. These system error messages should
262 -- be modified as required (i.e. change the system failure message to a user
263 -- friendly defined error message).
264 --
265 -- Access Status:
266 -- Internal Development Use Only.
267 --
268 -- {End Of Comments}
269 -- ----------------------------------------------------------------------------
270 Procedure constraint_error
271 (p_constraint_name in all_constraints.constraint_name%TYPE);
272 --
273 -- ----------------------------------------------------------------------------
274 -- |-----------------------------< api_updating >-----------------------------|
275 -- ----------------------------------------------------------------------------
276 -- {Start Of Comments}
277 --
278 -- Description:
282 -- already match the current g_old_rec. The function will always return
279 -- This function is used to populate the g_old_rec record with the
280 -- current row from the database for the specified primary key
281 -- provided that the primary key exists and is valid and does not
283 -- a TRUE value if the g_old_rec is populated with the current row.
284 -- A FALSE value will be returned if all of the primary key arguments
285 -- are null.
286 --
287 -- Prerequisites:
288 -- None.
289 --
290 -- In Parameters:
291 --
292 -- Post Success:
293 -- A value of TRUE will be returned indiciating that the g_old_rec
294 -- is current.
295 -- A value of FALSE will be returned if all of the primary key arguments
296 -- have a null value (this indicates that the row has not be inserted into
297 -- the Schema), and therefore could never have a corresponding row.
298 --
299 -- Post Failure:
300 -- A failure can only occur under two circumstances:
301 -- 1) The primary key is invalid (i.e. a row does not exist for the
302 -- specified primary key values).
303 -- 2) If an object_version_number exists but is NOT the same as the current
304 -- g_old_rec value.
305 --
306 -- Developer Implementation Notes:
307 -- None.
308 --
309 -- Access Status:
310 -- Internal Development Use Only.
311 --
312 -- {End Of Comments}
313 -- ----------------------------------------------------------------------------
314 Function api_updating
315 (
316 p_copy_entity_result_id in number,
317 p_object_version_number in number
318 ) Return Boolean;
319 --
320 -- ----------------------------------------------------------------------------
321 -- |---------------------------------< lck >----------------------------------|
322 -- ----------------------------------------------------------------------------
323 -- {Start Of Comments}
324 --
325 -- Description:
326 -- The Lck process has two main functions to perform. Firstly, the row to be
327 -- updated or deleted must be locked. The locking of the row will only be
328 -- successful if the row is not currently locked by another user.
329 -- Secondly, during the locking of the row, the row is selected into
330 -- the g_old_rec data structure which enables the current row values from the
331 -- server to be available to the api.
332 --
333 -- Prerequisites:
334 -- When attempting to call the lock the object version number (if defined)
335 -- is mandatory.
336 --
337 -- In Parameters:
338 -- The arguments to the Lck process are the primary key(s) which uniquely
339 -- identify the row and the object version number of row.
340 --
341 -- Post Success:
342 -- On successful completion of the Lck process the row to be updated or
343 -- deleted will be locked and selected into the global data structure
344 -- g_old_rec.
345 --
346 -- Post Failure:
347 -- The Lck process can fail for three reasons:
348 -- 1) When attempting to lock the row the row could already be locked by
349 -- another user. This will raise the HR_Api.Object_Locked exception.
350 -- 2) The row which is required to be locked doesn't exist in the HR Schema.
351 -- This error is trapped and reported using the message name
352 -- 'HR_7220_INVALID_PRIMARY_KEY'.
353 -- 3) The row although existing in the HR Schema has a different object
354 -- version number than the object version number specified.
355 -- This error is trapped and reported using the message name
356 -- 'HR_7155_OBJECT_INVALID'.
357 --
358 -- Developer Implementation Notes:
359 -- For each primary key and the object version number arguments add a
360 -- call to hr_api.mandatory_arg_error procedure to ensure that these
361 -- argument values are not null.
362 --
363 -- Access Status:
364 -- Internal Development Use Only.
365 --
366 -- {End Of Comments}
367 -- ----------------------------------------------------------------------------
368 Procedure lck
369 (
370 p_copy_entity_result_id in number,
371 p_object_version_number in number
372 );
373 --
374 -- ----------------------------------------------------------------------------
375 -- |-----------------------------< convert_args >-----------------------------|
376 -- ----------------------------------------------------------------------------
377 -- {Start Of Comments}
378 --
379 -- Description:
380 -- This function is used to turn attribute parameters into the record
381 -- structure parameter g_rec_type.
382 --
383 -- Prerequisites:
384 -- This is a private function and can only be called from the ins or upd
385 -- attribute processes.
386 --
387 -- In Parameters:
388 --
389 -- Post Success:
390 -- A returning record structure will be returned.
391 --
392 -- Post Failure:
393 -- No direct error handling is required within this function. Any possible
394 -- errors within this function will be a PL/SQL value error due to conversion
395 -- of datatypes or data lengths.
396 --
397 -- Developer Implementation Notes:
398 -- None.
399 --
400 -- Access Status:
401 -- Internal Row Handler Use Only.
402 --
403 -- {End Of Comments}
404 -- ----------------------------------------------------------------------------
405 Function convert_args
406 (
407 p_copy_entity_result_id in number,
411 p_status in varchar2,
408 p_copy_entity_txn_id in number,
409 p_result_type_cd in varchar2,
410 p_number_of_copies in number,
412 p_src_copy_entity_result_id in number,
413 p_information_category in varchar2,
414 p_information1 in varchar2,
415 p_information2 in varchar2,
416 p_information3 in varchar2,
417 p_information4 in varchar2,
418 p_information5 in varchar2,
419 p_information6 in varchar2,
420 p_information7 in varchar2,
421 p_information8 in varchar2,
422 p_information9 in varchar2,
423 p_information10 in varchar2,
424 p_information11 in varchar2,
425 p_information12 in varchar2,
426 p_information13 in varchar2,
427 p_information14 in varchar2,
428 p_information15 in varchar2,
429 p_information16 in varchar2,
430 p_information17 in varchar2,
431 p_information18 in varchar2,
432 p_information19 in varchar2,
433 p_information20 in varchar2,
434 p_information21 in varchar2,
435 p_information22 in varchar2,
436 p_information23 in varchar2,
437 p_information24 in varchar2,
438 p_information25 in varchar2,
439 p_information26 in varchar2,
440 p_information27 in varchar2,
441 p_information28 in varchar2,
442 p_information29 in varchar2,
443 p_information30 in varchar2,
444 p_information31 in varchar2,
445 p_information32 in varchar2,
446 p_information33 in varchar2,
447 p_information34 in varchar2,
448 p_information35 in varchar2,
449 p_information36 in varchar2,
450 p_information37 in varchar2,
451 p_information38 in varchar2,
452 p_information39 in varchar2,
453 p_information40 in varchar2,
454 p_information41 in varchar2,
455 p_information42 in varchar2,
456 p_information43 in varchar2,
457 p_information44 in varchar2,
458 p_information45 in varchar2,
459 p_information46 in varchar2,
460 p_information47 in varchar2,
461 p_information48 in varchar2,
462 p_information49 in varchar2,
463 p_information50 in varchar2,
464 p_information51 in varchar2,
465 p_information52 in varchar2,
466 p_information53 in varchar2,
467 p_information54 in varchar2,
468 p_information55 in varchar2,
469 p_information56 in varchar2,
470 p_information57 in varchar2,
471 p_information58 in varchar2,
472 p_information59 in varchar2,
473 p_information60 in varchar2,
474 p_information61 in varchar2,
475 p_information62 in varchar2,
476 p_information63 in varchar2,
477 p_information64 in varchar2,
478 p_information65 in varchar2,
479 p_information66 in varchar2,
480 p_information67 in varchar2,
481 p_information68 in varchar2,
482 p_information69 in varchar2,
483 p_information70 in varchar2,
484 p_information71 in varchar2,
485 p_information72 in varchar2,
486 p_information73 in varchar2,
487 p_information74 in varchar2,
488 p_information75 in varchar2,
489 p_information76 in varchar2,
490 p_information77 in varchar2,
491 p_information78 in varchar2,
492 p_information79 in varchar2,
493 p_information80 in varchar2,
494 p_information81 in varchar2,
495 p_information82 in varchar2,
496 p_information83 in varchar2,
497 p_information84 in varchar2,
498 p_information85 in varchar2,
499 p_information86 in varchar2,
500 p_information87 in varchar2,
501 p_information88 in varchar2,
502 p_information89 in varchar2,
503 p_information90 in varchar2,
504 p_information91 in varchar2,
505 p_information92 in varchar2,
506 p_information93 in varchar2,
507 p_information94 in varchar2,
508 p_information95 in varchar2,
509 p_information96 in varchar2,
510 p_information97 in varchar2,
511 p_information98 in varchar2,
512 p_information99 in varchar2,
513 p_information100 in varchar2,
514 p_information101 in varchar2,
515 p_information102 in varchar2,
516 p_information103 in varchar2,
517 p_information104 in varchar2,
518 p_information105 in varchar2,
519 p_information106 in varchar2,
523 p_information110 in varchar2,
520 p_information107 in varchar2,
521 p_information108 in varchar2,
522 p_information109 in varchar2,
524 p_information111 in varchar2,
525 p_information112 in varchar2,
526 p_information113 in varchar2,
527 p_information114 in varchar2,
528 p_information115 in varchar2,
529 p_information116 in varchar2,
530 p_information117 in varchar2,
531 p_information118 in varchar2,
532 p_information119 in varchar2,
533 p_information120 in varchar2,
534 p_information121 in varchar2,
535 p_information122 in varchar2,
536 p_information123 in varchar2,
537 p_information124 in varchar2,
538 p_information125 in varchar2,
539 p_information126 in varchar2,
540 p_information127 in varchar2,
541 p_information128 in varchar2,
542 p_information129 in varchar2,
543 p_information130 in varchar2,
544 p_information131 in varchar2,
545 p_information132 in varchar2,
546 p_information133 in varchar2,
547 p_information134 in varchar2,
548 p_information135 in varchar2,
549 p_information136 in varchar2,
550 p_information137 in varchar2,
551 p_information138 in varchar2,
552 p_information139 in varchar2,
553 p_information140 in varchar2,
554 p_information141 in varchar2,
555 p_information142 in varchar2,
556 p_information143 in varchar2,
557 p_information144 in varchar2,
558 p_information145 in varchar2,
559 p_information146 in varchar2,
560 p_information147 in varchar2,
561 p_information148 in varchar2,
562 p_information149 in varchar2,
563 p_information150 in varchar2,
564 p_information151 in varchar2,
565 p_information152 in varchar2,
566 p_information153 in varchar2,
567 p_information154 in varchar2,
568 p_information155 in varchar2,
569 p_information156 in varchar2,
570 p_information157 in varchar2,
571 p_information158 in varchar2,
572 p_information159 in varchar2,
573 p_information160 in varchar2,
574 p_information161 in varchar2,
575 p_information162 in varchar2,
576 p_information163 in varchar2,
577 p_information164 in varchar2,
578 p_information165 in varchar2,
579 p_information166 in varchar2,
580 p_information167 in varchar2,
581 p_information168 in varchar2,
582 p_information169 in varchar2,
583 p_information170 in varchar2,
584 p_information171 in varchar2,
585 p_information172 in varchar2,
586 p_information173 in varchar2,
587 p_information174 in varchar2,
588 p_information175 in varchar2,
589 p_information176 in varchar2,
590 p_information177 in varchar2,
591 p_information178 in varchar2,
592 p_information179 in varchar2,
593 p_information180 in varchar2,
594 p_information181 in varchar2,
595 p_information182 in varchar2,
596 p_information183 in varchar2,
597 p_information184 in varchar2,
598 p_information185 in varchar2,
599 p_information186 in varchar2,
600 p_information187 in varchar2,
601 p_information188 in varchar2,
602 p_information189 in varchar2,
603 p_information190 in varchar2,
604 p_mirror_entity_result_id in number,
605 p_mirror_src_entity_result_id in number,
606 p_parent_entity_result_id in number,
607 p_table_route_id in number,
608 p_long_attribute1 in long,
609 p_object_version_number in number
610 )
611 Return g_rec_type;
612 --
613 end pqh_cer_shd;