APPS.HR_NZ_PERSON_ADDRESS_API dependencies on PER_ADDRESSES

Line 21: ,p_comments IN per_addresses.comments%TYPE DEFAULT NULL

17: ,p_primary_flag IN VARCHAR2
18: ,p_date_from IN DATE
19: ,p_date_to IN DATE DEFAULT NULL
20: ,p_address_type IN VARCHAR2 DEFAULT NULL
21: ,p_comments IN per_addresses.comments%TYPE DEFAULT NULL
22: ,p_address_line1 IN VARCHAR2
23: ,p_address_line2 IN VARCHAR2 DEFAULT NULL
24: ,p_address_line3 IN VARCHAR2 DEFAULT NULL
25: ,p_town_or_city IN VARCHAR2 DEFAULT NULL

Line 152: ,p_comments IN per_addresses.comments%TYPE DEFAULT hr_api.g_varchar2

148: ,p_date_from IN DATE DEFAULT hr_api.g_date
149: ,p_date_to IN DATE DEFAULT hr_api.g_date
150: ,p_primary_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
151: ,p_address_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
152: ,p_comments IN per_addresses.comments%TYPE DEFAULT hr_api.g_varchar2
153: ,p_address_line1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
154: ,p_address_line2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
155: ,p_address_line3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
156: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 200: l_style per_addresses.style%TYPE;

196: --
197: -- Declare cursors and local variables
198: --
199: l_proc VARCHAR2(72) := g_package||'update_nz_person_address';
200: l_style per_addresses.style%TYPE;
201: --
202: CURSOR csr_add_style IS
203: SELECT addr.style
204: FROM per_addresses addr

Line 204: FROM per_addresses addr

200: l_style per_addresses.style%TYPE;
201: --
202: CURSOR csr_add_style IS
203: SELECT addr.style
204: FROM per_addresses addr
205: WHERE addr.address_id = p_address_id;
206: --
207: BEGIN
208: hr_utility.set_location('Entering:'|| l_proc, 5);