APPS.OTA_TRB_INS dependencies on OTA_RESOURCE_BOOKINGS

Line 87: -- Insert the row into: ota_resource_bookings

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: ota_trb_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: ota_resource_bookings
88: --
89: insert into ota_resource_bookings
90: (resource_booking_id
91: ,supplied_resource_id

Line 89: insert into ota_resource_bookings

85: ota_trb_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: ota_resource_bookings
88: --
89: insert into ota_resource_bookings
90: (resource_booking_id
91: ,supplied_resource_id
92: ,event_id
93: ,date_booking_placed

Line 253: Cursor C_Sel1 is select ota_resource_bookings_s.nextval from sys.dual;

249: Procedure pre_insert
250: (p_rec in out nocopy ota_trb_shd.g_rec_type
251: ) is
252: --
253: Cursor C_Sel1 is select ota_resource_bookings_s.nextval from sys.dual;
254: --
255: -- Cursor to check Automatic Primary Venue
256: --
257: Cursor C_Sel2 is

Line 259: From ota_resource_bookings orb

255: -- Cursor to check Automatic Primary Venue
256: --
257: Cursor C_Sel2 is
258: Select null
259: From ota_resource_bookings orb
260: Where orb.event_id = p_rec.event_id
261: and orb.primary_venue_flag = 'Y'
262: and orb.supplied_resource_id in(
263: Select osr.supplied_resource_id

Line 274: from ota_resource_bookings

270: WHERE SUPPLIED_RESOURCE_ID = p_rec.supplied_resource_id;
271: --
272: Cursor C_Sel4 is
273: Select null
274: from ota_resource_bookings
275: where resource_booking_id =
276: ota_trb_ins.g_resource_booking_id_i;
277: --
278: l_proc varchar2(72) := g_package||'pre_insert';

Line 297: fnd_message.set_token('TABLE_NAME','ota_resource_bookings');

293: --
294: -- The primary key values are already in use.
295: --
296: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
297: fnd_message.set_token('TABLE_NAME','ota_resource_bookings');
298: fnd_message.raise_error;
299: End If;
300: Close C_Sel4;
301: --

Line 509: (p_module_name => 'OTA_RESOURCE_BOOKINGS'

505: --
506: when hr_api.cannot_find_prog_unit then
507: --
508: hr_api.cannot_find_prog_unit_error
509: (p_module_name => 'OTA_RESOURCE_BOOKINGS'
510: ,p_hook_type => 'AI');
511: --
512: end;
513: --