[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT '1'
INTO l_instance_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_PRI_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 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_i_pricing_attribs_h s,
csi_transactions t
WHERE s.pricing_attribute_id=p_pricing_attr_id
AND s.transaction_id=t.transaction_id
AND t.transaction_id <>nvl(p_txn_id, -99999);
SELECT '1'
INTO l_pricing_attrib_id
FROM csi_i_pricing_attribs
WHERE pricing_attribute_id = p_pricing_attrib_id;
SELECT pricing_attribute_id,
instance_id,
active_start_date,
active_end_date,
pricing_context,
pricing_attribute1,
pricing_attribute2,
pricing_attribute3,
pricing_attribute4,
pricing_attribute5,
pricing_attribute6,
pricing_attribute7,
pricing_attribute8,
pricing_attribute9,
pricing_attribute10,
pricing_attribute11,
pricing_attribute12,
pricing_attribute13,
pricing_attribute14,
pricing_attribute15,
pricing_attribute16,
pricing_attribute17,
pricing_attribute18,
pricing_attribute19,
pricing_attribute20,
pricing_attribute21,
pricing_attribute22,
pricing_attribute23,
pricing_attribute24,
pricing_attribute25,
pricing_attribute26,
pricing_attribute27,
pricing_attribute28,
pricing_attribute29,
pricing_attribute30,
pricing_attribute31,
pricing_attribute32,
pricing_attribute33,
pricing_attribute34,
pricing_attribute35,
pricing_attribute36,
pricing_attribute37,
pricing_attribute38,
pricing_attribute39,
pricing_attribute40,
pricing_attribute41,
pricing_attribute42,
pricing_attribute43,
pricing_attribute44,
pricing_attribute45,
pricing_attribute46,
pricing_attribute47,
pricing_attribute48,
pricing_attribute49,
pricing_attribute50,
pricing_attribute51,
pricing_attribute52,
pricing_attribute53,
pricing_attribute54,
pricing_attribute55,
pricing_attribute56,
pricing_attribute57,
pricing_attribute58,
pricing_attribute59,
pricing_attribute60,
pricing_attribute61,
pricing_attribute62,
pricing_attribute63,
pricing_attribute64,
pricing_attribute65,
pricing_attribute66,
pricing_attribute67,
pricing_attribute68,
pricing_attribute69,
pricing_attribute70,
pricing_attribute71,
pricing_attribute72,
pricing_attribute73,
pricing_attribute74,
pricing_attribute75,
pricing_attribute76,
pricing_attribute77,
pricing_attribute78,
pricing_attribute79,
pricing_attribute80,
pricing_attribute81,
pricing_attribute82,
pricing_attribute83,
pricing_attribute84,
pricing_attribute85,
pricing_attribute86,
pricing_attribute87,
pricing_attribute88,
pricing_attribute89,
pricing_attribute90,
pricing_attribute91,
pricing_attribute92,
pricing_attribute93,
pricing_attribute94,
pricing_attribute95,
pricing_attribute96,
pricing_attribute97,
pricing_attribute98,
pricing_attribute99,
pricing_attribute100,
context,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
object_version_number
INTO p_pricing_attribs_rec.pricing_attribute_id,
p_pricing_attribs_rec.instance_id,
p_pricing_attribs_rec.active_start_date,
p_pricing_attribs_rec.active_end_date,
p_pricing_attribs_rec.pricing_context,
p_pricing_attribs_rec.pricing_attribute1,
p_pricing_attribs_rec.pricing_attribute2,
p_pricing_attribs_rec.pricing_attribute3,
p_pricing_attribs_rec.pricing_attribute4,
p_pricing_attribs_rec.pricing_attribute5,
p_pricing_attribs_rec.pricing_attribute6,
p_pricing_attribs_rec.pricing_attribute7,
p_pricing_attribs_rec.pricing_attribute8,
p_pricing_attribs_rec.pricing_attribute9,
p_pricing_attribs_rec.pricing_attribute10,
p_pricing_attribs_rec.pricing_attribute11,
p_pricing_attribs_rec.pricing_attribute12,
p_pricing_attribs_rec.pricing_attribute13,
p_pricing_attribs_rec.pricing_attribute14,
p_pricing_attribs_rec.pricing_attribute15,
p_pricing_attribs_rec.pricing_attribute16,
p_pricing_attribs_rec.pricing_attribute17,
p_pricing_attribs_rec.pricing_attribute18,
p_pricing_attribs_rec.pricing_attribute19,
p_pricing_attribs_rec.pricing_attribute20,
p_pricing_attribs_rec.pricing_attribute21,
p_pricing_attribs_rec.pricing_attribute22,
p_pricing_attribs_rec.pricing_attribute23,
p_pricing_attribs_rec.pricing_attribute24,
p_pricing_attribs_rec.pricing_attribute25,
p_pricing_attribs_rec.pricing_attribute26,
p_pricing_attribs_rec.pricing_attribute27,
p_pricing_attribs_rec.pricing_attribute28,
p_pricing_attribs_rec.pricing_attribute29,
p_pricing_attribs_rec.pricing_attribute30,
p_pricing_attribs_rec.pricing_attribute31,
p_pricing_attribs_rec.pricing_attribute32,
p_pricing_attribs_rec.pricing_attribute33,
p_pricing_attribs_rec.pricing_attribute34,
p_pricing_attribs_rec.pricing_attribute35,
p_pricing_attribs_rec.pricing_attribute36,
p_pricing_attribs_rec.pricing_attribute37,
p_pricing_attribs_rec.pricing_attribute38,
p_pricing_attribs_rec.pricing_attribute39,
p_pricing_attribs_rec.pricing_attribute40,
p_pricing_attribs_rec.pricing_attribute41,
p_pricing_attribs_rec.pricing_attribute42,
p_pricing_attribs_rec.pricing_attribute43,
p_pricing_attribs_rec.pricing_attribute44,
p_pricing_attribs_rec.pricing_attribute45,
p_pricing_attribs_rec.pricing_attribute46,
p_pricing_attribs_rec.pricing_attribute47,
p_pricing_attribs_rec.pricing_attribute48,
p_pricing_attribs_rec.pricing_attribute49,
p_pricing_attribs_rec.pricing_attribute50,
p_pricing_attribs_rec.pricing_attribute51,
p_pricing_attribs_rec.pricing_attribute52,
p_pricing_attribs_rec.pricing_attribute53,
p_pricing_attribs_rec.pricing_attribute54,
p_pricing_attribs_rec.pricing_attribute55,
p_pricing_attribs_rec.pricing_attribute56,
p_pricing_attribs_rec.pricing_attribute57,
p_pricing_attribs_rec.pricing_attribute58,
p_pricing_attribs_rec.pricing_attribute59,
p_pricing_attribs_rec.pricing_attribute60,
p_pricing_attribs_rec.pricing_attribute61,
p_pricing_attribs_rec.pricing_attribute62,
p_pricing_attribs_rec.pricing_attribute63,
p_pricing_attribs_rec.pricing_attribute64,
p_pricing_attribs_rec.pricing_attribute65,
p_pricing_attribs_rec.pricing_attribute66,
p_pricing_attribs_rec.pricing_attribute67,
p_pricing_attribs_rec.pricing_attribute68,
p_pricing_attribs_rec.pricing_attribute69,
p_pricing_attribs_rec.pricing_attribute70,
p_pricing_attribs_rec.pricing_attribute71,
p_pricing_attribs_rec.pricing_attribute72,
p_pricing_attribs_rec.pricing_attribute73,
p_pricing_attribs_rec.pricing_attribute74,
p_pricing_attribs_rec.pricing_attribute75,
p_pricing_attribs_rec.pricing_attribute76,
p_pricing_attribs_rec.pricing_attribute77,
p_pricing_attribs_rec.pricing_attribute78,
p_pricing_attribs_rec.pricing_attribute79,
p_pricing_attribs_rec.pricing_attribute80,
p_pricing_attribs_rec.pricing_attribute81,
p_pricing_attribs_rec.pricing_attribute82,
p_pricing_attribs_rec.pricing_attribute83,
p_pricing_attribs_rec.pricing_attribute84,
p_pricing_attribs_rec.pricing_attribute85,
p_pricing_attribs_rec.pricing_attribute86,
p_pricing_attribs_rec.pricing_attribute87,
p_pricing_attribs_rec.pricing_attribute88,
p_pricing_attribs_rec.pricing_attribute89,
p_pricing_attribs_rec.pricing_attribute90,
p_pricing_attribs_rec.pricing_attribute91,
p_pricing_attribs_rec.pricing_attribute92,
p_pricing_attribs_rec.pricing_attribute93,
p_pricing_attribs_rec.pricing_attribute94,
p_pricing_attribs_rec.pricing_attribute95,
p_pricing_attribs_rec.pricing_attribute96,
p_pricing_attribs_rec.pricing_attribute97,
p_pricing_attribs_rec.pricing_attribute98,
p_pricing_attribs_rec.pricing_attribute99,
p_pricing_attribs_rec.pricing_attribute100,
p_pricing_attribs_rec.context,
p_pricing_attribs_rec.attribute1,
p_pricing_attribs_rec.attribute2,
p_pricing_attribs_rec.attribute3,
p_pricing_attribs_rec.attribute4,
p_pricing_attribs_rec.attribute5,
p_pricing_attribs_rec.attribute6,
p_pricing_attribs_rec.attribute7,
p_pricing_attribs_rec.attribute8,
p_pricing_attribs_rec.attribute9,
p_pricing_attribs_rec.attribute10,
p_pricing_attribs_rec.attribute11,
p_pricing_attribs_rec.attribute12,
p_pricing_attribs_rec.attribute13,
p_pricing_attribs_rec.attribute14,
p_pricing_attribs_rec.attribute15,
p_pricing_attribs_rec.object_version_number
FROM csi_i_pricing_attribs
WHERE pricing_attribute_id = p_pricing_attrib_id;
SELECT csi_i_pricing_attribs_s.nextval
INTO l_pricing_attrib_id
FROM dual;
SELECT csi_i_pricing_attribs_h_s.nextval
INTO l_pricing_attrib_h_id
FROM dual;