APPS.OKE_K_ACCESS_RULES_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID                   IN OUT NOCOPY /* file.sql.39 change */    VARCHAR2,
  X_ACCESS_RULE_ID          IN OUT NOCOPY /* file.sql.39 change */    NUMBER,
  X_CREATION_DATE           in        DATE,
  X_CREATED_BY              in        NUMBER,
  X_LAST_UPDATE_DATE        in        DATE,
  X_LAST_UPDATED_BY         in        NUMBER,
  X_LAST_UPDATE_LOGIN       in        NUMBER,
  X_ROLE_ID                 in        NUMBER,
  X_SECURED_OBJECT_NAME     in        VARCHAR2,
  X_ATTRIBUTE_GROUP_TYPE    in        VARCHAR2,
  X_ATTRIBUTE_GROUP_CODE    in        VARCHAR2,
  X_ATTRIBUTE_CODE          in        VARCHAR2,
  X_ACCESS_LEVEL            in        VARCHAR2
) is
  cursor C is select ROWID from OKE_K_ACCESS_RULES
    where ACCESS_RULE_ID = X_ACCESS_RULE_ID
    ;

Line: 22

  select OKE_K_ACCESS_RULES_S.nextval
  into   X_ACCESS_RULE_ID
  from   dual;

Line: 26

  insert into OKE_K_ACCESS_RULES (
    ACCESS_RULE_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    ROLE_ID,
    SECURED_OBJECT_NAME,
    ATTRIBUTE_GROUP_TYPE,
    ATTRIBUTE_GROUP_CODE,
    ATTRIBUTE_CODE,
    ACCESS_LEVEL
  ) values (
    X_ACCESS_RULE_ID,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_ROLE_ID,
    X_SECURED_OBJECT_NAME,
    X_ATTRIBUTE_GROUP_TYPE,
    X_ATTRIBUTE_GROUP_CODE,
    X_ATTRIBUTE_CODE,
    X_ACCESS_LEVEL
  );

Line: 62

end INSERT_ROW;

Line: 73

  cursor c is select
      ROLE_ID,
      SECURED_OBJECT_NAME,
      ATTRIBUTE_GROUP_TYPE,
      ATTRIBUTE_GROUP_CODE,
      ATTRIBUTE_CODE,
      ACCESS_LEVEL
    from OKE_K_ACCESS_RULES
    where ACCESS_RULE_ID = X_ACCESS_RULE_ID
    for update of ACCESS_RULE_ID nowait;

Line: 90

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 113

procedure UPDATE_ROW (
  X_ACCESS_RULE_ID          in        NUMBER,
  X_LAST_UPDATE_DATE        in        DATE,
  X_LAST_UPDATED_BY         in        NUMBER,
  X_LAST_UPDATE_LOGIN       in        NUMBER,
  X_ROLE_ID                 in        NUMBER,
  X_SECURED_OBJECT_NAME     in        VARCHAR2,
  X_ATTRIBUTE_GROUP_TYPE    in        VARCHAR2,
  X_ATTRIBUTE_GROUP_CODE    in        VARCHAR2,
  X_ATTRIBUTE_CODE          in        VARCHAR2,
  X_ACCESS_LEVEL            in        VARCHAR2
) is
begin
  update OKE_K_ACCESS_RULES set
    LAST_UPDATE_DATE     = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY      = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN    = X_LAST_UPDATE_LOGIN,
    ROLE_ID              = X_ROLE_ID,
    SECURED_OBJECT_NAME  = X_SECURED_OBJECT_NAME,
    ATTRIBUTE_GROUP_TYPE = X_ATTRIBUTE_GROUP_TYPE,
    ATTRIBUTE_GROUP_CODE = X_ATTRIBUTE_GROUP_CODE,
    ATTRIBUTE_CODE       = X_ATTRIBUTE_CODE,
    ACCESS_LEVEL         = X_ACCESS_LEVEL
  where ACCESS_RULE_ID = X_ACCESS_RULE_ID;

Line: 141

end UPDATE_ROW;

Line: 143

procedure DELETE_ROW (
  X_ACCESS_RULE_ID          in        NUMBER
) is
begin
  delete from OKE_K_ACCESS_RULES
  where ACCESS_RULE_ID = X_ACCESS_RULE_ID;

Line: 154

end DELETE_ROW;

Line: 156

procedure DELETE_ALL (
  X_ROLE_ID                 in        NUMBER
) is
begin
  delete from OKE_K_ACCESS_RULES
  where ROLE_ID = X_ROLE_ID;

Line: 163

  delete from OKE_COMPILED_ACCESS_RULES
  where ROLE_ID = X_ROLE_ID;

Line: 166

end DELETE_ALL;