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

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

Line: 44


    SELECT
            ID,
            SFE_TYPE,
            DATE_START,
            DATE_PAID,
            AMOUNT,
            IDC_ACCOUNTING_FLAG,
            INCOME_OR_EXPENSE,
            DESCRIPTION,
            FEE_INDEX_NUMBER,
            LEVEL_INDEX_NUMBER,
            ADVANCE_OR_ARREARS,
            LEVEL_TYPE,
            LOCK_LEVEL_STEP,
            PERIOD,
            NUMBER_OF_PERIODS,
            LEVEL_LINE_NUMBER,
            SIF_ID,
            KLE_ID,
            SIL_ID,
       	    RATE,
       	    -- mvasudev, 05/13/2002
       	    QUERY_LEVEL_YN,
       	    STRUCTURE,
       	    DAYS_IN_PERIOD,
       	    --
       	    cash_effect_yn,
       	    tax_effect_yn,
            days_in_month,
            days_in_year,
            balance_type_code,
            OBJECT_VERSION_NUMBER,
            STREAM_INTERFACE_ATTRIBUTE01,
            STREAM_INTERFACE_ATTRIBUTE02,
            STREAM_INTERFACE_ATTRIBUTE03,
            STREAM_INTERFACE_ATTRIBUTE04,
            STREAM_INTERFACE_ATTRIBUTE05,
            STREAM_INTERFACE_ATTRIBUTE06,
            STREAM_INTERFACE_ATTRIBUTE07,
            STREAM_INTERFACE_ATTRIBUTE08,
            STREAM_INTERFACE_ATTRIBUTE09,
            STREAM_INTERFACE_ATTRIBUTE10,
            STREAM_INTERFACE_ATTRIBUTE11,
            STREAM_INTERFACE_ATTRIBUTE12,
            STREAM_INTERFACE_ATTRIBUTE13,
            STREAM_INTERFACE_ATTRIBUTE14,
            STREAM_INTERFACE_ATTRIBUTE15,
            STREAM_INTERFACE_ATTRIBUTE16,
            STREAM_INTERFACE_ATTRIBUTE17,
            STREAM_INTERFACE_ATTRIBUTE18,
            STREAM_INTERFACE_ATTRIBUTE19,
            STREAM_INTERFACE_ATTRIBUTE20,
            CREATED_BY,
            LAST_UPDATED_BY,
            CREATION_DATE,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            DOWN_PAYMENT_AMOUNT
      FROM Okl_Sif_Fees
     WHERE okl_sif_fees.id      = p_id;

Line: 163


              l_sfe_rec.LAST_UPDATED_BY,
              l_sfe_rec.CREATION_DATE,
              l_sfe_rec.LAST_UPDATE_DATE,
              l_sfe_rec.LAST_UPDATE_LOGIN,
              l_sfe_rec.DOWN_PAYMENT_AMOUNT;

Line: 188


    SELECT
            ID,
            SFE_TYPE,
            DATE_START,
            DATE_PAID,
            AMOUNT,
            IDC_ACCOUNTING_FLAG,
            INCOME_OR_EXPENSE,
            DESCRIPTION,
            FEE_INDEX_NUMBER,
            LEVEL_INDEX_NUMBER,
            ADVANCE_OR_ARREARS,
            LEVEL_TYPE,
            LOCK_LEVEL_STEP,
            PERIOD,
            NUMBER_OF_PERIODS,
            LEVEL_LINE_NUMBER,
            SIF_ID,
            KLE_ID,
            SIL_ID,
            RATE,
            -- mvasudev, 05/13/2002
            QUERY_LEVEL_YN,
            STRUCTURE,
            DAYS_IN_PERIOD,
            --
            OBJECT_VERSION_NUMBER,
       	    cash_effect_yn,
            tax_effect_yn,
            days_in_month,
            days_in_year,
            balance_type_code    ,
            STREAM_INTERFACE_ATTRIBUTE01,
            STREAM_INTERFACE_ATTRIBUTE02,
            STREAM_INTERFACE_ATTRIBUTE03,
            STREAM_INTERFACE_ATTRIBUTE04,
            STREAM_INTERFACE_ATTRIBUTE05,
            STREAM_INTERFACE_ATTRIBUTE06,
            STREAM_INTERFACE_ATTRIBUTE07,
            STREAM_INTERFACE_ATTRIBUTE08,
            STREAM_INTERFACE_ATTRIBUTE09,
            STREAM_INTERFACE_ATTRIBUTE10,
            STREAM_INTERFACE_ATTRIBUTE11,
            STREAM_INTERFACE_ATTRIBUTE12,
            STREAM_INTERFACE_ATTRIBUTE13,
            STREAM_INTERFACE_ATTRIBUTE14,
            STREAM_INTERFACE_ATTRIBUTE15,
            STREAM_INTERFACE_ATTRIBUTE16,
            STREAM_INTERFACE_ATTRIBUTE17,
            STREAM_INTERFACE_ATTRIBUTE18,
            STREAM_INTERFACE_ATTRIBUTE19,
            STREAM_INTERFACE_ATTRIBUTE20,
            CREATED_BY,
            LAST_UPDATED_BY,
            CREATION_DATE,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            DOWN_PAYMENT_AMOUNT
      FROM Okl_Sif_Fees_V
     WHERE okl_sif_fees_v.id    = p_id;

Line: 308


              l_sfev_rec.LAST_UPDATED_BY,
              l_sfev_rec.CREATION_DATE,
              l_sfev_rec.LAST_UPDATE_DATE,
              l_sfev_rec.LAST_UPDATE_LOGIN,
              l_sfev_rec.DOWN_PAYMENT_AMOUNT;

Line: 491


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

Line: 497


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

Line: 500


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

Line: 1057


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

Line: 1132


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

Line: 1204


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

Line: 1768


          SELECT '1'
            FROM OKL_SIF_FEES_V
           WHERE OKL_SIF_FEES_V.sif_id = p_rec.sif_id
           AND
           OKL_SIF_FEES_V.sfe_type = p_rec.sfe_type
           AND
           OKL_SIF_FEES_V.fee_index_number = p_rec.fee_index_number
           AND
           OKL_SIF_FEES_V.sil_id = p_rec.sil_id
           AND
           OKL_SIF_FEES_V.level_index_number = p_rec.level_index_number
           AND
           id     <> NVL(p_rec.id,-9999);

Line: 1919


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1921


    p_to.last_update_date := p_from.last_update_date;

Line: 1922


    p_to.last_update_login := p_from.last_update_login;

Line: 1983


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1985


    p_to.last_update_date := p_from.last_update_date;

Line: 1986


    p_to.last_update_login := p_from.last_update_login;

Line: 2161


  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_sfe_rec                      IN sfe_rec_type,
    x_sfe_rec                      OUT NOCOPY sfe_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2170


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

Line: 2207


    INSERT INTO OKL_SIF_FEES(
        id,
        sfe_type,
        date_start,
        date_paid,
        amount,
        idc_accounting_flag,
        income_or_expense,
        description,
        fee_index_number,
        level_index_number,
        advance_or_arrears,
        level_type,
        lock_level_step,
        period,
        number_of_periods,
        level_line_number,
        sif_id,
        kle_id,
        sil_id,
        rate,
        -- mvasudev, 05/13/2002
        query_level_yn,
        structure,
        days_in_period,
        --
        object_version_number,
       	cash_effect_yn,
       	tax_effect_yn,
        days_in_month,
        days_in_year,
        balance_type_code    ,
        stream_interface_attribute01,
        stream_interface_attribute02,
        stream_interface_attribute03,
        stream_interface_attribute04,
        stream_interface_attribute05,
        stream_interface_attribute06,
        stream_interface_attribute07,
        stream_interface_attribute08,
        stream_interface_attribute09,
        stream_interface_attribute10,
        stream_interface_attribute11,
        stream_interface_attribute12,
        stream_interface_attribute13,
        stream_interface_attribute14,
        stream_interface_attribute15,
        stream_interface_attribute16,
        stream_interface_attribute17,
        stream_interface_attribute18,
        stream_interface_attribute19,
        stream_interface_attribute20,
        created_by,
        last_updated_by,
        creation_date,
        last_update_date,
        last_update_login,
        down_payment_amount)
      VALUES (
        l_sfe_rec.id,
        l_sfe_rec.sfe_type,
        l_sfe_rec.date_start,
        l_sfe_rec.date_paid,
        l_sfe_rec.amount,
        l_sfe_rec.idc_accounting_flag,
        l_sfe_rec.income_or_expense,
        l_sfe_rec.description,
        l_sfe_rec.fee_index_number,
        l_sfe_rec.level_index_number,
        l_sfe_rec.advance_or_arrears,
        l_sfe_rec.level_type,
        l_sfe_rec.lock_level_step,
        l_sfe_rec.period,
        l_sfe_rec.number_of_periods,
        l_sfe_rec.level_line_number,
        l_sfe_rec.sif_id,
        l_sfe_rec.kle_id,
        l_sfe_rec.sil_id,
        l_sfe_rec.rate,
        -- mvasudev, 05/13/2002
        l_sfe_rec.QUERY_LEVEL_YN,
        l_sfe_rec.STRUCTURE,
        l_sfe_rec.DAYS_IN_PERIOD,
        --
        l_sfe_rec.object_version_number,
       	l_sfe_rec.cash_effect_yn,
       	l_sfe_rec.tax_effect_yn,
        l_sfe_rec.days_in_month,
        l_sfe_rec.days_in_year,
        l_sfe_rec.balance_type_code,
        l_sfe_rec.stream_interface_attribute01,
        l_sfe_rec.stream_interface_attribute02,
        l_sfe_rec.stream_interface_attribute03,
        l_sfe_rec.stream_interface_attribute04,
        l_sfe_rec.stream_interface_attribute05,
        l_sfe_rec.stream_interface_attribute06,
        l_sfe_rec.stream_interface_attribute07,
        l_sfe_rec.stream_interface_attribute08,
        l_sfe_rec.stream_interface_attribute09,
        l_sfe_rec.stream_interface_attribute10,
        l_sfe_rec.stream_interface_attribute11,
        l_sfe_rec.stream_interface_attribute12,
        l_sfe_rec.stream_interface_attribute13,
        l_sfe_rec.stream_interface_attribute14,
        l_sfe_rec.stream_interface_attribute15,
        l_sfe_rec.stream_interface_attribute16,
        l_sfe_rec.stream_interface_attribute17,
        l_sfe_rec.stream_interface_attribute18,
        l_sfe_rec.stream_interface_attribute19,
        l_sfe_rec.stream_interface_attribute20,
        l_sfe_rec.created_by,
        l_sfe_rec.last_updated_by,
        l_sfe_rec.creation_date,
        l_sfe_rec.last_update_date,
        l_sfe_rec.last_update_login,
        l_sfe_rec.down_payment_amount);

Line: 2358


  END insert_row;

Line: 2362


  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_sfev_rec                     IN sfev_rec_type,
    x_sfev_rec                     OUT NOCOPY sfev_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2372


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

Line: 2388


      l_sfev_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2389


      l_sfev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2390


      l_sfev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2454


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sfe_rec,
      lx_sfe_rec
    );

Line: 2502


  END insert_row;

Line: 2506


  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_sfev_tbl                     IN sfev_tbl_type,
    x_sfev_tbl                     OUT NOCOPY sfev_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2516


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

