1876: WHERE p_ip_category_id_tbl(i) IS NOT NULL
1877: AND p_ip_category_id_tbl(i) <> -2
1878: AND NOT EXISTS(
1879: SELECT 'Y'
1880: FROM icx_cat_categories_v
1881: WHERE rt_category_id = p_ip_category_id_tbl(i));
1882:
1883: IF (SQL%ROWCOUNT > 0) THEN
1884: x_result_type := po_validations.c_result_type_failure;
3259: WHERE p_ip_category_id_tbl(i) IS NOT NULL
3260: AND p_ip_category_id_tbl(i) <> -2
3261: AND NOT EXISTS(
3262: SELECT 'Y'
3263: FROM icx_cat_categories_v
3264: WHERE rt_category_id = p_ip_category_id_tbl(i));
3265:
3266: IF (SQL%ROWCOUNT > 0) THEN
3267: x_result_type := po_validations.c_result_type_failure;