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
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);