APPS.XTR_SYS_LANGUAGES_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_MODULE_NAME in VARCHAR2,
  X_CANVAS_TYPE in VARCHAR2,
  X_ITEM_NAME in VARCHAR2,
  X_ORIGINAL_TEXT in VARCHAR2,
  X_TEXT 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 XTR_SYS_LANGUAGES
    where MODULE_NAME = X_MODULE_NAME
    and CANVAS_TYPE = X_CANVAS_TYPE
    and ITEM_NAME = X_ITEM_NAME
    ;

Line: 23

  insert into XTR_SYS_LANGUAGES (
    MODULE_NAME,
    CANVAS_TYPE,
    ITEM_NAME,
    ORIGINAL_TEXT,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_MODULE_NAME,
    X_CANVAS_TYPE,
    X_ITEM_NAME,
    X_ORIGINAL_TEXT,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 45

  insert into XTR_SYS_LANGUAGES_TL (
    MODULE_NAME,
    TEXT,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    CANVAS_TYPE,
    ITEM_NAME,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_MODULE_NAME,
    X_TEXT,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN,
    X_CANVAS_TYPE,
    X_ITEM_NAME,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from XTR_SYS_LANGUAGES_TL T
    where T.MODULE_NAME = X_MODULE_NAME
    and T.CANVAS_TYPE = X_CANVAS_TYPE
    and T.ITEM_NAME = X_ITEM_NAME
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 86

end INSERT_ROW;

Line: 107

   xtr_sys_languages_pkg.update_row (
         x_module_name => X_MODULE_NAME,
         x_canvas_type => X_CANVAS_TYPE,
         x_item_name   => X_ITEM_NAME,
         x_original_text        => X_ORIGINAL_TEXT ,
         x_text        => X_TEXT ,
         x_lang        => null,
         x_last_update_date => sysdate ,
         x_last_updated_by => user_id,
         x_last_update_login => 0);

Line: 119

       xtr_sys_languages_pkg.insert_row(
       X_ROWID => row_id,
       x_module_name => X_MODULE_NAME,
       x_canvas_type => X_CANVAS_TYPE,
       x_item_name   => X_ITEM_NAME,
       x_original_text => X_ORIGINAL_TEXT,
       x_text        => X_TEXT ,
       x_creation_date => sysdate,
       x_created_by    => 1,
       x_last_update_date => sysdate ,
       x_last_updated_by =>user_id,
       x_last_update_login => 0);

Line: 141

  cursor c1 is select
      TEXT,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from XTR_SYS_LANGUAGES_TL
    where MODULE_NAME = X_MODULE_NAME
    and CANVAS_TYPE = X_CANVAS_TYPE
    and ITEM_NAME = X_ITEM_NAME
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of MODULE_NAME nowait;

Line: 166

procedure UPDATE_ROW (
  X_MODULE_NAME in VARCHAR2,
  X_CANVAS_TYPE in VARCHAR2,
  X_ITEM_NAME in VARCHAR2,
  X_ORIGINAL_TEXT in VARCHAR2,
  X_TEXT in VARCHAR2,
  X_LANG in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
/*  Update Logic

     File           Database         Update
 ---------------------------------------------
     CUSTOM         SEED              Yes
     CUSTOM         CUSTOM            Yes
     SEED           CUSTOM            No
     SEED           SEED              YES
*/


begin
  declare
   l_last_updated_by   number;

Line: 193

        /* need to update xtr_sys_languages if original_text
           is changed */
        select  original_text
        into l_original_text
        from xtr_sys_languages
  	where MODULE_NAME = X_MODULE_NAME
  	and CANVAS_TYPE = X_CANVAS_TYPE
        and ITEM_NAME = X_ITEM_NAME;

Line: 206

    		update XTR_SYS_LANGUAGES set
    		ORIGINAL_TEXT = X_ORIGINAL_TEXT,
    		LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    		LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    		LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  	     		where MODULE_NAME = X_MODULE_NAME
  	     		and CANVAS_TYPE = X_CANVAS_TYPE
             		and ITEM_NAME = X_ITEM_NAME;

Line: 216

        /* end of change for update of original_text */
        select last_updated_by
        into l_last_updated_by
        from xtr_sys_languages_tl
  	where MODULE_NAME = X_MODULE_NAME
  	and CANVAS_TYPE = X_CANVAS_TYPE
        and ITEM_NAME = X_ITEM_NAME
  	and LANGUAGE = userenv('LANG') ;

Line: 225

        If ( l_last_updated_by = 1 or x_last_updated_by <> 1)
	/* Update as long as Database is not CUSTOM and File is SEED */
        then
    		update XTR_SYS_LANGUAGES_TL set
    		TEXT = X_TEXT,
    		LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    		LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    		LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
		SOURCE_LANG = userenv('LANG')
  	     		where MODULE_NAME = X_MODULE_NAME
  	     		and CANVAS_TYPE = X_CANVAS_TYPE
             		and ITEM_NAME = X_ITEM_NAME
                        and LANGUAGE = nvl(X_LANG, userenv('LANG'))
  	     		and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 245

end UPDATE_ROW;

Line: 267

   xtr_sys_languages_pkg.update_row (
         x_module_name => X_MODULE_NAME,
         x_canvas_type => X_CANVAS_TYPE,
         x_item_name   => X_ITEM_NAME,
         x_original_text        => X_ORIGINAL_TEXT ,
         x_text        => X_TEXT ,
         x_last_update_date => sysdate ,
         x_last_updated_by => user_id,
         x_last_update_login => 0);

Line: 277

/* update XTR_SYS_LANGUAGES_TL set
    TEXT = X_TEXT,
    LAST_UPDATE_DATE = sysdate,
    LAST_UPDATED_BY = 1,
    LAST_UPDATE_LOGIN = 0,
    SOURCE_LANG = userenv('LANG')
  where MODULE_NAME = X_MODULE_NAME
  and CANVAS_TYPE = X_CANVAS_TYPE
  and ITEM_NAME = X_ITEM_NAME
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 293

procedure DELETE_ROW (
  X_MODULE_NAME in VARCHAR2,
  X_CANVAS_TYPE in VARCHAR2,
  X_ITEM_NAME in VARCHAR2
) is
begin
  delete from XTR_SYS_LANGUAGES_TL
  where MODULE_NAME = X_MODULE_NAME
  and CANVAS_TYPE = X_CANVAS_TYPE
  and ITEM_NAME = X_ITEM_NAME;

Line: 308

  delete from XTR_SYS_LANGUAGES
  where MODULE_NAME = X_MODULE_NAME
  and CANVAS_TYPE = X_CANVAS_TYPE
  and ITEM_NAME = X_ITEM_NAME;

Line: 316

end DELETE_ROW;

Line: 321

  delete from XTR_SYS_LANGUAGES_TL T
  where not exists
    (select NULL
    from XTR_SYS_LANGUAGES B
    where B.MODULE_NAME = T.MODULE_NAME
    and B.CANVAS_TYPE = T.CANVAS_TYPE
    and B.ITEM_NAME = T.ITEM_NAME
    );

Line: 330

  update XTR_SYS_LANGUAGES_TL T set (
      TEXT
    ) = (select
      B.TEXT
    from XTR_SYS_LANGUAGES_TL B
    where B.MODULE_NAME = T.MODULE_NAME
    and B.CANVAS_TYPE = T.CANVAS_TYPE
    and B.ITEM_NAME = T.ITEM_NAME
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.MODULE_NAME,
      T.CANVAS_TYPE,
      T.ITEM_NAME,
      T.LANGUAGE
  ) in (select
      SUBT.MODULE_NAME,
      SUBT.CANVAS_TYPE,
      SUBT.ITEM_NAME,
      SUBT.LANGUAGE
    from XTR_SYS_LANGUAGES_TL SUBB, XTR_SYS_LANGUAGES_TL SUBT
    where SUBB.MODULE_NAME = SUBT.MODULE_NAME
    and SUBB.CANVAS_TYPE = SUBT.CANVAS_TYPE
    and SUBB.ITEM_NAME = SUBT.ITEM_NAME
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.TEXT <> SUBT.TEXT
      or (SUBB.TEXT is null and SUBT.TEXT is not null)
      or (SUBB.TEXT is not null and SUBT.TEXT is null)
  ));

Line: 359

  insert into XTR_SYS_LANGUAGES_TL (
    MODULE_NAME,
    TEXT,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    CANVAS_TYPE,
    ITEM_NAME,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.MODULE_NAME,
    B.TEXT,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    B.CANVAS_TYPE,
    B.ITEM_NAME,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from XTR_SYS_LANGUAGES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from XTR_SYS_LANGUAGES_TL T
    where T.MODULE_NAME = B.MODULE_NAME
    and T.CANVAS_TYPE = B.CANVAS_TYPE
    and T.ITEM_NAME = B.ITEM_NAME
    and T.LANGUAGE = L.LANGUAGE_CODE);