[Home] [Help]
PACKAGE BODY: APPS.OTA_DELEGATE_BOOKING_SWI
Source
1 Package Body ota_delegate_booking_swi As
2 /* $Header: otenrswi.pkb 120.4.12010000.3 2008/08/05 11:43:55 ubhat ship $ */
3 --
4 -- Package variables
5 --
6 g_package varchar2(33) := 'ota_delegate_booking_swi.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_delegate_booking >-----------------------|
10 -- ----------------------------------------------------------------------------
11 PROCEDURE create_delegate_booking
12 (p_effective_date in date
13 ,p_booking_id in number
14 ,p_booking_status_type_id in number
15 ,p_delegate_person_id in number default null
16 ,p_contact_id in number
17 ,p_business_group_id in number
18 ,p_event_id in number
19 ,p_customer_id in number default null
20 ,p_authorizer_person_id in number default null
21 ,p_date_booking_placed in date
22 ,p_corespondent in varchar2 default null
23 ,p_internal_booking_flag in varchar2
24 ,p_number_of_places in number
25 ,p_object_version_number out nocopy number
26 ,p_administrator in number default null
27 ,p_booking_priority in varchar2 default null
28 ,p_comments in varchar2 default null
29 ,p_contact_address_id in number default null
30 ,p_delegate_contact_phone in varchar2 default null
31 ,p_delegate_contact_fax in varchar2 default null
32 ,p_third_party_customer_id in number default null
33 ,p_third_party_contact_id in number default null
34 ,p_third_party_address_id in number default null
35 ,p_third_party_contact_phone in varchar2 default null
36 ,p_third_party_contact_fax in varchar2 default null
37 ,p_date_status_changed in date default null
38 ,p_failure_reason in varchar2 default null
39 ,p_attendance_result in varchar2 default null
40 ,p_language_id in number default null
41 ,p_source_of_booking in varchar2 default null
42 ,p_special_booking_instructions in varchar2 default null
43 ,p_successful_attendance_flag in varchar2 default null
44 ,p_tdb_information_category in varchar2 default null
45 ,p_tdb_information1 in varchar2 default null
46 ,p_tdb_information2 in varchar2 default null
47 ,p_tdb_information3 in varchar2 default null
48 ,p_tdb_information4 in varchar2 default null
49 ,p_tdb_information5 in varchar2 default null
50 ,p_tdb_information6 in varchar2 default null
51 ,p_tdb_information7 in varchar2 default null
52 ,p_tdb_information8 in varchar2 default null
53 ,p_tdb_information9 in varchar2 default null
54 ,p_tdb_information10 in varchar2 default null
55 ,p_tdb_information11 in varchar2 default null
56 ,p_tdb_information12 in varchar2 default null
57 ,p_tdb_information13 in varchar2 default null
58 ,p_tdb_information14 in varchar2 default null
59 ,p_tdb_information15 in varchar2 default null
60 ,p_tdb_information16 in varchar2 default null
61 ,p_tdb_information17 in varchar2 default null
62 ,p_tdb_information18 in varchar2 default null
63 ,p_tdb_information19 in varchar2 default null
64 ,p_tdb_information20 in varchar2 default null
65 ,p_create_finance_line in varchar2 default null
66 ,p_finance_header_id in number default null
67 ,p_currency_code in varchar2 default null
68 ,p_standard_amount in number default null
69 ,p_unitary_amount in number default null
70 ,p_money_amount in number default null
71 ,p_booking_deal_id in number default null
72 ,p_booking_deal_type in varchar2 default null
73 ,p_finance_line_id in out nocopy number
74 ,p_enrollment_type in varchar2 default null
75 ,p_validate in number default hr_api.g_false_num
76 ,p_organization_id in number default null
77 ,p_sponsor_person_id in number default null
78 ,p_sponsor_assignment_id in number default null
79 ,p_person_address_id in number default null
80 ,p_delegate_assignment_id in number default null
81 ,p_delegate_contact_id in number default null
82 ,p_delegate_contact_email in varchar2 default null
83 ,p_third_party_email in varchar2 default null
84 ,p_person_address_type in varchar2 default null
85 ,p_line_id in number default null
86 ,p_org_id in number default null
87 ,p_daemon_flag in varchar2 default null
88 ,p_daemon_type in varchar2 default null
89 ,p_old_event_id in number default null
90 ,p_quote_line_id in number default null
91 ,p_interface_source in varchar2 default null
92 ,p_total_training_time in varchar2 default null
93 ,p_content_player_status in varchar2 default null
94 ,p_score in number default null
95 ,p_completed_content in number default null
96 ,p_total_content in number default null
97 ,p_return_status out nocopy varchar2
98 ,p_booking_justification_id in number default null
99 ,p_is_history_flag in varchar2 default 'N'
100 ,p_override_prerequisites in varchar2
101 ,p_override_learner_access in varchar2
102 ) is
103 --
104 -- Variables for API Boolean parameters
105 l_validate boolean;
106 --
107 -- Variables for IN/OUT parameters
108 l_finance_line_id number;
109 --
110 -- Other variables
111 l_booking_id number;
112 l_proc varchar2(72) := g_package ||'create_delegate_booking';
113 Begin
114 hr_utility.set_location(' Entering:' || l_proc,10);
115 --
116 -- Issue a savepoint
117 --
118 savepoint create_delegate_booking_swi;
119 --
120 -- Initialise Multiple Message Detection
121 --
122 hr_multi_message.enable_message_list;
123 --
124 -- Remember IN OUT parameter IN values
125 --
126 l_finance_line_id := p_finance_line_id;
127 --
128 -- Convert constant values to their corresponding boolean value
129 --
130 l_validate :=
131 hr_api.constant_to_boolean
132 (p_constant_value => p_validate);
133 --
134 -- Register Surrogate ID or user key values
135 --
136 ota_tdb_ins.set_base_key_value
137 (p_booking_id => p_booking_id
138 );
139 --
140 -- Call API
141 --
142 ota_delegate_booking_api.create_delegate_booking
143 (p_effective_date => p_effective_date
144 ,p_booking_id => l_booking_id
145 ,p_booking_status_type_id => p_booking_status_type_id
146 ,p_delegate_person_id => p_delegate_person_id
147 ,p_contact_id => p_contact_id
148 ,p_business_group_id => p_business_group_id
149 ,p_event_id => p_event_id
150 ,p_customer_id => p_customer_id
151 ,p_authorizer_person_id => p_authorizer_person_id
152 ,p_date_booking_placed => p_date_booking_placed
153 ,p_corespondent => p_corespondent
154 ,p_internal_booking_flag => p_internal_booking_flag
155 ,p_number_of_places => p_number_of_places
156 ,p_object_version_number => p_object_version_number
157 ,p_administrator => p_administrator
158 ,p_booking_priority => p_booking_priority
159 ,p_comments => p_comments
160 ,p_contact_address_id => p_contact_address_id
161 ,p_delegate_contact_phone => p_delegate_contact_phone
162 ,p_delegate_contact_fax => p_delegate_contact_fax
163 ,p_third_party_customer_id => p_third_party_customer_id
164 ,p_third_party_contact_id => p_third_party_contact_id
165 ,p_third_party_address_id => p_third_party_address_id
166 ,p_third_party_contact_phone => p_third_party_contact_phone
167 ,p_third_party_contact_fax => p_third_party_contact_fax
168 --Bug 6888629:Setting date_status_changed to null in create mode for single enrollment
169 -- to maintain consistency with bulk and self enrollment.
170 ,p_date_status_changed => null --p_date_status_changed
171 ,p_failure_reason => p_failure_reason
172 ,p_attendance_result => p_attendance_result
173 ,p_language_id => p_language_id
174 ,p_source_of_booking => p_source_of_booking
175 ,p_special_booking_instructions => p_special_booking_instructions
176 ,p_successful_attendance_flag => p_successful_attendance_flag
177 ,p_tdb_information_category => p_tdb_information_category
178 ,p_tdb_information1 => p_tdb_information1
179 ,p_tdb_information2 => p_tdb_information2
180 ,p_tdb_information3 => p_tdb_information3
181 ,p_tdb_information4 => p_tdb_information4
182 ,p_tdb_information5 => p_tdb_information5
183 ,p_tdb_information6 => p_tdb_information6
184 ,p_tdb_information7 => p_tdb_information7
185 ,p_tdb_information8 => p_tdb_information8
186 ,p_tdb_information9 => p_tdb_information9
187 ,p_tdb_information10 => p_tdb_information10
188 ,p_tdb_information11 => p_tdb_information11
189 ,p_tdb_information12 => p_tdb_information12
190 ,p_tdb_information13 => p_tdb_information13
191 ,p_tdb_information14 => p_tdb_information14
192 ,p_tdb_information15 => p_tdb_information15
193 ,p_tdb_information16 => p_tdb_information16
194 ,p_tdb_information17 => p_tdb_information17
195 ,p_tdb_information18 => p_tdb_information18
196 ,p_tdb_information19 => p_tdb_information19
197 ,p_tdb_information20 => p_tdb_information20
198 ,p_create_finance_line => p_create_finance_line
199 ,p_finance_header_id => p_finance_header_id
200 ,p_currency_code => p_currency_code
201 ,p_standard_amount => p_standard_amount
202 ,p_unitary_amount => p_unitary_amount
203 ,p_money_amount => p_money_amount
204 ,p_booking_deal_id => p_booking_deal_id
205 ,p_booking_deal_type => p_booking_deal_type
206 ,p_finance_line_id => p_finance_line_id
207 ,p_enrollment_type => p_enrollment_type
208 ,p_validate => l_validate
209 ,p_organization_id => p_organization_id
210 ,p_sponsor_person_id => p_sponsor_person_id
211 ,p_sponsor_assignment_id => p_sponsor_assignment_id
212 ,p_person_address_id => p_person_address_id
213 ,p_delegate_assignment_id => p_delegate_assignment_id
214 ,p_delegate_contact_id => p_delegate_contact_id
215 ,p_delegate_contact_email => p_delegate_contact_email
216 ,p_third_party_email => p_third_party_email
217 ,p_person_address_type => p_person_address_type
218 ,p_line_id => p_line_id
219 ,p_org_id => p_org_id
220 ,p_daemon_flag => p_daemon_flag
221 ,p_daemon_type => p_daemon_type
222 ,p_old_event_id => p_old_event_id
223 ,p_quote_line_id => p_quote_line_id
224 ,p_interface_source => p_interface_source
225 ,p_total_training_time => p_total_training_time
226 ,p_content_player_status => p_content_player_status
227 ,p_score => p_score
228 ,p_completed_content => p_completed_content
229 ,p_total_content => p_total_content
230 ,p_booking_justification_id => p_booking_justification_id
231 ,p_is_history_flag => p_is_history_flag
232 ,p_override_prerequisites => p_override_prerequisites
233 ,p_override_learner_access => p_override_learner_access
234 );
235 --
236 -- Convert API warning boolean parameter values to specific
237 -- messages and add them to Multiple Message List
238 --
239 --
240 -- Convert API non-warning boolean parameter values
241 --
242 --
243 -- Derive the API return status value based on whether
244 -- messages of any type exist in the Multiple Message List.
245 -- Also disable Multiple Message Detection.
246 --
247 p_return_status := hr_multi_message.get_return_status_disable;
248 hr_utility.set_location(' Leaving:' || l_proc,20);
249 --
250 exception
251 when hr_multi_message.error_message_exist then
252 --
253 -- Catch the Multiple Message List exception which
254 -- indicates API processing has been aborted because
255 -- at least one message exists in the list.
256 --
257 rollback to create_delegate_booking_swi;
258 --
259 -- Reset IN OUT parameters and set OUT parameters
260 --
261 p_object_version_number := null;
262 p_finance_line_id := l_finance_line_id;
263 p_return_status := hr_multi_message.get_return_status_disable;
264 hr_utility.set_location(' Leaving:' || l_proc, 30);
265 when others then
266 --
267 -- When Multiple Message Detection is enabled catch
268 -- any Application specific or other unexpected
269 -- exceptions. Adding appropriate details to the
270 -- Multiple Message List. Otherwise re-raise the
271 -- error.
272 --
273 rollback to create_delegate_booking_swi;
274 if hr_multi_message.unexpected_error_add(l_proc) then
275 hr_utility.set_location(' Leaving:' || l_proc,40);
276 raise;
277 end if;
278 --
279 -- Reset IN OUT and set OUT parameters
280 --
281 p_object_version_number := null;
282 p_finance_line_id := l_finance_line_id;
283 p_return_status := hr_multi_message.get_return_status_disable;
284 hr_utility.set_location(' Leaving:' || l_proc,50);
285 end create_delegate_booking;
286
287 -- ----------------------------------------------------------------------------
288 -- |------------------------< update_delegate_booking >-----------------------|
289 -- ----------------------------------------------------------------------------
290 PROCEDURE update_delegate_booking
291 (p_effective_date in date
292 ,p_booking_id in number
293 ,p_booking_status_type_id in number default hr_api.g_number
294 ,p_delegate_person_id in number default hr_api.g_number
295 ,p_contact_id in number default hr_api.g_number
296 ,p_business_group_id in number default hr_api.g_number
297 ,p_event_id in number default hr_api.g_number
298 ,p_customer_id in number default hr_api.g_number
299 ,p_authorizer_person_id in number default hr_api.g_number
300 ,p_date_booking_placed in date default hr_api.g_date
301 ,p_corespondent in varchar2 default hr_api.g_varchar2
302 ,p_internal_booking_flag in varchar2 default hr_api.g_varchar2
303 ,p_number_of_places in number default hr_api.g_number
304 ,p_object_version_number in out nocopy number
305 ,p_administrator in number default hr_api.g_number
306 ,p_booking_priority in varchar2 default hr_api.g_varchar2
307 ,p_comments in varchar2 default hr_api.g_varchar2
308 ,p_contact_address_id in number default hr_api.g_number
309 ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2
310 ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2
311 ,p_third_party_customer_id in number default hr_api.g_number
312 ,p_third_party_contact_id in number default hr_api.g_number
313 ,p_third_party_address_id in number default hr_api.g_number
314 ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2
315 ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2
316 ,p_date_status_changed in date default hr_api.g_date
317 ,p_status_change_comments in varchar2 default hr_api.g_varchar2
318 ,p_failure_reason in varchar2 default hr_api.g_varchar2
319 ,p_attendance_result in varchar2 default hr_api.g_varchar2
320 ,p_language_id in number default hr_api.g_number
321 ,p_source_of_booking in varchar2 default hr_api.g_varchar2
322 ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2
323 ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2
324 ,p_tdb_information_category in varchar2 default hr_api.g_varchar2
325 ,p_tdb_information1 in varchar2 default hr_api.g_varchar2
326 ,p_tdb_information2 in varchar2 default hr_api.g_varchar2
327 ,p_tdb_information3 in varchar2 default hr_api.g_varchar2
328 ,p_tdb_information4 in varchar2 default hr_api.g_varchar2
329 ,p_tdb_information5 in varchar2 default hr_api.g_varchar2
330 ,p_tdb_information6 in varchar2 default hr_api.g_varchar2
331 ,p_tdb_information7 in varchar2 default hr_api.g_varchar2
332 ,p_tdb_information8 in varchar2 default hr_api.g_varchar2
333 ,p_tdb_information9 in varchar2 default hr_api.g_varchar2
334 ,p_tdb_information10 in varchar2 default hr_api.g_varchar2
335 ,p_tdb_information11 in varchar2 default hr_api.g_varchar2
336 ,p_tdb_information12 in varchar2 default hr_api.g_varchar2
337 ,p_tdb_information13 in varchar2 default hr_api.g_varchar2
338 ,p_tdb_information14 in varchar2 default hr_api.g_varchar2
339 ,p_tdb_information15 in varchar2 default hr_api.g_varchar2
340 ,p_tdb_information16 in varchar2 default hr_api.g_varchar2
341 ,p_tdb_information17 in varchar2 default hr_api.g_varchar2
342 ,p_tdb_information18 in varchar2 default hr_api.g_varchar2
343 ,p_tdb_information19 in varchar2 default hr_api.g_varchar2
344 ,p_tdb_information20 in varchar2 default hr_api.g_varchar2
345 ,p_update_finance_line in varchar2 default hr_api.g_varchar2
346 ,p_tfl_object_version_number in out nocopy number
347 ,p_finance_header_id in number default hr_api.g_number
348 ,p_finance_line_id in out nocopy number
349 ,p_standard_amount in number default hr_api.g_number
350 ,p_unitary_amount in number default hr_api.g_number
351 ,p_money_amount in number default hr_api.g_number
352 ,p_currency_code in varchar2 default hr_api.g_varchar2
353 ,p_booking_deal_type in varchar2 default hr_api.g_varchar2
354 ,p_booking_deal_id in number default hr_api.g_number
355 ,p_enrollment_type in varchar2 default hr_api.g_varchar2
356 ,p_validate in number default hr_api.g_false_num
357 ,p_organization_id in number default hr_api.g_number
358 ,p_sponsor_person_id in number default hr_api.g_number
359 ,p_sponsor_assignment_id in number default hr_api.g_number
360 ,p_person_address_id in number default hr_api.g_number
361 ,p_delegate_assignment_id in number default hr_api.g_number
362 ,p_delegate_contact_id in number default hr_api.g_number
363 ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2
364 ,p_third_party_email in varchar2 default hr_api.g_varchar2
365 ,p_person_address_type in varchar2 default hr_api.g_varchar2
366 ,p_line_id in number default hr_api.g_number
367 ,p_org_id in number default hr_api.g_number
368 ,p_daemon_flag in varchar2 default hr_api.g_varchar2
369 ,p_daemon_type in varchar2 default hr_api.g_varchar2
370 ,p_old_event_id in number default hr_api.g_number
371 ,p_quote_line_id in number default hr_api.g_number
372 ,p_interface_source in varchar2 default hr_api.g_varchar2
373 ,p_total_training_time in varchar2 default hr_api.g_varchar2
374 ,p_content_player_status in varchar2 default hr_api.g_varchar2
375 ,p_score in number default hr_api.g_number
376 ,p_completed_content in number default hr_api.g_number
377 ,p_total_content in number default hr_api.g_number
378 ,p_return_status out nocopy varchar2
379 ,p_booking_justification_id in number default hr_api.g_number
380 ,p_is_history_flag in varchar2 default hr_api.g_varchar2
381 ,p_override_prerequisites in varchar2
382 ,p_override_learner_access in varchar2
383 ) is
384 --
385 -- Variables for API Boolean parameters
386 l_validate boolean;
387 --
388 -- Variables for IN/OUT parameters
389 l_object_version_number number;
390 l_tfl_object_version_number number;
391 l_finance_line_id number;
392 --
393 l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
394 l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
395
396 --Bug6768247:ANY CHANGE BY ADMIN TO ENROLLMENT CAUSED DATE_STATUS_CHANGED UPDATE
397 CURSOR booking_csr
398 IS
399 SELECT b.date_booking_placed,b.date_status_changed
400 FROM ota_delegate_bookings b
401 WHERE b.booking_id = p_booking_id;
402 --
403
404 -- Other variables
405 l_proc varchar2(72) := g_package ||'update_delegate_booking';
406 Begin
407 hr_utility.set_location(' Entering:' || l_proc,10);
408 --
409 -- Issue a savepoint
410 --
411 savepoint update_delegate_booking_swi;
412 --
413 -- Initialise Multiple Message Detection
414 --
415 hr_multi_message.enable_message_list;
416 --
417 -- Remember IN OUT parameter IN values
418 --
419 l_object_version_number := p_object_version_number;
420 l_tfl_object_version_number := p_tfl_object_version_number;
421 l_finance_line_id := p_finance_line_id;
422 --
423 --
424 /* Bug6768247:ANY CHANGE BY ADMIN TO ENROLLMENT CAUSED DATE_STATUS_CHANGED UPDATE
425 OPEN booking_csr;
426 FETCH booking_csr INTO l_date_booking_placed;
427 CLOSE booking_csr;
428 l_date_status_changed := trunc(sysdate);*/
429
430 OPEN booking_csr;
431 FETCH booking_csr INTO l_date_booking_placed,l_date_status_changed;
432 CLOSE booking_csr;
433
434 --
435 -- Convert constant values to their corresponding boolean value
436 --
437 l_validate :=
438 hr_api.constant_to_boolean
439 (p_constant_value => p_validate);
440 --
441 -- Register Surrogate ID or user key values
442 --
443 --
444 -- Call API
445 --
446 ota_delegate_booking_api.update_delegate_booking
447 (p_effective_date => p_effective_date
448 ,p_booking_id => p_booking_id
449 ,p_booking_status_type_id => p_booking_status_type_id
450 ,p_delegate_person_id => p_delegate_person_id
451 ,p_contact_id => p_contact_id
452 ,p_business_group_id => p_business_group_id
453 ,p_event_id => p_event_id
454 ,p_customer_id => p_customer_id
455 ,p_authorizer_person_id => p_authorizer_person_id
456 ,p_date_booking_placed => l_date_booking_placed
457 ,p_corespondent => p_corespondent
458 ,p_internal_booking_flag => p_internal_booking_flag
459 ,p_number_of_places => p_number_of_places
460 ,p_object_version_number => p_object_version_number
461 ,p_administrator => p_administrator
462 ,p_booking_priority => p_booking_priority
463 ,p_comments => p_comments
464 ,p_contact_address_id => p_contact_address_id
465 ,p_delegate_contact_phone => p_delegate_contact_phone
466 ,p_delegate_contact_fax => p_delegate_contact_fax
467 ,p_third_party_customer_id => p_third_party_customer_id
468 ,p_third_party_contact_id => p_third_party_contact_id
469 ,p_third_party_address_id => p_third_party_address_id
470 ,p_third_party_contact_phone => p_third_party_contact_phone
471 ,p_third_party_contact_fax => p_third_party_contact_fax
472 ,p_date_status_changed => l_date_status_changed
473 ,p_status_change_comments => p_status_change_comments
474 ,p_failure_reason => p_failure_reason
475 ,p_attendance_result => p_attendance_result
476 ,p_language_id => p_language_id
477 ,p_source_of_booking => p_source_of_booking
478 ,p_special_booking_instructions => p_special_booking_instructions
479 ,p_successful_attendance_flag => p_successful_attendance_flag
480 ,p_tdb_information_category => p_tdb_information_category
481 ,p_tdb_information1 => p_tdb_information1
482 ,p_tdb_information2 => p_tdb_information2
483 ,p_tdb_information3 => p_tdb_information3
484 ,p_tdb_information4 => p_tdb_information4
485 ,p_tdb_information5 => p_tdb_information5
486 ,p_tdb_information6 => p_tdb_information6
487 ,p_tdb_information7 => p_tdb_information7
488 ,p_tdb_information8 => p_tdb_information8
489 ,p_tdb_information9 => p_tdb_information9
490 ,p_tdb_information10 => p_tdb_information10
491 ,p_tdb_information11 => p_tdb_information11
492 ,p_tdb_information12 => p_tdb_information12
493 ,p_tdb_information13 => p_tdb_information13
494 ,p_tdb_information14 => p_tdb_information14
495 ,p_tdb_information15 => p_tdb_information15
496 ,p_tdb_information16 => p_tdb_information16
497 ,p_tdb_information17 => p_tdb_information17
498 ,p_tdb_information18 => p_tdb_information18
499 ,p_tdb_information19 => p_tdb_information19
500 ,p_tdb_information20 => p_tdb_information20
501 ,p_update_finance_line => p_update_finance_line
502 ,p_tfl_object_version_number => p_tfl_object_version_number
503 ,p_finance_header_id => p_finance_header_id
504 ,p_finance_line_id => p_finance_line_id
505 ,p_standard_amount => p_standard_amount
506 ,p_unitary_amount => p_unitary_amount
507 ,p_money_amount => p_money_amount
508 ,p_currency_code => p_currency_code
509 ,p_booking_deal_type => p_booking_deal_type
510 ,p_booking_deal_id => p_booking_deal_id
511 ,p_enrollment_type => p_enrollment_type
512 ,p_validate => l_validate
513 ,p_organization_id => p_organization_id
514 ,p_sponsor_person_id => p_sponsor_person_id
515 ,p_sponsor_assignment_id => p_sponsor_assignment_id
516 ,p_person_address_id => p_person_address_id
517 ,p_delegate_assignment_id => p_delegate_assignment_id
518 ,p_delegate_contact_id => p_delegate_contact_id
519 ,p_delegate_contact_email => p_delegate_contact_email
520 ,p_third_party_email => p_third_party_email
521 ,p_person_address_type => p_person_address_type
522 ,p_line_id => p_line_id
523 ,p_org_id => p_org_id
524 ,p_daemon_flag => p_daemon_flag
525 ,p_daemon_type => p_daemon_type
526 ,p_old_event_id => p_old_event_id
527 ,p_quote_line_id => p_quote_line_id
528 ,p_interface_source => p_interface_source
529 ,p_total_training_time => p_total_training_time
530 ,p_content_player_status => p_content_player_status
531 ,p_score => p_score
532 ,p_completed_content => p_completed_content
533 ,p_total_content => p_total_content
534 ,p_booking_justification_id => p_booking_justification_id
535 ,p_is_history_flag => p_is_history_flag
536 ,p_override_prerequisites => p_override_prerequisites
537 ,p_override_learner_access => p_override_learner_access
538 );
539 --
540 -- Convert API warning boolean parameter values to specific
541 -- messages and add them to Multiple Message List
542 --
543 --
544 -- Convert API non-warning boolean parameter values
545 --
546 --
547 -- Derive the API return status value based on whether
548 -- messages of any type exist in the Multiple Message List.
549 -- Also disable Multiple Message Detection.
550 --
551 p_return_status := hr_multi_message.get_return_status_disable;
552 hr_utility.set_location(' Leaving:' || l_proc,20);
553 --
554 exception
555 when hr_multi_message.error_message_exist then
556 --
557 -- Catch the Multiple Message List exception which
558 -- indicates API processing has been aborted because
559 -- at least one message exists in the list.
560 --
561 rollback to update_delegate_booking_swi;
562 --
563 -- Reset IN OUT parameters and set OUT parameters
564 --
565 p_object_version_number := l_object_version_number;
566 p_tfl_object_version_number := l_tfl_object_version_number;
567 p_finance_line_id := l_finance_line_id;
568 p_return_status := hr_multi_message.get_return_status_disable;
569 hr_utility.set_location(' Leaving:' || l_proc, 30);
570 when others then
571 --
572 -- When Multiple Message Detection is enabled catch
573 -- any Application specific or other unexpected
574 -- exceptions. Adding appropriate details to the
575 -- Multiple Message List. Otherwise re-raise the
576 -- error.
577 --
578 rollback to update_delegate_booking_swi;
579 if hr_multi_message.unexpected_error_add(l_proc) then
580 hr_utility.set_location(' Leaving:' || l_proc,40);
581 raise;
582 end if;
583 --
584 -- Reset IN OUT and set OUT parameters
585 --
586 p_object_version_number := l_object_version_number;
587 p_tfl_object_version_number := l_tfl_object_version_number;
588 p_finance_line_id := l_finance_line_id;
589 p_return_status := hr_multi_message.get_return_status_disable;
590 hr_utility.set_location(' Leaving:' || l_proc,50);
591 end update_delegate_booking;
592
593 -- ----------------------------------------------------------------------------
594 -- |------------------------< delete_delegate_booking >-----------------------|
595 -- ----------------------------------------------------------------------------
596 PROCEDURE delete_delegate_booking
597 (p_booking_id in number
598 ,p_object_version_number in number
599 ,p_validate in number default hr_api.g_false_num
600 ,p_return_status out nocopy varchar2
601 ) is
602 --
603 -- Variables for API Boolean parameters
604 l_validate boolean;
605 --
606 -- Variables for IN/OUT parameters
607 --
608 -- Other variables
609 l_proc varchar2(72) := g_package ||'delete_delegate_booking';
610 Begin
611 hr_utility.set_location(' Entering:' || l_proc,10);
612 --
613 -- Issue a savepoint
614 --
615 savepoint delete_delegate_booking_swi;
616 --
617 -- Initialise Multiple Message Detection
618 --
619 hr_multi_message.enable_message_list;
620 --
621 -- Remember IN OUT parameter IN values
622 --
623 --
624 -- Convert constant values to their corresponding boolean value
625 --
626 l_validate :=
627 hr_api.constant_to_boolean
628 (p_constant_value => p_validate);
629 --
630 -- Register Surrogate ID or user key values
631 --
632 --
633 -- Call API
634 --
635 ota_delegate_booking_api.delete_delegate_booking
636 (p_booking_id => p_booking_id
637 ,p_object_version_number => p_object_version_number
638 ,p_validate => l_validate
639 );
640 --
641 -- Convert API warning boolean parameter values to specific
642 -- messages and add them to Multiple Message List
643 --
644 --
645 -- Convert API non-warning boolean parameter values
646 --
647 --
648 -- Derive the API return status value based on whether
649 -- messages of any type exist in the Multiple Message List.
650 -- Also disable Multiple Message Detection.
651 --
652 p_return_status := hr_multi_message.get_return_status_disable;
653 hr_utility.set_location(' Leaving:' || l_proc,20);
654 --
655 exception
656 when hr_multi_message.error_message_exist then
657 --
658 -- Catch the Multiple Message List exception which
659 -- indicates API processing has been aborted because
660 -- at least one message exists in the list.
661 --
662 rollback to delete_delegate_booking_swi;
663 --
664 -- Reset IN OUT parameters and set OUT parameters
665 --
666 p_return_status := hr_multi_message.get_return_status_disable;
667 hr_utility.set_location(' Leaving:' || l_proc, 30);
668 when others then
669 --
670 -- When Multiple Message Detection is enabled catch
671 -- any Application specific or other unexpected
672 -- exceptions. Adding appropriate details to the
673 -- Multiple Message List. Otherwise re-raise the
674 -- error.
675 --
676 rollback to delete_delegate_booking_swi;
677 if hr_multi_message.unexpected_error_add(l_proc) then
678 hr_utility.set_location(' Leaving:' || l_proc,40);
679 raise;
680 end if;
681 --
682 -- Reset IN OUT and set OUT parameters
683 --
684 p_return_status := hr_multi_message.get_return_status_disable;
685 hr_utility.set_location(' Leaving:' || l_proc,50);
686 end delete_delegate_booking;
687 end ota_delegate_booking_swi;