[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_lot_dff
( p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
, p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
, p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_lot_rec IN ic_lots_mst%ROWTYPE
) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_lot_dff' ;
SELECT count(*)
INTO l_count
FROM ic_item_mst_b
WHERE item_id = p_lot_rec.item_id;
UPDATE ic_lots_mst
SET
attribute1 = p_lot_rec.attribute1,
attribute2 = p_lot_rec.attribute2,
attribute3 = p_lot_rec.attribute3,
attribute4 = p_lot_rec.attribute4,
attribute5 = p_lot_rec.attribute5,
attribute6 = p_lot_rec.attribute6,
attribute7 = p_lot_rec.attribute7,
attribute8 = p_lot_rec.attribute8,
attribute9 = p_lot_rec.attribute9,
attribute10 = p_lot_rec.attribute10,
attribute11 = p_lot_rec.attribute11,
attribute12 = p_lot_rec.attribute12,
attribute13 = p_lot_rec.attribute13,
attribute14 = p_lot_rec.attribute14,
attribute15 = p_lot_rec.attribute15,
attribute16 = p_lot_rec.attribute16,
attribute17 = p_lot_rec.attribute17,
attribute18 = p_lot_rec.attribute18,
attribute19 = p_lot_rec.attribute19,
attribute20 = p_lot_rec.attribute20,
attribute22 = p_lot_rec.attribute22,
attribute21 = p_lot_rec.attribute21,
attribute23 = p_lot_rec.attribute23,
attribute24 = p_lot_rec.attribute24,
attribute25 = p_lot_rec.attribute25,
attribute26 = p_lot_rec.attribute26,
attribute27 = p_lot_rec.attribute27,
attribute28 = p_lot_rec.attribute28,
attribute29 = p_lot_rec.attribute29,
attribute30 = p_lot_rec.attribute30
WHERE
item_id = p_lot_rec.item_id and
lot_id = p_lot_rec.lot_id;
| Update_Lot |
| |
| TYPE |
| Public |
| |
| DESCRIPTION |
| This is a public API for updating the descriptive columns as well |
| as expire date in lot master |
| |
| HISTORY |
| Created - Supriya Malluru - 21-Jan-2005 |
| |
+==========================================================================+
*/
PROCEDURE update_lot
( p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
, p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
, p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_lot_rec IN ic_lots_mst%ROWTYPE
) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_lot' ;
CURSOR cur_old_lot IS SELECT *
FROM ic_lots_mst a
WHERE a.item_id = p_lot_rec.item_id
AND a.lot_id = p_lot_rec.lot_id;
SELECT count(*)
INTO l_count
FROM ic_item_mst_b
WHERE item_id = l_old_rec.item_id;
UPDATE ic_lots_mst
SET
expire_date = p_lot_rec.expire_date,
attribute1 = p_lot_rec.attribute1,
attribute2 = p_lot_rec.attribute2,
attribute3 = p_lot_rec.attribute3,
attribute4 = p_lot_rec.attribute4,
attribute5 = p_lot_rec.attribute5,
attribute6 = p_lot_rec.attribute6,
attribute7 = p_lot_rec.attribute7,
attribute8 = p_lot_rec.attribute8,
attribute9 = p_lot_rec.attribute9,
attribute10 = p_lot_rec.attribute10,
attribute11 = p_lot_rec.attribute11,
attribute12 = p_lot_rec.attribute12,
attribute13 = p_lot_rec.attribute13,
attribute14 = p_lot_rec.attribute14,
attribute15 = p_lot_rec.attribute15,
attribute16 = p_lot_rec.attribute16,
attribute17 = p_lot_rec.attribute17,
attribute18 = p_lot_rec.attribute18,
attribute19 = p_lot_rec.attribute19,
attribute20 = p_lot_rec.attribute20,
attribute22 = p_lot_rec.attribute22,
attribute21 = p_lot_rec.attribute21,
attribute23 = p_lot_rec.attribute23,
attribute24 = p_lot_rec.attribute24,
attribute25 = p_lot_rec.attribute25,
attribute26 = p_lot_rec.attribute26,
attribute27 = p_lot_rec.attribute27,
attribute28 = p_lot_rec.attribute28,
attribute29 = p_lot_rec.attribute29,
attribute30 = p_lot_rec.attribute30
WHERE
item_id = l_old_rec.item_id
AND lot_id = l_old_rec.lot_id;