DBA Data[Home] [Help]

APPS.XLA_CMP_SOURCE_PKG dependencies on XLA_ENVIRONMENT_PKG

Line 58: g_chr_newline CONSTANT VARCHAR2(10):= xla_environment_pkg.g_chr_newline;

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: --

Line 2854: || xla_environment_pkg.g_chr_newline

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

Line 2856: || 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

Line 2858: || 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

Line 2860: || 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: ;

Line 2862: || xla_environment_pkg.g_chr_newline

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

Line 2911: || xla_environment_pkg.g_chr_newline

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

Line 2913: || 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

Line 2915: || 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: ;

Line 2917: || xla_environment_pkg.g_chr_newline

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: --

Line 2926: || xla_environment_pkg.g_chr_newline

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

Line 2928: || 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

Line 2930: || xla_environment_pkg.g_chr_newline

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: ;

Line 2949: l_statement_run := l_statement_run || xla_environment_pkg.g_chr_newline

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: --