1152: one_len number;
1153:
1154: CURSOR cat_set_name(v_category_set_id number) IS
1155: SELECT category_set_name
1156: FROM msc_category_sets
1157: where category_set_id = v_category_set_id;
1158:
1159:
1160: cursor plan_type_c(v_plan_id number) is
2281: where plan_id = v_plan_id;
2282:
2283: CURSOR cat_name_cur(v_category_set_id number) IS
2284: SELECT category_set_name
2285: FROM msc_category_sets
2286: where category_set_id = v_category_set_id;
2287: begin
2288:
2289: if p_item_id is null then