228:
229: l_log_module VARCHAR2(240);
230:
231: l_where VARCHAR2(32000);
232: l_bind_variables fnd_flex_xml_publisher_apis.bind_variables;
233: l_numof_bind_variables NUMBER;
234: l_segment_name VARCHAR2(30);
235: l_segment_value VARCHAR2(1000);
236: l_data_type VARCHAR2(30);
273: -- e.g. l_where stores the following:
274: -- gcck.SEGMENT1 BETWEEN :FLEX_PARM1 AND :FLEX_PARM2
275: -- AND gcck.SEGMENT2 BETWEEN :FLEX_PARM3 AND :FLEX_PARM4 ...
276: --
277: fnd_flex_xml_publisher_apis.kff_where
278: (p_lexical_name => 'FLEX_PARM'
279: ,p_application_short_name => 'SQLGL'
280: ,p_id_flex_code => 'GL#'
281: ,p_id_flex_num => p_coa_id