APPS.GHR_PA_REQUESTS_PKG dependencies on PER_ADDRESSES

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

193: --
194: PROCEDURE get_SF52_loc_ddf_details (p_location_id IN hr_locations.location_id%TYPE
195: ,p_duty_station_id OUT NOCOPY varchar2);
196: --
197: PROCEDURE get_address_details (p_person_id IN per_addresses.person_id%TYPE
198: ,p_effective_date IN DATE
199: ,p_address_line1 OUT NOCOPY per_addresses.address_line1%TYPE
200: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
201: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE

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

195: ,p_duty_station_id OUT NOCOPY varchar2);
196: --
197: PROCEDURE get_address_details (p_person_id IN per_addresses.person_id%TYPE
198: ,p_effective_date IN DATE
199: ,p_address_line1 OUT NOCOPY per_addresses.address_line1%TYPE
200: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
201: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
202: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
203: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE

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

196: --
197: PROCEDURE get_address_details (p_person_id IN per_addresses.person_id%TYPE
198: ,p_effective_date IN DATE
199: ,p_address_line1 OUT NOCOPY per_addresses.address_line1%TYPE
200: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
201: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
202: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
203: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE
204: ,p_postal_code OUT NOCOPY per_addresses.postal_code%TYPE

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

197: PROCEDURE get_address_details (p_person_id IN per_addresses.person_id%TYPE
198: ,p_effective_date IN DATE
199: ,p_address_line1 OUT NOCOPY per_addresses.address_line1%TYPE
200: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
201: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
202: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
203: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE
204: ,p_postal_code OUT NOCOPY per_addresses.postal_code%TYPE
205: ,p_country OUT NOCOPY per_addresses.country%TYPE

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

198: ,p_effective_date IN DATE
199: ,p_address_line1 OUT NOCOPY per_addresses.address_line1%TYPE
200: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
201: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
202: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
203: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE
204: ,p_postal_code OUT NOCOPY per_addresses.postal_code%TYPE
205: ,p_country OUT NOCOPY per_addresses.country%TYPE
206: ,p_territory_short_name OUT NOCOPY varchar2);

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

199: ,p_address_line1 OUT NOCOPY per_addresses.address_line1%TYPE
200: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
201: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
202: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
203: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE
204: ,p_postal_code OUT NOCOPY per_addresses.postal_code%TYPE
205: ,p_country OUT NOCOPY per_addresses.country%TYPE
206: ,p_territory_short_name OUT NOCOPY varchar2);
207: --

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

200: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
201: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
202: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
203: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE
204: ,p_postal_code OUT NOCOPY per_addresses.postal_code%TYPE
205: ,p_country OUT NOCOPY per_addresses.country%TYPE
206: ,p_territory_short_name OUT NOCOPY varchar2);
207: --
208: PROCEDURE get_SF52_to_data_elements

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

201: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
202: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
203: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE
204: ,p_postal_code OUT NOCOPY per_addresses.postal_code%TYPE
205: ,p_country OUT NOCOPY per_addresses.country%TYPE
206: ,p_territory_short_name OUT NOCOPY varchar2);
207: --
208: PROCEDURE get_SF52_to_data_elements
209: (p_position_id IN hr_all_positions_f.position_id%TYPE