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,
			REAMORT_BALANCE,
			REAMORT_DATE
      FROM Okl_Sif_Ret_Levels_V
     WHERE okl_sif_ret_levels_v.id = p_id;

Line: 177


              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,
              l_okl_sif_ret_levels_v_rec.reamort_balance,
              l_okl_sif_ret_levels_v_rec.reamort_date; -- racheruv 18.02.2013

Line: 224


    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,
			REAMORT_BALANCE,
			REAMORT_DATE -- racheruv 18.02.2013
      FROM Okl_Sif_Ret_Levels
     WHERE okl_sif_ret_levels.id = p_id;

Line: 300


              l_srl_rec.last_update_date,
              l_srl_rec.last_updated_by,
              l_srl_rec.last_update_login,
              l_srl_rec.rate,
              l_srl_rec.reamort_balance,
              l_srl_rec.reamort_date; -- racheruv 18.02.2013

Line: 437


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


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


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


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

Line: 708


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

Line: 788


    p_to.last_update_date := p_from.last_update_date;

Line: 789


    p_to.last_updated_by := p_from.last_updated_by;

Line: 790


    p_to.last_update_login := p_from.last_update_login;

Line: 830


    p_to.last_update_date := p_from.last_update_date;

Line: 831


    p_to.last_updated_by := p_from.last_updated_by;

Line: 832


    p_to.last_update_login := p_from.last_update_login;

Line: 1081


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


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

Line: 1126


    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,
	  reamort_balance,
	  reamort_date) -- racheruv 18.02.2013
    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
	  l_srl_rec.reamort_balance, -- racheruv 18.02.2013
	  l_srl_rec.reamort_date); -- racheruv 18.02.2013

Line: 1235


  END insert_row;

Line: 1239


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


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

Line: 1265


      l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := l_okl_sif_ret_levels_v_rec.CREATION_DATE;

Line: 1266


      l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1267


      l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1331


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

Line: 1380


  END insert_row;

Line: 1384


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


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

Line: 1409


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


  END insert_row;

Line: 1482


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


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

Line: 1499


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


  END insert_row;

Line: 1559


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


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SIF_RET_LEVELS
     WHERE ID = p_srl_rec.id;

Line: 1607


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1616


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1896


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


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

Line: 2045


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


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


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


    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,
        REAMORT_BALANCE = l_def_srl_rec.reamort_balance,
        REAMORT_DATE = l_def_srl_rec.reamort_date
    WHERE ID = l_def_srl_rec.id;

Line: 2184


  END update_row;

Line: 2188


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


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

Line: 2213


      l_okl_sif_ret_levels_v_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2214


      l_okl_sif_ret_levels_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2215


      l_okl_sif_ret_levels_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2350


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


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


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


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

Line: 2506


  END update_row;

Line: 2510


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


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

Line: 2535


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


  END update_row;

Line: 2608


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


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

Line: 2625


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


  END update_row;

Line: 2675


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


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

Line: 2698


    DELETE FROM OKL_SIF_RET_LEVELS
     WHERE ID = p_srl_rec.id;

Line: 2734


  END delete_row;

Line: 2738


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


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

Line: 2771


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

Line: 2816


  END delete_row;

Line: 2820


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


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

Line: 2844


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


  END delete_row;

Line: 2916


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


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

Line: 2932


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


  END delete_row;