APPS.XLA_FLEX_PKG dependencies on FND_FLEX_VALIDATION_TABLES

Line 291: FROM fnd_flex_validation_tables

287: ELSE
288:
289: SELECT additional_where_clause
290: INTO l_additional_where_clause
291: FROM fnd_flex_validation_tables
292: WHERE flex_value_set_id = p_flex_value_set_id;
293:
294: IF l_additional_where_clause is not null THEN
295:

Line 327: FROM fnd_flex_validation_tables

323: || 'FROM '||application_table_name
324: || xla_environment_pkg.g_chr_newline
325: || 'WHERE '||id_column_name || ' = :1'
326: INTO l_statement
327: FROM fnd_flex_validation_tables
328: WHERE flex_value_set_id = p_flex_value_set_id
329: ;
330:
331: ELSE

Line 342: FROM fnd_flex_validation_tables

338: || xla_environment_pkg.g_chr_newline
339: || 'WHERE '||id_column_name || ' = :1'
340: || ' AND '||l_additional_where_clause
341: INTO l_statement
342: FROM fnd_flex_validation_tables
343: WHERE flex_value_set_id = p_flex_value_set_id
344: ;
345:
346:

Line 551: SELECT * FROM fnd_flex_validation_tables fvt

547: ,p_where_col OUT NOCOPY VARCHAR2
548: ,p_type_out OUT NOCOPY INTEGER
549: ) IS
550: CURSOR c_fvt IS
551: SELECT * FROM fnd_flex_validation_tables fvt
552: WHERE fvt.flex_value_set_id = p_flex_value_set_id;
553:
554: c_fvt_rec c_fvt%ROWTYPE;
555:

Line 688: FROM fnd_flex_validation_tables

684: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);
685:
686: SELECT id_column_name
687: INTO l_id_column_name
688: FROM fnd_flex_validation_tables
689: WHERE flex_value_set_id = p_flex_value_set_id;
690:
691: IF l_id_column_name is null THEN
692: l_return := TRUE;

Line 733: FROM fnd_flex_validation_tables

729: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);
730:
731: SELECT meaning_column_name
732: INTO l_meaning_column_name
733: FROM fnd_flex_validation_tables
734: WHERE flex_value_set_id = p_flex_value_set_id;
735:
736: IF l_meaning_column_name is null THEN
737: l_return := TRUE;

Line 779: FROM fnd_flex_validation_tables

775:
776: BEGIN
777: SELECT additional_where_clause
778: INTO l_additional_where_clause
779: FROM fnd_flex_validation_tables
780: WHERE flex_value_set_id = p_flex_value_set_id;
781:
782: IF l_additional_where_clause is not null THEN
783: