APPS.HZ_TRANS_ATTRIBUTES_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  X_ATTRIBUTE_ID in OUT NOCOPY NUMBER,
  X_ENTITY_NAME in VARCHAR2,
  X_CUSTOM_ATTRIBUTE_PROCEDURE in VARCHAR2,
  X_SOURCE_TABLE in VARCHAR2,
  X_ATTRIBUTE_NAME in VARCHAR2,
  X_USER_DEFINED_ATTRIBUTE_NAME in VARCHAR2,
  x_DENORM_FLAG 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,
  X_OBJECT_VERSION_NUMBER in NUMBER
) is
   CURSOR C2 IS SELECT  HZ_TRANS_ATTRIBUTES_s.nextval FROM sys.dual;

Line: 30

      insert into HZ_TRANS_ATTRIBUTES_B (
       ATTRIBUTE_ID,
       ATTRIBUTE_NAME,
       ENTITY_NAME,
       CUSTOM_ATTRIBUTE_PROCEDURE,
       SOURCE_TABLE,
       DENORM_FLAG,
       CREATION_DATE,
       CREATED_BY,
       LAST_UPDATE_DATE,
       LAST_UPDATED_BY,
       LAST_UPDATE_LOGIN,
       OBJECT_VERSION_NUMBER
        ) values (
       X_ATTRIBUTE_ID,
       X_ATTRIBUTE_NAME,
       X_ENTITY_NAME,
       X_CUSTOM_ATTRIBUTE_PROCEDURE,
       X_SOURCE_TABLE,
       X_DENORM_FLAG,
       X_CREATION_DATE,
       X_CREATED_BY,
       X_LAST_UPDATE_DATE,
       X_LAST_UPDATED_BY,
       X_LAST_UPDATE_LOGIN,
       1
     );

Line: 67

                 SELECT  HZ_TRANS_ATTRIBUTES_s.nextval
		  into  X_ATTRIBUTE_ID FROM sys.dual;

Line: 70

                  SELECT 'Y' INTO l_dummy
                  FROM HZ_TRANS_ATTRIBUTES_B
                  WHERE ATTRIBUTE_ID =  X_ATTRIBUTE_ID;

Line: 83

   insert into HZ_TRANS_ATTRIBUTES_TL (
    LAST_UPDATE_DATE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    USER_DEFINED_ATTRIBUTE_NAME,
    ATTRIBUTE_ID,
    LANGUAGE,
    SOURCE_LANG,
    OBJECT_VERSION_NUMBER
  ) select
    X_LAST_UPDATE_DATE,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_USER_DEFINED_ATTRIBUTE_NAME,
    X_ATTRIBUTE_ID,
    L.LANGUAGE_CODE,
    userenv('LANG'),
    1
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from HZ_TRANS_ATTRIBUTES_TL T
    where T.ATTRIBUTE_ID = X_ATTRIBUTE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 113

end INSERT_ROW;

Line: 119

  cursor c is select
      OBJECT_VERSION_NUMBER
    from HZ_TRANS_ATTRIBUTES_B
    where ATTRIBUTE_ID = X_ATTRIBUTE_ID
    for update of ATTRIBUTE_ID nowait;

Line: 126

  cursor c1 is select
      OBJECT_VERSION_NUMBER,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from HZ_TRANS_ATTRIBUTES_TL
    where ATTRIBUTE_ID = X_ATTRIBUTE_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of ATTRIBUTE_ID nowait;

Line: 138

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

Line: 172

  cursor c is select
      OBJECT_VERSION_NUMBER
    from HZ_TRANS_ATTRIBUTES_B
    where ATTRIBUTE_ID = X_ATTRIBUTE_ID
    for update of ATTRIBUTE_ID nowait;

Line: 179

  cursor c1 is select
      USER_DEFINED_ATTRIBUTE_NAME,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from HZ_TRANS_ATTRIBUTES_TL
    where ATTRIBUTE_ID = X_ATTRIBUTE_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of ATTRIBUTE_ID nowait;

Line: 191

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

Line: 220

procedure UPDATE_ROW (
  X_ATTRIBUTE_ID in NUMBER,
  X_ENTITY_NAME in VARCHAR2,
  X_CUSTOM_ATTRIBUTE_PROCEDURE in VARCHAR2,
  X_SOURCE_TABLE in VARCHAR2,
  X_ATTRIBUTE_NAME in VARCHAR2,
  X_USER_DEFINED_ATTRIBUTE_NAME in VARCHAR2,
  X_DENORM_FLAG in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_OBJECT_VERSION_NUMBER IN out nocopy NUMBER
) is

  l_object_version_number number;

Line: 243

  SELECT 1 INTO TMP FROM HZ_TRANS_ATTRIBUTES_VL
  where attribute_id=X_ATTRIBUTE_ID;

Line: 248

  select ATTRIBUTE_NAME, USER_DEFINED_ATTRIBUTE_NAME,
         CUSTOM_ATTRIBUTE_PROCEDURE, LAST_UPDATED_BY, nvl(DENORM_FLAG,'N')
  into l_db_atr_name, l_db_user_def_atr, l_db_cus_atr_proc, l_db_upd_by, l_db_denorm_flag
  from HZ_TRANS_ATTRIBUTES_VL
  where attribute_id=X_ATTRIBUTE_ID;

Line: 254

  IF (X_LAST_UPDATED_BY = 1 AND l_db_upd_by <> 1) THEN
     -- coming from seed and data modified by user
     IF (l_db_cus_atr_proc <> X_CUSTOM_ATTRIBUTE_PROCEDURE) THEN
       update HZ_TRANS_ATTRIBUTES_B set
         CUSTOM_ATTRIBUTE_PROCEDURE = X_CUSTOM_ATTRIBUTE_PROCEDURE,
         OBJECT_VERSION_NUMBER = l_object_version_number
       where ATTRIBUTE_ID = X_ATTRIBUTE_ID;

Line: 262

       update hz_trans_functions_b
       set staged_flag = 'N'
       where attribute_id = X_ATTRIBUTE_ID;

Line: 267

    update HZ_TRANS_ATTRIBUTES_B set
      ENTITY_NAME = X_ENTITY_NAME,
      CUSTOM_ATTRIBUTE_PROCEDURE = X_CUSTOM_ATTRIBUTE_PROCEDURE,
      SOURCE_TABLE = X_SOURCE_TABLE,
      DENORM_FLAG = X_DENORM_FLAG,
      LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
      LAST_UPDATED_BY = X_LAST_UPDATED_BY, -- L_LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
      OBJECT_VERSION_NUMBER = l_object_version_number
    where ATTRIBUTE_ID = X_ATTRIBUTE_ID;

Line: 278

    update HZ_TRANS_ATTRIBUTES_TL set
      USER_DEFINED_ATTRIBUTE_NAME = X_USER_DEFINED_ATTRIBUTE_NAME,
      LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
      LAST_UPDATED_BY = X_LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
--    OBJECT_VERSION_NUMBER =l_object_version_number,
      SOURCE_LANG = userenv('LANG')
    where ATTRIBUTE_ID = X_ATTRIBUTE_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 289

       update hz_trans_functions_b
       set staged_flag = 'N'
       where attribute_id = X_ATTRIBUTE_ID;

Line: 295

end UPDATE_ROW;

Line: 297

procedure DELETE_ROW (
  X_ATTRIBUTE_ID in NUMBER
) is
begin
  delete from HZ_TRANS_ATTRIBUTES_TL
  where ATTRIBUTE_ID = X_ATTRIBUTE_ID;

Line: 308

  delete from HZ_TRANS_ATTRIBUTES_B
  where ATTRIBUTE_ID = X_ATTRIBUTE_ID;

Line: 314

end DELETE_ROW;

Line: 319

  delete from HZ_TRANS_ATTRIBUTES_TL T
  where not exists
    (select NULL
    from HZ_TRANS_ATTRIBUTES_B B
    where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
    );

Line: 326

     update HZ_TRANS_ATTRIBUTES_TL T set (
     USER_DEFINED_ATTRIBUTE_NAME
    ) = (select
    B.USER_DEFINED_ATTRIBUTE_NAME
    from HZ_TRANS_ATTRIBUTES_TL B
    where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.ATTRIBUTE_ID,
      T.LANGUAGE
  ) in (select
      SUBT.ATTRIBUTE_ID,
      SUBT.LANGUAGE
    from HZ_TRANS_ATTRIBUTES_TL SUBB, HZ_TRANS_ATTRIBUTES_TL SUBT
    where SUBB.ATTRIBUTE_ID = SUBT.ATTRIBUTE_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and  SUBB.USER_DEFINED_ATTRIBUTE_NAME <> SUBT.USER_DEFINED_ATTRIBUTE_NAME
  );

Line: 345

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

Line: 383

  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_OWNER in VARCHAR2) IS
begin

  declare
     user_id		number := 0;

Line: 404

     HZ_TRANS_ATTRIBUTES_PKG.UPDATE_ROW(
     X_ATTRIBUTE_ID => X_ATTRIBUTE_ID ,
     X_ENTITY_NAME =>  X_ENTITY_NAME,
     X_CUSTOM_ATTRIBUTE_PROCEDURE =>X_CUSTOM_ATTRIBUTE_PROCEDURE ,
     X_SOURCE_TABLE => X_SOURCE_TABLE ,
     X_DENORM_FLAG => X_DENORM_FLAG ,
     X_ATTRIBUTE_NAME => X_ATTRIBUTE_NAME ,
     X_USER_DEFINED_ATTRIBUTE_NAME =>X_USER_DEFINED_ATTRIBUTE_NAME ,
     X_LAST_UPDATE_DATE => sysdate,
     X_LAST_UPDATED_BY => user_id,
     X_LAST_UPDATE_LOGIN => 0,
     X_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER);

Line: 420

     HZ_TRANS_ATTRIBUTES_PKG.INSERT_ROW(
     X_ATTRIBUTE_ID => L_ATTRIBUTE_ID ,
     X_ENTITY_NAME =>  X_ENTITY_NAME,
     X_CUSTOM_ATTRIBUTE_PROCEDURE =>X_CUSTOM_ATTRIBUTE_PROCEDURE ,
     X_SOURCE_TABLE => X_SOURCE_TABLE ,
     X_ATTRIBUTE_NAME => X_ATTRIBUTE_NAME ,
     X_USER_DEFINED_ATTRIBUTE_NAME =>X_USER_DEFINED_ATTRIBUTE_NAME ,
     X_DENORM_FLAG => X_DENORM_FLAG ,
     X_CREATION_DATE=>SYSDATE  ,
     X_CREATED_BY =>USER_ID,
     X_LAST_UPDATE_DATE => sysdate,
     X_LAST_UPDATED_BY => user_id,
     X_LAST_UPDATE_LOGIN => 0,
     X_OBJECT_VERSION_NUMBER => 1);

Line: 445

    update HZ_TRANS_ATTRIBUTES_TL set
    USER_DEFINED_ATTRIBUTE_NAME= X_USER_DEFINED_ATTRIBUTE_NAME,
    source_lang = userenv('LANG'),
    last_update_date = sysdate,
    last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
    last_update_login = 0
    where ATTRIBUTE_ID= X_ATTRIBUTE_ID
    and   userenv('LANG') in (language, source_lang);