eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_CALC_EXT_TABLE_PKG dependencies on CN_CALC_EXT_TABLES

Line 37: SELECT cn_calc_ext_tables_s.nextval

33: PROCEDURE Get_UID( x_calc_ext_table_id IN OUT NOCOPY NUMBER) IS
34:
35: BEGIN
36:
37: SELECT cn_calc_ext_tables_s.nextval
38: INTO X_calc_ext_table_id
39: FROM dual;
40:
41: END Get_UID;

Line 87: INSERT INTO cn_calc_ext_tables

83: BEGIN
84:
85: Get_UID( x_calc_ext_table_id );
86:
87: INSERT INTO cn_calc_ext_tables
88: ( calc_ext_table_id
89: ,name
90: ,DESCRIPTION
91: ,INTERNAL_TABLE_ID

Line 151: select 1 INTO l_dummy from CN_CALC_EXT_TABLES

147: ,p_Last_Update_Date
148: ,p_Last_Update_Login
149: );
150:
151: select 1 INTO l_dummy from CN_CALC_EXT_TABLES
152: where calc_ext_table_id = x_calc_ext_table_id;
153:
154: END Insert_row;
155:

Line 193: FROM cn_calc_ext_tables

189: ) IS
190:
191: CURSOR C IS
192: SELECT *
193: FROM cn_calc_ext_tables
194: WHERE calc_ext_table_id = p_calc_ext_table_id
195: FOR UPDATE of calc_ext_table_id NOWAIT;
196:
197: tlinfo C%ROWTYPE;

Line 250: l_calc_ext_table_id cn_calc_ext_tables.calc_ext_table_id%TYPE;

246: ,p_Last_Update_Date DATE
247: ,p_Last_Update_Login NUMBER ) IS
248:
249:
250: l_calc_ext_table_id cn_calc_ext_tables.calc_ext_table_id%TYPE;
251: l_name cn_calc_ext_tables.name%TYPE;
252: l_description cn_calc_ext_tables.description%TYPE;
253: l_internal_table_id cn_calc_ext_tables.internal_table_id%TYPE;
254: l_external_table_id cn_calc_ext_tables.external_table_id%TYPE;

Line 251: l_name cn_calc_ext_tables.name%TYPE;

247: ,p_Last_Update_Login NUMBER ) IS
248:
249:
250: l_calc_ext_table_id cn_calc_ext_tables.calc_ext_table_id%TYPE;
251: l_name cn_calc_ext_tables.name%TYPE;
252: l_description cn_calc_ext_tables.description%TYPE;
253: l_internal_table_id cn_calc_ext_tables.internal_table_id%TYPE;
254: l_external_table_id cn_calc_ext_tables.external_table_id%TYPE;
255: l_USED_FLAG cn_calc_ext_tables.used_flag%TYPE;

Line 252: l_description cn_calc_ext_tables.description%TYPE;

248:
249:
250: l_calc_ext_table_id cn_calc_ext_tables.calc_ext_table_id%TYPE;
251: l_name cn_calc_ext_tables.name%TYPE;
252: l_description cn_calc_ext_tables.description%TYPE;
253: l_internal_table_id cn_calc_ext_tables.internal_table_id%TYPE;
254: l_external_table_id cn_calc_ext_tables.external_table_id%TYPE;
255: l_USED_FLAG cn_calc_ext_tables.used_flag%TYPE;
256: l_SCHEMA cn_calc_ext_tables.schema%TYPE;

Line 253: l_internal_table_id cn_calc_ext_tables.internal_table_id%TYPE;

249:
250: l_calc_ext_table_id cn_calc_ext_tables.calc_ext_table_id%TYPE;
251: l_name cn_calc_ext_tables.name%TYPE;
252: l_description cn_calc_ext_tables.description%TYPE;
253: l_internal_table_id cn_calc_ext_tables.internal_table_id%TYPE;
254: l_external_table_id cn_calc_ext_tables.external_table_id%TYPE;
255: l_USED_FLAG cn_calc_ext_tables.used_flag%TYPE;
256: l_SCHEMA cn_calc_ext_tables.schema%TYPE;
257: l_EXTERNAL_TABLE_NAME cn_calc_ext_tables.external_table_name%TYPE;

Line 254: l_external_table_id cn_calc_ext_tables.external_table_id%TYPE;

250: l_calc_ext_table_id cn_calc_ext_tables.calc_ext_table_id%TYPE;
251: l_name cn_calc_ext_tables.name%TYPE;
252: l_description cn_calc_ext_tables.description%TYPE;
253: l_internal_table_id cn_calc_ext_tables.internal_table_id%TYPE;
254: l_external_table_id cn_calc_ext_tables.external_table_id%TYPE;
255: l_USED_FLAG cn_calc_ext_tables.used_flag%TYPE;
256: l_SCHEMA cn_calc_ext_tables.schema%TYPE;
257: l_EXTERNAL_TABLE_NAME cn_calc_ext_tables.external_table_name%TYPE;
258: l_ALIAS cn_calc_ext_tables.alias%TYPE;

Line 255: l_USED_FLAG cn_calc_ext_tables.used_flag%TYPE;

251: l_name cn_calc_ext_tables.name%TYPE;
252: l_description cn_calc_ext_tables.description%TYPE;
253: l_internal_table_id cn_calc_ext_tables.internal_table_id%TYPE;
254: l_external_table_id cn_calc_ext_tables.external_table_id%TYPE;
255: l_USED_FLAG cn_calc_ext_tables.used_flag%TYPE;
256: l_SCHEMA cn_calc_ext_tables.schema%TYPE;
257: l_EXTERNAL_TABLE_NAME cn_calc_ext_tables.external_table_name%TYPE;
258: l_ALIAS cn_calc_ext_tables.alias%TYPE;
259: l_attribute_category cn_calc_ext_tables.attribute_category%TYPE;

Line 256: l_SCHEMA cn_calc_ext_tables.schema%TYPE;

252: l_description cn_calc_ext_tables.description%TYPE;
253: l_internal_table_id cn_calc_ext_tables.internal_table_id%TYPE;
254: l_external_table_id cn_calc_ext_tables.external_table_id%TYPE;
255: l_USED_FLAG cn_calc_ext_tables.used_flag%TYPE;
256: l_SCHEMA cn_calc_ext_tables.schema%TYPE;
257: l_EXTERNAL_TABLE_NAME cn_calc_ext_tables.external_table_name%TYPE;
258: l_ALIAS cn_calc_ext_tables.alias%TYPE;
259: l_attribute_category cn_calc_ext_tables.attribute_category%TYPE;
260: l_attribute1 cn_calc_ext_tables.attribute1%TYPE;

Line 257: l_EXTERNAL_TABLE_NAME cn_calc_ext_tables.external_table_name%TYPE;

253: l_internal_table_id cn_calc_ext_tables.internal_table_id%TYPE;
254: l_external_table_id cn_calc_ext_tables.external_table_id%TYPE;
255: l_USED_FLAG cn_calc_ext_tables.used_flag%TYPE;
256: l_SCHEMA cn_calc_ext_tables.schema%TYPE;
257: l_EXTERNAL_TABLE_NAME cn_calc_ext_tables.external_table_name%TYPE;
258: l_ALIAS cn_calc_ext_tables.alias%TYPE;
259: l_attribute_category cn_calc_ext_tables.attribute_category%TYPE;
260: l_attribute1 cn_calc_ext_tables.attribute1%TYPE;
261: l_attribute2 cn_calc_ext_tables.attribute2%TYPE;

Line 258: l_ALIAS cn_calc_ext_tables.alias%TYPE;

254: l_external_table_id cn_calc_ext_tables.external_table_id%TYPE;
255: l_USED_FLAG cn_calc_ext_tables.used_flag%TYPE;
256: l_SCHEMA cn_calc_ext_tables.schema%TYPE;
257: l_EXTERNAL_TABLE_NAME cn_calc_ext_tables.external_table_name%TYPE;
258: l_ALIAS cn_calc_ext_tables.alias%TYPE;
259: l_attribute_category cn_calc_ext_tables.attribute_category%TYPE;
260: l_attribute1 cn_calc_ext_tables.attribute1%TYPE;
261: l_attribute2 cn_calc_ext_tables.attribute2%TYPE;
262: l_attribute3 cn_calc_ext_tables.attribute3%TYPE;

Line 259: l_attribute_category cn_calc_ext_tables.attribute_category%TYPE;

