APPS.ICX_CAT_SQE_PVT dependencies on ICX_CAT_CONTENT_ZONES_B

Line 819: FROM icx_cat_content_zones_b zones, icx_cat_content_zones_tl zonestl

815: SELECT zones.zone_id, zonestl.name, supplier_attribute_action_flag, category_attribute_action_flag,
816: items_without_supplier_flag, items_without_shop_catg_flag, sqe_sequence
817: BULK COLLECT INTO l_content_zone_ids, l_content_zone_names, l_supplier_attr_action_flags,
818: l_category_attr_action_flags, l_items_without_supplier_flags, l_items_without_shop_cat_flags, l_sqe_sequences
819: FROM icx_cat_content_zones_b zones, icx_cat_content_zones_tl zonestl
820: WHERE zones.type = 'LOCAL'
821: AND zones.category_attribute_action_flag IN ('INCLUDE', 'EXCLUDE')
822: AND zones.zone_id = zonestl.zone_id
823: AND zonestl.language = USERENV('LANG');

Line 887: UPDATE icx_cat_content_zones_b

883:
884: l_err_loc := 800;
885: -- now update all the content zones with the new sqe sequences
886: FORALL i IN 1..l_content_zone_ids.COUNT
887: UPDATE icx_cat_content_zones_b
888: SET sqe_sequence = l_sqe_sequences(i)
889: WHERE zone_id = l_content_zone_ids(i);
890:
891: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1112: FROM icx_cat_content_zones_b zones, icx_cat_content_zones_tl zonestl

1108: SELECT zones.zone_id, zonestl.name, supplier_attribute_action_flag, category_attribute_action_flag,
1109: items_without_supplier_flag, items_without_shop_catg_flag, sqe_sequence
1110: BULK COLLECT INTO l_content_zone_ids, l_content_zone_names, l_supplier_attr_action_flags,
1111: l_category_attr_action_flags, l_items_without_supplier_flags, l_items_without_shop_cat_flags, l_sqe_sequences
1112: FROM icx_cat_content_zones_b zones, icx_cat_content_zones_tl zonestl
1113: WHERE zones.type = 'LOCAL'
1114: AND zones.zone_id = zonestl.zone_id
1115: AND zonestl.language = USERENV('LANG');
1116:

Line 1178: UPDATE icx_cat_content_zones_b

1174:
1175: l_err_loc := 800;
1176: -- now update all the content zones with the new sqe sequences
1177: FORALL i IN 1..l_content_zone_ids.COUNT
1178: UPDATE icx_cat_content_zones_b
1179: SET sqe_sequence = l_sqe_sequences(i)
1180: WHERE zone_id = l_content_zone_ids(i);
1181:
1182: l_err_loc := 900;