eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_CASE_DEFINITIONS_PVT SQL Statements

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

Line: 39


 Cursor c2 is SELECT IEX_CASE_DEFINITIONS_S.nextval from dual;

Line: 109


          IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.Insert_Row');

Line: 112


      IEX_CASE_DEFINITIONS_PKG.Insert_Row(
          x_rowid                  =>v_rowid,
          x_CASE_DEFINITION_ID     => v_CASE_DEFINITION_ID,
          x_COLUMN_NAME            => p_case_definition_rec.COLUMN_NAME,
          x_COLUMN_VALUE           => p_case_definition_rec.COLUMN_VALUE,
          x_ACTIVE_FLAG            => v_active_flag,
          x_TABLE_NAME            => p_case_definition_rec.TABLE_NAME,
          x_OBJECT_VERSION_NUMBER  => v_OBJECT_VERSION_NUMBER,
          x_CAS_ID                 => p_case_definition_rec.CAS_ID,
          x_REQUEST_ID             => p_case_definition_rec.REQUEST_ID,
          x_PROGRAM_APPLICATION_ID => p_case_definition_rec.PROGRAM_APPLICATION_ID,
          x_PROGRAM_ID             => p_case_definition_rec.PROGRAM_ID,
          x_PROGRAM_UPDATE_DATE    => p_case_definition_rec.PROGRAM_UPDATE_DATE,
          x_ATTRIBUTE_CATEGORY     => p_case_definition_rec.ATTRIBUTE_CATEGORY,
          x_ATTRIBUTE1            => p_case_definition_rec.ATTRIBUTE1,
          x_ATTRIBUTE2            => p_case_definition_rec.ATTRIBUTE2,
          x_ATTRIBUTE3  => p_case_definition_rec.ATTRIBUTE3,
          x_ATTRIBUTE4  => p_case_definition_rec.ATTRIBUTE4,
          x_ATTRIBUTE5  => p_case_definition_rec.ATTRIBUTE5,
          x_ATTRIBUTE6  => p_case_definition_rec.ATTRIBUTE6,
          x_ATTRIBUTE7  => p_case_definition_rec.ATTRIBUTE7,
          x_ATTRIBUTE8  => p_case_definition_rec.ATTRIBUTE8,
          x_ATTRIBUTE9  => p_case_definition_rec.ATTRIBUTE9,
          x_ATTRIBUTE10  => p_case_definition_rec.ATTRIBUTE10,
          x_ATTRIBUTE11  => p_case_definition_rec.ATTRIBUTE11,
          x_ATTRIBUTE12  => p_case_definition_rec.ATTRIBUTE12,
          x_ATTRIBUTE13  => p_case_definition_rec.ATTRIBUTE13,
          x_ATTRIBUTE14  => p_case_definition_rec.ATTRIBUTE14,
          x_ATTRIBUTE15  => p_case_definition_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: 151


           IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'After Calling IEX_CASE_DEFINITIONS_PKG.Insert_Row and case definition id => '||x_CASE_DEFINITION_ID);

Line: 214


PROCEDURE Update_case_definitions(
    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_definition_Rec        IN    case_definition_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_DEFINITIONS';

Line: 233


        IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_DEFINITIONS_PVT.Update_case_definitions ******** ');

Line: 236


      SAVEPOINT UPDATE_case_definitions_PVT;

Line: 266


         IEX_DEBUG_PUB.LogMessage('Update_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.lock_row');

Line: 274


        IEX_DEBUG_PUB.LogMessage('Update_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.update_row');

Line: 276


      IEX_CASE_DEFINITIONS_PKG.Update_Row(
          x_CASE_DEFINITION_ID  => p_case_definition_rec.CASE_DEFINITION_ID,
          x_COLUMN_NAME  => p_case_definition_rec.COLUMN_NAME,
          x_COLUMN_VALUE  =>p_case_definition_rec.COLUMN_VALUE,
          x_ACTIVE_FLAG  =>p_case_definition_rec.ACTIVE_FLAG,
          x_TABLE_NAME  => p_case_definition_rec.TABLE_NAME,
          x_OBJECT_VERSION_NUMBER  => l_OBJECT_VERSION_NUMBER +1,
          x_CAS_ID  => p_case_definition_rec.CAS_ID,
          x_REQUEST_ID  => p_case_definition_rec.REQUEST_ID,
          x_PROGRAM_APPLICATION_ID  => p_case_definition_rec.PROGRAM_APPLICATION_ID,
          x_PROGRAM_ID  => p_case_definition_rec.PROGRAM_ID,
          x_PROGRAM_UPDATE_DATE  => p_case_definition_rec.PROGRAM_UPDATE_DATE,
          x_ATTRIBUTE_CATEGORY  => p_case_definition_rec.ATTRIBUTE_CATEGORY,
          x_ATTRIBUTE1  => p_case_definition_rec.ATTRIBUTE1,
          x_ATTRIBUTE2  => p_case_definition_rec.ATTRIBUTE2,
          x_ATTRIBUTE3  => p_case_definition_rec.ATTRIBUTE3,
          x_ATTRIBUTE4  => p_case_definition_rec.ATTRIBUTE4,
          x_ATTRIBUTE5  => p_case_definition_rec.ATTRIBUTE5,
          x_ATTRIBUTE6  => p_case_definition_rec.ATTRIBUTE6,
          x_ATTRIBUTE7  => p_case_definition_rec.ATTRIBUTE7,
          x_ATTRIBUTE8  => p_case_definition_rec.ATTRIBUTE8,
          x_ATTRIBUTE9  => p_case_definition_rec.ATTRIBUTE9,
          x_ATTRIBUTE10  => p_case_definition_rec.ATTRIBUTE10,
          x_ATTRIBUTE11  => p_case_definition_rec.ATTRIBUTE11,
          x_ATTRIBUTE12  => p_case_definition_rec.ATTRIBUTE12,
          x_ATTRIBUTE13  => p_case_definition_rec.ATTRIBUTE13,
          x_ATTRIBUTE14  => p_case_definition_rec.ATTRIBUTE14,
          x_ATTRIBUTE15  => p_case_definition_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: 336


         IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_CASE_DEFINITIONS_PVT.update_case_definitions ******** ');

Line: 370


End Update_case_definitions;

Line: 375


PROCEDURE Delete_case_definitions(
    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_definition_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_DEFINITIONS';

Line: 392


      SAVEPOINT DELETE_case_definitions_PVT;

Line: 419


      IEX_CASE_DEFINITIONS_PKG.Delete_Row(
          X_CASE_DEFINITION_ID  => p_CASE_DEFINITION_ID);

Line: 470


End Delete_case_definitions;