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

Line 170: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

166: VALUES (
167: DECODE( X_PERSON_PROFILE_ID, FND_API.G_MISS_NUM, HZ_PERSON_PROFILES_S.NEXTVAL, NULL, HZ_PERSON_PROFILES_S.NEXTVAL, X_PERSON_PROFILE_ID ),
168: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
169: DECODE( X_PERSON_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME ),
170: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
171: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
172: HZ_UTILITY_V2PUB.CREATION_DATE,
173: HZ_UTILITY_V2PUB.CREATED_BY,
174: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 171: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

167: DECODE( X_PERSON_PROFILE_ID, FND_API.G_MISS_NUM, HZ_PERSON_PROFILES_S.NEXTVAL, NULL, HZ_PERSON_PROFILES_S.NEXTVAL, X_PERSON_PROFILE_ID ),
168: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
169: DECODE( X_PERSON_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME ),
170: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
171: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
172: HZ_UTILITY_V2PUB.CREATION_DATE,
173: HZ_UTILITY_V2PUB.CREATED_BY,
174: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
175: HZ_UTILITY_V2PUB.REQUEST_ID,

Line 172: HZ_UTILITY_V2PUB.CREATION_DATE,

168: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
169: DECODE( X_PERSON_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME ),
170: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
171: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
172: HZ_UTILITY_V2PUB.CREATION_DATE,
173: HZ_UTILITY_V2PUB.CREATED_BY,
174: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
175: HZ_UTILITY_V2PUB.REQUEST_ID,
176: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 173: HZ_UTILITY_V2PUB.CREATED_BY,

169: DECODE( X_PERSON_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME ),
170: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
171: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
172: HZ_UTILITY_V2PUB.CREATION_DATE,
173: HZ_UTILITY_V2PUB.CREATED_BY,
174: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
175: HZ_UTILITY_V2PUB.REQUEST_ID,
176: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
177: HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 174: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

170: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
171: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
172: HZ_UTILITY_V2PUB.CREATION_DATE,
173: HZ_UTILITY_V2PUB.CREATED_BY,
174: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
175: HZ_UTILITY_V2PUB.REQUEST_ID,
176: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
177: HZ_UTILITY_V2PUB.PROGRAM_ID,
178: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 175: HZ_UTILITY_V2PUB.REQUEST_ID,

171: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
172: HZ_UTILITY_V2PUB.CREATION_DATE,
173: HZ_UTILITY_V2PUB.CREATED_BY,
174: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
175: HZ_UTILITY_V2PUB.REQUEST_ID,
176: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
177: HZ_UTILITY_V2PUB.PROGRAM_ID,
178: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
179: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),

Line 176: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

172: HZ_UTILITY_V2PUB.CREATION_DATE,
173: HZ_UTILITY_V2PUB.CREATED_BY,
174: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
175: HZ_UTILITY_V2PUB.REQUEST_ID,
176: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
177: HZ_UTILITY_V2PUB.PROGRAM_ID,
178: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
179: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
180: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

Line 177: HZ_UTILITY_V2PUB.PROGRAM_ID,

173: HZ_UTILITY_V2PUB.CREATED_BY,
174: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
175: HZ_UTILITY_V2PUB.REQUEST_ID,
176: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
177: HZ_UTILITY_V2PUB.PROGRAM_ID,
178: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
179: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
180: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
181: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),

Line 178: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

174: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
175: HZ_UTILITY_V2PUB.REQUEST_ID,
176: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
177: HZ_UTILITY_V2PUB.PROGRAM_ID,
178: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
179: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
180: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
181: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
182: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),

Line 232: DECODE( X_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, trunc(hz_utility_v2pub.CREATION_DATE), NULL, trunc(hz_utility_v2pub.CREATION_DATE), X_EFFECTIVE_START_DATE ),

228: DECODE( X_HOUSEHOLD_INCOME, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_INCOME ),
229: DECODE( X_HOUSEHOLD_SIZE, FND_API.G_MISS_NUM, NULL, X_HOUSEHOLD_SIZE ),
230: DECODE( X_RENT_OWN_IND, FND_API.G_MISS_CHAR, NULL, X_RENT_OWN_IND ),
231: DECODE( X_LAST_KNOWN_GPS, FND_API.G_MISS_CHAR, NULL, X_LAST_KNOWN_GPS ),
232: DECODE( X_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, trunc(hz_utility_v2pub.CREATION_DATE), NULL, trunc(hz_utility_v2pub.CREATION_DATE), X_EFFECTIVE_START_DATE ),
233: DECODE( X_EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_EFFECTIVE_END_DATE ),
234: DECODE( X_CONTENT_SOURCE_TYPE, FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE, NULL, G_MISS_CONTENT_SOURCE_TYPE, X_CONTENT_SOURCE_TYPE ),
235: DECODE( X_KNOWN_AS2, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS2 ),
236: DECODE( X_KNOWN_AS3, FND_API.G_MISS_CHAR, NULL, X_KNOWN_AS3 ),

Line 365: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

361: UPDATE HZ_PERSON_PROFILES SET
362: PERSON_PROFILE_ID = DECODE( X_PERSON_PROFILE_ID, NULL, PERSON_PROFILE_ID, FND_API.G_MISS_NUM, NULL, X_PERSON_PROFILE_ID ),
363: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
364: PERSON_NAME = DECODE( X_PERSON_NAME, NULL, PERSON_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME),
365: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
366: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
367: CREATION_DATE = CREATION_DATE,
368: CREATED_BY = CREATED_BY,
369: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 366: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

362: PERSON_PROFILE_ID = DECODE( X_PERSON_PROFILE_ID, NULL, PERSON_PROFILE_ID, FND_API.G_MISS_NUM, NULL, X_PERSON_PROFILE_ID ),
363: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
364: PERSON_NAME = DECODE( X_PERSON_NAME, NULL, PERSON_NAME, FND_API.G_MISS_CHAR, NULL, X_PERSON_NAME),
365: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
366: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
367: CREATION_DATE = CREATION_DATE,
368: CREATED_BY = CREATED_BY,
369: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
370: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

Line 369: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

365: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
366: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
367: CREATION_DATE = CREATION_DATE,
368: CREATED_BY = CREATED_BY,
369: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
370: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
371: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
372: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
373: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 370: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

366: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
367: CREATION_DATE = CREATION_DATE,
368: CREATED_BY = CREATED_BY,
369: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
370: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
371: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
372: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
373: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
374: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),

Line 371: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

367: CREATION_DATE = CREATION_DATE,
368: CREATED_BY = CREATED_BY,
369: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
370: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
371: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
372: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
373: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
374: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
375: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

Line 372: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

368: CREATED_BY = CREATED_BY,
369: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
370: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
371: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
372: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
373: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
374: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
375: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
376: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),

Line 373: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

369: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
370: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
371: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
372: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
373: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
374: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
375: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
376: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
377: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),