APPS.OTA_EVT_INS dependencies on OTA_EVENTS

Line 81: -- Insert the row into: ota_events

77: p_rec.object_version_number := 1; -- Initialise the object version
78: --
79: ota_evt_shd.g_api_dml := true; -- Set the api dml status
80: --
81: -- Insert the row into: ota_events
82: --
83: insert into ota_events
84: ( event_id,
85: vendor_id,

Line 83: insert into ota_events

79: ota_evt_shd.g_api_dml := true; -- Set the api dml status
80: --
81: -- Insert the row into: ota_events
82: --
83: insert into ota_events
84: ( event_id,
85: vendor_id,
86: activity_version_id,
87: business_group_id,

Line 291: Cursor C_Sel1 is select ota_events_s.nextval from sys.dual;

287: ) is
288: --
289: l_proc varchar2(72) := g_package||'pre_insert';
290: --
291: Cursor C_Sel1 is select ota_events_s.nextval from sys.dual;
292: --
293: Cursor C_Sel2 is
294: Select null
295: from ota_events

Line 295: from ota_events

291: Cursor C_Sel1 is select ota_events_s.nextval from sys.dual;
292: --
293: Cursor C_Sel2 is
294: Select null
295: from ota_events
296: where event_id =
297: ota_evt_ins.g_event_id_i;
298: --
299: l_exists varchar2(1);