APPS.AME_APPROVAL_GROUPS_LOAD_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: 15

procedure INSERT_ROW (X_NAME                    in     VARCHAR2
                     ,X_QUERY_STRING            in     VARCHAR2
                     ,X_IS_STATIC               in     VARCHAR2
                     ,X_DESCRIPTION             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
                     ,X_APPROVAL_GROUP_ID       in out nocopy NUMBER
                     )
  is
  begin
    if (X_APPROVAL_GROUP_ID is null) then
      select ame_approval_groups_s.nextval
        into X_APPROVAL_GROUP_ID
        from sys.dual;

Line: 35

    insert into AME_APPROVAL_GROUPS
      (APPROVAL_GROUP_ID
      ,NAME
      ,QUERY_STRING
      ,IS_STATIC
      ,CREATED_BY
      ,CREATION_DATE
      ,LAST_UPDATED_BY
      ,LAST_UPDATE_DATE
      ,LAST_UPDATE_LOGIN
      ,START_DATE
      ,END_DATE
      ,DESCRIPTION
      ,OBJECT_VERSION_NUMBER
      ) select
       X_APPROVAL_GROUP_ID
      ,X_NAME
      ,X_QUERY_STRING
      ,X_IS_STATIC
      ,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_OBJECT_VERSION_NUMBER
      from  sys.dual
      where not exists (select NULL
                          from AME_APPROVAL_GROUPS
                         where NAME = X_NAME
                           and sysdate between START_DATE
                                 and nvl(END_DATE - (1/86400), sysdate));

Line: 69

  end INSERT_ROW;

Line: 71

procedure INSERT_TL_ROW (
  X_APPROVAL_GROUP_ID in NUMBER,
  X_USER_APPROVAL_GROUP_NAME in VARCHAR2,
  X_DESCRIPTION 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) is
 begin
    if not AME_SEED_UTILITY.MLS_ENABLED then
      return;

Line: 85

  insert into AME_APPROVAL_GROUPS_TL
    (APPROVAL_GROUP_ID
    ,USER_APPROVAL_GROUP_NAME
    ,DESCRIPTION
    ,CREATED_BY
    ,CREATION_DATE
    ,LAST_UPDATED_BY
    ,LAST_UPDATE_DATE
    ,LAST_UPDATE_LOGIN
    ,LANGUAGE
    ,SOURCE_LANG
    ) select X_APPROVAL_GROUP_ID,
             X_USER_APPROVAL_GROUP_NAME,
             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_APPROVAL_GROUPS_TL T
                          where T.APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID
                            and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 112

END INSERT_TL_ROW;

Line: 118

                     ,X_CURRENT_LAST_UPDATE_DATE out nocopy VARCHAR2
                     ,X_CURRENT_OVN              out nocopy NUMBER
                     ,X_MAX_START_DATE           out nocopy DATE
                     ) is
  cursor CSR_GET_MAX_START
  (
    X_APPROVAL_GROUP_NAME in VARCHAR2
  ) is
    select max(START_DATE)
      from AME_APPROVAL_GROUPS
     where NAME = X_APPROVAL_GROUP_NAME;

Line: 134

    select ROWID, APPROVAL_GROUP_ID,
           LAST_UPDATED_BY,
           to_char(LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
           nvl(OBJECT_VERSION_NUMBER,1)
      from AME_APPROVAL_GROUPS
     where NAME = X_APPROVAL_GROUP_NAME
       and sysdate between START_DATE
       and nvl(END_DATE  - (1/86400), sysdate)
    for update of END_DATE;

Line: 154

                                X_CURRENT_OWNER, X_CURRENT_LAST_UPDATE_DATE, X_CURRENT_OVN;

Line: 161

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

end DO_UPDATE_INSERT;

Line: 177

function DO_TL_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_CREATED_BY in VARCHAR2,
                   X_CUSTOM_MODE in VARCHAR2 default null)
return boolean as
begin
  if X_CUSTOM_MODE = 'FORCE' then
    return true;

Line: 194

      ,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: 200

