APPS.EAM_ATTR_ASSIGN_PVT SQL Statements

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

Line: 41

PROCEDURE INSERT_ROW(
  P_API_VERSION IN NUMBER,
  P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
  P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
  P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
  P_ROWID                         IN OUT NOCOPY VARCHAR2,
  P_ATTRIBUTE_ASSOCIATION_ID      IN OUT NOCOPY NUMBER,
  P_APPLICATION_ID                NUMBER,
  P_FLEXFIELD_NAME                VARCHAR2,
  P_FLEX_CONTEXT_CODE             VARCHAR2,
  P_ORGANIZATION_ID               NUMBER,
  P_INVENTORY_ITEM_ID             NUMBER,
  P_ENABLED_FLAG                  VARCHAR2,
  P_LAST_UPDATE_DATE              DATE,
  P_LAST_UPDATED_BY               NUMBER,
  P_CREATION_DATE                 DATE,
  P_CREATED_BY                    NUMBER,
  P_LAST_UPDATE_LOGIN             NUMBER,
  P_CREATION_ORGANIZATION_ID	  NUMBER,
  X_RETURN_STATUS OUT NOCOPY VARCHAR2,
  X_MSG_COUNT OUT NOCOPY NUMBER,
  X_MSG_DATA OUT NOCOPY VARCHAR2
  ) IS
    l_api_name       CONSTANT VARCHAR2(30) := 'insert_row';

Line: 68

    CURSOR C IS SELECT rowid FROM MTL_EAM_ASSET_ATTR_GROUPS
                 WHERE ASSOCIATION_ID = P_ATTRIBUTE_ASSOCIATION_ID;

Line: 90

       INSERT INTO MTL_EAM_ASSET_ATTR_GROUPS(
       ASSOCIATION_ID,
       APPLICATION_ID,
       DESCRIPTIVE_FLEXFIELD_NAME,
       DESCRIPTIVE_FLEX_CONTEXT_CODE,
       ORGANIZATION_ID,
       INVENTORY_ITEM_ID,
       ENABLED_FLAG,
       LAST_UPDATE_DATE,
       LAST_UPDATED_BY,
       CREATION_DATE,
       CREATED_BY,
       LAST_UPDATE_LOGIN,
       CREATION_ORGANIZATION_ID
       ) values (
--       P_ATTRIBUTE_ASSOCIATION_ID,
       mtl_eam_asset_attr_groups_s.nextval,
       P_APPLICATION_ID,
       P_FLEXFIELD_NAME,
       P_FLEX_CONTEXT_CODE,
       P_ORGANIZATION_ID,
       P_INVENTORY_ITEM_ID,
       P_ENABLED_FLAG,
       P_LAST_UPDATE_DATE,
       P_LAST_UPDATED_BY,
       P_CREATION_DATE,
       P_CREATED_BY,
       P_LAST_UPDATE_LOGIN,
       P_CREATION_ORGANIZATION_ID) returning association_id, rowid into P_ATTRIBUTE_ASSOCIATION_ID, P_ROWID;

Line: 157

  END Insert_Row;

Line: 181

        SELECT *
        FROM   MTL_EAM_ASSET_ATTR_GROUPS
        WHERE  rowid = P_Rowid
        FOR UPDATE of ASSOCIATION_ID NOWAIT;

Line: 211

      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 260

PROCEDURE UPDATE_ROW(
  P_API_VERSION IN NUMBER,
  P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
  P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
  P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
  P_ROWID                         VARCHAR2,
  P_ENABLED_FLAG                  VARCHAR2,
  P_LAST_UPDATE_DATE              DATE,
  P_LAST_UPDATED_BY               NUMBER,
  P_LAST_UPDATE_LOGIN             NUMBER,
  X_RETURN_STATUS OUT NOCOPY VARCHAR2,
  X_MSG_COUNT OUT NOCOPY NUMBER,
  X_MSG_DATA OUT NOCOPY VARCHAR2
  ) IS
    l_api_name       CONSTANT VARCHAR2(30) := 'update_row';

Line: 296

    UPDATE MTL_EAM_ASSET_ATTR_GROUPS
    SET
     ENABLED_FLAG                    =     P_ENABLED_FLAG,
     LAST_UPDATE_DATE                =     P_LAST_UPDATE_DATE,
     LAST_UPDATED_BY                 =     P_LAST_UPDATED_BY,
     LAST_UPDATE_LOGIN               =     P_LAST_UPDATE_LOGIN
    WHERE ROWID = P_ROWID;

Line: 337

  END Update_Row;