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.OKC_RIL_PVT SQL Statements

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

Line: 32


      SELECT 'x'
        FROM OKC_TIMEVALUES tvev
       WHERE tvev.ID = p_rilv_rec.TVE_ID;

Line: 111


      SELECT 'x'
        FROM OKC_RULES_B rulv
       WHERE rulv.ID = p_rilv_rec.RUL_ID;

Line: 190


      SELECT 'x'
        FROM OKX_UNITS_OF_MEASURE_V uomv
       WHERE uomv.UOM_CODE = p_rilv_rec.uom_code;

Line: 321


      SELECT 'x'
        FROM OKC_K_HEADERS_B chrv
       WHERE chrv.ID = p_rilv_rec.DNZ_CHR_ID;

Line: 522


    SELECT
            TVE_ID,
            RUL_ID,
            DNZ_CHR_ID,
            uom_code,
            DURATION,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_React_Intervals
     WHERE okc_react_intervals.tve_id = p_tve_id
       AND okc_react_intervals.rul_id = p_rul_id;

Line: 553


              l_ril_rec.LAST_UPDATED_BY,
              l_ril_rec.LAST_UPDATE_DATE,
              l_ril_rec.LAST_UPDATE_LOGIN;

Line: 577


    SELECT
            TVE_ID,
            RUL_ID,
            DNZ_CHR_ID,
            OBJECT_VERSION_NUMBER,
            uom_code,
            DURATION,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_React_Intervals_V
     WHERE okc_react_intervals_v.tve_id = p_tve_id
       AND okc_react_intervals_v.rul_id = p_rul_id;

Line: 608


              l_rilv_rec.LAST_UPDATED_BY,
              l_rilv_rec.LAST_UPDATE_DATE,
              l_rilv_rec.LAST_UPDATE_LOGIN;

Line: 656


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

Line: 659


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

Line: 662


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

Line: 743


    p_to.last_updated_by := p_from.last_updated_by;

Line: 744


    p_to.last_update_date := p_from.last_update_date;

Line: 745


    p_to.last_update_login := p_from.last_update_login;

Line: 760


    p_to.last_updated_by := p_from.last_updated_by;

Line: 761


    p_to.last_update_date := p_from.last_update_date;

Line: 762


    p_to.last_update_login := p_from.last_update_login;

Line: 915


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ril_rec                      IN ril_rec_type,
    x_ril_rec                      OUT NOCOPY ril_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 924


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

Line: 960


    INSERT INTO OKC_REACT_INTERVALS(
        tve_id,
        rul_id,
        dnz_chr_id,
        uom_code,
        duration,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_ril_rec.tve_id,
        l_ril_rec.rul_id,
        l_ril_rec.dnz_chr_id,
        l_ril_rec.uom_code,
        l_ril_rec.duration,
        l_ril_rec.object_version_number,
        l_ril_rec.created_by,
        l_ril_rec.creation_date,
        l_ril_rec.last_updated_by,
        l_ril_rec.last_update_date,
        l_ril_rec.last_update_login);

Line: 1018


  END insert_row;

Line: 1022


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rilv_rec                     IN rilv_rec_type,
    x_rilv_rec                     OUT NOCOPY rilv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1032


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

Line: 1048


      l_rilv_rec.LAST_UPDATE_DATE := l_rilv_rec.CREATION_DATE;

Line: 1049


      l_rilv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1050


      l_rilv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1112


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_ril_rec,
      lx_ril_rec
    );

Line: 1160


  END insert_row;

Line: 1164


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rilv_tbl                     IN rilv_tbl_type,
    x_rilv_tbl                     OUT NOCOPY rilv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1174


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

Line: 1183


        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_rilv_rec                     => p_rilv_tbl(i),
          x_rilv_rec                     => x_rilv_tbl(i));

Line: 1226


  END insert_row;

Line: 1244


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_REACT_INTERVALS
     WHERE TVE_ID = p_ril_rec.tve_id
       AND RUL_ID = p_ril_rec.rul_id
       AND OBJECT_VERSION_NUMBER = p_ril_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1252


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_REACT_INTERVALS
    WHERE TVE_ID = p_ril_rec.tve_id
       AND RUL_ID = p_ril_rec.rul_id;

Line: 1294


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1303


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1490


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ril_rec                      IN ril_rec_type,
    x_ril_rec                      OUT NOCOPY ril_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1499


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

Line: 1553


      IF (x_ril_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_ril_rec.last_updated_by := l_ril_rec.last_updated_by;

Line: 1557


      IF (x_ril_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_ril_rec.last_update_date := l_ril_rec.last_update_date;

Line: 1561


      IF (x_ril_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_ril_rec.last_update_login := l_ril_rec.last_update_login;

Line: 1605


    UPDATE  OKC_REACT_INTERVALS
    SET DNZ_CHR_ID = l_def_ril_rec.dnz_chr_id,
        uom_code = l_def_ril_rec.uom_code,
        DURATION = l_def_ril_rec.duration,
        OBJECT_VERSION_NUMBER = l_def_ril_rec.object_version_number,
        CREATED_BY = l_def_ril_rec.created_by,
        CREATION_DATE = l_def_ril_rec.creation_date,
        LAST_UPDATED_BY = l_def_ril_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_ril_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_ril_rec.last_update_login
    WHERE TVE_ID = l_def_ril_rec.tve_id
      AND RUL_ID = l_def_ril_rec.rul_id;

Line: 1651


  END update_row;

Line: 1655


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rilv_rec                     IN rilv_rec_type,
    x_rilv_rec                     OUT NOCOPY rilv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1665


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

Line: 1679


      l_rilv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1680


      l_rilv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1681


      l_rilv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1733


      IF (x_rilv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_rilv_rec.last_updated_by := l_rilv_rec.last_updated_by;

Line: 1737


      IF (x_rilv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_rilv_rec.last_update_date := l_rilv_rec.last_update_date;

Line: 1741


      IF (x_rilv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_rilv_rec.last_update_login := l_rilv_rec.last_update_login;

Line: 1812


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_ril_rec,
      lx_ril_rec
    );

Line: 1859


  END update_row;

Line: 1863


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rilv_tbl                     IN rilv_tbl_type,
    x_rilv_tbl                     OUT NOCOPY rilv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1873


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

Line: 1882


        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_rilv_rec                     => p_rilv_tbl(i),
          x_rilv_rec                     => x_rilv_tbl(i));

Line: 1925


  END update_row;

Line: 1933


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ril_rec                      IN ril_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1941


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

Line: 1959


        okc_time_pub.delete_timevalues_n_tasks(
        p_api_version   => l_api_version,
        p_init_msg_list => p_init_msg_list,
        x_return_status => x_return_status,
        x_msg_count     => x_msg_count,
        x_msg_data      => x_msg_data,
        p_tve_id        => l_ril_rec.tve_id);

Line: 1975


    DELETE FROM OKC_REACT_INTERVALS
    WHERE TVE_ID = l_ril_rec.tve_id AND RUL_ID = l_ril_rec.rul_id;

Line: 2010


  END delete_row;

Line: 2014


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rilv_rec                     IN rilv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2023


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

Line: 2047


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

Line: 2091


  END delete_row;

Line: 2095


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rilv_tbl                     IN rilv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2104


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

Line: 2113


        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_rilv_rec                     => p_rilv_tbl(i));

Line: 2155


  END delete_row;

Line: 2160


PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_rilv_tbl rilv_tbl_type) IS
  l_tabsize NUMBER := p_rilv_tbl.COUNT;

Line: 2172


  in_last_updated_by               OKC_DATATYPES.NumberTabTyp;

Line: 2173


  in_last_update_date              OKC_DATATYPES.DateTabTyp;

Line: 2174


  in_last_update_login             OKC_DATATYPES.NumberTabTyp;

Line: 2191


    in_last_updated_by          (j) := p_rilv_tbl(i).last_updated_by;

Line: 2192


    in_last_update_date         (j) := p_rilv_tbl(i).last_update_date;

Line: 2193


    in_last_update_login        (j) := p_rilv_tbl(i).last_update_login;

Line: 2198


    INSERT
      INTO OKC_REACT_INTERVALS
      (
        tve_id,
        rul_id,
        dnz_chr_id,
        uom_code,
        duration,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login
-- REMOVE comma from the previous line
     )
     VALUES (
        in_tve_id(i),
        in_rul_id(i),
        in_dnz_chr_id(i),
        in_uom_code(i),
        in_duration(i),
        in_object_version_number(i),
        in_created_by(i),
        in_creation_date(i),
        in_last_updated_by(i),
        in_last_update_date(i),
        in_last_update_login(i)
-- REMOVE comma from the previous line
     );

Line: 2244


END INSERT_ROW_UPG;

Line: 2258


INSERT INTO okc_react_intervals_h
  (
      major_version,
      tve_id,
      rul_id,
      dnz_chr_id,
      uom_code,
      duration,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
)
  SELECT
      p_major_version,
      tve_id,
      rul_id,
      dnz_chr_id,
      uom_code,
      duration,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
  FROM okc_react_intervals
 WHERE dnz_chr_id = p_chr_id;

Line: 2318


INSERT INTO okc_react_intervals
  (
      tve_id,
      rul_id,
      dnz_chr_id,
      uom_code,
      duration,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
)
  SELECT
      tve_id,
      rul_id,
      dnz_chr_id,
      uom_code,
      duration,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
  FROM okc_react_intervals_h
WHERE dnz_chr_id = p_chr_id
  AND major_version = p_major_version;