APPS.OTA_TSP_INS dependencies on OTA_SKILL_PROVISIONS

Line 79: -- Insert the row into: ota_skill_provisions

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

Line 81: insert into ota_skill_provisions

77: ota_tsp_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Insert the row into: ota_skill_provisions
80: --
81: insert into ota_skill_provisions
82: ( skill_provision_id,
83: activity_version_id,
84: object_version_number,
85: type,

Line 208: Cursor C_Sel1 is select ota_skill_provisions_s.nextval from sys.dual;

204: ) is
205: --
206: l_proc varchar2(72) := g_package||'pre_insert';
207: --
208: Cursor C_Sel1 is select ota_skill_provisions_s.nextval from sys.dual;
209: --
210: Cursor C_Sel2 is
211: Select null
212: from ota_skill_provisions

Line 212: from ota_skill_provisions

208: Cursor C_Sel1 is select ota_skill_provisions_s.nextval from sys.dual;
209: --
210: Cursor C_Sel2 is
211: Select null
212: from ota_skill_provisions
213: where skill_provision_id =
214: ota_tsp_ins.g_skill_provision_id_i;
215: --
216: l_exists varchar2(1);