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

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

Line: 101


    SELECT
            ID,
            CFO_ID,
            STS_CODE,
            STY_ID,
            CFT_CODE,
            DUE_ARREARS_YN,
            START_DATE,
            NUMBER_OF_ADVANCE_PERIODS,
            DNZ_KHR_ID,
            DNZ_QTE_ID,
            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,
            OBJECT_VERSION_NUMBER
      FROM Okl_Cash_Flows_V
     WHERE okl_cash_flows_v.id  = p_id;

Line: 171


              l_cafv_rec.last_updated_by,
              l_cafv_rec.last_update_date,
              l_cafv_rec.last_update_login,
              l_cafv_rec.object_version_number;

Line: 216


    SELECT
            ID,
            CFO_ID,
            STS_CODE,
            STY_ID,
            CFT_CODE,
            DUE_ARREARS_YN,
            START_DATE,
            NUMBER_OF_ADVANCE_PERIODS,
            DNZ_KHR_ID,
            DNZ_QTE_ID,
            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,
            OBJECT_VERSION_NUMBER
      FROM Okl_Cash_Flows
     WHERE okl_cash_flows.id    = p_id;

Line: 286


              l_caf_rec.last_updated_by,
              l_caf_rec.last_update_date,
              l_caf_rec.last_update_login,
              l_caf_rec.object_version_number;

Line: 415


    IF (l_cafv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
      l_cafv_rec.last_updated_by := NULL;

Line: 418


    IF (l_cafv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
      l_cafv_rec.last_update_date := NULL;

Line: 421


    IF (l_cafv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
      l_cafv_rec.last_update_login := NULL;

Line: 467


      SELECT 'x'
      FROM   Okl_Cash_Flow_Objects_V
      WHERE  Okl_Cash_Flow_Objects_V.id  = p_id;

Line: 518


     SELECT 'x'
     FROM   Fnd_Lookup_Values
     WHERE  fnd_lookup_values.lookup_code = p_lookup_code
     AND    fnd_lookup_values.lookup_type = p_lookup_type;

Line: 571


      SELECT 'x'
      FROM   Okl_strm_type_V
      WHERE  Okl_strm_type_V.id  = p_id;

Line: 620


     SELECT 'x'
     FROM   Fnd_Lookup_Values
     WHERE  fnd_lookup_values.lookup_code = p_lookup_code
     AND    fnd_lookup_values.lookup_type = p_lookup_type  ;

Line: 881


      p_to.last_updated_by := p_from.last_updated_by;

Line: 882


      p_to.last_update_date := p_from.last_update_date;

Line: 883


      p_to.last_update_login := p_from.last_update_login;

Line: 919


      p_to.last_updated_by := p_from.last_updated_by;

Line: 920


      p_to.last_update_date := p_from.last_update_date;

Line: 921


      p_to.last_update_login := p_from.last_update_login;

Line: 1175


    PROCEDURE insert_row(
      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_caf_rec                      IN caf_rec_type,
      x_caf_rec                      OUT NOCOPY caf_rec_type) IS

      l_api_version                  CONSTANT NUMBER := 1;

Line: 1184


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

Line: 1220


      INSERT INTO OKL_CASH_FLOWS(
        id,
        cfo_id,
        sts_code,
        sty_id,
        cft_code,
        due_arrears_yn,
        start_date,
        number_of_advance_periods,
        dnz_khr_id,
        dnz_qte_id,
        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,
        object_version_number)
      VALUES (
        l_caf_rec.id,
        l_caf_rec.cfo_id,
        l_caf_rec.sts_code,
        l_caf_rec.sty_id,
        l_caf_rec.cft_code,
        l_caf_rec.due_arrears_yn,
        l_caf_rec.start_date,
        l_caf_rec.number_of_advance_periods,
        l_caf_rec.dnz_khr_id,
        l_caf_rec.dnz_qte_id,
        l_caf_rec.attribute_category,
        l_caf_rec.attribute1,
        l_caf_rec.attribute2,
        l_caf_rec.attribute3,
        l_caf_rec.attribute4,
        l_caf_rec.attribute5,
        l_caf_rec.attribute6,
        l_caf_rec.attribute7,
        l_caf_rec.attribute8,
        l_caf_rec.attribute9,
        l_caf_rec.attribute10,
        l_caf_rec.attribute11,
        l_caf_rec.attribute12,
        l_caf_rec.attribute13,
        l_caf_rec.attribute14,
        l_caf_rec.attribute15,
        l_caf_rec.created_by,
        l_caf_rec.creation_date,
        l_caf_rec.last_updated_by,
        l_caf_rec.last_update_date,
        l_caf_rec.last_update_login,
        l_caf_rec.object_version_number);

Line: 1321


    END insert_row;

Line: 1325


    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_cafv_rec                     IN cafv_rec_type,
      x_cafv_rec                     OUT NOCOPY cafv_rec_type) IS

      l_api_version                  CONSTANT NUMBER := 1;

Line: 1335


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

Line: 1351


        l_cafv_rec.LAST_UPDATE_DATE := l_cafv_rec.CREATION_DATE;

Line: 1352


        l_cafv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1353


        l_cafv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1422


      insert_row(
        p_init_msg_list,
        l_return_status,
        x_msg_count,
        x_msg_data,
        l_caf_rec,
        lx_caf_rec
      );

Line: 1471


    END insert_row;

Line: 1475


    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_cafv_tbl                     IN cafv_tbl_type,
      x_cafv_tbl                     OUT NOCOPY cafv_tbl_type,
      px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

      l_api_version                  CONSTANT NUMBER := 1;

Line: 1486


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

Line: 1500


            insert_row (
              p_api_version                  => p_api_version,
              p_init_msg_list                => OKL_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_cafv_rec                     => p_cafv_tbl(i),
              x_cafv_rec                     => x_cafv_tbl(i));

Line: 1568


    END insert_row;

Line: 1575


    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_cafv_tbl                     IN cafv_tbl_type,
      x_cafv_tbl                     OUT NOCOPY cafv_tbl_type) IS

      l_api_version                  CONSTANT NUMBER := 1;

Line: 1585


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

Line: 1592


        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKL_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_cafv_tbl                     => p_cafv_tbl,
          x_cafv_tbl                     => x_cafv_tbl,
          px_error_tbl                   => l_error_tbl);

