[Home] [Help]
PACKAGE BODY: APPS.HR_KIOSK_ADDRESS_API
Source
1 Package Body hr_kiosk_address_api as
2 /* $Header: pekadapi.pkb 115.2 2003/02/11 10:48:43 pkakar ship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' hr_kiosk_address_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_person_address >-------------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_person_address
13 (p_validate in boolean default false
14 ,p_effective_date in date
15 ,p_person_id in number
16 ,p_primary_flag in varchar2
17 ,p_style 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 long default null
22 ,p_address_line1 in varchar2 default null
23 ,p_address_line2 in varchar2 default null
24 ,p_address_line3 in varchar2 default null
25 ,p_town_or_city in varchar2 default null
26 ,p_region_1 in varchar2 default null
27 ,p_region_2 in varchar2 default null
28 ,p_region_3 in varchar2 default null
29 ,p_postal_code in varchar2 default null
30 ,p_country in varchar2 default null
31 ,p_telephone_number_1 in varchar2 default null
32 ,p_telephone_number_2 in varchar2 default null
33 ,p_telephone_number_3 in varchar2 default null
34 ,p_addr_attribute_category in varchar2 default null
35 ,p_addr_attribute1 in varchar2 default null
36 ,p_addr_attribute2 in varchar2 default null
37 ,p_addr_attribute3 in varchar2 default null
38 ,p_addr_attribute4 in varchar2 default null
39 ,p_addr_attribute5 in varchar2 default null
40 ,p_addr_attribute6 in varchar2 default null
41 ,p_addr_attribute7 in varchar2 default null
42 ,p_addr_attribute8 in varchar2 default null
43 ,p_addr_attribute9 in varchar2 default null
44 ,p_addr_attribute10 in varchar2 default null
45 ,p_addr_attribute11 in varchar2 default null
46 ,p_addr_attribute12 in varchar2 default null
47 ,p_addr_attribute13 in varchar2 default null
48 ,p_addr_attribute14 in varchar2 default null
49 ,p_addr_attribute15 in varchar2 default null
50 ,p_addr_attribute16 in varchar2 default null
51 ,p_addr_attribute17 in varchar2 default null
52 ,p_addr_attribute18 in varchar2 default null
53 ,p_addr_attribute19 in varchar2 default null
54 ,p_addr_attribute20 in varchar2 default null
55 ,p_address_id out nocopy number
56 ,p_object_version_number out nocopy number
57 ) is
58 --
59 -- Declare cursors and local variables
60 --
61 l_business_group_id per_addresses.business_group_id%TYPE;
62 l_date_from per_addresses.date_from%TYPE;
63 l_proc varchar2(72) := g_package||'create_person_address';
64 --
65 cursor csr_bus_grp is
66 select per.business_group_id
67 from per_people_f per
68 where per.person_id = p_person_id
69 and l_date_from between per.effective_start_date
70 and per.effective_end_date;
71 --
72 begin
73 hr_utility.set_location('Entering:'|| l_proc, 5);
74 --
75 -- Issue a savepoint if operating in validation only mode.
76 --
77 if p_validate then
78 savepoint create_person_address;
79 end if;
80 --
81 -- Check that p_person_id, p_date_from are not null as they are used in the
82 -- cursor.
83 --
84 hr_api.mandatory_arg_error
85 (p_api_name => l_proc,
86 p_argument => 'person_id',
87 p_argument_value => p_person_id);
88 --
89 hr_api.mandatory_arg_error
90 (p_api_name => l_proc,
91 p_argument => 'date_from',
92 p_argument_value => p_date_from);
93 --
94 hr_utility.set_location(l_proc, 6);
95 --
96 l_date_from := trunc(p_date_from);
97 --
98 -- Get business_group_id using person_id.
99 --
100 open csr_bus_grp;
101 fetch csr_bus_grp
102 into l_business_group_id;
103 --
104 if csr_bus_grp%notfound then
105 close csr_bus_grp;
106 hr_utility.set_message(801, 'HR_7298_ADD_PERSON_INVALID');
107 hr_utility.raise_error;
108 end if;
109 --
110 close csr_bus_grp;
111 --
112 hr_utility.set_location(l_proc, 7);
113 --
114 -- Insert Person Address details.
115 --
116 per_kad_ins.ins
117 (p_address_id => p_address_id
118 ,p_business_group_id => l_business_group_id
119 ,p_person_id => p_person_id
120 ,p_date_from => l_date_from
121 ,p_primary_flag => p_primary_flag
122 ,p_style => p_style
123 ,p_address_line1 => p_address_line1
124 ,p_address_line2 => p_address_line2
125 ,p_address_line3 => p_address_line3
126 ,p_address_type => p_address_type
127 ,p_comments => p_comments
128 ,p_country => p_country
129 ,p_date_to => trunc(p_date_to)
130 ,p_postal_code => p_postal_code
131 ,p_region_1 => p_region_1
132 ,p_region_2 => p_region_2
133 ,p_region_3 => p_region_3
134 ,p_telephone_number_1 => p_telephone_number_1
135 ,p_telephone_number_2 => p_telephone_number_2
136 ,p_telephone_number_3 => p_telephone_number_3
137 ,p_town_or_city => p_town_or_city
138 ,p_addr_attribute_category => p_addr_attribute_category
139 ,p_addr_attribute1 => p_addr_attribute1
140 ,p_addr_attribute2 => p_addr_attribute2
141 ,p_addr_attribute3 => p_addr_attribute3
142 ,p_addr_attribute4 => p_addr_attribute4
143 ,p_addr_attribute5 => p_addr_attribute5
144 ,p_addr_attribute6 => p_addr_attribute6
145 ,p_addr_attribute7 => p_addr_attribute7
146 ,p_addr_attribute8 => p_addr_attribute8
147 ,p_addr_attribute9 => p_addr_attribute9
148 ,p_addr_attribute10 => p_addr_attribute10
149 ,p_addr_attribute11 => p_addr_attribute11
150 ,p_addr_attribute12 => p_addr_attribute12
151 ,p_addr_attribute13 => p_addr_attribute13
152 ,p_addr_attribute14 => p_addr_attribute14
153 ,p_addr_attribute15 => p_addr_attribute15
154 ,p_addr_attribute16 => p_addr_attribute16
155 ,p_addr_attribute17 => p_addr_attribute17
156 ,p_addr_attribute18 => p_addr_attribute18
157 ,p_addr_attribute19 => p_addr_attribute19
158 ,p_addr_attribute20 => p_addr_attribute20
159 ,p_object_version_number => p_object_version_number
160 ,p_validate => FALSE
161 ,p_effective_date => p_effective_date
162 );
163 --
164 hr_utility.set_location(l_proc, 8);
165 --
166 -- When in validation only mode raise the Validate_Enabled exception
167 --
168 if p_validate then
169 raise hr_api.validate_enabled;
170 end if;
171 --
172 hr_utility.set_location(' Leaving:'||l_proc, 11);
173 exception
174 when hr_api.validate_enabled then
175 --
176 -- As the Validate_Enabled exception has been raised
177 -- we must rollback to the savepoint
178 --
179 ROLLBACK TO create_person_address;
180 --
181 -- Only set output warning arguments
182 -- (Any key or derived arguments must be set to null
183 -- when validation only mode is being used.)
184 --
185 p_address_id := null;
186 p_object_version_number := null;
187 end create_person_address;
188 --
189 -- ----------------------------------------------------------------------------
190 -- |-----------------------< create_gb_person_address >-----------------------|
191 -- ----------------------------------------------------------------------------
192 --
193 procedure create_gb_person_address
194 (p_validate in boolean default false
195 ,p_effective_date in date
196 ,p_person_id in number
197 ,p_primary_flag in varchar2
198 ,p_date_from in date
199 ,p_date_to in date default null
200 ,p_address_type in varchar2 default null
201 ,p_comments in long default null
202 ,p_address_line1 in varchar2
203 ,p_address_line2 in varchar2 default null
204 ,p_address_line3 in varchar2 default null
205 ,p_town in varchar2 default null
206 ,p_county in varchar2 default null
207 ,p_postcode in varchar2 default null
208 ,p_country in varchar2
209 ,p_telephone_number in varchar2 default null
210 ,p_addr_attribute_category in varchar2 default null
211 ,p_addr_attribute1 in varchar2 default null
212 ,p_addr_attribute2 in varchar2 default null
213 ,p_addr_attribute3 in varchar2 default null
214 ,p_addr_attribute4 in varchar2 default null
215 ,p_addr_attribute5 in varchar2 default null
216 ,p_addr_attribute6 in varchar2 default null
217 ,p_addr_attribute7 in varchar2 default null
218 ,p_addr_attribute8 in varchar2 default null
219 ,p_addr_attribute9 in varchar2 default null
220 ,p_addr_attribute10 in varchar2 default null
221 ,p_addr_attribute11 in varchar2 default null
222 ,p_addr_attribute12 in varchar2 default null
223 ,p_addr_attribute13 in varchar2 default null
224 ,p_addr_attribute14 in varchar2 default null
225 ,p_addr_attribute15 in varchar2 default null
226 ,p_addr_attribute16 in varchar2 default null
227 ,p_addr_attribute17 in varchar2 default null
228 ,p_addr_attribute18 in varchar2 default null
229 ,p_addr_attribute19 in varchar2 default null
230 ,p_addr_attribute20 in varchar2 default null
231 ,p_address_id out nocopy number
232 ,p_object_version_number out nocopy number
233 ) is
234 --
235 -- Declare cursors and local variables
236 --
237 l_proc varchar2(72) := g_package||'create_gb_person_address';
238 --
239 begin
240 hr_utility.set_location('Entering:'|| l_proc, 5);
241 --
242 -- Create Person Address details.
243 --
244 hr_kiosk_address_api.create_person_address
245 (p_validate => p_validate
246 ,p_effective_date => p_effective_date
247 ,p_person_id => p_person_id
248 ,p_primary_flag => p_primary_flag
249 ,p_style => 'GB'
250 ,p_date_from => p_date_from
251 ,p_date_to => p_date_to
252 ,p_address_type => p_address_type
253 ,p_comments => p_comments
254 ,p_address_line1 => p_address_line1
255 ,p_address_line2 => p_address_line2
256 ,p_address_line3 => p_address_line3
257 ,p_town_or_city => p_town
258 ,p_region_1 => p_county
259 ,p_postal_code => p_postcode
260 ,p_country => p_country
261 ,p_telephone_number_1 => p_telephone_number
262 ,p_addr_attribute_category => p_addr_attribute_category
263 ,p_addr_attribute1 => p_addr_attribute1
264 ,p_addr_attribute2 => p_addr_attribute2
265 ,p_addr_attribute3 => p_addr_attribute3
266 ,p_addr_attribute4 => p_addr_attribute4
267 ,p_addr_attribute5 => p_addr_attribute5
268 ,p_addr_attribute6 => p_addr_attribute6
269 ,p_addr_attribute7 => p_addr_attribute7
270 ,p_addr_attribute8 => p_addr_attribute8
271 ,p_addr_attribute9 => p_addr_attribute9
272 ,p_addr_attribute10 => p_addr_attribute10
273 ,p_addr_attribute11 => p_addr_attribute11
274 ,p_addr_attribute12 => p_addr_attribute12
275 ,p_addr_attribute13 => p_addr_attribute13
276 ,p_addr_attribute14 => p_addr_attribute14
277 ,p_addr_attribute15 => p_addr_attribute15
278 ,p_addr_attribute16 => p_addr_attribute16
279 ,p_addr_attribute17 => p_addr_attribute17
280 ,p_addr_attribute18 => p_addr_attribute18
281 ,p_addr_attribute19 => p_addr_attribute19
282 ,p_addr_attribute20 => p_addr_attribute20
283 ,p_address_id => p_address_id
284 ,p_object_version_number => p_object_version_number
285 );
286 --
287 hr_utility.set_location(' Leaving:'||l_proc, 10);
288 end create_gb_person_address;
289 --
290 -- ----------------------------------------------------------------------------
291 -- |-----------------------< create_us_person_address >-----------------------|
292 -- ----------------------------------------------------------------------------
293 --
294 procedure create_us_person_address
295 (p_validate in boolean default false
296 ,p_effective_date in date
297 ,p_person_id in number
298 ,p_primary_flag in varchar2
299 ,p_date_from in date
300 ,p_date_to in date default null
301 ,p_address_type in varchar2 default null
302 ,p_comments in long default null
303 ,p_address_line1 in varchar2
304 ,p_address_line2 in varchar2 default null
305 ,p_address_line3 in varchar2 default null
306 ,p_city in varchar2 default null
307 ,p_state in varchar2 default null
308 ,p_zip_code in varchar2 default null
309 ,p_county in varchar2 default null
310 ,p_country in varchar2
311 ,p_telephone_number_1 in varchar2 default null
312 ,p_telephone_number_2 in varchar2 default null
313 ,p_addr_attribute_category in varchar2 default null
314 ,p_addr_attribute1 in varchar2 default null
315 ,p_addr_attribute2 in varchar2 default null
316 ,p_addr_attribute3 in varchar2 default null
317 ,p_addr_attribute4 in varchar2 default null
318 ,p_addr_attribute5 in varchar2 default null
319 ,p_addr_attribute6 in varchar2 default null
320 ,p_addr_attribute7 in varchar2 default null
321 ,p_addr_attribute8 in varchar2 default null
322 ,p_addr_attribute9 in varchar2 default null
323 ,p_addr_attribute10 in varchar2 default null
324 ,p_addr_attribute11 in varchar2 default null
325 ,p_addr_attribute12 in varchar2 default null
326 ,p_addr_attribute13 in varchar2 default null
327 ,p_addr_attribute14 in varchar2 default null
328 ,p_addr_attribute15 in varchar2 default null
329 ,p_addr_attribute16 in varchar2 default null
330 ,p_addr_attribute17 in varchar2 default null
331 ,p_addr_attribute18 in varchar2 default null
332 ,p_addr_attribute19 in varchar2 default null
333 ,p_addr_attribute20 in varchar2 default null
334 ,p_address_id out nocopy number
335 ,p_object_version_number out nocopy number
336 ) is
337 --
338 -- Declare cursors and local variables
339 --
340 l_proc varchar2(72) := g_package||'create_us_person_address';
341 --
342 begin
343 hr_utility.set_location('Entering:'|| l_proc, 5);
344 --
345 -- Create Person Address details.
346 --
347 hr_kiosk_address_api.create_person_address
348 (p_validate => p_validate
349 ,p_effective_date => p_effective_date
350 ,p_person_id => p_person_id
351 ,p_primary_flag => p_primary_flag
352 ,p_style => 'US'
353 ,p_date_from => p_date_from
354 ,p_date_to => p_date_to
355 ,p_address_type => p_address_type
356 ,p_comments => p_comments
357 ,p_address_line1 => p_address_line1
358 ,p_address_line2 => p_address_line2
359 ,p_address_line3 => p_address_line3
360 ,p_town_or_city => p_city
361 ,p_region_1 => p_county
362 ,p_region_2 => p_state
363 ,p_postal_code => p_zip_code
364 ,p_country => p_country
365 ,p_telephone_number_1 => p_telephone_number_1
366 ,p_telephone_number_2 => p_telephone_number_2
367 ,p_addr_attribute_category => p_addr_attribute_category
368 ,p_addr_attribute1 => p_addr_attribute1
369 ,p_addr_attribute2 => p_addr_attribute2
370 ,p_addr_attribute3 => p_addr_attribute3
371 ,p_addr_attribute4 => p_addr_attribute4
372 ,p_addr_attribute5 => p_addr_attribute5
373 ,p_addr_attribute6 => p_addr_attribute6
374 ,p_addr_attribute7 => p_addr_attribute7
375 ,p_addr_attribute8 => p_addr_attribute8
376 ,p_addr_attribute9 => p_addr_attribute9
377 ,p_addr_attribute10 => p_addr_attribute10
378 ,p_addr_attribute11 => p_addr_attribute11
379 ,p_addr_attribute12 => p_addr_attribute12
380 ,p_addr_attribute13 => p_addr_attribute13
381 ,p_addr_attribute14 => p_addr_attribute14
382 ,p_addr_attribute15 => p_addr_attribute15
383 ,p_addr_attribute16 => p_addr_attribute16
384 ,p_addr_attribute17 => p_addr_attribute17
385 ,p_addr_attribute18 => p_addr_attribute18
386 ,p_addr_attribute19 => p_addr_attribute19
387 ,p_addr_attribute20 => p_addr_attribute20
388 ,p_address_id => p_address_id
389 ,p_object_version_number => p_object_version_number
390 );
391 --
392 hr_utility.set_location(' Leaving:'||l_proc, 10);
393 end create_us_person_address;
394 --
395 -- ----------------------------------------------------------------------------
396 -- |------------------------< update_person_address >-------------------------|
397 -- ----------------------------------------------------------------------------
398 --
399 procedure update_person_address
400 (p_validate in boolean default false
401 ,p_effective_date in date
402 ,p_address_id in number
403 ,p_object_version_number in out nocopy number
404 ,p_date_from in date default hr_api.g_date
405 ,p_date_to in date default hr_api.g_date
406 ,p_address_type in varchar2 default hr_api.g_varchar2
407 ,p_comments in long default hr_api.g_varchar2
408 ,p_address_line1 in varchar2 default hr_api.g_varchar2
409 ,p_address_line2 in varchar2 default hr_api.g_varchar2
410 ,p_address_line3 in varchar2 default hr_api.g_varchar2
411 ,p_town_or_city in varchar2 default hr_api.g_varchar2
412 ,p_region_1 in varchar2 default hr_api.g_varchar2
413 ,p_region_2 in varchar2 default hr_api.g_varchar2
414 ,p_region_3 in varchar2 default hr_api.g_varchar2
415 ,p_postal_code in varchar2 default hr_api.g_varchar2
416 ,p_country in varchar2 default hr_api.g_varchar2
417 ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
418 ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
419 ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
420 ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
421 ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
422 ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
423 ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
424 ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
425 ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
426 ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
427 ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
428 ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
429 ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
430 ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
431 ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
432 ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
433 ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
434 ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
435 ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
436 ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
437 ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
438 ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
439 ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
440 ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
441 ) is
442 --
443 -- Declare cursors and local variables
444 --
445 l_object_version_number per_addresses.object_version_number%TYPE;
446 l_proc varchar2(72) := g_package||'update_person_address';
447 --
448 begin
449 hr_utility.set_location('Entering:'|| l_proc, 5);
450 --
451 -- Issue a savepoint if operating in validation only mode.
452 --
453 if p_validate then
454 savepoint update_person_address;
455 end if;
456 hr_utility.set_location(l_proc, 6);
457 --
458 l_object_version_number := p_object_version_number;
459 --
460 -- Update Person Address details.
461 --
462 per_kad_upd.upd
463 (p_address_id => p_address_id
464 ,p_date_from => trunc(p_date_from)
465 ,p_address_line1 => p_address_line1
466 ,p_address_line2 => p_address_line2
467 ,p_address_line3 => p_address_line3
468 ,p_address_type => p_address_type
469 ,p_comments => p_comments
470 ,p_country => p_country
471 ,p_date_to => trunc(p_date_to)
472 ,p_postal_code => p_postal_code
473 ,p_region_1 => p_region_1
474 ,p_region_2 => p_region_2
475 ,p_region_3 => p_region_3
476 ,p_telephone_number_1 => p_telephone_number_1
477 ,p_telephone_number_2 => p_telephone_number_2
478 ,p_telephone_number_3 => p_telephone_number_3
479 ,p_town_or_city => p_town_or_city
480 ,p_addr_attribute_category => p_addr_attribute_category
481 ,p_addr_attribute1 => p_addr_attribute1
482 ,p_addr_attribute2 => p_addr_attribute2
483 ,p_addr_attribute3 => p_addr_attribute3
484 ,p_addr_attribute4 => p_addr_attribute4
485 ,p_addr_attribute5 => p_addr_attribute5
486 ,p_addr_attribute6 => p_addr_attribute6
487 ,p_addr_attribute7 => p_addr_attribute7
488 ,p_addr_attribute8 => p_addr_attribute8
489 ,p_addr_attribute9 => p_addr_attribute9
490 ,p_addr_attribute10 => p_addr_attribute10
491 ,p_addr_attribute11 => p_addr_attribute11
492 ,p_addr_attribute12 => p_addr_attribute12
493 ,p_addr_attribute13 => p_addr_attribute13
494 ,p_addr_attribute14 => p_addr_attribute14
495 ,p_addr_attribute15 => p_addr_attribute15
496 ,p_addr_attribute16 => p_addr_attribute16
497 ,p_addr_attribute17 => p_addr_attribute17
498 ,p_addr_attribute18 => p_addr_attribute18
499 ,p_addr_attribute19 => p_addr_attribute19
500 ,p_addr_attribute20 => p_addr_attribute20
501 ,p_object_version_number => p_object_version_number
502 ,p_validate => FALSE
503 ,p_effective_date => p_effective_date
504 );
505 --
506 hr_utility.set_location(l_proc, 8);
507 --
508 -- When in validation only mode raise the Validate_Enabled exception
509 --
510 if p_validate then
511 raise hr_api.validate_enabled;
512 end if;
513 --
514 hr_utility.set_location(' Leaving:'||l_proc, 11);
515 exception
516 when hr_api.validate_enabled then
517 --
518 -- As the Validate_Enabled exception has been raised
519 -- we must rollback to the savepoint
520 --
521 ROLLBACK TO update_person_address;
522 --
523 -- Only set output warning arguments
524 -- (Any key or derived arguments must be set to null
525 -- when validation only mode is being used.)
526 --
527 p_object_version_number := l_object_version_number;
528 end update_person_address;
529 --
530 -- ----------------------------------------------------------------------------
531 -- |-----------------------< update_gb_person_address >-----------------------|
532 -- ----------------------------------------------------------------------------
533 --
534 procedure update_gb_person_address
535 (p_validate in boolean default false
536 ,p_effective_date in date
537 ,p_address_id in number
538 ,p_object_version_number in out nocopy number
539 ,p_date_from in date default hr_api.g_date
540 ,p_date_to in date default hr_api.g_date
541 ,p_address_type in varchar2 default hr_api.g_varchar2
542 ,p_comments in long default hr_api.g_varchar2
543 ,p_address_line1 in varchar2 default hr_api.g_varchar2
544 ,p_address_line2 in varchar2 default hr_api.g_varchar2
545 ,p_address_line3 in varchar2 default hr_api.g_varchar2
546 ,p_town in varchar2 default hr_api.g_varchar2
547 ,p_county in varchar2 default hr_api.g_varchar2
548 ,p_postcode in varchar2 default hr_api.g_varchar2
549 ,p_country in varchar2 default hr_api.g_varchar2
550 ,p_telephone_number in varchar2 default hr_api.g_varchar2
551 ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
552 ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
553 ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
554 ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
555 ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
556 ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
557 ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
558 ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
559 ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
560 ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
561 ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
562 ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
563 ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
564 ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
565 ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
566 ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
567 ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
568 ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
569 ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
570 ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
571 ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
572 ) is
573 --
574 -- Declare cursors and local variables
575 --
576 l_proc varchar2(72) := g_package||'update_gb_person_address';
577 l_style per_addresses.style%TYPE;
578 --
579 cursor csr_add_style is
580 select addr.style
581 from per_addresses addr
582 where addr.address_id = p_address_id;
583 --
584 begin
585 hr_utility.set_location('Entering:'|| l_proc, 5);
586 --
587 -- Check that the Address identified is GB style.
588 --
589 open csr_add_style;
590 fetch csr_add_style
591 into l_style;
592 if csr_add_style%notfound then
593 --
594 close csr_add_style;
595 --
596 hr_utility.set_location(l_proc, 7);
597 --
598 hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
599 hr_utility.raise_error;
600 --
601 else
602 --
603 close csr_add_style;
604 --
605 if l_style <> 'GB' then
606 --
607 hr_utility.set_location(l_proc, 8);
608 --
609 hr_utility.set_message(801, 'HR_7788_ADD_INV_NOT_GB_STYLE');
610 hr_utility.raise_error;
611 --
612 end if;
613 end if;
614 --
615 hr_utility.set_location(l_proc, 9);
616 --
617 -- Update Person Address details.
618 --
619 hr_kiosk_address_api.update_person_address
620 (p_validate => p_validate
621 ,p_effective_date => p_effective_date
622 ,p_address_id => p_address_id
623 ,p_object_version_number => p_object_version_number
624 ,p_date_from => p_date_from
625 ,p_date_to => p_date_to
626 ,p_address_type => p_address_type
627 ,p_comments => p_comments
628 ,p_address_line1 => p_address_line1
629 ,p_address_line2 => p_address_line2
630 ,p_address_line3 => p_address_line3
631 ,p_town_or_city => p_town
632 ,p_region_1 => p_county
633 ,p_postal_code => p_postcode
634 ,p_country => p_country
635 ,p_telephone_number_1 => p_telephone_number
636 ,p_addr_attribute_category => p_addr_attribute_category
637 ,p_addr_attribute1 => p_addr_attribute1
638 ,p_addr_attribute2 => p_addr_attribute2
639 ,p_addr_attribute3 => p_addr_attribute3
640 ,p_addr_attribute4 => p_addr_attribute4
641 ,p_addr_attribute5 => p_addr_attribute5
642 ,p_addr_attribute6 => p_addr_attribute6
643 ,p_addr_attribute7 => p_addr_attribute7
644 ,p_addr_attribute8 => p_addr_attribute8
645 ,p_addr_attribute9 => p_addr_attribute9
646 ,p_addr_attribute10 => p_addr_attribute10
647 ,p_addr_attribute11 => p_addr_attribute11
648 ,p_addr_attribute12 => p_addr_attribute12
649 ,p_addr_attribute13 => p_addr_attribute13
650 ,p_addr_attribute14 => p_addr_attribute14
651 ,p_addr_attribute15 => p_addr_attribute15
652 ,p_addr_attribute16 => p_addr_attribute16
653 ,p_addr_attribute17 => p_addr_attribute17
654 ,p_addr_attribute18 => p_addr_attribute18
655 ,p_addr_attribute19 => p_addr_attribute19
656 ,p_addr_attribute20 => p_addr_attribute20
657 );
658 --
659 hr_utility.set_location(' Leaving:'||l_proc, 11);
660 end update_gb_person_address;
661 --
662 -- ----------------------------------------------------------------------------
663 -- |-----------------------< update_us_person_address >-----------------------|
664 -- ----------------------------------------------------------------------------
665 --
666 procedure update_us_person_address
667 (p_validate in boolean default false
668 ,p_effective_date in date
669 ,p_address_id in number
670 ,p_object_version_number in out nocopy number
671 ,p_date_from in date default hr_api.g_date
672 ,p_date_to in date default hr_api.g_date
673 ,p_address_type in varchar2 default hr_api.g_varchar2
674 ,p_comments in long default hr_api.g_varchar2
675 ,p_address_line1 in varchar2 default hr_api.g_varchar2
676 ,p_address_line2 in varchar2 default hr_api.g_varchar2
677 ,p_address_line3 in varchar2 default hr_api.g_varchar2
678 ,p_city in varchar2 default hr_api.g_varchar2
679 ,p_state in varchar2 default hr_api.g_varchar2
680 ,p_zip_code in varchar2 default hr_api.g_varchar2
681 ,p_county in varchar2 default hr_api.g_varchar2
682 ,p_country in varchar2 default hr_api.g_varchar2
683 ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
684 ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
685 ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
686 ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
687 ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
688 ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
689 ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
690 ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
691 ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
692 ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
693 ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
694 ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
695 ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
696 ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
697 ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
698 ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
699 ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
700 ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
701 ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
702 ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
703 ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
704 ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
705 ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
706 ) is
707 --
708 -- Declare cursors and local variables
709 --
710 l_proc varchar2(72) := g_package||'update_us_person_address';
711 l_style per_addresses.style%TYPE;
712 --
713 cursor csr_add_style is
714 select style
715 from per_addresses
716 where address_id = p_address_id;
717 --
718 begin
719 hr_utility.set_location('Entering:'|| l_proc, 5);
720 --
721 -- Check that the address is US style.
722 --
723 open csr_add_style;
724 fetch csr_add_style
725 into l_style;
726 if csr_add_style%notfound then
727 close csr_add_style;
728 --
729 hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
730 hr_utility.raise_error;
731 else
732 hr_utility.set_location(l_proc, 10);
733 --
734 close csr_add_style;
735 --
736 if l_style <> 'US' then
737 hr_utility.set_message(801, 'HR_51283_ADD_MUST_BE_US_STYLE');
738 hr_utility.raise_error;
739 end if;
740 end if;
741 --
742 hr_utility.set_location(l_proc, 15);
743 --
744 -- Update Person Address details.
745 --
746 hr_kiosk_address_api.update_person_address
747 (p_validate => p_validate
748 ,p_effective_date => p_effective_date
749 ,p_address_id => p_address_id
750 ,p_object_version_number => p_object_version_number
751 ,p_date_from => p_date_from
752 ,p_date_to => p_date_to
753 ,p_address_type => p_address_type
754 ,p_comments => p_comments
755 ,p_address_line1 => p_address_line1
756 ,p_address_line2 => p_address_line2
757 ,p_address_line3 => p_address_line3
758 ,p_town_or_city => p_city
759 ,p_region_1 => p_county
760 ,p_region_2 => p_state
761 ,p_postal_code => p_zip_code
762 ,p_country => p_country
763 ,p_telephone_number_1 => p_telephone_number_1
764 ,p_telephone_number_2 => p_telephone_number_2
765 ,p_addr_attribute_category => p_addr_attribute_category
766 ,p_addr_attribute1 => p_addr_attribute1
767 ,p_addr_attribute2 => p_addr_attribute2
768 ,p_addr_attribute3 => p_addr_attribute3
769 ,p_addr_attribute4 => p_addr_attribute4
770 ,p_addr_attribute5 => p_addr_attribute5
771 ,p_addr_attribute6 => p_addr_attribute6
772 ,p_addr_attribute7 => p_addr_attribute7
773 ,p_addr_attribute8 => p_addr_attribute8
774 ,p_addr_attribute9 => p_addr_attribute9
775 ,p_addr_attribute10 => p_addr_attribute10
776 ,p_addr_attribute11 => p_addr_attribute11
777 ,p_addr_attribute12 => p_addr_attribute12
778 ,p_addr_attribute13 => p_addr_attribute13
779 ,p_addr_attribute14 => p_addr_attribute14
780 ,p_addr_attribute15 => p_addr_attribute15
781 ,p_addr_attribute16 => p_addr_attribute16
782 ,p_addr_attribute17 => p_addr_attribute17
783 ,p_addr_attribute18 => p_addr_attribute18
784 ,p_addr_attribute19 => p_addr_attribute19
785 ,p_addr_attribute20 => p_addr_attribute20
786 );
787 --
788 hr_utility.set_location(' Leaving:'||l_proc, 20);
789 end update_us_person_address;
790 --
791 end hr_kiosk_address_api;