64: query_condition VARCHAR2(2000) default NULL;
65: high_value VARCHAR2(240);
66: low_value VARCHAR2(240);
67:
68: high_segments fnd_flex_ext.SegmentArray;
69: low_segments fnd_flex_ext.SegmentArray;
70: delim VARCHAR2(1);
71:
72: l_flex_condition VARCHAR2(2000);
65: high_value VARCHAR2(240);
66: low_value VARCHAR2(240);
67:
68: high_segments fnd_flex_ext.SegmentArray;
69: low_segments fnd_flex_ext.SegmentArray;
70: delim VARCHAR2(1);
71:
72: l_flex_condition VARCHAR2(2000);
73: l_segment_condition VARCHAR2(2000);
96: l_id_flex_code := 'GL#';
97: l_application_id := 101;
98: /* End bug #4924031 */
99:
100: delim := fnd_flex_ext.get_delimiter(
101: application_short_name => 'SQLGL',
102: key_flex_code => 'GL#',
103: structure_number => p_chart_of_accounts
104: );
106: -- breakup the segments into an array
107: l_num_of_low_segments := 0;
108: l_num_of_high_segments := 0;
109: IF p_flexfield_low IS NOT NULL then
110: l_num_of_low_segments := fnd_flex_ext.breakup_segments
111: (concatenated_segs => p_flexfield_low,
112: delimiter => delim,
113: segments => low_segments);
114: END IF;
113: segments => low_segments);
114: END IF;
115:
116: IF p_flexfield_high IS NOT NULL then
117: l_num_of_high_segments := fnd_flex_ext.breakup_segments
118: (concatenated_segs => p_flexfield_high,
119: delimiter => delim,
120: segments => high_segments);
121: END IF;