APPS.FND_DOC_CATEGORIES_PKG SQL Statements

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

Line: 5

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_CATEGORY_ID in NUMBER,
  X_APPLICATION_ID in NUMBER,
  X_NAME in VARCHAR2,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_DEFAULT_DATATYPE_ID in NUMBER,
  X_USER_NAME in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER) is
  cursor C is select ROWID from FND_DOCUMENT_CATEGORIES
    where CATEGORY_ID = X_CATEGORY_ID;

Line: 39

  insert into FND_DOCUMENT_CATEGORIES (
    CATEGORY_ID,
    APPLICATION_ID,
    NAME,
    START_DATE_ACTIVE,
    END_DATE_ACTIVE,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    DEFAULT_DATATYPE_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_CATEGORY_ID,
    X_APPLICATION_ID,
    X_NAME,
    X_START_DATE_ACTIVE,
    X_END_DATE_ACTIVE,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_DEFAULT_DATATYPE_ID,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN );

Line: 104

  insert into FND_DOCUMENT_CATEGORIES_TL (
    CATEGORY_ID,
    LANGUAGE,
    NAME,
    USER_NAME,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    SOURCE_LANG,
    app_source_version
  ) select
    X_CATEGORY_ID,
    L.LANGUAGE_CODE,
    X_NAME,
    X_USER_NAME,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    userenv('LANG'),
    '<<' || USER || '>>'
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from FND_DOCUMENT_CATEGORIES_TL T
    where T.CATEGORY_ID = X_CATEGORY_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 135

end INSERT_ROW;

Line: 161

  cursor c is select
      APPLICATION_ID,
      NAME,
      START_DATE_ACTIVE,
      END_DATE_ACTIVE,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      DEFAULT_DATATYPE_ID
    from FND_DOCUMENT_CATEGORIES
    where CATEGORY_ID = X_CATEGORY_ID
    for update of CATEGORY_ID nowait;

Line: 188

  cursor c1 is select
      USER_NAME
    from FND_DOCUMENT_CATEGORIES_TL
    where CATEGORY_ID = X_CATEGORY_ID
    and LANGUAGE = userenv('LANG')
    for update of CATEGORY_ID nowait;

Line: 201

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 289

procedure UPDATE_ROW (
  X_CATEGORY_ID in NUMBER,
  X_APPLICATION_ID in NUMBER,
  X_NAME in VARCHAR2,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_DEFAULT_DATATYPE_ID in NUMBER,
  X_USER_NAME in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER) is
begin
    update FND_DOCUMENT_CATEGORIES set
      CATEGORY_ID = X_CATEGORY_ID,
      APPLICATION_ID = X_APPLICATION_ID,
      NAME = X_NAME,
      START_DATE_ACTIVE = X_START_DATE_ACTIVE,
      END_DATE_ACTIVE = X_END_DATE_ACTIVE,
      ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
      ATTRIBUTE1 = X_ATTRIBUTE1,
      ATTRIBUTE2 = X_ATTRIBUTE2,
      ATTRIBUTE3 = X_ATTRIBUTE3,
      ATTRIBUTE4 = X_ATTRIBUTE4,
      ATTRIBUTE5 = X_ATTRIBUTE5,
      ATTRIBUTE6 = X_ATTRIBUTE6,
      ATTRIBUTE7 = X_ATTRIBUTE7,
      ATTRIBUTE8 = X_ATTRIBUTE8,
      ATTRIBUTE9 = X_ATTRIBUTE9,
      ATTRIBUTE10 = X_ATTRIBUTE10,
      ATTRIBUTE11 = X_ATTRIBUTE11,
      ATTRIBUTE12 = X_ATTRIBUTE12,
      ATTRIBUTE13 = X_ATTRIBUTE13,
      ATTRIBUTE14 = X_ATTRIBUTE14,
      ATTRIBUTE15 = X_ATTRIBUTE15,
      DEFAULT_DATATYPE_ID = X_DEFAULT_DATATYPE_ID,
      LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
      LAST_UPDATED_BY = X_LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
    where CATEGORY_ID = X_CATEGORY_ID;

Line: 348

  update FND_DOCUMENT_CATEGORIES_TL set
    NAME = X_NAME,
    USER_NAME = X_USER_NAME,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    APP_SOURCE_VERSION = '<<' || USER || '>>',
    SOURCE_LANG = userenv('LANG')
  where CATEGORY_ID = X_CATEGORY_ID
  and userenv('LANG') in (LANGUAGE,SOURCE_LANG);

Line: 361

end UPDATE_ROW;

Line: 363

