[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
SAFETY_ASSOCIATION_ID
,SOURCE_ID
,TARGET_REF_ID
,ASSOCIATION_TYPE
,ORGANIZATION_ID
,EFFECTIVE_FROM
,EFFECTIVE_TO
,ENABLED
,COMMENTS
,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
,CREATION_DATE
,CREATED_BY
INTO
l_safety_association_rec.SAFETY_ASSOCIATION_ID
,l_safety_association_rec.SOURCE_ID
,l_safety_association_rec.TARGET_REF_ID
,l_safety_association_rec.ASSOCIATION_TYPE
,l_safety_association_rec.ORGANIZATION_ID
,l_safety_association_rec.EFFECTIVE_FROM
,l_safety_association_rec.EFFECTIVE_TO
,l_safety_association_rec.ENABLED
,l_safety_association_rec.COMMENTS
,l_safety_association_rec.ATTRIBUTE_CATEGORY
,l_safety_association_rec.ATTRIBUTE1
,l_safety_association_rec.ATTRIBUTE2
,l_safety_association_rec.ATTRIBUTE3
,l_safety_association_rec.ATTRIBUTE4
,l_safety_association_rec.ATTRIBUTE5
,l_safety_association_rec.ATTRIBUTE6
,l_safety_association_rec.ATTRIBUTE7
,l_safety_association_rec.ATTRIBUTE8
,l_safety_association_rec.ATTRIBUTE9
,l_safety_association_rec.ATTRIBUTE10
,l_safety_association_rec.ATTRIBUTE11
,l_safety_association_rec.ATTRIBUTE12
,l_safety_association_rec.ATTRIBUTE13
,l_safety_association_rec.ATTRIBUTE14
,l_safety_association_rec.ATTRIBUTE15
,l_safety_association_rec.ATTRIBUTE16
,l_safety_association_rec.ATTRIBUTE17
,l_safety_association_rec.ATTRIBUTE18
,l_safety_association_rec.ATTRIBUTE19
,l_safety_association_rec.ATTRIBUTE20
,l_safety_association_rec.ATTRIBUTE21
,l_safety_association_rec.ATTRIBUTE22
,l_safety_association_rec.ATTRIBUTE23
,l_safety_association_rec.ATTRIBUTE24
,l_safety_association_rec.ATTRIBUTE25
,l_safety_association_rec.ATTRIBUTE26
,l_safety_association_rec.ATTRIBUTE27
,l_safety_association_rec.ATTRIBUTE28
,l_safety_association_rec.ATTRIBUTE28
,l_safety_association_rec.ATTRIBUTE30
,l_safety_association_rec.CREATION_DATE
,l_safety_association_rec.CREATED_BY
FROM EAM_SAFETY_ASSOCIATIONS esa
WHERE esa.SOURCE_ID = p_source_id
AND esa.organization_id = p_organization_id
AND esa.ASSOCIATION_TYPE = p_association_type;
* Procedure : INSERT_ SAFFETY_ASSOCIATION _ROW
* Purpose : Procedure will perfrom an insert into the table
*********************************************************************/
PROCEDURE INSERT_SAFFETY_ASSOCIATION_ROW
( p_safety_association_rec IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
, p_association_type IN NUMBER
, x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
, x_return_Status OUT NOCOPY VARCHAR2
)IS
-- l_organization_id NUMBER;
IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inserting Safety Association Row'); END IF;
INSERT INTO EAM_SAFETY_ASSOCIATIONS(
SAFETY_ASSOCIATION_ID
,SOURCE_ID
,TARGET_REF_ID
,ASSOCIATION_TYPE
,ORGANIZATION_ID
,EFFECTIVE_FROM
,EFFECTIVE_TO
,ENABLED
,COMMENTS
,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_association_rec.SAFETY_ASSOCIATION_ID
,p_safety_association_rec.SOURCE_ID
,p_safety_association_rec.TARGET_REF_ID
,p_safety_association_rec.ASSOCIATION_TYPE
,p_safety_association_rec.ORGANIZATION_ID
,p_safety_association_rec.EFFECTIVE_FROM
,p_safety_association_rec.EFFECTIVE_TO
,p_safety_association_rec.ENABLED
,p_safety_association_rec.COMMENTS
,p_safety_association_rec.ATTRIBUTE_CATEGORY
,p_safety_association_rec.ATTRIBUTE1
,p_safety_association_rec.ATTRIBUTE2
,p_safety_association_rec.ATTRIBUTE3
,p_safety_association_rec.ATTRIBUTE4
,p_safety_association_rec.ATTRIBUTE5
,p_safety_association_rec.ATTRIBUTE6
,p_safety_association_rec.ATTRIBUTE7
,p_safety_association_rec.ATTRIBUTE8
,p_safety_association_rec.ATTRIBUTE9
,p_safety_association_rec.ATTRIBUTE10
,p_safety_association_rec.ATTRIBUTE11
,p_safety_association_rec.ATTRIBUTE12
,p_safety_association_rec.ATTRIBUTE13
,p_safety_association_rec.ATTRIBUTE14
,p_safety_association_rec.ATTRIBUTE15
,p_safety_association_rec.ATTRIBUTE16
,p_safety_association_rec.ATTRIBUTE17
,p_safety_association_rec.ATTRIBUTE18
,p_safety_association_rec.ATTRIBUTE19
,p_safety_association_rec.ATTRIBUTE20
,p_safety_association_rec.ATTRIBUTE21
,p_safety_association_rec.ATTRIBUTE22
,p_safety_association_rec.ATTRIBUTE23
,p_safety_association_rec.ATTRIBUTE24
,p_safety_association_rec.ATTRIBUTE25
,p_safety_association_rec.ATTRIBUTE26
,p_safety_association_rec.ATTRIBUTE27
,p_safety_association_rec.ATTRIBUTE28
,p_safety_association_rec.ATTRIBUTE29
,p_safety_association_rec.ATTRIBUTE30
,SYSDATE
,FND_GLOBAL.user_id
,SYSDATE
,FND_GLOBAL.user_id
,FND_GLOBAL.login_id);
END INSERT_SAFFETY_ASSOCIATION_ROW;
* Procedure : UPDATE_ SAFFETY_ASSOCIATION _ROW
* Purpose : Procedure will perform an update on the table
*********************************************************************/
PROCEDURE UPDATE_SAFFETY_ASSOCIATION_ROW
( p_safety_association_rec IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
, p_association_type IN NUMBER
, 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 Safety Association Row'); END IF;
UPDATE EAM_SAFETY_ASSOCIATIONS
SET
TARGET_REF_ID =p_safety_association_rec.TARGET_REF_ID
,ASSOCIATION_TYPE =p_safety_association_rec.ASSOCIATION_TYPE
,COMMENTS =p_safety_association_rec.COMMENTS
,EFFECTIVE_FROM =p_safety_association_rec.EFFECTIVE_FROM
,EFFECTIVE_TO =p_safety_association_rec.EFFECTIVE_TO
,ATTRIBUTE_CATEGORY =p_safety_association_rec.ATTRIBUTE_CATEGORY
,ATTRIBUTE1 =p_safety_association_rec.ATTRIBUTE1
,ATTRIBUTE2 =p_safety_association_rec.ATTRIBUTE2
,ATTRIBUTE3 =p_safety_association_rec.ATTRIBUTE3
,ATTRIBUTE4 =p_safety_association_rec.ATTRIBUTE4
,ATTRIBUTE5 =p_safety_association_rec.ATTRIBUTE5
,ATTRIBUTE6 =p_safety_association_rec.ATTRIBUTE6
,ATTRIBUTE7 =p_safety_association_rec.ATTRIBUTE7
,ATTRIBUTE8 =p_safety_association_rec.ATTRIBUTE8
,ATTRIBUTE9 =p_safety_association_rec.ATTRIBUTE9
,ATTRIBUTE10 =p_safety_association_rec.ATTRIBUTE10
,ATTRIBUTE11 =p_safety_association_rec.ATTRIBUTE11
,ATTRIBUTE12 =p_safety_association_rec.ATTRIBUTE12
,ATTRIBUTE13 =p_safety_association_rec.ATTRIBUTE13
,ATTRIBUTE14 =p_safety_association_rec.ATTRIBUTE14
,ATTRIBUTE15 =p_safety_association_rec.ATTRIBUTE15
,ATTRIBUTE16 =p_safety_association_rec.ATTRIBUTE16
,ATTRIBUTE17 =p_safety_association_rec.ATTRIBUTE17
,ATTRIBUTE18 =p_safety_association_rec.ATTRIBUTE18
,ATTRIBUTE19 =p_safety_association_rec.ATTRIBUTE19
,ATTRIBUTE20 =p_safety_association_rec.ATTRIBUTE20
,ATTRIBUTE21 =p_safety_association_rec.ATTRIBUTE21
,ATTRIBUTE22 =p_safety_association_rec.ATTRIBUTE22
,ATTRIBUTE23 =p_safety_association_rec.ATTRIBUTE23
,ATTRIBUTE24 =p_safety_association_rec.ATTRIBUTE24
,ATTRIBUTE25 =p_safety_association_rec.ATTRIBUTE25
,ATTRIBUTE26 =p_safety_association_rec.ATTRIBUTE26
,ATTRIBUTE27 =p_safety_association_rec.ATTRIBUTE27
,ATTRIBUTE28 =p_safety_association_rec.ATTRIBUTE28
,ATTRIBUTE29 =p_safety_association_rec.ATTRIBUTE29
,ATTRIBUTE30 =p_safety_association_rec.ATTRIBUTE30
,LAST_UPDATE_DATE =SYSDATE
,LAST_UPDATED_BY =FND_GLOBAL.user_id
,LAST_UPDATE_LOGIN =FND_GLOBAL.login_id
WHERE SAFETY_ASSOCIATION_ID=p_safety_association_rec.SAFETY_ASSOCIATION_ID
AND ASSOCIATION_TYPE=p_safety_association_rec.ASSOCIATION_TYPE;
END UPDATE_SAFFETY_ASSOCIATION_ROW;
* Procedure : DELETE SAFFETY_ASSOCIATION _ROW
* Purpose : This will perform delete on the table
*********************************************************************/
PROCEDURE DELETE_SAFFETY_ASSOCIATION_ROW
( p_safety_association_rec IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
, p_association_type IN NUMBER
, 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 Safety Association Row'); END IF;
FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS(
X_entity_name => 'EAM_SAFETY_ASSOC',
X_pk1_value => p_safety_association_rec.ORGANIZATION_ID,
X_pk2_value => p_safety_association_rec.SOURCE_ID,
X_pk3_value => p_safety_association_rec.TARGET_REF_ID,
X_pk4_value => p_safety_association_rec.ASSOCIATION_TYPE,
X_pk5_value => null,
X_delete_document_flag => 'Y'
);
DELETE FROM EAM_SAFETY_ASSOCIATIONS
WHERE SAFETY_ASSOCIATION_ID =p_safety_association_rec.SAFETY_ASSOCIATION_ID
AND ASSOCIATION_TYPE = p_association_type;
END DELETE_SAFFETY_ASSOCIATION_ROW;
INSERT_SAFFETY_ASSOCIATION_ROW
( p_safety_association_rec => p_safety_association_rec
, p_association_type => p_association_type
, x_mesg_token_Tbl => x_mesg_token_Tbl
, x_return_Status => l_return_status
);
ELSIF p_safety_association_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE
THEN
UPDATE_SAFFETY_ASSOCIATION_ROW
( p_safety_association_rec => p_safety_association_rec
, p_association_type => p_association_type
, x_mesg_token_Tbl => x_mesg_token_Tbl
, x_return_Status => l_return_status
);
ELSIF p_safety_association_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE
THEN
DELETE_SAFFETY_ASSOCIATION_ROW
( p_safety_association_rec => p_safety_association_rec
, p_association_type => p_association_type
, x_mesg_token_Tbl => x_mesg_token_Tbl
, x_return_Status => l_return_status
);