[Home] [Help]
1: package body CS_KB_CAT_GROUP_MEMBERS_PKG as
2: /* $Header: cskbcgmb.pls 115.0 2003/08/29 18:22:58 mkettle noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_CATEGORY_GROUP_ID in NUMBER,
25: X_LAST_UPDATE_DATE in DATE,
26: X_LAST_UPDATED_BY in NUMBER,
27: X_LAST_UPDATE_LOGIN in NUMBER
28: ) is
29: cursor C is select ROWID from CS_KB_CAT_GROUP_MEMBERS
30: where CATEGORY_GROUP_ID = X_CATEGORY_GROUP_ID
31: and CATEGORY_ID = X_CATEGORY_ID;
32: begin
33: insert into CS_KB_CAT_GROUP_MEMBERS (
29: cursor C is select ROWID from CS_KB_CAT_GROUP_MEMBERS
30: where CATEGORY_GROUP_ID = X_CATEGORY_GROUP_ID
31: and CATEGORY_ID = X_CATEGORY_ID;
32: begin
33: insert into CS_KB_CAT_GROUP_MEMBERS (
34: CATEGORY_GROUP_ID,
35: CATEGORY_ID,
36: CREATION_DATE,
37: CREATED_BY,
96: ) is
97: cursor c is select
98: CATEGORY_ID,
99: CATEGORY_GROUP_ID
100: from CS_KB_CAT_GROUP_MEMBERS
101: where CATEGORY_GROUP_ID = X_CATEGORY_GROUP_ID
102: for update of CATEGORY_GROUP_ID nowait;
103: recinfo c%rowtype;
104:
137: X_LAST_UPDATED_BY in NUMBER,
138: X_LAST_UPDATE_LOGIN in NUMBER
139: ) is
140: begin
141: update CS_KB_CAT_GROUP_MEMBERS set
142: CATEGORY_ID = X_CATEGORY_ID,
143: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
144: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
145: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
171: X_CATEGORY_GROUP_ID in NUMBER,
172: X_CATEGORY_ID in NUMBER
173: ) is
174: begin
175: delete from CS_KB_CAT_GROUP_MEMBERS
176: where CATEGORY_GROUP_ID = X_CATEGORY_GROUP_ID
177: and CATEGORY_ID = X_CATEGORY_ID;
178:
179: if (sql%notfound) then
183:
184: end DELETE_ROW;
185:
186:
187: end CS_KB_CAT_GROUP_MEMBERS_PKG;