eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_KB_SECURITY_PVT dependencies on CS_KB_SOLN_CATEGORIES_B

Line 656: FROM CS_KB_SOLN_CATEGORIES_B

652:
653:
654: CURSOR USED_IN_CATEGORY IS
655: SELECT count(*)
656: FROM CS_KB_SOLN_CATEGORIES_B
657: WHERE visibility_id = P_VISIBILITY_ID;
658:
659: CURSOR CHECK_VISIBILITY IS
660: SELECT count(*)

Line 1499: FROM cs_kb_soln_categories_b b

1495: FROM CS_KB_CAT_GROUP_MEMBERS m
1496: WHERE m.category_group_id = P_CATEGORY_GROUP_ID
1497: AND category_id in (
1498: SELECT b.category_id
1499: FROM cs_kb_soln_categories_b b
1500: START WITH b.category_id = P_CATEGORY_ID
1501: CONNECT BY PRIOR b.parent_category_id = b.category_id);
1502:
1503: l_count NUMBER;

Line 1598: FROM CS_KB_SOLN_CATEGORIES_B

1594: WHERE category_group_id = P_CATEGORY_GROUP_ID;
1595:
1596: CURSOR Validate_Category IS
1597: SELECT count(*)
1598: FROM CS_KB_SOLN_CATEGORIES_B
1599: WHERE category_id = P_CATEGORY_ID;
1600:
1601: BEGIN
1602: --dbms_output.put_line('In api-'||P_CATEGORY_GROUP_ID||' - '||P_CATEGORY_ID);

Line 1676: FROM cs_kb_soln_categories_b b

1672: --> Validate if any children already exist - if yes then remove !!!!
1673: DELETE FROM CS_KB_CAT_GROUP_MEMBERS
1674: WHERE CATEGORY_GROUP_ID = P_CATEGORY_GROUP_ID
1675: AND CATEGORY_ID IN (SELECT b.category_id
1676: FROM cs_kb_soln_categories_b b
1677: START WITH b.parent_category_id = P_CATEGORY_ID
1678: CONNECT BY PRIOR b.category_id = b.parent_category_id);
1679:
1680:

Line 1989: FROM cs_kb_soln_categories_b b

1985: CURSOR GET_CHILD_CATEGORIES IS
1986: SELECT New_Members.category_id, New_Members.visibility_id, v.position
1987: FROM (
1988: SELECT b.category_id, b.visibility_id
1989: FROM cs_kb_soln_categories_b b
1990: START WITH b.parent_category_id = P_CATEGORY_ID
1991: CONNECT BY PRIOR b.category_id = b.parent_category_id
1992: UNION
1993: SELECT b.category_id, b.visibility_id

Line 1994: FROM cs_kb_soln_categories_b b

1990: START WITH b.parent_category_id = P_CATEGORY_ID
1991: CONNECT BY PRIOR b.category_id = b.parent_category_id
1992: UNION
1993: SELECT b.category_id, b.visibility_id
1994: FROM cs_kb_soln_categories_b b
1995: WHERE b.category_id = P_CATEGORY_ID
1996: ) New_Members ,
1997: CS_KB_VISIBILITIES_b v
1998: WHERE New_Members.visibility_id = v.visibility_id

Line 2078: FROM cs_kb_soln_categories_b b

2074: ) IS
2075:
2076: CURSOR GET_CHILD_CATEGORIES IS
2077: SELECT b.category_id
2078: FROM cs_kb_soln_categories_b b
2079: START WITH b.parent_category_id = P_CATEGORY_ID
2080: CONNECT BY PRIOR b.category_id = b.parent_category_id
2081: UNION
2082: SELECT b.category_id

Line 2083: FROM cs_kb_soln_categories_b b

2079: START WITH b.parent_category_id = P_CATEGORY_ID
2080: CONNECT BY PRIOR b.category_id = b.parent_category_id
2081: UNION
2082: SELECT b.category_id
2083: FROM cs_kb_soln_categories_b b
2084: WHERE b.category_id = P_CATEGORY_ID;
2085:
2086:
2087: --Type NumTabType is VARRAY(10000) of NUMBER;

Line 2128: -- 1) If a New Category is added to CS_KB_SOLN_CATEGORIES_B then this api

2124: --
2125: --
2126: --
2127: -- Notes :
2128: -- 1) If a New Category is added to CS_KB_SOLN_CATEGORIES_B then this api
2129: -- is used to update the Denorm table with this new Category_Id if
2130: -- any Category Groups already include its parent
2131: --
2132: -- Used By:

Line 2146: FROM CS_KB_SOLN_CATEGORIES_B

2142: ) IS
2143:
2144: CURSOR Validate_Category IS
2145: SELECT Category_id
2146: FROM CS_KB_SOLN_CATEGORIES_B
2147: WHERE Category_id = P_CATEGORY_ID
2148: AND Parent_Category_Id = P_PARENT_CATEGORY_ID;
2149:
2150: CURSOR Get_Visibility_Position IS

Line 2296: FROM CS_KB_SOLN_CATEGORIES_B

2292: ) IS
2293:
2294: CURSOR Validate_Category IS
2295: SELECT Category_id, Visibility_id
2296: FROM CS_KB_SOLN_CATEGORIES_B
2297: WHERE Category_id = P_CATEGORY_ID;
2298:
2299: CURSOR Get_Position IS
2300: SELECT Position

Line 2496: FROM cs_kb_soln_categories_b b , CS_KB_VISIBILITIES_b v

2492: ) RETURN VARCHAR2 IS
2493:
2494: CURSOR GET_CHILD_CATEGORIES ( v_cg NUMBER) IS
2495: SELECT b.category_id, b.visibility_id , v.position
2496: FROM cs_kb_soln_categories_b b , CS_KB_VISIBILITIES_b v
2497: WHERE b.visibility_id = v.visibility_id
2498: START WITH b.parent_category_id in (select m.category_id
2499: FROM CS_KB_CAT_GROUP_MEMBERS m
2500: where m.category_group_id = v_cg)

Line 2504: FROM cs_kb_soln_categories_b b, CS_KB_VISIBILITIES_b v

2500: where m.category_group_id = v_cg)
2501: CONNECT BY PRIOR b.category_id = b.parent_category_id
2502: UNION
2503: SELECT b.category_id, b.visibility_id, v.position
2504: FROM cs_kb_soln_categories_b b, CS_KB_VISIBILITIES_b v
2505: WHERE b.category_id in (select m.category_id
2506: FROM CS_KB_CAT_GROUP_MEMBERS m
2507: where m.category_group_id = v_cg)
2508: AND b.visibility_id = v.visibility_id;

Line 2577: FROM cs_kb_soln_categories_b b , CS_KB_VISIBILITIES_b v

2573: RETURN VARCHAR2 IS
2574:
2575: CURSOR GET_CHILD_CATEGORIES ( v_cg NUMBER) IS
2576: SELECT b.category_id, b.visibility_id , v.position
2577: FROM cs_kb_soln_categories_b b , CS_KB_VISIBILITIES_b v
2578: WHERE b.visibility_id = v.visibility_id
2579: START WITH b.parent_category_id in (select m.category_id
2580: FROM CS_KB_CAT_GROUP_MEMBERS m
2581: where m.category_group_id = v_cg)

Line 2585: FROM cs_kb_soln_categories_b b, CS_KB_VISIBILITIES_b v

2581: where m.category_group_id = v_cg)
2582: CONNECT BY PRIOR b.category_id = b.parent_category_id
2583: UNION
2584: SELECT b.category_id, b.visibility_id, v.position
2585: FROM cs_kb_soln_categories_b b, CS_KB_VISIBILITIES_b v
2586: WHERE b.category_id in (select m.category_id
2587: FROM CS_KB_CAT_GROUP_MEMBERS m
2588: where m.category_group_id = v_cg)
2589: AND b.visibility_id = v.visibility_id;

Line 3084: FROM CS_KB_SOLN_CATEGORIES_B c

3080:
3081:
3082: CURSOR Get_Moved_Categories IS
3083: SELECT c.category_id, c.parent_category_id, c.visibility_id
3084: FROM CS_KB_SOLN_CATEGORIES_B c
3085: START WITH c.category_id = P_CATEGORY_ID
3086: CONNECT BY PRIOR c.category_id = c.parent_category_id
3087: ORDER BY level asc;
3088:

Line 3105: FROM cs_kb_soln_categories_b b

3101: -- Catageory and its Children except where this Category has been directly
3102: -- associated to a Category Group (via a link in CS_KB_CAT_GROUP_MEMBERS)
3103: DELETE FROM cs_kb_cat_group_denorm d
3104: WHERE d.child_category_id IN (SELECT b.category_id
3105: FROM cs_kb_soln_categories_b b
3106: START WITH b.category_id = P_CATEGORY_ID
3107: CONNECT BY PRIOR b.category_id =
3108: b.parent_category_id)
3109:

Line 3113: FROM cs_kb_soln_categories_b b

3109:
3110: AND NOT EXISTS (SELECT 'x'
3111: FROM cs_kb_cat_group_members m
3112: WHERE m.category_id IN ( SELECT b.category_id
3113: FROM cs_kb_soln_categories_b b
3114: START WITH b.category_id =
3115: P_CATEGORY_ID
3116: CONNECT BY PRIOR
3117: b.category_id = b.parent_category_id)