APPS.ICX_CAT_SQE_PVT dependencies on ICX_CAT_CONTENT_ZONES_B

Line 808: FROM icx_cat_content_zones_b zones, icx_cat_content_zones_tl zonestl

804: SELECT zones.zone_id, zonestl.name, supplier_attribute_action_flag, category_attribute_action_flag,
805: items_without_supplier_flag, items_without_shop_catg_flag, sqe_sequence
806: BULK COLLECT INTO l_content_zone_ids, l_content_zone_names, l_supplier_attr_action_flags,
807: l_category_attr_action_flags, l_items_without_supplier_flags, l_items_without_shop_cat_flags, l_sqe_sequences
808: FROM icx_cat_content_zones_b zones, icx_cat_content_zones_tl zonestl
809: WHERE zones.type = 'LOCAL'
810: AND zones.category_attribute_action_flag IN ('INCLUDE', 'EXCLUDE')
811: AND zones.zone_id = zonestl.zone_id
812: AND zonestl.language = USERENV('LANG');

Line 876: UPDATE icx_cat_content_zones_b

872:
873: l_err_loc := 800;
874: -- now update all the content zones with the new sqe sequences
875: FORALL i IN 1..l_content_zone_ids.COUNT
876: UPDATE icx_cat_content_zones_b
877: SET sqe_sequence = l_sqe_sequences(i)
878: WHERE zone_id = l_content_zone_ids(i);
879:
880: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1101: FROM icx_cat_content_zones_b zones, icx_cat_content_zones_tl zonestl

1097: SELECT zones.zone_id, zonestl.name, supplier_attribute_action_flag, category_attribute_action_flag,
1098: items_without_supplier_flag, items_without_shop_catg_flag, sqe_sequence
1099: BULK COLLECT INTO l_content_zone_ids, l_content_zone_names, l_supplier_attr_action_flags,
1100: l_category_attr_action_flags, l_items_without_supplier_flags, l_items_without_shop_cat_flags, l_sqe_sequences
1101: FROM icx_cat_content_zones_b zones, icx_cat_content_zones_tl zonestl
1102: WHERE zones.type = 'LOCAL'
1103: AND zones.zone_id = zonestl.zone_id
1104: AND zonestl.language = USERENV('LANG');
1105:

Line 1167: UPDATE icx_cat_content_zones_b

1163:
1164: l_err_loc := 800;
1165: -- now update all the content zones with the new sqe sequences
1166: FORALL i IN 1..l_content_zone_ids.COUNT
1167: UPDATE icx_cat_content_zones_b
1168: SET sqe_sequence = l_sqe_sequences(i)
1169: WHERE zone_id = l_content_zone_ids(i);
1170:
1171: l_err_loc := 900;