DBA Data[Home] [Help]

APPS.XLA_CMP_SOURCE_PKG dependencies on XLA_ENVIRONMENT_PKG

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

52: --| |
53: --+==========================================================================+
54: --
55: --
56: g_chr_newline CONSTANT VARCHAR2(10):= xla_environment_pkg.g_chr_newline;
57: --
58: C_UNTRANSLATED CONSTANT VARCHAR2(1) := 'N';
59: C_TRANSLATED CONSTANT VARCHAR2(1) := 'Y';
60: --

Line 2851: || xla_environment_pkg.g_chr_newline

2847: --
2848: -- Independant value set
2849: --
2850: l_statement_run := 'SELECT flex_value_meaning'
2851: || xla_environment_pkg.g_chr_newline
2852: || ' INTO l_meaning_meaning'
2853: || xla_environment_pkg.g_chr_newline
2854: || ' FROM fnd_flex_values_vl'
2855: || xla_environment_pkg.g_chr_newline

Line 2853: || xla_environment_pkg.g_chr_newline

2849: --
2850: l_statement_run := 'SELECT flex_value_meaning'
2851: || xla_environment_pkg.g_chr_newline
2852: || ' INTO l_meaning_meaning'
2853: || xla_environment_pkg.g_chr_newline
2854: || ' FROM fnd_flex_values_vl'
2855: || xla_environment_pkg.g_chr_newline
2856: ||' WHERE flex_value_set_id = p_flex_value_set_id'
2857: || xla_environment_pkg.g_chr_newline

Line 2855: || xla_environment_pkg.g_chr_newline

2851: || xla_environment_pkg.g_chr_newline
2852: || ' INTO l_meaning_meaning'
2853: || xla_environment_pkg.g_chr_newline
2854: || ' FROM fnd_flex_values_vl'
2855: || xla_environment_pkg.g_chr_newline
2856: ||' WHERE flex_value_set_id = p_flex_value_set_id'
2857: || xla_environment_pkg.g_chr_newline
2858: || ' AND flex_value = p_flex_value'
2859: || xla_environment_pkg.g_chr_newline

Line 2857: || xla_environment_pkg.g_chr_newline

2853: || xla_environment_pkg.g_chr_newline
2854: || ' FROM fnd_flex_values_vl'
2855: || xla_environment_pkg.g_chr_newline
2856: ||' WHERE flex_value_set_id = p_flex_value_set_id'
2857: || xla_environment_pkg.g_chr_newline
2858: || ' AND flex_value = p_flex_value'
2859: || xla_environment_pkg.g_chr_newline
2860: || ' ;'
2861: ;

Line 2859: || xla_environment_pkg.g_chr_newline

2855: || xla_environment_pkg.g_chr_newline
2856: ||' WHERE flex_value_set_id = p_flex_value_set_id'
2857: || xla_environment_pkg.g_chr_newline
2858: || ' AND flex_value = p_flex_value'
2859: || xla_environment_pkg.g_chr_newline
2860: || ' ;'
2861: ;
2862:
2863: ELSIF l_validation_type = 'F' THEN

Line 2908: || xla_environment_pkg.g_chr_newline

2904: --
2905: -- Table value set
2906: --
2907: l_statement:= 'SELECT '|| l_value_column_name
2908: || xla_environment_pkg.g_chr_newline
2909: || ' INTO l_meaning_meaning'
2910: || xla_environment_pkg.g_chr_newline
2911: || ' FROM '||l_application_table_name
2912: || xla_environment_pkg.g_chr_newline

Line 2910: || xla_environment_pkg.g_chr_newline

2906: --
2907: l_statement:= 'SELECT '|| l_value_column_name
2908: || xla_environment_pkg.g_chr_newline
2909: || ' INTO l_meaning_meaning'
2910: || xla_environment_pkg.g_chr_newline
2911: || ' FROM '||l_application_table_name
2912: || xla_environment_pkg.g_chr_newline
2913: || ' WHERE '||l_id_column_name || ' = p_flex_value'
2914: || xla_environment_pkg.g_chr_newline

Line 2912: || xla_environment_pkg.g_chr_newline

2908: || xla_environment_pkg.g_chr_newline
2909: || ' INTO l_meaning_meaning'
2910: || xla_environment_pkg.g_chr_newline
2911: || ' FROM '||l_application_table_name
2912: || xla_environment_pkg.g_chr_newline
2913: || ' WHERE '||l_id_column_name || ' = p_flex_value'
2914: || xla_environment_pkg.g_chr_newline
2915: || ' ;'
2916: ;

Line 2914: || xla_environment_pkg.g_chr_newline

2910: || xla_environment_pkg.g_chr_newline
2911: || ' FROM '||l_application_table_name
2912: || xla_environment_pkg.g_chr_newline
2913: || ' WHERE '||l_id_column_name || ' = p_flex_value'
2914: || xla_environment_pkg.g_chr_newline
2915: || ' ;'
2916: ;
2917: ELSE
2918: --

Line 2923: || xla_environment_pkg.g_chr_newline

2919: -- Table value set
2920: --
2921:
2922: l_statement:= 'SELECT '||l_value_column_name
2923: || xla_environment_pkg.g_chr_newline
2924: || ' INTO l_meaning_meaning'
2925: || xla_environment_pkg.g_chr_newline
2926: || ' FROM '||l_application_table_name
2927: || xla_environment_pkg.g_chr_newline

Line 2925: || xla_environment_pkg.g_chr_newline

2921:
2922: l_statement:= 'SELECT '||l_value_column_name
2923: || xla_environment_pkg.g_chr_newline
2924: || ' INTO l_meaning_meaning'
2925: || xla_environment_pkg.g_chr_newline
2926: || ' FROM '||l_application_table_name
2927: || xla_environment_pkg.g_chr_newline
2928: || ' WHERE '||l_id_column_name || ' = p_flex_value'
2929: || ' AND '||l_additional_where_clause

Line 2927: || xla_environment_pkg.g_chr_newline

2923: || xla_environment_pkg.g_chr_newline
2924: || ' INTO l_meaning_meaning'
2925: || xla_environment_pkg.g_chr_newline
2926: || ' FROM '||l_application_table_name
2927: || xla_environment_pkg.g_chr_newline
2928: || ' WHERE '||l_id_column_name || ' = p_flex_value'
2929: || ' AND '||l_additional_where_clause
2930: || ' ;'
2931: ;

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

2942: END IF;
2943: --
2944: --
2945: l_statement_run := l_statement ;
2946: l_statement_run := l_statement_run || xla_environment_pkg.g_chr_newline
2947: ;
2948:
2949: END IF;
2950: --