APPS.CS_FORUM_CATEGORIES_PKG dependencies on CS_FORUM_CATEGORIES_TL

Line 90: insert into CS_FORUM_CATEGORIES_TL (

86: X_ATTRIBUTE14,
87: X_ATTRIBUTE15
88: );
89:
90: insert into CS_FORUM_CATEGORIES_TL (
91: CATEGORY_ID,
92: NAME,
93: DESCRIPTION,
94: CREATION_DATE,

Line 116: from CS_FORUM_CATEGORIES_TL T

112: from FND_LANGUAGES L
113: where L.INSTALLED_FLAG in ('I', 'B')
114: and not exists
115: (select NULL
116: from CS_FORUM_CATEGORIES_TL T
117: where T.CATEGORY_ID = X_CATEGORY_ID
118: and T.LANGUAGE = L.LANGUAGE_CODE);
119:
120: open c;

Line 184: from CS_FORUM_CATEGORIES_TL

180: cursor c1 is select
181: NAME,
182: DESCRIPTION,
183: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
184: from CS_FORUM_CATEGORIES_TL
185: where CATEGORY_ID = X_CATEGORY_ID
186: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
187: for update of CATEGORY_ID nowait;
188: begin

Line 315: update CS_FORUM_CATEGORIES_TL set

311: if (sql%notfound) then
312: raise no_data_found;
313: end if;
314:
315: update CS_FORUM_CATEGORIES_TL set
316: NAME = X_NAME,
317: DESCRIPTION = X_DESCRIPTION,
318: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
319: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 334: delete from CS_FORUM_CATEGORIES_TL

330: procedure DELETE_ROW (
331: X_CATEGORY_ID in NUMBER
332: ) is
333: begin
334: delete from CS_FORUM_CATEGORIES_TL
335: where CATEGORY_ID = X_CATEGORY_ID;
336:
337: /*
338: if (sql%notfound) then

Line 355: delete from CS_FORUM_CATEGORIES_TL T

351:
352: procedure ADD_LANGUAGE
353: is
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

Line 362: update CS_FORUM_CATEGORIES_TL T set (

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 (
363: NAME,
364: DESCRIPTION
365: ) = (select
366: B.NAME,

Line 368: from CS_FORUM_CATEGORIES_TL B

364: DESCRIPTION
365: ) = (select
366: B.NAME,
367: B.DESCRIPTION
368: from CS_FORUM_CATEGORIES_TL B
369: where B.CATEGORY_ID = T.CATEGORY_ID
370: and B.LANGUAGE = T.SOURCE_LANG)
371: where (
372: T.CATEGORY_ID,

Line 377: from CS_FORUM_CATEGORIES_TL SUBB, CS_FORUM_CATEGORIES_TL SUBT

373: T.LANGUAGE
374: ) in (select
375: SUBT.CATEGORY_ID,
376: SUBT.LANGUAGE
377: from CS_FORUM_CATEGORIES_TL SUBB, CS_FORUM_CATEGORIES_TL SUBT
378: where SUBB.CATEGORY_ID = SUBT.CATEGORY_ID
379: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
380: and (SUBB.NAME <> SUBT.NAME
381: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 388: insert into CS_FORUM_CATEGORIES_TL (

384: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
385: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
386: ));
387:
388: insert into CS_FORUM_CATEGORIES_TL (
389: CATEGORY_ID,
390: NAME,
391: DESCRIPTION,
392: CREATION_DATE,

Line 410: from CS_FORUM_CATEGORIES_TL B, FND_LANGUAGES L

406: B.LAST_UPDATED_BY,
407: B.LAST_UPDATE_LOGIN,
408: L.LANGUAGE_CODE,
409: B.SOURCE_LANG
410: from CS_FORUM_CATEGORIES_TL B, FND_LANGUAGES L
411: where L.INSTALLED_FLAG in ('I', 'B')
412: and B.LANGUAGE = userenv('LANG')
413: and not exists
414: (select NULL

Line 415: from CS_FORUM_CATEGORIES_TL T

411: where L.INSTALLED_FLAG in ('I', 'B')
412: and B.LANGUAGE = userenv('LANG')
413: and not exists
414: (select NULL
415: from CS_FORUM_CATEGORIES_TL T
416: where T.CATEGORY_ID = B.CATEGORY_ID
417: and T.LANGUAGE = L.LANGUAGE_CODE);
418: end ADD_LANGUAGE;
419:

Line 430: update cs_forum_categories_tl set

426: x_owner in varchar2
427: )
428: is
429: begin
430: update cs_forum_categories_tl set
431: description = x_description,
432: name = x_name,
433: LAST_UPDATE_DATE = sysdate,
434: LAST_UPDATED_BY = decode(x_owner, 'SEED', 1, 0),