APPS.AME_CONDITIONS_API SQL Statements

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

Line: 8

  X_LAST_UPDATED_BY out nocopy NUMBER,
  X_LAST_UPDATE_LOGIN out nocopy NUMBER
) is
begin
  X_CREATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);

Line: 13

  X_LAST_UPDATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);

Line: 14

  X_LAST_UPDATE_LOGIN := 0;

Line: 27

   select ATTRIBUTE_ID
   from   AME_ATTRIBUTES
 where NAME = X_ATTRIBUTE_NAME
   and sysdate between START_DATE
   and nvl(END_DATE-(1/86400), sysdate);

Line: 37

   select C.CREATED_BY
   from   AME_ATTRIBUTES C
   where  C.START_DATE =
    (select min(A.START_DATE) from AME_ATTRIBUTES A
      where A.ATTRIBUTE_ID = C.ATTRIBUTE_ID)
   and    C.ATTRIBUTE_ID = X_ATTRIBUTE_ID;

Line: 48

   select COUNT(*)
   from   AME_CONDITIONS
   where  CONDITION_ID        = X_CONDITION_ID;

Line: 103

    select ATTRIBUTE_TYPE
      into X_ATTRIBUTE_TYPE
      from AME_ATTRIBUTES
     where NAME = X_ATTRIBUTE_NAME
		   and sysdate between START_DATE
		     and nvl(END_DATE-(1/86400), sysdate);

Line: 141

         select to_number(X_PARAMETER_ONE)
           into X_PARAMETER_ONE_NUMBER
           from dual;

Line: 146

         select to_number(X_PARAMETER_TWO)
           into X_PARAMETER_TWO_NUMBER
           from dual;

Line: 165

         select to_number(X_PARAMETER_ONE)
           into X_PARAMETER_ONE_NUMBER
           from dual;

Line: 170

         select to_number(X_PARAMETER_TWO)
           into X_PARAMETER_TWO_NUMBER
           from dual;

Line: 188

          select to_date(X_PARAMETER_ONE,'YYYY:MM:DD:HH24:MI:SS')
            into X_PARAMETER_ONE_DATE
            from dual;

Line: 193

          select to_date(X_PARAMETER_TWO,'YYYY:MM:DD:HH24:MI:SS')
            into X_PARAMETER_TWO_DATE
            from dual;

Line: 248

procedure INSERT_ROW (
 X_CONDITION_ID                    in NUMBER,
 X_CONDITION_KEY                   in VARCHAR2,
 X_CONDITION_TYPE                  in VARCHAR2,
 X_ATTRIBUTE_ID                    in NUMBER,
 X_PARAMETER_ONE                   in VARCHAR2,
 X_PARAMETER_TWO                   in VARCHAR2,
 X_PARAMETER_THREE                 in VARCHAR2,
 X_INCLUDE_UPPER_LIMIT             in VARCHAR2,
 X_INCLUDE_LOWER_LIMIT             in VARCHAR2,
 X_CREATED_BY                      in NUMBER,
 X_CREATION_DATE                   in DATE,
 X_LAST_UPDATED_BY                 in NUMBER,
 X_LAST_UPDATE_DATE                in DATE,
 X_LAST_UPDATE_LOGIN               in NUMBER,
 X_START_DATE                      in DATE,
 X_OBJECT_VERSION_NUMBER           in NUMBER)
 is
  lockHandle varchar2(500);

Line: 277

    insert into AME_CONDITIONS
    (
      CONDITION_ID,
      CONDITION_KEY,
      CONDITION_TYPE,
      ATTRIBUTE_ID,
      PARAMETER_ONE,
      PARAMETER_TWO,
      PARAMETER_THREE,
      INCLUDE_UPPER_LIMIT,
      INCLUDE_LOWER_LIMIT,
      CREATED_BY,
      CREATION_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN,
      START_DATE,
      END_DATE,
      OBJECT_VERSION_NUMBER
    ) select
     X_CONDITION_ID,
     X_CONDITION_KEY,
     X_CONDITION_TYPE,
     X_ATTRIBUTE_ID,
     X_PARAMETER_ONE,
     X_PARAMETER_TWO,
     X_PARAMETER_THREE,
     X_INCLUDE_UPPER_LIMIT,
     X_INCLUDE_LOWER_LIMIT,
     X_CREATED_BY,
     X_CREATION_DATE,
     X_LAST_UPDATED_BY,
     X_LAST_UPDATE_DATE,
     X_LAST_UPDATE_LOGIN,
     X_START_DATE,
     AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
     X_OBJECT_VERSION_NUMBER
     from sys.dual
     where not exists (select NULL
                       from AME_CONDITIONS
                          where ((CONDITION_ID = X_CONDITION_ID
                          and sysdate < nvl(END_DATE - (1/86400), sysdate + (1/86400)))
                          or (X_AME_INSTALLATION_LEVEL is not null and CONDITION_KEY = X_CONDITION_KEY))
         );

Line: 322

end INSERT_ROW;

Line: 324

procedure DELETE_ROW (
  X_CONDITION_ID in NUMBER
) is
begin
  delete from AME_CONDITIONS
  where CONDITION_ID = X_CONDITION_ID;

Line: 333

end DELETE_ROW;

Line: 337

      select to_char(DB.DBID)
      from   V$DATABASE DB,
             V$INSTANCE INSTANCE
      where  upper(DB.NAME) = upper(INSTANCE.INSTANCE_NAME);

Line: 356

        select AME_CONDITION_KEYS_S.NEXTVAL into X_CONDITION_KEY_ID from dual;

Line: 358

      select count(*)
        into X_CONDITION_COUNT
        from AME_CONDITIONS
       where upper(CONDITION_KEY) = upper(X_NEW_CONDITION_KEY)
         and rownum < 2;

Line: 387

          X_LAST_UPDATE_DATE    in VARCHAR2
)
is
  X_ATTRIBUTE_ID       NUMBER;

Line: 394

  X_LAST_UPDATED_BY    NUMBER;

Line: 395

  X_LAST_UPDATE_LOGIN  NUMBER;

Line: 417

    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 428

     INSERT_ROW (
       X_CONDITION_ID,
       X_CONDITION_KEY,
       X_CONDITION_TYPE,
       X_ATTRIBUTE_ID,
       X_PARAMETER_ONE,
       X_PARAMETER_TWO,
       X_PARAMETER_THREE,
       X_INCLUDE_UPPER_LIMIT,
       X_INCLUDE_LOWER_LIMIT,
       X_CREATED_BY,
       to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
       X_LAST_UPDATED_BY,
       to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
       X_LAST_UPDATE_LOGIN,
       to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
       1);