eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EXT_BNF dependencies on BEN_EXT_PERSON

Line 22: ben_ext_person.g_bnf_pl_bnf_id := null;

18: Begin
19: --
20: hr_utility.set_location('Entering'||l_proc, 5);
21: --
22: ben_ext_person.g_bnf_pl_bnf_id := null;
23: ben_ext_person.g_bnf_ssn := null;
24: ben_ext_person.g_bnf_lst_nm := null;
25: ben_ext_person.g_bnf_fst_nm := null;
26: ben_ext_person.g_bnf_mid_nm := null;

Line 23: ben_ext_person.g_bnf_ssn := null;

19: --
20: hr_utility.set_location('Entering'||l_proc, 5);
21: --
22: ben_ext_person.g_bnf_pl_bnf_id := null;
23: ben_ext_person.g_bnf_ssn := null;
24: ben_ext_person.g_bnf_lst_nm := null;
25: ben_ext_person.g_bnf_fst_nm := null;
26: ben_ext_person.g_bnf_mid_nm := null;
27: ben_ext_person.g_bnf_fl_nm := null;

Line 24: ben_ext_person.g_bnf_lst_nm := null;

20: hr_utility.set_location('Entering'||l_proc, 5);
21: --
22: ben_ext_person.g_bnf_pl_bnf_id := null;
23: ben_ext_person.g_bnf_ssn := null;
24: ben_ext_person.g_bnf_lst_nm := null;
25: ben_ext_person.g_bnf_fst_nm := null;
26: ben_ext_person.g_bnf_mid_nm := null;
27: ben_ext_person.g_bnf_fl_nm := null;
28: ben_ext_person.g_bnf_suffix := null;

Line 25: ben_ext_person.g_bnf_fst_nm := null;

21: --
22: ben_ext_person.g_bnf_pl_bnf_id := null;
23: ben_ext_person.g_bnf_ssn := null;
24: ben_ext_person.g_bnf_lst_nm := null;
25: ben_ext_person.g_bnf_fst_nm := null;
26: ben_ext_person.g_bnf_mid_nm := null;
27: ben_ext_person.g_bnf_fl_nm := null;
28: ben_ext_person.g_bnf_suffix := null;
29: ben_ext_person.g_bnf_prefix := null;

Line 26: ben_ext_person.g_bnf_mid_nm := null;

22: ben_ext_person.g_bnf_pl_bnf_id := null;
23: ben_ext_person.g_bnf_ssn := null;
24: ben_ext_person.g_bnf_lst_nm := null;
25: ben_ext_person.g_bnf_fst_nm := null;
26: ben_ext_person.g_bnf_mid_nm := null;
27: ben_ext_person.g_bnf_fl_nm := null;
28: ben_ext_person.g_bnf_suffix := null;
29: ben_ext_person.g_bnf_prefix := null;
30: ben_ext_person.g_bnf_title := null;

Line 27: ben_ext_person.g_bnf_fl_nm := null;

23: ben_ext_person.g_bnf_ssn := null;
24: ben_ext_person.g_bnf_lst_nm := null;
25: ben_ext_person.g_bnf_fst_nm := null;
26: ben_ext_person.g_bnf_mid_nm := null;
27: ben_ext_person.g_bnf_fl_nm := null;
28: ben_ext_person.g_bnf_suffix := null;
29: ben_ext_person.g_bnf_prefix := null;
30: ben_ext_person.g_bnf_title := null;
31: ben_ext_person.g_bnf_prv_lst_nm := null;

Line 28: ben_ext_person.g_bnf_suffix := null;

24: ben_ext_person.g_bnf_lst_nm := null;
25: ben_ext_person.g_bnf_fst_nm := null;
26: ben_ext_person.g_bnf_mid_nm := null;
27: ben_ext_person.g_bnf_fl_nm := null;
28: ben_ext_person.g_bnf_suffix := null;
29: ben_ext_person.g_bnf_prefix := null;
30: ben_ext_person.g_bnf_title := null;
31: ben_ext_person.g_bnf_prv_lst_nm := null;
32: ben_ext_person.g_bnf_pre_nm_adjunct := null;

Line 29: ben_ext_person.g_bnf_prefix := null;

25: ben_ext_person.g_bnf_fst_nm := null;
26: ben_ext_person.g_bnf_mid_nm := null;
27: ben_ext_person.g_bnf_fl_nm := null;
28: ben_ext_person.g_bnf_suffix := null;
29: ben_ext_person.g_bnf_prefix := null;
30: ben_ext_person.g_bnf_title := null;
31: ben_ext_person.g_bnf_prv_lst_nm := null;
32: ben_ext_person.g_bnf_pre_nm_adjunct := null;
33: ben_ext_person.g_bnf_prmy_cont := null;

Line 30: ben_ext_person.g_bnf_title := null;

26: ben_ext_person.g_bnf_mid_nm := null;
27: ben_ext_person.g_bnf_fl_nm := null;
28: ben_ext_person.g_bnf_suffix := null;
29: ben_ext_person.g_bnf_prefix := null;
30: ben_ext_person.g_bnf_title := null;
31: ben_ext_person.g_bnf_prv_lst_nm := null;
32: ben_ext_person.g_bnf_pre_nm_adjunct := null;
33: ben_ext_person.g_bnf_prmy_cont := null;
34: ben_ext_person.g_bnf_pct_dsgd := null;

Line 31: ben_ext_person.g_bnf_prv_lst_nm := null;

27: ben_ext_person.g_bnf_fl_nm := null;
28: ben_ext_person.g_bnf_suffix := null;
29: ben_ext_person.g_bnf_prefix := null;
30: ben_ext_person.g_bnf_title := null;
31: ben_ext_person.g_bnf_prv_lst_nm := null;
32: ben_ext_person.g_bnf_pre_nm_adjunct := null;
33: ben_ext_person.g_bnf_prmy_cont := null;
34: ben_ext_person.g_bnf_pct_dsgd := null;
35: ben_ext_person.g_bnf_amt_dsgd := null;

Line 32: ben_ext_person.g_bnf_pre_nm_adjunct := null;

28: ben_ext_person.g_bnf_suffix := null;
29: ben_ext_person.g_bnf_prefix := null;
30: ben_ext_person.g_bnf_title := null;
31: ben_ext_person.g_bnf_prv_lst_nm := null;
32: ben_ext_person.g_bnf_pre_nm_adjunct := null;
33: ben_ext_person.g_bnf_prmy_cont := null;
34: ben_ext_person.g_bnf_pct_dsgd := null;
35: ben_ext_person.g_bnf_amt_dsgd := null;
36: ben_ext_person.g_bnf_amt_uom := null;

Line 33: ben_ext_person.g_bnf_prmy_cont := null;

29: ben_ext_person.g_bnf_prefix := null;
30: ben_ext_person.g_bnf_title := null;
31: ben_ext_person.g_bnf_prv_lst_nm := null;
32: ben_ext_person.g_bnf_pre_nm_adjunct := null;
33: ben_ext_person.g_bnf_prmy_cont := null;
34: ben_ext_person.g_bnf_pct_dsgd := null;
35: ben_ext_person.g_bnf_amt_dsgd := null;
36: ben_ext_person.g_bnf_amt_uom := null;
37: ben_ext_person.g_bnf_rlshp := null;

Line 34: ben_ext_person.g_bnf_pct_dsgd := null;

30: ben_ext_person.g_bnf_title := null;
31: ben_ext_person.g_bnf_prv_lst_nm := null;
32: ben_ext_person.g_bnf_pre_nm_adjunct := null;
33: ben_ext_person.g_bnf_prmy_cont := null;
34: ben_ext_person.g_bnf_pct_dsgd := null;
35: ben_ext_person.g_bnf_amt_dsgd := null;
36: ben_ext_person.g_bnf_amt_uom := null;
37: ben_ext_person.g_bnf_rlshp := null;
38: ben_ext_person.g_bnf_contact_seq_num := null;

Line 35: ben_ext_person.g_bnf_amt_dsgd := null;

31: ben_ext_person.g_bnf_prv_lst_nm := null;
32: ben_ext_person.g_bnf_pre_nm_adjunct := null;
33: ben_ext_person.g_bnf_prmy_cont := null;
34: ben_ext_person.g_bnf_pct_dsgd := null;
35: ben_ext_person.g_bnf_amt_dsgd := null;
36: ben_ext_person.g_bnf_amt_uom := null;
37: ben_ext_person.g_bnf_rlshp := null;
38: ben_ext_person.g_bnf_contact_seq_num := null;
39: ben_ext_person.g_bnf_shared_resd_flag := null;

