54: --| |
55: --+==========================================================================+
56: --
57: --
58: g_chr_newline CONSTANT VARCHAR2(10):= xla_environment_pkg.g_chr_newline;
59: --
60: C_UNTRANSLATED CONSTANT VARCHAR2(1) := 'N';
61: C_TRANSLATED CONSTANT VARCHAR2(1) := 'Y';
62: --
2850: --
2851: -- Independant value set
2852: --
2853: l_statement_run := 'SELECT flex_value_meaning'
2854: || xla_environment_pkg.g_chr_newline
2855: || ' INTO l_meaning_meaning'
2856: || xla_environment_pkg.g_chr_newline
2857: || ' FROM fnd_flex_values_vl'
2858: || xla_environment_pkg.g_chr_newline
2852: --
2853: l_statement_run := 'SELECT flex_value_meaning'
2854: || xla_environment_pkg.g_chr_newline
2855: || ' INTO l_meaning_meaning'
2856: || xla_environment_pkg.g_chr_newline
2857: || ' FROM fnd_flex_values_vl'
2858: || xla_environment_pkg.g_chr_newline
2859: ||' WHERE flex_value_set_id = p_flex_value_set_id'
2860: || xla_environment_pkg.g_chr_newline
2854: || xla_environment_pkg.g_chr_newline
2855: || ' INTO l_meaning_meaning'
2856: || xla_environment_pkg.g_chr_newline
2857: || ' FROM fnd_flex_values_vl'
2858: || xla_environment_pkg.g_chr_newline
2859: ||' WHERE flex_value_set_id = p_flex_value_set_id'
2860: || xla_environment_pkg.g_chr_newline
2861: || ' AND flex_value = p_flex_value'
2862: || xla_environment_pkg.g_chr_newline
2856: || xla_environment_pkg.g_chr_newline
2857: || ' FROM fnd_flex_values_vl'
2858: || xla_environment_pkg.g_chr_newline
2859: ||' WHERE flex_value_set_id = p_flex_value_set_id'
2860: || xla_environment_pkg.g_chr_newline
2861: || ' AND flex_value = p_flex_value'
2862: || xla_environment_pkg.g_chr_newline
2863: || ' ;'
2864: ;
2858: || xla_environment_pkg.g_chr_newline
2859: ||' WHERE flex_value_set_id = p_flex_value_set_id'
2860: || xla_environment_pkg.g_chr_newline
2861: || ' AND flex_value = p_flex_value'
2862: || xla_environment_pkg.g_chr_newline
2863: || ' ;'
2864: ;
2865:
2866: ELSIF l_validation_type = 'F' THEN
2907: --
2908: -- Table value set
2909: --
2910: l_statement:= 'SELECT distinct '|| l_value_column_name --14756735
2911: || xla_environment_pkg.g_chr_newline
2912: || ' INTO l_meaning_meaning'
2913: || xla_environment_pkg.g_chr_newline
2914: || ' FROM '||l_application_table_name
2915: || xla_environment_pkg.g_chr_newline
2909: --
2910: l_statement:= 'SELECT distinct '|| l_value_column_name --14756735
2911: || xla_environment_pkg.g_chr_newline
2912: || ' INTO l_meaning_meaning'
2913: || xla_environment_pkg.g_chr_newline
2914: || ' FROM '||l_application_table_name
2915: || xla_environment_pkg.g_chr_newline
2916: || ' WHERE '||l_id_column_name || ' = p_flex_value'
2917: || xla_environment_pkg.g_chr_newline
2911: || xla_environment_pkg.g_chr_newline
2912: || ' INTO l_meaning_meaning'
2913: || xla_environment_pkg.g_chr_newline
2914: || ' FROM '||l_application_table_name
2915: || xla_environment_pkg.g_chr_newline
2916: || ' WHERE '||l_id_column_name || ' = p_flex_value'
2917: || xla_environment_pkg.g_chr_newline
2918: || ' ;'
2919: ;
2913: || xla_environment_pkg.g_chr_newline
2914: || ' FROM '||l_application_table_name
2915: || xla_environment_pkg.g_chr_newline
2916: || ' WHERE '||l_id_column_name || ' = p_flex_value'
2917: || xla_environment_pkg.g_chr_newline
2918: || ' ;'
2919: ;
2920: ELSE
2921: --
2922: -- Table value set
2923: --
2924:
2925: l_statement:= 'SELECT distinct '||l_value_column_name --14756735
2926: || xla_environment_pkg.g_chr_newline
2927: || ' INTO l_meaning_meaning'
2928: || xla_environment_pkg.g_chr_newline
2929: || ' FROM '||l_application_table_name
2930: || xla_environment_pkg.g_chr_newline
2924:
2925: l_statement:= 'SELECT distinct '||l_value_column_name --14756735
2926: || xla_environment_pkg.g_chr_newline
2927: || ' INTO l_meaning_meaning'
2928: || xla_environment_pkg.g_chr_newline
2929: || ' FROM '||l_application_table_name
2930: || xla_environment_pkg.g_chr_newline
2931: || ' WHERE '||l_id_column_name || ' = p_flex_value'
2932: || ' AND '||l_additional_where_clause
2926: || xla_environment_pkg.g_chr_newline
2927: || ' INTO l_meaning_meaning'
2928: || xla_environment_pkg.g_chr_newline
2929: || ' FROM '||l_application_table_name
2930: || xla_environment_pkg.g_chr_newline
2931: || ' WHERE '||l_id_column_name || ' = p_flex_value'
2932: || ' AND '||l_additional_where_clause
2933: || ' ;'
2934: ;
2945: END IF;
2946: --
2947: --
2948: l_statement_run := l_statement ;
2949: l_statement_run := l_statement_run || xla_environment_pkg.g_chr_newline
2950: ;
2951:
2952: END IF;
2953: --