APPS.FA_RX_GROUP dependencies on FA_RX_FLEX_PKG

Line 877: fa_rx_flex_pkg.flex_sql(p_application_id, 'CAT#',

873: x_select_stmt := 'null';
874: ELSE
875: BEGIN
876: x_select_stmt :=
877: fa_rx_flex_pkg.flex_sql(p_application_id, 'CAT#',
878: p_category_flex_structure, 'cat',
879: 'SELECT', p_qualifier);
880: EXCEPTION
881: WHEN OTHERS THEN

Line 890: fa_rx_flex_pkg.flex_sql(

886:
887: -- Create where clause
888: IF p_category_low = p_category_high THEN
889: x_where_stmt := ' AND ' ||
890: fa_rx_flex_pkg.flex_sql(
891: p_application_id,
892: 'CAT#',
893: p_category_flex_structure,
894: 'cat',

Line 902: fa_rx_flex_pkg.flex_sql(

898: p_category_low);
899:
900: ELSIF p_category_low IS NOT NULL AND p_category_high IS NOT NULL THEN
901: x_where_stmt := ' AND ' ||
902: fa_rx_flex_pkg.flex_sql(
903: p_application_id,
904: 'CAT#',
905: p_category_flex_structure,
906: 'cat',

Line 915: fa_rx_flex_pkg.flex_sql(

911: p_category_high);
912:
913: ELSIF p_category_low IS NOT NULL THEN
914: x_where_stmt := ' AND ' ||
915: fa_rx_flex_pkg.flex_sql(
916: p_application_id,
917: 'CAT#',
918: p_category_flex_structure,
919: 'cat',

Line 927: fa_rx_flex_pkg.flex_sql(

923: p_category_low);
924:
925: ELSIF p_category_high IS NOT NULL THEN
926: x_where_stmt := ' AND ' ||
927: fa_rx_flex_pkg.flex_sql(
928: p_application_id,
929: 'CAT#',
930: p_category_flex_structure,
931: 'cat',