APPS.HR_PL_PERSON_ADDRESS_API dependencies on PER_ADDRESSES

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

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 -- bug 13375568
23: ,p_street_type in varchar2 default null
24: ,p_street_name in varchar2 default null
25: ,p_house_number in varchar2
26: ,p_flat_number in varchar2 default null

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

140: ,p_primary_flag in varchar2
141: ,p_date_from in date
142: ,p_date_to in date default null
143: ,p_address_type in varchar2 default null
144: ,p_comments in PER_ADDRESSES.COMMENTS%TYPE default null
145: ,p_street_type in varchar2 default null
146: ,p_street_name in varchar2 default null
147: ,p_house_number in varchar2
148: ,p_flat_number in varchar2 default null

Line 184: l_style per_addresses.style%TYPE;

180: --
181: -- Declare cursors and local variables
182: --
183: l_proc varchar2(72) ;
184: l_style per_addresses.style%TYPE;
185: --
186: cursor csr_add_style is
187: select addr.style
188: from per_addresses addr

Line 188: from per_addresses addr

184: l_style per_addresses.style%TYPE;
185: --
186: cursor csr_add_style is
187: select addr.style
188: from per_addresses addr
189: where addr.address_id = p_address_id;
190: --
191: BEGIN
192: l_proc := g_package||'update_pl_person_address';