APPS.GHR_PA_REQUESTS_PKG dependencies on PER_ADDRESSES

Line 149: PROCEDURE get_address_details (p_person_id IN per_addresses.person_id%TYPE

145: --
146: PROCEDURE get_SF52_loc_ddf_details (p_location_id IN hr_locations.location_id%TYPE
147: ,p_duty_station_id OUT NOCOPY varchar2);
148: --
149: PROCEDURE get_address_details (p_person_id IN per_addresses.person_id%TYPE
150: ,p_effective_date IN DATE
151: ,p_address_line1 OUT NOCOPY per_addresses.address_line1%TYPE
152: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
153: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE

Line 151: ,p_address_line1 OUT NOCOPY per_addresses.address_line1%TYPE

147: ,p_duty_station_id OUT NOCOPY varchar2);
148: --
149: PROCEDURE get_address_details (p_person_id IN per_addresses.person_id%TYPE
150: ,p_effective_date IN DATE
151: ,p_address_line1 OUT NOCOPY per_addresses.address_line1%TYPE
152: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
153: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
154: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
155: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE

Line 152: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE

148: --
149: PROCEDURE get_address_details (p_person_id IN per_addresses.person_id%TYPE
150: ,p_effective_date IN DATE
151: ,p_address_line1 OUT NOCOPY per_addresses.address_line1%TYPE
152: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
153: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
154: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
155: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE
156: ,p_postal_code OUT NOCOPY per_addresses.postal_code%TYPE

Line 153: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE

149: PROCEDURE get_address_details (p_person_id IN per_addresses.person_id%TYPE
150: ,p_effective_date IN DATE
151: ,p_address_line1 OUT NOCOPY per_addresses.address_line1%TYPE
152: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
153: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
154: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
155: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE
156: ,p_postal_code OUT NOCOPY per_addresses.postal_code%TYPE
157: ,p_country OUT NOCOPY per_addresses.country%TYPE

Line 154: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE

150: ,p_effective_date IN DATE
151: ,p_address_line1 OUT NOCOPY per_addresses.address_line1%TYPE
152: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
153: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
154: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
155: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE
156: ,p_postal_code OUT NOCOPY per_addresses.postal_code%TYPE
157: ,p_country OUT NOCOPY per_addresses.country%TYPE
158: ,p_territory_short_name OUT NOCOPY varchar2);

Line 155: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE

151: ,p_address_line1 OUT NOCOPY per_addresses.address_line1%TYPE
152: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
153: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
154: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
155: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE
156: ,p_postal_code OUT NOCOPY per_addresses.postal_code%TYPE
157: ,p_country OUT NOCOPY per_addresses.country%TYPE
158: ,p_territory_short_name OUT NOCOPY varchar2);
159: --

Line 156: ,p_postal_code OUT NOCOPY per_addresses.postal_code%TYPE

152: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
153: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
154: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
155: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE
156: ,p_postal_code OUT NOCOPY per_addresses.postal_code%TYPE
157: ,p_country OUT NOCOPY per_addresses.country%TYPE
158: ,p_territory_short_name OUT NOCOPY varchar2);
159: --
160: PROCEDURE get_SF52_to_data_elements

Line 157: ,p_country OUT NOCOPY per_addresses.country%TYPE

153: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
154: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
155: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE
156: ,p_postal_code OUT NOCOPY per_addresses.postal_code%TYPE
157: ,p_country OUT NOCOPY per_addresses.country%TYPE
158: ,p_territory_short_name OUT NOCOPY varchar2);
159: --
160: PROCEDURE get_SF52_to_data_elements
161: (p_position_id IN hr_all_positions_f.position_id%TYPE