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

Line 121: HZ_UTILITY_V2PUB.CREATION_DATE,

117: X_ATTRIBUTE17,
118: X_ATTRIBUTE18,
119: X_ATTRIBUTE19,
120: X_ATTRIBUTE20,
121: HZ_UTILITY_V2PUB.CREATION_DATE,
122: HZ_UTILITY_V2PUB.CREATED_BY,
123: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
124: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
125: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN

Line 122: HZ_UTILITY_V2PUB.CREATED_BY,

118: X_ATTRIBUTE18,
119: X_ATTRIBUTE19,
120: X_ATTRIBUTE20,
121: HZ_UTILITY_V2PUB.CREATION_DATE,
122: HZ_UTILITY_V2PUB.CREATED_BY,
123: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
124: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
125: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
126: );

Line 123: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

119: X_ATTRIBUTE19,
120: X_ATTRIBUTE20,
121: HZ_UTILITY_V2PUB.CREATION_DATE,
122: HZ_UTILITY_V2PUB.CREATED_BY,
123: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
124: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
125: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
126: );
127:

Line 124: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

120: X_ATTRIBUTE20,
121: HZ_UTILITY_V2PUB.CREATION_DATE,
122: HZ_UTILITY_V2PUB.CREATED_BY,
123: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
124: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
125: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
126: );
127:
128: l_success := 'Y';

Line 125: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN

121: HZ_UTILITY_V2PUB.CREATION_DATE,
122: HZ_UTILITY_V2PUB.CREATED_BY,
123: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
124: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
125: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
126: );
127:
128: l_success := 'Y';
129:

Line 172: HZ_UTILITY_V2PUB.CREATED_BY,

168: ) select
169: X_ORIG_SYSTEM_ID,
170: X_ORIG_SYSTEM_NAME,
171: X_DESCRIPTION,
172: HZ_UTILITY_V2PUB.CREATED_BY,
173: HZ_UTILITY_V2PUB.CREATION_DATE,
174: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
175: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
176: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 173: HZ_UTILITY_V2PUB.CREATION_DATE,

169: X_ORIG_SYSTEM_ID,
170: X_ORIG_SYSTEM_NAME,
171: X_DESCRIPTION,
172: HZ_UTILITY_V2PUB.CREATED_BY,
173: HZ_UTILITY_V2PUB.CREATION_DATE,
174: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
175: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
176: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
177: L.LANGUAGE_CODE,

Line 174: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

170: X_ORIG_SYSTEM_NAME,
171: X_DESCRIPTION,
172: HZ_UTILITY_V2PUB.CREATED_BY,
173: HZ_UTILITY_V2PUB.CREATION_DATE,
174: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
175: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
176: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
177: L.LANGUAGE_CODE,
178: userenv('LANG')

Line 175: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

171: X_DESCRIPTION,
172: HZ_UTILITY_V2PUB.CREATED_BY,
173: HZ_UTILITY_V2PUB.CREATION_DATE,
174: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
175: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
176: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
177: L.LANGUAGE_CODE,
178: userenv('LANG')
179: from FND_LANGUAGES L

Line 176: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

172: HZ_UTILITY_V2PUB.CREATED_BY,
173: HZ_UTILITY_V2PUB.CREATION_DATE,
174: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
175: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
176: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
177: L.LANGUAGE_CODE,
178: userenv('LANG')
179: from FND_LANGUAGES L
180: where L.INSTALLED_FLAG in ('I', 'B')

Line 300: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

296: ATTRIBUTE17 = DECODE(X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,NULL,ATTRIBUTE17, X_ATTRIBUTE17),
297: ATTRIBUTE18 = DECODE(X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,NULL,ATTRIBUTE18, X_ATTRIBUTE18),
298: ATTRIBUTE19 = DECODE(X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,NULL,ATTRIBUTE19, X_ATTRIBUTE19),
299: ATTRIBUTE20 = DECODE(X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,NULL,ATTRIBUTE20, X_ATTRIBUTE20),
300: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
301: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
302: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
303: where ORIG_SYSTEM_ID = X_ORIG_SYSTEM_ID;
304:

Line 301: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

297: ATTRIBUTE18 = DECODE(X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,NULL,ATTRIBUTE18, X_ATTRIBUTE18),
298: ATTRIBUTE19 = DECODE(X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,NULL,ATTRIBUTE19, X_ATTRIBUTE19),
299: ATTRIBUTE20 = DECODE(X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,NULL,ATTRIBUTE20, X_ATTRIBUTE20),
300: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
301: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
302: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
303: where ORIG_SYSTEM_ID = X_ORIG_SYSTEM_ID;
304:
305: if (sql%notfound) then

Line 302: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN

298: ATTRIBUTE19 = DECODE(X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,NULL,ATTRIBUTE19, X_ATTRIBUTE19),
299: ATTRIBUTE20 = DECODE(X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,NULL,ATTRIBUTE20, X_ATTRIBUTE20),
300: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
301: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
302: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
303: where ORIG_SYSTEM_ID = X_ORIG_SYSTEM_ID;
304:
305: if (sql%notfound) then
306: raise no_data_found;

Line 312: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

308:
309: update HZ_ORIG_SYSTEMS_TL set
310: ORIG_SYSTEM_NAME = DECODE(X_ORIG_SYSTEM_NAME, FND_API.G_MISS_CHAR, NULL,NULL,ORIG_SYSTEM_NAME, X_ORIG_SYSTEM_NAME),
311: DESCRIPTION = DECODE(X_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,NULL,DESCRIPTION, X_DESCRIPTION),
312: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
313: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
314: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
315: SOURCE_LANG = userenv('LANG')
316: where ORIG_SYSTEM_ID = X_ORIG_SYSTEM_ID

Line 313: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

309: update HZ_ORIG_SYSTEMS_TL set
310: ORIG_SYSTEM_NAME = DECODE(X_ORIG_SYSTEM_NAME, FND_API.G_MISS_CHAR, NULL,NULL,ORIG_SYSTEM_NAME, X_ORIG_SYSTEM_NAME),
311: DESCRIPTION = DECODE(X_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,NULL,DESCRIPTION, X_DESCRIPTION),
312: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
313: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
314: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
315: SOURCE_LANG = userenv('LANG')
316: where ORIG_SYSTEM_ID = X_ORIG_SYSTEM_ID
317: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 314: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

310: ORIG_SYSTEM_NAME = DECODE(X_ORIG_SYSTEM_NAME, FND_API.G_MISS_CHAR, NULL,NULL,ORIG_SYSTEM_NAME, X_ORIG_SYSTEM_NAME),
311: DESCRIPTION = DECODE(X_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,NULL,DESCRIPTION, X_DESCRIPTION),
312: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
313: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
314: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
315: SOURCE_LANG = userenv('LANG')
316: where ORIG_SYSTEM_ID = X_ORIG_SYSTEM_ID
317: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
318: