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_CONTACT dependencies on BEN_EXT_PERSON

Line 24: ben_ext_person.g_contact_rlshp_id := null;

20: --
21: hr_utility.set_location('Entering'||l_proc, 5);
22: --
23: --
24: ben_ext_person.g_contact_rlshp_id := null;
25: ben_ext_person.g_contact_rlshp_type := null;
26: ben_ext_person.g_contact_seq_num := null;
27: ben_ext_person.g_contact_national_ident := null;
28: ben_ext_person.g_contact_last_name := null;

Line 25: ben_ext_person.g_contact_rlshp_type := null;

21: hr_utility.set_location('Entering'||l_proc, 5);
22: --
23: --
24: ben_ext_person.g_contact_rlshp_id := null;
25: ben_ext_person.g_contact_rlshp_type := null;
26: ben_ext_person.g_contact_seq_num := null;
27: ben_ext_person.g_contact_national_ident := null;
28: ben_ext_person.g_contact_last_name := null;
29: ben_ext_person.g_contact_first_name := null;

Line 26: ben_ext_person.g_contact_seq_num := null;

22: --
23: --
24: ben_ext_person.g_contact_rlshp_id := null;
25: ben_ext_person.g_contact_rlshp_type := null;
26: ben_ext_person.g_contact_seq_num := null;
27: ben_ext_person.g_contact_national_ident := null;
28: ben_ext_person.g_contact_last_name := null;
29: ben_ext_person.g_contact_first_name := null;
30: ben_ext_person.g_contact_middle_names := null;

Line 27: ben_ext_person.g_contact_national_ident := null;

23: --
24: ben_ext_person.g_contact_rlshp_id := null;
25: ben_ext_person.g_contact_rlshp_type := null;
26: ben_ext_person.g_contact_seq_num := null;
27: ben_ext_person.g_contact_national_ident := null;
28: ben_ext_person.g_contact_last_name := null;
29: ben_ext_person.g_contact_first_name := null;
30: ben_ext_person.g_contact_middle_names := null;
31: ben_ext_person.g_contact_full_name := null;

Line 28: ben_ext_person.g_contact_last_name := null;

24: ben_ext_person.g_contact_rlshp_id := null;
25: ben_ext_person.g_contact_rlshp_type := null;
26: ben_ext_person.g_contact_seq_num := null;
27: ben_ext_person.g_contact_national_ident := null;
28: ben_ext_person.g_contact_last_name := null;
29: ben_ext_person.g_contact_first_name := null;
30: ben_ext_person.g_contact_middle_names := null;
31: ben_ext_person.g_contact_full_name := null;
32: ben_ext_person.g_contact_suffix := null;

Line 29: ben_ext_person.g_contact_first_name := null;

25: ben_ext_person.g_contact_rlshp_type := null;
26: ben_ext_person.g_contact_seq_num := null;
27: ben_ext_person.g_contact_national_ident := null;
28: ben_ext_person.g_contact_last_name := null;
29: ben_ext_person.g_contact_first_name := null;
30: ben_ext_person.g_contact_middle_names := null;
31: ben_ext_person.g_contact_full_name := null;
32: ben_ext_person.g_contact_suffix := null;
33: ben_ext_person.g_contact_prefix := null;

Line 30: ben_ext_person.g_contact_middle_names := null;

26: ben_ext_person.g_contact_seq_num := null;
27: ben_ext_person.g_contact_national_ident := null;
28: ben_ext_person.g_contact_last_name := null;
29: ben_ext_person.g_contact_first_name := null;
30: ben_ext_person.g_contact_middle_names := null;
31: ben_ext_person.g_contact_full_name := null;
32: ben_ext_person.g_contact_suffix := null;
33: ben_ext_person.g_contact_prefix := null;
34: ben_ext_person.g_contact_title := null;

Line 31: ben_ext_person.g_contact_full_name := null;

27: ben_ext_person.g_contact_national_ident := null;
28: ben_ext_person.g_contact_last_name := null;
29: ben_ext_person.g_contact_first_name := null;
30: ben_ext_person.g_contact_middle_names := null;
31: ben_ext_person.g_contact_full_name := null;
32: ben_ext_person.g_contact_suffix := null;
33: ben_ext_person.g_contact_prefix := null;
34: ben_ext_person.g_contact_title := null;
35: ben_ext_person.g_contact_date_of_birth := null;

Line 32: ben_ext_person.g_contact_suffix := null;

28: ben_ext_person.g_contact_last_name := null;
29: ben_ext_person.g_contact_first_name := null;
30: ben_ext_person.g_contact_middle_names := null;
31: ben_ext_person.g_contact_full_name := null;
32: ben_ext_person.g_contact_suffix := null;
33: ben_ext_person.g_contact_prefix := null;
34: ben_ext_person.g_contact_title := null;
35: ben_ext_person.g_contact_date_of_birth := null;
36: ben_ext_person.g_contact_marital_status := null;

Line 33: ben_ext_person.g_contact_prefix := null;

29: ben_ext_person.g_contact_first_name := null;
30: ben_ext_person.g_contact_middle_names := null;
31: ben_ext_person.g_contact_full_name := null;
32: ben_ext_person.g_contact_suffix := null;
33: ben_ext_person.g_contact_prefix := null;
34: ben_ext_person.g_contact_title := null;
35: ben_ext_person.g_contact_date_of_birth := null;
36: ben_ext_person.g_contact_marital_status := null;
37: ben_ext_person.g_contact_sex := null;

Line 34: ben_ext_person.g_contact_title := null;

30: ben_ext_person.g_contact_middle_names := null;
31: ben_ext_person.g_contact_full_name := null;
32: ben_ext_person.g_contact_suffix := null;
33: ben_ext_person.g_contact_prefix := null;
34: ben_ext_person.g_contact_title := null;
35: ben_ext_person.g_contact_date_of_birth := null;
36: ben_ext_person.g_contact_marital_status := null;
37: ben_ext_person.g_contact_sex := null;
38: ben_ext_person.g_contact_disabled_flag := null;

Line 35: ben_ext_person.g_contact_date_of_birth := null;

31: ben_ext_person.g_contact_full_name := null;
32: ben_ext_person.g_contact_suffix := null;
33: ben_ext_person.g_contact_prefix := null;
34: ben_ext_person.g_contact_title := null;
35: ben_ext_person.g_contact_date_of_birth := null;
36: ben_ext_person.g_contact_marital_status := null;
37: ben_ext_person.g_contact_sex := null;
38: ben_ext_person.g_contact_disabled_flag := null;
39: ben_ext_person.g_contact_student_status := null;

Line 36: ben_ext_person.g_contact_marital_status := null;

32: ben_ext_person.g_contact_suffix := null;
33: ben_ext_person.g_contact_prefix := null;
34: ben_ext_person.g_contact_title := null;
35: ben_ext_person.g_contact_date_of_birth := null;
36: ben_ext_person.g_contact_marital_status := null;
37: ben_ext_person.g_contact_sex := null;
38: ben_ext_person.g_contact_disabled_flag := null;
39: ben_ext_person.g_contact_student_status := null;
40: ben_ext_person.g_contact_date_of_death := null;

Line 37: ben_ext_person.g_contact_sex := null;

33: ben_ext_person.g_contact_prefix := null;
34: ben_ext_person.g_contact_title := null;
35: ben_ext_person.g_contact_date_of_birth := null;
36: ben_ext_person.g_contact_marital_status := null;
37: ben_ext_person.g_contact_sex := null;
38: ben_ext_person.g_contact_disabled_flag := null;
39: ben_ext_person.g_contact_student_status := null;
40: ben_ext_person.g_contact_date_of_death := null;
41: ben_ext_person.g_contact_language := null;

Line 38: ben_ext_person.g_contact_disabled_flag := null;

34: ben_ext_person.g_contact_title := null;
35: ben_ext_person.g_contact_date_of_birth := null;
36: ben_ext_person.g_contact_marital_status := null;
37: ben_ext_person.g_contact_sex := null;
38: ben_ext_person.g_contact_disabled_flag := null;
39: ben_ext_person.g_contact_student_status := null;
40: ben_ext_person.g_contact_date_of_death := null;
41: ben_ext_person.g_contact_language := null;
42: ben_ext_person.g_contact_nationality := null;

Line 39: ben_ext_person.g_contact_student_status := null;

35: ben_ext_person.g_contact_date_of_birth := null;
36: ben_ext_person.g_contact_marital_status := null;
37: ben_ext_person.g_contact_sex := null;
38: ben_ext_person.g_contact_disabled_flag := null;
39: ben_ext_person.g_contact_student_status := null;
40: ben_ext_person.g_contact_date_of_death := null;
41: ben_ext_person.g_contact_language := null;
42: ben_ext_person.g_contact_nationality := null;
43: ben_ext_person.g_contact_email_address := null;

