APPS.IEX_COSTS_PVT SQL Statements

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

Line: 42

Cursor c2 is SELECT IEX_COSTS_S.nextval from dual;

Line: 164

      IEX_COSTS_PKG.Insert_Row(
          x_rowid                     =>v_rowid,
          p_COST_ID                   => v_COST_ID,
          p_CASE_ID                   => p_costs_rec.CASE_ID,
          p_DELINQUENCY_ID            => p_costs_rec.DELINQUENCY_ID,
          p_COST_TYPE_CODE            => p_costs_rec.COST_TYPE_CODE,
          p_COST_ITEM_TYPE_CODE       => p_costs_rec.COST_ITEM_TYPE_CODE,
          p_COST_ITEM_TYPE_DESC       => p_costs_rec.COST_ITEM_TYPE_DESC,
          p_COST_ITEM_AMOUNT          => p_costs_rec.COST_ITEM_AMOUNT,
          p_COST_ITEM_CURRENCY_CODE   => p_costs_rec.COST_ITEM_CURRENCY_CODE,
          p_COST_ITEM_QTY             => p_costs_rec.COST_ITEM_QTY,
          p_COST_ITEM_DATE            => p_costs_rec.COST_ITEM_DATE,
          p_FUNCTIONAL_AMOUNT         => p_costs_rec.FUNCTIONAL_AMOUNT,
          p_EXCHANGE_TYPE             => p_costs_rec.EXCHANGE_TYPE,
          p_EXCHANGE_RATE             => p_costs_rec.EXCHANGE_RATE,
          p_EXCHANGE_DATE             => p_costs_rec.EXCHANGE_DATE,
          p_COST_ITEM_APPROVED        => v_COST_ITEM_APPROVED,
          p_ACTIVE_FLAG               => v_ACTIVE_FLAG,
          p_OBJECT_VERSION_NUMBER     => v_OBJECT_VERSION_NUMBER,
          p_CREATED_BY                => FND_GLOBAL.USER_ID,
          p_CREATION_DATE             => SYSDATE,
          p_LAST_UPDATED_BY           => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_DATE          => SYSDATE,
          p_REQUEST_ID                => p_costs_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID    => p_costs_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID                => p_costs_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE       => p_costs_rec.PROGRAM_UPDATE_DATE,
          p_ATTRIBUTE_CATEGORY        => p_costs_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1                => p_costs_rec.ATTRIBUTE1,
          p_ATTRIBUTE2                => p_costs_rec.ATTRIBUTE2,
          p_ATTRIBUTE3                => p_costs_rec.ATTRIBUTE3,
          p_ATTRIBUTE4                => p_costs_rec.ATTRIBUTE4,
          p_ATTRIBUTE5                => p_costs_rec.ATTRIBUTE5,
          p_ATTRIBUTE6                => p_costs_rec.ATTRIBUTE6,
          p_ATTRIBUTE7                => p_costs_rec.ATTRIBUTE7,
          p_ATTRIBUTE8                => p_costs_rec.ATTRIBUTE8,
          p_ATTRIBUTE9                => p_costs_rec.ATTRIBUTE9,
          p_ATTRIBUTE10               => p_costs_rec.ATTRIBUTE10,
          p_ATTRIBUTE11               => p_costs_rec.ATTRIBUTE11,
          p_ATTRIBUTE12               => p_costs_rec.ATTRIBUTE12,
          p_ATTRIBUTE13               => p_costs_rec.ATTRIBUTE13,
          p_ATTRIBUTE14               => p_costs_rec.ATTRIBUTE14,
          p_ATTRIBUTE15               => p_costs_rec.ATTRIBUTE15,
          p_LAST_UPDATE_LOGIN         => p_costs_rec.LAST_UPDATE_LOGIN);

Line: 214

             IEX_DEBUG_PUB.LogMessage('Create_costs: ' || 'After Calling IEX_COSTS_PKG.Insert_Row'
           ||' and cost id => ' ||v_cost_id);

Line: 280

PROCEDURE Update_costs(
    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_costs_Rec                  IN    costs_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_COSTS';

Line: 300

         IEX_DEBUG_PUB.LogMessage ('********* start of Procedure =>IEX_COSTS_PVT.update_COSTS ******** ');

Line: 303

      SAVEPOINT UPDATE_COSTS_PVT;

Line: 337

      IEX_COSTS_PKG.Update_Row(
          p_COST_ID                   => p_costs_rec.COST_ID,
          p_CASE_ID                   => p_costs_rec.CASE_ID,
          p_DELINQUENCY_ID            => p_costs_rec.DELINQUENCY_ID,
          p_COST_TYPE_CODE            => p_costs_rec.COST_TYPE_CODE,
          p_COST_ITEM_TYPE_CODE       => p_costs_rec.COST_ITEM_TYPE_CODE,
          p_COST_ITEM_TYPE_DESC       => p_costs_rec.COST_ITEM_TYPE_DESC,
          p_COST_ITEM_AMOUNT          => p_costs_rec.COST_ITEM_AMOUNT,
          p_COST_ITEM_CURRENCY_CODE   => p_costs_rec.COST_ITEM_CURRENCY_CODE,
          p_COST_ITEM_QTY             => p_costs_rec.COST_ITEM_QTY,
          p_COST_ITEM_DATE            => p_costs_rec.COST_ITEM_DATE,
          p_FUNCTIONAL_AMOUNT         =>p_costs_rec.FUNCTIONAL_AMOUNT,
          p_EXCHANGE_TYPE             => p_costs_rec.EXCHANGE_TYPE,
          p_EXCHANGE_RATE             => p_costs_rec.EXCHANGE_RATE,
          p_EXCHANGE_DATE             => p_costs_rec.EXCHANGE_DATE,
          p_COST_ITEM_APPROVED        => p_costs_rec.COST_ITEM_APPROVED,
          p_ACTIVE_FLAG               => p_costs_rec.ACTIVE_FLAG,
          p_OBJECT_VERSION_NUMBER     => l_OBJECT_VERSION_NUMBER +1,
          p_LAST_UPDATED_BY           => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_DATE          => SYSDATE,
          p_REQUEST_ID                => p_costs_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID    => p_costs_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID                => p_costs_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE       => p_costs_rec.PROGRAM_UPDATE_DATE,
          p_ATTRIBUTE_CATEGORY        => p_costs_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1                => p_costs_rec.ATTRIBUTE1,
          p_ATTRIBUTE2                => p_costs_rec.ATTRIBUTE2,
          p_ATTRIBUTE3                => p_costs_rec.ATTRIBUTE3,
          p_ATTRIBUTE4                => p_costs_rec.ATTRIBUTE4,
          p_ATTRIBUTE5                => p_costs_rec.ATTRIBUTE5,
          p_ATTRIBUTE6                => p_costs_rec.ATTRIBUTE6,
          p_ATTRIBUTE7                => p_costs_rec.ATTRIBUTE7,
          p_ATTRIBUTE8                => p_costs_rec.ATTRIBUTE8,
          p_ATTRIBUTE9                => p_costs_rec.ATTRIBUTE9,
          p_ATTRIBUTE10               => p_costs_rec.ATTRIBUTE10,
          p_ATTRIBUTE11               => p_costs_rec.ATTRIBUTE11,
          p_ATTRIBUTE12               => p_costs_rec.ATTRIBUTE12,
          p_ATTRIBUTE13               => p_costs_rec.ATTRIBUTE13,
          p_ATTRIBUTE14               => p_costs_rec.ATTRIBUTE14,
          p_ATTRIBUTE15               => p_costs_rec.ATTRIBUTE15,
          p_LAST_UPDATE_LOGIN         => p_costs_rec.LAST_UPDATE_LOGIN);

Line: 402

        IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_COSTS_PVT.update_costs ******** ');

Line: 436

End Update_costs;

Line: 441

PROCEDURE Delete_costs(
    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_cost_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_costs';

Line: 459

        IEX_DEBUG_PUB.LogMessage ('********* start of Procedure =>IEX_COSTS_PVT.delete_costs ******** ');

Line: 462

      SAVEPOINT DELETE_COSTS_PVT;

Line: 488

      IEX_COSTS_PKG.Delete_Row(
          p_COST_ID  => p_COST_ID);

Line: 508

         IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_COSTS_PVT.delete_costs ******** ');

Line: 543

End Delete_costs;