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

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

Line: 105


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            TRX_TYPE_CODE,
            SOURCE_TYPE_CODE,
            SOURCE_OBJECT_ID,
            SUBSIDY_POOL_ID,
            DNZ_ASSET_NUMBER,
            VENDOR_ID,
            SOURCE_TRX_DATE,
            TRX_DATE,
            SUBSIDY_ID,
            TRX_REASON_CODE,
            TRX_CURRENCY_CODE,
            TRX_AMOUNT,
            SUBSIDY_POOL_CURRENCY_CODE,
            SUBSIDY_POOL_AMOUNT,
            CONVERSION_RATE,
            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
      FROM Okl_Trx_Subsidy_Pools_V
     WHERE okl_trx_subsidy_pools_v.id = p_id;

Line: 188


              l_sixv_rec.last_updated_by,
              l_sixv_rec.last_update_date,
              l_sixv_rec.last_update_login;

Line: 232


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            TRX_TYPE_CODE,
            SOURCE_TYPE_CODE,
            SOURCE_OBJECT_ID,
            SUBSIDY_POOL_ID,
            DNZ_ASSET_NUMBER,
            VENDOR_ID,
            SOURCE_TRX_DATE,
            TRX_DATE,
            SUBSIDY_ID,
            TRX_REASON_CODE,
            TRX_CURRENCY_CODE,
            TRX_AMOUNT,
            SUBSIDY_POOL_CURRENCY_CODE,
            SUBSIDY_POOL_AMOUNT,
            CONVERSION_RATE,
            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
      FROM Okl_Trx_Subsidy_Pools
     WHERE okl_trx_subsidy_pools.id = p_id;

Line: 315


              l_okl_trx_subsidy_pools_rec.last_updated_by,
              l_okl_trx_subsidy_pools_rec.last_update_date,
              l_okl_trx_subsidy_pools_rec.last_update_login;

Line: 464


    IF (l_sixv_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
      l_sixv_rec.last_updated_by := NULL;

Line: 467


    IF (l_sixv_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
      l_sixv_rec.last_update_date := NULL;

Line: 470


    IF (l_sixv_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
      l_sixv_rec.last_update_login := NULL;

Line: 538


     SELECT 'X'
       FROM fnd_lookups
      WHERE lookup_type = 'OKL_SUB_POOL_LINE_TYPE'
        AND lookup_code = p_trx_type_code;

Line: 590


     SELECT 'X'
       FROM fnd_lookups
      WHERE lookup_type = 'OKL_SUB_POOL_TRX_SOURCE_TYPE'
        AND lookup_code = p_source_type_code;

Line: 694


     SELECT 'X'
       FROM fnd_lookups
      WHERE lookup_type = 'OKL_SUB_POOL_TRX_REASON_TYPE'
        AND lookup_code = p_trx_reason_code;

Line: 823


     SELECT 'X'
       FROM po_vendors
      WHERE vendor_id = p_vendor_id;

Line: 865


     SELECT 'X'
       FROM gl_currencies
      WHERE CURRENCY_CODE = p_trx_currency_code;

Line: 1173


    SELECT effective_from_date, effective_to_date, name
      FROM okl_subsidies_b
     WHERE id = p_sixv_rec.subsidy_id;

Line: 1178


    SELECT effective_from_date, effective_to_date, subsidy_pool_name
      FROM okl_subsidy_pools_b
     WHERE id = p_sixv_rec.subsidy_pool_id;

Line: 1265


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1266


    p_to.last_update_date := p_from.last_update_date;

Line: 1267


    p_to.last_update_login := p_from.last_update_login;

Line: 1309


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1310


    p_to.last_update_date := p_from.last_update_date;

Line: 1311


    p_to.last_update_login := p_from.last_update_login;

Line: 1557


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_okl_trx_subsidy_pools_rec    IN okl_trx_subsidy_pools_rec_type,
    x_okl_trx_subsidy_pools_rec    OUT NOCOPY okl_trx_subsidy_pools_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1566


    l_api_name                     CONSTANT VARCHAR2(30) := 'B_insert_row';

Line: 1602


    INSERT INTO OKL_TRX_SUBSIDY_POOLS(
      id,
      object_version_number,
      trx_type_code,
      source_type_code,
      source_object_id,
      subsidy_pool_id,
      dnz_asset_number,
      vendor_id,
      source_trx_date,
      trx_date,
      subsidy_id,
      trx_reason_code,
      trx_currency_code,
      trx_amount,
      subsidy_pool_currency_code,
      subsidy_pool_amount,
      conversion_rate,
      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)
    VALUES (
      l_okl_trx_subsidy_pools_rec.id,
      l_okl_trx_subsidy_pools_rec.object_version_number,
      l_okl_trx_subsidy_pools_rec.trx_type_code,
      l_okl_trx_subsidy_pools_rec.source_type_code,
      l_okl_trx_subsidy_pools_rec.source_object_id,
      l_okl_trx_subsidy_pools_rec.subsidy_pool_id,
      l_okl_trx_subsidy_pools_rec.dnz_asset_number,
      l_okl_trx_subsidy_pools_rec.vendor_id,
      l_okl_trx_subsidy_pools_rec.source_trx_date,
      l_okl_trx_subsidy_pools_rec.trx_date,
      l_okl_trx_subsidy_pools_rec.subsidy_id,
      l_okl_trx_subsidy_pools_rec.trx_reason_code,
      l_okl_trx_subsidy_pools_rec.trx_currency_code,
      l_okl_trx_subsidy_pools_rec.trx_amount,
      l_okl_trx_subsidy_pools_rec.subsidy_pool_currency_code,
      l_okl_trx_subsidy_pools_rec.subsidy_pool_amount,
      l_okl_trx_subsidy_pools_rec.conversion_rate,
      l_okl_trx_subsidy_pools_rec.attribute_category,
      l_okl_trx_subsidy_pools_rec.attribute1,
      l_okl_trx_subsidy_pools_rec.attribute2,
      l_okl_trx_subsidy_pools_rec.attribute3,
      l_okl_trx_subsidy_pools_rec.attribute4,
      l_okl_trx_subsidy_pools_rec.attribute5,
      l_okl_trx_subsidy_pools_rec.attribute6,
      l_okl_trx_subsidy_pools_rec.attribute7,
      l_okl_trx_subsidy_pools_rec.attribute8,
      l_okl_trx_subsidy_pools_rec.attribute9,
      l_okl_trx_subsidy_pools_rec.attribute10,
      l_okl_trx_subsidy_pools_rec.attribute11,
      l_okl_trx_subsidy_pools_rec.attribute12,
      l_okl_trx_subsidy_pools_rec.attribute13,
      l_okl_trx_subsidy_pools_rec.attribute14,
      l_okl_trx_subsidy_pools_rec.attribute15,
      l_okl_trx_subsidy_pools_rec.created_by,
      l_okl_trx_subsidy_pools_rec.creation_date,
      l_okl_trx_subsidy_pools_rec.last_updated_by,
      l_okl_trx_subsidy_pools_rec.last_update_date,
      l_okl_trx_subsidy_pools_rec.last_update_login);

Line: 1715


  END insert_row;

Line: 1719


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sixv_rec                     IN sixv_rec_type,
    x_sixv_rec                     OUT NOCOPY sixv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1729


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';

Line: 1745


      l_sixv_rec.LAST_UPDATE_DATE := l_sixv_rec.CREATION_DATE;

Line: 1746


      l_sixv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1747


      l_sixv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1811


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_trx_subsidy_pools_rec,
      lx_okl_trx_subsidy_pools_rec
    );

Line: 1860


  END insert_row;

Line: 1864


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sixv_tbl                     IN sixv_tbl_type,
    x_sixv_tbl                     OUT NOCOPY sixv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1875


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';

Line: 1889


          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_sixv_rec                     => p_sixv_tbl(i),
            x_sixv_rec                     => x_sixv_tbl(i));

Line: 1957


  END insert_row;

Line: 1962


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sixv_tbl                     IN sixv_tbl_type,
    x_sixv_tbl                     OUT NOCOPY sixv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1972


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';

Line: 1979


      insert_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKC_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_sixv_tbl                     => p_sixv_tbl,
        x_sixv_tbl                     => x_sixv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2021


  END insert_row;

Line: 2039


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TRX_SUBSIDY_POOLS
     WHERE ID = p_okl_trx_subsidy_pools_rec.id
       AND OBJECT_VERSION_NUMBER = p_okl_trx_subsidy_pools_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 2046


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TRX_SUBSIDY_POOLS
     WHERE ID = p_okl_trx_subsidy_pools_rec.id;

Line: 2087


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2096


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2376


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_okl_trx_subsidy_pools_rec    IN okl_trx_subsidy_pools_rec_type,
    x_okl_trx_subsidy_pools_rec    OUT NOCOPY okl_trx_subsidy_pools_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2385


    l_api_name                     CONSTANT VARCHAR2(30) := 'B_update_row';

Line: 2545


        IF (x_okl_trx_subsidy_pools_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_okl_trx_subsidy_pools_rec.last_updated_by := l_okl_trx_subsidy_pools_rec.last_updated_by;

Line: 2549


        IF (x_okl_trx_subsidy_pools_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_okl_trx_subsidy_pools_rec.last_update_date := l_okl_trx_subsidy_pools_rec.last_update_date;

Line: 2553


        IF (x_okl_trx_subsidy_pools_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_okl_trx_subsidy_pools_rec.last_update_login := l_okl_trx_subsidy_pools_rec.last_update_login;

Line: 2599


    UPDATE OKL_TRX_SUBSIDY_POOLS
    SET OBJECT_VERSION_NUMBER = LDefOklTrxSubsidyPoolsRec.object_version_number,
        TRX_TYPE_CODE = LDefOklTrxSubsidyPoolsRec.trx_type_code,
        SOURCE_TYPE_CODE = LDefOklTrxSubsidyPoolsRec.source_type_code,
        SOURCE_OBJECT_ID = LDefOklTrxSubsidyPoolsRec.source_object_id,
        SUBSIDY_POOL_ID = LDefOklTrxSubsidyPoolsRec.subsidy_pool_id,
        DNZ_ASSET_NUMBER = LDefOklTrxSubsidyPoolsRec.dnz_asset_number,
        VENDOR_ID = LDefOklTrxSubsidyPoolsRec.vendor_id,
        SOURCE_TRX_DATE = LDefOklTrxSubsidyPoolsRec.source_trx_date,
        TRX_DATE = LDefOklTrxSubsidyPoolsRec.trx_date,
        SUBSIDY_ID = LDefOklTrxSubsidyPoolsRec.subsidy_id,
        TRX_REASON_CODE = LDefOklTrxSubsidyPoolsRec.trx_reason_code,
        TRX_CURRENCY_CODE = LDefOklTrxSubsidyPoolsRec.trx_currency_code,
        TRX_AMOUNT = LDefOklTrxSubsidyPoolsRec.trx_amount,
        SUBSIDY_POOL_CURRENCY_CODE = LDefOklTrxSubsidyPoolsRec.subsidy_pool_currency_code,
        SUBSIDY_POOL_AMOUNT = LDefOklTrxSubsidyPoolsRec.subsidy_pool_amount,
        CONVERSION_RATE = LDefOklTrxSubsidyPoolsRec.conversion_rate,
        ATTRIBUTE_CATEGORY = LDefOklTrxSubsidyPoolsRec.attribute_category,
        ATTRIBUTE1 = LDefOklTrxSubsidyPoolsRec.attribute1,
        ATTRIBUTE2 = LDefOklTrxSubsidyPoolsRec.attribute2,
        ATTRIBUTE3 = LDefOklTrxSubsidyPoolsRec.attribute3,
        ATTRIBUTE4 = LDefOklTrxSubsidyPoolsRec.attribute4,
        ATTRIBUTE5 = LDefOklTrxSubsidyPoolsRec.attribute5,
        ATTRIBUTE6 = LDefOklTrxSubsidyPoolsRec.attribute6,
        ATTRIBUTE7 = LDefOklTrxSubsidyPoolsRec.attribute7,
        ATTRIBUTE8 = LDefOklTrxSubsidyPoolsRec.attribute8,
        ATTRIBUTE9 = LDefOklTrxSubsidyPoolsRec.attribute9,
        ATTRIBUTE10 = LDefOklTrxSubsidyPoolsRec.attribute10,
        ATTRIBUTE11 = LDefOklTrxSubsidyPoolsRec.attribute11,
        ATTRIBUTE12 = LDefOklTrxSubsidyPoolsRec.attribute12,
        ATTRIBUTE13 = LDefOklTrxSubsidyPoolsRec.attribute13,
        ATTRIBUTE14 = LDefOklTrxSubsidyPoolsRec.attribute14,
        ATTRIBUTE15 = LDefOklTrxSubsidyPoolsRec.attribute15,
        CREATED_BY = LDefOklTrxSubsidyPoolsRec.created_by,
        CREATION_DATE = LDefOklTrxSubsidyPoolsRec.creation_date,
        LAST_UPDATED_BY = LDefOklTrxSubsidyPoolsRec.last_updated_by,
        LAST_UPDATE_DATE = LDefOklTrxSubsidyPoolsRec.last_update_date,
        LAST_UPDATE_LOGIN = LDefOklTrxSubsidyPoolsRec.last_update_login
    WHERE ID = LDefOklTrxSubsidyPoolsRec.id;

Line: 2673


  END update_row;

Line: 2677


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sixv_rec                     IN sixv_rec_type,
    x_sixv_rec                     OUT NOCOPY sixv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2687


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';

Line: 2702


      l_sixv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2703


      l_sixv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2704


      l_sixv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2859


        IF (x_sixv_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_sixv_rec.last_updated_by := l_db_sixv_rec.last_updated_by;

Line: 2863


        IF (x_sixv_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_sixv_rec.last_update_date := l_db_sixv_rec.last_update_date;

Line: 2867


        IF (x_sixv_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_sixv_rec.last_update_login := l_db_sixv_rec.last_update_login;

Line: 2954


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_trx_subsidy_pools_rec,
      lx_okl_trx_subsidy_pools_rec
    );

Line: 3002


  END update_row;

Line: 3006


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sixv_tbl                     IN sixv_tbl_type,
    x_sixv_tbl                     OUT NOCOPY sixv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3017


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';

Line: 3031


          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_sixv_rec                     => p_sixv_tbl(i),
            x_sixv_rec                     => x_sixv_tbl(i));

Line: 3099


  END update_row;

Line: 3104


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sixv_tbl                     IN sixv_tbl_type,
    x_sixv_tbl                     OUT NOCOPY sixv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3114


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';

Line: 3121


      update_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKC_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_sixv_tbl                     => p_sixv_tbl,
        x_sixv_tbl                     => x_sixv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3163


  END update_row;

Line: 3171


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_okl_trx_subsidy_pools_rec    IN okl_trx_subsidy_pools_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3179


    l_api_name                     CONSTANT VARCHAR2(30) := 'B_delete_row';

Line: 3194


    DELETE FROM OKL_TRX_SUBSIDY_POOLS
     WHERE ID = p_okl_trx_subsidy_pools_rec.id;

Line: 3230


  END delete_row;

Line: 3234


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sixv_rec                     IN sixv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3243


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';

Line: 3267


    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_trx_subsidy_pools_rec
    );

Line: 3312


  END delete_row;

Line: 3316


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sixv_tbl                     IN sixv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3326


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';

Line: 3340


          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_sixv_rec                     => p_sixv_tbl(i));

Line: 3407


  END delete_row;

Line: 3412


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sixv_tbl                     IN sixv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3421


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';

Line: 3428


      delete_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKC_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_sixv_tbl                     => p_sixv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3469


  END delete_row;