The following lines contain the word 'select', 'insert', 'update' or 'delete':
Cursor c2 is SELECT IEX_CASE_OBJECTS_S.nextval from dual;
IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.Insert_Row');
IEX_CASE_OBJECTS_PKG.Insert_Row(
x_rowid =>v_rowid,
x_CASE_OBJECT_ID => v_CASE_OBJECT_ID,
x_OBJECT_ID => p_case_object_rec.OBJECT_ID,
x_OBJECT_CODE => p_case_object_rec.OBJECT_CODE,
x_active_flag => v_active_flag,
x_OBJECT_VERSION_NUMBER => v_OBJECT_VERSION_NUMBER,
x_CAS_ID => p_case_object_rec.CAS_ID,
x_REQUEST_ID => p_case_object_rec.REQUEST_ID,
x_PROGRAM_APPLICATION_ID => p_case_object_rec.PROGRAM_APPLICATION_ID,
x_PROGRAM_ID => p_case_object_rec.PROGRAM_ID,
x_PROGRAM_UPDATE_DATE => p_case_object_rec.PROGRAM_UPDATE_DATE,
x_ATTRIBUTE_CATEGORY => p_case_object_rec.ATTRIBUTE_CATEGORY,
x_ATTRIBUTE1 => p_case_object_rec.ATTRIBUTE1,
x_ATTRIBUTE2 => p_case_object_rec.ATTRIBUTE2,
x_ATTRIBUTE3 => p_case_object_rec.ATTRIBUTE3,
x_ATTRIBUTE4 => p_case_object_rec.ATTRIBUTE4,
x_ATTRIBUTE5 => p_case_object_rec.ATTRIBUTE5,
x_ATTRIBUTE6 => p_case_object_rec.ATTRIBUTE6,
x_ATTRIBUTE7 => p_case_object_rec.ATTRIBUTE7,
x_ATTRIBUTE8 => p_case_object_rec.ATTRIBUTE8,
x_ATTRIBUTE9 => p_case_object_rec.ATTRIBUTE9,
x_ATTRIBUTE10 => p_case_object_rec.ATTRIBUTE10,
x_ATTRIBUTE11 => p_case_object_rec.ATTRIBUTE11,
x_ATTRIBUTE12 => p_case_object_rec.ATTRIBUTE12,
x_ATTRIBUTE13 => p_case_object_rec.ATTRIBUTE13,
x_ATTRIBUTE14 => p_case_object_rec.ATTRIBUTE14,
x_ATTRIBUTE15 => p_case_object_rec.ATTRIBUTE15,
x_CREATED_BY => FND_GLOBAL.USER_ID,
x_CREATION_DATE => SYSDATE,
x_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
x_LAST_UPDATE_DATE => SYSDATE,
x_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'After Calling IEX_CASE_OBJECTS_PKG.Insert_Row and case objectid => '||x_CASE_OBJECT_ID);
PROCEDURE Update_case_objects(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
P_case_object_Rec IN case_object_Rec_Type,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2,
XO_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CASE_OBJECTS';
IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_OBJECTS_PVT.update_case_objects ******** ');
SAVEPOINT UPDATE_case_objects_PVT;
IEX_DEBUG_PUB.LogMessage('Update_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.lock_row');
IEX_DEBUG_PUB.LogMessage('Update_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.update_row');
IEX_CASE_OBJECTS_PKG.Update_Row(
x_CASE_OBJECT_ID => p_case_object_rec.CASE_OBJECT_ID,
x_OBJECT_ID => p_case_object_rec.OBJECT_ID,
x_OBJECT_CODE => p_case_object_rec.OBJECT_CODE,
x_ACTIVE_FLAG => p_case_object_rec.ACTIVE_FLAG,
x_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER +1,
x_CAS_ID => p_case_object_rec.CAS_ID,
x_REQUEST_ID => p_case_object_rec.REQUEST_ID,
x_PROGRAM_APPLICATION_ID => p_case_object_rec.PROGRAM_APPLICATION_ID,
x_PROGRAM_ID => p_case_object_rec.PROGRAM_ID,
x_PROGRAM_UPDATE_DATE => p_case_object_rec.PROGRAM_UPDATE_DATE,
x_ATTRIBUTE_CATEGORY => p_case_object_rec.ATTRIBUTE_CATEGORY,
x_ATTRIBUTE1 => p_case_object_rec.ATTRIBUTE1,
x_ATTRIBUTE2 => p_case_object_rec.ATTRIBUTE2,
x_ATTRIBUTE3 => p_case_object_rec.ATTRIBUTE3,
x_ATTRIBUTE4 => p_case_object_rec.ATTRIBUTE4,
x_ATTRIBUTE5 => p_case_object_rec.ATTRIBUTE5,
x_ATTRIBUTE6 => p_case_object_rec.ATTRIBUTE6,
x_ATTRIBUTE7 => p_case_object_rec.ATTRIBUTE7,
x_ATTRIBUTE8 => p_case_object_rec.ATTRIBUTE8,
x_ATTRIBUTE9 => p_case_object_rec.ATTRIBUTE9,
x_ATTRIBUTE10 => p_case_object_rec.ATTRIBUTE10,
x_ATTRIBUTE11 => p_case_object_rec.ATTRIBUTE11,
x_ATTRIBUTE12 => p_case_object_rec.ATTRIBUTE12,
x_ATTRIBUTE13 => p_case_object_rec.ATTRIBUTE13,
x_ATTRIBUTE14 => p_case_object_rec.ATTRIBUTE14,
x_ATTRIBUTE15 => p_case_object_rec.ATTRIBUTE15,
x_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
x_LAST_UPDATE_DATE => SYSDATE,
x_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_CASE_OBJECTS_PVT.update_case_objects ******** ');
End Update_case_objects;
PROCEDURE Delete_case_objects(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
P_case_object_ID IN NUMBER,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CASE_OBJECTS';
SAVEPOINT DELETE_case_objects_PVT;
IEX_CASE_OBJECTS_PKG.Delete_Row(
X_CASE_OBJECT_ID => p_CASE_OBJECT_ID);
End Delete_case_objects;