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

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

Line: 101


    SELECT
            ID,
            CAF_ID,
            AMOUNT,
            NUMBER_OF_PERIODS,
            FQY_CODE,
            LEVEL_SEQUENCE,
            STUB_DAYS,
            STUB_AMOUNT,
            START_DATE,
            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,
            OBJECT_VERSION_NUMBER,
            missing_pmt_flag
      FROM Okl_Cash_Flow_Levels_V
     WHERE okl_cash_flow_levels_v.id = p_id;

Line: 172


              l_cflv_rec.last_updated_by,
              l_cflv_rec.last_update_date,
              l_cflv_rec.last_update_login,
              l_cflv_rec.object_version_number,
              l_cflv_rec.missing_pmt_flag;

Line: 218


    SELECT
            ID,
            CAF_ID,
            AMOUNT,
            NUMBER_OF_PERIODS,
            FQY_CODE,
            LEVEL_SEQUENCE,
            STUB_DAYS,
            STUB_AMOUNT,
            START_DATE,
            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,
            OBJECT_VERSION_NUMBER,
            missing_pmt_flag
      FROM Okl_Cash_Flow_Levels
     WHERE okl_cash_flow_levels.id = p_id;

Line: 289


              l_cfl_rec.last_updated_by,
              l_cfl_rec.last_update_date,
              l_cfl_rec.last_update_login,
              l_cfl_rec.object_version_number,
              l_cfl_rec.missing_pmt_flag;

Line: 419


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

Line: 422


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

Line: 425


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

Line: 474


      SELECT 'x'
      FROM Okl_Cash_Flows_V
      WHERE okl_cash_flows_v.id  = p_id;

Line: 643


     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: 921


      SELECT 'x'
        FROM Okl_Cash_Flows_V
       WHERE okl_cash_flows_v.id  = p_id;

Line: 927


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

Line: 1147


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1148


    p_to.last_update_date := p_from.last_update_date;

Line: 1149


    p_to.last_update_login := p_from.last_update_login;

Line: 1186


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1187


    p_to.last_update_date := p_from.last_update_date;

Line: 1188


    p_to.last_update_login := p_from.last_update_login;

Line: 1440


  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_cfl_rec                      IN cfl_rec_type,
    x_cfl_rec                      OUT NOCOPY cfl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1449


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

Line: 1485


    INSERT INTO OKL_CASH_FLOW_LEVELS(
      id,
      caf_id,
      amount,
      number_of_periods,
      fqy_code,
      level_sequence,
      stub_days,
      stub_amount,
      start_date,
      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,
      object_version_number,
      missing_pmt_flag)
    VALUES (
      l_cfl_rec.id,
      l_cfl_rec.caf_id,
      l_cfl_rec.amount,
      l_cfl_rec.number_of_periods,
      l_cfl_rec.fqy_code,
      l_cfl_rec.level_sequence,
      l_cfl_rec.stub_days,
      l_cfl_rec.stub_amount,
      l_cfl_rec.start_date,
      l_cfl_rec.rate,
      l_cfl_rec.attribute_category,
      l_cfl_rec.attribute1,
      l_cfl_rec.attribute2,
      l_cfl_rec.attribute3,
      l_cfl_rec.attribute4,
      l_cfl_rec.attribute5,
      l_cfl_rec.attribute6,
      l_cfl_rec.attribute7,
      l_cfl_rec.attribute8,
      l_cfl_rec.attribute9,
      l_cfl_rec.attribute10,
      l_cfl_rec.attribute11,
      l_cfl_rec.attribute12,
      l_cfl_rec.attribute13,
      l_cfl_rec.attribute14,
      l_cfl_rec.attribute15,
      l_cfl_rec.created_by,
      l_cfl_rec.creation_date,
      l_cfl_rec.last_updated_by,
      l_cfl_rec.last_update_date,
      l_cfl_rec.last_update_login,
      l_cfl_rec.object_version_number,
      l_cfl_rec.missing_pmt_flag);

Line: 1588


  END insert_row;

Line: 1592


  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_cflv_rec                     IN cflv_rec_type,
    x_cflv_rec                     OUT NOCOPY cflv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1602


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

Line: 1618


      l_cflv_rec.LAST_UPDATE_DATE := l_cflv_rec.CREATION_DATE;

Line: 1619


      l_cflv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1620


      l_cflv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1688


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_cfl_rec,
      lx_cfl_rec
    );

Line: 1737


  END insert_row;

Line: 1741


  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_cflv_tbl                     IN cflv_tbl_type,
    x_cflv_tbl                     OUT NOCOPY cflv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1752


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

Line: 1766


          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_cflv_rec                     => p_cflv_tbl(i),
            x_cflv_rec                     => x_cflv_tbl(i));

Line: 1834


  END insert_row;

Line: 1841


  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_cflv_tbl                     IN cflv_tbl_type,
    x_cflv_tbl                     OUT NOCOPY cflv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1851


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

Line: 1858


      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_cflv_tbl                     => p_cflv_tbl,
        x_cflv_tbl                     => x_cflv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1900


  END insert_row;

Line: 1907


  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_cflv_tbl                     IN cflv_tbl_type,
    x_cflv_tbl                     OUT NOCOPY cflv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1917


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

Line: 1943


    in_last_updated_by Number15TabTyp;

Line: 1944


    in_last_update_date DateTabTyp;

Line: 1945


    in_last_update_login Number15TabTyp;

Line: 1993


      l_cflv_rec.LAST_UPDATE_DATE := l_cflv_rec.CREATION_DATE;

Line: 1994


      l_cflv_rec.LAST_UPDATED_BY := l_user_id;

Line: 1995


      l_cflv_rec.LAST_UPDATE_LOGIN := l_login_id;

Line: 2036


      in_last_updated_by(j) := l_cflv_rec.last_updated_by;

Line: 2037


      in_last_update_date(j) := l_cflv_rec.last_update_date;

Line: 2038


      in_last_update_login(j) := l_cflv_rec.last_update_login;

Line: 2047


    INSERT INTO OKL_CASH_FLOW_LEVELS(
      id,
      caf_id,
      amount,
      number_of_periods,
      fqy_code,
      level_sequence,
      stub_days,
      stub_amount,
      start_date,
      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,
      object_version_number,
      missing_pmt_flag)
    VALUES (
      in_id(i),
      in_caf_id(i),
      in_amount(i),
      in_number_of_periods(i),
      in_fqy_code(i),
      in_level_sequence(i),
      in_stub_days(i),
      in_stub_amount(i),
      in_start_date(i),
      in_rate(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),
      in_missing_pmt_flag(i));

Line: 2151


  END insert_row_bulk;

Line: 2170


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CASH_FLOW_LEVELS
     WHERE ID = p_cfl_rec.id
       AND OBJECT_VERSION_NUMBER = p_cfl_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 2177


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CASH_FLOW_LEVELS
     WHERE ID = p_cfl_rec.id;

Line: 2218


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2227


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2507


  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_cfl_rec                      IN cfl_rec_type,
    x_cfl_rec                      OUT NOCOPY cfl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2516


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

Line: 2651


        IF (x_cfl_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_cfl_rec.last_updated_by := l_cfl_rec.last_updated_by;

Line: 2655


        IF (x_cfl_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_cfl_rec.last_update_date := l_cfl_rec.last_update_date;

Line: 2659


        IF (x_cfl_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_cfl_rec.last_update_login := l_cfl_rec.last_update_login;

Line: 2713


    UPDATE OKL_CASH_FLOW_LEVELS
    SET CAF_ID = l_def_cfl_rec.caf_id,
        AMOUNT = l_def_cfl_rec.amount,
        NUMBER_OF_PERIODS = l_def_cfl_rec.number_of_periods,
        FQY_CODE = l_def_cfl_rec.fqy_code,
        LEVEL_SEQUENCE = l_def_cfl_rec.level_sequence,
        STUB_DAYS = l_def_cfl_rec.stub_days,
        STUB_AMOUNT = l_def_cfl_rec.stub_amount,
        START_DATE = l_def_cfl_rec.start_date,
        RATE = l_def_cfl_rec.rate,
        ATTRIBUTE_CATEGORY = l_def_cfl_rec.attribute_category,
        ATTRIBUTE1 = l_def_cfl_rec.attribute1,
        ATTRIBUTE2 = l_def_cfl_rec.attribute2,
        ATTRIBUTE3 = l_def_cfl_rec.attribute3,
        ATTRIBUTE4 = l_def_cfl_rec.attribute4,
        ATTRIBUTE5 = l_def_cfl_rec.attribute5,
        ATTRIBUTE6 = l_def_cfl_rec.attribute6,
        ATTRIBUTE7 = l_def_cfl_rec.attribute7,
        ATTRIBUTE8 = l_def_cfl_rec.attribute8,
        ATTRIBUTE9 = l_def_cfl_rec.attribute9,
        ATTRIBUTE10 = l_def_cfl_rec.attribute10,
        ATTRIBUTE11 = l_def_cfl_rec.attribute11,
        ATTRIBUTE12 = l_def_cfl_rec.attribute12,
        ATTRIBUTE13 = l_def_cfl_rec.attribute13,
        ATTRIBUTE14 = l_def_cfl_rec.attribute14,
        ATTRIBUTE15 = l_def_cfl_rec.attribute15,
        CREATED_BY = l_def_cfl_rec.created_by,
        CREATION_DATE = l_def_cfl_rec.creation_date,
        LAST_UPDATED_BY = l_def_cfl_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_cfl_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_cfl_rec.last_update_login,
        OBJECT_VERSION_NUMBER = l_def_cfl_rec.object_version_number,
        missing_pmt_flag = l_def_cfl_rec.missing_pmt_flag
    WHERE ID = l_def_cfl_rec.id;

Line: 2782


  END update_row;

Line: 2786


  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_cflv_rec                     IN cflv_rec_type,
    x_cflv_rec                     OUT NOCOPY cflv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2796


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

Line: 2811


      l_cflv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2812


      l_cflv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2813


      l_cflv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2946


        IF (x_cflv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_cflv_rec.last_updated_by := l_db_cflv_rec.last_updated_by;

Line: 2950


        IF (x_cflv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_cflv_rec.last_update_date := l_db_cflv_rec.last_update_date;

Line: 2954


        IF (x_cflv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_cflv_rec.last_update_login := l_db_cflv_rec.last_update_login;

Line: 3056


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_cfl_rec,
      lx_cfl_rec
    );

Line: 3104


  END update_row;

Line: 3108


  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_cflv_tbl                     IN cflv_tbl_type,
    x_cflv_tbl                     OUT NOCOPY cflv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3119


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

Line: 3133


          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_cflv_rec                     => p_cflv_tbl(i),
            x_cflv_rec                     => x_cflv_tbl(i));

Line: 3201


  END update_row;

Line: 3208


  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_cflv_tbl                     IN cflv_tbl_type,
    x_cflv_tbl                     OUT NOCOPY cflv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3218


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

Line: 3225


      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_cflv_tbl                     => p_cflv_tbl,
        x_cflv_tbl                     => x_cflv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3267


  END update_row;

Line: 3275


  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_cfl_rec                      IN cfl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3283


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

Line: 3298


    DELETE FROM OKL_CASH_FLOW_LEVELS
     WHERE ID = p_cfl_rec.id;

Line: 3334


  END delete_row;

Line: 3338


  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_cflv_rec                     IN cflv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3347


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

Line: 3371


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

Line: 3416


  END delete_row;

Line: 3420


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

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3430


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

Line: 3444


          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_cflv_rec                     => p_cflv_tbl(i));

Line: 3511


  END delete_row;

Line: 3516


  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_cflv_tbl                     IN cflv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3525


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

Line: 3532


      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_cflv_tbl                     => p_cflv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3573


  END delete_row;