APPS.GHR_UTILITY dependencies on FND_ID_FLEX_SEGMENTS_VL

Line 111: p_flex_code fnd_id_flex_segments_vl.id_flex_code%type)

107: END get_pos_flex_num;
108:
109: --############### Function to get Flex field segment values #############################################
110: FUNCTION get_segments(p_flex_num fnd_id_flex_structures_tl.id_flex_num%type,
111: p_flex_code fnd_id_flex_segments_vl.id_flex_code%type)
112: RETURN t_flex_recs IS
113:
114: CURSOR c_get_segment_rec(c_flex_num fnd_id_flex_structures_tl.id_flex_num%type,
115: c_flex_code fnd_id_flex_segments_vl.id_flex_code%type) IS

Line 115: c_flex_code fnd_id_flex_segments_vl.id_flex_code%type) IS

111: p_flex_code fnd_id_flex_segments_vl.id_flex_code%type)
112: RETURN t_flex_recs IS
113:
114: CURSOR c_get_segment_rec(c_flex_num fnd_id_flex_structures_tl.id_flex_num%type,
115: c_flex_code fnd_id_flex_segments_vl.id_flex_code%type) IS
116: SELECT
117: SEGMENT_NAME,
118: DESCRIPTION,
119: ENABLED_FLAG,

Line 142: FND_ID_FLEX_SEGMENTS_VL

138: ID_FLEX_CODE,
139: APPLICATION_ID,
140: ROW_ID
141: FROM
142: FND_ID_FLEX_SEGMENTS_VL
143: WHERE
144: (ID_FLEX_NUM= c_flex_num) and -- 50520
145: (ID_FLEX_CODE= c_flex_code) and -- 'POS'
146: (APPLICATION_ID= 800)

Line 160: FUNCTION get_flex_delimiter(p_flex_code fnd_id_flex_segments_vl.id_flex_code%type,

156: RETURN l_flex_recs;
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:

Line 162: CURSOR c_get_delimiter(c_flex_code fnd_id_flex_segments_vl.id_flex_code%type,

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
166: FROM fnd_id_flex_structures_vl