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

Line 224: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

220: VALUES (
221: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, HZ_CUST_ACCOUNTS_S.NEXTVAL, NULL, HZ_CUST_ACCOUNTS_S.NEXTVAL, X_CUST_ACCOUNT_ID ),
222: DECODE( X_ACCOUNT_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_ACCOUNT_NUM_S.NEXTVAL ), NULL, TO_CHAR( HZ_ACCOUNT_NUM_S.NEXTVAL ), X_ACCOUNT_NUMBER ),
223: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
224: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
225: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
226: HZ_UTILITY_V2PUB.CREATION_DATE,
227: HZ_UTILITY_V2PUB.CREATED_BY,
228: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 225: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

221: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, HZ_CUST_ACCOUNTS_S.NEXTVAL, NULL, HZ_CUST_ACCOUNTS_S.NEXTVAL, X_CUST_ACCOUNT_ID ),
222: DECODE( X_ACCOUNT_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_ACCOUNT_NUM_S.NEXTVAL ), NULL, TO_CHAR( HZ_ACCOUNT_NUM_S.NEXTVAL ), X_ACCOUNT_NUMBER ),
223: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
224: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
225: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
226: HZ_UTILITY_V2PUB.CREATION_DATE,
227: HZ_UTILITY_V2PUB.CREATED_BY,
228: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
229: HZ_UTILITY_V2PUB.REQUEST_ID,

Line 226: HZ_UTILITY_V2PUB.CREATION_DATE,

222: DECODE( X_ACCOUNT_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_ACCOUNT_NUM_S.NEXTVAL ), NULL, TO_CHAR( HZ_ACCOUNT_NUM_S.NEXTVAL ), X_ACCOUNT_NUMBER ),
223: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
224: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
225: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
226: HZ_UTILITY_V2PUB.CREATION_DATE,
227: HZ_UTILITY_V2PUB.CREATED_BY,
228: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
229: HZ_UTILITY_V2PUB.REQUEST_ID,
230: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 227: HZ_UTILITY_V2PUB.CREATED_BY,

223: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
224: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
225: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
226: HZ_UTILITY_V2PUB.CREATION_DATE,
227: HZ_UTILITY_V2PUB.CREATED_BY,
228: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
229: HZ_UTILITY_V2PUB.REQUEST_ID,
230: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
231: HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 228: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

224: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
225: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
226: HZ_UTILITY_V2PUB.CREATION_DATE,
227: HZ_UTILITY_V2PUB.CREATED_BY,
228: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
229: HZ_UTILITY_V2PUB.REQUEST_ID,
230: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
231: HZ_UTILITY_V2PUB.PROGRAM_ID,
232: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 229: HZ_UTILITY_V2PUB.REQUEST_ID,

225: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
226: HZ_UTILITY_V2PUB.CREATION_DATE,
227: HZ_UTILITY_V2PUB.CREATED_BY,
228: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
229: HZ_UTILITY_V2PUB.REQUEST_ID,
230: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
231: HZ_UTILITY_V2PUB.PROGRAM_ID,
232: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
233: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),

Line 230: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

226: HZ_UTILITY_V2PUB.CREATION_DATE,
227: HZ_UTILITY_V2PUB.CREATED_BY,
228: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
229: HZ_UTILITY_V2PUB.REQUEST_ID,
230: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
231: HZ_UTILITY_V2PUB.PROGRAM_ID,
232: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
233: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
234: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

Line 231: HZ_UTILITY_V2PUB.PROGRAM_ID,

227: HZ_UTILITY_V2PUB.CREATED_BY,
228: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
229: HZ_UTILITY_V2PUB.REQUEST_ID,
230: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
231: HZ_UTILITY_V2PUB.PROGRAM_ID,
232: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
233: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
234: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
235: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),

Line 232: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

228: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
229: HZ_UTILITY_V2PUB.REQUEST_ID,
230: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
231: HZ_UTILITY_V2PUB.PROGRAM_ID,
232: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
233: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
234: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
235: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
236: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),

Line 508: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

504:
505: UPDATE HZ_CUST_ACCOUNTS SET
506: CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
507: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
508: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
509: ACCOUNT_NUMBER = DECODE( X_ACCOUNT_NUMBER, NULL, ACCOUNT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_ACCOUNT_NUMBER ),
510: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
511: CREATION_DATE = CREATION_DATE,
512: CREATED_BY = CREATED_BY,

Line 510: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

506: CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
507: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
508: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
509: ACCOUNT_NUMBER = DECODE( X_ACCOUNT_NUMBER, NULL, ACCOUNT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_ACCOUNT_NUMBER ),
510: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
511: CREATION_DATE = CREATION_DATE,
512: CREATED_BY = CREATED_BY,
513: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
514: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

Line 513: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

509: ACCOUNT_NUMBER = DECODE( X_ACCOUNT_NUMBER, NULL, ACCOUNT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_ACCOUNT_NUMBER ),
510: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
511: CREATION_DATE = CREATION_DATE,
512: CREATED_BY = CREATED_BY,
513: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
514: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
515: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
516: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
517: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 514: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

510: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
511: CREATION_DATE = CREATION_DATE,
512: CREATED_BY = CREATED_BY,
513: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
514: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
515: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
516: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
517: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
518: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),

Line 515: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

511: CREATION_DATE = CREATION_DATE,
512: CREATED_BY = CREATED_BY,
513: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
514: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
515: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
516: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
517: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
518: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
519: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

Line 516: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

512: CREATED_BY = CREATED_BY,
513: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
514: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
515: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
516: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
517: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
518: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
519: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
520: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),

Line 517: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

513: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
514: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
515: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
516: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
517: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
518: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
519: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
520: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
521: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),