APPS.OTA_TSR_INS dependencies on OTA_SUPPLIABLE_RESOURCES

Line 84: -- Insert the row into: ota_suppliable_resources

80: p_rec.object_version_number := 1; -- Initialise the object version
81: --
82: ota_tsr_shd.g_api_dml := true; -- Set the api dml status
83: --
84: -- Insert the row into: ota_suppliable_resources
85: --
86: insert into ota_suppliable_resources
87: ( supplied_resource_id,
88: vendor_id,

Line 86: insert into ota_suppliable_resources

82: ota_tsr_shd.g_api_dml := true; -- Set the api dml status
83: --
84: -- Insert the row into: ota_suppliable_resources
85: --
86: insert into ota_suppliable_resources
87: ( supplied_resource_id,
88: vendor_id,
89: business_group_id,
90: resource_definition_id,

Line 240: Cursor C_Sel1 is select ota_suppliable_resources_s.nextval from sys.dual;

236: Procedure pre_insert(p_rec in out nocopy ota_tsr_shd.g_rec_type) is
237: --
238: l_proc varchar2(72) := g_package||'pre_insert';
239: --
240: Cursor C_Sel1 is select ota_suppliable_resources_s.nextval from sys.dual;
241: --
242: Cursor C_Sel2 is
243: Select null
244: from ota_suppliable_resources

Line 244: from ota_suppliable_resources

240: Cursor C_Sel1 is select ota_suppliable_resources_s.nextval from sys.dual;
241: --
242: Cursor C_Sel2 is
243: Select null
244: from ota_suppliable_resources
245: where supplied_resource_id =
246: ota_tsr_ins.g_supplied_resource_id_i;
247: --
248:

Line 265: fnd_message.set_token('TABLE_NAME','ota_suppliable_resources');

261: --
262: -- The primary key values are already in use.
263: --
264: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
265: fnd_message.set_token('TABLE_NAME','ota_suppliable_resources');
266: fnd_message.raise_error;
267: End If;
268: Close C_Sel2;
269: --