The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
iso.establishment_id
,iso.establishment_source
,iso.establishment_source_id
,iso.sequence_type
,iso.sequence_number
,iso.description
,iso.organization_id
,iso.maintenance_object_id
,iso.resource_id
,iso.dept_id
,iso.res_instance_id
,iso.completion_date
,iso.safety_tag
,iso.tag_position
,iso.lockout_device
,iso.lock_number
,iso.ATTRIBUTE_CATEGORY
,iso.ATTRIBUTE1
,iso.ATTRIBUTE2
,iso.ATTRIBUTE3
,iso.ATTRIBUTE4
,iso.ATTRIBUTE5
,iso.ATTRIBUTE6
,iso.ATTRIBUTE7
,iso.ATTRIBUTE8
,iso.ATTRIBUTE9
,iso.ATTRIBUTE10
,iso.ATTRIBUTE11
,iso.ATTRIBUTE12
,iso.ATTRIBUTE13
,iso.ATTRIBUTE14
,iso.ATTRIBUTE15
,iso.ATTRIBUTE16
,iso.ATTRIBUTE17
,iso.ATTRIBUTE18
,iso.ATTRIBUTE19
,iso.ATTRIBUTE20
,iso.ATTRIBUTE21
,iso.ATTRIBUTE22
,iso.ATTRIBUTE23
,iso.ATTRIBUTE24
,iso.ATTRIBUTE25
,iso.ATTRIBUTE26
,iso.ATTRIBUTE27
,iso.ATTRIBUTE28
,iso.ATTRIBUTE29
,iso.ATTRIBUTE30
,iso.CREATION_DATE
,iso.CREATED_BY
INTO
l_safety_establishment_rec.establishment_id
,l_safety_establishment_rec.establishment_source
,l_safety_establishment_rec.establishment_source_id
,l_safety_establishment_rec.sequence_type
,l_safety_establishment_rec.sequence_number
,l_safety_establishment_rec.description
,l_safety_establishment_rec.organization_id
,l_safety_establishment_rec.maintenance_object_id
,l_safety_establishment_rec.resource_id
,l_safety_establishment_rec.dept_id
,l_safety_establishment_rec.res_instance_id
,l_safety_establishment_rec.completion_date
,l_safety_establishment_rec.safety_tag
,l_safety_establishment_rec.tag_position
,l_safety_establishment_rec.lockout_device
,l_safety_establishment_rec.lock_number
,l_safety_establishment_rec.ATTRIBUTE_CATEGORY
,l_safety_establishment_rec.ATTRIBUTE1
,l_safety_establishment_rec.ATTRIBUTE2
,l_safety_establishment_rec.ATTRIBUTE3
,l_safety_establishment_rec.ATTRIBUTE4
,l_safety_establishment_rec.ATTRIBUTE5
,l_safety_establishment_rec.ATTRIBUTE6
,l_safety_establishment_rec.ATTRIBUTE7
,l_safety_establishment_rec.ATTRIBUTE8
,l_safety_establishment_rec.ATTRIBUTE9
,l_safety_establishment_rec.ATTRIBUTE10
,l_safety_establishment_rec.ATTRIBUTE11
,l_safety_establishment_rec.ATTRIBUTE12
,l_safety_establishment_rec.ATTRIBUTE13
,l_safety_establishment_rec.ATTRIBUTE14
,l_safety_establishment_rec.ATTRIBUTE15
,l_safety_establishment_rec.ATTRIBUTE16
,l_safety_establishment_rec.ATTRIBUTE17
,l_safety_establishment_rec.ATTRIBUTE18
,l_safety_establishment_rec.ATTRIBUTE19
,l_safety_establishment_rec.ATTRIBUTE20
,l_safety_establishment_rec.ATTRIBUTE21
,l_safety_establishment_rec.ATTRIBUTE22
,l_safety_establishment_rec.ATTRIBUTE23
,l_safety_establishment_rec.ATTRIBUTE24
,l_safety_establishment_rec.ATTRIBUTE25
,l_safety_establishment_rec.ATTRIBUTE26
,l_safety_establishment_rec.ATTRIBUTE27
,l_safety_establishment_rec.ATTRIBUTE28
,l_safety_establishment_rec.ATTRIBUTE29
,l_safety_establishment_rec.ATTRIBUTE30
,l_safety_establishment_rec.CREATION_DATE
,l_safety_establishment_rec.CREATED_BY
FROM EAM_ESTABLISHMENT_DETAILS iso
WHERE iso.establishment_id = p_establishment_id
AND iso.organization_id = p_organization_id;
* Procedure : INSERT_ROW
* Purpose : Procedure will perfrom an insert into the table
*********************************************************************/
PROCEDURE INSERT_ROW
( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_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 Isolation Establishment record for ' || p_safety_establishment_rec.establishment_id); END IF;
INSERT INTO EAM_ESTABLISHMENT_DETAILS(
establishment_id
,establishment_source
,establishment_source_id
,sequence_type
,sequence_number
,description
,organization_id
,maintenance_object_id
,resource_id
,dept_id
,res_instance_id
,completion_date
,safety_tag
,tag_position
,lockout_device
,lock_number
,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_DATE
,LAST_UPDATED_BY
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_LOGIN)
VALUES
(
p_safety_establishment_rec.establishment_id
,p_safety_establishment_rec.establishment_source
,p_safety_establishment_rec.establishment_source_id
,p_safety_establishment_rec.sequence_type
,p_safety_establishment_rec.sequence_number
,p_safety_establishment_rec.description
,p_safety_establishment_rec.organization_id
,p_safety_establishment_rec.maintenance_object_id
,p_safety_establishment_rec.resource_id
,p_safety_establishment_rec.dept_id
,p_safety_establishment_rec.res_instance_id
,p_safety_establishment_rec.completion_date
,p_safety_establishment_rec.safety_tag
,p_safety_establishment_rec.tag_position
,p_safety_establishment_rec.lockout_device
,p_safety_establishment_rec.lock_number
,p_safety_establishment_rec.ATTRIBUTE_CATEGORY
,p_safety_establishment_rec.ATTRIBUTE1
,p_safety_establishment_rec.ATTRIBUTE2
,p_safety_establishment_rec.ATTRIBUTE3
,p_safety_establishment_rec.ATTRIBUTE4
,p_safety_establishment_rec.ATTRIBUTE5
,p_safety_establishment_rec.ATTRIBUTE6
,p_safety_establishment_rec.ATTRIBUTE7
,p_safety_establishment_rec.ATTRIBUTE8
,p_safety_establishment_rec.ATTRIBUTE9
,p_safety_establishment_rec.ATTRIBUTE10
,p_safety_establishment_rec.ATTRIBUTE11
,p_safety_establishment_rec.ATTRIBUTE12
,p_safety_establishment_rec.ATTRIBUTE13
,p_safety_establishment_rec.ATTRIBUTE14
,p_safety_establishment_rec.ATTRIBUTE15
,p_safety_establishment_rec.ATTRIBUTE16
,p_safety_establishment_rec.ATTRIBUTE17
,p_safety_establishment_rec.ATTRIBUTE18
,p_safety_establishment_rec.ATTRIBUTE19
,p_safety_establishment_rec.ATTRIBUTE20
,p_safety_establishment_rec.ATTRIBUTE21
,p_safety_establishment_rec.ATTRIBUTE22
,p_safety_establishment_rec.ATTRIBUTE23
,p_safety_establishment_rec.ATTRIBUTE24
,p_safety_establishment_rec.ATTRIBUTE25
,p_safety_establishment_rec.ATTRIBUTE26
,p_safety_establishment_rec.ATTRIBUTE27
,p_safety_establishment_rec.ATTRIBUTE28
,p_safety_establishment_rec.ATTRIBUTE29
,p_safety_establishment_rec.ATTRIBUTE30
,SYSDATE
,FND_GLOBAL.user_id
,SYSDATE
,FND_GLOBAL.user_id
,FND_GLOBAL.login_id);
END INSERT_ROW;
* Procedure : UPDATE_ROW
* Purpose : Procedure will perform an update on the table
*********************************************************************/
PROCEDURE UPDATE_ROW
( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_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 Isolation establishment rec for ' || p_safety_establishment_rec.establishment_id); END IF;
UPDATE EAM_ESTABLISHMENT_DETAILS
SET
establishment_source =p_safety_establishment_rec.establishment_source
,establishment_source_id =p_safety_establishment_rec.establishment_source_id
,sequence_type =p_safety_establishment_rec.sequence_type
,sequence_number =p_safety_establishment_rec.sequence_number
,description =p_safety_establishment_rec.description
,organization_id =p_safety_establishment_rec.organization_id
,maintenance_object_id =p_safety_establishment_rec.maintenance_object_id
,resource_id =p_safety_establishment_rec.resource_id
,dept_id =p_safety_establishment_rec.dept_id
,res_instance_id =p_safety_establishment_rec.res_instance_id
,completion_date =p_safety_establishment_rec.completion_date
,safety_tag =p_safety_establishment_rec.safety_tag
,tag_position =p_safety_establishment_rec.tag_position
,lockout_device =p_safety_establishment_rec.lockout_device
,lock_number =p_safety_establishment_rec.lock_number
,ATTRIBUTE_CATEGORY =p_safety_establishment_rec.ATTRIBUTE_CATEGORY
,ATTRIBUTE1 =p_safety_establishment_rec.ATTRIBUTE1
,ATTRIBUTE2 =p_safety_establishment_rec.ATTRIBUTE2
,ATTRIBUTE3 =p_safety_establishment_rec.ATTRIBUTE3
,ATTRIBUTE4 =p_safety_establishment_rec.ATTRIBUTE4
,ATTRIBUTE5 =p_safety_establishment_rec.ATTRIBUTE5
,ATTRIBUTE6 =p_safety_establishment_rec.ATTRIBUTE6
,ATTRIBUTE7 =p_safety_establishment_rec.ATTRIBUTE7
,ATTRIBUTE8 =p_safety_establishment_rec.ATTRIBUTE8
,ATTRIBUTE9 =p_safety_establishment_rec.ATTRIBUTE9
,ATTRIBUTE10 =p_safety_establishment_rec.ATTRIBUTE10
,ATTRIBUTE11 =p_safety_establishment_rec.ATTRIBUTE11
,ATTRIBUTE12 =p_safety_establishment_rec.ATTRIBUTE12
,ATTRIBUTE13 =p_safety_establishment_rec.ATTRIBUTE13
,ATTRIBUTE14 =p_safety_establishment_rec.ATTRIBUTE14
,ATTRIBUTE15 =p_safety_establishment_rec.ATTRIBUTE15
,ATTRIBUTE16 =p_safety_establishment_rec.ATTRIBUTE16
,ATTRIBUTE17 =p_safety_establishment_rec.ATTRIBUTE17
,ATTRIBUTE18 =p_safety_establishment_rec.ATTRIBUTE18
,ATTRIBUTE19 =p_safety_establishment_rec.ATTRIBUTE19
,ATTRIBUTE20 =p_safety_establishment_rec.ATTRIBUTE20
,ATTRIBUTE21 =p_safety_establishment_rec.ATTRIBUTE21
,ATTRIBUTE22 =p_safety_establishment_rec.ATTRIBUTE22
,ATTRIBUTE23 =p_safety_establishment_rec.ATTRIBUTE23
,ATTRIBUTE24 =p_safety_establishment_rec.ATTRIBUTE24
,ATTRIBUTE25 =p_safety_establishment_rec.ATTRIBUTE25
,ATTRIBUTE26 =p_safety_establishment_rec.ATTRIBUTE26
,ATTRIBUTE27 =p_safety_establishment_rec.ATTRIBUTE27
,ATTRIBUTE28 =p_safety_establishment_rec.ATTRIBUTE28
,ATTRIBUTE29 =p_safety_establishment_rec.ATTRIBUTE29
,ATTRIBUTE30 =p_safety_establishment_rec.ATTRIBUTE30
,LAST_UPDATE_DATE =SYSDATE
,LAST_UPDATED_BY =FND_GLOBAL.user_id
,LAST_UPDATE_LOGIN =FND_GLOBAL.login_id
WHERE establishment_id = p_safety_establishment_rec.establishment_id
AND organization_id = p_safety_establishment_rec.organization_id;
END UPDATE_ROW;
* Procedure : DELETE_ROW
* Purpose : Procedure will perform a delete on the table
*********************************************************************/
PROCEDURE DELETE_ROW
( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type
, p_organization_id IN NUMBER
, x_return_Status OUT NOCOPY VARCHAR2
) IS
BEGIN
IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deletiing establishment details ' ); END IF;
DELETE FROM EAM_ESTABLISHMENT_DETAILS
WHERE establishment_id =p_safety_establishment_rec.establishment_id
AND organization_id = p_organization_id;
END DELETE_ROW;
Insert_Row
( p_safety_establishment_rec => p_safety_establishment_rec
, x_return_Status => l_return_status
);
ELSIF p_safety_establishment_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE
THEN
Update_Row
( p_safety_establishment_rec => p_safety_establishment_rec
, x_mesg_token_Tbl => x_mesg_token_Tbl
, x_return_Status => l_return_status
);
ELSIF p_safety_establishment_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE
THEN
DELETE_ROW
( p_safety_establishment_rec => p_safety_establishment_rec
, p_organization_id => p_safety_establishment_rec.ORGANIZATION_ID
, x_return_Status => l_return_status
);