APPS.GHR_UTILITY dependencies on FND_ID_FLEX_STRUCTURES_VL

Line 151: p_flex_num fnd_id_flex_structures_vl.id_flex_num%type) RETURN VARCHAR2 IS

147: END get_segments;
148:
149: --############### Function to get Flex field delimiter #############################################
150: FUNCTION get_flex_delimiter(p_flex_code fnd_id_flex_segments_vl.id_flex_code%type,
151: p_flex_num fnd_id_flex_structures_vl.id_flex_num%type) RETURN VARCHAR2 IS
152: CURSOR c_get_delimiter(c_flex_code fnd_id_flex_segments_vl.id_flex_code%type,
153: c_flex_num fnd_id_flex_structures_vl.id_flex_num%type) IS
154:
155: SELECT concatenated_segment_delimiter delimiter

Line 153: c_flex_num fnd_id_flex_structures_vl.id_flex_num%type) IS

149: --############### Function to get Flex field delimiter #############################################
150: FUNCTION get_flex_delimiter(p_flex_code fnd_id_flex_segments_vl.id_flex_code%type,
151: p_flex_num fnd_id_flex_structures_vl.id_flex_num%type) RETURN VARCHAR2 IS
152: CURSOR c_get_delimiter(c_flex_code fnd_id_flex_segments_vl.id_flex_code%type,
153: c_flex_num fnd_id_flex_structures_vl.id_flex_num%type) IS
154:
155: SELECT concatenated_segment_delimiter delimiter
156: FROM fnd_id_flex_structures_vl
157: WHERE (APPLICATION_ID=800) AND

Line 156: FROM fnd_id_flex_structures_vl

152: CURSOR c_get_delimiter(c_flex_code fnd_id_flex_segments_vl.id_flex_code%type,
153: c_flex_num fnd_id_flex_structures_vl.id_flex_num%type) IS
154:
155: SELECT concatenated_segment_delimiter delimiter
156: FROM fnd_id_flex_structures_vl
157: WHERE (APPLICATION_ID=800) AND
158: (ID_FLEX_CODE= c_flex_code) AND
159: id_flex_num = c_flex_num; --
160: l_flex_delimiter fnd_id_flex_structures_vl.concatenated_segment_delimiter%type;

Line 160: l_flex_delimiter fnd_id_flex_structures_vl.concatenated_segment_delimiter%type;

156: FROM fnd_id_flex_structures_vl
157: WHERE (APPLICATION_ID=800) AND
158: (ID_FLEX_CODE= c_flex_code) AND
159: id_flex_num = c_flex_num; --
160: l_flex_delimiter fnd_id_flex_structures_vl.concatenated_segment_delimiter%type;
161: BEGIN
162: FOR l_get_delimiter IN c_get_delimiter(p_flex_code,p_flex_num) LOOP
163: l_flex_delimiter := l_get_delimiter.delimiter;
164: END LOOP;