160:
161: l_log_module VARCHAR2(240);
162:
163: l_where VARCHAR2(32000);
164: l_bind_variables fnd_flex_xml_publisher_apis.bind_variables;
165: l_numof_bind_variables NUMBER;
166: l_segment_name VARCHAR2(30);
167: l_segment_value VARCHAR2(1000);
168: l_data_type VARCHAR2(30);
186: -- e.g. l_where stores the following:
187: -- gcck.SEGMENT1 BETWEEN :FLEX_PARM1 AND :FLEX_PARM2
188: -- AND gcck.SEGMENT2 BETWEEN :FLEX_PARM3 AND :FLEX_PARM4 ...
189: --
190: fnd_flex_xml_publisher_apis.kff_where
191: (p_lexical_name => 'FLEX_PARM'
192: ,p_application_short_name => 'SQLGL'
193: ,p_id_flex_code => 'GL#'
194: ,p_id_flex_num => p_coa_id