18: BEGIN
19: --
20: hr_utility.set_location('Entering'||l_proc, 5);
21: --
22: ben_ext_person.g_actn_prtt_enrt_actn_id := null;
23: ben_ext_person.g_actn_type_id := null;
24: ben_ext_person.g_actn_name := null;
25: ben_ext_person.g_actn_description := null;
26: ben_ext_person.g_actn_type := null;
19: --
20: hr_utility.set_location('Entering'||l_proc, 5);
21: --
22: ben_ext_person.g_actn_prtt_enrt_actn_id := null;
23: ben_ext_person.g_actn_type_id := null;
24: ben_ext_person.g_actn_name := null;
25: ben_ext_person.g_actn_description := null;
26: ben_ext_person.g_actn_type := null;
27: ben_ext_person.g_actn_due_date := null;
20: hr_utility.set_location('Entering'||l_proc, 5);
21: --
22: ben_ext_person.g_actn_prtt_enrt_actn_id := null;
23: ben_ext_person.g_actn_type_id := null;
24: ben_ext_person.g_actn_name := null;
25: ben_ext_person.g_actn_description := null;
26: ben_ext_person.g_actn_type := null;
27: ben_ext_person.g_actn_due_date := null;
28: ben_ext_person.g_actn_required_flag := null;
21: --
22: ben_ext_person.g_actn_prtt_enrt_actn_id := null;
23: ben_ext_person.g_actn_type_id := null;
24: ben_ext_person.g_actn_name := null;
25: ben_ext_person.g_actn_description := null;
26: ben_ext_person.g_actn_type := null;
27: ben_ext_person.g_actn_due_date := null;
28: ben_ext_person.g_actn_required_flag := null;
29: ben_ext_person.g_actn_cmpltd_date := null;
22: ben_ext_person.g_actn_prtt_enrt_actn_id := null;
23: ben_ext_person.g_actn_type_id := null;
24: ben_ext_person.g_actn_name := null;
25: ben_ext_person.g_actn_description := null;
26: ben_ext_person.g_actn_type := null;
27: ben_ext_person.g_actn_due_date := null;
28: ben_ext_person.g_actn_required_flag := null;
29: ben_ext_person.g_actn_cmpltd_date := null;
30: --
23: ben_ext_person.g_actn_type_id := null;
24: ben_ext_person.g_actn_name := null;
25: ben_ext_person.g_actn_description := null;
26: ben_ext_person.g_actn_type := null;
27: ben_ext_person.g_actn_due_date := null;
28: ben_ext_person.g_actn_required_flag := null;
29: ben_ext_person.g_actn_cmpltd_date := null;
30: --
31: hr_utility.set_location('Exiting'||l_proc, 15);
24: ben_ext_person.g_actn_name := null;
25: ben_ext_person.g_actn_description := null;
26: ben_ext_person.g_actn_type := null;
27: ben_ext_person.g_actn_due_date := null;
28: ben_ext_person.g_actn_required_flag := null;
29: ben_ext_person.g_actn_cmpltd_date := null;
30: --
31: hr_utility.set_location('Exiting'||l_proc, 15);
32: --
25: ben_ext_person.g_actn_description := null;
26: ben_ext_person.g_actn_type := null;
27: ben_ext_person.g_actn_due_date := null;
28: ben_ext_person.g_actn_required_flag := null;
29: ben_ext_person.g_actn_cmpltd_date := null;
30: --
31: hr_utility.set_location('Exiting'||l_proc, 15);
32: --
33: End initialize_globals;
89: if l_include = 'Y' then
90:
91: -- fetch actions information into globals
92: --
93: ben_ext_person.g_actn_type_id := actn.action_id;
94: ben_ext_person.g_actn_name := actn.action_name;
95: ben_ext_person.g_actn_description := actn.action_desc;
96: ben_ext_person.g_actn_type := actn.action_type;
97: ben_ext_person.g_actn_due_date := actn.action_due_dt;
90:
91: -- fetch actions information into globals
92: --
93: ben_ext_person.g_actn_type_id := actn.action_id;
94: ben_ext_person.g_actn_name := actn.action_name;
95: ben_ext_person.g_actn_description := actn.action_desc;
96: ben_ext_person.g_actn_type := actn.action_type;
97: ben_ext_person.g_actn_due_date := actn.action_due_dt;
98: ben_ext_person.g_actn_required_flag := actn.action_rqd_flag;
91: -- fetch actions information into globals
92: --
93: ben_ext_person.g_actn_type_id := actn.action_id;
94: ben_ext_person.g_actn_name := actn.action_name;
95: ben_ext_person.g_actn_description := actn.action_desc;
96: ben_ext_person.g_actn_type := actn.action_type;
97: ben_ext_person.g_actn_due_date := actn.action_due_dt;
98: ben_ext_person.g_actn_required_flag := actn.action_rqd_flag;
99: ben_ext_person.g_actn_cmpltd_date := actn.action_cmpltd_dt;
92: --
93: ben_ext_person.g_actn_type_id := actn.action_id;
94: ben_ext_person.g_actn_name := actn.action_name;
95: ben_ext_person.g_actn_description := actn.action_desc;
96: ben_ext_person.g_actn_type := actn.action_type;
97: ben_ext_person.g_actn_due_date := actn.action_due_dt;
98: ben_ext_person.g_actn_required_flag := actn.action_rqd_flag;
99: ben_ext_person.g_actn_cmpltd_date := actn.action_cmpltd_dt;
100: ben_ext_person.g_actn_prtt_enrt_actn_id := actn.prtt_enrt_actn_id;
93: ben_ext_person.g_actn_type_id := actn.action_id;
94: ben_ext_person.g_actn_name := actn.action_name;
95: ben_ext_person.g_actn_description := actn.action_desc;
96: ben_ext_person.g_actn_type := actn.action_type;
97: ben_ext_person.g_actn_due_date := actn.action_due_dt;
98: ben_ext_person.g_actn_required_flag := actn.action_rqd_flag;
99: ben_ext_person.g_actn_cmpltd_date := actn.action_cmpltd_dt;
100: ben_ext_person.g_actn_prtt_enrt_actn_id := actn.prtt_enrt_actn_id;
101: --
94: ben_ext_person.g_actn_name := actn.action_name;
95: ben_ext_person.g_actn_description := actn.action_desc;
96: ben_ext_person.g_actn_type := actn.action_type;
97: ben_ext_person.g_actn_due_date := actn.action_due_dt;
98: ben_ext_person.g_actn_required_flag := actn.action_rqd_flag;
99: ben_ext_person.g_actn_cmpltd_date := actn.action_cmpltd_dt;
100: ben_ext_person.g_actn_prtt_enrt_actn_id := actn.prtt_enrt_actn_id;
101: --
102: -- format and write
95: ben_ext_person.g_actn_description := actn.action_desc;
96: ben_ext_person.g_actn_type := actn.action_type;
97: ben_ext_person.g_actn_due_date := actn.action_due_dt;
98: ben_ext_person.g_actn_required_flag := actn.action_rqd_flag;
99: ben_ext_person.g_actn_cmpltd_date := actn.action_cmpltd_dt;
100: ben_ext_person.g_actn_prtt_enrt_actn_id := actn.prtt_enrt_actn_id;
101: --
102: -- format and write
103: --
96: ben_ext_person.g_actn_type := actn.action_type;
97: ben_ext_person.g_actn_due_date := actn.action_due_dt;
98: ben_ext_person.g_actn_required_flag := actn.action_rqd_flag;
99: ben_ext_person.g_actn_cmpltd_date := actn.action_cmpltd_dt;
100: ben_ext_person.g_actn_prtt_enrt_actn_id := actn.prtt_enrt_actn_id;
101: --
102: -- format and write
103: --
104: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,