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 308: Cursor C_Sel1 is select ota_delegate_bookings_s.nextval from sys.dual;

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

Line 313: from ota_delegate_bookings

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

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

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