APPS.OZF_DENORM_QUERIES_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  X_ROWID             IN OUT NOCOPY VARCHAR2,
  X_DENORM_QUERY_ID   IN NUMBER,
  X_QUERY_FOR         IN VARCHAR2,
  X_CONTEXT           IN VARCHAR2,
  X_ATTRIBUTE         IN VARCHAR2,
  X_CONDITION_ID_COLUMN      IN VARCHAR2,
  X_CONDITION_NAME_COLUMN    IN VARCHAR2,
  X_ACTIVE_FLAG       IN VARCHAR2,
  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_SEEDED_FLAG       IN VARCHAR2,
  X_SQL_VALIDATION_1  IN VARCHAR2,
  X_SQL_VALIDATION_2  IN VARCHAR2,
  X_SQL_VALIDATION_3  IN VARCHAR2,
  X_SQL_VALIDATION_4  IN VARCHAR2,
  X_SQL_VALIDATION_5  IN VARCHAR2,
  X_SQL_VALIDATION_6  IN VARCHAR2,
  X_SQL_VALIDATION_7  IN VARCHAR2,
  X_SQL_VALIDATION_8  IN VARCHAR2,
  X_OBJECT_VERSION_NUMBER IN NUMBER,
  X_SECURITY_GROUP_ID IN NUMBER)
  is
  cursor C is select ROWID from OZF_DENORM_QUERIES
    where DENORM_QUERY_ID = X_DENORM_QUERY_ID;

Line: 33

  insert into OZF_DENORM_QUERIES(
    DENORM_QUERY_ID,
    QUERY_FOR,
    CONTEXT,
    ATTRIBUTE,
    CONDITION_ID_COLUMN,
    CONDITION_NAME_COLUMN,
    ACTIVE_FLAG,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    SEEDED_FLAG,
    SQL_VALIDATION_1,
    SQL_VALIDATION_2,
    SQL_VALIDATION_3,
    SQL_VALIDATION_4,
    SQL_VALIDATION_5,
    SQL_VALIDATION_6,
    SQL_VALIDATION_7,
    SQL_VALIDATION_8,
    OBJECT_VERSION_NUMBER,
    SECURITY_GROUP_ID
  )
  values (
    X_DENORM_QUERY_ID,
    X_QUERY_FOR,
    X_CONTEXT,
    X_ATTRIBUTE,
    X_CONDITION_ID_COLUMN,
    X_CONDITION_NAME_COLUMN,
    X_ACTIVE_FLAG,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_SEEDED_FLAG,
    X_SQL_VALIDATION_1,
    X_SQL_VALIDATION_2,
    X_SQL_VALIDATION_3,
    X_SQL_VALIDATION_4,
    X_SQL_VALIDATION_5,
    X_SQL_VALIDATION_6,
    X_SQL_VALIDATION_7,
    X_SQL_VALIDATION_8,
    X_OBJECT_VERSION_NUMBER,
    X_SECURITY_GROUP_ID

  );

Line: 94

end INSERT_ROW;

Line: 118

procedure UPDATE_ROW (
  X_DENORM_QUERY_ID   IN NUMBER,
  X_QUERY_FOR         IN VARCHAR2,
  X_CONTEXT           IN VARCHAR2,
  X_ATTRIBUTE         IN VARCHAR2,
  X_CONDITION_ID_COLUMN      IN VARCHAR2,
  X_CONDITION_NAME_COLUMN    IN VARCHAR2,
  X_ACTIVE_FLAG       IN VARCHAR2,
  X_LAST_UPDATE_DATE  IN DATE,
  X_LAST_UPDATED_BY   IN NUMBER,
  X_LAST_UPDATE_LOGIN IN NUMBER,
  X_SEEDED_FLAG       IN VARCHAR2,
  X_SQL_VALIDATION_1  IN VARCHAR2,
  X_SQL_VALIDATION_2  IN VARCHAR2,
  X_SQL_VALIDATION_3  IN VARCHAR2,
  X_SQL_VALIDATION_4  IN VARCHAR2,
  X_SQL_VALIDATION_5  IN VARCHAR2,
  X_SQL_VALIDATION_6  IN VARCHAR2,
  X_SQL_VALIDATION_7  IN VARCHAR2,
  X_SQL_VALIDATION_8  IN VARCHAR2,
  X_OBJECT_VERSION_NUMBER IN NUMBER,
  X_SECURITY_GROUP_ID IN NUMBER
) is
begin
  update OZF_DENORM_QUERIES set
    QUERY_FOR       = X_QUERY_FOR ,
    CONTEXT         = X_CONTEXT ,
    ATTRIBUTE       = X_ATTRIBUTE,
    CONDITION_ID_COLUMN    = X_CONDITION_ID_COLUMN,
    CONDITION_NAME_COLUMN  = X_CONDITION_NAME_COLUMN,
    ACTIVE_FLAG     = X_ACTIVE_FLAG,
    LAST_UPDATE_DATE  = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY   = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SEEDED_FLAG     = X_SEEDED_FLAG,
    SQL_VALIDATION_1= X_SQL_VALIDATION_1,
    SQL_VALIDATION_2= X_SQL_VALIDATION_2,
    SQL_VALIDATION_3= X_SQL_VALIDATION_3,
    SQL_VALIDATION_4= X_SQL_VALIDATION_4,
    SQL_VALIDATION_5= X_SQL_VALIDATION_5,
    SQL_VALIDATION_6= X_SQL_VALIDATION_6,
    SQL_VALIDATION_7= X_SQL_VALIDATION_7,
    SQL_VALIDATION_8= X_SQL_VALIDATION_8,
    OBJECT_VERSION_NUMBER=X_OBJECT_VERSION_NUMBER,
    SECURITY_GROUP_ID=X_SECURITY_GROUP_ID
  where DENORM_QUERY_ID = X_DENORM_QUERY_ID;