end DO_TL_UPDATE_INSERT;

Line: 202

procedure UPDATE_ROW (X_APPROVAL_GROUP_ROWID in VARCHAR2
                     ,X_END_DATE             in DATE
                     ,X_APPROVAL_GROUP_ID    in NUMBER
                     ,X_NAME                 in VARCHAR2
                     ,X_QUERY_STRING         in VARCHAR2
                     ,X_IS_STATIC            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_DESCRIPTION          in VARCHAR2
                     ,X_OBJECT_VERSION_NUMBER in NUMBER
                     )
is
  L_APPROVAL_GROUP_ID number;

Line: 221

    update AME_APPROVAL_GROUPS
       set END_DATE = X_END_DATE
     where ROWID = X_APPROVAL_GROUP_ROWID;

Line: 224

    INSERT_ROW (X_NAME                 => X_NAME
               ,X_QUERY_STRING         => X_QUERY_STRING
               ,X_IS_STATIC            => X_IS_STATIC
               ,X_DESCRIPTION          => X_DESCRIPTION
               ,X_CREATED_BY           => X_CREATED_BY
               ,X_CREATION_DATE        => X_CREATION_DATE
               ,X_LAST_UPDATED_BY      => X_LAST_UPDATED_BY
               ,X_LAST_UPDATE_DATE     => X_LAST_UPDATE_DATE
               ,X_LAST_UPDATE_LOGIN    => X_LAST_UPDATE_LOGIN
               ,X_START_DATE           => X_START_DATE
               ,X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER
               ,X_APPROVAL_GROUP_ID    => L_APPROVAL_GROUP_ID
               );

Line: 237

  end UPDATE_ROW;

Line: 239

procedure FORCE_UPDATE_ROW (
  X_ROWID                      in VARCHAR2,
  X_NAME                       in VARCHAR2,
  X_QUERY_STRING               in VARCHAR2,
  X_IS_STATIC                  in VARCHAR2,
  X_DESCRIPTION                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_APPROVAL_GROUPS
     set NAME = X_NAME,
         QUERY_STRING = X_QUERY_STRING,
         IS_STATIC = X_IS_STATIC,
         DESCRIPTION = X_DESCRIPTION,
         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: 269

end FORCE_UPDATE_ROW;

Line: 276

    delete from AME_APPROVAL_GROUP_MEMBERS
          where APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID;

Line: 278

    insert into AME_APPROVAL_GROUP_MEMBERS
      (APPROVAL_GROUP_ID
      ,PARAMETER_NAME
      ,PARAMETER
      ,QUERY_STRING
      ,ORDER_NUMBER
      ) select
       X_APPROVAL_GROUP_ID
      ,ame_util.approverOamGroupId
      ,X_APPROVAL_GROUP_ID
      ,X_QUERY_STRING
      ,1
      from sys.dual;

Line: 291

    update AME_APPROVAL_GROUP_MEMBERS
       set QUERY_STRING = X_QUERY_STRING
     where PARAMETER_NAME = ame_util.approverOamGroupId
       and PARAMETER = to_char(X_APPROVAL_GROUP_ID)
       and APPROVAL_GROUP_ID <> X_APPROVAL_GROUP_ID;

Line: 301

                                ,X_LAST_UPDATED_BY         in     NUMBER
                                ,X_LAST_UPDATE_DATE        in     DATE
                                ,X_LAST_UPDATE_LOGIN       in     NUMBER
                                ,X_START_DATE              in     DATE
                                )
is
  cursor get_active_application is
         select APPLICATION_ID
           from AME_CALLING_APPS
          where sysdate between start_date
            and nvl(end_date - ame_util.oneSecond,sysdate);

Line: 329

        select nvl(max(order_number),0)+1
          into L_ORDER_NUMBER
          from AME_APPROVAL_GROUP_CONFIG
         where application_id = APPLICATION_ID_LIST(indx)
           and sysdate between start_date
           and nvl(end_date - ame_util.oneSecond,sysdate);

