32: END IF;
33:
34: SELECT
35: Decode(x_new_rec.attribute_category,
36: fnd_api.g_miss_char, NULL,
37: x_new_rec.attribute_category),
38: Decode(x_new_rec.attribute1,
39: fnd_api.g_miss_char, NULL,
40: x_new_rec.attribute1),
35: Decode(x_new_rec.attribute_category,
36: fnd_api.g_miss_char, NULL,
37: x_new_rec.attribute_category),
38: Decode(x_new_rec.attribute1,
39: fnd_api.g_miss_char, NULL,
40: x_new_rec.attribute1),
41: Decode(x_new_rec.attribute2,
42: fnd_api.g_miss_char, NULL,
43: x_new_rec.attribute2),
38: Decode(x_new_rec.attribute1,
39: fnd_api.g_miss_char, NULL,
40: x_new_rec.attribute1),
41: Decode(x_new_rec.attribute2,
42: fnd_api.g_miss_char, NULL,
43: x_new_rec.attribute2),
44: Decode(x_new_rec.attribute3,
45: fnd_api.g_miss_char, NULL,
46: x_new_rec.attribute3),
41: Decode(x_new_rec.attribute2,
42: fnd_api.g_miss_char, NULL,
43: x_new_rec.attribute2),
44: Decode(x_new_rec.attribute3,
45: fnd_api.g_miss_char, NULL,
46: x_new_rec.attribute3),
47: Decode(x_new_rec.attribute4,
48: fnd_api.g_miss_char, NULL,
49: x_new_rec.attribute4),
44: Decode(x_new_rec.attribute3,
45: fnd_api.g_miss_char, NULL,
46: x_new_rec.attribute3),
47: Decode(x_new_rec.attribute4,
48: fnd_api.g_miss_char, NULL,
49: x_new_rec.attribute4),
50: Decode(x_new_rec.attribute5,
51: fnd_api.g_miss_char, NULL,
52: x_new_rec.attribute5),
47: Decode(x_new_rec.attribute4,
48: fnd_api.g_miss_char, NULL,
49: x_new_rec.attribute4),
50: Decode(x_new_rec.attribute5,
51: fnd_api.g_miss_char, NULL,
52: x_new_rec.attribute5),
53: Decode(x_new_rec.attribute6,
54: fnd_api.g_miss_char, NULL,
55: x_new_rec.attribute6),
50: Decode(x_new_rec.attribute5,
51: fnd_api.g_miss_char, NULL,
52: x_new_rec.attribute5),
53: Decode(x_new_rec.attribute6,
54: fnd_api.g_miss_char, NULL,
55: x_new_rec.attribute6),
56: Decode(x_new_rec.attribute7,
57: fnd_api.g_miss_char, NULL,
58: x_new_rec.attribute7),
53: Decode(x_new_rec.attribute6,
54: fnd_api.g_miss_char, NULL,
55: x_new_rec.attribute6),
56: Decode(x_new_rec.attribute7,
57: fnd_api.g_miss_char, NULL,
58: x_new_rec.attribute7),
59: Decode(x_new_rec.attribute8,
60: fnd_api.g_miss_char, NULL,
61: x_new_rec.attribute8),
56: Decode(x_new_rec.attribute7,
57: fnd_api.g_miss_char, NULL,
58: x_new_rec.attribute7),
59: Decode(x_new_rec.attribute8,
60: fnd_api.g_miss_char, NULL,
61: x_new_rec.attribute8),
62: Decode(x_new_rec.attribute9,
63: fnd_api.g_miss_char, NULL,
64: x_new_rec.attribute9),
59: Decode(x_new_rec.attribute8,
60: fnd_api.g_miss_char, NULL,
61: x_new_rec.attribute8),
62: Decode(x_new_rec.attribute9,
63: fnd_api.g_miss_char, NULL,
64: x_new_rec.attribute9),
65: Decode(x_new_rec.attribute10,
66: fnd_api.g_miss_char, NULL,
67: x_new_rec.attribute10),
62: Decode(x_new_rec.attribute9,
63: fnd_api.g_miss_char, NULL,
64: x_new_rec.attribute9),
65: Decode(x_new_rec.attribute10,
66: fnd_api.g_miss_char, NULL,
67: x_new_rec.attribute10),
68: Decode(x_new_rec.attribute11,
69: fnd_api.g_miss_char, NULL,
70: x_new_rec.attribute11),
65: Decode(x_new_rec.attribute10,
66: fnd_api.g_miss_char, NULL,
67: x_new_rec.attribute10),
68: Decode(x_new_rec.attribute11,
69: fnd_api.g_miss_char, NULL,
70: x_new_rec.attribute11),
71: Decode(x_new_rec.attribute12,
72: fnd_api.g_miss_char, NULL,
73: x_new_rec.attribute12),
68: Decode(x_new_rec.attribute11,
69: fnd_api.g_miss_char, NULL,
70: x_new_rec.attribute11),
71: Decode(x_new_rec.attribute12,
72: fnd_api.g_miss_char, NULL,
73: x_new_rec.attribute12),
74: Decode(x_new_rec.attribute13,
75: fnd_api.g_miss_char, NULL,
76: x_new_rec.attribute13),
71: Decode(x_new_rec.attribute12,
72: fnd_api.g_miss_char, NULL,
73: x_new_rec.attribute12),
74: Decode(x_new_rec.attribute13,
75: fnd_api.g_miss_char, NULL,
76: x_new_rec.attribute13),
77: Decode(x_new_rec.attribute14,
78: fnd_api.g_miss_char, NULL,
79: x_new_rec.attribute14),
74: Decode(x_new_rec.attribute13,
75: fnd_api.g_miss_char, NULL,
76: x_new_rec.attribute13),
77: Decode(x_new_rec.attribute14,
78: fnd_api.g_miss_char, NULL,
79: x_new_rec.attribute14),
80: Decode(x_new_rec.attribute15,
81: fnd_api.g_miss_char, NULL,
82: x_new_rec.attribute15),
77: Decode(x_new_rec.attribute14,
78: fnd_api.g_miss_char, NULL,
79: x_new_rec.attribute14),
80: Decode(x_new_rec.attribute15,
81: fnd_api.g_miss_char, NULL,
82: x_new_rec.attribute15),
83: Decode(x_new_rec.created_by,
84: cn_api.g_miss_id, g_created_by,
85: x_new_rec.created_by),
83: Decode(x_new_rec.created_by,
84: cn_api.g_miss_id, g_created_by,
85: x_new_rec.created_by),
86: Decode(x_new_rec.creation_date,
87: fnd_api.g_miss_date, g_creation_date,
88: x_new_rec.creation_date),
89: Decode(x_new_rec.last_update_login,
90: cn_api.g_miss_id, g_last_update_login,
91: x_new_rec.last_update_login),
89: Decode(x_new_rec.last_update_login,
90: cn_api.g_miss_id, g_last_update_login,
91: x_new_rec.last_update_login),
92: Decode(x_new_rec.last_update_date,
93: fnd_api.g_miss_date, g_last_update_date,
94: x_new_rec.last_update_date),
95: Decode(x_new_rec.last_updated_by,
96: cn_api.g_miss_id, g_last_updated_by,
97: x_new_rec.last_updated_by)
204: Decode(x_new_rec.profile_user_id,
205: cn_api.g_miss_id, rec.profile_user_id,
206: x_new_rec.profile_user_id),
207: Decode(x_new_rec.attribute_category,
208: fnd_api.g_miss_char, rec.attribute_category,
209: x_new_rec.attribute_category),
210: Decode(x_new_rec.attribute1,
211: fnd_api.g_miss_char, rec.attribute1,
212: x_new_rec.attribute1),
207: Decode(x_new_rec.attribute_category,
208: fnd_api.g_miss_char, rec.attribute_category,
209: x_new_rec.attribute_category),
210: Decode(x_new_rec.attribute1,
211: fnd_api.g_miss_char, rec.attribute1,
212: x_new_rec.attribute1),
213: Decode(x_new_rec.attribute2,
214: fnd_api.g_miss_char, rec.attribute2,
215: x_new_rec.attribute2),
210: Decode(x_new_rec.attribute1,
211: fnd_api.g_miss_char, rec.attribute1,
212: x_new_rec.attribute1),
213: Decode(x_new_rec.attribute2,
214: fnd_api.g_miss_char, rec.attribute2,
215: x_new_rec.attribute2),
216: Decode(x_new_rec.attribute3,
217: fnd_api.g_miss_char, rec.attribute3,
218: x_new_rec.attribute3),
213: Decode(x_new_rec.attribute2,
214: fnd_api.g_miss_char, rec.attribute2,
215: x_new_rec.attribute2),
216: Decode(x_new_rec.attribute3,
217: fnd_api.g_miss_char, rec.attribute3,
218: x_new_rec.attribute3),
219: Decode(x_new_rec.attribute4,
220: fnd_api.g_miss_char, rec.attribute4,
221: x_new_rec.attribute4),
216: Decode(x_new_rec.attribute3,
217: fnd_api.g_miss_char, rec.attribute3,
218: x_new_rec.attribute3),
219: Decode(x_new_rec.attribute4,
220: fnd_api.g_miss_char, rec.attribute4,
221: x_new_rec.attribute4),
222: Decode(x_new_rec.attribute5,
223: fnd_api.g_miss_char, rec.attribute5,
224: x_new_rec.attribute5),
219: Decode(x_new_rec.attribute4,
220: fnd_api.g_miss_char, rec.attribute4,
221: x_new_rec.attribute4),
222: Decode(x_new_rec.attribute5,
223: fnd_api.g_miss_char, rec.attribute5,
224: x_new_rec.attribute5),
225: Decode(x_new_rec.attribute6,
226: fnd_api.g_miss_char, rec.attribute6,
227: x_new_rec.attribute6),
222: Decode(x_new_rec.attribute5,
223: fnd_api.g_miss_char, rec.attribute5,
224: x_new_rec.attribute5),
225: Decode(x_new_rec.attribute6,
226: fnd_api.g_miss_char, rec.attribute6,
227: x_new_rec.attribute6),
228: Decode(x_new_rec.attribute7,
229: fnd_api.g_miss_char, rec.attribute7,
230: x_new_rec.attribute7),
225: Decode(x_new_rec.attribute6,
226: fnd_api.g_miss_char, rec.attribute6,
227: x_new_rec.attribute6),
228: Decode(x_new_rec.attribute7,
229: fnd_api.g_miss_char, rec.attribute7,
230: x_new_rec.attribute7),
231: Decode(x_new_rec.attribute8,
232: fnd_api.g_miss_char, rec.attribute8,
233: x_new_rec.attribute8),
228: Decode(x_new_rec.attribute7,
229: fnd_api.g_miss_char, rec.attribute7,
230: x_new_rec.attribute7),
231: Decode(x_new_rec.attribute8,
232: fnd_api.g_miss_char, rec.attribute8,
233: x_new_rec.attribute8),
234: Decode(x_new_rec.attribute9,
235: fnd_api.g_miss_char, rec.attribute9,
236: x_new_rec.attribute9),
231: Decode(x_new_rec.attribute8,
232: fnd_api.g_miss_char, rec.attribute8,
233: x_new_rec.attribute8),
234: Decode(x_new_rec.attribute9,
235: fnd_api.g_miss_char, rec.attribute9,
236: x_new_rec.attribute9),
237: Decode(x_new_rec.attribute10,
238: fnd_api.g_miss_char, rec.attribute10,
239: x_new_rec.attribute10),
234: Decode(x_new_rec.attribute9,
235: fnd_api.g_miss_char, rec.attribute9,
236: x_new_rec.attribute9),
237: Decode(x_new_rec.attribute10,
238: fnd_api.g_miss_char, rec.attribute10,
239: x_new_rec.attribute10),
240: Decode(x_new_rec.attribute11,
241: fnd_api.g_miss_char, rec.attribute11,
242: x_new_rec.attribute11),
237: Decode(x_new_rec.attribute10,
238: fnd_api.g_miss_char, rec.attribute10,
239: x_new_rec.attribute10),
240: Decode(x_new_rec.attribute11,
241: fnd_api.g_miss_char, rec.attribute11,
242: x_new_rec.attribute11),
243: Decode(x_new_rec.attribute12,
244: fnd_api.g_miss_char, rec.attribute12,
245: x_new_rec.attribute12),
240: Decode(x_new_rec.attribute11,
241: fnd_api.g_miss_char, rec.attribute11,
242: x_new_rec.attribute11),
243: Decode(x_new_rec.attribute12,
244: fnd_api.g_miss_char, rec.attribute12,
245: x_new_rec.attribute12),
246: Decode(x_new_rec.attribute13,
247: fnd_api.g_miss_char, rec.attribute13,
248: x_new_rec.attribute13),
243: Decode(x_new_rec.attribute12,
244: fnd_api.g_miss_char, rec.attribute12,
245: x_new_rec.attribute12),
246: Decode(x_new_rec.attribute13,
247: fnd_api.g_miss_char, rec.attribute13,
248: x_new_rec.attribute13),
249: Decode(x_new_rec.attribute14,
250: fnd_api.g_miss_char, rec.attribute14,
251: x_new_rec.attribute14),
246: Decode(x_new_rec.attribute13,
247: fnd_api.g_miss_char, rec.attribute13,
248: x_new_rec.attribute13),
249: Decode(x_new_rec.attribute14,
250: fnd_api.g_miss_char, rec.attribute14,
251: x_new_rec.attribute14),
252: Decode(x_new_rec.attribute15,
253: fnd_api.g_miss_char, rec.attribute15,
254: x_new_rec.attribute15),
249: Decode(x_new_rec.attribute14,
250: fnd_api.g_miss_char, rec.attribute14,
251: x_new_rec.attribute14),
252: Decode(x_new_rec.attribute15,
253: fnd_api.g_miss_char, rec.attribute15,
254: x_new_rec.attribute15),
255: Decode(x_new_rec.last_update_login,
256: cn_api.g_miss_id, g_last_update_login,
257: x_new_rec.last_update_login),
255: Decode(x_new_rec.last_update_login,
256: cn_api.g_miss_id, g_last_update_login,
257: x_new_rec.last_update_login),
258: Decode(x_new_rec.last_update_date,
259: fnd_api.g_miss_date, g_last_update_date,
260: x_new_rec.last_update_date),
261: Decode(x_new_rec.last_updated_by,
262: cn_api.g_miss_id, g_last_updated_by,
263: x_new_rec.last_updated_by)