Line 36: ben_ext_person.g_bnf_amt_uom := null;

32: ben_ext_person.g_bnf_pre_nm_adjunct := null;
33: ben_ext_person.g_bnf_prmy_cont := null;
34: ben_ext_person.g_bnf_pct_dsgd := null;
35: ben_ext_person.g_bnf_amt_dsgd := null;
36: ben_ext_person.g_bnf_amt_uom := null;
37: ben_ext_person.g_bnf_rlshp := null;
38: ben_ext_person.g_bnf_contact_seq_num := null;
39: ben_ext_person.g_bnf_shared_resd_flag := null;
40: ben_ext_person.g_bnf_email_address := null;

Line 37: ben_ext_person.g_bnf_rlshp := null;

33: ben_ext_person.g_bnf_prmy_cont := null;
34: ben_ext_person.g_bnf_pct_dsgd := null;
35: ben_ext_person.g_bnf_amt_dsgd := null;
36: ben_ext_person.g_bnf_amt_uom := null;
37: ben_ext_person.g_bnf_rlshp := null;
38: ben_ext_person.g_bnf_contact_seq_num := null;
39: ben_ext_person.g_bnf_shared_resd_flag := null;
40: ben_ext_person.g_bnf_email_address := null;
41: ben_ext_person.g_bnf_known_as := null;

Line 38: ben_ext_person.g_bnf_contact_seq_num := null;

34: ben_ext_person.g_bnf_pct_dsgd := null;
35: ben_ext_person.g_bnf_amt_dsgd := null;
36: ben_ext_person.g_bnf_amt_uom := null;
37: ben_ext_person.g_bnf_rlshp := null;
38: ben_ext_person.g_bnf_contact_seq_num := null;
39: ben_ext_person.g_bnf_shared_resd_flag := null;
40: ben_ext_person.g_bnf_email_address := null;
41: ben_ext_person.g_bnf_known_as := null;
42: ben_ext_person.g_bnf_nationality := null;

Line 39: ben_ext_person.g_bnf_shared_resd_flag := null;

35: ben_ext_person.g_bnf_amt_dsgd := null;
36: ben_ext_person.g_bnf_amt_uom := null;
37: ben_ext_person.g_bnf_rlshp := null;
38: ben_ext_person.g_bnf_contact_seq_num := null;
39: ben_ext_person.g_bnf_shared_resd_flag := null;
40: ben_ext_person.g_bnf_email_address := null;
41: ben_ext_person.g_bnf_known_as := null;
42: ben_ext_person.g_bnf_nationality := null;
43: ben_ext_person.g_bnf_tobacco_usage := null;

Line 40: ben_ext_person.g_bnf_email_address := null;

36: ben_ext_person.g_bnf_amt_uom := null;
37: ben_ext_person.g_bnf_rlshp := null;
38: ben_ext_person.g_bnf_contact_seq_num := null;
39: ben_ext_person.g_bnf_shared_resd_flag := null;
40: ben_ext_person.g_bnf_email_address := null;
41: ben_ext_person.g_bnf_known_as := null;
42: ben_ext_person.g_bnf_nationality := null;
43: ben_ext_person.g_bnf_tobacco_usage := null;
44: ben_ext_person.g_bnf_gender := null;

Line 41: ben_ext_person.g_bnf_known_as := null;

37: ben_ext_person.g_bnf_rlshp := null;
38: ben_ext_person.g_bnf_contact_seq_num := null;
39: ben_ext_person.g_bnf_shared_resd_flag := null;
40: ben_ext_person.g_bnf_email_address := null;
41: ben_ext_person.g_bnf_known_as := null;
42: ben_ext_person.g_bnf_nationality := null;
43: ben_ext_person.g_bnf_tobacco_usage := null;
44: ben_ext_person.g_bnf_gender := null;
45: ben_ext_person.g_bnf_date_of_birth := null;

Line 42: ben_ext_person.g_bnf_nationality := null;

38: ben_ext_person.g_bnf_contact_seq_num := null;
39: ben_ext_person.g_bnf_shared_resd_flag := null;
40: ben_ext_person.g_bnf_email_address := null;
41: ben_ext_person.g_bnf_known_as := null;
42: ben_ext_person.g_bnf_nationality := null;
43: ben_ext_person.g_bnf_tobacco_usage := null;
44: ben_ext_person.g_bnf_gender := null;
45: ben_ext_person.g_bnf_date_of_birth := null;
46: ben_ext_person.g_bnf_marital_status := null;

Line 43: ben_ext_person.g_bnf_tobacco_usage := null;

39: ben_ext_person.g_bnf_shared_resd_flag := null;
40: ben_ext_person.g_bnf_email_address := null;
41: ben_ext_person.g_bnf_known_as := null;
42: ben_ext_person.g_bnf_nationality := null;
43: ben_ext_person.g_bnf_tobacco_usage := null;
44: ben_ext_person.g_bnf_gender := null;
45: ben_ext_person.g_bnf_date_of_birth := null;
46: ben_ext_person.g_bnf_marital_status := null;
47: ben_ext_person.g_bnf_disabled_flag := null;

Line 44: ben_ext_person.g_bnf_gender := null;

40: ben_ext_person.g_bnf_email_address := null;
41: ben_ext_person.g_bnf_known_as := null;
42: ben_ext_person.g_bnf_nationality := null;
43: ben_ext_person.g_bnf_tobacco_usage := null;
44: ben_ext_person.g_bnf_gender := null;
45: ben_ext_person.g_bnf_date_of_birth := null;
46: ben_ext_person.g_bnf_marital_status := null;
47: ben_ext_person.g_bnf_disabled_flag := null;
48: ben_ext_person.g_bnf_student_status := null;

Line 45: ben_ext_person.g_bnf_date_of_birth := null;

41: ben_ext_person.g_bnf_known_as := null;
42: ben_ext_person.g_bnf_nationality := null;
43: ben_ext_person.g_bnf_tobacco_usage := null;
44: ben_ext_person.g_bnf_gender := null;
45: ben_ext_person.g_bnf_date_of_birth := null;
46: ben_ext_person.g_bnf_marital_status := null;
47: ben_ext_person.g_bnf_disabled_flag := null;
48: ben_ext_person.g_bnf_student_status := null;
49: ben_ext_person.g_bnf_date_of_death := null;

Line 46: ben_ext_person.g_bnf_marital_status := null;

42: ben_ext_person.g_bnf_nationality := null;
43: ben_ext_person.g_bnf_tobacco_usage := null;
44: ben_ext_person.g_bnf_gender := null;
45: ben_ext_person.g_bnf_date_of_birth := null;
46: ben_ext_person.g_bnf_marital_status := null;
47: ben_ext_person.g_bnf_disabled_flag := null;
48: ben_ext_person.g_bnf_student_status := null;
49: ben_ext_person.g_bnf_date_of_death := null;
50: ben_ext_person.g_bnf_language := null;

Line 47: ben_ext_person.g_bnf_disabled_flag := null;

43: ben_ext_person.g_bnf_tobacco_usage := null;
44: ben_ext_person.g_bnf_gender := null;
45: ben_ext_person.g_bnf_date_of_birth := null;
46: ben_ext_person.g_bnf_marital_status := null;
47: ben_ext_person.g_bnf_disabled_flag := null;
48: ben_ext_person.g_bnf_student_status := null;
49: ben_ext_person.g_bnf_date_of_death := null;
50: ben_ext_person.g_bnf_language := null;
51: ben_ext_person.g_bnf_prim_address1 := null;

Line 48: ben_ext_person.g_bnf_student_status := null;

44: ben_ext_person.g_bnf_gender := null;
45: ben_ext_person.g_bnf_date_of_birth := null;
46: ben_ext_person.g_bnf_marital_status := null;
47: ben_ext_person.g_bnf_disabled_flag := null;
48: ben_ext_person.g_bnf_student_status := null;
49: ben_ext_person.g_bnf_date_of_death := null;
50: ben_ext_person.g_bnf_language := null;
51: ben_ext_person.g_bnf_prim_address1 := null;
52: ben_ext_person.g_bnf_prim_address2 := null;

Line 49: ben_ext_person.g_bnf_date_of_death := null;

