[Home] [Help]
PACKAGE: APPS.HRWSECI
Source
1 PACKAGE hrwseci AUTHID CURRENT_USER AS
2 /* $Header: pecobeci.pkh 115.0 99/07/17 18:50:11 porting 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 NUMBER,
75 p_coverage_uom OUT 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 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 NUMBER,
138 p_position_id IN OUT 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 VARCHAR2,
207 p_Cobra_Coverage_Enrollment_Id IN OUT NUMBER,
208 p_Business_Group_Id NUMBER,
209 p_Assignment_Id NUMBER,
210 p_Period_Type VARCHAR2,
211 p_Qualifying_Date IN OUT 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 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_calculate_amount_charged
276 --
277 -- Purpose
278 --
279 -- Calculates the sum of the COBRA costs for ACCepted ben plans
280 --
281 -- Arguments
282 --
283 -- p_cobra_coverage_enrollment_id
284 --
285 -- Example
286 --
287 -- Notes
288 --
289 FUNCTION hr_cobra_calc_amt_charged ( p_cobra_coverage_enrollment_id NUMBER ) RETURN VARCHAR2;
290 --
291 --
292 --
293 -- Name hr_cobra_ins_schedule
294 --
295 -- Purpose
296 --
297 -- insert payment schedules into PER_SCHED_COBRA_PAYMENTS
298 --
299 -- Arguments
300 --
301 -- p_business_group_id NUMBER
302 -- p_cobra_coverage_enrollment_id NUMBER
303 -- p_event_coverage NUMBER
304 -- p_first_payment_due_date DATE
305 -- p_amount_charged NUMBER
306 -- p_grace_days NUMBER
307 --
308 -- Example
309 --
310 -- Notes
311 --
312 PROCEDURE hr_cobra_ins_schedule (p_business_group_id NUMBER,
313 p_cobra_coverage_enrollment_id NUMBER,
314 p_event_coverage NUMBER,
315 p_first_payment_due_date DATE,
316 p_amount_charged NUMBER,
317 p_grace_days NUMBER);
318 --
319 --
320 --
321 -- Name hr_cobra_do_cce_update
322 --
323 -- Purpose
324 --
325 -- Update evwent handler - bundles update logic and parameters
326 --
327 -- Arguments
328 --
329 --
330 -- Example
331 --
332 -- Notes
333 --
334 --
335 --
336 PROCEDURE hr_cobra_do_cce_update ( p_Rowid IN OUT VARCHAR2,
337 p_Cobra_Coverage_Enrollment_Id IN OUT NUMBER,
338 p_Business_Group_Id NUMBER,
339 p_Assignment_Id NUMBER,
340 p_Period_Type VARCHAR2,
341 p_Qualifying_Date DATE,
342 p_Qualifying_Event VARCHAR2,
343 p_Coverage_End_Date DATE,
344 p_Coverage_Start_Date DATE,
345 p_Termination_Reason VARCHAR2,
346 p_Contact_Relationship_Id NUMBER,
347 p_Attribute_Category VARCHAR2,
348 p_Attribute1 VARCHAR2,
349 p_Attribute2 VARCHAR2,
350 p_Attribute3 VARCHAR2,
351 p_Attribute4 VARCHAR2,
352 p_Attribute5 VARCHAR2,
353 p_Attribute6 VARCHAR2,
354 p_Attribute7 VARCHAR2,
355 p_Attribute8 VARCHAR2,
356 p_Attribute9 VARCHAR2,
357 p_Attribute10 VARCHAR2,
358 p_Attribute11 VARCHAR2,
362 p_Attribute15 VARCHAR2,
359 p_Attribute12 VARCHAR2,
360 p_Attribute13 VARCHAR2,
361 p_Attribute14 VARCHAR2,
363 p_Attribute16 VARCHAR2,
364 p_Attribute17 VARCHAR2,
365 p_Attribute18 VARCHAR2,
366 p_Attribute19 VARCHAR2,
367 p_Attribute20 VARCHAR2,
368 p_Grace_Days NUMBER,
369 p_comments VARCHAR2,
370 p_event_coverage NUMBER,
371 p_session_date DATE,
372 p_status VARCHAR2,
373 p_status_date IN OUT DATE,
374 p_status_meaning IN OUT VARCHAR2,
375 p_first_payment_due_date DATE,
376 p_old_first_payment_due_date VARCHAR2,
377 p_amount_charged IN OUT VARCHAR2 );
378 --
379 --
380 --
381 -- Name hr_cobra_get_current_status
382 --
383 -- Purpose
384 --
385 -- gets the latest cobra status
386 --
387 -- Arguments
388 --
389 -- Example
390 --
391 -- Notes
392 --
393 PROCEDURE hr_cobra_get_current_status ( p_cobra_coverage_enrollment_id NUMBER,
394 p_session_date DATE,
395 p_status IN OUT VARCHAR2,
396 p_status_meaning IN OUT VARCHAR2,
397 p_status_date IN OUT DATE,
398 p_d_status_date IN OUT DATE );
399 --
400 --
401 --
402 -- Name hr_cobra_do_ccs_insert
403 --
404 -- Purpose
405 --
406 -- insert bundle
407 --
408 -- Arguments
409 --
410 --
411 PROCEDURE hr_cobra_do_ccs_insert ( p_Rowid IN OUT VARCHAR2,
412 p_Cobra_Coverage_Status_Id IN OUT NUMBER,
413 p_Business_Group_Id NUMBER,
414 p_Cobra_Coverage_Enrollment_Id NUMBER,
415 p_Cobra_Coverage_Status_Type VARCHAR2,
416 p_Effective_Date DATE,
417 p_current_status IN OUT VARCHAR2,
418 p_current_status_meaning IN OUT VARCHAR2,
419 p_current_status_date IN OUT DATE,
420 p_current_d_status_date IN OUT DATE,
421 p_Attribute_Category VARCHAR2,
422 p_Attribute1 VARCHAR2,
423 p_Attribute2 VARCHAR2,
424 p_Attribute3 VARCHAR2,
425 p_Attribute4 VARCHAR2,
426 p_Attribute5 VARCHAR2,
427 p_Attribute6 VARCHAR2,
428 p_Attribute7 VARCHAR2,
429 p_Attribute8 VARCHAR2,
430 p_Attribute9 VARCHAR2,
431 p_Attribute10 VARCHAR2,
432 p_Attribute11 VARCHAR2,
433 p_Attribute12 VARCHAR2,
434 p_Attribute13 VARCHAR2,
435 p_Attribute14 VARCHAR2,
436 p_Attribute15 VARCHAR2,
437 p_Attribute16 VARCHAR2,
438 p_Attribute17 VARCHAR2,
439 p_Attribute18 VARCHAR2,
440 p_Attribute19 VARCHAR2,
441 p_Attribute20 VARCHAR2,
442 p_comments VARCHAR2,
443 p_session_date DATE );
444 --
445 --
446 --
447 -- Name hr_cobra_do_ccs_update
448 --
449 -- Purpose
450 --
451 -- update bundle
452 --
453 -- Arguments
454 --
455 PROCEDURE hr_cobra_do_ccs_update ( p_Rowid IN OUT VARCHAR2,
456 p_Cobra_Coverage_Status_Id IN OUT NUMBER,
457 p_Business_Group_Id NUMBER,
458 p_Cobra_Coverage_Enrollment_Id NUMBER,
459 p_Cobra_Coverage_Status_Type VARCHAR2,
460 p_Effective_Date DATE,
461 p_current_status IN OUT VARCHAR2,
462 p_current_status_meaning IN OUT VARCHAR2,
466 p_Attribute1 VARCHAR2,
463 p_current_status_date IN OUT DATE,
464 p_current_d_status_date IN OUT DATE,
465 p_Attribute_Category VARCHAR2,
467 p_Attribute2 VARCHAR2,
468 p_Attribute3 VARCHAR2,
469 p_Attribute4 VARCHAR2,
470 p_Attribute5 VARCHAR2,
471 p_Attribute6 VARCHAR2,
472 p_Attribute7 VARCHAR2,
473 p_Attribute8 VARCHAR2,
474 p_Attribute9 VARCHAR2,
475 p_Attribute10 VARCHAR2,
476 p_Attribute11 VARCHAR2,
477 p_Attribute12 VARCHAR2,
478 p_Attribute13 VARCHAR2,
479 p_Attribute14 VARCHAR2,
480 p_Attribute15 VARCHAR2,
481 p_Attribute16 VARCHAR2,
482 p_Attribute17 VARCHAR2,
483 p_Attribute18 VARCHAR2,
484 p_Attribute19 VARCHAR2,
485 p_Attribute20 VARCHAR2,
486 p_comments VARCHAR2,
487 p_session_date DATE );
488 --
489 --
490 --
491 -- Name hr_cobra_do_ccs_delete
492 --
493 -- Purpose
494 --
495 -- delete bundle
496 --
497 -- Arguments
498 --
499 PROCEDURE hr_cobra_do_ccs_delete ( p_Rowid VARCHAR2,
500 p_cobra_coverage_enrollment_id NUMBER,
501 p_session_date DATE,
502 p_status IN OUT VARCHAR2,
503 p_status_meaning IN OUT VARCHAR2,
504 p_status_date IN OUT DATE,
505 p_d_status_date IN OUT DATE );
506 --
507 --
508 --
509 -- Name hr_cobra_button_status
510 --
511 -- Purpose
512 --
513 -- Inserts COBRA Coverage Status according to which button the
514 -- user presses
515 --
516 -- Arguments
517 --
518 -- p_business_group_id NUMBER
519 -- p_cobra_coverage_enrollment_id NUMBER
520 -- p_status VARCHAR2
521 -- p_status_date DATE
522 --
523 PROCEDURE hr_cobra_button_status ( p_business_group_id NUMBER,
524 p_cobra_coverage_enrollment_id NUMBER,
525 p_session_date DATE,
526 p_status VARCHAR2,
527 p_cce_status IN OUT VARCHAR2,
528 p_status_date IN OUT DATE,
529 p_d_status_date IN OUT DATE,
530 p_status_meaning IN OUT VARCHAR2 );
531 --
532 --
533 --
534 -- ************************************
535 -- SCP - Schedule COBRA Payments Stuff
536 -- ************************************
537 --
538 --
539 --
540 -- Name hr_cobra_chk_dup_pay_due_date
541 --
542 -- Purpose
543 --
544 -- ensure that duplicate due dates are not entered.
545 --
546 -- Arguments
547 --
548 -- p_scheduled_cobra_payment_id NUMBER
549 -- p_cobra_coverage_enrollment_id NUMBER
550 -- p_due_date DATE
551 --
552 -- Example
553 --
554 -- Notes
555 --
556 PROCEDURE hr_cobra_chk_dup_pay_due_date ( p_scheduled_cobra_payment_id NUMBER,
557 p_cobra_coverage_enrollment_id NUMBER,
558 p_due_date DATE );
559 --
560 --
561 --
562 -- Name hr_cobra_do_scp_pre_insert
563 --
564 -- Purpose
565 --
566 -- Bundles pre-insert logic to server
567 --
568 -- Arguments
569 --
570 -- p_scheduled_cobra_payment_id NUMBER
571 -- p_cobra_coverage_enrollment_id NUMBER
572 -- p_due_date DATE
573 --
574 -- Example
575 --
576 -- Notes
577 --
578 PROCEDURE hr_cobra_do_scp_pre_insert ( p_scheduled_cobra_payment_id IN OUT NUMBER,
579 p_cobra_coverage_enrollment_id NUMBER,
580 p_due_date DATE );
581 --
582 --
583 --
584 -- Name hr_cobra_do_scp_pre_update
585 --
586 -- Purpose
587 --
588 -- Bundles pre-update logic to server
589 --
590 -- Arguments
591 --
592 -- p_scheduled_cobra_payment_id NUMBER
593 -- p_cobra_coverage_enrollment_id NUMBER
594 -- p_due_date DATE
595 --
596 -- Example
597 --
598 -- Notes
599 --
600 PROCEDURE hr_cobra_do_scp_pre_update ( p_scheduled_cobra_payment_id IN OUT NUMBER,
601 p_cobra_coverage_enrollment_id NUMBER,
605 --
602 p_due_date DATE );
603 --
604 --
606 -- Name
607 --
608 -- Purpose
609 --
610 -- defaults COBRA cost for chosen coverage and benefit plan
611 --
612 -- Arguments
613 --
614 -- p_element_type_id NUMBER
615 -- p_coverage_type VARCHAR2
616 -- p_qualifying_date DATE
617 -- p_business_group_id NUMBER
618 -- p_coverage_amount IN OUT VARCHAR2
619 -- p_basic_cost IN OUT VARCHAR2
620 --
621 -- Example
622 --
623 -- Notes
624 --
625 PROCEDURE hr_cobra_default_cobra_cost ( p_element_type_id NUMBER,
626 p_coverage_type VARCHAR2,
627 p_session_date DATE,
628 p_business_group_id NUMBER,
629 p_coverage_amount IN OUT VARCHAR2,
630 p_basic_cost IN OUT VARCHAR2);
631 --
632 --
633 --
634 -- Name hr_cobra_do_ccb_update
635 --
636 -- Purpose
637 --
638 -- bundles update logic
639 --
640 -- Arguments
641 --
642 -- Example
643 --
644 -- Notes
645 --
646 PROCEDURE hr_cobra_do_ccb_update ( p_Rowid IN OUT VARCHAR2,
647 p_Cobra_Coverage_Benefit_Id IN OUT NUMBER,
648 p_Effective_Start_Date DATE,
649 p_Effective_End_Date DATE,
650 p_Business_Group_Id NUMBER,
651 p_Cobra_Coverage_Enrollment_Id NUMBER,
652 p_Element_Type_Id NUMBER,
653 p_Accept_Reject_Flag VARCHAR2,
654 p_Coverage_Amount VARCHAR2,
655 p_Coverage_Type VARCHAR2,
656 p_Attribute_Category VARCHAR2,
657 p_Attribute1 VARCHAR2,
658 p_Attribute2 VARCHAR2,
659 p_Attribute3 VARCHAR2,
660 p_Attribute4 VARCHAR2,
661 p_Attribute5 VARCHAR2,
662 p_Attribute6 VARCHAR2,
663 p_Attribute7 VARCHAR2,
664 p_Attribute8 VARCHAR2,
665 p_Attribute9 VARCHAR2,
666 p_Attribute10 VARCHAR2,
667 p_Attribute11 VARCHAR2,
668 p_Attribute12 VARCHAR2,
669 p_Attribute13 VARCHAR2,
670 p_Attribute14 VARCHAR2,
671 p_Attribute15 VARCHAR2,
672 p_Attribute16 VARCHAR2,
673 p_Attribute17 VARCHAR2,
674 p_Attribute18 VARCHAR2,
675 p_Attribute19 VARCHAR2,
676 p_Attribute20 VARCHAR2,
677 p_qualifying_event VARCHAR2,
678 p_new_amount_charged IN OUT VARCHAR2 );
679 --
680 --
681 --
682 -- Name hr_cobra_lock_scp
683 --
684 -- Purpose
685 --
686 -- locks scp rows if cobra cost is being changed
687 --
688 -- Arguments
689 --
690 -- p_business_group_id
691 -- p_cobra_coverage_enrollment_id
692 --
693 --
694 PROCEDURE hr_cobra_lock_scp ( p_business_group_id NUMBER,
695 p_cobra_coverage_enrollment_id NUMBER);
696 --
697 --
698 --
699 -- Name hr_cobra_chk_rej_to_acc
700 --
701 -- Purpose
702 --
703 -- If the user changes from Reject to accept - should prompt them to manually
704 -- re-activate element entries for the particular benefit if the person enrolled
705 -- is to pay thriugh payroll.
706 --
707 -- returns TRUE if changing from rej to acc
708 --
709 -- Arguments
710 --
711 -- p_rowid
712 --
713 FUNCTION hr_cobra_chk_rej_to_acc (p_rowid VARCHAR2 ) RETURN BOOLEAN;
714 --
715 --
716 --
717 -- Name hr_cobra_do_ccb_post_update
718 --
719 -- Purpose
720 --
721 -- ccb post update logic
722 --
723 -- Arguments
724 --
725 -- p_cobra_coverage_enrollment_id NUMBER
726 -- p_first_payment_due_date DATE
727 -- d_amount_charged IN OUT VARCHAR2
728 --
729 PROCEDURE hr_cobra_do_ccb_post_update ( p_cobra_coverage_enrollment_id NUMBER,
730 p_new_amount_charged VARCHAR2,
731 p_session_date DATE );
732 --
733 --
734 FUNCTION get_basic_cost ( p_element_type_id NUMBER,
735 p_coverage_type VARCHAR2,
736 p_assignment_id NUMBER) RETURN NUMBER;
737 --
738 --
739 --
740 --
741 -- Name hr_cobra_correct_scp
742 --
743 -- Purpose
744 --
748 -- Arguments
745 -- updates amount due of payment schedules if the
746 -- user has updated the cobra cost
747 --
749 --
750 -- p_cobra_coverage_enrollment_id
751 -- p_new_amount_charged
752 --
753 -- Example
754 --
755 -- Notes
756 --
757 --
758 --
759 PROCEDURE hr_cobra_correct_scp( p_cobra_coverage_enrollment_id NUMBER,
760 p_session_date DATE );
761 --
762 PROCEDURE eci_init_form( p_assignment_id NUMBER,
763 p_business_group_id NUMBER,
764 p_qualifying_date DATE,
765 p_organization_id IN OUT NUMBER,
766 p_position_id IN OUT NUMBER,
767 p_await_meaning IN OUT VARCHAR2,
768 p_period_type IN OUT VARCHAR2);
769 --
770 PROCEDURE hr_cobra_do_cdp_insert(p_cobra_dependent_id out number,
771 p_cobra_coverage_enrollment_id in number,
772 p_contact_relationship_id in number,
773 p_effective_start_date in date,
774 p_effective_end_date in date,
775 p_object_version_number out number,
776 p_attribute_category in varchar2,
777 p_attribute1 in varchar2,
778 p_attribute2 in varchar2,
779 p_attribute3 in varchar2,
780 p_attribute4 in varchar2,
781 p_attribute5 in varchar2,
782 p_attribute6 in varchar2,
783 p_attribute7 in varchar2,
784 p_attribute8 in varchar2,
785 p_attribute9 in varchar2,
786 p_attribute10 in varchar2,
787 p_attribute11 in varchar2,
788 p_attribute12 in varchar2,
789 p_attribute13 in varchar2,
790 p_attribute14 in varchar2,
791 p_attribute15 in varchar2,
792 p_attribute16 in varchar2,
793 p_attribute17 in varchar2,
794 p_attribute18 in varchar2,
795 p_attribute19 in varchar2,
796 p_attribute20 in varchar2);
797 --
798 PROCEDURE hr_cobra_do_cdp_update(p_row_id in varchar2,
799 p_cobra_dependent_id in number,
800 p_cobra_coverage_enrollment_id in number,
801 p_contact_relationship_id in number,
802 p_effective_start_date in date,
803 p_effective_end_date in date,
804 p_object_version_number in out number,
805 p_attribute_category in varchar2,
806 p_attribute1 in varchar2,
807 p_attribute2 in varchar2,
808 p_attribute3 in varchar2,
809 p_attribute4 in varchar2,
810 p_attribute5 in varchar2,
811 p_attribute6 in varchar2,
812 p_attribute7 in varchar2,
813 p_attribute8 in varchar2,
814 p_attribute9 in varchar2,
815 p_attribute10 in varchar2,
816 p_attribute11 in varchar2,
817 p_attribute12 in varchar2,
818 p_attribute13 in varchar2,
819 p_attribute14 in varchar2,
820 p_attribute15 in varchar2,
821 p_attribute16 in varchar2,
822 p_attribute17 in varchar2,
823 p_attribute18 in varchar2,
824 p_attribute19 in varchar2,
825 p_attribute20 in varchar2);
826 --
827 PROCEDURE hr_cobra_do_cdp_delete(p_cobra_dependent_id in number,
828 p_effective_start_date in date,
829 p_effective_end_date in date,
830 p_object_version_number in number);
831 --
832 PROCEDURE hr_cobra_do_cdp_lock(p_cobra_dependent_id in number,
833 p_effective_start_date in date,
834 p_effective_end_date in date,
835 p_object_version_number in number);
836 --
837 FUNCTION dependent_born_in_coverage
838 (p_contact_relationship_id in number,
839 p_coverage_start_date in date,
840 p_coverage_end_date in date) return boolean;
841 --
845 p_coverage_start_date in date,
842 FUNCTION check_clashing_periods
843 (p_cobra_coverage_enrollment_id in number,
844 p_assignment_id in number,
846 p_coverage_end_date in date) return boolean;
847 --
848 PROCEDURE check_date_invalidation
849 (p_cobra_coverage_enrollment_id in number,
850 p_coverage_start_date in date,
851 p_coverage_end_date in date);
852 --
853 FUNCTION coverage_exceeded
854 (p_assignment_id in number,
855 p_cobra_coverage_enrollment_id in number,
856 p_coverage_start_date in date,
857 p_coverage_end_date in date) return boolean;
858 --
859 END hrwseci;