Line 40: ben_ext_person.g_contact_date_of_death := null;

36: ben_ext_person.g_contact_marital_status := null;
37: ben_ext_person.g_contact_sex := null;
38: ben_ext_person.g_contact_disabled_flag := null;
39: ben_ext_person.g_contact_student_status := null;
40: ben_ext_person.g_contact_date_of_death := null;
41: ben_ext_person.g_contact_language := null;
42: ben_ext_person.g_contact_nationality := null;
43: ben_ext_person.g_contact_email_address := null;
44: ben_ext_person.g_contact_known_as := null;

Line 41: ben_ext_person.g_contact_language := null;

37: ben_ext_person.g_contact_sex := null;
38: ben_ext_person.g_contact_disabled_flag := null;
39: ben_ext_person.g_contact_student_status := null;
40: ben_ext_person.g_contact_date_of_death := null;
41: ben_ext_person.g_contact_language := null;
42: ben_ext_person.g_contact_nationality := null;
43: ben_ext_person.g_contact_email_address := null;
44: ben_ext_person.g_contact_known_as := null;
45: ben_ext_person.g_contact_pre_name_adjunct := null;

Line 42: ben_ext_person.g_contact_nationality := null;

38: ben_ext_person.g_contact_disabled_flag := null;
39: ben_ext_person.g_contact_student_status := null;
40: ben_ext_person.g_contact_date_of_death := null;
41: ben_ext_person.g_contact_language := null;
42: ben_ext_person.g_contact_nationality := null;
43: ben_ext_person.g_contact_email_address := null;
44: ben_ext_person.g_contact_known_as := null;
45: ben_ext_person.g_contact_pre_name_adjunct := null;
46: ben_ext_person.g_contact_tobacco_usage := null;

Line 43: ben_ext_person.g_contact_email_address := null;

39: ben_ext_person.g_contact_student_status := null;
40: ben_ext_person.g_contact_date_of_death := null;
41: ben_ext_person.g_contact_language := null;
42: ben_ext_person.g_contact_nationality := null;
43: ben_ext_person.g_contact_email_address := null;
44: ben_ext_person.g_contact_known_as := null;
45: ben_ext_person.g_contact_pre_name_adjunct := null;
46: ben_ext_person.g_contact_tobacco_usage := null;
47: ben_ext_person.g_contact_prev_last_name := null;

Line 44: ben_ext_person.g_contact_known_as := null;

40: ben_ext_person.g_contact_date_of_death := null;
41: ben_ext_person.g_contact_language := null;
42: ben_ext_person.g_contact_nationality := null;
43: ben_ext_person.g_contact_email_address := null;
44: ben_ext_person.g_contact_known_as := null;
45: ben_ext_person.g_contact_pre_name_adjunct := null;
46: ben_ext_person.g_contact_tobacco_usage := null;
47: ben_ext_person.g_contact_prev_last_name := null;
48: ben_ext_person.g_contact_prim_address1 := null;

Line 45: ben_ext_person.g_contact_pre_name_adjunct := null;

41: ben_ext_person.g_contact_language := null;
42: ben_ext_person.g_contact_nationality := null;
43: ben_ext_person.g_contact_email_address := null;
44: ben_ext_person.g_contact_known_as := null;
45: ben_ext_person.g_contact_pre_name_adjunct := null;
46: ben_ext_person.g_contact_tobacco_usage := null;
47: ben_ext_person.g_contact_prev_last_name := null;
48: ben_ext_person.g_contact_prim_address1 := null;
49: ben_ext_person.g_contact_prim_address2 := null;

Line 46: ben_ext_person.g_contact_tobacco_usage := null;

42: ben_ext_person.g_contact_nationality := null;
43: ben_ext_person.g_contact_email_address := null;
44: ben_ext_person.g_contact_known_as := null;
45: ben_ext_person.g_contact_pre_name_adjunct := null;
46: ben_ext_person.g_contact_tobacco_usage := null;
47: ben_ext_person.g_contact_prev_last_name := null;
48: ben_ext_person.g_contact_prim_address1 := null;
49: ben_ext_person.g_contact_prim_address2 := null;
50: ben_ext_person.g_contact_prim_address3 := null;

Line 47: ben_ext_person.g_contact_prev_last_name := null;

43: ben_ext_person.g_contact_email_address := null;
44: ben_ext_person.g_contact_known_as := null;
45: ben_ext_person.g_contact_pre_name_adjunct := null;
46: ben_ext_person.g_contact_tobacco_usage := null;
47: ben_ext_person.g_contact_prev_last_name := null;
48: ben_ext_person.g_contact_prim_address1 := null;
49: ben_ext_person.g_contact_prim_address2 := null;
50: ben_ext_person.g_contact_prim_address3 := null;
51: ben_ext_person.g_contact_prim_city := null;

Line 48: ben_ext_person.g_contact_prim_address1 := null;

44: ben_ext_person.g_contact_known_as := null;
45: ben_ext_person.g_contact_pre_name_adjunct := null;
46: ben_ext_person.g_contact_tobacco_usage := null;
47: ben_ext_person.g_contact_prev_last_name := null;
48: ben_ext_person.g_contact_prim_address1 := null;
49: ben_ext_person.g_contact_prim_address2 := null;
50: ben_ext_person.g_contact_prim_address3 := null;
51: ben_ext_person.g_contact_prim_city := null;
52: ben_ext_person.g_contact_prim_state := null;

Line 49: ben_ext_person.g_contact_prim_address2 := null;

45: ben_ext_person.g_contact_pre_name_adjunct := null;
46: ben_ext_person.g_contact_tobacco_usage := null;
47: ben_ext_person.g_contact_prev_last_name := null;
48: ben_ext_person.g_contact_prim_address1 := null;
49: ben_ext_person.g_contact_prim_address2 := null;
50: ben_ext_person.g_contact_prim_address3 := null;
51: ben_ext_person.g_contact_prim_city := null;
52: ben_ext_person.g_contact_prim_state := null;
53: ben_ext_person.g_contact_prim_postal_code := null;

Line 50: ben_ext_person.g_contact_prim_address3 := null;

46: ben_ext_person.g_contact_tobacco_usage := null;
47: ben_ext_person.g_contact_prev_last_name := null;
48: ben_ext_person.g_contact_prim_address1 := null;
49: ben_ext_person.g_contact_prim_address2 := null;
50: ben_ext_person.g_contact_prim_address3 := null;
51: ben_ext_person.g_contact_prim_city := null;
52: ben_ext_person.g_contact_prim_state := null;
53: ben_ext_person.g_contact_prim_postal_code := null;
54: ben_ext_person.g_contact_prim_country := null;

Line 51: ben_ext_person.g_contact_prim_city := null;

47: ben_ext_person.g_contact_prev_last_name := null;
48: ben_ext_person.g_contact_prim_address1 := null;
49: ben_ext_person.g_contact_prim_address2 := null;
50: ben_ext_person.g_contact_prim_address3 := null;
51: ben_ext_person.g_contact_prim_city := null;
52: ben_ext_person.g_contact_prim_state := null;
53: ben_ext_person.g_contact_prim_postal_code := null;
54: ben_ext_person.g_contact_prim_country := null;
55: ben_ext_person.g_contact_prim_effect_date := null;

Line 52: ben_ext_person.g_contact_prim_state := null;

48: ben_ext_person.g_contact_prim_address1 := null;
49: ben_ext_person.g_contact_prim_address2 := null;
50: ben_ext_person.g_contact_prim_address3 := null;
51: ben_ext_person.g_contact_prim_city := null;
52: ben_ext_person.g_contact_prim_state := null;
53: ben_ext_person.g_contact_prim_postal_code := null;
54: ben_ext_person.g_contact_prim_country := null;
55: ben_ext_person.g_contact_prim_effect_date := null;
56: ben_ext_person.g_contact_prim_region := null;

Line 53: ben_ext_person.g_contact_prim_postal_code := null;

49: ben_ext_person.g_contact_prim_address2 := null;
50: ben_ext_person.g_contact_prim_address3 := null;
51: ben_ext_person.g_contact_prim_city := null;
52: ben_ext_person.g_contact_prim_state := null;
53: ben_ext_person.g_contact_prim_postal_code := null;
54: ben_ext_person.g_contact_prim_country := null;
55: ben_ext_person.g_contact_prim_effect_date := null;
56: ben_ext_person.g_contact_prim_region := null;
57: ben_ext_person.g_contact_home_phone := null;

Line 54: ben_ext_person.g_contact_prim_country := null;

