DBA Data[Home] [Help]

APPS.FA_RX_GROUP dependencies on FA_RX_FLEX_PKG

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

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

Line 685: fa_rx_flex_pkg.flex_sql(

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',

Line 697: fa_rx_flex_pkg.flex_sql(

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',

Line 710: fa_rx_flex_pkg.flex_sql(

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',

Line 722: fa_rx_flex_pkg.flex_sql(

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',