42: VALUES (
43: DECODE( X_PARTY_SITE_USE_ID, FND_API.G_MISS_NUM, HZ_PARTY_SITE_USES_S.NEXTVAL, NULL, HZ_PARTY_SITE_USES_S.NEXTVAL, X_PARTY_SITE_USE_ID ),
44: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
45: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
46: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
47: HZ_UTILITY_V2PUB.REQUEST_ID,
48: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
49: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
43: DECODE( X_PARTY_SITE_USE_ID, FND_API.G_MISS_NUM, HZ_PARTY_SITE_USES_S.NEXTVAL, NULL, HZ_PARTY_SITE_USES_S.NEXTVAL, X_PARTY_SITE_USE_ID ),
44: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
45: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
46: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
47: HZ_UTILITY_V2PUB.REQUEST_ID,
48: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
49: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.PROGRAM_ID,
44: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
45: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
46: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
47: HZ_UTILITY_V2PUB.REQUEST_ID,
48: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
49: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.PROGRAM_ID,
52: HZ_UTILITY_V2PUB.CREATED_BY,
45: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
46: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
47: HZ_UTILITY_V2PUB.REQUEST_ID,
48: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
49: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.PROGRAM_ID,
52: HZ_UTILITY_V2PUB.CREATED_BY,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
46: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
47: HZ_UTILITY_V2PUB.REQUEST_ID,
48: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
49: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.PROGRAM_ID,
52: HZ_UTILITY_V2PUB.CREATED_BY,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
47: HZ_UTILITY_V2PUB.REQUEST_ID,
48: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
49: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.PROGRAM_ID,
52: HZ_UTILITY_V2PUB.CREATED_BY,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
55: DECODE( X_SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
48: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
49: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.PROGRAM_ID,
52: HZ_UTILITY_V2PUB.CREATED_BY,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
55: DECODE( X_SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
56: DECODE( X_PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_PER_TYPE ),
49: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.PROGRAM_ID,
52: HZ_UTILITY_V2PUB.CREATED_BY,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
55: DECODE( X_SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
56: DECODE( X_PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_PER_TYPE ),
57: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.PROGRAM_ID,
52: HZ_UTILITY_V2PUB.CREATED_BY,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
55: DECODE( X_SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
56: DECODE( X_PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_PER_TYPE ),
57: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
58: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
116: UPDATE HZ_PARTY_SITE_USES SET
117: PARTY_SITE_USE_ID = DECODE( X_PARTY_SITE_USE_ID, NULL, PARTY_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_USE_ID ),
118: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
119: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
120: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
121: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
122: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
123: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
124: CREATION_DATE = CREATION_DATE,
117: PARTY_SITE_USE_ID = DECODE( X_PARTY_SITE_USE_ID, NULL, PARTY_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_USE_ID ),
118: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
119: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
120: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
121: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
122: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
123: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
124: CREATION_DATE = CREATION_DATE,
125: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
118: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
119: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
120: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
121: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
122: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
123: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
124: CREATION_DATE = CREATION_DATE,
125: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
126: CREATED_BY = CREATED_BY,
119: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
120: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
121: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
122: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
123: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
124: CREATION_DATE = CREATION_DATE,
125: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
126: CREATED_BY = CREATED_BY,
127: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
121: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
122: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
123: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
124: CREATION_DATE = CREATION_DATE,
125: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
126: CREATED_BY = CREATED_BY,
127: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
128: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
129: SITE_USE_TYPE = DECODE( X_SITE_USE_TYPE, NULL, SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
123: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
124: CREATION_DATE = CREATION_DATE,
125: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
126: CREATED_BY = CREATED_BY,
127: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
128: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
129: SITE_USE_TYPE = DECODE( X_SITE_USE_TYPE, NULL, SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
130: PRIMARY_PER_TYPE = DECODE( X_PRIMARY_PER_TYPE, NULL, PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_PER_TYPE ),
131: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
124: CREATION_DATE = CREATION_DATE,
125: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
126: CREATED_BY = CREATED_BY,
127: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
128: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
129: SITE_USE_TYPE = DECODE( X_SITE_USE_TYPE, NULL, SITE_USE_TYPE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_TYPE ),
130: PRIMARY_PER_TYPE = DECODE( X_PRIMARY_PER_TYPE, NULL, PRIMARY_PER_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_PER_TYPE ),
131: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
132: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),