[Home] [Help]
PACKAGE BODY: APPS.OTA_BOOKING_STATUS_TYPE_API
Source
1 PACKAGE BODY OTA_BOOKING_STATUS_TYPE_API as
2 /* $Header: otbstapi.pkb 120.0 2005/05/29 07:04:39 appldev noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' OTA_BOOKING_STATUS_TYPE_API.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |-------------------------< CREATE_BOOKING_STATUS_TYPE >------------------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure CREATE_BOOKING_STATUS_TYPE(
13 p_validate in boolean default false
14 ,p_effective_date in date
15 ,p_business_group_id in number
16 ,p_active_flag in varchar2 default null
17 ,p_default_flag in varchar2 default null
18 ,p_name in varchar2 default null
19 ,p_type in varchar2 default null
20 ,p_place_used_flag in varchar2 default null
21 ,p_comments in varchar2 default null
22 ,p_description in varchar2 default null
23 ,p_bst_information_category in varchar2 default null
24 ,p_bst_information1 in varchar2 default null
25 ,p_bst_information2 in varchar2 default null
26 ,p_bst_information3 in varchar2 default null
27 ,p_bst_information4 in varchar2 default null
28 ,p_bst_information5 in varchar2 default null
29 ,p_bst_information6 in varchar2 default null
30 ,p_bst_information7 in varchar2 default null
31 ,p_bst_information8 in varchar2 default null
32 ,p_bst_information9 in varchar2 default null
33 ,p_bst_information10 in varchar2 default null
34 ,p_bst_information11 in varchar2 default null
35 ,p_bst_information12 in varchar2 default null
36 ,p_bst_information13 in varchar2 default null
37 ,p_bst_information14 in varchar2 default null
38 ,p_bst_information15 in varchar2 default null
39 ,p_bst_information16 in varchar2 default null
40 ,p_bst_information17 in varchar2 default null
41 ,p_bst_information18 in varchar2 default null
42 ,p_bst_information19 in varchar2 default null
43 ,p_bst_information20 in varchar2 default null
44 , p_object_version_number out nocopy number
45 , p_booking_status_type_id out nocopy number
46 -- ,p_data_source in varchar2 default null
47 ) is
48 --
49 -- Declare cursors and local variables
50 --
51 l_proc varchar2(72) := g_package||' Create Training Plan';
52 l_booking_status_type_id number;
53 l_object_version_number number;
54 l_effective_date date;
55 l_name varchar2(80);
56 begin
57 hr_utility.set_location('Entering:'|| l_proc, 10);
58 --
59 -- Issue a savepoint
60 --
61 savepoint CREATE_BOOKING_STATUS_TYPE;
62 --
63 -- Truncate the time portion from all IN date parameters
64 --
65 l_effective_date := trunc(p_effective_date);
66
67 l_name := rtrim(p_name);
68 --
69 -- Call Before Process User Hook
70 --
71
72 begin
73 OTA_BOOKING_STATUS_TYPE_BK1.CREATE_BOOKING_STATUS_TYPE_B
74 (p_effective_date => l_effective_date
75 ,p_business_group_id => p_business_group_id
76 ,p_active_flag => p_active_flag
77 ,p_default_flag => p_default_flag
78 ,p_place_used_flag => p_place_used_flag
79 ,p_name => p_name
80 ,p_type => p_type
81 ,p_comments => p_comments
82 ,p_description => p_description
83 ,p_bst_information_category => p_bst_information_category
84 ,p_bst_information1 => p_bst_information1
85 ,p_bst_information2 => p_bst_information2
86 ,p_bst_information3 => p_bst_information3
87 ,p_bst_information4 => p_bst_information4
88 ,p_bst_information5 => p_bst_information5
89 ,p_bst_information6 => p_bst_information6
90 ,p_bst_information7 => p_bst_information7
91 ,p_bst_information8 => p_bst_information8
92 ,p_bst_information9 => p_bst_information9
93 ,p_bst_information10 => p_bst_information10
94 ,p_bst_information11 => p_bst_information11
95 ,p_bst_information12 => p_bst_information12
96 ,p_bst_information13 => p_bst_information13
97 ,p_bst_information14 => p_bst_information14
98 ,p_bst_information15 => p_bst_information15
99 ,p_bst_information16 => p_bst_information16
100 ,p_bst_information17 => p_bst_information17
101 ,p_bst_information18 => p_bst_information18
102 ,p_bst_information19 => p_bst_information19
103 ,p_bst_information20 => p_bst_information20
104 -- ,p_data_source => p_data_source
105 );
106 exception
107 when hr_api.cannot_find_prog_unit then
108 hr_api.cannot_find_prog_unit_error
109 (p_module_name => 'CREATE_BOOKING_STATUS_TYPE'
110 ,p_hook_type => 'BP'
111 );
112 end;
113 --
114
115 -- Validation in addition to Row Handlers
116 --
117 --
118 -- Process Logic
119 --
120 /*
121 l_end_date := END_DATE(
122 p_start_date ,
123 p_end_date ,
124 p_duration ,
125 p_duration_units );
126 */
127 ota_bst_api.ins
128 ( -- p_effective_date => l_effective_date
129 p_booking_status_type_id => l_booking_status_type_id
130 ,p_business_group_id => p_business_group_id
131 ,p_active_flag => p_active_flag
132 ,p_default_flag => p_default_flag
133 -- ,p_place_used_flag => p_place_used_flag
134 ,p_name => p_name
135 ,p_object_version_number => l_object_version_number
136 ,p_type => p_type
137 ,p_comments => p_comments
138 ,p_description => p_description
139 ,p_bst_information_category => p_bst_information_category
140 ,p_bst_information1 => p_bst_information1
141 ,p_bst_information2 => p_bst_information2
142 ,p_bst_information3 => p_bst_information3
143 ,p_bst_information4 => p_bst_information4
144 ,p_bst_information5 => p_bst_information5
145 ,p_bst_information6 => p_bst_information6
146 ,p_bst_information7 => p_bst_information7
147 ,p_bst_information8 => p_bst_information8
148 ,p_bst_information9 => p_bst_information9
149 ,p_bst_information10 => p_bst_information10
150 ,p_bst_information11 => p_bst_information11
151 ,p_bst_information12 => p_bst_information12
152 ,p_bst_information13 => p_bst_information13
153 ,p_bst_information14 => p_bst_information14
154 ,p_bst_information15 => p_bst_information15
155 ,p_bst_information16 => p_bst_information16
156 ,p_bst_information17 => p_bst_information17
157 ,p_bst_information18 => p_bst_information18
158 ,p_bst_information19 => p_bst_information19
159 ,p_bst_information20 => p_bst_information20
160
161 );
162
163 ota_bsl_ins.ins_tl
164 (p_effective_date => l_effective_date
165 ,p_language_code => USERENV('LANG')
166 ,p_booking_status_type_id => l_booking_status_type_id
167 ,p_name => l_name
168 ,p_description => p_description );
169 --
170 -- Call After Process User Hook
171 --
172
173 begin
174 OTA_BOOKING_STATUS_TYPE_BK1.CREATE_BOOKING_STATUS_TYPE_A
175 (p_effective_date => l_effective_date
176 ,p_business_group_id => p_business_group_id
177 ,p_active_flag => p_active_flag
178 ,p_default_flag => p_default_flag
179 ,p_place_used_flag => p_place_used_flag
180 ,p_name => p_name
181 ,p_type => p_type
182 ,p_comments => p_comments
183 ,p_description => p_description
184 ,p_bst_information_category => p_bst_information_category
185 ,p_bst_information1 => p_bst_information1
186 ,p_bst_information2 => p_bst_information2
187 ,p_bst_information3 => p_bst_information3
188 ,p_bst_information4 => p_bst_information4
189 ,p_bst_information5 => p_bst_information5
190 ,p_bst_information6 => p_bst_information6
191 ,p_bst_information7 => p_bst_information7
192 ,p_bst_information8 => p_bst_information8
193 ,p_bst_information9 => p_bst_information9
194 ,p_bst_information10 => p_bst_information10
195 ,p_bst_information11 => p_bst_information11
196 ,p_bst_information12 => p_bst_information12
197 ,p_bst_information13 => p_bst_information13
198 ,p_bst_information14 => p_bst_information14
199 ,p_bst_information15 => p_bst_information15
200 ,p_bst_information16 => p_bst_information16
201 ,p_bst_information17 => p_bst_information17
202 ,p_bst_information18 => p_bst_information18
203 ,p_bst_information19 => p_bst_information19
204 ,p_bst_information20 => p_bst_information20
205 ,p_booking_status_type_id => l_booking_status_type_id
206 ,p_object_version_number => l_object_version_number
207 -- ,p_data_source => p_data_source
208 );
209 exception
210 when hr_api.cannot_find_prog_unit then
211 hr_api.cannot_find_prog_unit_error
212 (p_module_name => 'CREATE_BOOKING_STATUS_TYPE'
213 ,p_hook_type => 'AP'
214 );
215 end;
216
217 --
218 -- When in validation only mode raise the Validate_Enabled exception
219 --
220 if p_validate then
221 raise hr_api.validate_enabled;
222 end if;
223 --
224 -- Set all output arguments
225 --
226 p_booking_status_type_id := l_booking_status_type_id;
227 p_object_version_number := l_object_version_number;
228
229
230 hr_utility.set_location(' Leaving:'||l_proc, 70);
231 exception
232 when hr_api.validate_enabled then
233 --
234 -- As the Validate_Enabled exception has been raised
235 -- we must rollback to the savepoint
236 --
237 rollback to CREATE_BOOKING_STATUS_TYPE;
238 --
239 -- Only set output warning arguments
240 -- (Any key or derived arguments must be set to null
241 -- when validation only mode is being used.)
242 --
243 p_booking_status_type_id := null;
244 p_object_version_number := null;
245 hr_utility.set_location(' Leaving:'||l_proc, 80);
246 when others then
247 --
248 -- A validation or unexpected error has occured
249 --
250 rollback to CREATE_BOOKING_STATUS_TYPE;
251 p_booking_status_type_id := null;
252 p_object_version_number := null;
253 hr_utility.set_location(' Leaving:'||l_proc, 90);
254 raise;
255 end create_BOOKING_STATUS_TYPE;
256 -- ----------------------------------------------------------------------------
257 -- |----------------------------< UPDATE_BOOKING_STATUS_TYPE >---------------------------|
258 -- ----------------------------------------------------------------------------
259 --
260 procedure UPDATE_BOOKING_STATUS_TYPE
261 (p_validate in boolean default false
262 ,p_effective_date in date
263 ,p_business_group_id in number
264 ,p_active_flag in varchar2 default hr_api.g_varchar2
265 ,p_default_flag in varchar2 default hr_api.g_varchar2
266 ,p_name in varchar2 default hr_api.g_varchar2
267 ,p_type in varchar2 default hr_api.g_varchar2
268 ,p_place_used_flag in varchar2 default hr_api.g_varchar2
269 ,p_comments in varchar2 default hr_api.g_varchar2
270 ,p_description in varchar2 default hr_api.g_varchar2
271 ,p_bst_information_category in varchar2 default hr_api.g_varchar2
272 ,p_bst_information1 in varchar2 default hr_api.g_varchar2
273 ,p_bst_information2 in varchar2 default hr_api.g_varchar2
274 ,p_bst_information3 in varchar2 default hr_api.g_varchar2
275 ,p_bst_information4 in varchar2 default hr_api.g_varchar2
276 ,p_bst_information5 in varchar2 default hr_api.g_varchar2
277 ,p_bst_information6 in varchar2 default hr_api.g_varchar2
278 ,p_bst_information7 in varchar2 default hr_api.g_varchar2
279 ,p_bst_information8 in varchar2 default hr_api.g_varchar2
280 ,p_bst_information9 in varchar2 default hr_api.g_varchar2
281 ,p_bst_information10 in varchar2 default hr_api.g_varchar2
282 ,p_bst_information11 in varchar2 default hr_api.g_varchar2
283 ,p_bst_information12 in varchar2 default hr_api.g_varchar2
284 ,p_bst_information13 in varchar2 default hr_api.g_varchar2
285 ,p_bst_information14 in varchar2 default hr_api.g_varchar2
286 ,p_bst_information15 in varchar2 default hr_api.g_varchar2
287 ,p_bst_information16 in varchar2 default hr_api.g_varchar2
288 ,p_bst_information17 in varchar2 default hr_api.g_varchar2
289 ,p_bst_information18 in varchar2 default hr_api.g_varchar2
290 ,p_bst_information19 in varchar2 default hr_api.g_varchar2
291 ,p_bst_information20 in varchar2 default hr_api.g_varchar2
292 ,p_booking_status_type_id in number default hr_api.g_number
293 ,p_object_version_number in out nocopy number
294 -- ,p_data_source in varchar2 default hr_api.g_varchar2
295 ) is
296 --
297 -- Declare cursors and local variables
298 --
299 l_proc varchar2(72) := g_package||' Update Training Plan';
300 l_effective_date date;
301 l_object_version_number number := p_object_version_number;
302 l_name varchar2(80);
303 begin
304 hr_utility.set_location('Entering:'|| l_proc, 10);
305 --
306 -- Issue a savepoint
307 --
308 savepoint UPDATE_BOOKING_STATUS_TYPE;
309 --
310 -- Truncate the time portion from all IN date parameters
311 --
312 l_effective_date := trunc(p_effective_date);
313 l_name := rtrim(p_name);
314 --
315 -- Call Before Process User Hook
316 --
317
318 begin
319 OTA_BOOKING_STATUS_TYPE_BK2.UPDATE_BOOKING_STATUS_TYPE_B
320 (p_effective_date => l_effective_date
324 ,p_place_used_flag => p_place_used_flag
321 ,p_business_group_id => p_business_group_id
322 ,p_active_flag => p_active_flag
323 ,p_default_flag => p_default_flag
325 ,p_name => p_name
326 ,p_type => p_type
327 ,p_comments => p_comments
328 ,p_description => p_description
329 ,p_bst_information_category => p_bst_information_category
330 ,p_bst_information1 => p_bst_information1
331 ,p_bst_information2 => p_bst_information2
332 ,p_bst_information3 => p_bst_information3
333 ,p_bst_information4 => p_bst_information4
334 ,p_bst_information5 => p_bst_information5
335 ,p_bst_information6 => p_bst_information6
336 ,p_bst_information7 => p_bst_information7
337 ,p_bst_information8 => p_bst_information8
338 ,p_bst_information9 => p_bst_information9
339 ,p_bst_information10 => p_bst_information10
340 ,p_bst_information11 => p_bst_information11
341 ,p_bst_information12 => p_bst_information12
342 ,p_bst_information13 => p_bst_information13
343 ,p_bst_information14 => p_bst_information14
344 ,p_bst_information15 => p_bst_information15
345 ,p_bst_information16 => p_bst_information16
346 ,p_bst_information17 => p_bst_information17
347 ,p_bst_information18 => p_bst_information18
348 ,p_bst_information19 => p_bst_information19
349 ,p_bst_information20 => p_bst_information20
350 ,p_booking_status_type_id => p_booking_status_type_id
351 ,p_object_version_number => p_object_version_number
352 -- ,p_data_source => p_data_source
353 );
354 exception
355 when hr_api.cannot_find_prog_unit then
356 hr_api.cannot_find_prog_unit_error
357 (p_module_name => 'UPDATE_BOOKING_STATUS_TYPE'
358 ,p_hook_type => 'BP'
359 );
360 end;
361 --
362 -- Validation in addition to Row Handlers
363 --
364 --
365 -- Process Logic
366 --
367
368 ota_bst_api.upd
369 (--p_effective_date => l_effective_date
370 p_booking_status_type_id => p_booking_status_type_id
371 ,p_business_group_id => p_business_group_id
372 ,p_active_flag => p_active_flag
373 ,p_default_flag => p_default_flag
374 -- ,p_place_used_flag => p_place_used_flag
375 ,p_name => p_name
376 ,p_object_version_number => p_object_version_number
377 ,p_type => p_type
378 ,p_comments => p_comments
379 ,p_description => p_description
380 ,p_bst_information_category => p_bst_information_category
381 ,p_bst_information1 => p_bst_information1
382 ,p_bst_information2 => p_bst_information2
383 ,p_bst_information3 => p_bst_information3
384 ,p_bst_information4 => p_bst_information4
385 ,p_bst_information5 => p_bst_information5
386 ,p_bst_information6 => p_bst_information6
387 ,p_bst_information7 => p_bst_information7
388 ,p_bst_information8 => p_bst_information8
389 ,p_bst_information9 => p_bst_information9
390 ,p_bst_information10 => p_bst_information10
391 ,p_bst_information11 => p_bst_information11
392 ,p_bst_information12 => p_bst_information12
393 ,p_bst_information13 => p_bst_information13
394 ,p_bst_information14 => p_bst_information14
395 ,p_bst_information15 => p_bst_information15
396 ,p_bst_information16 => p_bst_information16
397 ,p_bst_information17 => p_bst_information17
398 ,p_bst_information18 => p_bst_information18
399 ,p_bst_information19 => p_bst_information19
400 ,p_bst_information20 => p_bst_information20
401
402 );
403
404 ota_bsl_upd.upd_tl(p_effective_date => p_effective_date
405 ,p_language_code => USERENV('LANG')
406 ,P_BOOKING_STATUS_TYPE_ID => P_BOOKING_STATUS_TYPE_ID
407 ,p_name => l_name
408 ,p_description => p_description );
409 --
410 -- Call After Process User Hook
411 --
412 begin
413 OTA_BOOKING_STATUS_TYPE_BK2.UPDATE_BOOKING_STATUS_TYPE_A
414 (p_effective_date => l_effective_date
415 ,p_business_group_id => p_business_group_id
416 ,p_active_flag => p_active_flag
417 ,p_default_flag => p_default_flag
418 ,p_place_used_flag => p_place_used_flag
419 ,p_name => p_name
420 ,p_type => p_type
421 ,p_comments => p_comments
422 ,p_description => p_description
423 ,p_bst_information_category => p_bst_information_category
424 ,p_bst_information1 => p_bst_information1
425 ,p_bst_information2 => p_bst_information2
426 ,p_bst_information3 => p_bst_information3
427 ,p_bst_information4 => p_bst_information4
428 ,p_bst_information5 => p_bst_information5
429 ,p_bst_information6 => p_bst_information6
430 ,p_bst_information7 => p_bst_information7
431 ,p_bst_information8 => p_bst_information8
432 ,p_bst_information9 => p_bst_information9
433 ,p_bst_information10 => p_bst_information10
434 ,p_bst_information11 => p_bst_information11
435 ,p_bst_information12 => p_bst_information12
436 ,p_bst_information13 => p_bst_information13
437 ,p_bst_information14 => p_bst_information14
438 ,p_bst_information15 => p_bst_information15
439 ,p_bst_information16 => p_bst_information16
443 ,p_bst_information20 => p_bst_information20
440 ,p_bst_information17 => p_bst_information17
441 ,p_bst_information18 => p_bst_information18
442 ,p_bst_information19 => p_bst_information19
444 ,p_booking_status_type_id => p_booking_status_type_id
445 ,p_object_version_number => p_object_version_number
446 -- ,p_data_source => p_data_source
447 );
448 exception
449 when hr_api.cannot_find_prog_unit then
450 hr_api.cannot_find_prog_unit_error
451 (p_module_name => 'UPDATE_BOOKING_STATUS_TYPE'
452 ,p_hook_type => 'AP'
453 );
454 end;
455
456 --
457 -- When in validation only mode raise the Validate_Enabled exception
458 --
459 if p_validate then
460 raise hr_api.validate_enabled;
461 end if;
462 --
463 -- Set all output arguments
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 UPDATE_BOOKING_STATUS_TYPE;
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_object_version_number := null;
479 hr_utility.set_location(' Leaving:'||l_proc, 80);
480 when others then
481 --
482 -- A validation or unexpected error has occured
483 --
484 rollback to UPDATE_BOOKING_STATUS_TYPE;
485 p_object_version_number := l_object_version_number;
486 hr_utility.set_location(' Leaving:'||l_proc, 90);
487 raise;
488 end update_BOOKING_STATUS_TYPE;
489 --
490 -- ----------------------------------------------------------------------------
491 -- |-------------------------< DELETE_BOOKING_STATUS_TYPE >------------------------------|
492 -- ----------------------------------------------------------------------------
493 --
494 procedure delete_BOOKING_STATUS_TYPE
495 (p_validate in boolean default false
496 ,p_booking_status_type_id in number
497 ,p_object_version_number in number
498 ) is
499 --
500 -- Declare cursors and local variables
501 --
502 l_proc varchar2(72) := g_package||' Delete Training Plan';
503 l_object_version_id number;
504 --
505 --
506 begin
507 hr_utility.set_location('Entering:'|| l_proc, 10);
508 --
509 -- Issue a savepoint
510 --
511 savepoint DELETE_BOOKING_STATUS_TYPE;
512 --
513 -- Truncate the time portion from all IN date parameters
514 --
515 --
516
517 -- Call Before Process User Hook
518 --
519 begin
520 OTA_BOOKING_STATUS_TYPE_BK3.DELETE_BOOKING_STATUS_TYPE_B
521 (p_BOOKING_STATUS_TYPE_id => p_BOOKING_STATUS_TYPE_id
522 ,p_object_version_number => p_object_version_number
523 );
524 exception
525 when hr_api.cannot_find_prog_unit then
526 hr_api.cannot_find_prog_unit_error
527 (p_module_name => 'DELETE_BOOKING_STATUS_TYPE'
528 ,p_hook_type => 'BP'
529 );
530 end;
531 --
532 -- Validation in addition to Row Handlers
533 --
534 --
535 -- Process Logic
536 --
537 ota_bst_api.del
538 (P_BOOKING_STATUS_TYPE_ID => P_BOOKING_STATUS_TYPE_ID
539 ,p_object_version_number => p_object_version_number
540 ,p_validate => p_validate
541 );
542
543 ota_bsl_del.del_tl
544 (P_BOOKING_STATUS_TYPE_ID => P_BOOKING_STATUS_TYPE_ID
545 --,p_language => USERENV('LANG')
546 );
547 --
548 -- Call After Process User Hook
549 --
550 begin
551 OTA_BOOKING_STATUS_TYPE_BK3.DELETE_BOOKING_STATUS_TYPE_A
552 (P_BOOKING_STATUS_TYPE_ID => P_BOOKING_STATUS_TYPE_ID
553 ,p_object_version_number => p_object_version_number
554 );
555 exception
556 when hr_api.cannot_find_prog_unit then
557 hr_api.cannot_find_prog_unit_error
558 (p_module_name => 'DELETE_BOOKING_STATUS_TYPE'
559 ,p_hook_type => 'AP'
560 );
561 end;
562
563 --
564 -- When in validation only mode raise the Validate_Enabled exception
565 --
566 if p_validate then
567 raise hr_api.validate_enabled;
568 end if;
569 --
570 -- Set all output arguments
571 --
572 --
573 hr_utility.set_location(' Leaving:'||l_proc, 170);
574 exception
575 when hr_api.validate_enabled then
576 --
577 -- As the Validate_Enabled exception has been raised
578 -- we must rollback to the savepoint
579 --
580 rollback to DELETE_BOOKING_STATUS_TYPE;
581 --
582 -- Only set output warning arguments
583 -- (Any key or derived arguments must be set to null
584 -- when validation only mode is being used.)
585 --
586 hr_utility.set_location(' Leaving:'||l_proc, 180);
587 when others then
588 --
589 -- A validation or unexpected error has occured
590 --
591 rollback to DELETE_BOOKING_STATUS_TYPE;
592 hr_utility.set_location(' Leaving:'||l_proc, 190);
593 raise;
594 end delete_BOOKING_STATUS_TYPE;
595 --
596
597
598 END OTA_BOOKING_STATUS_TYPE_API;