APPS.CN_ROLE_DETAILS_PKG dependencies on CN_ROLE_DETAILS

Line 1: package body CN_ROLE_DETAILS_PKG as

1: package body CN_ROLE_DETAILS_PKG as
2: /* $Header: cntrldtb.pls 115.6 2002/11/21 21:10:35 hlchen ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_ROLE_ID in NUMBER,

Line 39: cursor C is select ROWID from CN_ROLE_DETAILS

35: X_LAST_UPDATE_DATE in DATE,
36: X_LAST_UPDATED_BY in NUMBER,
37: X_LAST_UPDATE_LOGIN in NUMBER
38: ) is
39: cursor C is select ROWID from CN_ROLE_DETAILS
40: where ROLE_ID = X_ROLE_ID
41: ;
42: begin
43: insert into CN_ROLE_DETAILS (

Line 43: insert into CN_ROLE_DETAILS (

39: cursor C is select ROWID from CN_ROLE_DETAILS
40: where ROLE_ID = X_ROLE_ID
41: ;
42: begin
43: insert into CN_ROLE_DETAILS (
44: ROLE_ID,
45: CLUB_ELIGIBLE_FLAG,
46: OTE,
47: ROUNDING_FACTOR,

Line 182: from CN_ROLE_DETAILS

178: ATTRIBUTE15,
179: PLAN_ACTIVATE_STATUS,
180: REASON,
181: OBJECT_VERSION_NUMBER
182: from CN_ROLE_DETAILS
183: where ROLE_ID = X_ROLE_ID
184: for update of ROLE_ID nowait;
185: begin
186: for tlinfo in c1 loop

Line 284: update CN_ROLE_DETAILS set

280: X_LAST_UPDATED_BY in NUMBER,
281: X_LAST_UPDATE_LOGIN in NUMBER
282: ) is
283: begin
284: update CN_ROLE_DETAILS set
285: CLUB_ELIGIBLE_FLAG = X_CLUB_ELIGIBLE_FLAG,
286: OTE = X_OTE,
287: ROUNDING_FACTOR = X_ROUNDING_FACTOR,
288: ATTAIN_SCHEDULE_ID = X_ATTAIN_SCHEDULE_ID,

Line 326: delete from CN_ROLE_DETAILS

322: procedure DELETE_ROW (
323: X_ROLE_ID in NUMBER
324: ) is
325: begin
326: delete from CN_ROLE_DETAILS
327: where ROLE_ID = X_ROLE_ID;
328:
329: if (sql%notfound) then
330: raise no_data_found;

Line 335: end CN_ROLE_DETAILS_PKG;

331: end if;
332:
333: end DELETE_ROW;
334:
335: end CN_ROLE_DETAILS_PKG;