[Home] [Help]
PACKAGE: APPS.PER_COBRA_ECI
Source
1 PACKAGE per_cobra_eci AS
2 /* $Header: pecobeci.pkh 120.2.12000000.1 2007/01/21 21:24:23 appldev ship $ */
3 Type g_rec_type Is Record
4 (
5 cobra_dependent_id number(15),
6 cobra_coverage_enrollment_id number(15),
7 contact_relationship_id number(15),
8 effective_start_date date,
9 effective_end_date date,
10 object_version_number number(9),
11 attribute_category varchar2(30),
12 attribute1 varchar2(150),
13 attribute2 varchar2(150),
14 attribute3 varchar2(150),
15 attribute4 varchar2(150),
16 attribute5 varchar2(150),
17 attribute6 varchar2(150),
18 attribute7 varchar2(150),
19 attribute8 varchar2(150),
20 attribute9 varchar2(150),
21 attribute10 varchar2(150),
22 attribute11 varchar2(150),
23 attribute12 varchar2(150),
24 attribute13 varchar2(150),
25 attribute14 varchar2(150),
26 attribute15 varchar2(150),
27 attribute16 varchar2(150),
28 attribute17 varchar2(150),
29 attribute18 varchar2(150),
30 attribute19 varchar2(150),
31 attribute20 varchar2(150)
32 );
33 --
34 -- ----------------------------------------------------------------------------
35 -- | Global Definitions - Internal Development Use Only |
36 -- ----------------------------------------------------------------------------
37 --
38 g_old_rec g_rec_type; -- Global record definition
39 --
40 --
41 --
42 -- Name person_disabled
43 --
44 -- Purpose
45 --
46 -- Check that the person was disabled at the start of their COBRA coverage
47 -- or during the first sixty days of their COBRA coverage.
48 --
49 -- Example
50 --
51 -- Notes
52 --
53 FUNCTION person_disabled (p_person_id IN NUMBER,
54 p_qualifying_start_date IN DATE) RETURN BOOLEAN;
55 --
56 -- Name check_cobra_coverage_period
57 --
58 -- Purpose
59 --
60 -- Check that the coverage period defaulted from the qualifying event
61 -- is in fact right. Legislative changes have happened over time so check
62 -- what the coverage period is at a particular time. The session date is
63 -- not used to track time but instead the qualifying event start date as this
64 -- is the day that they are starting the coverage.
65 --
66 -- Example
67 --
68 -- Notes
69 --
70 PROCEDURE check_cobra_coverage_period
71 (p_qualifying_event IN VARCHAR2,
72 p_qualifying_start_date IN DATE,
73 p_type_code IN VARCHAR2,
74 p_coverage OUT nocopy NUMBER,
75 p_coverage_uom OUT nocopy VARCHAR2);
76 --
77 --
78 -- Name hr_cobra_chk_event_eligible
79 --
80 -- Purpose
81 --
82 -- check whether or not the enrolled is infact
83 -- entitled to the Qualifying event entered
84 --
85 -- Example
86 --
87 -- Notes
88 --
89 PROCEDURE hr_cobra_chk_event_eligible (p_organization_id NUMBER,
90 p_business_group_id NUMBER,
91 p_assignment_id NUMBER,
92 p_person_id NUMBER,
93 p_position_id NUMBER,
94 p_qualifying_event VARCHAR2,
95 p_qualifying_date IN OUT nocopy DATE );
96 --
97 --
98 --
99 -- Name hr_cobra_chk_benefits_exist
100 --
101 -- Name hr_cobra_chk_benefits_exist
102 --
103 -- Purpose
104 --
105 -- Checks that an employee is currently enolled in COBRA eligible
106 -- benefit plans
107 --
108 -- Arguments
109 --
110 -- p_assignment_id NUMBER
111 -- p_qualifying_date DATE
112 --
113 -- Example
114 --
115 -- Notes
116 --
117 PROCEDURE hr_cobra_chk_benefits_exist ( p_assignment_id NUMBER,
118 p_qualifying_date DATE );
119 --
120 --
121 --
122 -- Name hr_get_assignment_info
123 --
124 -- Purpose
125 --
126 -- gets assignment's org id
127 --
128 -- Arguments
129 --
130 -- Example
131 --
132 -- Notes
133 --
134 PROCEDURE hr_get_assignment_info (p_assignment_id NUMBER,
135 p_business_group_id NUMBER,
136 p_qualifying_date DATE,
137 p_organization_id IN OUT nocopy NUMBER,
138 p_position_id IN OUT nocopy NUMBER);
139 --
140 --
141 --
142 -- Name hr_cobra_chk_elect_status
143 --
144 -- Purpose
145 --
146 -- check to see if a status of 'ELECT' exists for the
147 -- COBRA enrollment
148 --
149 -- Arguments
150 --
151 -- p_cobra_coverage_enrollment_id NUMBER
152 --
153 -- Example
154 --
155 -- Notes
156 --
157 -- Called from client hr_cobra_chk_cov_dates_null
158 -- returns TRUE if ELECT status exists.
159 --
160 FUNCTION hr_cobra_chk_elect_status (p_cobra_coverage_enrollment_id NUMBER) RETURN BOOLEAN;
161 --
162 --
163 --
164 -- Name hr_cobra_get_await_meaning
165 --
166 -- Purpose
167 --
168 -- gets the meaning of the statsus 'AWAIT' for initial
169 -- default of this field in the COBRA Coverage Enrollment
170 -- block. This meaning could be changed by the user.
171 --
172 -- Arguments
173 --
174 -- None
175 --
176 FUNCTION hr_cobra_get_await_meaning RETURN VARCHAR2;
177 --
178 --
179 --
180 -- Name hr_cobra_get_period_type
181 --
182 -- Purpose
183 --
184 -- Retrives default time period for payment cycle
185 --
186 -- Arguments
187 --
188 -- None
189 --
190 FUNCTION hr_cobra_get_period_type RETURN VARCHAR2;
191 --
192 --
193 --
194 -- Name hr_cobra_do_cce_insert
195 --
196 -- Purpose
197 --
198 -- Bundles insert calls and logic
199 --
200 -- Arguments
201 --
202 -- Example
203 --
204 -- Notes
205 --
206 PROCEDURE hr_cobra_do_cce_insert ( p_Rowid IN OUT nocopy VARCHAR2,
207 p_Cobra_Coverage_Enrollment_Id IN OUT nocopy NUMBER,
208 p_Business_Group_Id NUMBER,
209 p_Assignment_Id NUMBER,
210 p_Period_Type VARCHAR2,
211 p_Qualifying_Date IN OUT nocopy DATE,
212 p_Qualifying_Event VARCHAR2,
213 p_Coverage_End_Date DATE,
214 p_Coverage_Start_Date DATE,
215 p_Termination_Reason VARCHAR2,
216 p_Contact_Relationship_Id NUMBER,
217 p_Attribute_Category VARCHAR2,
218 p_Attribute1 VARCHAR2,
219 p_Attribute2 VARCHAR2,
220 p_Attribute3 VARCHAR2,
221 p_Attribute4 VARCHAR2,
222 p_Attribute5 VARCHAR2,
223 p_Attribute6 VARCHAR2,
224 p_Attribute7 VARCHAR2,
225 p_Attribute8 VARCHAR2,
226 p_Attribute9 VARCHAR2,
227 p_Attribute10 VARCHAR2,
228 p_Attribute11 VARCHAR2,
229 p_Attribute12 VARCHAR2,
230 p_Attribute13 VARCHAR2,
231 p_Attribute14 VARCHAR2,
232 p_Attribute15 VARCHAR2,
233 p_Attribute16 VARCHAR2,
234 p_Attribute17 VARCHAR2,
235 p_Attribute18 VARCHAR2,
236 p_Attribute19 VARCHAR2,
237 p_Attribute20 VARCHAR2,
238 p_Grace_Days NUMBER,
239 p_comments VARCHAR2,
240 p_organization_id NUMBER,
241 p_person_id NUMBER,
242 p_position_id NUMBER,
243 p_status VARCHAR2,
244 p_status_date DATE,
245 p_amount_charged IN OUT nocopy VARCHAR2,
246 p_first_payment_due_date DATE,
247 p_event_coverage NUMBER);
248 --
249 --
250 --
251 -- Name hr_cobra_ins_benefits;
252 --
253 -- Purpose
254 --
255 -- Creates row in PER_COBRA_COVERAGE_BENEFITS
256 --
257 -- Arguments
258 --
259 -- p_cobra_coverage_enrollment_id
260 -- p_business_group_id
261 -- p_assignment_id
262 -- p_qualifying_date
263 --
264 -- Example
265 --
266 -- Notes
267 --
268 PROCEDURE hr_cobra_ins_benefits (p_cobra_coverage_enrollment_id NUMBER,
269 p_business_group_id NUMBER,
270 p_assignment_id NUMBER,
271 p_qualifying_date DATE);
272 --
273 --
274 --
275 -- Name hr_cobra_calc_amt_charged
276 --
277 -- Purpose
278 --
279 -- Calculates the sum of the COBRA costs for ACCepted ben plans
280 --
281 -- Arguments
282 -- Added session date to get the correct cobra amount charged, part of fix#4599753
283 -- p_cobra_coverage_enrollment_id
284 -- p_session_date
285 --
286 -- Example
287 --
288 -- Notes
289 --
290 FUNCTION hr_cobra_calc_amt_charged ( p_cobra_coverage_enrollment_id NUMBER,
291 p_session_date DATE) RETURN VARCHAR2;
292 --
293 --
294 --
295 -- Name hr_cobra_ins_schedule
296 --
297 -- Purpose
298 --
299 -- insert payment schedules into PER_SCHED_COBRA_PAYMENTS
300 --
301 -- Arguments
302 --
303 -- p_business_group_id NUMBER
304 -- p_cobra_coverage_enrollment_id NUMBER
305 -- p_event_coverage NUMBER
306 -- p_first_payment_due_date DATE
307 -- p_amount_charged NUMBER
308 -- p_grace_days NUMBER
309 --
310 -- Example
311 --
312 -- Notes
313 --
314 PROCEDURE hr_cobra_ins_schedule (p_business_group_id NUMBER,
315 p_cobra_coverage_enrollment_id NUMBER,
316 p_event_coverage NUMBER,
317 p_first_payment_due_date DATE,
318 p_amount_charged NUMBER,
319 p_grace_days NUMBER);
320
324 p_new_grace_days NUMBER);
321 -- Added new procedure as part of fix for bug#4599753
322 PROCEDURE correct_cobra_scp_graceperiod(p_cobra_coverage_enrollment_id NUMBER,
323 p_session_date DATE,
325 --
326 --
327 --
328 -- Name hr_cobra_do_cce_update
329 --
330 -- Purpose
331 --
332 -- Update evwent handler - bundles update logic and parameters
333 --
334 -- Arguments
335 --
336 --
337 -- Example
338 --
339 -- Notes
340 --
341 --
342 --
343 PROCEDURE hr_cobra_do_cce_update ( p_Rowid IN OUT nocopy VARCHAR2,
344 p_Cobra_Coverage_Enrollment_Id IN OUT nocopy NUMBER,
345 p_Business_Group_Id NUMBER,
346 p_Assignment_Id NUMBER,
347 p_Period_Type VARCHAR2,
348 p_Qualifying_Date DATE,
349 p_Qualifying_Event VARCHAR2,
350 p_Coverage_End_Date DATE,
351 p_Coverage_Start_Date DATE,
352 p_Termination_Reason VARCHAR2,
353 p_Contact_Relationship_Id NUMBER,
354 p_Attribute_Category VARCHAR2,
355 p_Attribute1 VARCHAR2,
356 p_Attribute2 VARCHAR2,
357 p_Attribute3 VARCHAR2,
358 p_Attribute4 VARCHAR2,
359 p_Attribute5 VARCHAR2,
360 p_Attribute6 VARCHAR2,
361 p_Attribute7 VARCHAR2,
362 p_Attribute8 VARCHAR2,
363 p_Attribute9 VARCHAR2,
364 p_Attribute10 VARCHAR2,
365 p_Attribute11 VARCHAR2,
366 p_Attribute12 VARCHAR2,
367 p_Attribute13 VARCHAR2,
368 p_Attribute14 VARCHAR2,
369 p_Attribute15 VARCHAR2,
370 p_Attribute16 VARCHAR2,
371 p_Attribute17 VARCHAR2,
372 p_Attribute18 VARCHAR2,
373 p_Attribute19 VARCHAR2,
374 p_Attribute20 VARCHAR2,
375 p_Grace_Days NUMBER,
376 p_comments VARCHAR2,
377 p_event_coverage NUMBER,
378 p_session_date DATE,
379 p_status VARCHAR2,
380 p_status_date IN OUT nocopy DATE,
381 p_status_meaning IN OUT nocopy VARCHAR2,
382 p_first_payment_due_date DATE,
386 --
383 p_old_first_payment_due_date VARCHAR2,
384 p_amount_charged IN OUT nocopy VARCHAR2 );
385 --
387 --
388 -- Name hr_cobra_get_current_status
389 --
390 -- Purpose
391 --
392 -- gets the latest cobra status
393 --
394 -- Arguments
395 --
396 -- Example
397 --
398 -- Notes
399 --
400 PROCEDURE hr_cobra_get_current_status ( p_cobra_coverage_enrollment_id NUMBER,
401 p_session_date DATE,
402 p_status IN OUT nocopy VARCHAR2,
403 p_status_meaning IN OUT nocopy VARCHAR2,
404 p_status_date IN OUT nocopy DATE,
405 p_d_status_date IN OUT nocopy DATE );
406 --
407 --
408 --
409 -- Name hr_cobra_element_update
410 --
411 -- Purpose
412 --
413 -- update cobra coverage element
414 --
415 -- Arguments
416 --
417 -- Example
418 --
419 -- Notes
420 -- BUG2974921
421 --
422 function hr_cobra_update_element
423 (p_effective_date date
424 ,p_Cobra_Coverage_Enrollment_Id NUMBER
425 ,p_Business_Group_Id NUMBER
426 ,p_Assignment_Id NUMBER
427 ,p_amount_charged in out nocopy varchar2
428 ,p_cobra_coverage_benefit_id in out nocopy number
429 ,p_effective_start_date in out nocopy date
430 ,p_effective_end_date in out nocopy date
431 ) return boolean;
432 --
433 --
434 --
435 -- Name hr_cobra_do_ccs_insert
436 --
437 -- Purpose
438 --
439 -- insert bundle
440 --
441 -- Arguments
442 --
443 --
444 PROCEDURE hr_cobra_do_ccs_insert ( p_Rowid IN OUT nocopy VARCHAR2,
445 p_Cobra_Coverage_Status_Id IN OUT nocopy NUMBER,
446 p_Business_Group_Id NUMBER,
447 p_Cobra_Coverage_Enrollment_Id NUMBER,
448 p_Cobra_Coverage_Status_Type VARCHAR2,
449 p_Effective_Date DATE,
450 p_current_status IN OUT nocopy VARCHAR2,
451 p_current_status_meaning IN OUT nocopy VARCHAR2,
452 p_current_status_date IN OUT nocopy DATE,
453 p_current_d_status_date IN OUT nocopy DATE,
454 p_Attribute_Category VARCHAR2,
455 p_Attribute1 VARCHAR2,
456 p_Attribute2 VARCHAR2,
457 p_Attribute3 VARCHAR2,
458 p_Attribute4 VARCHAR2,
459 p_Attribute5 VARCHAR2,
460 p_Attribute6 VARCHAR2,
461 p_Attribute7 VARCHAR2,
462 p_Attribute8 VARCHAR2,
463 p_Attribute9 VARCHAR2,
464 p_Attribute10 VARCHAR2,
465 p_Attribute11 VARCHAR2,
466 p_Attribute12 VARCHAR2,
467 p_Attribute13 VARCHAR2,
468 p_Attribute14 VARCHAR2,
469 p_Attribute15 VARCHAR2,
470 p_Attribute16 VARCHAR2,
471 p_Attribute17 VARCHAR2,
472 p_Attribute18 VARCHAR2,
473 p_Attribute19 VARCHAR2,
474 p_Attribute20 VARCHAR2,
475 p_comments VARCHAR2,
476 p_session_date DATE );
477 --
478 --
479 --
480 -- Name hr_cobra_do_ccs_update
481 --
482 -- Purpose
483 --
484 -- update bundle
485 --
486 -- Arguments
487 --
488 PROCEDURE hr_cobra_do_ccs_update ( p_Rowid IN OUT nocopy VARCHAR2,
489 p_Cobra_Coverage_Status_Id IN OUT nocopy NUMBER,
490 p_Business_Group_Id NUMBER,
491 p_Cobra_Coverage_Enrollment_Id NUMBER,
492 p_Cobra_Coverage_Status_Type VARCHAR2,
493 p_Effective_Date DATE,
494 p_current_status IN OUT nocopy VARCHAR2,
495 p_current_status_meaning IN OUT nocopy VARCHAR2,
496 p_current_status_date IN OUT nocopy DATE,
500 p_Attribute2 VARCHAR2,
497 p_current_d_status_date IN OUT nocopy DATE,
498 p_Attribute_Category VARCHAR2,
499 p_Attribute1 VARCHAR2,
501 p_Attribute3 VARCHAR2,
502 p_Attribute4 VARCHAR2,
503 p_Attribute5 VARCHAR2,
504 p_Attribute6 VARCHAR2,
505 p_Attribute7 VARCHAR2,
506 p_Attribute8 VARCHAR2,
507 p_Attribute9 VARCHAR2,
508 p_Attribute10 VARCHAR2,
509 p_Attribute11 VARCHAR2,
510 p_Attribute12 VARCHAR2,
511 p_Attribute13 VARCHAR2,
512 p_Attribute14 VARCHAR2,
513 p_Attribute15 VARCHAR2,
514 p_Attribute16 VARCHAR2,
515 p_Attribute17 VARCHAR2,
516 p_Attribute18 VARCHAR2,
517 p_Attribute19 VARCHAR2,
518 p_Attribute20 VARCHAR2,
519 p_comments VARCHAR2,
520 p_session_date DATE );
521 --
522 --
523 --
524 -- Name hr_cobra_do_ccs_delete
525 --
526 -- Purpose
527 --
528 -- delete bundle
529 --
530 -- Arguments
531 --
532 PROCEDURE hr_cobra_do_ccs_delete ( p_Rowid VARCHAR2,
533 p_cobra_coverage_enrollment_id NUMBER,
534 p_session_date DATE,
535 p_status IN OUT nocopy VARCHAR2,
536 p_status_meaning IN OUT nocopy VARCHAR2,
537 p_status_date IN OUT nocopy DATE,
538 p_d_status_date IN OUT nocopy DATE );
539
540
541 --
542 -- Name hr_cobra_term_enroll
543 --
544 -- Purpose
545 -- Update COBRA Coverage End date with Session date when Cobra
546 -- event is terminated. Part of fix for bug#4599753
547 --
548 -- Arguments
549 --
550 -- p_business_group_id NUMBER
551 -- p_cobra_coverage_enrollment_id NUMBER
552 -- p_session_date DATE
553 -- p_qualifying_event VARCHAR2
554 -- p_coverage_start_date DATE
555 -- p_coverage_end_date DATE
556 --
557 PROCEDURE hr_cobra_term_enroll( p_business_group_id NUMBER,
558 p_cobra_coverage_enrollment_id NUMBER,
559 p_session_date DATE,
560 p_qualifying_event VARCHAR2,
561 p_coverage_start_date DATE,
562 p_coverage_end_date IN OUT nocopy DATE);
563
564
565 --
566 -- Name hr_cobra_term_dependents
567 --
568 -- Purpose
569 -- Update COBRA Dependent Effective_End_date with Session date when Cobra
570 -- event is terminated. Part of fix for bug#4599753
571 --
572 -- Arguments
573 --
574 -- p_business_group_id NUMBER
575 -- p_cobra_coverage_enrollment_id NUMBER
576 -- p_session_date DATE
577 -- p_qualifying_event VARCHAR2
578 -- p_coverage_start_date DATE
579 -- p_coverage_end_date DATE
580 --
581 PROCEDURE hr_cobra_term_dependents( p_business_group_id NUMBER,
582 p_cobra_coverage_enrollment_id NUMBER,
583 p_session_date DATE,
584 p_qualifying_event VARCHAR2,
585 p_coverage_start_date DATE,
586 p_coverage_end_date DATE);
587
588
589 --
590 -- Name hr_cobra_button_status
591 --
592 -- Purpose
593 --
594 -- Inserts COBRA Coverage Status according to which button the
595 -- user presses
596 --
597 -- Arguments
598 --
599 -- p_business_group_id NUMBER
600 -- p_cobra_coverage_enrollment_id NUMBER
601 -- p_status VARCHAR2
602 -- p_status_date DATE
603 --
604 PROCEDURE hr_cobra_button_status ( p_business_group_id NUMBER,
605 p_cobra_coverage_enrollment_id NUMBER,
606 p_session_date DATE,
607 p_status VARCHAR2,
608 p_cce_status IN OUT nocopy VARCHAR2,
612 --
609 p_status_date IN OUT nocopy DATE,
610 p_d_status_date IN OUT nocopy DATE,
611 p_status_meaning IN OUT nocopy VARCHAR2 );
613 --
614 --
615 -- ************************************
616 -- SCP - Schedule COBRA Payments Stuff
617 -- ************************************
618 --
619 --
620 --
621 -- Name hr_cobra_chk_dup_pay_due_date
622 --
623 -- Purpose
624 --
625 -- ensure that duplicate due dates are not entered.
626 --
627 -- Arguments
628 --
629 -- p_scheduled_cobra_payment_id NUMBER
630 -- p_cobra_coverage_enrollment_id NUMBER
631 -- p_due_date DATE
632 --
633 -- Example
634 --
635 -- Notes
636 --
637 PROCEDURE hr_cobra_chk_dup_pay_due_date ( p_scheduled_cobra_payment_id NUMBER,
638 p_cobra_coverage_enrollment_id NUMBER,
639 p_due_date DATE );
640 --
641 --
642 --
643 -- Name hr_cobra_do_scp_pre_insert
644 --
645 -- Purpose
646 --
647 -- Bundles pre-insert logic to server
648 --
649 -- Arguments
650 --
651 -- p_scheduled_cobra_payment_id NUMBER
652 -- p_cobra_coverage_enrollment_id NUMBER
653 -- p_due_date DATE
654 --
655 -- Example
656 --
657 -- Notes
658 --
659 PROCEDURE hr_cobra_do_scp_pre_insert ( p_scheduled_cobra_payment_id IN OUT nocopy NUMBER,
660 p_cobra_coverage_enrollment_id NUMBER,
661 p_due_date DATE );
662 --
663 --
664 --
665 -- Name hr_cobra_do_scp_pre_update
666 --
667 -- Purpose
668 --
669 -- Bundles pre-update logic to server
670 --
671 -- Arguments
672 --
673 -- p_scheduled_cobra_payment_id NUMBER
674 -- p_cobra_coverage_enrollment_id NUMBER
675 -- p_due_date DATE
676 --
677 -- Example
678 --
679 -- Notes
680 --
681 PROCEDURE hr_cobra_do_scp_pre_update ( p_scheduled_cobra_payment_id IN OUT nocopy NUMBER,
682 p_cobra_coverage_enrollment_id NUMBER,
683 p_due_date DATE );
684 --
685 --
686 --
687 -- Name
688 --
689 -- Purpose
690 --
691 -- defaults COBRA cost for chosen coverage and benefit plan
692 --
693 -- Arguments
694 --
695 -- p_element_type_id NUMBER
696 -- p_coverage_type VARCHAR2
697 -- p_qualifying_date DATE
698 -- p_business_group_id NUMBER
699 -- p_coverage_amount IN OUT VARCHAR2
700 -- p_basic_cost IN OUT VARCHAR2
701 --
702 -- Example
703 --
704 -- Notes
705 --
706 PROCEDURE hr_cobra_default_cobra_cost ( p_element_type_id NUMBER,
707 p_coverage_type VARCHAR2,
708 p_session_date DATE,
709 p_business_group_id NUMBER,
710 p_coverage_amount IN OUT nocopy VARCHAR2,
711 p_basic_cost IN OUT nocopy VARCHAR2);
712 --
713 --
714 --
715 -- Name hr_cobra_do_ccb_update
716 --
717 -- Purpose
718 --
719 -- bundles update logic
720 --
721 -- Arguments
722 --
723 -- Example
724 --
725 -- Notes
726 --
727 PROCEDURE hr_cobra_do_ccb_update ( p_Rowid IN OUT nocopy VARCHAR2,
728 p_Cobra_Coverage_Benefit_Id IN OUT nocopy NUMBER,
729 p_Effective_Start_Date DATE,
730 p_Effective_End_Date DATE,
731 p_Business_Group_Id NUMBER,
732 p_Cobra_Coverage_Enrollment_Id NUMBER,
733 p_Element_Type_Id NUMBER,
734 p_Accept_Reject_Flag VARCHAR2,
735 p_Coverage_Amount VARCHAR2,
736 p_Coverage_Type VARCHAR2,
737 p_Attribute_Category VARCHAR2,
738 p_Attribute1 VARCHAR2,
739 p_Attribute2 VARCHAR2,
740 p_Attribute3 VARCHAR2,
741 p_Attribute4 VARCHAR2,
742 p_Attribute5 VARCHAR2,
743 p_Attribute6 VARCHAR2,
744 p_Attribute7 VARCHAR2,
745 p_Attribute8 VARCHAR2,
746 p_Attribute9 VARCHAR2,
747 p_Attribute10 VARCHAR2,
751 p_Attribute14 VARCHAR2,
748 p_Attribute11 VARCHAR2,
749 p_Attribute12 VARCHAR2,
750 p_Attribute13 VARCHAR2,
752 p_Attribute15 VARCHAR2,
753 p_Attribute16 VARCHAR2,
754 p_Attribute17 VARCHAR2,
755 p_Attribute18 VARCHAR2,
756 p_Attribute19 VARCHAR2,
757 p_Attribute20 VARCHAR2,
758 p_qualifying_event VARCHAR2,
759 p_new_amount_charged IN OUT nocopy VARCHAR2 );
760 --
761 --
762 --
763 -- Name hr_cobra_lock_scp
764 --
765 -- Purpose
766 --
767 -- locks scp rows if cobra cost is being changed
768 --
769 -- Arguments
770 --
771 -- p_business_group_id
772 -- p_cobra_coverage_enrollment_id
773 --
774 --
775 PROCEDURE hr_cobra_lock_scp ( p_business_group_id NUMBER,
776 p_cobra_coverage_enrollment_id NUMBER);
777 --
778 --
779 --
780 -- Name hr_cobra_chk_rej_to_acc
781 --
782 -- Purpose
783 --
784 -- If the user changes from Reject to accept - should prompt them to manually
785 -- re-activate element entries for the particular benefit if the person enrolled
786 -- is to pay thriugh payroll.
787 --
788 -- returns TRUE if changing from rej to acc
789 --
790 -- Arguments
791 --
792 -- p_rowid
793 --
794 FUNCTION hr_cobra_chk_rej_to_acc (p_rowid VARCHAR2 ) RETURN BOOLEAN;
795 --
796 --
797 --
798 -- Name hr_cobra_do_ccb_post_update
799 --
800 -- Purpose
801 --
802 -- ccb post update logic
803 --
804 -- Arguments
805 --
806 -- p_cobra_coverage_enrollment_id NUMBER
807 -- p_first_payment_due_date DATE
808 -- d_amount_charged IN OUT VARCHAR2
809 --
810 PROCEDURE hr_cobra_do_ccb_post_update ( p_cobra_coverage_enrollment_id NUMBER,
811 p_new_amount_charged VARCHAR2,
812 p_session_date DATE );
813 --
814 --
815 FUNCTION get_basic_cost ( p_element_type_id NUMBER,
816 p_coverage_type VARCHAR2,
817 p_assignment_id NUMBER) RETURN NUMBER;
818 --
819 --
820 --
821 --
822 -- Name hr_cobra_correct_scp
823 --
824 -- Purpose
825 --
826 -- updates amount due of payment schedules if the
827 -- user has updated the cobra cost
828 --
829 -- Arguments
830 --
831 -- p_cobra_coverage_enrollment_id
832 -- p_new_amount_charged
833 --
834 -- Example
835 --
836 -- Notes
837 --
838 --
839 --
840 PROCEDURE hr_cobra_correct_scp( p_cobra_coverage_enrollment_id NUMBER,
841 p_session_date DATE );
842 --
843 PROCEDURE eci_init_form( p_assignment_id NUMBER,
844 p_business_group_id NUMBER,
845 p_qualifying_date DATE,
846 p_organization_id IN OUT nocopy NUMBER,
847 p_position_id IN OUT nocopy NUMBER,
848 p_await_meaning IN OUT nocopy VARCHAR2,
849 p_period_type IN OUT nocopy VARCHAR2);
850 --
851 PROCEDURE hr_cobra_do_cdp_insert(p_cobra_dependent_id out nocopy number,
852 p_cobra_coverage_enrollment_id in number,
853 p_contact_relationship_id in number,
854 p_effective_start_date in date,
855 p_effective_end_date in date,
856 p_object_version_number out nocopy number,
857 p_attribute_category in varchar2,
858 p_attribute1 in varchar2,
859 p_attribute2 in varchar2,
860 p_attribute3 in varchar2,
861 p_attribute4 in varchar2,
862 p_attribute5 in varchar2,
863 p_attribute6 in varchar2,
864 p_attribute7 in varchar2,
865 p_attribute8 in varchar2,
866 p_attribute9 in varchar2,
867 p_attribute10 in varchar2,
868 p_attribute11 in varchar2,
869 p_attribute12 in varchar2,
870 p_attribute13 in varchar2,
871 p_attribute14 in varchar2,
875 p_attribute18 in varchar2,
872 p_attribute15 in varchar2,
873 p_attribute16 in varchar2,
874 p_attribute17 in varchar2,
876 p_attribute19 in varchar2,
877 p_attribute20 in varchar2);
878 --
879 PROCEDURE hr_cobra_do_cdp_update(p_row_id in varchar2,
880 p_cobra_dependent_id in number,
881 p_cobra_coverage_enrollment_id in number,
882 p_contact_relationship_id in number,
883 p_effective_start_date in date,
884 p_effective_end_date in date,
885 p_object_version_number in out nocopy number,
886 p_attribute_category in varchar2,
887 p_attribute1 in varchar2,
888 p_attribute2 in varchar2,
889 p_attribute3 in varchar2,
890 p_attribute4 in varchar2,
891 p_attribute5 in varchar2,
892 p_attribute6 in varchar2,
893 p_attribute7 in varchar2,
894 p_attribute8 in varchar2,
895 p_attribute9 in varchar2,
896 p_attribute10 in varchar2,
897 p_attribute11 in varchar2,
898 p_attribute12 in varchar2,
899 p_attribute13 in varchar2,
900 p_attribute14 in varchar2,
901 p_attribute15 in varchar2,
902 p_attribute16 in varchar2,
903 p_attribute17 in varchar2,
904 p_attribute18 in varchar2,
905 p_attribute19 in varchar2,
906 p_attribute20 in varchar2);
907 --
908 PROCEDURE hr_cobra_do_cdp_delete(p_cobra_dependent_id in number,
909 p_effective_start_date in date,
910 p_effective_end_date in date,
911 p_object_version_number in number);
912 --
913 PROCEDURE hr_cobra_do_cdp_lock(p_cobra_dependent_id in number,
914 p_effective_start_date in date,
915 p_effective_end_date in date,
916 p_object_version_number in number);
917 --
918 FUNCTION dependent_born_in_coverage
919 (p_contact_relationship_id in number,
920 p_coverage_start_date in date,
921 p_coverage_end_date in date) return boolean;
922 --
923 FUNCTION check_clashing_periods
924 (p_cobra_coverage_enrollment_id in number,
925 p_assignment_id in number,
926 p_coverage_start_date in date,
927 p_coverage_end_date in date,
928 p_qualifying_event in varchar2) return boolean;
929 --
930 PROCEDURE check_date_invalidation
931 (p_cobra_coverage_enrollment_id in number,
932 p_coverage_start_date in date,
933 p_coverage_end_date in date);
934 --
935 FUNCTION coverage_exceeded
936 (p_assignment_id in number,
937 p_cobra_coverage_enrollment_id in number,
938 p_coverage_start_date in date,
939 p_coverage_end_date in date,
940 p_qualifying_event in varchar2) return boolean;
941 --
942 END per_cobra_eci;