APPS.CS_FORUM_ATTRS_PKG dependencies on CS_FORUM_ATTRS_TL

Line 88: insert into CS_FORUM_ATTRS_TL (

84: X_ATTRIBUTE14,
85: X_ATTRIBUTE15
86: );
87:
88: insert into CS_FORUM_ATTRS_TL (
89: ATTRIBUTE_ID,
90: NAME,
91: DESCRIPTION,
92: CREATION_DATE,

Line 114: from CS_FORUM_ATTRS_TL T

110: from FND_LANGUAGES L
111: where L.INSTALLED_FLAG in ('I', 'B')
112: and not exists
113: (select NULL
114: from CS_FORUM_ATTRS_TL T
115: where T.ATTRIBUTE_ID = X_ATTRIBUTE_ID
116: and T.LANGUAGE = L.LANGUAGE_CODE);
117:
118: open c;

Line 182: from CS_FORUM_ATTRS_TL

178: cursor c1 is select
179: NAME,
180: DESCRIPTION,
181: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
182: from CS_FORUM_ATTRS_TL
183: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
184: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
185: for update of ATTRIBUTE_ID nowait;
186: begin

Line 311: update CS_FORUM_ATTRS_TL set

307: if (sql%notfound) then
308: raise no_data_found;
309: end if;
310:
311: update CS_FORUM_ATTRS_TL set
312: NAME = X_NAME,
313: DESCRIPTION = X_DESCRIPTION,
314: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
315: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 330: delete from CS_FORUM_ATTRS_TL

326: procedure DELETE_ROW (
327: X_ATTRIBUTE_ID in NUMBER
328: ) is
329: begin
330: delete from CS_FORUM_ATTRS_TL
331: where ATTRIBUTE_ID = X_ATTRIBUTE_ID;
332:
333: /*
334: if (sql%notfound) then

Line 351: delete from CS_FORUM_ATTRS_TL T

347:
348: procedure ADD_LANGUAGE
349: is
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

Line 358: update CS_FORUM_ATTRS_TL T set (

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 (
359: NAME,
360: DESCRIPTION
361: ) = (select
362: B.NAME,

Line 364: from CS_FORUM_ATTRS_TL B

360: DESCRIPTION
361: ) = (select
362: B.NAME,
363: B.DESCRIPTION
364: from CS_FORUM_ATTRS_TL B
365: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
366: and B.LANGUAGE = T.SOURCE_LANG)
367: where (
368: T.ATTRIBUTE_ID,

Line 373: from CS_FORUM_ATTRS_TL SUBB, CS_FORUM_ATTRS_TL SUBT

369: T.LANGUAGE
370: ) in (select
371: SUBT.ATTRIBUTE_ID,
372: SUBT.LANGUAGE
373: from CS_FORUM_ATTRS_TL SUBB, CS_FORUM_ATTRS_TL SUBT
374: where SUBB.ATTRIBUTE_ID = SUBT.ATTRIBUTE_ID
375: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
376: and (SUBB.NAME <> SUBT.NAME
377: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 384: insert into CS_FORUM_ATTRS_TL (

380: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
381: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
382: ));
383:
384: insert into CS_FORUM_ATTRS_TL (
385: ATTRIBUTE_ID,
386: NAME,
387: DESCRIPTION,
388: CREATION_DATE,

Line 406: from CS_FORUM_ATTRS_TL B, FND_LANGUAGES L

402: B.LAST_UPDATED_BY,
403: B.LAST_UPDATE_LOGIN,
404: L.LANGUAGE_CODE,
405: B.SOURCE_LANG
406: from CS_FORUM_ATTRS_TL B, FND_LANGUAGES L
407: where L.INSTALLED_FLAG in ('I', 'B')
408: and B.LANGUAGE = userenv('LANG')
409: and not exists
410: (select NULL

Line 411: from CS_FORUM_ATTRS_TL T

407: where L.INSTALLED_FLAG in ('I', 'B')
408: and B.LANGUAGE = userenv('LANG')
409: and not exists
410: (select NULL
411: from CS_FORUM_ATTRS_TL T
412: where T.ATTRIBUTE_ID = B.ATTRIBUTE_ID
413: and T.LANGUAGE = L.LANGUAGE_CODE);
414: end ADD_LANGUAGE;
415:

Line 425: update cs_forum_attrs_tl set

421: x_owner in varchar2
422: )
423: is
424: begin
425: update cs_forum_attrs_tl set
426: description = x_description,
427: name = x_name,
428: LAST_UPDATE_DATE = sysdate,
429: LAST_UPDATED_BY = decode(x_owner, 'SEED', 1, 0),