APPS.IEX_CASES_PVT SQL Statements

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

Line: 41

 Cursor c2 is SELECT IEX_CASES_ALL_B_S.nextval from dual;

Line: 168

          IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'Before Calling iex_cases_pkg.insert_row');

Line: 171

      IEX_CASES_PKG.Insert_Row(
          x_rowid   =>v_rowid,
          x_CAS_ID  => v_CAS_ID,
          x_CASE_NUMBER  => v_CASE_NUMBER,
          x_active_flag  => v_active_flag,
          x_party_id     => p_cas_rec.party_id,
          x_ORIG_CAS_ID  => p_cas_rec.orig_cas_id,
          x_CASE_STATE   => v_CASE_STATE,
          x_STATUS_CODE  => v_STATUS_CODE,
          x_OBJECT_VERSION_NUMBER  => v_OBJECT_VERSION_NUMBER,
          x_CASE_ESTABLISHED_DATE  => v_CASE_ESTABLISHED_DATE,
          x_CASE_CLOSING_DATE  => p_cas_rec.CASE_CLOSING_DATE,
          X_OWNER_RESOURCE_ID  => p_cas_rec.OWNER_RESOURCE_ID,
          x_ACCESS_RESOURCE_ID  => p_cas_rec.ACCESS_RESOURCE_ID,
          X_COMMENTS    =>P_CAS_REC.COMMENTS,
          X_PREDICTED_RECOVERY_AMOUNT =>p_cas_rec.PREDICTED_RECOVERY_AMOUNT,
          X_PREDICTED_CHANCE =>p_cas_rec.PREDICTED_CHANCE,
          x_REQUEST_ID  => p_cas_rec.REQUEST_ID,
          x_PROGRAM_APPLICATION_ID  => p_cas_rec.PROGRAM_APPLICATION_ID,
          x_PROGRAM_ID  => p_cas_rec.PROGRAM_ID,
          x_PROGRAM_UPDATE_DATE  => p_cas_rec.PROGRAM_UPDATE_DATE,
          x_ATTRIBUTE_CATEGORY  => p_cas_rec.ATTRIBUTE_CATEGORY,
          x_ATTRIBUTE1  => p_cas_rec.ATTRIBUTE1,
          x_ATTRIBUTE2  => p_cas_rec.ATTRIBUTE2,
          x_ATTRIBUTE3  => p_cas_rec.ATTRIBUTE3,
          x_ATTRIBUTE4  => p_cas_rec.ATTRIBUTE4,
          x_ATTRIBUTE5  => p_cas_rec.ATTRIBUTE5,
          x_ATTRIBUTE6  => p_cas_rec.ATTRIBUTE6,
          x_ATTRIBUTE7  => p_cas_rec.ATTRIBUTE7,
          x_ATTRIBUTE8  => p_cas_rec.ATTRIBUTE8,
          x_ATTRIBUTE9  => p_cas_rec.ATTRIBUTE9,
          x_ATTRIBUTE10  => p_cas_rec.ATTRIBUTE10,
          x_ATTRIBUTE11  => p_cas_rec.ATTRIBUTE11,
          x_ATTRIBUTE12  => p_cas_rec.ATTRIBUTE12,
          x_ATTRIBUTE13  => p_cas_rec.ATTRIBUTE13,
          x_ATTRIBUTE14  => p_cas_rec.ATTRIBUTE14,
          x_ATTRIBUTE15  => p_cas_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,
          x_CLOSE_REASON  => p_cas_rec.CLOSE_REASON,
          x_org_id       =>v_org_id);

Line: 220

           IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'After Calling iex_cases_pkg.insert_row and case id => '||x_case_id);

Line: 289

