[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
| - insert_row
| - fetch_row
| - update_row
| - lock_row
|
|
=============================================================================
*/
/* Api start of comments
+============================================================================
| FUNCTION NAME
| insert_row
|
| TYPE
| Private
| USAGE
| Insert_Row will insert a row in gme_batch_step_items
|
|
| DESCRIPTION
| Insert_Row will insert a row in gme_batch_step_items
|
|
|
| PARAMETERS
| p_batch_step_items IN gme_batch_step_items%ROWTYPE
| x_batch_step_items IN OUT NOCOPY gme_batch_step_items%ROWTYPE
|
| RETURNS
| BOOLEAN
| HISTORY
| 12-MAR-01 Thomas Daniel Created
| 29-APR-04 Rishi Varma 3307549
| Added the fields minimum_transfer_qty,maximum_delay
| and minimum_delay.
| Rajesh Patangya DFF Enhancement 03Jan2008 Bug# 6195829
|
|
+=============================================================================
Api end of comments
*/
FUNCTION insert_row (
p_batch_step_items IN gme_batch_step_items%ROWTYPE
,x_batch_step_items IN OUT NOCOPY gme_batch_step_items%ROWTYPE)
RETURN BOOLEAN
IS
l_api_name CONSTANT VARCHAR2 (30) := 'insert_row';
INSERT INTO gme_batch_step_items
(material_detail_id
,batch_id
,batchstep_id
,text_code
,minimum_transfer_qty
,minimum_delay
,maximum_delay
--Rajesh Patangya DFF Enhancement 03Jan2008 Bug# 6195829
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,ATTRIBUTE16
,ATTRIBUTE17
,ATTRIBUTE18
,ATTRIBUTE19
,ATTRIBUTE20
,ATTRIBUTE21
,ATTRIBUTE22
,ATTRIBUTE23
,ATTRIBUTE24
,ATTRIBUTE25
,ATTRIBUTE26
,ATTRIBUTE27
,ATTRIBUTE28
,ATTRIBUTE29
,ATTRIBUTE30
,last_update_login, last_update_date
,last_updated_by, creation_date
,created_by)
VALUES (x_batch_step_items.material_detail_id
,x_batch_step_items.batch_id
,x_batch_step_items.batchstep_id
,x_batch_step_items.text_code
,x_batch_step_items.minimum_transfer_qty
,x_batch_step_items.minimum_delay
,x_batch_step_items.maximum_delay
--Rajesh Patangya DFF Enhancement 03Jan2008 Bug# 6195829
,x_batch_step_items.ATTRIBUTE_CATEGORY
,x_batch_step_items.ATTRIBUTE1
,x_batch_step_items.ATTRIBUTE2
,x_batch_step_items.ATTRIBUTE3
,x_batch_step_items.ATTRIBUTE4
,x_batch_step_items.ATTRIBUTE5
,x_batch_step_items.ATTRIBUTE6
,x_batch_step_items.ATTRIBUTE7
,x_batch_step_items.ATTRIBUTE8
,x_batch_step_items.ATTRIBUTE9
,x_batch_step_items.ATTRIBUTE10
,x_batch_step_items.ATTRIBUTE11
,x_batch_step_items.ATTRIBUTE12
,x_batch_step_items.ATTRIBUTE13
,x_batch_step_items.ATTRIBUTE14
,x_batch_step_items.ATTRIBUTE15
,x_batch_step_items.ATTRIBUTE16
,x_batch_step_items.ATTRIBUTE17
,x_batch_step_items.ATTRIBUTE18
,x_batch_step_items.ATTRIBUTE19
,x_batch_step_items.ATTRIBUTE20
,x_batch_step_items.ATTRIBUTE21
,x_batch_step_items.ATTRIBUTE22
,x_batch_step_items.ATTRIBUTE23
,x_batch_step_items.ATTRIBUTE24
,x_batch_step_items.ATTRIBUTE25
,x_batch_step_items.ATTRIBUTE26
,x_batch_step_items.ATTRIBUTE27
,x_batch_step_items.ATTRIBUTE28
,x_batch_step_items.ATTRIBUTE29
,x_batch_step_items.ATTRIBUTE30
,gme_common_pvt.g_login_id, gme_common_pvt.g_timestamp
,gme_common_pvt.g_user_ident, gme_common_pvt.g_timestamp
,gme_common_pvt.g_user_ident);
END insert_row;
SELECT material_detail_id
,batch_id
,batchstep_id
,text_code
,minimum_transfer_qty
,minimum_delay
,maximum_delay
--Rajesh Patangya DFF Enhancement 03Jan2008 Bug# 6195829
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,ATTRIBUTE16
,ATTRIBUTE17
,ATTRIBUTE18
,ATTRIBUTE19
,ATTRIBUTE20
,ATTRIBUTE21
,ATTRIBUTE22
,ATTRIBUTE23
,ATTRIBUTE24
,ATTRIBUTE25
,ATTRIBUTE26
,ATTRIBUTE27
,ATTRIBUTE28
,ATTRIBUTE29
,ATTRIBUTE30
,last_update_login
,last_update_date
,last_updated_by
,creation_date
,created_by
INTO x_batch_step_items.material_detail_id
,x_batch_step_items.batch_id
,x_batch_step_items.batchstep_id
,x_batch_step_items.text_code
,x_batch_step_items.minimum_transfer_qty
,x_batch_step_items.minimum_delay
,x_batch_step_items.maximum_delay
--Rajesh Patangya DFF Enhancement 03Jan2008 Bug# 6195829
,x_batch_step_items.ATTRIBUTE_CATEGORY
,x_batch_step_items.ATTRIBUTE1
,x_batch_step_items.ATTRIBUTE2
,x_batch_step_items.ATTRIBUTE3
,x_batch_step_items.ATTRIBUTE4
,x_batch_step_items.ATTRIBUTE5
,x_batch_step_items.ATTRIBUTE6
,x_batch_step_items.ATTRIBUTE7
,x_batch_step_items.ATTRIBUTE8
,x_batch_step_items.ATTRIBUTE9
,x_batch_step_items.ATTRIBUTE10
,x_batch_step_items.ATTRIBUTE11
,x_batch_step_items.ATTRIBUTE12
,x_batch_step_items.ATTRIBUTE13
,x_batch_step_items.ATTRIBUTE14
,x_batch_step_items.ATTRIBUTE15
,x_batch_step_items.ATTRIBUTE16
,x_batch_step_items.ATTRIBUTE17
,x_batch_step_items.ATTRIBUTE18
,x_batch_step_items.ATTRIBUTE19
,x_batch_step_items.ATTRIBUTE20
,x_batch_step_items.ATTRIBUTE21
,x_batch_step_items.ATTRIBUTE22
,x_batch_step_items.ATTRIBUTE23
,x_batch_step_items.ATTRIBUTE24
,x_batch_step_items.ATTRIBUTE25
,x_batch_step_items.ATTRIBUTE26
,x_batch_step_items.ATTRIBUTE27
,x_batch_step_items.ATTRIBUTE28
,x_batch_step_items.ATTRIBUTE29
,x_batch_step_items.ATTRIBUTE30
,x_batch_step_items.last_update_login
,x_batch_step_items.last_update_date
,x_batch_step_items.last_updated_by
,x_batch_step_items.creation_date
,x_batch_step_items.created_by
FROM gme_batch_step_items
WHERE material_detail_id = p_batch_step_items.material_detail_id;
| delete_row
|
| TYPE
| Private
| USAGE
| Delete_Row will delete a row in gme_batch_step_items
|
|
| DESCRIPTION
| Delete_Row will delete a row in gme_batch_step_items
|
|
|
| PARAMETERS
| p_batch_step_items IN gme_batch_step_items%ROWTYPE
|
| RETURNS
| BOOLEAN
| HISTORY
| 12-MAR-01 Thomas Daniel Created
| 26-AUG-02 Bharati Satpute Bug2404126
| Added error message 'GME_RECORD_CHANGED'
|
|
+=============================================================================
Api end of comments
*/
FUNCTION delete_row (p_batch_step_items IN gme_batch_step_items%ROWTYPE)
RETURN BOOLEAN
IS
l_dummy NUMBER := 0;
l_api_name CONSTANT VARCHAR2 (30) := 'delete_row';
SELECT 1
INTO l_dummy
FROM gme_batch_step_items
WHERE material_detail_id = p_batch_step_items.material_detail_id
FOR UPDATE NOWAIT;
DELETE FROM gme_batch_step_items
WHERE material_detail_id =
p_batch_step_items.material_detail_id;
END delete_row;
| update_row
|
| TYPE
| Private
| USAGE
| Update_Row will update a row in gme_batch_step_items
|
|
| DESCRIPTION
| Update_Row will update a row in gme_batch_step_items
|
|
|
| PARAMETERS
| p_batch_step_items IN gme_batch_step_items%ROWTYPE
|
| RETURNS
| BOOLEAN
| HISTORY
| 12-MAR-01 Thomas Daniel Created
| 26-AUG-02 Bharati Satpute Bug2404126
| Added error message 'GME_RECORD_CHANGED'
| 13-MAY-04 Rishi Varma 3307549
| Added the fields minimum_transfer_qty,maximum_delay
| and minimum_delay.
| Rajesh Patangya DFF Enhancement 03Jan2008 Bug# 6195829
|
+=============================================================================
Api end of comments
*/
FUNCTION update_row (p_batch_step_items IN gme_batch_step_items%ROWTYPE)
RETURN BOOLEAN
IS
l_dummy NUMBER (5) := 0;
l_api_name CONSTANT VARCHAR2 (30) := 'update_row';
SELECT 1
INTO l_dummy
FROM gme_batch_step_items
WHERE material_detail_id = p_batch_step_items.material_detail_id
FOR UPDATE NOWAIT;
UPDATE gme_batch_step_items
SET batch_id = p_batch_step_items.batch_id
,batchstep_id = p_batch_step_items.batchstep_id
,text_code = p_batch_step_items.text_code
,minimum_transfer_qty = p_batch_step_items.minimum_transfer_qty
,minimum_delay = p_batch_step_items.minimum_delay
,maximum_delay = p_batch_step_items.maximum_delay
--Rajesh Patangya DFF Enhancement 03Jan2008 Bug# 6195829
,ATTRIBUTE_CATEGORY = p_batch_step_items.ATTRIBUTE_CATEGORY
,ATTRIBUTE1 = p_batch_step_items.ATTRIBUTE1
,ATTRIBUTE2 = p_batch_step_items.ATTRIBUTE2
,ATTRIBUTE3 = p_batch_step_items.ATTRIBUTE3
,ATTRIBUTE4 = p_batch_step_items.ATTRIBUTE4
,ATTRIBUTE5 = p_batch_step_items.ATTRIBUTE5
,ATTRIBUTE6 = p_batch_step_items.ATTRIBUTE6
,ATTRIBUTE7 = p_batch_step_items.ATTRIBUTE7
,ATTRIBUTE8 = p_batch_step_items.ATTRIBUTE8
,ATTRIBUTE9 = p_batch_step_items.ATTRIBUTE9
,ATTRIBUTE10 = p_batch_step_items.ATTRIBUTE10
,ATTRIBUTE11 =p_batch_step_items.ATTRIBUTE11
,ATTRIBUTE12 =p_batch_step_items.ATTRIBUTE12
,ATTRIBUTE13 =p_batch_step_items.ATTRIBUTE13
,ATTRIBUTE14 =p_batch_step_items.ATTRIBUTE14
,ATTRIBUTE15 =p_batch_step_items.ATTRIBUTE15
,ATTRIBUTE16 = p_batch_step_items.ATTRIBUTE16
,ATTRIBUTE17 = p_batch_step_items.ATTRIBUTE17
,ATTRIBUTE18 = p_batch_step_items.ATTRIBUTE18
,ATTRIBUTE19 = p_batch_step_items.ATTRIBUTE19
,ATTRIBUTE20 = p_batch_step_items.ATTRIBUTE20
,ATTRIBUTE21 = p_batch_step_items.ATTRIBUTE21
,ATTRIBUTE22 = p_batch_step_items.ATTRIBUTE22
,ATTRIBUTE23 = p_batch_step_items.ATTRIBUTE23
,ATTRIBUTE24 = p_batch_step_items.ATTRIBUTE24
,ATTRIBUTE25 = p_batch_step_items.ATTRIBUTE25
,ATTRIBUTE26 = p_batch_step_items.ATTRIBUTE26
,ATTRIBUTE27 = p_batch_step_items.ATTRIBUTE27
,ATTRIBUTE28 = p_batch_step_items.ATTRIBUTE28
,ATTRIBUTE29 = p_batch_step_items.ATTRIBUTE29
,ATTRIBUTE30 = p_batch_step_items.ATTRIBUTE30
,last_update_login = gme_common_pvt.g_login_id
,last_update_date = gme_common_pvt.g_timestamp
,last_updated_by = gme_common_pvt.g_user_ident
WHERE material_detail_id = p_batch_step_items.material_detail_id
AND last_update_date = p_batch_step_items.last_update_date;
END update_row;
SELECT 1
INTO l_dummy
FROM gme_batch_step_items
WHERE material_detail_id = p_batch_step_items.material_detail_id
FOR UPDATE NOWAIT;