APPS.HR_AE_PERSON_ADDRESS_API dependencies on PER_ADDRESSES

Line 22: ,p_comments in PER_ADDRESSES.COMMENTS%TYPE default null

18: ,p_primary_flag in varchar2
19: ,p_date_from in date
20: ,p_date_to in date default null
21: ,p_address_type in varchar2 default null
22: ,p_comments in PER_ADDRESSES.COMMENTS%TYPE default null
23: ,p_address_line1 in varchar2
24: ,p_address_line2 in varchar2 default null
25: ,p_emirate in varchar2
26: ,p_city_village in varchar2 default null

Line 140: ,p_comments in PER_ADDRESSES.COMMENTS%TYPE default null

136: ,p_primary_flag in varchar2
137: ,p_date_from in date
138: ,p_date_to in date default null
139: ,p_address_type in varchar2 default null
140: ,p_comments in PER_ADDRESSES.COMMENTS%TYPE default null
141: ,p_address_line1 in varchar2
142: ,p_address_line2 in varchar2 default null
143: ,p_emirate in varchar2
144: ,p_city_village in varchar2 default null

Line 178: l_style per_addresses.style%TYPE;

174: --
175: -- Declare cursors and local variables
176: --
177: l_proc varchar2(72) ;
178: l_style per_addresses.style%TYPE;
179: --
180: cursor csr_add_style is
181: select addr.style
182: from per_addresses addr

Line 182: from per_addresses addr

178: l_style per_addresses.style%TYPE;
179: --
180: cursor csr_add_style is
181: select addr.style
182: from per_addresses addr
183: where addr.address_id = p_address_id;
184: --
185: BEGIN
186: l_proc := g_package||'update_ae_person_address';