APPS.CS_KB_CATEGORY_GROUPS_PKG dependencies on CS_KB_CATEGORY_GROUPS_TL

Line 88: insert into CS_KB_CATEGORY_GROUPS_TL (

84: X_LAST_UPDATED_BY,
85: X_LAST_UPDATE_LOGIN
86: );
87:
88: insert into CS_KB_CATEGORY_GROUPS_TL (
89: CATEGORY_GROUP_ID,
90: NAME,
91: DESCRIPTION,
92: CREATION_DATE,

Line 114: from CS_KB_CATEGORY_GROUPS_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_KB_CATEGORY_GROUPS_TL T
115: where T.CATEGORY_GROUP_ID = X_CATEGORY_GROUP_ID
116: and T.LANGUAGE = L.LANGUAGE_CODE);
117:
118: open c;

Line 179: from CS_KB_CATEGORY_GROUPS_TL

175: cursor c1 is select
176: NAME,
177: DESCRIPTION,
178: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
179: from CS_KB_CATEGORY_GROUPS_TL
180: where CATEGORY_GROUP_ID = X_CATEGORY_GROUP_ID
181: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
182: for update of CATEGORY_GROUP_ID nowait;
183: begin

Line 306: update CS_KB_CATEGORY_GROUPS_TL set

302: if (sql%notfound) then
303: raise no_data_found;
304: end if;
305:
306: update CS_KB_CATEGORY_GROUPS_TL set
307: NAME = X_NAME,
308: DESCRIPTION = X_DESCRIPTION,
309: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
310: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 325: delete from CS_KB_CATEGORY_GROUPS_TL

321: procedure DELETE_ROW (
322: X_CATEGORY_GROUP_ID in NUMBER
323: ) is
324: begin
325: delete from CS_KB_CATEGORY_GROUPS_TL
326: where CATEGORY_GROUP_ID = X_CATEGORY_GROUP_ID;
327:
328: if (sql%notfound) then
329: raise no_data_found;

Line 343: delete from CS_KB_CATEGORY_GROUPS_TL T

339:
340: procedure ADD_LANGUAGE
341: is
342: begin
343: delete from CS_KB_CATEGORY_GROUPS_TL T
344: where not exists
345: (select NULL
346: from CS_KB_CATEGORY_GROUPS_B B
347: where B.CATEGORY_GROUP_ID = T.CATEGORY_GROUP_ID

Line 350: update CS_KB_CATEGORY_GROUPS_TL T set (

346: from CS_KB_CATEGORY_GROUPS_B B
347: where B.CATEGORY_GROUP_ID = T.CATEGORY_GROUP_ID
348: );
349:
350: update CS_KB_CATEGORY_GROUPS_TL T set (
351: NAME,
352: DESCRIPTION
353: ) = (select
354: B.NAME,

Line 356: from CS_KB_CATEGORY_GROUPS_TL B

352: DESCRIPTION
353: ) = (select
354: B.NAME,
355: B.DESCRIPTION
356: from CS_KB_CATEGORY_GROUPS_TL B
357: where B.CATEGORY_GROUP_ID = T.CATEGORY_GROUP_ID
358: and B.LANGUAGE = T.SOURCE_LANG)
359: where (
360: T.CATEGORY_GROUP_ID,

Line 365: from CS_KB_CATEGORY_GROUPS_TL SUBB, CS_KB_CATEGORY_GROUPS_TL SUBT

361: T.LANGUAGE
362: ) in (select
363: SUBT.CATEGORY_GROUP_ID,
364: SUBT.LANGUAGE
365: from CS_KB_CATEGORY_GROUPS_TL SUBB, CS_KB_CATEGORY_GROUPS_TL SUBT
366: where SUBB.CATEGORY_GROUP_ID = SUBT.CATEGORY_GROUP_ID
367: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
368: and (SUBB.NAME <> SUBT.NAME
369: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 374: insert into CS_KB_CATEGORY_GROUPS_TL (

370: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
371: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
372: ));
373:
374: insert into CS_KB_CATEGORY_GROUPS_TL (
375: CATEGORY_GROUP_ID,
376: NAME,
377: DESCRIPTION,
378: CREATION_DATE,

Line 396: from CS_KB_CATEGORY_GROUPS_TL B, FND_LANGUAGES L

392: B.LAST_UPDATED_BY,
393: B.LAST_UPDATE_LOGIN,
394: L.LANGUAGE_CODE,
395: B.SOURCE_LANG
396: from CS_KB_CATEGORY_GROUPS_TL B, FND_LANGUAGES L
397: where L.INSTALLED_FLAG in ('I', 'B')
398: and B.LANGUAGE = userenv('LANG')
399: and not exists
400: (select NULL

Line 401: from CS_KB_CATEGORY_GROUPS_TL T

397: where L.INSTALLED_FLAG in ('I', 'B')
398: and B.LANGUAGE = userenv('LANG')
399: and not exists
400: (select NULL
401: from CS_KB_CATEGORY_GROUPS_TL T
402: where T.CATEGORY_GROUP_ID = B.CATEGORY_GROUP_ID
403: and T.LANGUAGE = L.LANGUAGE_CODE);
404: end ADD_LANGUAGE;
405:

Line 415: UPDATE CS_KB_CATEGORY_GROUPS_TL

411: X_OWNER IN VARCHAR2
412: )
413: IS
414: BEGIN
415: UPDATE CS_KB_CATEGORY_GROUPS_TL
416: SET
417: name = X_NAME,
418: description = X_DESCRIPTION,
419: last_update_date = sysdate,