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.

[Home] [Help]

APPS.OKC_CTI_PVT SQL Statements

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

Line: 32


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

Line: 112


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

Line: 191


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

Line: 371


    SELECT
            RUL_ID,
            TVE_ID,
            DNZ_CHR_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Cover_Times
     WHERE okc_cover_times.rul_id = p_rul_id
       AND okc_cover_times.tve_id = p_tve_id;

Line: 398


              l_cti_rec.LAST_UPDATED_BY,
              l_cti_rec.LAST_UPDATE_DATE,
              l_cti_rec.LAST_UPDATE_LOGIN;

Line: 422


    SELECT
            RUL_ID,
            TVE_ID,
            DNZ_CHR_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Cover_Times_V
     WHERE okc_cover_times_v.rul_id = p_rul_id
       AND okc_cover_times_v.tve_id = p_tve_id;

Line: 449


              l_ctiv_rec.LAST_UPDATED_BY,
              l_ctiv_rec.LAST_UPDATE_DATE,
              l_ctiv_rec.LAST_UPDATE_LOGIN;

Line: 491


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

Line: 494


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

Line: 497


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

Line: 566


    p_to.last_updated_by := p_from.last_updated_by;

Line: 567


    p_to.last_update_date := p_from.last_update_date;

Line: 568


    p_to.last_update_login := p_from.last_update_login;

Line: 581


    p_to.last_updated_by := p_from.last_updated_by;

Line: 582


    p_to.last_update_date := p_from.last_update_date;

Line: 583


    p_to.last_update_login := p_from.last_update_login;

Line: 736


  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_cti_rec                      IN cti_rec_type,
    x_cti_rec                      OUT NOCOPY cti_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 745


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

Line: 781


    INSERT INTO OKC_COVER_TIMES(
        rul_id,
        tve_id,
        dnz_chr_id,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_cti_rec.rul_id,
        l_cti_rec.tve_id,
        l_cti_rec.dnz_chr_id,
        l_cti_rec.object_version_number,
        l_cti_rec.created_by,
        l_cti_rec.creation_date,
        l_cti_rec.last_updated_by,
        l_cti_rec.last_update_date,
        l_cti_rec.last_update_login);

Line: 835


  END insert_row;

Line: 839


  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_ctiv_rec                     IN ctiv_rec_type,
    x_ctiv_rec                     OUT NOCOPY ctiv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 849


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

Line: 865


      l_ctiv_rec.LAST_UPDATE_DATE := l_ctiv_rec.CREATION_DATE;

Line: 866


      l_ctiv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 867


      l_ctiv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 929


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cti_rec,
      lx_cti_rec
    );

Line: 977


  END insert_row;

Line: 981


  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_ctiv_tbl                     IN ctiv_tbl_type,
    x_ctiv_tbl                     OUT NOCOPY ctiv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 991


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

Line: 1000


        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_ctiv_rec                     => p_ctiv_tbl(i),
          x_ctiv_rec                     => x_ctiv_tbl(i));

Line: 1043


  END insert_row;

Line: 1061


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

Line: 1069


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_COVER_TIMES
    WHERE RUL_ID = p_cti_rec.rul_id
       AND TVE_ID = p_cti_rec.tve_id;

Line: 1111


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1120


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1307


  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_cti_rec                      IN cti_rec_type,
    x_cti_rec                      OUT NOCOPY cti_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1316


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

Line: 1362


      IF (x_cti_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_cti_rec.last_updated_by := l_cti_rec.last_updated_by;

Line: 1366


      IF (x_cti_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_cti_rec.last_update_date := l_cti_rec.last_update_date;

Line: 1370


      IF (x_cti_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_cti_rec.last_update_login := l_cti_rec.last_update_login;

Line: 1414


    UPDATE  OKC_COVER_TIMES
    SET DNZ_CHR_ID = l_def_cti_rec.dnz_chr_id,
        OBJECT_VERSION_NUMBER = l_def_cti_rec.object_version_number,
        CREATED_BY = l_def_cti_rec.created_by,
        CREATION_DATE = l_def_cti_rec.creation_date,
        LAST_UPDATED_BY = l_def_cti_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_cti_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_cti_rec.last_update_login
    WHERE RUL_ID = l_def_cti_rec.rul_id
      AND TVE_ID = l_def_cti_rec.tve_id;

Line: 1458


  END update_row;

Line: 1462


  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_ctiv_rec                     IN ctiv_rec_type,
    x_ctiv_rec                     OUT NOCOPY ctiv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1472


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

Line: 1486


      l_ctiv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1487


      l_ctiv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1488


      l_ctiv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1532


      IF (x_ctiv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_ctiv_rec.last_updated_by := l_ctiv_rec.last_updated_by;

Line: 1536


      IF (x_ctiv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_ctiv_rec.last_update_date := l_ctiv_rec.last_update_date;

Line: 1540


      IF (x_ctiv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_ctiv_rec.last_update_login := l_ctiv_rec.last_update_login;

Line: 1611


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cti_rec,
      lx_cti_rec
    );

Line: 1658


  END update_row;

Line: 1662


  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_ctiv_tbl                     IN ctiv_tbl_type,
    x_ctiv_tbl                     OUT NOCOPY ctiv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1672


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

Line: 1681


        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_ctiv_rec                     => p_ctiv_tbl(i),
          x_ctiv_rec                     => x_ctiv_tbl(i));

Line: 1724


  END update_row;

Line: 1732


  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_cti_rec                      IN cti_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1740


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

Line: 1758


        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_cti_rec.tve_id);

Line: 1775


        DELETE FROM OKC_COVER_TIMES
        WHERE RUL_ID = l_cti_rec.rul_id AND TVE_ID = l_cti_rec.tve_id;

Line: 1810


  END delete_row;

Line: 1814


  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_ctiv_rec                     IN ctiv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1823


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

Line: 1847


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

Line: 1891


  END delete_row;

Line: 1895


  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_ctiv_tbl                     IN ctiv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1904


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

Line: 1913


        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_ctiv_rec                     => p_ctiv_tbl(i));

Line: 1955


  END delete_row;

Line: 1960


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

Line: 1970


  in_last_updated_by               OKC_DATATYPES.NumberTabTyp;

Line: 1971


  in_last_update_date              OKC_DATATYPES.DateTabTyp;

Line: 1972


  in_last_update_login             OKC_DATATYPES.NumberTabTyp;

Line: 1989


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

Line: 1990


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

Line: 1991


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

Line: 1996


    INSERT
      INTO OKC_COVER_TIMES
      (
        rul_id,
        tve_id,
        dnz_chr_id,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login
-- REMOVE comma from the previous line
     )
     VALUES (
        in_rul_id(i),
        in_tve_id(i),
        in_dnz_chr_id(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: 2037


END INSERT_ROW_UPG;

Line: 2051


INSERT INTO okc_cover_times_h
  (
      major_version,
      rul_id,
      tve_id,
      dnz_chr_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
)
  SELECT
      p_major_version,
      rul_id,
      tve_id,
      dnz_chr_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
  FROM okc_cover_times
WHERE dnz_chr_id = p_chr_id;

Line: 2107


INSERT INTO okc_cover_times
  (
      rul_id,
      tve_id,
      dnz_chr_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
)
  SELECT
      rul_id,
      tve_id,
      dnz_chr_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
  FROM okc_cover_times_h
WHERE dnz_chr_id = p_chr_id
  AND major_version = p_major_version;