APPS.IEX_CASE_OBJECTS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 39

 Cursor c2 is SELECT IEX_CASE_OBJECTS_S.nextval from dual;

Line: 116

         IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.Insert_Row');

Line: 118

      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);

Line: 156

           IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'After Calling IEX_CASE_OBJECTS_PKG.Insert_Row and case objectid => '||x_CASE_OBJECT_ID);

Line: 219

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';

Line: 238

         IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_OBJECTS_PVT.update_case_objects ******** ');

Line: 241

      SAVEPOINT UPDATE_case_objects_PVT;

Line: 272

         IEX_DEBUG_PUB.LogMessage('Update_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.lock_row');

Line: 280

         IEX_DEBUG_PUB.LogMessage('Update_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.update_row');

Line: 282

      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);

Line: 341

         IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_CASE_OBJECTS_PVT.update_case_objects ******** ');

Line: 375

End Update_case_objects;

Line: 380

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';

Line: 397

      SAVEPOINT DELETE_case_objects_PVT;

Line: 425

      IEX_CASE_OBJECTS_PKG.Delete_Row(
          X_CASE_OBJECT_ID  => p_CASE_OBJECT_ID);

Line: 477

End Delete_case_objects;