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

Line 121: HZ_UTILITY_V2PUB.validate_lookup(

117: -- only if it is non-trivial ( neither null nor fnd_api.g_miss_char)
118:
119: IF p_cert_level is not null and p_cert_level <> FND_API.G_MISS_CHAR
120: THEN
121: HZ_UTILITY_V2PUB.validate_lookup(
122: p_column => 'certification_level',
123: p_lookup_type => 'HZ_PARTY_CERT_LEVEL',
124: p_column_value => p_cert_level ,
125: x_return_status => x_return_status

Line 140: HZ_UTILITY_V2PUB.validate_lookup(

136: -- only if it is non-trivial ( neither null nor fnd_api.g_miss_char)
137:
138: IF p_cert_reason_code is not null and p_cert_reason_code <> FND_API.G_MISS_CHAR
139: THEN
140: HZ_UTILITY_V2PUB.validate_lookup(
141: p_column => 'cert_reason_code',
142: p_lookup_type => 'HZ_PARTY_CERT_REASON',
143: p_column_value => p_cert_reason_code ,
144: x_return_status => x_return_status

Line 186: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

182: -- do the actual update
183: UPDATE HZ_PARTIES SET
184: CERTIFICATION_LEVEL = DECODE( p_cert_level, FND_API.G_MISS_CHAR, NULL, p_cert_level ),
185: CERT_REASON_CODE = DECODE( l_cert_reason_code, FND_API.G_MISS_CHAR, NULL, l_cert_reason_code ),
186: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
187: CREATION_DATE = CREATION_DATE,
188: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
189: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
190: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 188: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

184: CERTIFICATION_LEVEL = DECODE( p_cert_level, FND_API.G_MISS_CHAR, NULL, p_cert_level ),
185: CERT_REASON_CODE = DECODE( l_cert_reason_code, FND_API.G_MISS_CHAR, NULL, l_cert_reason_code ),
186: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
187: CREATION_DATE = CREATION_DATE,
188: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
189: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
190: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
191: CREATED_BY = CREATED_BY,
192: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 189: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943

185: CERT_REASON_CODE = DECODE( l_cert_reason_code, FND_API.G_MISS_CHAR, NULL, l_cert_reason_code ),
186: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
187: CREATION_DATE = CREATION_DATE,
188: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
189: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
190: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
191: CREATED_BY = CREATED_BY,
192: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
193: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 190: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

186: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
187: CREATION_DATE = CREATION_DATE,
188: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
189: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
190: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
191: CREATED_BY = CREATED_BY,
192: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
193: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
194: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 192: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

188: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
189: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
190: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
191: CREATED_BY = CREATED_BY,
192: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
193: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
194: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
195: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
196: WHERE ROWID = l_rowid;

Line 193: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

189: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
190: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
191: CREATED_BY = CREATED_BY,
192: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
193: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
194: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
195: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
196: WHERE ROWID = l_rowid;
197:

Line 194: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

190: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
191: CREATED_BY = CREATED_BY,
192: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
193: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
194: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
195: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
196: WHERE ROWID = l_rowid;
197:
198: -- Start of changes Bug No: 4181943

Line 324: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

320:
321:
322: UPDATE HZ_ORGANIZATION_PROFILES SET
323: internal_flag = p_internal_flag,
324: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
325: CREATION_DATE = CREATION_DATE,
326: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
327: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
328: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 326: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

322: UPDATE HZ_ORGANIZATION_PROFILES SET
323: internal_flag = p_internal_flag,
324: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
325: CREATION_DATE = CREATION_DATE,
326: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
327: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
328: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
329: CREATED_BY = CREATED_BY,
330: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 327: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943

323: internal_flag = p_internal_flag,
324: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
325: CREATION_DATE = CREATION_DATE,
326: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
327: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
328: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
329: CREATED_BY = CREATED_BY,
330: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
331: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 328: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

324: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
325: CREATION_DATE = CREATION_DATE,
326: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
327: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
328: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
329: CREATED_BY = CREATED_BY,
330: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
331: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
332: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 330: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

326: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
327: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
328: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
329: CREATED_BY = CREATED_BY,
330: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
331: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
332: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
333: OBJECT_VERSION_NUMBER = nvl(object_version_number,1)+1
334: WHERE party_id = p_party_id;

Line 331: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

327: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
328: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
329: CREATED_BY = CREATED_BY,
330: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
331: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
332: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
333: OBJECT_VERSION_NUMBER = nvl(object_version_number,1)+1
334: WHERE party_id = p_party_id;
335:

Line 332: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

328: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
329: CREATED_BY = CREATED_BY,
330: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
331: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
332: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
333: OBJECT_VERSION_NUMBER = nvl(object_version_number,1)+1
334: WHERE party_id = p_party_id;
335:
336:

Line 342: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

338: then
339:
340: UPDATE HZ_PERSON_PROFILES SET
341: internal_flag = p_internal_flag,
342: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
343: CREATION_DATE = CREATION_DATE,
344: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
345: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
346: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 344: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

340: UPDATE HZ_PERSON_PROFILES SET
341: internal_flag = p_internal_flag,
342: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
343: CREATION_DATE = CREATION_DATE,
344: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
345: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
346: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
347: CREATED_BY = CREATED_BY,
348: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 345: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943

341: internal_flag = p_internal_flag,
342: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
343: CREATION_DATE = CREATION_DATE,
344: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
345: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
346: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
347: CREATED_BY = CREATED_BY,
348: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
349: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 346: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

342: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
343: CREATION_DATE = CREATION_DATE,
344: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
345: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
346: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
347: CREATED_BY = CREATED_BY,
348: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
349: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
350: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 348: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

344: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
345: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
346: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
347: CREATED_BY = CREATED_BY,
348: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
349: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
350: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
351: OBJECT_VERSION_NUMBER = nvl(object_version_number,1)+1
352: WHERE party_id = p_party_id;

Line 349: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

345: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
346: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
347: CREATED_BY = CREATED_BY,
348: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
349: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
350: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
351: OBJECT_VERSION_NUMBER = nvl(object_version_number,1)+1
352: WHERE party_id = p_party_id;
353:

Line 350: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

346: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
347: CREATED_BY = CREATED_BY,
348: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
349: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
350: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
351: OBJECT_VERSION_NUMBER = nvl(object_version_number,1)+1
352: WHERE party_id = p_party_id;
353:
354:

Line 362: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

358: if p_status is not null
359: then
360: UPDATE HZ_PARTIES SET
361: status = p_status,
362: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
363: CREATION_DATE = CREATION_DATE,
364: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
365: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
366: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 364: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

360: UPDATE HZ_PARTIES SET
361: status = p_status,
362: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
363: CREATION_DATE = CREATION_DATE,
364: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
365: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
366: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
367: CREATED_BY = CREATED_BY,
368: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 365: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943

361: status = p_status,
362: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
363: CREATION_DATE = CREATION_DATE,
364: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
365: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
366: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
367: CREATED_BY = CREATED_BY,
368: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
369: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 366: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

362: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
363: CREATION_DATE = CREATION_DATE,
364: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
365: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
366: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
367: CREATED_BY = CREATED_BY,
368: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
369: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
370: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 368: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

364: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
365: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
366: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
367: CREATED_BY = CREATED_BY,
368: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
369: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
370: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
371: OBJECT_VERSION_NUMBER = nvl(object_version_number,1)+1
372: WHERE party_id = p_party_id;

Line 369: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

365: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID, --Bug No.4181943
366: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
367: CREATED_BY = CREATED_BY,
368: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
369: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
370: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
371: OBJECT_VERSION_NUMBER = nvl(object_version_number,1)+1
372: WHERE party_id = p_party_id;
373: end if;

Line 370: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

366: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
367: CREATED_BY = CREATED_BY,
368: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
369: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
370: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
371: OBJECT_VERSION_NUMBER = nvl(object_version_number,1)+1
372: WHERE party_id = p_party_id;
373: end if;
374: