[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ota_trb_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: ota_trb_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the ota_resource_bookings Row
69: --
70: update ota_resource_bookings
117: ,forum_id = p_rec.forum_id
118: ,timezone_code = p_rec.timezone_code
119: where resource_booking_id = p_rec.resource_booking_id;
120: --
121: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
122: --
123: hr_utility.set_location(' Leaving:'||l_proc, 10);
124: --
125: Exception
124: --
125: Exception
126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
128: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
129: ota_trb_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
125: Exception
126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
128: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
129: ota_trb_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
129: ota_trb_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
134: ota_trb_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
134: ota_trb_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
134: ota_trb_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
139: ota_trb_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
139: ota_trb_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
143: Raise;
138: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
139: ota_trb_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
143: Raise;
144: End update_dml;
145: --
146: -- ----------------------------------------------------------------------------
175: --
176: -- {End Of Comments}
177: -- ----------------------------------------------------------------------------
178: Procedure pre_update
179: (p_rec in ota_trb_shd.g_rec_type
180: ) is
181: --
182: l_proc varchar2(72) := g_package||'pre_update';
183: --
220: -- {End Of Comments}
221: -- ----------------------------------------------------------------------------
222: Procedure post_update
223: (p_effective_date in date
224: ,p_rec in ota_trb_shd.g_rec_type
225: ) is
226: --
227: l_proc varchar2(72) := g_package||'post_update';
228: --
326: => p_rec.forum_id
327: ,p_timezone_code
328: => p_rec.timezone_code
329: ,p_supplied_resource_id_o
330: => ota_trb_shd.g_old_rec.supplied_resource_id
331: ,p_event_id_o
332: => ota_trb_shd.g_old_rec.event_id
333: ,p_date_booking_placed_o
334: => ota_trb_shd.g_old_rec.date_booking_placed
328: => p_rec.timezone_code
329: ,p_supplied_resource_id_o
330: => ota_trb_shd.g_old_rec.supplied_resource_id
331: ,p_event_id_o
332: => ota_trb_shd.g_old_rec.event_id
333: ,p_date_booking_placed_o
334: => ota_trb_shd.g_old_rec.date_booking_placed
335: ,p_object_version_number_o
336: => ota_trb_shd.g_old_rec.object_version_number
330: => ota_trb_shd.g_old_rec.supplied_resource_id
331: ,p_event_id_o
332: => ota_trb_shd.g_old_rec.event_id
333: ,p_date_booking_placed_o
334: => ota_trb_shd.g_old_rec.date_booking_placed
335: ,p_object_version_number_o
336: => ota_trb_shd.g_old_rec.object_version_number
337: ,p_status_o
338: => ota_trb_shd.g_old_rec.status
332: => ota_trb_shd.g_old_rec.event_id
333: ,p_date_booking_placed_o
334: => ota_trb_shd.g_old_rec.date_booking_placed
335: ,p_object_version_number_o
336: => ota_trb_shd.g_old_rec.object_version_number
337: ,p_status_o
338: => ota_trb_shd.g_old_rec.status
339: ,p_absolute_price_o
340: => ota_trb_shd.g_old_rec.absolute_price
334: => ota_trb_shd.g_old_rec.date_booking_placed
335: ,p_object_version_number_o
336: => ota_trb_shd.g_old_rec.object_version_number
337: ,p_status_o
338: => ota_trb_shd.g_old_rec.status
339: ,p_absolute_price_o
340: => ota_trb_shd.g_old_rec.absolute_price
341: ,p_booking_person_id_o
342: => ota_trb_shd.g_old_rec.booking_person_id
336: => ota_trb_shd.g_old_rec.object_version_number
337: ,p_status_o
338: => ota_trb_shd.g_old_rec.status
339: ,p_absolute_price_o
340: => ota_trb_shd.g_old_rec.absolute_price
341: ,p_booking_person_id_o
342: => ota_trb_shd.g_old_rec.booking_person_id
343: ,p_comments_o
344: => ota_trb_shd.g_old_rec.comments
338: => ota_trb_shd.g_old_rec.status
339: ,p_absolute_price_o
340: => ota_trb_shd.g_old_rec.absolute_price
341: ,p_booking_person_id_o
342: => ota_trb_shd.g_old_rec.booking_person_id
343: ,p_comments_o
344: => ota_trb_shd.g_old_rec.comments
345: ,p_contact_name_o
346: => ota_trb_shd.g_old_rec.contact_name
340: => ota_trb_shd.g_old_rec.absolute_price
341: ,p_booking_person_id_o
342: => ota_trb_shd.g_old_rec.booking_person_id
343: ,p_comments_o
344: => ota_trb_shd.g_old_rec.comments
345: ,p_contact_name_o
346: => ota_trb_shd.g_old_rec.contact_name
347: ,p_contact_phone_number_o
348: => ota_trb_shd.g_old_rec.contact_phone_number
342: => ota_trb_shd.g_old_rec.booking_person_id
343: ,p_comments_o
344: => ota_trb_shd.g_old_rec.comments
345: ,p_contact_name_o
346: => ota_trb_shd.g_old_rec.contact_name
347: ,p_contact_phone_number_o
348: => ota_trb_shd.g_old_rec.contact_phone_number
349: ,p_delegates_per_unit_o
350: => ota_trb_shd.g_old_rec.delegates_per_unit
344: => ota_trb_shd.g_old_rec.comments
345: ,p_contact_name_o
346: => ota_trb_shd.g_old_rec.contact_name
347: ,p_contact_phone_number_o
348: => ota_trb_shd.g_old_rec.contact_phone_number
349: ,p_delegates_per_unit_o
350: => ota_trb_shd.g_old_rec.delegates_per_unit
351: ,p_quantity_o
352: => ota_trb_shd.g_old_rec.quantity
346: => ota_trb_shd.g_old_rec.contact_name
347: ,p_contact_phone_number_o
348: => ota_trb_shd.g_old_rec.contact_phone_number
349: ,p_delegates_per_unit_o
350: => ota_trb_shd.g_old_rec.delegates_per_unit
351: ,p_quantity_o
352: => ota_trb_shd.g_old_rec.quantity
353: ,p_required_date_from_o
354: => ota_trb_shd.g_old_rec.required_date_from
348: => ota_trb_shd.g_old_rec.contact_phone_number
349: ,p_delegates_per_unit_o
350: => ota_trb_shd.g_old_rec.delegates_per_unit
351: ,p_quantity_o
352: => ota_trb_shd.g_old_rec.quantity
353: ,p_required_date_from_o
354: => ota_trb_shd.g_old_rec.required_date_from
355: ,p_required_date_to_o
356: => ota_trb_shd.g_old_rec.required_date_to
350: => ota_trb_shd.g_old_rec.delegates_per_unit
351: ,p_quantity_o
352: => ota_trb_shd.g_old_rec.quantity
353: ,p_required_date_from_o
354: => ota_trb_shd.g_old_rec.required_date_from
355: ,p_required_date_to_o
356: => ota_trb_shd.g_old_rec.required_date_to
357: ,p_required_end_time_o
358: => ota_trb_shd.g_old_rec.required_end_time
352: => ota_trb_shd.g_old_rec.quantity
353: ,p_required_date_from_o
354: => ota_trb_shd.g_old_rec.required_date_from
355: ,p_required_date_to_o
356: => ota_trb_shd.g_old_rec.required_date_to
357: ,p_required_end_time_o
358: => ota_trb_shd.g_old_rec.required_end_time
359: ,p_required_start_time_o
360: => ota_trb_shd.g_old_rec.required_start_time
354: => ota_trb_shd.g_old_rec.required_date_from
355: ,p_required_date_to_o
356: => ota_trb_shd.g_old_rec.required_date_to
357: ,p_required_end_time_o
358: => ota_trb_shd.g_old_rec.required_end_time
359: ,p_required_start_time_o
360: => ota_trb_shd.g_old_rec.required_start_time
361: ,p_deliver_to_o
362: => ota_trb_shd.g_old_rec.deliver_to
356: => ota_trb_shd.g_old_rec.required_date_to
357: ,p_required_end_time_o
358: => ota_trb_shd.g_old_rec.required_end_time
359: ,p_required_start_time_o
360: => ota_trb_shd.g_old_rec.required_start_time
361: ,p_deliver_to_o
362: => ota_trb_shd.g_old_rec.deliver_to
363: ,p_primary_venue_flag_o
364: => ota_trb_shd.g_old_rec.primary_venue_flag
358: => ota_trb_shd.g_old_rec.required_end_time
359: ,p_required_start_time_o
360: => ota_trb_shd.g_old_rec.required_start_time
361: ,p_deliver_to_o
362: => ota_trb_shd.g_old_rec.deliver_to
363: ,p_primary_venue_flag_o
364: => ota_trb_shd.g_old_rec.primary_venue_flag
365: ,p_role_to_play_o
366: => ota_trb_shd.g_old_rec.role_to_play
360: => ota_trb_shd.g_old_rec.required_start_time
361: ,p_deliver_to_o
362: => ota_trb_shd.g_old_rec.deliver_to
363: ,p_primary_venue_flag_o
364: => ota_trb_shd.g_old_rec.primary_venue_flag
365: ,p_role_to_play_o
366: => ota_trb_shd.g_old_rec.role_to_play
367: ,p_trb_information_category_o
368: => ota_trb_shd.g_old_rec.trb_information_category
362: => ota_trb_shd.g_old_rec.deliver_to
363: ,p_primary_venue_flag_o
364: => ota_trb_shd.g_old_rec.primary_venue_flag
365: ,p_role_to_play_o
366: => ota_trb_shd.g_old_rec.role_to_play
367: ,p_trb_information_category_o
368: => ota_trb_shd.g_old_rec.trb_information_category
369: ,p_trb_information1_o
370: => ota_trb_shd.g_old_rec.trb_information1
364: => ota_trb_shd.g_old_rec.primary_venue_flag
365: ,p_role_to_play_o
366: => ota_trb_shd.g_old_rec.role_to_play
367: ,p_trb_information_category_o
368: => ota_trb_shd.g_old_rec.trb_information_category
369: ,p_trb_information1_o
370: => ota_trb_shd.g_old_rec.trb_information1
371: ,p_trb_information2_o
372: => ota_trb_shd.g_old_rec.trb_information2
366: => ota_trb_shd.g_old_rec.role_to_play
367: ,p_trb_information_category_o
368: => ota_trb_shd.g_old_rec.trb_information_category
369: ,p_trb_information1_o
370: => ota_trb_shd.g_old_rec.trb_information1
371: ,p_trb_information2_o
372: => ota_trb_shd.g_old_rec.trb_information2
373: ,p_trb_information3_o
374: => ota_trb_shd.g_old_rec.trb_information3
368: => ota_trb_shd.g_old_rec.trb_information_category
369: ,p_trb_information1_o
370: => ota_trb_shd.g_old_rec.trb_information1
371: ,p_trb_information2_o
372: => ota_trb_shd.g_old_rec.trb_information2
373: ,p_trb_information3_o
374: => ota_trb_shd.g_old_rec.trb_information3
375: ,p_trb_information4_o
376: => ota_trb_shd.g_old_rec.trb_information4
370: => ota_trb_shd.g_old_rec.trb_information1
371: ,p_trb_information2_o
372: => ota_trb_shd.g_old_rec.trb_information2
373: ,p_trb_information3_o
374: => ota_trb_shd.g_old_rec.trb_information3
375: ,p_trb_information4_o
376: => ota_trb_shd.g_old_rec.trb_information4
377: ,p_trb_information5_o
378: => ota_trb_shd.g_old_rec.trb_information5
372: => ota_trb_shd.g_old_rec.trb_information2
373: ,p_trb_information3_o
374: => ota_trb_shd.g_old_rec.trb_information3
375: ,p_trb_information4_o
376: => ota_trb_shd.g_old_rec.trb_information4
377: ,p_trb_information5_o
378: => ota_trb_shd.g_old_rec.trb_information5
379: ,p_trb_information6_o
380: => ota_trb_shd.g_old_rec.trb_information6
374: => ota_trb_shd.g_old_rec.trb_information3
375: ,p_trb_information4_o
376: => ota_trb_shd.g_old_rec.trb_information4
377: ,p_trb_information5_o
378: => ota_trb_shd.g_old_rec.trb_information5
379: ,p_trb_information6_o
380: => ota_trb_shd.g_old_rec.trb_information6
381: ,p_trb_information7_o
382: => ota_trb_shd.g_old_rec.trb_information7
376: => ota_trb_shd.g_old_rec.trb_information4
377: ,p_trb_information5_o
378: => ota_trb_shd.g_old_rec.trb_information5
379: ,p_trb_information6_o
380: => ota_trb_shd.g_old_rec.trb_information6
381: ,p_trb_information7_o
382: => ota_trb_shd.g_old_rec.trb_information7
383: ,p_trb_information8_o
384: => ota_trb_shd.g_old_rec.trb_information8
378: => ota_trb_shd.g_old_rec.trb_information5
379: ,p_trb_information6_o
380: => ota_trb_shd.g_old_rec.trb_information6
381: ,p_trb_information7_o
382: => ota_trb_shd.g_old_rec.trb_information7
383: ,p_trb_information8_o
384: => ota_trb_shd.g_old_rec.trb_information8
385: ,p_trb_information9_o
386: => ota_trb_shd.g_old_rec.trb_information9
380: => ota_trb_shd.g_old_rec.trb_information6
381: ,p_trb_information7_o
382: => ota_trb_shd.g_old_rec.trb_information7
383: ,p_trb_information8_o
384: => ota_trb_shd.g_old_rec.trb_information8
385: ,p_trb_information9_o
386: => ota_trb_shd.g_old_rec.trb_information9
387: ,p_trb_information10_o
388: => ota_trb_shd.g_old_rec.trb_information10
382: => ota_trb_shd.g_old_rec.trb_information7
383: ,p_trb_information8_o
384: => ota_trb_shd.g_old_rec.trb_information8
385: ,p_trb_information9_o
386: => ota_trb_shd.g_old_rec.trb_information9
387: ,p_trb_information10_o
388: => ota_trb_shd.g_old_rec.trb_information10
389: ,p_trb_information11_o
390: => ota_trb_shd.g_old_rec.trb_information11
384: => ota_trb_shd.g_old_rec.trb_information8
385: ,p_trb_information9_o
386: => ota_trb_shd.g_old_rec.trb_information9
387: ,p_trb_information10_o
388: => ota_trb_shd.g_old_rec.trb_information10
389: ,p_trb_information11_o
390: => ota_trb_shd.g_old_rec.trb_information11
391: ,p_trb_information12_o
392: => ota_trb_shd.g_old_rec.trb_information12
386: => ota_trb_shd.g_old_rec.trb_information9
387: ,p_trb_information10_o
388: => ota_trb_shd.g_old_rec.trb_information10
389: ,p_trb_information11_o
390: => ota_trb_shd.g_old_rec.trb_information11
391: ,p_trb_information12_o
392: => ota_trb_shd.g_old_rec.trb_information12
393: ,p_trb_information13_o
394: => ota_trb_shd.g_old_rec.trb_information13
388: => ota_trb_shd.g_old_rec.trb_information10
389: ,p_trb_information11_o
390: => ota_trb_shd.g_old_rec.trb_information11
391: ,p_trb_information12_o
392: => ota_trb_shd.g_old_rec.trb_information12
393: ,p_trb_information13_o
394: => ota_trb_shd.g_old_rec.trb_information13
395: ,p_trb_information14_o
396: => ota_trb_shd.g_old_rec.trb_information14
390: => ota_trb_shd.g_old_rec.trb_information11
391: ,p_trb_information12_o
392: => ota_trb_shd.g_old_rec.trb_information12
393: ,p_trb_information13_o
394: => ota_trb_shd.g_old_rec.trb_information13
395: ,p_trb_information14_o
396: => ota_trb_shd.g_old_rec.trb_information14
397: ,p_trb_information15_o
398: => ota_trb_shd.g_old_rec.trb_information15
392: => ota_trb_shd.g_old_rec.trb_information12
393: ,p_trb_information13_o
394: => ota_trb_shd.g_old_rec.trb_information13
395: ,p_trb_information14_o
396: => ota_trb_shd.g_old_rec.trb_information14
397: ,p_trb_information15_o
398: => ota_trb_shd.g_old_rec.trb_information15
399: ,p_trb_information16_o
400: => ota_trb_shd.g_old_rec.trb_information16
394: => ota_trb_shd.g_old_rec.trb_information13
395: ,p_trb_information14_o
396: => ota_trb_shd.g_old_rec.trb_information14
397: ,p_trb_information15_o
398: => ota_trb_shd.g_old_rec.trb_information15
399: ,p_trb_information16_o
400: => ota_trb_shd.g_old_rec.trb_information16
401: ,p_trb_information17_o
402: => ota_trb_shd.g_old_rec.trb_information17
396: => ota_trb_shd.g_old_rec.trb_information14
397: ,p_trb_information15_o
398: => ota_trb_shd.g_old_rec.trb_information15
399: ,p_trb_information16_o
400: => ota_trb_shd.g_old_rec.trb_information16
401: ,p_trb_information17_o
402: => ota_trb_shd.g_old_rec.trb_information17
403: ,p_trb_information18_o
404: => ota_trb_shd.g_old_rec.trb_information18
398: => ota_trb_shd.g_old_rec.trb_information15
399: ,p_trb_information16_o
400: => ota_trb_shd.g_old_rec.trb_information16
401: ,p_trb_information17_o
402: => ota_trb_shd.g_old_rec.trb_information17
403: ,p_trb_information18_o
404: => ota_trb_shd.g_old_rec.trb_information18
405: ,p_trb_information19_o
406: => ota_trb_shd.g_old_rec.trb_information19
400: => ota_trb_shd.g_old_rec.trb_information16
401: ,p_trb_information17_o
402: => ota_trb_shd.g_old_rec.trb_information17
403: ,p_trb_information18_o
404: => ota_trb_shd.g_old_rec.trb_information18
405: ,p_trb_information19_o
406: => ota_trb_shd.g_old_rec.trb_information19
407: ,p_trb_information20_o
408: => ota_trb_shd.g_old_rec.trb_information20
402: => ota_trb_shd.g_old_rec.trb_information17
403: ,p_trb_information18_o
404: => ota_trb_shd.g_old_rec.trb_information18
405: ,p_trb_information19_o
406: => ota_trb_shd.g_old_rec.trb_information19
407: ,p_trb_information20_o
408: => ota_trb_shd.g_old_rec.trb_information20
409: ,p_display_to_learner_flag_o
410: => ota_trb_shd.g_old_rec.display_to_learner_flag
404: => ota_trb_shd.g_old_rec.trb_information18
405: ,p_trb_information19_o
406: => ota_trb_shd.g_old_rec.trb_information19
407: ,p_trb_information20_o
408: => ota_trb_shd.g_old_rec.trb_information20
409: ,p_display_to_learner_flag_o
410: => ota_trb_shd.g_old_rec.display_to_learner_flag
411: ,p_book_entire_period_flag_o
412: => ota_trb_shd.g_old_rec.book_entire_period_flag
406: => ota_trb_shd.g_old_rec.trb_information19
407: ,p_trb_information20_o
408: => ota_trb_shd.g_old_rec.trb_information20
409: ,p_display_to_learner_flag_o
410: => ota_trb_shd.g_old_rec.display_to_learner_flag
411: ,p_book_entire_period_flag_o
412: => ota_trb_shd.g_old_rec.book_entire_period_flag
413: /* ,p_unbook_request_flag_o
414: => ota_trb_shd.g_old_rec.unbook_request_flag */
408: => ota_trb_shd.g_old_rec.trb_information20
409: ,p_display_to_learner_flag_o
410: => ota_trb_shd.g_old_rec.display_to_learner_flag
411: ,p_book_entire_period_flag_o
412: => ota_trb_shd.g_old_rec.book_entire_period_flag
413: /* ,p_unbook_request_flag_o
414: => ota_trb_shd.g_old_rec.unbook_request_flag */
415: ,p_chat_id_o
416: => ota_trb_shd.g_old_rec.chat_id
410: => ota_trb_shd.g_old_rec.display_to_learner_flag
411: ,p_book_entire_period_flag_o
412: => ota_trb_shd.g_old_rec.book_entire_period_flag
413: /* ,p_unbook_request_flag_o
414: => ota_trb_shd.g_old_rec.unbook_request_flag */
415: ,p_chat_id_o
416: => ota_trb_shd.g_old_rec.chat_id
417: ,p_forum_id_o
418: => ota_trb_shd.g_old_rec.forum_id
412: => ota_trb_shd.g_old_rec.book_entire_period_flag
413: /* ,p_unbook_request_flag_o
414: => ota_trb_shd.g_old_rec.unbook_request_flag */
415: ,p_chat_id_o
416: => ota_trb_shd.g_old_rec.chat_id
417: ,p_forum_id_o
418: => ota_trb_shd.g_old_rec.forum_id
419: ,p_timezone_code_o
420: => ota_trb_shd.g_old_rec.timezone_code
414: => ota_trb_shd.g_old_rec.unbook_request_flag */
415: ,p_chat_id_o
416: => ota_trb_shd.g_old_rec.chat_id
417: ,p_forum_id_o
418: => ota_trb_shd.g_old_rec.forum_id
419: ,p_timezone_code_o
420: => ota_trb_shd.g_old_rec.timezone_code
421: );
422: --
416: => ota_trb_shd.g_old_rec.chat_id
417: ,p_forum_id_o
418: => ota_trb_shd.g_old_rec.forum_id
419: ,p_timezone_code_o
420: => ota_trb_shd.g_old_rec.timezone_code
421: );
422: --
423: exception
424: --
476: --
477: -- {End Of Comments}
478: -- ----------------------------------------------------------------------------
479: Procedure convert_defs
480: (p_rec in out nocopy ota_trb_shd.g_rec_type
481: ) is
482: --
483: l_proc varchar2(72) := g_package||'convert_defs';
484: --
493: -- is being used then we must set to the 'current' argument value.
494: --
495: If (p_rec.supplied_resource_id = hr_api.g_number) then
496: p_rec.supplied_resource_id :=
497: ota_trb_shd.g_old_rec.supplied_resource_id;
498: End If;
499: If (p_rec.event_id = hr_api.g_number) then
500: p_rec.event_id :=
501: ota_trb_shd.g_old_rec.event_id;
497: ota_trb_shd.g_old_rec.supplied_resource_id;
498: End If;
499: If (p_rec.event_id = hr_api.g_number) then
500: p_rec.event_id :=
501: ota_trb_shd.g_old_rec.event_id;
502: End If;
503: If (p_rec.date_booking_placed = hr_api.g_date) then
504: p_rec.date_booking_placed :=
505: ota_trb_shd.g_old_rec.date_booking_placed;
501: ota_trb_shd.g_old_rec.event_id;
502: End If;
503: If (p_rec.date_booking_placed = hr_api.g_date) then
504: p_rec.date_booking_placed :=
505: ota_trb_shd.g_old_rec.date_booking_placed;
506: End If;
507: If (p_rec.status = hr_api.g_varchar2) then
508: p_rec.status :=
509: ota_trb_shd.g_old_rec.status;
505: ota_trb_shd.g_old_rec.date_booking_placed;
506: End If;
507: If (p_rec.status = hr_api.g_varchar2) then
508: p_rec.status :=
509: ota_trb_shd.g_old_rec.status;
510: End If;
511: If (p_rec.absolute_price = hr_api.g_number) then
512: p_rec.absolute_price :=
513: ota_trb_shd.g_old_rec.absolute_price;
509: ota_trb_shd.g_old_rec.status;
510: End If;
511: If (p_rec.absolute_price = hr_api.g_number) then
512: p_rec.absolute_price :=
513: ota_trb_shd.g_old_rec.absolute_price;
514: End If;
515: If (p_rec.booking_person_id = hr_api.g_number) then
516: p_rec.booking_person_id :=
517: ota_trb_shd.g_old_rec.booking_person_id;
513: ota_trb_shd.g_old_rec.absolute_price;
514: End If;
515: If (p_rec.booking_person_id = hr_api.g_number) then
516: p_rec.booking_person_id :=
517: ota_trb_shd.g_old_rec.booking_person_id;
518: End If;
519: If (p_rec.comments = hr_api.g_varchar2) then
520: p_rec.comments :=
521: ota_trb_shd.g_old_rec.comments;
517: ota_trb_shd.g_old_rec.booking_person_id;
518: End If;
519: If (p_rec.comments = hr_api.g_varchar2) then
520: p_rec.comments :=
521: ota_trb_shd.g_old_rec.comments;
522: End If;
523: If (p_rec.contact_name = hr_api.g_varchar2) then
524: p_rec.contact_name :=
525: ota_trb_shd.g_old_rec.contact_name;
521: ota_trb_shd.g_old_rec.comments;
522: End If;
523: If (p_rec.contact_name = hr_api.g_varchar2) then
524: p_rec.contact_name :=
525: ota_trb_shd.g_old_rec.contact_name;
526: End If;
527: If (p_rec.contact_phone_number = hr_api.g_varchar2) then
528: p_rec.contact_phone_number :=
529: ota_trb_shd.g_old_rec.contact_phone_number;
525: ota_trb_shd.g_old_rec.contact_name;
526: End If;
527: If (p_rec.contact_phone_number = hr_api.g_varchar2) then
528: p_rec.contact_phone_number :=
529: ota_trb_shd.g_old_rec.contact_phone_number;
530: End If;
531: If (p_rec.delegates_per_unit = hr_api.g_number) then
532: p_rec.delegates_per_unit :=
533: ota_trb_shd.g_old_rec.delegates_per_unit;
529: ota_trb_shd.g_old_rec.contact_phone_number;
530: End If;
531: If (p_rec.delegates_per_unit = hr_api.g_number) then
532: p_rec.delegates_per_unit :=
533: ota_trb_shd.g_old_rec.delegates_per_unit;
534: End If;
535: If (p_rec.quantity = hr_api.g_number) then
536: p_rec.quantity :=
537: ota_trb_shd.g_old_rec.quantity;
533: ota_trb_shd.g_old_rec.delegates_per_unit;
534: End If;
535: If (p_rec.quantity = hr_api.g_number) then
536: p_rec.quantity :=
537: ota_trb_shd.g_old_rec.quantity;
538: End If;
539: If (p_rec.required_date_from = hr_api.g_date) then
540: p_rec.required_date_from :=
541: ota_trb_shd.g_old_rec.required_date_from;
537: ota_trb_shd.g_old_rec.quantity;
538: End If;
539: If (p_rec.required_date_from = hr_api.g_date) then
540: p_rec.required_date_from :=
541: ota_trb_shd.g_old_rec.required_date_from;
542: End If;
543: If (p_rec.required_date_to = hr_api.g_date) then
544: p_rec.required_date_to :=
545: ota_trb_shd.g_old_rec.required_date_to;
541: ota_trb_shd.g_old_rec.required_date_from;
542: End If;
543: If (p_rec.required_date_to = hr_api.g_date) then
544: p_rec.required_date_to :=
545: ota_trb_shd.g_old_rec.required_date_to;
546: End If;
547: If (p_rec.required_end_time = hr_api.g_varchar2) then
548: p_rec.required_end_time :=
549: ota_trb_shd.g_old_rec.required_end_time;
545: ota_trb_shd.g_old_rec.required_date_to;
546: End If;
547: If (p_rec.required_end_time = hr_api.g_varchar2) then
548: p_rec.required_end_time :=
549: ota_trb_shd.g_old_rec.required_end_time;
550: End If;
551: If (p_rec.required_start_time = hr_api.g_varchar2) then
552: p_rec.required_start_time :=
553: ota_trb_shd.g_old_rec.required_start_time;
549: ota_trb_shd.g_old_rec.required_end_time;
550: End If;
551: If (p_rec.required_start_time = hr_api.g_varchar2) then
552: p_rec.required_start_time :=
553: ota_trb_shd.g_old_rec.required_start_time;
554: End If;
555: If (p_rec.deliver_to = hr_api.g_varchar2) then
556: p_rec.deliver_to :=
557: ota_trb_shd.g_old_rec.deliver_to;
553: ota_trb_shd.g_old_rec.required_start_time;
554: End If;
555: If (p_rec.deliver_to = hr_api.g_varchar2) then
556: p_rec.deliver_to :=
557: ota_trb_shd.g_old_rec.deliver_to;
558: End If;
559: If (p_rec.primary_venue_flag = hr_api.g_varchar2) then
560: p_rec.primary_venue_flag :=
561: ota_trb_shd.g_old_rec.primary_venue_flag;
557: ota_trb_shd.g_old_rec.deliver_to;
558: End If;
559: If (p_rec.primary_venue_flag = hr_api.g_varchar2) then
560: p_rec.primary_venue_flag :=
561: ota_trb_shd.g_old_rec.primary_venue_flag;
562: End If;
563: If (p_rec.role_to_play = hr_api.g_varchar2) then
564: p_rec.role_to_play :=
565: ota_trb_shd.g_old_rec.role_to_play;
561: ota_trb_shd.g_old_rec.primary_venue_flag;
562: End If;
563: If (p_rec.role_to_play = hr_api.g_varchar2) then
564: p_rec.role_to_play :=
565: ota_trb_shd.g_old_rec.role_to_play;
566: End If;
567: If (p_rec.trb_information_category = hr_api.g_varchar2) then
568: p_rec.trb_information_category :=
569: ota_trb_shd.g_old_rec.trb_information_category;
565: ota_trb_shd.g_old_rec.role_to_play;
566: End If;
567: If (p_rec.trb_information_category = hr_api.g_varchar2) then
568: p_rec.trb_information_category :=
569: ota_trb_shd.g_old_rec.trb_information_category;
570: End If;
571: If (p_rec.trb_information1 = hr_api.g_varchar2) then
572: p_rec.trb_information1 :=
573: ota_trb_shd.g_old_rec.trb_information1;
569: ota_trb_shd.g_old_rec.trb_information_category;
570: End If;
571: If (p_rec.trb_information1 = hr_api.g_varchar2) then
572: p_rec.trb_information1 :=
573: ota_trb_shd.g_old_rec.trb_information1;
574: End If;
575: If (p_rec.trb_information2 = hr_api.g_varchar2) then
576: p_rec.trb_information2 :=
577: ota_trb_shd.g_old_rec.trb_information2;
573: ota_trb_shd.g_old_rec.trb_information1;
574: End If;
575: If (p_rec.trb_information2 = hr_api.g_varchar2) then
576: p_rec.trb_information2 :=
577: ota_trb_shd.g_old_rec.trb_information2;
578: End If;
579: If (p_rec.trb_information3 = hr_api.g_varchar2) then
580: p_rec.trb_information3 :=
581: ota_trb_shd.g_old_rec.trb_information3;
577: ota_trb_shd.g_old_rec.trb_information2;
578: End If;
579: If (p_rec.trb_information3 = hr_api.g_varchar2) then
580: p_rec.trb_information3 :=
581: ota_trb_shd.g_old_rec.trb_information3;
582: End If;
583: If (p_rec.trb_information4 = hr_api.g_varchar2) then
584: p_rec.trb_information4 :=
585: ota_trb_shd.g_old_rec.trb_information4;
581: ota_trb_shd.g_old_rec.trb_information3;
582: End If;
583: If (p_rec.trb_information4 = hr_api.g_varchar2) then
584: p_rec.trb_information4 :=
585: ota_trb_shd.g_old_rec.trb_information4;
586: End If;
587: If (p_rec.trb_information5 = hr_api.g_varchar2) then
588: p_rec.trb_information5 :=
589: ota_trb_shd.g_old_rec.trb_information5;
585: ota_trb_shd.g_old_rec.trb_information4;
586: End If;
587: If (p_rec.trb_information5 = hr_api.g_varchar2) then
588: p_rec.trb_information5 :=
589: ota_trb_shd.g_old_rec.trb_information5;
590: End If;
591: If (p_rec.trb_information6 = hr_api.g_varchar2) then
592: p_rec.trb_information6 :=
593: ota_trb_shd.g_old_rec.trb_information6;
589: ota_trb_shd.g_old_rec.trb_information5;
590: End If;
591: If (p_rec.trb_information6 = hr_api.g_varchar2) then
592: p_rec.trb_information6 :=
593: ota_trb_shd.g_old_rec.trb_information6;
594: End If;
595: If (p_rec.trb_information7 = hr_api.g_varchar2) then
596: p_rec.trb_information7 :=
597: ota_trb_shd.g_old_rec.trb_information7;
593: ota_trb_shd.g_old_rec.trb_information6;
594: End If;
595: If (p_rec.trb_information7 = hr_api.g_varchar2) then
596: p_rec.trb_information7 :=
597: ota_trb_shd.g_old_rec.trb_information7;
598: End If;
599: If (p_rec.trb_information8 = hr_api.g_varchar2) then
600: p_rec.trb_information8 :=
601: ota_trb_shd.g_old_rec.trb_information8;
597: ota_trb_shd.g_old_rec.trb_information7;
598: End If;
599: If (p_rec.trb_information8 = hr_api.g_varchar2) then
600: p_rec.trb_information8 :=
601: ota_trb_shd.g_old_rec.trb_information8;
602: End If;
603: If (p_rec.trb_information9 = hr_api.g_varchar2) then
604: p_rec.trb_information9 :=
605: ota_trb_shd.g_old_rec.trb_information9;
601: ota_trb_shd.g_old_rec.trb_information8;
602: End If;
603: If (p_rec.trb_information9 = hr_api.g_varchar2) then
604: p_rec.trb_information9 :=
605: ota_trb_shd.g_old_rec.trb_information9;
606: End If;
607: If (p_rec.trb_information10 = hr_api.g_varchar2) then
608: p_rec.trb_information10 :=
609: ota_trb_shd.g_old_rec.trb_information10;
605: ota_trb_shd.g_old_rec.trb_information9;
606: End If;
607: If (p_rec.trb_information10 = hr_api.g_varchar2) then
608: p_rec.trb_information10 :=
609: ota_trb_shd.g_old_rec.trb_information10;
610: End If;
611: If (p_rec.trb_information11 = hr_api.g_varchar2) then
612: p_rec.trb_information11 :=
613: ota_trb_shd.g_old_rec.trb_information11;
609: ota_trb_shd.g_old_rec.trb_information10;
610: End If;
611: If (p_rec.trb_information11 = hr_api.g_varchar2) then
612: p_rec.trb_information11 :=
613: ota_trb_shd.g_old_rec.trb_information11;
614: End If;
615: If (p_rec.trb_information12 = hr_api.g_varchar2) then
616: p_rec.trb_information12 :=
617: ota_trb_shd.g_old_rec.trb_information12;
613: ota_trb_shd.g_old_rec.trb_information11;
614: End If;
615: If (p_rec.trb_information12 = hr_api.g_varchar2) then
616: p_rec.trb_information12 :=
617: ota_trb_shd.g_old_rec.trb_information12;
618: End If;
619: If (p_rec.trb_information13 = hr_api.g_varchar2) then
620: p_rec.trb_information13 :=
621: ota_trb_shd.g_old_rec.trb_information13;
617: ota_trb_shd.g_old_rec.trb_information12;
618: End If;
619: If (p_rec.trb_information13 = hr_api.g_varchar2) then
620: p_rec.trb_information13 :=
621: ota_trb_shd.g_old_rec.trb_information13;
622: End If;
623: If (p_rec.trb_information14 = hr_api.g_varchar2) then
624: p_rec.trb_information14 :=
625: ota_trb_shd.g_old_rec.trb_information14;
621: ota_trb_shd.g_old_rec.trb_information13;
622: End If;
623: If (p_rec.trb_information14 = hr_api.g_varchar2) then
624: p_rec.trb_information14 :=
625: ota_trb_shd.g_old_rec.trb_information14;
626: End If;
627: If (p_rec.trb_information15 = hr_api.g_varchar2) then
628: p_rec.trb_information15 :=
629: ota_trb_shd.g_old_rec.trb_information15;
625: ota_trb_shd.g_old_rec.trb_information14;
626: End If;
627: If (p_rec.trb_information15 = hr_api.g_varchar2) then
628: p_rec.trb_information15 :=
629: ota_trb_shd.g_old_rec.trb_information15;
630: End If;
631: If (p_rec.trb_information16 = hr_api.g_varchar2) then
632: p_rec.trb_information16 :=
633: ota_trb_shd.g_old_rec.trb_information16;
629: ota_trb_shd.g_old_rec.trb_information15;
630: End If;
631: If (p_rec.trb_information16 = hr_api.g_varchar2) then
632: p_rec.trb_information16 :=
633: ota_trb_shd.g_old_rec.trb_information16;
634: End If;
635: If (p_rec.trb_information17 = hr_api.g_varchar2) then
636: p_rec.trb_information17 :=
637: ota_trb_shd.g_old_rec.trb_information17;
633: ota_trb_shd.g_old_rec.trb_information16;
634: End If;
635: If (p_rec.trb_information17 = hr_api.g_varchar2) then
636: p_rec.trb_information17 :=
637: ota_trb_shd.g_old_rec.trb_information17;
638: End If;
639: If (p_rec.trb_information18 = hr_api.g_varchar2) then
640: p_rec.trb_information18 :=
641: ota_trb_shd.g_old_rec.trb_information18;
637: ota_trb_shd.g_old_rec.trb_information17;
638: End If;
639: If (p_rec.trb_information18 = hr_api.g_varchar2) then
640: p_rec.trb_information18 :=
641: ota_trb_shd.g_old_rec.trb_information18;
642: End If;
643: If (p_rec.trb_information19 = hr_api.g_varchar2) then
644: p_rec.trb_information19 :=
645: ota_trb_shd.g_old_rec.trb_information19;
641: ota_trb_shd.g_old_rec.trb_information18;
642: End If;
643: If (p_rec.trb_information19 = hr_api.g_varchar2) then
644: p_rec.trb_information19 :=
645: ota_trb_shd.g_old_rec.trb_information19;
646: End If;
647: If (p_rec.trb_information20 = hr_api.g_varchar2) then
648: p_rec.trb_information20 :=
649: ota_trb_shd.g_old_rec.trb_information20;
645: ota_trb_shd.g_old_rec.trb_information19;
646: End If;
647: If (p_rec.trb_information20 = hr_api.g_varchar2) then
648: p_rec.trb_information20 :=
649: ota_trb_shd.g_old_rec.trb_information20;
650: End If;
651: If (p_rec.display_to_learner_flag = hr_api.g_varchar2) then
652: p_rec.display_to_learner_flag :=
653: ota_trb_shd.g_old_rec.display_to_learner_flag;
649: ota_trb_shd.g_old_rec.trb_information20;
650: End If;
651: If (p_rec.display_to_learner_flag = hr_api.g_varchar2) then
652: p_rec.display_to_learner_flag :=
653: ota_trb_shd.g_old_rec.display_to_learner_flag;
654: End If;
655: If (p_rec.book_entire_period_flag = hr_api.g_varchar2) then
656: p_rec.book_entire_period_flag :=
657: ota_trb_shd.g_old_rec.book_entire_period_flag;
653: ota_trb_shd.g_old_rec.display_to_learner_flag;
654: End If;
655: If (p_rec.book_entire_period_flag = hr_api.g_varchar2) then
656: p_rec.book_entire_period_flag :=
657: ota_trb_shd.g_old_rec.book_entire_period_flag;
658: End If;
659: /* If (p_rec.unbook_request_flag = hr_api.g_varchar2) then
660: p_rec.unbook_request_flag :=
661: ota_trb_shd.g_old_rec.unbook_request_flag;
657: ota_trb_shd.g_old_rec.book_entire_period_flag;
658: End If;
659: /* If (p_rec.unbook_request_flag = hr_api.g_varchar2) then
660: p_rec.unbook_request_flag :=
661: ota_trb_shd.g_old_rec.unbook_request_flag;
662: End If; */
663: If (p_rec.chat_id = hr_api.g_number) then
664: p_rec.chat_id :=
665: ota_trb_shd.g_old_rec.chat_id;
661: ota_trb_shd.g_old_rec.unbook_request_flag;
662: End If; */
663: If (p_rec.chat_id = hr_api.g_number) then
664: p_rec.chat_id :=
665: ota_trb_shd.g_old_rec.chat_id;
666: End If;
667: If (p_rec.forum_id = hr_api.g_number) then
668: p_rec.forum_id :=
669: ota_trb_shd.g_old_rec.forum_id;
665: ota_trb_shd.g_old_rec.chat_id;
666: End If;
667: If (p_rec.forum_id = hr_api.g_number) then
668: p_rec.forum_id :=
669: ota_trb_shd.g_old_rec.forum_id;
670: End If;
671: If (p_rec.timezone_code = hr_api.g_varchar2) then
672: p_rec.timezone_code :=
673: ota_trb_shd.g_old_rec.timezone_code;
669: ota_trb_shd.g_old_rec.forum_id;
670: End If;
671: If (p_rec.timezone_code = hr_api.g_varchar2) then
672: p_rec.timezone_code :=
673: ota_trb_shd.g_old_rec.timezone_code;
674: End If;
675: --
676: hr_utility.set_location(' Leaving:'||l_proc, 10);
677: --
681: -- |---------------------------------< upd >----------------------------------|
682: -- ----------------------------------------------------------------------------
683: Procedure upd
684: (p_effective_date in date
685: ,p_rec in out nocopy ota_trb_shd.g_rec_type
686: ) is
687: --
688: l_proc varchar2(72) := g_package||'upd';
689: --
691: hr_utility.set_location('Entering:'||l_proc, 5);
692: --
693: -- We must lock the row which we need to update.
694: --
695: ota_trb_shd.lck
696: (p_rec.resource_booking_id
697: ,p_rec.object_version_number
698: );
699: --
784: ,p_forum_id in number default hr_api.g_number
785: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
786: ) is
787: --
788: l_rec ota_trb_shd.g_rec_type;
789: l_proc varchar2(72) := g_package||'upd';
790: --
791: Begin
792: hr_utility.set_location('Entering:'||l_proc, 5);
794: -- Call conversion function to turn arguments into the
795: -- l_rec structure.
796: --
797: l_rec :=
798: ota_trb_shd.convert_args
799: (p_resource_booking_id
800: ,p_supplied_resource_id
801: ,p_event_id
802: ,p_date_booking_placed