The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT inventory_item_id,
inv_master_organization_id
INTO p_inventory_item_id,
p_inv_master_org_id
FROM csi_item_instances
WHERE instance_id = p_instance_id
AND ((active_end_date is NULL) OR (active_end_date >= SYSDATE));
IF p_event = 'INSERT' THEN
IF ( p_stack_err_msg = TRUE ) THEN
FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
ELSIF p_event = 'UPDATE' THEN
IF ( p_stack_err_msg = TRUE ) THEN
FND_MESSAGE.SET_NAME('CSI','CSI_API_EXP_EXT_INST_ID');
/* Function Name : Val_inst_id_for_update */
/* */
/* Description : This function checks if instance */
/* ids can be updated */
/*----------------------------------------------------------*/
FUNCTION Val_inst_id_for_update
( p_instance_id_new IN NUMBER
,p_instance_id_old IN NUMBER
,p_stack_err_msg IN BOOLEAN )
RETURN BOOLEAN
IS
l_instance_id NUMBER;
END Val_inst_id_for_update;
SELECT attribute_level
,master_organization_id
,inventory_item_id
,item_category_id
,instance_id
INTO p_attribute_level
,p_master_organization_id
,p_inventory_item_id
,p_item_category_id
,p_instance_id
FROM csi_i_extended_attribs
WHERE attribute_id = p_attribute_id;
SELECT attribute_value_id,
attribute_id,
instance_id,
attribute_value,
active_start_date,
active_end_date,
context,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
object_version_number
INTO p_ext_attrib_rec.attribute_value_id,
p_ext_attrib_rec.attribute_id,
p_ext_attrib_rec.instance_id,
p_ext_attrib_rec.attribute_value,
p_ext_attrib_rec.active_start_date,
p_ext_attrib_rec.active_end_date,
p_ext_attrib_rec.context,
p_ext_attrib_rec.attribute1,
p_ext_attrib_rec.attribute2,
p_ext_attrib_rec.attribute3,
p_ext_attrib_rec.attribute4,
p_ext_attrib_rec.attribute5,
p_ext_attrib_rec.attribute6,
p_ext_attrib_rec.attribute7,
p_ext_attrib_rec.attribute8,
p_ext_attrib_rec.attribute9,
p_ext_attrib_rec.attribute10,
p_ext_attrib_rec.attribute11,
p_ext_attrib_rec.attribute12,
p_ext_attrib_rec.attribute13,
p_ext_attrib_rec.attribute14,
p_ext_attrib_rec.attribute15,
p_ext_attrib_rec.object_version_number
FROM csi_iea_values
WHERE attribute_value_id = p_att_value_id;
SELECT '1'
INTO l_dummy
FROM csi_iea_values
WHERE instance_id = p_instance_id
AND attribute_id = p_attribute_id;
SELECT active_start_date,
active_end_date
FROM csi_item_instances
WHERE instance_id = p_instance_id;
SELECT active_start_date,
active_end_date
FROM csi_item_instances
WHERE instance_id = p_instance_id;
SELECT MAX(t.transaction_date)
INTO l_transaction_date
FROM csi_iea_values_h s,
csi_transactions t
WHERE s.attribute_value_id=p_attr_value_id
AND s.transaction_id=t.transaction_id
AND t.transaction_id <> nvl(p_txn_id, -99999);
SELECT '1'
INTO l_dummy
FROM mtl_item_categories ic
WHERE ic.inventory_item_id = p_orig_inv_item_id
AND ic.organization_id = p_orig_master_org_id
AND ic.category_id = p_item_category_id
AND ic.category_set_id = l_category_set_id;
SELECT '1'
INTO l_attribute_value_id
FROM csi_iea_values
WHERE attribute_value_id = p_attribute_value_id ;
SELECT csi_iea_values_s.nextval
INTO l_attribute_value_id
FROM dual;
SELECT csi_iea_values_h_s.nextval
INTO l_attribute_value_id
FROM dual;