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

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

Line: 101


    SELECT
            ID,
            LEVEL_INDEX_NUMBER,
            NUMBER_OF_PERIODS,
            SIR_ID,
            INDEX_NUMBER,
            LEVEL_TYPE,
            AMOUNT,
            ADVANCE_OR_ARREARS,
            PERIOD,
            LOCK_LEVEL_STEP,
            DAYS_IN_PERIOD,
            FIRST_PAYMENT_DATE,
            OBJECT_VERSION_NUMBER,
            STREAM_INTERFACE_ATTRIBUTE1,
            STREAM_INTERFACE_ATTRIBUTE2,
            STREAM_INTERFACE_ATTRIBUTE3,
            STREAM_INTERFACE_ATTRIBUTE4,
            STREAM_INTERFACE_ATTRIBUTE5,
            STREAM_INTERFACE_ATTRIBUTE6,
            STREAM_INTERFACE_ATTRIBUTE7,
            STREAM_INTERFACE_ATTRIBUTE8,
            STREAM_INTERFACE_ATTRIBUTE9,
            STREAM_INTERFACE_ATTRIBUTE10,
            STREAM_INTERFACE_ATTRIBUTE11,
            STREAM_INTERFACE_ATTRIBUTE12,
            STREAM_INTERFACE_ATTRIBUTE13,
            STREAM_INTERFACE_ATTRIBUTE14,
            STREAM_INTERFACE_ATTRIBUTE15,
            CREATION_DATE,
            CREATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_LOGIN,
			RATE --smahapat 10/12/03
      FROM Okl_Sif_Ret_Levels_V
     WHERE okl_sif_ret_levels_v.id = p_id;

Line: 175


              l_okl_sif_ret_levels_v_rec.last_update_date,
              l_okl_sif_ret_levels_v_rec.last_updated_by,
              l_okl_sif_ret_levels_v_rec.last_update_login,
              l_okl_sif_ret_levels_v_rec.rate; --smahapat 10/12/03

Line: 220


    SELECT
            ID,
            SIR_ID,
            INDEX_NUMBER,
            NUMBER_OF_PERIODS,
            LEVEL_INDEX_NUMBER,
            LEVEL_TYPE,
            AMOUNT,
            ADVANCE_OR_ARREARS,
            PERIOD,
            LOCK_LEVEL_STEP,
            DAYS_IN_PERIOD,
            FIRST_PAYMENT_DATE,
            OBJECT_VERSION_NUMBER,
            STREAM_INTERFACE_ATTRIBUTE1,
            STREAM_INTERFACE_ATTRIBUTE2,
            STREAM_INTERFACE_ATTRIBUTE3,
            STREAM_INTERFACE_ATTRIBUTE4,
            STREAM_INTERFACE_ATTRIBUTE5,
            STREAM_INTERFACE_ATTRIBUTE6,
            STREAM_INTERFACE_ATTRIBUTE7,
            STREAM_INTERFACE_ATTRIBUTE8,
            STREAM_INTERFACE_ATTRIBUTE9,
            STREAM_INTERFACE_ATTRIBUTE10,
            STREAM_INTERFACE_ATTRIBUTE11,
            STREAM_INTERFACE_ATTRIBUTE12,
            STREAM_INTERFACE_ATTRIBUTE13,
            STREAM_INTERFACE_ATTRIBUTE14,
            STREAM_INTERFACE_ATTRIBUTE15,
            CREATION_DATE,
            CREATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_LOGIN,
			RATE --smahapat 10/12/03
      FROM Okl_Sif_Ret_Levels
     WHERE okl_sif_ret_levels.id = p_id;

Line: 294


              l_srl_rec.last_update_date,
              l_srl_rec.last_updated_by,
              l_srl_rec.last_update_login,
              l_srl_rec.rate; --smahapat 10/12/03

Line: 429


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

Line: 432


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

Line: 435


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

Line: 484


    SELECT '1'
    FROM OKL_Sif_rets_V
    WHERE OKL_Sif_rets_V.id = p_id;

Line: 693


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

Line: 773


    p_to.last_update_date := p_from.last_update_date;

Line: 774


    p_to.last_updated_by := p_from.last_updated_by;

Line: 775


    p_to.last_update_login := p_from.last_update_login;

Line: 813


    p_to.last_update_date := p_from.last_update_date;

Line: 814


    p_to.last_updated_by := p_from.last_updated_by;

Line: 815


    p_to.last_update_login := p_from.last_update_login;

Line: 1062


  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_srl_rec                      IN srl_rec_type,
    x_srl_rec                      OUT NOCOPY srl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1071


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

Line: 1107


    INSERT INTO OKL_SIF_RET_LEVELS(
      id,
      sir_id,
      index_number,
      number_of_periods,
      level_index_number,
      level_type,
      amount,
      advance_or_arrears,
      period,
      lock_level_step,
      days_in_period,
      first_payment_date,
      object_version_number,
      stream_interface_attribute1,
      stream_interface_attribute2,
      stream_interface_attribute3,
      stream_interface_attribute4,
      stream_interface_attribute5,
      stream_interface_attribute6,
      stream_interface_attribute7,
      stream_interface_attribute8,
      stream_interface_attribute9,
      stream_interface_attribute10,
      stream_interface_attribute11,
      stream_interface_attribute12,
      stream_interface_attribute13,
      stream_interface_attribute14,
      stream_interface_attribute15,
      creation_date,
      created_by,
      last_update_date,
      last_updated_by,
      last_update_login,
	  rate) --smahapat 10/12/03
    VALUES (
      l_srl_rec.id,
      l_srl_rec.sir_id,
      l_srl_rec.index_number,
      l_srl_rec.number_of_periods,
      l_srl_rec.level_index_number,
      l_srl_rec.level_type,
      l_srl_rec.amount,
      l_srl_rec.advance_or_arrears,
      l_srl_rec.period,
      l_srl_rec.lock_level_step,
      l_srl_rec.days_in_period,
      l_srl_rec.first_payment_date,
      l_srl_rec.object_version_number,
      l_srl_rec.stream_interface_attribute1,
      l_srl_rec.stream_interface_attribute2,
      l_srl_rec.stream_interface_attribute3,
      l_srl_rec.stream_interface_attribute4,
      l_srl_rec.stream_interface_attribute5,
      l_srl_rec.stream_interface_attribute6,
      l_srl_rec.stream_interface_attribute7,
      l_srl_rec.stream_interface_attribute8,
      l_srl_rec.stream_interface_attribute9,
      l_srl_rec.stream_interface_attribute10,
      l_srl_rec.stream_interface_attribute11,
      l_srl_rec.stream_interface_attribute12,
      l_srl_rec.stream_interface_attribute13,
      l_srl_rec.stream_interface_attribute14,
      l_srl_rec.stream_interface_attribute15,
      l_srl_rec.creation_date,
      l_srl_rec.created_by,
      l_srl_rec.last_update_date,
      l_srl_rec.last_updated_by,
      l_srl_rec.last_update_login,
	  l_srl_rec.rate); --smahapat 10/12/03

Line: 1212


  END insert_row;

Line: 1216


  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_okl_sif_ret_levels_v_rec     IN okl_sif_ret_levels_v_rec_type,
    x_okl_sif_ret_levels_v_rec     OUT NOCOPY okl_sif_ret_levels_v_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1226


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

Line: 1242


      l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := l_okl_sif_ret_levels_v_rec.CREATION_DATE;

Line: 1243


      l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1244


      l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1308


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_srl_rec,
      lx_srl_rec
    );

Line: 1357


  END insert_row;

Line: 1361


  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_okl_sif_ret_levels_v_tbl     IN okl_sif_ret_levels_v_tbl_type,
    x_okl_sif_ret_levels_v_tbl     OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1372


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