50: ben_ext_person.g_contact_prim_address3 := null;
51: ben_ext_person.g_contact_prim_city := null;
52: ben_ext_person.g_contact_prim_state := null;
53: ben_ext_person.g_contact_prim_postal_code := null;
54: ben_ext_person.g_contact_prim_country := null;
55: ben_ext_person.g_contact_prim_effect_date := null;
56: ben_ext_person.g_contact_prim_region := null;
57: ben_ext_person.g_contact_home_phone := null;
58: ben_ext_person.g_contact_work_phone := null;

Line 55: ben_ext_person.g_contact_prim_effect_date := null;

51: ben_ext_person.g_contact_prim_city := null;
52: ben_ext_person.g_contact_prim_state := null;
53: ben_ext_person.g_contact_prim_postal_code := null;
54: ben_ext_person.g_contact_prim_country := null;
55: ben_ext_person.g_contact_prim_effect_date := null;
56: ben_ext_person.g_contact_prim_region := null;
57: ben_ext_person.g_contact_home_phone := null;
58: ben_ext_person.g_contact_work_phone := null;
59: ben_ext_person.g_contact_fax := null;

Line 56: ben_ext_person.g_contact_prim_region := null;

52: ben_ext_person.g_contact_prim_state := null;
53: ben_ext_person.g_contact_prim_postal_code := null;
54: ben_ext_person.g_contact_prim_country := null;
55: ben_ext_person.g_contact_prim_effect_date := null;
56: ben_ext_person.g_contact_prim_region := null;
57: ben_ext_person.g_contact_home_phone := null;
58: ben_ext_person.g_contact_work_phone := null;
59: ben_ext_person.g_contact_fax := null;
60: ben_ext_person.g_contact_mobile := null;

Line 57: ben_ext_person.g_contact_home_phone := null;

53: ben_ext_person.g_contact_prim_postal_code := null;
54: ben_ext_person.g_contact_prim_country := null;
55: ben_ext_person.g_contact_prim_effect_date := null;
56: ben_ext_person.g_contact_prim_region := null;
57: ben_ext_person.g_contact_home_phone := null;
58: ben_ext_person.g_contact_work_phone := null;
59: ben_ext_person.g_contact_fax := null;
60: ben_ext_person.g_contact_mobile := null;
61: ben_ext_person.g_contact_prmy_contact_flag := null;

Line 58: ben_ext_person.g_contact_work_phone := null;

54: ben_ext_person.g_contact_prim_country := null;
55: ben_ext_person.g_contact_prim_effect_date := null;
56: ben_ext_person.g_contact_prim_region := null;
57: ben_ext_person.g_contact_home_phone := null;
58: ben_ext_person.g_contact_work_phone := null;
59: ben_ext_person.g_contact_fax := null;
60: ben_ext_person.g_contact_mobile := null;
61: ben_ext_person.g_contact_prmy_contact_flag := null;
62: ben_ext_person.g_contact_shared_resd_flag := null;

Line 59: ben_ext_person.g_contact_fax := null;

55: ben_ext_person.g_contact_prim_effect_date := null;
56: ben_ext_person.g_contact_prim_region := null;
57: ben_ext_person.g_contact_home_phone := null;
58: ben_ext_person.g_contact_work_phone := null;
59: ben_ext_person.g_contact_fax := null;
60: ben_ext_person.g_contact_mobile := null;
61: ben_ext_person.g_contact_prmy_contact_flag := null;
62: ben_ext_person.g_contact_shared_resd_flag := null;
63: ben_ext_person.g_contact_personal_flag := null;

Line 60: ben_ext_person.g_contact_mobile := null;

56: ben_ext_person.g_contact_prim_region := null;
57: ben_ext_person.g_contact_home_phone := null;
58: ben_ext_person.g_contact_work_phone := null;
59: ben_ext_person.g_contact_fax := null;
60: ben_ext_person.g_contact_mobile := null;
61: ben_ext_person.g_contact_prmy_contact_flag := null;
62: ben_ext_person.g_contact_shared_resd_flag := null;
63: ben_ext_person.g_contact_personal_flag := null;
64: ben_ext_person.g_contact_pymts_rcpnt_flag := null;

Line 61: ben_ext_person.g_contact_prmy_contact_flag := null;

57: ben_ext_person.g_contact_home_phone := null;
58: ben_ext_person.g_contact_work_phone := null;
59: ben_ext_person.g_contact_fax := null;
60: ben_ext_person.g_contact_mobile := null;
61: ben_ext_person.g_contact_prmy_contact_flag := null;
62: ben_ext_person.g_contact_shared_resd_flag := null;
63: ben_ext_person.g_contact_personal_flag := null;
64: ben_ext_person.g_contact_pymts_rcpnt_flag := null;
65: ben_ext_person.g_contact_start_date := null;

Line 62: ben_ext_person.g_contact_shared_resd_flag := null;

58: ben_ext_person.g_contact_work_phone := null;
59: ben_ext_person.g_contact_fax := null;
60: ben_ext_person.g_contact_mobile := null;
61: ben_ext_person.g_contact_prmy_contact_flag := null;
62: ben_ext_person.g_contact_shared_resd_flag := null;
63: ben_ext_person.g_contact_personal_flag := null;
64: ben_ext_person.g_contact_pymts_rcpnt_flag := null;
65: ben_ext_person.g_contact_start_date := null;
66: ben_ext_person.g_contact_end_date := null;

Line 63: ben_ext_person.g_contact_personal_flag := null;

59: ben_ext_person.g_contact_fax := null;
60: ben_ext_person.g_contact_mobile := null;
61: ben_ext_person.g_contact_prmy_contact_flag := null;
62: ben_ext_person.g_contact_shared_resd_flag := null;
63: ben_ext_person.g_contact_personal_flag := null;
64: ben_ext_person.g_contact_pymts_rcpnt_flag := null;
65: ben_ext_person.g_contact_start_date := null;
66: ben_ext_person.g_contact_end_date := null;
67: ben_ext_person.g_contact_start_life_evt := null;

Line 64: ben_ext_person.g_contact_pymts_rcpnt_flag := null;

60: ben_ext_person.g_contact_mobile := null;
61: ben_ext_person.g_contact_prmy_contact_flag := null;
62: ben_ext_person.g_contact_shared_resd_flag := null;
63: ben_ext_person.g_contact_personal_flag := null;
64: ben_ext_person.g_contact_pymts_rcpnt_flag := null;
65: ben_ext_person.g_contact_start_date := null;
66: ben_ext_person.g_contact_end_date := null;
67: ben_ext_person.g_contact_start_life_evt := null;
68: ben_ext_person.g_contact_start_ler_id := null;

Line 65: ben_ext_person.g_contact_start_date := null;

61: ben_ext_person.g_contact_prmy_contact_flag := null;
62: ben_ext_person.g_contact_shared_resd_flag := null;
63: ben_ext_person.g_contact_personal_flag := null;
64: ben_ext_person.g_contact_pymts_rcpnt_flag := null;
65: ben_ext_person.g_contact_start_date := null;
66: ben_ext_person.g_contact_end_date := null;
67: ben_ext_person.g_contact_start_life_evt := null;
68: ben_ext_person.g_contact_start_ler_id := null;
69: ben_ext_person.g_contact_end_life_evt := null;

Line 66: ben_ext_person.g_contact_end_date := null;

62: ben_ext_person.g_contact_shared_resd_flag := null;
63: ben_ext_person.g_contact_personal_flag := null;
64: ben_ext_person.g_contact_pymts_rcpnt_flag := null;
65: ben_ext_person.g_contact_start_date := null;
66: ben_ext_person.g_contact_end_date := null;
67: ben_ext_person.g_contact_start_life_evt := null;
68: ben_ext_person.g_contact_start_ler_id := null;
69: ben_ext_person.g_contact_end_life_evt := null;
70: ben_ext_person.g_contact_end_ler_id := null;

Line 67: ben_ext_person.g_contact_start_life_evt := null;

63: ben_ext_person.g_contact_personal_flag := null;
64: ben_ext_person.g_contact_pymts_rcpnt_flag := null;
65: ben_ext_person.g_contact_start_date := null;
66: ben_ext_person.g_contact_end_date := null;
67: ben_ext_person.g_contact_start_life_evt := null;
68: ben_ext_person.g_contact_start_ler_id := null;
69: ben_ext_person.g_contact_end_life_evt := null;
70: ben_ext_person.g_contact_end_ler_id := null;
71: ben_ext_person.g_contact_is_elig_dpnt_flag := null;

Line 68: ben_ext_person.g_contact_start_ler_id := null;

64: ben_ext_person.g_contact_pymts_rcpnt_flag := null;
65: ben_ext_person.g_contact_start_date := null;
66: ben_ext_person.g_contact_end_date := null;
67: ben_ext_person.g_contact_start_life_evt := null;
68: ben_ext_person.g_contact_start_ler_id := null;
69: ben_ext_person.g_contact_end_life_evt := null;
70: ben_ext_person.g_contact_end_ler_id := null;
71: ben_ext_person.g_contact_is_elig_dpnt_flag := null;
72: ben_ext_person.g_contact_is_cvrd_dpnt_flag := null;

Line 69: ben_ext_person.g_contact_end_life_evt := null;

65: ben_ext_person.g_contact_start_date := null;
66: ben_ext_person.g_contact_end_date := null;
67: ben_ext_person.g_contact_start_life_evt := null;
68: ben_ext_person.g_contact_start_ler_id := null;
69: ben_ext_person.g_contact_end_life_evt := null;
70: ben_ext_person.g_contact_end_ler_id := null;
71: ben_ext_person.g_contact_is_elig_dpnt_flag := null;
72: ben_ext_person.g_contact_is_cvrd_dpnt_flag := null;
73: ben_ext_person.g_contact_is_bnfcry_flag := null;

Line 70: ben_ext_person.g_contact_end_ler_id := null;

66: ben_ext_person.g_contact_end_date := null;
67: ben_ext_person.g_contact_start_life_evt := null;
68: ben_ext_person.g_contact_start_ler_id := null;
69: ben_ext_person.g_contact_end_life_evt := null;
70: ben_ext_person.g_contact_end_ler_id := null;
71: ben_ext_person.g_contact_is_elig_dpnt_flag := null;
72: ben_ext_person.g_contact_is_cvrd_dpnt_flag := null;
73: ben_ext_person.g_contact_is_bnfcry_flag := null;
74: --

Line 71: ben_ext_person.g_contact_is_elig_dpnt_flag := null;

67: ben_ext_person.g_contact_start_life_evt := null;
68: ben_ext_person.g_contact_start_ler_id := null;
69: ben_ext_person.g_contact_end_life_evt := null;
70: ben_ext_person.g_contact_end_ler_id := null;
71: ben_ext_person.g_contact_is_elig_dpnt_flag := null;
72: ben_ext_person.g_contact_is_cvrd_dpnt_flag := null;
73: ben_ext_person.g_contact_is_bnfcry_flag := null;
74: --
75: --

Line 72: ben_ext_person.g_contact_is_cvrd_dpnt_flag := null;

68: ben_ext_person.g_contact_start_ler_id := null;
69: ben_ext_person.g_contact_end_life_evt := null;
70: ben_ext_person.g_contact_end_ler_id := null;
71: ben_ext_person.g_contact_is_elig_dpnt_flag := null;
72: ben_ext_person.g_contact_is_cvrd_dpnt_flag := null;
73: ben_ext_person.g_contact_is_bnfcry_flag := null;
74: --
75: --
76: hr_utility.set_location('Exiting'||l_proc, 15);

Line 73: ben_ext_person.g_contact_is_bnfcry_flag := null;

69: ben_ext_person.g_contact_end_life_evt := null;
70: ben_ext_person.g_contact_end_ler_id := null;
71: ben_ext_person.g_contact_is_elig_dpnt_flag := null;
72: ben_ext_person.g_contact_is_cvrd_dpnt_flag := null;
73: ben_ext_person.g_contact_is_bnfcry_flag := null;
74: --
75: --
76: hr_utility.set_location('Exiting'||l_proc, 15);
77: --

Line 290: ben_ext_person.g_contact_rlshp_id := contact.contact_relationship_id;

286: initialize_globals;
287: --
288: -- fetch dependent information into globals
289: --
290: ben_ext_person.g_contact_rlshp_id := contact.contact_relationship_id;
291: ben_ext_person.g_contact_rlshp_type := contact.contact_type;
292: ben_ext_person.g_contact_seq_num := contact.sequence_number;
293: ben_ext_person.g_contact_prmy_contact_flag := contact.PRIMARY_CONTACT_FLAG;
294: ben_ext_person.g_contact_shared_resd_flag := contact.RLTD_PER_RSDS_W_DSGNTR_FLAG;

Line 291: ben_ext_person.g_contact_rlshp_type := contact.contact_type;

287: --
288: -- fetch dependent information into globals
289: --
290: ben_ext_person.g_contact_rlshp_id := contact.contact_relationship_id;
291: ben_ext_person.g_contact_rlshp_type := contact.contact_type;
292: ben_ext_person.g_contact_seq_num := contact.sequence_number;
293: ben_ext_person.g_contact_prmy_contact_flag := contact.PRIMARY_CONTACT_FLAG;
294: ben_ext_person.g_contact_shared_resd_flag := contact.RLTD_PER_RSDS_W_DSGNTR_FLAG;
295: ben_ext_person.g_contact_personal_flag := contact.PERSONAL_FLAG;

Line 292: ben_ext_person.g_contact_seq_num := contact.sequence_number;

288: -- fetch dependent information into globals
289: --
290: ben_ext_person.g_contact_rlshp_id := contact.contact_relationship_id;
291: ben_ext_person.g_contact_rlshp_type := contact.contact_type;
292: ben_ext_person.g_contact_seq_num := contact.sequence_number;
293: ben_ext_person.g_contact_prmy_contact_flag := contact.PRIMARY_CONTACT_FLAG;
294: ben_ext_person.g_contact_shared_resd_flag := contact.RLTD_PER_RSDS_W_DSGNTR_FLAG;
295: ben_ext_person.g_contact_personal_flag := contact.PERSONAL_FLAG;
296: ben_ext_person.g_contact_pymts_rcpnt_flag := contact.THIRD_PARTY_PAY_FLAG;

Line 293: ben_ext_person.g_contact_prmy_contact_flag := contact.PRIMARY_CONTACT_FLAG;

289: --
290: ben_ext_person.g_contact_rlshp_id := contact.contact_relationship_id;
291: ben_ext_person.g_contact_rlshp_type := contact.contact_type;
292: ben_ext_person.g_contact_seq_num := contact.sequence_number;
293: ben_ext_person.g_contact_prmy_contact_flag := contact.PRIMARY_CONTACT_FLAG;
294: ben_ext_person.g_contact_shared_resd_flag := contact.RLTD_PER_RSDS_W_DSGNTR_FLAG;
295: ben_ext_person.g_contact_personal_flag := contact.PERSONAL_FLAG;
296: ben_ext_person.g_contact_pymts_rcpnt_flag := contact.THIRD_PARTY_PAY_FLAG;
297: ben_ext_person.g_contact_start_date := contact.DATE_START;

Line 294: ben_ext_person.g_contact_shared_resd_flag := contact.RLTD_PER_RSDS_W_DSGNTR_FLAG;

290: ben_ext_person.g_contact_rlshp_id := contact.contact_relationship_id;
291: ben_ext_person.g_contact_rlshp_type := contact.contact_type;
292: ben_ext_person.g_contact_seq_num := contact.sequence_number;
293: ben_ext_person.g_contact_prmy_contact_flag := contact.PRIMARY_CONTACT_FLAG;
294: ben_ext_person.g_contact_shared_resd_flag := contact.RLTD_PER_RSDS_W_DSGNTR_FLAG;
295: ben_ext_person.g_contact_personal_flag := contact.PERSONAL_FLAG;
296: ben_ext_person.g_contact_pymts_rcpnt_flag := contact.THIRD_PARTY_PAY_FLAG;
297: ben_ext_person.g_contact_start_date := contact.DATE_START;
298: ben_ext_person.g_contact_end_date := contact.DATE_END;

Line 295: ben_ext_person.g_contact_personal_flag := contact.PERSONAL_FLAG;

291: ben_ext_person.g_contact_rlshp_type := contact.contact_type;
292: ben_ext_person.g_contact_seq_num := contact.sequence_number;
293: ben_ext_person.g_contact_prmy_contact_flag := contact.PRIMARY_CONTACT_FLAG;
294: ben_ext_person.g_contact_shared_resd_flag := contact.RLTD_PER_RSDS_W_DSGNTR_FLAG;
295: ben_ext_person.g_contact_personal_flag := contact.PERSONAL_FLAG;
296: ben_ext_person.g_contact_pymts_rcpnt_flag := contact.THIRD_PARTY_PAY_FLAG;
297: ben_ext_person.g_contact_start_date := contact.DATE_START;
298: ben_ext_person.g_contact_end_date := contact.DATE_END;
299: ben_ext_person.g_contact_national_ident := contact.national_identifier;

Line 296: ben_ext_person.g_contact_pymts_rcpnt_flag := contact.THIRD_PARTY_PAY_FLAG;

