APPS.AME_ACTION_TYPE_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: 21

  X_CURRENT_LAST_UPDATE_DATE out nocopy VARCHAR2,
  X_CURRENT_OVN out nocopy NUMBER
) is
  cursor CSR_GET_ACTION_TYPE_ID
  (
    X_ACTION_TYPE_NAME in VARCHAR2
  ) is
   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: 37

  ) 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_TYPE_USAGES
    where ACTION_TYPE_ID = X_ACTION_TYPE_ID
      and RULE_TYPE      = X_RULE_TYPE
      and sysdate between START_DATE
       and nvl(END_DATE  - (1/86400), sysdate);

Line: 65

                                          X_CURRENT_LAST_UPDATE_DATE,
                                          X_CURRENT_OVN;

Line: 73

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)
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: 87

end DO_UPDATE_INSERT;

Line: 126

procedure INSERT_ROW (
 X_ACTION_TYPE_ID                  in NUMBER,
 X_RULE_TYPE                       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
begin
  insert into AME_ACTION_TYPE_USAGES
  (
   ACTION_TYPE_ID,
   RULE_TYPE,
   CREATED_BY,
   CREATION_DATE,
   LAST_UPDATED_BY,
   LAST_UPDATE_DATE,
   LAST_UPDATE_LOGIN,
   START_DATE,
   END_DATE,
   OBJECT_VERSION_NUMBER
  ) values (
   X_ACTION_TYPE_ID,
   X_RULE_TYPE,
   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);

Line: 162

end INSERT_ROW;

Line: 164

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

Line: 172

end UPDATE_ROW;

Line: 174

procedure DELETE_ROW (
  X_ACTION_TYPE_ID in NUMBER,
  X_RULE_TYPE      in NUMBER
) is
begin
  delete from AME_ACTION_TYPE_USAGES
  where ACTION_TYPE_ID =   X_ACTION_TYPE_ID
    and RULE_TYPE      =   X_RULE_TYPE;

Line: 186

end DELETE_ROW;

Line: 192

          X_LAST_UPDATE_DATE in VARCHAR2,
          X_CUSTOM_MODE      in VARCHAR2
)
is
  X_ACTION_USAGE_ROWID ROWID;

Line: 199

  X_CURRENT_LAST_UPDATE_DATE VARCHAR2(19);

Line: 201

  X_LAST_UPDATED_BY NUMBER;

Line: 202

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 214

    X_CURRENT_LAST_UPDATE_DATE,
    X_CURRENT_OVN
  );

Line: 224

    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 231

       INSERT_ROW (
         X_ACTION_TYPE_ID,
         X_RULE_TYPE,
         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: 244

       if DO_UPDATE_INSERT
          (AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
           X_CURRENT_OWNER,
           X_LAST_UPDATE_DATE,
           X_CURRENT_LAST_UPDATE_DATE,
           X_CUSTOM_MODE) then
         UPDATE_ROW (
           X_ACTION_USAGE_ROWID,
           to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS')-(1/86400));

Line: 253

         INSERT_ROW (
           X_ACTION_TYPE_ID,
           X_RULE_TYPE,
           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_OVN + 1);