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

Line 183: HZ_UTILITY_V2PUB.CREATED_BY,

179: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
180: DECODE( TO_CHAR(X_START_DATE,'DD/MM/RRRR'), TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), SYSDATE, NULL,SYSDATE,X_START_DATE ),
181: DECODE( TO_CHAR(X_END_DATE,'DD/MM/RRRR'), TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), TO_DATE('31/12/4712 00:00:01','DD/MM/YYYY HH24:MI:SS'), NULL, TO_DATE('31/12/4712 00:00:01','DD/MM/YYYY HH24:MI:SS'), X_END_DATE ),
182: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
183: HZ_UTILITY_V2PUB.CREATED_BY,
184: HZ_UTILITY_V2PUB.CREATION_DATE,
185: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
186: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
187: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 184: HZ_UTILITY_V2PUB.CREATION_DATE,

180: DECODE( TO_CHAR(X_START_DATE,'DD/MM/RRRR'), TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), SYSDATE, NULL,SYSDATE,X_START_DATE ),
181: DECODE( TO_CHAR(X_END_DATE,'DD/MM/RRRR'), TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), TO_DATE('31/12/4712 00:00:01','DD/MM/YYYY HH24:MI:SS'), NULL, TO_DATE('31/12/4712 00:00:01','DD/MM/YYYY HH24:MI:SS'), X_END_DATE ),
182: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
183: HZ_UTILITY_V2PUB.CREATED_BY,
184: HZ_UTILITY_V2PUB.CREATION_DATE,
185: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
186: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
187: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
188: HZ_UTILITY_V2PUB.REQUEST_ID,

Line 185: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

181: DECODE( TO_CHAR(X_END_DATE,'DD/MM/RRRR'), TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), TO_DATE('31/12/4712 00:00:01','DD/MM/YYYY HH24:MI:SS'), NULL, TO_DATE('31/12/4712 00:00:01','DD/MM/YYYY HH24:MI:SS'), X_END_DATE ),
182: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
183: HZ_UTILITY_V2PUB.CREATED_BY,
184: HZ_UTILITY_V2PUB.CREATION_DATE,
185: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
186: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
187: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
188: HZ_UTILITY_V2PUB.REQUEST_ID,
189: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 186: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

182: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
183: HZ_UTILITY_V2PUB.CREATED_BY,
184: HZ_UTILITY_V2PUB.CREATION_DATE,
185: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
186: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
187: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
188: HZ_UTILITY_V2PUB.REQUEST_ID,
189: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
190: HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 187: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

183: HZ_UTILITY_V2PUB.CREATED_BY,
184: HZ_UTILITY_V2PUB.CREATION_DATE,
185: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
186: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
187: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
188: HZ_UTILITY_V2PUB.REQUEST_ID,
189: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
190: HZ_UTILITY_V2PUB.PROGRAM_ID,
191: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 188: HZ_UTILITY_V2PUB.REQUEST_ID,

184: HZ_UTILITY_V2PUB.CREATION_DATE,
185: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
186: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
187: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
188: HZ_UTILITY_V2PUB.REQUEST_ID,
189: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
190: HZ_UTILITY_V2PUB.PROGRAM_ID,
191: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
192: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),

Line 189: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

185: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
186: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
187: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
188: HZ_UTILITY_V2PUB.REQUEST_ID,
189: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
190: HZ_UTILITY_V2PUB.PROGRAM_ID,
191: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
192: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
193: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

Line 190: HZ_UTILITY_V2PUB.PROGRAM_ID,

186: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
187: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
188: HZ_UTILITY_V2PUB.REQUEST_ID,
189: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
190: HZ_UTILITY_V2PUB.PROGRAM_ID,
191: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
192: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
193: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
194: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),

Line 191: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

187: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
188: HZ_UTILITY_V2PUB.REQUEST_ID,
189: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
190: HZ_UTILITY_V2PUB.PROGRAM_ID,
191: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
192: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
193: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
194: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
195: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),

Line 356: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

352: END_DATE = DECODE( TO_CHAR(X_END_DATE,'DD/MM/RRRR'), NULL, END_DATE, TO_CHAR(FND_API.G_MISS_DATE,'DD/MM/RRRR'), TO_DATE('31/12/4712 00:00:01','DD/MM/YYYY HH24:MI:SS'), X_END_DATE ),
353: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
354: CREATED_BY = CREATED_BY,
355: CREATION_DATE = CREATION_DATE,
356: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
357: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
358: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
359: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
360: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 357: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

353: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
354: CREATED_BY = CREATED_BY,
355: CREATION_DATE = CREATION_DATE,
356: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
357: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
358: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
359: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
360: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
361: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 358: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

354: CREATED_BY = CREATED_BY,
355: CREATION_DATE = CREATION_DATE,
356: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
357: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
358: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
359: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
360: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
361: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
362: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 359: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

355: CREATION_DATE = CREATION_DATE,
356: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
357: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
358: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
359: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
360: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
361: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
362: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
363: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),

Line 360: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

356: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
357: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
358: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
359: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
360: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
361: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
362: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
363: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
364: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

Line 361: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

357: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
358: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
359: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
360: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
361: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
362: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
363: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
364: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
365: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),

Line 362: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

358: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
359: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
360: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
361: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
362: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
363: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
364: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
365: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
366: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),