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_CAT_GROUP_MEMBERS

Line 1305: FROM CS_KB_CAT_GROUP_MEMBERS

1301: WHERE category_group_id = P_CATEGORY_GROUP_ID;
1302:
1303: CURSOR CHECK_MEMBERS IS
1304: SELECT count(*)
1305: FROM CS_KB_CAT_GROUP_MEMBERS
1306: WHERE category_group_id = P_CATEGORY_GROUP_ID;
1307:
1308: CURSOR CHECK_FLOWS IS
1309: SELECT count(*)

Line 1495: FROM CS_KB_CAT_GROUP_MEMBERS m

1491: ) RETURN VARCHAR2 IS
1492:
1493: CURSOR CHECK_PARENT IS
1494: SELECT count(m.category_id)
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

Line 1587: FROM CS_KB_CAT_GROUP_MEMBERS

1583: l_return_status VARCHAR2(1);
1584:
1585: CURSOR Check_Insert (v_cg_id NUMBER, v_cat_id NUMBER) IS
1586: SELECT COUNT(*)
1587: FROM CS_KB_CAT_GROUP_MEMBERS
1588: WHERE CATEGORY_GROUP_ID = v_cg_id
1589: AND CATEGORY_ID = v_cat_id;
1590:
1591: CURSOR Validate_Category_Group IS

Line 1637: CS_KB_CAT_GROUP_MEMBERS_PKG.INSERT_ROW (

1633: -- Category Group Member already exists
1634: RAISE DUP_CATEGORY_GROUP_MEMBER;
1635: ELSE
1636: --dbms_output.put_line('before insert-');
1637: CS_KB_CAT_GROUP_MEMBERS_PKG.INSERT_ROW (
1638: X_ROWID => l_rowid,
1639: X_CATEGORY_GROUP_ID => P_CATEGORY_GROUP_ID ,
1640: X_CATEGORY_ID => P_CATEGORY_ID ,
1641: X_CREATION_DATE => l_date,

Line 1673: DELETE FROM CS_KB_CAT_GROUP_MEMBERS

1669: RAISE INSERT_FAILED;
1670: ELSE
1671:
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

Line 1823: FROM CS_KB_CAT_GROUP_MEMBERS

1819:
1820:
1821: CURSOR CHECK_DELETE IS
1822: SELECT count(*)
1823: FROM CS_KB_CAT_GROUP_MEMBERS
1824: WHERE category_group_id = P_CATEGORY_GROUP_ID
1825: AND category_id = P_CATEGORY_ID;
1826:
1827:

Line 1852: CS_KB_CAT_GROUP_MEMBERS_PKG.DELETE_ROW (X_CATEGORY_GROUP_ID => P_CATEGORY_GROUP_ID,

1848: FETCH CHECK_DELETE INTO l_valid;
1849: CLOSE CHECK_DELETE;
1850:
1851: IF l_valid <> 0 THEN
1852: CS_KB_CAT_GROUP_MEMBERS_PKG.DELETE_ROW (X_CATEGORY_GROUP_ID => P_CATEGORY_GROUP_ID,
1853: X_CATEGORY_ID => P_CATEGORY_ID);
1854:
1855: OPEN CHECK_DELETE;
1856: FETCH CHECK_DELETE INTO l_valid;

Line 1974: -- 1) For every Category_Id added to the CS_KB_CAT_GROUP_MEMBERS table

1970: --
1971: --
1972: --
1973: -- Notes :
1974: -- 1) For every Category_Id added to the CS_KB_CAT_GROUP_MEMBERS table
1975: -- this api populates the Denorm table with the Member Category_id
1976: -- and all of its Children
1977: --
1978: -- Used By:

Line 2066: -- 1) For every Category_Id deleted from the CS_KB_CAT_GROUP_MEMBERS table

2062: --
2063: --
2064: --
2065: -- Notes :
2066: -- 1) For every Category_Id deleted from the CS_KB_CAT_GROUP_MEMBERS table
2067: -- this api deleted the corresponding rows in the Denorm table (Member + Children)
2068: --
2069: -- Used By:
2070: -- 1) DELETE_CATEGORY_GROUP_MEMBER

Line 2393: -- CS_KB_CAT_GROUP_MEMBERS and CS_KB_CAT_GROUP_DENORM

2389: --
2390: --
2391: -- Notes :
2392: -- 1) If a Category is deleted this api will remove the FK links in
2393: -- CS_KB_CAT_GROUP_MEMBERS and CS_KB_CAT_GROUP_DENORM
2394: --
2395: --
2396: -- Used By:
2397: -- 1) CS_KB_SOLN_CATEGORIES_PVT.removeCategory

Line 2408: FROM CS_KB_CAT_GROUP_MEMBERS

2404: ) IS
2405:
2406: CURSOR Check_Delete_Member IS
2407: SELECT count(*)
2408: FROM CS_KB_CAT_GROUP_MEMBERS
2409: WHERE Category_id = P_CATEGORY_ID;
2410:
2411: CURSOR Check_Delete_Denorm IS
2412: SELECT count(*)

Line 2425: DELETE FROM CS_KB_CAT_GROUP_MEMBERS

2421: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2422:
2423: IF P_CATEGORY_ID IS NOT NULL THEN
2424: -- 1. Removes Category from Members table if the Category Exists
2425: DELETE FROM CS_KB_CAT_GROUP_MEMBERS
2426: WHERE Category_Id = P_CATEGORY_ID;
2427: -- 2. Removes Category from Denorm table if the Category Exists
2428: DELETE FROM CS_KB_CAT_GROUP_DENORM
2429: WHERE Child_Category_Id = P_CATEGORY_ID;

Line 2499: FROM CS_KB_CAT_GROUP_MEMBERS m

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)
2501: CONNECT BY PRIOR b.category_id = b.parent_category_id
2502: UNION
2503: SELECT b.category_id, b.visibility_id, v.position

Line 2506: FROM CS_KB_CAT_GROUP_MEMBERS m

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;
2509:
2510: --Type NumTabType is VARRAY(10000) of NUMBER;

Line 2580: FROM CS_KB_CAT_GROUP_MEMBERS m

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)
2582: CONNECT BY PRIOR b.category_id = b.parent_category_id
2583: UNION
2584: SELECT b.category_id, b.visibility_id, v.position

Line 2587: FROM CS_KB_CAT_GROUP_MEMBERS m

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;
2590:
2591: CURSOR GET_CATEGORY_GROUPS IS

Line 3102: -- associated to a Category Group (via a link in CS_KB_CAT_GROUP_MEMBERS)

3098:
3099:
3100: -- Firstly Delete all the Records in the Denorm Table For the Moved
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

Line 3111: FROM cs_kb_cat_group_members m

3107: CONNECT BY PRIOR b.category_id =
3108: b.parent_category_id)
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