Line: 1634


    END insert_row;

Line: 1641


    PROCEDURE insert_row_bulk(
      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_cafv_tbl                     IN cafv_tbl_type,
      x_cafv_tbl                     OUT NOCOPY cafv_tbl_type) IS

      l_api_version                  CONSTANT NUMBER := 1;

Line: 1651


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

Line: 1677


    in_last_updated_by Number15TabTyp;

Line: 1678


    in_last_update_date DateTabTyp;

Line: 1679


    in_last_update_login Number15TabTyp;

Line: 1731


      l_cafv_rec.LAST_UPDATE_DATE := l_cafv_rec.CREATION_DATE;

Line: 1732


      l_cafv_rec.LAST_UPDATED_BY := l_user_id;

Line: 1733


      l_cafv_rec.LAST_UPDATE_LOGIN := l_login_id;

Line: 1774


      in_last_updated_by(j) := l_cafv_rec.last_updated_by;

Line: 1775


      in_last_update_date(j) := l_cafv_rec.last_update_date;

Line: 1776


      in_last_update_login(j) := l_cafv_rec.last_update_login;

Line: 1785


      INSERT INTO OKL_CASH_FLOWS(
        id,
        cfo_id,
        sts_code,
        sty_id,
        cft_code,
        due_arrears_yn,
        start_date,
        number_of_advance_periods,
        dnz_khr_id,
        dnz_qte_id,
        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,
        object_version_number)
      VALUES (
        in_id(i),
        in_cfo_id(i),
        in_sts_code(i),
        in_sty_id(i),
        in_cft_code(i),
        in_due_arrears_yn(i),
        in_start_date(i),
        in_number_of_advance_periods(i),
        in_dnz_khr_id(i),
        in_dnz_qte_id(i),
        in_attribute_category(i),
        in_attribute1(i),
        in_attribute2(i),
        in_attribute3(i),
        in_attribute4(i),
        in_attribute5(i),
        in_attribute6(i),
        in_attribute7(i),
        in_attribute8(i),
        in_attribute9(i),
        in_attribute10(i),
        in_attribute11(i),
        in_attribute12(i),
        in_attribute13(i),
        in_attribute14(i),
        in_attribute15(i),
        in_created_by(i),
        in_creation_date(i),
        in_last_updated_by(i),
        in_last_update_date(i),
        in_last_update_login(i),
        in_object_version_number(i));

