1: PACKAGE BODY per_cobra_eci AS
2: /* $Header: pecobeci.pkb 120.3 2006/06/13 06:03:07 saikrish ship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: pecobeci.pkb 120.3 2006/06/13 06:03:07 saikrish ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'per_cobra_eci.';
7:
8:
9: --
10: --
417: bc.cobra_flag = 'Y';
418: --
419: BEGIN
420: --
421: hr_utility.set_location(g_package || 'per_cobra_eci.hr_cobra_chk_benefits_exist', 0);
422: --
423: --
424: -- Initialise last eligible date - i.e. to pick out plans
425: -- the employee was eligible for the day before qualifying
576: AND lookup_code = 'AWAIT';
577: --
578: BEGIN
579: --
580: hr_utility.set_location(g_package || 'per_cobra_eci.hr_cobra_get_await_meaning', 0);
581: --
582: --
583: -- get the meaning
584: --
3193: p_qualifying_date,
3194: p_organization_id,
3195: p_position_id);
3196: --
3197: p_await_meaning := per_cobra_eci.hr_cobra_get_await_meaning;
3198: p_period_type := per_cobra_eci.hr_cobra_get_period_type;
3199: --
3200: END eci_init_form;
3201: --
3194: p_organization_id,
3195: p_position_id);
3196: --
3197: p_await_meaning := per_cobra_eci.hr_cobra_get_await_meaning;
3198: p_period_type := per_cobra_eci.hr_cobra_get_period_type;
3199: --
3200: END eci_init_form;
3201: --
3202: Procedure chk_cobra_dependent_id(p_cobra_dependent_id in number,
3928: close c1;
3929: --
3930: end check_date_invalidation;
3931: --
3932: END per_cobra_eci;