APPS.OTA_TDB_INS dependencies on OTA_DELEGATE_BOOKINGS

Line 84: -- Insert the row into: ota_delegate_bookings

80: p_rec.object_version_number := 1; -- Initialise the object version
81: --
82: ota_tdb_shd.g_api_dml := true; -- Set the api dml status
83: --
84: -- Insert the row into: ota_delegate_bookings
85: --
86: insert into ota_delegate_bookings
87: ( booking_id,
88: booking_status_type_id,

Line 86: insert into ota_delegate_bookings

82: ota_tdb_shd.g_api_dml := true; -- Set the api dml status
83: --
84: -- Insert the row into: ota_delegate_bookings
85: --
86: insert into ota_delegate_bookings
87: ( booking_id,
88: booking_status_type_id,
89: delegate_person_id,
90: contact_id,

Line 310: Cursor C_Sel1 is select ota_delegate_bookings_s.nextval from sys.dual;

306: Procedure pre_insert(p_rec in out nocopy ota_tdb_shd.g_rec_type) is
307: --
308: l_proc varchar2(72) := g_package||'pre_insert';
309: --
310: Cursor C_Sel1 is select ota_delegate_bookings_s.nextval from sys.dual;
311: --
312: --
313: Cursor C_Sel2 is
314: Select null

Line 315: from ota_delegate_bookings

311: --
312: --
313: Cursor C_Sel2 is
314: Select null
315: from ota_delegate_bookings
316: where booking_id =
317: ota_tdb_ins.g_booking_id_i;
318: --
319: l_exists varchar2(1);

Line 336: fnd_message.set_token('TABLE_NAME','ota_delegate_bookings');

332: --
333: -- The primary key values are already in use.
334: --
335: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
336: fnd_message.set_token('TABLE_NAME','ota_delegate_bookings');
337: fnd_message.raise_error;
338: End If;
339: Close C_Sel2;
340: --