procedure DELETE_ROW (X_CATEGORY_ID in NUMBER) is
begin
 -- need to mark fnd_document_categories.app_source_version with the
 -- USER the delete is being sourced from so that trigger logic can call
 -- the delete stored procedure in the appropriate schema
 -- (R10/10SC compatibility logic) WIP logic operates off tl table
 --UPDATE fnd_document_categories_tl
 -- SET app_source_Version = 'DEL_10SC<<' || USER || '>>'
 --WHERE category_id = X_category_id;

Line: 374

  delete from FND_DOCUMENT_CATEGORIES
  where CATEGORY_ID = X_CATEGORY_ID;

Line: 381

  delete from FND_DOCUMENT_CATEGORIES_TL
  where CATEGORY_ID = X_CATEGORY_ID;

Line: 387

  DELETE FROM fnd_doc_category_usages
  WHERE category_id = x_category_id;

Line: 390

end DELETE_ROW;

Line: 397

/* The following delete and update statements are commented out */
/* as a quick workaround to fix the time-consuming table handler issue */
/* Eventually we'll need to turn them into a separate fix_language procedure */
/*

  delete from FND_DOCUMENT_CATEGORIES_TL T
  where not exists
    (select NULL
    from FND_DOCUMENT_CATEGORIES B
    where B.CATEGORY_ID = T.CATEGORY_ID
    );

Line: 409

  update FND_DOCUMENT_CATEGORIES_TL T set (
      USER_NAME
    ) = (select
      B.USER_NAME
    from FND_DOCUMENT_CATEGORIES_TL B
    where B.CATEGORY_ID = T.CATEGORY_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.CATEGORY_ID,
      T.LANGUAGE
  ) in (select
      SUBT.CATEGORY_ID,
      SUBT.LANGUAGE
    from FND_DOCUMENT_CATEGORIES_TL SUBB, FND_DOCUMENT_CATEGORIES_TL SUBT
    where SUBB.CATEGORY_ID = SUBT.CATEGORY_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.USER_NAME <> SUBT.USER_NAME
  ));

Line: 429

  insert into FND_DOCUMENT_CATEGORIES_TL (
    CATEGORY_ID,
    LANGUAGE,
    NAME,
    USER_NAME,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    SOURCE_LANG
  ) select
    M.CATEGORY_ID,
    L.LANGUAGE_CODE,
    M.NAME,
    M.USER_NAME,
    M.CREATION_DATE,
    M.CREATED_BY,
    M.LAST_UPDATE_DATE,
    M.LAST_UPDATED_BY,
    M.LAST_UPDATE_LOGIN,
    M.SOURCE_LANG
  from FND_DOCUMENT_CATEGORIES_TL M, FND_LANGUAGES B, FND_LANGUAGES L
  where B.INSTALLED_FLAG = 'B'
  and L.INSTALLED_FLAG in ('I', 'B')
  and M.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from FND_DOCUMENT_CATEGORIES_TL T
    where T.CATEGORY_ID = M.CATEGORY_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 468

   update fnd_document_categories_tl set
     user_name	= nvl(X_USER_NAME,user_name),
     last_update_date  = sysdate,
     last_updated_by   = decode(X_OWNER, 'SEED', 1, 0),
     last_update_login = 0,
     source_lang       = userenv('LANG')
   where name = X_CATEGORY_NAME
    and userenv('LANG') in (language, source_lang);

Line: 485

        X_LAST_UPDATE_DATE in   VARCHAR2,
        X_CUSTOM_MODE   in      VARCHAR2) IS

   f_luby    number;  -- entity owner in file

Line: 489

   f_ludate  date;    -- entity update date in file

Line: 491

   db_ludate date;    -- entity update date in db

Line: 498

   f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 500

   select LAST_UPDATED_BY, LAST_UPDATE_DATE
   into db_luby, db_ludate
   from fnd_document_categories_tl
   where name = X_CATEGORY_NAME
   and LANGUAGE = userenv('LANG');

Line: 508

     update fnd_document_categories_tl set
       user_name	= nvl(X_USER_NAME,user_name),
       last_update_date  = f_ludate,
       last_updated_by   = f_luby,
       last_update_login = 0,
       source_lang       = userenv('LANG')
     where name = X_CATEGORY_NAME
     and userenv('LANG') in (language, source_lang);

Line: 558

    	select application_id
        into   l_application_id
        from   fnd_application
       where   application_short_name = X_APP_SHORT_NAME;

Line: 568

      select category_id, application_id
        into l_category_id, l_application_id
        from fnd_document_categories
      where  name = X_CATEGORY_NAME ;

Line: 573

      UPDATE_ROW (
 	   X_CATEGORY_ID 		=> l_category_id,
 	   X_APPLICATION_ID 	=> l_application_id,
 	   X_NAME		=> X_CATEGORY_NAME,
 	   X_START_DATE_ACTIVE 	=> to_date(X_START_DATE_ACTIVE, 'YYYY/MM/DD'),
 	   X_END_DATE_ACTIVE 	=> to_date(X_END_DATE_ACTIVE, 'YYYY/MM/DD'),
 	   X_ATTRIBUTE_CATEGORY	=> X_ATTRIBUTE_CATEGORY,
 	   X_ATTRIBUTE1 	=> X_ATTRIBUTE1,
 	   X_ATTRIBUTE2 	=> X_ATTRIBUTE2,
 	   X_ATTRIBUTE3		=> X_ATTRIBUTE3,
 	   X_ATTRIBUTE4		=> X_ATTRIBUTE4,
 	   X_ATTRIBUTE5		=> X_ATTRIBUTE5,
 	   X_ATTRIBUTE6		=> X_ATTRIBUTE6,
 	   X_ATTRIBUTE7		=> X_ATTRIBUTE7,
 	   X_ATTRIBUTE8		=> X_ATTRIBUTE8,
 	   X_ATTRIBUTE9		=> X_ATTRIBUTE9,
 	   X_ATTRIBUTE10	=> X_ATTRIBUTE10,
 	   X_ATTRIBUTE11	=> X_ATTRIBUTE11,
 	   X_ATTRIBUTE12	=> X_ATTRIBUTE12,
 	   X_ATTRIBUTE13	=> X_ATTRIBUTE13,
 	   X_ATTRIBUTE14	=> X_ATTRIBUTE14,
 	   X_ATTRIBUTE15	=> X_ATTRIBUTE15,
 	   X_DEFAULT_DATATYPE_ID	=> to_number(X_DEFAULT_DATATYPE_ID),
  	   X_USER_NAME 		=> X_USER_NAME,
 	   X_LAST_UPDATE_DATE	=> sysdate,
 	   X_LAST_UPDATED_BY	=> l_user_id,
 	   X_LAST_UPDATE_LOGIN 	=> 0 );

Line: 605

      select fnd_document_categories_s.nextval
      into l_category_id
      from dual;

Line: 609

      INSERT_ROW (
 	  X_ROWID 		=> l_row_id,
 	  X_CATEGORY_ID 	=> l_category_id,
 	  X_APPLICATION_ID	=> l_application_id,
 	  X_NAME 		=> X_CATEGORY_NAME,
 	  X_START_DATE_ACTIVE	=> to_date(X_START_DATE_ACTIVE, 'YYYY/MM/DD'),
 	  X_END_DATE_ACTIVE	=> to_date(X_END_DATE_ACTIVE, 'YYYY/MM/DD'),
 	  X_ATTRIBUTE_CATEGORY	=> X_ATTRIBUTE_CATEGORY,
 	  X_ATTRIBUTE1		=> X_ATTRIBUTE1,
	  X_ATTRIBUTE2		=> X_ATTRIBUTE2,
          X_ATTRIBUTE3		=> X_ATTRIBUTE3,
          X_ATTRIBUTE4		=> X_ATTRIBUTE4,
          X_ATTRIBUTE5		=> X_ATTRIBUTE5,
          X_ATTRIBUTE6		=> X_ATTRIBUTE6,
          X_ATTRIBUTE7		=> X_ATTRIBUTE7,
          X_ATTRIBUTE8		=> X_ATTRIBUTE8,
          X_ATTRIBUTE9		=> X_ATTRIBUTE9,
          X_ATTRIBUTE10	=> X_ATTRIBUTE10,
          X_ATTRIBUTE11	=> X_ATTRIBUTE11,
          X_ATTRIBUTE12	=> X_ATTRIBUTE12,
          X_ATTRIBUTE13	=> X_ATTRIBUTE13,
          X_ATTRIBUTE14	=> X_ATTRIBUTE14,
          X_ATTRIBUTE15	=> X_ATTRIBUTE15,
          X_DEFAULT_DATATYPE_ID   => to_number(X_DEFAULT_DATATYPE_ID),
          X_USER_NAME          => X_USER_NAME,
          X_CREATION_DATE 	=> sysdate,
 	   X_CREATED_BY		=> l_user_id,
          X_LAST_UPDATE_DATE   => sysdate,
          X_LAST_UPDATED_BY    => l_user_id,
          X_LAST_UPDATE_LOGIN  => 0 );

Line: 670

        X_LAST_UPDATE_DATE      in      VARCHAR2,
        X_CUSTOM_MODE           in      VARCHAR2 ) IS

   l_user_id 		number := 0 ;

Line: 678

   f_ludate  date;    -- entity update date in file

Line: 680

   db_ludate date;    -- entity update date in db

Line: 687

   f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 691

    	select application_id
        into   l_application_id
        from   fnd_application
       where   application_short_name = X_APP_SHORT_NAME;

Line: 701

      select category_id, application_id, LAST_UPDATED_BY, LAST_UPDATE_DATE
        into l_category_id, l_application_id, db_luby, db_ludate
        from fnd_document_categories
      where  name = X_CATEGORY_NAME ;

Line: 708

        UPDATE_ROW (
 	     X_CATEGORY_ID 		=> l_category_id,
 	     X_APPLICATION_ID 	=> l_application_id,
 	     X_NAME		=> X_CATEGORY_NAME,
 	     X_START_DATE_ACTIVE => to_date(X_START_DATE_ACTIVE, 'YYYY/MM/DD'),
 	     X_END_DATE_ACTIVE 	=> to_date(X_END_DATE_ACTIVE, 'YYYY/MM/DD'),
 	     X_ATTRIBUTE_CATEGORY	=> X_ATTRIBUTE_CATEGORY,
 	     X_ATTRIBUTE1 	=> X_ATTRIBUTE1,
 	     X_ATTRIBUTE2 	=> X_ATTRIBUTE2,
 	     X_ATTRIBUTE3		=> X_ATTRIBUTE3,
 	     X_ATTRIBUTE4		=> X_ATTRIBUTE4,
 	     X_ATTRIBUTE5		=> X_ATTRIBUTE5,
 	     X_ATTRIBUTE6		=> X_ATTRIBUTE6,
 	     X_ATTRIBUTE7		=> X_ATTRIBUTE7,
 	     X_ATTRIBUTE8		=> X_ATTRIBUTE8,
 	     X_ATTRIBUTE9		=> X_ATTRIBUTE9,
 	     X_ATTRIBUTE10	=> X_ATTRIBUTE10,
 	     X_ATTRIBUTE11	=> X_ATTRIBUTE11,
 	     X_ATTRIBUTE12	=> X_ATTRIBUTE12,
 	     X_ATTRIBUTE13	=> X_ATTRIBUTE13,
 	     X_ATTRIBUTE14	=> X_ATTRIBUTE14,
 	     X_ATTRIBUTE15	=> X_ATTRIBUTE15,
 	     X_DEFAULT_DATATYPE_ID	=> to_number(X_DEFAULT_DATATYPE_ID),
  	     X_USER_NAME 		=> X_USER_NAME,
 	     X_LAST_UPDATE_DATE	=> f_ludate,
 	     X_LAST_UPDATED_BY	=> f_luby,
 	     X_LAST_UPDATE_LOGIN 	=> 0 );

Line: 741

      select fnd_document_categories_s.nextval
      into l_category_id
      from dual;

Line: 745

      INSERT_ROW (
 	  X_ROWID 		=> l_row_id,
 	  X_CATEGORY_ID 	=> l_category_id,
 	  X_APPLICATION_ID	=> l_application_id,
 	  X_NAME 		=> X_CATEGORY_NAME,
 	  X_START_DATE_ACTIVE	=> to_date(X_START_DATE_ACTIVE, 'YYYY/MM/DD'),
 	  X_END_DATE_ACTIVE	=> to_date(X_END_DATE_ACTIVE, 'YYYY/MM/DD'),
 	  X_ATTRIBUTE_CATEGORY	=> X_ATTRIBUTE_CATEGORY,
 	  X_ATTRIBUTE1		=> X_ATTRIBUTE1,
	  X_ATTRIBUTE2		=> X_ATTRIBUTE2,
          X_ATTRIBUTE3		=> X_ATTRIBUTE3,
          X_ATTRIBUTE4		=> X_ATTRIBUTE4,
          X_ATTRIBUTE5		=> X_ATTRIBUTE5,
          X_ATTRIBUTE6		=> X_ATTRIBUTE6,
          X_ATTRIBUTE7		=> X_ATTRIBUTE7,
          X_ATTRIBUTE8		=> X_ATTRIBUTE8,
          X_ATTRIBUTE9		=> X_ATTRIBUTE9,
          X_ATTRIBUTE10	=> X_ATTRIBUTE10,
          X_ATTRIBUTE11	=> X_ATTRIBUTE11,
          X_ATTRIBUTE12	=> X_ATTRIBUTE12,
          X_ATTRIBUTE13	=> X_ATTRIBUTE13,
          X_ATTRIBUTE14	=> X_ATTRIBUTE14,
          X_ATTRIBUTE15	=> X_ATTRIBUTE15,
          X_DEFAULT_DATATYPE_ID   => to_number(X_DEFAULT_DATATYPE_ID),
          X_USER_NAME          => X_USER_NAME,
          X_CREATION_DATE 	=> f_ludate,
 	  X_CREATED_BY		=> f_luby,
          X_LAST_UPDATE_DATE   => f_ludate,
          X_LAST_UPDATED_BY    => f_luby,
          X_LAST_UPDATE_LOGIN  => 0 );