DBA Data[Home] [Help]

APPS.OKC_COE_PVT SQL Statements

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

Line: 46

    SELECT
            ID,
            CNH_ID,
            DATETIME,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Condition_Occurs
     WHERE okc_condition_occurs.id = p_id;
Line: 71

              l_coe_rec.LAST_UPDATED_BY,
              l_coe_rec.LAST_UPDATE_DATE,
              l_coe_rec.LAST_UPDATE_LOGIN;
Line: 94

    SELECT
            ID,
            CNH_ID,
            OBJECT_VERSION_NUMBER,
            DATETIME,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Condition_Occurs_V
     WHERE okc_condition_occurs_v.id = p_id;
Line: 119

              l_coev_rec.LAST_UPDATED_BY,
              l_coev_rec.LAST_UPDATE_DATE,
              l_coev_rec.LAST_UPDATE_LOGIN;
Line: 158

    IF (l_coev_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_coev_rec.last_updated_by := NULL;
Line: 161

    IF (l_coev_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_coev_rec.last_update_date := NULL;
Line: 164

    IF (l_coev_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_coev_rec.last_update_login := NULL;
Line: 384

      SELECT  '1'
        FROM Okc_Condition_Headers_V
       WHERE okc_condition_headers_v.id = p_id;
Line: 536

      SELECT
              ID,
              VERSION,
              OBJECT_VERSION_NUMBER,
              SFWT_FLAG,
              ACN_ID,
              DESCRIPTION,
              SHORT_DESCRIPTION,
              COMMENTS,
              ENABLED_YN,
              ONE_TIME_YN,
              NAME,
              SYNCH_ASYNCH,
              BEFORE_AFTER,
              CNH_VARIANCE,
              OBJECT_ID,
              OBJECT_NAME,
              CNH_TYPE,
              ATTRIBUTE_CATEGORY,
              ATTRIBUTE1,
              ATTRIBUTE2,
              ATTRIBUTE3,
              ATTRIBUTE4,
              ATTRIBUTE5,
              ATTRIBUTE6,
              ATTRIBUTE7,
              ATTRIBUTE8,
              ATTRIBUTE9,
              ATTRIBUTE10,
              ATTRIBUTE11,
              ATTRIBUTE12,
              ATTRIBUTE13,
              ATTRIBUTE14,
              ATTRIBUTE15,
              CREATED_BY,
              CREATION_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_DATE,
              LAST_UPDATE_LOGIN
        FROM Okc_Condition_Headers_V
       WHERE okc_condition_headers_v.id = p_id;
Line: 626

    p_to.last_updated_by := p_from.last_updated_by;
Line: 627

    p_to.last_update_date := p_from.last_update_date;
Line: 628

    p_to.last_update_login := p_from.last_update_login;
Line: 642

    p_to.last_updated_by := p_from.last_updated_by;
Line: 643

    p_to.last_update_date := p_from.last_update_date;
Line: 644

    p_to.last_update_login := p_from.last_update_login;
Line: 797

  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_coe_rec                      IN coe_rec_type,
    x_coe_rec                      OUT NOCOPY coe_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 806

    l_api_name                     CONSTANT VARCHAR2(30) := 'OCCURS_insert_row';
Line: 846

    INSERT INTO OKC_CONDITION_OCCURS(
        id,
        cnh_id,
        datetime,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_coe_rec.id,
        l_coe_rec.cnh_id,
        l_coe_rec.datetime,
        l_coe_rec.object_version_number,
        l_coe_rec.created_by,
        l_coe_rec.creation_date,
        l_coe_rec.last_updated_by,
        l_coe_rec.last_update_date,
        l_coe_rec.last_update_login);
Line: 900

  END insert_row;
Line: 904

  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_coev_rec                     IN coev_rec_type,
    x_coev_rec                     OUT NOCOPY coev_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 914

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

      l_coev_rec.LAST_UPDATE_DATE := l_coev_rec.CREATION_DATE;
Line: 931

      l_coev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 932

      l_coev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 996

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_coe_rec,
      lx_coe_rec
    );
Line: 1044

  END insert_row;
Line: 1048

  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_coev_tbl                     IN coev_tbl_type,
    x_coev_tbl                     OUT NOCOPY coev_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1058

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

        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_coev_rec                     => p_coev_tbl(i),
          x_coev_rec                     => x_coev_tbl(i));
Line: 1110

  END insert_row;
Line: 1128

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_CONDITION_OCCURS
     WHERE ID = p_coe_rec.id
       AND OBJECT_VERSION_NUMBER = p_coe_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1135

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_CONDITION_OCCURS
    WHERE ID = p_coe_rec.id;
Line: 1176

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 1185

      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 1372

  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_coe_rec                      IN coe_rec_type,
    x_coe_rec                      OUT NOCOPY coe_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1381

    l_api_name                     CONSTANT VARCHAR2(30) := 'OCCURS_update_row';
Line: 1427

      IF (x_coe_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_coe_rec.last_updated_by := l_coe_rec.last_updated_by;
Line: 1431

      IF (x_coe_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_coe_rec.last_update_date := l_coe_rec.last_update_date;
Line: 1435

      IF (x_coe_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_coe_rec.last_update_login := l_coe_rec.last_update_login;
Line: 1479

    UPDATE  OKC_CONDITION_OCCURS
    SET CNH_ID = l_def_coe_rec.cnh_id,
        DATETIME = l_def_coe_rec.datetime,
        OBJECT_VERSION_NUMBER = l_def_coe_rec.object_version_number,
        CREATED_BY = l_def_coe_rec.created_by,
        CREATION_DATE = l_def_coe_rec.creation_date,
        LAST_UPDATED_BY = l_def_coe_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_coe_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_coe_rec.last_update_login
    WHERE ID = l_def_coe_rec.id;
Line: 1523

  END update_row;
Line: 1527

  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_coev_rec                     IN coev_rec_type,
    x_coev_rec                     OUT NOCOPY coev_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1537

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

      l_coev_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1552

      l_coev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1553

      l_coev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1597

      IF (x_coev_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_coev_rec.last_updated_by := l_coev_rec.last_updated_by;
Line: 1601

      IF (x_coev_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_coev_rec.last_update_date := l_coev_rec.last_update_date;
Line: 1605

      IF (x_coev_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_coev_rec.last_update_login := l_coev_rec.last_update_login;
Line: 1676

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_coe_rec,
      lx_coe_rec
    );
Line: 1723

  END update_row;
Line: 1727

  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_coev_tbl                     IN coev_tbl_type,
    x_coev_tbl                     OUT NOCOPY coev_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1737

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

        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_coev_rec                     => p_coev_tbl(i),
          x_coev_rec                     => x_coev_tbl(i));
Line: 1789

  END update_row;
Line: 1797

  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_coe_rec                      IN coe_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1805

    l_api_name                     CONSTANT VARCHAR2(30) := 'OCCURS_delete_row';
Line: 1819

    DELETE FROM OKC_CONDITION_OCCURS
     WHERE ID = l_coe_rec.id;
Line: 1854

  END delete_row;
Line: 1858

  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_coev_rec                     IN coev_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1867

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

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_coe_rec
    );
Line: 1935

  END delete_row;
Line: 1939

  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_coev_tbl                     IN coev_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1948

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

        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_coev_rec                     => p_coev_tbl(i));
Line: 1999

  END delete_row;
Line: 2003

PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_coev_tbl coev_tbl_type) IS
  l_tabsize NUMBER := p_coev_tbl.COUNT;
Line: 2013

  in_last_updated_by               OKC_DATATYPES.NumberTabTyp;
Line: 2014

  in_last_update_date              OKC_DATATYPES.DateTabTyp;
Line: 2015

  in_last_update_login             OKC_DATATYPES.NumberTabTyp;
Line: 2031

    in_last_updated_by          (j) := p_coev_tbl(i).last_updated_by;
Line: 2032

    in_last_update_date         (j) := p_coev_tbl(i).last_update_date;
Line: 2033

    in_last_update_login        (j) := p_coev_tbl(i).last_update_login;
Line: 2038

    INSERT
      INTO OKC_CONDITION_OCCURS
      (
        id,
        cnh_id,
        datetime,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login
     )
     VALUES (
        in_id(i),
        in_cnh_id(i),
        in_datetime(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)
     );
Line: 2076

END INSERT_ROW_UPG;