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

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

Line: 43


    SELECT
            ID,
            STATE_DEPRE_DMNSHING_VALUE_RT,
            BOOK_DEPRE_DMNSHING_VALUE_RT,
            RESIDUAL_GUARANTEE_METHOD,
            FED_DEPRE_TERM,
            FED_DEPRE_DMNSHING_VALUE_RATE,
            FED_DEPRE_ADR_CONVE,
            STATE_DEPRE_BASIS_PERCENT,
            STATE_DEPRE_METHOD,
            PURCHASE_OPTION,
            PURCHASE_OPTION_AMOUNT,
            ASSET_COST,
            STATE_DEPRE_TERM,
            STATE_DEPRE_ADR_CONVENT,
            FED_DEPRE_METHOD,
            RESIDUAL_AMOUNT,
            FED_DEPRE_SALVAGE,
            DATE_FED_DEPRE,
            BOOK_SALVAGE,
            BOOK_ADR_CONVENTION,
            STATE_DEPRE_SALVAGE,
            FED_DEPRE_BASIS_PERCENT,
            BOOK_BASIS_PERCENT,
            DATE_DELIVERY,
            BOOK_TERM,
            RESIDUAL_GUARANTEE_AMOUNT,
            DATE_FUNDING,
            DATE_BOOK,
            DATE_STATE_DEPRE,
            BOOK_METHOD,
            STREAM_INTERFACE_ATTRIBUTE08,
            STREAM_INTERFACE_ATTRIBUTE03,
            STREAM_INTERFACE_ATTRIBUTE01,
            INDEX_NUMBER,
            STREAM_INTERFACE_ATTRIBUTE05,
            DESCRIPTION,
            STREAM_INTERFACE_ATTRIBUTE10,
            STREAM_INTERFACE_ATTRIBUTE06,
            STREAM_INTERFACE_ATTRIBUTE09,
            STREAM_INTERFACE_ATTRIBUTE07,
            STREAM_INTERFACE_ATTRIBUTE14,
            STREAM_INTERFACE_ATTRIBUTE12,
            STREAM_INTERFACE_ATTRIBUTE15,
            STREAM_INTERFACE_ATTRIBUTE02,
            STREAM_INTERFACE_ATTRIBUTE11,
            STREAM_INTERFACE_ATTRIBUTE04,
            STREAM_INTERFACE_ATTRIBUTE13,
            DATE_START,
            DATE_LENDING,
            SIF_ID,
            OBJECT_VERSION_NUMBER,
            KLE_ID,
            SIL_TYPE,
            CREATED_BY,
            LAST_UPDATED_BY,
            CREATION_DATE,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            -- mvasudev , 05/13/2002
            RESIDUAL_GUARANTEE_TYPE,
            RESIDUAL_DATE,
            DOWN_PAYMENT_AMOUNT,
            CAPITALIZE_DOWN_PAYMENT_YN,
            orig_contract_line_id
      FROM Okl_Sif_Lines
     WHERE okl_sif_lines.id     = p_id;

Line: 171


              l_sil_rec.LAST_UPDATED_BY,
              l_sil_rec.CREATION_DATE,
              l_sil_rec.LAST_UPDATE_DATE,
              l_sil_rec.LAST_UPDATE_LOGIN,
              -- mvasudev , 05/13/2002
              l_sil_rec.RESIDUAL_GUARANTEE_TYPE,
              l_sil_rec.RESIDUAL_DATE,
              l_sil_rec.DOWN_PAYMENT_AMOUNT,
              l_sil_rec.CAPITALIZE_DOWN_PAYMENT_YN,
			  l_sil_rec.orig_contract_line_id;

