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_BUS dependencies on OTA_TRB_SHD

Line 197: (p_rec in ota_trb_shd.g_rec_type

193: -- Internal Row Handler Use Only.
194: --
195: -- ----------------------------------------------------------------------------
196: procedure chk_ddf
197: (p_rec in ota_trb_shd.g_rec_type
198: ) is
199: --
200: l_proc varchar2(72) := g_package || 'chk_ddf';
201: --

Line 206: nvl(ota_trb_shd.g_old_rec.trb_information_category, hr_api.g_varchar2) <>

202: begin
203: hr_utility.set_location('Entering:'||l_proc,10);
204: --
205: if ((p_rec.resource_booking_id is not null) and (
206: nvl(ota_trb_shd.g_old_rec.trb_information_category, hr_api.g_varchar2) <>
207: nvl(p_rec.trb_information_category, hr_api.g_varchar2) or
208: nvl(ota_trb_shd.g_old_rec.trb_information1, hr_api.g_varchar2) <>
209: nvl(p_rec.trb_information1, hr_api.g_varchar2) or
210: nvl(ota_trb_shd.g_old_rec.trb_information2, hr_api.g_varchar2) <>

Line 208: nvl(ota_trb_shd.g_old_rec.trb_information1, hr_api.g_varchar2) <>

204: --
205: if ((p_rec.resource_booking_id is not null) and (
206: nvl(ota_trb_shd.g_old_rec.trb_information_category, hr_api.g_varchar2) <>
207: nvl(p_rec.trb_information_category, hr_api.g_varchar2) or
208: nvl(ota_trb_shd.g_old_rec.trb_information1, hr_api.g_varchar2) <>
209: nvl(p_rec.trb_information1, hr_api.g_varchar2) or
210: nvl(ota_trb_shd.g_old_rec.trb_information2, hr_api.g_varchar2) <>
211: nvl(p_rec.trb_information2, hr_api.g_varchar2) or
212: nvl(ota_trb_shd.g_old_rec.trb_information3, hr_api.g_varchar2) <>

Line 210: nvl(ota_trb_shd.g_old_rec.trb_information2, hr_api.g_varchar2) <>

206: nvl(ota_trb_shd.g_old_rec.trb_information_category, hr_api.g_varchar2) <>
207: nvl(p_rec.trb_information_category, hr_api.g_varchar2) or
208: nvl(ota_trb_shd.g_old_rec.trb_information1, hr_api.g_varchar2) <>
209: nvl(p_rec.trb_information1, hr_api.g_varchar2) or
210: nvl(ota_trb_shd.g_old_rec.trb_information2, hr_api.g_varchar2) <>
211: nvl(p_rec.trb_information2, hr_api.g_varchar2) or
212: nvl(ota_trb_shd.g_old_rec.trb_information3, hr_api.g_varchar2) <>
213: nvl(p_rec.trb_information3, hr_api.g_varchar2) or
214: nvl(ota_trb_shd.g_old_rec.trb_information4, hr_api.g_varchar2) <>

Line 212: nvl(ota_trb_shd.g_old_rec.trb_information3, hr_api.g_varchar2) <>

208: nvl(ota_trb_shd.g_old_rec.trb_information1, hr_api.g_varchar2) <>
209: nvl(p_rec.trb_information1, hr_api.g_varchar2) or
210: nvl(ota_trb_shd.g_old_rec.trb_information2, hr_api.g_varchar2) <>
211: nvl(p_rec.trb_information2, hr_api.g_varchar2) or
212: nvl(ota_trb_shd.g_old_rec.trb_information3, hr_api.g_varchar2) <>
213: nvl(p_rec.trb_information3, hr_api.g_varchar2) or
214: nvl(ota_trb_shd.g_old_rec.trb_information4, hr_api.g_varchar2) <>
215: nvl(p_rec.trb_information4, hr_api.g_varchar2) or
216: nvl(ota_trb_shd.g_old_rec.trb_information5, hr_api.g_varchar2) <>

Line 214: nvl(ota_trb_shd.g_old_rec.trb_information4, hr_api.g_varchar2) <>

210: nvl(ota_trb_shd.g_old_rec.trb_information2, hr_api.g_varchar2) <>
211: nvl(p_rec.trb_information2, hr_api.g_varchar2) or
212: nvl(ota_trb_shd.g_old_rec.trb_information3, hr_api.g_varchar2) <>
213: nvl(p_rec.trb_information3, hr_api.g_varchar2) or
214: nvl(ota_trb_shd.g_old_rec.trb_information4, hr_api.g_varchar2) <>
215: nvl(p_rec.trb_information4, hr_api.g_varchar2) or
216: nvl(ota_trb_shd.g_old_rec.trb_information5, hr_api.g_varchar2) <>
217: nvl(p_rec.trb_information5, hr_api.g_varchar2) or
218: nvl(ota_trb_shd.g_old_rec.trb_information6, hr_api.g_varchar2) <>

Line 216: nvl(ota_trb_shd.g_old_rec.trb_information5, hr_api.g_varchar2) <>

212: nvl(ota_trb_shd.g_old_rec.trb_information3, hr_api.g_varchar2) <>
213: nvl(p_rec.trb_information3, hr_api.g_varchar2) or
214: nvl(ota_trb_shd.g_old_rec.trb_information4, hr_api.g_varchar2) <>
215: nvl(p_rec.trb_information4, hr_api.g_varchar2) or
216: nvl(ota_trb_shd.g_old_rec.trb_information5, hr_api.g_varchar2) <>
217: nvl(p_rec.trb_information5, hr_api.g_varchar2) or
218: nvl(ota_trb_shd.g_old_rec.trb_information6, hr_api.g_varchar2) <>
219: nvl(p_rec.trb_information6, hr_api.g_varchar2) or
220: nvl(ota_trb_shd.g_old_rec.trb_information7, hr_api.g_varchar2) <>

Line 218: nvl(ota_trb_shd.g_old_rec.trb_information6, hr_api.g_varchar2) <>

214: nvl(ota_trb_shd.g_old_rec.trb_information4, hr_api.g_varchar2) <>
215: nvl(p_rec.trb_information4, hr_api.g_varchar2) or
216: nvl(ota_trb_shd.g_old_rec.trb_information5, hr_api.g_varchar2) <>
217: nvl(p_rec.trb_information5, hr_api.g_varchar2) or
218: nvl(ota_trb_shd.g_old_rec.trb_information6, hr_api.g_varchar2) <>
219: nvl(p_rec.trb_information6, hr_api.g_varchar2) or
220: nvl(ota_trb_shd.g_old_rec.trb_information7, hr_api.g_varchar2) <>
221: nvl(p_rec.trb_information7, hr_api.g_varchar2) or
222: nvl(ota_trb_shd.g_old_rec.trb_information8, hr_api.g_varchar2) <>

Line 220: nvl(ota_trb_shd.g_old_rec.trb_information7, hr_api.g_varchar2) <>

216: nvl(ota_trb_shd.g_old_rec.trb_information5, hr_api.g_varchar2) <>
217: nvl(p_rec.trb_information5, hr_api.g_varchar2) or
218: nvl(ota_trb_shd.g_old_rec.trb_information6, hr_api.g_varchar2) <>
219: nvl(p_rec.trb_information6, hr_api.g_varchar2) or
220: nvl(ota_trb_shd.g_old_rec.trb_information7, hr_api.g_varchar2) <>
221: nvl(p_rec.trb_information7, hr_api.g_varchar2) or
222: nvl(ota_trb_shd.g_old_rec.trb_information8, hr_api.g_varchar2) <>
223: nvl(p_rec.trb_information8, hr_api.g_varchar2) or
224: nvl(ota_trb_shd.g_old_rec.trb_information9, hr_api.g_varchar2) <>

Line 222: nvl(ota_trb_shd.g_old_rec.trb_information8, hr_api.g_varchar2) <>

218: nvl(ota_trb_shd.g_old_rec.trb_information6, hr_api.g_varchar2) <>
219: nvl(p_rec.trb_information6, hr_api.g_varchar2) or
220: nvl(ota_trb_shd.g_old_rec.trb_information7, hr_api.g_varchar2) <>
221: nvl(p_rec.trb_information7, hr_api.g_varchar2) or
222: nvl(ota_trb_shd.g_old_rec.trb_information8, hr_api.g_varchar2) <>
223: nvl(p_rec.trb_information8, hr_api.g_varchar2) or
224: nvl(ota_trb_shd.g_old_rec.trb_information9, hr_api.g_varchar2) <>
225: nvl(p_rec.trb_information9, hr_api.g_varchar2) or
226: nvl(ota_trb_shd.g_old_rec.trb_information10, hr_api.g_varchar2) <>

Line 224: nvl(ota_trb_shd.g_old_rec.trb_information9, hr_api.g_varchar2) <>

220: nvl(ota_trb_shd.g_old_rec.trb_information7, hr_api.g_varchar2) <>
221: nvl(p_rec.trb_information7, hr_api.g_varchar2) or
222: nvl(ota_trb_shd.g_old_rec.trb_information8, hr_api.g_varchar2) <>
223: nvl(p_rec.trb_information8, hr_api.g_varchar2) or
224: nvl(ota_trb_shd.g_old_rec.trb_information9, hr_api.g_varchar2) <>
225: nvl(p_rec.trb_information9, hr_api.g_varchar2) or
226: nvl(ota_trb_shd.g_old_rec.trb_information10, hr_api.g_varchar2) <>
227: nvl(p_rec.trb_information10, hr_api.g_varchar2) or
228: nvl(ota_trb_shd.g_old_rec.trb_information11, hr_api.g_varchar2) <>

Line 226: nvl(ota_trb_shd.g_old_rec.trb_information10, hr_api.g_varchar2) <>

222: nvl(ota_trb_shd.g_old_rec.trb_information8, hr_api.g_varchar2) <>
223: nvl(p_rec.trb_information8, hr_api.g_varchar2) or
224: nvl(ota_trb_shd.g_old_rec.trb_information9, hr_api.g_varchar2) <>
225: nvl(p_rec.trb_information9, hr_api.g_varchar2) or
226: nvl(ota_trb_shd.g_old_rec.trb_information10, hr_api.g_varchar2) <>
227: nvl(p_rec.trb_information10, hr_api.g_varchar2) or
228: nvl(ota_trb_shd.g_old_rec.trb_information11, hr_api.g_varchar2) <>
229: nvl(p_rec.trb_information11, hr_api.g_varchar2) or
230: nvl(ota_trb_shd.g_old_rec.trb_information12, hr_api.g_varchar2) <>

Line 228: nvl(ota_trb_shd.g_old_rec.trb_information11, hr_api.g_varchar2) <>

224: nvl(ota_trb_shd.g_old_rec.trb_information9, hr_api.g_varchar2) <>
225: nvl(p_rec.trb_information9, hr_api.g_varchar2) or
226: nvl(ota_trb_shd.g_old_rec.trb_information10, hr_api.g_varchar2) <>
227: nvl(p_rec.trb_information10, hr_api.g_varchar2) or
228: nvl(ota_trb_shd.g_old_rec.trb_information11, hr_api.g_varchar2) <>
229: nvl(p_rec.trb_information11, hr_api.g_varchar2) or
230: nvl(ota_trb_shd.g_old_rec.trb_information12, hr_api.g_varchar2) <>
231: nvl(p_rec.trb_information12, hr_api.g_varchar2) or
232: nvl(ota_trb_shd.g_old_rec.trb_information13, hr_api.g_varchar2) <>

Line 230: nvl(ota_trb_shd.g_old_rec.trb_information12, hr_api.g_varchar2) <>

226: nvl(ota_trb_shd.g_old_rec.trb_information10, hr_api.g_varchar2) <>
227: nvl(p_rec.trb_information10, hr_api.g_varchar2) or
228: nvl(ota_trb_shd.g_old_rec.trb_information11, hr_api.g_varchar2) <>
229: nvl(p_rec.trb_information11, hr_api.g_varchar2) or
230: nvl(ota_trb_shd.g_old_rec.trb_information12, hr_api.g_varchar2) <>
231: nvl(p_rec.trb_information12, hr_api.g_varchar2) or
232: nvl(ota_trb_shd.g_old_rec.trb_information13, hr_api.g_varchar2) <>
233: nvl(p_rec.trb_information13, hr_api.g_varchar2) or
234: nvl(ota_trb_shd.g_old_rec.trb_information14, hr_api.g_varchar2) <>

Line 232: nvl(ota_trb_shd.g_old_rec.trb_information13, hr_api.g_varchar2) <>

228: nvl(ota_trb_shd.g_old_rec.trb_information11, hr_api.g_varchar2) <>
229: nvl(p_rec.trb_information11, hr_api.g_varchar2) or
230: nvl(ota_trb_shd.g_old_rec.trb_information12, hr_api.g_varchar2) <>
231: nvl(p_rec.trb_information12, hr_api.g_varchar2) or
232: nvl(ota_trb_shd.g_old_rec.trb_information13, hr_api.g_varchar2) <>
233: nvl(p_rec.trb_information13, hr_api.g_varchar2) or
234: nvl(ota_trb_shd.g_old_rec.trb_information14, hr_api.g_varchar2) <>
235: nvl(p_rec.trb_information14, hr_api.g_varchar2) or
236: nvl(ota_trb_shd.g_old_rec.trb_information15, hr_api.g_varchar2) <>

Line 234: nvl(ota_trb_shd.g_old_rec.trb_information14, hr_api.g_varchar2) <>

230: nvl(ota_trb_shd.g_old_rec.trb_information12, hr_api.g_varchar2) <>
231: nvl(p_rec.trb_information12, hr_api.g_varchar2) or
232: nvl(ota_trb_shd.g_old_rec.trb_information13, hr_api.g_varchar2) <>
233: nvl(p_rec.trb_information13, hr_api.g_varchar2) or
234: nvl(ota_trb_shd.g_old_rec.trb_information14, hr_api.g_varchar2) <>
235: nvl(p_rec.trb_information14, hr_api.g_varchar2) or
236: nvl(ota_trb_shd.g_old_rec.trb_information15, hr_api.g_varchar2) <>
237: nvl(p_rec.trb_information15, hr_api.g_varchar2) or
238: nvl(ota_trb_shd.g_old_rec.trb_information16, hr_api.g_varchar2) <>

Line 236: nvl(ota_trb_shd.g_old_rec.trb_information15, hr_api.g_varchar2) <>

232: nvl(ota_trb_shd.g_old_rec.trb_information13, hr_api.g_varchar2) <>
233: nvl(p_rec.trb_information13, hr_api.g_varchar2) or
234: nvl(ota_trb_shd.g_old_rec.trb_information14, hr_api.g_varchar2) <>
235: nvl(p_rec.trb_information14, hr_api.g_varchar2) or
236: nvl(ota_trb_shd.g_old_rec.trb_information15, hr_api.g_varchar2) <>
237: nvl(p_rec.trb_information15, hr_api.g_varchar2) or
238: nvl(ota_trb_shd.g_old_rec.trb_information16, hr_api.g_varchar2) <>
239: nvl(p_rec.trb_information16, hr_api.g_varchar2) or
240: nvl(ota_trb_shd.g_old_rec.trb_information17, hr_api.g_varchar2) <>

Line 238: nvl(ota_trb_shd.g_old_rec.trb_information16, hr_api.g_varchar2) <>

234: nvl(ota_trb_shd.g_old_rec.trb_information14, hr_api.g_varchar2) <>
235: nvl(p_rec.trb_information14, hr_api.g_varchar2) or
236: nvl(ota_trb_shd.g_old_rec.trb_information15, hr_api.g_varchar2) <>
237: nvl(p_rec.trb_information15, hr_api.g_varchar2) or
238: nvl(ota_trb_shd.g_old_rec.trb_information16, hr_api.g_varchar2) <>
239: nvl(p_rec.trb_information16, hr_api.g_varchar2) or
240: nvl(ota_trb_shd.g_old_rec.trb_information17, hr_api.g_varchar2) <>
241: nvl(p_rec.trb_information17, hr_api.g_varchar2) or
242: nvl(ota_trb_shd.g_old_rec.trb_information18, hr_api.g_varchar2) <>

Line 240: nvl(ota_trb_shd.g_old_rec.trb_information17, hr_api.g_varchar2) <>

236: nvl(ota_trb_shd.g_old_rec.trb_information15, hr_api.g_varchar2) <>
237: nvl(p_rec.trb_information15, hr_api.g_varchar2) or
238: nvl(ota_trb_shd.g_old_rec.trb_information16, hr_api.g_varchar2) <>
239: nvl(p_rec.trb_information16, hr_api.g_varchar2) or
240: nvl(ota_trb_shd.g_old_rec.trb_information17, hr_api.g_varchar2) <>
241: nvl(p_rec.trb_information17, hr_api.g_varchar2) or
242: nvl(ota_trb_shd.g_old_rec.trb_information18, hr_api.g_varchar2) <>
243: nvl(p_rec.trb_information18, hr_api.g_varchar2) or
244: nvl(ota_trb_shd.g_old_rec.trb_information19, hr_api.g_varchar2) <>

Line 242: nvl(ota_trb_shd.g_old_rec.trb_information18, hr_api.g_varchar2) <>

238: nvl(ota_trb_shd.g_old_rec.trb_information16, hr_api.g_varchar2) <>
239: nvl(p_rec.trb_information16, hr_api.g_varchar2) or
240: nvl(ota_trb_shd.g_old_rec.trb_information17, hr_api.g_varchar2) <>
241: nvl(p_rec.trb_information17, hr_api.g_varchar2) or
242: nvl(ota_trb_shd.g_old_rec.trb_information18, hr_api.g_varchar2) <>
243: nvl(p_rec.trb_information18, hr_api.g_varchar2) or
244: nvl(ota_trb_shd.g_old_rec.trb_information19, hr_api.g_varchar2) <>
245: nvl(p_rec.trb_information19, hr_api.g_varchar2) or
246: nvl(ota_trb_shd.g_old_rec.trb_information20, hr_api.g_varchar2) <>

Line 244: nvl(ota_trb_shd.g_old_rec.trb_information19, hr_api.g_varchar2) <>

240: nvl(ota_trb_shd.g_old_rec.trb_information17, hr_api.g_varchar2) <>
241: nvl(p_rec.trb_information17, hr_api.g_varchar2) or
242: nvl(ota_trb_shd.g_old_rec.trb_information18, hr_api.g_varchar2) <>
243: nvl(p_rec.trb_information18, hr_api.g_varchar2) or
244: nvl(ota_trb_shd.g_old_rec.trb_information19, hr_api.g_varchar2) <>
245: nvl(p_rec.trb_information19, hr_api.g_varchar2) or
246: nvl(ota_trb_shd.g_old_rec.trb_information20, hr_api.g_varchar2) <>
247: nvl(p_rec.trb_information20, hr_api.g_varchar2) ))
248: or (p_rec.resource_booking_id is null) then

Line 246: nvl(ota_trb_shd.g_old_rec.trb_information20, hr_api.g_varchar2) <>

242: nvl(ota_trb_shd.g_old_rec.trb_information18, hr_api.g_varchar2) <>
243: nvl(p_rec.trb_information18, hr_api.g_varchar2) or
244: nvl(ota_trb_shd.g_old_rec.trb_information19, hr_api.g_varchar2) <>
245: nvl(p_rec.trb_information19, hr_api.g_varchar2) or
246: nvl(ota_trb_shd.g_old_rec.trb_information20, hr_api.g_varchar2) <>
247: nvl(p_rec.trb_information20, hr_api.g_varchar2) ))
248: or (p_rec.resource_booking_id is null) then
249: --
250: -- Only execute the validation if absolutely necessary:

Line 334: ,p_rec in ota_trb_shd.g_rec_type

330: -- {End Of Comments}
331: -- ----------------------------------------------------------------------------
332: Procedure chk_non_updateable_args
333: (p_effective_date in date
334: ,p_rec in ota_trb_shd.g_rec_type
335: ) IS
336: --
337: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
338: --

Line 344: IF NOT ota_trb_shd.api_updating

340: --
341: -- Only proceed with the validation if a row exists for the current
342: -- record in the HR Schema.
343: --
344: IF NOT ota_trb_shd.api_updating
345: (p_resource_booking_id => p_rec.resource_booking_id
346: ,p_object_version_number => p_rec.object_version_number
347: ) THEN
348: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 426: p_rec in ota_trb_shd.g_rec_type ) is

422: -- {End Of Comments}
423: -- ----------------------------------------------------------------------------
424: Procedure insert_validate
425: (p_effective_date in date ,
426: p_rec in ota_trb_shd.g_rec_type ) is
427: --
428: l_proc varchar2(72) := g_package||'insert_validate';
429: l_resource_type varchar2(30);
430:

Line 605: ,p_rec in ota_trb_shd.g_rec_type

601: -- {End Of Comments}
602: -- ----------------------------------------------------------------------------
603: Procedure update_validate
604: (p_effective_date in date
605: ,p_rec in ota_trb_shd.g_rec_type
606: ) is
607: --
608: l_supplied_resource_id_changed boolean :=
609: ota_general.value_changed(ota_trb_shd.g_old_rec.supplied_resource_id,

Line 609: ota_general.value_changed(ota_trb_shd.g_old_rec.supplied_resource_id,

605: ,p_rec in ota_trb_shd.g_rec_type
606: ) is
607: --
608: l_supplied_resource_id_changed boolean :=
609: ota_general.value_changed(ota_trb_shd.g_old_rec.supplied_resource_id,
610: p_rec.supplied_resource_id);
611: --
612: l_event_id_changed boolean :=
613: ota_general.value_changed(ota_trb_shd.g_old_rec.event_id,

Line 613: ota_general.value_changed(ota_trb_shd.g_old_rec.event_id,

609: ota_general.value_changed(ota_trb_shd.g_old_rec.supplied_resource_id,
610: p_rec.supplied_resource_id);
611: --
612: l_event_id_changed boolean :=
613: ota_general.value_changed(ota_trb_shd.g_old_rec.event_id,
614: p_rec.event_id);
615: --
616: l_role_to_play_changed boolean :=
617: ota_general.value_changed(ota_trb_shd.g_old_rec.role_to_play,

Line 617: ota_general.value_changed(ota_trb_shd.g_old_rec.role_to_play,

613: ota_general.value_changed(ota_trb_shd.g_old_rec.event_id,
614: p_rec.event_id);
615: --
616: l_role_to_play_changed boolean :=
617: ota_general.value_changed(ota_trb_shd.g_old_rec.role_to_play,
618: p_rec.role_to_play);
619: --
620: l_quantity_changed boolean :=
621: ota_general.value_changed(ota_trb_shd.g_old_rec.quantity,

Line 621: ota_general.value_changed(ota_trb_shd.g_old_rec.quantity,

617: ota_general.value_changed(ota_trb_shd.g_old_rec.role_to_play,
618: p_rec.role_to_play);
619: --
620: l_quantity_changed boolean :=
621: ota_general.value_changed(ota_trb_shd.g_old_rec.quantity,
622: p_rec.quantity);
623: --
624: l_deliver_to_changed boolean :=
625: ota_general.value_changed(ota_trb_shd.g_old_rec.deliver_to,

Line 625: ota_general.value_changed(ota_trb_shd.g_old_rec.deliver_to,

621: ota_general.value_changed(ota_trb_shd.g_old_rec.quantity,
622: p_rec.quantity);
623: --
624: l_deliver_to_changed boolean :=
625: ota_general.value_changed(ota_trb_shd.g_old_rec.deliver_to,
626: p_rec.deliver_to);
627: --
628: l_number_del_per_unit_changed boolean :=
629: ota_general.value_changed(ota_trb_shd.g_old_rec.delegates_per_unit,

Line 629: ota_general.value_changed(ota_trb_shd.g_old_rec.delegates_per_unit,

625: ota_general.value_changed(ota_trb_shd.g_old_rec.deliver_to,
626: p_rec.deliver_to);
627: --
628: l_number_del_per_unit_changed boolean :=
629: ota_general.value_changed(ota_trb_shd.g_old_rec.delegates_per_unit,
630: p_rec.delegates_per_unit);
631: --
632: l_required_date_from_changed boolean :=
633: ota_general.value_changed(ota_trb_shd.g_old_rec.required_date_from,

Line 633: ota_general.value_changed(ota_trb_shd.g_old_rec.required_date_from,

629: ota_general.value_changed(ota_trb_shd.g_old_rec.delegates_per_unit,
630: p_rec.delegates_per_unit);
631: --
632: l_required_date_from_changed boolean :=
633: ota_general.value_changed(ota_trb_shd.g_old_rec.required_date_from,
634: p_rec.required_date_from);
635: --
636: l_required_start_time_changed boolean :=
637: ota_general.value_changed(ota_trb_shd.g_old_rec.required_start_time,

Line 637: ota_general.value_changed(ota_trb_shd.g_old_rec.required_start_time,

633: ota_general.value_changed(ota_trb_shd.g_old_rec.required_date_from,
634: p_rec.required_date_from);
635: --
636: l_required_start_time_changed boolean :=
637: ota_general.value_changed(ota_trb_shd.g_old_rec.required_start_time,
638: p_rec.required_start_time);
639: --
640: l_required_date_to_changed boolean :=
641: ota_general.value_changed(ota_trb_shd.g_old_rec.required_date_to,

Line 641: ota_general.value_changed(ota_trb_shd.g_old_rec.required_date_to,

637: ota_general.value_changed(ota_trb_shd.g_old_rec.required_start_time,
638: p_rec.required_start_time);
639: --
640: l_required_date_to_changed boolean :=
641: ota_general.value_changed(ota_trb_shd.g_old_rec.required_date_to,
642: p_rec.required_date_to);
643: --
644: l_required_end_time_changed boolean :=
645: ota_general.value_changed(ota_trb_shd.g_old_rec.required_end_time,

Line 645: ota_general.value_changed(ota_trb_shd.g_old_rec.required_end_time,

641: ota_general.value_changed(ota_trb_shd.g_old_rec.required_date_to,
642: p_rec.required_date_to);
643: --
644: l_required_end_time_changed boolean :=
645: ota_general.value_changed(ota_trb_shd.g_old_rec.required_end_time,
646: p_rec.required_end_time);
647: --
648: l_status_changed boolean :=
649: ota_general.value_changed(ota_trb_shd.g_old_rec.status,

Line 649: ota_general.value_changed(ota_trb_shd.g_old_rec.status,

645: ota_general.value_changed(ota_trb_shd.g_old_rec.required_end_time,
646: p_rec.required_end_time);
647: --
648: l_status_changed boolean :=
649: ota_general.value_changed(ota_trb_shd.g_old_rec.status,
650: p_rec.status);
651: --
652: l_primary_venue_flag_changed boolean :=
653: ota_general.value_changed(ota_trb_shd.g_old_rec.primary_venue_flag,

Line 653: ota_general.value_changed(ota_trb_shd.g_old_rec.primary_venue_flag,

649: ota_general.value_changed(ota_trb_shd.g_old_rec.status,
650: p_rec.status);
651: --
652: l_primary_venue_flag_changed boolean :=
653: ota_general.value_changed(ota_trb_shd.g_old_rec.primary_venue_flag,
654: p_rec.primary_venue_flag);
655:
656: l_book_entire_period_changed boolean :=
657: ota_general.value_changed(ota_trb_shd.g_old_rec.book_entire_period_flag,

Line 657: ota_general.value_changed(ota_trb_shd.g_old_rec.book_entire_period_flag,

653: ota_general.value_changed(ota_trb_shd.g_old_rec.primary_venue_flag,
654: p_rec.primary_venue_flag);
655:
656: l_book_entire_period_changed boolean :=
657: ota_general.value_changed(ota_trb_shd.g_old_rec.book_entire_period_flag,
658: p_rec.book_entire_period_flag);
659: l_timezone_changed boolean :=
660: ota_general.value_changed(ota_trb_shd.g_old_rec.timezone_code,
661: p_rec.timezone_code);

Line 660: ota_general.value_changed(ota_trb_shd.g_old_rec.timezone_code,

656: l_book_entire_period_changed boolean :=
657: ota_general.value_changed(ota_trb_shd.g_old_rec.book_entire_period_flag,
658: p_rec.book_entire_period_flag);
659: l_timezone_changed boolean :=
660: ota_general.value_changed(ota_trb_shd.g_old_rec.timezone_code,
661: p_rec.timezone_code);
662: --
663: --
664: l_proc varchar2(72) := g_package||'update_validate';

Line 679: IF ota_trb_shd.g_old_rec.event_id is not null then

675: --
676: -- Call all supporting business operations
677: --
678: --
679: IF ota_trb_shd.g_old_rec.event_id is not null then
680: ota_evt_bus.set_security_group_id(ota_trb_shd.g_old_rec.event_id);
681: ELSIF (ota_trb_shd.g_old_rec.supplied_resource_id = p_rec.supplied_resource_id) THEN
682: ota_tsr_bus.set_security_group_id(ota_trb_shd.g_old_rec.supplied_resource_id);
683: ELSE

Line 680: ota_evt_bus.set_security_group_id(ota_trb_shd.g_old_rec.event_id);

676: -- Call all supporting business operations
677: --
678: --
679: IF ota_trb_shd.g_old_rec.event_id is not null then
680: ota_evt_bus.set_security_group_id(ota_trb_shd.g_old_rec.event_id);
681: ELSIF (ota_trb_shd.g_old_rec.supplied_resource_id = p_rec.supplied_resource_id) THEN
682: ota_tsr_bus.set_security_group_id(ota_trb_shd.g_old_rec.supplied_resource_id);
683: ELSE
684: ota_tsr_bus.set_security_group_id(p_rec.supplied_resource_id);

Line 681: ELSIF (ota_trb_shd.g_old_rec.supplied_resource_id = p_rec.supplied_resource_id) THEN

677: --
678: --
679: IF ota_trb_shd.g_old_rec.event_id is not null then
680: ota_evt_bus.set_security_group_id(ota_trb_shd.g_old_rec.event_id);
681: ELSIF (ota_trb_shd.g_old_rec.supplied_resource_id = p_rec.supplied_resource_id) THEN
682: ota_tsr_bus.set_security_group_id(ota_trb_shd.g_old_rec.supplied_resource_id);
683: ELSE
684: ota_tsr_bus.set_security_group_id(p_rec.supplied_resource_id);
685: END IF;

Line 682: ota_tsr_bus.set_security_group_id(ota_trb_shd.g_old_rec.supplied_resource_id);

678: --
679: IF ota_trb_shd.g_old_rec.event_id is not null then
680: ota_evt_bus.set_security_group_id(ota_trb_shd.g_old_rec.event_id);
681: ELSIF (ota_trb_shd.g_old_rec.supplied_resource_id = p_rec.supplied_resource_id) THEN
682: ota_tsr_bus.set_security_group_id(ota_trb_shd.g_old_rec.supplied_resource_id);
683: ELSE
684: ota_tsr_bus.set_security_group_id(p_rec.supplied_resource_id);
685: END IF;
686: --

Line 856: (p_rec in ota_trb_shd.g_rec_type

852: --
853: -- {End Of Comments}
854: -- ----------------------------------------------------------------------------
855: Procedure delete_validate
856: (p_rec in ota_trb_shd.g_rec_type
857: ) is
858: --
859: l_proc varchar2(72) := g_package||'delete_validate';
860: --