The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT creation_date,
new_PRICING_CONTEXT,
new_PRICING_ATTRIBUTE1,
new_PRICING_ATTRIBUTE2,
new_PRICING_ATTRIBUTE3,
new_PRICING_ATTRIBUTE4,
new_PRICING_ATTRIBUTE5,
new_PRICING_ATTRIBUTE6,
new_PRICING_ATTRIBUTE7,
new_PRICING_ATTRIBUTE8,
new_PRICING_ATTRIBUTE9,
new_PRICING_ATTRIBUTE10,
new_PRICING_ATTRIBUTE11,
new_PRICING_ATTRIBUTE12,
new_PRICING_ATTRIBUTE13,
new_PRICING_ATTRIBUTE14,
new_PRICING_ATTRIBUTE15,
new_PRICING_ATTRIBUTE16,
new_PRICING_ATTRIBUTE17,
new_PRICING_ATTRIBUTE18,
new_PRICING_ATTRIBUTE19,
new_PRICING_ATTRIBUTE20,
new_PRICING_ATTRIBUTE21,
new_PRICING_ATTRIBUTE22,
new_PRICING_ATTRIBUTE23,
new_PRICING_ATTRIBUTE24,
new_PRICING_ATTRIBUTE25,
new_PRICING_ATTRIBUTE26,
new_PRICING_ATTRIBUTE27,
new_PRICING_ATTRIBUTE28,
new_PRICING_ATTRIBUTE29,
new_PRICING_ATTRIBUTE30,
new_PRICING_ATTRIBUTE31,
new_PRICING_ATTRIBUTE32,
new_PRICING_ATTRIBUTE33,
new_PRICING_ATTRIBUTE34,
new_PRICING_ATTRIBUTE35,
new_PRICING_ATTRIBUTE36,
new_PRICING_ATTRIBUTE37,
new_PRICING_ATTRIBUTE38,
new_PRICING_ATTRIBUTE39,
new_PRICING_ATTRIBUTE40,
new_PRICING_ATTRIBUTE41,
new_PRICING_ATTRIBUTE42,
new_PRICING_ATTRIBUTE43,
new_PRICING_ATTRIBUTE44,
new_PRICING_ATTRIBUTE45,
new_PRICING_ATTRIBUTE46,
new_PRICING_ATTRIBUTE47,
new_PRICING_ATTRIBUTE48,
new_PRICING_ATTRIBUTE49,
new_PRICING_ATTRIBUTE50,
new_PRICING_ATTRIBUTE51,
new_PRICING_ATTRIBUTE52,
new_PRICING_ATTRIBUTE53,
new_PRICING_ATTRIBUTE54,
new_PRICING_ATTRIBUTE55,
new_PRICING_ATTRIBUTE56,
new_PRICING_ATTRIBUTE57,
new_PRICING_ATTRIBUTE58,
new_PRICING_ATTRIBUTE59,
new_PRICING_ATTRIBUTE60,
new_PRICING_ATTRIBUTE61,
new_PRICING_ATTRIBUTE62,
new_PRICING_ATTRIBUTE63,
new_PRICING_ATTRIBUTE64,
new_PRICING_ATTRIBUTE65,
new_PRICING_ATTRIBUTE66,
new_PRICING_ATTRIBUTE67,
new_PRICING_ATTRIBUTE68,
new_PRICING_ATTRIBUTE69,
new_PRICING_ATTRIBUTE70,
new_PRICING_ATTRIBUTE71,
new_PRICING_ATTRIBUTE72,
new_PRICING_ATTRIBUTE73,
new_PRICING_ATTRIBUTE74,
new_PRICING_ATTRIBUTE75,
new_PRICING_ATTRIBUTE76,
new_PRICING_ATTRIBUTE77,
new_PRICING_ATTRIBUTE78,
new_PRICING_ATTRIBUTE79,
new_PRICING_ATTRIBUTE80,
new_PRICING_ATTRIBUTE81,
new_PRICING_ATTRIBUTE82,
new_PRICING_ATTRIBUTE83,
new_PRICING_ATTRIBUTE84,
new_PRICING_ATTRIBUTE85,
new_PRICING_ATTRIBUTE86,
new_PRICING_ATTRIBUTE87,
new_PRICING_ATTRIBUTE88,
new_PRICING_ATTRIBUTE89,
new_PRICING_ATTRIBUTE90,
new_PRICING_ATTRIBUTE91,
new_PRICING_ATTRIBUTE92,
new_PRICING_ATTRIBUTE93,
new_PRICING_ATTRIBUTE94,
new_PRICING_ATTRIBUTE95,
new_PRICING_ATTRIBUTE96,
new_PRICING_ATTRIBUTE97,
new_PRICING_ATTRIBUTE98,
new_PRICING_ATTRIBUTE99,
new_PRICING_ATTRIBUTE100,
new_active_start_date,
new_active_end_date,
new_context,
new_attribute1 ,
new_attribute2,
new_attribute3,
new_attribute4,
new_attribute5,
new_attribute6,
new_attribute7,
new_attribute8,
new_attribute9,
new_attribute10,
new_attribute11,
new_attribute12,
new_attribute13,
new_attribute14,
new_attribute15
FROM csi_i_pricing_attribs_h
WHERE pricing_attribute_id = p_pri_hist_id
ORDER BY creation_date;
SELECT creation_date,
new_PRICING_CONTEXT,
new_PRICING_ATTRIBUTE1,
new_PRICING_ATTRIBUTE2,
new_PRICING_ATTRIBUTE3,
new_PRICING_ATTRIBUTE4,
new_PRICING_ATTRIBUTE5,
new_PRICING_ATTRIBUTE6,
new_PRICING_ATTRIBUTE7,
new_PRICING_ATTRIBUTE8,
new_PRICING_ATTRIBUTE9,
new_PRICING_ATTRIBUTE10,
new_PRICING_ATTRIBUTE11,
new_PRICING_ATTRIBUTE12,
new_PRICING_ATTRIBUTE13,
new_PRICING_ATTRIBUTE14,
new_PRICING_ATTRIBUTE15,
new_PRICING_ATTRIBUTE16,
new_PRICING_ATTRIBUTE17,
new_PRICING_ATTRIBUTE18,
new_PRICING_ATTRIBUTE19,
new_PRICING_ATTRIBUTE20,
new_PRICING_ATTRIBUTE21,
new_PRICING_ATTRIBUTE22,
new_PRICING_ATTRIBUTE23,
new_PRICING_ATTRIBUTE24,
new_PRICING_ATTRIBUTE25,
new_PRICING_ATTRIBUTE26,
new_PRICING_ATTRIBUTE27,
new_PRICING_ATTRIBUTE28,
new_PRICING_ATTRIBUTE29,
new_PRICING_ATTRIBUTE30,
new_PRICING_ATTRIBUTE31,
new_PRICING_ATTRIBUTE32,
new_PRICING_ATTRIBUTE33,
new_PRICING_ATTRIBUTE34,
new_PRICING_ATTRIBUTE35,
new_PRICING_ATTRIBUTE36,
new_PRICING_ATTRIBUTE37,
new_PRICING_ATTRIBUTE38,
new_PRICING_ATTRIBUTE39,
new_PRICING_ATTRIBUTE40,
new_PRICING_ATTRIBUTE41,
new_PRICING_ATTRIBUTE42,
new_PRICING_ATTRIBUTE43,
new_PRICING_ATTRIBUTE44,
new_PRICING_ATTRIBUTE45,
new_PRICING_ATTRIBUTE46,
new_PRICING_ATTRIBUTE47,
new_PRICING_ATTRIBUTE48,
new_PRICING_ATTRIBUTE49,
new_PRICING_ATTRIBUTE50,
new_PRICING_ATTRIBUTE51,
new_PRICING_ATTRIBUTE52,
new_PRICING_ATTRIBUTE53,
new_PRICING_ATTRIBUTE54,
new_PRICING_ATTRIBUTE55,
new_PRICING_ATTRIBUTE56,
new_PRICING_ATTRIBUTE57,
new_PRICING_ATTRIBUTE58,
new_PRICING_ATTRIBUTE59,
new_PRICING_ATTRIBUTE60,
new_PRICING_ATTRIBUTE61,
new_PRICING_ATTRIBUTE62,
new_PRICING_ATTRIBUTE63,
new_PRICING_ATTRIBUTE64,
new_PRICING_ATTRIBUTE65,
new_PRICING_ATTRIBUTE66,
new_PRICING_ATTRIBUTE67,
new_PRICING_ATTRIBUTE68,
new_PRICING_ATTRIBUTE69,
new_PRICING_ATTRIBUTE70,
new_PRICING_ATTRIBUTE71,
new_PRICING_ATTRIBUTE72,
new_PRICING_ATTRIBUTE73,
new_PRICING_ATTRIBUTE74,
new_PRICING_ATTRIBUTE75,
new_PRICING_ATTRIBUTE76,
new_PRICING_ATTRIBUTE77,
new_PRICING_ATTRIBUTE78,
new_PRICING_ATTRIBUTE79,
new_PRICING_ATTRIBUTE80,
new_PRICING_ATTRIBUTE81,
new_PRICING_ATTRIBUTE82,
new_PRICING_ATTRIBUTE83,
new_PRICING_ATTRIBUTE84,
new_PRICING_ATTRIBUTE85,
new_PRICING_ATTRIBUTE86,
new_PRICING_ATTRIBUTE87,
new_PRICING_ATTRIBUTE88,
new_PRICING_ATTRIBUTE89,
new_PRICING_ATTRIBUTE90,
new_PRICING_ATTRIBUTE91,
new_PRICING_ATTRIBUTE92,
new_PRICING_ATTRIBUTE93,
new_PRICING_ATTRIBUTE94,
new_PRICING_ATTRIBUTE95,
new_PRICING_ATTRIBUTE96,
new_PRICING_ATTRIBUTE97,
new_PRICING_ATTRIBUTE98,
new_PRICING_ATTRIBUTE99,
new_PRICING_ATTRIBUTE100,
new_active_start_date,
new_active_end_date,
new_context,
new_attribute1 ,
new_attribute2,
new_attribute3,
new_attribute4,
new_attribute5,
new_attribute6,
new_attribute7,
new_attribute8,
new_attribute9,
new_attribute10,
new_attribute11,
new_attribute12,
new_attribute13,
new_attribute14,
new_attribute15
FROM csi_i_pricing_attribs_h
WHERE price_attrib_history_id = p_pri_att_hist_id
AND full_dump_flag = 'Y';
SELECT MAX(price_attrib_history_id)
FROM csi_i_pricing_attribs_h
WHERE creation_date <= p_time
AND pricing_attribute_id = p_pri_att_id
AND full_dump_flag = 'Y' ;
SELECT --price_attrib_history_id,
OLD_PRICING_CONTEXT,
NEW_PRICING_CONTEXT ,
OLD_PRICING_ATTRIBUTE1,
NEW_PRICING_ATTRIBUTE1,
OLD_PRICING_ATTRIBUTE2,
NEW_PRICING_ATTRIBUTE2,
OLD_PRICING_ATTRIBUTE3,
NEW_PRICING_ATTRIBUTE3,
OLD_PRICING_ATTRIBUTE4,
NEW_PRICING_ATTRIBUTE4,
OLD_PRICING_ATTRIBUTE5,
NEW_PRICING_ATTRIBUTE5,
OLD_PRICING_ATTRIBUTE6,
NEW_PRICING_ATTRIBUTE6,
OLD_PRICING_ATTRIBUTE7,
NEW_PRICING_ATTRIBUTE7,
OLD_PRICING_ATTRIBUTE8,
NEW_PRICING_ATTRIBUTE8,
OLD_PRICING_ATTRIBUTE9,
NEW_PRICING_ATTRIBUTE9,
OLD_PRICING_ATTRIBUTE10,
NEW_PRICING_ATTRIBUTE10,
OLD_PRICING_ATTRIBUTE11,
NEW_PRICING_ATTRIBUTE11,
OLD_PRICING_ATTRIBUTE12,
NEW_PRICING_ATTRIBUTE12,
OLD_PRICING_ATTRIBUTE13,
NEW_PRICING_ATTRIBUTE13,
OLD_PRICING_ATTRIBUTE14,
NEW_PRICING_ATTRIBUTE14,
OLD_PRICING_ATTRIBUTE15,
NEW_PRICING_ATTRIBUTE15,
OLD_PRICING_ATTRIBUTE16,
NEW_PRICING_ATTRIBUTE16,
OLD_PRICING_ATTRIBUTE17,
NEW_PRICING_ATTRIBUTE17,
OLD_PRICING_ATTRIBUTE18,
NEW_PRICING_ATTRIBUTE18,
OLD_PRICING_ATTRIBUTE19,
NEW_PRICING_ATTRIBUTE19,
OLD_PRICING_ATTRIBUTE20,
NEW_PRICING_ATTRIBUTE20,
OLD_PRICING_ATTRIBUTE21,
NEW_PRICING_ATTRIBUTE21,
OLD_PRICING_ATTRIBUTE22,
NEW_PRICING_ATTRIBUTE22,
OLD_PRICING_ATTRIBUTE23,
NEW_PRICING_ATTRIBUTE23,
OLD_PRICING_ATTRIBUTE24,
NEW_PRICING_ATTRIBUTE24,
NEW_PRICING_ATTRIBUTE25,
OLD_PRICING_ATTRIBUTE25,
OLD_PRICING_ATTRIBUTE26,
NEW_PRICING_ATTRIBUTE26,
OLD_PRICING_ATTRIBUTE27,
NEW_PRICING_ATTRIBUTE27,
OLD_PRICING_ATTRIBUTE28,
NEW_PRICING_ATTRIBUTE28,
OLD_PRICING_ATTRIBUTE29,
NEW_PRICING_ATTRIBUTE29,
OLD_PRICING_ATTRIBUTE30,
NEW_PRICING_ATTRIBUTE30,
OLD_PRICING_ATTRIBUTE31,
NEW_PRICING_ATTRIBUTE31,
OLD_PRICING_ATTRIBUTE32,
NEW_PRICING_ATTRIBUTE32,
OLD_PRICING_ATTRIBUTE33,
NEW_PRICING_ATTRIBUTE33,
OLD_PRICING_ATTRIBUTE34,
NEW_PRICING_ATTRIBUTE34,
OLD_PRICING_ATTRIBUTE35,
NEW_PRICING_ATTRIBUTE35,
OLD_PRICING_ATTRIBUTE36,
NEW_PRICING_ATTRIBUTE36,
OLD_PRICING_ATTRIBUTE37,
NEW_PRICING_ATTRIBUTE37,
OLD_PRICING_ATTRIBUTE38,
NEW_PRICING_ATTRIBUTE38,
OLD_PRICING_ATTRIBUTE39,
NEW_PRICING_ATTRIBUTE39,
OLD_PRICING_ATTRIBUTE40,
NEW_PRICING_ATTRIBUTE40,
OLD_PRICING_ATTRIBUTE41,
NEW_PRICING_ATTRIBUTE41,
OLD_PRICING_ATTRIBUTE42,
NEW_PRICING_ATTRIBUTE42,
OLD_PRICING_ATTRIBUTE43,
NEW_PRICING_ATTRIBUTE43,
OLD_PRICING_ATTRIBUTE44,
NEW_PRICING_ATTRIBUTE44,
OLD_PRICING_ATTRIBUTE45,
NEW_PRICING_ATTRIBUTE45,
OLD_PRICING_ATTRIBUTE46,
NEW_PRICING_ATTRIBUTE46,
OLD_PRICING_ATTRIBUTE47,
NEW_PRICING_ATTRIBUTE47,
OLD_PRICING_ATTRIBUTE48,
NEW_PRICING_ATTRIBUTE48,
OLD_PRICING_ATTRIBUTE49,
NEW_PRICING_ATTRIBUTE49,
OLD_PRICING_ATTRIBUTE50,
NEW_PRICING_ATTRIBUTE50,
OLD_PRICING_ATTRIBUTE51,
NEW_PRICING_ATTRIBUTE51,
OLD_PRICING_ATTRIBUTE52,
NEW_PRICING_ATTRIBUTE52,
OLD_PRICING_ATTRIBUTE53,
NEW_PRICING_ATTRIBUTE53,
OLD_PRICING_ATTRIBUTE54,
NEW_PRICING_ATTRIBUTE54,
OLD_PRICING_ATTRIBUTE55,
NEW_PRICING_ATTRIBUTE55,
OLD_PRICING_ATTRIBUTE56,
NEW_PRICING_ATTRIBUTE56,
OLD_PRICING_ATTRIBUTE57,
NEW_PRICING_ATTRIBUTE57,
OLD_PRICING_ATTRIBUTE58,
NEW_PRICING_ATTRIBUTE58,
OLD_PRICING_ATTRIBUTE59,
NEW_PRICING_ATTRIBUTE59,
OLD_PRICING_ATTRIBUTE60,
NEW_PRICING_ATTRIBUTE60,
OLD_PRICING_ATTRIBUTE61,
NEW_PRICING_ATTRIBUTE61,
OLD_PRICING_ATTRIBUTE62,
NEW_PRICING_ATTRIBUTE62,
OLD_PRICING_ATTRIBUTE63,
NEW_PRICING_ATTRIBUTE63,
OLD_PRICING_ATTRIBUTE64,
NEW_PRICING_ATTRIBUTE64,
OLD_PRICING_ATTRIBUTE65,
NEW_PRICING_ATTRIBUTE65,
OLD_PRICING_ATTRIBUTE66,
NEW_PRICING_ATTRIBUTE66,
OLD_PRICING_ATTRIBUTE67,
NEW_PRICING_ATTRIBUTE67,
OLD_PRICING_ATTRIBUTE68,
NEW_PRICING_ATTRIBUTE68,
OLD_PRICING_ATTRIBUTE69,
NEW_PRICING_ATTRIBUTE69,
OLD_PRICING_ATTRIBUTE70,
NEW_PRICING_ATTRIBUTE70,
OLD_PRICING_ATTRIBUTE71,
NEW_PRICING_ATTRIBUTE71,
OLD_PRICING_ATTRIBUTE72,
NEW_PRICING_ATTRIBUTE72,
OLD_PRICING_ATTRIBUTE73,
NEW_PRICING_ATTRIBUTE73,
OLD_PRICING_ATTRIBUTE74,
NEW_PRICING_ATTRIBUTE74,
OLD_PRICING_ATTRIBUTE75,
NEW_PRICING_ATTRIBUTE75,
OLD_PRICING_ATTRIBUTE76,
NEW_PRICING_ATTRIBUTE76,
OLD_PRICING_ATTRIBUTE77,
NEW_PRICING_ATTRIBUTE77,
OLD_PRICING_ATTRIBUTE78,
NEW_PRICING_ATTRIBUTE78,
OLD_PRICING_ATTRIBUTE79,
NEW_PRICING_ATTRIBUTE79,
OLD_PRICING_ATTRIBUTE80,
NEW_PRICING_ATTRIBUTE80,
OLD_PRICING_ATTRIBUTE81,
NEW_PRICING_ATTRIBUTE81,
OLD_PRICING_ATTRIBUTE82,
NEW_PRICING_ATTRIBUTE82,
OLD_PRICING_ATTRIBUTE83,
NEW_PRICING_ATTRIBUTE83,
OLD_PRICING_ATTRIBUTE84,
NEW_PRICING_ATTRIBUTE84,
OLD_PRICING_ATTRIBUTE85,
NEW_PRICING_ATTRIBUTE85,
OLD_PRICING_ATTRIBUTE86,
NEW_PRICING_ATTRIBUTE86,
OLD_PRICING_ATTRIBUTE87,
NEW_PRICING_ATTRIBUTE87,
OLD_PRICING_ATTRIBUTE88,
NEW_PRICING_ATTRIBUTE88,
OLD_PRICING_ATTRIBUTE89,
NEW_PRICING_ATTRIBUTE89,
OLD_PRICING_ATTRIBUTE90,
NEW_PRICING_ATTRIBUTE90,
OLD_PRICING_ATTRIBUTE91,
NEW_PRICING_ATTRIBUTE91,
OLD_PRICING_ATTRIBUTE92,
NEW_PRICING_ATTRIBUTE92,
OLD_PRICING_ATTRIBUTE93,
NEW_PRICING_ATTRIBUTE93,
OLD_PRICING_ATTRIBUTE94,
NEW_PRICING_ATTRIBUTE94,
OLD_PRICING_ATTRIBUTE95,
NEW_PRICING_ATTRIBUTE95,
OLD_PRICING_ATTRIBUTE96,
NEW_PRICING_ATTRIBUTE96,
OLD_PRICING_ATTRIBUTE97,
NEW_PRICING_ATTRIBUTE97,
OLD_PRICING_ATTRIBUTE98,
NEW_PRICING_ATTRIBUTE98,
OLD_PRICING_ATTRIBUTE99,
NEW_PRICING_ATTRIBUTE99,
OLD_PRICING_ATTRIBUTE100,
NEW_PRICING_ATTRIBUTE100,
OLD_ACTIVE_START_DATE,
NEW_ACTIVE_START_DATE,
OLD_ACTIVE_END_DATE,
NEW_ACTIVE_END_DATE,
OLD_CONTEXT,
NEW_CONTEXT,
OLD_ATTRIBUTE1,
NEW_ATTRIBUTE1,
OLD_ATTRIBUTE2,
NEW_ATTRIBUTE2,
OLD_ATTRIBUTE3,
NEW_ATTRIBUTE3,
OLD_ATTRIBUTE4,
NEW_ATTRIBUTE4,
OLD_ATTRIBUTE5,
NEW_ATTRIBUTE5,
OLD_ATTRIBUTE6,
NEW_ATTRIBUTE6,
OLD_ATTRIBUTE7,
NEW_ATTRIBUTE7,
OLD_ATTRIBUTE8,
NEW_ATTRIBUTE8,
OLD_ATTRIBUTE9,
NEW_ATTRIBUTE9,
OLD_ATTRIBUTE10,
NEW_ATTRIBUTE10,
OLD_ATTRIBUTE11,
NEW_ATTRIBUTE11,
OLD_ATTRIBUTE12,
NEW_ATTRIBUTE12,
OLD_ATTRIBUTE13,
NEW_ATTRIBUTE13,
OLD_ATTRIBUTE14,
NEW_ATTRIBUTE14,
OLD_ATTRIBUTE15,
NEW_ATTRIBUTE15
FROM csi_i_pricing_attribs_h
WHERE creation_date <= p_time
AND creation_date >= p_nearest_full_dump
AND pricing_attribute_id = p_pri_att_id
ORDER BY creation_date;
l_pri_tbl.DELETE(i);
x_pri_tbl.DELETE;
'INSERT')) THEN
RAISE FND_API.G_EXC_ERROR;
CSI_I_PRICING_ATTRIBS_PKG.Insert_Row
(
l_pricing_attrib_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.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
,fnd_global.user_id
,sysdate
,fnd_global.user_id
,sysdate
,fnd_global.user_id
,1
,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
);
CSI_I_PRICING_ATTRIBS_H_PKG.Insert_Row(
px_PRICE_ATTRIB_HISTORY_ID => l_pricing_attrib_h_id,
p_PRICING_ATTRIBUTE_ID => l_pricing_attrib_id,
p_TRANSACTION_ID => p_txn_rec.transaction_id,
p_OLD_PRICING_CONTEXT => NULL,
p_NEW_PRICING_CONTEXT => p_pricing_attribs_rec.pricing_context,
p_OLD_PRICING_ATTRIBUTE1 => NULL,
p_NEW_PRICING_ATTRIBUTE1 => p_pricing_attribs_rec.pricing_attribute1,
p_OLD_PRICING_ATTRIBUTE2 => NULL,
p_NEW_PRICING_ATTRIBUTE2 => p_pricing_attribs_rec.pricing_attribute2,
p_OLD_PRICING_ATTRIBUTE3 => NULL,
p_NEW_PRICING_ATTRIBUTE3 => p_pricing_attribs_rec.pricing_attribute3,
p_OLD_PRICING_ATTRIBUTE4 => NULL,
p_NEW_PRICING_ATTRIBUTE4 => p_pricing_attribs_rec.pricing_attribute4,
p_OLD_PRICING_ATTRIBUTE5 => NULL,
p_NEW_PRICING_ATTRIBUTE5 => p_pricing_attribs_rec.pricing_attribute5,
p_OLD_PRICING_ATTRIBUTE6 => NULL,
p_NEW_PRICING_ATTRIBUTE6 => p_pricing_attribs_rec.pricing_attribute6,
p_OLD_PRICING_ATTRIBUTE7 => NULL,
p_NEW_PRICING_ATTRIBUTE7 => p_pricing_attribs_rec.pricing_attribute7,
p_OLD_PRICING_ATTRIBUTE8 => NULL,
p_NEW_PRICING_ATTRIBUTE8 => p_pricing_attribs_rec.pricing_attribute8,
p_OLD_PRICING_ATTRIBUTE9 => NULL,
p_NEW_PRICING_ATTRIBUTE9 => p_pricing_attribs_rec.pricing_attribute9,
p_OLD_PRICING_ATTRIBUTE10 => NULL,
p_NEW_PRICING_ATTRIBUTE10 => p_pricing_attribs_rec.pricing_attribute10,
p_OLD_PRICING_ATTRIBUTE11 => NULL,
p_NEW_PRICING_ATTRIBUTE11 => p_pricing_attribs_rec.pricing_attribute11,
p_OLD_PRICING_ATTRIBUTE12 => NULL,
p_NEW_PRICING_ATTRIBUTE12 => p_pricing_attribs_rec.pricing_attribute12,
p_OLD_PRICING_ATTRIBUTE13 => NULL,
p_NEW_PRICING_ATTRIBUTE13 => p_pricing_attribs_rec.pricing_attribute13,
p_OLD_PRICING_ATTRIBUTE14 => NULL,
p_NEW_PRICING_ATTRIBUTE14 => p_pricing_attribs_rec.pricing_attribute14,
p_OLD_PRICING_ATTRIBUTE15 => NULL,
p_NEW_PRICING_ATTRIBUTE15 => p_pricing_attribs_rec.pricing_attribute15,
p_OLD_PRICING_ATTRIBUTE16 => NULL,
p_NEW_PRICING_ATTRIBUTE16 => p_pricing_attribs_rec.pricing_attribute16,
p_OLD_PRICING_ATTRIBUTE17 => NULL,
p_NEW_PRICING_ATTRIBUTE17 => p_pricing_attribs_rec.pricing_attribute17,
p_OLD_PRICING_ATTRIBUTE18 => NULL,
p_NEW_PRICING_ATTRIBUTE18 => p_pricing_attribs_rec.pricing_attribute18,
p_OLD_PRICING_ATTRIBUTE19 => NULL,
p_NEW_PRICING_ATTRIBUTE19 => p_pricing_attribs_rec.pricing_attribute19,
p_OLD_PRICING_ATTRIBUTE20 => NULL,
p_NEW_PRICING_ATTRIBUTE20 => p_pricing_attribs_rec.pricing_attribute20,
p_OLD_PRICING_ATTRIBUTE21 => NULL,
p_NEW_PRICING_ATTRIBUTE21 => p_pricing_attribs_rec.pricing_attribute21,
p_OLD_PRICING_ATTRIBUTE22 => NULL,
p_NEW_PRICING_ATTRIBUTE22 => p_pricing_attribs_rec.pricing_attribute22,
p_OLD_PRICING_ATTRIBUTE23 => NULL,
p_NEW_PRICING_ATTRIBUTE23 => p_pricing_attribs_rec.pricing_attribute23,
p_OLD_PRICING_ATTRIBUTE24 => NULL,
p_NEW_PRICING_ATTRIBUTE24 => p_pricing_attribs_rec.pricing_attribute24,
p_NEW_PRICING_ATTRIBUTE25 => NULL,
p_OLD_PRICING_ATTRIBUTE25 => p_pricing_attribs_rec.pricing_attribute25,
p_OLD_PRICING_ATTRIBUTE26 => NULL,
p_NEW_PRICING_ATTRIBUTE26 => p_pricing_attribs_rec.pricing_attribute26,
p_OLD_PRICING_ATTRIBUTE27 => NULL,
p_NEW_PRICING_ATTRIBUTE27 => p_pricing_attribs_rec.pricing_attribute27,
p_OLD_PRICING_ATTRIBUTE28 => NULL,
p_NEW_PRICING_ATTRIBUTE28 => p_pricing_attribs_rec.pricing_attribute28,
p_OLD_PRICING_ATTRIBUTE29 => NULL,
p_NEW_PRICING_ATTRIBUTE29 => p_pricing_attribs_rec.pricing_attribute29,
p_OLD_PRICING_ATTRIBUTE30 => NULL,
p_NEW_PRICING_ATTRIBUTE30 => p_pricing_attribs_rec.pricing_attribute30,
p_OLD_PRICING_ATTRIBUTE31 => NULL,
p_NEW_PRICING_ATTRIBUTE31 => p_pricing_attribs_rec.pricing_attribute31,
p_OLD_PRICING_ATTRIBUTE32 => NULL,
p_NEW_PRICING_ATTRIBUTE32 => p_pricing_attribs_rec.pricing_attribute32,
p_OLD_PRICING_ATTRIBUTE33 => NULL,
p_NEW_PRICING_ATTRIBUTE33 => p_pricing_attribs_rec.pricing_attribute33,
p_OLD_PRICING_ATTRIBUTE34 => NULL,
p_NEW_PRICING_ATTRIBUTE34 => p_pricing_attribs_rec.pricing_attribute34,
p_OLD_PRICING_ATTRIBUTE35 => NULL,
p_NEW_PRICING_ATTRIBUTE35 => p_pricing_attribs_rec.pricing_attribute35,
p_OLD_PRICING_ATTRIBUTE36 => NULL,
p_NEW_PRICING_ATTRIBUTE36 => p_pricing_attribs_rec.pricing_attribute36,
p_OLD_PRICING_ATTRIBUTE37 => NULL,
p_NEW_PRICING_ATTRIBUTE37 => p_pricing_attribs_rec.pricing_attribute37,
p_OLD_PRICING_ATTRIBUTE38 => NULL,
p_NEW_PRICING_ATTRIBUTE38 => p_pricing_attribs_rec.pricing_attribute38,
p_OLD_PRICING_ATTRIBUTE39 => NULL,
p_NEW_PRICING_ATTRIBUTE39 => p_pricing_attribs_rec.pricing_attribute39,
p_OLD_PRICING_ATTRIBUTE40 => NULL,
p_NEW_PRICING_ATTRIBUTE40 => p_pricing_attribs_rec.pricing_attribute40,
p_OLD_PRICING_ATTRIBUTE41 => NULL,
p_NEW_PRICING_ATTRIBUTE41 => p_pricing_attribs_rec.pricing_attribute41,
p_OLD_PRICING_ATTRIBUTE42 => NULL,
p_NEW_PRICING_ATTRIBUTE42 => p_pricing_attribs_rec.pricing_attribute42,
p_OLD_PRICING_ATTRIBUTE43 => NULL,
p_NEW_PRICING_ATTRIBUTE43 => p_pricing_attribs_rec.pricing_attribute43,
p_OLD_PRICING_ATTRIBUTE44 => NULL,
p_NEW_PRICING_ATTRIBUTE44 => p_pricing_attribs_rec.pricing_attribute44,
p_OLD_PRICING_ATTRIBUTE45 => NULL,
p_NEW_PRICING_ATTRIBUTE45 => p_pricing_attribs_rec.pricing_attribute45,
p_OLD_PRICING_ATTRIBUTE46 => NULL,
p_NEW_PRICING_ATTRIBUTE46 => p_pricing_attribs_rec.pricing_attribute46,
p_OLD_PRICING_ATTRIBUTE47 => NULL,
p_NEW_PRICING_ATTRIBUTE47 => p_pricing_attribs_rec.pricing_attribute47,
p_OLD_PRICING_ATTRIBUTE48 => NULL,
p_NEW_PRICING_ATTRIBUTE48 => p_pricing_attribs_rec.pricing_attribute48,
p_OLD_PRICING_ATTRIBUTE49 => NULL,
p_NEW_PRICING_ATTRIBUTE49 => p_pricing_attribs_rec.pricing_attribute49,
p_OLD_PRICING_ATTRIBUTE50 => NULL,
p_NEW_PRICING_ATTRIBUTE50 => p_pricing_attribs_rec.pricing_attribute50,
p_OLD_PRICING_ATTRIBUTE51 => NULL,
p_NEW_PRICING_ATTRIBUTE51 => p_pricing_attribs_rec.pricing_attribute51,
p_OLD_PRICING_ATTRIBUTE52 => NULL,
p_NEW_PRICING_ATTRIBUTE52 => p_pricing_attribs_rec.pricing_attribute52,
p_OLD_PRICING_ATTRIBUTE53 => NULL,
p_NEW_PRICING_ATTRIBUTE53 => p_pricing_attribs_rec.pricing_attribute53,
p_OLD_PRICING_ATTRIBUTE54 => NULL,
p_NEW_PRICING_ATTRIBUTE54 => p_pricing_attribs_rec.pricing_attribute54,
p_OLD_PRICING_ATTRIBUTE55 => NULL,
p_NEW_PRICING_ATTRIBUTE55 => p_pricing_attribs_rec.pricing_attribute55,
p_OLD_PRICING_ATTRIBUTE56 => NULL,
p_NEW_PRICING_ATTRIBUTE56 => p_pricing_attribs_rec.pricing_attribute56,
p_OLD_PRICING_ATTRIBUTE57 => NULL,
p_NEW_PRICING_ATTRIBUTE57 => p_pricing_attribs_rec.pricing_attribute57,
p_OLD_PRICING_ATTRIBUTE58 => NULL,
p_NEW_PRICING_ATTRIBUTE58 => p_pricing_attribs_rec.pricing_attribute58,
p_OLD_PRICING_ATTRIBUTE59 => NULL,
p_NEW_PRICING_ATTRIBUTE59 => p_pricing_attribs_rec.pricing_attribute59,
p_OLD_PRICING_ATTRIBUTE60 => NULL,
p_NEW_PRICING_ATTRIBUTE60 => p_pricing_attribs_rec.pricing_attribute60,
p_OLD_PRICING_ATTRIBUTE61 => NULL,
p_NEW_PRICING_ATTRIBUTE61 => p_pricing_attribs_rec.pricing_attribute61,
p_OLD_PRICING_ATTRIBUTE62 => NULL,
p_NEW_PRICING_ATTRIBUTE62 => p_pricing_attribs_rec.pricing_attribute62,
p_OLD_PRICING_ATTRIBUTE63 => NULL,
p_NEW_PRICING_ATTRIBUTE63 => p_pricing_attribs_rec.pricing_attribute63,
p_OLD_PRICING_ATTRIBUTE64 => NULL,
p_NEW_PRICING_ATTRIBUTE64 => p_pricing_attribs_rec.pricing_attribute64,
p_OLD_PRICING_ATTRIBUTE65 => NULL,
p_NEW_PRICING_ATTRIBUTE65 => p_pricing_attribs_rec.pricing_attribute65,
p_OLD_PRICING_ATTRIBUTE66 => NULL,
p_NEW_PRICING_ATTRIBUTE66 => p_pricing_attribs_rec.pricing_attribute66,
p_OLD_PRICING_ATTRIBUTE67 => NULL,
p_NEW_PRICING_ATTRIBUTE67 => p_pricing_attribs_rec.pricing_attribute67,
p_OLD_PRICING_ATTRIBUTE68 => NULL,
p_NEW_PRICING_ATTRIBUTE68 => p_pricing_attribs_rec.pricing_attribute68,
p_OLD_PRICING_ATTRIBUTE69 => NULL,
p_NEW_PRICING_ATTRIBUTE69 => p_pricing_attribs_rec.pricing_attribute69,
p_OLD_PRICING_ATTRIBUTE70 => NULL,
p_NEW_PRICING_ATTRIBUTE70 => p_pricing_attribs_rec.pricing_attribute70,
p_OLD_PRICING_ATTRIBUTE71 => NULL,
p_NEW_PRICING_ATTRIBUTE71 => p_pricing_attribs_rec.pricing_attribute71,
p_OLD_PRICING_ATTRIBUTE72 => NULL,
p_NEW_PRICING_ATTRIBUTE72 => p_pricing_attribs_rec.pricing_attribute72,
p_OLD_PRICING_ATTRIBUTE73 => NULL,
p_NEW_PRICING_ATTRIBUTE73 => p_pricing_attribs_rec.pricing_attribute73,
p_OLD_PRICING_ATTRIBUTE74 => NULL,
p_NEW_PRICING_ATTRIBUTE74 => p_pricing_attribs_rec.pricing_attribute74,
p_OLD_PRICING_ATTRIBUTE75 => NULL,
p_NEW_PRICING_ATTRIBUTE75 => p_pricing_attribs_rec.pricing_attribute75,
p_OLD_PRICING_ATTRIBUTE76 => NULL,
p_NEW_PRICING_ATTRIBUTE76 => p_pricing_attribs_rec.pricing_attribute76,
p_OLD_PRICING_ATTRIBUTE77 => NULL,
p_NEW_PRICING_ATTRIBUTE77 => p_pricing_attribs_rec.pricing_attribute77,
p_OLD_PRICING_ATTRIBUTE78 => NULL,
p_NEW_PRICING_ATTRIBUTE78 => p_pricing_attribs_rec.pricing_attribute78,
p_OLD_PRICING_ATTRIBUTE79 => NULL,
p_NEW_PRICING_ATTRIBUTE79 => p_pricing_attribs_rec.pricing_attribute79,
p_OLD_PRICING_ATTRIBUTE80 => NULL,
p_NEW_PRICING_ATTRIBUTE80 => p_pricing_attribs_rec.pricing_attribute80,
p_OLD_PRICING_ATTRIBUTE81 => NULL,
p_NEW_PRICING_ATTRIBUTE81 => p_pricing_attribs_rec.pricing_attribute81,
p_OLD_PRICING_ATTRIBUTE82 => NULL,
p_NEW_PRICING_ATTRIBUTE82 => p_pricing_attribs_rec.pricing_attribute82,
p_OLD_PRICING_ATTRIBUTE83 => NULL,
p_NEW_PRICING_ATTRIBUTE83 => p_pricing_attribs_rec.pricing_attribute83,
p_OLD_PRICING_ATTRIBUTE84 => NULL,
p_NEW_PRICING_ATTRIBUTE84 => p_pricing_attribs_rec.pricing_attribute84,
p_OLD_PRICING_ATTRIBUTE85 => NULL,
p_NEW_PRICING_ATTRIBUTE85 => p_pricing_attribs_rec.pricing_attribute85,
p_OLD_PRICING_ATTRIBUTE86 => NULL,
p_NEW_PRICING_ATTRIBUTE86 => p_pricing_attribs_rec.pricing_attribute86,
p_OLD_PRICING_ATTRIBUTE87 => NULL,
p_NEW_PRICING_ATTRIBUTE87 => p_pricing_attribs_rec.pricing_attribute87,
p_OLD_PRICING_ATTRIBUTE88 => NULL,
p_NEW_PRICING_ATTRIBUTE88 => p_pricing_attribs_rec.pricing_attribute88,
p_OLD_PRICING_ATTRIBUTE89 => NULL,
p_NEW_PRICING_ATTRIBUTE89 => p_pricing_attribs_rec.pricing_attribute89,
p_OLD_PRICING_ATTRIBUTE90 => NULL,
p_NEW_PRICING_ATTRIBUTE90 => p_pricing_attribs_rec.pricing_attribute90,
p_OLD_PRICING_ATTRIBUTE91 => NULL,
p_NEW_PRICING_ATTRIBUTE91 => p_pricing_attribs_rec.pricing_attribute91,
p_OLD_PRICING_ATTRIBUTE92 => NULL,
p_NEW_PRICING_ATTRIBUTE92 => p_pricing_attribs_rec.pricing_attribute92,
p_OLD_PRICING_ATTRIBUTE93 => NULL,
p_NEW_PRICING_ATTRIBUTE93 => p_pricing_attribs_rec.pricing_attribute93,
p_OLD_PRICING_ATTRIBUTE94 => NULL,
p_NEW_PRICING_ATTRIBUTE94 => p_pricing_attribs_rec.pricing_attribute94,
p_OLD_PRICING_ATTRIBUTE95 => NULL,
p_NEW_PRICING_ATTRIBUTE95 => p_pricing_attribs_rec.pricing_attribute95,
p_OLD_PRICING_ATTRIBUTE96 => NULL,
p_NEW_PRICING_ATTRIBUTE96 => p_pricing_attribs_rec.pricing_attribute96,
p_OLD_PRICING_ATTRIBUTE97 => NULL,
p_NEW_PRICING_ATTRIBUTE97 => p_pricing_attribs_rec.pricing_attribute97,
p_OLD_PRICING_ATTRIBUTE98 => NULL,
p_NEW_PRICING_ATTRIBUTE98 => p_pricing_attribs_rec.pricing_attribute98,
p_OLD_PRICING_ATTRIBUTE99 => NULL,
p_NEW_PRICING_ATTRIBUTE99 => p_pricing_attribs_rec.pricing_attribute99,
p_OLD_PRICING_ATTRIBUTE100 => NULL,
p_NEW_PRICING_ATTRIBUTE100 => p_pricing_attribs_rec.pricing_attribute100,
p_OLD_ACTIVE_START_DATE => NULL,
p_NEW_ACTIVE_START_DATE => p_pricing_attribs_rec.active_start_date,
p_OLD_ACTIVE_END_DATE => NULL,
p_NEW_ACTIVE_END_DATE => p_pricing_attribs_rec.active_end_date,
p_OLD_CONTEXT => NULL ,
p_NEW_CONTEXT => p_pricing_attribs_rec.context ,
p_OLD_ATTRIBUTE1 => NULL ,
p_NEW_ATTRIBUTE1 => p_pricing_attribs_rec.ATTRIBUTE1 ,
p_OLD_ATTRIBUTE2 => NULL ,
p_NEW_ATTRIBUTE2 => p_pricing_attribs_rec.ATTRIBUTE2 ,
p_OLD_ATTRIBUTE3 => NULL ,
p_NEW_ATTRIBUTE3 => p_pricing_attribs_rec.ATTRIBUTE3 ,
p_OLD_ATTRIBUTE4 => NULL ,
p_NEW_ATTRIBUTE4 => p_pricing_attribs_rec.ATTRIBUTE4 ,
p_OLD_ATTRIBUTE5 => NULL ,
p_NEW_ATTRIBUTE5 => p_pricing_attribs_rec.ATTRIBUTE5 ,
p_OLD_ATTRIBUTE6 => NULL ,
p_NEW_ATTRIBUTE6 => p_pricing_attribs_rec.ATTRIBUTE6 ,
p_OLD_ATTRIBUTE7 => NULL ,
p_NEW_ATTRIBUTE7 => p_pricing_attribs_rec.ATTRIBUTE7 ,
p_OLD_ATTRIBUTE8 => NULL ,
p_NEW_ATTRIBUTE8 => p_pricing_attribs_rec.ATTRIBUTE8 ,
p_OLD_ATTRIBUTE9 => NULL ,
p_NEW_ATTRIBUTE9 => p_pricing_attribs_rec.ATTRIBUTE9 ,
p_OLD_ATTRIBUTE10 => NULL ,
p_NEW_ATTRIBUTE10 => p_pricing_attribs_rec.ATTRIBUTE10 ,
p_OLD_ATTRIBUTE11 => NULL ,
p_NEW_ATTRIBUTE11 => p_pricing_attribs_rec.ATTRIBUTE11 ,
p_OLD_ATTRIBUTE12 => NULL ,
p_NEW_ATTRIBUTE12 => p_pricing_attribs_rec.ATTRIBUTE12 ,
p_OLD_ATTRIBUTE13 => NULL ,
p_NEW_ATTRIBUTE13 => p_pricing_attribs_rec.ATTRIBUTE13 ,
p_OLD_ATTRIBUTE14 => NULL ,
p_NEW_ATTRIBUTE14 => p_pricing_attribs_rec.ATTRIBUTE14 ,
p_OLD_ATTRIBUTE15 => NULL ,
p_NEW_ATTRIBUTE15 => p_pricing_attribs_rec.ATTRIBUTE15 ,
p_FULL_DUMP_FLAG => 'N',
p_CREATED_BY => fnd_global.user_id,
p_CREATION_DATE => sysdate,
p_LAST_UPDATED_BY => fnd_global.user_id,
p_LAST_UPDATE_DATE => sysdate,
p_LAST_UPDATE_LOGIN => fnd_global.user_id,
p_OBJECT_VERSION_NUMBER => 1);
/* procedure name: update_pricing_attribs */
/* description : Updates the existing pricing */
/* attributes for an item instance */
/* */
/*--------------------------------------------------*/
PROCEDURE update_pricing_attribs
( p_api_version IN NUMBER
,p_commit IN VARCHAR2
,p_init_msg_list IN VARCHAR2
,p_validation_level IN NUMBER
,p_pricing_attribs_rec IN csi_datastructures_pub.pricing_attribs_rec
,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'update_pricing_attribs';
SELECT *
FROM csi_i_pricing_attribs_h
WHERE csi_i_pricing_attribs_h.price_attrib_history_id = p_pricing_hist_id
FOR UPDATE OF object_version_number;
SAVEPOINT update_pricing_attribs;
csi_gen_utility_pvt.put_line( 'update_pricing_attribs');
'UPDATE'
)) THEN
-- Check if it is an expire operation
IF NOT(csi_pricing_attrib_vld_pvt.Is_Expire_Op
(p_pricing_attribs_rec)) THEN
RAISE FND_API.G_EXC_ERROR;
IF NOT(csi_pricing_attrib_vld_pvt.Val_inst_id_for_update
( p_pricing_attribs_rec.instance_id
,l_pricing_attribs_rec.instance_id
)) THEN
RAISE FND_API.G_EXC_ERROR;
CSI_I_PRICING_ATTRIBS_PKG.Update_Row
(
l_pricing_attrib_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.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
,fnd_api.g_miss_num -- fnd_global.user_id
,fnd_api.g_miss_date
,fnd_global.user_id
,sysdate
,fnd_global.user_id
,l_pricing_attribs_rec.object_version_number
,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
);
SELECT price_attrib_history_id
INTO l_pricing_hist_id
FROM csi_i_pricing_attribs_h h
WHERE h.transaction_id = p_txn_rec.transaction_id
AND h.pricing_attribute_id = p_pricing_attribs_rec.pricing_attribute_id;
CSI_I_PRICING_ATTRIBS_H_PKG.Update_Row(
p_PRICE_ATTRIB_HISTORY_ID => l_pricing_hist_id ,
p_PRICING_ATTRIBUTE_ID => fnd_api.g_miss_num ,
p_TRANSACTION_ID => fnd_api.g_miss_num ,
p_OLD_PRICING_CONTEXT => fnd_api.g_miss_char ,
p_NEW_PRICING_CONTEXT => l_temp_pricing_attribs_rec.pricing_context ,
p_OLD_PRICING_ATTRIBUTE1 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE1 => l_temp_pricing_attribs_rec.pricing_attribute1 ,
p_OLD_PRICING_ATTRIBUTE2 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE2 => l_temp_pricing_attribs_rec.pricing_attribute2 ,
p_OLD_PRICING_ATTRIBUTE3 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE3 => l_temp_pricing_attribs_rec.pricing_attribute3 ,
p_OLD_PRICING_ATTRIBUTE4 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE4 => l_temp_pricing_attribs_rec.pricing_attribute4 ,
p_OLD_PRICING_ATTRIBUTE5 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE5 => l_temp_pricing_attribs_rec.pricing_attribute5 ,
p_OLD_PRICING_ATTRIBUTE6 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE6 => l_temp_pricing_attribs_rec.pricing_attribute6 ,
p_OLD_PRICING_ATTRIBUTE7 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE7 => l_temp_pricing_attribs_rec.pricing_attribute7 ,
p_OLD_PRICING_ATTRIBUTE8 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE8 => l_temp_pricing_attribs_rec.pricing_attribute8 ,
p_OLD_PRICING_ATTRIBUTE9 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE9 => l_temp_pricing_attribs_rec.pricing_attribute9 ,
p_OLD_PRICING_ATTRIBUTE10 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE10 => l_temp_pricing_attribs_rec.pricing_attribute10,
p_OLD_PRICING_ATTRIBUTE11 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE11 => l_temp_pricing_attribs_rec.pricing_attribute11,
p_OLD_PRICING_ATTRIBUTE12 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE12 => l_temp_pricing_attribs_rec.pricing_attribute12,
p_OLD_PRICING_ATTRIBUTE13 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE13 => l_temp_pricing_attribs_rec.pricing_attribute13,
p_OLD_PRICING_ATTRIBUTE14 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE14 => l_temp_pricing_attribs_rec.pricing_attribute14,
p_OLD_PRICING_ATTRIBUTE15 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE15 => l_temp_pricing_attribs_rec.pricing_attribute15,
p_OLD_PRICING_ATTRIBUTE16 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE16 => l_temp_pricing_attribs_rec.pricing_attribute16,
p_OLD_PRICING_ATTRIBUTE17 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE17 => l_temp_pricing_attribs_rec.pricing_attribute17,
p_OLD_PRICING_ATTRIBUTE18 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE18 => l_temp_pricing_attribs_rec.pricing_attribute18,
p_OLD_PRICING_ATTRIBUTE19 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE19 => l_temp_pricing_attribs_rec.pricing_attribute19,
p_OLD_PRICING_ATTRIBUTE20 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE20 => l_temp_pricing_attribs_rec.pricing_attribute20,
p_OLD_PRICING_ATTRIBUTE21 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE21 => l_temp_pricing_attribs_rec.pricing_attribute21,
p_OLD_PRICING_ATTRIBUTE22 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE22 => l_temp_pricing_attribs_rec.pricing_attribute22,
p_OLD_PRICING_ATTRIBUTE23 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE23 => l_temp_pricing_attribs_rec.pricing_attribute23,
p_OLD_PRICING_ATTRIBUTE24 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE24 => l_temp_pricing_attribs_rec.pricing_attribute24,
p_NEW_PRICING_ATTRIBUTE25 => fnd_api.g_miss_char ,
p_OLD_PRICING_ATTRIBUTE25 => l_temp_pricing_attribs_rec.pricing_attribute25,
p_OLD_PRICING_ATTRIBUTE26 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE26 => l_temp_pricing_attribs_rec.pricing_attribute26,
p_OLD_PRICING_ATTRIBUTE27 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE27 => l_temp_pricing_attribs_rec.pricing_attribute27,
p_OLD_PRICING_ATTRIBUTE28 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE28 => l_temp_pricing_attribs_rec.pricing_attribute28,
p_OLD_PRICING_ATTRIBUTE29 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE29 => l_temp_pricing_attribs_rec.pricing_attribute29,
p_OLD_PRICING_ATTRIBUTE30 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE30 => l_temp_pricing_attribs_rec.pricing_attribute30,
p_OLD_PRICING_ATTRIBUTE31 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE31 => l_temp_pricing_attribs_rec.pricing_attribute31,
p_OLD_PRICING_ATTRIBUTE32 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE32 => l_temp_pricing_attribs_rec.pricing_attribute32,
p_OLD_PRICING_ATTRIBUTE33 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE33 => l_temp_pricing_attribs_rec.pricing_attribute33,
p_OLD_PRICING_ATTRIBUTE34 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE34 => l_temp_pricing_attribs_rec.pricing_attribute34,
p_OLD_PRICING_ATTRIBUTE35 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE35 => l_temp_pricing_attribs_rec.pricing_attribute35,
p_OLD_PRICING_ATTRIBUTE36 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE36 => l_temp_pricing_attribs_rec.pricing_attribute36,
p_OLD_PRICING_ATTRIBUTE37 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE37 => l_temp_pricing_attribs_rec.pricing_attribute37,
p_OLD_PRICING_ATTRIBUTE38 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE38 => l_temp_pricing_attribs_rec.pricing_attribute38,
p_OLD_PRICING_ATTRIBUTE39 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE39 => l_temp_pricing_attribs_rec.pricing_attribute39,
p_OLD_PRICING_ATTRIBUTE40 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE40 => l_temp_pricing_attribs_rec.pricing_attribute40,
p_OLD_PRICING_ATTRIBUTE41 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE41 => l_temp_pricing_attribs_rec.pricing_attribute41,
p_OLD_PRICING_ATTRIBUTE42 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE42 => l_temp_pricing_attribs_rec.pricing_attribute42,
p_OLD_PRICING_ATTRIBUTE43 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE43 => l_temp_pricing_attribs_rec.pricing_attribute43,
p_OLD_PRICING_ATTRIBUTE44 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE44 => l_temp_pricing_attribs_rec.pricing_attribute44,
p_OLD_PRICING_ATTRIBUTE45 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE45 => l_temp_pricing_attribs_rec.pricing_attribute45,
p_OLD_PRICING_ATTRIBUTE46 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE46 => l_temp_pricing_attribs_rec.pricing_attribute46,
p_OLD_PRICING_ATTRIBUTE47 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE47 => l_temp_pricing_attribs_rec.pricing_attribute47,
p_OLD_PRICING_ATTRIBUTE48 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE48 => l_temp_pricing_attribs_rec.pricing_attribute48,
p_OLD_PRICING_ATTRIBUTE49 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE49 => l_temp_pricing_attribs_rec.pricing_attribute49,
p_OLD_PRICING_ATTRIBUTE50 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE50 => l_temp_pricing_attribs_rec.pricing_attribute50,
p_OLD_PRICING_ATTRIBUTE51 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE51 => l_temp_pricing_attribs_rec.pricing_attribute51,
p_OLD_PRICING_ATTRIBUTE52 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE52 => l_temp_pricing_attribs_rec.pricing_attribute52,
p_OLD_PRICING_ATTRIBUTE53 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE53 => l_temp_pricing_attribs_rec.pricing_attribute53,
p_OLD_PRICING_ATTRIBUTE54 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE54 => l_temp_pricing_attribs_rec.pricing_attribute54,
p_OLD_PRICING_ATTRIBUTE55 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE55 => l_temp_pricing_attribs_rec.pricing_attribute55,
p_OLD_PRICING_ATTRIBUTE56 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE56 => l_temp_pricing_attribs_rec.pricing_attribute56,
p_OLD_PRICING_ATTRIBUTE57 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE57 => l_temp_pricing_attribs_rec.pricing_attribute57,
p_OLD_PRICING_ATTRIBUTE58 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE58 => l_temp_pricing_attribs_rec.pricing_attribute58,
p_OLD_PRICING_ATTRIBUTE59 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE59 => l_temp_pricing_attribs_rec.pricing_attribute59,
p_OLD_PRICING_ATTRIBUTE60 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE60 => l_temp_pricing_attribs_rec.pricing_attribute60,
p_OLD_PRICING_ATTRIBUTE61 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE61 => l_temp_pricing_attribs_rec.pricing_attribute61,
p_OLD_PRICING_ATTRIBUTE62 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE62 => l_temp_pricing_attribs_rec.pricing_attribute62,
p_OLD_PRICING_ATTRIBUTE63 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE63 => l_temp_pricing_attribs_rec.pricing_attribute63,
p_OLD_PRICING_ATTRIBUTE64 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE64 => l_temp_pricing_attribs_rec.pricing_attribute64,
p_OLD_PRICING_ATTRIBUTE65 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE65 => l_temp_pricing_attribs_rec.pricing_attribute65,
p_OLD_PRICING_ATTRIBUTE66 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE66 => l_temp_pricing_attribs_rec.pricing_attribute66,
p_OLD_PRICING_ATTRIBUTE67 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE67 => l_temp_pricing_attribs_rec.pricing_attribute67,
p_OLD_PRICING_ATTRIBUTE68 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE68 => l_temp_pricing_attribs_rec.pricing_attribute68,
p_OLD_PRICING_ATTRIBUTE69 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE69 => l_temp_pricing_attribs_rec.pricing_attribute69,
p_OLD_PRICING_ATTRIBUTE70 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE70 => l_temp_pricing_attribs_rec.pricing_attribute70,
p_OLD_PRICING_ATTRIBUTE71 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE71 => l_temp_pricing_attribs_rec.pricing_attribute71,
p_OLD_PRICING_ATTRIBUTE72 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE72 => l_temp_pricing_attribs_rec.pricing_attribute72,
p_OLD_PRICING_ATTRIBUTE73 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE73 => l_temp_pricing_attribs_rec.pricing_attribute73,
p_OLD_PRICING_ATTRIBUTE74 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE74 => l_temp_pricing_attribs_rec.pricing_attribute74,
p_OLD_PRICING_ATTRIBUTE75 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE75 => l_temp_pricing_attribs_rec.pricing_attribute75,
p_OLD_PRICING_ATTRIBUTE76 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE76 => l_temp_pricing_attribs_rec.pricing_attribute76,
p_OLD_PRICING_ATTRIBUTE77 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE77 => l_temp_pricing_attribs_rec.pricing_attribute77,
p_OLD_PRICING_ATTRIBUTE78 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE78 => l_temp_pricing_attribs_rec.pricing_attribute78,
p_OLD_PRICING_ATTRIBUTE79 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE79 => l_temp_pricing_attribs_rec.pricing_attribute79,
p_OLD_PRICING_ATTRIBUTE80 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE80 => l_temp_pricing_attribs_rec.pricing_attribute80,
p_OLD_PRICING_ATTRIBUTE81 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE81 => l_temp_pricing_attribs_rec.pricing_attribute81,
p_OLD_PRICING_ATTRIBUTE82 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE82 => l_temp_pricing_attribs_rec.pricing_attribute82,
p_OLD_PRICING_ATTRIBUTE83 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE83 => l_temp_pricing_attribs_rec.pricing_attribute83,
p_OLD_PRICING_ATTRIBUTE84 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE84 => l_temp_pricing_attribs_rec.pricing_attribute84,
p_OLD_PRICING_ATTRIBUTE85 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE85 => l_temp_pricing_attribs_rec.pricing_attribute85,
p_OLD_PRICING_ATTRIBUTE86 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE86 => l_temp_pricing_attribs_rec.pricing_attribute86,
p_OLD_PRICING_ATTRIBUTE87 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE87 => l_temp_pricing_attribs_rec.pricing_attribute87,
p_OLD_PRICING_ATTRIBUTE88 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE88 => l_temp_pricing_attribs_rec.pricing_attribute88,
p_OLD_PRICING_ATTRIBUTE89 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE89 => l_temp_pricing_attribs_rec.pricing_attribute89,
p_OLD_PRICING_ATTRIBUTE90 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE90 => l_temp_pricing_attribs_rec.pricing_attribute90,
p_OLD_PRICING_ATTRIBUTE91 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE91 => l_temp_pricing_attribs_rec.pricing_attribute91,
p_OLD_PRICING_ATTRIBUTE92 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE92 => l_temp_pricing_attribs_rec.pricing_attribute92,
p_OLD_PRICING_ATTRIBUTE93 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE93 => l_temp_pricing_attribs_rec.pricing_attribute93,
p_OLD_PRICING_ATTRIBUTE94 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE94 => l_temp_pricing_attribs_rec.pricing_attribute94,
p_OLD_PRICING_ATTRIBUTE95 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE95 => l_temp_pricing_attribs_rec.pricing_attribute95,
p_OLD_PRICING_ATTRIBUTE96 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE96 => l_temp_pricing_attribs_rec.pricing_attribute96,
p_OLD_PRICING_ATTRIBUTE97 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE97 => l_temp_pricing_attribs_rec.pricing_attribute97,
p_OLD_PRICING_ATTRIBUTE98 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE98 => l_temp_pricing_attribs_rec.pricing_attribute98,
p_OLD_PRICING_ATTRIBUTE99 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE99 => l_temp_pricing_attribs_rec.pricing_attribute99,
p_OLD_PRICING_ATTRIBUTE100 => fnd_api.g_miss_char ,
p_NEW_PRICING_ATTRIBUTE100 => l_temp_pricing_attribs_rec.pricing_attribute100,
p_OLD_ACTIVE_START_DATE => fnd_api.g_miss_date ,
p_NEW_ACTIVE_START_DATE => l_temp_pricing_attribs_rec.active_start_date ,
p_OLD_ACTIVE_END_DATE => fnd_api.g_miss_date ,
p_NEW_ACTIVE_END_DATE => l_temp_pricing_attribs_rec.active_end_date ,
p_OLD_CONTEXT => fnd_api.g_miss_char ,
p_NEW_CONTEXT => l_temp_pricing_attribs_rec.context ,
p_OLD_ATTRIBUTE1 => fnd_api.g_miss_char ,
p_NEW_ATTRIBUTE1 => l_temp_pricing_attribs_rec.ATTRIBUTE1 ,
p_OLD_ATTRIBUTE2 => fnd_api.g_miss_char ,
p_NEW_ATTRIBUTE2 => l_temp_pricing_attribs_rec.ATTRIBUTE2 ,
p_OLD_ATTRIBUTE3 => fnd_api.g_miss_char ,
p_NEW_ATTRIBUTE3 => l_temp_pricing_attribs_rec.ATTRIBUTE3 ,
p_OLD_ATTRIBUTE4 => fnd_api.g_miss_char ,
p_NEW_ATTRIBUTE4 => l_temp_pricing_attribs_rec.ATTRIBUTE4 ,
p_OLD_ATTRIBUTE5 => fnd_api.g_miss_char ,
p_NEW_ATTRIBUTE5 => l_temp_pricing_attribs_rec.ATTRIBUTE5 ,
p_OLD_ATTRIBUTE6 => fnd_api.g_miss_char ,
p_NEW_ATTRIBUTE6 => l_temp_pricing_attribs_rec.ATTRIBUTE6 ,
p_OLD_ATTRIBUTE7 => fnd_api.g_miss_char ,
p_NEW_ATTRIBUTE7 => l_temp_pricing_attribs_rec.ATTRIBUTE7 ,
p_OLD_ATTRIBUTE8 => fnd_api.g_miss_char ,
p_NEW_ATTRIBUTE8 => l_temp_pricing_attribs_rec.ATTRIBUTE8 ,
p_OLD_ATTRIBUTE9 => fnd_api.g_miss_char ,
p_NEW_ATTRIBUTE9 => l_temp_pricing_attribs_rec.ATTRIBUTE9 ,
p_OLD_ATTRIBUTE10 => fnd_api.g_miss_char ,
p_NEW_ATTRIBUTE10 => l_temp_pricing_attribs_rec.ATTRIBUTE10 ,
p_OLD_ATTRIBUTE11 => fnd_api.g_miss_char ,
p_NEW_ATTRIBUTE11 => l_temp_pricing_attribs_rec.ATTRIBUTE11 ,
p_OLD_ATTRIBUTE12 => fnd_api.g_miss_char ,
p_NEW_ATTRIBUTE12 => l_temp_pricing_attribs_rec.ATTRIBUTE12 ,
p_OLD_ATTRIBUTE13 => fnd_api.g_miss_char ,
p_NEW_ATTRIBUTE13 => l_temp_pricing_attribs_rec.ATTRIBUTE13 ,
p_OLD_ATTRIBUTE14 => fnd_api.g_miss_char ,
p_NEW_ATTRIBUTE14 => l_temp_pricing_attribs_rec.ATTRIBUTE14 ,
p_OLD_ATTRIBUTE15 => fnd_api.g_miss_char ,
p_NEW_ATTRIBUTE15 => l_temp_pricing_attribs_rec.ATTRIBUTE15 ,
p_FULL_DUMP_FLAG => fnd_api.g_miss_char ,
p_CREATED_BY => fnd_api.g_miss_num, -- fnd_global.user_id,
p_CREATION_DATE => fnd_api.g_miss_date ,
p_LAST_UPDATED_BY => fnd_global.user_id ,
p_LAST_UPDATE_DATE => sysdate ,
p_LAST_UPDATE_LOGIN => fnd_global.user_id ,
p_OBJECT_VERSION_NUMBER => fnd_api.g_miss_num );
CSI_I_PRICING_ATTRIBS_H_PKG.Update_Row(
p_price_attrib_history_id => l_pricing_hist_id ,
p_pricing_attribute_id => fnd_api.g_miss_num ,
p_transaction_id => fnd_api.g_miss_num ,
p_old_pricing_context => l_pricing_hist_csr.old_pricing_context ,
p_new_pricing_context => l_pricing_hist_csr.new_pricing_context ,
p_old_pricing_attribute1 => l_pricing_hist_csr.old_pricing_attribute1 ,
p_new_pricing_attribute1 => l_pricing_hist_csr.new_pricing_attribute1 ,
p_old_pricing_attribute2 => l_pricing_hist_csr.old_pricing_attribute2 ,
p_new_pricing_attribute2 => l_pricing_hist_csr.new_pricing_attribute2 ,
p_old_pricing_attribute3 => l_pricing_hist_csr.old_pricing_attribute3 ,
p_new_pricing_attribute3 => l_pricing_hist_csr.new_pricing_attribute3 ,
p_old_pricing_attribute4 => l_pricing_hist_csr.old_pricing_attribute4 ,
p_new_pricing_attribute4 => l_pricing_hist_csr.new_pricing_attribute4 ,
p_old_pricing_attribute5 => l_pricing_hist_csr.old_pricing_attribute5 ,
p_new_pricing_attribute5 => l_pricing_hist_csr.new_pricing_attribute5 ,
p_old_pricing_attribute6 => l_pricing_hist_csr.old_pricing_attribute6 ,
p_new_pricing_attribute6 => l_pricing_hist_csr.new_pricing_attribute6 ,
p_old_pricing_attribute7 => l_pricing_hist_csr.old_pricing_attribute7 ,
p_new_pricing_attribute7 => l_pricing_hist_csr.new_pricing_attribute7 ,
p_old_pricing_attribute8 => l_pricing_hist_csr.old_pricing_attribute8 ,
p_new_pricing_attribute8 => l_pricing_hist_csr.new_pricing_attribute8 ,
p_old_pricing_attribute9 => l_pricing_hist_csr.old_pricing_attribute9 ,
p_new_pricing_attribute9 => l_pricing_hist_csr.new_pricing_attribute9 ,
p_old_pricing_attribute10 => l_pricing_hist_csr.old_pricing_attribute10 ,
p_new_pricing_attribute10 => l_pricing_hist_csr.new_pricing_attribute10,
p_old_pricing_attribute11 => l_pricing_hist_csr.old_pricing_attribute11 ,
p_new_pricing_attribute11 => l_pricing_hist_csr.new_pricing_attribute11,
p_old_pricing_attribute12 => l_pricing_hist_csr.old_pricing_attribute12 ,
p_new_pricing_attribute12 => l_pricing_hist_csr.new_pricing_attribute12,
p_old_pricing_attribute13 => l_pricing_hist_csr.old_pricing_attribute13 ,
p_new_pricing_attribute13 => l_pricing_hist_csr.new_pricing_attribute13,
p_old_pricing_attribute14 => l_pricing_hist_csr.old_pricing_attribute14 ,
p_new_pricing_attribute14 => l_pricing_hist_csr.new_pricing_attribute14,
p_old_pricing_attribute15 => l_pricing_hist_csr.old_pricing_attribute15 ,
p_new_pricing_attribute15 => l_pricing_hist_csr.new_pricing_attribute15,
p_old_pricing_attribute16 => l_pricing_hist_csr.old_pricing_attribute16 ,
p_new_pricing_attribute16 => l_pricing_hist_csr.new_pricing_attribute16,
p_old_pricing_attribute17 => l_pricing_hist_csr.old_pricing_attribute17 ,
p_new_pricing_attribute17 => l_pricing_hist_csr.new_pricing_attribute17,
p_old_pricing_attribute18 => l_pricing_hist_csr.old_pricing_attribute18 ,
p_new_pricing_attribute18 => l_pricing_hist_csr.new_pricing_attribute18,
p_old_pricing_attribute19 => l_pricing_hist_csr.old_pricing_attribute19 ,
p_new_pricing_attribute19 => l_pricing_hist_csr.new_pricing_attribute19,
p_old_pricing_attribute20 => l_pricing_hist_csr.old_pricing_attribute20 ,
p_new_pricing_attribute20 => l_pricing_hist_csr.new_pricing_attribute20,
p_old_pricing_attribute21 => l_pricing_hist_csr.old_pricing_attribute21 ,
p_new_pricing_attribute21 => l_pricing_hist_csr.new_pricing_attribute21,
p_old_pricing_attribute22 => l_pricing_hist_csr.old_pricing_attribute22 ,
p_new_pricing_attribute22 => l_pricing_hist_csr.new_pricing_attribute22,
p_old_pricing_attribute23 => l_pricing_hist_csr.old_pricing_attribute23 ,
p_new_pricing_attribute23 => l_pricing_hist_csr.new_pricing_attribute23,
p_old_pricing_attribute24 => l_pricing_hist_csr.old_pricing_attribute24 ,
p_new_pricing_attribute24 => l_pricing_hist_csr.new_pricing_attribute24,
p_new_pricing_attribute25 => l_pricing_hist_csr.old_pricing_attribute25 ,
p_old_pricing_attribute25 => l_pricing_hist_csr.new_pricing_attribute25,
p_old_pricing_attribute26 => l_pricing_hist_csr.old_pricing_attribute26 ,
p_new_pricing_attribute26 => l_pricing_hist_csr.new_pricing_attribute26,
p_old_pricing_attribute27 => l_pricing_hist_csr.old_pricing_attribute27 ,
p_new_pricing_attribute27 => l_pricing_hist_csr.new_pricing_attribute27,
p_old_pricing_attribute28 => l_pricing_hist_csr.old_pricing_attribute28 ,
p_new_pricing_attribute28 => l_pricing_hist_csr.new_pricing_attribute28,
p_old_pricing_attribute29 => l_pricing_hist_csr.old_pricing_attribute29 ,
p_new_pricing_attribute29 => l_pricing_hist_csr.new_pricing_attribute29,
p_old_pricing_attribute30 => l_pricing_hist_csr.old_pricing_attribute30 ,
p_new_pricing_attribute30 => l_pricing_hist_csr.new_pricing_attribute30,
p_old_pricing_attribute31 => l_pricing_hist_csr.old_pricing_attribute31 ,
p_new_pricing_attribute31 => l_pricing_hist_csr.new_pricing_attribute31,
p_old_pricing_attribute32 => l_pricing_hist_csr.old_pricing_attribute32 ,
p_new_pricing_attribute32 => l_pricing_hist_csr.new_pricing_attribute32,
p_old_pricing_attribute33 => l_pricing_hist_csr.old_pricing_attribute33 ,
p_new_pricing_attribute33 => l_pricing_hist_csr.new_pricing_attribute33,
p_old_pricing_attribute34 => l_pricing_hist_csr.old_pricing_attribute34 ,
p_new_pricing_attribute34 => l_pricing_hist_csr.new_pricing_attribute34,
p_old_pricing_attribute35 => l_pricing_hist_csr.old_pricing_attribute35 ,
p_new_pricing_attribute35 => l_pricing_hist_csr.new_pricing_attribute35,
p_old_pricing_attribute36 => l_pricing_hist_csr.old_pricing_attribute36 ,
p_new_pricing_attribute36 => l_pricing_hist_csr.new_pricing_attribute36,
p_old_pricing_attribute37 => l_pricing_hist_csr.old_pricing_attribute37 ,
p_new_pricing_attribute37 => l_pricing_hist_csr.new_pricing_attribute37,
p_old_pricing_attribute38 => l_pricing_hist_csr.old_pricing_attribute38 ,
p_new_pricing_attribute38 => l_pricing_hist_csr.new_pricing_attribute38,
p_old_pricing_attribute39 => l_pricing_hist_csr.old_pricing_attribute39 ,
p_new_pricing_attribute39 => l_pricing_hist_csr.new_pricing_attribute39,
p_old_pricing_attribute40 => l_pricing_hist_csr.old_pricing_attribute40 ,
p_new_pricing_attribute40 => l_pricing_hist_csr.new_pricing_attribute40,
p_old_pricing_attribute41 => l_pricing_hist_csr.old_pricing_attribute41 ,
p_new_pricing_attribute41 => l_pricing_hist_csr.new_pricing_attribute41,
p_old_pricing_attribute42 => l_pricing_hist_csr.old_pricing_attribute42 ,
p_new_pricing_attribute42 => l_pricing_hist_csr.new_pricing_attribute42,
p_old_pricing_attribute43 => l_pricing_hist_csr.old_pricing_attribute43 ,
p_new_pricing_attribute43 => l_pricing_hist_csr.new_pricing_attribute43,
p_old_pricing_attribute44 => l_pricing_hist_csr.old_pricing_attribute44 ,
p_new_pricing_attribute44 => l_pricing_hist_csr.new_pricing_attribute44,
p_old_pricing_attribute45 => l_pricing_hist_csr.old_pricing_attribute45 ,
p_new_pricing_attribute45 => l_pricing_hist_csr.new_pricing_attribute45,
p_old_pricing_attribute46 => l_pricing_hist_csr.old_pricing_attribute46 ,
p_new_pricing_attribute46 => l_pricing_hist_csr.new_pricing_attribute46,
p_old_pricing_attribute47 => l_pricing_hist_csr.old_pricing_attribute47 ,
p_new_pricing_attribute47 => l_pricing_hist_csr.new_pricing_attribute47,
p_old_pricing_attribute48 => l_pricing_hist_csr.old_pricing_attribute48 ,
p_new_pricing_attribute48 => l_pricing_hist_csr.new_pricing_attribute48,
p_old_pricing_attribute49 => l_pricing_hist_csr.old_pricing_attribute49 ,
p_new_pricing_attribute49 => l_pricing_hist_csr.new_pricing_attribute49,
p_old_pricing_attribute50 => l_pricing_hist_csr.old_pricing_attribute50 ,
p_new_pricing_attribute50 => l_pricing_hist_csr.new_pricing_attribute50,
p_old_pricing_attribute51 => l_pricing_hist_csr.old_pricing_attribute51 ,
p_new_pricing_attribute51 => l_pricing_hist_csr.new_pricing_attribute51,
p_old_pricing_attribute52 => l_pricing_hist_csr.old_pricing_attribute52 ,
p_new_pricing_attribute52 => l_pricing_hist_csr.new_pricing_attribute52,
p_old_pricing_attribute53 => l_pricing_hist_csr.old_pricing_attribute53 ,
p_new_pricing_attribute53 => l_pricing_hist_csr.new_pricing_attribute53,
p_old_pricing_attribute54 => l_pricing_hist_csr.old_pricing_attribute54 ,
p_new_pricing_attribute54 => l_pricing_hist_csr.new_pricing_attribute54,
p_old_pricing_attribute55 => l_pricing_hist_csr.old_pricing_attribute55 ,
p_new_pricing_attribute55 => l_pricing_hist_csr.new_pricing_attribute55,
p_old_pricing_attribute56 => l_pricing_hist_csr.old_pricing_attribute56 ,
p_new_pricing_attribute56 => l_pricing_hist_csr.new_pricing_attribute56,
p_old_pricing_attribute57 => l_pricing_hist_csr.old_pricing_attribute57 ,
p_new_pricing_attribute57 => l_pricing_hist_csr.new_pricing_attribute57,
p_old_pricing_attribute58 => l_pricing_hist_csr.old_pricing_attribute58 ,
p_new_pricing_attribute58 => l_pricing_hist_csr.new_pricing_attribute58,
p_old_pricing_attribute59 => l_pricing_hist_csr.old_pricing_attribute59 ,
p_new_pricing_attribute59 => l_pricing_hist_csr.new_pricing_attribute59,
p_old_pricing_attribute60 => l_pricing_hist_csr.old_pricing_attribute60 ,
p_new_pricing_attribute60 => l_pricing_hist_csr.new_pricing_attribute60,
p_old_pricing_attribute61 => l_pricing_hist_csr.old_pricing_attribute61 ,
p_new_pricing_attribute61 => l_pricing_hist_csr.new_pricing_attribute61,
p_old_pricing_attribute62 => l_pricing_hist_csr.old_pricing_attribute62 ,
p_new_pricing_attribute62 => l_pricing_hist_csr.new_pricing_attribute62,
p_old_pricing_attribute63 => l_pricing_hist_csr.old_pricing_attribute63 ,
p_new_pricing_attribute63 => l_pricing_hist_csr.new_pricing_attribute63,
p_old_pricing_attribute64 => l_pricing_hist_csr.old_pricing_attribute64 ,
p_new_pricing_attribute64 => l_pricing_hist_csr.new_pricing_attribute64,
p_old_pricing_attribute65 => l_pricing_hist_csr.old_pricing_attribute65 ,
p_new_pricing_attribute65 => l_pricing_hist_csr.new_pricing_attribute65,
p_old_pricing_attribute66 => l_pricing_hist_csr.old_pricing_attribute66 ,
p_new_pricing_attribute66 => l_pricing_hist_csr.new_pricing_attribute66,
p_old_pricing_attribute67 => l_pricing_hist_csr.old_pricing_attribute67 ,
p_new_pricing_attribute67 => l_pricing_hist_csr.new_pricing_attribute67,
p_old_pricing_attribute68 => l_pricing_hist_csr.old_pricing_attribute68 ,
p_new_pricing_attribute68 => l_pricing_hist_csr.new_pricing_attribute68,
p_old_pricing_attribute69 => l_pricing_hist_csr.old_pricing_attribute69 ,
p_new_pricing_attribute69 => l_pricing_hist_csr.new_pricing_attribute69,
p_old_pricing_attribute70 => l_pricing_hist_csr.old_pricing_attribute70 ,
p_new_pricing_attribute70 => l_pricing_hist_csr.new_pricing_attribute70,
p_old_pricing_attribute71 => l_pricing_hist_csr.old_pricing_attribute71 ,
p_new_pricing_attribute71 => l_pricing_hist_csr.new_pricing_attribute71,
p_old_pricing_attribute72 => l_pricing_hist_csr.old_pricing_attribute72 ,
p_new_pricing_attribute72 => l_pricing_hist_csr.new_pricing_attribute72,
p_old_pricing_attribute73 => l_pricing_hist_csr.old_pricing_attribute73 ,
p_new_pricing_attribute73 => l_pricing_hist_csr.new_pricing_attribute73,
p_old_pricing_attribute74 => l_pricing_hist_csr.old_pricing_attribute74 ,
p_new_pricing_attribute74 => l_pricing_hist_csr.new_pricing_attribute74,
p_old_pricing_attribute75 => l_pricing_hist_csr.old_pricing_attribute75 ,
p_new_pricing_attribute75 => l_pricing_hist_csr.new_pricing_attribute75,
p_old_pricing_attribute76 => l_pricing_hist_csr.old_pricing_attribute76 ,
p_new_pricing_attribute76 => l_pricing_hist_csr.new_pricing_attribute76,
p_old_pricing_attribute77 => l_pricing_hist_csr.old_pricing_attribute77 ,
p_new_pricing_attribute77 => l_pricing_hist_csr.new_pricing_attribute77,
p_old_pricing_attribute78 => l_pricing_hist_csr.old_pricing_attribute78 ,
p_new_pricing_attribute78 => l_pricing_hist_csr.new_pricing_attribute78,
p_old_pricing_attribute79 => l_pricing_hist_csr.old_pricing_attribute79 ,
p_new_pricing_attribute79 => l_pricing_hist_csr.new_pricing_attribute79,
p_old_pricing_attribute80 => l_pricing_hist_csr.old_pricing_attribute80 ,
p_new_pricing_attribute80 => l_pricing_hist_csr.new_pricing_attribute80,
p_old_pricing_attribute81 => l_pricing_hist_csr.old_pricing_attribute81 ,
p_new_pricing_attribute81 => l_pricing_hist_csr.new_pricing_attribute81,
p_old_pricing_attribute82 => l_pricing_hist_csr.old_pricing_attribute82 ,
p_new_pricing_attribute82 => l_pricing_hist_csr.new_pricing_attribute82,
p_old_pricing_attribute83 => l_pricing_hist_csr.old_pricing_attribute83 ,
p_new_pricing_attribute83 => l_pricing_hist_csr.new_pricing_attribute83,
p_old_pricing_attribute84 => l_pricing_hist_csr.old_pricing_attribute84 ,
p_new_pricing_attribute84 => l_pricing_hist_csr.new_pricing_attribute84,
p_old_pricing_attribute85 => l_pricing_hist_csr.old_pricing_attribute85 ,
p_new_pricing_attribute85 => l_pricing_hist_csr.new_pricing_attribute85,
p_old_pricing_attribute86 => l_pricing_hist_csr.old_pricing_attribute86 ,
p_new_pricing_attribute86 => l_pricing_hist_csr.new_pricing_attribute86,
p_old_pricing_attribute87 => l_pricing_hist_csr.old_pricing_attribute87 ,
p_new_pricing_attribute87 => l_pricing_hist_csr.new_pricing_attribute87,
p_old_pricing_attribute88 => l_pricing_hist_csr.old_pricing_attribute88 ,
p_new_pricing_attribute88 => l_pricing_hist_csr.new_pricing_attribute88,
p_old_pricing_attribute89 => l_pricing_hist_csr.old_pricing_attribute89 ,
p_new_pricing_attribute89 => l_pricing_hist_csr.new_pricing_attribute89,
p_old_pricing_attribute90 => l_pricing_hist_csr.old_pricing_attribute90 ,
p_new_pricing_attribute90 => l_pricing_hist_csr.new_pricing_attribute90,
p_old_pricing_attribute91 => l_pricing_hist_csr.old_pricing_attribute91 ,
p_new_pricing_attribute91 => l_pricing_hist_csr.new_pricing_attribute91,
p_old_pricing_attribute92 => l_pricing_hist_csr.old_pricing_attribute92 ,
p_new_pricing_attribute92 => l_pricing_hist_csr.new_pricing_attribute92,
p_old_pricing_attribute93 => l_pricing_hist_csr.old_pricing_attribute93 ,
p_new_pricing_attribute93 => l_pricing_hist_csr.new_pricing_attribute93,
p_old_pricing_attribute94 => l_pricing_hist_csr.old_pricing_attribute94 ,
p_new_pricing_attribute94 => l_pricing_hist_csr.new_pricing_attribute94,
p_old_pricing_attribute95 => l_pricing_hist_csr.old_pricing_attribute95 ,
p_new_pricing_attribute95 => l_pricing_hist_csr.new_pricing_attribute95,
p_old_pricing_attribute96 => l_pricing_hist_csr.old_pricing_attribute96 ,
p_new_pricing_attribute96 => l_pricing_hist_csr.new_pricing_attribute96,
p_old_pricing_attribute97 => l_pricing_hist_csr.old_pricing_attribute97 ,
p_new_pricing_attribute97 => l_pricing_hist_csr.new_pricing_attribute97,
p_old_pricing_attribute98 => l_pricing_hist_csr.old_pricing_attribute98 ,
p_new_pricing_attribute98 => l_pricing_hist_csr.new_pricing_attribute98,
p_old_pricing_attribute99 => l_pricing_hist_csr.old_pricing_attribute99 ,
p_new_pricing_attribute99 => l_pricing_hist_csr.new_pricing_attribute99,
p_old_pricing_attribute100 => l_pricing_hist_csr.old_pricing_attribute100 ,
p_new_pricing_attribute100 => l_pricing_hist_csr.new_pricing_attribute100,
p_old_active_start_date => l_pricing_hist_csr.old_active_start_date ,
p_new_active_start_date => l_pricing_hist_csr.new_active_start_date ,
p_old_active_end_date => l_pricing_hist_csr.old_active_end_date ,
p_new_active_end_date => l_pricing_hist_csr.new_active_end_date ,
p_old_context => l_pricing_hist_csr.old_context ,
p_new_context => l_pricing_hist_csr.new_context ,
p_old_attribute1 => l_pricing_hist_csr.old_attribute1 ,
p_new_attribute1 => l_pricing_hist_csr.new_attribute1 ,
p_old_attribute2 => l_pricing_hist_csr.old_attribute2 ,
p_new_attribute2 => l_pricing_hist_csr.new_attribute2 ,
p_old_attribute3 => l_pricing_hist_csr.old_attribute3 ,
p_new_attribute3 => l_pricing_hist_csr.new_attribute3 ,
p_old_attribute4 => l_pricing_hist_csr.old_attribute4 ,
p_new_attribute4 => l_pricing_hist_csr.new_attribute4 ,
p_old_attribute5 => l_pricing_hist_csr.old_attribute5 ,
p_new_attribute5 => l_pricing_hist_csr.new_attribute5 ,
p_old_attribute6 => l_pricing_hist_csr.old_attribute6 ,
p_new_attribute6 => l_pricing_hist_csr.new_attribute6 ,
p_old_attribute7 => l_pricing_hist_csr.old_attribute7 ,
p_new_attribute7 => l_pricing_hist_csr.new_attribute7 ,
p_old_attribute8 => l_pricing_hist_csr.old_attribute8 ,
p_new_attribute8 => l_pricing_hist_csr.new_attribute8 ,
p_old_attribute9 => l_pricing_hist_csr.old_attribute9 ,
p_new_attribute9 => l_pricing_hist_csr.new_attribute9 ,
p_old_attribute10 => l_pricing_hist_csr.old_attribute10 ,
p_new_attribute10 => l_pricing_hist_csr.new_attribute10 ,
p_old_attribute11 => l_pricing_hist_csr.old_attribute11 ,
p_new_attribute11 => l_pricing_hist_csr.new_attribute11 ,
p_old_attribute12 => l_pricing_hist_csr.old_attribute12 ,
p_new_attribute12 => l_pricing_hist_csr.new_attribute12 ,
p_old_attribute13 => l_pricing_hist_csr.old_attribute13 ,
p_new_attribute13 => l_pricing_hist_csr.new_attribute13 ,
p_old_attribute14 => l_pricing_hist_csr.old_attribute14 ,
p_new_attribute14 => l_pricing_hist_csr.new_attribute14 ,
p_old_attribute15 => l_pricing_hist_csr.old_attribute15 ,
p_new_attribute15 => l_pricing_hist_csr.new_attribute15 ,
p_full_dump_flag => fnd_api.g_miss_char ,
p_created_by => fnd_api.g_miss_num, -- fnd_global.user_id,
p_creation_date => fnd_api.g_miss_date ,
p_last_updated_by => fnd_global.user_id ,
p_last_update_date => sysdate ,
p_last_update_login => fnd_global.user_id ,
p_object_version_number => fnd_api.g_miss_num );
CSI_I_PRICING_ATTRIBS_H_PKG.Insert_Row(
px_PRICE_ATTRIB_HISTORY_ID => l_pricing_attrib_h_id,
p_PRICING_ATTRIBUTE_ID => l_pricing_attrib_id,
p_TRANSACTION_ID => p_txn_rec.transaction_id,
p_OLD_PRICING_CONTEXT => l_pricing_attribs_rec.pricing_context,
p_NEW_PRICING_CONTEXT => l_temp_pricing_attribs_rec.pricing_context,
p_OLD_PRICING_ATTRIBUTE1 => l_pricing_attribs_rec.pricing_attribute1,
p_NEW_PRICING_ATTRIBUTE1 => l_temp_pricing_attribs_rec.pricing_attribute1,
p_OLD_PRICING_ATTRIBUTE2 => l_pricing_attribs_rec.pricing_attribute2,
p_NEW_PRICING_ATTRIBUTE2 => l_temp_pricing_attribs_rec.pricing_attribute2,
p_OLD_PRICING_ATTRIBUTE3 => l_pricing_attribs_rec.pricing_attribute3,
p_NEW_PRICING_ATTRIBUTE3 => l_temp_pricing_attribs_rec.pricing_attribute3,
p_OLD_PRICING_ATTRIBUTE4 => l_pricing_attribs_rec.pricing_attribute4,
p_NEW_PRICING_ATTRIBUTE4 => l_temp_pricing_attribs_rec.pricing_attribute4,
p_OLD_PRICING_ATTRIBUTE5 => l_pricing_attribs_rec.pricing_attribute5,
p_NEW_PRICING_ATTRIBUTE5 => l_temp_pricing_attribs_rec.pricing_attribute5,
p_OLD_PRICING_ATTRIBUTE6 => l_pricing_attribs_rec.pricing_attribute6,
p_NEW_PRICING_ATTRIBUTE6 => l_temp_pricing_attribs_rec.pricing_attribute6,
p_OLD_PRICING_ATTRIBUTE7 => l_pricing_attribs_rec.pricing_attribute7,
p_NEW_PRICING_ATTRIBUTE7 => l_temp_pricing_attribs_rec.pricing_attribute7,
p_OLD_PRICING_ATTRIBUTE8 => l_pricing_attribs_rec.pricing_attribute8,
p_NEW_PRICING_ATTRIBUTE8 => l_temp_pricing_attribs_rec.pricing_attribute8,
p_OLD_PRICING_ATTRIBUTE9 => l_pricing_attribs_rec.pricing_attribute9,
p_NEW_PRICING_ATTRIBUTE9 => l_temp_pricing_attribs_rec.pricing_attribute9,
p_OLD_PRICING_ATTRIBUTE10 => l_pricing_attribs_rec.pricing_attribute10,
p_NEW_PRICING_ATTRIBUTE10 => l_temp_pricing_attribs_rec.pricing_attribute10,
p_OLD_PRICING_ATTRIBUTE11 => l_pricing_attribs_rec.pricing_attribute11,
p_NEW_PRICING_ATTRIBUTE11 => l_temp_pricing_attribs_rec.pricing_attribute11,
p_OLD_PRICING_ATTRIBUTE12 => l_pricing_attribs_rec.pricing_attribute12,
p_NEW_PRICING_ATTRIBUTE12 => l_temp_pricing_attribs_rec.pricing_attribute12,
p_OLD_PRICING_ATTRIBUTE13 => l_pricing_attribs_rec.pricing_attribute13,
p_NEW_PRICING_ATTRIBUTE13 => l_temp_pricing_attribs_rec.pricing_attribute13,
p_OLD_PRICING_ATTRIBUTE14 => l_pricing_attribs_rec.pricing_attribute14,
p_NEW_PRICING_ATTRIBUTE14 => l_temp_pricing_attribs_rec.pricing_attribute14,
p_OLD_PRICING_ATTRIBUTE15 => l_pricing_attribs_rec.pricing_attribute15,
p_NEW_PRICING_ATTRIBUTE15 => l_temp_pricing_attribs_rec.pricing_attribute15,
p_OLD_PRICING_ATTRIBUTE16 => l_pricing_attribs_rec.pricing_attribute16,
p_NEW_PRICING_ATTRIBUTE16 => l_temp_pricing_attribs_rec.pricing_attribute16,
p_OLD_PRICING_ATTRIBUTE17 => l_pricing_attribs_rec.pricing_attribute17,
p_NEW_PRICING_ATTRIBUTE17 => l_temp_pricing_attribs_rec.pricing_attribute17,
p_OLD_PRICING_ATTRIBUTE18 => l_pricing_attribs_rec.pricing_attribute18,
p_NEW_PRICING_ATTRIBUTE18 => l_temp_pricing_attribs_rec.pricing_attribute18,
p_OLD_PRICING_ATTRIBUTE19 => l_pricing_attribs_rec.pricing_attribute19,
p_NEW_PRICING_ATTRIBUTE19 => l_temp_pricing_attribs_rec.pricing_attribute19,
p_OLD_PRICING_ATTRIBUTE20 => l_pricing_attribs_rec.pricing_attribute20,
p_NEW_PRICING_ATTRIBUTE20 => l_temp_pricing_attribs_rec.pricing_attribute20,
p_OLD_PRICING_ATTRIBUTE21 => l_pricing_attribs_rec.pricing_attribute21,
p_NEW_PRICING_ATTRIBUTE21 => l_temp_pricing_attribs_rec.pricing_attribute21,
p_OLD_PRICING_ATTRIBUTE22 => l_pricing_attribs_rec.pricing_attribute22,
p_NEW_PRICING_ATTRIBUTE22 => l_temp_pricing_attribs_rec.pricing_attribute22,
p_OLD_PRICING_ATTRIBUTE23 => l_pricing_attribs_rec.pricing_attribute23,
p_NEW_PRICING_ATTRIBUTE23 => l_temp_pricing_attribs_rec.pricing_attribute23,
p_OLD_PRICING_ATTRIBUTE24 => l_pricing_attribs_rec.pricing_attribute24,
p_NEW_PRICING_ATTRIBUTE24 => l_temp_pricing_attribs_rec.pricing_attribute24,
p_NEW_PRICING_ATTRIBUTE25 => l_pricing_attribs_rec.pricing_attribute25,
p_OLD_PRICING_ATTRIBUTE25 => l_temp_pricing_attribs_rec.pricing_attribute25,
p_OLD_PRICING_ATTRIBUTE26 => l_pricing_attribs_rec.pricing_attribute26,
p_NEW_PRICING_ATTRIBUTE26 => l_temp_pricing_attribs_rec.pricing_attribute26,
p_OLD_PRICING_ATTRIBUTE27 => l_pricing_attribs_rec.pricing_attribute27,
p_NEW_PRICING_ATTRIBUTE27 => l_temp_pricing_attribs_rec.pricing_attribute27,
p_OLD_PRICING_ATTRIBUTE28 => l_pricing_attribs_rec.pricing_attribute28,
p_NEW_PRICING_ATTRIBUTE28 => l_temp_pricing_attribs_rec.pricing_attribute28,
p_OLD_PRICING_ATTRIBUTE29 => l_pricing_attribs_rec.pricing_attribute29,
p_NEW_PRICING_ATTRIBUTE29 => l_temp_pricing_attribs_rec.pricing_attribute29,
p_OLD_PRICING_ATTRIBUTE30 => l_pricing_attribs_rec.pricing_attribute30,
p_NEW_PRICING_ATTRIBUTE30 => l_temp_pricing_attribs_rec.pricing_attribute30,
p_OLD_PRICING_ATTRIBUTE31 => l_pricing_attribs_rec.pricing_attribute31,
p_NEW_PRICING_ATTRIBUTE31 => l_temp_pricing_attribs_rec.pricing_attribute31,
p_OLD_PRICING_ATTRIBUTE32 => l_pricing_attribs_rec.pricing_attribute32,
p_NEW_PRICING_ATTRIBUTE32 => l_temp_pricing_attribs_rec.pricing_attribute32,
p_OLD_PRICING_ATTRIBUTE33 => l_pricing_attribs_rec.pricing_attribute33,
p_NEW_PRICING_ATTRIBUTE33 => l_temp_pricing_attribs_rec.pricing_attribute33,
p_OLD_PRICING_ATTRIBUTE34 => l_pricing_attribs_rec.pricing_attribute34,
p_NEW_PRICING_ATTRIBUTE34 => l_temp_pricing_attribs_rec.pricing_attribute34,
p_OLD_PRICING_ATTRIBUTE35 => l_pricing_attribs_rec.pricing_attribute35,
p_NEW_PRICING_ATTRIBUTE35 => l_temp_pricing_attribs_rec.pricing_attribute35,
p_OLD_PRICING_ATTRIBUTE36 => l_pricing_attribs_rec.pricing_attribute36,
p_NEW_PRICING_ATTRIBUTE36 => l_temp_pricing_attribs_rec.pricing_attribute36,
p_OLD_PRICING_ATTRIBUTE37 => l_pricing_attribs_rec.pricing_attribute37,
p_NEW_PRICING_ATTRIBUTE37 => l_temp_pricing_attribs_rec.pricing_attribute37,
p_OLD_PRICING_ATTRIBUTE38 => l_pricing_attribs_rec.pricing_attribute38,
p_NEW_PRICING_ATTRIBUTE38 => l_temp_pricing_attribs_rec.pricing_attribute38,
p_OLD_PRICING_ATTRIBUTE39 => l_pricing_attribs_rec.pricing_attribute39,
p_NEW_PRICING_ATTRIBUTE39 => l_temp_pricing_attribs_rec.pricing_attribute39,
p_OLD_PRICING_ATTRIBUTE40 => l_pricing_attribs_rec.pricing_attribute40,
p_NEW_PRICING_ATTRIBUTE40 => l_temp_pricing_attribs_rec.pricing_attribute40,
p_OLD_PRICING_ATTRIBUTE41 => l_pricing_attribs_rec.pricing_attribute41,
p_NEW_PRICING_ATTRIBUTE41 => l_temp_pricing_attribs_rec.pricing_attribute41,
p_OLD_PRICING_ATTRIBUTE42 => l_pricing_attribs_rec.pricing_attribute42,
p_NEW_PRICING_ATTRIBUTE42 => l_temp_pricing_attribs_rec.pricing_attribute42,
p_OLD_PRICING_ATTRIBUTE43 => l_pricing_attribs_rec.pricing_attribute43,
p_NEW_PRICING_ATTRIBUTE43 => l_temp_pricing_attribs_rec.pricing_attribute43,
p_OLD_PRICING_ATTRIBUTE44 => l_pricing_attribs_rec.pricing_attribute44,
p_NEW_PRICING_ATTRIBUTE44 => l_temp_pricing_attribs_rec.pricing_attribute44,
p_OLD_PRICING_ATTRIBUTE45 => l_pricing_attribs_rec.pricing_attribute45,
p_NEW_PRICING_ATTRIBUTE45 => l_temp_pricing_attribs_rec.pricing_attribute45,
p_OLD_PRICING_ATTRIBUTE46 => l_pricing_attribs_rec.pricing_attribute46,
p_NEW_PRICING_ATTRIBUTE46 => l_temp_pricing_attribs_rec.pricing_attribute46,
p_OLD_PRICING_ATTRIBUTE47 => l_pricing_attribs_rec.pricing_attribute47,
p_NEW_PRICING_ATTRIBUTE47 => l_temp_pricing_attribs_rec.pricing_attribute47,
p_OLD_PRICING_ATTRIBUTE48 => l_pricing_attribs_rec.pricing_attribute48,
p_NEW_PRICING_ATTRIBUTE48 => l_temp_pricing_attribs_rec.pricing_attribute48,
p_OLD_PRICING_ATTRIBUTE49 => l_pricing_attribs_rec.pricing_attribute49,
p_NEW_PRICING_ATTRIBUTE49 => l_temp_pricing_attribs_rec.pricing_attribute49,
p_OLD_PRICING_ATTRIBUTE50 => l_pricing_attribs_rec.pricing_attribute50,
p_NEW_PRICING_ATTRIBUTE50 => l_temp_pricing_attribs_rec.pricing_attribute50,
p_OLD_PRICING_ATTRIBUTE51 => l_pricing_attribs_rec.pricing_attribute51,
p_NEW_PRICING_ATTRIBUTE51 => l_temp_pricing_attribs_rec.pricing_attribute51,
p_OLD_PRICING_ATTRIBUTE52 => l_pricing_attribs_rec.pricing_attribute52,
p_NEW_PRICING_ATTRIBUTE52 => l_temp_pricing_attribs_rec.pricing_attribute52,
p_OLD_PRICING_ATTRIBUTE53 => l_pricing_attribs_rec.pricing_attribute53,
p_NEW_PRICING_ATTRIBUTE53 => l_temp_pricing_attribs_rec.pricing_attribute53,
p_OLD_PRICING_ATTRIBUTE54 => l_pricing_attribs_rec.pricing_attribute54,
p_NEW_PRICING_ATTRIBUTE54 => l_temp_pricing_attribs_rec.pricing_attribute54,
p_OLD_PRICING_ATTRIBUTE55 => l_pricing_attribs_rec.pricing_attribute55,
p_NEW_PRICING_ATTRIBUTE55 => l_temp_pricing_attribs_rec.pricing_attribute55,
p_OLD_PRICING_ATTRIBUTE56 => l_pricing_attribs_rec.pricing_attribute56,
p_NEW_PRICING_ATTRIBUTE56 => l_temp_pricing_attribs_rec.pricing_attribute56,
p_OLD_PRICING_ATTRIBUTE57 => l_pricing_attribs_rec.pricing_attribute57,
p_NEW_PRICING_ATTRIBUTE57 => l_temp_pricing_attribs_rec.pricing_attribute57,
p_OLD_PRICING_ATTRIBUTE58 => l_pricing_attribs_rec.pricing_attribute58,
p_NEW_PRICING_ATTRIBUTE58 => l_temp_pricing_attribs_rec.pricing_attribute58,
p_OLD_PRICING_ATTRIBUTE59 => l_pricing_attribs_rec.pricing_attribute59,
p_NEW_PRICING_ATTRIBUTE59 => l_temp_pricing_attribs_rec.pricing_attribute59,
p_OLD_PRICING_ATTRIBUTE60 => l_pricing_attribs_rec.pricing_attribute60,
p_NEW_PRICING_ATTRIBUTE60 => l_temp_pricing_attribs_rec.pricing_attribute60,
p_OLD_PRICING_ATTRIBUTE61 => l_pricing_attribs_rec.pricing_attribute61,
p_NEW_PRICING_ATTRIBUTE61 => l_temp_pricing_attribs_rec.pricing_attribute61,
p_OLD_PRICING_ATTRIBUTE62 => l_pricing_attribs_rec.pricing_attribute62,
p_NEW_PRICING_ATTRIBUTE62 => l_temp_pricing_attribs_rec.pricing_attribute62,
p_OLD_PRICING_ATTRIBUTE63 => l_pricing_attribs_rec.pricing_attribute63,
p_NEW_PRICING_ATTRIBUTE63 => l_temp_pricing_attribs_rec.pricing_attribute63,
p_OLD_PRICING_ATTRIBUTE64 => l_pricing_attribs_rec.pricing_attribute64,
p_NEW_PRICING_ATTRIBUTE64 => l_temp_pricing_attribs_rec.pricing_attribute64,
p_OLD_PRICING_ATTRIBUTE65 => l_pricing_attribs_rec.pricing_attribute65,
p_NEW_PRICING_ATTRIBUTE65 => l_temp_pricing_attribs_rec.pricing_attribute65,
p_OLD_PRICING_ATTRIBUTE66 => l_pricing_attribs_rec.pricing_attribute66,
p_NEW_PRICING_ATTRIBUTE66 => l_temp_pricing_attribs_rec.pricing_attribute66,
p_OLD_PRICING_ATTRIBUTE67 => l_pricing_attribs_rec.pricing_attribute67,
p_NEW_PRICING_ATTRIBUTE67 => l_temp_pricing_attribs_rec.pricing_attribute67,
p_OLD_PRICING_ATTRIBUTE68 => l_pricing_attribs_rec.pricing_attribute68,
p_NEW_PRICING_ATTRIBUTE68 => l_temp_pricing_attribs_rec.pricing_attribute68,
p_OLD_PRICING_ATTRIBUTE69 => l_pricing_attribs_rec.pricing_attribute69,
p_NEW_PRICING_ATTRIBUTE69 => l_temp_pricing_attribs_rec.pricing_attribute69,
p_OLD_PRICING_ATTRIBUTE70 => l_pricing_attribs_rec.pricing_attribute70,
p_NEW_PRICING_ATTRIBUTE70 => l_temp_pricing_attribs_rec.pricing_attribute70,
p_OLD_PRICING_ATTRIBUTE71 => l_pricing_attribs_rec.pricing_attribute71,
p_NEW_PRICING_ATTRIBUTE71 => l_temp_pricing_attribs_rec.pricing_attribute71,
p_OLD_PRICING_ATTRIBUTE72 => l_pricing_attribs_rec.pricing_attribute72,
p_NEW_PRICING_ATTRIBUTE72 => l_temp_pricing_attribs_rec.pricing_attribute72,
p_OLD_PRICING_ATTRIBUTE73 => l_pricing_attribs_rec.pricing_attribute73,
p_NEW_PRICING_ATTRIBUTE73 => l_temp_pricing_attribs_rec.pricing_attribute73,
p_OLD_PRICING_ATTRIBUTE74 => l_pricing_attribs_rec.pricing_attribute74,
p_NEW_PRICING_ATTRIBUTE74 => l_temp_pricing_attribs_rec.pricing_attribute74,
p_OLD_PRICING_ATTRIBUTE75 => l_pricing_attribs_rec.pricing_attribute75,
p_NEW_PRICING_ATTRIBUTE75 => l_temp_pricing_attribs_rec.pricing_attribute75,
p_OLD_PRICING_ATTRIBUTE76 => l_pricing_attribs_rec.pricing_attribute76,
p_NEW_PRICING_ATTRIBUTE76 => l_temp_pricing_attribs_rec.pricing_attribute76,
p_OLD_PRICING_ATTRIBUTE77 => l_pricing_attribs_rec.pricing_attribute77,
p_NEW_PRICING_ATTRIBUTE77 => l_temp_pricing_attribs_rec.pricing_attribute77,
p_OLD_PRICING_ATTRIBUTE78 => l_pricing_attribs_rec.pricing_attribute78,
p_NEW_PRICING_ATTRIBUTE78 => l_temp_pricing_attribs_rec.pricing_attribute78,
p_OLD_PRICING_ATTRIBUTE79 => l_pricing_attribs_rec.pricing_attribute79,
p_NEW_PRICING_ATTRIBUTE79 => l_temp_pricing_attribs_rec.pricing_attribute79,
p_OLD_PRICING_ATTRIBUTE80 => l_pricing_attribs_rec.pricing_attribute80,
p_NEW_PRICING_ATTRIBUTE80 => l_temp_pricing_attribs_rec.pricing_attribute80,
p_OLD_PRICING_ATTRIBUTE81 => l_pricing_attribs_rec.pricing_attribute81,
p_NEW_PRICING_ATTRIBUTE81 => l_temp_pricing_attribs_rec.pricing_attribute81,
p_OLD_PRICING_ATTRIBUTE82 => l_pricing_attribs_rec.pricing_attribute82,
p_NEW_PRICING_ATTRIBUTE82 => l_temp_pricing_attribs_rec.pricing_attribute82,
p_OLD_PRICING_ATTRIBUTE83 => l_pricing_attribs_rec.pricing_attribute83,
p_NEW_PRICING_ATTRIBUTE83 => l_temp_pricing_attribs_rec.pricing_attribute83,
p_OLD_PRICING_ATTRIBUTE84 => l_pricing_attribs_rec.pricing_attribute84,
p_NEW_PRICING_ATTRIBUTE84 => l_temp_pricing_attribs_rec.pricing_attribute84,
p_OLD_PRICING_ATTRIBUTE85 => l_pricing_attribs_rec.pricing_attribute85,
p_NEW_PRICING_ATTRIBUTE85 => l_temp_pricing_attribs_rec.pricing_attribute85,
p_OLD_PRICING_ATTRIBUTE86 => l_pricing_attribs_rec.pricing_attribute86,
p_NEW_PRICING_ATTRIBUTE86 => l_temp_pricing_attribs_rec.pricing_attribute86,
p_OLD_PRICING_ATTRIBUTE87 => l_pricing_attribs_rec.pricing_attribute87,
p_NEW_PRICING_ATTRIBUTE87 => l_temp_pricing_attribs_rec.pricing_attribute87,
p_OLD_PRICING_ATTRIBUTE88 => l_pricing_attribs_rec.pricing_attribute88,
p_NEW_PRICING_ATTRIBUTE88 => l_temp_pricing_attribs_rec.pricing_attribute88,
p_OLD_PRICING_ATTRIBUTE89 => l_pricing_attribs_rec.pricing_attribute89,
p_NEW_PRICING_ATTRIBUTE89 => l_temp_pricing_attribs_rec.pricing_attribute89,
p_OLD_PRICING_ATTRIBUTE90 => l_pricing_attribs_rec.pricing_attribute90,
p_NEW_PRICING_ATTRIBUTE90 => l_temp_pricing_attribs_rec.pricing_attribute90,
p_OLD_PRICING_ATTRIBUTE91 => l_pricing_attribs_rec.pricing_attribute91,
p_NEW_PRICING_ATTRIBUTE91 => l_temp_pricing_attribs_rec.pricing_attribute91,
p_OLD_PRICING_ATTRIBUTE92 => l_pricing_attribs_rec.pricing_attribute92,
p_NEW_PRICING_ATTRIBUTE92 => l_temp_pricing_attribs_rec.pricing_attribute92,
p_OLD_PRICING_ATTRIBUTE93 => l_pricing_attribs_rec.pricing_attribute93,
p_NEW_PRICING_ATTRIBUTE93 => l_temp_pricing_attribs_rec.pricing_attribute93,
p_OLD_PRICING_ATTRIBUTE94 => l_pricing_attribs_rec.pricing_attribute94,
p_NEW_PRICING_ATTRIBUTE94 => l_temp_pricing_attribs_rec.pricing_attribute94,
p_OLD_PRICING_ATTRIBUTE95 => l_pricing_attribs_rec.pricing_attribute95,
p_NEW_PRICING_ATTRIBUTE95 => l_temp_pricing_attribs_rec.pricing_attribute95,
p_OLD_PRICING_ATTRIBUTE96 => l_pricing_attribs_rec.pricing_attribute96,
p_NEW_PRICING_ATTRIBUTE96 => l_temp_pricing_attribs_rec.pricing_attribute96,
p_OLD_PRICING_ATTRIBUTE97 => l_pricing_attribs_rec.pricing_attribute97,
p_NEW_PRICING_ATTRIBUTE97 => l_temp_pricing_attribs_rec.pricing_attribute97,
p_OLD_PRICING_ATTRIBUTE98 => l_pricing_attribs_rec.pricing_attribute98,
p_NEW_PRICING_ATTRIBUTE98 => l_temp_pricing_attribs_rec.pricing_attribute98,
p_OLD_PRICING_ATTRIBUTE99 => l_pricing_attribs_rec.pricing_attribute99,
p_NEW_PRICING_ATTRIBUTE99 => l_temp_pricing_attribs_rec.pricing_attribute99,
p_OLD_PRICING_ATTRIBUTE100 => l_pricing_attribs_rec.pricing_attribute100,
p_NEW_PRICING_ATTRIBUTE100 => l_temp_pricing_attribs_rec.pricing_attribute100,
p_OLD_ACTIVE_START_DATE => l_pricing_attribs_rec.active_start_date,
p_NEW_ACTIVE_START_DATE => l_temp_pricing_attribs_rec.active_start_date,
p_OLD_ACTIVE_END_DATE => l_pricing_attribs_rec.active_end_date,
p_NEW_ACTIVE_END_DATE => l_temp_pricing_attribs_rec.active_end_date,
p_OLD_CONTEXT => l_pricing_attribs_rec.context ,
p_NEW_CONTEXT => l_temp_pricing_attribs_rec.context ,
p_OLD_ATTRIBUTE1 => l_pricing_attribs_rec.ATTRIBUTE1 ,
p_NEW_ATTRIBUTE1 => l_temp_pricing_attribs_rec.ATTRIBUTE1 ,
p_OLD_ATTRIBUTE2 => l_pricing_attribs_rec.ATTRIBUTE2 ,
p_NEW_ATTRIBUTE2 => l_temp_pricing_attribs_rec.ATTRIBUTE2 ,
p_OLD_ATTRIBUTE3 => l_pricing_attribs_rec.ATTRIBUTE3 ,
p_NEW_ATTRIBUTE3 => l_temp_pricing_attribs_rec.ATTRIBUTE3 ,
p_OLD_ATTRIBUTE4 => l_pricing_attribs_rec.ATTRIBUTE4 ,
p_NEW_ATTRIBUTE4 => l_temp_pricing_attribs_rec.ATTRIBUTE4 ,
p_OLD_ATTRIBUTE5 => l_pricing_attribs_rec.ATTRIBUTE5 ,
p_NEW_ATTRIBUTE5 => l_temp_pricing_attribs_rec.ATTRIBUTE5 ,
p_OLD_ATTRIBUTE6 => l_pricing_attribs_rec.ATTRIBUTE6 ,
p_NEW_ATTRIBUTE6 => l_temp_pricing_attribs_rec.ATTRIBUTE6 ,
p_OLD_ATTRIBUTE7 => l_pricing_attribs_rec.ATTRIBUTE7 ,
p_NEW_ATTRIBUTE7 => l_temp_pricing_attribs_rec.ATTRIBUTE7 ,
p_OLD_ATTRIBUTE8 => l_pricing_attribs_rec.ATTRIBUTE8 ,
p_NEW_ATTRIBUTE8 => l_temp_pricing_attribs_rec.ATTRIBUTE8 ,
p_OLD_ATTRIBUTE9 => l_pricing_attribs_rec.ATTRIBUTE9 ,
p_NEW_ATTRIBUTE9 => l_temp_pricing_attribs_rec.ATTRIBUTE9 ,
p_OLD_ATTRIBUTE10 => l_pricing_attribs_rec.ATTRIBUTE10 ,
p_NEW_ATTRIBUTE10 => l_temp_pricing_attribs_rec.ATTRIBUTE10 ,
p_OLD_ATTRIBUTE11 => l_pricing_attribs_rec.ATTRIBUTE11 ,
p_NEW_ATTRIBUTE11 => l_temp_pricing_attribs_rec.ATTRIBUTE11 ,
p_OLD_ATTRIBUTE12 => l_pricing_attribs_rec.ATTRIBUTE12 ,
p_NEW_ATTRIBUTE12 => l_temp_pricing_attribs_rec.ATTRIBUTE12 ,
p_OLD_ATTRIBUTE13 => l_pricing_attribs_rec.ATTRIBUTE13 ,
p_NEW_ATTRIBUTE13 => l_temp_pricing_attribs_rec.ATTRIBUTE13 ,
p_OLD_ATTRIBUTE14 => l_pricing_attribs_rec.ATTRIBUTE14 ,
p_NEW_ATTRIBUTE14 => l_temp_pricing_attribs_rec.ATTRIBUTE14 ,
p_OLD_ATTRIBUTE15 => l_pricing_attribs_rec.ATTRIBUTE15 ,
p_NEW_ATTRIBUTE15 => l_temp_pricing_attribs_rec.ATTRIBUTE15 ,
p_FULL_DUMP_FLAG => l_dump_frequency_flag,
p_CREATED_BY => fnd_global.user_id,
p_CREATION_DATE => sysdate,
p_LAST_UPDATED_BY => fnd_global.user_id,
p_LAST_UPDATE_DATE => sysdate,
p_LAST_UPDATE_LOGIN => fnd_global.user_id,
p_OBJECT_VERSION_NUMBER => 1);
CSI_I_PRICING_ATTRIBS_H_PKG.Insert_Row(
px_PRICE_ATTRIB_HISTORY_ID => l_pricing_attrib_h_id,
p_PRICING_ATTRIBUTE_ID => l_pricing_attrib_id,
p_TRANSACTION_ID => p_txn_rec.transaction_id,
p_OLD_PRICING_CONTEXT => l_pricing_history_rec.old_pricing_context,
p_NEW_PRICING_CONTEXT => l_pricing_history_rec.new_pricing_context,
p_OLD_PRICING_ATTRIBUTE1 => l_pricing_history_rec.old_pricing_attribute1,
p_NEW_PRICING_ATTRIBUTE1 => l_pricing_history_rec.new_pricing_attribute1,
p_OLD_PRICING_ATTRIBUTE2 => l_pricing_history_rec.old_pricing_attribute2,
p_NEW_PRICING_ATTRIBUTE2 => l_pricing_history_rec.new_pricing_attribute2,
p_OLD_PRICING_ATTRIBUTE3 => l_pricing_history_rec.old_pricing_attribute3,
p_NEW_PRICING_ATTRIBUTE3 => l_pricing_history_rec.new_pricing_attribute3,
p_OLD_PRICING_ATTRIBUTE4 => l_pricing_history_rec.old_pricing_attribute4,
p_NEW_PRICING_ATTRIBUTE4 => l_pricing_history_rec.new_pricing_attribute4,
p_OLD_PRICING_ATTRIBUTE5 => l_pricing_history_rec.old_pricing_attribute5,
p_NEW_PRICING_ATTRIBUTE5 => l_pricing_history_rec.new_pricing_attribute5,
p_OLD_PRICING_ATTRIBUTE6 => l_pricing_history_rec.old_pricing_attribute6,
p_NEW_PRICING_ATTRIBUTE6 => l_pricing_history_rec.new_pricing_attribute6,
p_OLD_PRICING_ATTRIBUTE7 => l_pricing_history_rec.old_pricing_attribute7,
p_NEW_PRICING_ATTRIBUTE7 => l_pricing_history_rec.new_pricing_attribute7,
p_OLD_PRICING_ATTRIBUTE8 => l_pricing_history_rec.old_pricing_attribute8,
p_NEW_PRICING_ATTRIBUTE8 => l_pricing_history_rec.new_pricing_attribute8,
p_OLD_PRICING_ATTRIBUTE9 => l_pricing_history_rec.old_pricing_attribute9,
p_NEW_PRICING_ATTRIBUTE9 => l_pricing_history_rec.new_pricing_attribute9,
p_OLD_PRICING_ATTRIBUTE10 => l_pricing_history_rec.old_pricing_attribute10,
p_NEW_PRICING_ATTRIBUTE10 => l_pricing_history_rec.new_pricing_attribute10,
p_OLD_PRICING_ATTRIBUTE11 => l_pricing_history_rec.old_pricing_attribute11,
p_NEW_PRICING_ATTRIBUTE11 => l_pricing_history_rec.new_pricing_attribute11,
p_OLD_PRICING_ATTRIBUTE12 => l_pricing_history_rec.old_pricing_attribute12,
p_NEW_PRICING_ATTRIBUTE12 => l_pricing_history_rec.new_pricing_attribute12,
p_OLD_PRICING_ATTRIBUTE13 => l_pricing_history_rec.old_pricing_attribute13,
p_NEW_PRICING_ATTRIBUTE13 => l_pricing_history_rec.new_pricing_attribute13,
p_OLD_PRICING_ATTRIBUTE14 => l_pricing_history_rec.old_pricing_attribute14,
p_NEW_PRICING_ATTRIBUTE14 => l_pricing_history_rec.new_pricing_attribute14,
p_OLD_PRICING_ATTRIBUTE15 => l_pricing_history_rec.old_pricing_attribute15,
p_NEW_PRICING_ATTRIBUTE15 => l_pricing_history_rec.new_pricing_attribute15,
p_OLD_PRICING_ATTRIBUTE16 => l_pricing_history_rec.old_pricing_attribute16,
p_NEW_PRICING_ATTRIBUTE16 => l_pricing_history_rec.new_pricing_attribute16,
p_OLD_PRICING_ATTRIBUTE17 => l_pricing_history_rec.old_pricing_attribute17,
p_NEW_PRICING_ATTRIBUTE17 => l_pricing_history_rec.new_pricing_attribute17,
p_OLD_PRICING_ATTRIBUTE18 => l_pricing_history_rec.old_pricing_attribute18,
p_NEW_PRICING_ATTRIBUTE18 => l_pricing_history_rec.new_pricing_attribute18,
p_OLD_PRICING_ATTRIBUTE19 => l_pricing_history_rec.old_pricing_attribute19,
p_NEW_PRICING_ATTRIBUTE19 => l_pricing_history_rec.new_pricing_attribute19,
p_OLD_PRICING_ATTRIBUTE20 => l_pricing_history_rec.old_pricing_attribute20,
p_NEW_PRICING_ATTRIBUTE20 => l_pricing_history_rec.new_pricing_attribute20,
p_OLD_PRICING_ATTRIBUTE21 => l_pricing_history_rec.old_pricing_attribute21,
p_NEW_PRICING_ATTRIBUTE21 => l_pricing_history_rec.new_pricing_attribute21,
p_OLD_PRICING_ATTRIBUTE22 => l_pricing_history_rec.old_pricing_attribute22,
p_NEW_PRICING_ATTRIBUTE22 => l_pricing_history_rec.new_pricing_attribute22,
p_OLD_PRICING_ATTRIBUTE23 => l_pricing_history_rec.old_pricing_attribute22,
p_NEW_PRICING_ATTRIBUTE23 => l_pricing_history_rec.new_pricing_attribute23,
p_OLD_PRICING_ATTRIBUTE24 => l_pricing_history_rec.old_pricing_attribute24,
p_NEW_PRICING_ATTRIBUTE24 => l_pricing_history_rec.new_pricing_attribute24,
p_NEW_PRICING_ATTRIBUTE25 => l_pricing_history_rec.old_pricing_attribute25,
p_OLD_PRICING_ATTRIBUTE25 => l_pricing_history_rec.new_pricing_attribute25,
p_OLD_PRICING_ATTRIBUTE26 => l_pricing_history_rec.old_pricing_attribute26,
p_NEW_PRICING_ATTRIBUTE26 => l_pricing_history_rec.new_pricing_attribute26,
p_OLD_PRICING_ATTRIBUTE27 => l_pricing_history_rec.old_pricing_attribute27,
p_NEW_PRICING_ATTRIBUTE27 => l_pricing_history_rec.new_pricing_attribute27,
p_OLD_PRICING_ATTRIBUTE28 => l_pricing_history_rec.old_pricing_attribute28,
p_NEW_PRICING_ATTRIBUTE28 => l_pricing_history_rec.new_pricing_attribute28,
p_OLD_PRICING_ATTRIBUTE29 => l_pricing_history_rec.old_pricing_attribute29,
p_NEW_PRICING_ATTRIBUTE29 => l_pricing_history_rec.new_pricing_attribute29,
p_OLD_PRICING_ATTRIBUTE30 => l_pricing_history_rec.old_pricing_attribute30,
p_NEW_PRICING_ATTRIBUTE30 => l_pricing_history_rec.new_pricing_attribute30,
p_OLD_PRICING_ATTRIBUTE31 => l_pricing_history_rec.old_pricing_attribute31,
p_NEW_PRICING_ATTRIBUTE31 => l_pricing_history_rec.new_pricing_attribute31,
p_OLD_PRICING_ATTRIBUTE32 => l_pricing_history_rec.old_pricing_attribute32,
p_NEW_PRICING_ATTRIBUTE32 => l_pricing_history_rec.new_pricing_attribute32,
p_OLD_PRICING_ATTRIBUTE33 => l_pricing_history_rec.old_pricing_attribute33,
p_NEW_PRICING_ATTRIBUTE33 => l_pricing_history_rec.new_pricing_attribute33,
p_OLD_PRICING_ATTRIBUTE34 => l_pricing_history_rec.old_pricing_attribute34,
p_NEW_PRICING_ATTRIBUTE34 => l_pricing_history_rec.new_pricing_attribute34,
p_OLD_PRICING_ATTRIBUTE35 => l_pricing_history_rec.old_pricing_attribute35,
p_NEW_PRICING_ATTRIBUTE35 => l_pricing_history_rec.new_pricing_attribute35,
p_OLD_PRICING_ATTRIBUTE36 => l_pricing_history_rec.old_pricing_attribute36,
p_NEW_PRICING_ATTRIBUTE36 => l_pricing_history_rec.new_pricing_attribute36,
p_OLD_PRICING_ATTRIBUTE37 => l_pricing_history_rec.old_pricing_attribute37,
p_NEW_PRICING_ATTRIBUTE37 => l_pricing_history_rec.new_pricing_attribute37,
p_OLD_PRICING_ATTRIBUTE38 => l_pricing_history_rec.old_pricing_attribute38,
p_NEW_PRICING_ATTRIBUTE38 => l_pricing_history_rec.new_pricing_attribute38,
p_OLD_PRICING_ATTRIBUTE39 => l_pricing_history_rec.old_pricing_attribute39,
p_NEW_PRICING_ATTRIBUTE39 => l_pricing_history_rec.new_pricing_attribute39,
p_OLD_PRICING_ATTRIBUTE40 => l_pricing_history_rec.old_pricing_attribute40,
p_NEW_PRICING_ATTRIBUTE40 => l_pricing_history_rec.new_pricing_attribute40,
p_OLD_PRICING_ATTRIBUTE41 => l_pricing_history_rec.old_pricing_attribute41,
p_NEW_PRICING_ATTRIBUTE41 => l_pricing_history_rec.new_pricing_attribute41,
p_OLD_PRICING_ATTRIBUTE42 => l_pricing_history_rec.old_pricing_attribute42,
p_NEW_PRICING_ATTRIBUTE42 => l_pricing_history_rec.new_pricing_attribute42,
p_OLD_PRICING_ATTRIBUTE43 => l_pricing_history_rec.old_pricing_attribute43,
p_NEW_PRICING_ATTRIBUTE43 => l_pricing_history_rec.new_pricing_attribute43,
p_OLD_PRICING_ATTRIBUTE44 => l_pricing_history_rec.old_pricing_attribute44,
p_NEW_PRICING_ATTRIBUTE44 => l_pricing_history_rec.new_pricing_attribute44,
p_OLD_PRICING_ATTRIBUTE45 => l_pricing_history_rec.old_pricing_attribute45,
p_NEW_PRICING_ATTRIBUTE45 => l_pricing_history_rec.new_pricing_attribute45,
p_OLD_PRICING_ATTRIBUTE46 => l_pricing_history_rec.old_pricing_attribute46,
p_NEW_PRICING_ATTRIBUTE46 => l_pricing_history_rec.new_pricing_attribute46,
p_OLD_PRICING_ATTRIBUTE47 => l_pricing_history_rec.old_pricing_attribute47,
p_NEW_PRICING_ATTRIBUTE47 => l_pricing_history_rec.new_pricing_attribute47,
p_OLD_PRICING_ATTRIBUTE48 => l_pricing_history_rec.old_pricing_attribute48,
p_NEW_PRICING_ATTRIBUTE48 => l_pricing_history_rec.new_pricing_attribute48,
p_OLD_PRICING_ATTRIBUTE49 => l_pricing_history_rec.old_pricing_attribute49,
p_NEW_PRICING_ATTRIBUTE49 => l_pricing_history_rec.new_pricing_attribute49,
p_OLD_PRICING_ATTRIBUTE50 => l_pricing_history_rec.old_pricing_attribute50,
p_NEW_PRICING_ATTRIBUTE50 => l_pricing_history_rec.new_pricing_attribute50,
p_OLD_PRICING_ATTRIBUTE51 => l_pricing_history_rec.old_pricing_attribute51,
p_NEW_PRICING_ATTRIBUTE51 => l_pricing_history_rec.new_pricing_attribute51,
p_OLD_PRICING_ATTRIBUTE52 => l_pricing_history_rec.old_pricing_attribute52,
p_NEW_PRICING_ATTRIBUTE52 => l_pricing_history_rec.new_pricing_attribute52,
p_OLD_PRICING_ATTRIBUTE53 => l_pricing_history_rec.old_pricing_attribute53,
p_NEW_PRICING_ATTRIBUTE53 => l_pricing_history_rec.new_pricing_attribute53,
p_OLD_PRICING_ATTRIBUTE54 => l_pricing_history_rec.old_pricing_attribute54,
p_NEW_PRICING_ATTRIBUTE54 => l_pricing_history_rec.new_pricing_attribute54,
p_OLD_PRICING_ATTRIBUTE55 => l_pricing_history_rec.old_pricing_attribute55,
p_NEW_PRICING_ATTRIBUTE55 => l_pricing_history_rec.new_pricing_attribute55,
p_OLD_PRICING_ATTRIBUTE56 => l_pricing_history_rec.old_pricing_attribute56,
p_NEW_PRICING_ATTRIBUTE56 => l_pricing_history_rec.new_pricing_attribute56,
p_OLD_PRICING_ATTRIBUTE57 => l_pricing_history_rec.old_pricing_attribute57,
p_NEW_PRICING_ATTRIBUTE57 => l_pricing_history_rec.new_pricing_attribute57,
p_OLD_PRICING_ATTRIBUTE58 => l_pricing_history_rec.old_pricing_attribute58,
p_NEW_PRICING_ATTRIBUTE58 => l_pricing_history_rec.new_pricing_attribute58,
p_OLD_PRICING_ATTRIBUTE59 => l_pricing_history_rec.old_pricing_attribute59,
p_NEW_PRICING_ATTRIBUTE59 => l_pricing_history_rec.new_pricing_attribute59,
p_OLD_PRICING_ATTRIBUTE60 => l_pricing_history_rec.old_pricing_attribute60,
p_NEW_PRICING_ATTRIBUTE60 => l_pricing_history_rec.new_pricing_attribute60,
p_OLD_PRICING_ATTRIBUTE61 => l_pricing_history_rec.old_pricing_attribute61,
p_NEW_PRICING_ATTRIBUTE61 => l_pricing_history_rec.new_pricing_attribute61,
p_OLD_PRICING_ATTRIBUTE62 => l_pricing_history_rec.old_pricing_attribute62,
p_NEW_PRICING_ATTRIBUTE62 => l_pricing_history_rec.new_pricing_attribute62,
p_OLD_PRICING_ATTRIBUTE63 => l_pricing_history_rec.old_pricing_attribute63,
p_NEW_PRICING_ATTRIBUTE63 => l_pricing_history_rec.new_pricing_attribute63,
p_OLD_PRICING_ATTRIBUTE64 => l_pricing_history_rec.old_pricing_attribute64,
p_NEW_PRICING_ATTRIBUTE64 => l_pricing_history_rec.new_pricing_attribute64,
p_OLD_PRICING_ATTRIBUTE65 => l_pricing_history_rec.old_pricing_attribute65,
p_NEW_PRICING_ATTRIBUTE65 => l_pricing_history_rec.new_pricing_attribute65,
p_OLD_PRICING_ATTRIBUTE66 => l_pricing_history_rec.old_pricing_attribute66,
p_NEW_PRICING_ATTRIBUTE66 => l_pricing_history_rec.new_pricing_attribute66,
p_OLD_PRICING_ATTRIBUTE67 => l_pricing_history_rec.old_pricing_attribute67,
p_NEW_PRICING_ATTRIBUTE67 => l_pricing_history_rec.new_pricing_attribute67,
p_OLD_PRICING_ATTRIBUTE68 => l_pricing_history_rec.old_pricing_attribute68,
p_NEW_PRICING_ATTRIBUTE68 => l_pricing_history_rec.new_pricing_attribute68,
p_OLD_PRICING_ATTRIBUTE69 => l_pricing_history_rec.old_pricing_attribute69,
p_NEW_PRICING_ATTRIBUTE69 => l_pricing_history_rec.new_pricing_attribute69,
p_OLD_PRICING_ATTRIBUTE70 => l_pricing_history_rec.old_pricing_attribute70,
p_NEW_PRICING_ATTRIBUTE70 => l_pricing_history_rec.new_pricing_attribute70,
p_OLD_PRICING_ATTRIBUTE71 => l_pricing_history_rec.old_pricing_attribute71,
p_NEW_PRICING_ATTRIBUTE71 => l_pricing_history_rec.new_pricing_attribute71,
p_OLD_PRICING_ATTRIBUTE72 => l_pricing_history_rec.old_pricing_attribute72,
p_NEW_PRICING_ATTRIBUTE72 => l_pricing_history_rec.new_pricing_attribute72,
p_OLD_PRICING_ATTRIBUTE73 => l_pricing_history_rec.old_pricing_attribute73,
p_NEW_PRICING_ATTRIBUTE73 => l_pricing_history_rec.new_pricing_attribute73,
p_OLD_PRICING_ATTRIBUTE74 => l_pricing_history_rec.old_pricing_attribute74,
p_NEW_PRICING_ATTRIBUTE74 => l_pricing_history_rec.new_pricing_attribute74,
p_OLD_PRICING_ATTRIBUTE75 => l_pricing_history_rec.old_pricing_attribute75,
p_NEW_PRICING_ATTRIBUTE75 => l_pricing_history_rec.new_pricing_attribute75,
p_OLD_PRICING_ATTRIBUTE76 => l_pricing_history_rec.old_pricing_attribute76,
p_NEW_PRICING_ATTRIBUTE76 => l_pricing_history_rec.new_pricing_attribute76,
p_OLD_PRICING_ATTRIBUTE77 => l_pricing_history_rec.old_pricing_attribute77,
p_NEW_PRICING_ATTRIBUTE77 => l_pricing_history_rec.new_pricing_attribute77,
p_OLD_PRICING_ATTRIBUTE78 => l_pricing_history_rec.old_pricing_attribute78,
p_NEW_PRICING_ATTRIBUTE78 => l_pricing_history_rec.new_pricing_attribute78,
p_OLD_PRICING_ATTRIBUTE79 => l_pricing_history_rec.old_pricing_attribute79,
p_NEW_PRICING_ATTRIBUTE79 => l_pricing_history_rec.new_pricing_attribute79,
p_OLD_PRICING_ATTRIBUTE80 => l_pricing_history_rec.old_pricing_attribute80,
p_NEW_PRICING_ATTRIBUTE80 => l_pricing_history_rec.new_pricing_attribute80,
p_OLD_PRICING_ATTRIBUTE81 => l_pricing_history_rec.old_pricing_attribute81,
p_NEW_PRICING_ATTRIBUTE81 => l_pricing_history_rec.new_pricing_attribute81,
p_OLD_PRICING_ATTRIBUTE82 => l_pricing_history_rec.old_pricing_attribute82,
p_NEW_PRICING_ATTRIBUTE82 => l_pricing_history_rec.new_pricing_attribute82,
p_OLD_PRICING_ATTRIBUTE83 => l_pricing_history_rec.old_pricing_attribute83,
p_NEW_PRICING_ATTRIBUTE83 => l_pricing_history_rec.new_pricing_attribute83,
p_OLD_PRICING_ATTRIBUTE84 => l_pricing_history_rec.old_pricing_attribute84,
p_NEW_PRICING_ATTRIBUTE84 => l_pricing_history_rec.new_pricing_attribute84,
p_OLD_PRICING_ATTRIBUTE85 => l_pricing_history_rec.old_pricing_attribute85,
p_NEW_PRICING_ATTRIBUTE85 => l_pricing_history_rec.new_pricing_attribute85,
p_OLD_PRICING_ATTRIBUTE86 => l_pricing_history_rec.old_pricing_attribute86,
p_NEW_PRICING_ATTRIBUTE86 => l_pricing_history_rec.new_pricing_attribute86,
p_OLD_PRICING_ATTRIBUTE87 => l_pricing_history_rec.old_pricing_attribute87,
p_NEW_PRICING_ATTRIBUTE87 => l_pricing_history_rec.new_pricing_attribute87,
p_OLD_PRICING_ATTRIBUTE88 => l_pricing_history_rec.old_pricing_attribute88,
p_NEW_PRICING_ATTRIBUTE88 => l_pricing_history_rec.new_pricing_attribute88,
p_OLD_PRICING_ATTRIBUTE89 => l_pricing_history_rec.old_pricing_attribute89,
p_NEW_PRICING_ATTRIBUTE89 => l_pricing_history_rec.new_pricing_attribute89,
p_OLD_PRICING_ATTRIBUTE90 => l_pricing_history_rec.old_pricing_attribute90,
p_NEW_PRICING_ATTRIBUTE90 => l_pricing_history_rec.new_pricing_attribute90,
p_OLD_PRICING_ATTRIBUTE91 => l_pricing_history_rec.old_pricing_attribute91,
p_NEW_PRICING_ATTRIBUTE91 => l_pricing_history_rec.new_pricing_attribute91,
p_OLD_PRICING_ATTRIBUTE92 => l_pricing_history_rec.old_pricing_attribute92,
p_NEW_PRICING_ATTRIBUTE92 => l_pricing_history_rec.new_pricing_attribute92,
p_OLD_PRICING_ATTRIBUTE93 => l_pricing_history_rec.old_pricing_attribute93,
p_NEW_PRICING_ATTRIBUTE93 => l_pricing_history_rec.new_pricing_attribute93,
p_OLD_PRICING_ATTRIBUTE94 => l_pricing_history_rec.old_pricing_attribute94,
p_NEW_PRICING_ATTRIBUTE94 => l_pricing_history_rec.new_pricing_attribute94,
p_OLD_PRICING_ATTRIBUTE95 => l_pricing_history_rec.old_pricing_attribute95,
p_NEW_PRICING_ATTRIBUTE95 => l_pricing_history_rec.new_pricing_attribute95,
p_OLD_PRICING_ATTRIBUTE96 => l_pricing_history_rec.old_pricing_attribute96,
p_NEW_PRICING_ATTRIBUTE96 => l_pricing_history_rec.new_pricing_attribute96,
p_OLD_PRICING_ATTRIBUTE97 => l_pricing_history_rec.old_pricing_attribute97,
p_NEW_PRICING_ATTRIBUTE97 => l_pricing_history_rec.new_pricing_attribute97,
p_OLD_PRICING_ATTRIBUTE98 => l_pricing_history_rec.old_pricing_attribute98,
p_NEW_PRICING_ATTRIBUTE98 => l_pricing_history_rec.new_pricing_attribute98,
p_OLD_PRICING_ATTRIBUTE99 => l_pricing_history_rec.old_pricing_attribute99,
p_NEW_PRICING_ATTRIBUTE99 => l_pricing_history_rec.new_pricing_attribute99,
p_OLD_PRICING_ATTRIBUTE100 => l_pricing_history_rec.old_pricing_attribute100,
p_NEW_PRICING_ATTRIBUTE100 => l_pricing_history_rec.new_pricing_attribute100,
p_OLD_ACTIVE_START_DATE => l_pricing_history_rec.old_active_start_date,
p_NEW_ACTIVE_START_DATE => l_pricing_history_rec.new_active_start_date,
p_OLD_ACTIVE_END_DATE => l_pricing_history_rec.old_active_end_date,
p_NEW_ACTIVE_END_DATE => l_pricing_history_rec.new_active_end_date,
p_OLD_CONTEXT => l_pricing_history_rec.old_context,
p_NEW_CONTEXT => l_pricing_history_rec.new_context,
p_OLD_ATTRIBUTE1 => l_pricing_history_rec.old_ATTRIBUTE1,
p_NEW_ATTRIBUTE1 => l_pricing_history_rec.new_ATTRIBUTE1,
p_OLD_ATTRIBUTE2 => l_pricing_history_rec.old_ATTRIBUTE2,
p_NEW_ATTRIBUTE2 => l_pricing_history_rec.new_ATTRIBUTE2,
p_OLD_ATTRIBUTE3 => l_pricing_history_rec.old_ATTRIBUTE3,
p_NEW_ATTRIBUTE3 => l_pricing_history_rec.new_ATTRIBUTE3,
p_OLD_ATTRIBUTE4 => l_pricing_history_rec.old_ATTRIBUTE4,
p_NEW_ATTRIBUTE4 => l_pricing_history_rec.new_ATTRIBUTE4,
p_OLD_ATTRIBUTE5 => l_pricing_history_rec.old_ATTRIBUTE5,
p_NEW_ATTRIBUTE5 => l_pricing_history_rec.new_ATTRIBUTE5,
p_OLD_ATTRIBUTE6 => l_pricing_history_rec.old_ATTRIBUTE6,
p_NEW_ATTRIBUTE6 => l_pricing_history_rec.new_ATTRIBUTE6,
p_OLD_ATTRIBUTE7 => l_pricing_history_rec.old_ATTRIBUTE7,
p_NEW_ATTRIBUTE7 => l_pricing_history_rec.new_ATTRIBUTE7,
p_OLD_ATTRIBUTE8 => l_pricing_history_rec.old_ATTRIBUTE8,
p_NEW_ATTRIBUTE8 => l_pricing_history_rec.new_ATTRIBUTE8,
p_OLD_ATTRIBUTE9 => l_pricing_history_rec.old_ATTRIBUTE9,
p_NEW_ATTRIBUTE9 => l_pricing_history_rec.new_ATTRIBUTE9,
p_OLD_ATTRIBUTE10 => l_pricing_history_rec.old_ATTRIBUTE10,
p_NEW_ATTRIBUTE10 => l_pricing_history_rec.new_ATTRIBUTE10,
p_OLD_ATTRIBUTE11 => l_pricing_history_rec.old_ATTRIBUTE11,
p_NEW_ATTRIBUTE11 => l_pricing_history_rec.new_ATTRIBUTE11,
p_OLD_ATTRIBUTE12 => l_pricing_history_rec.old_ATTRIBUTE12,
p_NEW_ATTRIBUTE12 => l_pricing_history_rec.new_ATTRIBUTE12,
p_OLD_ATTRIBUTE13 => l_pricing_history_rec.old_ATTRIBUTE13,
p_NEW_ATTRIBUTE13 => l_pricing_history_rec.new_ATTRIBUTE13,
p_OLD_ATTRIBUTE14 => l_pricing_history_rec.old_ATTRIBUTE14,
p_NEW_ATTRIBUTE14 => l_pricing_history_rec.new_ATTRIBUTE14,
p_OLD_ATTRIBUTE15 => l_pricing_history_rec.old_ATTRIBUTE15,
p_NEW_ATTRIBUTE15 => l_pricing_history_rec.new_ATTRIBUTE15,
p_FULL_DUMP_FLAG => l_dump_frequency_flag,
p_CREATED_BY => fnd_global.user_id,
p_CREATION_DATE => sysdate,
p_LAST_UPDATED_BY => fnd_global.user_id,
p_LAST_UPDATE_DATE => sysdate,
p_LAST_UPDATE_LOGIN => fnd_global.user_id,
p_OBJECT_VERSION_NUMBER => 1);
ROLLBACK TO update_pricing_attribs;
ROLLBACK TO update_pricing_attribs;
ROLLBACK TO update_pricing_attribs;
END update_pricing_attribs;
csi_pricing_attribs_pvt.update_pricing_attribs
( p_api_version => p_api_version
,p_commit => fnd_api.g_false
,p_init_msg_list => p_init_msg_list
,p_validation_level => p_validation_level
,p_pricing_attribs_rec => l_pricing_attribs_rec
,p_txn_rec => p_txn_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);