Line: 338

        insert into AME_APPROVAL_GROUP_CONFIG(
           APPLICATION_ID
          ,APPROVAL_GROUP_ID
          ,VOTING_REGIME
          ,ORDER_NUMBER
          ,CREATED_BY
          ,CREATION_DATE
          ,LAST_UPDATED_BY
          ,LAST_UPDATE_DATE
          ,LAST_UPDATE_LOGIN
          ,START_DATE
          ,END_DATE
          ,OBJECT_VERSION_NUMBER
          ) select
           APPLICATION_ID_LIST(indx)
          ,X_APPROVAL_GROUP_ID
          ,ame_util.serializedVoting
          ,L_ORDER_NUMBER
          ,X_CREATED_BY
          ,X_CREATION_DATE
          ,X_LAST_UPDATED_BY
          ,X_LAST_UPDATE_DATE
          ,X_LAST_UPDATE_LOGIN
          ,X_START_DATE
          ,null
          ,1
          from sys.dual;

Line: 369

procedure UPDATE_TL_ROW (
  X_APPROVAL_GROUP_ID in NUMBER,
  X_USER_APPROVAL_GROUP_NAME in VARCHAR2,
  X_DESCRIPTION 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_CUSTOM_MODE in VARCHAR2) is
  X_CURRENT_OWNER  NUMBER;

Line: 380

  X_CURRENT_LAST_UPDATE_DATE DATE;

Line: 386

    select LAST_UPDATED_BY,
           LAST_UPDATE_DATE
       into X_CURRENT_OWNER,
            X_CURRENT_LAST_UPDATE_DATE
       FROM AME_APPROVAL_GROUPS_TL
       WHERE APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID
       AND LANGUAGE = USERENV('LANG');

Line: 394

   if DO_UPDATE_INSERT
     (X_LAST_UPDATED_BY
     ,X_CURRENT_OWNER
     ,AME_SEED_UTILITY.DATE_AS_STRING(X_LAST_UPDATE_DATE)
     ,AME_SEED_UTILITY.DATE_AS_STRING(X_CURRENT_LAST_UPDATE_DATE)
     ,X_CUSTOM_MODE) then
      update AME_APPROVAL_GROUPS_TL
         set USER_APPROVAL_GROUP_NAME = nvl(X_USER_APPROVAL_GROUP_NAME,USER_APPROVAL_GROUP_NAME),
             DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
             SOURCE_LANG = userenv('LANG'),
             LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
             LAST_UPDATED_BY = X_LAST_UPDATED_BY,
             LAST_UPDATE_LOGIN = 0
       where APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID
         and userenv('LANG') in (LANGUAGE,SOURCE_LANG);

Line: 413

end UPDATE_TL_ROW;

Line: 421

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

Line: 428

  X_CURRENT_LAST_UPDATE_DATE  VARCHAR2(19);

Line: 432

  X_LAST_UPDATED_BY           NUMBER;

Line: 433

  X_LAST_UPDATE_LOGIN         NUMBER;

Line: 452

       ,X_CURRENT_LAST_UPDATE_DATE
       ,X_CURRENT_OVN
       ,X_MAX_START_DATE
       );

Line: 459

        ,X_LAST_UPDATED_BY
        ,X_LAST_UPDATE_LOGIN
        );

Line: 465

          INSERT_ROW (
             X_APPROVAL_GROUP_NAME
            ,X_QUERY_STRING
            ,X_IS_STATIC
            ,X_DESCRIPTION
            ,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
            ,X_APPROVAL_GROUP_ID
            );

Line: 479

          INSERT_TL_ROW
            (X_APPROVAL_GROUP_ID
            ,nvl(X_USER_APPROVAL_GROUP_NAME,X_APPROVAL_GROUP_NAME)
            ,X_DESCRIPTION
            ,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
            );

Line: 495

          ,X_CREATION_DATE     => to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS')
          ,X_LAST_UPDATED_BY   => X_LAST_UPDATED_BY
          ,X_LAST_UPDATE_DATE  => to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS')
          ,X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
          ,X_START_DATE        => to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS')
          );

Line: 505

            FORCE_UPDATE_ROW (
               X_APPROVAL_GROUP_ROWID
              ,X_APPROVAL_GROUP_NAME
              ,X_QUERY_STRING
              ,X_IS_STATIC
              ,X_DESCRIPTION
              ,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: 520

            UPDATE_TL_ROW
              (X_APPROVAL_GROUP_ID
              ,nvl(X_USER_APPROVAL_GROUP_NAME,X_APPROVAL_GROUP_NAME)
              ,X_DESCRIPTION
              ,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
              ,X_CUSTOM_MODE
              );

Line: 532

            if DO_UPDATE_INSERT
                (AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER)
                ,X_CURRENT_OWNER
                ,X_LAST_UPDATE_DATE
                ,X_CURRENT_LAST_UPDATE_DATE
                )
              and (X_MAX_START_DATE is not null)
              and (to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS') > X_MAX_START_DATE)
              then
                UPDATE_ROW (
                   X_APPROVAL_GROUP_ROWID
                  ,to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS')-(1/86400)
                  ,X_APPROVAL_GROUP_ID
                  ,X_APPROVAL_GROUP_NAME
                  ,X_QUERY_STRING
                  ,X_IS_STATIC
                  ,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_CURRENT_OVN + 1
                  );

Line: 557

              UPDATE_TL_ROW
                (X_APPROVAL_GROUP_ID
                ,nvl(X_USER_APPROVAL_GROUP_NAME,X_APPROVAL_GROUP_NAME)
                ,X_DESCRIPTION
                ,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
                ,X_CUSTOM_MODE
                );

Line: 585

procedure DELETE_ROW (X_APPROVAL_GROUP_ID in NUMBER
                     ) is
  begin
    if AME_SEED_UTILITY.MLS_ENABLED then
      delete from AME_APPROVAL_GROUPS_TL
       where APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID;

Line: 592

    delete from AME_APPROVAL_GROUPS
    where APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID;

Line: 597

  end DELETE_ROW;

Line: 604

    ,X_LAST_UPDATE_DATE       in varchar2
    ,X_CUSTOM_MODE            in varchar2
    ) as
    X_CURRENT_OWNER            number;

Line: 608

    X_CURRENT_LAST_UPDATE_DATE varchar2(20);

Line: 616

      select AAGTL.LAST_UPDATED_BY,
             AME_SEED_UTILITY.DATE_AS_STRING(AAGTL.LAST_UPDATE_DATE),
             AME_SEED_UTILITY.OWNER_AS_STRING(AAGTL.CREATED_BY),
             AAG.APPROVAL_GROUP_ID
        into X_CURRENT_OWNER,
             X_CURRENT_LAST_UPDATE_DATE,
             X_CREATED_BY,
             X_APPROVAL_GROUP_ID
        from AME_APPROVAL_GROUPS_TL AAGTL,
             AME_APPROVAL_GROUPS AAG
       where AAG.NAME = X_APPROVAL_GROUP_NAME
         and sysdate between AAG.START_DATE and nvl(AAG.END_DATE - (1/86400),sysdate)
         and AAGTL.APPROVAL_GROUP_ID = AAG.APPROVAL_GROUP_ID
         and AAGTL.LANGUAGE = userenv('LANG');

Line: 630

      if DO_TL_UPDATE_INSERT
          (X_OWNER                     => AME_SEED_UTILITY.OWNER_AS_INTEGER(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_CREATED_BY                => X_CREATED_BY,
           X_CUSTOM_MODE               => X_CUSTOM_MODE) then
        update AME_APPROVAL_GROUPS_TL AAGTL
           set USER_APPROVAL_GROUP_NAME = nvl(X_USER_APPROVAL_GROUP_NAME,USER_APPROVAL_GROUP_NAME),
               DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
               SOURCE_LANG = userenv('LANG'),
               LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),
               LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
               LAST_UPDATE_LOGIN = 0
         where AAGTL.APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID
           and userenv('LANG') in (AAGTL.LANGUAGE,AAGTL.SOURCE_LANG);