APPS.HZ_TIMEZONE_UTILS_PVT SQL Statements

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

Line: 7

		select 'Y'
		from hz_phone_country_codes
	where territory_code = p_territory_code;

Line: 31

		select 'Y'
		from hz_phone_area_codes
	where territory_code = p_territory_code
	 and area_code = p_area_code;

Line: 83

	HZ_PHONE_AREA_CODES_PKG.insert_row(
                    p_rowid      => l_rowid,
                    p_TERRITORY_CODE                       =>p_TERRITORY_CODE,
                    p_AREA_CODE                            =>p_AREA_CODE,
                    p_PHONE_COUNTRY_CODE                   =>p_PHONE_COUNTRY_CODE,
                    p_DESCRIPTION                          =>p_DESCRIPTION,
                    p_CREATED_BY                           =>hz_utility_v2pub.created_by,
                    p_CREATION_DATE                        =>hz_utility_v2pub.creation_date,
                    p_LAST_UPDATE_LOGIN                    => hz_utility_v2pub.last_update_login,
                    p_LAST_UPDATE_DATE                     => hz_utility_v2pub.last_update_date,
                    p_LAST_UPDATED_BY                      =>hz_utility_v2pub.last_updated_by,
                    p_OBJECT_VERSION_NUMBER                =>1,
		    p_TIMEZONE_ID			   =>p_TIMEZONE_ID);

Line: 128

PROCEDURE update_area_code(
  p_territory_code        IN VARCHAR2,
  p_area_code             IN VARCHAR2,
  p_old_area_code         IN VARCHAR2,
  p_description           IN VARCHAR2,
  p_timezone_id           IN NUMBER,
  p_object_version_number IN OUT NOCOPY NUMBER,
  x_return_status         OUT NOCOPY VARCHAR2,
  x_msg_count             OUT NOCOPY NUMBER,
  x_msg_data              OUT NOCOPY VARCHAR2) is

  l_object_version_number NUMBER;

Line: 146

	SAVEPOINT update_area_code;

Line: 162

        SELECT OBJECT_VERSION_NUMBER,rowid,area_code
        INTO   l_object_version_number, l_rowid, l_area_code
        FROM   HZ_PHONE_AREA_CODES
        WHERE  TERRITORY_CODE = p_territory_code
	and area_code = p_old_area_code
        FOR UPDATE OF TERRITORY_CODE NOWAIT;

Line: 202

	HZ_PHONE_AREA_CODES_PKG.update_row(
                    p_rowid      => l_rowid,
                    p_TERRITORY_CODE                       =>p_TERRITORY_CODE,
                    p_AREA_CODE                            =>p_AREA_CODE,
                    p_PHONE_COUNTRY_CODE                   =>fnd_api.g_miss_char,
                    p_DESCRIPTION                          =>p_DESCRIPTION,
                    p_CREATED_BY                           =>hz_utility_v2pub.created_by,
                    p_CREATION_DATE                        =>hz_utility_v2pub.creation_date,
                    p_LAST_UPDATE_LOGIN                    => hz_utility_v2pub.last_update_login,
                    p_LAST_UPDATE_DATE                     => hz_utility_v2pub.last_update_date,
                    p_LAST_UPDATED_BY                      =>hz_utility_v2pub.last_updated_by,
                    p_OBJECT_VERSION_NUMBER		   =>l_object_version_number,
		    p_TIMEZONE_ID			   =>p_TIMEZONE_ID );

Line: 218

        ROLLBACK to update_area_code;

Line: 226

        ROLLBACK to update_area_code;

Line: 234

        ROLLBACK to update_area_code;

Line: 249

		select 'Y'
		from hz_phone_area_codes
		where territory_code = p_territory_code
		and timezone_id is not null;

Line: 265

PROCEDURE update_country_timezone(
  p_territory_code        IN VARCHAR2,
  p_timezone_id           IN NUMBER,
  p_object_version_number IN OUT NOCOPY NUMBER,
  x_return_status         OUT NOCOPY VARCHAR2,
  x_msg_count             OUT NOCOPY NUMBER,
  x_msg_data              OUT NOCOPY VARCHAR2) is

l_exist_flag varchar2(1);

Line: 280

        SELECT OBJECT_VERSION_NUMBER
        INTO   l_object_version_number
        FROM   HZ_PHONE_COUNTRY_CODES
        WHERE  TERRITORY_CODE = p_territory_code
        FOR UPDATE OF TERRITORY_CODE NOWAIT;

Line: 312

	update hz_phone_country_codes
	set  timezone_id = p_timezone_id,
	object_version_number =  nvl(l_object_version_number, 1) + 1,
	-- Bug 3032780
        --CREATED_BY                           =hz_utility_v2pub.created_by,
        --CREATION_DATE                        =hz_utility_v2pub.creation_date,
        LAST_UPDATE_LOGIN                    = hz_utility_v2pub.last_update_login,
        LAST_UPDATE_DATE                     = hz_utility_v2pub.last_update_date,
        LAST_UPDATED_BY                      =hz_utility_v2pub.last_updated_by
	where territory_code = p_territory_code;

Line: 332

		update hz_phone_area_codes
		set timezone_id = null,
		object_version_number = nvl(object_version_number,1)+1,
	-- Bug 3032780
        --      CREATED_BY                           =hz_utility_v2pub.created_by,
	--	CREATION_DATE                        =hz_utility_v2pub.creation_date,
		LAST_UPDATE_LOGIN                    = hz_utility_v2pub.last_update_login,
		LAST_UPDATE_DATE                     = hz_utility_v2pub.last_update_date,
		LAST_UPDATED_BY                      =hz_utility_v2pub.last_updated_by
		where territory_code = p_territory_code;