Line: 1386


          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_okl_sif_ret_levels_v_rec     => p_okl_sif_ret_levels_v_tbl(i),
            x_okl_sif_ret_levels_v_rec     => x_okl_sif_ret_levels_v_tbl(i));

Line: 1454


  END insert_row;

Line: 1459


  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_okl_sif_ret_levels_v_tbl     IN okl_sif_ret_levels_v_tbl_type,
    x_okl_sif_ret_levels_v_tbl     OUT NOCOPY okl_sif_ret_levels_v_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1469


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

Line: 1476


      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_okl_sif_ret_levels_v_tbl     => p_okl_sif_ret_levels_v_tbl,
        x_okl_sif_ret_levels_v_tbl     => x_okl_sif_ret_levels_v_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1518


  END insert_row;

Line: 1536


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SIF_RET_LEVELS
     WHERE ID = p_srl_rec.id
       AND OBJECT_VERSION_NUMBER = p_srl_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1543


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SIF_RET_LEVELS
     WHERE ID = p_srl_rec.id;

Line: 1584


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1593


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1873


  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_srl_rec                      IN srl_rec_type,
    x_srl_rec                      OUT NOCOPY srl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1882


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

Line: 2022


        IF (x_srl_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_srl_rec.last_update_date := l_srl_rec.last_update_date;

Line: 2026


        IF (x_srl_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_srl_rec.last_updated_by := l_srl_rec.last_updated_by;

Line: 2030


        IF (x_srl_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_srl_rec.last_update_login := l_srl_rec.last_update_login;

Line: 2081


    UPDATE OKL_SIF_RET_LEVELS
    SET SIR_ID = l_def_srl_rec.sir_id,
        INDEX_NUMBER = l_def_srl_rec.index_number,
        NUMBER_OF_PERIODS = l_def_srl_rec.number_of_periods,
        LEVEL_INDEX_NUMBER = l_def_srl_rec.level_index_number,
        LEVEL_TYPE = l_def_srl_rec.level_type,
        AMOUNT = l_def_srl_rec.amount,
        ADVANCE_OR_ARREARS = l_def_srl_rec.advance_or_arrears,
        PERIOD = l_def_srl_rec.period,
        LOCK_LEVEL_STEP = l_def_srl_rec.lock_level_step,
        DAYS_IN_PERIOD = l_def_srl_rec.days_in_period,
        FIRST_PAYMENT_DATE = l_def_srl_rec.first_payment_date,
        OBJECT_VERSION_NUMBER = l_def_srl_rec.object_version_number,
        STREAM_INTERFACE_ATTRIBUTE1 = l_def_srl_rec.stream_interface_attribute1,
        STREAM_INTERFACE_ATTRIBUTE2 = l_def_srl_rec.stream_interface_attribute2,
        STREAM_INTERFACE_ATTRIBUTE3 = l_def_srl_rec.stream_interface_attribute3,
        STREAM_INTERFACE_ATTRIBUTE4 = l_def_srl_rec.stream_interface_attribute4,
        STREAM_INTERFACE_ATTRIBUTE5 = l_def_srl_rec.stream_interface_attribute5,
        STREAM_INTERFACE_ATTRIBUTE6 = l_def_srl_rec.stream_interface_attribute6,
        STREAM_INTERFACE_ATTRIBUTE7 = l_def_srl_rec.stream_interface_attribute7,
        STREAM_INTERFACE_ATTRIBUTE8 = l_def_srl_rec.stream_interface_attribute8,
        STREAM_INTERFACE_ATTRIBUTE9 = l_def_srl_rec.stream_interface_attribute9,
        STREAM_INTERFACE_ATTRIBUTE10 = l_def_srl_rec.stream_interface_attribute10,
        STREAM_INTERFACE_ATTRIBUTE11 = l_def_srl_rec.stream_interface_attribute11,
        STREAM_INTERFACE_ATTRIBUTE12 = l_def_srl_rec.stream_interface_attribute12,
        STREAM_INTERFACE_ATTRIBUTE13 = l_def_srl_rec.stream_interface_attribute13,
        STREAM_INTERFACE_ATTRIBUTE14 = l_def_srl_rec.stream_interface_attribute14,
        STREAM_INTERFACE_ATTRIBUTE15 = l_def_srl_rec.stream_interface_attribute15,
        CREATION_DATE = l_def_srl_rec.creation_date,
        CREATED_BY = l_def_srl_rec.created_by,
        LAST_UPDATE_DATE = l_def_srl_rec.last_update_date,
        LAST_UPDATED_BY = l_def_srl_rec.last_updated_by,
        LAST_UPDATE_LOGIN = l_def_srl_rec.last_update_login,
        RATE = l_def_srl_rec.rate
    WHERE ID = l_def_srl_rec.id;

Line: 2151


  END update_row;

Line: 2155


  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_okl_sif_ret_levels_v_rec     IN okl_sif_ret_levels_v_rec_type,
    x_okl_sif_ret_levels_v_rec     OUT NOCOPY okl_sif_ret_levels_v_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2165


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

Line: 2180


      l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2181


      l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2182


      l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2317


        IF (x_okl_sif_ret_levels_v_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_okl_sif_ret_levels_v_rec.last_update_date := l_db_okl_sif_ret_levels_v_rec.last_update_date;

Line: 2321


        IF (x_okl_sif_ret_levels_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_okl_sif_ret_levels_v_rec.last_updated_by := l_db_okl_sif_ret_levels_v_rec.last_updated_by;

Line: 2325


        IF (x_okl_sif_ret_levels_v_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_okl_sif_ret_levels_v_rec.last_update_login := l_db_okl_sif_ret_levels_v_rec.last_update_login;

Line: 2415


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_srl_rec,
      lx_srl_rec
    );

Line: 2463


  END update_row;

Line: 2467


  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_okl_sif_ret_levels_v_tbl     IN okl_sif_ret_levels_v_tbl_type,
    x_okl_sif_ret_levels_v_tbl     OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2478


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

Line: 2492


          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_okl_sif_ret_levels_v_rec     => p_okl_sif_ret_levels_v_tbl(i),
            x_okl_sif_ret_levels_v_rec     => x_okl_sif_ret_levels_v_tbl(i));

Line: 2560


  END update_row;

Line: 2565


  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_okl_sif_ret_levels_v_tbl     IN okl_sif_ret_levels_v_tbl_type,
    x_okl_sif_ret_levels_v_tbl     OUT NOCOPY okl_sif_ret_levels_v_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2575


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

Line: 2582


      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_okl_sif_ret_levels_v_tbl     => p_okl_sif_ret_levels_v_tbl,
        x_okl_sif_ret_levels_v_tbl     => x_okl_sif_ret_levels_v_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2624


  END update_row;

Line: 2632


  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_srl_rec                      IN srl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2640


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

Line: 2655


    DELETE FROM OKL_SIF_RET_LEVELS
     WHERE ID = p_srl_rec.id;

Line: 2691


  END delete_row;

Line: 2695


  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_okl_sif_ret_levels_v_rec     IN okl_sif_ret_levels_v_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2704


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

Line: 2728


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

Line: 2773


  END delete_row;

Line: 2777


  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_okl_sif_ret_levels_v_tbl     IN okl_sif_ret_levels_v_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2787


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

Line: 2801


          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_okl_sif_ret_levels_v_rec     => p_okl_sif_ret_levels_v_tbl(i));

Line: 2868


  END delete_row;

Line: 2873


  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_okl_sif_ret_levels_v_tbl     IN okl_sif_ret_levels_v_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2882


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

Line: 2889


      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_okl_sif_ret_levels_v_tbl     => p_okl_sif_ret_levels_v_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2930


  END delete_row;