83: SELECT as_interest_types_s.NEXTVAL
84: FROM DUAL;
85:
86: CURSOR prod_category_val_cur(p_prod_cat_set_id IN NUMBER, p_prod_cat_id IN NUMBER) IS
87: SELECT 1 FROM ENI_PROD_DEN_HRCHY_PARENTS_V P
88: WHERE P.CATEGORY_ID = p_prod_cat_id
89: AND P.CATEGORY_SET_ID = p_prod_cat_set_id;
90: l_module CONSTANT VARCHAR2(255) := 'as.plsql.intypub.create_interest_type';
91:
511: FROM as_interest_types_vl
512: WHERE interest_type_id = p_interest_type_id;
513:
514: CURSOR prod_category_val_cur(p_prod_cat_set_id IN NUMBER, p_prod_cat_id IN NUMBER) IS
515: SELECT 1 FROM ENI_PROD_DEN_HRCHY_PARENTS_V P
516: WHERE P.CATEGORY_ID = p_prod_cat_id
517: AND P.CATEGORY_SET_ID = p_prod_cat_set_id;
518: l_module CONSTANT VARCHAR2(255) := 'as.plsql.intypub.update_interest_type';
519: