13: Begin
14: --
15: hr_utility.set_location('Entering'||l_proc, 5);
16: --
17: ben_ext_person.g_flex_pgm_id := null;
18: ben_ext_person.g_flex_pgm_name := null;
19: ben_ext_person.g_flex_pl_id := null;
20: ben_ext_person.g_flex_pl_name := null;
21: ben_ext_person.g_flex_pl_typ_id := null;
14: --
15: hr_utility.set_location('Entering'||l_proc, 5);
16: --
17: ben_ext_person.g_flex_pgm_id := null;
18: ben_ext_person.g_flex_pgm_name := null;
19: ben_ext_person.g_flex_pl_id := null;
20: ben_ext_person.g_flex_pl_name := null;
21: ben_ext_person.g_flex_pl_typ_id := null;
22: ben_ext_person.g_flex_pl_typ_name := null;
15: hr_utility.set_location('Entering'||l_proc, 5);
16: --
17: ben_ext_person.g_flex_pgm_id := null;
18: ben_ext_person.g_flex_pgm_name := null;
19: ben_ext_person.g_flex_pl_id := null;
20: ben_ext_person.g_flex_pl_name := null;
21: ben_ext_person.g_flex_pl_typ_id := null;
22: ben_ext_person.g_flex_pl_typ_name := null;
23: ben_ext_person.g_flex_opt_id := null;
16: --
17: ben_ext_person.g_flex_pgm_id := null;
18: ben_ext_person.g_flex_pgm_name := null;
19: ben_ext_person.g_flex_pl_id := null;
20: ben_ext_person.g_flex_pl_name := null;
21: ben_ext_person.g_flex_pl_typ_id := null;
22: ben_ext_person.g_flex_pl_typ_name := null;
23: ben_ext_person.g_flex_opt_id := null;
24: ben_ext_person.g_flex_opt_name := null;
17: ben_ext_person.g_flex_pgm_id := null;
18: ben_ext_person.g_flex_pgm_name := null;
19: ben_ext_person.g_flex_pl_id := null;
20: ben_ext_person.g_flex_pl_name := null;
21: ben_ext_person.g_flex_pl_typ_id := null;
22: ben_ext_person.g_flex_pl_typ_name := null;
23: ben_ext_person.g_flex_opt_id := null;
24: ben_ext_person.g_flex_opt_name := null;
25: ben_ext_person.g_flex_cmbn_plip_id := null;
18: ben_ext_person.g_flex_pgm_name := null;
19: ben_ext_person.g_flex_pl_id := null;
20: ben_ext_person.g_flex_pl_name := null;
21: ben_ext_person.g_flex_pl_typ_id := null;
22: ben_ext_person.g_flex_pl_typ_name := null;
23: ben_ext_person.g_flex_opt_id := null;
24: ben_ext_person.g_flex_opt_name := null;
25: ben_ext_person.g_flex_cmbn_plip_id := null;
26: ben_ext_person.g_flex_cmbn_plip_name := null;
19: ben_ext_person.g_flex_pl_id := null;
20: ben_ext_person.g_flex_pl_name := null;
21: ben_ext_person.g_flex_pl_typ_id := null;
22: ben_ext_person.g_flex_pl_typ_name := null;
23: ben_ext_person.g_flex_opt_id := null;
24: ben_ext_person.g_flex_opt_name := null;
25: ben_ext_person.g_flex_cmbn_plip_id := null;
26: ben_ext_person.g_flex_cmbn_plip_name := null;
27: ben_ext_person.g_flex_cmbn_ptip_id := null;
20: ben_ext_person.g_flex_pl_name := null;
21: ben_ext_person.g_flex_pl_typ_id := null;
22: ben_ext_person.g_flex_pl_typ_name := null;
23: ben_ext_person.g_flex_opt_id := null;
24: ben_ext_person.g_flex_opt_name := null;
25: ben_ext_person.g_flex_cmbn_plip_id := null;
26: ben_ext_person.g_flex_cmbn_plip_name := null;
27: ben_ext_person.g_flex_cmbn_ptip_id := null;
28: ben_ext_person.g_flex_cmbn_ptip_name := null;
21: ben_ext_person.g_flex_pl_typ_id := null;
22: ben_ext_person.g_flex_pl_typ_name := null;
23: ben_ext_person.g_flex_opt_id := null;
24: ben_ext_person.g_flex_opt_name := null;
25: ben_ext_person.g_flex_cmbn_plip_id := null;
26: ben_ext_person.g_flex_cmbn_plip_name := null;
27: ben_ext_person.g_flex_cmbn_ptip_id := null;
28: ben_ext_person.g_flex_cmbn_ptip_name := null;
29: ben_ext_person.g_flex_cmbn_ptip_opt_id := null;
22: ben_ext_person.g_flex_pl_typ_name := null;
23: ben_ext_person.g_flex_opt_id := null;
24: ben_ext_person.g_flex_opt_name := null;
25: ben_ext_person.g_flex_cmbn_plip_id := null;
26: ben_ext_person.g_flex_cmbn_plip_name := null;
27: ben_ext_person.g_flex_cmbn_ptip_id := null;
28: ben_ext_person.g_flex_cmbn_ptip_name := null;
29: ben_ext_person.g_flex_cmbn_ptip_opt_id := null;
30: ben_ext_person.g_flex_cmbn_ptip_opt_name := null;
23: ben_ext_person.g_flex_opt_id := null;
24: ben_ext_person.g_flex_opt_name := null;
25: ben_ext_person.g_flex_cmbn_plip_id := null;
26: ben_ext_person.g_flex_cmbn_plip_name := null;
27: ben_ext_person.g_flex_cmbn_ptip_id := null;
28: ben_ext_person.g_flex_cmbn_ptip_name := null;
29: ben_ext_person.g_flex_cmbn_ptip_opt_id := null;
30: ben_ext_person.g_flex_cmbn_ptip_opt_name := null;
31: ben_ext_person.g_flex_amt := null;
24: ben_ext_person.g_flex_opt_name := null;
25: ben_ext_person.g_flex_cmbn_plip_id := null;
26: ben_ext_person.g_flex_cmbn_plip_name := null;
27: ben_ext_person.g_flex_cmbn_ptip_id := null;
28: ben_ext_person.g_flex_cmbn_ptip_name := null;
29: ben_ext_person.g_flex_cmbn_ptip_opt_id := null;
30: ben_ext_person.g_flex_cmbn_ptip_opt_name := null;
31: ben_ext_person.g_flex_amt := null;
32: ben_ext_person.g_flex_currency := null;
25: ben_ext_person.g_flex_cmbn_plip_id := null;
26: ben_ext_person.g_flex_cmbn_plip_name := null;
27: ben_ext_person.g_flex_cmbn_ptip_id := null;
28: ben_ext_person.g_flex_cmbn_ptip_name := null;
29: ben_ext_person.g_flex_cmbn_ptip_opt_id := null;
30: ben_ext_person.g_flex_cmbn_ptip_opt_name := null;
31: ben_ext_person.g_flex_amt := null;
32: ben_ext_person.g_flex_currency := null;
33: ben_ext_person.g_flex_bnft_pool_id := null;
26: ben_ext_person.g_flex_cmbn_plip_name := null;
27: ben_ext_person.g_flex_cmbn_ptip_id := null;
28: ben_ext_person.g_flex_cmbn_ptip_name := null;
29: ben_ext_person.g_flex_cmbn_ptip_opt_id := null;
30: ben_ext_person.g_flex_cmbn_ptip_opt_name := null;
31: ben_ext_person.g_flex_amt := null;
32: ben_ext_person.g_flex_currency := null;
33: ben_ext_person.g_flex_bnft_pool_id := null;
34: ben_ext_person.g_flex_bnft_pool_name := null;
27: ben_ext_person.g_flex_cmbn_ptip_id := null;
28: ben_ext_person.g_flex_cmbn_ptip_name := null;
29: ben_ext_person.g_flex_cmbn_ptip_opt_id := null;
30: ben_ext_person.g_flex_cmbn_ptip_opt_name := null;
31: ben_ext_person.g_flex_amt := null;
32: ben_ext_person.g_flex_currency := null;
33: ben_ext_person.g_flex_bnft_pool_id := null;
34: ben_ext_person.g_flex_bnft_pool_name := null;
35: --
28: ben_ext_person.g_flex_cmbn_ptip_name := null;
29: ben_ext_person.g_flex_cmbn_ptip_opt_id := null;
30: ben_ext_person.g_flex_cmbn_ptip_opt_name := null;
31: ben_ext_person.g_flex_amt := null;
32: ben_ext_person.g_flex_currency := null;
33: ben_ext_person.g_flex_bnft_pool_id := null;
34: ben_ext_person.g_flex_bnft_pool_name := null;
35: --
36: hr_utility.set_location('Exiting'||l_proc, 15);
29: ben_ext_person.g_flex_cmbn_ptip_opt_id := null;
30: ben_ext_person.g_flex_cmbn_ptip_opt_name := null;
31: ben_ext_person.g_flex_amt := null;
32: ben_ext_person.g_flex_currency := null;
33: ben_ext_person.g_flex_bnft_pool_id := null;
34: ben_ext_person.g_flex_bnft_pool_name := null;
35: --
36: hr_utility.set_location('Exiting'||l_proc, 15);
37: --
30: ben_ext_person.g_flex_cmbn_ptip_opt_name := null;
31: ben_ext_person.g_flex_amt := null;
32: ben_ext_person.g_flex_currency := null;
33: ben_ext_person.g_flex_bnft_pool_id := null;
34: ben_ext_person.g_flex_bnft_pool_name := null;
35: --
36: hr_utility.set_location('Exiting'||l_proc, 15);
37: --
38: End init_detl_globals;
173: IF l_include = 'Y' THEN
174:
175: -- assign eligibility info to global variables
176: --
177: ben_ext_person.g_flex_pgm_name := elig.program_name;
178: ben_ext_person.g_flex_pl_name := elig.pl_name;
179: ben_ext_person.g_flex_pl_typ_name := elig.pl_typ_name;
180: ben_ext_person.g_flex_opt_name := elig.opt_name;
181: ben_ext_person.g_flex_cmbn_plip_name := elig.cmbn_plip_name;
174:
175: -- assign eligibility info to global variables
176: --
177: ben_ext_person.g_flex_pgm_name := elig.program_name;
178: ben_ext_person.g_flex_pl_name := elig.pl_name;
179: ben_ext_person.g_flex_pl_typ_name := elig.pl_typ_name;
180: ben_ext_person.g_flex_opt_name := elig.opt_name;
181: ben_ext_person.g_flex_cmbn_plip_name := elig.cmbn_plip_name;
182: ben_ext_person.g_flex_cmbn_ptip_name := elig.cmbn_ptip_name;
175: -- assign eligibility info to global variables
176: --
177: ben_ext_person.g_flex_pgm_name := elig.program_name;
178: ben_ext_person.g_flex_pl_name := elig.pl_name;
179: ben_ext_person.g_flex_pl_typ_name := elig.pl_typ_name;
180: ben_ext_person.g_flex_opt_name := elig.opt_name;
181: ben_ext_person.g_flex_cmbn_plip_name := elig.cmbn_plip_name;
182: ben_ext_person.g_flex_cmbn_ptip_name := elig.cmbn_ptip_name;
183: ben_ext_person.g_flex_cmbn_ptip_opt_name := elig.cmbn_ptip_opt_name;
176: --
177: ben_ext_person.g_flex_pgm_name := elig.program_name;
178: ben_ext_person.g_flex_pl_name := elig.pl_name;
179: ben_ext_person.g_flex_pl_typ_name := elig.pl_typ_name;
180: ben_ext_person.g_flex_opt_name := elig.opt_name;
181: ben_ext_person.g_flex_cmbn_plip_name := elig.cmbn_plip_name;
182: ben_ext_person.g_flex_cmbn_ptip_name := elig.cmbn_ptip_name;
183: ben_ext_person.g_flex_cmbn_ptip_opt_name := elig.cmbn_ptip_opt_name;
184: ben_ext_person.g_flex_amt := elig.flex_amt;
177: ben_ext_person.g_flex_pgm_name := elig.program_name;
178: ben_ext_person.g_flex_pl_name := elig.pl_name;
179: ben_ext_person.g_flex_pl_typ_name := elig.pl_typ_name;
180: ben_ext_person.g_flex_opt_name := elig.opt_name;
181: ben_ext_person.g_flex_cmbn_plip_name := elig.cmbn_plip_name;
182: ben_ext_person.g_flex_cmbn_ptip_name := elig.cmbn_ptip_name;
183: ben_ext_person.g_flex_cmbn_ptip_opt_name := elig.cmbn_ptip_opt_name;
184: ben_ext_person.g_flex_amt := elig.flex_amt;
185: ben_ext_person.g_flex_currency := elig.uom;
178: ben_ext_person.g_flex_pl_name := elig.pl_name;
179: ben_ext_person.g_flex_pl_typ_name := elig.pl_typ_name;
180: ben_ext_person.g_flex_opt_name := elig.opt_name;
181: ben_ext_person.g_flex_cmbn_plip_name := elig.cmbn_plip_name;
182: ben_ext_person.g_flex_cmbn_ptip_name := elig.cmbn_ptip_name;
183: ben_ext_person.g_flex_cmbn_ptip_opt_name := elig.cmbn_ptip_opt_name;
184: ben_ext_person.g_flex_amt := elig.flex_amt;
185: ben_ext_person.g_flex_currency := elig.uom;
186: ben_ext_person.g_flex_opt_id := elig.opt_id;
179: ben_ext_person.g_flex_pl_typ_name := elig.pl_typ_name;
180: ben_ext_person.g_flex_opt_name := elig.opt_name;
181: ben_ext_person.g_flex_cmbn_plip_name := elig.cmbn_plip_name;
182: ben_ext_person.g_flex_cmbn_ptip_name := elig.cmbn_ptip_name;
183: ben_ext_person.g_flex_cmbn_ptip_opt_name := elig.cmbn_ptip_opt_name;
184: ben_ext_person.g_flex_amt := elig.flex_amt;
185: ben_ext_person.g_flex_currency := elig.uom;
186: ben_ext_person.g_flex_opt_id := elig.opt_id;
187: ben_ext_person.g_flex_pgm_id := elig.program_id;
180: ben_ext_person.g_flex_opt_name := elig.opt_name;
181: ben_ext_person.g_flex_cmbn_plip_name := elig.cmbn_plip_name;
182: ben_ext_person.g_flex_cmbn_ptip_name := elig.cmbn_ptip_name;
183: ben_ext_person.g_flex_cmbn_ptip_opt_name := elig.cmbn_ptip_opt_name;
184: ben_ext_person.g_flex_amt := elig.flex_amt;
185: ben_ext_person.g_flex_currency := elig.uom;
186: ben_ext_person.g_flex_opt_id := elig.opt_id;
187: ben_ext_person.g_flex_pgm_id := elig.program_id;
188: ben_ext_person.g_flex_pl_id := elig.pl_id;
181: ben_ext_person.g_flex_cmbn_plip_name := elig.cmbn_plip_name;
182: ben_ext_person.g_flex_cmbn_ptip_name := elig.cmbn_ptip_name;
183: ben_ext_person.g_flex_cmbn_ptip_opt_name := elig.cmbn_ptip_opt_name;
184: ben_ext_person.g_flex_amt := elig.flex_amt;
185: ben_ext_person.g_flex_currency := elig.uom;
186: ben_ext_person.g_flex_opt_id := elig.opt_id;
187: ben_ext_person.g_flex_pgm_id := elig.program_id;
188: ben_ext_person.g_flex_pl_id := elig.pl_id;
189: ben_ext_person.g_flex_pl_typ_id := elig.pl_typ_id;
182: ben_ext_person.g_flex_cmbn_ptip_name := elig.cmbn_ptip_name;
183: ben_ext_person.g_flex_cmbn_ptip_opt_name := elig.cmbn_ptip_opt_name;
184: ben_ext_person.g_flex_amt := elig.flex_amt;
185: ben_ext_person.g_flex_currency := elig.uom;
186: ben_ext_person.g_flex_opt_id := elig.opt_id;
187: ben_ext_person.g_flex_pgm_id := elig.program_id;
188: ben_ext_person.g_flex_pl_id := elig.pl_id;
189: ben_ext_person.g_flex_pl_typ_id := elig.pl_typ_id;
190: ben_ext_person.g_flex_cmbn_plip_id := elig.cmbn_plip_id;
183: ben_ext_person.g_flex_cmbn_ptip_opt_name := elig.cmbn_ptip_opt_name;
184: ben_ext_person.g_flex_amt := elig.flex_amt;
185: ben_ext_person.g_flex_currency := elig.uom;
186: ben_ext_person.g_flex_opt_id := elig.opt_id;
187: ben_ext_person.g_flex_pgm_id := elig.program_id;
188: ben_ext_person.g_flex_pl_id := elig.pl_id;
189: ben_ext_person.g_flex_pl_typ_id := elig.pl_typ_id;
190: ben_ext_person.g_flex_cmbn_plip_id := elig.cmbn_plip_id;
191: ben_ext_person.g_flex_cmbn_ptip_id := elig.cmbn_ptip_id;
184: ben_ext_person.g_flex_amt := elig.flex_amt;
185: ben_ext_person.g_flex_currency := elig.uom;
186: ben_ext_person.g_flex_opt_id := elig.opt_id;
187: ben_ext_person.g_flex_pgm_id := elig.program_id;
188: ben_ext_person.g_flex_pl_id := elig.pl_id;
189: ben_ext_person.g_flex_pl_typ_id := elig.pl_typ_id;
190: ben_ext_person.g_flex_cmbn_plip_id := elig.cmbn_plip_id;
191: ben_ext_person.g_flex_cmbn_ptip_id := elig.cmbn_ptip_id;
192: ben_ext_person.g_flex_cmbn_ptip_opt_id := elig.cmbn_ptip_opt_id;
185: ben_ext_person.g_flex_currency := elig.uom;
186: ben_ext_person.g_flex_opt_id := elig.opt_id;
187: ben_ext_person.g_flex_pgm_id := elig.program_id;
188: ben_ext_person.g_flex_pl_id := elig.pl_id;
189: ben_ext_person.g_flex_pl_typ_id := elig.pl_typ_id;
190: ben_ext_person.g_flex_cmbn_plip_id := elig.cmbn_plip_id;
191: ben_ext_person.g_flex_cmbn_ptip_id := elig.cmbn_ptip_id;
192: ben_ext_person.g_flex_cmbn_ptip_opt_id := elig.cmbn_ptip_opt_id;
193: ben_ext_person.g_flex_bnft_pool_id := elig.pool_id;
186: ben_ext_person.g_flex_opt_id := elig.opt_id;
187: ben_ext_person.g_flex_pgm_id := elig.program_id;
188: ben_ext_person.g_flex_pl_id := elig.pl_id;
189: ben_ext_person.g_flex_pl_typ_id := elig.pl_typ_id;
190: ben_ext_person.g_flex_cmbn_plip_id := elig.cmbn_plip_id;
191: ben_ext_person.g_flex_cmbn_ptip_id := elig.cmbn_ptip_id;
192: ben_ext_person.g_flex_cmbn_ptip_opt_id := elig.cmbn_ptip_opt_id;
193: ben_ext_person.g_flex_bnft_pool_id := elig.pool_id;
194: ben_ext_person.g_flex_bnft_pool_name := elig.pool_name;
187: ben_ext_person.g_flex_pgm_id := elig.program_id;
188: ben_ext_person.g_flex_pl_id := elig.pl_id;
189: ben_ext_person.g_flex_pl_typ_id := elig.pl_typ_id;
190: ben_ext_person.g_flex_cmbn_plip_id := elig.cmbn_plip_id;
191: ben_ext_person.g_flex_cmbn_ptip_id := elig.cmbn_ptip_id;
192: ben_ext_person.g_flex_cmbn_ptip_opt_id := elig.cmbn_ptip_opt_id;
193: ben_ext_person.g_flex_bnft_pool_id := elig.pool_id;
194: ben_ext_person.g_flex_bnft_pool_name := elig.pool_name;
195:
188: ben_ext_person.g_flex_pl_id := elig.pl_id;
189: ben_ext_person.g_flex_pl_typ_id := elig.pl_typ_id;
190: ben_ext_person.g_flex_cmbn_plip_id := elig.cmbn_plip_id;
191: ben_ext_person.g_flex_cmbn_ptip_id := elig.cmbn_ptip_id;
192: ben_ext_person.g_flex_cmbn_ptip_opt_id := elig.cmbn_ptip_opt_id;
193: ben_ext_person.g_flex_bnft_pool_id := elig.pool_id;
194: ben_ext_person.g_flex_bnft_pool_name := elig.pool_name;
195:
196: --
189: ben_ext_person.g_flex_pl_typ_id := elig.pl_typ_id;
190: ben_ext_person.g_flex_cmbn_plip_id := elig.cmbn_plip_id;
191: ben_ext_person.g_flex_cmbn_ptip_id := elig.cmbn_ptip_id;
192: ben_ext_person.g_flex_cmbn_ptip_opt_id := elig.cmbn_ptip_opt_id;
193: ben_ext_person.g_flex_bnft_pool_id := elig.pool_id;
194: ben_ext_person.g_flex_bnft_pool_name := elig.pool_name;
195:
196: --
197: -- format and write
190: ben_ext_person.g_flex_cmbn_plip_id := elig.cmbn_plip_id;
191: ben_ext_person.g_flex_cmbn_ptip_id := elig.cmbn_ptip_id;
192: ben_ext_person.g_flex_cmbn_ptip_opt_id := elig.cmbn_ptip_opt_id;
193: ben_ext_person.g_flex_bnft_pool_id := elig.pool_id;
194: ben_ext_person.g_flex_bnft_pool_name := elig.pool_name;
195:
196: --
197: -- format and write
198: --