240: DECODE( X_PARTY_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), NULL, TO_CHAR( HZ_PARTY_NUMBER_S.NEXTVAL ), X_PARTY_NUMBER ),
241: DECODE( X_PARTY_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_NAME ),
242: DECODE( X_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),
243: DECODE( X_VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_VALIDATED_FLAG ),
244: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
245: HZ_UTILITY_V2PUB.CREATION_DATE,
246: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
247: HZ_UTILITY_V2PUB.REQUEST_ID,
248: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
241: DECODE( X_PARTY_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_NAME ),
242: DECODE( X_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),
243: DECODE( X_VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_VALIDATED_FLAG ),
244: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
245: HZ_UTILITY_V2PUB.CREATION_DATE,
246: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
247: HZ_UTILITY_V2PUB.REQUEST_ID,
248: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
249: HZ_UTILITY_V2PUB.CREATED_BY,
242: DECODE( X_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),
243: DECODE( X_VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_VALIDATED_FLAG ),
244: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
245: HZ_UTILITY_V2PUB.CREATION_DATE,
246: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
247: HZ_UTILITY_V2PUB.REQUEST_ID,
248: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
249: HZ_UTILITY_V2PUB.CREATED_BY,
250: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
243: DECODE( X_VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_VALIDATED_FLAG ),
244: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
245: HZ_UTILITY_V2PUB.CREATION_DATE,
246: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
247: HZ_UTILITY_V2PUB.REQUEST_ID,
248: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
249: HZ_UTILITY_V2PUB.CREATED_BY,
250: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
251: HZ_UTILITY_V2PUB.PROGRAM_ID,
244: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
245: HZ_UTILITY_V2PUB.CREATION_DATE,
246: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
247: HZ_UTILITY_V2PUB.REQUEST_ID,
248: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
249: HZ_UTILITY_V2PUB.CREATED_BY,
250: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
251: HZ_UTILITY_V2PUB.PROGRAM_ID,
252: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
245: HZ_UTILITY_V2PUB.CREATION_DATE,
246: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
247: HZ_UTILITY_V2PUB.REQUEST_ID,
248: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
249: HZ_UTILITY_V2PUB.CREATED_BY,
250: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
251: HZ_UTILITY_V2PUB.PROGRAM_ID,
252: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
253: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
246: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
247: HZ_UTILITY_V2PUB.REQUEST_ID,
248: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
249: HZ_UTILITY_V2PUB.CREATED_BY,
250: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
251: HZ_UTILITY_V2PUB.PROGRAM_ID,
252: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
253: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
254: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
247: HZ_UTILITY_V2PUB.REQUEST_ID,
248: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
249: HZ_UTILITY_V2PUB.CREATED_BY,
250: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
251: HZ_UTILITY_V2PUB.PROGRAM_ID,
252: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
253: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
254: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
255: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
248: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
249: HZ_UTILITY_V2PUB.CREATED_BY,
250: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
251: HZ_UTILITY_V2PUB.PROGRAM_ID,
252: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
253: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
254: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
255: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
256: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
509: PARTY_NUMBER = DECODE( X_PARTY_NUMBER, NULL, PARTY_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_NUMBER ),
510: PARTY_NAME = DECODE( X_PARTY_NAME, NULL, PARTY_NAME, FND_API.G_MISS_CHAR, NULL, X_PARTY_NAME ),
511: PARTY_TYPE = DECODE( X_PARTY_TYPE, NULL, PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),
512: VALIDATED_FLAG = DECODE( X_VALIDATED_FLAG, NULL, VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', X_VALIDATED_FLAG ),
513: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
514: CREATION_DATE = CREATION_DATE,
515: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
516: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
517: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
511: PARTY_TYPE = DECODE( X_PARTY_TYPE, NULL, PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PARTY_TYPE ),
512: VALIDATED_FLAG = DECODE( X_VALIDATED_FLAG, NULL, VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', X_VALIDATED_FLAG ),
513: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
514: CREATION_DATE = CREATION_DATE,
515: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
516: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
517: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
518: CREATED_BY = CREATED_BY,
519: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
512: VALIDATED_FLAG = DECODE( X_VALIDATED_FLAG, NULL, VALIDATED_FLAG, FND_API.G_MISS_CHAR, 'N', X_VALIDATED_FLAG ),
513: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
514: CREATION_DATE = CREATION_DATE,
515: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
516: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
517: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
518: CREATED_BY = CREATED_BY,
519: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
520: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
513: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
514: CREATION_DATE = CREATION_DATE,
515: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
516: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
517: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
518: CREATED_BY = CREATED_BY,
519: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
520: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
521: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
515: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
516: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
517: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
518: CREATED_BY = CREATED_BY,
519: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
520: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
521: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
522: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
523: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
516: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
517: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
518: CREATED_BY = CREATED_BY,
519: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
520: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
521: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
522: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
523: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
524: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
517: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
518: CREATED_BY = CREATED_BY,
519: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
520: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
521: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
522: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
523: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
524: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
525: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),