45: ben_ext_person.g_bnf_date_of_birth := null;
46: ben_ext_person.g_bnf_marital_status := null;
47: ben_ext_person.g_bnf_disabled_flag := null;
48: ben_ext_person.g_bnf_student_status := null;
49: ben_ext_person.g_bnf_date_of_death := null;
50: ben_ext_person.g_bnf_language := null;
51: ben_ext_person.g_bnf_prim_address1 := null;
52: ben_ext_person.g_bnf_prim_address2 := null;
53: ben_ext_person.g_bnf_prim_address3 := null;

Line 50: ben_ext_person.g_bnf_language := null;

46: ben_ext_person.g_bnf_marital_status := null;
47: ben_ext_person.g_bnf_disabled_flag := null;
48: ben_ext_person.g_bnf_student_status := null;
49: ben_ext_person.g_bnf_date_of_death := null;
50: ben_ext_person.g_bnf_language := null;
51: ben_ext_person.g_bnf_prim_address1 := null;
52: ben_ext_person.g_bnf_prim_address2 := null;
53: ben_ext_person.g_bnf_prim_address3 := null;
54: ben_ext_person.g_bnf_prim_city := null;

Line 51: ben_ext_person.g_bnf_prim_address1 := null;

47: ben_ext_person.g_bnf_disabled_flag := null;
48: ben_ext_person.g_bnf_student_status := null;
49: ben_ext_person.g_bnf_date_of_death := null;
50: ben_ext_person.g_bnf_language := null;
51: ben_ext_person.g_bnf_prim_address1 := null;
52: ben_ext_person.g_bnf_prim_address2 := null;
53: ben_ext_person.g_bnf_prim_address3 := null;
54: ben_ext_person.g_bnf_prim_city := null;
55: ben_ext_person.g_bnf_prim_state := null;

Line 52: ben_ext_person.g_bnf_prim_address2 := null;

48: ben_ext_person.g_bnf_student_status := null;
49: ben_ext_person.g_bnf_date_of_death := null;
50: ben_ext_person.g_bnf_language := null;
51: ben_ext_person.g_bnf_prim_address1 := null;
52: ben_ext_person.g_bnf_prim_address2 := null;
53: ben_ext_person.g_bnf_prim_address3 := null;
54: ben_ext_person.g_bnf_prim_city := null;
55: ben_ext_person.g_bnf_prim_state := null;
56: ben_ext_person.g_bnf_prim_postal_code := null;

Line 53: ben_ext_person.g_bnf_prim_address3 := null;

49: ben_ext_person.g_bnf_date_of_death := null;
50: ben_ext_person.g_bnf_language := null;
51: ben_ext_person.g_bnf_prim_address1 := null;
52: ben_ext_person.g_bnf_prim_address2 := null;
53: ben_ext_person.g_bnf_prim_address3 := null;
54: ben_ext_person.g_bnf_prim_city := null;
55: ben_ext_person.g_bnf_prim_state := null;
56: ben_ext_person.g_bnf_prim_postal_code := null;
57: ben_ext_person.g_bnf_prim_country := null;

Line 54: ben_ext_person.g_bnf_prim_city := null;

50: ben_ext_person.g_bnf_language := null;
51: ben_ext_person.g_bnf_prim_address1 := null;
52: ben_ext_person.g_bnf_prim_address2 := null;
53: ben_ext_person.g_bnf_prim_address3 := null;
54: ben_ext_person.g_bnf_prim_city := null;
55: ben_ext_person.g_bnf_prim_state := null;
56: ben_ext_person.g_bnf_prim_postal_code := null;
57: ben_ext_person.g_bnf_prim_country := null;
58: ben_ext_person.g_bnf_prim_effect_date := null;

Line 55: ben_ext_person.g_bnf_prim_state := null;

51: ben_ext_person.g_bnf_prim_address1 := null;
52: ben_ext_person.g_bnf_prim_address2 := null;
53: ben_ext_person.g_bnf_prim_address3 := null;
54: ben_ext_person.g_bnf_prim_city := null;
55: ben_ext_person.g_bnf_prim_state := null;
56: ben_ext_person.g_bnf_prim_postal_code := null;
57: ben_ext_person.g_bnf_prim_country := null;
58: ben_ext_person.g_bnf_prim_effect_date := null;
59: ben_ext_person.g_bnf_prim_region := null;

Line 56: ben_ext_person.g_bnf_prim_postal_code := null;

52: ben_ext_person.g_bnf_prim_address2 := null;
53: ben_ext_person.g_bnf_prim_address3 := null;
54: ben_ext_person.g_bnf_prim_city := null;
55: ben_ext_person.g_bnf_prim_state := null;
56: ben_ext_person.g_bnf_prim_postal_code := null;
57: ben_ext_person.g_bnf_prim_country := null;
58: ben_ext_person.g_bnf_prim_effect_date := null;
59: ben_ext_person.g_bnf_prim_region := null;
60: ben_ext_person.g_bnf_home_phone := null;

Line 57: ben_ext_person.g_bnf_prim_country := null;

53: ben_ext_person.g_bnf_prim_address3 := null;
54: ben_ext_person.g_bnf_prim_city := null;
55: ben_ext_person.g_bnf_prim_state := null;
56: ben_ext_person.g_bnf_prim_postal_code := null;
57: ben_ext_person.g_bnf_prim_country := null;
58: ben_ext_person.g_bnf_prim_effect_date := null;
59: ben_ext_person.g_bnf_prim_region := null;
60: ben_ext_person.g_bnf_home_phone := null;
61: ben_ext_person.g_bnf_work_phone := null;

Line 58: ben_ext_person.g_bnf_prim_effect_date := null;

54: ben_ext_person.g_bnf_prim_city := null;
55: ben_ext_person.g_bnf_prim_state := null;
56: ben_ext_person.g_bnf_prim_postal_code := null;
57: ben_ext_person.g_bnf_prim_country := null;
58: ben_ext_person.g_bnf_prim_effect_date := null;
59: ben_ext_person.g_bnf_prim_region := null;
60: ben_ext_person.g_bnf_home_phone := null;
61: ben_ext_person.g_bnf_work_phone := null;
62: ben_ext_person.g_bnf_fax := null;

Line 59: ben_ext_person.g_bnf_prim_region := null;

55: ben_ext_person.g_bnf_prim_state := null;
56: ben_ext_person.g_bnf_prim_postal_code := null;
57: ben_ext_person.g_bnf_prim_country := null;
58: ben_ext_person.g_bnf_prim_effect_date := null;
59: ben_ext_person.g_bnf_prim_region := null;
60: ben_ext_person.g_bnf_home_phone := null;
61: ben_ext_person.g_bnf_work_phone := null;
62: ben_ext_person.g_bnf_fax := null;
63: ben_ext_person.g_bnf_mobile := null;

Line 60: ben_ext_person.g_bnf_home_phone := null;

56: ben_ext_person.g_bnf_prim_postal_code := null;
57: ben_ext_person.g_bnf_prim_country := null;
58: ben_ext_person.g_bnf_prim_effect_date := null;
59: ben_ext_person.g_bnf_prim_region := null;
60: ben_ext_person.g_bnf_home_phone := null;
61: ben_ext_person.g_bnf_work_phone := null;
62: ben_ext_person.g_bnf_fax := null;
63: ben_ext_person.g_bnf_mobile := null;
64:

Line 61: ben_ext_person.g_bnf_work_phone := null;

57: ben_ext_person.g_bnf_prim_country := null;
58: ben_ext_person.g_bnf_prim_effect_date := null;
59: ben_ext_person.g_bnf_prim_region := null;
60: ben_ext_person.g_bnf_home_phone := null;
61: ben_ext_person.g_bnf_work_phone := null;
62: ben_ext_person.g_bnf_fax := null;
63: ben_ext_person.g_bnf_mobile := null;
64:
65: --

Line 62: ben_ext_person.g_bnf_fax := null;

58: ben_ext_person.g_bnf_prim_effect_date := null;
59: ben_ext_person.g_bnf_prim_region := null;
60: ben_ext_person.g_bnf_home_phone := null;
61: ben_ext_person.g_bnf_work_phone := null;
62: ben_ext_person.g_bnf_fax := null;
63: ben_ext_person.g_bnf_mobile := null;
64:
65: --
66: hr_utility.set_location('Exiting'||l_proc, 15);

Line 63: ben_ext_person.g_bnf_mobile := null;

