40: ) VALUES (
41: DECODE( x_WORK_CLASS_ID, FND_API.G_MISS_NUM, HZ_WORK_CLASS_S.NEXTVAL, NULL, HZ_WORK_CLASS_S.NEXTVAL, X_WORK_CLASS_ID ),
42: decode( x_LEVEL_OF_EXPERIENCE, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_EXPERIENCE),
43: decode( x_WORK_CLASS_NAME, FND_API.G_MISS_CHAR, NULL,x_WORK_CLASS_NAME),
44: HZ_UTILITY_V2PUB.CREATED_BY,
45: decode( x_EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYMENT_HISTORY_ID),
46: HZ_UTILITY_V2PUB.CREATION_DATE,
47: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
48: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
42: decode( x_LEVEL_OF_EXPERIENCE, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_EXPERIENCE),
43: decode( x_WORK_CLASS_NAME, FND_API.G_MISS_CHAR, NULL,x_WORK_CLASS_NAME),
44: HZ_UTILITY_V2PUB.CREATED_BY,
45: decode( x_EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYMENT_HISTORY_ID),
46: HZ_UTILITY_V2PUB.CREATION_DATE,
47: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
48: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
49: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
50: HZ_UTILITY_V2PUB.REQUEST_ID,
43: decode( x_WORK_CLASS_NAME, FND_API.G_MISS_CHAR, NULL,x_WORK_CLASS_NAME),
44: HZ_UTILITY_V2PUB.CREATED_BY,
45: decode( x_EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYMENT_HISTORY_ID),
46: HZ_UTILITY_V2PUB.CREATION_DATE,
47: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
48: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
49: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
50: HZ_UTILITY_V2PUB.REQUEST_ID,
51: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
44: HZ_UTILITY_V2PUB.CREATED_BY,
45: decode( x_EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYMENT_HISTORY_ID),
46: HZ_UTILITY_V2PUB.CREATION_DATE,
47: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
48: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
49: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
50: HZ_UTILITY_V2PUB.REQUEST_ID,
51: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
52: HZ_UTILITY_V2PUB.PROGRAM_ID,
45: decode( x_EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYMENT_HISTORY_ID),
46: HZ_UTILITY_V2PUB.CREATION_DATE,
47: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
48: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
49: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
50: HZ_UTILITY_V2PUB.REQUEST_ID,
51: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
52: HZ_UTILITY_V2PUB.PROGRAM_ID,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
46: HZ_UTILITY_V2PUB.CREATION_DATE,
47: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
48: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
49: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
50: HZ_UTILITY_V2PUB.REQUEST_ID,
51: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
52: HZ_UTILITY_V2PUB.PROGRAM_ID,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: decode( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
47: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
48: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
49: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
50: HZ_UTILITY_V2PUB.REQUEST_ID,
51: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
52: HZ_UTILITY_V2PUB.PROGRAM_ID,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: decode( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
55: decode( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
48: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
49: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
50: HZ_UTILITY_V2PUB.REQUEST_ID,
51: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
52: HZ_UTILITY_V2PUB.PROGRAM_ID,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: decode( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
55: decode( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
56: decode( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
49: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
50: HZ_UTILITY_V2PUB.REQUEST_ID,
51: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
52: HZ_UTILITY_V2PUB.PROGRAM_ID,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: decode( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
55: decode( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
56: decode( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
57: HZ_UTILITY_V2PUB.APPLICATION_ID
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: decode( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
55: decode( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
56: decode( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
57: HZ_UTILITY_V2PUB.APPLICATION_ID
58: ) RETURNING
59: WORK_CLASS_ID
60: INTO
61: X_WORK_CLASS_ID;
128: WORK_CLASS_ID = decode( x_WORK_CLASS_ID, NULL, WORK_CLASS_ID, FND_API.G_MISS_NUM, NULL, x_WORK_CLASS_ID),
129: LEVEL_OF_EXPERIENCE = decode( x_LEVEL_OF_EXPERIENCE, NULL, LEVEL_OF_EXPERIENCE, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_EXPERIENCE),
130: WORK_CLASS_NAME = decode( x_WORK_CLASS_NAME, NULL, WORK_CLASS_NAME, FND_API.G_MISS_CHAR, NULL, x_WORK_CLASS_NAME),
131: -- Bug 3032780
132: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
133: EMPLOYMENT_HISTORY_ID = decode( x_EMPLOYMENT_HISTORY_ID, NULL, EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM,NULL, x_EMPLOYMENT_HISTORY_ID),
134: -- Bug 3032780
135: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
136: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
131: -- Bug 3032780
132: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
133: EMPLOYMENT_HISTORY_ID = decode( x_EMPLOYMENT_HISTORY_ID, NULL, EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM,NULL, x_EMPLOYMENT_HISTORY_ID),
134: -- Bug 3032780
135: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
136: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
137: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
138: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
139: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
132: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
133: EMPLOYMENT_HISTORY_ID = decode( x_EMPLOYMENT_HISTORY_ID, NULL, EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM,NULL, x_EMPLOYMENT_HISTORY_ID),
134: -- Bug 3032780
135: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
136: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
137: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
138: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
139: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
140: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
133: EMPLOYMENT_HISTORY_ID = decode( x_EMPLOYMENT_HISTORY_ID, NULL, EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM,NULL, x_EMPLOYMENT_HISTORY_ID),
134: -- Bug 3032780
135: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
136: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
137: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
138: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
139: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
140: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
141: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
134: -- Bug 3032780
135: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
136: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
137: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
138: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
139: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
140: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
141: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
142: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
135: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
136: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
137: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
138: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
139: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
140: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
141: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
142: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
143: STATUS =decode(x_STATUS, NULL,STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
136: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
137: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
138: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
139: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
140: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
141: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
142: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
143: STATUS =decode(x_STATUS, NULL,STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
144: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
137: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
138: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
139: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
140: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
141: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
142: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
143: STATUS =decode(x_STATUS, NULL,STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
144: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
145: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
138: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
139: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
140: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
141: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
142: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
143: STATUS =decode(x_STATUS, NULL,STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
144: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
145: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
146: APPLICATION_ID=HZ_UTILITY_V2PUB.APPLICATION_ID
142: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
143: STATUS =decode(x_STATUS, NULL,STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
144: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
145: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
146: APPLICATION_ID=HZ_UTILITY_V2PUB.APPLICATION_ID
147: where rowid = X_RowId;
148:
149: If (SQL%NOTFOUND) then
150: RAISE NO_DATA_FOUND;