eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TRB_DEL dependencies on OTA_TRB_SHD

Line 52: (p_rec in ota_trb_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in ota_trb_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 60: ota_trb_shd.g_api_dml := true; -- Set the api dml status

56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: ota_trb_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the ota_resource_bookings row.
63: --
64: delete from ota_resource_bookings

Line 67: ota_trb_shd.g_api_dml := false; -- Unset the api dml status

63: --
64: delete from ota_resource_bookings
65: where resource_booking_id = p_rec.resource_booking_id;
66: --
67: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: Exception

Line 74: ota_trb_shd.g_api_dml := false; -- Unset the api dml status

70: --
71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
75: ota_trb_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: ota_trb_shd.g_api_dml := false; -- Unset the api dml status

Line 75: ota_trb_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
75: ota_trb_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;

Line 78: ota_trb_shd.g_api_dml := false; -- Unset the api dml status

74: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
75: ota_trb_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: ota_trb_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;
80: End delete_dml;
81: --
82: -- ----------------------------------------------------------------------------

Line 114: Procedure pre_delete(p_rec in ota_trb_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in ota_trb_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin

Line 169: Procedure post_delete(p_rec in ota_trb_shd.g_rec_type) is

165: -- Internal Row Handler Use Only.
166: --
167: -- {End Of Comments}
168: -- -----------------------------------------------------------------------------
169: Procedure post_delete(p_rec in ota_trb_shd.g_rec_type) is
170: --
171: l_proc varchar2(72) := g_package||'post_delete';
172: --
173: Begin

Line 181: => ota_trb_shd.g_old_rec.supplied_resource_id

177: ota_trb_rkd.after_delete
178: (p_resource_booking_id
179: => p_rec.resource_booking_id
180: ,p_supplied_resource_id_o
181: => ota_trb_shd.g_old_rec.supplied_resource_id
182: ,p_event_id_o
183: => ota_trb_shd.g_old_rec.event_id
184: ,p_date_booking_placed_o
185: => ota_trb_shd.g_old_rec.date_booking_placed

Line 183: => ota_trb_shd.g_old_rec.event_id

179: => p_rec.resource_booking_id
180: ,p_supplied_resource_id_o
181: => ota_trb_shd.g_old_rec.supplied_resource_id
182: ,p_event_id_o
183: => ota_trb_shd.g_old_rec.event_id
184: ,p_date_booking_placed_o
185: => ota_trb_shd.g_old_rec.date_booking_placed
186: ,p_object_version_number_o
187: => ota_trb_shd.g_old_rec.object_version_number

Line 185: => ota_trb_shd.g_old_rec.date_booking_placed

181: => ota_trb_shd.g_old_rec.supplied_resource_id
182: ,p_event_id_o
183: => ota_trb_shd.g_old_rec.event_id
184: ,p_date_booking_placed_o
185: => ota_trb_shd.g_old_rec.date_booking_placed
186: ,p_object_version_number_o
187: => ota_trb_shd.g_old_rec.object_version_number
188: ,p_status_o
189: => ota_trb_shd.g_old_rec.status

Line 187: => ota_trb_shd.g_old_rec.object_version_number

183: => ota_trb_shd.g_old_rec.event_id
184: ,p_date_booking_placed_o
185: => ota_trb_shd.g_old_rec.date_booking_placed
186: ,p_object_version_number_o
187: => ota_trb_shd.g_old_rec.object_version_number
188: ,p_status_o
189: => ota_trb_shd.g_old_rec.status
190: ,p_absolute_price_o
191: => ota_trb_shd.g_old_rec.absolute_price

Line 189: => ota_trb_shd.g_old_rec.status

185: => ota_trb_shd.g_old_rec.date_booking_placed
186: ,p_object_version_number_o
187: => ota_trb_shd.g_old_rec.object_version_number
188: ,p_status_o
189: => ota_trb_shd.g_old_rec.status
190: ,p_absolute_price_o
191: => ota_trb_shd.g_old_rec.absolute_price
192: ,p_booking_person_id_o
193: => ota_trb_shd.g_old_rec.booking_person_id

Line 191: => ota_trb_shd.g_old_rec.absolute_price

187: => ota_trb_shd.g_old_rec.object_version_number
188: ,p_status_o
189: => ota_trb_shd.g_old_rec.status
190: ,p_absolute_price_o
191: => ota_trb_shd.g_old_rec.absolute_price
192: ,p_booking_person_id_o
193: => ota_trb_shd.g_old_rec.booking_person_id
194: ,p_comments_o
195: => ota_trb_shd.g_old_rec.comments

Line 193: => ota_trb_shd.g_old_rec.booking_person_id

189: => ota_trb_shd.g_old_rec.status
190: ,p_absolute_price_o
191: => ota_trb_shd.g_old_rec.absolute_price
192: ,p_booking_person_id_o
193: => ota_trb_shd.g_old_rec.booking_person_id
194: ,p_comments_o
195: => ota_trb_shd.g_old_rec.comments
196: ,p_contact_name_o
197: => ota_trb_shd.g_old_rec.contact_name

Line 195: => ota_trb_shd.g_old_rec.comments

191: => ota_trb_shd.g_old_rec.absolute_price
192: ,p_booking_person_id_o
193: => ota_trb_shd.g_old_rec.booking_person_id
194: ,p_comments_o
195: => ota_trb_shd.g_old_rec.comments
196: ,p_contact_name_o
197: => ota_trb_shd.g_old_rec.contact_name
198: ,p_contact_phone_number_o
199: => ota_trb_shd.g_old_rec.contact_phone_number

Line 197: => ota_trb_shd.g_old_rec.contact_name

193: => ota_trb_shd.g_old_rec.booking_person_id
194: ,p_comments_o
195: => ota_trb_shd.g_old_rec.comments
196: ,p_contact_name_o
197: => ota_trb_shd.g_old_rec.contact_name
198: ,p_contact_phone_number_o
199: => ota_trb_shd.g_old_rec.contact_phone_number
200: ,p_delegates_per_unit_o
201: => ota_trb_shd.g_old_rec.delegates_per_unit

Line 199: => ota_trb_shd.g_old_rec.contact_phone_number

195: => ota_trb_shd.g_old_rec.comments
196: ,p_contact_name_o
197: => ota_trb_shd.g_old_rec.contact_name
198: ,p_contact_phone_number_o
199: => ota_trb_shd.g_old_rec.contact_phone_number
200: ,p_delegates_per_unit_o
201: => ota_trb_shd.g_old_rec.delegates_per_unit
202: ,p_quantity_o
203: => ota_trb_shd.g_old_rec.quantity

Line 201: => ota_trb_shd.g_old_rec.delegates_per_unit

197: => ota_trb_shd.g_old_rec.contact_name
198: ,p_contact_phone_number_o
199: => ota_trb_shd.g_old_rec.contact_phone_number
200: ,p_delegates_per_unit_o
201: => ota_trb_shd.g_old_rec.delegates_per_unit
202: ,p_quantity_o
203: => ota_trb_shd.g_old_rec.quantity
204: ,p_required_date_from_o
205: => ota_trb_shd.g_old_rec.required_date_from

Line 203: => ota_trb_shd.g_old_rec.quantity

199: => ota_trb_shd.g_old_rec.contact_phone_number
200: ,p_delegates_per_unit_o
201: => ota_trb_shd.g_old_rec.delegates_per_unit
202: ,p_quantity_o
203: => ota_trb_shd.g_old_rec.quantity
204: ,p_required_date_from_o
205: => ota_trb_shd.g_old_rec.required_date_from
206: ,p_required_date_to_o
207: => ota_trb_shd.g_old_rec.required_date_to

Line 205: => ota_trb_shd.g_old_rec.required_date_from

201: => ota_trb_shd.g_old_rec.delegates_per_unit
202: ,p_quantity_o
203: => ota_trb_shd.g_old_rec.quantity
204: ,p_required_date_from_o
205: => ota_trb_shd.g_old_rec.required_date_from
206: ,p_required_date_to_o
207: => ota_trb_shd.g_old_rec.required_date_to
208: ,p_required_end_time_o
209: => ota_trb_shd.g_old_rec.required_end_time

Line 207: => ota_trb_shd.g_old_rec.required_date_to

203: => ota_trb_shd.g_old_rec.quantity
204: ,p_required_date_from_o
205: => ota_trb_shd.g_old_rec.required_date_from
206: ,p_required_date_to_o
207: => ota_trb_shd.g_old_rec.required_date_to
208: ,p_required_end_time_o
209: => ota_trb_shd.g_old_rec.required_end_time
210: ,p_required_start_time_o
211: => ota_trb_shd.g_old_rec.required_start_time

Line 209: => ota_trb_shd.g_old_rec.required_end_time

205: => ota_trb_shd.g_old_rec.required_date_from
206: ,p_required_date_to_o
207: => ota_trb_shd.g_old_rec.required_date_to
208: ,p_required_end_time_o
209: => ota_trb_shd.g_old_rec.required_end_time
210: ,p_required_start_time_o
211: => ota_trb_shd.g_old_rec.required_start_time
212: ,p_deliver_to_o
213: => ota_trb_shd.g_old_rec.deliver_to

Line 211: => ota_trb_shd.g_old_rec.required_start_time

207: => ota_trb_shd.g_old_rec.required_date_to
208: ,p_required_end_time_o
209: => ota_trb_shd.g_old_rec.required_end_time
210: ,p_required_start_time_o
211: => ota_trb_shd.g_old_rec.required_start_time
212: ,p_deliver_to_o
213: => ota_trb_shd.g_old_rec.deliver_to
214: ,p_primary_venue_flag_o
215: => ota_trb_shd.g_old_rec.primary_venue_flag

Line 213: => ota_trb_shd.g_old_rec.deliver_to

209: => ota_trb_shd.g_old_rec.required_end_time
210: ,p_required_start_time_o
211: => ota_trb_shd.g_old_rec.required_start_time
212: ,p_deliver_to_o
213: => ota_trb_shd.g_old_rec.deliver_to
214: ,p_primary_venue_flag_o
215: => ota_trb_shd.g_old_rec.primary_venue_flag
216: ,p_role_to_play_o
217: => ota_trb_shd.g_old_rec.role_to_play

Line 215: => ota_trb_shd.g_old_rec.primary_venue_flag

211: => ota_trb_shd.g_old_rec.required_start_time
212: ,p_deliver_to_o
213: => ota_trb_shd.g_old_rec.deliver_to
214: ,p_primary_venue_flag_o
215: => ota_trb_shd.g_old_rec.primary_venue_flag
216: ,p_role_to_play_o
217: => ota_trb_shd.g_old_rec.role_to_play
218: ,p_trb_information_category_o
219: => ota_trb_shd.g_old_rec.trb_information_category

Line 217: => ota_trb_shd.g_old_rec.role_to_play

213: => ota_trb_shd.g_old_rec.deliver_to
214: ,p_primary_venue_flag_o
215: => ota_trb_shd.g_old_rec.primary_venue_flag
216: ,p_role_to_play_o
217: => ota_trb_shd.g_old_rec.role_to_play
218: ,p_trb_information_category_o
219: => ota_trb_shd.g_old_rec.trb_information_category
220: ,p_trb_information1_o
221: => ota_trb_shd.g_old_rec.trb_information1

Line 219: => ota_trb_shd.g_old_rec.trb_information_category

215: => ota_trb_shd.g_old_rec.primary_venue_flag
216: ,p_role_to_play_o
217: => ota_trb_shd.g_old_rec.role_to_play
218: ,p_trb_information_category_o
219: => ota_trb_shd.g_old_rec.trb_information_category
220: ,p_trb_information1_o
221: => ota_trb_shd.g_old_rec.trb_information1
222: ,p_trb_information2_o
223: => ota_trb_shd.g_old_rec.trb_information2

Line 221: => ota_trb_shd.g_old_rec.trb_information1

217: => ota_trb_shd.g_old_rec.role_to_play
218: ,p_trb_information_category_o
219: => ota_trb_shd.g_old_rec.trb_information_category
220: ,p_trb_information1_o
221: => ota_trb_shd.g_old_rec.trb_information1
222: ,p_trb_information2_o
223: => ota_trb_shd.g_old_rec.trb_information2
224: ,p_trb_information3_o
225: => ota_trb_shd.g_old_rec.trb_information3

Line 223: => ota_trb_shd.g_old_rec.trb_information2

219: => ota_trb_shd.g_old_rec.trb_information_category
220: ,p_trb_information1_o
221: => ota_trb_shd.g_old_rec.trb_information1
222: ,p_trb_information2_o
223: => ota_trb_shd.g_old_rec.trb_information2
224: ,p_trb_information3_o
225: => ota_trb_shd.g_old_rec.trb_information3
226: ,p_trb_information4_o
227: => ota_trb_shd.g_old_rec.trb_information4

Line 225: => ota_trb_shd.g_old_rec.trb_information3

221: => ota_trb_shd.g_old_rec.trb_information1
222: ,p_trb_information2_o
223: => ota_trb_shd.g_old_rec.trb_information2
224: ,p_trb_information3_o
225: => ota_trb_shd.g_old_rec.trb_information3
226: ,p_trb_information4_o
227: => ota_trb_shd.g_old_rec.trb_information4
228: ,p_trb_information5_o
229: => ota_trb_shd.g_old_rec.trb_information5

Line 227: => ota_trb_shd.g_old_rec.trb_information4

223: => ota_trb_shd.g_old_rec.trb_information2
224: ,p_trb_information3_o
225: => ota_trb_shd.g_old_rec.trb_information3
226: ,p_trb_information4_o
227: => ota_trb_shd.g_old_rec.trb_information4
228: ,p_trb_information5_o
229: => ota_trb_shd.g_old_rec.trb_information5
230: ,p_trb_information6_o
231: => ota_trb_shd.g_old_rec.trb_information6

Line 229: => ota_trb_shd.g_old_rec.trb_information5

225: => ota_trb_shd.g_old_rec.trb_information3
226: ,p_trb_information4_o
227: => ota_trb_shd.g_old_rec.trb_information4
228: ,p_trb_information5_o
229: => ota_trb_shd.g_old_rec.trb_information5
230: ,p_trb_information6_o
231: => ota_trb_shd.g_old_rec.trb_information6
232: ,p_trb_information7_o
233: => ota_trb_shd.g_old_rec.trb_information7

Line 231: => ota_trb_shd.g_old_rec.trb_information6

227: => ota_trb_shd.g_old_rec.trb_information4
228: ,p_trb_information5_o
229: => ota_trb_shd.g_old_rec.trb_information5
230: ,p_trb_information6_o
231: => ota_trb_shd.g_old_rec.trb_information6
232: ,p_trb_information7_o
233: => ota_trb_shd.g_old_rec.trb_information7
234: ,p_trb_information8_o
235: => ota_trb_shd.g_old_rec.trb_information8

Line 233: => ota_trb_shd.g_old_rec.trb_information7

229: => ota_trb_shd.g_old_rec.trb_information5
230: ,p_trb_information6_o
231: => ota_trb_shd.g_old_rec.trb_information6
232: ,p_trb_information7_o
233: => ota_trb_shd.g_old_rec.trb_information7
234: ,p_trb_information8_o
235: => ota_trb_shd.g_old_rec.trb_information8
236: ,p_trb_information9_o
237: => ota_trb_shd.g_old_rec.trb_information9

Line 235: => ota_trb_shd.g_old_rec.trb_information8

231: => ota_trb_shd.g_old_rec.trb_information6
232: ,p_trb_information7_o
233: => ota_trb_shd.g_old_rec.trb_information7
234: ,p_trb_information8_o
235: => ota_trb_shd.g_old_rec.trb_information8
236: ,p_trb_information9_o
237: => ota_trb_shd.g_old_rec.trb_information9
238: ,p_trb_information10_o
239: => ota_trb_shd.g_old_rec.trb_information10

Line 237: => ota_trb_shd.g_old_rec.trb_information9

233: => ota_trb_shd.g_old_rec.trb_information7
234: ,p_trb_information8_o
235: => ota_trb_shd.g_old_rec.trb_information8
236: ,p_trb_information9_o
237: => ota_trb_shd.g_old_rec.trb_information9
238: ,p_trb_information10_o
239: => ota_trb_shd.g_old_rec.trb_information10
240: ,p_trb_information11_o
241: => ota_trb_shd.g_old_rec.trb_information11

Line 239: => ota_trb_shd.g_old_rec.trb_information10

235: => ota_trb_shd.g_old_rec.trb_information8
236: ,p_trb_information9_o
237: => ota_trb_shd.g_old_rec.trb_information9
238: ,p_trb_information10_o
239: => ota_trb_shd.g_old_rec.trb_information10
240: ,p_trb_information11_o
241: => ota_trb_shd.g_old_rec.trb_information11
242: ,p_trb_information12_o
243: => ota_trb_shd.g_old_rec.trb_information12

Line 241: => ota_trb_shd.g_old_rec.trb_information11

237: => ota_trb_shd.g_old_rec.trb_information9
238: ,p_trb_information10_o
239: => ota_trb_shd.g_old_rec.trb_information10
240: ,p_trb_information11_o
241: => ota_trb_shd.g_old_rec.trb_information11
242: ,p_trb_information12_o
243: => ota_trb_shd.g_old_rec.trb_information12
244: ,p_trb_information13_o
245: => ota_trb_shd.g_old_rec.trb_information13

Line 243: => ota_trb_shd.g_old_rec.trb_information12

239: => ota_trb_shd.g_old_rec.trb_information10
240: ,p_trb_information11_o
241: => ota_trb_shd.g_old_rec.trb_information11
242: ,p_trb_information12_o
243: => ota_trb_shd.g_old_rec.trb_information12
244: ,p_trb_information13_o
245: => ota_trb_shd.g_old_rec.trb_information13
246: ,p_trb_information14_o
247: => ota_trb_shd.g_old_rec.trb_information14

Line 245: => ota_trb_shd.g_old_rec.trb_information13

241: => ota_trb_shd.g_old_rec.trb_information11
242: ,p_trb_information12_o
243: => ota_trb_shd.g_old_rec.trb_information12
244: ,p_trb_information13_o
245: => ota_trb_shd.g_old_rec.trb_information13
246: ,p_trb_information14_o
247: => ota_trb_shd.g_old_rec.trb_information14
248: ,p_trb_information15_o
249: => ota_trb_shd.g_old_rec.trb_information15

Line 247: => ota_trb_shd.g_old_rec.trb_information14

243: => ota_trb_shd.g_old_rec.trb_information12
244: ,p_trb_information13_o
245: => ota_trb_shd.g_old_rec.trb_information13
246: ,p_trb_information14_o
247: => ota_trb_shd.g_old_rec.trb_information14
248: ,p_trb_information15_o
249: => ota_trb_shd.g_old_rec.trb_information15
250: ,p_trb_information16_o
251: => ota_trb_shd.g_old_rec.trb_information16

Line 249: => ota_trb_shd.g_old_rec.trb_information15

245: => ota_trb_shd.g_old_rec.trb_information13
246: ,p_trb_information14_o
247: => ota_trb_shd.g_old_rec.trb_information14
248: ,p_trb_information15_o
249: => ota_trb_shd.g_old_rec.trb_information15
250: ,p_trb_information16_o
251: => ota_trb_shd.g_old_rec.trb_information16
252: ,p_trb_information17_o
253: => ota_trb_shd.g_old_rec.trb_information17

Line 251: => ota_trb_shd.g_old_rec.trb_information16

247: => ota_trb_shd.g_old_rec.trb_information14
248: ,p_trb_information15_o
249: => ota_trb_shd.g_old_rec.trb_information15
250: ,p_trb_information16_o
251: => ota_trb_shd.g_old_rec.trb_information16
252: ,p_trb_information17_o
253: => ota_trb_shd.g_old_rec.trb_information17
254: ,p_trb_information18_o
255: => ota_trb_shd.g_old_rec.trb_information18

Line 253: => ota_trb_shd.g_old_rec.trb_information17

249: => ota_trb_shd.g_old_rec.trb_information15
250: ,p_trb_information16_o
251: => ota_trb_shd.g_old_rec.trb_information16
252: ,p_trb_information17_o
253: => ota_trb_shd.g_old_rec.trb_information17
254: ,p_trb_information18_o
255: => ota_trb_shd.g_old_rec.trb_information18
256: ,p_trb_information19_o
257: => ota_trb_shd.g_old_rec.trb_information19

Line 255: => ota_trb_shd.g_old_rec.trb_information18

251: => ota_trb_shd.g_old_rec.trb_information16
252: ,p_trb_information17_o
253: => ota_trb_shd.g_old_rec.trb_information17
254: ,p_trb_information18_o
255: => ota_trb_shd.g_old_rec.trb_information18
256: ,p_trb_information19_o
257: => ota_trb_shd.g_old_rec.trb_information19
258: ,p_trb_information20_o
259: => ota_trb_shd.g_old_rec.trb_information20

Line 257: => ota_trb_shd.g_old_rec.trb_information19

253: => ota_trb_shd.g_old_rec.trb_information17
254: ,p_trb_information18_o
255: => ota_trb_shd.g_old_rec.trb_information18
256: ,p_trb_information19_o
257: => ota_trb_shd.g_old_rec.trb_information19
258: ,p_trb_information20_o
259: => ota_trb_shd.g_old_rec.trb_information20
260: ,p_display_to_learner_flag_o
261: => ota_trb_shd.g_old_rec.display_to_learner_flag

Line 259: => ota_trb_shd.g_old_rec.trb_information20

255: => ota_trb_shd.g_old_rec.trb_information18
256: ,p_trb_information19_o
257: => ota_trb_shd.g_old_rec.trb_information19
258: ,p_trb_information20_o
259: => ota_trb_shd.g_old_rec.trb_information20
260: ,p_display_to_learner_flag_o
261: => ota_trb_shd.g_old_rec.display_to_learner_flag
262: ,p_book_entire_period_flag_o
263: => ota_trb_shd.g_old_rec.book_entire_period_flag

Line 261: => ota_trb_shd.g_old_rec.display_to_learner_flag

257: => ota_trb_shd.g_old_rec.trb_information19
258: ,p_trb_information20_o
259: => ota_trb_shd.g_old_rec.trb_information20
260: ,p_display_to_learner_flag_o
261: => ota_trb_shd.g_old_rec.display_to_learner_flag
262: ,p_book_entire_period_flag_o
263: => ota_trb_shd.g_old_rec.book_entire_period_flag
264: /* ,p_unbook_request_flag_o
265: => ota_trb_shd.g_old_rec.unbook_request_flag */

Line 263: => ota_trb_shd.g_old_rec.book_entire_period_flag

259: => ota_trb_shd.g_old_rec.trb_information20
260: ,p_display_to_learner_flag_o
261: => ota_trb_shd.g_old_rec.display_to_learner_flag
262: ,p_book_entire_period_flag_o
263: => ota_trb_shd.g_old_rec.book_entire_period_flag
264: /* ,p_unbook_request_flag_o
265: => ota_trb_shd.g_old_rec.unbook_request_flag */
266: ,p_chat_id_o
267: => ota_trb_shd.g_old_rec.chat_id

Line 265: => ota_trb_shd.g_old_rec.unbook_request_flag */

261: => ota_trb_shd.g_old_rec.display_to_learner_flag
262: ,p_book_entire_period_flag_o
263: => ota_trb_shd.g_old_rec.book_entire_period_flag
264: /* ,p_unbook_request_flag_o
265: => ota_trb_shd.g_old_rec.unbook_request_flag */
266: ,p_chat_id_o
267: => ota_trb_shd.g_old_rec.chat_id
268: ,p_forum_id_o
269: => ota_trb_shd.g_old_rec.forum_id

Line 267: => ota_trb_shd.g_old_rec.chat_id

263: => ota_trb_shd.g_old_rec.book_entire_period_flag
264: /* ,p_unbook_request_flag_o
265: => ota_trb_shd.g_old_rec.unbook_request_flag */
266: ,p_chat_id_o
267: => ota_trb_shd.g_old_rec.chat_id
268: ,p_forum_id_o
269: => ota_trb_shd.g_old_rec.forum_id
270: ,p_timezone_code_o
271: => ota_trb_shd.g_old_rec.timezone_code

Line 269: => ota_trb_shd.g_old_rec.forum_id

265: => ota_trb_shd.g_old_rec.unbook_request_flag */
266: ,p_chat_id_o
267: => ota_trb_shd.g_old_rec.chat_id
268: ,p_forum_id_o
269: => ota_trb_shd.g_old_rec.forum_id
270: ,p_timezone_code_o
271: => ota_trb_shd.g_old_rec.timezone_code
272: );
273: --

Line 271: => ota_trb_shd.g_old_rec.timezone_code

267: => ota_trb_shd.g_old_rec.chat_id
268: ,p_forum_id_o
269: => ota_trb_shd.g_old_rec.forum_id
270: ,p_timezone_code_o
271: => ota_trb_shd.g_old_rec.timezone_code
272: );
273: --
274: exception
275: --

Line 291: (p_rec in ota_trb_shd.g_rec_type

287: -- ----------------------------------------------------------------------------
288: -- |---------------------------------< del >----------------------------------|
289: -- ----------------------------------------------------------------------------
290: Procedure del
291: (p_rec in ota_trb_shd.g_rec_type
292: ) is
293: --
294: l_proc varchar2(72) := g_package||'del';
295: --

Line 301: ota_trb_shd.lck

297: hr_utility.set_location('Entering:'||l_proc, 5);
298: --
299: -- We must lock the row which we need to delete.
300: --
301: ota_trb_shd.lck
302: (p_rec.resource_booking_id
303: ,p_rec.object_version_number
304: );
305: --

Line 338: l_rec ota_trb_shd.g_rec_type;

334: (p_resource_booking_id in number
335: ,p_object_version_number in number
336: ) is
337: --
338: l_rec ota_trb_shd.g_rec_type;
339: l_proc varchar2(72) := g_package||'del';
340: --
341: Begin
342: hr_utility.set_location('Entering:'||l_proc, 5);