APPS.ICX_POR_SCHEMA_UPLOAD dependencies on ICX_CAT_CATEGORY_ITEMS

Line 1015: ** icx_cat_category_items;

1011: ** Proc : delete_category
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

Line 1530: SELECT 1 FROM icx_cat_category_items);

1526:
1527: IF (p_owner_id = 0) THEN
1528: SELECT 1 INTO l_num_val
1529: FROM dual WHERE EXISTS (
1530: SELECT 1 FROM icx_cat_category_items);
1531:
1532: ELSE
1533: SELECT 1 INTO l_num_val
1534: FROM dual WHERE EXISTS (

Line 1535: SELECT 1 FROM icx_cat_category_items

1531:
1532: ELSE
1533: SELECT 1 INTO l_num_val
1534: FROM dual WHERE EXISTS (
1535: SELECT 1 FROM icx_cat_category_items
1536: WHERE rt_category_id = p_owner_id);
1537:
1538: END IF;
1539:

Line 1862: WHERE EXISTS (SELECT 1 FROM icx_cat_category_items

1858:
1859: -- check if there are any items in this category
1860: SELECT 1 INTO l_num_val
1861: FROM dual
1862: WHERE EXISTS (SELECT 1 FROM icx_cat_category_items
1863: WHERE rt_category_id = p_category_id);
1864:
1865: InsertError(p_request_id, 'ICX_POR_CATEGORY_KEY', 'ICX_POR_CAT_HAS_ITEMS',
1866: p_line_number);