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_WRITEOFF_OBJECTS_PVT SQL Statements

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

Line: 50


Cursor c2 is SELECT IEX_writeoff_objects_S.nextval from dual;

Line: 129


           IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.insert_row');

Line: 132


      IEX_writeoff_objects_PKG.Insert_Row(
          x_rowid                     => v_rowid,
          x_WRITEOFF_OBJECT_ID        => v_writeoff_object_id,
          x_WRITEOFF_ID               => p_writeoff_obj_rec.WRITEOFF_ID,
          x_OBJECT_VERSION_NUMBER     => v_OBJECT_VERSION_NUMBER,
          x_CONTRACT_ID               => p_writeoff_obj_rec.CONTRACT_ID,
          x_CONS_INVOICE_ID           => p_writeoff_obj_rec.CONS_INVOICE_ID,
          x_CONS_INVOICE_LINE_ID      => p_writeoff_obj_rec.CONS_INVOICE_LINE_ID,
          x_TRANSACTION_ID            => p_writeoff_obj_rec.TRANSACTION_ID,
          x_ADJUSTMENT_AMOUNT         => p_writeoff_obj_rec.ADJUSTMENT_AMOUNT,
          x_ADJUSTMENT_REASON_CODE    => p_writeoff_obj_rec.adjustment_reason_code,
          x_RECEVIABLES_ADJUSTMENT_ID => p_writeoff_obj_rec.RECEVIABLES_ADJUSTMENT_ID,
          x_REQUEST_ID                => p_writeoff_obj_rec.REQUEST_ID,
          x_PROGRAM_APPLICATION_ID   => p_writeoff_obj_rec.PROGRAM_APPLICATION_ID,
          x_PROGRAM_ID               => p_writeoff_obj_rec.PROGRAM_ID,
          x_PROGRAM_UPDATE_DATE      => p_writeoff_obj_rec.PROGRAM_UPDATE_DATE,
          x_ATTRIBUTE_CATEGORY       => p_writeoff_obj_rec.ATTRIBUTE_CATEGORY,
          x_ATTRIBUTE1  => p_writeoff_obj_rec.ATTRIBUTE1,
          x_ATTRIBUTE2  => p_writeoff_obj_rec.ATTRIBUTE2,
          x_ATTRIBUTE3  => p_writeoff_obj_rec.ATTRIBUTE3,
          x_ATTRIBUTE4  => p_writeoff_obj_rec.ATTRIBUTE4,
          x_ATTRIBUTE5  => p_writeoff_obj_rec.ATTRIBUTE5,
          x_ATTRIBUTE6  => p_writeoff_obj_rec.ATTRIBUTE6,
          x_ATTRIBUTE7  => p_writeoff_obj_rec.ATTRIBUTE7,
          x_ATTRIBUTE8  => p_writeoff_obj_rec.ATTRIBUTE8,
          x_ATTRIBUTE9  => p_writeoff_obj_rec.ATTRIBUTE9,
          x_ATTRIBUTE10  => p_writeoff_obj_rec.ATTRIBUTE10,
          x_ATTRIBUTE11  => p_writeoff_obj_rec.ATTRIBUTE11,
          x_ATTRIBUTE12  => p_writeoff_obj_rec.ATTRIBUTE12,
          x_ATTRIBUTE13  => p_writeoff_obj_rec.ATTRIBUTE13,
          x_ATTRIBUTE14  => p_writeoff_obj_rec.ATTRIBUTE14,
          x_ATTRIBUTE15  => p_writeoff_obj_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_WRITEOFF_STATUS  => p_writeoff_obj_rec.WRITEOFF_STATUS,
          x_WRITEOFF_TYPE_ID  => p_writeoff_obj_rec.WRITEOFF_TYPE_ID,
          x_WRITEOFF_TYPE => p_writeoff_obj_rec.WRITEOFF_TYPE,
          x_customer_trx_id => p_writeoff_obj_rec.customer_trx_id,
          x_customer_trx_line_id => p_writeoff_obj_rec.customer_trx_line_id);

Line: 178


        IEX_DEBUG_PUB.LogMessage('After Calling iex_writeoff_objects_pkg.insert_row'||
        'and writeoff_object_id => '||x_writeoff_object_id);

Line: 233


PROCEDURE update_writeoff_objects(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    P_writeoff_obj_rec           IN    writeoff_obj_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(60) := 'UPDATE_WRITEOFF_OBJECTS';

Line: 253


        'IEX_writeoff_objects_PVT.update_writeoff_objects *** ');

Line: 257


      SAVEPOINT UPDATE_WRITEOFF_OBJECTS_PVT;

Line: 294


      IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.update_row');

Line: 297


      IEX_writeoff_objects_PKG.Update_Row(
          x_WRITEOFF_OBJECT_ID        => p_writeoff_obj_rec.writeoff_object_id,
          x_WRITEOFF_ID               => p_writeoff_obj_rec.WRITEOFF_ID,
          x_OBJECT_VERSION_NUMBER     => v_OBJECT_VERSION_NUMBER + 1,
          x_CONTRACT_ID               => p_writeoff_obj_rec.CONTRACT_ID,
          x_CONS_INVOICE_ID           => p_writeoff_obj_rec.CONS_INVOICE_ID,
          x_CONS_INVOICE_LINE_ID      => p_writeoff_obj_rec.CONS_INVOICE_LINE_ID,
          x_TRANSACTION_ID            => p_writeoff_obj_rec.TRANSACTION_ID,
          x_ADJUSTMENT_AMOUNT         => p_writeoff_obj_rec.ADJUSTMENT_AMOUNT,
          x_ADJUSTMENT_REASON_CODE    => p_writeoff_obj_rec.adjustment_reason_code,
          x_RECEVIABLES_ADJUSTMENT_ID => p_writeoff_obj_rec.RECEVIABLES_ADJUSTMENT_ID,
          x_REQUEST_ID                => p_writeoff_obj_rec.REQUEST_ID,
          x_PROGRAM_APPLICATION_ID   => p_writeoff_obj_rec.PROGRAM_APPLICATION_ID,
          x_PROGRAM_ID               => p_writeoff_obj_rec.PROGRAM_ID,
          x_PROGRAM_UPDATE_DATE      => p_writeoff_obj_rec.PROGRAM_UPDATE_DATE,
          x_ATTRIBUTE_CATEGORY       => p_writeoff_obj_rec.ATTRIBUTE_CATEGORY,
          x_ATTRIBUTE1  => p_writeoff_obj_rec.ATTRIBUTE1,
          x_ATTRIBUTE2  => p_writeoff_obj_rec.ATTRIBUTE2,
          x_ATTRIBUTE3  => p_writeoff_obj_rec.ATTRIBUTE3,
          x_ATTRIBUTE4  => p_writeoff_obj_rec.ATTRIBUTE4,
          x_ATTRIBUTE5  => p_writeoff_obj_rec.ATTRIBUTE5,
          x_ATTRIBUTE6  => p_writeoff_obj_rec.ATTRIBUTE6,
          x_ATTRIBUTE7  => p_writeoff_obj_rec.ATTRIBUTE7,
          x_ATTRIBUTE8  => p_writeoff_obj_rec.ATTRIBUTE8,
          x_ATTRIBUTE9  => p_writeoff_obj_rec.ATTRIBUTE9,
          x_ATTRIBUTE10  => p_writeoff_obj_rec.ATTRIBUTE10,
          x_ATTRIBUTE11  => p_writeoff_obj_rec.ATTRIBUTE11,
          x_ATTRIBUTE12  => p_writeoff_obj_rec.ATTRIBUTE12,
          x_ATTRIBUTE13  => p_writeoff_obj_rec.ATTRIBUTE13,
          x_ATTRIBUTE14  => p_writeoff_obj_rec.ATTRIBUTE14,
          x_ATTRIBUTE15  => p_writeoff_obj_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_WRITEOFF_STATUS  => p_writeoff_obj_rec.WRITEOFF_STATUS,
          x_WRITEOFF_TYPE_ID  => p_writeoff_obj_rec.WRITEOFF_TYPE_ID,
          x_WRITEOFF_TYPE => p_writeoff_obj_rec.WRITEOFF_TYPE,
          x_customer_trx_id => p_writeoff_obj_rec.customer_trx_id,
          x_customer_trx_line_id => p_writeoff_obj_rec.customer_trx_line_id);

Line: 365


          'IEX_writeoff_objects_PVT.update_writeoff_objects ** ');

Line: 369


                ROLLBACK TO UPDATE_WRITEOFF_OBJECTS_PVT;

Line: 374


                ROLLBACK TO UPDATE_WRITEOFF_OBJECTS_PVT;

Line: 380


                ROLLBACK TO UPDATE_WRITEOFF_OBJECTS_PVT;

Line: 386


End update_writeoff_objects;

Line: 390


PROCEDURE delete_writeoff_objects(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    P_writeoff_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(50) := 'DELETE_WRITEOFF_OBJECTS';

Line: 405


      SAVEPOINT DELETE_WRITEOFF_OBJECTS_PVT;

Line: 431


      iex_writeoff_objects_pkg.delete_row (p_writeoff_object_id);

Line: 458


                ROLLBACK TO DELETE_WRITEOFF_OBJECTS_PVT;

Line: 463


                ROLLBACK TO DELETE_WRITEOFF_OBJECTS_PVT;

Line: 469


                ROLLBACK TO DELETE_WRITEOFF_OBJECTS_PVT;

Line: 475


End delete_writeoff_objects;