255: l_USED_FLAG cn_calc_ext_tables.used_flag%TYPE;
256: l_SCHEMA cn_calc_ext_tables.schema%TYPE;
257: l_EXTERNAL_TABLE_NAME cn_calc_ext_tables.external_table_name%TYPE;
258: l_ALIAS cn_calc_ext_tables.alias%TYPE;
259: l_attribute_category cn_calc_ext_tables.attribute_category%TYPE;
260: l_attribute1 cn_calc_ext_tables.attribute1%TYPE;
261: l_attribute2 cn_calc_ext_tables.attribute2%TYPE;
262: l_attribute3 cn_calc_ext_tables.attribute3%TYPE;
263: l_attribute4 cn_calc_ext_tables.attribute4%TYPE;

Line 260: l_attribute1 cn_calc_ext_tables.attribute1%TYPE;

256: l_SCHEMA cn_calc_ext_tables.schema%TYPE;
257: l_EXTERNAL_TABLE_NAME cn_calc_ext_tables.external_table_name%TYPE;
258: l_ALIAS cn_calc_ext_tables.alias%TYPE;
259: l_attribute_category cn_calc_ext_tables.attribute_category%TYPE;
260: l_attribute1 cn_calc_ext_tables.attribute1%TYPE;
261: l_attribute2 cn_calc_ext_tables.attribute2%TYPE;
262: l_attribute3 cn_calc_ext_tables.attribute3%TYPE;
263: l_attribute4 cn_calc_ext_tables.attribute4%TYPE;
264: l_attribute5 cn_calc_ext_tables.attribute5%TYPE;

Line 261: l_attribute2 cn_calc_ext_tables.attribute2%TYPE;

257: l_EXTERNAL_TABLE_NAME cn_calc_ext_tables.external_table_name%TYPE;
258: l_ALIAS cn_calc_ext_tables.alias%TYPE;
259: l_attribute_category cn_calc_ext_tables.attribute_category%TYPE;
260: l_attribute1 cn_calc_ext_tables.attribute1%TYPE;
261: l_attribute2 cn_calc_ext_tables.attribute2%TYPE;
262: l_attribute3 cn_calc_ext_tables.attribute3%TYPE;
263: l_attribute4 cn_calc_ext_tables.attribute4%TYPE;
264: l_attribute5 cn_calc_ext_tables.attribute5%TYPE;
265: l_attribute6 cn_calc_ext_tables.attribute6%TYPE;

Line 262: l_attribute3 cn_calc_ext_tables.attribute3%TYPE;

258: l_ALIAS cn_calc_ext_tables.alias%TYPE;
259: l_attribute_category cn_calc_ext_tables.attribute_category%TYPE;
260: l_attribute1 cn_calc_ext_tables.attribute1%TYPE;
261: l_attribute2 cn_calc_ext_tables.attribute2%TYPE;
262: l_attribute3 cn_calc_ext_tables.attribute3%TYPE;
263: l_attribute4 cn_calc_ext_tables.attribute4%TYPE;
264: l_attribute5 cn_calc_ext_tables.attribute5%TYPE;
265: l_attribute6 cn_calc_ext_tables.attribute6%TYPE;
266: l_attribute7 cn_calc_ext_tables.attribute7%TYPE;

Line 263: l_attribute4 cn_calc_ext_tables.attribute4%TYPE;

259: l_attribute_category cn_calc_ext_tables.attribute_category%TYPE;
260: l_attribute1 cn_calc_ext_tables.attribute1%TYPE;
261: l_attribute2 cn_calc_ext_tables.attribute2%TYPE;
262: l_attribute3 cn_calc_ext_tables.attribute3%TYPE;
263: l_attribute4 cn_calc_ext_tables.attribute4%TYPE;
264: l_attribute5 cn_calc_ext_tables.attribute5%TYPE;
265: l_attribute6 cn_calc_ext_tables.attribute6%TYPE;
266: l_attribute7 cn_calc_ext_tables.attribute7%TYPE;
267: l_attribute8 cn_calc_ext_tables.attribute8%TYPE;

Line 264: l_attribute5 cn_calc_ext_tables.attribute5%TYPE;

260: l_attribute1 cn_calc_ext_tables.attribute1%TYPE;
261: l_attribute2 cn_calc_ext_tables.attribute2%TYPE;
262: l_attribute3 cn_calc_ext_tables.attribute3%TYPE;
263: l_attribute4 cn_calc_ext_tables.attribute4%TYPE;
264: l_attribute5 cn_calc_ext_tables.attribute5%TYPE;
265: l_attribute6 cn_calc_ext_tables.attribute6%TYPE;
266: l_attribute7 cn_calc_ext_tables.attribute7%TYPE;
267: l_attribute8 cn_calc_ext_tables.attribute8%TYPE;
268: l_attribute9 cn_calc_ext_tables.attribute9%TYPE;

Line 265: l_attribute6 cn_calc_ext_tables.attribute6%TYPE;

261: l_attribute2 cn_calc_ext_tables.attribute2%TYPE;
262: l_attribute3 cn_calc_ext_tables.attribute3%TYPE;
263: l_attribute4 cn_calc_ext_tables.attribute4%TYPE;
264: l_attribute5 cn_calc_ext_tables.attribute5%TYPE;
265: l_attribute6 cn_calc_ext_tables.attribute6%TYPE;
266: l_attribute7 cn_calc_ext_tables.attribute7%TYPE;
267: l_attribute8 cn_calc_ext_tables.attribute8%TYPE;
268: l_attribute9 cn_calc_ext_tables.attribute9%TYPE;
269: l_attribute10 cn_calc_ext_tables.attribute10%TYPE;

Line 266: l_attribute7 cn_calc_ext_tables.attribute7%TYPE;

262: l_attribute3 cn_calc_ext_tables.attribute3%TYPE;
263: l_attribute4 cn_calc_ext_tables.attribute4%TYPE;
264: l_attribute5 cn_calc_ext_tables.attribute5%TYPE;
265: l_attribute6 cn_calc_ext_tables.attribute6%TYPE;
266: l_attribute7 cn_calc_ext_tables.attribute7%TYPE;
267: l_attribute8 cn_calc_ext_tables.attribute8%TYPE;
268: l_attribute9 cn_calc_ext_tables.attribute9%TYPE;
269: l_attribute10 cn_calc_ext_tables.attribute10%TYPE;
270: l_attribute11 cn_calc_ext_tables.attribute11%TYPE;

Line 267: l_attribute8 cn_calc_ext_tables.attribute8%TYPE;

263: l_attribute4 cn_calc_ext_tables.attribute4%TYPE;
264: l_attribute5 cn_calc_ext_tables.attribute5%TYPE;
265: l_attribute6 cn_calc_ext_tables.attribute6%TYPE;
266: l_attribute7 cn_calc_ext_tables.attribute7%TYPE;
267: l_attribute8 cn_calc_ext_tables.attribute8%TYPE;
268: l_attribute9 cn_calc_ext_tables.attribute9%TYPE;
269: l_attribute10 cn_calc_ext_tables.attribute10%TYPE;
270: l_attribute11 cn_calc_ext_tables.attribute11%TYPE;
271: l_attribute12 cn_calc_ext_tables.attribute12%TYPE;

Line 268: l_attribute9 cn_calc_ext_tables.attribute9%TYPE;

264: l_attribute5 cn_calc_ext_tables.attribute5%TYPE;
265: l_attribute6 cn_calc_ext_tables.attribute6%TYPE;
266: l_attribute7 cn_calc_ext_tables.attribute7%TYPE;
267: l_attribute8 cn_calc_ext_tables.attribute8%TYPE;
268: l_attribute9 cn_calc_ext_tables.attribute9%TYPE;
269: l_attribute10 cn_calc_ext_tables.attribute10%TYPE;
270: l_attribute11 cn_calc_ext_tables.attribute11%TYPE;
271: l_attribute12 cn_calc_ext_tables.attribute12%TYPE;
272: l_attribute13 cn_calc_ext_tables.attribute13%TYPE;

Line 269: l_attribute10 cn_calc_ext_tables.attribute10%TYPE;

265: l_attribute6 cn_calc_ext_tables.attribute6%TYPE;
266: l_attribute7 cn_calc_ext_tables.attribute7%TYPE;
267: l_attribute8 cn_calc_ext_tables.attribute8%TYPE;
268: l_attribute9 cn_calc_ext_tables.attribute9%TYPE;
269: l_attribute10 cn_calc_ext_tables.attribute10%TYPE;
270: l_attribute11 cn_calc_ext_tables.attribute11%TYPE;
271: l_attribute12 cn_calc_ext_tables.attribute12%TYPE;
272: l_attribute13 cn_calc_ext_tables.attribute13%TYPE;
273: l_attribute14 cn_calc_ext_tables.attribute14%TYPE;

Line 270: l_attribute11 cn_calc_ext_tables.attribute11%TYPE;

266: l_attribute7 cn_calc_ext_tables.attribute7%TYPE;
267: l_attribute8 cn_calc_ext_tables.attribute8%TYPE;
268: l_attribute9 cn_calc_ext_tables.attribute9%TYPE;
269: l_attribute10 cn_calc_ext_tables.attribute10%TYPE;
270: l_attribute11 cn_calc_ext_tables.attribute11%TYPE;
271: l_attribute12 cn_calc_ext_tables.attribute12%TYPE;
272: l_attribute13 cn_calc_ext_tables.attribute13%TYPE;
273: l_attribute14 cn_calc_ext_tables.attribute14%TYPE;
274: l_attribute15 cn_calc_ext_tables.attribute15%TYPE;

Line 271: l_attribute12 cn_calc_ext_tables.attribute12%TYPE;

267: l_attribute8 cn_calc_ext_tables.attribute8%TYPE;
268: l_attribute9 cn_calc_ext_tables.attribute9%TYPE;
269: l_attribute10 cn_calc_ext_tables.attribute10%TYPE;
270: l_attribute11 cn_calc_ext_tables.attribute11%TYPE;
271: l_attribute12 cn_calc_ext_tables.attribute12%TYPE;
272: l_attribute13 cn_calc_ext_tables.attribute13%TYPE;
273: l_attribute14 cn_calc_ext_tables.attribute14%TYPE;
274: l_attribute15 cn_calc_ext_tables.attribute15%TYPE;
275:

Line 272: l_attribute13 cn_calc_ext_tables.attribute13%TYPE;

268: l_attribute9 cn_calc_ext_tables.attribute9%TYPE;
269: l_attribute10 cn_calc_ext_tables.attribute10%TYPE;
270: l_attribute11 cn_calc_ext_tables.attribute11%TYPE;
271: l_attribute12 cn_calc_ext_tables.attribute12%TYPE;
272: l_attribute13 cn_calc_ext_tables.attribute13%TYPE;
273: l_attribute14 cn_calc_ext_tables.attribute14%TYPE;
274: l_attribute15 cn_calc_ext_tables.attribute15%TYPE;
275:
276: CURSOR C IS

Line 273: l_attribute14 cn_calc_ext_tables.attribute14%TYPE;

269: l_attribute10 cn_calc_ext_tables.attribute10%TYPE;
270: l_attribute11 cn_calc_ext_tables.attribute11%TYPE;
271: l_attribute12 cn_calc_ext_tables.attribute12%TYPE;
272: l_attribute13 cn_calc_ext_tables.attribute13%TYPE;
273: l_attribute14 cn_calc_ext_tables.attribute14%TYPE;
274: l_attribute15 cn_calc_ext_tables.attribute15%TYPE;
275:
276: CURSOR C IS
277: SELECT *

Line 274: l_attribute15 cn_calc_ext_tables.attribute15%TYPE;

270: l_attribute11 cn_calc_ext_tables.attribute11%TYPE;
271: l_attribute12 cn_calc_ext_tables.attribute12%TYPE;
272: l_attribute13 cn_calc_ext_tables.attribute13%TYPE;
273: l_attribute14 cn_calc_ext_tables.attribute14%TYPE;
274: l_attribute15 cn_calc_ext_tables.attribute15%TYPE;
275:
276: CURSOR C IS
277: SELECT *
278: FROM cn_calc_ext_tables

Line 278: FROM cn_calc_ext_tables

274: l_attribute15 cn_calc_ext_tables.attribute15%TYPE;
275:
276: CURSOR C IS
277: SELECT *
278: FROM cn_calc_ext_tables
279: WHERE calc_ext_table_id = p_calc_ext_table_id
280: FOR UPDATE of calc_ext_table_id NOWAIT;
281: oldrow C%ROWTYPE;
282:

Line 398: UPDATE cn_calc_ext_tables

394: l_attribute14,
395: l_attribute15
396: FROM dual;
397:
398: UPDATE cn_calc_ext_tables
399: SET
400: calc_ext_table_id = l_calc_ext_table_id,
401: name = l_name,
402: description = l_description,

Line 445: DELETE FROM cn_calc_ext_tables

441:
442: PROCEDURE Delete_row( p_calc_ext_table_id NUMBER ) IS
443: BEGIN
444:
445: DELETE FROM cn_calc_ext_tables
446: WHERE calc_ext_table_id = p_calc_ext_table_id;
447: IF (SQL%NOTFOUND) THEN
448: RAISE NO_DATA_FOUND;
449: END IF;