APPS.HZ_TRANSFORMATIONS_PKG SQL Statements

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

Line: 4

PROCEDURE Insert_Row (
    x_transformation_id                          IN  OUT NOCOPY NUMBER,
    x_transformation_name                        IN VARCHAR2,
    x_description                                IN VARCHAR2,
    x_procedure_name				 IN VARCHAR2,
    x_object_version_number			 IN  NUMBER
) IS


   CURSOR C2 IS SELECT   HZ_TRANSFORMATIONS_S.nextval FROM sys.dual ;

Line: 37

        INSERT INTO HZ_TRANSFORMATIONS_B(
         transformation_id,
         procedure_name,
         object_version_number,
         created_by,
	 creation_date,
         last_updated_by,
	 last_update_login,
	 last_update_date
        )
        VALUES (
         x_transformation_id,
         DECODE(x_procedure_name,FND_API.G_MISS_CHAR, NULL,x_procedure_name),
	 l_object_version_number,
         hz_utility_v2pub.created_by,
         hz_utility_v2pub.creation_date,
         hz_utility_v2pub.last_updated_by,
         hz_utility_v2pub.last_update_login,
	 hz_utility_v2pub.last_update_date
        );

Line: 66

	    SELECT  HZ_TRANSFORMATIONS_S.nextval
	    into  x_transformation_id FROM sys.dual;

Line: 69

	      SELECT 'Y' INTO l_dummy
	      FROM HZ_TRANSFORMATIONS_B
	      WHERE TRANSFORMATION_ID =  X_TRANSFORMATION_ID;

Line: 82

  INSERT INTO HZ_TRANSFORMATIONS_TL (
        transformation_id,
        transformation_name,
        description,
        language,
        source_lang,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_login,
	last_update_date
      )
       SELECT
        x_transformation_id,
        x_transformation_name,
        x_description,
        l.language_code,
        userenv('LANG'),
        l_object_version_number,
	hz_utility_v2pub.created_by,
	hz_utility_v2pub.creation_date,
        hz_utility_v2pub.last_updated_by,
        hz_utility_v2pub.last_update_login,
        hz_utility_v2pub.last_update_date
       FROM FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG in ('I', 'B')
       AND NOT EXISTS (select NULL from HZ_TRANSFORMATIONS_TL T
                       where T.TRANSFORMATION_ID = X_TRANSFORMATION_ID
                       and   T.LANGUAGE = L.LANGUAGE_CODE
	               );

Line: 114

END Insert_Row;

Line: 117

procedure Update_Row (
    x_transformation_id                          IN NUMBER,
    x_transformation_name                        IN VARCHAR2,
    x_description                                IN VARCHAR2,
    x_procedure_name				 IN VARCHAR2,
    x_object_version_number			 IN OUT NOCOPY NUMBER
)
IS
   p_object_version_number NUMBER ;

Line: 135

   UPDATE HZ_TRANSFORMATIONS_B set
        procedure_name = decode(x_procedure_name,null,procedure_name,fnd_api.g_miss_char,NULL,x_procedure_name),
        object_version_number = p_object_version_number,
        last_updated_by       = hz_utility_v2pub.last_updated_by,
        last_update_login     = hz_utility_v2pub.last_update_login,
        last_update_date      = hz_utility_v2pub.last_update_date
   where transformation_id = x_transformation_id;

Line: 147

  update HZ_TRANSFORMATIONS_TL set
        transformation_name = decode(x_transformation_name,null,transformation_name,fnd_api.g_miss_char,NULL,x_transformation_name),
        description = decode(x_description,null,description,fnd_api.g_miss_char,NULL,x_description),
        object_version_number = p_object_version_number,
        last_updated_by = hz_utility_v2pub.last_updated_by,
        last_update_login = hz_utility_v2pub.last_update_login,
        last_update_date = hz_utility_v2pub.last_update_date,
        source_lang = userenv('LANG')
  where transformation_id = x_transformation_id
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 166

procedure Delete_Row (
  x_transformation_id in NUMBER
)
IS
BEGIN
  delete from HZ_TRANSFORMATIONS_B
  where transformation_id = x_transformation_id ;

