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_CHLG dependencies on PER_ADDRESSES

Line 60: g_prev_upd_adr_person_id per_addresses.person_id%type;

56:
57: */
58: --
59: g_package varchar2(80) := 'ben_ext_chlg';
60: g_prev_upd_adr_person_id per_addresses.person_id%type;
61: g_prev_upd_adr_primary_flag per_addresses.primary_flag%type;
62: g_prev_upd_adr_to_date per_addresses.date_to%type;
63: g_prev_upd_adr_address_line1 per_addresses.address_line1%type;
64: g_prev_upd_adr_address_line2 per_addresses.address_line2%type;

Line 61: g_prev_upd_adr_primary_flag per_addresses.primary_flag%type;

57: */
58: --
59: g_package varchar2(80) := 'ben_ext_chlg';
60: g_prev_upd_adr_person_id per_addresses.person_id%type;
61: g_prev_upd_adr_primary_flag per_addresses.primary_flag%type;
62: g_prev_upd_adr_to_date per_addresses.date_to%type;
63: g_prev_upd_adr_address_line1 per_addresses.address_line1%type;
64: g_prev_upd_adr_address_line2 per_addresses.address_line2%type;
65: g_prev_upd_adr_address_line3 per_addresses.address_line3%type;

Line 62: g_prev_upd_adr_to_date per_addresses.date_to%type;

58: --
59: g_package varchar2(80) := 'ben_ext_chlg';
60: g_prev_upd_adr_person_id per_addresses.person_id%type;
61: g_prev_upd_adr_primary_flag per_addresses.primary_flag%type;
62: g_prev_upd_adr_to_date per_addresses.date_to%type;
63: g_prev_upd_adr_address_line1 per_addresses.address_line1%type;
64: g_prev_upd_adr_address_line2 per_addresses.address_line2%type;
65: g_prev_upd_adr_address_line3 per_addresses.address_line3%type;
66: g_prev_upd_adr_country per_addresses.country%type;

Line 63: g_prev_upd_adr_address_line1 per_addresses.address_line1%type;

59: g_package varchar2(80) := 'ben_ext_chlg';
60: g_prev_upd_adr_person_id per_addresses.person_id%type;
61: g_prev_upd_adr_primary_flag per_addresses.primary_flag%type;
62: g_prev_upd_adr_to_date per_addresses.date_to%type;
63: g_prev_upd_adr_address_line1 per_addresses.address_line1%type;
64: g_prev_upd_adr_address_line2 per_addresses.address_line2%type;
65: g_prev_upd_adr_address_line3 per_addresses.address_line3%type;
66: g_prev_upd_adr_country per_addresses.country%type;
67: g_prev_upd_adr_postal_code per_addresses.postal_code%type;

Line 64: g_prev_upd_adr_address_line2 per_addresses.address_line2%type;

60: g_prev_upd_adr_person_id per_addresses.person_id%type;
61: g_prev_upd_adr_primary_flag per_addresses.primary_flag%type;
62: g_prev_upd_adr_to_date per_addresses.date_to%type;
63: g_prev_upd_adr_address_line1 per_addresses.address_line1%type;
64: g_prev_upd_adr_address_line2 per_addresses.address_line2%type;
65: g_prev_upd_adr_address_line3 per_addresses.address_line3%type;
66: g_prev_upd_adr_country per_addresses.country%type;
67: g_prev_upd_adr_postal_code per_addresses.postal_code%type;
68: g_prev_upd_adr_region_1 per_addresses.region_1%type;

Line 65: g_prev_upd_adr_address_line3 per_addresses.address_line3%type;

61: g_prev_upd_adr_primary_flag per_addresses.primary_flag%type;
62: g_prev_upd_adr_to_date per_addresses.date_to%type;
63: g_prev_upd_adr_address_line1 per_addresses.address_line1%type;
64: g_prev_upd_adr_address_line2 per_addresses.address_line2%type;
65: g_prev_upd_adr_address_line3 per_addresses.address_line3%type;
66: g_prev_upd_adr_country per_addresses.country%type;
67: g_prev_upd_adr_postal_code per_addresses.postal_code%type;
68: g_prev_upd_adr_region_1 per_addresses.region_1%type;
69: g_prev_upd_adr_region_2 per_addresses.region_2%type;

Line 66: g_prev_upd_adr_country per_addresses.country%type;

62: g_prev_upd_adr_to_date per_addresses.date_to%type;
63: g_prev_upd_adr_address_line1 per_addresses.address_line1%type;
64: g_prev_upd_adr_address_line2 per_addresses.address_line2%type;
65: g_prev_upd_adr_address_line3 per_addresses.address_line3%type;
66: g_prev_upd_adr_country per_addresses.country%type;
67: g_prev_upd_adr_postal_code per_addresses.postal_code%type;
68: g_prev_upd_adr_region_1 per_addresses.region_1%type;
69: g_prev_upd_adr_region_2 per_addresses.region_2%type;
70: g_prev_upd_adr_region_3 per_addresses.region_3%type;

Line 67: g_prev_upd_adr_postal_code per_addresses.postal_code%type;

63: g_prev_upd_adr_address_line1 per_addresses.address_line1%type;
64: g_prev_upd_adr_address_line2 per_addresses.address_line2%type;
65: g_prev_upd_adr_address_line3 per_addresses.address_line3%type;
66: g_prev_upd_adr_country per_addresses.country%type;
67: g_prev_upd_adr_postal_code per_addresses.postal_code%type;
68: g_prev_upd_adr_region_1 per_addresses.region_1%type;
69: g_prev_upd_adr_region_2 per_addresses.region_2%type;
70: g_prev_upd_adr_region_3 per_addresses.region_3%type;
71: g_prev_upd_adr_town_or_city per_addresses.town_or_city%type;

Line 68: g_prev_upd_adr_region_1 per_addresses.region_1%type;

64: g_prev_upd_adr_address_line2 per_addresses.address_line2%type;
65: g_prev_upd_adr_address_line3 per_addresses.address_line3%type;
66: g_prev_upd_adr_country per_addresses.country%type;
67: g_prev_upd_adr_postal_code per_addresses.postal_code%type;
68: g_prev_upd_adr_region_1 per_addresses.region_1%type;
69: g_prev_upd_adr_region_2 per_addresses.region_2%type;
70: g_prev_upd_adr_region_3 per_addresses.region_3%type;
71: g_prev_upd_adr_town_or_city per_addresses.town_or_city%type;
72: g_prev_upd_adr_address_id per_addresses.address_id%type;

Line 69: g_prev_upd_adr_region_2 per_addresses.region_2%type;

65: g_prev_upd_adr_address_line3 per_addresses.address_line3%type;
66: g_prev_upd_adr_country per_addresses.country%type;
67: g_prev_upd_adr_postal_code per_addresses.postal_code%type;
68: g_prev_upd_adr_region_1 per_addresses.region_1%type;
69: g_prev_upd_adr_region_2 per_addresses.region_2%type;
70: g_prev_upd_adr_region_3 per_addresses.region_3%type;
71: g_prev_upd_adr_town_or_city per_addresses.town_or_city%type;
72: g_prev_upd_adr_address_id per_addresses.address_id%type;
73: -- g_prev_upd_adr_last_update_login

Line 70: g_prev_upd_adr_region_3 per_addresses.region_3%type;

66: g_prev_upd_adr_country per_addresses.country%type;
67: g_prev_upd_adr_postal_code per_addresses.postal_code%type;
68: g_prev_upd_adr_region_1 per_addresses.region_1%type;
69: g_prev_upd_adr_region_2 per_addresses.region_2%type;
70: g_prev_upd_adr_region_3 per_addresses.region_3%type;
71: g_prev_upd_adr_town_or_city per_addresses.town_or_city%type;
72: g_prev_upd_adr_address_id per_addresses.address_id%type;
73: -- g_prev_upd_adr_last_update_login
74: --

Line 71: g_prev_upd_adr_town_or_city per_addresses.town_or_city%type;

67: g_prev_upd_adr_postal_code per_addresses.postal_code%type;
68: g_prev_upd_adr_region_1 per_addresses.region_1%type;
69: g_prev_upd_adr_region_2 per_addresses.region_2%type;
70: g_prev_upd_adr_region_3 per_addresses.region_3%type;
71: g_prev_upd_adr_town_or_city per_addresses.town_or_city%type;
72: g_prev_upd_adr_address_id per_addresses.address_id%type;
73: -- g_prev_upd_adr_last_update_login
74: --
75: Type g_per_rec_type is RECORD

Line 72: g_prev_upd_adr_address_id per_addresses.address_id%type;

68: g_prev_upd_adr_region_1 per_addresses.region_1%type;
69: g_prev_upd_adr_region_2 per_addresses.region_2%type;
70: g_prev_upd_adr_region_3 per_addresses.region_3%type;
71: g_prev_upd_adr_town_or_city per_addresses.town_or_city%type;
72: g_prev_upd_adr_address_id per_addresses.address_id%type;
73: -- g_prev_upd_adr_last_update_login
74: --
75: Type g_per_rec_type is RECORD
76: (national_identifier per_all_people_f.national_identifier%type

Line 156: (address_id per_addresses.address_id%type

152: ,date_start per_contact_relationships.date_start%TYPE
153: );
154: --
155: Type g_add_rec_type is RECORD
156: (address_id per_addresses.address_id%type
157: ,primary_flag per_addresses.primary_flag%type
158: ,person_id per_addresses.person_id%type
159: ,business_group_id per_addresses.business_group_id%type
160: ,address_line1 per_addresses.address_line1%type

Line 157: ,primary_flag per_addresses.primary_flag%type

153: );
154: --
155: Type g_add_rec_type is RECORD
156: (address_id per_addresses.address_id%type
157: ,primary_flag per_addresses.primary_flag%type
158: ,person_id per_addresses.person_id%type
159: ,business_group_id per_addresses.business_group_id%type
160: ,address_line1 per_addresses.address_line1%type
161: ,address_line2 per_addresses.address_line2%type

Line 158: ,person_id per_addresses.person_id%type

154: --
155: Type g_add_rec_type is RECORD
156: (address_id per_addresses.address_id%type
157: ,primary_flag per_addresses.primary_flag%type
158: ,person_id per_addresses.person_id%type
159: ,business_group_id per_addresses.business_group_id%type
160: ,address_line1 per_addresses.address_line1%type
161: ,address_line2 per_addresses.address_line2%type
162: ,address_line3 per_addresses.address_line3%type

Line 159: ,business_group_id per_addresses.business_group_id%type

155: Type g_add_rec_type is RECORD
156: (address_id per_addresses.address_id%type
157: ,primary_flag per_addresses.primary_flag%type
158: ,person_id per_addresses.person_id%type
159: ,business_group_id per_addresses.business_group_id%type
160: ,address_line1 per_addresses.address_line1%type
161: ,address_line2 per_addresses.address_line2%type
162: ,address_line3 per_addresses.address_line3%type
163: ,country per_addresses.country%type

Line 160: ,address_line1 per_addresses.address_line1%type

156: (address_id per_addresses.address_id%type
157: ,primary_flag per_addresses.primary_flag%type
158: ,person_id per_addresses.person_id%type
159: ,business_group_id per_addresses.business_group_id%type
160: ,address_line1 per_addresses.address_line1%type
161: ,address_line2 per_addresses.address_line2%type
162: ,address_line3 per_addresses.address_line3%type
163: ,country per_addresses.country%type
164: ,postal_code per_addresses.postal_code%type

Line 161: ,address_line2 per_addresses.address_line2%type

157: ,primary_flag per_addresses.primary_flag%type
158: ,person_id per_addresses.person_id%type
159: ,business_group_id per_addresses.business_group_id%type
160: ,address_line1 per_addresses.address_line1%type
161: ,address_line2 per_addresses.address_line2%type
162: ,address_line3 per_addresses.address_line3%type
163: ,country per_addresses.country%type
164: ,postal_code per_addresses.postal_code%type
165: ,region_1 per_addresses.region_1%type

Line 162: ,address_line3 per_addresses.address_line3%type

158: ,person_id per_addresses.person_id%type
159: ,business_group_id per_addresses.business_group_id%type
160: ,address_line1 per_addresses.address_line1%type
161: ,address_line2 per_addresses.address_line2%type
162: ,address_line3 per_addresses.address_line3%type
163: ,country per_addresses.country%type
164: ,postal_code per_addresses.postal_code%type
165: ,region_1 per_addresses.region_1%type
166: ,region_2 per_addresses.region_2%type

Line 163: ,country per_addresses.country%type

159: ,business_group_id per_addresses.business_group_id%type
160: ,address_line1 per_addresses.address_line1%type
161: ,address_line2 per_addresses.address_line2%type
162: ,address_line3 per_addresses.address_line3%type
163: ,country per_addresses.country%type
164: ,postal_code per_addresses.postal_code%type
165: ,region_1 per_addresses.region_1%type
166: ,region_2 per_addresses.region_2%type
167: ,region_3 per_addresses.region_3%type

Line 164: ,postal_code per_addresses.postal_code%type

160: ,address_line1 per_addresses.address_line1%type
161: ,address_line2 per_addresses.address_line2%type
162: ,address_line3 per_addresses.address_line3%type
163: ,country per_addresses.country%type
164: ,postal_code per_addresses.postal_code%type
165: ,region_1 per_addresses.region_1%type
166: ,region_2 per_addresses.region_2%type
167: ,region_3 per_addresses.region_3%type
168: ,town_or_city per_addresses.town_or_city%type

Line 165: ,region_1 per_addresses.region_1%type

161: ,address_line2 per_addresses.address_line2%type
162: ,address_line3 per_addresses.address_line3%type
163: ,country per_addresses.country%type
164: ,postal_code per_addresses.postal_code%type
165: ,region_1 per_addresses.region_1%type
166: ,region_2 per_addresses.region_2%type
167: ,region_3 per_addresses.region_3%type
168: ,town_or_city per_addresses.town_or_city%type
169: ,address_type per_addresses.address_type%type

Line 166: ,region_2 per_addresses.region_2%type

162: ,address_line3 per_addresses.address_line3%type
163: ,country per_addresses.country%type
164: ,postal_code per_addresses.postal_code%type
165: ,region_1 per_addresses.region_1%type
166: ,region_2 per_addresses.region_2%type
167: ,region_3 per_addresses.region_3%type
168: ,town_or_city per_addresses.town_or_city%type
169: ,address_type per_addresses.address_type%type
170: ,date_from per_addresses.date_from%type

Line 167: ,region_3 per_addresses.region_3%type

163: ,country per_addresses.country%type
164: ,postal_code per_addresses.postal_code%type
165: ,region_1 per_addresses.region_1%type
166: ,region_2 per_addresses.region_2%type
167: ,region_3 per_addresses.region_3%type
168: ,town_or_city per_addresses.town_or_city%type
169: ,address_type per_addresses.address_type%type
170: ,date_from per_addresses.date_from%type
171: ,date_to per_addresses.date_to%type

Line 168: ,town_or_city per_addresses.town_or_city%type

164: ,postal_code per_addresses.postal_code%type
165: ,region_1 per_addresses.region_1%type
166: ,region_2 per_addresses.region_2%type
167: ,region_3 per_addresses.region_3%type
168: ,town_or_city per_addresses.town_or_city%type
169: ,address_type per_addresses.address_type%type
170: ,date_from per_addresses.date_from%type
171: ,date_to per_addresses.date_to%type
172: );

Line 169: ,address_type per_addresses.address_type%type

165: ,region_1 per_addresses.region_1%type
166: ,region_2 per_addresses.region_2%type
167: ,region_3 per_addresses.region_3%type
168: ,town_or_city per_addresses.town_or_city%type
169: ,address_type per_addresses.address_type%type
170: ,date_from per_addresses.date_from%type
171: ,date_to per_addresses.date_to%type
172: );
173: --

Line 170: ,date_from per_addresses.date_from%type

166: ,region_2 per_addresses.region_2%type
167: ,region_3 per_addresses.region_3%type
168: ,town_or_city per_addresses.town_or_city%type
169: ,address_type per_addresses.address_type%type
170: ,date_from per_addresses.date_from%type
171: ,date_to per_addresses.date_to%type
172: );
173: --
174: Type g_asg_rec_type is RECORD

Line 171: ,date_to per_addresses.date_to%type

167: ,region_3 per_addresses.region_3%type
168: ,town_or_city per_addresses.town_or_city%type
169: ,address_type per_addresses.address_type%type
170: ,date_from per_addresses.date_from%type
171: ,date_to per_addresses.date_to%type
172: );
173: --
174: Type g_asg_rec_type is RECORD
175: (assignment_id per_all_assignments_f.assignment_id%type