Line: 201


    SELECT
            ID,
            STATE_DEPRE_DMNSHING_VALUE_RT,
            BOOK_DEPRE_DMNSHING_VALUE_RT,
            RESIDUAL_GUARANTEE_METHOD,
            FED_DEPRE_TERM,
            FED_DEPRE_DMNSHING_VALUE_RATE,
            FED_DEPRE_ADR_CONVE,
            STATE_DEPRE_BASIS_PERCENT,
            STATE_DEPRE_METHOD,
            PURCHASE_OPTION,
            PURCHASE_OPTION_AMOUNT,
            ASSET_COST,
            STATE_DEPRE_TERM,
            STATE_DEPRE_ADR_CONVENT,
            FED_DEPRE_METHOD,
            RESIDUAL_AMOUNT,
            FED_DEPRE_SALVAGE,
            DATE_FED_DEPRE,
            BOOK_SALVAGE,
            BOOK_ADR_CONVENTION,
            STATE_DEPRE_SALVAGE,
            FED_DEPRE_BASIS_PERCENT,
            BOOK_BASIS_PERCENT,
            DATE_DELIVERY,
            BOOK_TERM,
            RESIDUAL_GUARANTEE_AMOUNT,
            DATE_FUNDING,
            DATE_BOOK,
            DATE_STATE_DEPRE,
            BOOK_METHOD,
            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,
            DATE_START,
            DATE_LENDING,
            INDEX_NUMBER,
            SIF_ID,
            OBJECT_VERSION_NUMBER,
            KLE_ID,
            SIL_TYPE,
            DESCRIPTION,
            CREATED_BY,
            LAST_UPDATED_BY,
            CREATION_DATE,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            -- mvasudev , 05/13/2002
            RESIDUAL_GUARANTEE_TYPE,
            RESIDUAL_DATE,
            DOWN_PAYMENT_AMOUNT,
            CAPITALIZE_DOWN_PAYMENT_YN,
            orig_contract_line_id
      FROM Okl_Sif_Lines_V
     WHERE okl_sif_lines_v.id   = p_id;

Line: 329


              l_silv_rec.LAST_UPDATED_BY,
              l_silv_rec.CREATION_DATE,
              l_silv_rec.LAST_UPDATE_DATE,
              l_silv_rec.LAST_UPDATE_LOGIN,
              -- mvasudev , 05/13/2002
              l_silv_rec.RESIDUAL_GUARANTEE_TYPE,
              l_silv_rec.RESIDUAL_DATE,
              l_silv_rec.DOWN_PAYMENT_AMOUNT,
              l_silv_rec.CAPITALIZE_DOWN_PAYMENT_YN,
			  l_silv_rec.orig_contract_line_id;

Line: 526


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

Line: 532


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

Line: 535


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

Line: 840


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

Line: 914


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

Line: 2897


    p_to.last_updated_by := p_from.last_updated_by;

Line: 2899


    p_to.last_update_date := p_from.last_update_date;

Line: 2900


    p_to.last_update_login := p_from.last_update_login;

Line: 2968


    p_to.last_updated_by := p_from.last_updated_by;

Line: 2970


    p_to.last_update_date := p_from.last_update_date;

Line: 2971


    p_to.last_update_login := p_from.last_update_login;

Line: 3146


  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_sil_rec                      IN sil_rec_type,
    x_sil_rec                      OUT NOCOPY sil_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3155


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

Line: 3191


    INSERT INTO OKL_SIF_LINES(
        id,
        STATE_DEPRE_DMNSHING_VALUE_RT,
        BOOK_DEPRE_DMNSHING_VALUE_RT,
        residual_guarantee_method,
        fed_depre_term,
        fed_depre_dmnshing_value_rate,
        fed_depre_adr_conve,
        state_depre_basis_percent,
        state_depre_method,
        purchase_option,
        purchase_option_amount,
        asset_cost,
        state_depre_term,
        state_depre_adr_convent,
        fed_depre_method,
        residual_amount,
        fed_depre_salvage,
        date_fed_depre,
        book_salvage,
        book_adr_convention,
        state_depre_salvage,
        fed_depre_basis_percent,
        book_basis_percent,
        date_delivery,
        book_term,
        residual_guarantee_amount,
        date_funding,
        date_book,
        date_state_depre,
        book_method,
        stream_interface_attribute08,
        stream_interface_attribute03,
        stream_interface_attribute01,
        index_number,
        stream_interface_attribute05,
        description,
        stream_interface_attribute10,
        stream_interface_attribute06,
        stream_interface_attribute09,
        stream_interface_attribute07,
        stream_interface_attribute14,
        stream_interface_attribute12,
        stream_interface_attribute15,
        stream_interface_attribute02,
        stream_interface_attribute11,
        stream_interface_attribute04,
        stream_interface_attribute13,
        date_start,
        date_lending,
        sif_id,
        object_version_number,
        kle_id,
        sil_type,
        created_by,
        last_updated_by,
        creation_date,
        last_update_date,
        last_update_login,
        -- mvasudev , 05/13/2002
        residual_guarantee_type,
        residual_date,
        down_payment_amount,
        capitalize_down_payment_yn,
		orig_contract_line_id)
      VALUES (
        l_sil_rec.id,
        l_sil_rec.STATE_DEPRE_DMNSHING_VALUE_RT,
        l_sil_rec.BOOK_DEPRE_DMNSHING_VALUE_RT,
        l_sil_rec.residual_guarantee_method,
        l_sil_rec.fed_depre_term,
        l_sil_rec.fed_depre_dmnshing_value_rate,
        l_sil_rec.fed_depre_adr_conve,
        l_sil_rec.state_depre_basis_percent,
        l_sil_rec.state_depre_method,
        l_sil_rec.purchase_option,
        l_sil_rec.purchase_option_amount,
        l_sil_rec.asset_cost,
        l_sil_rec.state_depre_term,
        l_sil_rec.state_depre_adr_convent,
        l_sil_rec.fed_depre_method,
        l_sil_rec.residual_amount,
        l_sil_rec.fed_depre_salvage,
        l_sil_rec.date_fed_depre,
        l_sil_rec.book_salvage,
        l_sil_rec.book_adr_convention,
        l_sil_rec.state_depre_salvage,
        l_sil_rec.fed_depre_basis_percent,
        l_sil_rec.book_basis_percent,
        l_sil_rec.date_delivery,
        l_sil_rec.book_term,
        l_sil_rec.residual_guarantee_amount,
        l_sil_rec.date_funding,
        l_sil_rec.date_book,
        l_sil_rec.date_state_depre,
        l_sil_rec.book_method,
        l_sil_rec.stream_interface_attribute08,
        l_sil_rec.stream_interface_attribute03,
        l_sil_rec.stream_interface_attribute01,
        l_sil_rec.index_number,
        l_sil_rec.stream_interface_attribute05,
        l_sil_rec.description,
        l_sil_rec.stream_interface_attribute10,
        l_sil_rec.stream_interface_attribute06,
        l_sil_rec.stream_interface_attribute09,
        l_sil_rec.stream_interface_attribute07,
        l_sil_rec.stream_interface_attribute14,
        l_sil_rec.stream_interface_attribute12,
        l_sil_rec.stream_interface_attribute15,
        l_sil_rec.stream_interface_attribute02,
        l_sil_rec.stream_interface_attribute11,
        l_sil_rec.stream_interface_attribute04,
        l_sil_rec.stream_interface_attribute13,
        l_sil_rec.date_start,
        l_sil_rec.date_lending,
        l_sil_rec.sif_id,
        l_sil_rec.object_version_number,
        l_sil_rec.kle_id,
        l_sil_rec.sil_type,
        l_sil_rec.created_by,
        l_sil_rec.last_updated_by,
        l_sil_rec.creation_date,
        l_sil_rec.last_update_date,
        l_sil_rec.last_update_login,
        -- mvasudev , 05/13/2002
        l_sil_rec.residual_guarantee_type,
        l_sil_rec.residual_date,
        l_sil_rec.down_payment_amount,
        l_sil_rec.capitalize_down_payment_yn,
		l_sil_rec.orig_contract_line_id);

Line: 3355


  END insert_row;

Line: 3359


  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_silv_rec                     IN silv_rec_type,
    x_silv_rec                     OUT NOCOPY silv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3369


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

Line: 3385


      l_silv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3386


      l_silv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3387


      l_silv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3451


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sil_rec,
      lx_sil_rec
    );

Line: 3499


  END insert_row;

Line: 3503


  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_silv_tbl                     IN silv_tbl_type,
    x_silv_tbl                     OUT NOCOPY silv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3513


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

Line: 3526


        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_silv_rec                     => p_silv_tbl(i),
          x_silv_rec                     => x_silv_tbl(i));