59: ben_ext_person.g_bnf_prim_region := null;
60: ben_ext_person.g_bnf_home_phone := null;
61: ben_ext_person.g_bnf_work_phone := null;
62: ben_ext_person.g_bnf_fax := null;
63: ben_ext_person.g_bnf_mobile := null;
64:
65: --
66: hr_utility.set_location('Exiting'||l_proc, 15);
67: --

Line 270: ben_ext_person.g_bnf_ssn := bnfcry.bnf_ssn;

266: --
267: FOR bnfcry IN c_bnfcry(p_prtt_enrt_rslt_id) LOOP
268: -- assign beneficiary info to global variables
269: --
270: ben_ext_person.g_bnf_ssn := bnfcry.bnf_ssn;
271: ben_ext_person.g_bnf_lst_nm := bnfcry.bnf_lst_nm;
272: ben_ext_person.g_bnf_fst_nm := bnfcry.bnf_fst_nm;
273: ben_ext_person.g_bnf_mid_nm := bnfcry.bnf_mid_nm;
274: ben_ext_person.g_bnf_fl_nm := bnfcry.bnf_fl_nm;

Line 271: ben_ext_person.g_bnf_lst_nm := bnfcry.bnf_lst_nm;

267: FOR bnfcry IN c_bnfcry(p_prtt_enrt_rslt_id) LOOP
268: -- assign beneficiary info to global variables
269: --
270: ben_ext_person.g_bnf_ssn := bnfcry.bnf_ssn;
271: ben_ext_person.g_bnf_lst_nm := bnfcry.bnf_lst_nm;
272: ben_ext_person.g_bnf_fst_nm := bnfcry.bnf_fst_nm;
273: ben_ext_person.g_bnf_mid_nm := bnfcry.bnf_mid_nm;
274: ben_ext_person.g_bnf_fl_nm := bnfcry.bnf_fl_nm;
275: ben_ext_person.g_bnf_suffix := bnfcry.bnf_suffix;

Line 272: ben_ext_person.g_bnf_fst_nm := bnfcry.bnf_fst_nm;

268: -- assign beneficiary info to global variables
269: --
270: ben_ext_person.g_bnf_ssn := bnfcry.bnf_ssn;
271: ben_ext_person.g_bnf_lst_nm := bnfcry.bnf_lst_nm;
272: ben_ext_person.g_bnf_fst_nm := bnfcry.bnf_fst_nm;
273: ben_ext_person.g_bnf_mid_nm := bnfcry.bnf_mid_nm;
274: ben_ext_person.g_bnf_fl_nm := bnfcry.bnf_fl_nm;
275: ben_ext_person.g_bnf_suffix := bnfcry.bnf_suffix;
276: ben_ext_person.g_bnf_prefix := bnfcry.bnf_prefix;

Line 273: ben_ext_person.g_bnf_mid_nm := bnfcry.bnf_mid_nm;

269: --
270: ben_ext_person.g_bnf_ssn := bnfcry.bnf_ssn;
271: ben_ext_person.g_bnf_lst_nm := bnfcry.bnf_lst_nm;
272: ben_ext_person.g_bnf_fst_nm := bnfcry.bnf_fst_nm;
273: ben_ext_person.g_bnf_mid_nm := bnfcry.bnf_mid_nm;
274: ben_ext_person.g_bnf_fl_nm := bnfcry.bnf_fl_nm;
275: ben_ext_person.g_bnf_suffix := bnfcry.bnf_suffix;
276: ben_ext_person.g_bnf_prefix := bnfcry.bnf_prefix;
277: ben_ext_person.g_bnf_title := bnfcry.bnf_title;

Line 274: ben_ext_person.g_bnf_fl_nm := bnfcry.bnf_fl_nm;

270: ben_ext_person.g_bnf_ssn := bnfcry.bnf_ssn;
271: ben_ext_person.g_bnf_lst_nm := bnfcry.bnf_lst_nm;
272: ben_ext_person.g_bnf_fst_nm := bnfcry.bnf_fst_nm;
273: ben_ext_person.g_bnf_mid_nm := bnfcry.bnf_mid_nm;
274: ben_ext_person.g_bnf_fl_nm := bnfcry.bnf_fl_nm;
275: ben_ext_person.g_bnf_suffix := bnfcry.bnf_suffix;
276: ben_ext_person.g_bnf_prefix := bnfcry.bnf_prefix;
277: ben_ext_person.g_bnf_title := bnfcry.bnf_title;
278: ben_ext_person.g_bnf_prv_lst_nm := bnfcry.bnf_prv_lst_nm;

Line 275: ben_ext_person.g_bnf_suffix := bnfcry.bnf_suffix;

271: ben_ext_person.g_bnf_lst_nm := bnfcry.bnf_lst_nm;
272: ben_ext_person.g_bnf_fst_nm := bnfcry.bnf_fst_nm;
273: ben_ext_person.g_bnf_mid_nm := bnfcry.bnf_mid_nm;
274: ben_ext_person.g_bnf_fl_nm := bnfcry.bnf_fl_nm;
275: ben_ext_person.g_bnf_suffix := bnfcry.bnf_suffix;
276: ben_ext_person.g_bnf_prefix := bnfcry.bnf_prefix;
277: ben_ext_person.g_bnf_title := bnfcry.bnf_title;
278: ben_ext_person.g_bnf_prv_lst_nm := bnfcry.bnf_prv_lst_nm;
279: ben_ext_person.g_bnf_pre_nm_adjunct := bnfcry.bnf_pre_nm_adjunct;

Line 276: ben_ext_person.g_bnf_prefix := bnfcry.bnf_prefix;

272: ben_ext_person.g_bnf_fst_nm := bnfcry.bnf_fst_nm;
273: ben_ext_person.g_bnf_mid_nm := bnfcry.bnf_mid_nm;
274: ben_ext_person.g_bnf_fl_nm := bnfcry.bnf_fl_nm;
275: ben_ext_person.g_bnf_suffix := bnfcry.bnf_suffix;
276: ben_ext_person.g_bnf_prefix := bnfcry.bnf_prefix;
277: ben_ext_person.g_bnf_title := bnfcry.bnf_title;
278: ben_ext_person.g_bnf_prv_lst_nm := bnfcry.bnf_prv_lst_nm;
279: ben_ext_person.g_bnf_pre_nm_adjunct := bnfcry.bnf_pre_nm_adjunct;
280: ben_ext_person.g_bnf_email_address := bnfcry.bnf_email;

Line 277: ben_ext_person.g_bnf_title := bnfcry.bnf_title;

273: ben_ext_person.g_bnf_mid_nm := bnfcry.bnf_mid_nm;
274: ben_ext_person.g_bnf_fl_nm := bnfcry.bnf_fl_nm;
275: ben_ext_person.g_bnf_suffix := bnfcry.bnf_suffix;
276: ben_ext_person.g_bnf_prefix := bnfcry.bnf_prefix;
277: ben_ext_person.g_bnf_title := bnfcry.bnf_title;
278: ben_ext_person.g_bnf_prv_lst_nm := bnfcry.bnf_prv_lst_nm;
279: ben_ext_person.g_bnf_pre_nm_adjunct := bnfcry.bnf_pre_nm_adjunct;
280: ben_ext_person.g_bnf_email_address := bnfcry.bnf_email;
281: ben_ext_person.g_bnf_known_as := bnfcry.bnf_known_as;

Line 278: ben_ext_person.g_bnf_prv_lst_nm := bnfcry.bnf_prv_lst_nm;

274: ben_ext_person.g_bnf_fl_nm := bnfcry.bnf_fl_nm;
275: ben_ext_person.g_bnf_suffix := bnfcry.bnf_suffix;
276: ben_ext_person.g_bnf_prefix := bnfcry.bnf_prefix;
277: ben_ext_person.g_bnf_title := bnfcry.bnf_title;
278: ben_ext_person.g_bnf_prv_lst_nm := bnfcry.bnf_prv_lst_nm;
279: ben_ext_person.g_bnf_pre_nm_adjunct := bnfcry.bnf_pre_nm_adjunct;
280: ben_ext_person.g_bnf_email_address := bnfcry.bnf_email;
281: ben_ext_person.g_bnf_known_as := bnfcry.bnf_known_as;
282: ben_ext_person.g_bnf_nationality := bnfcry.bnf_nationality;

Line 279: ben_ext_person.g_bnf_pre_nm_adjunct := bnfcry.bnf_pre_nm_adjunct;

275: ben_ext_person.g_bnf_suffix := bnfcry.bnf_suffix;
276: ben_ext_person.g_bnf_prefix := bnfcry.bnf_prefix;
277: ben_ext_person.g_bnf_title := bnfcry.bnf_title;
278: ben_ext_person.g_bnf_prv_lst_nm := bnfcry.bnf_prv_lst_nm;
279: ben_ext_person.g_bnf_pre_nm_adjunct := bnfcry.bnf_pre_nm_adjunct;
280: ben_ext_person.g_bnf_email_address := bnfcry.bnf_email;
281: ben_ext_person.g_bnf_known_as := bnfcry.bnf_known_as;
282: ben_ext_person.g_bnf_nationality := bnfcry.bnf_nationality;
283: ben_ext_person.g_bnf_tobacco_usage := bnfcry.bnf_tobacco_usage;

Line 280: ben_ext_person.g_bnf_email_address := bnfcry.bnf_email;

276: ben_ext_person.g_bnf_prefix := bnfcry.bnf_prefix;
277: ben_ext_person.g_bnf_title := bnfcry.bnf_title;
278: ben_ext_person.g_bnf_prv_lst_nm := bnfcry.bnf_prv_lst_nm;
279: ben_ext_person.g_bnf_pre_nm_adjunct := bnfcry.bnf_pre_nm_adjunct;
280: ben_ext_person.g_bnf_email_address := bnfcry.bnf_email;
281: ben_ext_person.g_bnf_known_as := bnfcry.bnf_known_as;
282: ben_ext_person.g_bnf_nationality := bnfcry.bnf_nationality;
283: ben_ext_person.g_bnf_tobacco_usage := bnfcry.bnf_tobacco_usage;
284: ben_ext_person.g_bnf_gender := bnfcry.bnf_gender;

Line 281: ben_ext_person.g_bnf_known_as := bnfcry.bnf_known_as;

277: ben_ext_person.g_bnf_title := bnfcry.bnf_title;
278: ben_ext_person.g_bnf_prv_lst_nm := bnfcry.bnf_prv_lst_nm;
279: ben_ext_person.g_bnf_pre_nm_adjunct := bnfcry.bnf_pre_nm_adjunct;
280: ben_ext_person.g_bnf_email_address := bnfcry.bnf_email;
281: ben_ext_person.g_bnf_known_as := bnfcry.bnf_known_as;
282: ben_ext_person.g_bnf_nationality := bnfcry.bnf_nationality;
283: ben_ext_person.g_bnf_tobacco_usage := bnfcry.bnf_tobacco_usage;
284: ben_ext_person.g_bnf_gender := bnfcry.bnf_gender;
285: ben_ext_person.g_bnf_date_of_birth := bnfcry.bnf_dob;

Line 282: ben_ext_person.g_bnf_nationality := bnfcry.bnf_nationality;

278: ben_ext_person.g_bnf_prv_lst_nm := bnfcry.bnf_prv_lst_nm;
279: ben_ext_person.g_bnf_pre_nm_adjunct := bnfcry.bnf_pre_nm_adjunct;
280: ben_ext_person.g_bnf_email_address := bnfcry.bnf_email;
281: ben_ext_person.g_bnf_known_as := bnfcry.bnf_known_as;
282: ben_ext_person.g_bnf_nationality := bnfcry.bnf_nationality;
283: ben_ext_person.g_bnf_tobacco_usage := bnfcry.bnf_tobacco_usage;
284: ben_ext_person.g_bnf_gender := bnfcry.bnf_gender;
285: ben_ext_person.g_bnf_date_of_birth := bnfcry.bnf_dob;
286: ben_ext_person.g_bnf_marital_status := bnfcry.bnf_marital_status;

Line 283: ben_ext_person.g_bnf_tobacco_usage := bnfcry.bnf_tobacco_usage;

279: ben_ext_person.g_bnf_pre_nm_adjunct := bnfcry.bnf_pre_nm_adjunct;
280: ben_ext_person.g_bnf_email_address := bnfcry.bnf_email;
281: ben_ext_person.g_bnf_known_as := bnfcry.bnf_known_as;
282: ben_ext_person.g_bnf_nationality := bnfcry.bnf_nationality;
283: ben_ext_person.g_bnf_tobacco_usage := bnfcry.bnf_tobacco_usage;
284: ben_ext_person.g_bnf_gender := bnfcry.bnf_gender;
285: ben_ext_person.g_bnf_date_of_birth := bnfcry.bnf_dob;
286: ben_ext_person.g_bnf_marital_status := bnfcry.bnf_marital_status;
287: ben_ext_person.g_bnf_disabled_flag := bnfcry.bnf_disabled_flag;

Line 284: ben_ext_person.g_bnf_gender := bnfcry.bnf_gender;

280: ben_ext_person.g_bnf_email_address := bnfcry.bnf_email;
281: ben_ext_person.g_bnf_known_as := bnfcry.bnf_known_as;
282: ben_ext_person.g_bnf_nationality := bnfcry.bnf_nationality;
283: ben_ext_person.g_bnf_tobacco_usage := bnfcry.bnf_tobacco_usage;
284: ben_ext_person.g_bnf_gender := bnfcry.bnf_gender;
285: ben_ext_person.g_bnf_date_of_birth := bnfcry.bnf_dob;
286: ben_ext_person.g_bnf_marital_status := bnfcry.bnf_marital_status;
287: ben_ext_person.g_bnf_disabled_flag := bnfcry.bnf_disabled_flag;
288: ben_ext_person.g_bnf_student_status := bnfcry.bnf_student_status;

Line 285: ben_ext_person.g_bnf_date_of_birth := bnfcry.bnf_dob;

281: ben_ext_person.g_bnf_known_as := bnfcry.bnf_known_as;
282: ben_ext_person.g_bnf_nationality := bnfcry.bnf_nationality;
283: ben_ext_person.g_bnf_tobacco_usage := bnfcry.bnf_tobacco_usage;
284: ben_ext_person.g_bnf_gender := bnfcry.bnf_gender;
285: ben_ext_person.g_bnf_date_of_birth := bnfcry.bnf_dob;
286: ben_ext_person.g_bnf_marital_status := bnfcry.bnf_marital_status;
287: ben_ext_person.g_bnf_disabled_flag := bnfcry.bnf_disabled_flag;
288: ben_ext_person.g_bnf_student_status := bnfcry.bnf_student_status;
289: ben_ext_person.g_bnf_date_of_death := bnfcry.bnf_dod;

Line 286: ben_ext_person.g_bnf_marital_status := bnfcry.bnf_marital_status;

282: ben_ext_person.g_bnf_nationality := bnfcry.bnf_nationality;
283: ben_ext_person.g_bnf_tobacco_usage := bnfcry.bnf_tobacco_usage;
284: ben_ext_person.g_bnf_gender := bnfcry.bnf_gender;
285: ben_ext_person.g_bnf_date_of_birth := bnfcry.bnf_dob;
286: ben_ext_person.g_bnf_marital_status := bnfcry.bnf_marital_status;
287: ben_ext_person.g_bnf_disabled_flag := bnfcry.bnf_disabled_flag;
288: ben_ext_person.g_bnf_student_status := bnfcry.bnf_student_status;
289: ben_ext_person.g_bnf_date_of_death := bnfcry.bnf_dod;
290: ben_ext_person.g_bnf_language := bnfcry.bnf_language;

Line 287: ben_ext_person.g_bnf_disabled_flag := bnfcry.bnf_disabled_flag;

283: ben_ext_person.g_bnf_tobacco_usage := bnfcry.bnf_tobacco_usage;
284: ben_ext_person.g_bnf_gender := bnfcry.bnf_gender;
285: ben_ext_person.g_bnf_date_of_birth := bnfcry.bnf_dob;
286: ben_ext_person.g_bnf_marital_status := bnfcry.bnf_marital_status;
287: ben_ext_person.g_bnf_disabled_flag := bnfcry.bnf_disabled_flag;
288: ben_ext_person.g_bnf_student_status := bnfcry.bnf_student_status;
289: ben_ext_person.g_bnf_date_of_death := bnfcry.bnf_dod;
290: ben_ext_person.g_bnf_language := bnfcry.bnf_language;
291: ben_ext_person.g_bnf_prmy_cont := bnfcry.bnf_prmy_cont;

Line 288: ben_ext_person.g_bnf_student_status := bnfcry.bnf_student_status;

