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

Line 46: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

42: VALUES (
43: DECODE( X_PARTY_SITE_USE_ID, FND_API.G_MISS_NUM, HZ_PARTY_SITE_USES_S.NEXTVAL, NULL, HZ_PARTY_SITE_USES_S.NEXTVAL, X_PARTY_SITE_USE_ID ),
44: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
45: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
46: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
47: HZ_UTILITY_V2PUB.REQUEST_ID,
48: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
49: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
50: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 47: HZ_UTILITY_V2PUB.REQUEST_ID,

43: DECODE( X_PARTY_SITE_USE_ID, FND_API.G_MISS_NUM, HZ_PARTY_SITE_USES_S.NEXTVAL, NULL, HZ_PARTY_SITE_USES_S.NEXTVAL, X_PARTY_SITE_USE_ID ),
44: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
45: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
46: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
47: HZ_UTILITY_V2PUB.REQUEST_ID,
48: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
49: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 48: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

44: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
45: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
46: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
47: HZ_UTILITY_V2PUB.REQUEST_ID,
48: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
49: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.PROGRAM_ID,
52: HZ_UTILITY_V2PUB.CREATED_BY,

Line 49: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

45: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
46: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
47: HZ_UTILITY_V2PUB.REQUEST_ID,
48: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
49: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.PROGRAM_ID,
52: HZ_UTILITY_V2PUB.CREATED_BY,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 50: HZ_UTILITY_V2PUB.CREATION_DATE,

46: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
47: HZ_UTILITY_V2PUB.REQUEST_ID,
48: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
49: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.PROGRAM_ID,
52: HZ_UTILITY_V2PUB.CREATED_BY,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 51: HZ_UTILITY_V2PUB.PROGRAM_ID,

47: HZ_UTILITY_V2PUB.REQUEST_ID,
48: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
49: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.PROGRAM_ID,
52: HZ_UTILITY_V2PUB.CREATED_BY,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
55: DECODE( X_SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),

Line 52: HZ_UTILITY_V2PUB.CREATED_BY,

48: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
49: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.PROGRAM_ID,
52: HZ_UTILITY_V2PUB.CREATED_BY,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
55: DECODE( X_SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
56: DECODE( X_PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_PER_TYPE ),

Line 53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

49: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.PROGRAM_ID,
52: HZ_UTILITY_V2PUB.CREATED_BY,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
55: DECODE( X_SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
56: DECODE( X_PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_PER_TYPE ),
57: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),

Line 54: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.PROGRAM_ID,
52: HZ_UTILITY_V2PUB.CREATED_BY,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
55: DECODE( X_SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
56: DECODE( X_PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_PER_TYPE ),
57: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
58: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

Line 120: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

116: UPDATE HZ_PARTY_SITE_USES SET
117: PARTY_SITE_USE_ID = DECODE( X_PARTY_SITE_USE_ID, NULL, PARTY_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_USE_ID ),
118: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
119: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
120: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
121: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
122: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
123: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
124: CREATION_DATE = CREATION_DATE,

Line 121: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

117: PARTY_SITE_USE_ID = DECODE( X_PARTY_SITE_USE_ID, NULL, PARTY_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_USE_ID ),
118: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
119: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
120: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
121: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
122: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
123: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
124: CREATION_DATE = CREATION_DATE,
125: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 122: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

118: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
119: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
120: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
121: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
122: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
123: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
124: CREATION_DATE = CREATION_DATE,
125: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
126: CREATED_BY = CREATED_BY,

Line 123: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

119: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
120: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
121: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
122: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
123: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
124: CREATION_DATE = CREATION_DATE,
125: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
126: CREATED_BY = CREATED_BY,
127: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 125: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

121: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
122: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
123: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
124: CREATION_DATE = CREATION_DATE,
125: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
126: CREATED_BY = CREATED_BY,
127: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
128: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
129: SITE_USE_TYPE = DECODE( X_SITE_USE_TYPE, NULL, SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),

Line 127: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

123: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
124: CREATION_DATE = CREATION_DATE,
125: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
126: CREATED_BY = CREATED_BY,
127: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
128: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
129: SITE_USE_TYPE = DECODE( X_SITE_USE_TYPE, NULL, SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
130: PRIMARY_PER_TYPE = DECODE( X_PRIMARY_PER_TYPE, NULL, PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_PER_TYPE ),
131: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),

Line 128: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

124: CREATION_DATE = CREATION_DATE,
125: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
126: CREATED_BY = CREATED_BY,
127: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
128: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
129: SITE_USE_TYPE = DECODE( X_SITE_USE_TYPE, NULL, SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
130: PRIMARY_PER_TYPE = DECODE( X_PRIMARY_PER_TYPE, NULL, PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_PER_TYPE ),
131: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
132: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),