668: x_select_stmt := 'null';
669: ELSE
670: BEGIN
671: x_select_stmt :=
672: fa_rx_flex_pkg.flex_sql(p_application_id, 'CAT#',
673: p_category_flex_structure, 'cat',
674: 'SELECT', p_qualifier);
675: EXCEPTION
676: WHEN OTHERS THEN
681:
682: -- Create where clause
683: IF p_category_low = p_category_high THEN
684: x_where_stmt := ' AND ' ||
685: fa_rx_flex_pkg.flex_sql(
686: p_application_id,
687: 'CAT#',
688: p_category_flex_structure,
689: 'cat',
693: p_category_low);
694:
695: ELSIF p_category_low IS NOT NULL AND p_category_high IS NOT NULL THEN
696: x_where_stmt := ' AND ' ||
697: fa_rx_flex_pkg.flex_sql(
698: p_application_id,
699: 'CAT#',
700: p_category_flex_structure,
701: 'cat',
706: p_category_high);
707:
708: ELSIF p_category_low IS NOT NULL THEN
709: x_where_stmt := ' AND ' ||
710: fa_rx_flex_pkg.flex_sql(
711: p_application_id,
712: 'CAT#',
713: p_category_flex_structure,
714: 'cat',
718: p_category_low);
719:
720: ELSIF p_category_high IS NOT NULL THEN
721: x_where_stmt := ' AND ' ||
722: fa_rx_flex_pkg.flex_sql(
723: p_application_id,
724: 'CAT#',
725: p_category_flex_structure,
726: 'cat',