220: -- Declare cursors and local variables
221: --
222: g_package VARCHAR2(10);
223: l_proc VARCHAR2(72);
224: l_style per_addresses.style%TYPE;
225:
226: CURSOR c_add_style IS
227: SELECT addr.style
228: FROM per_addresses addr
224: l_style per_addresses.style%TYPE;
225:
226: CURSOR c_add_style IS
227: SELECT addr.style
228: FROM per_addresses addr
229: WHERE addr.address_id = p_address_id;
230:
231: BEGIN
232: l_proc := g_package||'update_IN_person_address';