Line: 171

end UPDATE_ROW;

Line: 173

procedure DELETE_ROW (
  X_DENORM_QUERY_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER IN NUMBER
) is
begin
  delete from OZF_DENORM_QUERIES
  where DENORM_QUERY_ID = X_DENORM_QUERY_ID
  and object_version_number=X_OBJECT_VERSION_NUMBER;

Line: 186

end DELETE_ROW;

Line: 222

SELECT last_updated_by
FROM   ozf_denorm_queries
WHERE  denorm_query_id = X_DENORM_QUERY_ID;

Line: 229

  select 'x'
  from    OZF_DENORM_QUERIES
  where  context=  X_CONTEXT
  AND attribute=X_ATTRIBUTE;

Line: 235

   select OZF_DENORM_QUERIES_S.nextval
   from dual;

Line: 256

    OZF_DENORM_QUERIES_PKG.INSERT_ROW(
    X_ROWID			=> l_row_id,
    X_DENORM_QUERY_ID		=> l_DENORM_QUERY_id,
    X_QUERY_FOR                 => X_QUERY_FOR,
    X_CONTEXT                   => X_CONTEXT,
    X_ATTRIBUTE                 => X_ATTRIBUTE,
    X_CONDITION_ID_COLUMN             => X_CONDITION_ID_COLUMN ,
    X_CONDITION_NAME_COLUMN            => X_CONDITION_NAME_COLUMN,
    X_ACTIVE_FLAG               => X_ACTIVE_FLAG,
    X_CREATION_DATE		=> SYSDATE,
    X_CREATED_BY		=> l_user_id,
    X_LAST_UPDATE_DATE		=> SYSDATE,
    X_LAST_UPDATED_BY		=> l_user_id,
    X_LAST_UPDATE_LOGIN		=> FND_GLOBAL.CONC_LOGIN_ID,
    X_SEEDED_FLAG               => X_SEEDED_FLAG,
    X_SQL_VALIDATION_1          => X_SQL_VALIDATION_1,
    X_SQL_VALIDATION_2          => X_SQL_VALIDATION_2,
    X_SQL_VALIDATION_3          => X_SQL_VALIDATION_3,
    X_SQL_VALIDATION_4          => X_SQL_VALIDATION_4,
    X_SQL_VALIDATION_5          => X_SQL_VALIDATION_5,
    X_SQL_VALIDATION_6          => X_SQL_VALIDATION_6,
    X_SQL_VALIDATION_7          => X_SQL_VALIDATION_7,
    X_SQL_VALIDATION_8          => X_SQL_VALIDATION_8 ,
    X_OBJECT_VERSION_NUMBER =>X_OBJECT_VERSION_NUMBER,
    X_SECURITY_GROUP_ID => X_SECURITY_GROUP_ID
    );

Line: 296

    OZF_DENORM_QUERIES_PKG.UPDATE_ROW(
    X_DENORM_QUERY_ID   =>  l_denorm_query_id,
    X_QUERY_FOR         =>  X_QUERY_FOR,
    X_CONTEXT           =>  X_CONTEXT,
    X_ATTRIBUTE         =>  X_ATTRIBUTE,
    X_CONDITION_ID_COLUMN      =>  X_CONDITION_ID_COLUMN,
    X_CONDITION_NAME_COLUMN    =>  X_CONDITION_NAME_COLUMN,
    X_ACTIVE_FLAG       =>  X_ACTIVE_FLAG,
    X_LAST_UPDATE_DATE  =>  SYSDATE,
    X_LAST_UPDATED_BY   =>  l_user_id,
    X_LAST_UPDATE_LOGIN	=>  FND_GLOBAL.CONC_LOGIN_ID,
    X_SEEDED_FLAG       =>  X_SEEDED_FLAG,
    X_SQL_VALIDATION_1  =>  X_SQL_VALIDATION_1,
    X_SQL_VALIDATION_2  =>  X_SQL_VALIDATION_2,
    X_SQL_VALIDATION_3  =>  X_SQL_VALIDATION_3,
    X_SQL_VALIDATION_4  =>  X_SQL_VALIDATION_4,
    X_SQL_VALIDATION_5  =>  X_SQL_VALIDATION_5,
    X_SQL_VALIDATION_6  =>  X_SQL_VALIDATION_6,
    X_SQL_VALIDATION_7  =>  X_SQL_VALIDATION_7,
    X_SQL_VALIDATION_8  =>  X_SQL_VALIDATION_8,
    X_OBJECT_VERSION_NUMBER =>X_OBJECT_VERSION_NUMBER,
    X_SECURITY_GROUP_ID => X_SECURITY_GROUP_ID
    );