57: DECODE( X_READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),
58: DECODE( X_SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),
59: DECODE( X_WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),
60: DECODE( X_SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),
61: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
62: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
63: HZ_UTILITY_V2PUB.CREATED_BY,
64: HZ_UTILITY_V2PUB.CREATION_DATE,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
58: DECODE( X_SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),
59: DECODE( X_WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),
60: DECODE( X_SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),
61: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
62: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
63: HZ_UTILITY_V2PUB.CREATED_BY,
64: HZ_UTILITY_V2PUB.CREATION_DATE,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: HZ_UTILITY_V2PUB.REQUEST_ID,
59: DECODE( X_WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),
60: DECODE( X_SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),
61: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
62: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
63: HZ_UTILITY_V2PUB.CREATED_BY,
64: HZ_UTILITY_V2PUB.CREATION_DATE,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: HZ_UTILITY_V2PUB.REQUEST_ID,
67: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
60: DECODE( X_SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),
61: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
62: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
63: HZ_UTILITY_V2PUB.CREATED_BY,
64: HZ_UTILITY_V2PUB.CREATION_DATE,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: HZ_UTILITY_V2PUB.REQUEST_ID,
67: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
68: HZ_UTILITY_V2PUB.PROGRAM_ID,
61: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
62: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
63: HZ_UTILITY_V2PUB.CREATED_BY,
64: HZ_UTILITY_V2PUB.CREATION_DATE,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: HZ_UTILITY_V2PUB.REQUEST_ID,
67: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
68: HZ_UTILITY_V2PUB.PROGRAM_ID,
69: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
62: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
63: HZ_UTILITY_V2PUB.CREATED_BY,
64: HZ_UTILITY_V2PUB.CREATION_DATE,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: HZ_UTILITY_V2PUB.REQUEST_ID,
67: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
68: HZ_UTILITY_V2PUB.PROGRAM_ID,
69: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
70: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
63: HZ_UTILITY_V2PUB.CREATED_BY,
64: HZ_UTILITY_V2PUB.CREATION_DATE,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: HZ_UTILITY_V2PUB.REQUEST_ID,
67: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
68: HZ_UTILITY_V2PUB.PROGRAM_ID,
69: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
70: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
71: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
64: HZ_UTILITY_V2PUB.CREATION_DATE,
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: HZ_UTILITY_V2PUB.REQUEST_ID,
67: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
68: HZ_UTILITY_V2PUB.PROGRAM_ID,
69: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
70: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
71: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
72: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
65: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: HZ_UTILITY_V2PUB.REQUEST_ID,
67: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
68: HZ_UTILITY_V2PUB.PROGRAM_ID,
69: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
70: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
71: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
72: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
73: HZ_UTILITY_V2PUB.APPLICATION_ID
69: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
70: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
71: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
72: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
73: HZ_UTILITY_V2PUB.APPLICATION_ID
74: ) RETURNING
75: LANGUAGE_USE_REFERENCE_ID
76: INTO
77: X_LANGUAGE_USE_REFERENCE_ID;
140: READS_LEVEL = DECODE( X_READS_LEVEL, NULL, READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),
141: SPEAKS_LEVEL = DECODE( X_SPEAKS_LEVEL, NULL, SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),
142: WRITES_LEVEL = DECODE( X_WRITES_LEVEL, NULL, WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),
143: SPOKEN_COMPREHENSION_LEVEL = DECODE( X_SPOKEN_COMPREHENSION_LEVEL, NULL, SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),
144: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
145: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
146: -- Bug 3032780
147: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
148: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
141: SPEAKS_LEVEL = DECODE( X_SPEAKS_LEVEL, NULL, SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),
142: WRITES_LEVEL = DECODE( X_WRITES_LEVEL, NULL, WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),
143: SPOKEN_COMPREHENSION_LEVEL = DECODE( X_SPOKEN_COMPREHENSION_LEVEL, NULL, SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),
144: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
145: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
146: -- Bug 3032780
147: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
148: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
149: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
143: SPOKEN_COMPREHENSION_LEVEL = DECODE( X_SPOKEN_COMPREHENSION_LEVEL, NULL, SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),
144: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
145: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
146: -- Bug 3032780
147: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
148: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
149: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
150: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
151: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
144: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
145: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
146: -- Bug 3032780
147: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
148: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
149: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
150: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
151: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
152: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
145: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
146: -- Bug 3032780
147: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
148: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
149: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
150: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
151: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
152: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
153: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
146: -- Bug 3032780
147: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
148: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
149: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
150: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
151: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
152: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
153: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
154: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
147: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
148: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
149: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
150: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
151: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
152: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
153: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
154: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
155: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
148: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
149: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
150: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
151: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
152: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
153: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
154: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
155: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
156: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
149: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
150: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
151: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
152: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
153: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
154: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
155: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
156: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
157: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )