APPS.AME_ACTION_USAGES_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: 26

  X_CURRENT_LAST_UPDATE_DATE out nocopy VARCHAR2,
  X_CURRENT_OVN              out nocopy NUMBER,
  X_RULE_ROWID               out nocopy VARCHAR2
) is
  cursor CSR_GET_RULE_ID
 (
   X_RULE_KEY      in VARCHAR2
 ) is
  select RULE_ID
    from AME_RULES
   where RULE_KEY = X_RULE_KEY;

Line: 41

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

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

  ) is 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: 74

   select APPROVAL_GROUP_ID
   from   AME_APPROVAL_GROUPS
   where  NAME = X_APPROVAL_GROUP_NAME
   and    sysdate between START_DATE
                  and nvl(end_date - (1/86400), sysdate);

Line: 83

  ) is select ROWID
         from AME_RULES
        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: 145

                      X_CURRENT_OWNER, X_CURRENT_LAST_UPDATE_DATE, X_CURRENT_OVN;

Line: 164

  select RULE_TYPE
    from AME_RULES
   where RULE_KEY = X_RULE_KEY
     and sysdate between START_DATE
           and nvl(END_DATE  - (1/86400), sysdate);

Line: 205

function DO_UPDATE_INSERT(X_OWNER in NUMBER,
                   X_CURRENT_OWNER in NUMBER,
                   X_LAST_UPDATE_DATE in VARCHAR2,
                   X_CURRENT_LAST_UPDATE_DATE in VARCHAR2,
                   X_CUSTOM_MODE in VARCHAR2 default null)
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               => X_CUSTOM_MODE
    );

Line: 219

end DO_UPDATE_INSERT;

Line: 225

   select ACA.APPLICATION_ID
   from   AME_CALLING_APPS ACA,
          AME_RULE_USAGES ARU
   where  ACA.APPLICATION_ID = ARU.ITEM_ID
     and  ARU.RULE_ID = X_RULE_ID
     and  sysdate between ARU.START_DATE
       and nvl(ARU.END_DATE - (1/86400), sysdate);

Line: 239

procedure INSERT_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: 258

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

end INSERT_ROW;

Line: 292

procedure UPDATE_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: 300

end UPDATE_ROW;

Line: 301

procedure DELETE_ROW (
  X_RULE_ID          in NUMBER,
  X_ACTION_ID        in NUMBER
) is
begin
  delete from AME_ACTION_USAGES
  where RULE_ID   = X_RULE_ID
    and ACTION_ID = X_ACTION_ID;

Line: 312

end DELETE_ROW;

Line: 313

procedure FORCE_UPDATE_ROW (
  X_ROWID                      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_END_DATE                   in DATE,
  X_OBJECT_VERSION_NUMBER      in NUMBER
) is
begin
  update AME_ACTION_USAGES
     set CREATED_BY = X_CREATED_BY,
         CREATION_DATE = X_CREATION_DATE,
         LAST_UPDATED_BY = X_LAST_UPDATED_BY,
         LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
         LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
         START_DATE = X_START_DATE,
         END_DATE = X_END_DATE,
         OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
   where ROWID = X_ROWID;

Line: 335

end FORCE_UPDATE_ROW;

Line: 341

          X_LAST_UPDATE_DATE in VARCHAR2,
          X_CUSTOM_MODE      in VARCHAR2
)
is
  X_ACTION_ID      NUMBER;

Line: 349

  X_CURRENT_LAST_UPDATE_DATE VARCHAR2(19);

Line: 351

  X_LAST_UPDATED_BY NUMBER;

Line: 352

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 375

  X_CURRENT_LAST_UPDATE_DATE,
  X_CURRENT_OVN,
  X_RULE_ROWID
  );

Line: 383

    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 392

     INSERT_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: 414

        FORCE_UPDATE_ROW (
          X_ACTION_USAGE_ROWID,
          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'),
          AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
          X_CURRENT_OVN + 1);