APPS.CN_ROLE_PLAN_MAPS_PKG dependencies on CN_ROLE_PLAN_MAPS

Line 1: package body CN_ROLE_PLAN_MAPS_PKG as

1: package body CN_ROLE_PLAN_MAPS_PKG as
2: /* $Header: cntrlpmb.pls 115.5 2002/11/21 21:10:42 hlchen ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_ROLE_PLAN_MAP_ID in NUMBER,

Line 34: cursor C is select ROWID from CN_ROLE_PLAN_MAPS

30: X_LAST_UPDATE_DATE in DATE,
31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER
33: ) is
34: cursor C is select ROWID from CN_ROLE_PLAN_MAPS
35: where ROLE_PLAN_MAP_ID = X_ROLE_PLAN_MAP_ID
36: ;
37: begin
38: insert into CN_ROLE_PLAN_MAPS (

Line 38: insert into CN_ROLE_PLAN_MAPS (

34: cursor C is select ROWID from CN_ROLE_PLAN_MAPS
35: where ROLE_PLAN_MAP_ID = X_ROLE_PLAN_MAP_ID
36: ;
37: begin
38: insert into CN_ROLE_PLAN_MAPS (
39: OBJECT_VERSION_NUMBER,
40: CREATED_BY,
41: ROLE_PLAN_MAP_ID,
42: ROLE_ID,

Line 156: from CN_ROLE_PLAN_MAPS

152: ATTRIBUTE12,
153: ATTRIBUTE13,
154: ATTRIBUTE14,
155: ATTRIBUTE15
156: from CN_ROLE_PLAN_MAPS
157: where ROLE_PLAN_MAP_ID = X_ROLE_PLAN_MAP_ID
158: for update of ROLE_PLAN_MAP_ID nowait;
159: begin
160: for tlinfo in c1 loop

Line 238: update CN_ROLE_PLAN_MAPS set

234: X_LAST_UPDATED_BY in NUMBER,
235: X_LAST_UPDATE_LOGIN in NUMBER
236: ) is
237: begin
238: update CN_ROLE_PLAN_MAPS set
239: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
240: ROLE_ID = X_ROLE_ID,
241: ROLE_MODEL_ID = X_ROLE_MODEL_ID,
242: COMP_PLAN_NAME = X_COMP_PLAN_NAME,

Line 275: delete from CN_ROLE_PLAN_MAPS

271: procedure DELETE_ROW (
272: X_ROLE_PLAN_MAP_ID in NUMBER
273: ) is
274: begin
275: delete from CN_ROLE_PLAN_MAPS
276: where ROLE_PLAN_MAP_ID = X_ROLE_PLAN_MAP_ID;
277:
278: if (sql%notfound) then
279: raise no_data_found;

Line 284: end CN_ROLE_PLAN_MAPS_PKG;

280: end if;
281:
282: end DELETE_ROW;
283:
284: end CN_ROLE_PLAN_MAPS_PKG;