DBA Data[Home] [Help]

APPS.OKC_AAV_PVT SQL Statements

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

Line: 46

    SELECT
            AAE_ID,
            COE_ID,
            VALUE,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Action_Att_Vals
     WHERE okc_action_att_vals.aae_id = p_aae_id
       AND okc_action_att_vals.coe_id = p_coe_id;
Line: 73

              l_aav_rec.LAST_UPDATED_BY,
              l_aav_rec.LAST_UPDATE_DATE,
              l_aav_rec.LAST_UPDATE_LOGIN;
Line: 97

    SELECT
            AAE_ID,
            COE_ID,
            OBJECT_VERSION_NUMBER,
            VALUE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Action_Att_Vals_V
     WHERE okc_action_att_vals_v.aae_id = p_aae_id
       AND okc_action_att_vals_v.coe_id = p_coe_id;
Line: 124

              l_aavv_rec.LAST_UPDATED_BY,
              l_aavv_rec.LAST_UPDATE_DATE,
              l_aavv_rec.LAST_UPDATE_LOGIN;
Line: 166

    IF (l_aavv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_aavv_rec.last_updated_by := NULL;
Line: 169

    IF (l_aavv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_aavv_rec.last_update_date := NULL;
Line: 172

    IF (l_aavv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_aavv_rec.last_update_login := NULL;
Line: 383

  SELECT 1
  FROM okc_action_att_vals
  WHERE  aae_id = p_aae_id
  AND    coe_id = p_coe_id;
Line: 462

      SELECT  '1'
        FROM Okc_Action_Attributes_V
       WHERE okc_action_attributes_v.id = p_id;
Line: 469

      SELECT  '1'
        FROM Okc_Condition_Occurs_V
       WHERE okc_condition_occurs_v.id = p_id;
Line: 622

      SELECT
              ID,
              AAL_ID,
              OBJECT_VERSION_NUMBER,
              SFWT_FLAG,
              ACN_ID,
              ELEMENT_NAME,
              NAME,
              DESCRIPTION,
              DATA_TYPE,
              LIST_YN,
              VISIBLE_YN,
              DATE_OF_INTEREST_YN,
              FORMAT_MASK,
              MINIMUM_VALUE,
              MAXIMUM_VALUE,
              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_Action_Attributes_V
       WHERE okc_action_attributes_v.id = p_id;
Line: 663

      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: 719

 /******** Commented out nocopy , called in Insert Row ***********
   -- Validate_Unique_Aav_Record;
Line: 752

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

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

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

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

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

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

  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_aav_rec                      IN aav_rec_type,
    x_aav_rec                      OUT NOCOPY aav_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 932

    l_api_name                     CONSTANT VARCHAR2(30) := 'VALS_insert_row';
Line: 968

    INSERT INTO OKC_ACTION_ATT_VALS(
        aae_id,
        coe_id,
        value,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_aav_rec.aae_id,
        l_aav_rec.coe_id,
        l_aav_rec.value,
        l_aav_rec.object_version_number,
        l_aav_rec.created_by,
        l_aav_rec.creation_date,
        l_aav_rec.last_updated_by,
        l_aav_rec.last_update_date,
        l_aav_rec.last_update_login);
Line: 1022

  END insert_row;
Line: 1026

  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_aavv_rec                     IN aavv_rec_type,
    x_aavv_rec                     OUT NOCOPY aavv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1036

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

      l_aavv_rec.LAST_UPDATE_DATE := l_aavv_rec.CREATION_DATE;
Line: 1053

      l_aavv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1054

      l_aavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1136

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_aav_rec,
      lx_aav_rec
    );
Line: 1184

  END insert_row;
Line: 1188

  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_aavv_tbl                     IN aavv_tbl_type,
    x_aavv_tbl                     OUT NOCOPY aavv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1198

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

        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_aavv_rec                     => p_aavv_tbl(i),
          x_aavv_rec                     => x_aavv_tbl(i));
Line: 1250

  END insert_row;
Line: 1268

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_ACTION_ATT_VALS
     WHERE AAE_ID = p_aav_rec.aae_id
       AND COE_ID = p_aav_rec.coe_id
       AND OBJECT_VERSION_NUMBER = p_aav_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1276

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_ACTION_ATT_VALS
    WHERE AAE_ID = p_aav_rec.aae_id
       AND COE_ID = p_aav_rec.coe_id;
Line: 1318

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

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

  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_aav_rec                      IN aav_rec_type,
    x_aav_rec                      OUT NOCOPY aav_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1523

    l_api_name                     CONSTANT VARCHAR2(30) := 'VALS_update_row';
Line: 1569

      IF (x_aav_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_aav_rec.last_updated_by := l_aav_rec.last_updated_by;
Line: 1573

      IF (x_aav_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_aav_rec.last_update_date := l_aav_rec.last_update_date;
Line: 1577

      IF (x_aav_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_aav_rec.last_update_login := l_aav_rec.last_update_login;
Line: 1621

    UPDATE  OKC_ACTION_ATT_VALS
    SET VALUE = l_def_aav_rec.value,
        OBJECT_VERSION_NUMBER = l_def_aav_rec.object_version_number,
        CREATED_BY = l_def_aav_rec.created_by,
        CREATION_DATE = l_def_aav_rec.creation_date,
        LAST_UPDATED_BY = l_def_aav_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_aav_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_aav_rec.last_update_login
    WHERE AAE_ID = l_def_aav_rec.aae_id
      AND COE_ID = l_def_aav_rec.coe_id;
Line: 1665

  END update_row;
Line: 1669

  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_aavv_rec                     IN aavv_rec_type,
    x_aavv_rec                     OUT NOCOPY aavv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1679

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

      l_aavv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1694

      l_aavv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1695

      l_aavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1739

      IF (x_aavv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_aavv_rec.last_updated_by := l_aavv_rec.last_updated_by;
Line: 1743

      IF (x_aavv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_aavv_rec.last_update_date := l_aavv_rec.last_update_date;
Line: 1747

      IF (x_aavv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_aavv_rec.last_update_login := l_aavv_rec.last_update_login;
Line: 1818

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_aav_rec,
      lx_aav_rec
    );
Line: 1865

  END update_row;
Line: 1869

  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_aavv_tbl                     IN aavv_tbl_type,
    x_aavv_tbl                     OUT NOCOPY aavv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1879

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

        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_aavv_rec                     => p_aavv_tbl(i),
          x_aavv_rec                     => x_aavv_tbl(i));
Line: 1931

  END update_row;
Line: 1939

  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_aav_rec                      IN aav_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1947

    l_api_name                     CONSTANT VARCHAR2(30) := 'VALS_delete_row';
Line: 1961

    DELETE FROM OKC_ACTION_ATT_VALS
     WHERE AAE_ID = l_aav_rec.aae_id AND
COE_ID = l_aav_rec.coe_id;
Line: 1997

  END delete_row;
Line: 2001

  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_aavv_rec                     IN aavv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2010

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

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_aav_rec
    );
Line: 2078

  END delete_row;
Line: 2082

  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_aavv_tbl                     IN aavv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2091

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

        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_aavv_rec                     => p_aavv_tbl(i));
Line: 2142

  END delete_row;
Line: 2146

PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_aavv_tbl aavv_tbl_type) IS
  l_tabsize NUMBER := p_aavv_tbl.COUNT;
Line: 2156

  in_last_updated_by               OKC_DATATYPES.NumberTabTyp;
Line: 2157

  in_last_update_date              OKC_DATATYPES.DateTabTyp;
Line: 2158

  in_last_update_login             OKC_DATATYPES.NumberTabTyp;
Line: 2174

    in_last_updated_by          (j) := p_aavv_tbl(i).last_updated_by;
Line: 2175

    in_last_update_date         (j) := p_aavv_tbl(i).last_update_date;
Line: 2176

    in_last_update_login        (j) := p_aavv_tbl(i).last_update_login;
Line: 2181

    INSERT
      INTO OKC_ACTION_ATT_VALS
      (
        aae_id,
        coe_id,
        value,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login
     )
     VALUES (
        in_aae_id(i),
        in_coe_id(i),
        in_value(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: 2219

END INSERT_ROW_UPG;