292: ben_ext_person.g_contact_seq_num := contact.sequence_number;
293: ben_ext_person.g_contact_prmy_contact_flag := contact.PRIMARY_CONTACT_FLAG;
294: ben_ext_person.g_contact_shared_resd_flag := contact.RLTD_PER_RSDS_W_DSGNTR_FLAG;
295: ben_ext_person.g_contact_personal_flag := contact.PERSONAL_FLAG;
296: ben_ext_person.g_contact_pymts_rcpnt_flag := contact.THIRD_PARTY_PAY_FLAG;
297: ben_ext_person.g_contact_start_date := contact.DATE_START;
298: ben_ext_person.g_contact_end_date := contact.DATE_END;
299: ben_ext_person.g_contact_national_ident := contact.national_identifier;
300: ben_ext_person.g_contact_last_name := contact.last_name;

Line 297: ben_ext_person.g_contact_start_date := contact.DATE_START;

293: ben_ext_person.g_contact_prmy_contact_flag := contact.PRIMARY_CONTACT_FLAG;
294: ben_ext_person.g_contact_shared_resd_flag := contact.RLTD_PER_RSDS_W_DSGNTR_FLAG;
295: ben_ext_person.g_contact_personal_flag := contact.PERSONAL_FLAG;
296: ben_ext_person.g_contact_pymts_rcpnt_flag := contact.THIRD_PARTY_PAY_FLAG;
297: ben_ext_person.g_contact_start_date := contact.DATE_START;
298: ben_ext_person.g_contact_end_date := contact.DATE_END;
299: ben_ext_person.g_contact_national_ident := contact.national_identifier;
300: ben_ext_person.g_contact_last_name := contact.last_name;
301: ben_ext_person.g_contact_first_name := contact.first_name;

Line 298: ben_ext_person.g_contact_end_date := contact.DATE_END;

294: ben_ext_person.g_contact_shared_resd_flag := contact.RLTD_PER_RSDS_W_DSGNTR_FLAG;
295: ben_ext_person.g_contact_personal_flag := contact.PERSONAL_FLAG;
296: ben_ext_person.g_contact_pymts_rcpnt_flag := contact.THIRD_PARTY_PAY_FLAG;
297: ben_ext_person.g_contact_start_date := contact.DATE_START;
298: ben_ext_person.g_contact_end_date := contact.DATE_END;
299: ben_ext_person.g_contact_national_ident := contact.national_identifier;
300: ben_ext_person.g_contact_last_name := contact.last_name;
301: ben_ext_person.g_contact_first_name := contact.first_name;
302: ben_ext_person.g_contact_middle_names := contact.middle_names;

Line 299: ben_ext_person.g_contact_national_ident := contact.national_identifier;

295: ben_ext_person.g_contact_personal_flag := contact.PERSONAL_FLAG;
296: ben_ext_person.g_contact_pymts_rcpnt_flag := contact.THIRD_PARTY_PAY_FLAG;
297: ben_ext_person.g_contact_start_date := contact.DATE_START;
298: ben_ext_person.g_contact_end_date := contact.DATE_END;
299: ben_ext_person.g_contact_national_ident := contact.national_identifier;
300: ben_ext_person.g_contact_last_name := contact.last_name;
301: ben_ext_person.g_contact_first_name := contact.first_name;
302: ben_ext_person.g_contact_middle_names := contact.middle_names;
303: ben_ext_person.g_contact_full_name := contact.full_name;

Line 300: ben_ext_person.g_contact_last_name := contact.last_name;

296: ben_ext_person.g_contact_pymts_rcpnt_flag := contact.THIRD_PARTY_PAY_FLAG;
297: ben_ext_person.g_contact_start_date := contact.DATE_START;
298: ben_ext_person.g_contact_end_date := contact.DATE_END;
299: ben_ext_person.g_contact_national_ident := contact.national_identifier;
300: ben_ext_person.g_contact_last_name := contact.last_name;
301: ben_ext_person.g_contact_first_name := contact.first_name;
302: ben_ext_person.g_contact_middle_names := contact.middle_names;
303: ben_ext_person.g_contact_full_name := contact.full_name;
304: ben_ext_person.g_contact_suffix := contact.suffix;

Line 301: ben_ext_person.g_contact_first_name := contact.first_name;

297: ben_ext_person.g_contact_start_date := contact.DATE_START;
298: ben_ext_person.g_contact_end_date := contact.DATE_END;
299: ben_ext_person.g_contact_national_ident := contact.national_identifier;
300: ben_ext_person.g_contact_last_name := contact.last_name;
301: ben_ext_person.g_contact_first_name := contact.first_name;
302: ben_ext_person.g_contact_middle_names := contact.middle_names;
303: ben_ext_person.g_contact_full_name := contact.full_name;
304: ben_ext_person.g_contact_suffix := contact.suffix;
305: ben_ext_person.g_contact_prefix := contact.prefix;

Line 302: ben_ext_person.g_contact_middle_names := contact.middle_names;

298: ben_ext_person.g_contact_end_date := contact.DATE_END;
299: ben_ext_person.g_contact_national_ident := contact.national_identifier;
300: ben_ext_person.g_contact_last_name := contact.last_name;
301: ben_ext_person.g_contact_first_name := contact.first_name;
302: ben_ext_person.g_contact_middle_names := contact.middle_names;
303: ben_ext_person.g_contact_full_name := contact.full_name;
304: ben_ext_person.g_contact_suffix := contact.suffix;
305: ben_ext_person.g_contact_prefix := contact.prefix;
306: ben_ext_person.g_contact_title := contact.title;

Line 303: ben_ext_person.g_contact_full_name := contact.full_name;

299: ben_ext_person.g_contact_national_ident := contact.national_identifier;
300: ben_ext_person.g_contact_last_name := contact.last_name;
301: ben_ext_person.g_contact_first_name := contact.first_name;
302: ben_ext_person.g_contact_middle_names := contact.middle_names;
303: ben_ext_person.g_contact_full_name := contact.full_name;
304: ben_ext_person.g_contact_suffix := contact.suffix;
305: ben_ext_person.g_contact_prefix := contact.prefix;
306: ben_ext_person.g_contact_title := contact.title;
307: ben_ext_person.g_contact_date_of_birth := contact.date_of_birth;

Line 304: ben_ext_person.g_contact_suffix := contact.suffix;

300: ben_ext_person.g_contact_last_name := contact.last_name;
301: ben_ext_person.g_contact_first_name := contact.first_name;
302: ben_ext_person.g_contact_middle_names := contact.middle_names;
303: ben_ext_person.g_contact_full_name := contact.full_name;
304: ben_ext_person.g_contact_suffix := contact.suffix;
305: ben_ext_person.g_contact_prefix := contact.prefix;
306: ben_ext_person.g_contact_title := contact.title;
307: ben_ext_person.g_contact_date_of_birth := contact.date_of_birth;
308: ben_ext_person.g_contact_marital_status := contact.marital_status;

Line 305: ben_ext_person.g_contact_prefix := contact.prefix;

301: ben_ext_person.g_contact_first_name := contact.first_name;
302: ben_ext_person.g_contact_middle_names := contact.middle_names;
303: ben_ext_person.g_contact_full_name := contact.full_name;
304: ben_ext_person.g_contact_suffix := contact.suffix;
305: ben_ext_person.g_contact_prefix := contact.prefix;
306: ben_ext_person.g_contact_title := contact.title;
307: ben_ext_person.g_contact_date_of_birth := contact.date_of_birth;
308: ben_ext_person.g_contact_marital_status := contact.marital_status;
309: ben_ext_person.g_contact_sex := contact.sex;

Line 306: ben_ext_person.g_contact_title := contact.title;

302: ben_ext_person.g_contact_middle_names := contact.middle_names;
303: ben_ext_person.g_contact_full_name := contact.full_name;
304: ben_ext_person.g_contact_suffix := contact.suffix;
305: ben_ext_person.g_contact_prefix := contact.prefix;
306: ben_ext_person.g_contact_title := contact.title;
307: ben_ext_person.g_contact_date_of_birth := contact.date_of_birth;
308: ben_ext_person.g_contact_marital_status := contact.marital_status;
309: ben_ext_person.g_contact_sex := contact.sex;
310: ben_ext_person.g_contact_disabled_flag := contact.registered_disabled_flag;

Line 307: ben_ext_person.g_contact_date_of_birth := contact.date_of_birth;

303: ben_ext_person.g_contact_full_name := contact.full_name;
304: ben_ext_person.g_contact_suffix := contact.suffix;
305: ben_ext_person.g_contact_prefix := contact.prefix;
306: ben_ext_person.g_contact_title := contact.title;
307: ben_ext_person.g_contact_date_of_birth := contact.date_of_birth;
308: ben_ext_person.g_contact_marital_status := contact.marital_status;
309: ben_ext_person.g_contact_sex := contact.sex;
310: ben_ext_person.g_contact_disabled_flag := contact.registered_disabled_flag;
311: ben_ext_person.g_contact_student_status := contact.student_status;

Line 308: ben_ext_person.g_contact_marital_status := contact.marital_status;

