32: VALUES (
33: DECODE( X_LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
34: DECODE( X_LOC_ID, FND_API.G_MISS_NUM, NULL, X_LOC_ID ),
35: DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ),
36: HZ_UTILITY_V2PUB.CREATED_BY,
37: HZ_UTILITY_V2PUB.CREATION_DATE,
38: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
39: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
40: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
33: DECODE( X_LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
34: DECODE( X_LOC_ID, FND_API.G_MISS_NUM, NULL, X_LOC_ID ),
35: DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ),
36: HZ_UTILITY_V2PUB.CREATED_BY,
37: HZ_UTILITY_V2PUB.CREATION_DATE,
38: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
39: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
40: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
41: HZ_UTILITY_V2PUB.REQUEST_ID,
34: DECODE( X_LOC_ID, FND_API.G_MISS_NUM, NULL, X_LOC_ID ),
35: DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ),
36: HZ_UTILITY_V2PUB.CREATED_BY,
37: HZ_UTILITY_V2PUB.CREATION_DATE,
38: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
39: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
40: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
41: HZ_UTILITY_V2PUB.REQUEST_ID,
42: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
35: DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ),
36: HZ_UTILITY_V2PUB.CREATED_BY,
37: HZ_UTILITY_V2PUB.CREATION_DATE,
38: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
39: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
40: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
41: HZ_UTILITY_V2PUB.REQUEST_ID,
42: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
43: HZ_UTILITY_V2PUB.PROGRAM_ID,
36: HZ_UTILITY_V2PUB.CREATED_BY,
37: HZ_UTILITY_V2PUB.CREATION_DATE,
38: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
39: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
40: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
41: HZ_UTILITY_V2PUB.REQUEST_ID,
42: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
43: HZ_UTILITY_V2PUB.PROGRAM_ID,
44: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
37: HZ_UTILITY_V2PUB.CREATION_DATE,
38: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
39: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
40: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
41: HZ_UTILITY_V2PUB.REQUEST_ID,
42: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
43: HZ_UTILITY_V2PUB.PROGRAM_ID,
44: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
45: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
38: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
39: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
40: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
41: HZ_UTILITY_V2PUB.REQUEST_ID,
42: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
43: HZ_UTILITY_V2PUB.PROGRAM_ID,
44: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
45: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
46: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
39: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
40: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
41: HZ_UTILITY_V2PUB.REQUEST_ID,
42: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
43: HZ_UTILITY_V2PUB.PROGRAM_ID,
44: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
45: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
46: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
47: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
40: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
41: HZ_UTILITY_V2PUB.REQUEST_ID,
42: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
43: HZ_UTILITY_V2PUB.PROGRAM_ID,
44: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
45: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
46: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
47: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
48: ) ;
67: LOC_ID = DECODE( X_LOC_ID, NULL, LOC_ID, FND_API.G_MISS_NUM, NULL, X_LOC_ID ),
68: ORG_ID = DECODE( X_ORG_ID, NULL, ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ),
69: CREATED_BY = CREATED_BY,
70: CREATION_DATE = CREATION_DATE,
71: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
72: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
73: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
74: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
75: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
68: ORG_ID = DECODE( X_ORG_ID, NULL, ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ),
69: CREATED_BY = CREATED_BY,
70: CREATION_DATE = CREATION_DATE,
71: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
72: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
73: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
74: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
75: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
76: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
69: CREATED_BY = CREATED_BY,
70: CREATION_DATE = CREATION_DATE,
71: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
72: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
73: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
74: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
75: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
76: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
77: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
70: CREATION_DATE = CREATION_DATE,
71: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
72: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
73: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
74: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
75: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
76: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
77: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
78: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
71: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
72: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
73: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
74: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
75: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
76: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
77: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
78: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
79: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
72: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
73: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
74: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
75: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
76: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
77: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
78: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
79: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
80: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
73: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
74: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
75: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
76: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
77: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
78: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
79: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
80: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
81: WHERE ROWID = X_RowId;