APPS.CN_CALC_EXT_TBL_DTLS_PKG dependencies on CN_CALC_EXT_TBL_DTLS

Line 1: PACKAGE BODY cn_calc_ext_tbl_dtls_pkg as

1: PACKAGE BODY cn_calc_ext_tbl_dtls_pkg as
2: -- $Header: cntblmpb.pls 115.5 2002/02/05 00:25:40 pkm ship $
3: procedure INSERT_ROW (
4: X_ROWID in out VARCHAR2,
5: X_CALC_EXT_TBL_DTL_ID in NUMBER,

Line 31: cursor C is select ROWID from CN_CALC_EXT_TBL_DTLS

27: X_LAST_UPDATE_DATE in DATE,
28: X_LAST_UPDATED_BY in NUMBER,
29: X_LAST_UPDATE_LOGIN in NUMBER
30: ) is
31: cursor C is select ROWID from CN_CALC_EXT_TBL_DTLS
32: where CALC_EXT_TBL_DTL_ID = X_CALC_EXT_TBL_DTL_ID ;
33:
34: l_calc_ext_tbl_dtl_id NUMBER;
35: BEGIN

Line 37: SELECT cn_calc_ext_tbl_dtls_s.NEXTVAL

33:
34: l_calc_ext_tbl_dtl_id NUMBER;
35: BEGIN
36: IF (x_calc_ext_tbl_dtl_id IS NULL) THEN
37: SELECT cn_calc_ext_tbl_dtls_s.NEXTVAL
38: INTO l_calc_ext_tbl_dtl_id
39: FROM dual;
40: ELSE
41: l_calc_ext_tbl_dtl_id := x_calc_ext_tbl_dtl_id;

Line 44: insert into CN_CALC_EXT_TBL_DTLS (

40: ELSE
41: l_calc_ext_tbl_dtl_id := x_calc_ext_tbl_dtl_id;
42: END IF;
43:
44: insert into CN_CALC_EXT_TBL_DTLS (
45: EXTERNAL_COLUMN_ID,
46: CALC_EXT_TBL_DTL_ID,
47: CALC_EXT_TABLE_ID,
48: INTERNAL_COLUMN_ID,

Line 149: from CN_CALC_EXT_TBL_DTLS

145: ATTRIBUTE10,
146: EXTERNAL_COLUMN_ID,
147: CALC_EXT_TABLE_ID,
148: INTERNAL_COLUMN_ID
149: from CN_CALC_EXT_TBL_DTLS
150: where CALC_EXT_TBL_DTL_ID = X_CALC_EXT_TBL_DTL_ID
151: for update of CALC_EXT_TBL_DTL_ID nowait;
152:
153: tlinfo c1%ROWTYPE;

Line 230: update CN_CALC_EXT_TBL_DTLS set

226: X_LAST_UPDATED_BY in NUMBER,
227: X_LAST_UPDATE_LOGIN in NUMBER
228: ) is
229: begin
230: update CN_CALC_EXT_TBL_DTLS set
231: ATTRIBUTE11 = X_ATTRIBUTE11,
232: ATTRIBUTE12 = X_ATTRIBUTE12,
233: ATTRIBUTE13 = X_ATTRIBUTE13,
234: ATTRIBUTE14 = X_ATTRIBUTE14,

Line 264: delete from CN_CALC_EXT_TBL_DTLS

260: procedure DELETE_ROW (
261: X_CALC_EXT_TBL_DTL_ID in NUMBER
262: ) is
263: begin
264: delete from CN_CALC_EXT_TBL_DTLS
265: where CALC_EXT_TBL_DTL_ID = X_CALC_EXT_TBL_DTL_ID;
266:
267: if (sql%notfound) then
268: raise no_data_found;

Line 274: END cn_calc_ext_tbl_dtls_pkg;

270:
271: end DELETE_ROW;
272:
273:
274: END cn_calc_ext_tbl_dtls_pkg;