304: ben_ext_person.g_contact_suffix := contact.suffix;
305: ben_ext_person.g_contact_prefix := contact.prefix;
306: ben_ext_person.g_contact_title := contact.title;
307: ben_ext_person.g_contact_date_of_birth := contact.date_of_birth;
308: ben_ext_person.g_contact_marital_status := contact.marital_status;
309: ben_ext_person.g_contact_sex := contact.sex;
310: ben_ext_person.g_contact_disabled_flag := contact.registered_disabled_flag;
311: ben_ext_person.g_contact_student_status := contact.student_status;
312: ben_ext_person.g_contact_date_of_death := contact.date_of_death;

Line 309: ben_ext_person.g_contact_sex := contact.sex;

305: ben_ext_person.g_contact_prefix := contact.prefix;
306: ben_ext_person.g_contact_title := contact.title;
307: ben_ext_person.g_contact_date_of_birth := contact.date_of_birth;
308: ben_ext_person.g_contact_marital_status := contact.marital_status;
309: ben_ext_person.g_contact_sex := contact.sex;
310: ben_ext_person.g_contact_disabled_flag := contact.registered_disabled_flag;
311: ben_ext_person.g_contact_student_status := contact.student_status;
312: ben_ext_person.g_contact_date_of_death := contact.date_of_death;
313: ben_ext_person.g_contact_language := contact.correspondence_language;

Line 310: ben_ext_person.g_contact_disabled_flag := contact.registered_disabled_flag;

306: ben_ext_person.g_contact_title := contact.title;
307: ben_ext_person.g_contact_date_of_birth := contact.date_of_birth;
308: ben_ext_person.g_contact_marital_status := contact.marital_status;
309: ben_ext_person.g_contact_sex := contact.sex;
310: ben_ext_person.g_contact_disabled_flag := contact.registered_disabled_flag;
311: ben_ext_person.g_contact_student_status := contact.student_status;
312: ben_ext_person.g_contact_date_of_death := contact.date_of_death;
313: ben_ext_person.g_contact_language := contact.correspondence_language;
314: ben_ext_person.g_contact_nationality := contact.nationality;

Line 311: ben_ext_person.g_contact_student_status := contact.student_status;

307: ben_ext_person.g_contact_date_of_birth := contact.date_of_birth;
308: ben_ext_person.g_contact_marital_status := contact.marital_status;
309: ben_ext_person.g_contact_sex := contact.sex;
310: ben_ext_person.g_contact_disabled_flag := contact.registered_disabled_flag;
311: ben_ext_person.g_contact_student_status := contact.student_status;
312: ben_ext_person.g_contact_date_of_death := contact.date_of_death;
313: ben_ext_person.g_contact_language := contact.correspondence_language;
314: ben_ext_person.g_contact_nationality := contact.nationality;
315: ben_ext_person.g_contact_email_address := contact.email_address;

Line 312: ben_ext_person.g_contact_date_of_death := contact.date_of_death;

308: ben_ext_person.g_contact_marital_status := contact.marital_status;
309: ben_ext_person.g_contact_sex := contact.sex;
310: ben_ext_person.g_contact_disabled_flag := contact.registered_disabled_flag;
311: ben_ext_person.g_contact_student_status := contact.student_status;
312: ben_ext_person.g_contact_date_of_death := contact.date_of_death;
313: ben_ext_person.g_contact_language := contact.correspondence_language;
314: ben_ext_person.g_contact_nationality := contact.nationality;
315: ben_ext_person.g_contact_email_address := contact.email_address;
316: ben_ext_person.g_contact_known_as := contact.known_as;

Line 313: ben_ext_person.g_contact_language := contact.correspondence_language;

309: ben_ext_person.g_contact_sex := contact.sex;
310: ben_ext_person.g_contact_disabled_flag := contact.registered_disabled_flag;
311: ben_ext_person.g_contact_student_status := contact.student_status;
312: ben_ext_person.g_contact_date_of_death := contact.date_of_death;
313: ben_ext_person.g_contact_language := contact.correspondence_language;
314: ben_ext_person.g_contact_nationality := contact.nationality;
315: ben_ext_person.g_contact_email_address := contact.email_address;
316: ben_ext_person.g_contact_known_as := contact.known_as;
317: ben_ext_person.g_contact_pre_name_adjunct := contact.pre_name_adjunct;

Line 314: ben_ext_person.g_contact_nationality := contact.nationality;

310: ben_ext_person.g_contact_disabled_flag := contact.registered_disabled_flag;
311: ben_ext_person.g_contact_student_status := contact.student_status;
312: ben_ext_person.g_contact_date_of_death := contact.date_of_death;
313: ben_ext_person.g_contact_language := contact.correspondence_language;
314: ben_ext_person.g_contact_nationality := contact.nationality;
315: ben_ext_person.g_contact_email_address := contact.email_address;
316: ben_ext_person.g_contact_known_as := contact.known_as;
317: ben_ext_person.g_contact_pre_name_adjunct := contact.pre_name_adjunct;
318: ben_ext_person.g_contact_tobacco_usage := contact.uses_tobacco_flag;

Line 315: ben_ext_person.g_contact_email_address := contact.email_address;

311: ben_ext_person.g_contact_student_status := contact.student_status;
312: ben_ext_person.g_contact_date_of_death := contact.date_of_death;
313: ben_ext_person.g_contact_language := contact.correspondence_language;
314: ben_ext_person.g_contact_nationality := contact.nationality;
315: ben_ext_person.g_contact_email_address := contact.email_address;
316: ben_ext_person.g_contact_known_as := contact.known_as;
317: ben_ext_person.g_contact_pre_name_adjunct := contact.pre_name_adjunct;
318: ben_ext_person.g_contact_tobacco_usage := contact.uses_tobacco_flag;
319: ben_ext_person.g_contact_prev_last_name := contact.previous_last_name;

Line 316: ben_ext_person.g_contact_known_as := contact.known_as;

312: ben_ext_person.g_contact_date_of_death := contact.date_of_death;
313: ben_ext_person.g_contact_language := contact.correspondence_language;
314: ben_ext_person.g_contact_nationality := contact.nationality;
315: ben_ext_person.g_contact_email_address := contact.email_address;
316: ben_ext_person.g_contact_known_as := contact.known_as;
317: ben_ext_person.g_contact_pre_name_adjunct := contact.pre_name_adjunct;
318: ben_ext_person.g_contact_tobacco_usage := contact.uses_tobacco_flag;
319: ben_ext_person.g_contact_prev_last_name := contact.previous_last_name;
320: ben_ext_person.g_contact_start_ler_id := contact.start_life_reason_id;

Line 317: ben_ext_person.g_contact_pre_name_adjunct := contact.pre_name_adjunct;

313: ben_ext_person.g_contact_language := contact.correspondence_language;
314: ben_ext_person.g_contact_nationality := contact.nationality;
315: ben_ext_person.g_contact_email_address := contact.email_address;
316: ben_ext_person.g_contact_known_as := contact.known_as;
317: ben_ext_person.g_contact_pre_name_adjunct := contact.pre_name_adjunct;
318: ben_ext_person.g_contact_tobacco_usage := contact.uses_tobacco_flag;
319: ben_ext_person.g_contact_prev_last_name := contact.previous_last_name;
320: ben_ext_person.g_contact_start_ler_id := contact.start_life_reason_id;
321: ben_ext_person.g_contact_end_ler_id := contact.end_life_reason_id;

Line 318: ben_ext_person.g_contact_tobacco_usage := contact.uses_tobacco_flag;

314: ben_ext_person.g_contact_nationality := contact.nationality;
315: ben_ext_person.g_contact_email_address := contact.email_address;
316: ben_ext_person.g_contact_known_as := contact.known_as;
317: ben_ext_person.g_contact_pre_name_adjunct := contact.pre_name_adjunct;
318: ben_ext_person.g_contact_tobacco_usage := contact.uses_tobacco_flag;
319: ben_ext_person.g_contact_prev_last_name := contact.previous_last_name;
320: ben_ext_person.g_contact_start_ler_id := contact.start_life_reason_id;
321: ben_ext_person.g_contact_end_ler_id := contact.end_life_reason_id;
322: --

Line 319: ben_ext_person.g_contact_prev_last_name := contact.previous_last_name;

315: ben_ext_person.g_contact_email_address := contact.email_address;
316: ben_ext_person.g_contact_known_as := contact.known_as;
317: ben_ext_person.g_contact_pre_name_adjunct := contact.pre_name_adjunct;
318: ben_ext_person.g_contact_tobacco_usage := contact.uses_tobacco_flag;
319: ben_ext_person.g_contact_prev_last_name := contact.previous_last_name;
320: ben_ext_person.g_contact_start_ler_id := contact.start_life_reason_id;
321: ben_ext_person.g_contact_end_ler_id := contact.end_life_reason_id;
322: --
323: -- retrieve dependent address info if required

Line 320: ben_ext_person.g_contact_start_ler_id := contact.start_life_reason_id;

316: ben_ext_person.g_contact_known_as := contact.known_as;
317: ben_ext_person.g_contact_pre_name_adjunct := contact.pre_name_adjunct;
318: ben_ext_person.g_contact_tobacco_usage := contact.uses_tobacco_flag;
319: ben_ext_person.g_contact_prev_last_name := contact.previous_last_name;
320: ben_ext_person.g_contact_start_ler_id := contact.start_life_reason_id;
321: ben_ext_person.g_contact_end_ler_id := contact.end_life_reason_id;
322: --
323: -- retrieve dependent address info if required
324: if ben_extract.g_coa_csr = 'Y' then

Line 321: ben_ext_person.g_contact_end_ler_id := contact.end_life_reason_id;

317: ben_ext_person.g_contact_pre_name_adjunct := contact.pre_name_adjunct;
318: ben_ext_person.g_contact_tobacco_usage := contact.uses_tobacco_flag;
319: ben_ext_person.g_contact_prev_last_name := contact.previous_last_name;
320: ben_ext_person.g_contact_start_ler_id := contact.start_life_reason_id;
321: ben_ext_person.g_contact_end_ler_id := contact.end_life_reason_id;
322: --
323: -- retrieve dependent address info if required
324: if ben_extract.g_coa_csr = 'Y' then
325: open prim_address_c (contact.contact_person_id);

Line 326: fetch prim_address_c into ben_ext_person.g_contact_prim_address1

322: --
323: -- retrieve dependent address info if required
324: if ben_extract.g_coa_csr = 'Y' then
325: open prim_address_c (contact.contact_person_id);
326: fetch prim_address_c into ben_ext_person.g_contact_prim_address1
327: ,ben_ext_person.g_contact_prim_address2
328: ,ben_ext_person.g_contact_prim_address3
329: ,ben_ext_person.g_contact_prim_city
330: ,ben_ext_person.g_contact_prim_state

Line 327: ,ben_ext_person.g_contact_prim_address2

323: -- retrieve dependent address info if required
324: if ben_extract.g_coa_csr = 'Y' then
325: open prim_address_c (contact.contact_person_id);
326: fetch prim_address_c into ben_ext_person.g_contact_prim_address1
327: ,ben_ext_person.g_contact_prim_address2
328: ,ben_ext_person.g_contact_prim_address3
329: ,ben_ext_person.g_contact_prim_city
330: ,ben_ext_person.g_contact_prim_state
331: ,ben_ext_person.g_contact_prim_postal_code

Line 328: ,ben_ext_person.g_contact_prim_address3

324: if ben_extract.g_coa_csr = 'Y' then
325: open prim_address_c (contact.contact_person_id);
326: fetch prim_address_c into ben_ext_person.g_contact_prim_address1
327: ,ben_ext_person.g_contact_prim_address2
328: ,ben_ext_person.g_contact_prim_address3
329: ,ben_ext_person.g_contact_prim_city
330: ,ben_ext_person.g_contact_prim_state
331: ,ben_ext_person.g_contact_prim_postal_code
332: ,ben_ext_person.g_contact_prim_country

Line 329: ,ben_ext_person.g_contact_prim_city

325: open prim_address_c (contact.contact_person_id);
326: fetch prim_address_c into ben_ext_person.g_contact_prim_address1
327: ,ben_ext_person.g_contact_prim_address2
328: ,ben_ext_person.g_contact_prim_address3
329: ,ben_ext_person.g_contact_prim_city
330: ,ben_ext_person.g_contact_prim_state
331: ,ben_ext_person.g_contact_prim_postal_code
332: ,ben_ext_person.g_contact_prim_country
333: ,ben_ext_person.g_contact_prim_effect_date

Line 330: ,ben_ext_person.g_contact_prim_state

326: fetch prim_address_c into ben_ext_person.g_contact_prim_address1
327: ,ben_ext_person.g_contact_prim_address2
328: ,ben_ext_person.g_contact_prim_address3
329: ,ben_ext_person.g_contact_prim_city
330: ,ben_ext_person.g_contact_prim_state
331: ,ben_ext_person.g_contact_prim_postal_code
332: ,ben_ext_person.g_contact_prim_country
333: ,ben_ext_person.g_contact_prim_effect_date
334: ,ben_ext_person.g_contact_prim_region;

Line 331: ,ben_ext_person.g_contact_prim_postal_code

327: ,ben_ext_person.g_contact_prim_address2
328: ,ben_ext_person.g_contact_prim_address3
329: ,ben_ext_person.g_contact_prim_city
330: ,ben_ext_person.g_contact_prim_state
331: ,ben_ext_person.g_contact_prim_postal_code
332: ,ben_ext_person.g_contact_prim_country
333: ,ben_ext_person.g_contact_prim_effect_date
334: ,ben_ext_person.g_contact_prim_region;
335: if prim_address_c%notfound then

Line 332: ,ben_ext_person.g_contact_prim_country

328: ,ben_ext_person.g_contact_prim_address3
329: ,ben_ext_person.g_contact_prim_city
330: ,ben_ext_person.g_contact_prim_state
331: ,ben_ext_person.g_contact_prim_postal_code
332: ,ben_ext_person.g_contact_prim_country
333: ,ben_ext_person.g_contact_prim_effect_date
334: ,ben_ext_person.g_contact_prim_region;
335: if prim_address_c%notfound then
336: open prim_rltd_address_c(contact.contact_person_id);

Line 333: ,ben_ext_person.g_contact_prim_effect_date

329: ,ben_ext_person.g_contact_prim_city
330: ,ben_ext_person.g_contact_prim_state
331: ,ben_ext_person.g_contact_prim_postal_code
332: ,ben_ext_person.g_contact_prim_country
333: ,ben_ext_person.g_contact_prim_effect_date
334: ,ben_ext_person.g_contact_prim_region;
335: if prim_address_c%notfound then
336: open prim_rltd_address_c(contact.contact_person_id);
337: fetch prim_rltd_address_c into ben_ext_person.g_contact_prim_address1

Line 334: ,ben_ext_person.g_contact_prim_region;

330: ,ben_ext_person.g_contact_prim_state
331: ,ben_ext_person.g_contact_prim_postal_code
332: ,ben_ext_person.g_contact_prim_country
333: ,ben_ext_person.g_contact_prim_effect_date
334: ,ben_ext_person.g_contact_prim_region;
335: if prim_address_c%notfound then
336: open prim_rltd_address_c(contact.contact_person_id);
337: fetch prim_rltd_address_c into ben_ext_person.g_contact_prim_address1
338: , ben_ext_person.g_contact_prim_address2

Line 337: fetch prim_rltd_address_c into ben_ext_person.g_contact_prim_address1

333: ,ben_ext_person.g_contact_prim_effect_date
334: ,ben_ext_person.g_contact_prim_region;
335: if prim_address_c%notfound then
336: open prim_rltd_address_c(contact.contact_person_id);
337: fetch prim_rltd_address_c into ben_ext_person.g_contact_prim_address1
338: , ben_ext_person.g_contact_prim_address2
339: , ben_ext_person.g_contact_prim_address3
340: , ben_ext_person.g_contact_prim_city
341: , ben_ext_person.g_contact_prim_state

Line 338: , ben_ext_person.g_contact_prim_address2

334: ,ben_ext_person.g_contact_prim_region;
335: if prim_address_c%notfound then
336: open prim_rltd_address_c(contact.contact_person_id);
337: fetch prim_rltd_address_c into ben_ext_person.g_contact_prim_address1
338: , ben_ext_person.g_contact_prim_address2
339: , ben_ext_person.g_contact_prim_address3
340: , ben_ext_person.g_contact_prim_city
341: , ben_ext_person.g_contact_prim_state
342: , ben_ext_person.g_contact_prim_postal_code

Line 339: , ben_ext_person.g_contact_prim_address3

335: if prim_address_c%notfound then
336: open prim_rltd_address_c(contact.contact_person_id);
337: fetch prim_rltd_address_c into ben_ext_person.g_contact_prim_address1
338: , ben_ext_person.g_contact_prim_address2
339: , ben_ext_person.g_contact_prim_address3
340: , ben_ext_person.g_contact_prim_city
341: , ben_ext_person.g_contact_prim_state
342: , ben_ext_person.g_contact_prim_postal_code
343: , ben_ext_person.g_contact_prim_country

Line 340: , ben_ext_person.g_contact_prim_city

336: open prim_rltd_address_c(contact.contact_person_id);
337: fetch prim_rltd_address_c into ben_ext_person.g_contact_prim_address1
338: , ben_ext_person.g_contact_prim_address2
339: , ben_ext_person.g_contact_prim_address3
340: , ben_ext_person.g_contact_prim_city
341: , ben_ext_person.g_contact_prim_state
342: , ben_ext_person.g_contact_prim_postal_code
343: , ben_ext_person.g_contact_prim_country
344: , ben_ext_person.g_contact_prim_effect_date

Line 341: , ben_ext_person.g_contact_prim_state

337: fetch prim_rltd_address_c into ben_ext_person.g_contact_prim_address1
338: , ben_ext_person.g_contact_prim_address2
339: , ben_ext_person.g_contact_prim_address3
340: , ben_ext_person.g_contact_prim_city
341: , ben_ext_person.g_contact_prim_state
342: , ben_ext_person.g_contact_prim_postal_code
343: , ben_ext_person.g_contact_prim_country
344: , ben_ext_person.g_contact_prim_effect_date
345: , ben_ext_person.g_contact_prim_region;

Line 342: , ben_ext_person.g_contact_prim_postal_code

338: , ben_ext_person.g_contact_prim_address2
339: , ben_ext_person.g_contact_prim_address3
340: , ben_ext_person.g_contact_prim_city
341: , ben_ext_person.g_contact_prim_state
342: , ben_ext_person.g_contact_prim_postal_code
343: , ben_ext_person.g_contact_prim_country
344: , ben_ext_person.g_contact_prim_effect_date
345: , ben_ext_person.g_contact_prim_region;
346: close prim_rltd_address_c;

Line 343: , ben_ext_person.g_contact_prim_country

339: , ben_ext_person.g_contact_prim_address3
340: , ben_ext_person.g_contact_prim_city
341: , ben_ext_person.g_contact_prim_state
342: , ben_ext_person.g_contact_prim_postal_code
343: , ben_ext_person.g_contact_prim_country
344: , ben_ext_person.g_contact_prim_effect_date
345: , ben_ext_person.g_contact_prim_region;
346: close prim_rltd_address_c;
347: end if;

Line 344: , ben_ext_person.g_contact_prim_effect_date

340: , ben_ext_person.g_contact_prim_city
341: , ben_ext_person.g_contact_prim_state
342: , ben_ext_person.g_contact_prim_postal_code
343: , ben_ext_person.g_contact_prim_country
344: , ben_ext_person.g_contact_prim_effect_date
345: , ben_ext_person.g_contact_prim_region;
346: close prim_rltd_address_c;
347: end if;
348: close prim_address_c;

Line 345: , ben_ext_person.g_contact_prim_region;

341: , ben_ext_person.g_contact_prim_state
342: , ben_ext_person.g_contact_prim_postal_code
343: , ben_ext_person.g_contact_prim_country
344: , ben_ext_person.g_contact_prim_effect_date
345: , ben_ext_person.g_contact_prim_region;
346: close prim_rltd_address_c;
347: end if;
348: close prim_address_c;
349: end if;

Line 354: fetch ext_phone_c into ben_ext_person.g_contact_home_phone

350: --
351: -- retrieve dependent phone numbers if required
352: if ben_extract.g_cop_csr = 'Y' then
353: open ext_phone_c(contact.contact_person_id);
354: fetch ext_phone_c into ben_ext_person.g_contact_home_phone
355: ,ben_ext_person.g_contact_work_phone
356: ,ben_ext_person.g_contact_fax
357: ,ben_ext_person.g_contact_mobile;
358: close ext_phone_c;

Line 355: ,ben_ext_person.g_contact_work_phone

351: -- retrieve dependent phone numbers if required
352: if ben_extract.g_cop_csr = 'Y' then
353: open ext_phone_c(contact.contact_person_id);
354: fetch ext_phone_c into ben_ext_person.g_contact_home_phone
355: ,ben_ext_person.g_contact_work_phone
356: ,ben_ext_person.g_contact_fax
357: ,ben_ext_person.g_contact_mobile;
358: close ext_phone_c;
359: end if;

Line 356: ,ben_ext_person.g_contact_fax

352: if ben_extract.g_cop_csr = 'Y' then
353: open ext_phone_c(contact.contact_person_id);
354: fetch ext_phone_c into ben_ext_person.g_contact_home_phone
355: ,ben_ext_person.g_contact_work_phone
356: ,ben_ext_person.g_contact_fax
357: ,ben_ext_person.g_contact_mobile;
358: close ext_phone_c;
359: end if;
360:

Line 357: ,ben_ext_person.g_contact_mobile;

353: open ext_phone_c(contact.contact_person_id);
354: fetch ext_phone_c into ben_ext_person.g_contact_home_phone
355: ,ben_ext_person.g_contact_work_phone
356: ,ben_ext_person.g_contact_fax
357: ,ben_ext_person.g_contact_mobile;
358: close ext_phone_c;
359: end if;
360:
361: -- retrieve eligible dependent flag

Line 363: ben_ext_person.g_contact_is_elig_dpnt_flag := 'N';

359: end if;
360:
361: -- retrieve eligible dependent flag
362: if ben_extract.g_coed_csr = 'Y' then
363: ben_ext_person.g_contact_is_elig_dpnt_flag := 'N';
364: open c_elig_dpnt(contact.contact_person_id);
365: fetch c_elig_dpnt into ben_ext_person.g_contact_is_elig_dpnt_flag;
366: close c_elig_dpnt;
367: end if;

Line 365: fetch c_elig_dpnt into ben_ext_person.g_contact_is_elig_dpnt_flag;

361: -- retrieve eligible dependent flag
362: if ben_extract.g_coed_csr = 'Y' then
363: ben_ext_person.g_contact_is_elig_dpnt_flag := 'N';
364: open c_elig_dpnt(contact.contact_person_id);
365: fetch c_elig_dpnt into ben_ext_person.g_contact_is_elig_dpnt_flag;
366: close c_elig_dpnt;
367: end if;
368:
369: -- retrieve covered dependent flag

Line 371: ben_ext_person.g_contact_is_cvrd_dpnt_flag := 'N';

367: end if;
368:
369: -- retrieve covered dependent flag
370: if ben_extract.g_cocd_csr = 'Y' then
371: ben_ext_person.g_contact_is_cvrd_dpnt_flag := 'N';
372: open c_cvrd_dpnt(contact.contact_person_id);
373: fetch c_cvrd_dpnt into ben_ext_person.g_contact_is_cvrd_dpnt_flag;
374: close c_cvrd_dpnt;
375: end if;

Line 373: fetch c_cvrd_dpnt into ben_ext_person.g_contact_is_cvrd_dpnt_flag;

369: -- retrieve covered dependent flag
370: if ben_extract.g_cocd_csr = 'Y' then
371: ben_ext_person.g_contact_is_cvrd_dpnt_flag := 'N';
372: open c_cvrd_dpnt(contact.contact_person_id);
373: fetch c_cvrd_dpnt into ben_ext_person.g_contact_is_cvrd_dpnt_flag;
374: close c_cvrd_dpnt;
375: end if;
376:
377: -- retrieve beneficiary flag

Line 379: ben_ext_person.g_contact_is_bnfcry_flag := 'N';

375: end if;
376:
377: -- retrieve beneficiary flag
378: if ben_extract.g_cob_csr = 'Y' then
379: ben_ext_person.g_contact_is_bnfcry_flag := 'N';
380: open c_beneficiary(contact.contact_person_id);
381: fetch c_beneficiary into ben_ext_person.g_contact_is_bnfcry_flag;
382: close c_beneficiary;
383: end if;

Line 381: fetch c_beneficiary into ben_ext_person.g_contact_is_bnfcry_flag;

377: -- retrieve beneficiary flag
378: if ben_extract.g_cob_csr = 'Y' then
379: ben_ext_person.g_contact_is_bnfcry_flag := 'N';
380: open c_beneficiary(contact.contact_person_id);
381: fetch c_beneficiary into ben_ext_person.g_contact_is_bnfcry_flag;
382: close c_beneficiary;
383: end if;
384: --
385: -- retrieve life reason start

Line 388: fetch c_start_ler into ben_ext_person.g_contact_start_life_evt;

384: --
385: -- retrieve life reason start
386: if ben_extract.g_cosl_csr = 'Y' then
387: open c_start_ler(contact.start_life_reason_id);
388: fetch c_start_ler into ben_ext_person.g_contact_start_life_evt;
389: close c_start_ler;
390: end if;
391: --
392: -- retrieve life reason end

Line 395: fetch c_end_ler into ben_ext_person.g_contact_end_life_evt;

391: --
392: -- retrieve life reason end
393: if ben_extract.g_coel_csr = 'Y' then
394: open c_end_ler(contact.end_life_reason_id);
395: fetch c_end_ler into ben_ext_person.g_contact_end_life_evt;
396: close c_end_ler;
397: end if;
398: -- format and write
399: --