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