284: ben_ext_person.g_bnf_gender := bnfcry.bnf_gender;
285: ben_ext_person.g_bnf_date_of_birth := bnfcry.bnf_dob;
286: ben_ext_person.g_bnf_marital_status := bnfcry.bnf_marital_status;
287: ben_ext_person.g_bnf_disabled_flag := bnfcry.bnf_disabled_flag;
288: ben_ext_person.g_bnf_student_status := bnfcry.bnf_student_status;
289: ben_ext_person.g_bnf_date_of_death := bnfcry.bnf_dod;
290: ben_ext_person.g_bnf_language := bnfcry.bnf_language;
291: ben_ext_person.g_bnf_prmy_cont := bnfcry.bnf_prmy_cont;
292: ben_ext_person.g_bnf_pct_dsgd := bnfcry.bnf_pct_dsgd;

Line 289: ben_ext_person.g_bnf_date_of_death := bnfcry.bnf_dod;

285: ben_ext_person.g_bnf_date_of_birth := bnfcry.bnf_dob;
286: ben_ext_person.g_bnf_marital_status := bnfcry.bnf_marital_status;
287: ben_ext_person.g_bnf_disabled_flag := bnfcry.bnf_disabled_flag;
288: ben_ext_person.g_bnf_student_status := bnfcry.bnf_student_status;
289: ben_ext_person.g_bnf_date_of_death := bnfcry.bnf_dod;
290: ben_ext_person.g_bnf_language := bnfcry.bnf_language;
291: ben_ext_person.g_bnf_prmy_cont := bnfcry.bnf_prmy_cont;
292: ben_ext_person.g_bnf_pct_dsgd := bnfcry.bnf_pct_dsgd;
293: ben_ext_person.g_bnf_amt_dsgd := bnfcry.bnf_amt_dsgd;

Line 290: ben_ext_person.g_bnf_language := bnfcry.bnf_language;

286: ben_ext_person.g_bnf_marital_status := bnfcry.bnf_marital_status;
287: ben_ext_person.g_bnf_disabled_flag := bnfcry.bnf_disabled_flag;
288: ben_ext_person.g_bnf_student_status := bnfcry.bnf_student_status;
289: ben_ext_person.g_bnf_date_of_death := bnfcry.bnf_dod;
290: ben_ext_person.g_bnf_language := bnfcry.bnf_language;
291: ben_ext_person.g_bnf_prmy_cont := bnfcry.bnf_prmy_cont;
292: ben_ext_person.g_bnf_pct_dsgd := bnfcry.bnf_pct_dsgd;
293: ben_ext_person.g_bnf_amt_dsgd := bnfcry.bnf_amt_dsgd;
294: ben_ext_person.g_bnf_amt_uom := bnfcry.bnf_amt_uom;

Line 291: ben_ext_person.g_bnf_prmy_cont := bnfcry.bnf_prmy_cont;

287: ben_ext_person.g_bnf_disabled_flag := bnfcry.bnf_disabled_flag;
288: ben_ext_person.g_bnf_student_status := bnfcry.bnf_student_status;
289: ben_ext_person.g_bnf_date_of_death := bnfcry.bnf_dod;
290: ben_ext_person.g_bnf_language := bnfcry.bnf_language;
291: ben_ext_person.g_bnf_prmy_cont := bnfcry.bnf_prmy_cont;
292: ben_ext_person.g_bnf_pct_dsgd := bnfcry.bnf_pct_dsgd;
293: ben_ext_person.g_bnf_amt_dsgd := bnfcry.bnf_amt_dsgd;
294: ben_ext_person.g_bnf_amt_uom := bnfcry.bnf_amt_uom;
295: ben_ext_person.g_bnf_rlshp := bnfcry.bnf_rlshp;

Line 292: ben_ext_person.g_bnf_pct_dsgd := bnfcry.bnf_pct_dsgd;

288: ben_ext_person.g_bnf_student_status := bnfcry.bnf_student_status;
289: ben_ext_person.g_bnf_date_of_death := bnfcry.bnf_dod;
290: ben_ext_person.g_bnf_language := bnfcry.bnf_language;
291: ben_ext_person.g_bnf_prmy_cont := bnfcry.bnf_prmy_cont;
292: ben_ext_person.g_bnf_pct_dsgd := bnfcry.bnf_pct_dsgd;
293: ben_ext_person.g_bnf_amt_dsgd := bnfcry.bnf_amt_dsgd;
294: ben_ext_person.g_bnf_amt_uom := bnfcry.bnf_amt_uom;
295: ben_ext_person.g_bnf_rlshp := bnfcry.bnf_rlshp;
296: ben_ext_person.g_bnf_contact_seq_num := bnfcry.bnf_contact_seq_num;

Line 293: ben_ext_person.g_bnf_amt_dsgd := bnfcry.bnf_amt_dsgd;

289: ben_ext_person.g_bnf_date_of_death := bnfcry.bnf_dod;
290: ben_ext_person.g_bnf_language := bnfcry.bnf_language;
291: ben_ext_person.g_bnf_prmy_cont := bnfcry.bnf_prmy_cont;
292: ben_ext_person.g_bnf_pct_dsgd := bnfcry.bnf_pct_dsgd;
293: ben_ext_person.g_bnf_amt_dsgd := bnfcry.bnf_amt_dsgd;
294: ben_ext_person.g_bnf_amt_uom := bnfcry.bnf_amt_uom;
295: ben_ext_person.g_bnf_rlshp := bnfcry.bnf_rlshp;
296: ben_ext_person.g_bnf_contact_seq_num := bnfcry.bnf_contact_seq_num;
297: ben_ext_person.g_bnf_shared_resd_flag := bnfcry.rltd_per_rsds_w_dsgntr_flag;

Line 294: ben_ext_person.g_bnf_amt_uom := bnfcry.bnf_amt_uom;

290: ben_ext_person.g_bnf_language := bnfcry.bnf_language;
291: ben_ext_person.g_bnf_prmy_cont := bnfcry.bnf_prmy_cont;
292: ben_ext_person.g_bnf_pct_dsgd := bnfcry.bnf_pct_dsgd;
293: ben_ext_person.g_bnf_amt_dsgd := bnfcry.bnf_amt_dsgd;
294: ben_ext_person.g_bnf_amt_uom := bnfcry.bnf_amt_uom;
295: ben_ext_person.g_bnf_rlshp := bnfcry.bnf_rlshp;
296: ben_ext_person.g_bnf_contact_seq_num := bnfcry.bnf_contact_seq_num;
297: ben_ext_person.g_bnf_shared_resd_flag := bnfcry.rltd_per_rsds_w_dsgntr_flag;
298: ben_ext_person.g_bnf_pl_bnf_id := bnfcry.pl_bnf_id;

Line 295: ben_ext_person.g_bnf_rlshp := bnfcry.bnf_rlshp;

291: ben_ext_person.g_bnf_prmy_cont := bnfcry.bnf_prmy_cont;
292: ben_ext_person.g_bnf_pct_dsgd := bnfcry.bnf_pct_dsgd;
293: ben_ext_person.g_bnf_amt_dsgd := bnfcry.bnf_amt_dsgd;
294: ben_ext_person.g_bnf_amt_uom := bnfcry.bnf_amt_uom;
295: ben_ext_person.g_bnf_rlshp := bnfcry.bnf_rlshp;
296: ben_ext_person.g_bnf_contact_seq_num := bnfcry.bnf_contact_seq_num;
297: ben_ext_person.g_bnf_shared_resd_flag := bnfcry.rltd_per_rsds_w_dsgntr_flag;
298: ben_ext_person.g_bnf_pl_bnf_id := bnfcry.pl_bnf_id;
299:

Line 296: ben_ext_person.g_bnf_contact_seq_num := bnfcry.bnf_contact_seq_num;

292: ben_ext_person.g_bnf_pct_dsgd := bnfcry.bnf_pct_dsgd;
293: ben_ext_person.g_bnf_amt_dsgd := bnfcry.bnf_amt_dsgd;
294: ben_ext_person.g_bnf_amt_uom := bnfcry.bnf_amt_uom;
295: ben_ext_person.g_bnf_rlshp := bnfcry.bnf_rlshp;
296: ben_ext_person.g_bnf_contact_seq_num := bnfcry.bnf_contact_seq_num;
297: ben_ext_person.g_bnf_shared_resd_flag := bnfcry.rltd_per_rsds_w_dsgntr_flag;
298: ben_ext_person.g_bnf_pl_bnf_id := bnfcry.pl_bnf_id;
299:
300: --

Line 297: ben_ext_person.g_bnf_shared_resd_flag := bnfcry.rltd_per_rsds_w_dsgntr_flag;

293: ben_ext_person.g_bnf_amt_dsgd := bnfcry.bnf_amt_dsgd;
294: ben_ext_person.g_bnf_amt_uom := bnfcry.bnf_amt_uom;
295: ben_ext_person.g_bnf_rlshp := bnfcry.bnf_rlshp;
296: ben_ext_person.g_bnf_contact_seq_num := bnfcry.bnf_contact_seq_num;
297: ben_ext_person.g_bnf_shared_resd_flag := bnfcry.rltd_per_rsds_w_dsgntr_flag;
298: ben_ext_person.g_bnf_pl_bnf_id := bnfcry.pl_bnf_id;
299:
300: --
301: hr_utility.set_location('Beneficiary id ' || bnfcry.bnf_person_id,178);

Line 298: ben_ext_person.g_bnf_pl_bnf_id := bnfcry.pl_bnf_id;

294: ben_ext_person.g_bnf_amt_uom := bnfcry.bnf_amt_uom;
295: ben_ext_person.g_bnf_rlshp := bnfcry.bnf_rlshp;
296: ben_ext_person.g_bnf_contact_seq_num := bnfcry.bnf_contact_seq_num;
297: ben_ext_person.g_bnf_shared_resd_flag := bnfcry.rltd_per_rsds_w_dsgntr_flag;
298: ben_ext_person.g_bnf_pl_bnf_id := bnfcry.pl_bnf_id;
299:
300: --
301: hr_utility.set_location('Beneficiary id ' || bnfcry.bnf_person_id,178);
302: --

Line 307: fetch prim_address_c into ben_ext_person.g_bnf_prim_address1

303: -- retrieve beneficiary address if required
304: l_relatated_true := 'N' ;
305: if ben_extract.g_ba_csr = 'Y' then
306: open prim_address_c(bnfcry.bnf_person_id);
307: fetch prim_address_c into ben_ext_person.g_bnf_prim_address1
308: , ben_ext_person.g_bnf_prim_address2
309: , ben_ext_person.g_bnf_prim_address3
310: , ben_ext_person.g_bnf_prim_city
311: , ben_ext_person.g_bnf_prim_state

Line 308: , ben_ext_person.g_bnf_prim_address2

304: l_relatated_true := 'N' ;
305: if ben_extract.g_ba_csr = 'Y' then
306: open prim_address_c(bnfcry.bnf_person_id);
307: fetch prim_address_c into ben_ext_person.g_bnf_prim_address1
308: , ben_ext_person.g_bnf_prim_address2
309: , ben_ext_person.g_bnf_prim_address3
310: , ben_ext_person.g_bnf_prim_city
311: , ben_ext_person.g_bnf_prim_state
312: , ben_ext_person.g_bnf_prim_postal_code

Line 309: , ben_ext_person.g_bnf_prim_address3

305: if ben_extract.g_ba_csr = 'Y' then
306: open prim_address_c(bnfcry.bnf_person_id);
307: fetch prim_address_c into ben_ext_person.g_bnf_prim_address1
308: , ben_ext_person.g_bnf_prim_address2
309: , ben_ext_person.g_bnf_prim_address3
310: , ben_ext_person.g_bnf_prim_city
311: , ben_ext_person.g_bnf_prim_state
312: , ben_ext_person.g_bnf_prim_postal_code
313: , ben_ext_person.g_bnf_prim_country

Line 310: , ben_ext_person.g_bnf_prim_city

306: open prim_address_c(bnfcry.bnf_person_id);
307: fetch prim_address_c into ben_ext_person.g_bnf_prim_address1
308: , ben_ext_person.g_bnf_prim_address2
309: , ben_ext_person.g_bnf_prim_address3
310: , ben_ext_person.g_bnf_prim_city
311: , ben_ext_person.g_bnf_prim_state
312: , ben_ext_person.g_bnf_prim_postal_code
313: , ben_ext_person.g_bnf_prim_country
314: , ben_ext_person.g_bnf_prim_effect_date

Line 311: , ben_ext_person.g_bnf_prim_state

307: fetch prim_address_c into ben_ext_person.g_bnf_prim_address1
308: , ben_ext_person.g_bnf_prim_address2
309: , ben_ext_person.g_bnf_prim_address3
310: , ben_ext_person.g_bnf_prim_city
311: , ben_ext_person.g_bnf_prim_state
312: , ben_ext_person.g_bnf_prim_postal_code
313: , ben_ext_person.g_bnf_prim_country
314: , ben_ext_person.g_bnf_prim_effect_date
315: , ben_ext_person.g_bnf_prim_region;

Line 312: , ben_ext_person.g_bnf_prim_postal_code

308: , ben_ext_person.g_bnf_prim_address2
309: , ben_ext_person.g_bnf_prim_address3
310: , ben_ext_person.g_bnf_prim_city
311: , ben_ext_person.g_bnf_prim_state
312: , ben_ext_person.g_bnf_prim_postal_code
313: , ben_ext_person.g_bnf_prim_country
314: , ben_ext_person.g_bnf_prim_effect_date
315: , ben_ext_person.g_bnf_prim_region;
316: if prim_address_c%notfound then

Line 313: , ben_ext_person.g_bnf_prim_country

309: , ben_ext_person.g_bnf_prim_address3
310: , ben_ext_person.g_bnf_prim_city
311: , ben_ext_person.g_bnf_prim_state
312: , ben_ext_person.g_bnf_prim_postal_code
313: , ben_ext_person.g_bnf_prim_country
314: , ben_ext_person.g_bnf_prim_effect_date
315: , ben_ext_person.g_bnf_prim_region;
316: if prim_address_c%notfound then
317: open prim_rltd_address_c(bnfcry.bnf_person_id);

Line 314: , ben_ext_person.g_bnf_prim_effect_date

310: , ben_ext_person.g_bnf_prim_city
311: , ben_ext_person.g_bnf_prim_state
312: , ben_ext_person.g_bnf_prim_postal_code
313: , ben_ext_person.g_bnf_prim_country
314: , ben_ext_person.g_bnf_prim_effect_date
315: , ben_ext_person.g_bnf_prim_region;
316: if prim_address_c%notfound then
317: open prim_rltd_address_c(bnfcry.bnf_person_id);
318: fetch prim_rltd_address_c into ben_ext_person.g_bnf_prim_address1

Line 315: , ben_ext_person.g_bnf_prim_region;

311: , ben_ext_person.g_bnf_prim_state
312: , ben_ext_person.g_bnf_prim_postal_code
313: , ben_ext_person.g_bnf_prim_country
314: , ben_ext_person.g_bnf_prim_effect_date
315: , ben_ext_person.g_bnf_prim_region;
316: if prim_address_c%notfound then
317: open prim_rltd_address_c(bnfcry.bnf_person_id);
318: fetch prim_rltd_address_c into ben_ext_person.g_bnf_prim_address1
319: , ben_ext_person.g_bnf_prim_address2

Line 318: fetch prim_rltd_address_c into ben_ext_person.g_bnf_prim_address1

314: , ben_ext_person.g_bnf_prim_effect_date
315: , ben_ext_person.g_bnf_prim_region;
316: if prim_address_c%notfound then
317: open prim_rltd_address_c(bnfcry.bnf_person_id);
318: fetch prim_rltd_address_c into ben_ext_person.g_bnf_prim_address1
319: , ben_ext_person.g_bnf_prim_address2
320: , ben_ext_person.g_bnf_prim_address3
321: , ben_ext_person.g_bnf_prim_city
322: , ben_ext_person.g_bnf_prim_state

Line 319: , ben_ext_person.g_bnf_prim_address2

315: , ben_ext_person.g_bnf_prim_region;
316: if prim_address_c%notfound then
317: open prim_rltd_address_c(bnfcry.bnf_person_id);
318: fetch prim_rltd_address_c into ben_ext_person.g_bnf_prim_address1
319: , ben_ext_person.g_bnf_prim_address2
320: , ben_ext_person.g_bnf_prim_address3
321: , ben_ext_person.g_bnf_prim_city
322: , ben_ext_person.g_bnf_prim_state
323: , ben_ext_person.g_bnf_prim_postal_code

Line 320: , ben_ext_person.g_bnf_prim_address3

