APPS.CSK_SETUP_UTILITY_PKG dependencies on CS_KB_SOLN_CATEGORIES_TL

Line 383: DELETE FROM cs_kb_soln_categories_tl WHERE CATEGORY_ID = P_CATEGORY_ID;

379:
380: BEGIN
381:
382: DELETE FROM cs_kb_soln_categories_b WHERE CATEGORY_ID = P_CATEGORY_ID;
383: DELETE FROM cs_kb_soln_categories_tl WHERE CATEGORY_ID = P_CATEGORY_ID;
384:
385: insert into CS_KB_SOLN_CATEGORIES_B
386: (
387: CATEGORY_ID,

Line 407: insert into CS_KB_SOLN_CATEGORIES_TL

403: -1351,
404: P_VISIBILITY_ID
405: );
406:
407: insert into CS_KB_SOLN_CATEGORIES_TL
408: (
409: CATEGORY_ID,
410: NAME,
411: DESCRIPTION,

Line 435: from CS_KB_SOLN_CATEGORIES_TL T

431: from FND_LANGUAGES L
432: where L.INSTALLED_FLAG in ('I', 'B')
433: and not exists
434: (select NULL
435: from CS_KB_SOLN_CATEGORIES_TL T
436: where T.CATEGORY_ID = P_CATEGORY_ID
437: and T.LANGUAGE = L.LANGUAGE_CODE);
438:
439: OPEN Get_Posn;

Line 497: delete from cs_kb_soln_categories_tl

493: delete /*+ index(sl) */ from cs_kb_set_categories sl
494: where sl.category_id = p_category_id;
495:
496: -- Delete this leaf category
497: delete from cs_kb_soln_categories_tl
498: where category_id = p_category_id;
499:
500: delete from cs_kb_soln_categories_b
501: where category_id = p_category_id;