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

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

Line: 52


Cursor c2 is SELECT IEX_BALI_FILTERS_S.nextval from dual;

Line: 149


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

Line: 152


      IEX_BALI_FILTERS_PKG.Insert_Row(
          x_rowid                     => v_rowid,
          x_bali_filter_id            => v_bali_filter_id,
          x_bali_filter_name          => P_bali_filter_rec.bali_filter_name,
          x_bali_datasource           => P_bali_filter_rec.bali_datasource,
          x_bali_user_id              =>P_bali_filter_rec.bali_user_id,
          x_bali_col_alias             => P_bali_filter_rec.bali_col_alias,
          x_bali_col_data_type         => P_bali_filter_rec.bali_col_data_type
         ,x_bali_col_label_text        => P_bali_filter_rec.bali_col_label_text
         ,x_bali_col_condition_code    => P_bali_filter_rec.bali_col_condition_code
         ,x_bali_col_condition_value   => P_bali_filter_rec.bali_col_condition_value
         ,x_bali_col_value             => P_bali_filter_rec.bali_col_value
         ,x_right_parenthesis_code     => P_bali_filter_rec.right_parenthesis_code
         ,x_left_parenthesis_code      => P_bali_filter_rec.left_parenthesis_code
         ,x_boolean_operator_code      => P_bali_filter_rec.boolean_operator_code
          ,x_OBJECT_VERSION_NUMBER     => v_OBJECT_VERSION_NUMBER,
          x_REQUEST_ID                => P_bali_filter_rec.REQUEST_ID,
          x_PROGRAM_APPLICATION_ID   => P_bali_filter_rec.PROGRAM_APPLICATION_ID,
          x_PROGRAM_ID               => P_bali_filter_rec.PROGRAM_ID,
          x_PROGRAM_UPDATE_DATE      => P_bali_filter_rec.PROGRAM_UPDATE_DATE,
          x_ATTRIBUTE_CATEGORY       => P_bali_filter_rec.ATTRIBUTE_CATEGORY,
          x_ATTRIBUTE1  => P_bali_filter_rec.ATTRIBUTE1,
          x_ATTRIBUTE2  => P_bali_filter_rec.ATTRIBUTE2,
          x_ATTRIBUTE3  => P_bali_filter_rec.ATTRIBUTE3,
          x_ATTRIBUTE4  => P_bali_filter_rec.ATTRIBUTE4,
          x_ATTRIBUTE5  => P_bali_filter_rec.ATTRIBUTE5,
          x_ATTRIBUTE6  => P_bali_filter_rec.ATTRIBUTE6,
          x_ATTRIBUTE7  => P_bali_filter_rec.ATTRIBUTE7,
          x_ATTRIBUTE8  => P_bali_filter_rec.ATTRIBUTE8,
          x_ATTRIBUTE9  => P_bali_filter_rec.ATTRIBUTE9,
          x_ATTRIBUTE10  => P_bali_filter_rec.ATTRIBUTE10,
          x_ATTRIBUTE11  => P_bali_filter_rec.ATTRIBUTE11,
          x_ATTRIBUTE12  => P_bali_filter_rec.ATTRIBUTE12,
          x_ATTRIBUTE13  => P_bali_filter_rec.ATTRIBUTE13,
          x_ATTRIBUTE14  => P_bali_filter_rec.ATTRIBUTE14,
          x_ATTRIBUTE15  => P_bali_filter_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: 199


        IEX_DEBUG_PUB.LogMessage('After Calling iex_BALI_FILTERS_pkg.insert_row'||
        'and bali_filter_id => '||x_bali_filter_id);

Line: 254


PROCEDURE update_BALI_FILTERS(
    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_bali_filter_rec            IN    bali_filter_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_BALI_FILTERS';

Line: 273


        'IEX_BALI_FILTERS_PVT.update_BALI_FILTERS *** ');

Line: 277


      SAVEPOINT UPDATE_BALI_FILTERS_PVT;

Line: 314


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

Line: 317


      IEX_BALI_FILTERS_PKG.Update_Row(
          x_bali_filter_id        => P_bali_filter_rec.bali_filter_id,
          x_bali_filter_name          => P_bali_filter_rec.bali_filter_name,
          x_bali_datasource           => P_bali_filter_rec.bali_datasource,
          x_bali_user_id              =>P_bali_filter_rec.bali_user_id,
          x_bali_col_alias             => P_bali_filter_rec.bali_col_alias
         ,x_bali_col_data_type         => P_bali_filter_rec.bali_col_data_type
         ,x_bali_col_label_text        => P_bali_filter_rec.bali_col_label_text
         ,x_bali_col_condition_code    => P_bali_filter_rec.bali_col_condition_code
         ,x_bali_col_condition_value   => P_bali_filter_rec.bali_col_condition_value
         ,x_bali_col_value             => P_bali_filter_rec.bali_col_value
         ,x_right_parenthesis_code     => P_bali_filter_rec.right_parenthesis_code
         ,x_left_parenthesis_code      => P_bali_filter_rec.left_parenthesis_code
         ,x_boolean_operator_code      => P_bali_filter_rec.boolean_operator_code
          ,x_OBJECT_VERSION_NUMBER     => v_OBJECT_VERSION_NUMBER + 1,
          x_REQUEST_ID                => P_bali_filter_rec.REQUEST_ID,
          x_PROGRAM_APPLICATION_ID   => P_bali_filter_rec.PROGRAM_APPLICATION_ID,
          x_PROGRAM_ID               => P_bali_filter_rec.PROGRAM_ID,
          x_PROGRAM_UPDATE_DATE      => P_bali_filter_rec.PROGRAM_UPDATE_DATE,
          x_ATTRIBUTE_CATEGORY       => P_bali_filter_rec.ATTRIBUTE_CATEGORY,
          x_ATTRIBUTE1  => P_bali_filter_rec.ATTRIBUTE1,
          x_ATTRIBUTE2  => P_bali_filter_rec.ATTRIBUTE2,
          x_ATTRIBUTE3  => P_bali_filter_rec.ATTRIBUTE3,
          x_ATTRIBUTE4  => P_bali_filter_rec.ATTRIBUTE4,
          x_ATTRIBUTE5  => P_bali_filter_rec.ATTRIBUTE5,
          x_ATTRIBUTE6  => P_bali_filter_rec.ATTRIBUTE6,
          x_ATTRIBUTE7  => P_bali_filter_rec.ATTRIBUTE7,
          x_ATTRIBUTE8  => P_bali_filter_rec.ATTRIBUTE8,
          x_ATTRIBUTE9  => P_bali_filter_rec.ATTRIBUTE9,
          x_ATTRIBUTE10  => P_bali_filter_rec.ATTRIBUTE10,
          x_ATTRIBUTE11  => P_bali_filter_rec.ATTRIBUTE11,
          x_ATTRIBUTE12  => P_bali_filter_rec.ATTRIBUTE12,
          x_ATTRIBUTE13  => P_bali_filter_rec.ATTRIBUTE13,
          x_ATTRIBUTE14  => P_bali_filter_rec.ATTRIBUTE14,
          x_ATTRIBUTE15  => P_bali_filter_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: 385


          'IEX_BALI_FILTERS_PVT.update_BALI_FILTERS ** ');

Line: 389


                ROLLBACK TO UPDATE_BALI_FILTERS_PVT;

Line: 394


                ROLLBACK TO UPDATE_BALI_FILTERS_PVT;

Line: 400


                ROLLBACK TO UPDATE_BALI_FILTERS_PVT;

Line: 406


End update_BALI_FILTERS;

Line: 410


PROCEDURE  delete_BALI_FILTERS(
    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_bali_filter_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_BALI_FILTERS';

Line: 427


      SAVEPOINT DELETE_BALI_FILTERS_PVT;

Line: 453


      iex_BALI_FILTERS_pkg.delete_row (p_bali_filter_id);

Line: 480


                ROLLBACK TO DELETE_BALI_FILTERS_PVT;

Line: 485


                ROLLBACK TO DELETE_BALI_FILTERS_PVT;

Line: 491


                ROLLBACK TO DELETE_BALI_FILTERS_PVT;

Line: 497


End delete_BALI_FILTERS;