APPS.ICX_POR_SCHEMA_UPLOAD dependencies on ICX_CAT_BROWSE_TREES

Line 262: INSERT INTO icx_cat_browse_trees

258:
259: xErrLoc := 300;
260:
261: --Changes for userId, loginId
262: INSERT INTO icx_cat_browse_trees
263: (parent_category_id, child_category_id,
264: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, LAST_UPDATE_DATE,
265: CREATED_BY, CREATION_DATE)
266: SELECT p_parent_id, p_child_id,

Line 270: FROM icx_cat_browse_trees

266: SELECT p_parent_id, p_child_id,
267: p_login_id, p_user_id, sysdate, p_user_id, sysdate
268: FROM DUAL
269: WHERE NOT EXISTS (SELECT NULL
270: FROM icx_cat_browse_trees
271: WHERE parent_category_id = p_parent_id
272: AND child_category_id = p_child_id);
273: xErrLoc := 400;
274: -- pcreddy # bug 2959731 :

Line 280: DELETE FROM icx_cat_browse_trees

276: IF (p_parent_id <> 0) THEN
277: -- 1775192
278: -- we also need to remove the child who is originally
279: -- a top level navigational category
280: DELETE FROM icx_cat_browse_trees
281: WHERE parent_category_id = 0
282: AND child_category_id = p_child_id;
283:
284: xErrLoc := 500;

Line 289: INSERT INTO icx_cat_browse_trees

285: -- Add entry for parent category into toc table
286: -- with its parentid=0: For Browse category to work
287: -- Bug#1681042: Only Exception: If the parent is already a child dont add
288: --Changes for userId, loginId
289: INSERT INTO icx_cat_browse_trees
290: (PARENT_CATEGORY_ID, CHILD_CATEGORY_ID,
291: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, LAST_UPDATE_DATE,
292: CREATED_BY, CREATION_DATE)
293: SELECT 0, p_parent_id, p_login_id, p_user_id, sysdate, p_user_id, sysdate

Line 296: FROM icx_cat_browse_trees

292: CREATED_BY, CREATION_DATE)
293: SELECT 0, p_parent_id, p_login_id, p_user_id, sysdate, p_user_id, sysdate
294: FROM DUAL
295: WHERE NOT EXISTS (SELECT NULL
296: FROM icx_cat_browse_trees
297: WHERE child_category_id = p_parent_id);
298: END IF;
299:
300: xErrLoc := 600;

Line 349: DELETE FROM ICX_CAT_BROWSE_TREES

345: end if;
346:
347: xErrLoc := 300;
348:
349: DELETE FROM ICX_CAT_BROWSE_TREES
350: WHERE PARENT_CATEGORY_ID = p_parent_id
351: AND CHILD_CATEGORY_ID = p_child_id;
352:
353: xErrLoc := 500;

Line 1016: ** Delete links from icx_cat_browse_trees;

1012: ** Desc : Delete category from icx_cat_categories_tl;
1013: ** Delete local descriptors from icx_cat_descriptors_tl;
1014: ** Dlete items from icx_por_items, icx_por_items_tl and
1015: ** icx_cat_category_items;
1016: ** Delete links from icx_cat_browse_trees;
1017: **/
1018: PROCEDURE delete_category (p_category_id IN NUMBER)
1019: IS
1020:

Line 1027: select child_category_id from icx_cat_browse_trees

1023: l_count NUMBER := 0;
1024: l_type NUMBER := 0;
1025:
1026: CURSOR toc_children(p_category_id number) IS
1027: select child_category_id from icx_cat_browse_trees
1028: where parent_category_id = p_category_id;
1029:
1030:
1031: BEGIN

Line 1051: delete from icx_cat_browse_trees

1047: where rt_category_id = p_category_id;
1048:
1049: xErrLoc := 300;
1050:
1051: delete from icx_cat_browse_trees
1052: where child_category_id = p_category_id;
1053:
1054: xErrLoc := 700;
1055: -- OEX_IP_PORTING: Check

Line 1061: delete from icx_cat_browse_trees

1057:
1058: xErrLoc := 800;
1059: FOR c_child IN toc_children(p_category_id) LOOP
1060:
1061: delete from icx_cat_browse_trees
1062: where child_category_id = c_child.child_category_id
1063: and parent_category_id = p_category_id;
1064: xErrLoc := 810;
1065:

Line 1067: from icx_cat_browse_trees

1063: and parent_category_id = p_category_id;
1064: xErrLoc := 810;
1065:
1066: select count(*) into l_count
1067: from icx_cat_browse_trees
1068: where child_category_id = c_child.child_category_id;
1069: xErrLoc := 820;
1070:
1071: if ( l_count = 0 ) then

Line 1080: INSERT INTO icx_cat_browse_trees

1076: xErrLoc := 830;
1077:
1078: -- only if the child is a navigational category
1079: if ( l_type = 1 ) then
1080: INSERT INTO icx_cat_browse_trees
1081: (parent_category_id, child_category_id,
1082: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, LAST_UPDATE_DATE,
1083: CREATED_BY, CREATION_DATE)
1084: VALUES

Line 1122: icx_cat_browse_trees toc

1118: CURSOR child_categories_csr (p_category_id NUMBER) IS
1119: select distinct cat.rt_category_id,
1120: cat.type
1121: from icx_cat_categories_tl cat,
1122: icx_cat_browse_trees toc
1123: where toc.parent_category_id = p_category_id
1124: and toc.child_category_id = cat.rt_category_id;
1125:
1126: BEGIN

Line 2133: WHERE exists (SELECT 1 FROM icx_cat_browse_trees

2129:
2130: BEGIN
2131: SELECT 1 INTO l_num_val
2132: FROM dual
2133: WHERE exists (SELECT 1 FROM icx_cat_browse_trees
2134: WHERE parent_category_id = p_parent_id
2135: AND child_category_id = p_child_id);
2136:
2137: EXCEPTION