eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_STYLE_FORMATS_PKG SQL Statements

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

Line: 7


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_STYLE_FORMAT_CODE in VARCHAR2,
  X_STYLE_CODE in VARCHAR2,
  X_DEFAULT_FLAG in VARCHAR2,
  X_STYLE_FORMAT_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_OBJECT_VERSION_NUMBER  IN NUMBER
) is
  cursor C is select ROWID from HZ_STYLE_FORMATS_B
    where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
    ;

Line: 20


  insert into HZ_STYLE_FORMATS_B (
    STYLE_FORMAT_CODE,
    STYLE_CODE,
    DEFAULT_FLAG,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATE_LOGIN,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    OBJECT_VERSION_NUMBER
  ) values (
    DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
    DECODE( X_STYLE_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_CODE ),
    DECODE( X_DEFAULT_FLAG, FND_API.G_MISS_CHAR, NULL, X_DEFAULT_FLAG ),
    NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
    HZ_UTILITY_V2PUB.CREATION_DATE,
    NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
    HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
    NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
    DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
  );

Line: 42


  insert into HZ_STYLE_FORMATS_TL (
    STYLE_FORMAT_CODE,
    STYLE_FORMAT_NAME,
    DESCRIPTION,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATE_LOGIN,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LANGUAGE,
    SOURCE_LANG
  ) select
    DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
    DECODE( X_STYLE_FORMAT_NAME, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_NAME ),
    DECODE( X_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_DESCRIPTION ),
    NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
    HZ_UTILITY_V2PUB.CREATION_DATE,
    NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
    HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
    NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from HZ_STYLE_FORMATS_TL T
    where T.STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 80


end INSERT_ROW;

Line: 89


  cursor c is select
      STYLE_CODE,
      DEFAULT_FLAG
    from HZ_STYLE_FORMATS_B
    where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
    for update of STYLE_FORMAT_CODE nowait;

Line: 97


  cursor c1 is select
      STYLE_FORMAT_NAME,
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from HZ_STYLE_FORMATS_TL
    where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of STYLE_FORMAT_CODE nowait;

Line: 110


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

Line: 139


procedure UPDATE_ROW (
  X_STYLE_FORMAT_CODE in VARCHAR2,
  X_STYLE_CODE in VARCHAR2,
  X_DEFAULT_FLAG in VARCHAR2,
  X_STYLE_FORMAT_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_OBJECT_VERSION_NUMBER IN NUMBER
) is
begin
  update HZ_STYLE_FORMATS_B set
    STYLE_CODE = DECODE( X_STYLE_CODE, NULL, STYLE_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_CODE ),
    DEFAULT_FLAG = DECODE( X_DEFAULT_FLAG, NULL, DEFAULT_FLAG, FND_API.G_MISS_CHAR, NULL, X_DEFAULT_FLAG ),
    LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
    LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
    LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
    OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER,
                                  FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)
  where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE;

Line: 162


  update HZ_STYLE_FORMATS_TL set
    STYLE_FORMAT_NAME =  DECODE( X_STYLE_FORMAT_NAME, NULL, STYLE_FORMAT_NAME, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_NAME ),
    DESCRIPTION = DECODE( X_DESCRIPTION, NULL, DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_DESCRIPTION ),
    LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
    LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
    LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
    SOURCE_LANG = userenv('LANG')
  where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 175


end UPDATE_ROW;

Line: 177


PROCEDURE SELECT_ROW (
  X_STYLE_FORMAT_CODE		IN OUT NOCOPY VARCHAR2,
  X_STYLE_CODE			OUT    NOCOPY VARCHAR2,
  X_DEFAULT_FLAG		OUT    NOCOPY VARCHAR2,
  X_STYLE_FORMAT_NAME		OUT    NOCOPY VARCHAR2,
  X_DESCRIPTION			OUT    NOCOPY VARCHAR2
) IS
BEGIN

    SELECT
        NVL( B.STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
        NVL( B.STYLE_CODE, FND_API.G_MISS_CHAR ),
        NVL( B.DEFAULT_FLAG, FND_API.G_MISS_CHAR ),
        NVL( T.STYLE_FORMAT_NAME, FND_API.G_MISS_CHAR ),
        NVL( T.DESCRIPTION, FND_API.G_MISS_CHAR )
    INTO X_STYLE_FORMAT_CODE,
         X_STYLE_CODE,
	 X_DEFAULT_FLAG,
	 X_STYLE_FORMAT_NAME,
	 X_DESCRIPTION
    FROM HZ_STYLE_FORMATS_B B, HZ_STYLE_FORMATS_TL T
    WHERE B.STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
    AND   T.STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
    AND   T.LANGUAGE = userenv('LANG');

Line: 209


END SELECT_ROW;

Line: 212


procedure DELETE_ROW (
  X_STYLE_FORMAT_CODE in VARCHAR2
) is
begin
  delete from HZ_STYLE_FORMATS_TL
  where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE;

Line: 223


  delete from HZ_STYLE_FORMATS_B
  where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE;

Line: 229


end DELETE_ROW;

Line: 234


  delete from HZ_STYLE_FORMATS_TL T
  where not exists
    (select NULL
    from HZ_STYLE_FORMATS_B B
    where B.STYLE_FORMAT_CODE = T.STYLE_FORMAT_CODE
    );

Line: 241


  update HZ_STYLE_FORMATS_TL T set (
      STYLE_FORMAT_NAME,
      DESCRIPTION
    ) = (select
      B.STYLE_FORMAT_NAME,
      B.DESCRIPTION
    from HZ_STYLE_FORMATS_TL B
    where B.STYLE_FORMAT_CODE = T.STYLE_FORMAT_CODE
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.STYLE_FORMAT_CODE,
      T.LANGUAGE
  ) in (select
      SUBT.STYLE_FORMAT_CODE,
      SUBT.LANGUAGE
    from HZ_STYLE_FORMATS_TL SUBB, HZ_STYLE_FORMATS_TL SUBT
    where SUBB.STYLE_FORMAT_CODE = SUBT.STYLE_FORMAT_CODE
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.STYLE_FORMAT_NAME <> SUBT.STYLE_FORMAT_NAME
      or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
      or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
      or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
  ));

Line: 265


  insert into HZ_STYLE_FORMATS_TL (
    STYLE_FORMAT_CODE,
    STYLE_FORMAT_NAME,
    DESCRIPTION,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.STYLE_FORMAT_CODE,
    B.STYLE_FORMAT_NAME,
    B.DESCRIPTION,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from HZ_STYLE_FORMATS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from HZ_STYLE_FORMATS_TL T
    where T.STYLE_FORMAT_CODE = B.STYLE_FORMAT_CODE
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 304


  X_LAST_UPDATE_DATE in DATE,
  X_CUSTOM_MODE in VARCHAR2
) is
  l_f_luby    number;  -- entity owner in file

Line: 308


  l_f_ludate  date;    -- entity update date in file

Line: 310


  l_db_ludate date;    -- entity update date in db

Line: 324


  l_f_ludate := nvl(x_last_update_date, sysdate);

Line: 327


    select LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER
         into l_db_luby, l_db_ludate, l_object_version_number
         from HZ_STYLE_FORMATS_B
         where STYLE_FORMAT_CODE = x_style_format_code;

Line: 342


      hz_style_formats_pkg.update_row (
        X_STYLE_FORMAT_CODE    => X_STYLE_FORMAT_CODE,
        X_STYLE_CODE           => X_STYLE_CODE,
        X_DEFAULT_FLAG         => X_DEFAULT_FLAG,
        X_STYLE_FORMAT_NAME    => X_STYLE_FORMAT_NAME,
        X_DESCRIPTION          => X_DESCRIPTION,
        X_OBJECT_VERSION_NUMBER => l_object_version_number
      );

Line: 355


      hz_style_formats_pkg.insert_row(
          x_rowid                => l_rowid,
          x_style_format_code    => X_STYLE_FORMAT_CODE,
          x_style_code           => X_STYLE_CODE,
          x_default_flag         => X_DEFAULT_FLAG,
          x_style_format_name    => X_STYLE_FORMAT_NAME,
          x_description          => X_DESCRIPTION,
	  x_object_version_number => 1
      );

Line: 373


  X_LAST_UPDATE_DATE in DATE,
  X_CUSTOM_MODE in VARCHAR2
) is
  l_f_luby    number;  -- entity owner in file

Line: 377


  l_f_ludate  date;    -- entity update date in file

Line: 379


  l_db_ludate date;    -- entity update date in db

Line: 389


  l_f_ludate := nvl(x_last_update_date, sysdate);

Line: 392


    select LAST_UPDATED_BY, LAST_UPDATE_DATE
         into l_db_luby, l_db_ludate
         from HZ_STYLE_FORMATS_TL
         where STYLE_FORMAT_CODE = x_style_format_code
           and LANGUAGE = userenv('LANG');

Line: 408


      update HZ_STYLE_FORMATS_TL
         set STYLE_FORMAT_NAME = nvl(X_STYLE_FORMAT_NAME,STYLE_FORMAT_NAME),
             DESCRIPTION       = nvl(X_DESCRIPTION,DESCRIPTION),
             LAST_UPDATE_DATE  = l_f_ludate,
             LAST_UPDATED_BY   = l_f_luby,
             LAST_UPDATE_LOGIN = 0,
             SOURCE_LANG       = userenv('LANG')
       where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE
         and userenv('LANG') in (LANGUAGE, SOURCE_LANG);