179: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
180: DECODE( X_START_DATE, FND_API.G_MISS_DATE, SYSDATE, NULL,SYSDATE,X_START_DATE ),
181: DECODE( X_END_DATE, FND_API.G_MISS_DATE, TO_DATE('31/12/4712 00:00:01','DD/MM/YYYY HH24:MI:SS'), NULL, TO_DATE('31/12/4712 00:00:01','DD/MM/YYYY HH24:MI:SS'), X_END_DATE ),
182: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
183: HZ_UTILITY_V2PUB.CREATED_BY,
184: HZ_UTILITY_V2PUB.CREATION_DATE,
185: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
186: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
187: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
180: DECODE( X_START_DATE, FND_API.G_MISS_DATE, SYSDATE, NULL,SYSDATE,X_START_DATE ),
181: DECODE( X_END_DATE, FND_API.G_MISS_DATE, TO_DATE('31/12/4712 00:00:01','DD/MM/YYYY HH24:MI:SS'), NULL, TO_DATE('31/12/4712 00:00:01','DD/MM/YYYY HH24:MI:SS'), X_END_DATE ),
182: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
183: HZ_UTILITY_V2PUB.CREATED_BY,
184: HZ_UTILITY_V2PUB.CREATION_DATE,
185: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
186: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
187: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
188: HZ_UTILITY_V2PUB.REQUEST_ID,
181: DECODE( X_END_DATE, FND_API.G_MISS_DATE, TO_DATE('31/12/4712 00:00:01','DD/MM/YYYY HH24:MI:SS'), NULL, TO_DATE('31/12/4712 00:00:01','DD/MM/YYYY HH24:MI:SS'), X_END_DATE ),
182: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
183: HZ_UTILITY_V2PUB.CREATED_BY,
184: HZ_UTILITY_V2PUB.CREATION_DATE,
185: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
186: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
187: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
188: HZ_UTILITY_V2PUB.REQUEST_ID,
189: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
182: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
183: HZ_UTILITY_V2PUB.CREATED_BY,
184: HZ_UTILITY_V2PUB.CREATION_DATE,
185: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
186: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
187: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
188: HZ_UTILITY_V2PUB.REQUEST_ID,
189: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
190: HZ_UTILITY_V2PUB.PROGRAM_ID,
183: HZ_UTILITY_V2PUB.CREATED_BY,
184: HZ_UTILITY_V2PUB.CREATION_DATE,
185: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
186: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
187: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
188: HZ_UTILITY_V2PUB.REQUEST_ID,
189: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
190: HZ_UTILITY_V2PUB.PROGRAM_ID,
191: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
184: HZ_UTILITY_V2PUB.CREATION_DATE,
185: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
186: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
187: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
188: HZ_UTILITY_V2PUB.REQUEST_ID,
189: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
190: HZ_UTILITY_V2PUB.PROGRAM_ID,
191: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
192: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
185: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
186: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
187: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
188: HZ_UTILITY_V2PUB.REQUEST_ID,
189: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
190: HZ_UTILITY_V2PUB.PROGRAM_ID,
191: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
192: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
193: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
186: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
187: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
188: HZ_UTILITY_V2PUB.REQUEST_ID,
189: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
190: HZ_UTILITY_V2PUB.PROGRAM_ID,
191: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
192: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
193: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
194: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
187: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
188: HZ_UTILITY_V2PUB.REQUEST_ID,
189: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
190: HZ_UTILITY_V2PUB.PROGRAM_ID,
191: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
192: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
193: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
194: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
195: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
352: END_DATE = DECODE( X_END_DATE, NULL, END_DATE, FND_API.G_MISS_DATE, TO_DATE('31/12/4712 00:00:01','DD/MM/YYYY HH24:MI:SS'), X_END_DATE ),
353: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
354: CREATED_BY = CREATED_BY,
355: CREATION_DATE = CREATION_DATE,
356: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
357: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
358: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
359: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
360: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
353: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
354: CREATED_BY = CREATED_BY,
355: CREATION_DATE = CREATION_DATE,
356: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
357: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
358: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
359: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
360: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
361: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
354: CREATED_BY = CREATED_BY,
355: CREATION_DATE = CREATION_DATE,
356: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
357: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
358: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
359: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
360: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
361: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
362: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
355: CREATION_DATE = CREATION_DATE,
356: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
357: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
358: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
359: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
360: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
361: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
362: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
363: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
356: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
357: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
358: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
359: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
360: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
361: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
362: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
363: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
364: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
357: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
358: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
359: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
360: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
361: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
362: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
363: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
364: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
365: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
358: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
359: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
360: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
361: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
362: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
363: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
364: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
365: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
366: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),