Line: 2530


        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_sfev_rec                     => p_sfev_tbl(i),
          x_sfev_rec                     => x_sfev_tbl(i));

Line: 2586


  END insert_row;

Line: 2604


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SIF_FEES
     WHERE ID = p_sfe_rec.id
       AND OBJECT_VERSION_NUMBER = p_sfe_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 2611


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SIF_FEES
    WHERE ID = p_sfe_rec.id;

Line: 2653


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2662


      OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);

Line: 2868


  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_sfe_rec                      IN sfe_rec_type,
    x_sfe_rec                      OUT NOCOPY sfe_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2877


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

Line: 3109


      IF (x_sfe_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_sfe_rec.last_updated_by := l_sfe_rec.last_updated_by;

Line: 3117


      IF (x_sfe_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_sfe_rec.last_update_date := l_sfe_rec.last_update_date;

Line: 3121


      IF (x_sfe_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_sfe_rec.last_update_login := l_sfe_rec.last_update_login;

Line: 3169


    UPDATE  OKL_SIF_FEES
    SET SFE_TYPE = l_def_sfe_rec.sfe_type,
        DATE_START = l_def_sfe_rec.date_start,
        DATE_PAID = l_def_sfe_rec.date_paid,
        AMOUNT = l_def_sfe_rec.amount,
        IDC_ACCOUNTING_FLAG = l_def_sfe_rec.idc_accounting_flag,
        INCOME_OR_EXPENSE = l_def_sfe_rec.income_or_expense,
        DESCRIPTION = l_def_sfe_rec.description,
        FEE_INDEX_NUMBER = l_def_sfe_rec.fee_index_number,
        LEVEL_INDEX_NUMBER = l_def_sfe_rec.level_index_number,
        ADVANCE_OR_ARREARS = l_def_sfe_rec.advance_or_arrears,
        LEVEL_TYPE = l_def_sfe_rec.level_type,
        LOCK_LEVEL_STEP = l_def_sfe_rec.lock_level_step,
        -- mvasudev, 05/13/2002
        QUERY_LEVEL_YN = l_def_sfe_rec.query_level_yn,
        STRUCTURE = l_def_sfe_rec.STRUCTURE,
        DAYS_IN_PERIOD = l_def_sfe_rec.DAYS_IN_PERIOD,
        --
        PERIOD = l_def_sfe_rec.period,
        cash_effect_yn = l_def_sfe_rec.cash_effect_yn,
        tax_effect_yn = l_def_sfe_rec.tax_effect_yn,
        days_in_month = l_def_sfe_rec.days_in_month,
        days_in_year = l_def_sfe_rec.days_in_year,
        balance_type_code     = l_def_sfe_rec.balance_type_code     ,
        NUMBER_OF_PERIODS = l_def_sfe_rec.number_of_periods,
        LEVEL_LINE_NUMBER = l_def_sfe_rec.level_line_number,
        SIF_ID = l_def_sfe_rec.sif_id,
        KLE_ID = l_def_sfe_rec.kle_id,
        SIL_ID = l_def_sfe_rec.sil_id,
        RATE = l_def_sfe_rec.rate,
        OBJECT_VERSION_NUMBER = l_def_sfe_rec.object_version_number,
        STREAM_INTERFACE_ATTRIBUTE01 = l_def_sfe_rec.stream_interface_attribute01,
        STREAM_INTERFACE_ATTRIBUTE02 = l_def_sfe_rec.stream_interface_attribute02,
        STREAM_INTERFACE_ATTRIBUTE03 = l_def_sfe_rec.stream_interface_attribute03,
        STREAM_INTERFACE_ATTRIBUTE04 = l_def_sfe_rec.stream_interface_attribute04,
        STREAM_INTERFACE_ATTRIBUTE05 = l_def_sfe_rec.stream_interface_attribute05,
        STREAM_INTERFACE_ATTRIBUTE06 = l_def_sfe_rec.stream_interface_attribute06,
        STREAM_INTERFACE_ATTRIBUTE07 = l_def_sfe_rec.stream_interface_attribute07,
        STREAM_INTERFACE_ATTRIBUTE08 = l_def_sfe_rec.stream_interface_attribute08,
        STREAM_INTERFACE_ATTRIBUTE09 = l_def_sfe_rec.stream_interface_attribute09,
        STREAM_INTERFACE_ATTRIBUTE10 = l_def_sfe_rec.stream_interface_attribute10,
        STREAM_INTERFACE_ATTRIBUTE11 = l_def_sfe_rec.stream_interface_attribute11,
        STREAM_INTERFACE_ATTRIBUTE12 = l_def_sfe_rec.stream_interface_attribute12,
        STREAM_INTERFACE_ATTRIBUTE13 = l_def_sfe_rec.stream_interface_attribute13,
        STREAM_INTERFACE_ATTRIBUTE14 = l_def_sfe_rec.stream_interface_attribute14,
        STREAM_INTERFACE_ATTRIBUTE15 = l_def_sfe_rec.stream_interface_attribute15,
        STREAM_INTERFACE_ATTRIBUTE16 = l_def_sfe_rec.stream_interface_attribute16,
        STREAM_INTERFACE_ATTRIBUTE17 = l_def_sfe_rec.stream_interface_attribute17,
        STREAM_INTERFACE_ATTRIBUTE18 = l_def_sfe_rec.stream_interface_attribute18,
        STREAM_INTERFACE_ATTRIBUTE19 = l_def_sfe_rec.stream_interface_attribute19,
        STREAM_INTERFACE_ATTRIBUTE20 = l_def_sfe_rec.stream_interface_attribute20,
        CREATED_BY = l_def_sfe_rec.created_by,
        LAST_UPDATED_BY = l_def_sfe_rec.last_updated_by,
        CREATION_DATE = l_def_sfe_rec.creation_date,
        LAST_UPDATE_DATE = l_def_sfe_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_sfe_rec.last_update_login,
        DOWN_PAYMENT_AMOUNT = l_def_sfe_rec.down_payment_amount
    WHERE ID = l_def_sfe_rec.id;

Line: 3261


  END update_row;

Line: 3265


  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_sfev_rec                     IN sfev_rec_type,
    x_sfev_rec                     OUT NOCOPY sfev_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3275


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

Line: 3290


      l_sfev_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3291


      l_sfev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3292


      l_sfev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3522


      IF (x_sfev_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_sfev_rec.last_updated_by := l_sfev_rec.last_updated_by;

Line: 3530


      IF (x_sfev_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_sfev_rec.last_update_date := l_sfev_rec.last_update_date;

Line: 3534


      IF (x_sfev_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_sfev_rec.last_update_login := l_sfev_rec.last_update_login;

Line: 3609


    update_row(
      p_init_msg_list,

      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sfe_rec,
      lx_sfe_rec
    );

Line: 3657


  END update_row;

Line: 3661


  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_sfev_tbl                     IN sfev_tbl_type,
    x_sfev_tbl                     OUT NOCOPY sfev_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3671


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

Line: 3685


        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_sfev_rec                     => p_sfev_tbl(i),
          x_sfev_rec                     => x_sfev_tbl(i));

Line: 3741


  END update_row;

Line: 3749


  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_sfe_rec                      IN sfe_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3757


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

Line: 3771


    DELETE FROM OKL_SIF_FEES
     WHERE ID = l_sfe_rec.id;

Line: 3806


  END delete_row;

Line: 3810


  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_sfev_rec                     IN sfev_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3820


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

Line: 3844


    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sfe_rec
    );

Line: 3888


  END delete_row;

Line: 3892


  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_sfev_tbl                     IN sfev_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3901


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

Line: 3916


        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_sfev_rec                     => p_sfev_tbl(i));

Line: 3970


  END delete_row;