APPS.CS_KB_SOLN_CATEGORIES_PVT dependencies on CS_KB_SOLN_CATEGORIES_B

Line 147: from cs_kb_soln_categories_b

143: --and b.status = 'PUB';
144: and (b.status = 'PUB' or (b.status <> 'OBS' and b.latest_version_flag = 'Y'));
145:
146: select count( * ) into n_subcatgories
147: from cs_kb_soln_categories_b
148: where parent_category_id = p_category_id;
149:
150: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
151: -- check if the category is deletable

Line 236: FROM cs_kb_soln_categories_b SolnCategoryEO

232: cursor Get_Descendent_Categories
233: ( cp_category_id number)
234: is
235: SELECT SolnCategoryEO.CATEGORY_ID
236: FROM cs_kb_soln_categories_b SolnCategoryEO
237: start with SolnCategoryEO.CATEGORY_ID = cp_category_id
238: connect by prior CATEGORY_ID = PARENT_CATEGORY_ID
239: order by level desc;
240: cursor Get_Category_Fullpath_Name

Line 352: FROM CS_KB_SOLN_CATEGORIES_B

348: l_category_id number;
349:
350: CURSOR GET_ORIGINAL_CAT_VISIBILITY IS
351: SELECT Visibility_Id
352: FROM CS_KB_SOLN_CATEGORIES_B
353: WHERE Category_Id = p_category_id;
354:
355: CURSOR GET_ORIGINAL_PARENT_CAT IS
356: SELECT parent_category_Id

Line 357: FROM CS_KB_SOLN_CATEGORIES_B

353: WHERE Category_Id = p_category_id;
354:
355: CURSOR GET_ORIGINAL_PARENT_CAT IS
356: SELECT parent_category_Id
357: FROM CS_KB_SOLN_CATEGORIES_B
358: WHERE Category_Id = p_category_id;
359:
360: CURSOR Get_Moved_Categories IS
361: SELECT c.category_id

Line 362: FROM CS_KB_SOLN_CATEGORIES_B c

358: WHERE Category_Id = p_category_id;
359:
360: CURSOR Get_Moved_Categories IS
361: SELECT c.category_id
362: FROM CS_KB_SOLN_CATEGORIES_B c
363: START WITH c.category_id = P_CATEGORY_ID
364: CONNECT BY PRIOR c.category_id = c.parent_category_id
365: ORDER BY level asc;
366:

Line 642: FROM cs_kb_soln_categories_b

638: p_category_group_id number,
639: p_soln_visibility_position number) is
640: select tl.name--, b.category_id, b.lev
641: from ( SELECT category_id, level lev
642: FROM cs_kb_soln_categories_b
643: START WITH category_id = p_cat_id
644: CONNECT BY prior parent_category_id = category_id
645: ) b, cs_kb_soln_categories_tl tl, cs_kb_cat_group_denorm mv
646: where

Line 685: FROM cs_kb_soln_categories_b

681: return varchar2 is
682: cursor c_fullpath_names( cat_id number ) is
683: select tl.name--, b.category_id, b.lev
684: from ( SELECT category_id, level lev
685: FROM cs_kb_soln_categories_b
686: START WITH category_id = cat_id
687: CONNECT BY prior parent_category_id = category_id
688: ) b, cs_kb_soln_categories_tl tl
689: where

Line 717: FROM cs_kb_soln_categories_b

713: function admin_cat_fullpath_ids( category_id number )
714: return varchar2 is
715: cursor c_fullpath_ids( cat_id number ) is
716: SELECT category_id
717: FROM cs_kb_soln_categories_b
718: START WITH category_id = cat_id
719: CONNECT BY prior parent_category_id = category_id
720: order by level desc;
721:

Line 747: FROM cs_kb_soln_categories_b

743: return varchar2 is
744: cursor get_descendents(cp_category_id number)
745: is
746: SELECT CATEGORY_ID
747: FROM cs_kb_soln_categories_b
748: start with CATEGORY_ID = cp_category_id
749: connect by prior CATEGORY_ID = PARENT_CATEGORY_ID;
750:
751: cursor get_pub_inprog(cp_category_id number)