APPS.CSK_SETUP_UTILITY_PKG dependencies on CS_KB_SOLN_CATEGORIES_B

Line 382: DELETE FROM cs_kb_soln_categories_b WHERE CATEGORY_ID = P_CATEGORY_ID;

378: l_posn NUMBER;
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: (

Line 385: insert into CS_KB_SOLN_CATEGORIES_B

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,
388: PARENT_CATEGORY_ID,
389: CREATION_DATE,

Line 476: from cs_kb_soln_categories_b

472: and b.set_id = sl.set_id
473: and (b.status = 'PUB' or (b.status <> 'OBS' and b.latest_version_flag = 'Y'));
474:
475: select count( * ) into n_subcatgories
476: from cs_kb_soln_categories_b
477: where parent_category_id = p_category_id;
478:
479: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
480: -- check if the category is deletable

Line 500: delete from cs_kb_soln_categories_b

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;
502:
503: -- cs_kb_security_pvt.REMOVE_CATEGORY_FROM_CAT_GROUP
504: -- Removes Category from Members table if the Category Exists