APPS.CN_ROLE_QUOTA_FORMULAS_PKG dependencies on CN_ROLE_QUOTA_FORMULAS

Line 1: package body CN_ROLE_QUOTA_FORMULAS_PKG as

1: package body CN_ROLE_QUOTA_FORMULAS_PKG as
2: /* $Header: cntrlqfb.pls 115.4 2002/11/21 21:10:48 hlchen ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_ROLE_QUOTA_FORMULA_ID in NUMBER,

Line 32: cursor C is select ROWID from CN_ROLE_QUOTA_FORMULAS

28: X_LAST_UPDATE_DATE in DATE,
29: X_LAST_UPDATED_BY in NUMBER,
30: X_LAST_UPDATE_LOGIN in NUMBER
31: ) is
32: cursor C is select ROWID from CN_ROLE_QUOTA_FORMULAS
33: where ROLE_QUOTA_FORMULA_ID = X_ROLE_QUOTA_FORMULA_ID
34: ;
35: begin
36: insert into CN_ROLE_QUOTA_FORMULAS (

Line 36: insert into CN_ROLE_QUOTA_FORMULAS (

32: cursor C is select ROWID from CN_ROLE_QUOTA_FORMULAS
33: where ROLE_QUOTA_FORMULA_ID = X_ROLE_QUOTA_FORMULA_ID
34: ;
35: begin
36: insert into CN_ROLE_QUOTA_FORMULAS (
37: ROLE_QUOTA_FORMULA_ID,
38: ROLE_QUOTA_CATE_ID,
39: BASE_ROLE_QUOTA_ID,
40: PERCENT,

Line 147: from CN_ROLE_QUOTA_FORMULAS

143: ATTRIBUTE13,
144: ATTRIBUTE14,
145: ATTRIBUTE15,
146: OBJECT_VERSION_NUMBER
147: from CN_ROLE_QUOTA_FORMULAS
148: where ROLE_QUOTA_FORMULA_ID = X_ROLE_QUOTA_FORMULA_ID
149: for update of ROLE_QUOTA_FORMULA_ID nowait;
150: begin
151: for tlinfo in c1 loop

Line 226: update CN_ROLE_QUOTA_FORMULAS set

222: X_LAST_UPDATED_BY in NUMBER,
223: X_LAST_UPDATE_LOGIN in NUMBER
224: ) is
225: begin
226: update CN_ROLE_QUOTA_FORMULAS set
227: ROLE_QUOTA_CATE_ID = X_ROLE_QUOTA_CATE_ID,
228: BASE_ROLE_QUOTA_ID = X_BASE_ROLE_QUOTA_ID,
229: PERCENT = X_PERCENT,
230: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,

Line 261: delete from CN_ROLE_QUOTA_FORMULAS

257: procedure DELETE_ROW (
258: X_ROLE_QUOTA_FORMULA_ID in NUMBER
259: ) is
260: begin
261: delete from CN_ROLE_QUOTA_FORMULAS
262: where ROLE_QUOTA_FORMULA_ID = X_ROLE_QUOTA_FORMULA_ID;
263:
264: if (sql%notfound) then
265: raise no_data_found;

Line 270: end CN_ROLE_QUOTA_FORMULAS_PKG;

266: end if;
267:
268: end DELETE_ROW;
269:
270: end CN_ROLE_QUOTA_FORMULAS_PKG;