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

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

Line 269: from ota_activity_versions

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