APPS.CS_FORUM_ATTRS_PKG dependencies on CS_FORUM_ATTRS_B

Line 32: cursor C is select ATTRIBUTE_ID from CS_FORUM_ATTRS_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 ATTRIBUTE_ID from CS_FORUM_ATTRS_B
33: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
34: ;
35: begin
36: insert into CS_FORUM_ATTRS_B (

Line 36: insert into CS_FORUM_ATTRS_B (

32: cursor C is select ATTRIBUTE_ID from CS_FORUM_ATTRS_B
33: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
34: ;
35: begin
36: insert into CS_FORUM_ATTRS_B (
37: ATTRIBUTE_ID,
38: ATTRIBUTE_TYPE,
39: ATTRIBUTE_NAME,
40: CREATION_DATE,

Line 173: from CS_FORUM_ATTRS_B

169: ATTRIBUTE12,
170: ATTRIBUTE13,
171: ATTRIBUTE14,
172: ATTRIBUTE15
173: from CS_FORUM_ATTRS_B
174: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
175: for update of ATTRIBUTE_ID nowait;
176: recinfo c%rowtype;
177:

Line 283: update CS_FORUM_ATTRS_B set

279: X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
280: X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL
281: ) is
282: begin
283: update CS_FORUM_ATTRS_B set
284: ATTRIBUTE_TYPE = X_ATTRIBUTE_TYPE,
285: ATTRIBUTE_NAME = X_ATTRIBUTE_NAME,
286: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
287: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 339: delete from CS_FORUM_ATTRS_B

335: raise no_data_found;
336: end if;
337: */
338:
339: delete from CS_FORUM_ATTRS_B
340: where ATTRIBUTE_ID = X_ATTRIBUTE_ID;
341: /*
342: if (sql%notfound) then
343: raise no_data_found;

Line 354: from CS_FORUM_ATTRS_B B

350: begin
351: delete from CS_FORUM_ATTRS_TL T
352: where not exists
353: (select NULL
354: from CS_FORUM_ATTRS_B B
355: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
356: );
357:
358: update CS_FORUM_ATTRS_TL T set (