APPS.CS_FORUM_MESSAGES_PKG dependencies on CS_FORUM_MESSAGES_TL

Line 20: | cs_forum_messages_tl. |

16: | HISTORY |
17: | 19-OCT-1999 A. WONG Created |
18: | 04-OCT-2002 KLOU (UNISRCH) |
19: | 1. Add new column composite_assoc_col in |
20: | cs_forum_messages_tl. |
21: | 25-NOV-2002 ALLAU
22: | Remove default value for IN parameters due to GSCC
23: | restriction
24: +======================================================================*/

Line 125: insert into CS_FORUM_MESSAGES_TL (

121: X_ATTRIBUTE14,
122: X_ATTRIBUTE15
123: );
124:
125: insert into CS_FORUM_MESSAGES_TL (
126: MESSAGE_ID,
127: NAME,
128: DESCRIPTION,
129: CREATION_DATE,

Line 153: from CS_FORUM_MESSAGES_TL T

149: from FND_LANGUAGES L
150: where L.INSTALLED_FLAG in ('I', 'B')
151: and not exists
152: (select NULL
153: from CS_FORUM_MESSAGES_TL T
154: where T.MESSAGE_ID = X_MESSAGE_ID
155: and T.LANGUAGE = L.LANGUAGE_CODE);
156:
157: open c;

Line 223: from CS_FORUM_MESSAGES_TL

219: cursor c1 is select
220: NAME,
221: DESCRIPTION,
222: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
223: from CS_FORUM_MESSAGES_TL
224: where MESSAGE_ID = X_MESSAGE_ID
225: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
226: for update of MESSAGE_ID nowait;
227: begin

Line 368: update CS_FORUM_MESSAGES_TL set

364: if (sql%notfound) then
365: raise no_data_found;
366: end if;
367:
368: update CS_FORUM_MESSAGES_TL set
369: NAME = X_NAME,
370: DESCRIPTION = X_DESCRIPTION,
371: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
372: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 388: delete from CS_FORUM_MESSAGES_TL

384: procedure DELETE_ROW (
385: X_MESSAGE_ID in NUMBER
386: ) is
387: begin
388: delete from CS_FORUM_MESSAGES_TL
389: where MESSAGE_ID = X_MESSAGE_ID;
390:
391: /*
392: if (sql%notfound) then

Line 410: delete from CS_FORUM_MESSAGES_TL T

406:
407: procedure ADD_LANGUAGE
408: is
409: begin
410: delete from CS_FORUM_MESSAGES_TL T
411: where not exists
412: (select NULL
413: from CS_FORUM_MESSAGES_B B
414: where B.MESSAGE_ID = T.MESSAGE_ID

Line 417: update CS_FORUM_MESSAGES_TL T set (

413: from CS_FORUM_MESSAGES_B B
414: where B.MESSAGE_ID = T.MESSAGE_ID
415: );
416:
417: update CS_FORUM_MESSAGES_TL T set (
418: NAME,
419: DESCRIPTION,
420: COMPOSITE_ASSOC_COL --UNISRCH
421: ) = (select

Line 425: from CS_FORUM_MESSAGES_TL B

421: ) = (select
422: B.NAME,
423: B.DESCRIPTION,
424: 'a'
425: from CS_FORUM_MESSAGES_TL B
426: where B.MESSAGE_ID = T.MESSAGE_ID
427: and B.LANGUAGE = T.SOURCE_LANG)
428: where (
429: T.MESSAGE_ID,

Line 434: from CS_FORUM_MESSAGES_TL SUBB, CS_FORUM_MESSAGES_TL SUBT

430: T.LANGUAGE
431: ) in (select
432: SUBT.MESSAGE_ID,
433: SUBT.LANGUAGE
434: from CS_FORUM_MESSAGES_TL SUBB, CS_FORUM_MESSAGES_TL SUBT
435: where SUBB.MESSAGE_ID = SUBT.MESSAGE_ID
436: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
437: and (SUBB.NAME <> SUBT.NAME
438: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 447: insert into CS_FORUM_MESSAGES_TL (

443: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
444: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
445: ));
446:
447: insert into CS_FORUM_MESSAGES_TL (
448: MESSAGE_ID,
449: NAME,
450: DESCRIPTION,
451: CREATION_DATE,

Line 471: from CS_FORUM_MESSAGES_TL B, FND_LANGUAGES L

467: B.LAST_UPDATE_LOGIN,
468: L.LANGUAGE_CODE,
469: B.SOURCE_LANG,
470: 'a'
471: from CS_FORUM_MESSAGES_TL B, FND_LANGUAGES L
472: where L.INSTALLED_FLAG in ('I', 'B')
473: and B.LANGUAGE = userenv('LANG')
474: and not exists
475: (select NULL

Line 476: from CS_FORUM_MESSAGES_TL T

472: where L.INSTALLED_FLAG in ('I', 'B')
473: and B.LANGUAGE = userenv('LANG')
474: and not exists
475: (select NULL
476: from CS_FORUM_MESSAGES_TL T
477: where T.MESSAGE_ID = B.MESSAGE_ID
478: and T.LANGUAGE = L.LANGUAGE_CODE);
479: end ADD_LANGUAGE;
480:

Line 489: update cs_forum_messages_tl set

485: x_owner in varchar2
486: )
487: is
488: begin
489: update cs_forum_messages_tl set
490: description = x_description,
491: name = x_name,
492: LAST_UPDATE_DATE = sysdate,
493: LAST_UPDATED_BY = decode(x_owner, 'SEED', 1, 0),