[Home] [Help]
19: Begin
20: --
21: hr_utility.set_location('Entering'||l_proc, 5);
22: --
23: ben_ext_person.g_enrt_prtt_enrt_rslt_id := null;
24: ben_ext_person.g_enrt_pl_name := null;
25: ben_ext_person.g_enrt_opt_name := null;
26: ben_ext_person.g_enrt_pl_id := null;
27: ben_ext_person.g_enrt_opt_id := null;
20: --
21: hr_utility.set_location('Entering'||l_proc, 5);
22: --
23: ben_ext_person.g_enrt_prtt_enrt_rslt_id := null;
24: ben_ext_person.g_enrt_pl_name := null;
25: ben_ext_person.g_enrt_opt_name := null;
26: ben_ext_person.g_enrt_pl_id := null;
27: ben_ext_person.g_enrt_opt_id := null;
28: ben_ext_person.g_enrt_cvg_strt_dt := null;
21: hr_utility.set_location('Entering'||l_proc, 5);
22: --
23: ben_ext_person.g_enrt_prtt_enrt_rslt_id := null;
24: ben_ext_person.g_enrt_pl_name := null;
25: ben_ext_person.g_enrt_opt_name := null;
26: ben_ext_person.g_enrt_pl_id := null;
27: ben_ext_person.g_enrt_opt_id := null;
28: ben_ext_person.g_enrt_cvg_strt_dt := null;
29: ben_ext_person.g_enrt_cvg_thru_dt := null;
22: --
23: ben_ext_person.g_enrt_prtt_enrt_rslt_id := null;
24: ben_ext_person.g_enrt_pl_name := null;
25: ben_ext_person.g_enrt_opt_name := null;
26: ben_ext_person.g_enrt_pl_id := null;
27: ben_ext_person.g_enrt_opt_id := null;
28: ben_ext_person.g_enrt_cvg_strt_dt := null;
29: ben_ext_person.g_enrt_cvg_thru_dt := null;
30: ben_ext_person.g_enrt_orgcovg_strdt := null;
23: ben_ext_person.g_enrt_prtt_enrt_rslt_id := null;
24: ben_ext_person.g_enrt_pl_name := null;
25: ben_ext_person.g_enrt_opt_name := null;
26: ben_ext_person.g_enrt_pl_id := null;
27: ben_ext_person.g_enrt_opt_id := null;
28: ben_ext_person.g_enrt_cvg_strt_dt := null;
29: ben_ext_person.g_enrt_cvg_thru_dt := null;
30: ben_ext_person.g_enrt_orgcovg_strdt := null;
31: ben_ext_person.g_enrt_prt_orgcovg_strdt := null;
24: ben_ext_person.g_enrt_pl_name := null;
25: ben_ext_person.g_enrt_opt_name := null;
26: ben_ext_person.g_enrt_pl_id := null;
27: ben_ext_person.g_enrt_opt_id := null;
28: ben_ext_person.g_enrt_cvg_strt_dt := null;
29: ben_ext_person.g_enrt_cvg_thru_dt := null;
30: ben_ext_person.g_enrt_orgcovg_strdt := null;
31: ben_ext_person.g_enrt_prt_orgcovg_strdt := null;
32: ben_ext_person.g_enrt_cvg_amt := null;
25: ben_ext_person.g_enrt_opt_name := null;
26: ben_ext_person.g_enrt_pl_id := null;
27: ben_ext_person.g_enrt_opt_id := null;
28: ben_ext_person.g_enrt_cvg_strt_dt := null;
29: ben_ext_person.g_enrt_cvg_thru_dt := null;
30: ben_ext_person.g_enrt_orgcovg_strdt := null;
31: ben_ext_person.g_enrt_prt_orgcovg_strdt := null;
32: ben_ext_person.g_enrt_cvg_amt := null;
33: ben_ext_person.g_enrt_pgm_id := null;
26: ben_ext_person.g_enrt_pl_id := null;
27: ben_ext_person.g_enrt_opt_id := null;
28: ben_ext_person.g_enrt_cvg_strt_dt := null;
29: ben_ext_person.g_enrt_cvg_thru_dt := null;
30: ben_ext_person.g_enrt_orgcovg_strdt := null;
31: ben_ext_person.g_enrt_prt_orgcovg_strdt := null;
32: ben_ext_person.g_enrt_cvg_amt := null;
33: ben_ext_person.g_enrt_pgm_id := null;
34: ben_ext_person.g_enrt_benefit_order_num := null;
27: ben_ext_person.g_enrt_opt_id := null;
28: ben_ext_person.g_enrt_cvg_strt_dt := null;
29: ben_ext_person.g_enrt_cvg_thru_dt := null;
30: ben_ext_person.g_enrt_orgcovg_strdt := null;
31: ben_ext_person.g_enrt_prt_orgcovg_strdt := null;
32: ben_ext_person.g_enrt_cvg_amt := null;
33: ben_ext_person.g_enrt_pgm_id := null;
34: ben_ext_person.g_enrt_benefit_order_num := null;
35: ben_ext_person.g_enrt_method := null;
28: ben_ext_person.g_enrt_cvg_strt_dt := null;
29: ben_ext_person.g_enrt_cvg_thru_dt := null;
30: ben_ext_person.g_enrt_orgcovg_strdt := null;
31: ben_ext_person.g_enrt_prt_orgcovg_strdt := null;
32: ben_ext_person.g_enrt_cvg_amt := null;
33: ben_ext_person.g_enrt_pgm_id := null;
34: ben_ext_person.g_enrt_benefit_order_num := null;
35: ben_ext_person.g_enrt_method := null;
36: ben_ext_person.g_enrt_ovrd_flag := null;
29: ben_ext_person.g_enrt_cvg_thru_dt := null;
30: ben_ext_person.g_enrt_orgcovg_strdt := null;
31: ben_ext_person.g_enrt_prt_orgcovg_strdt := null;
32: ben_ext_person.g_enrt_cvg_amt := null;
33: ben_ext_person.g_enrt_pgm_id := null;
34: ben_ext_person.g_enrt_benefit_order_num := null;
35: ben_ext_person.g_enrt_method := null;
36: ben_ext_person.g_enrt_ovrd_flag := null;
37: ben_ext_person.g_enrt_ovrd_thru_dt := null;
30: ben_ext_person.g_enrt_orgcovg_strdt := null;
31: ben_ext_person.g_enrt_prt_orgcovg_strdt := null;
32: ben_ext_person.g_enrt_cvg_amt := null;
33: ben_ext_person.g_enrt_pgm_id := null;
34: ben_ext_person.g_enrt_benefit_order_num := null;
35: ben_ext_person.g_enrt_method := null;
36: ben_ext_person.g_enrt_ovrd_flag := null;
37: ben_ext_person.g_enrt_ovrd_thru_dt := null;
38: ben_ext_person.g_enrt_ovrd_reason := null;
31: ben_ext_person.g_enrt_prt_orgcovg_strdt := null;
32: ben_ext_person.g_enrt_cvg_amt := null;
33: ben_ext_person.g_enrt_pgm_id := null;
34: ben_ext_person.g_enrt_benefit_order_num := null;
35: ben_ext_person.g_enrt_method := null;
36: ben_ext_person.g_enrt_ovrd_flag := null;
37: ben_ext_person.g_enrt_ovrd_thru_dt := null;
38: ben_ext_person.g_enrt_ovrd_reason := null;
39: ben_ext_person.g_enrt_suspended_flag := null;
32: ben_ext_person.g_enrt_cvg_amt := null;
33: ben_ext_person.g_enrt_pgm_id := null;
34: ben_ext_person.g_enrt_benefit_order_num := null;
35: ben_ext_person.g_enrt_method := null;
36: ben_ext_person.g_enrt_ovrd_flag := null;
37: ben_ext_person.g_enrt_ovrd_thru_dt := null;
38: ben_ext_person.g_enrt_ovrd_reason := null;
39: ben_ext_person.g_enrt_suspended_flag := null;
40: ben_ext_person.g_enrt_rslt_effct_strdt := null;
33: ben_ext_person.g_enrt_pgm_id := null;
34: ben_ext_person.g_enrt_benefit_order_num := null;
35: ben_ext_person.g_enrt_method := null;
36: ben_ext_person.g_enrt_ovrd_flag := null;
37: ben_ext_person.g_enrt_ovrd_thru_dt := null;
38: ben_ext_person.g_enrt_ovrd_reason := null;
39: ben_ext_person.g_enrt_suspended_flag := null;
40: ben_ext_person.g_enrt_rslt_effct_strdt := null;
41: ben_ext_person.g_enrt_pgm_name := null;
34: ben_ext_person.g_enrt_benefit_order_num := null;
35: ben_ext_person.g_enrt_method := null;
36: ben_ext_person.g_enrt_ovrd_flag := null;
37: ben_ext_person.g_enrt_ovrd_thru_dt := null;
38: ben_ext_person.g_enrt_ovrd_reason := null;
39: ben_ext_person.g_enrt_suspended_flag := null;
40: ben_ext_person.g_enrt_rslt_effct_strdt := null;
41: ben_ext_person.g_enrt_pgm_name := null;
42: ben_ext_person.g_enrt_pl_typ_id := null;
35: ben_ext_person.g_enrt_method := null;
36: ben_ext_person.g_enrt_ovrd_flag := null;
37: ben_ext_person.g_enrt_ovrd_thru_dt := null;
38: ben_ext_person.g_enrt_ovrd_reason := null;
39: ben_ext_person.g_enrt_suspended_flag := null;
40: ben_ext_person.g_enrt_rslt_effct_strdt := null;
41: ben_ext_person.g_enrt_pgm_name := null;
42: ben_ext_person.g_enrt_pl_typ_id := null;
43: ben_ext_person.g_enrt_pl_typ_name := null;
36: ben_ext_person.g_enrt_ovrd_flag := null;
37: ben_ext_person.g_enrt_ovrd_thru_dt := null;
38: ben_ext_person.g_enrt_ovrd_reason := null;
39: ben_ext_person.g_enrt_suspended_flag := null;
40: ben_ext_person.g_enrt_rslt_effct_strdt := null;
41: ben_ext_person.g_enrt_pgm_name := null;
42: ben_ext_person.g_enrt_pl_typ_id := null;
43: ben_ext_person.g_enrt_pl_typ_name := null;
44: ben_ext_person.g_enrt_attr_1 := null;
37: ben_ext_person.g_enrt_ovrd_thru_dt := null;
38: ben_ext_person.g_enrt_ovrd_reason := null;
39: ben_ext_person.g_enrt_suspended_flag := null;
40: ben_ext_person.g_enrt_rslt_effct_strdt := null;
41: ben_ext_person.g_enrt_pgm_name := null;
42: ben_ext_person.g_enrt_pl_typ_id := null;
43: ben_ext_person.g_enrt_pl_typ_name := null;
44: ben_ext_person.g_enrt_attr_1 := null;
45: ben_ext_person.g_enrt_attr_2 := null;
38: ben_ext_person.g_enrt_ovrd_reason := null;
39: ben_ext_person.g_enrt_suspended_flag := null;
40: ben_ext_person.g_enrt_rslt_effct_strdt := null;
41: ben_ext_person.g_enrt_pgm_name := null;
42: ben_ext_person.g_enrt_pl_typ_id := null;
43: ben_ext_person.g_enrt_pl_typ_name := null;
44: ben_ext_person.g_enrt_attr_1 := null;
45: ben_ext_person.g_enrt_attr_2 := null;
46: ben_ext_person.g_enrt_attr_3 := null;
39: ben_ext_person.g_enrt_suspended_flag := null;
40: ben_ext_person.g_enrt_rslt_effct_strdt := null;
41: ben_ext_person.g_enrt_pgm_name := null;
42: ben_ext_person.g_enrt_pl_typ_id := null;
43: ben_ext_person.g_enrt_pl_typ_name := null;
44: ben_ext_person.g_enrt_attr_1 := null;
45: ben_ext_person.g_enrt_attr_2 := null;
46: ben_ext_person.g_enrt_attr_3 := null;
47: ben_ext_person.g_enrt_attr_4 := null;
40: ben_ext_person.g_enrt_rslt_effct_strdt := null;
41: ben_ext_person.g_enrt_pgm_name := null;
42: ben_ext_person.g_enrt_pl_typ_id := null;
43: ben_ext_person.g_enrt_pl_typ_name := null;
44: ben_ext_person.g_enrt_attr_1 := null;
45: ben_ext_person.g_enrt_attr_2 := null;
46: ben_ext_person.g_enrt_attr_3 := null;
47: ben_ext_person.g_enrt_attr_4 := null;
48: ben_ext_person.g_enrt_attr_5 := null;
41: ben_ext_person.g_enrt_pgm_name := null;
42: ben_ext_person.g_enrt_pl_typ_id := null;
43: ben_ext_person.g_enrt_pl_typ_name := null;
44: ben_ext_person.g_enrt_attr_1 := null;
45: ben_ext_person.g_enrt_attr_2 := null;
46: ben_ext_person.g_enrt_attr_3 := null;
47: ben_ext_person.g_enrt_attr_4 := null;
48: ben_ext_person.g_enrt_attr_5 := null;
49: ben_ext_person.g_enrt_attr_6 := null;
42: ben_ext_person.g_enrt_pl_typ_id := null;
43: ben_ext_person.g_enrt_pl_typ_name := null;
44: ben_ext_person.g_enrt_attr_1 := null;
45: ben_ext_person.g_enrt_attr_2 := null;
46: ben_ext_person.g_enrt_attr_3 := null;
47: ben_ext_person.g_enrt_attr_4 := null;
48: ben_ext_person.g_enrt_attr_5 := null;
49: ben_ext_person.g_enrt_attr_6 := null;
50: ben_ext_person.g_enrt_attr_7 := null;
43: ben_ext_person.g_enrt_pl_typ_name := null;
44: ben_ext_person.g_enrt_attr_1 := null;
45: ben_ext_person.g_enrt_attr_2 := null;
46: ben_ext_person.g_enrt_attr_3 := null;
47: ben_ext_person.g_enrt_attr_4 := null;
48: ben_ext_person.g_enrt_attr_5 := null;
49: ben_ext_person.g_enrt_attr_6 := null;
50: ben_ext_person.g_enrt_attr_7 := null;
51: ben_ext_person.g_enrt_attr_8 := null;
44: ben_ext_person.g_enrt_attr_1 := null;
45: ben_ext_person.g_enrt_attr_2 := null;
46: ben_ext_person.g_enrt_attr_3 := null;
47: ben_ext_person.g_enrt_attr_4 := null;
48: ben_ext_person.g_enrt_attr_5 := null;
49: ben_ext_person.g_enrt_attr_6 := null;
50: ben_ext_person.g_enrt_attr_7 := null;
51: ben_ext_person.g_enrt_attr_8 := null;
52: ben_ext_person.g_enrt_attr_9 := null;
45: ben_ext_person.g_enrt_attr_2 := null;
46: ben_ext_person.g_enrt_attr_3 := null;
47: ben_ext_person.g_enrt_attr_4 := null;
48: ben_ext_person.g_enrt_attr_5 := null;
49: ben_ext_person.g_enrt_attr_6 := null;
50: ben_ext_person.g_enrt_attr_7 := null;
51: ben_ext_person.g_enrt_attr_8 := null;
52: ben_ext_person.g_enrt_attr_9 := null;
53: ben_ext_person.g_enrt_attr_10 := null;
46: ben_ext_person.g_enrt_attr_3 := null;
47: ben_ext_person.g_enrt_attr_4 := null;
48: ben_ext_person.g_enrt_attr_5 := null;
49: ben_ext_person.g_enrt_attr_6 := null;
50: ben_ext_person.g_enrt_attr_7 := null;
51: ben_ext_person.g_enrt_attr_8 := null;
52: ben_ext_person.g_enrt_attr_9 := null;
53: ben_ext_person.g_enrt_attr_10 := null;
54: ben_ext_person.g_pl_attr_1 := null;
47: ben_ext_person.g_enrt_attr_4 := null;
48: ben_ext_person.g_enrt_attr_5 := null;
49: ben_ext_person.g_enrt_attr_6 := null;
50: ben_ext_person.g_enrt_attr_7 := null;
51: ben_ext_person.g_enrt_attr_8 := null;
52: ben_ext_person.g_enrt_attr_9 := null;
53: ben_ext_person.g_enrt_attr_10 := null;
54: ben_ext_person.g_pl_attr_1 := null;
55: ben_ext_person.g_pl_attr_2 := null;
48: ben_ext_person.g_enrt_attr_5 := null;
49: ben_ext_person.g_enrt_attr_6 := null;
50: ben_ext_person.g_enrt_attr_7 := null;
51: ben_ext_person.g_enrt_attr_8 := null;
52: ben_ext_person.g_enrt_attr_9 := null;
53: ben_ext_person.g_enrt_attr_10 := null;
54: ben_ext_person.g_pl_attr_1 := null;
55: ben_ext_person.g_pl_attr_2 := null;
56: ben_ext_person.g_pl_attr_3 := null;
49: ben_ext_person.g_enrt_attr_6 := null;
50: ben_ext_person.g_enrt_attr_7 := null;
51: ben_ext_person.g_enrt_attr_8 := null;
52: ben_ext_person.g_enrt_attr_9 := null;
53: ben_ext_person.g_enrt_attr_10 := null;
54: ben_ext_person.g_pl_attr_1 := null;
55: ben_ext_person.g_pl_attr_2 := null;
56: ben_ext_person.g_pl_attr_3 := null;
57: ben_ext_person.g_pl_attr_4 := null;
50: ben_ext_person.g_enrt_attr_7 := null;
51: ben_ext_person.g_enrt_attr_8 := null;
52: ben_ext_person.g_enrt_attr_9 := null;
53: ben_ext_person.g_enrt_attr_10 := null;
54: ben_ext_person.g_pl_attr_1 := null;
55: ben_ext_person.g_pl_attr_2 := null;
56: ben_ext_person.g_pl_attr_3 := null;
57: ben_ext_person.g_pl_attr_4 := null;
58: ben_ext_person.g_pl_attr_5 := null;
51: ben_ext_person.g_enrt_attr_8 := null;
52: ben_ext_person.g_enrt_attr_9 := null;
53: ben_ext_person.g_enrt_attr_10 := null;
54: ben_ext_person.g_pl_attr_1 := null;
55: ben_ext_person.g_pl_attr_2 := null;
56: ben_ext_person.g_pl_attr_3 := null;
57: ben_ext_person.g_pl_attr_4 := null;
58: ben_ext_person.g_pl_attr_5 := null;
59: ben_ext_person.g_pl_attr_6 := null;
52: ben_ext_person.g_enrt_attr_9 := null;
53: ben_ext_person.g_enrt_attr_10 := null;
54: ben_ext_person.g_pl_attr_1 := null;
55: ben_ext_person.g_pl_attr_2 := null;
56: ben_ext_person.g_pl_attr_3 := null;
57: ben_ext_person.g_pl_attr_4 := null;
58: ben_ext_person.g_pl_attr_5 := null;
59: ben_ext_person.g_pl_attr_6 := null;
60: ben_ext_person.g_pl_attr_7 := null;
53: ben_ext_person.g_enrt_attr_10 := null;
54: ben_ext_person.g_pl_attr_1 := null;
55: ben_ext_person.g_pl_attr_2 := null;
56: ben_ext_person.g_pl_attr_3 := null;
57: ben_ext_person.g_pl_attr_4 := null;
58: ben_ext_person.g_pl_attr_5 := null;
59: ben_ext_person.g_pl_attr_6 := null;
60: ben_ext_person.g_pl_attr_7 := null;
61: ben_ext_person.g_pl_attr_8 := null;
54: ben_ext_person.g_pl_attr_1 := null;
55: ben_ext_person.g_pl_attr_2 := null;
56: ben_ext_person.g_pl_attr_3 := null;
57: ben_ext_person.g_pl_attr_4 := null;
58: ben_ext_person.g_pl_attr_5 := null;
59: ben_ext_person.g_pl_attr_6 := null;
60: ben_ext_person.g_pl_attr_7 := null;
61: ben_ext_person.g_pl_attr_8 := null;
62: ben_ext_person.g_pl_attr_9 := null;
55: ben_ext_person.g_pl_attr_2 := null;
56: ben_ext_person.g_pl_attr_3 := null;
57: ben_ext_person.g_pl_attr_4 := null;
58: ben_ext_person.g_pl_attr_5 := null;
59: ben_ext_person.g_pl_attr_6 := null;
60: ben_ext_person.g_pl_attr_7 := null;
61: ben_ext_person.g_pl_attr_8 := null;
62: ben_ext_person.g_pl_attr_9 := null;
63: ben_ext_person.g_pl_attr_10 := null;
56: ben_ext_person.g_pl_attr_3 := null;
57: ben_ext_person.g_pl_attr_4 := null;
58: ben_ext_person.g_pl_attr_5 := null;
59: ben_ext_person.g_pl_attr_6 := null;
60: ben_ext_person.g_pl_attr_7 := null;
61: ben_ext_person.g_pl_attr_8 := null;
62: ben_ext_person.g_pl_attr_9 := null;
63: ben_ext_person.g_pl_attr_10 := null;
64: ben_ext_person.g_pgm_attr_1 := null;
57: ben_ext_person.g_pl_attr_4 := null;
58: ben_ext_person.g_pl_attr_5 := null;
59: ben_ext_person.g_pl_attr_6 := null;
60: ben_ext_person.g_pl_attr_7 := null;
61: ben_ext_person.g_pl_attr_8 := null;
62: ben_ext_person.g_pl_attr_9 := null;
63: ben_ext_person.g_pl_attr_10 := null;
64: ben_ext_person.g_pgm_attr_1 := null;
65: ben_ext_person.g_pgm_attr_2 := null;
58: ben_ext_person.g_pl_attr_5 := null;
59: ben_ext_person.g_pl_attr_6 := null;
60: ben_ext_person.g_pl_attr_7 := null;
61: ben_ext_person.g_pl_attr_8 := null;
62: ben_ext_person.g_pl_attr_9 := null;
63: ben_ext_person.g_pl_attr_10 := null;
64: ben_ext_person.g_pgm_attr_1 := null;
65: ben_ext_person.g_pgm_attr_2 := null;
66: ben_ext_person.g_pgm_attr_3 := null;
59: ben_ext_person.g_pl_attr_6 := null;
60: ben_ext_person.g_pl_attr_7 := null;
61: ben_ext_person.g_pl_attr_8 := null;
62: ben_ext_person.g_pl_attr_9 := null;
63: ben_ext_person.g_pl_attr_10 := null;
64: ben_ext_person.g_pgm_attr_1 := null;
65: ben_ext_person.g_pgm_attr_2 := null;
66: ben_ext_person.g_pgm_attr_3 := null;
67: ben_ext_person.g_pgm_attr_4 := null;
60: ben_ext_person.g_pl_attr_7 := null;
61: ben_ext_person.g_pl_attr_8 := null;
62: ben_ext_person.g_pl_attr_9 := null;
63: ben_ext_person.g_pl_attr_10 := null;
64: ben_ext_person.g_pgm_attr_1 := null;
65: ben_ext_person.g_pgm_attr_2 := null;
66: ben_ext_person.g_pgm_attr_3 := null;
67: ben_ext_person.g_pgm_attr_4 := null;
68: ben_ext_person.g_pgm_attr_5 := null;
61: ben_ext_person.g_pl_attr_8 := null;
62: ben_ext_person.g_pl_attr_9 := null;
63: ben_ext_person.g_pl_attr_10 := null;
64: ben_ext_person.g_pgm_attr_1 := null;
65: ben_ext_person.g_pgm_attr_2 := null;
66: ben_ext_person.g_pgm_attr_3 := null;
67: ben_ext_person.g_pgm_attr_4 := null;
68: ben_ext_person.g_pgm_attr_5 := null;
69: ben_ext_person.g_pgm_attr_6 := null;
62: ben_ext_person.g_pl_attr_9 := null;
63: ben_ext_person.g_pl_attr_10 := null;
64: ben_ext_person.g_pgm_attr_1 := null;
65: ben_ext_person.g_pgm_attr_2 := null;
66: ben_ext_person.g_pgm_attr_3 := null;
67: ben_ext_person.g_pgm_attr_4 := null;
68: ben_ext_person.g_pgm_attr_5 := null;
69: ben_ext_person.g_pgm_attr_6 := null;
70: ben_ext_person.g_pgm_attr_7 := null;
63: ben_ext_person.g_pl_attr_10 := null;
64: ben_ext_person.g_pgm_attr_1 := null;
65: ben_ext_person.g_pgm_attr_2 := null;
66: ben_ext_person.g_pgm_attr_3 := null;
67: ben_ext_person.g_pgm_attr_4 := null;
68: ben_ext_person.g_pgm_attr_5 := null;
69: ben_ext_person.g_pgm_attr_6 := null;
70: ben_ext_person.g_pgm_attr_7 := null;
71: ben_ext_person.g_pgm_attr_8 := null;
64: ben_ext_person.g_pgm_attr_1 := null;
65: ben_ext_person.g_pgm_attr_2 := null;
66: ben_ext_person.g_pgm_attr_3 := null;
67: ben_ext_person.g_pgm_attr_4 := null;
68: ben_ext_person.g_pgm_attr_5 := null;
69: ben_ext_person.g_pgm_attr_6 := null;
70: ben_ext_person.g_pgm_attr_7 := null;
71: ben_ext_person.g_pgm_attr_8 := null;
72: ben_ext_person.g_pgm_attr_9 := null;
65: ben_ext_person.g_pgm_attr_2 := null;
66: ben_ext_person.g_pgm_attr_3 := null;
67: ben_ext_person.g_pgm_attr_4 := null;
68: ben_ext_person.g_pgm_attr_5 := null;
69: ben_ext_person.g_pgm_attr_6 := null;
70: ben_ext_person.g_pgm_attr_7 := null;
71: ben_ext_person.g_pgm_attr_8 := null;
72: ben_ext_person.g_pgm_attr_9 := null;
73: ben_ext_person.g_pgm_attr_10 := null;
66: ben_ext_person.g_pgm_attr_3 := null;
67: ben_ext_person.g_pgm_attr_4 := null;
68: ben_ext_person.g_pgm_attr_5 := null;
69: ben_ext_person.g_pgm_attr_6 := null;
70: ben_ext_person.g_pgm_attr_7 := null;
71: ben_ext_person.g_pgm_attr_8 := null;
72: ben_ext_person.g_pgm_attr_9 := null;
73: ben_ext_person.g_pgm_attr_10 := null;
74: ben_ext_person.g_ptp_attr_1 := null;
67: ben_ext_person.g_pgm_attr_4 := null;
68: ben_ext_person.g_pgm_attr_5 := null;
69: ben_ext_person.g_pgm_attr_6 := null;
70: ben_ext_person.g_pgm_attr_7 := null;
71: ben_ext_person.g_pgm_attr_8 := null;
72: ben_ext_person.g_pgm_attr_9 := null;
73: ben_ext_person.g_pgm_attr_10 := null;
74: ben_ext_person.g_ptp_attr_1 := null;
75: ben_ext_person.g_ptp_attr_2 := null;
68: ben_ext_person.g_pgm_attr_5 := null;
69: ben_ext_person.g_pgm_attr_6 := null;
70: ben_ext_person.g_pgm_attr_7 := null;
71: ben_ext_person.g_pgm_attr_8 := null;
72: ben_ext_person.g_pgm_attr_9 := null;
73: ben_ext_person.g_pgm_attr_10 := null;
74: ben_ext_person.g_ptp_attr_1 := null;
75: ben_ext_person.g_ptp_attr_2 := null;
76: ben_ext_person.g_ptp_attr_3 := null;
69: ben_ext_person.g_pgm_attr_6 := null;
70: ben_ext_person.g_pgm_attr_7 := null;
71: ben_ext_person.g_pgm_attr_8 := null;
72: ben_ext_person.g_pgm_attr_9 := null;
73: ben_ext_person.g_pgm_attr_10 := null;
74: ben_ext_person.g_ptp_attr_1 := null;
75: ben_ext_person.g_ptp_attr_2 := null;
76: ben_ext_person.g_ptp_attr_3 := null;
77: ben_ext_person.g_ptp_attr_4 := null;
70: ben_ext_person.g_pgm_attr_7 := null;
71: ben_ext_person.g_pgm_attr_8 := null;
72: ben_ext_person.g_pgm_attr_9 := null;
73: ben_ext_person.g_pgm_attr_10 := null;
74: ben_ext_person.g_ptp_attr_1 := null;
75: ben_ext_person.g_ptp_attr_2 := null;
76: ben_ext_person.g_ptp_attr_3 := null;
77: ben_ext_person.g_ptp_attr_4 := null;
78: ben_ext_person.g_ptp_attr_5 := null;
71: ben_ext_person.g_pgm_attr_8 := null;
72: ben_ext_person.g_pgm_attr_9 := null;
73: ben_ext_person.g_pgm_attr_10 := null;
74: ben_ext_person.g_ptp_attr_1 := null;
75: ben_ext_person.g_ptp_attr_2 := null;
76: ben_ext_person.g_ptp_attr_3 := null;
77: ben_ext_person.g_ptp_attr_4 := null;
78: ben_ext_person.g_ptp_attr_5 := null;
79: ben_ext_person.g_ptp_attr_6 := null;
72: ben_ext_person.g_pgm_attr_9 := null;
73: ben_ext_person.g_pgm_attr_10 := null;
74: ben_ext_person.g_ptp_attr_1 := null;
75: ben_ext_person.g_ptp_attr_2 := null;
76: ben_ext_person.g_ptp_attr_3 := null;
77: ben_ext_person.g_ptp_attr_4 := null;
78: ben_ext_person.g_ptp_attr_5 := null;
79: ben_ext_person.g_ptp_attr_6 := null;
80: ben_ext_person.g_ptp_attr_7 := null;
73: ben_ext_person.g_pgm_attr_10 := null;
74: ben_ext_person.g_ptp_attr_1 := null;
75: ben_ext_person.g_ptp_attr_2 := null;
76: ben_ext_person.g_ptp_attr_3 := null;
77: ben_ext_person.g_ptp_attr_4 := null;
78: ben_ext_person.g_ptp_attr_5 := null;
79: ben_ext_person.g_ptp_attr_6 := null;
80: ben_ext_person.g_ptp_attr_7 := null;
81: ben_ext_person.g_ptp_attr_8 := null;
74: ben_ext_person.g_ptp_attr_1 := null;
75: ben_ext_person.g_ptp_attr_2 := null;
76: ben_ext_person.g_ptp_attr_3 := null;
77: ben_ext_person.g_ptp_attr_4 := null;
78: ben_ext_person.g_ptp_attr_5 := null;
79: ben_ext_person.g_ptp_attr_6 := null;
80: ben_ext_person.g_ptp_attr_7 := null;
81: ben_ext_person.g_ptp_attr_8 := null;
82: ben_ext_person.g_ptp_attr_9 := null;
75: ben_ext_person.g_ptp_attr_2 := null;
76: ben_ext_person.g_ptp_attr_3 := null;
77: ben_ext_person.g_ptp_attr_4 := null;
78: ben_ext_person.g_ptp_attr_5 := null;
79: ben_ext_person.g_ptp_attr_6 := null;
80: ben_ext_person.g_ptp_attr_7 := null;
81: ben_ext_person.g_ptp_attr_8 := null;
82: ben_ext_person.g_ptp_attr_9 := null;
83: ben_ext_person.g_ptp_attr_10 := null;
76: ben_ext_person.g_ptp_attr_3 := null;
77: ben_ext_person.g_ptp_attr_4 := null;
78: ben_ext_person.g_ptp_attr_5 := null;
79: ben_ext_person.g_ptp_attr_6 := null;
80: ben_ext_person.g_ptp_attr_7 := null;
81: ben_ext_person.g_ptp_attr_8 := null;
82: ben_ext_person.g_ptp_attr_9 := null;
83: ben_ext_person.g_ptp_attr_10 := null;
84: ben_ext_person.g_plip_attr_1 := null;
77: ben_ext_person.g_ptp_attr_4 := null;
78: ben_ext_person.g_ptp_attr_5 := null;
79: ben_ext_person.g_ptp_attr_6 := null;
80: ben_ext_person.g_ptp_attr_7 := null;
81: ben_ext_person.g_ptp_attr_8 := null;
82: ben_ext_person.g_ptp_attr_9 := null;
83: ben_ext_person.g_ptp_attr_10 := null;
84: ben_ext_person.g_plip_attr_1 := null;
85: ben_ext_person.g_plip_attr_2 := null;
78: ben_ext_person.g_ptp_attr_5 := null;
79: ben_ext_person.g_ptp_attr_6 := null;
80: ben_ext_person.g_ptp_attr_7 := null;
81: ben_ext_person.g_ptp_attr_8 := null;
82: ben_ext_person.g_ptp_attr_9 := null;
83: ben_ext_person.g_ptp_attr_10 := null;
84: ben_ext_person.g_plip_attr_1 := null;
85: ben_ext_person.g_plip_attr_2 := null;
86: ben_ext_person.g_plip_attr_3 := null;
79: ben_ext_person.g_ptp_attr_6 := null;
80: ben_ext_person.g_ptp_attr_7 := null;
81: ben_ext_person.g_ptp_attr_8 := null;
82: ben_ext_person.g_ptp_attr_9 := null;
83: ben_ext_person.g_ptp_attr_10 := null;
84: ben_ext_person.g_plip_attr_1 := null;
85: ben_ext_person.g_plip_attr_2 := null;
86: ben_ext_person.g_plip_attr_3 := null;
87: ben_ext_person.g_plip_attr_4 := null;
80: ben_ext_person.g_ptp_attr_7 := null;
81: ben_ext_person.g_ptp_attr_8 := null;
82: ben_ext_person.g_ptp_attr_9 := null;
83: ben_ext_person.g_ptp_attr_10 := null;
84: ben_ext_person.g_plip_attr_1 := null;
85: ben_ext_person.g_plip_attr_2 := null;
86: ben_ext_person.g_plip_attr_3 := null;
87: ben_ext_person.g_plip_attr_4 := null;
88: ben_ext_person.g_plip_attr_5 := null;
81: ben_ext_person.g_ptp_attr_8 := null;
82: ben_ext_person.g_ptp_attr_9 := null;
83: ben_ext_person.g_ptp_attr_10 := null;
84: ben_ext_person.g_plip_attr_1 := null;
85: ben_ext_person.g_plip_attr_2 := null;
86: ben_ext_person.g_plip_attr_3 := null;
87: ben_ext_person.g_plip_attr_4 := null;
88: ben_ext_person.g_plip_attr_5 := null;
89: ben_ext_person.g_plip_attr_6 := null;
82: ben_ext_person.g_ptp_attr_9 := null;
83: ben_ext_person.g_ptp_attr_10 := null;
84: ben_ext_person.g_plip_attr_1 := null;
85: ben_ext_person.g_plip_attr_2 := null;
86: ben_ext_person.g_plip_attr_3 := null;
87: ben_ext_person.g_plip_attr_4 := null;
88: ben_ext_person.g_plip_attr_5 := null;
89: ben_ext_person.g_plip_attr_6 := null;
90: ben_ext_person.g_plip_attr_7 := null;
83: ben_ext_person.g_ptp_attr_10 := null;
84: ben_ext_person.g_plip_attr_1 := null;
85: ben_ext_person.g_plip_attr_2 := null;
86: ben_ext_person.g_plip_attr_3 := null;
87: ben_ext_person.g_plip_attr_4 := null;
88: ben_ext_person.g_plip_attr_5 := null;
89: ben_ext_person.g_plip_attr_6 := null;
90: ben_ext_person.g_plip_attr_7 := null;
91: ben_ext_person.g_plip_attr_8 := null;
84: ben_ext_person.g_plip_attr_1 := null;
85: ben_ext_person.g_plip_attr_2 := null;
86: ben_ext_person.g_plip_attr_3 := null;
87: ben_ext_person.g_plip_attr_4 := null;
88: ben_ext_person.g_plip_attr_5 := null;
89: ben_ext_person.g_plip_attr_6 := null;
90: ben_ext_person.g_plip_attr_7 := null;
91: ben_ext_person.g_plip_attr_8 := null;
92: ben_ext_person.g_plip_attr_9 := null;
85: ben_ext_person.g_plip_attr_2 := null;
86: ben_ext_person.g_plip_attr_3 := null;
87: ben_ext_person.g_plip_attr_4 := null;
88: ben_ext_person.g_plip_attr_5 := null;
89: ben_ext_person.g_plip_attr_6 := null;
90: ben_ext_person.g_plip_attr_7 := null;
91: ben_ext_person.g_plip_attr_8 := null;
92: ben_ext_person.g_plip_attr_9 := null;
93: ben_ext_person.g_plip_attr_10 := null;
86: ben_ext_person.g_plip_attr_3 := null;
87: ben_ext_person.g_plip_attr_4 := null;
88: ben_ext_person.g_plip_attr_5 := null;
89: ben_ext_person.g_plip_attr_6 := null;
90: ben_ext_person.g_plip_attr_7 := null;
91: ben_ext_person.g_plip_attr_8 := null;
92: ben_ext_person.g_plip_attr_9 := null;
93: ben_ext_person.g_plip_attr_10 := null;
94: ben_ext_person.g_oipl_attr_1 := null;
87: ben_ext_person.g_plip_attr_4 := null;
88: ben_ext_person.g_plip_attr_5 := null;
89: ben_ext_person.g_plip_attr_6 := null;
90: ben_ext_person.g_plip_attr_7 := null;
91: ben_ext_person.g_plip_attr_8 := null;
92: ben_ext_person.g_plip_attr_9 := null;
93: ben_ext_person.g_plip_attr_10 := null;
94: ben_ext_person.g_oipl_attr_1 := null;
95: ben_ext_person.g_oipl_attr_2 := null;
88: ben_ext_person.g_plip_attr_5 := null;
89: ben_ext_person.g_plip_attr_6 := null;
90: ben_ext_person.g_plip_attr_7 := null;
91: ben_ext_person.g_plip_attr_8 := null;
92: ben_ext_person.g_plip_attr_9 := null;
93: ben_ext_person.g_plip_attr_10 := null;
94: ben_ext_person.g_oipl_attr_1 := null;
95: ben_ext_person.g_oipl_attr_2 := null;
96: ben_ext_person.g_oipl_attr_3 := null;
89: ben_ext_person.g_plip_attr_6 := null;
90: ben_ext_person.g_plip_attr_7 := null;
91: ben_ext_person.g_plip_attr_8 := null;
92: ben_ext_person.g_plip_attr_9 := null;
93: ben_ext_person.g_plip_attr_10 := null;
94: ben_ext_person.g_oipl_attr_1 := null;
95: ben_ext_person.g_oipl_attr_2 := null;
96: ben_ext_person.g_oipl_attr_3 := null;
97: ben_ext_person.g_oipl_attr_4 := null;
90: ben_ext_person.g_plip_attr_7 := null;
91: ben_ext_person.g_plip_attr_8 := null;
92: ben_ext_person.g_plip_attr_9 := null;
93: ben_ext_person.g_plip_attr_10 := null;
94: ben_ext_person.g_oipl_attr_1 := null;
95: ben_ext_person.g_oipl_attr_2 := null;
96: ben_ext_person.g_oipl_attr_3 := null;
97: ben_ext_person.g_oipl_attr_4 := null;
98: ben_ext_person.g_oipl_attr_5 := null;
91: ben_ext_person.g_plip_attr_8 := null;
92: ben_ext_person.g_plip_attr_9 := null;
93: ben_ext_person.g_plip_attr_10 := null;
94: ben_ext_person.g_oipl_attr_1 := null;
95: ben_ext_person.g_oipl_attr_2 := null;
96: ben_ext_person.g_oipl_attr_3 := null;
97: ben_ext_person.g_oipl_attr_4 := null;
98: ben_ext_person.g_oipl_attr_5 := null;
99: ben_ext_person.g_oipl_attr_6 := null;
92: ben_ext_person.g_plip_attr_9 := null;
93: ben_ext_person.g_plip_attr_10 := null;
94: ben_ext_person.g_oipl_attr_1 := null;
95: ben_ext_person.g_oipl_attr_2 := null;
96: ben_ext_person.g_oipl_attr_3 := null;
97: ben_ext_person.g_oipl_attr_4 := null;
98: ben_ext_person.g_oipl_attr_5 := null;
99: ben_ext_person.g_oipl_attr_6 := null;
100: ben_ext_person.g_oipl_attr_7 := null;
93: ben_ext_person.g_plip_attr_10 := null;
94: ben_ext_person.g_oipl_attr_1 := null;
95: ben_ext_person.g_oipl_attr_2 := null;
96: ben_ext_person.g_oipl_attr_3 := null;
97: ben_ext_person.g_oipl_attr_4 := null;
98: ben_ext_person.g_oipl_attr_5 := null;
99: ben_ext_person.g_oipl_attr_6 := null;
100: ben_ext_person.g_oipl_attr_7 := null;
101: ben_ext_person.g_oipl_attr_8 := null;
94: ben_ext_person.g_oipl_attr_1 := null;
95: ben_ext_person.g_oipl_attr_2 := null;
96: ben_ext_person.g_oipl_attr_3 := null;
97: ben_ext_person.g_oipl_attr_4 := null;
98: ben_ext_person.g_oipl_attr_5 := null;
99: ben_ext_person.g_oipl_attr_6 := null;
100: ben_ext_person.g_oipl_attr_7 := null;
101: ben_ext_person.g_oipl_attr_8 := null;
102: ben_ext_person.g_oipl_attr_9 := null;
95: ben_ext_person.g_oipl_attr_2 := null;
96: ben_ext_person.g_oipl_attr_3 := null;
97: ben_ext_person.g_oipl_attr_4 := null;
98: ben_ext_person.g_oipl_attr_5 := null;
99: ben_ext_person.g_oipl_attr_6 := null;
100: ben_ext_person.g_oipl_attr_7 := null;
101: ben_ext_person.g_oipl_attr_8 := null;
102: ben_ext_person.g_oipl_attr_9 := null;
103: ben_ext_person.g_oipl_attr_10 := null;
96: ben_ext_person.g_oipl_attr_3 := null;
97: ben_ext_person.g_oipl_attr_4 := null;
98: ben_ext_person.g_oipl_attr_5 := null;
99: ben_ext_person.g_oipl_attr_6 := null;
100: ben_ext_person.g_oipl_attr_7 := null;
101: ben_ext_person.g_oipl_attr_8 := null;
102: ben_ext_person.g_oipl_attr_9 := null;
103: ben_ext_person.g_oipl_attr_10 := null;
104: ben_ext_person.g_enrt_plcy_r_grp := null;
97: ben_ext_person.g_oipl_attr_4 := null;
98: ben_ext_person.g_oipl_attr_5 := null;
99: ben_ext_person.g_oipl_attr_6 := null;
100: ben_ext_person.g_oipl_attr_7 := null;
101: ben_ext_person.g_oipl_attr_8 := null;
102: ben_ext_person.g_oipl_attr_9 := null;
103: ben_ext_person.g_oipl_attr_10 := null;
104: ben_ext_person.g_enrt_plcy_r_grp := null;
105: ben_ext_person.g_ppr_name := null;
98: ben_ext_person.g_oipl_attr_5 := null;
99: ben_ext_person.g_oipl_attr_6 := null;
100: ben_ext_person.g_oipl_attr_7 := null;
101: ben_ext_person.g_oipl_attr_8 := null;
102: ben_ext_person.g_oipl_attr_9 := null;
103: ben_ext_person.g_oipl_attr_10 := null;
104: ben_ext_person.g_enrt_plcy_r_grp := null;
105: ben_ext_person.g_ppr_name := null;
106: ben_ext_person.g_ppr_ident := null;
99: ben_ext_person.g_oipl_attr_6 := null;
100: ben_ext_person.g_oipl_attr_7 := null;
101: ben_ext_person.g_oipl_attr_8 := null;
102: ben_ext_person.g_oipl_attr_9 := null;
103: ben_ext_person.g_oipl_attr_10 := null;
104: ben_ext_person.g_enrt_plcy_r_grp := null;
105: ben_ext_person.g_ppr_name := null;
106: ben_ext_person.g_ppr_ident := null;
107: ben_ext_person.g_ppr_typ := null;
100: ben_ext_person.g_oipl_attr_7 := null;
101: ben_ext_person.g_oipl_attr_8 := null;
102: ben_ext_person.g_oipl_attr_9 := null;
103: ben_ext_person.g_oipl_attr_10 := null;
104: ben_ext_person.g_enrt_plcy_r_grp := null;
105: ben_ext_person.g_ppr_name := null;
106: ben_ext_person.g_ppr_ident := null;
107: ben_ext_person.g_ppr_typ := null;
108: ben_ext_person.g_ppr_strt_dt := null;
101: ben_ext_person.g_oipl_attr_8 := null;
102: ben_ext_person.g_oipl_attr_9 := null;
103: ben_ext_person.g_oipl_attr_10 := null;
104: ben_ext_person.g_enrt_plcy_r_grp := null;
105: ben_ext_person.g_ppr_name := null;
106: ben_ext_person.g_ppr_ident := null;
107: ben_ext_person.g_ppr_typ := null;
108: ben_ext_person.g_ppr_strt_dt := null;
109: ben_ext_person.g_ppr_end_dt := null;
102: ben_ext_person.g_oipl_attr_9 := null;
103: ben_ext_person.g_oipl_attr_10 := null;
104: ben_ext_person.g_enrt_plcy_r_grp := null;
105: ben_ext_person.g_ppr_name := null;
106: ben_ext_person.g_ppr_ident := null;
107: ben_ext_person.g_ppr_typ := null;
108: ben_ext_person.g_ppr_strt_dt := null;
109: ben_ext_person.g_ppr_end_dt := null;
110: ben_ext_person.g_enrt_lfevt_name := null;
103: ben_ext_person.g_oipl_attr_10 := null;
104: ben_ext_person.g_enrt_plcy_r_grp := null;
105: ben_ext_person.g_ppr_name := null;
106: ben_ext_person.g_ppr_ident := null;
107: ben_ext_person.g_ppr_typ := null;
108: ben_ext_person.g_ppr_strt_dt := null;
109: ben_ext_person.g_ppr_end_dt := null;
110: ben_ext_person.g_enrt_lfevt_name := null;
111: ben_ext_person.g_enrt_lfevt_status := null;
104: ben_ext_person.g_enrt_plcy_r_grp := null;
105: ben_ext_person.g_ppr_name := null;
106: ben_ext_person.g_ppr_ident := null;
107: ben_ext_person.g_ppr_typ := null;
108: ben_ext_person.g_ppr_strt_dt := null;
109: ben_ext_person.g_ppr_end_dt := null;
110: ben_ext_person.g_enrt_lfevt_name := null;
111: ben_ext_person.g_enrt_lfevt_status := null;
112: ben_ext_person.g_enrt_lfevt_note_dt := null;
105: ben_ext_person.g_ppr_name := null;
106: ben_ext_person.g_ppr_ident := null;
107: ben_ext_person.g_ppr_typ := null;
108: ben_ext_person.g_ppr_strt_dt := null;
109: ben_ext_person.g_ppr_end_dt := null;
110: ben_ext_person.g_enrt_lfevt_name := null;
111: ben_ext_person.g_enrt_lfevt_status := null;
112: ben_ext_person.g_enrt_lfevt_note_dt := null;
113: ben_ext_person.g_enrt_lfevt_ocrd_dt := null;
106: ben_ext_person.g_ppr_ident := null;
107: ben_ext_person.g_ppr_typ := null;
108: ben_ext_person.g_ppr_strt_dt := null;
109: ben_ext_person.g_ppr_end_dt := null;
110: ben_ext_person.g_enrt_lfevt_name := null;
111: ben_ext_person.g_enrt_lfevt_status := null;
112: ben_ext_person.g_enrt_lfevt_note_dt := null;
113: ben_ext_person.g_enrt_lfevt_ocrd_dt := null;
114: ben_ext_person.g_dpnt_cvrd_dpnt_id := null;
107: ben_ext_person.g_ppr_typ := null;
108: ben_ext_person.g_ppr_strt_dt := null;
109: ben_ext_person.g_ppr_end_dt := null;
110: ben_ext_person.g_enrt_lfevt_name := null;
111: ben_ext_person.g_enrt_lfevt_status := null;
112: ben_ext_person.g_enrt_lfevt_note_dt := null;
113: ben_ext_person.g_enrt_lfevt_ocrd_dt := null;
114: ben_ext_person.g_dpnt_cvrd_dpnt_id := null;
115: --
108: ben_ext_person.g_ppr_strt_dt := null;
109: ben_ext_person.g_ppr_end_dt := null;
110: ben_ext_person.g_enrt_lfevt_name := null;
111: ben_ext_person.g_enrt_lfevt_status := null;
112: ben_ext_person.g_enrt_lfevt_note_dt := null;
113: ben_ext_person.g_enrt_lfevt_ocrd_dt := null;
114: ben_ext_person.g_dpnt_cvrd_dpnt_id := null;
115: --
116: --
109: ben_ext_person.g_ppr_end_dt := null;
110: ben_ext_person.g_enrt_lfevt_name := null;
111: ben_ext_person.g_enrt_lfevt_status := null;
112: ben_ext_person.g_enrt_lfevt_note_dt := null;
113: ben_ext_person.g_enrt_lfevt_ocrd_dt := null;
114: ben_ext_person.g_dpnt_cvrd_dpnt_id := null;
115: --
116: --
117: hr_utility.set_location('Exiting'||l_proc, 15);
110: ben_ext_person.g_enrt_lfevt_name := null;
111: ben_ext_person.g_enrt_lfevt_status := null;
112: ben_ext_person.g_enrt_lfevt_note_dt := null;
113: ben_ext_person.g_enrt_lfevt_ocrd_dt := null;
114: ben_ext_person.g_dpnt_cvrd_dpnt_id := null;
115: --
116: --
117: hr_utility.set_location('Exiting'||l_proc, 15);
118: --
358: IF l_include = 'Y' THEN
359: --
360: -- assign enrollment info to global variables
361: --
362: ben_ext_person.g_enrt_prtt_enrt_rslt_id := dpnt_enrt.prtt_enrt_rslt_id ;
363: ben_ext_person.g_dpnt_cvrd_dpnt_id := dpnt_enrt.elig_cvrd_dpnt_id;
364: ben_ext_person.g_enrt_pl_name := dpnt_enrt.pl_name;
365: ben_ext_person.g_enrt_pl_id := dpnt_enrt.pl_id;
366: ben_ext_person.g_enrt_prt_orgcovg_strdt := dpnt_enrt.orgn_strdt ;
359: --
360: -- assign enrollment info to global variables
361: --
362: ben_ext_person.g_enrt_prtt_enrt_rslt_id := dpnt_enrt.prtt_enrt_rslt_id ;
363: ben_ext_person.g_dpnt_cvrd_dpnt_id := dpnt_enrt.elig_cvrd_dpnt_id;
364: ben_ext_person.g_enrt_pl_name := dpnt_enrt.pl_name;
365: ben_ext_person.g_enrt_pl_id := dpnt_enrt.pl_id;
366: ben_ext_person.g_enrt_prt_orgcovg_strdt := dpnt_enrt.orgn_strdt ;
367: ben_ext_person.g_enrt_cvg_strt_dt := dpnt_enrt.cvg_strt_dt;
360: -- assign enrollment info to global variables
361: --
362: ben_ext_person.g_enrt_prtt_enrt_rslt_id := dpnt_enrt.prtt_enrt_rslt_id ;
363: ben_ext_person.g_dpnt_cvrd_dpnt_id := dpnt_enrt.elig_cvrd_dpnt_id;
364: ben_ext_person.g_enrt_pl_name := dpnt_enrt.pl_name;
365: ben_ext_person.g_enrt_pl_id := dpnt_enrt.pl_id;
366: ben_ext_person.g_enrt_prt_orgcovg_strdt := dpnt_enrt.orgn_strdt ;
367: ben_ext_person.g_enrt_cvg_strt_dt := dpnt_enrt.cvg_strt_dt;
368: ben_ext_person.g_enrt_cvg_thru_dt := dpnt_enrt.cvg_thru_dt;
361: --
362: ben_ext_person.g_enrt_prtt_enrt_rslt_id := dpnt_enrt.prtt_enrt_rslt_id ;
363: ben_ext_person.g_dpnt_cvrd_dpnt_id := dpnt_enrt.elig_cvrd_dpnt_id;
364: ben_ext_person.g_enrt_pl_name := dpnt_enrt.pl_name;
365: ben_ext_person.g_enrt_pl_id := dpnt_enrt.pl_id;
366: ben_ext_person.g_enrt_prt_orgcovg_strdt := dpnt_enrt.orgn_strdt ;
367: ben_ext_person.g_enrt_cvg_strt_dt := dpnt_enrt.cvg_strt_dt;
368: ben_ext_person.g_enrt_cvg_thru_dt := dpnt_enrt.cvg_thru_dt;
369: ben_ext_person.g_enrt_cvg_amt := dpnt_enrt.bnft_amt;
362: ben_ext_person.g_enrt_prtt_enrt_rslt_id := dpnt_enrt.prtt_enrt_rslt_id ;
363: ben_ext_person.g_dpnt_cvrd_dpnt_id := dpnt_enrt.elig_cvrd_dpnt_id;
364: ben_ext_person.g_enrt_pl_name := dpnt_enrt.pl_name;
365: ben_ext_person.g_enrt_pl_id := dpnt_enrt.pl_id;
366: ben_ext_person.g_enrt_prt_orgcovg_strdt := dpnt_enrt.orgn_strdt ;
367: ben_ext_person.g_enrt_cvg_strt_dt := dpnt_enrt.cvg_strt_dt;
368: ben_ext_person.g_enrt_cvg_thru_dt := dpnt_enrt.cvg_thru_dt;
369: ben_ext_person.g_enrt_cvg_amt := dpnt_enrt.bnft_amt;
370: ben_ext_person.g_enrt_pgm_id := dpnt_enrt.pgm_id;
363: ben_ext_person.g_dpnt_cvrd_dpnt_id := dpnt_enrt.elig_cvrd_dpnt_id;
364: ben_ext_person.g_enrt_pl_name := dpnt_enrt.pl_name;
365: ben_ext_person.g_enrt_pl_id := dpnt_enrt.pl_id;
366: ben_ext_person.g_enrt_prt_orgcovg_strdt := dpnt_enrt.orgn_strdt ;
367: ben_ext_person.g_enrt_cvg_strt_dt := dpnt_enrt.cvg_strt_dt;
368: ben_ext_person.g_enrt_cvg_thru_dt := dpnt_enrt.cvg_thru_dt;
369: ben_ext_person.g_enrt_cvg_amt := dpnt_enrt.bnft_amt;
370: ben_ext_person.g_enrt_pgm_id := dpnt_enrt.pgm_id;
371: ben_ext_person.g_enrt_benefit_order_num := dpnt_enrt.bnft_order_num;
364: ben_ext_person.g_enrt_pl_name := dpnt_enrt.pl_name;
365: ben_ext_person.g_enrt_pl_id := dpnt_enrt.pl_id;
366: ben_ext_person.g_enrt_prt_orgcovg_strdt := dpnt_enrt.orgn_strdt ;
367: ben_ext_person.g_enrt_cvg_strt_dt := dpnt_enrt.cvg_strt_dt;
368: ben_ext_person.g_enrt_cvg_thru_dt := dpnt_enrt.cvg_thru_dt;
369: ben_ext_person.g_enrt_cvg_amt := dpnt_enrt.bnft_amt;
370: ben_ext_person.g_enrt_pgm_id := dpnt_enrt.pgm_id;
371: ben_ext_person.g_enrt_benefit_order_num := dpnt_enrt.bnft_order_num;
372: ben_ext_person.g_enrt_method := dpnt_enrt.mthd_cd;
365: ben_ext_person.g_enrt_pl_id := dpnt_enrt.pl_id;
366: ben_ext_person.g_enrt_prt_orgcovg_strdt := dpnt_enrt.orgn_strdt ;
367: ben_ext_person.g_enrt_cvg_strt_dt := dpnt_enrt.cvg_strt_dt;
368: ben_ext_person.g_enrt_cvg_thru_dt := dpnt_enrt.cvg_thru_dt;
369: ben_ext_person.g_enrt_cvg_amt := dpnt_enrt.bnft_amt;
370: ben_ext_person.g_enrt_pgm_id := dpnt_enrt.pgm_id;
371: ben_ext_person.g_enrt_benefit_order_num := dpnt_enrt.bnft_order_num;
372: ben_ext_person.g_enrt_method := dpnt_enrt.mthd_cd;
373: ben_ext_person.g_enrt_ovrd_flag := dpnt_enrt.ovridn_flag;
366: ben_ext_person.g_enrt_prt_orgcovg_strdt := dpnt_enrt.orgn_strdt ;
367: ben_ext_person.g_enrt_cvg_strt_dt := dpnt_enrt.cvg_strt_dt;
368: ben_ext_person.g_enrt_cvg_thru_dt := dpnt_enrt.cvg_thru_dt;
369: ben_ext_person.g_enrt_cvg_amt := dpnt_enrt.bnft_amt;
370: ben_ext_person.g_enrt_pgm_id := dpnt_enrt.pgm_id;
371: ben_ext_person.g_enrt_benefit_order_num := dpnt_enrt.bnft_order_num;
372: ben_ext_person.g_enrt_method := dpnt_enrt.mthd_cd;
373: ben_ext_person.g_enrt_ovrd_flag := dpnt_enrt.ovridn_flag;
374: ben_ext_person.g_enrt_ovrd_thru_dt := dpnt_enrt.ovrid_thru_dt;
367: ben_ext_person.g_enrt_cvg_strt_dt := dpnt_enrt.cvg_strt_dt;
368: ben_ext_person.g_enrt_cvg_thru_dt := dpnt_enrt.cvg_thru_dt;
369: ben_ext_person.g_enrt_cvg_amt := dpnt_enrt.bnft_amt;
370: ben_ext_person.g_enrt_pgm_id := dpnt_enrt.pgm_id;
371: ben_ext_person.g_enrt_benefit_order_num := dpnt_enrt.bnft_order_num;
372: ben_ext_person.g_enrt_method := dpnt_enrt.mthd_cd;
373: ben_ext_person.g_enrt_ovrd_flag := dpnt_enrt.ovridn_flag;
374: ben_ext_person.g_enrt_ovrd_thru_dt := dpnt_enrt.ovrid_thru_dt;
375: ben_ext_person.g_enrt_ovrd_reason := dpnt_enrt.ovrid_rsn_cd;
368: ben_ext_person.g_enrt_cvg_thru_dt := dpnt_enrt.cvg_thru_dt;
369: ben_ext_person.g_enrt_cvg_amt := dpnt_enrt.bnft_amt;
370: ben_ext_person.g_enrt_pgm_id := dpnt_enrt.pgm_id;
371: ben_ext_person.g_enrt_benefit_order_num := dpnt_enrt.bnft_order_num;
372: ben_ext_person.g_enrt_method := dpnt_enrt.mthd_cd;
373: ben_ext_person.g_enrt_ovrd_flag := dpnt_enrt.ovridn_flag;
374: ben_ext_person.g_enrt_ovrd_thru_dt := dpnt_enrt.ovrid_thru_dt;
375: ben_ext_person.g_enrt_ovrd_reason := dpnt_enrt.ovrid_rsn_cd;
376: ben_ext_person.g_enrt_suspended_flag := dpnt_enrt.sspndd_flag;
369: ben_ext_person.g_enrt_cvg_amt := dpnt_enrt.bnft_amt;
370: ben_ext_person.g_enrt_pgm_id := dpnt_enrt.pgm_id;
371: ben_ext_person.g_enrt_benefit_order_num := dpnt_enrt.bnft_order_num;
372: ben_ext_person.g_enrt_method := dpnt_enrt.mthd_cd;
373: ben_ext_person.g_enrt_ovrd_flag := dpnt_enrt.ovridn_flag;
374: ben_ext_person.g_enrt_ovrd_thru_dt := dpnt_enrt.ovrid_thru_dt;
375: ben_ext_person.g_enrt_ovrd_reason := dpnt_enrt.ovrid_rsn_cd;
376: ben_ext_person.g_enrt_suspended_flag := dpnt_enrt.sspndd_flag;
377: ben_ext_person.g_enrt_rslt_effct_strdt := dpnt_enrt.effct_strdt;
370: ben_ext_person.g_enrt_pgm_id := dpnt_enrt.pgm_id;
371: ben_ext_person.g_enrt_benefit_order_num := dpnt_enrt.bnft_order_num;
372: ben_ext_person.g_enrt_method := dpnt_enrt.mthd_cd;
373: ben_ext_person.g_enrt_ovrd_flag := dpnt_enrt.ovridn_flag;
374: ben_ext_person.g_enrt_ovrd_thru_dt := dpnt_enrt.ovrid_thru_dt;
375: ben_ext_person.g_enrt_ovrd_reason := dpnt_enrt.ovrid_rsn_cd;
376: ben_ext_person.g_enrt_suspended_flag := dpnt_enrt.sspndd_flag;
377: ben_ext_person.g_enrt_rslt_effct_strdt := dpnt_enrt.effct_strdt;
378: ben_ext_person.g_enrt_pl_typ_id := dpnt_enrt.pl_typ_id;
371: ben_ext_person.g_enrt_benefit_order_num := dpnt_enrt.bnft_order_num;
372: ben_ext_person.g_enrt_method := dpnt_enrt.mthd_cd;
373: ben_ext_person.g_enrt_ovrd_flag := dpnt_enrt.ovridn_flag;
374: ben_ext_person.g_enrt_ovrd_thru_dt := dpnt_enrt.ovrid_thru_dt;
375: ben_ext_person.g_enrt_ovrd_reason := dpnt_enrt.ovrid_rsn_cd;
376: ben_ext_person.g_enrt_suspended_flag := dpnt_enrt.sspndd_flag;
377: ben_ext_person.g_enrt_rslt_effct_strdt := dpnt_enrt.effct_strdt;
378: ben_ext_person.g_enrt_pl_typ_id := dpnt_enrt.pl_typ_id;
379: ben_ext_person.g_enrt_pl_typ_name := dpnt_enrt.pl_typ_name;
372: ben_ext_person.g_enrt_method := dpnt_enrt.mthd_cd;
373: ben_ext_person.g_enrt_ovrd_flag := dpnt_enrt.ovridn_flag;
374: ben_ext_person.g_enrt_ovrd_thru_dt := dpnt_enrt.ovrid_thru_dt;
375: ben_ext_person.g_enrt_ovrd_reason := dpnt_enrt.ovrid_rsn_cd;
376: ben_ext_person.g_enrt_suspended_flag := dpnt_enrt.sspndd_flag;
377: ben_ext_person.g_enrt_rslt_effct_strdt := dpnt_enrt.effct_strdt;
378: ben_ext_person.g_enrt_pl_typ_id := dpnt_enrt.pl_typ_id;
379: ben_ext_person.g_enrt_pl_typ_name := dpnt_enrt.pl_typ_name;
380: ben_ext_person.g_enrt_lfevt_name := dpnt_enrt.ler_name;
373: ben_ext_person.g_enrt_ovrd_flag := dpnt_enrt.ovridn_flag;
374: ben_ext_person.g_enrt_ovrd_thru_dt := dpnt_enrt.ovrid_thru_dt;
375: ben_ext_person.g_enrt_ovrd_reason := dpnt_enrt.ovrid_rsn_cd;
376: ben_ext_person.g_enrt_suspended_flag := dpnt_enrt.sspndd_flag;
377: ben_ext_person.g_enrt_rslt_effct_strdt := dpnt_enrt.effct_strdt;
378: ben_ext_person.g_enrt_pl_typ_id := dpnt_enrt.pl_typ_id;
379: ben_ext_person.g_enrt_pl_typ_name := dpnt_enrt.pl_typ_name;
380: ben_ext_person.g_enrt_lfevt_name := dpnt_enrt.ler_name;
381: ben_ext_person.g_enrt_lfevt_status := dpnt_enrt.per_in_ler_stat_cd;
374: ben_ext_person.g_enrt_ovrd_thru_dt := dpnt_enrt.ovrid_thru_dt;
375: ben_ext_person.g_enrt_ovrd_reason := dpnt_enrt.ovrid_rsn_cd;
376: ben_ext_person.g_enrt_suspended_flag := dpnt_enrt.sspndd_flag;
377: ben_ext_person.g_enrt_rslt_effct_strdt := dpnt_enrt.effct_strdt;
378: ben_ext_person.g_enrt_pl_typ_id := dpnt_enrt.pl_typ_id;
379: ben_ext_person.g_enrt_pl_typ_name := dpnt_enrt.pl_typ_name;
380: ben_ext_person.g_enrt_lfevt_name := dpnt_enrt.ler_name;
381: ben_ext_person.g_enrt_lfevt_status := dpnt_enrt.per_in_ler_stat_cd;
382: ben_ext_person.g_enrt_lfevt_note_dt := dpnt_enrt.ntfn_dt;
375: ben_ext_person.g_enrt_ovrd_reason := dpnt_enrt.ovrid_rsn_cd;
376: ben_ext_person.g_enrt_suspended_flag := dpnt_enrt.sspndd_flag;
377: ben_ext_person.g_enrt_rslt_effct_strdt := dpnt_enrt.effct_strdt;
378: ben_ext_person.g_enrt_pl_typ_id := dpnt_enrt.pl_typ_id;
379: ben_ext_person.g_enrt_pl_typ_name := dpnt_enrt.pl_typ_name;
380: ben_ext_person.g_enrt_lfevt_name := dpnt_enrt.ler_name;
381: ben_ext_person.g_enrt_lfevt_status := dpnt_enrt.per_in_ler_stat_cd;
382: ben_ext_person.g_enrt_lfevt_note_dt := dpnt_enrt.ntfn_dt;
383: ben_ext_person.g_enrt_lfevt_ocrd_dt := dpnt_enrt.lf_evt_ocrd_dt;
376: ben_ext_person.g_enrt_suspended_flag := dpnt_enrt.sspndd_flag;
377: ben_ext_person.g_enrt_rslt_effct_strdt := dpnt_enrt.effct_strdt;
378: ben_ext_person.g_enrt_pl_typ_id := dpnt_enrt.pl_typ_id;
379: ben_ext_person.g_enrt_pl_typ_name := dpnt_enrt.pl_typ_name;
380: ben_ext_person.g_enrt_lfevt_name := dpnt_enrt.ler_name;
381: ben_ext_person.g_enrt_lfevt_status := dpnt_enrt.per_in_ler_stat_cd;
382: ben_ext_person.g_enrt_lfevt_note_dt := dpnt_enrt.ntfn_dt;
383: ben_ext_person.g_enrt_lfevt_ocrd_dt := dpnt_enrt.lf_evt_ocrd_dt;
384: ben_ext_person.g_enrt_attr_1 := dpnt_enrt.pen_attribute1;
377: ben_ext_person.g_enrt_rslt_effct_strdt := dpnt_enrt.effct_strdt;
378: ben_ext_person.g_enrt_pl_typ_id := dpnt_enrt.pl_typ_id;
379: ben_ext_person.g_enrt_pl_typ_name := dpnt_enrt.pl_typ_name;
380: ben_ext_person.g_enrt_lfevt_name := dpnt_enrt.ler_name;
381: ben_ext_person.g_enrt_lfevt_status := dpnt_enrt.per_in_ler_stat_cd;
382: ben_ext_person.g_enrt_lfevt_note_dt := dpnt_enrt.ntfn_dt;
383: ben_ext_person.g_enrt_lfevt_ocrd_dt := dpnt_enrt.lf_evt_ocrd_dt;
384: ben_ext_person.g_enrt_attr_1 := dpnt_enrt.pen_attribute1;
385: ben_ext_person.g_enrt_attr_2 := dpnt_enrt.pen_attribute2;
378: ben_ext_person.g_enrt_pl_typ_id := dpnt_enrt.pl_typ_id;
379: ben_ext_person.g_enrt_pl_typ_name := dpnt_enrt.pl_typ_name;
380: ben_ext_person.g_enrt_lfevt_name := dpnt_enrt.ler_name;
381: ben_ext_person.g_enrt_lfevt_status := dpnt_enrt.per_in_ler_stat_cd;
382: ben_ext_person.g_enrt_lfevt_note_dt := dpnt_enrt.ntfn_dt;
383: ben_ext_person.g_enrt_lfevt_ocrd_dt := dpnt_enrt.lf_evt_ocrd_dt;
384: ben_ext_person.g_enrt_attr_1 := dpnt_enrt.pen_attribute1;
385: ben_ext_person.g_enrt_attr_2 := dpnt_enrt.pen_attribute2;
386: ben_ext_person.g_enrt_attr_3 := dpnt_enrt.pen_attribute3;
379: ben_ext_person.g_enrt_pl_typ_name := dpnt_enrt.pl_typ_name;
380: ben_ext_person.g_enrt_lfevt_name := dpnt_enrt.ler_name;
381: ben_ext_person.g_enrt_lfevt_status := dpnt_enrt.per_in_ler_stat_cd;
382: ben_ext_person.g_enrt_lfevt_note_dt := dpnt_enrt.ntfn_dt;
383: ben_ext_person.g_enrt_lfevt_ocrd_dt := dpnt_enrt.lf_evt_ocrd_dt;
384: ben_ext_person.g_enrt_attr_1 := dpnt_enrt.pen_attribute1;
385: ben_ext_person.g_enrt_attr_2 := dpnt_enrt.pen_attribute2;
386: ben_ext_person.g_enrt_attr_3 := dpnt_enrt.pen_attribute3;
387: ben_ext_person.g_enrt_attr_4 := dpnt_enrt.pen_attribute4;
380: ben_ext_person.g_enrt_lfevt_name := dpnt_enrt.ler_name;
381: ben_ext_person.g_enrt_lfevt_status := dpnt_enrt.per_in_ler_stat_cd;
382: ben_ext_person.g_enrt_lfevt_note_dt := dpnt_enrt.ntfn_dt;
383: ben_ext_person.g_enrt_lfevt_ocrd_dt := dpnt_enrt.lf_evt_ocrd_dt;
384: ben_ext_person.g_enrt_attr_1 := dpnt_enrt.pen_attribute1;
385: ben_ext_person.g_enrt_attr_2 := dpnt_enrt.pen_attribute2;
386: ben_ext_person.g_enrt_attr_3 := dpnt_enrt.pen_attribute3;
387: ben_ext_person.g_enrt_attr_4 := dpnt_enrt.pen_attribute4;
388: ben_ext_person.g_enrt_attr_5 := dpnt_enrt.pen_attribute5;
381: ben_ext_person.g_enrt_lfevt_status := dpnt_enrt.per_in_ler_stat_cd;
382: ben_ext_person.g_enrt_lfevt_note_dt := dpnt_enrt.ntfn_dt;
383: ben_ext_person.g_enrt_lfevt_ocrd_dt := dpnt_enrt.lf_evt_ocrd_dt;
384: ben_ext_person.g_enrt_attr_1 := dpnt_enrt.pen_attribute1;
385: ben_ext_person.g_enrt_attr_2 := dpnt_enrt.pen_attribute2;
386: ben_ext_person.g_enrt_attr_3 := dpnt_enrt.pen_attribute3;
387: ben_ext_person.g_enrt_attr_4 := dpnt_enrt.pen_attribute4;
388: ben_ext_person.g_enrt_attr_5 := dpnt_enrt.pen_attribute5;
389: ben_ext_person.g_enrt_attr_6 := dpnt_enrt.pen_attribute6;
382: ben_ext_person.g_enrt_lfevt_note_dt := dpnt_enrt.ntfn_dt;
383: ben_ext_person.g_enrt_lfevt_ocrd_dt := dpnt_enrt.lf_evt_ocrd_dt;
384: ben_ext_person.g_enrt_attr_1 := dpnt_enrt.pen_attribute1;
385: ben_ext_person.g_enrt_attr_2 := dpnt_enrt.pen_attribute2;
386: ben_ext_person.g_enrt_attr_3 := dpnt_enrt.pen_attribute3;
387: ben_ext_person.g_enrt_attr_4 := dpnt_enrt.pen_attribute4;
388: ben_ext_person.g_enrt_attr_5 := dpnt_enrt.pen_attribute5;
389: ben_ext_person.g_enrt_attr_6 := dpnt_enrt.pen_attribute6;
390: ben_ext_person.g_enrt_attr_7 := dpnt_enrt.pen_attribute7;
383: ben_ext_person.g_enrt_lfevt_ocrd_dt := dpnt_enrt.lf_evt_ocrd_dt;
384: ben_ext_person.g_enrt_attr_1 := dpnt_enrt.pen_attribute1;
385: ben_ext_person.g_enrt_attr_2 := dpnt_enrt.pen_attribute2;
386: ben_ext_person.g_enrt_attr_3 := dpnt_enrt.pen_attribute3;
387: ben_ext_person.g_enrt_attr_4 := dpnt_enrt.pen_attribute4;
388: ben_ext_person.g_enrt_attr_5 := dpnt_enrt.pen_attribute5;
389: ben_ext_person.g_enrt_attr_6 := dpnt_enrt.pen_attribute6;
390: ben_ext_person.g_enrt_attr_7 := dpnt_enrt.pen_attribute7;
391: ben_ext_person.g_enrt_attr_8 := dpnt_enrt.pen_attribute8;
384: ben_ext_person.g_enrt_attr_1 := dpnt_enrt.pen_attribute1;
385: ben_ext_person.g_enrt_attr_2 := dpnt_enrt.pen_attribute2;
386: ben_ext_person.g_enrt_attr_3 := dpnt_enrt.pen_attribute3;
387: ben_ext_person.g_enrt_attr_4 := dpnt_enrt.pen_attribute4;
388: ben_ext_person.g_enrt_attr_5 := dpnt_enrt.pen_attribute5;
389: ben_ext_person.g_enrt_attr_6 := dpnt_enrt.pen_attribute6;
390: ben_ext_person.g_enrt_attr_7 := dpnt_enrt.pen_attribute7;
391: ben_ext_person.g_enrt_attr_8 := dpnt_enrt.pen_attribute8;
392: ben_ext_person.g_enrt_attr_9 := dpnt_enrt.pen_attribute9;
385: ben_ext_person.g_enrt_attr_2 := dpnt_enrt.pen_attribute2;
386: ben_ext_person.g_enrt_attr_3 := dpnt_enrt.pen_attribute3;
387: ben_ext_person.g_enrt_attr_4 := dpnt_enrt.pen_attribute4;
388: ben_ext_person.g_enrt_attr_5 := dpnt_enrt.pen_attribute5;
389: ben_ext_person.g_enrt_attr_6 := dpnt_enrt.pen_attribute6;
390: ben_ext_person.g_enrt_attr_7 := dpnt_enrt.pen_attribute7;
391: ben_ext_person.g_enrt_attr_8 := dpnt_enrt.pen_attribute8;
392: ben_ext_person.g_enrt_attr_9 := dpnt_enrt.pen_attribute9;
393: ben_ext_person.g_enrt_attr_10 := dpnt_enrt.pen_attribute10;
386: ben_ext_person.g_enrt_attr_3 := dpnt_enrt.pen_attribute3;
387: ben_ext_person.g_enrt_attr_4 := dpnt_enrt.pen_attribute4;
388: ben_ext_person.g_enrt_attr_5 := dpnt_enrt.pen_attribute5;
389: ben_ext_person.g_enrt_attr_6 := dpnt_enrt.pen_attribute6;
390: ben_ext_person.g_enrt_attr_7 := dpnt_enrt.pen_attribute7;
391: ben_ext_person.g_enrt_attr_8 := dpnt_enrt.pen_attribute8;
392: ben_ext_person.g_enrt_attr_9 := dpnt_enrt.pen_attribute9;
393: ben_ext_person.g_enrt_attr_10 := dpnt_enrt.pen_attribute10;
394: ben_ext_person.g_pl_attr_1 := dpnt_enrt.pln_attribute1;
387: ben_ext_person.g_enrt_attr_4 := dpnt_enrt.pen_attribute4;
388: ben_ext_person.g_enrt_attr_5 := dpnt_enrt.pen_attribute5;
389: ben_ext_person.g_enrt_attr_6 := dpnt_enrt.pen_attribute6;
390: ben_ext_person.g_enrt_attr_7 := dpnt_enrt.pen_attribute7;
391: ben_ext_person.g_enrt_attr_8 := dpnt_enrt.pen_attribute8;
392: ben_ext_person.g_enrt_attr_9 := dpnt_enrt.pen_attribute9;
393: ben_ext_person.g_enrt_attr_10 := dpnt_enrt.pen_attribute10;
394: ben_ext_person.g_pl_attr_1 := dpnt_enrt.pln_attribute1;
395: ben_ext_person.g_pl_attr_2 := dpnt_enrt.pln_attribute2;
388: ben_ext_person.g_enrt_attr_5 := dpnt_enrt.pen_attribute5;
389: ben_ext_person.g_enrt_attr_6 := dpnt_enrt.pen_attribute6;
390: ben_ext_person.g_enrt_attr_7 := dpnt_enrt.pen_attribute7;
391: ben_ext_person.g_enrt_attr_8 := dpnt_enrt.pen_attribute8;
392: ben_ext_person.g_enrt_attr_9 := dpnt_enrt.pen_attribute9;
393: ben_ext_person.g_enrt_attr_10 := dpnt_enrt.pen_attribute10;
394: ben_ext_person.g_pl_attr_1 := dpnt_enrt.pln_attribute1;
395: ben_ext_person.g_pl_attr_2 := dpnt_enrt.pln_attribute2;
396: ben_ext_person.g_pl_attr_3 := dpnt_enrt.pln_attribute3;
389: ben_ext_person.g_enrt_attr_6 := dpnt_enrt.pen_attribute6;
390: ben_ext_person.g_enrt_attr_7 := dpnt_enrt.pen_attribute7;
391: ben_ext_person.g_enrt_attr_8 := dpnt_enrt.pen_attribute8;
392: ben_ext_person.g_enrt_attr_9 := dpnt_enrt.pen_attribute9;
393: ben_ext_person.g_enrt_attr_10 := dpnt_enrt.pen_attribute10;
394: ben_ext_person.g_pl_attr_1 := dpnt_enrt.pln_attribute1;
395: ben_ext_person.g_pl_attr_2 := dpnt_enrt.pln_attribute2;
396: ben_ext_person.g_pl_attr_3 := dpnt_enrt.pln_attribute3;
397: ben_ext_person.g_pl_attr_4 := dpnt_enrt.pln_attribute4;
390: ben_ext_person.g_enrt_attr_7 := dpnt_enrt.pen_attribute7;
391: ben_ext_person.g_enrt_attr_8 := dpnt_enrt.pen_attribute8;
392: ben_ext_person.g_enrt_attr_9 := dpnt_enrt.pen_attribute9;
393: ben_ext_person.g_enrt_attr_10 := dpnt_enrt.pen_attribute10;
394: ben_ext_person.g_pl_attr_1 := dpnt_enrt.pln_attribute1;
395: ben_ext_person.g_pl_attr_2 := dpnt_enrt.pln_attribute2;
396: ben_ext_person.g_pl_attr_3 := dpnt_enrt.pln_attribute3;
397: ben_ext_person.g_pl_attr_4 := dpnt_enrt.pln_attribute4;
398: ben_ext_person.g_pl_attr_5 := dpnt_enrt.pln_attribute5;
391: ben_ext_person.g_enrt_attr_8 := dpnt_enrt.pen_attribute8;
392: ben_ext_person.g_enrt_attr_9 := dpnt_enrt.pen_attribute9;
393: ben_ext_person.g_enrt_attr_10 := dpnt_enrt.pen_attribute10;
394: ben_ext_person.g_pl_attr_1 := dpnt_enrt.pln_attribute1;
395: ben_ext_person.g_pl_attr_2 := dpnt_enrt.pln_attribute2;
396: ben_ext_person.g_pl_attr_3 := dpnt_enrt.pln_attribute3;
397: ben_ext_person.g_pl_attr_4 := dpnt_enrt.pln_attribute4;
398: ben_ext_person.g_pl_attr_5 := dpnt_enrt.pln_attribute5;
399: ben_ext_person.g_pl_attr_6 := dpnt_enrt.pln_attribute6;
392: ben_ext_person.g_enrt_attr_9 := dpnt_enrt.pen_attribute9;
393: ben_ext_person.g_enrt_attr_10 := dpnt_enrt.pen_attribute10;
394: ben_ext_person.g_pl_attr_1 := dpnt_enrt.pln_attribute1;
395: ben_ext_person.g_pl_attr_2 := dpnt_enrt.pln_attribute2;
396: ben_ext_person.g_pl_attr_3 := dpnt_enrt.pln_attribute3;
397: ben_ext_person.g_pl_attr_4 := dpnt_enrt.pln_attribute4;
398: ben_ext_person.g_pl_attr_5 := dpnt_enrt.pln_attribute5;
399: ben_ext_person.g_pl_attr_6 := dpnt_enrt.pln_attribute6;
400: ben_ext_person.g_pl_attr_7 := dpnt_enrt.pln_attribute7;
393: ben_ext_person.g_enrt_attr_10 := dpnt_enrt.pen_attribute10;
394: ben_ext_person.g_pl_attr_1 := dpnt_enrt.pln_attribute1;
395: ben_ext_person.g_pl_attr_2 := dpnt_enrt.pln_attribute2;
396: ben_ext_person.g_pl_attr_3 := dpnt_enrt.pln_attribute3;
397: ben_ext_person.g_pl_attr_4 := dpnt_enrt.pln_attribute4;
398: ben_ext_person.g_pl_attr_5 := dpnt_enrt.pln_attribute5;
399: ben_ext_person.g_pl_attr_6 := dpnt_enrt.pln_attribute6;
400: ben_ext_person.g_pl_attr_7 := dpnt_enrt.pln_attribute7;
401: ben_ext_person.g_pl_attr_8 := dpnt_enrt.pln_attribute8;
394: ben_ext_person.g_pl_attr_1 := dpnt_enrt.pln_attribute1;
395: ben_ext_person.g_pl_attr_2 := dpnt_enrt.pln_attribute2;
396: ben_ext_person.g_pl_attr_3 := dpnt_enrt.pln_attribute3;
397: ben_ext_person.g_pl_attr_4 := dpnt_enrt.pln_attribute4;
398: ben_ext_person.g_pl_attr_5 := dpnt_enrt.pln_attribute5;
399: ben_ext_person.g_pl_attr_6 := dpnt_enrt.pln_attribute6;
400: ben_ext_person.g_pl_attr_7 := dpnt_enrt.pln_attribute7;
401: ben_ext_person.g_pl_attr_8 := dpnt_enrt.pln_attribute8;
402: ben_ext_person.g_pl_attr_9 := dpnt_enrt.pln_attribute9;
395: ben_ext_person.g_pl_attr_2 := dpnt_enrt.pln_attribute2;
396: ben_ext_person.g_pl_attr_3 := dpnt_enrt.pln_attribute3;
397: ben_ext_person.g_pl_attr_4 := dpnt_enrt.pln_attribute4;
398: ben_ext_person.g_pl_attr_5 := dpnt_enrt.pln_attribute5;
399: ben_ext_person.g_pl_attr_6 := dpnt_enrt.pln_attribute6;
400: ben_ext_person.g_pl_attr_7 := dpnt_enrt.pln_attribute7;
401: ben_ext_person.g_pl_attr_8 := dpnt_enrt.pln_attribute8;
402: ben_ext_person.g_pl_attr_9 := dpnt_enrt.pln_attribute9;
403: ben_ext_person.g_pl_attr_10 := dpnt_enrt.pln_attribute10;
396: ben_ext_person.g_pl_attr_3 := dpnt_enrt.pln_attribute3;
397: ben_ext_person.g_pl_attr_4 := dpnt_enrt.pln_attribute4;
398: ben_ext_person.g_pl_attr_5 := dpnt_enrt.pln_attribute5;
399: ben_ext_person.g_pl_attr_6 := dpnt_enrt.pln_attribute6;
400: ben_ext_person.g_pl_attr_7 := dpnt_enrt.pln_attribute7;
401: ben_ext_person.g_pl_attr_8 := dpnt_enrt.pln_attribute8;
402: ben_ext_person.g_pl_attr_9 := dpnt_enrt.pln_attribute9;
403: ben_ext_person.g_pl_attr_10 := dpnt_enrt.pln_attribute10;
404: ben_ext_person.g_ptp_attr_1 := dpnt_enrt.ptp_attribute1;
397: ben_ext_person.g_pl_attr_4 := dpnt_enrt.pln_attribute4;
398: ben_ext_person.g_pl_attr_5 := dpnt_enrt.pln_attribute5;
399: ben_ext_person.g_pl_attr_6 := dpnt_enrt.pln_attribute6;
400: ben_ext_person.g_pl_attr_7 := dpnt_enrt.pln_attribute7;
401: ben_ext_person.g_pl_attr_8 := dpnt_enrt.pln_attribute8;
402: ben_ext_person.g_pl_attr_9 := dpnt_enrt.pln_attribute9;
403: ben_ext_person.g_pl_attr_10 := dpnt_enrt.pln_attribute10;
404: ben_ext_person.g_ptp_attr_1 := dpnt_enrt.ptp_attribute1;
405: ben_ext_person.g_ptp_attr_2 := dpnt_enrt.ptp_attribute2;
398: ben_ext_person.g_pl_attr_5 := dpnt_enrt.pln_attribute5;
399: ben_ext_person.g_pl_attr_6 := dpnt_enrt.pln_attribute6;
400: ben_ext_person.g_pl_attr_7 := dpnt_enrt.pln_attribute7;
401: ben_ext_person.g_pl_attr_8 := dpnt_enrt.pln_attribute8;
402: ben_ext_person.g_pl_attr_9 := dpnt_enrt.pln_attribute9;
403: ben_ext_person.g_pl_attr_10 := dpnt_enrt.pln_attribute10;
404: ben_ext_person.g_ptp_attr_1 := dpnt_enrt.ptp_attribute1;
405: ben_ext_person.g_ptp_attr_2 := dpnt_enrt.ptp_attribute2;
406: ben_ext_person.g_ptp_attr_3 := dpnt_enrt.ptp_attribute3;
399: ben_ext_person.g_pl_attr_6 := dpnt_enrt.pln_attribute6;
400: ben_ext_person.g_pl_attr_7 := dpnt_enrt.pln_attribute7;
401: ben_ext_person.g_pl_attr_8 := dpnt_enrt.pln_attribute8;
402: ben_ext_person.g_pl_attr_9 := dpnt_enrt.pln_attribute9;
403: ben_ext_person.g_pl_attr_10 := dpnt_enrt.pln_attribute10;
404: ben_ext_person.g_ptp_attr_1 := dpnt_enrt.ptp_attribute1;
405: ben_ext_person.g_ptp_attr_2 := dpnt_enrt.ptp_attribute2;
406: ben_ext_person.g_ptp_attr_3 := dpnt_enrt.ptp_attribute3;
407: ben_ext_person.g_ptp_attr_4 := dpnt_enrt.ptp_attribute4;
400: ben_ext_person.g_pl_attr_7 := dpnt_enrt.pln_attribute7;
401: ben_ext_person.g_pl_attr_8 := dpnt_enrt.pln_attribute8;
402: ben_ext_person.g_pl_attr_9 := dpnt_enrt.pln_attribute9;
403: ben_ext_person.g_pl_attr_10 := dpnt_enrt.pln_attribute10;
404: ben_ext_person.g_ptp_attr_1 := dpnt_enrt.ptp_attribute1;
405: ben_ext_person.g_ptp_attr_2 := dpnt_enrt.ptp_attribute2;
406: ben_ext_person.g_ptp_attr_3 := dpnt_enrt.ptp_attribute3;
407: ben_ext_person.g_ptp_attr_4 := dpnt_enrt.ptp_attribute4;
408: ben_ext_person.g_ptp_attr_5 := dpnt_enrt.ptp_attribute5;
401: ben_ext_person.g_pl_attr_8 := dpnt_enrt.pln_attribute8;
402: ben_ext_person.g_pl_attr_9 := dpnt_enrt.pln_attribute9;
403: ben_ext_person.g_pl_attr_10 := dpnt_enrt.pln_attribute10;
404: ben_ext_person.g_ptp_attr_1 := dpnt_enrt.ptp_attribute1;
405: ben_ext_person.g_ptp_attr_2 := dpnt_enrt.ptp_attribute2;
406: ben_ext_person.g_ptp_attr_3 := dpnt_enrt.ptp_attribute3;
407: ben_ext_person.g_ptp_attr_4 := dpnt_enrt.ptp_attribute4;
408: ben_ext_person.g_ptp_attr_5 := dpnt_enrt.ptp_attribute5;
409: ben_ext_person.g_ptp_attr_6 := dpnt_enrt.ptp_attribute6;
402: ben_ext_person.g_pl_attr_9 := dpnt_enrt.pln_attribute9;
403: ben_ext_person.g_pl_attr_10 := dpnt_enrt.pln_attribute10;
404: ben_ext_person.g_ptp_attr_1 := dpnt_enrt.ptp_attribute1;
405: ben_ext_person.g_ptp_attr_2 := dpnt_enrt.ptp_attribute2;
406: ben_ext_person.g_ptp_attr_3 := dpnt_enrt.ptp_attribute3;
407: ben_ext_person.g_ptp_attr_4 := dpnt_enrt.ptp_attribute4;
408: ben_ext_person.g_ptp_attr_5 := dpnt_enrt.ptp_attribute5;
409: ben_ext_person.g_ptp_attr_6 := dpnt_enrt.ptp_attribute6;
410: ben_ext_person.g_ptp_attr_7 := dpnt_enrt.ptp_attribute7;
403: ben_ext_person.g_pl_attr_10 := dpnt_enrt.pln_attribute10;
404: ben_ext_person.g_ptp_attr_1 := dpnt_enrt.ptp_attribute1;
405: ben_ext_person.g_ptp_attr_2 := dpnt_enrt.ptp_attribute2;
406: ben_ext_person.g_ptp_attr_3 := dpnt_enrt.ptp_attribute3;
407: ben_ext_person.g_ptp_attr_4 := dpnt_enrt.ptp_attribute4;
408: ben_ext_person.g_ptp_attr_5 := dpnt_enrt.ptp_attribute5;
409: ben_ext_person.g_ptp_attr_6 := dpnt_enrt.ptp_attribute6;
410: ben_ext_person.g_ptp_attr_7 := dpnt_enrt.ptp_attribute7;
411: ben_ext_person.g_ptp_attr_8 := dpnt_enrt.ptp_attribute8;
404: ben_ext_person.g_ptp_attr_1 := dpnt_enrt.ptp_attribute1;
405: ben_ext_person.g_ptp_attr_2 := dpnt_enrt.ptp_attribute2;
406: ben_ext_person.g_ptp_attr_3 := dpnt_enrt.ptp_attribute3;
407: ben_ext_person.g_ptp_attr_4 := dpnt_enrt.ptp_attribute4;
408: ben_ext_person.g_ptp_attr_5 := dpnt_enrt.ptp_attribute5;
409: ben_ext_person.g_ptp_attr_6 := dpnt_enrt.ptp_attribute6;
410: ben_ext_person.g_ptp_attr_7 := dpnt_enrt.ptp_attribute7;
411: ben_ext_person.g_ptp_attr_8 := dpnt_enrt.ptp_attribute8;
412: ben_ext_person.g_ptp_attr_9 := dpnt_enrt.ptp_attribute9;
405: ben_ext_person.g_ptp_attr_2 := dpnt_enrt.ptp_attribute2;
406: ben_ext_person.g_ptp_attr_3 := dpnt_enrt.ptp_attribute3;
407: ben_ext_person.g_ptp_attr_4 := dpnt_enrt.ptp_attribute4;
408: ben_ext_person.g_ptp_attr_5 := dpnt_enrt.ptp_attribute5;
409: ben_ext_person.g_ptp_attr_6 := dpnt_enrt.ptp_attribute6;
410: ben_ext_person.g_ptp_attr_7 := dpnt_enrt.ptp_attribute7;
411: ben_ext_person.g_ptp_attr_8 := dpnt_enrt.ptp_attribute8;
412: ben_ext_person.g_ptp_attr_9 := dpnt_enrt.ptp_attribute9;
413: ben_ext_person.g_ptp_attr_10 := dpnt_enrt.ptp_attribute10;
406: ben_ext_person.g_ptp_attr_3 := dpnt_enrt.ptp_attribute3;
407: ben_ext_person.g_ptp_attr_4 := dpnt_enrt.ptp_attribute4;
408: ben_ext_person.g_ptp_attr_5 := dpnt_enrt.ptp_attribute5;
409: ben_ext_person.g_ptp_attr_6 := dpnt_enrt.ptp_attribute6;
410: ben_ext_person.g_ptp_attr_7 := dpnt_enrt.ptp_attribute7;
411: ben_ext_person.g_ptp_attr_8 := dpnt_enrt.ptp_attribute8;
412: ben_ext_person.g_ptp_attr_9 := dpnt_enrt.ptp_attribute9;
413: ben_ext_person.g_ptp_attr_10 := dpnt_enrt.ptp_attribute10;
414: --
407: ben_ext_person.g_ptp_attr_4 := dpnt_enrt.ptp_attribute4;
408: ben_ext_person.g_ptp_attr_5 := dpnt_enrt.ptp_attribute5;
409: ben_ext_person.g_ptp_attr_6 := dpnt_enrt.ptp_attribute6;
410: ben_ext_person.g_ptp_attr_7 := dpnt_enrt.ptp_attribute7;
411: ben_ext_person.g_ptp_attr_8 := dpnt_enrt.ptp_attribute8;
412: ben_ext_person.g_ptp_attr_9 := dpnt_enrt.ptp_attribute9;
413: ben_ext_person.g_ptp_attr_10 := dpnt_enrt.ptp_attribute10;
414: --
415:
408: ben_ext_person.g_ptp_attr_5 := dpnt_enrt.ptp_attribute5;
409: ben_ext_person.g_ptp_attr_6 := dpnt_enrt.ptp_attribute6;
410: ben_ext_person.g_ptp_attr_7 := dpnt_enrt.ptp_attribute7;
411: ben_ext_person.g_ptp_attr_8 := dpnt_enrt.ptp_attribute8;
412: ben_ext_person.g_ptp_attr_9 := dpnt_enrt.ptp_attribute9;
413: ben_ext_person.g_ptp_attr_10 := dpnt_enrt.ptp_attribute10;
414: --
415:
416: --
409: ben_ext_person.g_ptp_attr_6 := dpnt_enrt.ptp_attribute6;
410: ben_ext_person.g_ptp_attr_7 := dpnt_enrt.ptp_attribute7;
411: ben_ext_person.g_ptp_attr_8 := dpnt_enrt.ptp_attribute8;
412: ben_ext_person.g_ptp_attr_9 := dpnt_enrt.ptp_attribute9;
413: ben_ext_person.g_ptp_attr_10 := dpnt_enrt.ptp_attribute10;
414: --
415:
416: --
417: if dpnt_enrt.pgm_id is not null then
416: --
417: if dpnt_enrt.pgm_id is not null then
418: open c_pgm_enrt (dpnt_enrt.pgm_id) ;
419: fetch c_pgm_enrt into
420: ben_ext_person.g_enrt_pgm_name
421: ,ben_ext_person.g_pgm_attr_1
422: ,ben_ext_person.g_pgm_attr_2
423: ,ben_ext_person.g_pgm_attr_3
424: ,ben_ext_person.g_pgm_attr_4
417: if dpnt_enrt.pgm_id is not null then
418: open c_pgm_enrt (dpnt_enrt.pgm_id) ;
419: fetch c_pgm_enrt into
420: ben_ext_person.g_enrt_pgm_name
421: ,ben_ext_person.g_pgm_attr_1
422: ,ben_ext_person.g_pgm_attr_2
423: ,ben_ext_person.g_pgm_attr_3
424: ,ben_ext_person.g_pgm_attr_4
425: ,ben_ext_person.g_pgm_attr_5
418: open c_pgm_enrt (dpnt_enrt.pgm_id) ;
419: fetch c_pgm_enrt into
420: ben_ext_person.g_enrt_pgm_name
421: ,ben_ext_person.g_pgm_attr_1
422: ,ben_ext_person.g_pgm_attr_2
423: ,ben_ext_person.g_pgm_attr_3
424: ,ben_ext_person.g_pgm_attr_4
425: ,ben_ext_person.g_pgm_attr_5
426: ,ben_ext_person.g_pgm_attr_6
419: fetch c_pgm_enrt into
420: ben_ext_person.g_enrt_pgm_name
421: ,ben_ext_person.g_pgm_attr_1
422: ,ben_ext_person.g_pgm_attr_2
423: ,ben_ext_person.g_pgm_attr_3
424: ,ben_ext_person.g_pgm_attr_4
425: ,ben_ext_person.g_pgm_attr_5
426: ,ben_ext_person.g_pgm_attr_6
427: ,ben_ext_person.g_pgm_attr_7
420: ben_ext_person.g_enrt_pgm_name
421: ,ben_ext_person.g_pgm_attr_1
422: ,ben_ext_person.g_pgm_attr_2
423: ,ben_ext_person.g_pgm_attr_3
424: ,ben_ext_person.g_pgm_attr_4
425: ,ben_ext_person.g_pgm_attr_5
426: ,ben_ext_person.g_pgm_attr_6
427: ,ben_ext_person.g_pgm_attr_7
428: ,ben_ext_person.g_pgm_attr_8
421: ,ben_ext_person.g_pgm_attr_1
422: ,ben_ext_person.g_pgm_attr_2
423: ,ben_ext_person.g_pgm_attr_3
424: ,ben_ext_person.g_pgm_attr_4
425: ,ben_ext_person.g_pgm_attr_5
426: ,ben_ext_person.g_pgm_attr_6
427: ,ben_ext_person.g_pgm_attr_7
428: ,ben_ext_person.g_pgm_attr_8
429: ,ben_ext_person.g_pgm_attr_9
422: ,ben_ext_person.g_pgm_attr_2
423: ,ben_ext_person.g_pgm_attr_3
424: ,ben_ext_person.g_pgm_attr_4
425: ,ben_ext_person.g_pgm_attr_5
426: ,ben_ext_person.g_pgm_attr_6
427: ,ben_ext_person.g_pgm_attr_7
428: ,ben_ext_person.g_pgm_attr_8
429: ,ben_ext_person.g_pgm_attr_9
430: ,ben_ext_person.g_pgm_attr_10
423: ,ben_ext_person.g_pgm_attr_3
424: ,ben_ext_person.g_pgm_attr_4
425: ,ben_ext_person.g_pgm_attr_5
426: ,ben_ext_person.g_pgm_attr_6
427: ,ben_ext_person.g_pgm_attr_7
428: ,ben_ext_person.g_pgm_attr_8
429: ,ben_ext_person.g_pgm_attr_9
430: ,ben_ext_person.g_pgm_attr_10
431: ;
424: ,ben_ext_person.g_pgm_attr_4
425: ,ben_ext_person.g_pgm_attr_5
426: ,ben_ext_person.g_pgm_attr_6
427: ,ben_ext_person.g_pgm_attr_7
428: ,ben_ext_person.g_pgm_attr_8
429: ,ben_ext_person.g_pgm_attr_9
430: ,ben_ext_person.g_pgm_attr_10
431: ;
432: close c_pgm_enrt ;
425: ,ben_ext_person.g_pgm_attr_5
426: ,ben_ext_person.g_pgm_attr_6
427: ,ben_ext_person.g_pgm_attr_7
428: ,ben_ext_person.g_pgm_attr_8
429: ,ben_ext_person.g_pgm_attr_9
430: ,ben_ext_person.g_pgm_attr_10
431: ;
432: close c_pgm_enrt ;
433: end if ;
426: ,ben_ext_person.g_pgm_attr_6
427: ,ben_ext_person.g_pgm_attr_7
428: ,ben_ext_person.g_pgm_attr_8
429: ,ben_ext_person.g_pgm_attr_9
430: ,ben_ext_person.g_pgm_attr_10
431: ;
432: close c_pgm_enrt ;
433: end if ;
434:
435: if dpnt_enrt.pgm_id is not null and dpnt_enrt.pl_id is not null then
436: open c_plip_enrt (dpnt_enrt.pl_id ,
437: dpnt_enrt.pgm_id ) ;
438: fetch c_plip_enrt into
439: ben_ext_person.g_plip_attr_1
440: ,ben_ext_person.g_plip_attr_2
441: ,ben_ext_person.g_plip_attr_3
442: ,ben_ext_person.g_plip_attr_4
443: ,ben_ext_person.g_plip_attr_5
436: open c_plip_enrt (dpnt_enrt.pl_id ,
437: dpnt_enrt.pgm_id ) ;
438: fetch c_plip_enrt into
439: ben_ext_person.g_plip_attr_1
440: ,ben_ext_person.g_plip_attr_2
441: ,ben_ext_person.g_plip_attr_3
442: ,ben_ext_person.g_plip_attr_4
443: ,ben_ext_person.g_plip_attr_5
444: ,ben_ext_person.g_plip_attr_6
437: dpnt_enrt.pgm_id ) ;
438: fetch c_plip_enrt into
439: ben_ext_person.g_plip_attr_1
440: ,ben_ext_person.g_plip_attr_2
441: ,ben_ext_person.g_plip_attr_3
442: ,ben_ext_person.g_plip_attr_4
443: ,ben_ext_person.g_plip_attr_5
444: ,ben_ext_person.g_plip_attr_6
445: ,ben_ext_person.g_plip_attr_7
438: fetch c_plip_enrt into
439: ben_ext_person.g_plip_attr_1
440: ,ben_ext_person.g_plip_attr_2
441: ,ben_ext_person.g_plip_attr_3
442: ,ben_ext_person.g_plip_attr_4
443: ,ben_ext_person.g_plip_attr_5
444: ,ben_ext_person.g_plip_attr_6
445: ,ben_ext_person.g_plip_attr_7
446: ,ben_ext_person.g_plip_attr_8
439: ben_ext_person.g_plip_attr_1
440: ,ben_ext_person.g_plip_attr_2
441: ,ben_ext_person.g_plip_attr_3
442: ,ben_ext_person.g_plip_attr_4
443: ,ben_ext_person.g_plip_attr_5
444: ,ben_ext_person.g_plip_attr_6
445: ,ben_ext_person.g_plip_attr_7
446: ,ben_ext_person.g_plip_attr_8
447: ,ben_ext_person.g_plip_attr_9
440: ,ben_ext_person.g_plip_attr_2
441: ,ben_ext_person.g_plip_attr_3
442: ,ben_ext_person.g_plip_attr_4
443: ,ben_ext_person.g_plip_attr_5
444: ,ben_ext_person.g_plip_attr_6
445: ,ben_ext_person.g_plip_attr_7
446: ,ben_ext_person.g_plip_attr_8
447: ,ben_ext_person.g_plip_attr_9
448: ,ben_ext_person.g_plip_attr_10
441: ,ben_ext_person.g_plip_attr_3
442: ,ben_ext_person.g_plip_attr_4
443: ,ben_ext_person.g_plip_attr_5
444: ,ben_ext_person.g_plip_attr_6
445: ,ben_ext_person.g_plip_attr_7
446: ,ben_ext_person.g_plip_attr_8
447: ,ben_ext_person.g_plip_attr_9
448: ,ben_ext_person.g_plip_attr_10
449: ;
442: ,ben_ext_person.g_plip_attr_4
443: ,ben_ext_person.g_plip_attr_5
444: ,ben_ext_person.g_plip_attr_6
445: ,ben_ext_person.g_plip_attr_7
446: ,ben_ext_person.g_plip_attr_8
447: ,ben_ext_person.g_plip_attr_9
448: ,ben_ext_person.g_plip_attr_10
449: ;
450: close c_plip_enrt ;
443: ,ben_ext_person.g_plip_attr_5
444: ,ben_ext_person.g_plip_attr_6
445: ,ben_ext_person.g_plip_attr_7
446: ,ben_ext_person.g_plip_attr_8
447: ,ben_ext_person.g_plip_attr_9
448: ,ben_ext_person.g_plip_attr_10
449: ;
450: close c_plip_enrt ;
451:
444: ,ben_ext_person.g_plip_attr_6
445: ,ben_ext_person.g_plip_attr_7
446: ,ben_ext_person.g_plip_attr_8
447: ,ben_ext_person.g_plip_attr_9
448: ,ben_ext_person.g_plip_attr_10
449: ;
450: close c_plip_enrt ;
451:
452: end if ;
454: if dpnt_enrt.oipl_id is not null then
455:
456: open c_oipl_enrt(dpnt_enrt.oipl_id) ;
457: fetch c_oipl_enrt into
458: ben_ext_person.g_enrt_opt_id
459: ,ben_ext_person.g_enrt_opt_name
460: ,ben_ext_person.g_oipl_attr_1
461: ,ben_ext_person.g_oipl_attr_2
462: ,ben_ext_person.g_oipl_attr_3
455:
456: open c_oipl_enrt(dpnt_enrt.oipl_id) ;
457: fetch c_oipl_enrt into
458: ben_ext_person.g_enrt_opt_id
459: ,ben_ext_person.g_enrt_opt_name
460: ,ben_ext_person.g_oipl_attr_1
461: ,ben_ext_person.g_oipl_attr_2
462: ,ben_ext_person.g_oipl_attr_3
463: ,ben_ext_person.g_oipl_attr_4
456: open c_oipl_enrt(dpnt_enrt.oipl_id) ;
457: fetch c_oipl_enrt into
458: ben_ext_person.g_enrt_opt_id
459: ,ben_ext_person.g_enrt_opt_name
460: ,ben_ext_person.g_oipl_attr_1
461: ,ben_ext_person.g_oipl_attr_2
462: ,ben_ext_person.g_oipl_attr_3
463: ,ben_ext_person.g_oipl_attr_4
464: ,ben_ext_person.g_oipl_attr_5
457: fetch c_oipl_enrt into
458: ben_ext_person.g_enrt_opt_id
459: ,ben_ext_person.g_enrt_opt_name
460: ,ben_ext_person.g_oipl_attr_1
461: ,ben_ext_person.g_oipl_attr_2
462: ,ben_ext_person.g_oipl_attr_3
463: ,ben_ext_person.g_oipl_attr_4
464: ,ben_ext_person.g_oipl_attr_5
465: ,ben_ext_person.g_oipl_attr_6
458: ben_ext_person.g_enrt_opt_id
459: ,ben_ext_person.g_enrt_opt_name
460: ,ben_ext_person.g_oipl_attr_1
461: ,ben_ext_person.g_oipl_attr_2
462: ,ben_ext_person.g_oipl_attr_3
463: ,ben_ext_person.g_oipl_attr_4
464: ,ben_ext_person.g_oipl_attr_5
465: ,ben_ext_person.g_oipl_attr_6
466: ,ben_ext_person.g_oipl_attr_7
459: ,ben_ext_person.g_enrt_opt_name
460: ,ben_ext_person.g_oipl_attr_1
461: ,ben_ext_person.g_oipl_attr_2
462: ,ben_ext_person.g_oipl_attr_3
463: ,ben_ext_person.g_oipl_attr_4
464: ,ben_ext_person.g_oipl_attr_5
465: ,ben_ext_person.g_oipl_attr_6
466: ,ben_ext_person.g_oipl_attr_7
467: ,ben_ext_person.g_oipl_attr_8
460: ,ben_ext_person.g_oipl_attr_1
461: ,ben_ext_person.g_oipl_attr_2
462: ,ben_ext_person.g_oipl_attr_3
463: ,ben_ext_person.g_oipl_attr_4
464: ,ben_ext_person.g_oipl_attr_5
465: ,ben_ext_person.g_oipl_attr_6
466: ,ben_ext_person.g_oipl_attr_7
467: ,ben_ext_person.g_oipl_attr_8
468: ,ben_ext_person.g_oipl_attr_9
461: ,ben_ext_person.g_oipl_attr_2
462: ,ben_ext_person.g_oipl_attr_3
463: ,ben_ext_person.g_oipl_attr_4
464: ,ben_ext_person.g_oipl_attr_5
465: ,ben_ext_person.g_oipl_attr_6
466: ,ben_ext_person.g_oipl_attr_7
467: ,ben_ext_person.g_oipl_attr_8
468: ,ben_ext_person.g_oipl_attr_9
469: ,ben_ext_person.g_oipl_attr_10
462: ,ben_ext_person.g_oipl_attr_3
463: ,ben_ext_person.g_oipl_attr_4
464: ,ben_ext_person.g_oipl_attr_5
465: ,ben_ext_person.g_oipl_attr_6
466: ,ben_ext_person.g_oipl_attr_7
467: ,ben_ext_person.g_oipl_attr_8
468: ,ben_ext_person.g_oipl_attr_9
469: ,ben_ext_person.g_oipl_attr_10
470: ;
463: ,ben_ext_person.g_oipl_attr_4
464: ,ben_ext_person.g_oipl_attr_5
465: ,ben_ext_person.g_oipl_attr_6
466: ,ben_ext_person.g_oipl_attr_7
467: ,ben_ext_person.g_oipl_attr_8
468: ,ben_ext_person.g_oipl_attr_9
469: ,ben_ext_person.g_oipl_attr_10
470: ;
471: close c_oipl_enrt ;
464: ,ben_ext_person.g_oipl_attr_5
465: ,ben_ext_person.g_oipl_attr_6
466: ,ben_ext_person.g_oipl_attr_7
467: ,ben_ext_person.g_oipl_attr_8
468: ,ben_ext_person.g_oipl_attr_9
469: ,ben_ext_person.g_oipl_attr_10
470: ;
471: close c_oipl_enrt ;
472: end if ;
465: ,ben_ext_person.g_oipl_attr_6
466: ,ben_ext_person.g_oipl_attr_7
467: ,ben_ext_person.g_oipl_attr_8
468: ,ben_ext_person.g_oipl_attr_9
469: ,ben_ext_person.g_oipl_attr_10
470: ;
471: close c_oipl_enrt ;
472: end if ;
473: --
481: open c_prtt_asg ;
482: fetch c_prtt_asg into l_prtt_asg_id ;
483: close c_prtt_asg ;
484:
485: open plcy_c(dpnt_enrt.pl_id , nvl(ben_ext_person.g_assignment_id,l_prtt_asg_id));
486: fetch plcy_c into ben_ext_person.g_enrt_plcy_r_grp;
487: close plcy_c;
488: end if;
489: --
482: fetch c_prtt_asg into l_prtt_asg_id ;
483: close c_prtt_asg ;
484:
485: open plcy_c(dpnt_enrt.pl_id , nvl(ben_ext_person.g_assignment_id,l_prtt_asg_id));
486: fetch plcy_c into ben_ext_person.g_enrt_plcy_r_grp;
487: close plcy_c;
488: end if;
489: --
490: -- retrieve primary care provider info if required
490: -- retrieve primary care provider info if required
491: --
492: if ben_extract.g_ppcp_csr = 'Y' then
493: open c_dpnt_prmry_care_prvdr(dpnt_enrt.elig_cvrd_dpnt_id);
494: fetch c_dpnt_prmry_care_prvdr into ben_ext_person.g_ppr_name
495: ,ben_ext_person.g_ppr_ident
496: ,ben_ext_person.g_ppr_typ
497: ,ben_ext_person.g_ppr_strt_dt
498: ,ben_ext_person.g_ppr_end_dt;
491: --
492: if ben_extract.g_ppcp_csr = 'Y' then
493: open c_dpnt_prmry_care_prvdr(dpnt_enrt.elig_cvrd_dpnt_id);
494: fetch c_dpnt_prmry_care_prvdr into ben_ext_person.g_ppr_name
495: ,ben_ext_person.g_ppr_ident
496: ,ben_ext_person.g_ppr_typ
497: ,ben_ext_person.g_ppr_strt_dt
498: ,ben_ext_person.g_ppr_end_dt;
499: close c_dpnt_prmry_care_prvdr;
492: if ben_extract.g_ppcp_csr = 'Y' then
493: open c_dpnt_prmry_care_prvdr(dpnt_enrt.elig_cvrd_dpnt_id);
494: fetch c_dpnt_prmry_care_prvdr into ben_ext_person.g_ppr_name
495: ,ben_ext_person.g_ppr_ident
496: ,ben_ext_person.g_ppr_typ
497: ,ben_ext_person.g_ppr_strt_dt
498: ,ben_ext_person.g_ppr_end_dt;
499: close c_dpnt_prmry_care_prvdr;
500: end if;
493: open c_dpnt_prmry_care_prvdr(dpnt_enrt.elig_cvrd_dpnt_id);
494: fetch c_dpnt_prmry_care_prvdr into ben_ext_person.g_ppr_name
495: ,ben_ext_person.g_ppr_ident
496: ,ben_ext_person.g_ppr_typ
497: ,ben_ext_person.g_ppr_strt_dt
498: ,ben_ext_person.g_ppr_end_dt;
499: close c_dpnt_prmry_care_prvdr;
500: end if;
501: --
494: fetch c_dpnt_prmry_care_prvdr into ben_ext_person.g_ppr_name
495: ,ben_ext_person.g_ppr_ident
496: ,ben_ext_person.g_ppr_typ
497: ,ben_ext_person.g_ppr_strt_dt
498: ,ben_ext_person.g_ppr_end_dt;
499: close c_dpnt_prmry_care_prvdr;
500: end if;
501: --
502: --