62: --
63: l_proc varchar2(72) := g_package||'create_ca_person_address';
64: --
65: begin
66: hr_utility.set_location('Entering:'|| l_proc, 5);
67: --
68: -- Create Person Address details.
69: --
70: hr_person_address_api.create_person_address
116: ,p_address_id => p_address_id
117: ,p_object_version_number => p_object_version_number
118: );
119: --
120: hr_utility.set_location(' Leaving:'||l_proc, 10);
121: end create_ca_person_address;
122: --
123: -- ----------------------------------------------------------------------------
124: -- |-----------------------< update_ca_person_address >-----------------------|
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);
185: --
186: -- Check that the Address identified is CA style.
187: --
188: open csr_add_style;
191: if csr_add_style%notfound then
192: --
193: close csr_add_style;
194: --
195: hr_utility.set_location(l_proc, 7);
196: --
197: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
198: hr_utility.raise_error;
199: --
193: close csr_add_style;
194: --
195: hr_utility.set_location(l_proc, 7);
196: --
197: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
198: hr_utility.raise_error;
199: --
200: else
201: --
194: --
195: hr_utility.set_location(l_proc, 7);
196: --
197: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
198: hr_utility.raise_error;
199: --
200: else
201: --
202: close csr_add_style;
202: close csr_add_style;
203: --
204: if l_style <> 'CA' then
205: --
206: hr_utility.set_location(l_proc, 8);
207: --
208: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
209: hr_utility.raise_error;
210: --
204: if l_style <> 'CA' then
205: --
206: hr_utility.set_location(l_proc, 8);
207: --
208: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
209: hr_utility.raise_error;
210: --
211: end if;
212: end if;
205: --
206: hr_utility.set_location(l_proc, 8);
207: --
208: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
209: hr_utility.raise_error;
210: --
211: end if;
212: end if;
213: --
210: --
211: end if;
212: end if;
213: --
214: hr_utility.set_location(l_proc, 9);
215: --
216: -- Update Person Address details.
217: --
218: hr_person_address_api.update_person_address
260: ,p_add_information19 => p_add_information19
261: ,p_add_information20 => p_add_information20
262: );
263: --
264: hr_utility.set_location(' Leaving:'||l_proc, 11);
265: end update_ca_person_address;
266: --
267: end per_ca_person_address_api;