18: BEGIN
19: --
20: hr_utility.set_location('Entering'||l_proc, 5);
21: --
22: ben_ext_person.g_prem_actl_prem_id := null;
23: ben_ext_person.g_prem_mn_amt := null;
24: ben_ext_person.g_prem_mn_uom := null;
25: ben_ext_person.g_prem_mn_mnl_adj := null;
26: ben_ext_person.g_prem_mn_cr_mnl_adj := null;
19: --
20: hr_utility.set_location('Entering'||l_proc, 5);
21: --
22: ben_ext_person.g_prem_actl_prem_id := null;
23: ben_ext_person.g_prem_mn_amt := null;
24: ben_ext_person.g_prem_mn_uom := null;
25: ben_ext_person.g_prem_mn_mnl_adj := null;
26: ben_ext_person.g_prem_mn_cr_mnl_adj := null;
27: ben_ext_person.g_prem_mn_cramt := null;
20: hr_utility.set_location('Entering'||l_proc, 5);
21: --
22: ben_ext_person.g_prem_actl_prem_id := null;
23: ben_ext_person.g_prem_mn_amt := null;
24: ben_ext_person.g_prem_mn_uom := null;
25: ben_ext_person.g_prem_mn_mnl_adj := null;
26: ben_ext_person.g_prem_mn_cr_mnl_adj := null;
27: ben_ext_person.g_prem_mn_cramt := null;
28: ben_ext_person.g_prem_mn_costalloc_name := null;
21: --
22: ben_ext_person.g_prem_actl_prem_id := null;
23: ben_ext_person.g_prem_mn_amt := null;
24: ben_ext_person.g_prem_mn_uom := null;
25: ben_ext_person.g_prem_mn_mnl_adj := null;
26: ben_ext_person.g_prem_mn_cr_mnl_adj := null;
27: ben_ext_person.g_prem_mn_cramt := null;
28: ben_ext_person.g_prem_mn_costalloc_name := null;
29: ben_ext_person.g_prem_mn_costalloc_id := null;
22: ben_ext_person.g_prem_actl_prem_id := null;
23: ben_ext_person.g_prem_mn_amt := null;
24: ben_ext_person.g_prem_mn_uom := null;
25: ben_ext_person.g_prem_mn_mnl_adj := null;
26: ben_ext_person.g_prem_mn_cr_mnl_adj := null;
27: ben_ext_person.g_prem_mn_cramt := null;
28: ben_ext_person.g_prem_mn_costalloc_name := null;
29: ben_ext_person.g_prem_mn_costalloc_id := null;
30: ben_ext_person.g_prem_mn_costalloc_flex_01 := null;
23: ben_ext_person.g_prem_mn_amt := null;
24: ben_ext_person.g_prem_mn_uom := null;
25: ben_ext_person.g_prem_mn_mnl_adj := null;
26: ben_ext_person.g_prem_mn_cr_mnl_adj := null;
27: ben_ext_person.g_prem_mn_cramt := null;
28: ben_ext_person.g_prem_mn_costalloc_name := null;
29: ben_ext_person.g_prem_mn_costalloc_id := null;
30: ben_ext_person.g_prem_mn_costalloc_flex_01 := null;
31: ben_ext_person.g_prem_mn_costalloc_flex_02 := null;
24: ben_ext_person.g_prem_mn_uom := null;
25: ben_ext_person.g_prem_mn_mnl_adj := null;
26: ben_ext_person.g_prem_mn_cr_mnl_adj := null;
27: ben_ext_person.g_prem_mn_cramt := null;
28: ben_ext_person.g_prem_mn_costalloc_name := null;
29: ben_ext_person.g_prem_mn_costalloc_id := null;
30: ben_ext_person.g_prem_mn_costalloc_flex_01 := null;
31: ben_ext_person.g_prem_mn_costalloc_flex_02 := null;
32: ben_ext_person.g_prem_mn_costalloc_flex_03 := null;
25: ben_ext_person.g_prem_mn_mnl_adj := null;
26: ben_ext_person.g_prem_mn_cr_mnl_adj := null;
27: ben_ext_person.g_prem_mn_cramt := null;
28: ben_ext_person.g_prem_mn_costalloc_name := null;
29: ben_ext_person.g_prem_mn_costalloc_id := null;
30: ben_ext_person.g_prem_mn_costalloc_flex_01 := null;
31: ben_ext_person.g_prem_mn_costalloc_flex_02 := null;
32: ben_ext_person.g_prem_mn_costalloc_flex_03 := null;
33: ben_ext_person.g_prem_month := null;
26: ben_ext_person.g_prem_mn_cr_mnl_adj := null;
27: ben_ext_person.g_prem_mn_cramt := null;
28: ben_ext_person.g_prem_mn_costalloc_name := null;
29: ben_ext_person.g_prem_mn_costalloc_id := null;
30: ben_ext_person.g_prem_mn_costalloc_flex_01 := null;
31: ben_ext_person.g_prem_mn_costalloc_flex_02 := null;
32: ben_ext_person.g_prem_mn_costalloc_flex_03 := null;
33: ben_ext_person.g_prem_month := null;
34: ben_ext_person.g_prem_year := null;
27: ben_ext_person.g_prem_mn_cramt := null;
28: ben_ext_person.g_prem_mn_costalloc_name := null;
29: ben_ext_person.g_prem_mn_costalloc_id := null;
30: ben_ext_person.g_prem_mn_costalloc_flex_01 := null;
31: ben_ext_person.g_prem_mn_costalloc_flex_02 := null;
32: ben_ext_person.g_prem_mn_costalloc_flex_03 := null;
33: ben_ext_person.g_prem_month := null;
34: ben_ext_person.g_prem_year := null;
35: ben_ext_person.g_prtt_prem_by_mo_id := null;
28: ben_ext_person.g_prem_mn_costalloc_name := null;
29: ben_ext_person.g_prem_mn_costalloc_id := null;
30: ben_ext_person.g_prem_mn_costalloc_flex_01 := null;
31: ben_ext_person.g_prem_mn_costalloc_flex_02 := null;
32: ben_ext_person.g_prem_mn_costalloc_flex_03 := null;
33: ben_ext_person.g_prem_month := null;
34: ben_ext_person.g_prem_year := null;
35: ben_ext_person.g_prtt_prem_by_mo_id := null;
36: ben_ext_person.g_prem_last_upd_date := null ;
29: ben_ext_person.g_prem_mn_costalloc_id := null;
30: ben_ext_person.g_prem_mn_costalloc_flex_01 := null;
31: ben_ext_person.g_prem_mn_costalloc_flex_02 := null;
32: ben_ext_person.g_prem_mn_costalloc_flex_03 := null;
33: ben_ext_person.g_prem_month := null;
34: ben_ext_person.g_prem_year := null;
35: ben_ext_person.g_prtt_prem_by_mo_id := null;
36: ben_ext_person.g_prem_last_upd_date := null ;
37:
30: ben_ext_person.g_prem_mn_costalloc_flex_01 := null;
31: ben_ext_person.g_prem_mn_costalloc_flex_02 := null;
32: ben_ext_person.g_prem_mn_costalloc_flex_03 := null;
33: ben_ext_person.g_prem_month := null;
34: ben_ext_person.g_prem_year := null;
35: ben_ext_person.g_prtt_prem_by_mo_id := null;
36: ben_ext_person.g_prem_last_upd_date := null ;
37:
38: hr_utility.set_location('Exiting'||l_proc, 15);
31: ben_ext_person.g_prem_mn_costalloc_flex_02 := null;
32: ben_ext_person.g_prem_mn_costalloc_flex_03 := null;
33: ben_ext_person.g_prem_month := null;
34: ben_ext_person.g_prem_year := null;
35: ben_ext_person.g_prtt_prem_by_mo_id := null;
36: ben_ext_person.g_prem_last_upd_date := null ;
37:
38: hr_utility.set_location('Exiting'||l_proc, 15);
39: --
32: ben_ext_person.g_prem_mn_costalloc_flex_03 := null;
33: ben_ext_person.g_prem_month := null;
34: ben_ext_person.g_prem_year := null;
35: ben_ext_person.g_prtt_prem_by_mo_id := null;
36: ben_ext_person.g_prem_last_upd_date := null ;
37:
38: hr_utility.set_location('Exiting'||l_proc, 15);
39: --
40: End initialize_globals;
76: --
77: hr_utility.set_location('Entering'||l_proc, 5);
78: --
79: -- Monthly Premium Informations
80: ben_ext_person.g_enrt_mntot_prem_amt := null ;
81: ben_ext_person.g_enrt_mntot_prem_cramt := null ;
82:
83: --
84: FOR prem IN c_mn_prem(p_prtt_enrt_rslt_id) LOOP
77: hr_utility.set_location('Entering'||l_proc, 5);
78: --
79: -- Monthly Premium Informations
80: ben_ext_person.g_enrt_mntot_prem_amt := null ;
81: ben_ext_person.g_enrt_mntot_prem_cramt := null ;
82:
83: --
84: FOR prem IN c_mn_prem(p_prtt_enrt_rslt_id) LOOP
85: --
100:
101: end if ;
102: --
103: END LOOP;
104: ben_ext_person.g_enrt_mntot_prem_amt := l_tot_val ;
105: ben_ext_person.g_enrt_mntot_prem_cramt := l_tot_cr_val ;
106: --
107: hr_utility.set_location('Exiting'||l_proc, 15);
108:
101: end if ;
102: --
103: END LOOP;
104: ben_ext_person.g_enrt_mntot_prem_amt := l_tot_val ;
105: ben_ext_person.g_enrt_mntot_prem_cramt := l_tot_cr_val ;
106: --
107: hr_utility.set_location('Exiting'||l_proc, 15);
108:
109: END; -- premium_total
186: --
187: hr_utility.set_location(' month ' || prem.mo_num , 119);
188: hr_utility.set_location(' year ' || prem.yr_num , 119);
189:
190: ben_ext_person.g_prem_actl_prem_id := prem.actl_prem_id;
191: ben_ext_person.g_prem_mn_amt := prem.val;
192: ben_ext_person.g_prem_mn_uom := prem.uom;
193: ben_ext_person.g_prem_month := prem.mo_num;
194: ben_ext_person.g_prem_year := prem.yr_num;
187: hr_utility.set_location(' month ' || prem.mo_num , 119);
188: hr_utility.set_location(' year ' || prem.yr_num , 119);
189:
190: ben_ext_person.g_prem_actl_prem_id := prem.actl_prem_id;
191: ben_ext_person.g_prem_mn_amt := prem.val;
192: ben_ext_person.g_prem_mn_uom := prem.uom;
193: ben_ext_person.g_prem_month := prem.mo_num;
194: ben_ext_person.g_prem_year := prem.yr_num;
195: ben_ext_person.g_prem_mn_cramt := prem.cr_val;
188: hr_utility.set_location(' year ' || prem.yr_num , 119);
189:
190: ben_ext_person.g_prem_actl_prem_id := prem.actl_prem_id;
191: ben_ext_person.g_prem_mn_amt := prem.val;
192: ben_ext_person.g_prem_mn_uom := prem.uom;
193: ben_ext_person.g_prem_month := prem.mo_num;
194: ben_ext_person.g_prem_year := prem.yr_num;
195: ben_ext_person.g_prem_mn_cramt := prem.cr_val;
196: ben_ext_person.g_prem_mn_mnl_adj := prem.mnl_adj_flag;
189:
190: ben_ext_person.g_prem_actl_prem_id := prem.actl_prem_id;
191: ben_ext_person.g_prem_mn_amt := prem.val;
192: ben_ext_person.g_prem_mn_uom := prem.uom;
193: ben_ext_person.g_prem_month := prem.mo_num;
194: ben_ext_person.g_prem_year := prem.yr_num;
195: ben_ext_person.g_prem_mn_cramt := prem.cr_val;
196: ben_ext_person.g_prem_mn_mnl_adj := prem.mnl_adj_flag;
197: ben_ext_person.g_prem_mn_cr_mnl_adj := prem.cr_mnl_adj_flag;
190: ben_ext_person.g_prem_actl_prem_id := prem.actl_prem_id;
191: ben_ext_person.g_prem_mn_amt := prem.val;
192: ben_ext_person.g_prem_mn_uom := prem.uom;
193: ben_ext_person.g_prem_month := prem.mo_num;
194: ben_ext_person.g_prem_year := prem.yr_num;
195: ben_ext_person.g_prem_mn_cramt := prem.cr_val;
196: ben_ext_person.g_prem_mn_mnl_adj := prem.mnl_adj_flag;
197: ben_ext_person.g_prem_mn_cr_mnl_adj := prem.cr_mnl_adj_flag;
198: ben_ext_person.g_prem_mn_costalloc_name := prem.concatenated_segments;
191: ben_ext_person.g_prem_mn_amt := prem.val;
192: ben_ext_person.g_prem_mn_uom := prem.uom;
193: ben_ext_person.g_prem_month := prem.mo_num;
194: ben_ext_person.g_prem_year := prem.yr_num;
195: ben_ext_person.g_prem_mn_cramt := prem.cr_val;
196: ben_ext_person.g_prem_mn_mnl_adj := prem.mnl_adj_flag;
197: ben_ext_person.g_prem_mn_cr_mnl_adj := prem.cr_mnl_adj_flag;
198: ben_ext_person.g_prem_mn_costalloc_name := prem.concatenated_segments;
199: ben_ext_person.g_prem_mn_costalloc_id := prem.cost_allocation_keyflex_id;
192: ben_ext_person.g_prem_mn_uom := prem.uom;
193: ben_ext_person.g_prem_month := prem.mo_num;
194: ben_ext_person.g_prem_year := prem.yr_num;
195: ben_ext_person.g_prem_mn_cramt := prem.cr_val;
196: ben_ext_person.g_prem_mn_mnl_adj := prem.mnl_adj_flag;
197: ben_ext_person.g_prem_mn_cr_mnl_adj := prem.cr_mnl_adj_flag;
198: ben_ext_person.g_prem_mn_costalloc_name := prem.concatenated_segments;
199: ben_ext_person.g_prem_mn_costalloc_id := prem.cost_allocation_keyflex_id;
200: ben_ext_person.g_prem_mn_costalloc_flex_01 := prem.segment1;
193: ben_ext_person.g_prem_month := prem.mo_num;
194: ben_ext_person.g_prem_year := prem.yr_num;
195: ben_ext_person.g_prem_mn_cramt := prem.cr_val;
196: ben_ext_person.g_prem_mn_mnl_adj := prem.mnl_adj_flag;
197: ben_ext_person.g_prem_mn_cr_mnl_adj := prem.cr_mnl_adj_flag;
198: ben_ext_person.g_prem_mn_costalloc_name := prem.concatenated_segments;
199: ben_ext_person.g_prem_mn_costalloc_id := prem.cost_allocation_keyflex_id;
200: ben_ext_person.g_prem_mn_costalloc_flex_01 := prem.segment1;
201: ben_ext_person.g_prem_mn_costalloc_flex_02 := prem.segment2;
194: ben_ext_person.g_prem_year := prem.yr_num;
195: ben_ext_person.g_prem_mn_cramt := prem.cr_val;
196: ben_ext_person.g_prem_mn_mnl_adj := prem.mnl_adj_flag;
197: ben_ext_person.g_prem_mn_cr_mnl_adj := prem.cr_mnl_adj_flag;
198: ben_ext_person.g_prem_mn_costalloc_name := prem.concatenated_segments;
199: ben_ext_person.g_prem_mn_costalloc_id := prem.cost_allocation_keyflex_id;
200: ben_ext_person.g_prem_mn_costalloc_flex_01 := prem.segment1;
201: ben_ext_person.g_prem_mn_costalloc_flex_02 := prem.segment2;
202: ben_ext_person.g_prem_mn_costalloc_flex_03 := prem.segment3;
195: ben_ext_person.g_prem_mn_cramt := prem.cr_val;
196: ben_ext_person.g_prem_mn_mnl_adj := prem.mnl_adj_flag;
197: ben_ext_person.g_prem_mn_cr_mnl_adj := prem.cr_mnl_adj_flag;
198: ben_ext_person.g_prem_mn_costalloc_name := prem.concatenated_segments;
199: ben_ext_person.g_prem_mn_costalloc_id := prem.cost_allocation_keyflex_id;
200: ben_ext_person.g_prem_mn_costalloc_flex_01 := prem.segment1;
201: ben_ext_person.g_prem_mn_costalloc_flex_02 := prem.segment2;
202: ben_ext_person.g_prem_mn_costalloc_flex_03 := prem.segment3;
203: ben_ext_person.g_prem_type := prem.actl_prem_typ_cd;
196: ben_ext_person.g_prem_mn_mnl_adj := prem.mnl_adj_flag;
197: ben_ext_person.g_prem_mn_cr_mnl_adj := prem.cr_mnl_adj_flag;
198: ben_ext_person.g_prem_mn_costalloc_name := prem.concatenated_segments;
199: ben_ext_person.g_prem_mn_costalloc_id := prem.cost_allocation_keyflex_id;
200: ben_ext_person.g_prem_mn_costalloc_flex_01 := prem.segment1;
201: ben_ext_person.g_prem_mn_costalloc_flex_02 := prem.segment2;
202: ben_ext_person.g_prem_mn_costalloc_flex_03 := prem.segment3;
203: ben_ext_person.g_prem_type := prem.actl_prem_typ_cd;
204: ben_ext_person.g_prtt_prem_by_mo_id := prem.prtt_prem_by_mo_id;
197: ben_ext_person.g_prem_mn_cr_mnl_adj := prem.cr_mnl_adj_flag;
198: ben_ext_person.g_prem_mn_costalloc_name := prem.concatenated_segments;
199: ben_ext_person.g_prem_mn_costalloc_id := prem.cost_allocation_keyflex_id;
200: ben_ext_person.g_prem_mn_costalloc_flex_01 := prem.segment1;
201: ben_ext_person.g_prem_mn_costalloc_flex_02 := prem.segment2;
202: ben_ext_person.g_prem_mn_costalloc_flex_03 := prem.segment3;
203: ben_ext_person.g_prem_type := prem.actl_prem_typ_cd;
204: ben_ext_person.g_prtt_prem_by_mo_id := prem.prtt_prem_by_mo_id;
205: ben_ext_person.g_prem_last_upd_date := prem.last_update_date;
198: ben_ext_person.g_prem_mn_costalloc_name := prem.concatenated_segments;
199: ben_ext_person.g_prem_mn_costalloc_id := prem.cost_allocation_keyflex_id;
200: ben_ext_person.g_prem_mn_costalloc_flex_01 := prem.segment1;
201: ben_ext_person.g_prem_mn_costalloc_flex_02 := prem.segment2;
202: ben_ext_person.g_prem_mn_costalloc_flex_03 := prem.segment3;
203: ben_ext_person.g_prem_type := prem.actl_prem_typ_cd;
204: ben_ext_person.g_prtt_prem_by_mo_id := prem.prtt_prem_by_mo_id;
205: ben_ext_person.g_prem_last_upd_date := prem.last_update_date;
206: --
199: ben_ext_person.g_prem_mn_costalloc_id := prem.cost_allocation_keyflex_id;
200: ben_ext_person.g_prem_mn_costalloc_flex_01 := prem.segment1;
201: ben_ext_person.g_prem_mn_costalloc_flex_02 := prem.segment2;
202: ben_ext_person.g_prem_mn_costalloc_flex_03 := prem.segment3;
203: ben_ext_person.g_prem_type := prem.actl_prem_typ_cd;
204: ben_ext_person.g_prtt_prem_by_mo_id := prem.prtt_prem_by_mo_id;
205: ben_ext_person.g_prem_last_upd_date := prem.last_update_date;
206: --
207: hr_utility.set_location(' month ' || ben_ext_person.g_prem_month , 119);
200: ben_ext_person.g_prem_mn_costalloc_flex_01 := prem.segment1;
201: ben_ext_person.g_prem_mn_costalloc_flex_02 := prem.segment2;
202: ben_ext_person.g_prem_mn_costalloc_flex_03 := prem.segment3;
203: ben_ext_person.g_prem_type := prem.actl_prem_typ_cd;
204: ben_ext_person.g_prtt_prem_by_mo_id := prem.prtt_prem_by_mo_id;
205: ben_ext_person.g_prem_last_upd_date := prem.last_update_date;
206: --
207: hr_utility.set_location(' month ' || ben_ext_person.g_prem_month , 119);
208: hr_utility.set_location(' year ' || ben_ext_person.g_prem_year , 119);
201: ben_ext_person.g_prem_mn_costalloc_flex_02 := prem.segment2;
202: ben_ext_person.g_prem_mn_costalloc_flex_03 := prem.segment3;
203: ben_ext_person.g_prem_type := prem.actl_prem_typ_cd;
204: ben_ext_person.g_prtt_prem_by_mo_id := prem.prtt_prem_by_mo_id;
205: ben_ext_person.g_prem_last_upd_date := prem.last_update_date;
206: --
207: hr_utility.set_location(' month ' || ben_ext_person.g_prem_month , 119);
208: hr_utility.set_location(' year ' || ben_ext_person.g_prem_year , 119);
209: -- format and write
203: ben_ext_person.g_prem_type := prem.actl_prem_typ_cd;
204: ben_ext_person.g_prtt_prem_by_mo_id := prem.prtt_prem_by_mo_id;
205: ben_ext_person.g_prem_last_upd_date := prem.last_update_date;
206: --
207: hr_utility.set_location(' month ' || ben_ext_person.g_prem_month , 119);
208: hr_utility.set_location(' year ' || ben_ext_person.g_prem_year , 119);
209: -- format and write
210: --
211: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,
204: ben_ext_person.g_prtt_prem_by_mo_id := prem.prtt_prem_by_mo_id;
205: ben_ext_person.g_prem_last_upd_date := prem.last_update_date;
206: --
207: hr_utility.set_location(' month ' || ben_ext_person.g_prem_month , 119);
208: hr_utility.set_location(' year ' || ben_ext_person.g_prem_year , 119);
209: -- format and write
210: --
211: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,
212: p_ext_file_id => p_ext_file_id,