316: if prim_address_c%notfound then
317: open prim_rltd_address_c(bnfcry.bnf_person_id);
318: fetch prim_rltd_address_c into ben_ext_person.g_bnf_prim_address1
319: , ben_ext_person.g_bnf_prim_address2
320: , ben_ext_person.g_bnf_prim_address3
321: , ben_ext_person.g_bnf_prim_city
322: , ben_ext_person.g_bnf_prim_state
323: , ben_ext_person.g_bnf_prim_postal_code
324: , ben_ext_person.g_bnf_prim_country

Line 321: , ben_ext_person.g_bnf_prim_city

317: open prim_rltd_address_c(bnfcry.bnf_person_id);
318: fetch prim_rltd_address_c into ben_ext_person.g_bnf_prim_address1
319: , ben_ext_person.g_bnf_prim_address2
320: , ben_ext_person.g_bnf_prim_address3
321: , ben_ext_person.g_bnf_prim_city
322: , ben_ext_person.g_bnf_prim_state
323: , ben_ext_person.g_bnf_prim_postal_code
324: , ben_ext_person.g_bnf_prim_country
325: , ben_ext_person.g_bnf_prim_effect_date

Line 322: , ben_ext_person.g_bnf_prim_state

318: fetch prim_rltd_address_c into ben_ext_person.g_bnf_prim_address1
319: , ben_ext_person.g_bnf_prim_address2
320: , ben_ext_person.g_bnf_prim_address3
321: , ben_ext_person.g_bnf_prim_city
322: , ben_ext_person.g_bnf_prim_state
323: , ben_ext_person.g_bnf_prim_postal_code
324: , ben_ext_person.g_bnf_prim_country
325: , ben_ext_person.g_bnf_prim_effect_date
326: , ben_ext_person.g_bnf_prim_region;

Line 323: , ben_ext_person.g_bnf_prim_postal_code

319: , ben_ext_person.g_bnf_prim_address2
320: , ben_ext_person.g_bnf_prim_address3
321: , ben_ext_person.g_bnf_prim_city
322: , ben_ext_person.g_bnf_prim_state
323: , ben_ext_person.g_bnf_prim_postal_code
324: , ben_ext_person.g_bnf_prim_country
325: , ben_ext_person.g_bnf_prim_effect_date
326: , ben_ext_person.g_bnf_prim_region;
327: close prim_rltd_address_c;

Line 324: , ben_ext_person.g_bnf_prim_country

320: , ben_ext_person.g_bnf_prim_address3
321: , ben_ext_person.g_bnf_prim_city
322: , ben_ext_person.g_bnf_prim_state
323: , ben_ext_person.g_bnf_prim_postal_code
324: , ben_ext_person.g_bnf_prim_country
325: , ben_ext_person.g_bnf_prim_effect_date
326: , ben_ext_person.g_bnf_prim_region;
327: close prim_rltd_address_c;
328: l_relatated_true := 'Y' ;

Line 325: , ben_ext_person.g_bnf_prim_effect_date

321: , ben_ext_person.g_bnf_prim_city
322: , ben_ext_person.g_bnf_prim_state
323: , ben_ext_person.g_bnf_prim_postal_code
324: , ben_ext_person.g_bnf_prim_country
325: , ben_ext_person.g_bnf_prim_effect_date
326: , ben_ext_person.g_bnf_prim_region;
327: close prim_rltd_address_c;
328: l_relatated_true := 'Y' ;
329: end if;

Line 326: , ben_ext_person.g_bnf_prim_region;

322: , ben_ext_person.g_bnf_prim_state
323: , ben_ext_person.g_bnf_prim_postal_code
324: , ben_ext_person.g_bnf_prim_country
325: , ben_ext_person.g_bnf_prim_effect_date
326: , ben_ext_person.g_bnf_prim_region;
327: close prim_rltd_address_c;
328: l_relatated_true := 'Y' ;
329: end if;
330: close prim_address_c;

Line 338: fetch ext_phone_c into ben_ext_person.g_bnf_home_phone

334:
335: if ben_extract.g_bp_csr = 'Y' then
336: if l_relatated_true = 'N' then
337: open ext_phone_c(bnfcry.bnf_person_id);
338: fetch ext_phone_c into ben_ext_person.g_bnf_home_phone
339: , ben_ext_person.g_bnf_work_phone
340: , ben_ext_person.g_bnf_fax
341: , ben_ext_person.g_bnf_mobile;
342: close ext_phone_c;

Line 339: , ben_ext_person.g_bnf_work_phone

335: if ben_extract.g_bp_csr = 'Y' then
336: if l_relatated_true = 'N' then
337: open ext_phone_c(bnfcry.bnf_person_id);
338: fetch ext_phone_c into ben_ext_person.g_bnf_home_phone
339: , ben_ext_person.g_bnf_work_phone
340: , ben_ext_person.g_bnf_fax
341: , ben_ext_person.g_bnf_mobile;
342: close ext_phone_c;
343: else

Line 340: , ben_ext_person.g_bnf_fax

336: if l_relatated_true = 'N' then
337: open ext_phone_c(bnfcry.bnf_person_id);
338: fetch ext_phone_c into ben_ext_person.g_bnf_home_phone
339: , ben_ext_person.g_bnf_work_phone
340: , ben_ext_person.g_bnf_fax
341: , ben_ext_person.g_bnf_mobile;
342: close ext_phone_c;
343: else
344:

Line 341: , ben_ext_person.g_bnf_mobile;

337: open ext_phone_c(bnfcry.bnf_person_id);
338: fetch ext_phone_c into ben_ext_person.g_bnf_home_phone
339: , ben_ext_person.g_bnf_work_phone
340: , ben_ext_person.g_bnf_fax
341: , ben_ext_person.g_bnf_mobile;
342: close ext_phone_c;
343: else
344:
345: open ext_related_phone_c(bnfcry.bnf_person_id);

Line 346: fetch ext_related_phone_c into ben_ext_person.g_bnf_home_phone

342: close ext_phone_c;
343: else
344:
345: open ext_related_phone_c(bnfcry.bnf_person_id);
346: fetch ext_related_phone_c into ben_ext_person.g_bnf_home_phone
347: , ben_ext_person.g_bnf_work_phone
348: , ben_ext_person.g_bnf_fax
349: , ben_ext_person.g_bnf_mobile;
350: hr_utility.set_location('sec_ph'|| ben_ext_person.g_bnf_home_phone,178);

Line 347: , ben_ext_person.g_bnf_work_phone

343: else
344:
345: open ext_related_phone_c(bnfcry.bnf_person_id);
346: fetch ext_related_phone_c into ben_ext_person.g_bnf_home_phone
347: , ben_ext_person.g_bnf_work_phone
348: , ben_ext_person.g_bnf_fax
349: , ben_ext_person.g_bnf_mobile;
350: hr_utility.set_location('sec_ph'|| ben_ext_person.g_bnf_home_phone,178);
351: close ext_related_phone_c;

Line 348: , ben_ext_person.g_bnf_fax

344:
345: open ext_related_phone_c(bnfcry.bnf_person_id);
346: fetch ext_related_phone_c into ben_ext_person.g_bnf_home_phone
347: , ben_ext_person.g_bnf_work_phone
348: , ben_ext_person.g_bnf_fax
349: , ben_ext_person.g_bnf_mobile;
350: hr_utility.set_location('sec_ph'|| ben_ext_person.g_bnf_home_phone,178);
351: close ext_related_phone_c;
352: end if ;

Line 349: , ben_ext_person.g_bnf_mobile;

345: open ext_related_phone_c(bnfcry.bnf_person_id);
346: fetch ext_related_phone_c into ben_ext_person.g_bnf_home_phone
347: , ben_ext_person.g_bnf_work_phone
348: , ben_ext_person.g_bnf_fax
349: , ben_ext_person.g_bnf_mobile;
350: hr_utility.set_location('sec_ph'|| ben_ext_person.g_bnf_home_phone,178);
351: close ext_related_phone_c;
352: end if ;
353: end if ;

Line 350: hr_utility.set_location('sec_ph'|| ben_ext_person.g_bnf_home_phone,178);

346: fetch ext_related_phone_c into ben_ext_person.g_bnf_home_phone
347: , ben_ext_person.g_bnf_work_phone
348: , ben_ext_person.g_bnf_fax
349: , ben_ext_person.g_bnf_mobile;
350: hr_utility.set_location('sec_ph'|| ben_ext_person.g_bnf_home_phone,178);
351: close ext_related_phone_c;
352: end if ;
353: end if ;
354: --