PROCEDURE Update_cas(
    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_cas_Rec                    IN    cas_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_CAS';

Line: 309

        IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASES_PVT.update_cas ******** ');

Line: 312

      SAVEPOINT UPDATE_CAS_PVT;

Line: 340

         IEX_DEBUG_PUB.LogMessage('Update_cas: ' || 'Before Calling iex_cases_pkg.lock_row');

Line: 350

         IEX_DEBUG_PUB.LogMessage('Update_cas: ' || 'Before Calling iex_cases_pkg.update_row');

Line: 352

      IEX_CASES_PKG.Update_Row(
          x_CAS_ID  => p_cas_rec.CAS_ID,
          x_CASE_NUMBER  => p_cas_rec.CASE_NUMBER,
          x_ACTIVE_FLAG  => p_cas_rec.ACTIVE_FLAG,
          x_PARTY_ID  => p_cas_rec.PARTY_ID,
          x_ORIG_CAS_ID  => p_cas_rec.orig_cas_id,
          x_CASE_STATE   => p_cas_rec.CASE_STATE,
          x_STATUS_CODE  => p_cas_rec.STATUS_CODE,
          x_OBJECT_VERSION_NUMBER  => l_OBJECT_VERSION_NUMBER +1,
          x_CASE_ESTABLISHED_DATE  => p_cas_rec.CASE_ESTABLISHED_DATE,
          x_CASE_CLOSING_DATE  => p_cas_rec.CASE_CLOSING_DATE,
          x_OWNER_RESOURCE_ID  => p_cas_rec.OWNER_RESOURCE_ID,
          x_ACCESS_RESOURCE_ID  => p_cas_rec.ACCESS_RESOURCE_ID,
          x_REQUEST_ID  => p_cas_rec.REQUEST_ID,
          X_COMMENTS    =>P_CAS_REC.COMMENTS,
          X_PREDICTED_RECOVERY_AMOUNT =>p_cas_rec.PREDICTED_RECOVERY_AMOUNT,
          X_PREDICTED_CHANCE =>p_cas_rec.PREDICTED_CHANCE,
          x_PROGRAM_APPLICATION_ID  => p_cas_rec.PROGRAM_APPLICATION_ID,
          x_PROGRAM_ID  => p_cas_rec.PROGRAM_ID,
          x_PROGRAM_UPDATE_DATE  => p_cas_rec.PROGRAM_UPDATE_DATE,
          x_ATTRIBUTE_CATEGORY  => p_cas_rec.ATTRIBUTE_CATEGORY,
          x_ATTRIBUTE1  => p_cas_rec.ATTRIBUTE1,
          x_ATTRIBUTE2  => p_cas_rec.ATTRIBUTE2,
          x_ATTRIBUTE3  => p_cas_rec.ATTRIBUTE3,
          x_ATTRIBUTE4  => p_cas_rec.ATTRIBUTE4,
          x_ATTRIBUTE5  => p_cas_rec.ATTRIBUTE5,
          x_ATTRIBUTE6  => p_cas_rec.ATTRIBUTE6,
          x_ATTRIBUTE7  => p_cas_rec.ATTRIBUTE7,
          x_ATTRIBUTE8  => p_cas_rec.ATTRIBUTE8,
          x_ATTRIBUTE9  => p_cas_rec.ATTRIBUTE9,
          x_ATTRIBUTE10  => p_cas_rec.ATTRIBUTE10,
          x_ATTRIBUTE11  => p_cas_rec.ATTRIBUTE11,
          x_ATTRIBUTE12  => p_cas_rec.ATTRIBUTE12,
          x_ATTRIBUTE13  => p_cas_rec.ATTRIBUTE13,
          x_ATTRIBUTE14  => p_cas_rec.ATTRIBUTE14,
          x_ATTRIBUTE15  => p_cas_rec.ATTRIBUTE15,
          x_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID,
          x_LAST_UPDATE_DATE  => SYSDATE,
          x_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID,
          x_CLOSE_REASON  => p_cas_rec.CLOSE_REASON,
          x_org_id       =>p_cas_rec.org_id);

Line: 421

         IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASES_PVT.Update_cas ******** ');

Line: 455

End Update_cas;

Line: 460

PROCEDURE Delete_cas(
    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_cas_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_CAS';

Line: 477

      SAVEPOINT DELETE_CAS_PVT;

Line: 503

      iex_cases_pkg.delete_row (p_cas_id);

Line: 560

End Delete_cas;