Line: 178

  delete from HZ_TRANSFORMATIONS_TL
  where transformation_id = x_transformation_id ;

Line: 191

 cursor c is select object_version_number
             from HZ_TRANSFORMATIONS_TL
             where transformation_id = x_transformation_id
	     and   language = userenv('lang');

Line: 195

 cursor c1 is select object_version_number
             from HZ_TRANSFORMATIONS_B
             where transformation_id = x_transformation_id
 for update of transformation_id nowait;

Line: 200

 cursor c2 is select object_version_number
             from HZ_TRANSFORMATIONS_TL
             where transformation_id = x_transformation_id
 for update of transformation_id nowait;

Line: 218

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

Line: 243

  delete from HZ_TRANSFORMATIONS_TL T
  where not exists
    (select NULL
    from HZ_TRANSFORMATIONS_B B
    where B.transformation_id = T.transformation_id
    );

Line: 250

  update HZ_TRANSFORMATIONS_TL T set (
      transformation_name,
      description,
      object_version_number
    ) = (select B.transformation_name,B.description,
            NVL(T.object_version_number, 1) + 1
         from HZ_TRANSFORMATIONS_TL B
         where B.transformation_id = T.transformation_id
         and B.language = T.source_lang
	 )
  where (T.transformation_id,T.language) in (select SUBT.transformation_id,SUBT.language
					     from HZ_TRANSFORMATIONS_TL SUBB, HZ_TRANSFORMATIONS_TL SUBT
					     where SUBB.transformation_id = SUBT.transformation_id
					     and SUBB.language = SUBT.source_lang
					     and (SUBB.transformation_name <> SUBT.transformation_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: 271

  insert into HZ_TRANSFORMATIONS_TL (
    LAST_UPDATE_DATE,
    CREATION_DATE,
    CREATED_BY,
    DESCRIPTION,
    TRANSFORMATION_NAME,
    TRANSFORMATION_ID,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG,
    OBJECT_VERSION_NUMBER
  ) select
    B.LAST_UPDATE_DATE,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.DESCRIPTION,
    B.TRANSFORMATION_NAME,
    B.TRANSFORMATION_ID,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG,
    1
  from HZ_TRANSFORMATIONS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and L.LANGUAGE_CODE <> B.LANGUAGE
  and not exists
    (select NULL
    from HZ_TRANSFORMATIONS_TL T
    where T.TRANSFORMATION_ID = B.TRANSFORMATION_ID
    and T.language = L.language_code );

Line: 313

    x_last_updated_by				 IN number,
    x_last_update_login				 IN number,
    x_last_update_date				 IN date,
    x_owner                                      IN VARCHAR2,
    x_custom_mode                                IN VARCHAR2
    )
IS
  l_f_luby    number;  -- entity owner in file

Line: 321

  l_f_ludate  date;    -- entity update date in file

Line: 323

  l_db_ludate date;    -- entity update date in db

Line: 337

  l_f_ludate := nvl(x_last_update_date, sysdate);

Line: 342

         select LAST_UPDATED_BY, LAST_UPDATE_DATE
         into l_db_luby, l_db_ludate
         from HZ_TRANSFORMATIONS_B
         where transformation_id = x_transformation_id ;

Line: 358

    HZ_TRANSFORMATIONS_PKG.UPDATE_ROW(
       x_transformation_id => x_transformation_id,
       x_transformation_name => x_transformation_name,
       x_description => x_description,
       x_procedure_name => x_procedure_name,
       x_object_version_number => l_object_version_number
    );

Line: 370

          HZ_TRANSFORMATIONS_PKG.INSERT_ROW(
            x_transformation_id => x_transformation_id,
            x_transformation_name => x_transformation_name,
            x_description => x_description,
            x_procedure_name => x_procedure_name,
            x_object_version_number => x_object_version_number
          );

Line: 391

 UPDATE HZ_TRANSFORMATIONS_TL set
 transformation_name = x_transformation_name,
 description = x_description,
 source_lang = userenv('LANG'),
 last_update_date = sysdate,
 last_updated_by = decode(x_owner, 'SEED', 1, 0),
 last_update_login = 0
 where transformation_id = x_transformation_id
 and   userenv('LANG') in (language, source_lang);