APPS.OTA_TAV_INS dependencies on OTA_ACTIVITY_VERSIONS

Line 79: -- Insert the row into: ota_activity_versions

75: p_rec.object_version_number := 1; -- Initialise the object version
76: --
77: ota_tav_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Insert the row into: ota_activity_versions
80: --
81: insert into ota_activity_versions
82: ( activity_version_id,
83: activity_id,

Line 81: insert into ota_activity_versions

77: ota_tav_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Insert the row into: ota_activity_versions
80: --
81: insert into ota_activity_versions
82: ( activity_version_id,
83: activity_id,
84: superseded_by_act_version_id,
85: developer_organization_id,

Line 266: Cursor C_Sel1 is select ota_activity_versions_s.nextval from sys.dual;

262: Procedure pre_insert(p_rec in out nocopy ota_tav_shd.g_rec_type) is
263: --
264: l_proc varchar2(72) := g_package||'pre_insert';
265: --
266: Cursor C_Sel1 is select ota_activity_versions_s.nextval from sys.dual;
267: --
268: --
269: Cursor C_Sel2 is
270: Select null

Line 271: from ota_activity_versions

267: --
268: --
269: Cursor C_Sel2 is
270: Select null
271: from ota_activity_versions
272: where activity_version_id =
273: ota_tav_ins.g_activity_version_id_i;
274: --
275: l_exists varchar2(1);