APPS.CS_KB_SOLN_CATEGORIES_PKG dependencies on CS_KB_SOLN_CATEGORIES_B

Line 25: from CS_KB_SOLN_CATEGORIES_B

21: from dual;
22:
23: cursor verifyRowCursor is
24: select ROWID
25: from CS_KB_SOLN_CATEGORIES_B
26: where CATEGORY_ID = X_CATEGORY_ID;
27: BEGIN
28:
29: /* Get a new category id if none is passed */

Line 38: insert into CS_KB_SOLN_CATEGORIES_B

34: CLOSE getNewCategoryIdCsr;
35: END IF;
36:
37: /* created base table record */
38: insert into CS_KB_SOLN_CATEGORIES_B
39: (
40: CATEGORY_ID,
41: PARENT_CATEGORY_ID,
42: CREATION_DATE,

Line 120: update cs_kb_soln_categories_b

116: X_VISIBILITY_ID in NUMBER
117: )
118: is
119: begin
120: update cs_kb_soln_categories_b
121: set
122: parent_category_id = X_PARENT_CATEGORY_ID,
123: last_update_date = X_LAST_UPDATE_DATE,
124: last_updated_by = X_LAST_UPDATED_BY,

Line 165: delete from cs_kb_soln_categories_b

161: if (sql%notfound) then
162: raise no_data_found;
163: end if;
164:
165: delete from cs_kb_soln_categories_b
166: where category_id = X_CATEGORY_ID;
167:
168: if (sql%notfound) then
169: raise no_data_found;

Line 197: from CS_KB_SOLN_CATEGORIES_B B

193: begin
194: delete from CS_KB_SOLN_CATEGORIES_TL T
195: where not exists
196: (select NULL
197: from CS_KB_SOLN_CATEGORIES_B B
198: where B.CATEGORY_ID = T.CATEGORY_ID
199: );
200:
201: update CS_KB_SOLN_CATEGORIES_TL T

Line 299: FROM cs_kb_soln_categories_b

295: l_category_id number := x_category_id;
296:
297: CURSOR Check_Last_Updated_By IS
298: SELECT last_updated_by
299: FROM cs_kb_soln_categories_b
300: WHERE category_id = X_CATEGORY_ID;
301:
302: l_last_upd_by NUMBER := NULL;
303: