81: ( p_assignment_action_id number)
82: return number;
83:
84: procedure get_home_address
85: (p_person_id in per_addresses.person_id%type,
86: p_address_line1 out nocopy per_addresses.address_line1%type,
87: p_address_line2 out nocopy per_addresses.address_line2%type,
88: p_address_line3 out nocopy per_addresses.address_line3%type,
89: p_town_city out nocopy per_addresses.town_or_city%type,
82: return number;
83:
84: procedure get_home_address
85: (p_person_id in per_addresses.person_id%type,
86: p_address_line1 out nocopy per_addresses.address_line1%type,
87: p_address_line2 out nocopy per_addresses.address_line2%type,
88: p_address_line3 out nocopy per_addresses.address_line3%type,
89: p_town_city out nocopy per_addresses.town_or_city%type,
90: p_postal_code out nocopy per_addresses.postal_code%type,
83:
84: procedure get_home_address
85: (p_person_id in per_addresses.person_id%type,
86: p_address_line1 out nocopy per_addresses.address_line1%type,
87: p_address_line2 out nocopy per_addresses.address_line2%type,
88: p_address_line3 out nocopy per_addresses.address_line3%type,
89: p_town_city out nocopy per_addresses.town_or_city%type,
90: p_postal_code out nocopy per_addresses.postal_code%type,
91: p_country_name out nocopy fnd_territories_tl.territory_short_name%type);
84: procedure get_home_address
85: (p_person_id in per_addresses.person_id%type,
86: p_address_line1 out nocopy per_addresses.address_line1%type,
87: p_address_line2 out nocopy per_addresses.address_line2%type,
88: p_address_line3 out nocopy per_addresses.address_line3%type,
89: p_town_city out nocopy per_addresses.town_or_city%type,
90: p_postal_code out nocopy per_addresses.postal_code%type,
91: p_country_name out nocopy fnd_territories_tl.territory_short_name%type);
92:
85: (p_person_id in per_addresses.person_id%type,
86: p_address_line1 out nocopy per_addresses.address_line1%type,
87: p_address_line2 out nocopy per_addresses.address_line2%type,
88: p_address_line3 out nocopy per_addresses.address_line3%type,
89: p_town_city out nocopy per_addresses.town_or_city%type,
90: p_postal_code out nocopy per_addresses.postal_code%type,
91: p_country_name out nocopy fnd_territories_tl.territory_short_name%type);
92:
93: procedure get_work_address
86: p_address_line1 out nocopy per_addresses.address_line1%type,
87: p_address_line2 out nocopy per_addresses.address_line2%type,
88: p_address_line3 out nocopy per_addresses.address_line3%type,
89: p_town_city out nocopy per_addresses.town_or_city%type,
90: p_postal_code out nocopy per_addresses.postal_code%type,
91: p_country_name out nocopy fnd_territories_tl.territory_short_name%type);
92:
93: procedure get_work_address
94: (p_location_id in hr_locations.location_id%type,