The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
wip_entity_id
, organization_id
, prior_operation
, next_operation
, attribute_category
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
INTO
l_eam_op_network_rec.wip_entity_id
, l_eam_op_network_rec.organization_id
, l_eam_op_network_rec.prior_operation
, l_eam_op_network_rec.next_operation
, l_eam_op_network_rec.attribute_category
, l_eam_op_network_rec.attribute1
, l_eam_op_network_rec.attribute2
, l_eam_op_network_rec.attribute3
, l_eam_op_network_rec.attribute4
, l_eam_op_network_rec.attribute5
, l_eam_op_network_rec.attribute6
, l_eam_op_network_rec.attribute7
, l_eam_op_network_rec.attribute8
, l_eam_op_network_rec.attribute9
, l_eam_op_network_rec.attribute10
, l_eam_op_network_rec.attribute11
, l_eam_op_network_rec.attribute12
, l_eam_op_network_rec.attribute13
, l_eam_op_network_rec.attribute14
, l_eam_op_network_rec.attribute15
FROM wip_operation_networks won
WHERE won.wip_entity_id = p_wip_entity_id
AND won.organization_id = p_organization_id
AND won.prior_operation = p_prior_operation
AND won.next_operation = p_next_operation;
* Procedure : Insert_Row
* Parameters IN : Operation Networks column record
* Parameters OUT NOCOPY: Message Token Table
* Return Status
* Purpose : Procedure will perfrom an insert into the
* wip_operation_networks table.
*********************************************************************/
PROCEDURE Insert_Row
( p_eam_op_network_rec IN EAM_PROCESS_WO_PUB.eam_op_network_rec_type
, x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
, x_return_Status OUT NOCOPY VARCHAR2
)
IS
BEGIN
IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Operation Networks rec for ' || p_eam_op_network_rec.prior_operation); END IF;
INSERT INTO WIP_OPERATION_NETWORKS
( wip_entity_id
, organization_id
, prior_operation
, next_operation
, attribute_category
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
)
VALUES
( p_eam_op_network_rec.wip_entity_id
, p_eam_op_network_rec.organization_id
, p_eam_op_network_rec.prior_operation
, p_eam_op_network_rec.next_operation
, p_eam_op_network_rec.attribute_category
, p_eam_op_network_rec.attribute1
, p_eam_op_network_rec.attribute2
, p_eam_op_network_rec.attribute3
, p_eam_op_network_rec.attribute4
, p_eam_op_network_rec.attribute5
, p_eam_op_network_rec.attribute6
, p_eam_op_network_rec.attribute7
, p_eam_op_network_rec.attribute8
, p_eam_op_network_rec.attribute9
, p_eam_op_network_rec.attribute10
, p_eam_op_network_rec.attribute11
, p_eam_op_network_rec.attribute12
, p_eam_op_network_rec.attribute13
, p_eam_op_network_rec.attribute14
, p_eam_op_network_rec.attribute15
, SYSDATE
, FND_GLOBAL.user_id
, SYSDATE
, FND_GLOBAL.user_id
, FND_GLOBAL.login_id
);
, p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
, x_mesg_token_Tbl => x_mesg_token_tbl
);
END Insert_Row;
* Procedure : Update_Row
* Parameters IN : Operation Networks column record
* Parameters OUT NOCOPY: Message Token Table
* Return Status
* Purpose : Procedure will perfrom an Update on the
* wip_operation_networks table.
*********************************************************************/
PROCEDURE Update_Row
( p_eam_op_network_rec IN EAM_PROCESS_WO_PUB.eam_op_network_rec_type
, x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
, x_return_Status OUT NOCOPY VARCHAR2
)
IS
BEGIN
IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Operation Networks '|| p_eam_op_network_rec.prior_operation); END IF;
UPDATE WIP_OPERATION_NETWORKS
SET prior_operation = p_eam_op_network_rec.prior_operation
, next_operation = p_eam_op_network_rec.next_operation
, attribute_category = p_eam_op_network_rec.attribute_category
, attribute1 = p_eam_op_network_rec.attribute1
, attribute2 = p_eam_op_network_rec.attribute2
, attribute3 = p_eam_op_network_rec.attribute3
, attribute4 = p_eam_op_network_rec.attribute4
, attribute5 = p_eam_op_network_rec.attribute5
, attribute6 = p_eam_op_network_rec.attribute6
, attribute7 = p_eam_op_network_rec.attribute7
, attribute8 = p_eam_op_network_rec.attribute8
, attribute9 = p_eam_op_network_rec.attribute9
, attribute10 = p_eam_op_network_rec.attribute10
, attribute11 = p_eam_op_network_rec.attribute11
, attribute12 = p_eam_op_network_rec.attribute12
, attribute13 = p_eam_op_network_rec.attribute13
, attribute14 = p_eam_op_network_rec.attribute14
, attribute15 = p_eam_op_network_rec.attribute15
, last_update_date = SYSDATE
, last_updated_by = FND_GLOBAL.user_id
, last_update_login = FND_GLOBAL.login_id
WHERE organization_id = p_eam_op_network_rec.organization_id
AND wip_entity_id = p_eam_op_network_rec.wip_entity_id
AND prior_operation = p_eam_op_network_rec.prior_operation;
END Update_Row;
* Procedure : Delete_Row
* Parameters IN : Operation Networks column record
* Parameters OUT NOCOPY: Message Token Table
* Return Status
* Purpose : Procedure will perfrom an Delete on the
* wip_operation_networks table.
*********************************************************************/
PROCEDURE Delete_Row
( p_eam_op_network_rec IN EAM_PROCESS_WO_PUB.eam_op_network_rec_type
, x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
, x_return_Status OUT NOCOPY VARCHAR2
)
IS
BEGIN
IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Operation Networks '|| p_eam_op_network_rec.prior_operation); END IF;
DELETE FROM WIP_OPERATION_NETWORKS
WHERE organization_id = p_eam_op_network_rec.organization_id
AND wip_entity_id = p_eam_op_network_rec.wip_entity_id
AND prior_operation = p_eam_op_network_rec.prior_operation
AND next_operation = p_eam_op_network_rec.next_operation;
END Delete_Row;
Insert_Row
( p_eam_op_network_rec => p_eam_op_network_rec
, x_mesg_token_Tbl => l_mesg_token_tbl
, x_return_Status => l_return_status
);
ELSIF p_eam_op_network_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE
THEN
Update_Row
( p_eam_op_network_rec => p_eam_op_network_rec
, x_mesg_token_Tbl => l_mesg_token_tbl
, x_return_Status => l_return_status
);
ELSIF p_eam_op_network_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE
THEN
Delete_Row
( p_eam_op_network_rec => p_eam_op_network_rec
, x_mesg_token_Tbl => l_mesg_token_tbl
, x_return_Status => l_return_status
);