APPS.CN_ROLE_QUOTA_CATES_PKG dependencies on CN_ROLE_QUOTA_CATES

Line 1: package body CN_ROLE_QUOTA_CATES_PKG as

1: package body CN_ROLE_QUOTA_CATES_PKG as
2: /* $Header: cntrlqcb.pls 115.6 2002/11/21 21:30:33 hlchen ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_ROLE_QUOTA_CATE_ID in NUMBER,

Line 44: cursor C is select ROWID from CN_ROLE_QUOTA_CATES

40: X_LAST_UPDATE_DATE in DATE,
41: X_LAST_UPDATED_BY in NUMBER,
42: X_LAST_UPDATE_LOGIN in NUMBER
43: ) is
44: cursor C is select ROWID from CN_ROLE_QUOTA_CATES
45: where ROLE_QUOTA_CATE_ID = X_ROLE_QUOTA_CATE_ID
46: ;
47: begin
48: insert into CN_ROLE_QUOTA_CATES (

Line 48: insert into CN_ROLE_QUOTA_CATES (

44: cursor C is select ROWID from CN_ROLE_QUOTA_CATES
45: where ROLE_QUOTA_CATE_ID = X_ROLE_QUOTA_CATE_ID
46: ;
47: begin
48: insert into CN_ROLE_QUOTA_CATES (
49: FORMULA_TYPE,
50: ROLE_ID,
51: ROLE_MODEL_ID,
52: QUOTA_CATEGORY_ID,

Line 178: update CN_ROLE_QUOTA_CATES set

174: X_LAST_UPDATED_BY in NUMBER,
175: X_LAST_UPDATE_LOGIN in NUMBER
176: ) is
177: begin
178: update CN_ROLE_QUOTA_CATES set
179: FORMULA_TYPE = X_FORMULA_TYPE,
180: ROLE_ID = X_ROLE_ID,
181: ROLE_MODEL_ID = X_ROLE_MODEL_ID,
182: QUOTA_CATEGORY_ID = X_QUOTA_CATEGORY_ID,

Line 225: delete from CN_ROLE_QUOTA_CATES

221: procedure DELETE_ROW (
222: X_ROLE_QUOTA_CATE_ID in NUMBER
223: ) is
224: begin
225: delete from CN_ROLE_QUOTA_CATES
226: where ROLE_QUOTA_CATE_ID = X_ROLE_QUOTA_CATE_ID;
227:
228: if (sql%notfound) then
229: raise no_data_found;

Line 234: end CN_ROLE_QUOTA_CATES_PKG;

230: end if;
231:
232: end DELETE_ROW;
233:
234: end CN_ROLE_QUOTA_CATES_PKG;