[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
| - insert_row |
| - fetch_row |
| - update_row |
| - delete_row |
| - lock_row |
| |
=========================================================================*/
/*==========================================================================
| FUNCTION NAME |
| insert_row |
| |
| TYPE |
| Private |
| |
| USAGE |
| insert_row will insert a row in gme_pending_product_lots |
| |
| DESCRIPTION |
| insert_row will insert a row in gme_pending_product_lots |
| |
| PARAMETERS |
| p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE |
| x_pending_product_lots_rec IN OUT NOCOPY gme_pending_product_lots%ROWTYPE |
| |
| RETURNS |
| BOOLEAN |
| |
| HISTORY |
| |
==========================================================================*/
FUNCTION insert_row
(p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
,x_pending_product_lots_rec IN OUT NOCOPY gme_pending_product_lots%ROWTYPE) RETURN BOOLEAN IS
l_api_name CONSTANT VARCHAR2 (30) := 'insert_row';
x_pending_product_lots_rec.last_update_date := gme_common_pvt.g_timestamp;
x_pending_product_lots_rec.last_updated_by := gme_common_pvt.g_user_ident;
x_pending_product_lots_rec.last_update_login := gme_common_pvt.g_login_id;
SELECT apps.gme_pending_product_lots_s.nextval
INTO x_pending_product_lots_rec.PENDING_PRODUCT_LOT_ID
FROM sys.dual;
INSERT INTO gme_pending_product_lots
(PENDING_PRODUCT_LOT_ID
,SEQUENCE
,BATCH_ID
,MATERIAL_DETAIL_ID
,REVISION
,LOT_NUMBER
,QUANTITY
,SECONDARY_QUANTITY
,REASON_ID
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN)
VALUES (x_pending_product_lots_rec.PENDING_PRODUCT_LOT_ID
,x_pending_product_lots_rec.SEQUENCE
,x_pending_product_lots_rec.BATCH_ID
,x_pending_product_lots_rec.MATERIAL_DETAIL_ID
,x_pending_product_lots_rec.REVISION
,x_pending_product_lots_rec.LOT_NUMBER
,x_pending_product_lots_rec.QUANTITY
,x_pending_product_lots_rec.SECONDARY_QUANTITY
,x_pending_product_lots_rec.REASON_ID
,x_pending_product_lots_rec.CREATION_DATE
,x_pending_product_lots_rec.CREATED_BY
,x_pending_product_lots_rec.LAST_UPDATE_DATE
,x_pending_product_lots_rec.LAST_UPDATED_BY
,x_pending_product_lots_rec.LAST_UPDATE_LOGIN);
END insert_row;
SELECT *
INTO x_pending_product_lots_rec
FROM gme_pending_product_lots
WHERE pending_product_lot_id = l_pp_lot_id;
SELECT *
INTO x_pending_product_lots_rec
FROM gme_pending_product_lots
WHERE material_detail_id = l_matl_dtl_id
AND sequence = l_sequ;
| delete_row |
| |
| TYPE |
| Private |
| |
| USAGE |
| delete_row will delete a row in gme_pending_product_lots |
| |
| DESCRIPTION |
| delete_row will delete a row in gme_pending_product_lots |
| |
| PARAMETERS |
| p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE |
| |
| RETURNS |
| BOOLEAN |
| |
| HISTORY |
| |
==========================================================================*/
FUNCTION delete_row (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE) RETURN BOOLEAN IS
l_api_name CONSTANT VARCHAR2 (30) := 'delete_row';
SELECT 1
INTO l_dummy
FROM gme_pending_product_lots
WHERE pending_product_lot_id = l_pp_lot_id
FOR UPDATE NOWAIT;
DELETE
FROM gme_pending_product_lots
WHERE pending_product_lot_id = l_pp_lot_id;
SELECT 1
INTO l_dummy
FROM gme_pending_product_lots
WHERE material_detail_id = l_matl_dtl_id
AND sequence = l_sequ
FOR UPDATE NOWAIT;
DELETE
FROM gme_pending_product_lots
WHERE material_detail_id = l_matl_dtl_id
AND sequence = l_sequ;
END delete_row;
| update_row |
| |
| TYPE |
| Private |
| |
| USAGE |
| update_row will update a row in gme_pending_product_lots |
| |
| DESCRIPTION |
| update_row will update a row in gme_pending_product_lots |
| |
| PARAMETERS |
| p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE |
| |
| RETURNS |
| BOOLEAN |
| |
| HISTORY |
| |
==========================================================================*/
FUNCTION update_row (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE) RETURN BOOLEAN IS
l_dummy NUMBER := 0;
l_api_name CONSTANT VARCHAR2 (30) := 'update_row';
l_pp_lot_rec.last_update_date := gme_common_pvt.g_timestamp;
l_pp_lot_rec.last_updated_by := gme_common_pvt.g_user_ident;
l_pp_lot_rec.last_update_login := gme_common_pvt.g_login_id;
SELECT 1
INTO l_dummy
FROM gme_pending_product_lots
WHERE pending_product_lot_id = l_pp_lot_id
FOR UPDATE NOWAIT;
UPDATE gme_pending_product_lots
SET SEQUENCE = l_pp_lot_rec.SEQUENCE
,LOT_NUMBER = l_pp_lot_rec.LOT_NUMBER
,REVISION = l_pp_lot_rec.REVISION
,QUANTITY = l_pp_lot_rec.QUANTITY
,SECONDARY_QUANTITY = l_pp_lot_rec.SECONDARY_QUANTITY
,REASON_ID = l_pp_lot_rec.REASON_ID
,LAST_UPDATE_DATE = l_pp_lot_rec.LAST_UPDATE_DATE
,LAST_UPDATED_BY = l_pp_lot_rec.LAST_UPDATED_BY
,LAST_UPDATE_LOGIN = l_pp_lot_rec.LAST_UPDATE_LOGIN
WHERE pending_product_lot_id = l_pp_lot_id
AND last_update_date = p_pending_product_lots_rec.last_update_date;
SELECT 1
INTO l_dummy
FROM gme_pending_product_lots
WHERE material_detail_id = l_matl_dtl_id
AND sequence = l_sequ
FOR UPDATE NOWAIT;
UPDATE gme_pending_product_lots
SET SEQUENCE = l_pp_lot_rec.SEQUENCE
,REVISION = l_pp_lot_rec.REVISION
,QUANTITY = l_pp_lot_rec.QUANTITY
,SECONDARY_QUANTITY = l_pp_lot_rec.SECONDARY_QUANTITY
,REASON_ID = l_pp_lot_rec.REASON_ID
,LAST_UPDATE_DATE = l_pp_lot_rec.LAST_UPDATE_DATE
,LAST_UPDATED_BY = l_pp_lot_rec.LAST_UPDATED_BY
,LAST_UPDATE_LOGIN = l_pp_lot_rec.LAST_UPDATE_LOGIN
WHERE material_detail_id = l_matl_dtl_id
AND sequence = l_sequ
AND last_update_date = p_pending_product_lots_rec.last_update_date;
END update_row;
SELECT 1
INTO l_dummy
FROM gme_pending_product_lots
WHERE pending_product_lot_id = l_pp_lot_id
FOR UPDATE NOWAIT;
SELECT 1
INTO l_dummy
FROM gme_pending_product_lots
WHERE material_detail_id = l_matl_dtl_id
AND sequence = l_sequ
FOR UPDATE NOWAIT;