607: IS
608:
609: l_log_module VARCHAR2(240);
610: l_where VARCHAR2(32000);
611: l_bind_variables fnd_flex_xml_publisher_apis.bind_variables;
612: l_numof_bind_variables NUMBER;
613: l_segment_name VARCHAR2(30);
614: l_segment_value VARCHAR2(1000);
615: l_data_type VARCHAR2(30);
649: -- e.g. l_where stores the following:
650: -- gcck.SEGMENT1 BETWEEN :FLEX_PARM1 AND :FLEX_PARM2
651: -- AND gcck.SEGMENT2 BETWEEN :FLEX_PARM3 AND :FLEX_PARM4 ...
652: --
653: fnd_flex_xml_publisher_apis.kff_where
654: (p_lexical_name => 'FLEX_PARM'
655: ,p_application_short_name => 'SQLGL'
656: ,p_id_flex_code => 'GL#'
657: ,p_id_flex_num => p_coa_id