Line: 3582


  END insert_row;

Line: 3600


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SIF_LINES
     WHERE ID = p_sil_rec.id
       AND OBJECT_VERSION_NUMBER = p_sil_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 3607


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SIF_LINES
    WHERE ID = p_sil_rec.id;

Line: 3648


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 3657


      OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);

Line: 3860


  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_sil_rec                      IN sil_rec_type,
    x_sil_rec                      OUT NOCOPY sil_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3869


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

Line: 4116


      IF (x_sil_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_sil_rec.last_updated_by := l_sil_rec.last_updated_by;

Line: 4124


      IF (x_sil_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_sil_rec.last_update_date := l_sil_rec.last_update_date;

Line: 4128


      IF (x_sil_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_sil_rec.last_update_login := l_sil_rec.last_update_login;

Line: 4186


    UPDATE  OKL_SIF_LINES
    SET STATE_DEPRE_DMNSHING_VALUE_RT = l_def_sil_rec.STATE_DEPRE_DMNSHING_VALUE_RT,
        BOOK_DEPRE_DMNSHING_VALUE_RT = l_def_sil_rec.BOOK_DEPRE_DMNSHING_VALUE_RT,
        RESIDUAL_GUARANTEE_METHOD = l_def_sil_rec.residual_guarantee_method,
        -- mvasudev , 05/13/2002
        RESIDUAL_GUARANTEE_TYPE = l_def_sil_rec.residual_guarantee_type,
        RESIDUAL_DATE = l_def_sil_rec.residual_date,
        FED_DEPRE_TERM = l_def_sil_rec.fed_depre_term,
        FED_DEPRE_DMNSHING_VALUE_RATE = l_def_sil_rec.fed_depre_dmnshing_value_rate,
        FED_DEPRE_ADR_CONVE = l_def_sil_rec.fed_depre_adr_conve,
        STATE_DEPRE_BASIS_PERCENT = l_def_sil_rec.state_depre_basis_percent,
        STATE_DEPRE_METHOD = l_def_sil_rec.state_depre_method,
        PURCHASE_OPTION = l_def_sil_rec.purchase_option,
        PURCHASE_OPTION_AMOUNT = l_def_sil_rec.purchase_option_amount,
        ASSET_COST = l_def_sil_rec.asset_cost,
        STATE_DEPRE_TERM = l_def_sil_rec.state_depre_term,
        STATE_DEPRE_ADR_CONVENT = l_def_sil_rec.state_depre_adr_convent,
        FED_DEPRE_METHOD = l_def_sil_rec.fed_depre_method,
        RESIDUAL_AMOUNT = l_def_sil_rec.residual_amount,
        FED_DEPRE_SALVAGE = l_def_sil_rec.fed_depre_salvage,
        DATE_FED_DEPRE = l_def_sil_rec.date_fed_depre,
        BOOK_SALVAGE = l_def_sil_rec.book_salvage,
        BOOK_ADR_CONVENTION = l_def_sil_rec.book_adr_convention,
        STATE_DEPRE_SALVAGE = l_def_sil_rec.state_depre_salvage,
        FED_DEPRE_BASIS_PERCENT = l_def_sil_rec.fed_depre_basis_percent,
        BOOK_BASIS_PERCENT = l_def_sil_rec.book_basis_percent,
        DATE_DELIVERY = l_def_sil_rec.date_delivery,
        BOOK_TERM = l_def_sil_rec.book_term,
        RESIDUAL_GUARANTEE_AMOUNT = l_def_sil_rec.residual_guarantee_amount,
        DATE_FUNDING = l_def_sil_rec.date_funding,
        DATE_BOOK = l_def_sil_rec.date_book,
        DATE_STATE_DEPRE = l_def_sil_rec.date_state_depre,
        BOOK_METHOD = l_def_sil_rec.book_method,
        STREAM_INTERFACE_ATTRIBUTE08 = l_def_sil_rec.stream_interface_attribute08,
        STREAM_INTERFACE_ATTRIBUTE03 = l_def_sil_rec.stream_interface_attribute03,
        STREAM_INTERFACE_ATTRIBUTE01 = l_def_sil_rec.stream_interface_attribute01,
        INDEX_NUMBER = l_def_sil_rec.index_number,
        STREAM_INTERFACE_ATTRIBUTE05 = l_def_sil_rec.stream_interface_attribute05,
        DESCRIPTION = l_def_sil_rec.description,
        STREAM_INTERFACE_ATTRIBUTE10 = l_def_sil_rec.stream_interface_attribute10,
        STREAM_INTERFACE_ATTRIBUTE06 = l_def_sil_rec.stream_interface_attribute06,
        STREAM_INTERFACE_ATTRIBUTE09 = l_def_sil_rec.stream_interface_attribute09,
        STREAM_INTERFACE_ATTRIBUTE07 = l_def_sil_rec.stream_interface_attribute07,
        STREAM_INTERFACE_ATTRIBUTE14 = l_def_sil_rec.stream_interface_attribute14,
        STREAM_INTERFACE_ATTRIBUTE12 = l_def_sil_rec.stream_interface_attribute12,
        STREAM_INTERFACE_ATTRIBUTE15 = l_def_sil_rec.stream_interface_attribute15,
        STREAM_INTERFACE_ATTRIBUTE02 = l_def_sil_rec.stream_interface_attribute02,
        STREAM_INTERFACE_ATTRIBUTE11 = l_def_sil_rec.stream_interface_attribute11,
        STREAM_INTERFACE_ATTRIBUTE04 = l_def_sil_rec.stream_interface_attribute04,
        STREAM_INTERFACE_ATTRIBUTE13 = l_def_sil_rec.stream_interface_attribute13,
        DATE_START = l_def_sil_rec.date_start,
        DATE_LENDING = l_def_sil_rec.date_lending,
        SIF_ID = l_def_sil_rec.sif_id,
        OBJECT_VERSION_NUMBER = l_def_sil_rec.object_version_number,
        KLE_ID = l_def_sil_rec.kle_id,
        SIL_TYPE = l_def_sil_rec.sil_type,
        CREATED_BY = l_def_sil_rec.created_by,
        LAST_UPDATED_BY = l_def_sil_rec.last_updated_by,
        CREATION_DATE = l_def_sil_rec.creation_date,
        LAST_UPDATE_DATE = l_def_sil_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_sil_rec.last_update_login,
        DOWN_PAYMENT_AMOUNT = l_def_sil_rec.down_payment_amount,
        CAPITALIZE_DOWN_PAYMENT_YN	= l_def_sil_rec.capitalize_down_payment_yn,
        orig_contract_line_id	= l_def_sil_rec.orig_contract_line_id
    WHERE ID = l_def_sil_rec.id;

Line: 4285


  END update_row;

Line: 4289


  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_silv_rec                     IN silv_rec_type,
    x_silv_rec                     OUT NOCOPY silv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4299


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

Line: 4313


      l_silv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 4314


      l_silv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 4315


      l_silv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 4560


      IF (x_silv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_silv_rec.last_updated_by := l_silv_rec.last_updated_by;

Line: 4568


      IF (x_silv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_silv_rec.last_update_date := l_silv_rec.last_update_date;

Line: 4572


      IF (x_silv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_silv_rec.last_update_login := l_silv_rec.last_update_login;

Line: 4657


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sil_rec,
      lx_sil_rec
    );

Line: 4704


  END update_row;

Line: 4708


  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_silv_tbl                     IN silv_tbl_type,
    x_silv_tbl                     OUT NOCOPY silv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4718


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

Line: 4731


        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_silv_rec                     => p_silv_tbl(i),
          x_silv_rec                     => x_silv_tbl(i));

Line: 4786


  END update_row;

Line: 4794


  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_sil_rec                      IN sil_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4802


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

Line: 4816


    DELETE FROM OKL_SIF_LINES
     WHERE ID = l_sil_rec.id;

Line: 4851


  END delete_row;

Line: 4855


  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_silv_rec                     IN silv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4864


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

Line: 4888


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

Line: 4932


  END delete_row;

Line: 4936


  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_silv_tbl                     IN silv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4945


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

Line: 4958


        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_silv_rec                     => p_silv_tbl(i));

Line: 5012


  END delete_row;