[Home] [Help]
PACKAGE BODY: APPS.PQH_ACCOMMODATIONS_API
Source
1 Package Body pqh_accommodations_api as
2 /* $Header: pqaccapi.pkb 115.1 2002/11/26 22:33:05 rpasapul noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' PQH_ACCOMMODATIONS_API.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |--------------------------<create_accommodation>--------------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_accommodation
13 (p_validate in boolean default false
14 ,p_effective_date in date
15 ,p_accommodation_name in varchar2
16 ,p_business_group_id in number
17 ,p_location_id in number
18 ,p_accommodation_desc in varchar2 default null
19 ,p_accommodation_type in varchar2 default null
20 ,p_style in varchar2 default null
21 ,p_address_line_1 in varchar2 default null
22 ,p_address_line_2 in varchar2 default null
23 ,p_address_line_3 in varchar2 default null
24 ,p_town_or_city in varchar2 default null
25 ,p_country in varchar2 default null
26 ,p_postal_code in varchar2 default null
27 ,p_region_1 in varchar2 default null
28 ,p_region_2 in varchar2 default null
29 ,p_region_3 in varchar2 default null
30 ,p_telephone_number_1 in varchar2 default null
31 ,p_telephone_number_2 in varchar2 default null
32 ,p_telephone_number_3 in varchar2 default null
33 ,p_floor_number in varchar2 default null
34 ,p_floor_area in number default null
35 ,p_floor_area_measure_unit in varchar2 default null
36 ,p_main_rooms in number default null
37 ,p_family_size in number default null
38 ,p_suitability_disabled in varchar2 default null
39 ,p_rental_value in number default null
40 ,p_rental_value_currency in varchar2 default null
41 ,p_owner in varchar2 default null
42 ,p_comments in varchar2 default null
43 ,p_information_category in varchar2 default null
44 ,p_information1 in varchar2 default null
45 ,p_information2 in varchar2 default null
46 ,p_information3 in varchar2 default null
47 ,p_information4 in varchar2 default null
48 ,p_information5 in varchar2 default null
49 ,p_information6 in varchar2 default null
50 ,p_information7 in varchar2 default null
51 ,p_information8 in varchar2 default null
52 ,p_information9 in varchar2 default null
53 ,p_information10 in varchar2 default null
54 ,p_information11 in varchar2 default null
55 ,p_information12 in varchar2 default null
56 ,p_information13 in varchar2 default null
57 ,p_information14 in varchar2 default null
58 ,p_information15 in varchar2 default null
59 ,p_information16 in varchar2 default null
60 ,p_information17 in varchar2 default null
61 ,p_information18 in varchar2 default null
62 ,p_information19 in varchar2 default null
63 ,p_information20 in varchar2 default null
64 ,p_information21 in varchar2 default null
65 ,p_information22 in varchar2 default null
66 ,p_information23 in varchar2 default null
67 ,p_information24 in varchar2 default null
68 ,p_information25 in varchar2 default null
69 ,p_information26 in varchar2 default null
70 ,p_information27 in varchar2 default null
71 ,p_information28 in varchar2 default null
72 ,p_information29 in varchar2 default null
73 ,p_information30 in varchar2 default null
74 ,p_attribute_category in varchar2 default null
75 ,p_attribute1 in varchar2 default null
76 ,p_attribute2 in varchar2 default null
77 ,p_attribute3 in varchar2 default null
78 ,p_attribute4 in varchar2 default null
79 ,p_attribute5 in varchar2 default null
80 ,p_attribute6 in varchar2 default null
81 ,p_attribute7 in varchar2 default null
82 ,p_attribute8 in varchar2 default null
83 ,p_attribute9 in varchar2 default null
84 ,p_attribute10 in varchar2 default null
85 ,p_attribute11 in varchar2 default null
86 ,p_attribute12 in varchar2 default null
87 ,p_attribute13 in varchar2 default null
88 ,p_attribute14 in varchar2 default null
89 ,p_attribute15 in varchar2 default null
90 ,p_attribute16 in varchar2 default null
91 ,p_attribute17 in varchar2 default null
92 ,p_attribute18 in varchar2 default null
93 ,p_attribute19 in varchar2 default null
94 ,p_attribute20 in varchar2 default null
95 ,p_attribute21 in varchar2 default null
96 ,p_attribute22 in varchar2 default null
97 ,p_attribute23 in varchar2 default null
98 ,p_attribute24 in varchar2 default null
99 ,p_attribute25 in varchar2 default null
100 ,p_attribute26 in varchar2 default null
101 ,p_attribute27 in varchar2 default null
102 ,p_attribute28 in varchar2 default null
103 ,p_attribute29 in varchar2 default null
104 ,p_attribute30 in varchar2 default null
105 ,p_accommodation_id out nocopy number
106 ,p_object_version_number out nocopy number
107 ,p_effective_start_date out nocopy date
108 ,p_effective_end_date out nocopy date
109 ) is
110 --
111 -- Declare cursors and local variables
112 --
113
114 l_proc varchar2(72) := g_package||'CREATE_ACCOMMODATION';
115
116 l_accommodation_id pqh_accommodations_f.accommodation_id%TYPE;
117 l_object_version_number pqh_accommodations_f.object_version_number%TYPE;
118 l_effective_start_date pqh_accommodations_f.effective_start_date%TYPE;
119 l_effective_end_date pqh_accommodations_f.effective_end_date%TYPE;
120 --
121 begin
122 hr_utility.set_location('Entering:'|| l_proc, 10);
123 --
124 -- Issue a savepoint
125 --
126 savepoint CREATE_ACCOMMODATION;
127 --
128 -- Truncate the time portion from all IN date parameters
129 --
130
131 --
132 -- Call Before Process User Hook
133 --
134 begin
135 PQH_ACCOMMODATIONS_BK1.create_accommodation_b
136 (p_effective_date => p_effective_date
137 ,p_accommodation_name => p_accommodation_name
138 ,p_business_group_id => p_business_group_id
139 ,p_location_id => p_location_id
140 ,p_accommodation_desc => p_accommodation_desc
141 ,p_accommodation_type => p_accommodation_type
142 ,p_style => p_style
143 ,p_address_line_1 => p_address_line_1
144 ,p_address_line_2 => p_address_line_3
145 ,p_address_line_3 => p_address_line_3
146 ,p_town_or_city => p_town_or_city
147 ,p_country => p_country
148 ,p_postal_code => p_postal_code
149 ,p_region_1 => p_region_1
150 ,p_region_2 => p_region_2
151 ,p_region_3 => p_region_3
152 ,p_telephone_number_1 => p_telephone_number_1
153 ,p_telephone_number_2 => p_telephone_number_2
154 ,p_telephone_number_3 => p_telephone_number_3
155 ,p_floor_number => p_floor_number
156 ,p_floor_area => p_floor_area
157 ,p_floor_area_measure_unit => p_floor_area_measure_unit
158 ,p_main_rooms => p_main_rooms
159 ,p_family_size => p_family_size
160 ,p_suitability_disabled => p_suitability_disabled
161 ,p_rental_value => p_rental_value
162 ,p_rental_value_currency => p_rental_value_currency
163 ,p_owner => p_owner
164 ,p_comments => p_comments
165 ,p_information_category => p_information_category
166 ,p_information1 => p_information1
167 ,p_information2 => p_information2
168 ,p_information3 => p_information3
169 ,p_information4 => p_information4
170 ,p_information5 => p_information5
171 ,p_information6 => p_information6
172 ,p_information7 => p_information7
173 ,p_information8 => p_information8
174 ,p_information9 => p_information9
175 ,p_information10 => p_information10
176 ,p_information11 => p_information11
177 ,p_information12 => p_information12
178 ,p_information13 => p_information13
179 ,p_information14 => p_information14
180 ,p_information15 => p_information15
181 ,p_information16 => p_information16
182 ,p_information17 => p_information17
183 ,p_information18 => p_information18
184 ,p_information19 => p_information19
185 ,p_information20 => p_information20
186 ,p_information21 => p_information21
187 ,p_information22 => p_information22
188 ,p_information23 => p_information23
189 ,p_information24 => p_information24
190 ,p_information25 => p_information25
191 ,p_information26 => p_information26
192 ,p_information27 => p_information27
193 ,p_information28 => p_information28
194 ,p_information29 => p_information29
195 ,p_information30 => p_information30
196 ,p_attribute_category => p_attribute_category
197 ,p_attribute1 => p_attribute1
198 ,p_attribute2 => p_attribute2
199 ,p_attribute3 => p_attribute3
200 ,p_attribute4 => p_attribute4
201 ,p_attribute5 => p_attribute5
202 ,p_attribute6 => p_attribute6
203 ,p_attribute7 => p_attribute7
204 ,p_attribute8 => p_attribute8
205 ,p_attribute9 => p_attribute9
206 ,p_attribute10 => p_attribute10
207 ,p_attribute11 => p_attribute11
208 ,p_attribute12 => p_attribute12
209 ,p_attribute13 => p_attribute13
210 ,p_attribute14 => p_attribute14
211 ,p_attribute15 => p_attribute15
212 ,p_attribute16 => p_attribute16
213 ,p_attribute17 => p_attribute17
214 ,p_attribute18 => p_attribute18
215 ,p_attribute19 => p_attribute19
216 ,p_attribute20 => p_attribute20
217 ,p_attribute21 => p_attribute21
218 ,p_attribute22 => p_attribute22
219 ,p_attribute23 => p_attribute23
220 ,p_attribute24 => p_attribute24
221 ,p_attribute25 => p_attribute25
222 ,p_attribute26 => p_attribute26
223 ,p_attribute27 => p_attribute27
224 ,p_attribute28 => p_attribute28
225 ,p_attribute29 => p_attribute29
226 ,p_attribute30 => p_attribute30
227 );
228 exception
229 when hr_api.cannot_find_prog_unit then
230 hr_api.cannot_find_prog_unit_error
231 (p_module_name => 'CREATE_ACCOMMODATION'
232 ,p_hook_type => 'BP'
233 );
234 end;
235 --
236 -- Validation in addition to Row Handlers
237 --
238
239
240
241 --
242 -- Process Logic
243 --
244 pqh_acc_ins.ins
245 (p_effective_date => p_effective_date
246 ,p_accommodation_name => p_accommodation_name
247 ,p_business_group_id => p_business_group_id
248 ,p_location_id => p_location_id
249 ,p_accommodation_desc => p_accommodation_desc
250 ,p_accommodation_type => p_accommodation_type
251 ,p_style => p_style
252 ,p_address_line_1 => p_address_line_1
253 ,p_address_line_2 => p_address_line_3
254 ,p_address_line_3 => p_address_line_3
255 ,p_town_or_city => p_town_or_city
256 ,p_country => p_country
257 ,p_postal_code => p_postal_code
258 ,p_region_1 => p_region_1
259 ,p_region_2 => p_region_2
260 ,p_region_3 => p_region_3
261 ,p_telephone_number_1 => p_telephone_number_1
262 ,p_telephone_number_2 => p_telephone_number_2
263 ,p_telephone_number_3 => p_telephone_number_3
264 ,p_floor_number => p_floor_number
265 ,p_floor_area => p_floor_area
266 ,p_floor_area_measure_unit => p_floor_area_measure_unit
267 ,p_main_rooms => p_main_rooms
268 ,p_family_size => p_family_size
269 ,p_suitability_disabled => p_suitability_disabled
270 ,p_rental_value => p_rental_value
271 ,p_rental_value_currency => p_rental_value_currency
272 ,p_owner => p_owner
273 ,p_comments => p_comments
274 ,p_information_category => p_information_category
275 ,p_information1 => p_information1
276 ,p_information2 => p_information2
277 ,p_information3 => p_information3
278 ,p_information4 => p_information4
279 ,p_information5 => p_information5
280 ,p_information6 => p_information6
281 ,p_information7 => p_information7
282 ,p_information8 => p_information8
283 ,p_information9 => p_information9
284 ,p_information10 => p_information10
285 ,p_information11 => p_information11
286 ,p_information12 => p_information12
287 ,p_information13 => p_information13
288 ,p_information14 => p_information14
289 ,p_information15 => p_information15
290 ,p_information16 => p_information16
291 ,p_information17 => p_information17
292 ,p_information18 => p_information18
293 ,p_information19 => p_information19
294 ,p_information20 => p_information20
295 ,p_information21 => p_information21
296 ,p_information22 => p_information22
297 ,p_information23 => p_information23
301 ,p_information27 => p_information27
298 ,p_information24 => p_information24
299 ,p_information25 => p_information25
300 ,p_information26 => p_information26
302 ,p_information28 => p_information28
303 ,p_information29 => p_information29
304 ,p_information30 => p_information30
305 ,p_attribute_category => p_attribute_category
306 ,p_attribute1 => p_attribute1
307 ,p_attribute2 => p_attribute2
308 ,p_attribute3 => p_attribute3
309 ,p_attribute4 => p_attribute4
310 ,p_attribute5 => p_attribute5
311 ,p_attribute6 => p_attribute6
312 ,p_attribute7 => p_attribute7
313 ,p_attribute8 => p_attribute8
314 ,p_attribute9 => p_attribute9
315 ,p_attribute10 => p_attribute10
316 ,p_attribute11 => p_attribute11
317 ,p_attribute12 => p_attribute12
318 ,p_attribute13 => p_attribute13
319 ,p_attribute14 => p_attribute14
320 ,p_attribute15 => p_attribute15
321 ,p_attribute16 => p_attribute16
322 ,p_attribute17 => p_attribute17
323 ,p_attribute18 => p_attribute18
324 ,p_attribute19 => p_attribute19
325 ,p_attribute20 => p_attribute20
326 ,p_attribute21 => p_attribute21
327 ,p_attribute22 => p_attribute22
328 ,p_attribute23 => p_attribute23
329 ,p_attribute24 => p_attribute24
330 ,p_attribute25 => p_attribute25
331 ,p_attribute26 => p_attribute26
332 ,p_attribute27 => p_attribute27
333 ,p_attribute28 => p_attribute28
334 ,p_attribute29 => p_attribute29
335 ,p_attribute30 => p_attribute30
336 ,p_accommodation_id => l_accommodation_id
337 ,p_object_version_number => l_object_version_number
338 ,p_effective_start_date => l_effective_start_date
339 ,p_effective_end_date => l_effective_end_date
340 );
341
342
343 --
344 -- Call After Process User Hook
345 --
346 begin
347 PQH_ACCOMMODATIONS_BK1.create_accommodation_a
348 (p_effective_date => p_effective_date
349 ,p_accommodation_name => p_accommodation_name
350 ,p_business_group_id => p_business_group_id
351 ,p_location_id => p_location_id
352 ,p_accommodation_desc => p_accommodation_desc
353 ,p_accommodation_type => p_accommodation_type
354 ,p_style => p_style
355 ,p_address_line_1 => p_address_line_1
356 ,p_address_line_2 => p_address_line_3
357 ,p_address_line_3 => p_address_line_3
358 ,p_town_or_city => p_town_or_city
359 ,p_country => p_country
360 ,p_postal_code => p_postal_code
361 ,p_region_1 => p_region_1
362 ,p_region_2 => p_region_2
363 ,p_region_3 => p_region_3
364 ,p_telephone_number_1 => p_telephone_number_1
365 ,p_telephone_number_2 => p_telephone_number_2
366 ,p_telephone_number_3 => p_telephone_number_3
367 ,p_floor_number => p_floor_number
368 ,p_floor_area => p_floor_area
369 ,p_floor_area_measure_unit => p_floor_area_measure_unit
370 ,p_main_rooms => p_main_rooms
371 ,p_family_size => p_family_size
372 ,p_suitability_disabled => p_suitability_disabled
373 ,p_rental_value => p_rental_value
374 ,p_rental_value_currency => p_rental_value_currency
375 ,p_owner => p_owner
376 ,p_comments => p_comments
377 ,p_information_category => p_information_category
378 ,p_information1 => p_information1
379 ,p_information2 => p_information2
380 ,p_information3 => p_information3
381 ,p_information4 => p_information4
382 ,p_information5 => p_information5
383 ,p_information6 => p_information6
384 ,p_information7 => p_information7
385 ,p_information8 => p_information8
386 ,p_information9 => p_information9
387 ,p_information10 => p_information10
388 ,p_information11 => p_information11
389 ,p_information12 => p_information12
390 ,p_information13 => p_information13
391 ,p_information14 => p_information14
392 ,p_information15 => p_information15
393 ,p_information16 => p_information16
394 ,p_information17 => p_information17
395 ,p_information18 => p_information18
396 ,p_information19 => p_information19
400 ,p_information23 => p_information23
397 ,p_information20 => p_information20
398 ,p_information21 => p_information21
399 ,p_information22 => p_information22
401 ,p_information24 => p_information24
402 ,p_information25 => p_information25
403 ,p_information26 => p_information26
404 ,p_information27 => p_information27
405 ,p_information28 => p_information28
406 ,p_information29 => p_information29
407 ,p_information30 => p_information30
408 ,p_attribute_category => p_attribute_category
409 ,p_attribute1 => p_attribute1
410 ,p_attribute2 => p_attribute2
411 ,p_attribute3 => p_attribute3
412 ,p_attribute4 => p_attribute4
413 ,p_attribute5 => p_attribute5
414 ,p_attribute6 => p_attribute6
415 ,p_attribute7 => p_attribute7
416 ,p_attribute8 => p_attribute8
417 ,p_attribute9 => p_attribute9
418 ,p_attribute10 => p_attribute10
419 ,p_attribute11 => p_attribute11
420 ,p_attribute12 => p_attribute12
421 ,p_attribute13 => p_attribute13
422 ,p_attribute14 => p_attribute14
423 ,p_attribute15 => p_attribute15
424 ,p_attribute16 => p_attribute16
425 ,p_attribute17 => p_attribute17
426 ,p_attribute18 => p_attribute18
427 ,p_attribute19 => p_attribute19
428 ,p_attribute20 => p_attribute20
429 ,p_attribute21 => p_attribute21
430 ,p_attribute22 => p_attribute22
431 ,p_attribute23 => p_attribute23
432 ,p_attribute24 => p_attribute24
433 ,p_attribute25 => p_attribute25
434 ,p_attribute26 => p_attribute26
435 ,p_attribute27 => p_attribute27
436 ,p_attribute28 => p_attribute28
437 ,p_attribute29 => p_attribute29
438 ,p_attribute30 => p_attribute30
439 ,p_accommodation_id => l_accommodation_id
440 ,p_object_version_number => l_object_version_number
441 ,p_effective_start_date => l_effective_start_date
442 ,p_effective_end_date => l_effective_end_date
443 );
444 exception
445 when hr_api.cannot_find_prog_unit then
446 hr_api.cannot_find_prog_unit_error
447 (p_module_name => 'CREATE_ACCOMMODATION'
448 ,p_hook_type => 'AP'
449 );
450 end;
451 --
452 -- When in validation only mode raise the Validate_Enabled exception
453 --
454 if p_validate then
455 raise hr_api.validate_enabled;
456 end if;
457 --
458 -- Set all output arguments
459 --
460 p_accommodation_id := l_accommodation_id;
461 p_object_version_number := l_object_version_number;
462 p_effective_start_date := l_effective_start_date;
463 p_effective_end_date := l_effective_end_date;
464 --
465 hr_utility.set_location(' Leaving:'||l_proc, 70);
466 exception
467 when hr_api.validate_enabled then
468 --
469 -- As the Validate_Enabled exception has been raised
470 -- we must rollback to the savepoint
471 --
472 rollback to CREATE_ACCOMMODATION;
473 --
474 -- Only set output warning arguments
475 -- (Any key or derived arguments must be set to null
476 -- when validation only mode is being used.)
477 --
478 p_accommodation_id := null;
479 p_object_version_number := null;
480 p_effective_start_date := null;
481 p_effective_end_date := null;
482 hr_utility.set_location(' Leaving:'||l_proc, 80);
483 when others then
484 --
485 -- A validation or unexpected error has occured
486 --
487 p_accommodation_id := null;
488 p_object_version_number := null;
489 p_effective_start_date := null;
490 p_effective_end_date := null;
491
492 rollback to CREATE_ACCOMMODATION;
493 hr_utility.set_location(' Leaving:'||l_proc, 90);
494 raise;
495 end create_accommodation;
496 --
497 --
498 -- ----------------------------------------------------------------------------
499 -- |--------------------------<update_accommodation>--------------------------|
500 -- ----------------------------------------------------------------------------
501 --
502 procedure update_accommodation
503 (p_validate in boolean default false
504 ,p_effective_date in date
505 ,p_datetrack_mode in varchar2
506 ,p_accommodation_id in number
507 ,p_object_version_number in out nocopy number
508 ,p_accommodation_name in varchar2 default hr_api.g_varchar2
509 ,p_business_group_id in number default hr_api.g_number
510 ,p_location_id in number default hr_api.g_number
511 ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
512 ,p_accommodation_type in varchar2 default hr_api.g_varchar2
513 ,p_style in varchar2 default hr_api.g_varchar2
517 ,p_town_or_city in varchar2 default hr_api.g_varchar2
514 ,p_address_line_1 in varchar2 default hr_api.g_varchar2
515 ,p_address_line_2 in varchar2 default hr_api.g_varchar2
516 ,p_address_line_3 in varchar2 default hr_api.g_varchar2
518 ,p_country in varchar2 default hr_api.g_varchar2
519 ,p_postal_code in varchar2 default hr_api.g_varchar2
520 ,p_region_1 in varchar2 default hr_api.g_varchar2
521 ,p_region_2 in varchar2 default hr_api.g_varchar2
522 ,p_region_3 in varchar2 default hr_api.g_varchar2
523 ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
524 ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
525 ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
526 ,p_floor_number in varchar2 default hr_api.g_varchar2
527 ,p_floor_area in number default hr_api.g_number
528 ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
529 ,p_main_rooms in number default hr_api.g_number
530 ,p_family_size in number default hr_api.g_number
531 ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
532 ,p_rental_value in number default hr_api.g_number
533 ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
534 ,p_owner in varchar2 default hr_api.g_varchar2
535 ,p_comments in varchar2 default hr_api.g_varchar2
536 ,p_information_category in varchar2 default hr_api.g_varchar2
537 ,p_information1 in varchar2 default hr_api.g_varchar2
538 ,p_information2 in varchar2 default hr_api.g_varchar2
539 ,p_information3 in varchar2 default hr_api.g_varchar2
540 ,p_information4 in varchar2 default hr_api.g_varchar2
541 ,p_information5 in varchar2 default hr_api.g_varchar2
542 ,p_information6 in varchar2 default hr_api.g_varchar2
543 ,p_information7 in varchar2 default hr_api.g_varchar2
544 ,p_information8 in varchar2 default hr_api.g_varchar2
545 ,p_information9 in varchar2 default hr_api.g_varchar2
546 ,p_information10 in varchar2 default hr_api.g_varchar2
547 ,p_information11 in varchar2 default hr_api.g_varchar2
548 ,p_information12 in varchar2 default hr_api.g_varchar2
549 ,p_information13 in varchar2 default hr_api.g_varchar2
550 ,p_information14 in varchar2 default hr_api.g_varchar2
551 ,p_information15 in varchar2 default hr_api.g_varchar2
552 ,p_information16 in varchar2 default hr_api.g_varchar2
553 ,p_information17 in varchar2 default hr_api.g_varchar2
554 ,p_information18 in varchar2 default hr_api.g_varchar2
555 ,p_information19 in varchar2 default hr_api.g_varchar2
556 ,p_information20 in varchar2 default hr_api.g_varchar2
557 ,p_information21 in varchar2 default hr_api.g_varchar2
558 ,p_information22 in varchar2 default hr_api.g_varchar2
559 ,p_information23 in varchar2 default hr_api.g_varchar2
560 ,p_information24 in varchar2 default hr_api.g_varchar2
561 ,p_information25 in varchar2 default hr_api.g_varchar2
562 ,p_information26 in varchar2 default hr_api.g_varchar2
563 ,p_information27 in varchar2 default hr_api.g_varchar2
564 ,p_information28 in varchar2 default hr_api.g_varchar2
565 ,p_information29 in varchar2 default hr_api.g_varchar2
566 ,p_information30 in varchar2 default hr_api.g_varchar2
567 ,p_attribute_category in varchar2 default hr_api.g_varchar2
568 ,p_attribute1 in varchar2 default hr_api.g_varchar2
569 ,p_attribute2 in varchar2 default hr_api.g_varchar2
570 ,p_attribute3 in varchar2 default hr_api.g_varchar2
571 ,p_attribute4 in varchar2 default hr_api.g_varchar2
572 ,p_attribute5 in varchar2 default hr_api.g_varchar2
573 ,p_attribute6 in varchar2 default hr_api.g_varchar2
574 ,p_attribute7 in varchar2 default hr_api.g_varchar2
575 ,p_attribute8 in varchar2 default hr_api.g_varchar2
576 ,p_attribute9 in varchar2 default hr_api.g_varchar2
577 ,p_attribute10 in varchar2 default hr_api.g_varchar2
578 ,p_attribute11 in varchar2 default hr_api.g_varchar2
579 ,p_attribute12 in varchar2 default hr_api.g_varchar2
580 ,p_attribute13 in varchar2 default hr_api.g_varchar2
581 ,p_attribute14 in varchar2 default hr_api.g_varchar2
582 ,p_attribute15 in varchar2 default hr_api.g_varchar2
583 ,p_attribute16 in varchar2 default hr_api.g_varchar2
584 ,p_attribute17 in varchar2 default hr_api.g_varchar2
585 ,p_attribute18 in varchar2 default hr_api.g_varchar2
586 ,p_attribute19 in varchar2 default hr_api.g_varchar2
587 ,p_attribute20 in varchar2 default hr_api.g_varchar2
591 ,p_attribute24 in varchar2 default hr_api.g_varchar2
588 ,p_attribute21 in varchar2 default hr_api.g_varchar2
589 ,p_attribute22 in varchar2 default hr_api.g_varchar2
590 ,p_attribute23 in varchar2 default hr_api.g_varchar2
592 ,p_attribute25 in varchar2 default hr_api.g_varchar2
593 ,p_attribute26 in varchar2 default hr_api.g_varchar2
594 ,p_attribute27 in varchar2 default hr_api.g_varchar2
595 ,p_attribute28 in varchar2 default hr_api.g_varchar2
596 ,p_attribute29 in varchar2 default hr_api.g_varchar2
597 ,p_attribute30 in varchar2 default hr_api.g_varchar2
598 ,p_effective_start_date out nocopy date
599 ,p_effective_end_date out nocopy date
600 ) is
601 --
602 -- Declare cursors and local variables
603 --
604
605 l_proc varchar2(72) := g_package||'UPDATE_ACCOMMODATION';
606
607 l_effective_start_date pqh_accommodations_f.effective_start_date%TYPE;
608 l_effective_end_date pqh_accommodations_f.effective_end_date%TYPE;
609 l_object_version_number number := p_object_version_number;
610 --
611 begin
612 hr_utility.set_location('Entering:'|| l_proc, 10);
613 --
614 -- Issue a savepoint
615 --
616 savepoint UPDATE_ACCOMMODATION;
617 --
618 -- Truncate the time portion from all IN date parameters
619 --
620
621 --
622 -- Call Before Process User Hook
623 --
624 begin
625 PQH_ACCOMMODATIONS_BK2.update_accommodation_b
626 (p_effective_date => p_effective_date
627 ,p_datetrack_mode => p_datetrack_mode
628 ,p_accommodation_id => p_accommodation_id
629 ,p_object_version_number => p_object_version_number
630 ,p_accommodation_name => p_accommodation_name
631 ,p_business_group_id => p_business_group_id
632 ,p_location_id => p_location_id
633 ,p_accommodation_desc => p_accommodation_desc
634 ,p_accommodation_type => p_accommodation_type
635 ,p_style => p_style
636 ,p_address_line_1 => p_address_line_1
637 ,p_address_line_2 => p_address_line_3
638 ,p_address_line_3 => p_address_line_3
639 ,p_town_or_city => p_town_or_city
640 ,p_country => p_country
641 ,p_postal_code => p_postal_code
642 ,p_region_1 => p_region_1
643 ,p_region_2 => p_region_2
644 ,p_region_3 => p_region_3
645 ,p_telephone_number_1 => p_telephone_number_1
646 ,p_telephone_number_2 => p_telephone_number_2
647 ,p_telephone_number_3 => p_telephone_number_3
648 ,p_floor_number => p_floor_number
649 ,p_floor_area => p_floor_area
650 ,p_floor_area_measure_unit => p_floor_area_measure_unit
651 ,p_main_rooms => p_main_rooms
652 ,p_family_size => p_family_size
653 ,p_suitability_disabled => p_suitability_disabled
654 ,p_rental_value => p_rental_value
655 ,p_rental_value_currency => p_rental_value_currency
656 ,p_owner => p_owner
657 ,p_comments => p_comments
658 ,p_information_category => p_information_category
659 ,p_information1 => p_information1
660 ,p_information2 => p_information2
661 ,p_information3 => p_information3
662 ,p_information4 => p_information4
663 ,p_information5 => p_information5
664 ,p_information6 => p_information6
665 ,p_information7 => p_information7
666 ,p_information8 => p_information8
667 ,p_information9 => p_information9
668 ,p_information10 => p_information10
669 ,p_information11 => p_information11
670 ,p_information12 => p_information12
671 ,p_information13 => p_information13
672 ,p_information14 => p_information14
673 ,p_information15 => p_information15
674 ,p_information16 => p_information16
675 ,p_information17 => p_information17
676 ,p_information18 => p_information18
677 ,p_information19 => p_information19
678 ,p_information20 => p_information20
679 ,p_information21 => p_information21
680 ,p_information22 => p_information22
681 ,p_information23 => p_information23
682 ,p_information24 => p_information24
683 ,p_information25 => p_information25
684 ,p_information26 => p_information26
685 ,p_information27 => p_information27
686 ,p_information28 => p_information28
687 ,p_information29 => p_information29
688 ,p_information30 => p_information30
689 ,p_attribute_category => p_attribute_category
690 ,p_attribute1 => p_attribute1
694 ,p_attribute5 => p_attribute5
691 ,p_attribute2 => p_attribute2
692 ,p_attribute3 => p_attribute3
693 ,p_attribute4 => p_attribute4
695 ,p_attribute6 => p_attribute6
696 ,p_attribute7 => p_attribute7
697 ,p_attribute8 => p_attribute8
698 ,p_attribute9 => p_attribute9
699 ,p_attribute10 => p_attribute10
700 ,p_attribute11 => p_attribute11
701 ,p_attribute12 => p_attribute12
702 ,p_attribute13 => p_attribute13
703 ,p_attribute14 => p_attribute14
704 ,p_attribute15 => p_attribute15
705 ,p_attribute16 => p_attribute16
706 ,p_attribute17 => p_attribute17
707 ,p_attribute18 => p_attribute18
708 ,p_attribute19 => p_attribute19
709 ,p_attribute20 => p_attribute20
710 ,p_attribute21 => p_attribute21
711 ,p_attribute22 => p_attribute22
712 ,p_attribute23 => p_attribute23
713 ,p_attribute24 => p_attribute24
714 ,p_attribute25 => p_attribute25
715 ,p_attribute26 => p_attribute26
716 ,p_attribute27 => p_attribute27
717 ,p_attribute28 => p_attribute28
718 ,p_attribute29 => p_attribute29
719 ,p_attribute30 => p_attribute30
720 );
721 exception
722 when hr_api.cannot_find_prog_unit then
723 hr_api.cannot_find_prog_unit_error
724 (p_module_name => 'UPDATE_ACCOMMODATION'
725 ,p_hook_type => 'BP'
726 );
727 end;
728 --
729 -- Validation in addition to Row Handlers
730 --
731
732
733
734 --
735 -- Process Logic
736 --
737 pqh_acc_upd.upd
738 (p_effective_date => p_effective_date
739 ,p_datetrack_mode => p_datetrack_mode
740 ,p_accommodation_id => p_accommodation_id
741 ,p_object_version_number => p_object_version_number
742 ,p_accommodation_name => p_accommodation_name
743 ,p_business_group_id => p_business_group_id
744 ,p_location_id => p_location_id
745 ,p_accommodation_desc => p_accommodation_desc
746 ,p_accommodation_type => p_accommodation_type
747 ,p_style => p_style
748 ,p_address_line_1 => p_address_line_1
749 ,p_address_line_2 => p_address_line_3
750 ,p_address_line_3 => p_address_line_3
751 ,p_town_or_city => p_town_or_city
752 ,p_country => p_country
753 ,p_postal_code => p_postal_code
754 ,p_region_1 => p_region_1
755 ,p_region_2 => p_region_2
756 ,p_region_3 => p_region_3
757 ,p_telephone_number_1 => p_telephone_number_1
758 ,p_telephone_number_2 => p_telephone_number_2
759 ,p_telephone_number_3 => p_telephone_number_3
760 ,p_floor_number => p_floor_number
761 ,p_floor_area => p_floor_area
762 ,p_floor_area_measure_unit => p_floor_area_measure_unit
763 ,p_main_rooms => p_main_rooms
764 ,p_family_size => p_family_size
765 ,p_suitability_disabled => p_suitability_disabled
766 ,p_rental_value => p_rental_value
767 ,p_rental_value_currency => p_rental_value_currency
768 ,p_owner => p_owner
769 ,p_comments => p_comments
770 ,p_information_category => p_information_category
771 ,p_information1 => p_information1
772 ,p_information2 => p_information2
773 ,p_information3 => p_information3
774 ,p_information4 => p_information4
775 ,p_information5 => p_information5
776 ,p_information6 => p_information6
777 ,p_information7 => p_information7
778 ,p_information8 => p_information8
779 ,p_information9 => p_information9
780 ,p_information10 => p_information10
781 ,p_information11 => p_information11
782 ,p_information12 => p_information12
783 ,p_information13 => p_information13
784 ,p_information14 => p_information14
785 ,p_information15 => p_information15
786 ,p_information16 => p_information16
787 ,p_information17 => p_information17
788 ,p_information18 => p_information18
789 ,p_information19 => p_information19
790 ,p_information20 => p_information20
791 ,p_information21 => p_information21
792 ,p_information22 => p_information22
793 ,p_information23 => p_information23
794 ,p_information24 => p_information24
798 ,p_information28 => p_information28
795 ,p_information25 => p_information25
796 ,p_information26 => p_information26
797 ,p_information27 => p_information27
799 ,p_information29 => p_information29
800 ,p_information30 => p_information30
801 ,p_attribute_category => p_attribute_category
802 ,p_attribute1 => p_attribute1
803 ,p_attribute2 => p_attribute2
804 ,p_attribute3 => p_attribute3
805 ,p_attribute4 => p_attribute4
806 ,p_attribute5 => p_attribute5
807 ,p_attribute6 => p_attribute6
808 ,p_attribute7 => p_attribute7
809 ,p_attribute8 => p_attribute8
810 ,p_attribute9 => p_attribute9
811 ,p_attribute10 => p_attribute10
812 ,p_attribute11 => p_attribute11
813 ,p_attribute12 => p_attribute12
814 ,p_attribute13 => p_attribute13
815 ,p_attribute14 => p_attribute14
816 ,p_attribute15 => p_attribute15
817 ,p_attribute16 => p_attribute16
818 ,p_attribute17 => p_attribute17
819 ,p_attribute18 => p_attribute18
820 ,p_attribute19 => p_attribute19
821 ,p_attribute20 => p_attribute20
822 ,p_attribute21 => p_attribute21
823 ,p_attribute22 => p_attribute22
824 ,p_attribute23 => p_attribute23
825 ,p_attribute24 => p_attribute24
826 ,p_attribute25 => p_attribute25
827 ,p_attribute26 => p_attribute26
828 ,p_attribute27 => p_attribute27
829 ,p_attribute28 => p_attribute28
830 ,p_attribute29 => p_attribute29
831 ,p_attribute30 => p_attribute30
832 ,p_effective_start_date => l_effective_start_date
833 ,p_effective_end_date => l_effective_end_date
834 );
835
836
837 --
838 -- Call After Process User Hook
839 --
840 begin
841 PQH_ACCOMMODATIONS_BK2.update_accommodation_a
842 (p_effective_date => p_effective_date
843 ,p_datetrack_mode => p_datetrack_mode
844 ,p_accommodation_id => p_accommodation_id
845 ,p_object_version_number => p_object_version_number
846 ,p_accommodation_name => p_accommodation_name
847 ,p_business_group_id => p_business_group_id
848 ,p_location_id => p_location_id
849 ,p_accommodation_desc => p_accommodation_desc
850 ,p_accommodation_type => p_accommodation_type
851 ,p_style => p_style
852 ,p_address_line_1 => p_address_line_1
853 ,p_address_line_2 => p_address_line_3
854 ,p_address_line_3 => p_address_line_3
855 ,p_town_or_city => p_town_or_city
856 ,p_country => p_country
857 ,p_postal_code => p_postal_code
858 ,p_region_1 => p_region_1
859 ,p_region_2 => p_region_2
860 ,p_region_3 => p_region_3
861 ,p_telephone_number_1 => p_telephone_number_1
862 ,p_telephone_number_2 => p_telephone_number_2
863 ,p_telephone_number_3 => p_telephone_number_3
864 ,p_floor_number => p_floor_number
865 ,p_floor_area => p_floor_area
866 ,p_floor_area_measure_unit => p_floor_area_measure_unit
867 ,p_main_rooms => p_main_rooms
868 ,p_family_size => p_family_size
869 ,p_suitability_disabled => p_suitability_disabled
870 ,p_rental_value => p_rental_value
871 ,p_rental_value_currency => p_rental_value_currency
872 ,p_owner => p_owner
873 ,p_comments => p_comments
874 ,p_information_category => p_information_category
875 ,p_information1 => p_information1
876 ,p_information2 => p_information2
877 ,p_information3 => p_information3
878 ,p_information4 => p_information4
879 ,p_information5 => p_information5
880 ,p_information6 => p_information6
881 ,p_information7 => p_information7
882 ,p_information8 => p_information8
883 ,p_information9 => p_information9
884 ,p_information10 => p_information10
885 ,p_information11 => p_information11
886 ,p_information12 => p_information12
887 ,p_information13 => p_information13
888 ,p_information14 => p_information14
889 ,p_information15 => p_information15
890 ,p_information16 => p_information16
891 ,p_information17 => p_information17
892 ,p_information18 => p_information18
893 ,p_information19 => p_information19
897 ,p_information23 => p_information23
894 ,p_information20 => p_information20
895 ,p_information21 => p_information21
896 ,p_information22 => p_information22
898 ,p_information24 => p_information24
899 ,p_information25 => p_information25
900 ,p_information26 => p_information26
901 ,p_information27 => p_information27
902 ,p_information28 => p_information28
903 ,p_information29 => p_information29
904 ,p_information30 => p_information30
905 ,p_attribute_category => p_attribute_category
906 ,p_attribute1 => p_attribute1
907 ,p_attribute2 => p_attribute2
908 ,p_attribute3 => p_attribute3
909 ,p_attribute4 => p_attribute4
910 ,p_attribute5 => p_attribute5
911 ,p_attribute6 => p_attribute6
912 ,p_attribute7 => p_attribute7
913 ,p_attribute8 => p_attribute8
914 ,p_attribute9 => p_attribute9
915 ,p_attribute10 => p_attribute10
916 ,p_attribute11 => p_attribute11
917 ,p_attribute12 => p_attribute12
918 ,p_attribute13 => p_attribute13
919 ,p_attribute14 => p_attribute14
920 ,p_attribute15 => p_attribute15
921 ,p_attribute16 => p_attribute16
922 ,p_attribute17 => p_attribute17
923 ,p_attribute18 => p_attribute18
924 ,p_attribute19 => p_attribute19
925 ,p_attribute20 => p_attribute20
926 ,p_attribute21 => p_attribute21
927 ,p_attribute22 => p_attribute22
928 ,p_attribute23 => p_attribute23
929 ,p_attribute24 => p_attribute24
930 ,p_attribute25 => p_attribute25
931 ,p_attribute26 => p_attribute26
932 ,p_attribute27 => p_attribute27
933 ,p_attribute28 => p_attribute28
934 ,p_attribute29 => p_attribute29
935 ,p_attribute30 => p_attribute30
936 ,p_effective_start_date => l_effective_start_date
937 ,p_effective_end_date => l_effective_end_date
938 );
939 exception
940 when hr_api.cannot_find_prog_unit then
941 hr_api.cannot_find_prog_unit_error
942 (p_module_name => 'UPDATE_ACCOMMODATION'
943 ,p_hook_type => 'AP'
944 );
945 end;
946 --
947 -- When in validation only mode raise the Validate_Enabled exception
948 --
949 if p_validate then
950 raise hr_api.validate_enabled;
951 end if;
952 --
953 -- Set all output arguments
954 --
955 p_object_version_number := p_object_version_number;
956 p_effective_start_date := l_effective_start_date;
957 p_effective_end_date := l_effective_end_date;
958 --
959 hr_utility.set_location(' Leaving:'||l_proc, 70);
960 exception
961 when hr_api.validate_enabled then
962 --
963 -- As the Validate_Enabled exception has been raised
964 -- we must rollback to the savepoint
965 --
966 rollback to UPDATE_ACCOMMODATION;
967 --
968 -- Only set output warning arguments
969 -- (Any key or derived arguments must be set to null
970 -- when validation only mode is being used.)
971 --
972 p_object_version_number := l_object_version_number;
973 p_effective_start_date := null;
974 p_effective_end_date := null;
975
976 hr_utility.set_location(' Leaving:'||l_proc, 80);
977 when others then
978 --
979 -- A validation or unexpected error has occured
980 --
981
982 p_object_version_number := l_object_version_number;
983 p_effective_start_date := null;
984 p_effective_end_date := null;
985
986 rollback to UPDATE_ACCOMMODATION;
987 hr_utility.set_location(' Leaving:'||l_proc, 90);
988 raise;
989 end update_accommodation;
990 --
991 --
992 -- ----------------------------------------------------------------------------
993 -- |--------------------------<delete_accommodation>--------------------------|
994 -- ----------------------------------------------------------------------------
995 --
996 procedure delete_accommodation
997 (p_validate in boolean default false
998 ,p_effective_date in date
999 ,p_datetrack_mode in varchar2
1000 ,p_accommodation_id in number
1001 ,p_object_version_number in out nocopy number
1002 ,p_effective_start_date out nocopy date
1003 ,p_effective_end_date out nocopy date
1004 ) is
1005 --
1006 -- Declare cursors and local variables
1007 --
1008
1009 l_proc varchar2(72) := g_package||'DELETE_SITUATION';
1010 l_effective_start_date pqh_accommodations_f.effective_start_date%TYPE;
1011 l_effective_end_date pqh_accommodations_f.effective_end_date%TYPE;
1012 l_object_version_number number := p_object_version_number;
1013 --
1014 begin
1015 hr_utility.set_location('Entering:'|| l_proc, 10);
1016 --
1017 -- Issue a savepoint
1018 --
1019 savepoint DELETE_ACCOMMODATION;
1020 --
1021 -- Truncate the time portion from all IN date parameters
1022 --
1023
1024 --
1025 -- Call Before Process User Hook
1026 --
1027 begin
1028 PQH_ACCOMMODATIONS_BK3.delete_accommodation_b
1032 ,p_object_version_number => p_object_version_number
1029 (p_effective_date => p_effective_date
1030 ,p_datetrack_mode => p_datetrack_mode
1031 ,p_accommodation_id => p_accommodation_id
1033 );
1034 exception
1035 when hr_api.cannot_find_prog_unit then
1036 hr_api.cannot_find_prog_unit_error
1037 (p_module_name => 'DELETE_ACCOMMODATION'
1038 ,p_hook_type => 'BP'
1039 );
1040 end;
1041 --
1042 -- Validation in addition to Row Handlers
1043 --
1044
1045
1046
1047 --
1048 -- Process Logic
1049 --
1050 pqh_acc_del.del
1051 (p_effective_date => p_effective_date
1052 ,p_datetrack_mode => p_datetrack_mode
1053 ,p_accommodation_id => p_accommodation_id
1054 ,p_object_version_number => p_object_version_number
1055 ,p_effective_start_date => l_effective_start_date
1056 ,p_effective_end_date => l_effective_end_date
1057 );
1058
1059
1060 --
1061 -- Call After Process User Hook
1062 --
1063 begin
1064 PQH_ACCOMMODATIONS_BK3.delete_accommodation_a
1065 (p_effective_date => p_effective_date
1066 ,p_datetrack_mode => p_datetrack_mode
1067 ,p_accommodation_id => p_accommodation_id
1068 ,p_object_version_number => p_object_version_number
1069 ,p_effective_start_date => l_effective_start_date
1070 ,p_effective_end_date => l_effective_end_date
1071 );
1072 exception
1073 when hr_api.cannot_find_prog_unit then
1074 hr_api.cannot_find_prog_unit_error
1075 (p_module_name => 'DELETE_ACCOMMODATION'
1076 ,p_hook_type => 'AP'
1077 );
1078 end;
1079 --
1080 -- When in validation only mode raise the Validate_Enabled exception
1081 --
1082 if p_validate then
1083 raise hr_api.validate_enabled;
1084 end if;
1085 --
1086 p_object_version_number := p_object_version_number;
1087 p_effective_start_date := l_effective_start_date;
1088 p_effective_end_date := l_effective_end_date;
1089 --
1090 --
1091 hr_utility.set_location(' Leaving:'||l_proc, 70);
1092 exception
1093 when hr_api.validate_enabled then
1094 --
1095 -- As the Validate_Enabled exception has been raised
1096 -- we must rollback to the savepoint
1097 --
1098 rollback to DELETE_ACCOMMODATION;
1099 --
1100 -- Only set output warning arguments
1101 -- (Any key or derived arguments must be set to null
1102 -- when validation only mode is being used.)
1103 --
1104 p_object_version_number := l_object_version_number;
1105 p_effective_start_date := null;
1106 p_effective_end_date := null;
1107 --
1111 -- A validation or unexpected error has occured
1108 hr_utility.set_location(' Leaving:'||l_proc, 80);
1109 when others then
1110 --
1112 --
1113 p_object_version_number := l_object_version_number;
1114 p_effective_start_date := null;
1115 p_effective_end_date := null;
1116
1117 rollback to DELETE_ACCOMMODATION;
1118 hr_utility.set_location(' Leaving:'||l_proc, 90);
1119 raise;
1120 end delete_accommodation;
1121 --
1122 end pqh_accommodations_api;