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
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
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,
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,
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,
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,
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;
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:
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
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,
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,
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,
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,
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;
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:
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:
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,
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,
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,
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,
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;
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:
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:
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,
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,
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,
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,
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;
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;
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: