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

Line 81: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

77: )
78: VALUES (
79: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
80: DECODE( X_RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_RELATED_CUST_ACCOUNT_ID ),
81: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
82: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
83: HZ_UTILITY_V2PUB.CREATION_DATE,
84: HZ_UTILITY_V2PUB.CREATED_BY,
85: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 82: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

78: VALUES (
79: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
80: DECODE( X_RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_RELATED_CUST_ACCOUNT_ID ),
81: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
82: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
83: HZ_UTILITY_V2PUB.CREATION_DATE,
84: HZ_UTILITY_V2PUB.CREATED_BY,
85: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
86: DECODE( X_RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),

Line 83: HZ_UTILITY_V2PUB.CREATION_DATE,

79: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
80: DECODE( X_RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_RELATED_CUST_ACCOUNT_ID ),
81: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
82: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
83: HZ_UTILITY_V2PUB.CREATION_DATE,
84: HZ_UTILITY_V2PUB.CREATED_BY,
85: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
86: DECODE( X_RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),
87: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),

Line 84: HZ_UTILITY_V2PUB.CREATED_BY,

80: DECODE( X_RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_RELATED_CUST_ACCOUNT_ID ),
81: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
82: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
83: HZ_UTILITY_V2PUB.CREATION_DATE,
84: HZ_UTILITY_V2PUB.CREATED_BY,
85: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
86: DECODE( X_RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),
87: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
88: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),

Line 85: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

81: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
82: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
83: HZ_UTILITY_V2PUB.CREATION_DATE,
84: HZ_UTILITY_V2PUB.CREATED_BY,
85: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
86: DECODE( X_RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),
87: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
88: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
89: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

Line 99: HZ_UTILITY_V2PUB.REQUEST_ID,

95: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
96: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
97: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
98: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
99: HZ_UTILITY_V2PUB.REQUEST_ID,
100: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
101: HZ_UTILITY_V2PUB.PROGRAM_ID,
102: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
103: DECODE( X_CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_CUSTOMER_RECIPROCAL_FLAG ),

Line 100: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

96: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
97: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
98: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
99: HZ_UTILITY_V2PUB.REQUEST_ID,
100: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
101: HZ_UTILITY_V2PUB.PROGRAM_ID,
102: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
103: DECODE( X_CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_CUSTOMER_RECIPROCAL_FLAG ),
104: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),

Line 101: HZ_UTILITY_V2PUB.PROGRAM_ID,

97: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
98: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
99: HZ_UTILITY_V2PUB.REQUEST_ID,
100: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
101: HZ_UTILITY_V2PUB.PROGRAM_ID,
102: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
103: DECODE( X_CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_CUSTOMER_RECIPROCAL_FLAG ),
104: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
105: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

Line 102: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

98: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
99: HZ_UTILITY_V2PUB.REQUEST_ID,
100: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
101: HZ_UTILITY_V2PUB.PROGRAM_ID,
102: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
103: DECODE( X_CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_CUSTOMER_RECIPROCAL_FLAG ),
104: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
105: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
106: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),

Line 162: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

158:
159: UPDATE HZ_CUST_ACCT_RELATE_ALL SET -- Bug 3456489
160: CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
161: RELATED_CUST_ACCOUNT_ID = DECODE( X_RELATED_CUST_ACCOUNT_ID, NULL, RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_RELATED_CUST_ACCOUNT_ID ),
162: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
163: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
164: CREATION_DATE = CREATION_DATE,
165: CREATED_BY = CREATED_BY,
166: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 163: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

159: UPDATE HZ_CUST_ACCT_RELATE_ALL SET -- Bug 3456489
160: CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
161: RELATED_CUST_ACCOUNT_ID = DECODE( X_RELATED_CUST_ACCOUNT_ID, NULL, RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_RELATED_CUST_ACCOUNT_ID ),
162: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
163: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
164: CREATION_DATE = CREATION_DATE,
165: CREATED_BY = CREATED_BY,
166: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
167: RELATIONSHIP_TYPE = DECODE( X_RELATIONSHIP_TYPE, NULL, RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),

Line 166: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

162: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
163: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
164: CREATION_DATE = CREATION_DATE,
165: CREATED_BY = CREATED_BY,
166: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
167: RELATIONSHIP_TYPE = DECODE( X_RELATIONSHIP_TYPE, NULL, RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),
168: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
169: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
170: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

Line 180: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

176: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
177: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
178: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
179: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
180: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
181: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
182: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
183: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
184: CUSTOMER_RECIPROCAL_FLAG = DECODE( X_CUSTOMER_RECIPROCAL_FLAG, NULL, CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, 'N', X_CUSTOMER_RECIPROCAL_FLAG ),

Line 181: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

177: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
178: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
179: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
180: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
181: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
182: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
183: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
184: CUSTOMER_RECIPROCAL_FLAG = DECODE( X_CUSTOMER_RECIPROCAL_FLAG, NULL, CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, 'N', X_CUSTOMER_RECIPROCAL_FLAG ),
185: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),

Line 182: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

178: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
179: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
180: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
181: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
182: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
183: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
184: CUSTOMER_RECIPROCAL_FLAG = DECODE( X_CUSTOMER_RECIPROCAL_FLAG, NULL, CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, 'N', X_CUSTOMER_RECIPROCAL_FLAG ),
185: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
186: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

Line 183: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

179: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
180: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
181: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
182: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
183: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
184: CUSTOMER_RECIPROCAL_FLAG = DECODE( X_CUSTOMER_RECIPROCAL_FLAG, NULL, CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, 'N', X_CUSTOMER_RECIPROCAL_FLAG ),
185: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
186: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
187: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),