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_TIMEZONE_UTILS_PVT dependencies on HZ_UTILITY_V2PUB

Line 89: p_CREATED_BY =>hz_utility_v2pub.created_by,

85: p_TERRITORY_CODE =>p_TERRITORY_CODE,
86: p_AREA_CODE =>p_AREA_CODE,
87: p_PHONE_COUNTRY_CODE =>p_PHONE_COUNTRY_CODE,
88: p_DESCRIPTION =>p_DESCRIPTION,
89: p_CREATED_BY =>hz_utility_v2pub.created_by,
90: p_CREATION_DATE =>hz_utility_v2pub.creation_date,
91: p_LAST_UPDATE_LOGIN => hz_utility_v2pub.last_update_login,
92: p_LAST_UPDATE_DATE => hz_utility_v2pub.last_update_date,
93: p_LAST_UPDATED_BY =>hz_utility_v2pub.last_updated_by,

Line 90: p_CREATION_DATE =>hz_utility_v2pub.creation_date,

86: p_AREA_CODE =>p_AREA_CODE,
87: p_PHONE_COUNTRY_CODE =>p_PHONE_COUNTRY_CODE,
88: p_DESCRIPTION =>p_DESCRIPTION,
89: p_CREATED_BY =>hz_utility_v2pub.created_by,
90: p_CREATION_DATE =>hz_utility_v2pub.creation_date,
91: p_LAST_UPDATE_LOGIN => hz_utility_v2pub.last_update_login,
92: p_LAST_UPDATE_DATE => hz_utility_v2pub.last_update_date,
93: p_LAST_UPDATED_BY =>hz_utility_v2pub.last_updated_by,
94: p_OBJECT_VERSION_NUMBER =>1,

Line 91: p_LAST_UPDATE_LOGIN => hz_utility_v2pub.last_update_login,

87: p_PHONE_COUNTRY_CODE =>p_PHONE_COUNTRY_CODE,
88: p_DESCRIPTION =>p_DESCRIPTION,
89: p_CREATED_BY =>hz_utility_v2pub.created_by,
90: p_CREATION_DATE =>hz_utility_v2pub.creation_date,
91: p_LAST_UPDATE_LOGIN => hz_utility_v2pub.last_update_login,
92: p_LAST_UPDATE_DATE => hz_utility_v2pub.last_update_date,
93: p_LAST_UPDATED_BY =>hz_utility_v2pub.last_updated_by,
94: p_OBJECT_VERSION_NUMBER =>1,
95: p_TIMEZONE_ID =>p_TIMEZONE_ID);

Line 92: p_LAST_UPDATE_DATE => hz_utility_v2pub.last_update_date,

88: p_DESCRIPTION =>p_DESCRIPTION,
89: p_CREATED_BY =>hz_utility_v2pub.created_by,
90: p_CREATION_DATE =>hz_utility_v2pub.creation_date,
91: p_LAST_UPDATE_LOGIN => hz_utility_v2pub.last_update_login,
92: p_LAST_UPDATE_DATE => hz_utility_v2pub.last_update_date,
93: p_LAST_UPDATED_BY =>hz_utility_v2pub.last_updated_by,
94: p_OBJECT_VERSION_NUMBER =>1,
95: p_TIMEZONE_ID =>p_TIMEZONE_ID);
96:

Line 93: p_LAST_UPDATED_BY =>hz_utility_v2pub.last_updated_by,

89: p_CREATED_BY =>hz_utility_v2pub.created_by,
90: p_CREATION_DATE =>hz_utility_v2pub.creation_date,
91: p_LAST_UPDATE_LOGIN => hz_utility_v2pub.last_update_login,
92: p_LAST_UPDATE_DATE => hz_utility_v2pub.last_update_date,
93: p_LAST_UPDATED_BY =>hz_utility_v2pub.last_updated_by,
94: p_OBJECT_VERSION_NUMBER =>1,
95: p_TIMEZONE_ID =>p_TIMEZONE_ID);
96:
97: EXCEPTION

Line 208: p_CREATED_BY =>hz_utility_v2pub.created_by,

204: p_TERRITORY_CODE =>p_TERRITORY_CODE,
205: p_AREA_CODE =>p_AREA_CODE,
206: p_PHONE_COUNTRY_CODE =>fnd_api.g_miss_char,
207: p_DESCRIPTION =>p_DESCRIPTION,
208: p_CREATED_BY =>hz_utility_v2pub.created_by,
209: p_CREATION_DATE =>hz_utility_v2pub.creation_date,
210: p_LAST_UPDATE_LOGIN => hz_utility_v2pub.last_update_login,
211: p_LAST_UPDATE_DATE => hz_utility_v2pub.last_update_date,
212: p_LAST_UPDATED_BY =>hz_utility_v2pub.last_updated_by,

Line 209: p_CREATION_DATE =>hz_utility_v2pub.creation_date,

205: p_AREA_CODE =>p_AREA_CODE,
206: p_PHONE_COUNTRY_CODE =>fnd_api.g_miss_char,
207: p_DESCRIPTION =>p_DESCRIPTION,
208: p_CREATED_BY =>hz_utility_v2pub.created_by,
209: p_CREATION_DATE =>hz_utility_v2pub.creation_date,
210: p_LAST_UPDATE_LOGIN => hz_utility_v2pub.last_update_login,
211: p_LAST_UPDATE_DATE => hz_utility_v2pub.last_update_date,
212: p_LAST_UPDATED_BY =>hz_utility_v2pub.last_updated_by,
213: p_OBJECT_VERSION_NUMBER =>l_object_version_number,

Line 210: p_LAST_UPDATE_LOGIN => hz_utility_v2pub.last_update_login,

206: p_PHONE_COUNTRY_CODE =>fnd_api.g_miss_char,
207: p_DESCRIPTION =>p_DESCRIPTION,
208: p_CREATED_BY =>hz_utility_v2pub.created_by,
209: p_CREATION_DATE =>hz_utility_v2pub.creation_date,
210: p_LAST_UPDATE_LOGIN => hz_utility_v2pub.last_update_login,
211: p_LAST_UPDATE_DATE => hz_utility_v2pub.last_update_date,
212: p_LAST_UPDATED_BY =>hz_utility_v2pub.last_updated_by,
213: p_OBJECT_VERSION_NUMBER =>l_object_version_number,
214: p_TIMEZONE_ID =>p_TIMEZONE_ID );

Line 211: p_LAST_UPDATE_DATE => hz_utility_v2pub.last_update_date,

207: p_DESCRIPTION =>p_DESCRIPTION,
208: p_CREATED_BY =>hz_utility_v2pub.created_by,
209: p_CREATION_DATE =>hz_utility_v2pub.creation_date,
210: p_LAST_UPDATE_LOGIN => hz_utility_v2pub.last_update_login,
211: p_LAST_UPDATE_DATE => hz_utility_v2pub.last_update_date,
212: p_LAST_UPDATED_BY =>hz_utility_v2pub.last_updated_by,
213: p_OBJECT_VERSION_NUMBER =>l_object_version_number,
214: p_TIMEZONE_ID =>p_TIMEZONE_ID );
215:

Line 212: p_LAST_UPDATED_BY =>hz_utility_v2pub.last_updated_by,

208: p_CREATED_BY =>hz_utility_v2pub.created_by,
209: p_CREATION_DATE =>hz_utility_v2pub.creation_date,
210: p_LAST_UPDATE_LOGIN => hz_utility_v2pub.last_update_login,
211: p_LAST_UPDATE_DATE => hz_utility_v2pub.last_update_date,
212: p_LAST_UPDATED_BY =>hz_utility_v2pub.last_updated_by,
213: p_OBJECT_VERSION_NUMBER =>l_object_version_number,
214: p_TIMEZONE_ID =>p_TIMEZONE_ID );
215:
216: EXCEPTION

Line 316: --CREATED_BY =hz_utility_v2pub.created_by,

312: update hz_phone_country_codes
313: set timezone_id = p_timezone_id,
314: object_version_number = nvl(l_object_version_number, 1) + 1,
315: -- Bug 3032780
316: --CREATED_BY =hz_utility_v2pub.created_by,
317: --CREATION_DATE =hz_utility_v2pub.creation_date,
318: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login,
319: LAST_UPDATE_DATE = hz_utility_v2pub.last_update_date,
320: LAST_UPDATED_BY =hz_utility_v2pub.last_updated_by

Line 317: --CREATION_DATE =hz_utility_v2pub.creation_date,

313: set timezone_id = p_timezone_id,
314: object_version_number = nvl(l_object_version_number, 1) + 1,
315: -- Bug 3032780
316: --CREATED_BY =hz_utility_v2pub.created_by,
317: --CREATION_DATE =hz_utility_v2pub.creation_date,
318: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login,
319: LAST_UPDATE_DATE = hz_utility_v2pub.last_update_date,
320: LAST_UPDATED_BY =hz_utility_v2pub.last_updated_by
321: where territory_code = p_territory_code;

Line 318: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login,

314: object_version_number = nvl(l_object_version_number, 1) + 1,
315: -- Bug 3032780
316: --CREATED_BY =hz_utility_v2pub.created_by,
317: --CREATION_DATE =hz_utility_v2pub.creation_date,
318: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login,
319: LAST_UPDATE_DATE = hz_utility_v2pub.last_update_date,
320: LAST_UPDATED_BY =hz_utility_v2pub.last_updated_by
321: where territory_code = p_territory_code;
322:

Line 319: LAST_UPDATE_DATE = hz_utility_v2pub.last_update_date,

315: -- Bug 3032780
316: --CREATED_BY =hz_utility_v2pub.created_by,
317: --CREATION_DATE =hz_utility_v2pub.creation_date,
318: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login,
319: LAST_UPDATE_DATE = hz_utility_v2pub.last_update_date,
320: LAST_UPDATED_BY =hz_utility_v2pub.last_updated_by
321: where territory_code = p_territory_code;
322:
323: If (SQL%NOTFOUND) then

Line 320: LAST_UPDATED_BY =hz_utility_v2pub.last_updated_by

316: --CREATED_BY =hz_utility_v2pub.created_by,
317: --CREATION_DATE =hz_utility_v2pub.creation_date,
318: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login,
319: LAST_UPDATE_DATE = hz_utility_v2pub.last_update_date,
320: LAST_UPDATED_BY =hz_utility_v2pub.last_updated_by
321: where territory_code = p_territory_code;
322:
323: If (SQL%NOTFOUND) then
324: x_return_status := FND_API.G_RET_STS_ERROR;

Line 336: -- CREATED_BY =hz_utility_v2pub.created_by,

332: update hz_phone_area_codes
333: set timezone_id = null,
334: object_version_number = nvl(object_version_number,1)+1,
335: -- Bug 3032780
336: -- CREATED_BY =hz_utility_v2pub.created_by,
337: -- CREATION_DATE =hz_utility_v2pub.creation_date,
338: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login,
339: LAST_UPDATE_DATE = hz_utility_v2pub.last_update_date,
340: LAST_UPDATED_BY =hz_utility_v2pub.last_updated_by

Line 337: -- CREATION_DATE =hz_utility_v2pub.creation_date,

333: set timezone_id = null,
334: object_version_number = nvl(object_version_number,1)+1,
335: -- Bug 3032780
336: -- CREATED_BY =hz_utility_v2pub.created_by,
337: -- CREATION_DATE =hz_utility_v2pub.creation_date,
338: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login,
339: LAST_UPDATE_DATE = hz_utility_v2pub.last_update_date,
340: LAST_UPDATED_BY =hz_utility_v2pub.last_updated_by
341: where territory_code = p_territory_code;

Line 338: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login,

334: object_version_number = nvl(object_version_number,1)+1,
335: -- Bug 3032780
336: -- CREATED_BY =hz_utility_v2pub.created_by,
337: -- CREATION_DATE =hz_utility_v2pub.creation_date,
338: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login,
339: LAST_UPDATE_DATE = hz_utility_v2pub.last_update_date,
340: LAST_UPDATED_BY =hz_utility_v2pub.last_updated_by
341: where territory_code = p_territory_code;
342: end if;

Line 339: LAST_UPDATE_DATE = hz_utility_v2pub.last_update_date,

335: -- Bug 3032780
336: -- CREATED_BY =hz_utility_v2pub.created_by,
337: -- CREATION_DATE =hz_utility_v2pub.creation_date,
338: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login,
339: LAST_UPDATE_DATE = hz_utility_v2pub.last_update_date,
340: LAST_UPDATED_BY =hz_utility_v2pub.last_updated_by
341: where territory_code = p_territory_code;
342: end if;
343:

Line 340: LAST_UPDATED_BY =hz_utility_v2pub.last_updated_by

336: -- CREATED_BY =hz_utility_v2pub.created_by,
337: -- CREATION_DATE =hz_utility_v2pub.creation_date,
338: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login,
339: LAST_UPDATE_DATE = hz_utility_v2pub.last_update_date,
340: LAST_UPDATED_BY =hz_utility_v2pub.last_updated_by
341: where territory_code = p_territory_code;
342: end if;
343:
344: end;