[Home] [Help]
21: -- 1. Get local content zones with sqe_sequence not populated due to size
22: -- restriction
23: -- 2. For each of the zones, find the category count. Group them into
24: -- multiple zones with 150 categories each.
25: -- 3. Create icx_cat_content_zones_b, icx_cat_content_zones_tl for each of
26: -- these new zones.
27: -- 4. Duplicate the supplier restrictions from the original zones to the new
28: -- zones.
29: -- 5. Create Category restrictions to these new zones.
54: l_err_loc := 0;
55:
56: SELECT zone_id
57: BULK COLLECT INTO l_original_zone_ids
58: FROM icx_cat_content_zones_b
59: WHERE type='LOCAL'
60: AND category_attribute_action_flag='INCLUDE'
61: AND sqe_sequence IS NULL;
62:
212:
213: l_err_loc := 0;
214:
215: FORALL i IN 1..p_new_zone_ids.COUNT
216: INSERT INTO icx_cat_content_zones_b
217: (zone_id, type, url, security_assignment_flag,
218: category_attribute_action_flag, supplier_attribute_action_flag,
219: items_without_supplier_flag, items_without_shop_catg_flag,
220: created_by, creation_date, last_updated_by,
223: zones.category_attribute_action_flag, zones.supplier_attribute_action_flag,
224: zones.items_without_supplier_flag, zones.items_without_shop_catg_flag,
225: zones.created_by, zones.creation_date, zones.last_updated_by,
226: zones.last_update_date, zones.last_update_login
227: FROM icx_cat_content_zones_b zones
228: WHERE zones.zone_id = p_old_zone_id;
229:
230: l_err_loc := 100;
231:
442: WHERE zone_id=p_old_zone_id;
443:
444: l_err_loc := 400;
445:
446: -- delete from icx_cat_content_zones_b
447: DELETE icx_cat_content_zones_b
448: WHERE zone_id=p_old_zone_id;
449:
450: l_err_loc := 500;
443:
444: l_err_loc := 400;
445:
446: -- delete from icx_cat_content_zones_b
447: DELETE icx_cat_content_zones_b
448: WHERE zone_id=p_old_zone_id;
449:
450: l_err_loc := 500;
451: