APPS.CN_COMP_ANCHORS_PKG dependencies on CN_COMP_ANCHORS

Line 1: package body CN_COMP_ANCHORS_PKG as

1: package body CN_COMP_ANCHORS_PKG as
2: /* $Header: cntancb.pls 115.4 2002/11/21 21:08:59 hlchen ship $ */
3:
4: procedure INSERT_ROW
5: (X_ROWID IN OUT NOCOPY VARCHAR2,

Line 35: cursor C is select ROWID from cn_comp_anchors

31: X_LAST_UPDATED_BY IN NUMBER,
32: X_LAST_UPDATE_LOGIN IN NUMBER,
33: X_OBJECT_VERSION_NUMBER IN NUMBER
34: ) IS
35: cursor C is select ROWID from cn_comp_anchors
36: where COMP_ANCHOR_ID = x_comp_anchor_id;
37:
38: CURSOR id IS SELECT cn_comp_anchors_s.NEXTVAL FROM dual;
39: BEGIN

Line 38: CURSOR id IS SELECT cn_comp_anchors_s.NEXTVAL FROM dual;

34: ) IS
35: cursor C is select ROWID from cn_comp_anchors
36: where COMP_ANCHOR_ID = x_comp_anchor_id;
37:
38: CURSOR id IS SELECT cn_comp_anchors_s.NEXTVAL FROM dual;
39: BEGIN
40: IF (x_comp_anchor_id IS NULL) THEN
41: OPEN id;
42: FETCH id INTO x_comp_anchor_id;

Line 50: insert into CN_COMP_ANCHORS

46: END IF;
47: CLOSE id;
48: END IF;
49:
50: insert into CN_COMP_ANCHORS
51: (LAST_UPDATED_BY,
52: LAST_UPDATE_LOGIN,
53: CREATION_DATE,
54: CREATED_BY,

Line 172: FROM cn_comp_anchors

168: ATTRIBUTE14,
169: ATTRIBUTE15,
170: comp_anchor_id,
171: OBJECT_VERSION_NUMBER
172: FROM cn_comp_anchors
173: WHERE COMP_ANCHOR_ID = x_comp_anchor_id
174: for update of COMP_ANCHOR_ID nowait;
175: tlinfo c1%ROWTYPE;
176:

Line 266: update CN_COMP_ANCHORS SET

262: X_LAST_UPDATE_LOGIN IN NUMBER,
263: X_OBJECT_VERSION_NUMBER IN NUMBER
264: ) IS
265: BEGIN
266: update CN_COMP_ANCHORS SET
267: ROLE_QUOTA_CATE_ID = X_ROLE_QUOTA_CATE_ID,
268: QUOTA_CATEGORY_ID = X_QUOTA_CATEGORY_ID,
269: ATTAINMENT = X_ATTAINMENT,
270: TYPE = X_TYPE,

Line 305: delete from CN_COMP_ANCHORS

301: procedure DELETE_ROW (
302: X_COMP_ANCHOR_ID in NUMBER
303: ) is
304: begin
305: delete from CN_COMP_ANCHORS
306: where COMP_ANCHOR_ID = X_COMP_ANCHOR_ID;
307:
308: if (sql%notfound) then
309: raise no_data_found;

Line 314: end CN_COMP_ANCHORS_PKG;

310: end if;
311:
312: end DELETE_ROW;
313:
314: end CN_COMP_ANCHORS_PKG;