230: --
231: TYPE person_name_address IS RECORD (
232: full_name per_all_people_f.full_name%type := NULL,
233: employee_number per_all_people_f.employee_number%type := NULL,
234: addr_line_1 per_addresses.address_line1%type := NULL,
235: addr_line_2 per_addresses.address_line2%type := NULL,
236: addr_line_3 per_addresses.address_line3%type := NULL,
237: city per_addresses.town_or_city%type := NULL,
238: province_state varchar2(240) := NULL,
231: TYPE person_name_address IS RECORD (
232: full_name per_all_people_f.full_name%type := NULL,
233: employee_number per_all_people_f.employee_number%type := NULL,
234: addr_line_1 per_addresses.address_line1%type := NULL,
235: addr_line_2 per_addresses.address_line2%type := NULL,
236: addr_line_3 per_addresses.address_line3%type := NULL,
237: city per_addresses.town_or_city%type := NULL,
238: province_state varchar2(240) := NULL,
239: postal_code varchar2(240) := NULL,
232: full_name per_all_people_f.full_name%type := NULL,
233: employee_number per_all_people_f.employee_number%type := NULL,
234: addr_line_1 per_addresses.address_line1%type := NULL,
235: addr_line_2 per_addresses.address_line2%type := NULL,
236: addr_line_3 per_addresses.address_line3%type := NULL,
237: city per_addresses.town_or_city%type := NULL,
238: province_state varchar2(240) := NULL,
239: postal_code varchar2(240) := NULL,
240: country varchar2(240) := NULL,
233: employee_number per_all_people_f.employee_number%type := NULL,
234: addr_line_1 per_addresses.address_line1%type := NULL,
235: addr_line_2 per_addresses.address_line2%type := NULL,
236: addr_line_3 per_addresses.address_line3%type := NULL,
237: city per_addresses.town_or_city%type := NULL,
238: province_state varchar2(240) := NULL,
239: postal_code varchar2(240) := NULL,
240: country varchar2(240) := NULL,
241: country_name varchar2(240) := NULL,
238: province_state varchar2(240) := NULL,
239: postal_code varchar2(240) := NULL,
240: country varchar2(240) := NULL,
241: country_name varchar2(240) := NULL,
242: region_1 per_addresses.region_1%type := NULL,
243: region_2 per_addresses.region_2%type := NULL,
244: valid_address varchar2(3) := 'N');
245: --
246: -- Function to get Person/Employee Address
239: postal_code varchar2(240) := NULL,
240: country varchar2(240) := NULL,
241: country_name varchar2(240) := NULL,
242: region_1 per_addresses.region_1%type := NULL,
243: region_2 per_addresses.region_2%type := NULL,
244: valid_address varchar2(3) := 'N');
245: --
246: -- Function to get Person/Employee Address
247: --