APPS.CS_FORUM_CATEGORIES_PKG dependencies on CS_FORUM_CATEGORIES_B

Line 32: cursor C is select CATEGORY_ID from CS_FORUM_CATEGORIES_B

28: X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
29: X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
30: X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL
31: ) is
32: cursor C is select CATEGORY_ID from CS_FORUM_CATEGORIES_B
33: where CATEGORY_ID = X_CATEGORY_ID
34: ;
35: begin
36: insert into CS_FORUM_CATEGORIES_B (

Line 36: insert into CS_FORUM_CATEGORIES_B (

32: cursor C is select CATEGORY_ID from CS_FORUM_CATEGORIES_B
33: where CATEGORY_ID = X_CATEGORY_ID
34: ;
35: begin
36: insert into CS_FORUM_CATEGORIES_B (
37: CATEGORY_ID,
38: CATEGORY_TYPE,
39: CATEGORY_NAME,
40: STATUS,

Line 175: from CS_FORUM_CATEGORIES_B

171: ATTRIBUTE12,
172: ATTRIBUTE13,
173: ATTRIBUTE14,
174: ATTRIBUTE15
175: from CS_FORUM_CATEGORIES_B
176: where CATEGORY_ID = X_CATEGORY_ID
177: for update of CATEGORY_ID nowait;
178: recinfo c%rowtype;
179:

Line 286: update CS_FORUM_CATEGORIES_B set

282: X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
283: X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL
284: ) is
285: begin
286: update CS_FORUM_CATEGORIES_B set
287: CATEGORY_TYPE = X_CATEGORY_TYPE,
288: CATEGORY_NAME = X_CATEGORY_NAME,
289: STATUS = X_STATUS,
290: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 343: delete from CS_FORUM_CATEGORIES_B

339: raise no_data_found;
340: end if;
341: */
342:
343: delete from CS_FORUM_CATEGORIES_B
344: where CATEGORY_ID = X_CATEGORY_ID;
345: /*
346: if (sql%notfound) then
347: raise no_data_found;

Line 358: from CS_FORUM_CATEGORIES_B B

354: begin
355: delete from CS_FORUM_CATEGORIES_TL T
356: where not exists
357: (select NULL
358: from CS_FORUM_CATEGORIES_B B
359: where B.CATEGORY_ID = T.CATEGORY_ID
360: );
361:
362: update CS_FORUM_CATEGORIES_TL T set (