DBA Data[Home] [Help]

APPS.PAY_AU_SOE_PKG dependencies on PER_ADDRESSES

Line 5: (p_person_id in per_addresses.person_id%type,

1: package pay_au_soe_pkg AUTHID CURRENT_USER as
2: /* $Header: pyausoe.pkh 120.11.12020000.2 2012/12/21 07:54:49 ruihuang ship $ */
3:
4: procedure get_home_address
5: (p_person_id in per_addresses.person_id%type,
6: p_address_line1 out NOCOPY per_addresses.address_line1%type,
7: p_address_line2 out NOCOPY per_addresses.address_line2%type,
8: p_address_line3 out NOCOPY per_addresses.address_line3%type,
9: p_town_city out NOCOPY per_addresses.town_or_city%type,

Line 6: p_address_line1 out NOCOPY per_addresses.address_line1%type,

2: /* $Header: pyausoe.pkh 120.11.12020000.2 2012/12/21 07:54:49 ruihuang ship $ */
3:
4: procedure get_home_address
5: (p_person_id in per_addresses.person_id%type,
6: p_address_line1 out NOCOPY per_addresses.address_line1%type,
7: p_address_line2 out NOCOPY per_addresses.address_line2%type,
8: p_address_line3 out NOCOPY per_addresses.address_line3%type,
9: p_town_city out NOCOPY per_addresses.town_or_city%type,
10: p_postal_code out NOCOPY per_addresses.postal_code%type,

Line 7: p_address_line2 out NOCOPY per_addresses.address_line2%type,

3:
4: procedure get_home_address
5: (p_person_id in per_addresses.person_id%type,
6: p_address_line1 out NOCOPY per_addresses.address_line1%type,
7: p_address_line2 out NOCOPY per_addresses.address_line2%type,
8: p_address_line3 out NOCOPY per_addresses.address_line3%type,
9: p_town_city out NOCOPY per_addresses.town_or_city%type,
10: p_postal_code out NOCOPY per_addresses.postal_code%type,
11: p_country_name out NOCOPY fnd_territories_tl.territory_short_name%type);

Line 8: p_address_line3 out NOCOPY per_addresses.address_line3%type,

4: procedure get_home_address
5: (p_person_id in per_addresses.person_id%type,
6: p_address_line1 out NOCOPY per_addresses.address_line1%type,
7: p_address_line2 out NOCOPY per_addresses.address_line2%type,
8: p_address_line3 out NOCOPY per_addresses.address_line3%type,
9: p_town_city out NOCOPY per_addresses.town_or_city%type,
10: p_postal_code out NOCOPY per_addresses.postal_code%type,
11: p_country_name out NOCOPY fnd_territories_tl.territory_short_name%type);
12:

Line 9: p_town_city out NOCOPY per_addresses.town_or_city%type,

5: (p_person_id in per_addresses.person_id%type,
6: p_address_line1 out NOCOPY per_addresses.address_line1%type,
7: p_address_line2 out NOCOPY per_addresses.address_line2%type,
8: p_address_line3 out NOCOPY per_addresses.address_line3%type,
9: p_town_city out NOCOPY per_addresses.town_or_city%type,
10: p_postal_code out NOCOPY per_addresses.postal_code%type,
11: p_country_name out NOCOPY fnd_territories_tl.territory_short_name%type);
12:
13: procedure get_work_address

Line 10: p_postal_code out NOCOPY per_addresses.postal_code%type,

6: p_address_line1 out NOCOPY per_addresses.address_line1%type,
7: p_address_line2 out NOCOPY per_addresses.address_line2%type,
8: p_address_line3 out NOCOPY per_addresses.address_line3%type,
9: p_town_city out NOCOPY per_addresses.town_or_city%type,
10: p_postal_code out NOCOPY per_addresses.postal_code%type,
11: p_country_name out NOCOPY fnd_territories_tl.territory_short_name%type);
12:
13: procedure get_work_address
14: (p_location_id in hr_locations.location_id%type,