APPS.CN_CALC_EXT_TABLES_PKG dependencies on CN_CALC_EXT_TABLES

Line 1: PACKAGE BODY cn_calc_ext_tables_pkg as

1: PACKAGE BODY cn_calc_ext_tables_pkg as
2: /* $Header: cnextblb.pls 115.7 2002/11/21 21:02:45 hlchen ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_CALC_EXT_TABLE_ID in NUMBER,

Line 36: cursor C is select ROWID from CN_CALC_EXT_TABLES

32: X_LAST_UPDATE_DATE in DATE,
33: X_LAST_UPDATED_BY in NUMBER,
34: X_LAST_UPDATE_LOGIN in NUMBER
35: ) is
36: cursor C is select ROWID from CN_CALC_EXT_TABLES
37: where CALC_EXT_TABLE_ID = X_CALC_EXT_TABLE_ID ;
38:
39: l_calc_ext_table_id NUMBER;
40: BEGIN

Line 42: SELECT cn_calc_ext_tables_s.NEXTVAL

38:
39: l_calc_ext_table_id NUMBER;
40: BEGIN
41: IF (x_calc_ext_table_id IS NULL) THEN
42: SELECT cn_calc_ext_tables_s.NEXTVAL
43: INTO l_calc_ext_table_id
44: FROM dual;
45: ELSE
46: l_calc_ext_table_id := x_calc_ext_table_id;

Line 49: insert into CN_CALC_EXT_TABLES (

45: ELSE
46: l_calc_ext_table_id := x_calc_ext_table_id;
47: END IF;
48:
49: insert into CN_CALC_EXT_TABLES (
50: CALC_EXT_TABLE_ID,
51: NAME,
52: DESCRIPTION,
53: INTERNAL_TABLE_ID,

Line 174: from CN_CALC_EXT_TABLES

170: ATTRIBUTE12,
171: ATTRIBUTE13,
172: ATTRIBUTE14,
173: ATTRIBUTE15
174: from CN_CALC_EXT_TABLES
175: where CALC_EXT_TABLE_ID = X_CALC_EXT_TABLE_ID
176: for update of CALC_EXT_TABLE_ID nowait;
177:
178: tlinfo c1%ROWTYPE;

Line 270: update CN_CALC_EXT_TABLES set

266: X_LAST_UPDATED_BY in NUMBER,
267: X_LAST_UPDATE_LOGIN in NUMBER
268: ) is
269: begin
270: update CN_CALC_EXT_TABLES set
271: ATTRIBUTE12 = X_ATTRIBUTE12,
272: ATTRIBUTE13 = X_ATTRIBUTE13,
273: ATTRIBUTE14 = X_ATTRIBUTE14,
274: ATTRIBUTE15 = X_ATTRIBUTE15,

Line 309: delete from CN_CALC_EXT_TABLES

305: procedure DELETE_ROW (
306: X_CALC_EXT_TABLE_ID in NUMBER
307: ) is
308: begin
309: delete from CN_CALC_EXT_TABLES
310: where CALC_EXT_TABLE_ID = X_CALC_EXT_TABLE_ID;
311:
312: if (sql%notfound) then
313: raise no_data_found;

Line 319: END cn_calc_ext_tables_pkg ;

315:
316: end DELETE_ROW;
317:
318:
319: END cn_calc_ext_tables_pkg ;