DBA Data[Home] [Help]

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

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

Line 293: from ota_events

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