APPS.CS_KB_CATEGORY_GROUPS_PKG dependencies on CS_KB_CATEGORY_GROUPS_B

Line 32: cursor C is select ROWID from CS_KB_CATEGORY_GROUPS_B

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 CS_KB_CATEGORY_GROUPS_B
33: where CATEGORY_GROUP_ID = X_CATEGORY_GROUP_ID
34: ;
35: begin
36: insert into CS_KB_CATEGORY_GROUPS_B (

Line 36: insert into CS_KB_CATEGORY_GROUPS_B (

32: cursor C is select ROWID from CS_KB_CATEGORY_GROUPS_B
33: where CATEGORY_GROUP_ID = X_CATEGORY_GROUP_ID
34: ;
35: begin
36: insert into CS_KB_CATEGORY_GROUPS_B (
37: ATTRIBUTE_CATEGORY,
38: ATTRIBUTE1,
39: ATTRIBUTE2,
40: ATTRIBUTE3,

Line 170: from CS_KB_CATEGORY_GROUPS_B

166: ATTRIBUTE14,
167: ATTRIBUTE15,
168: START_DATE_ACTIVE,
169: END_DATE_ACTIVE--,
170: from CS_KB_CATEGORY_GROUPS_B
171: where CATEGORY_GROUP_ID = X_CATEGORY_GROUP_ID
172: for update of CATEGORY_GROUP_ID nowait;
173: recinfo c%rowtype;
174:

Line 278: update CS_KB_CATEGORY_GROUPS_B set

274: X_LAST_UPDATED_BY in NUMBER,
275: X_LAST_UPDATE_LOGIN in NUMBER
276: ) is
277: begin
278: update CS_KB_CATEGORY_GROUPS_B set
279: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
280: ATTRIBUTE1 = X_ATTRIBUTE1,
281: ATTRIBUTE2 = X_ATTRIBUTE2,
282: ATTRIBUTE3 = X_ATTRIBUTE3,

Line 332: delete from CS_KB_CATEGORY_GROUPS_B

328: if (sql%notfound) then
329: raise no_data_found;
330: end if;
331:
332: delete from CS_KB_CATEGORY_GROUPS_B
333: where CATEGORY_GROUP_ID = X_CATEGORY_GROUP_ID;
334:
335: if (sql%notfound) then
336: raise no_data_found;

Line 346: from CS_KB_CATEGORY_GROUPS_B B

342: begin
343: delete from CS_KB_CATEGORY_GROUPS_TL T
344: where not exists
345: (select NULL
346: from CS_KB_CATEGORY_GROUPS_B B
347: where B.CATEGORY_GROUP_ID = T.CATEGORY_GROUP_ID
348: );
349:
350: update CS_KB_CATEGORY_GROUPS_TL T set (