DBA Data[Home] [Help]

APPS.AME_CONDITIONS_API2 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: 29

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

   select CONDITION_ID, CREATED_BY
   from   AME_CONDITIONS
   where  CONDITION_KEY = X_CONDITION_KEY;
Line: 46

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

   select CONDITION_ID
   from   AME_CONDITIONS
   where  CONDITION_KEY = X_CONDITION_KEY;
Line: 127

   select CONDITION_KEY
   from   AME_CONDITIONS
   where  CONDITION_ID = X_CONDITION_ID;
Line: 135

   select count(*)
   from   AME_CONDITIONS
   where  CONDITION_ID = X_CONDITION_ID;
Line: 142

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

   select ATTRIBUTE_ID
   from   AME_ATTRIBUTES
   where  NAME = X_ATTRIBUTE_NAME
     and ((START_DATE - (1/86400)) <= sysdate)
     and (((END_DATE  - (1/86400)) >= sysdate)
      or (END_DATE is null));
Line: 253

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

         select to_number(X_PARAMETER_ONE)
           into X_PARAMETER_ONE_NUMBER
           from dual;
Line: 296

         select to_number(X_PARAMETER_TWO)
           into X_PARAMETER_TWO_NUMBER
           from dual;
Line: 315

         select to_number(X_PARAMETER_ONE)
           into X_PARAMETER_ONE_NUMBER
           from dual;
Line: 320

         select to_number(X_PARAMETER_TWO)
           into X_PARAMETER_TWO_NUMBER
           from dual;
Line: 338

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

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

procedure INSERT_ROW (
 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: 423

    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
     ame_conditions_s.nextval,
     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_KEY = X_CONDITION_KEY);
Line: 465

end INSERT_ROW;
Line: 467

procedure INSERT_ROW_2 (
 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: 491

  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);
Line: 533

end INSERT_ROW_2;
Line: 535

procedure DELETE_ROW (
  X_CONDITION_KEY in VARCHAR2
) is
begin
  delete from AME_CONDITIONS
  where CONDITION_KEY = X_CONDITION_KEY;
Line: 545

end DELETE_ROW;
Line: 558

          X_LAST_UPDATE_DATE    in VARCHAR2,
          X_CUSTOM_MODE         in VARCHAR2
)
is
  X_ATTRIBUTE_ID NUMBER;
Line: 569

  X_LAST_UPDATED_BY NUMBER;
Line: 570

  X_LAST_UPDATE_LOGIN NUMBER;
Line: 585

    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );
Line: 608

           update AME_CONDITIONS
           set CONDITION_KEY = '@' || X_CONDITION_KEY
           where CONDITION_KEY = X_CONDITION_KEY;
Line: 611

         INSERT_ROW (
           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);
Line: 631

         INSERT_ROW (
           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);
Line: 663

       INSERT_ROW_2 (
       X_CONDITION_ID,
       X_CONDITION_KEY2,
       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);
Line: 688

       update AME_CONDITIONS
       set CONDITION_KEY = X_CONDITION_KEY
       where CONDITION_KEY = X_EXISTING_CONDITION_KEY
         and CONDITION_ID  = X_CONDITION_ID;