The following lines contain the word 'select', 'insert', 'update' or 'delete':
CURSOR c IS SELECT ROWID
FROM JTF_BRM_WF_ATTR_VALUES
WHERE WF_ATTR_VALUE_ID = l_wf_attr_value_id;
SELECT jtf_brm_wf_attr_values_s.NEXTVAL INTO l_wf_attr_value_id
FROM DUAL;
INSERT INTO JTF_BRM_WF_ATTR_VALUES
( WF_ATTR_VALUE_ID
, PROCESS_ID
, WF_ITEM_TYPE
, WF_ACTIVITY_NAME
, WF_ACTIVITY_VERSION
, WF_ACTIVITY_ATTRIBUTE_NAME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TEXT_VALUE
, NUMBER_VALUE
, DATE_VALUE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
, APPLICATION_ID
) VALUES
( l_wf_attr_value_id
, p_bwa_rec.PROCESS_ID
, p_bwa_rec.WF_ITEM_TYPE
, p_bwa_rec.WF_ACTIVITY_NAME
, p_bwa_rec.WF_ACTIVITY_VERSION
, p_bwa_rec.WF_ACTIVITY_ATTRIBUTE_NAME
, p_bwa_rec.CREATED_BY
, p_bwa_rec.CREATION_DATE
, p_bwa_rec.LAST_UPDATED_BY
, p_bwa_rec.LAST_UPDATE_DATE
, p_bwa_rec.LAST_UPDATE_LOGIN
, p_bwa_rec.TEXT_VALUE
, p_bwa_rec.NUMBER_VALUE
, p_bwa_rec.DATE_VALUE
, p_bwa_rec.ATTRIBUTE1
, p_bwa_rec.ATTRIBUTE2
, p_bwa_rec.ATTRIBUTE3
, p_bwa_rec.ATTRIBUTE4
, p_bwa_rec.ATTRIBUTE5
, p_bwa_rec.ATTRIBUTE6
, p_bwa_rec.ATTRIBUTE7
, p_bwa_rec.ATTRIBUTE8
, p_bwa_rec.ATTRIBUTE9
, p_bwa_rec.ATTRIBUTE10
, p_bwa_rec.ATTRIBUTE11
, p_bwa_rec.ATTRIBUTE12
, p_bwa_rec.ATTRIBUTE13
, p_bwa_rec.ATTRIBUTE14
, p_bwa_rec.ATTRIBUTE15
, p_bwa_rec.ATTRIBUTE_CATEGORY
, p_bwa_rec.SECURITY_GROUP_ID
, l_object_version_number
, p_bwa_rec.APPLICATION_ID
);
PROCEDURE Update_WFAttrValue
( p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
, p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
, p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_bwa_rec IN brm_wf_attr_value_rec_type
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_WFAttrValue';
SAVEPOINT Update_WFAttrValue_PVT;
SELECT JTF_BRM_OBJECT_VERSION_S.NEXTVAL
INTO l_object_version_number
FROM DUAL;
UPDATE JTF_BRM_WF_ATTR_VALUES
SET PROCESS_ID = p_bwa_rec.PROCESS_ID
, WF_ITEM_TYPE = p_bwa_rec.WF_ITEM_TYPE
, WF_ACTIVITY_NAME = p_bwa_rec.WF_ACTIVITY_NAME
, WF_ACTIVITY_VERSION = p_bwa_rec.WF_ACTIVITY_VERSION
, WF_ACTIVITY_ATTRIBUTE_NAME = p_bwa_rec.WF_ACTIVITY_ATTRIBUTE_NAME
, LAST_UPDATED_BY = p_bwa_rec.LAST_UPDATED_BY
, LAST_UPDATE_DATE = p_bwa_rec.LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN = p_bwa_rec.LAST_UPDATE_LOGIN
, TEXT_VALUE = p_bwa_rec.TEXT_VALUE
, NUMBER_VALUE = p_bwa_rec.NUMBER_VALUE
, DATE_VALUE = p_bwa_rec.DATE_VALUE
, ATTRIBUTE1 = p_bwa_rec.ATTRIBUTE1
, ATTRIBUTE2 = p_bwa_rec.ATTRIBUTE2
, ATTRIBUTE3 = p_bwa_rec.ATTRIBUTE3
, ATTRIBUTE4 = p_bwa_rec.ATTRIBUTE4
, ATTRIBUTE5 = p_bwa_rec.ATTRIBUTE5
, ATTRIBUTE6 = p_bwa_rec.ATTRIBUTE6
, ATTRIBUTE7 = p_bwa_rec.ATTRIBUTE7
, ATTRIBUTE8 = p_bwa_rec.ATTRIBUTE8
, ATTRIBUTE9 = p_bwa_rec.ATTRIBUTE9
, ATTRIBUTE10 = p_bwa_rec.ATTRIBUTE10
, ATTRIBUTE11 = p_bwa_rec.ATTRIBUTE11
, ATTRIBUTE12 = p_bwa_rec.ATTRIBUTE12
, ATTRIBUTE13 = p_bwa_rec.ATTRIBUTE13
, ATTRIBUTE14 = p_bwa_rec.ATTRIBUTE14
, ATTRIBUTE15 = p_bwa_rec.ATTRIBUTE15
, ATTRIBUTE_CATEGORY = p_bwa_rec.ATTRIBUTE_CATEGORY
, SECURITY_GROUP_ID = p_bwa_rec.SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER = l_object_version_number
, APPLICATION_ID = p_bwa_rec.APPLICATION_ID
WHERE WF_ATTR_VALUE_ID = p_bwa_rec.WF_ATTR_VALUE_ID;
ROLLBACK TO Update_WFAttrValue_PVT;
ROLLBACK TO Update_WFAttrValue_PVT;
ROLLBACK TO Update_WFAttrValue_PVT;
END Update_WFAttrValue;
PROCEDURE Delete_WFAttrValue
( p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
, p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
, p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_wf_attr_value_id IN NUMBER
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Delete_WFAttrValue';
SAVEPOINT Delete_WFAttrValue_PVT;
DELETE FROM JTF_BRM_WF_ATTR_VALUES
WHERE WF_ATTR_VALUE_ID = p_wf_attr_value_id;
ROLLBACK TO Delete_WFAttrValue_PVT;
ROLLBACK TO Delete_WFAttrValue_PVT;
ROLLBACK TO Delete_WFAttrValue_PVT;
END Delete_WFAttrValue;