APPS.GHR_UTILITY dependencies on FND_ID_FLEX_SEGMENTS_VL

Line 101: p_flex_code fnd_id_flex_segments_vl.id_flex_code%type)

97: END get_pos_flex_num;
98:
99: --############### Function to get Flex field segment values #############################################
100: FUNCTION get_segments(p_flex_num fnd_id_flex_structures_tl.id_flex_num%type,
101: p_flex_code fnd_id_flex_segments_vl.id_flex_code%type)
102: RETURN t_flex_recs IS
103:
104: CURSOR c_get_segment_rec(c_flex_num fnd_id_flex_structures_tl.id_flex_num%type,
105: c_flex_code fnd_id_flex_segments_vl.id_flex_code%type) IS

Line 105: c_flex_code fnd_id_flex_segments_vl.id_flex_code%type) IS

101: p_flex_code fnd_id_flex_segments_vl.id_flex_code%type)
102: RETURN t_flex_recs IS
103:
104: CURSOR c_get_segment_rec(c_flex_num fnd_id_flex_structures_tl.id_flex_num%type,
105: c_flex_code fnd_id_flex_segments_vl.id_flex_code%type) IS
106: SELECT
107: SEGMENT_NAME,
108: DESCRIPTION,
109: ENABLED_FLAG,

Line 132: FND_ID_FLEX_SEGMENTS_VL

128: ID_FLEX_CODE,
129: APPLICATION_ID,
130: ROW_ID
131: FROM
132: FND_ID_FLEX_SEGMENTS_VL
133: WHERE
134: (ID_FLEX_NUM= c_flex_num) and -- 50520
135: (ID_FLEX_CODE= c_flex_code) and -- 'POS'
136: (APPLICATION_ID= 800)

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

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

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

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