[Home] [Help]
637: p_upd_egd_with_epe_id called after
638: electable choice is created to set
639: electable choice id on dependent rows.
640: 12 May 00 mhoyes 115.201 - Pulled filtering out nocopy of benmngle into
641: ben_comp_obj_filter.
642: 12 May 00 stee 115.202 - Fix c_get_inelig_dpnt_info cursor.
643: 15 May 00 mhoyes 115.203 - Called get_comp_object_name
644: procedure only when audit log flag
645: is Y.
1126: 27-Apr-11 krupani 120.28.12010000.11 Bug 12360677 : Forward port of 11i bug 12354919
1127: 07-Jul-11 velvanop 120.28.12010000.12 Bug 12711900 : Commented ben_enrolment_requirements.g_auto_choice_created check. Profile 'Ben:Check Enrollment limits' should be validated
1128: even though automatic enrollments are assigned for Life Event. Only when there is no electability
1129: profile validation should happen
1130: 13-Sep-11 usaraswa 120.28.12010000.13 Bug 12715758 : In Process_comp_objects while calling ben_comp_obj_filter.filter_comp_objects sending
1131: p_effective_date instead of nvl(l_rec.lf_evt_ocrd_dt,p_effective_date).
1132: 14-Dec-11 usaraswa 120.28.12010000.14 Bug 12732878 : Added procedure check_for_first_eligible to check whether the comp objects present in the global variables
1133: ben_determine_eligibility2.g_cache_first_inelig_object,ben_determine_eligibility2.g_cache_first_elig_object
1134: are having any future records are there in ben_elig_per_f and ben_elig_per_opt_f tables.If the future records are present
2400: procedure update_elig_per_rows
2401: (p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec
2402: ,p_comp_rec in ben_derive_part_and_rate_facts.g_cache_structure
2403: ,p_person_id in number
2404: ,p_par_elig_state in out nocopy ben_comp_obj_filter.g_par_elig_state_rec
2405: ,p_treeele_num in number
2406: ,p_business_group_id in number
2407: ,p_effective_date in date
2408: ,p_lf_evt_ocrd_dt in date
2556: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
2557: l_epo_row ben_derive_part_and_rate_facts.g_cache_structure;
2558: l_pep_row ben_derive_part_and_rate_facts.g_cache_structure;
2559: l_proc VARCHAR2(72);
2560: l_par_elig_state ben_comp_obj_filter.g_par_elig_state_rec := p_par_elig_state;
2561: l_dummy varchar2(100);
2562: --
2563:
2564: begin
2738: l_elig_per_id := l_pep_row.elig_per_id;
2739: l_object_version_number := l_pep_row.object_version_number;
2740: --
2741: if l_pep_row.elig_flag = 'Y' then
2742: ben_comp_obj_filter.set_parent_elig_flags
2743: (p_comp_obj_tree_row => p_comp_obj_tree_row
2744: ,p_eligible => TRUE
2745: ,p_treeele_num => p_treeele_num
2746: ,p_par_elig_state => l_par_elig_state
2745: ,p_treeele_num => p_treeele_num
2746: ,p_par_elig_state => l_par_elig_state
2747: );
2748: else
2749: ben_comp_obj_filter.set_parent_elig_flags
2750: (p_comp_obj_tree_row => p_comp_obj_tree_row
2751: ,p_eligible => FALSE
2752: ,p_treeele_num => p_treeele_num
2753: ,p_par_elig_state => l_par_elig_state
2775: l_elig_per_id := l_prev_elig_check.elig_per_id;
2776: l_object_version_number := l_prev_elig_check.object_version_number;
2777:
2778: if l_prev_elig_check.elig_flag = 'Y' then
2779: ben_comp_obj_filter.set_parent_elig_flags
2780: (p_comp_obj_tree_row => p_comp_obj_tree_row
2781: ,p_eligible => TRUE
2782: ,p_treeele_num => p_treeele_num
2783: ,p_par_elig_state => l_par_elig_state
2782: ,p_treeele_num => p_treeele_num
2783: ,p_par_elig_state => l_par_elig_state
2784: );
2785: else
2786: ben_comp_obj_filter.set_parent_elig_flags
2787: (p_comp_obj_tree_row => p_comp_obj_tree_row
2788: ,p_eligible => FALSE
2789: ,p_treeele_num => p_treeele_num
2790: ,p_par_elig_state => l_par_elig_state
10325: l_enb_valrow ben_determine_coverage.ENBValType;
10326: --
10327: l_env ben_env_object.g_global_env_rec_type;
10328: l_comp_obj_tree ben_manage_life_events.g_cache_proc_object_table;
10329: l_par_elig_state ben_comp_obj_filter.g_par_elig_state_rec;
10330: l_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
10331: l_parpepgm_row ben_prtn_elig_f%rowtype;
10332: l_parpeptip_row ben_prtn_elig_f%rowtype;
10333: l_parpeplip_row ben_prtn_elig_f%rowtype;
10856: l_comp_obj_tree := g_cache_proc_object;
10857: --
10858: -- Flush duplicate ptip list
10859: --
10860: ben_comp_obj_filter.flush_dupproc_ptip_list;
10861: --
10862: l_treeele_num := l_comp_obj_tree.first;
10863: l_treeloop := TRUE;
10864: l_maxtreeele_num := l_comp_obj_tree.last;
11064: -- filter_comp_objects and we need p_effective_date to determine
11065: -- fonm dates in filter_comp_objects for every comp object.
11066: if l_mode <> 'W' then
11067: --
11068: ben_comp_obj_filter.filter_comp_objects
11069: (p_comp_obj_tree => l_comp_obj_tree
11070: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
11071: ,p_mode => l_mode
11072: ,p_person_id => p_person_id
11602: -- Set comp object parent eligibility flags
11603: --
11604: if l_eligible then
11605: --
11606: ben_comp_obj_filter.set_parent_elig_flags
11607: (p_comp_obj_tree_row => l_comp_obj_tree_row
11608: ,p_eligible => TRUE
11609: ,p_treeele_num => l_treeele_num
11610: --
11662: end if;
11663: --
11664: elsif l_not_eligible then
11665: --
11666: ben_comp_obj_filter.set_parent_elig_flags
11667: (p_comp_obj_tree_row => l_comp_obj_tree_row
11668: ,p_eligible => FALSE
11669: ,p_treeele_num => l_treeele_num
11670: --