APPS.PER_CA_PERSON_ADDRESS_API dependencies on PER_ADDRESSES

Line 21: ,p_comments in per_addresses.comments%TYPE default null

17: ,p_primary_flag in varchar2
18: ,p_date_from in date
19: ,p_date_to in date default null
20: ,p_address_type in varchar2 default null
21: ,p_comments in per_addresses.comments%TYPE default null
22: ,p_address_line1 in varchar2
23: ,p_address_line2 in varchar2 default null
24: ,p_address_line3 in varchar2 default null
25: ,p_city in varchar2 default null

Line 135: ,p_comments in per_addresses.comments%TYPE default hr_api.g_varchar2

131: ,p_object_version_number in out nocopy number
132: ,p_date_from in date default hr_api.g_date
133: ,p_date_to in date default hr_api.g_date
134: ,p_address_type in varchar2 default hr_api.g_varchar2
135: ,p_comments in per_addresses.comments%TYPE default hr_api.g_varchar2
136: ,p_address_line1 in varchar2 default hr_api.g_varchar2
137: ,p_address_line2 in varchar2 default hr_api.g_varchar2
138: ,p_address_line3 in varchar2 default hr_api.g_varchar2
139: ,p_city in varchar2 default hr_api.g_varchar2

Line 176: l_style per_addresses.style%TYPE;

172: --
173: -- Declare cursors and local variables
174: --
175: l_proc varchar2(72) := g_package||'update_ca_person_address';
176: l_style per_addresses.style%TYPE;
177: --
178: cursor csr_add_style is
179: select addr.style
180: from per_addresses addr

Line 180: from per_addresses addr

176: l_style per_addresses.style%TYPE;
177: --
178: cursor csr_add_style is
179: select addr.style
180: from per_addresses addr
181: where addr.address_id = p_address_id;
182: --
183: begin
184: hr_utility.set_location('Entering:'|| l_proc, 5);