APPS.AME_MAN_ATTRIBUTES_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: 23

  X_CURRENT_LAST_UPDATE_DATE out nocopy VARCHAR2,
  X_CURRENT_OVN out nocopy NUMBER
) is
  cursor CSR_GET_ATTRIBUTE_ID
  (
    X_ATTRIBUTE_NAME in VARCHAR2
  ) is
    select ATTRIBUTE_ID
      from AME_ATTRIBUTES
     where NAME = X_ATTRIBUTE_NAME
      and sysdate between START_DATE
       and nvl(END_DATE  - (1/86400), sysdate);

Line: 40

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

Line: 51

  is select ROWID,
            LAST_UPDATED_BY,
            to_char(LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
            nvl(OBJECT_VERSION_NUMBER,1)
       from AME_MANDATORY_ATTRIBUTES
    where ATTRIBUTE_ID   = X_ATTRIBUTE_ID
      and ACTION_TYPE_ID = X_ACTION_TYPE_ID
      and sysdate between START_DATE
       and nvl(END_DATE  - (1/86400), sysdate);

Line: 88

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

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_MANDATORY_ATTRIBUTES
     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: 135

end FORCE_UPDATE_ROW;

Line: 137

procedure INSERT_ROW (
 X_ATTRIBUTE_ID                    in NUMBER,
 X_ACTION_TYPE_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: 157

    insert into AME_MANDATORY_ATTRIBUTES
    (
     ATTRIBUTE_ID,
     ACTION_TYPE_ID,
     CREATED_BY,
     CREATION_DATE,
     LAST_UPDATED_BY,
     LAST_UPDATE_DATE,
     LAST_UPDATE_LOGIN,
     START_DATE,
     END_DATE,
     OBJECT_VERSION_NUMBER
    ) values (
     X_ATTRIBUTE_ID,
     X_ACTION_TYPE_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);

Line: 181

end INSERT_ROW;

Line: 183

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

Line: 191

end UPDATE_ROW;

Line: 193

procedure DELETE_ROW (
  X_ATTRIBUTE_ID   in NUMBER,
  X_ACTION_TYPE_ID in NUMBER
) is
begin
  delete from AME_MANDATORY_ATTRIBUTES
  where ATTRIBUTE_ID   = X_ATTRIBUTE_ID
    and ACTION_TYPE_ID = X_ACTION_TYPE_ID;

Line: 205

end DELETE_ROW;

Line: 211

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

Line: 219

  X_CURRENT_LAST_UPDATE_DATE VARCHAR2(19);

Line: 221

  X_LAST_UPDATED_BY NUMBER;

Line: 222

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 293

  X_CURRENT_LAST_UPDATE_DATE,
  X_CURRENT_OVN
);

Line: 300

  X_LAST_UPDATED_BY,
  X_LAST_UPDATE_LOGIN
);

Line: 307

    INSERT_ROW (
      X_ATTRIBUTE_ID,
      X_ACTION_TYPE_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: 321

       FORCE_UPDATE_ROW (
         X_MAN_ATTRIBUTE_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);

Line: 332

       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_MAN_ATTRIBUTE_ROWID,
           to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS')-(1/86400));

Line: 340

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

Line: 370

  X_LAST_UPDATE_DATE                in VARCHAR2,
  X_UPLOAD_MODE                     in VARCHAR2,
  X_CUSTOM_MODE                     in VARCHAR2) as
begin
  if X_UPLOAD_MODE = 'NLS' then
    null;

Line: 381

      ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE
      ,X_CUSTOM_MODE      => X_CUSTOM_MODE
      );