283: ELSE
284:
285: SELECT additional_where_clause
286: INTO l_additional_where_clause
287: FROM fnd_flex_validation_tables
288: WHERE flex_value_set_id = p_flex_value_set_id;
289:
290: IF l_additional_where_clause is not null THEN
291:
317: || 'FROM '||application_table_name
318: || xla_environment_pkg.g_chr_newline
319: || 'WHERE '||id_column_name || ' = :1'
320: INTO l_statement
321: FROM fnd_flex_validation_tables
322: WHERE flex_value_set_id = p_flex_value_set_id
323: ;
324:
325: ELSE
332: || xla_environment_pkg.g_chr_newline
333: || 'WHERE '||id_column_name || ' = :1'
334: || ' AND '||l_additional_where_clause
335: INTO l_statement
336: FROM fnd_flex_validation_tables
337: WHERE flex_value_set_id = p_flex_value_set_id
338: ;
339:
340:
615: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);
616:
617: SELECT id_column_name
618: INTO l_id_column_name
619: FROM fnd_flex_validation_tables
620: WHERE flex_value_set_id = p_flex_value_set_id;
621:
622: IF l_id_column_name is null THEN
623: l_return := TRUE;
660: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);
661:
662: SELECT meaning_column_name
663: INTO l_meaning_column_name
664: FROM fnd_flex_validation_tables
665: WHERE flex_value_set_id = p_flex_value_set_id;
666:
667: IF l_meaning_column_name is null THEN
668: l_return := TRUE;
706:
707: BEGIN
708: SELECT additional_where_clause
709: INTO l_additional_where_clause
710: FROM fnd_flex_validation_tables
711: WHERE flex_value_set_id = p_flex_value_set_id;
712:
713: IF l_additional_where_clause is not null THEN
714: