DBA Data[Home] [Help]

APPS.CN_COMP_ANCHORS_PKG dependencies on CN_COMP_ANCHORS_S

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 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,