APPS.HR_FR_PERSON_ADDRESS_API dependencies on PER_ADDRESSES

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

16: ,p_primary_flag in varchar2
17: ,p_date_from in date
18: ,p_date_to in date default null
19: ,p_address_type in varchar2 default null
20: ,p_comments in PER_ADDRESSES.COMMENTS%TYPE default null
21: ,p_address_line1 in varchar2
22: ,p_address_line2 in varchar2 default null
23: ,p_address_line3 in varchar2 default null
24: ,p_insee_code in varchar2 default null

Line 129: ,p_comments in PER_ADDRESSES.COMMENTS%TYPE default hr_api.g_varchar2

125: ,p_object_version_number in out nocopy number
126: ,p_date_from in date default hr_api.g_date
127: ,p_date_to in date default hr_api.g_date
128: ,p_address_type in varchar2 default hr_api.g_varchar2
129: ,p_comments in PER_ADDRESSES.COMMENTS%TYPE default hr_api.g_varchar2
130: ,p_address_line1 in varchar2
131: ,p_address_line2 in varchar2 default hr_api.g_varchar2
132: ,p_address_line3 in varchar2 default hr_api.g_varchar2
133: ,p_insee_code in varchar2 default hr_api.g_varchar2

Line 168: l_style per_addresses.style%TYPE;

164: --
165: -- Declare cursors and local variables
166: --
167: l_proc varchar2(72) := g_package||'update_fr_person_address';
168: l_style per_addresses.style%TYPE;
169: --
170: cursor csr_add_style is
171: select addr.style
172: from per_addresses addr

Line 172: from per_addresses addr

168: l_style per_addresses.style%TYPE;
169: --
170: cursor csr_add_style is
171: select addr.style
172: from per_addresses addr
173: where addr.address_id = p_address_id;
174: --
175: begin
176: hr_utility.set_location('Entering:'|| l_proc, 5);