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

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

Line: 43


    SELECT
            ID,
            YIELD_NAME,
            OBJECT_VERSION_NUMBER,
            SIF_ID,
            METHOD,
            ARRAY_TYPE,
            ROE_TYPE,
            ROE_BASE,
            COMPOUNDED_METHOD,
            TARGET_VALUE,
            INDEX_NUMBER,
            NOMINAL_YN,
            PRE_TAX_YN,
            CREATED_BY,
            LAST_UPDATED_BY,
            CREATION_DATE,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Sif_Yields
     WHERE okl_sif_yields.id    = p_id ;

Line: 85


            l_siy_rec.LAST_UPDATED_BY,
            l_siy_rec.CREATION_DATE,
            l_siy_rec.LAST_UPDATE_DATE,
            l_siy_rec.LAST_UPDATE_LOGIN;

Line: 109


    SELECT
            ID,
            YIELD_NAME,
            OBJECT_VERSION_NUMBER,
            SIF_ID,
            METHOD,
            ARRAY_TYPE,
            ROE_TYPE,
            ROE_BASE,
            COMPOUNDED_METHOD,
            TARGET_VALUE,
            INDEX_NUMBER,
            NOMINAL_YN,
            PRE_TAX_YN,
            CREATED_BY,
            LAST_UPDATED_BY,
            CREATION_DATE,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Sif_Yields_V
     WHERE okl_sif_yields_v.id  = p_id;

Line: 151


              l_siyv_rec.LAST_UPDATED_BY,
              l_siyv_rec.CREATION_DATE,
              l_siyv_rec.LAST_UPDATE_DATE,
              l_siyv_rec.LAST_UPDATE_LOGIN;

Line: 263


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

Line: 269


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

Line: 272


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

Line: 498


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

Line: 983


    p_to.last_updated_by := p_from.last_updated_by;

Line: 985


    p_to.last_update_date := p_from.last_update_date;

Line: 986


    p_to.last_update_login := p_from.last_update_login;

Line: 1027


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1029


    p_to.last_update_date := p_from.last_update_date;

Line: 1030


    p_to.last_update_login := p_from.last_update_login;

Line: 1216


  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_siy_rec                      IN siy_rec_type,
    x_siy_rec                      OUT NOCOPY siy_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1225


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

Line: 1261


    INSERT INTO OKL_SIF_YIELDS(
        id,
        yield_name,
        object_version_number,
        sif_id,
        method,
        array_type,
        roe_type,
        roe_base,
        compounded_method,
        target_value,
        index_number,
        nominal_yn,
        pre_tax_yn,
        siy_type,
        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,
        created_by,
        last_updated_by,
        creation_date,
        last_update_date,
        last_update_login)
      VALUES (
        l_siy_rec.id,
        l_siy_rec.yield_name,
        l_siy_rec.object_version_number,
        l_siy_rec.sif_id,
        l_siy_rec.method,
        l_siy_rec.array_type,
        l_siy_rec.roe_type,
        l_siy_rec.roe_base,
        l_siy_rec.compounded_method,
        l_siy_rec.target_value,
        l_siy_rec.index_number,
        l_siy_rec.nominal_yn,
        l_siy_rec.pre_tax_yn,
        l_siy_rec.siy_type,
        l_siy_rec.stream_interface_attribute01,
        l_siy_rec.stream_interface_attribute02,
        l_siy_rec.stream_interface_attribute03,
        l_siy_rec.stream_interface_attribute04,
        l_siy_rec.stream_interface_attribute05,
        l_siy_rec.stream_interface_attribute06,
        l_siy_rec.stream_interface_attribute07,
        l_siy_rec.stream_interface_attribute08,
        l_siy_rec.stream_interface_attribute09,
        l_siy_rec.stream_interface_attribute10,
        l_siy_rec.stream_interface_attribute11,
        l_siy_rec.stream_interface_attribute12,
        l_siy_rec.stream_interface_attribute13,
        l_siy_rec.stream_interface_attribute14,
        l_siy_rec.stream_interface_attribute15,
        l_siy_rec.created_by,
        l_siy_rec.last_updated_by,
        l_siy_rec.creation_date,
        l_siy_rec.last_update_date,
        l_siy_rec.last_update_login);

Line: 1365


  END insert_row;

Line: 1369


  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_siyv_rec                     IN siyv_rec_type,
    x_siyv_rec                     OUT NOCOPY siyv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1379


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

Line: 1395


      l_siyv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1396


      l_siyv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1397


      l_siyv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1461


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_siy_rec,
      lx_siy_rec
    );

Line: 1509


  END insert_row;

Line: 1513


  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_siyv_tbl                     IN siyv_tbl_type,
    x_siyv_tbl                     OUT NOCOPY siyv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1523


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

Line: 1537


        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_siyv_rec                     => p_siyv_tbl(i),
          x_siyv_rec                     => x_siyv_tbl(i));

Line: 1592


  END insert_row;

Line: 1610


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SIF_YIELDS
     WHERE ID = p_siy_rec.id
       AND OBJECT_VERSION_NUMBER = p_siy_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1617


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_SIF_YIELDS
    WHERE ID = p_siy_rec.id;

Line: 1658


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1667


      OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);

Line: 1870


  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_siy_rec                      IN siy_rec_type,
    x_siy_rec                      OUT NOCOPY siy_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1879


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

Line: 2025


      IF (x_siy_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_siy_rec.last_updated_by := l_siy_rec.last_updated_by;

Line: 2033


      IF (x_siy_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_siy_rec.last_update_date := l_siy_rec.last_update_date;

Line: 2037


      IF (x_siy_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_siy_rec.last_update_login := l_siy_rec.last_update_login;

Line: 2081


    UPDATE  OKL_SIF_YIELDS
    SET YIELD_NAME = l_def_siy_rec.yield_name,
        NOMINAL_YN = l_def_siy_rec.nominal_yn,
        PRE_TAX_YN = l_def_siy_rec.pre_tax_yn,
        SIY_TYPE = l_def_siy_rec.siy_type,
        STREAM_INTERFACE_ATTRIBUTE01 = l_def_siy_rec.stream_interface_attribute01,
        STREAM_INTERFACE_ATTRIBUTE02 = l_def_siy_rec.stream_interface_attribute02,
        STREAM_INTERFACE_ATTRIBUTE03 = l_def_siy_rec.stream_interface_attribute03,
        STREAM_INTERFACE_ATTRIBUTE04 = l_def_siy_rec.stream_interface_attribute04,
        STREAM_INTERFACE_ATTRIBUTE05 = l_def_siy_rec.stream_interface_attribute05,
        STREAM_INTERFACE_ATTRIBUTE06 = l_def_siy_rec.stream_interface_attribute06,
        STREAM_INTERFACE_ATTRIBUTE07 = l_def_siy_rec.stream_interface_attribute07,
        STREAM_INTERFACE_ATTRIBUTE08 = l_def_siy_rec.stream_interface_attribute08,
        STREAM_INTERFACE_ATTRIBUTE09 = l_def_siy_rec.stream_interface_attribute09,
        STREAM_INTERFACE_ATTRIBUTE10 = l_def_siy_rec.stream_interface_attribute10,
        STREAM_INTERFACE_ATTRIBUTE11 = l_def_siy_rec.stream_interface_attribute11,
        STREAM_INTERFACE_ATTRIBUTE12 = l_def_siy_rec.stream_interface_attribute12,
        STREAM_INTERFACE_ATTRIBUTE13 = l_def_siy_rec.stream_interface_attribute13,
        STREAM_INTERFACE_ATTRIBUTE14 = l_def_siy_rec.stream_interface_attribute14,
        STREAM_INTERFACE_ATTRIBUTE15 = l_def_siy_rec.stream_interface_attribute15,
        INDEX_NUMBER = l_def_siy_rec.index_number,
        COMPOUNDED_METHOD = l_def_siy_rec.compounded_method,
        METHOD = l_def_siy_rec.method,
        ARRAY_TYPE = l_def_siy_rec.array_type,
        ROE_BASE = l_def_siy_rec.roe_base,
        TARGET_VALUE = l_def_siy_rec.target_value,
        ROE_TYPE = l_def_siy_rec.roe_type,
        OBJECT_VERSION_NUMBER = l_def_siy_rec.object_version_number,
        SIF_ID = l_def_siy_rec.sif_id,
        CREATED_BY = l_def_siy_rec.created_by,
        LAST_UPDATED_BY = l_def_siy_rec.last_updated_by,
        CREATION_DATE = l_def_siy_rec.creation_date,
        LAST_UPDATE_DATE = l_def_siy_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_siy_rec.last_update_login
    WHERE ID = l_def_siy_rec.id ;

Line: 2150


  END update_row;

Line: 2154


  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_siyv_rec                     IN siyv_rec_type,
    x_siyv_rec                     OUT NOCOPY siyv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2164


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

Line: 2178


      l_siyv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2179


      l_siyv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2180


      l_siyv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2320


      IF (x_siyv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_siyv_rec.last_updated_by := l_siyv_rec.last_updated_by;

Line: 2328


      IF (x_siyv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_siyv_rec.last_update_date := l_siyv_rec.last_update_date;

Line: 2332


      IF (x_siyv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_siyv_rec.last_update_login := l_siyv_rec.last_update_login;

Line: 2403


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_siy_rec,
      lx_siy_rec
    );

Line: 2450


  END update_row;

Line: 2454


  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_siyv_tbl                     IN siyv_tbl_type,
    x_siyv_tbl                     OUT NOCOPY siyv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2464


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

Line: 2477


        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_siyv_rec                     => p_siyv_tbl(i),
          x_siyv_rec                     => x_siyv_tbl(i));

Line: 2532


  END update_row;

Line: 2540


  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_siy_rec                      IN siy_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2548


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

Line: 2562


    DELETE FROM OKL_SIF_YIELDS
     WHERE ID = l_siy_rec.id;

Line: 2598


  END delete_row;

Line: 2602


  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_siyv_rec                     IN siyv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2611


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

Line: 2635


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

Line: 2679


  END delete_row;

Line: 2683


  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_siyv_tbl                     IN siyv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2692


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

Line: 2705


        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_siyv_rec                     => p_siyv_tbl(i));

Line: 2759


  END delete_row;