157: END get_segments;
158:
159: --############### Function to get Flex field delimiter #############################################
160: FUNCTION get_flex_delimiter(p_flex_code fnd_id_flex_segments_vl.id_flex_code%type,
161: p_flex_num fnd_id_flex_structures_vl.id_flex_num%type) RETURN VARCHAR2 IS
162: CURSOR c_get_delimiter(c_flex_code fnd_id_flex_segments_vl.id_flex_code%type,
163: c_flex_num fnd_id_flex_structures_vl.id_flex_num%type) IS
164:
165: SELECT concatenated_segment_delimiter delimiter
159: --############### Function to get Flex field delimiter #############################################
160: FUNCTION get_flex_delimiter(p_flex_code fnd_id_flex_segments_vl.id_flex_code%type,
161: p_flex_num fnd_id_flex_structures_vl.id_flex_num%type) RETURN VARCHAR2 IS
162: CURSOR c_get_delimiter(c_flex_code fnd_id_flex_segments_vl.id_flex_code%type,
163: c_flex_num fnd_id_flex_structures_vl.id_flex_num%type) IS
164:
165: SELECT concatenated_segment_delimiter delimiter
166: FROM fnd_id_flex_structures_vl
167: WHERE (APPLICATION_ID=800) AND
162: CURSOR c_get_delimiter(c_flex_code fnd_id_flex_segments_vl.id_flex_code%type,
163: c_flex_num fnd_id_flex_structures_vl.id_flex_num%type) IS
164:
165: SELECT concatenated_segment_delimiter delimiter
166: FROM fnd_id_flex_structures_vl
167: WHERE (APPLICATION_ID=800) AND
168: (ID_FLEX_CODE= c_flex_code) AND
169: id_flex_num = c_flex_num; --
170: l_flex_delimiter fnd_id_flex_structures_vl.concatenated_segment_delimiter%type;
166: FROM fnd_id_flex_structures_vl
167: WHERE (APPLICATION_ID=800) AND
168: (ID_FLEX_CODE= c_flex_code) AND
169: id_flex_num = c_flex_num; --
170: l_flex_delimiter fnd_id_flex_structures_vl.concatenated_segment_delimiter%type;
171: BEGIN
172: FOR l_get_delimiter IN c_get_delimiter(p_flex_code,p_flex_num) LOOP
173: l_flex_delimiter := l_get_delimiter.delimiter;
174: END LOOP;