APPS.ICX_CAT_CNTNT_SCRTY_UPG_PVT dependencies on ICX_CAT_CONTENT_ZONES_S

Line 1255: SELECT sources.item_source_id, sc.store_id, ICX_CAT_CONTENT_ZONES_S.NEXTVAL

1251: END IF;
1252:
1253: l_err_loc := 0;
1254:
1255: SELECT sources.item_source_id, sc.store_id, ICX_CAT_CONTENT_ZONES_S.NEXTVAL
1256: BULK COLLECT INTO l_catalog_ids, l_store_ids, l_new_zone_ids
1257: FROM icx_por_item_sources sources, icx_cat_store_catalogs sc
1258: WHERE sources.type = 'LOCAL'
1259: AND sources.item_source_id = sc.item_source_id(+);

Line 1302: SELECT sources.item_source_id, sc.store_id, ICX_CAT_CONTENT_ZONES_S.NEXTVAL

1298: END IF;
1299:
1300: l_err_loc := 0;
1301:
1302: SELECT sources.item_source_id, sc.store_id, ICX_CAT_CONTENT_ZONES_S.NEXTVAL
1303: BULK COLLECT INTO l_item_source_ids, l_store_ids, l_new_zone_ids
1304: FROM icx_por_item_sources sources, icx_cat_store_catalogs sc
1305: WHERE sources.type IN ('EXTERNAL', 'DISTSRCH', 'INFO')
1306: AND sources.item_source_id = sc.item_source_id(+);

Line 3052: SELECT ICX_CAT_CONTENT_ZONES_S.NEXTVAL

3048: FOR i IN 1..p_num_zones LOOP
3049:
3050: l_err_loc := 100;
3051:
3052: SELECT ICX_CAT_CONTENT_ZONES_S.NEXTVAL
3053: INTO l_new_zone_ids(i)
3054: FROM dual;
3055:
3056: END LOOP;