1 PACKAGE PAY_GB_AEI_API AUTHID CURRENT_USER as
2 /* $Header: pyaeigbi.pkh 120.7.12020000.4 2013/03/29 13:44:03 rajganga ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-------------------------< pay_gb_ins_p45_3>-----------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- Alternative interface to call insert api for Assignment Extra Info table
11 -- to create a P45(3) context record for the assignment
12 --
13 -- Prerequisites : None
14 --
15 --
16 -- In Parameters:
17 -- Name Reqd Type Description
18 -- p_validate No Boolean Validate Only flag
19 -- p_assignment_id Yes Number The ID of the assignment
20 -- p_business_group_id Yes Number The ID of the Business Group
21 -- p_information_type Yes Varchar2 Context fo the Assignment
22 -- Extra Info Row
23 -- p_aei_information_category No Varchar2
24 -- p_aei_information1 No Varchar2 Send P45(3) EDI Flag
25 -- p_aei_information2 No Varchar2 Previous Tax District
26 -- p_aei_information3 No varchar2 Date left prevous employer
27 -- p_aei_information4 No Varchar2 Previous Tax Code
28 -- p_aei_information5 No Varchar2 Previous Tax Basis
29 -- p_aei_information6 No Varchar2 Previous last payment period
30 -- type
31 -- p_aei_information7 No Varchar2 Previous last payment period
32 --
33 -- Bug 1843915
34 -- p_aei_information8 No Varchar2 P45(3) Send EDI flag
35 -- Bug 6345375
36 -- p_aei_information9 No Varchar2 Previous Tax Paid Notified
37 -- p_aei_information10 No Varchar2 Not paid between start and next 5th April
38 -- p_aei_information11 No Varchar2 Continue Student Loan Deductions
39 --
40 -- Post Success:
41 --
42 -- GB_P45_3 record will be created for assignment
43 -- New object version number should be returned
44 -- p_some_warning returned as null
45 --
46 -- Post Failure:
47 --
48 -- GB_P45_3 record will not be created, error messgae will be returned
49 --
50 -- Access Status:
51 -- Internal Development Use Only.
52 --
53 -- {End Of Comments}
54 procedure pay_gb_ins_p45_3
55 (p_validate in boolean default false
56 ,p_assignment_id in number
57 ,p_business_group_id in number
58 ,p_information_type in varchar2
59 ,p_aei_information_category in varchar2 default null
60 ,p_aei_information1 in varchar2 default null
61 ,p_aei_information2 in varchar2 default null
62 ,p_aei_information3 in varchar2 default null
63 ,p_aei_information4 in varchar2 default null
64 ,p_aei_information5 in varchar2 default null
65 ,p_aei_information6 in varchar2 default null
66 ,p_aei_information7 in varchar2 default null
67 ,p_aei_information8 in varchar2 default null
68 ,p_aei_information9 in varchar2 default null
69 ,p_aei_information10 in varchar2 default null
70 ,p_aei_information11 in varchar2 default null
71 ,p_aei_information12 in varchar2 default null -- Bug 6994632 added for Prev Tax Pay Notified
72 ,p_object_version_number out nocopy number
73 ,p_assignment_extra_info_id out nocopy number
74 );
75 --
76 --
77 -- ----------------------------------------------------------------------------
78 -- |-------------------------< pay_gb_upd_p45_3>-----------------------|
79 -- ----------------------------------------------------------------------------
80 -- {Start Of Comments}
81 --
82 -- Description:
83 -- Alternative interface to call update api for Assignment Extra Info table
84 -- to create a P45(3) context record for the assignment
85 --
86 -- Prerequisites : None
87 --
88 --
89 -- In Parameters:
90 -- Name Reqd Type Description
91 -- p_assignment_extra_info_id Yes Number The ID of the assignment
92 -- p_business_group_id Yes Number The ID of the Business Group
93 -- p_aei_information_category No Varchar2
94 -- p_aei_information1 No Varchar2 Send P45(3) EDI Flag
95 -- p_aei_information2 No Varchar2 Previous Tax District
96 -- p_aei_information3 No Varchar2 Date left prevous employer
97 -- p_aei_information4 No Varchar2 Previous Tax Code
98 -- p_aei_information5 No Varchar2 Previous Tax Basis
99 -- p_aei_information6 No Varchar2 Previous last payment period
100 -- type
101 -- p_aei_information7 No Varchar2 Previous last payment period
102 -- p_object_version_number Yes Number Object Version Number
103 --
104 -- Bug 1843915
105 -- p_aei_information8 No Varchar2 P45(3) Send EDI flag
106 --
107 -- Bug 6345375
108 -- p_aei_information9 No Varchar2 Previous Tax Paid Notified
109 -- p_aei_information10 No Varchar2 Not paid between start and next 5th April
110 -- p_aei_information11 No Varchar2 Continue Student Loan Deductions
111
112 -- Post Success:
113 --
114 -- GB_P45_3 record will be updated for assignment
115 -- New object version number should be returned
116 -- p_some_warning returned as null
117 --
118 -- Post Failure:
119 --
120 -- GB_P45_3 record will not be updated, error messgae will be returned
121 --
122 -- Access Status:
123 -- Internal Development Use Only.
124 --
125 -- {End Of Comments}
126 --
127 procedure pay_gb_upd_p45_3
128 (p_validate in boolean default false
129 ,p_assignment_extra_info_id in number
130 ,p_business_group_id in number
131 ,p_object_version_number in out nocopy number
132 ,p_aei_information_category in varchar2 default null
133 ,p_aei_information1 in varchar2 default null
134 ,p_aei_information2 in varchar2 default null
135 ,p_aei_information3 in varchar2 default null
136 ,p_aei_information4 in varchar2 default null
137 ,p_aei_information5 in varchar2 default null
138 ,p_aei_information6 in varchar2 default null
139 ,p_aei_information7 in varchar2 default null
140 ,p_aei_information8 in varchar2 default null
141 ,p_aei_information9 in varchar2 default null
142 ,p_aei_information10 in varchar2 default null
143 ,p_aei_information11 in varchar2 default null
144 ,p_aei_information12 in varchar2 default null -- Bug 6994632 added for Prev Tax Pay Notified
145 );
146 --
147 --
148 -- ----------------------------------------------------------------------------
149 -- |-------------------------< pay_gb_ins_p46>-----------------------|
150 -- ----------------------------------------------------------------------------
151 -- {Start Of Comments}
152 --
153 -- Description:
154 -- Alternative interface to call insert api for Assignment Extra Info table
155 -- to create a P46 context record for the assignment
156 --
157 -- Prerequisites : None
158 --
159 --
160 -- In Parameters:
161 -- Name Reqd Type Description
162 -- p_assignment_id Yes Number The ID of the assignment
163 -- p_business_group_id Yes Number The ID of the Business Group
164 -- p_information_type Yes Varchar2 Context fo the Assignment
165 -- Extra Info Row
166 -- p_aei_information_category No Varchar2
167 -- p_aei_information1 No Varchar2 Send P46 EDI Flag
168 -- p_aei_information2 No Varchar2 P46 Statement
169 -- p_aei_information3 No Varchar2 Flag for Send P46 EDI Flag
170 -- p_aei_information4 No Varchar2 Flag for Send P46 Student Loan
171
172 --
173 -- Post Success:
174 --
175 -- GB_P46 record will be created for assignment
176 -- New object version number should be returned
177 -- p_some_warning returned as null
178 --
179 -- Post Failure:
180 --
181 -- GB_P46 record will not be created, error messgae will be returned
182 --
183 -- Access Status:
184 -- Internal Development Use Only.
185 --
186 -- {End Of Comments}
187 --
188 /* BUG 1843915 Added parameter p_aei_information3 for
189 passing value of P46_SEND_EDI_FlAG */
190 procedure pay_gb_ins_p46
191 (p_validate in boolean default false
192 ,p_assignment_id in number
193 ,p_business_group_id in number
194 ,p_information_type in varchar2
195 ,p_aei_information_category in varchar2 default null
196 ,p_aei_information1 in varchar2 default null
197 ,p_aei_information2 in varchar2 default null
198 ,p_aei_information3 in varchar2 default null
199 ,p_aei_information4 in varchar2 default null
200 ,p_aei_information5 in varchar2 default null
201 ,p_aei_information6 in varchar2 default null
202 ,p_object_version_number out nocopy number
203 ,p_assignment_extra_info_id out nocopy number
204 );
205 --
206 --
207 -- ----------------------------------------------------------------------------
208 -- |-------------------------< pay_gb_upd_p46>-----------------------|
209 -- ----------------------------------------------------------------------------
210 -- {Start Of Comments}
211 --
212 -- Description:
213 -- Alternative interface to call update api for Assignment Extra Info table
214 -- to create a P46 context record for the assignment
215 --
216 -- Prerequisites : None
217 --
218 --
219 -- In Parameters:
220 -- Name Reqd Type Description
221 -- p_assignment_id Yes Number The ID of the assignment
222 -- p_business_group_id Yes Number The ID of the Business Group
223 -- p_information_type Yes Varchar2 Context fo the Assignment
224 -- Extra Info Row
225 -- p_aei_information_category No Varchar2
226 -- p_aei_information1 No Varchar2 Send P45(3) EDI Flag
227 -- p_aei_information2 No Varchar2 Previous Tax District
228 -- p_aei_information3 No Varchar2 Flag for Send P46 EDI Flag
229 -- p_object_version_number Yes Number Object Version Number
230 --
231 -- Post Success:
232 --
233 -- GB_P46 record will be updated for assignment
234 -- New object version number should be returned
235 -- p_some_warning returned as null
236 --
237 -- Post Failure:
238 --
239 -- GB_P46 record will not be updated, error messgae will be returned
240 --
241 -- Access Status:
242 -- Internal Development Use Only.
243 --
244 -- {End Of Comments}
245 --
246 /* BUG 1843915 Added parameter p_aei_information3 for
247 passing value of P46_SEND_EDI_FlAG */
248 procedure pay_gb_upd_p46
249 (p_validate in boolean default false
250 ,p_assignment_extra_info_id in number
251 ,p_business_group_id in number
252 ,p_object_version_number in out nocopy number
253 ,p_aei_information_category in varchar2 default null
254 ,p_aei_information1 in varchar2 default null
255 ,p_aei_information2 in varchar2 default null
256 ,p_aei_information3 in varchar2 default null
257 ,p_aei_information4 in varchar2 default null
258 ,p_aei_information5 in varchar2 default null
259 ,p_aei_information6 in varchar2 default null
260 );
261 --
262 --
263 -- ----------------------------------------------------------------------------
264 -- |-------------------------< pay_gb_ins_p46_pennot>-----------------------|
265 -- ----------------------------------------------------------------------------
266 -- {Start Of Comments}
267 --
268 -- Description:
269 -- Alternative interface to call insert api for Assignment Extra Info table
270 -- to create a P46_PENNOT context record for the assignment
271 --
272 -- Prerequisites : None
273 --
274 --
275 -- In Parameters:
276 -- Name Reqd Type Description
277 -- p_assignment_id Yes Number The ID of the assignment
278 -- p_business_group_id Yes Number The ID of the Business Group
279 -- p_information_type Yes Varchar2 Context fo the Assignment
280 -- Extra Info Row
281 -- p_aei_information_category No Varchar2
282 -- p_aei_information1 No Varchar2 Send P46_PENNOT EDI Flag
283 -- p_aei_information2 No Varchar2 Annual Pension
284 -- p_aei_information3 No Varchar2 Date Pension Started
285 --
286 -- Bug 1843915
287 -- p_aei_information4 No Varchar2 P46 Pennot Send EDI Flag
288 -- Post Success:
289 --
290 -- GB_P46_PENNOT record will be created for assignment
291 -- New object version number should be returned
292 --
293 -- Post Failure:
294 --
295 -- GB_P46_PENNOT record will not be created, error messgae will be returned
296 --
297 -- Access Status:
298 -- Internal Development Use Only.
299 --
300 -- {End Of Comments}
301 --
302 procedure pay_gb_ins_p46_pennot
303 (p_validate in boolean default false
304 ,p_assignment_id in number
305 ,p_business_group_id in number
306 ,p_information_type in varchar2
307 ,p_aei_information_category in varchar2 default null
308 ,p_aei_information1 in varchar2 default null
309 ,p_aei_information2 in varchar2 default null
310 ,p_aei_information3 in varchar2 default null
311 ,p_aei_information4 in varchar2 default null
312 ,p_aei_information5 in varchar2 default null
313 ,p_aei_information6 in varchar2 default null
314 ,p_aei_information7 in varchar2 default null
315 ,p_aei_information8 in varchar2 default null
316 ,p_aei_information9 in varchar2 default null
317 ,p_aei_information10 in varchar2 default null
318 ,p_aei_information11 in varchar2 default null
319 ,p_object_version_number out nocopy number
320 ,p_assignment_extra_info_id out nocopy number );
321 --
322 --
323 -- ----------------------------------------------------------------------------
324 -- |-------------------------< pay_gb_upd_p46_pennot>-----------------------|
325 -- ----------------------------------------------------------------------------
326 -- {Start Of Comments}
327 --
331 --
328 -- Description:
329 -- Alternative interface to call update api for Assignment Extra Info table
330 -- to create a P46_PENNOT context record for the assignment
332 -- Prerequisites : None
333 --
334 --
335 -- In Parameters:
336 -- Name Reqd Type Description
337 -- p_assignment_id Yes Number The ID of the assignment
338 -- p_business_group_id Yes Number The ID of the Business Group
339 -- p_information_type Yes Varchar2 Context fo the Assignment
340 -- Extra Info Row
341 -- p_aei_information_category No Varchar2
342 -- p_aei_information1 No Varchar2 Send P46_PENNOT EDI Flag
343 -- p_aei_information2 No Varchar2 Annual Pension
344 -- p_aei_information3 No Varchar2 Date Pension Started
345 -- p_object_version_number Yes Number Object Version Number
346 --
347 -- Bug 1843915
348 -- p_aei_information4 No Varchar2 P46 Pennot Send EDI Flag
349
350 -- Post Success:
351 --
352 -- GB_P46 record will be updated for assignment
353 -- New object version number should be returned
354 -- p_some_warning returned as null
355 --
356 -- Post Failure:
357 --
358 -- GB_P46 record will not be updated, error messgae will be returned
359 --
360 -- Access Status:
361 -- Internal Development Use Only.
362 --
363 -- {End Of Comments}
364 --
365 procedure pay_gb_upd_p46_pennot
366 (p_validate in boolean default false
367 ,p_assignment_extra_info_id in number
368 ,p_business_group_id in number
369 ,p_object_version_number in out nocopy number
370 ,p_aei_information_category in varchar2 default null
371 ,p_aei_information1 in varchar2 default null
372 ,p_aei_information2 in varchar2 default null
373 ,p_aei_information3 in varchar2 default null
374 ,p_aei_information4 in varchar2 default null
375 ,p_aei_information5 in varchar2 default null
376 ,p_aei_information6 in varchar2 default null
377 ,p_aei_information7 in varchar2 default null
378 ,p_aei_information8 in varchar2 default null
379 ,p_aei_information9 in varchar2 default null
380 ,p_aei_information10 in varchar2 default null
381 ,p_aei_information11 in varchar2 default null
382 );
383 -----------------------------------------------------------------------------
384 -- |-------------------------< pay_gb_ins_p45_info>-----------------------|
385 -- --------------------------------------------------------------------------
386 procedure pay_gb_ins_p45_info
387 -- {Start Of Comments}
388 --
389 -- Description:
390 -- Interface to call insert api for Assignment Extra Info table
391 -- to create a GB_P45 context record for the assignment.
392 --
393 -- Prerequisites : None
394 --
395 --
396 -- In Parameters:
397 -- Name Reqd Type Description
398 -- p_assignment_id Yes Number The ID of the assignment
399 -- p_business_group_id Yes Number The ID of the Business Group
400 -- p_person_id Yes Number The ID for the Person
401 -- p_effective_date Yes Date The date used to determine
402 -- the current datetracked row
403 -- for the person and asg.
404 -- p_aggregated_paye_flag No Varchar2 The Flag held on the person
405 -- record to determine whether
406 -- the persons PAYE is aggregated
407 -- p_information_type Yes Varchar2 Context fo the Assignment
408 -- Extra Info Row
409 -- p_aei_information_category No Varchar2
410 -- p_aei_information1 No Varchar2 P45 Issued flag
411 -- p_aei_information2 No Varchar2 P45 Marked for print flag
412 -- p_aei_information3 No Varchar2 Manual issue date
413 -- p_aei_information4 No Varchar2 P45 Override date
414 -- p_object_version_number Yes Number Object Version Number
415 --
416 --
417 -- Post Success:
418 --
419 -- GB_P45 record will be inserted for assignment with the extra information
420 -- set accordingly. The following OUT parameters are set:
421 --
422 -- Name Type Description
423 -- p_object_version_number Number New object version number should be set
424 -- and returned.
425 -- p_assignment_extra_info_id Number The new assignment extra info ID
426 -- as the primary key of the record.
427 --
428 -- Post Failure:
429 --
430 -- GB_P45 record will not be inserted, error messgae will be returned
431 --
432 -- Access Status:
433 -- Internal Development Use Only.
434 --
435 -- {End Of Comments}
436 --
437 (p_validate in boolean default false
438 ,p_assignment_id in number
439 ,p_business_group_id in number
440 ,p_person_id in number
441 ,p_effective_date in date
442 ,p_aggregated_paye_flag in varchar2 default null
443 ,p_information_type in varchar2
444 ,p_aei_information_category in varchar2 default null
445 ,p_aei_information1 in varchar2 default null
446 ,p_aei_information2 in varchar2 default null
447 ,p_aei_information3 in varchar2 default null
451 );
448 ,p_aei_information4 in varchar2 default null
449 ,p_object_version_number out nocopy number
450 ,p_assignment_extra_info_id out nocopy number
452 -- -----------------------------------------------------------------------
453 -- |-------------------------< pay_gb_upd_p45_info>-----------------------|
454 -- -----------------------------------------------------------------------
455 -- {Start Of Comments}
456 --
457 -- Description:
458 -- Interface to call update api for Assignment Extra Info table
459 -- to create a GB_P45 context record for the assignment.
460 --
461 -- Prerequisites : None
462 --
463 --
464 -- In Parameters:
465 -- Name Reqd Type Description
466 -- p_validate No Boolean If true, the database
467 -- remains unchanged. If false
468 -- then the record will be
469 -- created in the database.
470 -- p_assignment_extra_info_id Yes Number Primary Key ID of the
471 -- Assignment Extra Info record.
472 -- p_business_group_id Yes Number The ID of the Business Group
473 -- p_assignment_id Yes Number The ID of the assignment
474 -- p_person_id Yes Number The ID for the Person
475 -- p_effective_date Yes Date The date used to determine
476 -- the current datetracked row
477 -- for the person and asg.
478 -- p_aggregated_paye_flag No Varchar2 The Flag held on the person
479 -- record to determine whether
480 -- the persons PAYE is aggregated
481 -- p_object_version_number Yes Number Object Version Number
482 -- p_aei_information_category No Varchar2
483 -- p_aei_information1 No Varchar2 P45 Issued flag
484 -- p_aei_information2 No Varchar2 P45 Marked for print flag
485 -- p_aei_information3 No Varchar2 Manual issue date
486 -- p_aei_information4 No Varchar2 P45 Override date
487 --
488 --
489 -- Post Success:
490 --
491 -- GB_P45 record will be updated for assignment with the extra information
492 -- set accordingly. The following OUT parameters are set:
493 --
494 -- Name Type Description
495 -- p_object_version_number Number increased object version number should be set
496 -- and returned.
497 --
498 -- Post Failure:
499 --
500 -- GB_P45 record will not be updated, error messgae will be returned
501 --
502 -- Access Status:
503 -- Internal Development Use Only.
504 --
505 -- {End Of Comments}
506 --
507 procedure pay_gb_upd_p45_info
508 (p_validate in boolean default false
509 ,p_assignment_extra_info_id in number
510 ,p_business_group_id in number
511 ,p_assignment_id in number
512 ,p_person_id in number
513 ,p_effective_date in date
514 ,p_aggregated_paye_flag in varchar2 default null
515 ,p_object_version_number in out nocopy number
516 ,p_aei_information_category in varchar2 default null
517 ,p_aei_information1 in varchar2 default null
518 ,p_aei_information2 in varchar2 default null
519 ,p_aei_information3 in varchar2 default null
520 ,p_aei_information4 in varchar2 default null
521 );
522 --
523 -- -----------------------------------------------------------------------
524 -- |-------------------------< pay_gb_del_p45_info>-----------------------|
525 -- -----------------------------------------------------------------------
526 -- {Start Of Comments}
527 --
528 -- Description:
529 -- Interface to call delete api for Assignment Extra Info table
530 -- to delete a GB_P45 context record for the assignment.
531 --
532 -- Prerequisites : None
533 --
534 --
535 -- In Parameters:
536 -- Name Reqd Type Description
537 -- p_validate No Boolean If true, the database
538 -- remains unchanged. If false
539 -- then the record will be
540 -- created in the database.
541 -- p_assignment_extra_info_id Yes Number Primary Key ID of the
542 -- Assignment Extra Info record.
543 -- p_business_group_id Yes Number The ID of the Business Group
544 -- p_object_version_number Yes Number Object Version Number
545 --
546 --
547 -- Post Success:
548 --
549 -- GB_P45 record will be deleted for assignment with the extra information
550 -- set accordingly.
551 --
552 -- Post Failure:
553 --
554 -- GB_P45 record will not be deleted, error messgae will be returned
555 --
556 -- Access Status:
557 -- Internal Development Use Only.
558 --
559 -- {End Of Comments}
560 --
561 procedure pay_gb_del_p45_info
562 (p_validate in boolean default false
563 ,p_assignment_extra_info_id in number
564 ,p_business_group_id in number
565 ,p_object_version_number in number
566 );
567 --
568
569 --P46(Expat):Added API procedures
570 --
571 -- ----------------------------------------------------------------------------
572 -- |-------------------------< pay_gb_ins_p46_expat>-----------------------|
576 -- Description:
573 -- ----------------------------------------------------------------------------
574 -- {Start Of Comments}
575 --
577 -- Alternative interface to call insert api for Assignment Extra Info table
578 -- to create a P46(Expat) context record for the assignment
579 --
580 -- Prerequisites : None
581 --
582 -- Post Success:
583 --
584 -- GB_P46_expat record will be created for assignment
585 -- New object version number should be returned
586 -- p_some_warning returned as null
587 --
588 -- Post Failure:
589 --
590 -- GB_P46_expat record will not be created, error messgae will be returned
591 --
592 -- Access Status:
593 -- Internal Development Use Only.
594 --
595 -- {End Of Comments}
596
597 procedure pay_gb_ins_p46_expat
598 (p_validate in boolean default false
599 ,p_assignment_id in number
600 ,p_business_group_id in number
601 ,p_information_type in varchar2
602 ,p_aei_information_category in varchar2 default null
603 ,p_aei_information1 in varchar2 default null
604 ,p_aei_information2 in varchar2 default null
605 ,p_aei_information3 in varchar2 default null
606 ,p_aei_information4 in varchar2 default null
607 ,p_aei_information5 in varchar2 default null
608 ,p_aei_information6 in varchar2 default null
609 ,p_aei_information7 in varchar2 default null
610 ,p_object_version_number out nocopy number
611 ,p_assignment_extra_info_id out nocopy number
612 );
613 --
614 --
615 -- ----------------------------------------------------------------------------
616 -- |-------------------------< pay_gb_upd_p46_expat>-----------------------|
617 -- ----------------------------------------------------------------------------
618 -- {Start Of Comments}
619 --
620 -- Description:
621 -- Alternative interface to call update api for Assignment Extra Info table
622 -- to create a P46 context record for the assignment
623 --
624 -- Prerequisites : None
625 --
626 -- Post Success:
627 --
628 -- GB_P46_expat record will be updated for assignment
629 -- New object version number should be returned
630 -- p_some_warning returned as null
631 --
632 -- Post Failure:
633 --
634 -- GB_P46_expat record will not be updated, error messgae will be returned
635 --
636 -- Access Status:
637 -- Internal Development Use Only.
638 --
639 -- {End Of Comments}
640 --
641
642 procedure pay_gb_upd_p46_expat
643 (p_validate in boolean default false
644 ,p_assignment_extra_info_id in number
645 ,p_business_group_id in number
646 ,p_object_version_number in out nocopy number
647 ,p_aei_information_category in varchar2 default null
648 ,p_aei_information1 in varchar2 default null
649 ,p_aei_information2 in varchar2 default null
650 ,p_aei_information3 in varchar2 default null
651 ,p_aei_information4 in varchar2 default null
652 ,p_aei_information5 in varchar2 default null
653 ,p_aei_information6 in varchar2 default null
654 ,p_aei_information7 in varchar2 default null
655 );
656
657
658
659 -- ----------------------------------------------------------------------------
660 -- |-------------------------< pay_gb_ins_rti_new_strt>-----------------------|
661 -- ----------------------------------------------------------------------------
662 -- {Start Of Comments}
663 --
664 -- Description:
665 -- Alternative interface to call update api for Assignment Extra Info table
666 -- to create a RTI New Starter context record for the assignment
667 --
668 -- Prerequisites : None
669 --
670 -- Post Success:
671 --
672 -- GB_RTI_NEW record will be inserted for assignment
673 -- New object version number should be returned
674 -- p_some_warning returned as null
675 --
676 -- Post Failure:
677 --
678 -- GB_RTI_NEW record will not be updated, error messgae will be returned
679 --
680 -- Access Status:
681 -- Internal Development Use Only.
682 --
683 -- {End Of Comments}
684 --
685 procedure pay_gb_ins_rti_new_strt
686 (p_validate in boolean default false
687 ,p_assignment_id in number
688 ,p_business_group_id in number
689 ,p_information_type in varchar2 default null
690 ,p_aei_information_category in varchar2 default null
691 ,p_aei_information1 in varchar2 default null
692 ,p_aei_information2 in varchar2 default null
693 ,p_aei_information3 in varchar2 default null
694 ,p_aei_information4 in varchar2 default null
695 ,p_aei_information5 in varchar2 default null
696 ,p_aei_information6 in varchar2 default null
697 ,p_aei_information7 in varchar2 default null
698 ,p_aei_information8 in varchar2 default null
699 ,p_aei_information9 in varchar2 default null
700 ,p_aei_information10 in varchar2 default null
701 ,p_aei_information11 in varchar2 default null
702 ,p_aei_information12 in varchar2 default null
703 ,p_aei_information13 in varchar2 default null
704 ,p_aei_information14 in varchar2 default null
705 ,p_aei_information15 in varchar2 default null
706 ,p_aei_information16 in varchar2 default null
707 ,p_aei_information17 in varchar2 default null
711 ,p_assignment_extra_info_id out nocopy number
708 ,p_aei_information18 in varchar2 default null
709 ,p_aei_information19 in varchar2 default null
710 ,p_object_version_number out nocopy number
712 );
713
714
715 -- ----------------------------------------------------------------------------
716 -- |-------------------------< pay_gb_upd_rti_new_strt>-----------------------|
717 -- ----------------------------------------------------------------------------
718 -- {Start Of Comments}
719 --
720 -- Description:
721 -- Alternative interface to call update api for Assignment Extra Info table
722 -- to create a RTI New Starter context record for the assignment
723 --
724 -- Prerequisites : None
725 --
726 -- Post Success:
727 --
728 -- GB_RTI_NEW record will be updated for assignment
729 -- New object version number should be returned
730 -- p_some_warning returned as null
731 --
732 -- Post Failure:
733 --
734 -- GB_RTI_NEW record will not be updated, error messgae will be returned
735 --
736 -- Access Status:
737 -- Internal Development Use Only.
738 --
739 -- {End Of Comments}
740 --
741 procedure pay_gb_upd_rti_new_strt
742 (p_validate in boolean default false
743 ,p_assignment_extra_info_id in number
744 ,p_business_group_id in number
745 ,p_object_version_number in out nocopy number
746 ,p_aei_information_category in varchar2 default null
747 ,p_aei_information1 in varchar2 default null
748 ,p_aei_information2 in varchar2 default null
749 ,p_aei_information3 in varchar2 default null
750 ,p_aei_information4 in varchar2 default null
751 ,p_aei_information5 in varchar2 default null
752 ,p_aei_information6 in varchar2 default null
753 ,p_aei_information7 in varchar2 default null
754 ,p_aei_information8 in varchar2 default null
755 ,p_aei_information9 in varchar2 default null
756 ,p_aei_information10 in varchar2 default null
757 ,p_aei_information11 in varchar2 default null
758 ,p_aei_information12 in varchar2 default null
759 ,p_aei_information13 in varchar2 default null
760 ,p_aei_information14 in varchar2 default null
761 ,p_aei_information15 in varchar2 default null
762 ,p_aei_information16 in varchar2 default null
763 ,p_aei_information17 in varchar2 default null
764 ,p_aei_information18 in varchar2 default null
765 ,p_aei_information19 in varchar2 default null
766 );
767 --
768
769
770 -- ----------------------------------------------------------------------------
771 -- |-------------------------< pay_gb_ins_rti_agg_strt>-----------------------|
772 -- ----------------------------------------------------------------------------
773 -- {Start Of Comments}
774 --
775 -- Description:
776 -- Alternative interface to call update api for Assignment Extra Info table
777 -- to create a RTI Aggregated assignment context record for the assignment
778 --
779 -- Prerequisites : None
780 --
781 -- Post Success:
782 --
783 -- GB_RTI_AGG_ASGrecord will be inserted for assignment
784 -- New object version number should be returned
785 -- p_some_warning returned as null
786 --
787 -- Post Failure:
788 --
789 -- GB_RTI_AGG_ASG record will not be updated, error messgae will be returned
790 --
791 -- Access Status:
792 -- Internal Development Use Only.
793 --
794 -- {End Of Comments}
795 --
796 procedure pay_gb_ins_rti_agg_strt
797 (p_validate in boolean default false
798 ,p_assignment_id in number
799 ,p_business_group_id in number
800 ,p_information_type in varchar2 default null
801 ,p_aei_information_category in varchar2 default null
802 ,p_aei_information1 in varchar2 default null
803 ,p_aei_information2 in varchar2 default null
804 ,p_aei_information3 in varchar2 default null
805 ,p_aei_information4 in varchar2 default null
806 ,p_object_version_number out nocopy number
807 ,p_assignment_extra_info_id out nocopy number
808 );
809
810
811 -- ----------------------------------------------------------------------------
812 -- |-------------------------< pay_gb_upd_rti_agg_strt>-----------------------|
813 -- ----------------------------------------------------------------------------
814 -- {Start Of Comments}
815 --
816 -- Description:
817 -- Alternative interface to call update api for Assignment Extra Info table
818 -- to create a RTI Aggregated Assignment context record for the assignment
819 --
820 -- Prerequisites : None
821 --
822 -- Post Success:
823 --
824 -- GB_RTI_AGG record will be updated for assignment
825 -- New object version number should be returned
826 -- p_some_warning returned as null
827 --
828 -- Post Failure:
829 --
830 -- GB_RTI_AGG record will not be updated, error messgae will be returned
831 --
832 -- Access Status:
833 -- Internal Development Use Only.
834 --
835 -- {End Of Comments}
836 --
837 procedure pay_gb_upd_rti_agg_strt
838 (p_validate in boolean default false
839 ,p_assignment_extra_info_id in number
840 ,p_business_group_id in number
841 ,p_object_version_number in out nocopy number
842 ,p_aei_information_category in varchar2 default null
843 ,p_aei_information1 in varchar2 default null
844 ,p_aei_information2 in varchar2 default null
845 ,p_aei_information3 in varchar2 default null
846 ,p_aei_information4 in varchar2 default null
847 );
848 --
849
850
851 end pay_gb_aei_api;
[Home] [Help]