APPS.AME_RULES_API SQL Statements

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

Line: 7

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

  X_LAST_UPDATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);

Line: 13

  X_LAST_UPDATE_LOGIN := 0;

Line: 32

   select ACTION_TYPE_ID
   from   AME_ACTION_TYPES
   where  NAME = X_ACTION_TYPE_NAME
      and sysdate between START_DATE
      and nvl(END_DATE  - (1/86400), sysdate);

Line: 42

   select ACTION_ID from AME_ACTIONS
    where ACTION_TYPE_ID = X_ACTION_TYPE_ID
      and nvl(PARAMETER,'NULL')      = nvl(X_PARAMETER,'NULL')
      and sysdate between START_DATE
      and nvl(END_DATE  - (1/86400), sysdate);

Line: 52

  select ROWID,
         LAST_UPDATED_BY,
         to_char(LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
         nvl(OBJECT_VERSION_NUMBER,1)
    from AME_ACTION_USAGES
   where RULE_ID   = X_RULE_ID
     and ACTION_ID = X_ACTION_ID
      and sysdate between START_DATE
      and nvl(END_DATE  - (1/86400), sysdate);

Line: 65

  select COUNT(*)
    from AME_RULES
   where RULE_ID = X_RULE_ID;

Line: 139

procedure INSERT_ROW (
 X_RULE_ID                         in NUMBER,
 X_RULE_KEY                        in VARCHAR2,
 X_RULE_TYPE                       in NUMBER,
 X_ACTION_ID                       in NUMBER,
 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_DESCRIPTION                     in VARCHAR2,
 X_ITEM_CLASS_ID                   in NUMBER,
 X_OBJECT_VERSION_NUMBER           in NUMBER)
 is
  lockHandle varchar2(500);

Line: 161

  insert into AME_RULES
  (
   RULE_ID,
   RULE_KEY,
   RULE_TYPE,
   ACTION_ID,
   CREATED_BY,
   CREATION_DATE,
   LAST_UPDATED_BY,
   LAST_UPDATE_DATE,
   LAST_UPDATE_LOGIN,
   START_DATE,
   END_DATE,
   DESCRIPTION,
   ITEM_CLASS_ID,
   OBJECT_VERSION_NUMBER
  ) select
   X_RULE_ID,
   X_RULE_KEY,
   X_RULE_TYPE,
   X_ACTION_ID,
   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_DESCRIPTION,
   X_ITEM_CLASS_ID,
   X_OBJECT_VERSION_NUMBER
   from sys.dual
   where not exists (select NULL
                       from AME_RULES
                          where ((RULE_ID = X_RULE_ID
                          and sysdate < nvl(END_DATE - (1/86400), sysdate + (1/86400)))
                          or (X_AME_INSTALLATION_LEVEL is not null and RULE_KEY = X_RULE_KEY))
         );

Line: 200

    insert into AME_RULES_TL
      (RULE_ID
      ,DESCRIPTION
      ,CREATED_BY
      ,CREATION_DATE
      ,LAST_UPDATED_BY
      ,LAST_UPDATE_DATE
      ,LAST_UPDATE_LOGIN
      ,LANGUAGE
      ,SOURCE_LANG
      ) select X_RULE_ID,
               X_DESCRIPTION,
               X_CREATED_BY,
               X_CREATION_DATE,
               X_LAST_UPDATED_BY,
               X_LAST_UPDATE_DATE,
               X_LAST_UPDATE_LOGIN,
               L.LANGUAGE_CODE,
               userenv('LANG')
          from FND_LANGUAGES L
         where L.INSTALLED_FLAG in ('I', 'B')
           and not exists (select null
                             from AME_RULES_TL T
                            where T.RULE_ID = X_RULE_ID
                              and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 227

end INSERT_ROW;

Line: 228

function DO_USAGE_UPDATE_INSERT(X_OWNER in NUMBER,
                   X_CURRENT_OWNER in NUMBER,
                   X_LAST_UPDATE_DATE in VARCHAR2,
                   X_CURRENT_LAST_UPDATE_DATE in VARCHAR2)
return boolean as
begin
  return AME_SEED_UTILITY.MERGE_ROW_TEST
    (X_OWNER                     => X_OWNER
    ,X_CURRENT_OWNER             => X_CURRENT_OWNER
    ,X_LAST_UPDATE_DATE          => X_LAST_UPDATE_DATE
    ,X_CURRENT_LAST_UPDATE_DATE  => X_CURRENT_LAST_UPDATE_DATE
    ,X_CUSTOM_MODE               => null
    );

Line: 241

end DO_USAGE_UPDATE_INSERT;

Line: 243

procedure INSERT_USAGE_ROW (
 X_RULE_ID                         in NUMBER,
 X_ACTION_ID                       in NUMBER,
 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: 262

    insert into AME_ACTION_USAGES
    (
     RULE_ID,
     ACTION_ID,
     CREATED_BY,
     CREATION_DATE,
     LAST_UPDATED_BY,
     LAST_UPDATE_DATE,
     LAST_UPDATE_LOGIN,
     START_DATE,
     END_DATE,
     OBJECT_VERSION_NUMBER
    ) select
     X_RULE_ID,
     X_ACTION_ID,
     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_ACTION_USAGES
                      where RULE_ID   = X_RULE_ID
                        and ACTION_ID = X_ACTION_ID
                        and sysdate between START_DATE
                        and nvl(END_DATE - (1/86400), sysdate));

Line: 294

end INSERT_USAGE_ROW;

Line: 296

procedure DELETE_ROW (
  X_RULE_ID  in VARCHAR2
) is
begin
  delete from AME_RULES
  where RULE_ID = X_RULE_ID;

Line: 305

end DELETE_ROW;

Line: 307

procedure UPDATE_USAGE_ROW (
 X_ACTION_USAGE_ROWID             in VARCHAR2,
 X_END_DATE                       in DATE)
 is
begin
  update AME_ACTION_USAGES set
   END_DATE             = X_END_DATE
  where ROWID           = X_ACTION_USAGE_ROWID;

Line: 315

end UPDATE_USAGE_ROW;

Line: 319

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

Line: 337

      select AME_RULE_KEYS_S.NEXTVAL into X_RULE_KEY_ID from dual;

Line: 339

      select count(*)
        into X_RULE_COUNT
        from AME_RULES
       where upper(RULE_KEY) = upper(X_NEW_RULE_KEY)
         and rownum < 2;

Line: 365

          X_LAST_UPDATE_DATE in VARCHAR2
)
is
  X_ACTION_TYPE_ID NUMBER;

Line: 377

  X_LAST_UPDATED_BY NUMBER;

Line: 378

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 404

    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 422

       INSERT_ROW (
         X_RULE_ID,
         X_RULE_KEY,
         X_RULE_TYPE,
         X_ACTION_ID2,
         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'),
         X_DESCRIPTION,
         X_ITEM_CLASS_ID,
         1);

Line: 440

          INSERT_USAGE_ROW (
            X_RULE_ID,
            X_ACTION_ID,
            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: 451

          if DO_USAGE_UPDATE_INSERT
            (AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
             X_CURRENT_USAGE_OWNER,
             X_LAST_UPDATE_DATE,
             X_CURRENT_USAGE_LUD) then
             UPDATE_USAGE_ROW (
               X_USAGE_ROWID,
               to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS')-(1/86400));

Line: 459

             INSERT_USAGE_ROW (
               X_RULE_ID,
               X_ACTION_ID,
               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'),
               X_CURRENT_USAGE_OVN + 1);