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.OKL_QUL_PVT SQL Statements

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

Line: 123


    SELECT
      id
      ,object_version_number
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,subpool_trx_id
      ,source_type_code
      ,source_object_id
      ,asset_number
      ,asset_start_date
      ,subsidy_pool_id
      ,subsidy_pool_amount
      ,subsidy_pool_currency_code
      ,subsidy_id
      ,subsidy_amount
      ,subsidy_currency_code
      ,vendor_id
      ,conversion_rate
    INTO
      l_qulv_rec.id
      ,l_qulv_rec.object_version_number
      ,l_qulv_rec.attribute_category
      ,l_qulv_rec.attribute1
      ,l_qulv_rec.attribute2
      ,l_qulv_rec.attribute3
      ,l_qulv_rec.attribute4
      ,l_qulv_rec.attribute5
      ,l_qulv_rec.attribute6
      ,l_qulv_rec.attribute7
      ,l_qulv_rec.attribute8
      ,l_qulv_rec.attribute9
      ,l_qulv_rec.attribute10
      ,l_qulv_rec.attribute11
      ,l_qulv_rec.attribute12
      ,l_qulv_rec.attribute13
      ,l_qulv_rec.attribute14
      ,l_qulv_rec.attribute15
      ,l_qulv_rec.subpool_trx_id
      ,l_qulv_rec.source_type_code
      ,l_qulv_rec.source_object_id
      ,l_qulv_rec.asset_number
      ,l_qulv_rec.asset_start_date
      ,l_qulv_rec.subsidy_pool_id
      ,l_qulv_rec.subsidy_pool_amount
      ,l_qulv_rec.subsidy_pool_currency_code
      ,l_qulv_rec.subsidy_id
      ,l_qulv_rec.subsidy_amount
      ,l_qulv_rec.subsidy_currency_code
      ,l_qulv_rec.vendor_id
      ,l_qulv_rec.conversion_rate
    FROM okl_quote_subpool_usage_v
    WHERE id = p_id;

Line: 318


  PROCEDURE insert_row (x_return_status OUT NOCOPY VARCHAR2, p_qul_rec IN qul_rec_type) IS

    l_prog_name  VARCHAR2(61);

Line: 324


    l_prog_name := G_PKG_NAME||'.insert_row (B)';

Line: 326


    INSERT INTO okl_quote_subpool_usage (
      id
      ,object_version_number
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,created_by
      ,creation_date
      ,last_updated_by
      ,last_update_date
      ,last_update_login
      ,subpool_trx_id
      ,source_type_code
      ,source_object_id
      ,asset_number
      ,asset_start_date
      ,subsidy_pool_id
      ,subsidy_pool_amount
      ,subsidy_pool_currency_code
      ,subsidy_id
      ,subsidy_amount
      ,subsidy_currency_code
      ,vendor_id
      ,conversion_rate
      )
    VALUES
      (
       p_qul_rec.id
      ,p_qul_rec.object_version_number
      ,p_qul_rec.attribute_category
      ,p_qul_rec.attribute1
      ,p_qul_rec.attribute2
      ,p_qul_rec.attribute3
      ,p_qul_rec.attribute4
      ,p_qul_rec.attribute5
      ,p_qul_rec.attribute6
      ,p_qul_rec.attribute7
      ,p_qul_rec.attribute8
      ,p_qul_rec.attribute9
      ,p_qul_rec.attribute10
      ,p_qul_rec.attribute11
      ,p_qul_rec.attribute12
      ,p_qul_rec.attribute13
      ,p_qul_rec.attribute14
      ,p_qul_rec.attribute15
      ,G_USER_ID
      ,SYSDATE
      ,G_USER_ID
      ,SYSDATE
      ,G_LOGIN_ID
      ,p_qul_rec.subpool_trx_id
      ,p_qul_rec.source_type_code
      ,p_qul_rec.source_object_id
      ,p_qul_rec.asset_number
      ,p_qul_rec.asset_start_date
      ,p_qul_rec.subsidy_pool_id
      ,p_qul_rec.subsidy_pool_amount
      ,p_qul_rec.subsidy_pool_currency_code
      ,p_qul_rec.subsidy_id
      ,p_qul_rec.subsidy_amount
      ,p_qul_rec.subsidy_currency_code
      ,p_qul_rec.vendor_id
      ,p_qul_rec.conversion_rate
    );

Line: 421


  END insert_row;

Line: 427


  PROCEDURE insert_row (
    x_return_status                OUT NOCOPY VARCHAR2,
    p_qulv_rec                     IN qulv_rec_type,
    x_qulv_rec                     OUT NOCOPY qulv_rec_type) IS

    l_return_status                VARCHAR2(1);

Line: 441


    l_prog_name := G_PKG_NAME||'.insert_row (V)';

Line: 445


    SELECT okl_qul_seq.nextval INTO l_qulv_rec.ID FROM DUAL;

Line: 467


    insert_row (x_return_status => l_return_status, p_qul_rec => l_qul_rec);

Line: 501


  END insert_row;

Line: 507


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qulv_rec                     IN qulv_rec_type,
    x_qulv_rec                     OUT NOCOPY qulv_rec_type) IS

    l_return_status              VARCHAR2(1);

Line: 522


    l_prog_name := G_PKG_NAME||'.insert_row (REC)';

Line: 528


    insert_row (x_return_status                => l_return_status,
                p_qulv_rec                     => p_qulv_rec,
                x_qulv_rec                     => x_qulv_rec);

Line: 563


  END insert_row;

Line: 569


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qulv_tbl                     IN qulv_tbl_type,
    x_qulv_tbl                     OUT NOCOPY qulv_tbl_type) IS

    l_return_status              VARCHAR2(1);

Line: 585


    l_prog_name := G_PKG_NAME||'.insert_row (TBL)';

Line: 596


          insert_row (x_return_status                => l_return_status,
                      p_qulv_rec                     => p_qulv_tbl(i),
                      x_qulv_rec                     => x_qulv_tbl(i));

Line: 644


  END insert_row;

Line: 657


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_QUOTE_SUBPOOL_USAGE
     WHERE ID = p_qul_rec.id
       AND OBJECT_VERSION_NUMBER = p_qul_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 664


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_QUOTE_SUBPOOL_USAGE
     WHERE ID = p_qul_rec.id;

Line: 751


  PROCEDURE update_row(x_return_status OUT NOCOPY VARCHAR2, p_qul_rec IN qul_rec_type) IS

    l_return_status           VARCHAR2(1);

Line: 759


    l_prog_name := G_PKG_NAME||'.update_row (B)';

Line: 769


    UPDATE okl_quote_subpool_usage
    SET
      object_version_number = p_qul_rec.object_version_number+1
      ,attribute_category = p_qul_rec.attribute_category
      ,attribute1 = p_qul_rec.attribute1
      ,attribute2 = p_qul_rec.attribute2
      ,attribute3 = p_qul_rec.attribute3
      ,attribute4 = p_qul_rec.attribute4
      ,attribute5 = p_qul_rec.attribute5
      ,attribute6 = p_qul_rec.attribute6
      ,attribute7 = p_qul_rec.attribute7
      ,attribute8 = p_qul_rec.attribute8
      ,attribute9 = p_qul_rec.attribute9
      ,attribute10 = p_qul_rec.attribute10
      ,attribute11 = p_qul_rec.attribute11
      ,attribute12 = p_qul_rec.attribute12
      ,attribute13 = p_qul_rec.attribute13
      ,attribute14 = p_qul_rec.attribute14
      ,attribute15 = p_qul_rec.attribute15
      ,subpool_trx_id = p_qul_rec.subpool_trx_id
      ,source_type_code = p_qul_rec.source_type_code
      ,source_object_id = p_qul_rec.source_object_id
      ,asset_number = p_qul_rec.asset_number
      ,asset_start_date = p_qul_rec.asset_start_date
      ,subsidy_pool_id = p_qul_rec.subsidy_pool_id
      ,subsidy_pool_amount = p_qul_rec.subsidy_pool_amount
      ,subsidy_pool_currency_code = p_qul_rec.subsidy_pool_currency_code
      ,subsidy_id = p_qul_rec.subsidy_id
      ,subsidy_amount = p_qul_rec.subsidy_amount
      ,subsidy_currency_code = p_qul_rec.subsidy_currency_code
      ,vendor_id = p_qul_rec.vendor_id
      ,conversion_rate = p_qul_rec.conversion_rate
    WHERE id = p_qul_rec.id;

Line: 825


  END update_row;

Line: 831


  PROCEDURE update_row (
    x_return_status                OUT NOCOPY VARCHAR2,
    p_qulv_rec                     IN qulv_rec_type,
    x_qulv_rec                     OUT NOCOPY qulv_rec_type) IS

    l_prog_name                    VARCHAR2(61);

Line: 982


    l_prog_name := G_PKG_NAME||'.update_row (V)';

Line: 1010


    update_row (x_return_status => l_return_status, p_qul_rec => l_qul_rec);

Line: 1044


  END update_row;

Line: 1050


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qulv_rec                     IN qulv_rec_type,
    x_qulv_rec                     OUT NOCOPY qulv_rec_type) IS

    l_return_status              VARCHAR2(1);

Line: 1065


    l_prog_name := G_PKG_NAME||'.update_row (REC)';

Line: 1071


    update_row (x_return_status                => l_return_status,
                p_qulv_rec                     => p_qulv_rec,
                x_qulv_rec                     => x_qulv_rec);

Line: 1106


  END update_row;

Line: 1112


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qulv_tbl                     IN qulv_tbl_type,
    x_qulv_tbl                     OUT NOCOPY qulv_tbl_type) IS

    l_return_status              VARCHAR2(1);

Line: 1127


    l_prog_name := G_PKG_NAME||'.update_row (TBL)';

Line: 1142


          update_row (x_return_status                => l_return_status,
                      p_qulv_rec                     => p_qulv_tbl(i),
                      x_qulv_rec                     => x_qulv_tbl(i));

Line: 1190


  END update_row;

Line: 1196


  PROCEDURE delete_row(
    x_return_status                OUT NOCOPY VARCHAR2,
    p_id                           IN NUMBER) IS

    l_prog_name                  VARCHAR2(61);

Line: 1204


    l_prog_name := G_PKG_NAME||'.delete_row (V)';

Line: 1206


    DELETE FROM OKL_QUOTE_SUBPOOL_USAGE WHERE id = p_id;

Line: 1225


  END delete_row;

Line: 1231


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qulv_rec                     IN qulv_rec_type) IS

    l_return_status              VARCHAR2(1);

Line: 1245


    l_prog_name := G_PKG_NAME||'.delete_row (REC)';

Line: 1251


    delete_row (x_return_status                => l_return_status,
                p_id                           => p_qulv_rec.id);

Line: 1285


  END delete_row;

Line: 1291


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qulv_tbl                     IN qulv_tbl_type) IS

    l_return_status                VARCHAR2(1);

Line: 1306


    l_prog_name := G_PKG_NAME||'.delete_row (TBL)';

Line: 1320


          delete_row (x_return_status                => l_return_status,
                      p_id                           => p_qulv_tbl(i).id);

Line: 1359


  END delete_row;