Line: 1886


    END insert_row_bulk;

Line: 1905


      SELECT OBJECT_VERSION_NUMBER
        FROM OKL_CASH_FLOWS
       WHERE ID = p_caf_rec.id
         AND OBJECT_VERSION_NUMBER = p_caf_rec.object_version_number
      FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1912


      SELECT OBJECT_VERSION_NUMBER
        FROM OKL_CASH_FLOWS
       WHERE ID = p_caf_rec.id;

Line: 1953


        OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1962


        OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2242


    PROCEDURE update_row(
      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_caf_rec                      IN caf_rec_type,
      x_caf_rec                      OUT NOCOPY caf_rec_type) IS

      l_api_version                  CONSTANT NUMBER := 1;

Line: 2251


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

Line: 2383


          IF (x_caf_rec.last_updated_by = OKL_API.G_MISS_NUM)
          THEN
            x_caf_rec.last_updated_by := l_caf_rec.last_updated_by;

Line: 2387


          IF (x_caf_rec.last_update_date = OKL_API.G_MISS_DATE)
          THEN
            x_caf_rec.last_update_date := l_caf_rec.last_update_date;

Line: 2391


          IF (x_caf_rec.last_update_login = OKL_API.G_MISS_NUM)
          THEN
            x_caf_rec.last_update_login := l_caf_rec.last_update_login;

Line: 2441


      UPDATE OKL_CASH_FLOWS
      SET CFO_ID = l_def_caf_rec.cfo_id,
          STS_CODE = l_def_caf_rec.sts_code,
          STY_ID = l_def_caf_rec.sty_id,
          CFT_CODE = l_def_caf_rec.cft_code,
          DUE_ARREARS_YN = l_def_caf_rec.due_arrears_yn,
          START_DATE = l_def_caf_rec.start_date,
          NUMBER_OF_ADVANCE_PERIODS = l_def_caf_rec.number_of_advance_periods,
          DNZ_KHR_ID = l_def_caf_rec.dnz_khr_id,
          DNZ_QTE_ID = l_def_caf_rec.dnz_qte_id,
          ATTRIBUTE_CATEGORY = l_def_caf_rec.attribute_category,
          ATTRIBUTE1 = l_def_caf_rec.attribute1,
          ATTRIBUTE2 = l_def_caf_rec.attribute2,
          ATTRIBUTE3 = l_def_caf_rec.attribute3,
          ATTRIBUTE4 = l_def_caf_rec.attribute4,
          ATTRIBUTE5 = l_def_caf_rec.attribute5,
          ATTRIBUTE6 = l_def_caf_rec.attribute6,
          ATTRIBUTE7 = l_def_caf_rec.attribute7,
          ATTRIBUTE8 = l_def_caf_rec.attribute8,
          ATTRIBUTE9 = l_def_caf_rec.attribute9,
          ATTRIBUTE10 = l_def_caf_rec.attribute10,
          ATTRIBUTE11 = l_def_caf_rec.attribute11,
          ATTRIBUTE12 = l_def_caf_rec.attribute12,
          ATTRIBUTE13 = l_def_caf_rec.attribute13,
          ATTRIBUTE14 = l_def_caf_rec.attribute14,
          ATTRIBUTE15 = l_def_caf_rec.attribute15,
          CREATED_BY = l_def_caf_rec.created_by,
          CREATION_DATE = l_def_caf_rec.creation_date,
          LAST_UPDATED_BY = l_def_caf_rec.last_updated_by,
          LAST_UPDATE_DATE = l_def_caf_rec.last_update_date,
          LAST_UPDATE_LOGIN = l_def_caf_rec.last_update_login,
          OBJECT_VERSION_NUMBER = l_def_caf_rec.object_version_number
      WHERE ID = l_def_caf_rec.id;

