APPS.AME_ITEM_CLASS_USAGES_API SQL Statements

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

Line: 6

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

  X_LAST_UPDATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);

Line: 12

  X_LAST_UPDATE_LOGIN := 0;

Line: 22

  X_CURRENT_LAST_UPDATE_DATE out nocopy VARCHAR2,
  X_CURRENT_OVN  out nocopy VARCHAR2
) is
  cursor CSR_GET_ITEM_CLASS_ID
  (
    X_ITEM_CLASS_NAME in VARCHAR2
  ) is
   select ITEM_CLASS_ID
   from   AME_ITEM_CLASSES
   where  NAME = X_ITEM_CLASS_NAME
	    and sysdate between START_DATE
			 and nvl(END_DATE  - (1/86400), sysdate);

Line: 39

   select APPLICATION_ID
   from   AME_CALLING_APPS
   where  APPLICATION_NAME = X_APPLICATION_NAME
	    and sysdate between START_DATE
			 and nvl(END_DATE  - (1/86400), sysdate);

Line: 50

   select ROWID,
          LAST_UPDATED_BY,
          to_char(LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
          nvl(OBJECT_VERSION_NUMBER,1)
     from AME_ITEM_CLASS_USAGES
    where ITEM_CLASS_ID  = X_ITEM_CLASS_ID
      and APPLICATION_ID = X_APPLICATION_ID
	    and sysdate between START_DATE
			 and nvl(END_DATE  - (1/86400), sysdate);

Line: 87

                                        X_CURRENT_LAST_UPDATE_DATE,
                                        X_CURRENT_OVN;

Line: 97

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

end DO_UPDATE_INSERT;

Line: 112

procedure INSERT_ROW (
 X_ITEM_CLASS_ID                   in NUMBER,
 X_APPLICATION_ID                  in NUMBER,
 X_ITEM_ID_QUERY                   in VARCHAR2,
 X_ITEM_CLASS_ORDER_NUMBER         in NUMBER,
 X_ITEM_CLASS_PAR_MODE             in VARCHAR2,
 X_ITEM_CLASS_SUBLIST_MODE         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
begin
  insert into AME_ITEM_CLASS_USAGES
  (ITEM_CLASS_ID,
   APPLICATION_ID,
   ITEM_ID_QUERY,
   ITEM_CLASS_ORDER_NUMBER,
   ITEM_CLASS_PAR_MODE,
   ITEM_CLASS_SUBLIST_MODE,
   CREATED_BY,
   CREATION_DATE,
   LAST_UPDATED_BY,
   LAST_UPDATE_DATE,
   LAST_UPDATE_LOGIN,
   START_DATE,
   END_DATE,
   OBJECT_VERSION_NUMBER
   ) values (
   X_ITEM_CLASS_ID,
   X_APPLICATION_ID,
   X_ITEM_ID_QUERY,
   X_ITEM_CLASS_ORDER_NUMBER,
   X_ITEM_CLASS_PAR_MODE,
   X_ITEM_CLASS_SUBLIST_MODE,
   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: 159

end INSERT_ROW;

Line: 161

procedure FORCE_UPDATE_ROW (
  X_ROWID                      in VARCHAR2,
  X_ITEM_ID_QUERY              in VARCHAR2,
  X_ITEM_CLASS_ORDER_NUMBER    in NUMBER,
  X_ITEM_CLASS_SUBLIST_MODE    in VARCHAR2,
  X_ITEM_CLASS_PAR_MODE        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_ITEM_CLASS_USAGES
     set ITEM_CLASS_ORDER_NUMBER = X_ITEM_CLASS_ORDER_NUMBER,
         ITEM_ID_QUERY = X_ITEM_ID_QUERY,
         ITEM_CLASS_SUBLIST_MODE = X_ITEM_CLASS_SUBLIST_MODE,
         ITEM_CLASS_PAR_MODE = X_ITEM_CLASS_PAR_MODE,
         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: 191

end FORCE_UPDATE_ROW;

Line: 193

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

Line: 201

end UPDATE_ROW;

Line: 203

procedure DELETE_ROW (
  X_ITEM_CLASS_ID in NUMBER,
  X_APPLICATION_ID in NUMBER
) is
begin
  delete from AME_ITEM_CLASS_USAGES
  where ITEM_CLASS_ID  = X_ITEM_CLASS_ID
    and APPLICATION_ID = X_APPLICATION_ID;

Line: 215

end DELETE_ROW;

Line: 225

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

Line: 232

  X_CURRENT_LAST_UPDATE_DATE VARCHAR2(19);

Line: 234

  X_LAST_UPDATED_BY NUMBER;

Line: 235

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 247

    X_CURRENT_LAST_UPDATE_DATE,
    X_CURRENT_OVN);

Line: 253

    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 262

       INSERT_ROW (
         X_ITEM_CLASS_ID,
         X_APPLICATION_ID,
         X_ITEM_ID_QUERY,
         X_ITEM_CLASS_ORDER_NUMBER,
         X_ITEM_CLASS_PAR_MODE,
         X_ITEM_CLASS_SUBLIST_MODE,
         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: 280

         FORCE_UPDATE_ROW
           (
           X_USAGES_ROWID,
           X_ITEM_ID_QUERY,
           X_ITEM_CLASS_ORDER_NUMBER,
           X_ITEM_CLASS_PAR_MODE,
           X_ITEM_CLASS_SUBLIST_MODE,
           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);

Line: 296

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

Line: 304

           INSERT_ROW (
             X_ITEM_CLASS_ID,
             X_APPLICATION_ID,
             X_ITEM_ID_QUERY,
             X_ITEM_CLASS_ORDER_NUMBER,
             X_ITEM_CLASS_PAR_MODE,
             X_ITEM_CLASS_SUBLIST_MODE,
             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);