39: l_ccid NUMBER;
40: BEGIN
41:
42: SELECT mtl_item_catalog_groups_b_s.NEXTVAL
43: INTO l_ccid from dual;
44:
45: Return l_ccid;
46:
47: END;
274: IF (p_create_new)
275: THEN
276: SELECT mtl_item_catalog_groups_b_s.nextval
277: INTO ccid
278: FROM dual;
279: END IF;
280:
281: return ccid;
282:
283: END Perform_Segment_Breakup;
284:
285: /********************************************************
286: * Function : Concatenate_Segments
287: * Purpose : Takes the individual segments and
288: * concatenates them based on the flex
289: * structure, by arranging the segments in
290: * display order and then calling the flex api.
291: * Returns : the concatenated segment value.