292: CLOSE C;
293:
294:
295: SELECT decode(p_calc_ext_table_id,
296: fnd_api.g_miss_num, oldrow.calc_ext_table_id,
297: p_calc_ext_table_id),
298: decode(p_name,
299: fnd_api.g_miss_char, oldrow.name,
300: p_name),
295: SELECT decode(p_calc_ext_table_id,
296: fnd_api.g_miss_num, oldrow.calc_ext_table_id,
297: p_calc_ext_table_id),
298: decode(p_name,
299: fnd_api.g_miss_char, oldrow.name,
300: p_name),
301: decode(p_description,
302: fnd_api.g_miss_char, oldrow.description,
303: p_description),
298: decode(p_name,
299: fnd_api.g_miss_char, oldrow.name,
300: p_name),
301: decode(p_description,
302: fnd_api.g_miss_char, oldrow.description,
303: p_description),
304: decode(p_internal_table_id,
305: fnd_api.g_miss_num, oldrow.internal_table_id,
306: p_internal_table_id),
301: decode(p_description,
302: fnd_api.g_miss_char, oldrow.description,
303: p_description),
304: decode(p_internal_table_id,
305: fnd_api.g_miss_num, oldrow.internal_table_id,
306: p_internal_table_id),
307: decode(p_external_table_id,
308: fnd_api.g_miss_num, oldrow.external_table_id,
309: p_external_table_id),
304: decode(p_internal_table_id,
305: fnd_api.g_miss_num, oldrow.internal_table_id,
306: p_internal_table_id),
307: decode(p_external_table_id,
308: fnd_api.g_miss_num, oldrow.external_table_id,
309: p_external_table_id),
310: decode(p_used_flag,
311: fnd_api.g_miss_char, oldrow.used_flag,
312: p_used_flag),
307: decode(p_external_table_id,
308: fnd_api.g_miss_num, oldrow.external_table_id,
309: p_external_table_id),
310: decode(p_used_flag,
311: fnd_api.g_miss_char, oldrow.used_flag,
312: p_used_flag),
313: decode(p_schema,
314: fnd_api.g_miss_char, oldrow.schema,
315: p_schema),
310: decode(p_used_flag,
311: fnd_api.g_miss_char, oldrow.used_flag,
312: p_used_flag),
313: decode(p_schema,
314: fnd_api.g_miss_char, oldrow.schema,
315: p_schema),
316: decode(p_external_table_name,
317: fnd_api.g_miss_char, oldrow.external_table_name,
318: p_external_table_name),
313: decode(p_schema,
314: fnd_api.g_miss_char, oldrow.schema,
315: p_schema),
316: decode(p_external_table_name,
317: fnd_api.g_miss_char, oldrow.external_table_name,
318: p_external_table_name),
319: decode(p_alias,
320: fnd_api.g_miss_char, oldrow.alias,
321: p_alias),
316: decode(p_external_table_name,
317: fnd_api.g_miss_char, oldrow.external_table_name,
318: p_external_table_name),
319: decode(p_alias,
320: fnd_api.g_miss_char, oldrow.alias,
321: p_alias),
322: decode(p_attribute_category,
323: fnd_api.g_miss_char, oldrow.attribute_category,
324: p_attribute_category),
319: decode(p_alias,
320: fnd_api.g_miss_char, oldrow.alias,
321: p_alias),
322: decode(p_attribute_category,
323: fnd_api.g_miss_char, oldrow.attribute_category,
324: p_attribute_category),
325: decode(p_attribute1,
326: fnd_api.g_miss_char, oldrow.attribute1,
327: p_attribute1),
322: decode(p_attribute_category,
323: fnd_api.g_miss_char, oldrow.attribute_category,
324: p_attribute_category),
325: decode(p_attribute1,
326: fnd_api.g_miss_char, oldrow.attribute1,
327: p_attribute1),
328: decode(p_attribute2,
329: fnd_api.g_miss_char, oldrow.attribute2,
330: p_attribute2),
325: decode(p_attribute1,
326: fnd_api.g_miss_char, oldrow.attribute1,
327: p_attribute1),
328: decode(p_attribute2,
329: fnd_api.g_miss_char, oldrow.attribute2,
330: p_attribute2),
331: decode(p_attribute3,
332: fnd_api.g_miss_char, oldrow.attribute3,
333: p_attribute3),
328: decode(p_attribute2,
329: fnd_api.g_miss_char, oldrow.attribute2,
330: p_attribute2),
331: decode(p_attribute3,
332: fnd_api.g_miss_char, oldrow.attribute3,
333: p_attribute3),
334: decode(p_attribute4,
335: fnd_api.g_miss_char, oldrow.attribute4,
336: p_attribute4),
331: decode(p_attribute3,
332: fnd_api.g_miss_char, oldrow.attribute3,
333: p_attribute3),
334: decode(p_attribute4,
335: fnd_api.g_miss_char, oldrow.attribute4,
336: p_attribute4),
337: decode(p_attribute5,
338: fnd_api.g_miss_char, oldrow.attribute5,
339: p_attribute5),
334: decode(p_attribute4,
335: fnd_api.g_miss_char, oldrow.attribute4,
336: p_attribute4),
337: decode(p_attribute5,
338: fnd_api.g_miss_char, oldrow.attribute5,
339: p_attribute5),
340: decode(p_attribute6,
341: fnd_api.g_miss_char, oldrow.attribute6,
342: p_attribute6),
337: decode(p_attribute5,
338: fnd_api.g_miss_char, oldrow.attribute5,
339: p_attribute5),
340: decode(p_attribute6,
341: fnd_api.g_miss_char, oldrow.attribute6,
342: p_attribute6),
343: decode(p_attribute7,
344: fnd_api.g_miss_char, oldrow.attribute7,
345: p_attribute7),
340: decode(p_attribute6,
341: fnd_api.g_miss_char, oldrow.attribute6,
342: p_attribute6),
343: decode(p_attribute7,
344: fnd_api.g_miss_char, oldrow.attribute7,
345: p_attribute7),
346: decode(p_attribute8,
347: fnd_api.g_miss_char, oldrow.attribute8,
348: p_attribute8),
343: decode(p_attribute7,
344: fnd_api.g_miss_char, oldrow.attribute7,
345: p_attribute7),
346: decode(p_attribute8,
347: fnd_api.g_miss_char, oldrow.attribute8,
348: p_attribute8),
349: decode(p_attribute9,
350: fnd_api.g_miss_char, oldrow.attribute9,
351: p_attribute9),
346: decode(p_attribute8,
347: fnd_api.g_miss_char, oldrow.attribute8,
348: p_attribute8),
349: decode(p_attribute9,
350: fnd_api.g_miss_char, oldrow.attribute9,
351: p_attribute9),
352: decode(p_attribute10,
353: fnd_api.g_miss_char, oldrow.attribute10,
354: p_attribute10),
349: decode(p_attribute9,
350: fnd_api.g_miss_char, oldrow.attribute9,
351: p_attribute9),
352: decode(p_attribute10,
353: fnd_api.g_miss_char, oldrow.attribute10,
354: p_attribute10),
355: decode(p_attribute11,
356: fnd_api.g_miss_char, oldrow.attribute11,
357: p_attribute11),
352: decode(p_attribute10,
353: fnd_api.g_miss_char, oldrow.attribute10,
354: p_attribute10),
355: decode(p_attribute11,
356: fnd_api.g_miss_char, oldrow.attribute11,
357: p_attribute11),
358: decode(p_attribute12,
359: fnd_api.g_miss_char, oldrow.attribute12,
360: p_attribute12),
355: decode(p_attribute11,
356: fnd_api.g_miss_char, oldrow.attribute11,
357: p_attribute11),
358: decode(p_attribute12,
359: fnd_api.g_miss_char, oldrow.attribute12,
360: p_attribute12),
361: decode(p_attribute13,
362: fnd_api.g_miss_char, oldrow.attribute13,
363: p_attribute13),
358: decode(p_attribute12,
359: fnd_api.g_miss_char, oldrow.attribute12,
360: p_attribute12),
361: decode(p_attribute13,
362: fnd_api.g_miss_char, oldrow.attribute13,
363: p_attribute13),
364: decode(p_attribute14,
365: fnd_api.g_miss_char, oldrow.attribute14,
366: p_attribute14),
361: decode(p_attribute13,
362: fnd_api.g_miss_char, oldrow.attribute13,
363: p_attribute13),
364: decode(p_attribute14,
365: fnd_api.g_miss_char, oldrow.attribute14,
366: p_attribute14),
367: decode(p_attribute15,
368: fnd_api.g_miss_char, oldrow.attribute15,
369: p_attribute15)
364: decode(p_attribute14,
365: fnd_api.g_miss_char, oldrow.attribute14,
366: p_attribute14),
367: decode(p_attribute15,
368: fnd_api.g_miss_char, oldrow.attribute15,
369: p_attribute15)
370: INTO
371: l_calc_ext_table_id,
372: l_name ,