Line: 2509


    END update_row;

Line: 2513


    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_cafv_rec                     IN cafv_rec_type,
      x_cafv_rec                     OUT NOCOPY cafv_rec_type) IS

      l_api_version                  CONSTANT NUMBER := 1;

Line: 2523


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

Line: 2538


        l_cafv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2539


        l_cafv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2540


        l_cafv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2671


          IF (x_cafv_rec.last_updated_by = OKL_API.G_MISS_NUM)
          THEN
            x_cafv_rec.last_updated_by := l_db_cafv_rec.last_updated_by;

Line: 2675


          IF (x_cafv_rec.last_update_date = OKL_API.G_MISS_DATE)
          THEN
            x_cafv_rec.last_update_date := l_db_cafv_rec.last_update_date;

Line: 2679


          IF (x_cafv_rec.last_update_login = OKL_API.G_MISS_NUM)
          THEN
            x_cafv_rec.last_update_login := l_db_cafv_rec.last_update_login;

Line: 2768


      update_row(
        p_init_msg_list,
        l_return_status,
        x_msg_count,
        x_msg_data,
        l_caf_rec,
        lx_caf_rec
      );

Line: 2816


    END update_row;

Line: 2820


    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_cafv_tbl                     IN cafv_tbl_type,
      x_cafv_tbl                     OUT NOCOPY cafv_tbl_type,
      px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

      l_api_version                  CONSTANT NUMBER := 1;

Line: 2831


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

Line: 2845


            update_row (
              p_api_version                  => p_api_version,
              p_init_msg_list                => OKL_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_cafv_rec                     => p_cafv_tbl(i),
              x_cafv_rec                     => x_cafv_tbl(i));

Line: 2913


    END update_row;

Line: 2920


    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_cafv_tbl                     IN cafv_tbl_type,
      x_cafv_tbl                     OUT NOCOPY cafv_tbl_type) IS

      l_api_version                  CONSTANT NUMBER := 1;

Line: 2930


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

Line: 2937


        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKL_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_cafv_tbl                     => p_cafv_tbl,
          x_cafv_tbl                     => x_cafv_tbl,
          px_error_tbl                   => l_error_tbl);

Line: 2979


    END update_row;

Line: 2987


    PROCEDURE delete_row(
      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_caf_rec                      IN caf_rec_type) IS

      l_api_version                  CONSTANT NUMBER := 1;

Line: 2995


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

Line: 3010


      DELETE FROM OKL_CASH_FLOWS
       WHERE ID = p_caf_rec.id;

Line: 3046


    END delete_row;

Line: 3050


    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_cafv_rec                     IN cafv_rec_type) IS

      l_api_version                  CONSTANT NUMBER := 1;

Line: 3059


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

Line: 3083


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

Line: 3128


    END delete_row;

Line: 3132


    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_cafv_tbl                     IN cafv_tbl_type,
      px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

      l_api_version                  CONSTANT NUMBER := 1;

Line: 3142


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

Line: 3156


            delete_row (
              p_api_version                  => p_api_version,
              p_init_msg_list                => OKL_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_cafv_rec                     => p_cafv_tbl(i));

Line: 3223


    END delete_row;

Line: 3228


    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_cafv_tbl                     IN cafv_tbl_type) IS

      l_api_version                  CONSTANT NUMBER := 1;

Line: 3237


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

Line: 3244


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

Line: 3285


    END delete_row;