eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_FLEX_SERVER dependencies on FND_FLEX_VALIDATION_TABLES

Line 5468: fnd_columns fc, fnd_flex_validation_tables ffvt

5464: ffvt.id_column_size vset_id_column_size,
5465: fc.column_type column_type,
5466: fc.width column_size
5467: FROM fnd_id_flex_segments fifsg, fnd_flex_value_sets ffvs,
5468: fnd_columns fc, fnd_flex_validation_tables ffvt
5469: WHERE fifsg.application_id = p_application_id
5470: AND fifsg.id_flex_code = p_id_flex_code
5471: AND fifsg.id_flex_num = p_id_flex_num
5472: AND fifsg.enabled_flag = 'Y'

Line 6136: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

6132: e_DefaultTypeField EXCEPTION;
6133: e_DefaultTypeSQL EXCEPTION;
6134: l_reference_field fnd_descriptive_flexs.default_context_field_name%TYPE;
6135: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
6136: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
6137: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
6138: l_num_binds NUMBER;
6139: l_segement_name fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
6140: BEGIN

Line 6137: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;

6133: e_DefaultTypeSQL EXCEPTION;
6134: l_reference_field fnd_descriptive_flexs.default_context_field_name%TYPE;
6135: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
6136: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
6137: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
6138: l_num_binds NUMBER;
6139: l_segement_name fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
6140: BEGIN
6141:

Line 6143: SELECT fnd_flex_value_sets.validation_type,fnd_flex_validation_tables.additional_where_clause,

6139: l_segement_name fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
6140: BEGIN
6141:
6142:
6143: SELECT fnd_flex_value_sets.validation_type,fnd_flex_validation_tables.additional_where_clause,
6144: fnd_flex_validation_tables.additional_quickpick_columns,
6145: fnd_descriptive_flexs.default_context_field_name,fnd_flex_value_sets.flex_value_set_name
6146: INTO l_validation_type,l_additional_where_clause,l_additional_quickpick_columns,
6147: l_reference_field,l_value_set_name

Line 6144: fnd_flex_validation_tables.additional_quickpick_columns,

6140: BEGIN
6141:
6142:
6143: SELECT fnd_flex_value_sets.validation_type,fnd_flex_validation_tables.additional_where_clause,
6144: fnd_flex_validation_tables.additional_quickpick_columns,
6145: fnd_descriptive_flexs.default_context_field_name,fnd_flex_value_sets.flex_value_set_name
6146: INTO l_validation_type,l_additional_where_clause,l_additional_quickpick_columns,
6147: l_reference_field,l_value_set_name
6148: FROM fnd_flex_value_sets,fnd_descriptive_flexs,fnd_flex_validation_tables

Line 6148: FROM fnd_flex_value_sets,fnd_descriptive_flexs,fnd_flex_validation_tables

6144: fnd_flex_validation_tables.additional_quickpick_columns,
6145: fnd_descriptive_flexs.default_context_field_name,fnd_flex_value_sets.flex_value_set_name
6146: INTO l_validation_type,l_additional_where_clause,l_additional_quickpick_columns,
6147: l_reference_field,l_value_set_name
6148: FROM fnd_flex_value_sets,fnd_descriptive_flexs,fnd_flex_validation_tables
6149: WHERE fnd_flex_value_sets.flex_value_set_id (+)= fnd_descriptive_flexs.context_override_value_set_id
6150: AND fnd_flex_value_sets.flex_value_set_id = fnd_flex_validation_tables.flex_value_set_id(+)
6151: AND fnd_descriptive_flexs.application_id = p_application_id
6152: AND fnd_descriptive_flexs.descriptive_flexfield_name = p_descriptive_flexfield_name;

Line 6150: AND fnd_flex_value_sets.flex_value_set_id = fnd_flex_validation_tables.flex_value_set_id(+)

6146: INTO l_validation_type,l_additional_where_clause,l_additional_quickpick_columns,
6147: l_reference_field,l_value_set_name
6148: FROM fnd_flex_value_sets,fnd_descriptive_flexs,fnd_flex_validation_tables
6149: WHERE fnd_flex_value_sets.flex_value_set_id (+)= fnd_descriptive_flexs.context_override_value_set_id
6150: AND fnd_flex_value_sets.flex_value_set_id = fnd_flex_validation_tables.flex_value_set_id(+)
6151: AND fnd_descriptive_flexs.application_id = p_application_id
6152: AND fnd_descriptive_flexs.descriptive_flexfield_name = p_descriptive_flexfield_name;
6153:
6154: BEGIN -- Check context segment's value set's warnings

Line 6208: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

6204: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
6205: l_default_type fnd_descr_flex_column_usages.default_type%TYPE;
6206: l_default_value fnd_descr_flex_column_usages.default_value%TYPE;
6207: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
6208: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
6209: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
6210: l_segment_name fnd_descr_flex_column_usages.end_user_column_name%TYPE;
6211: e_DateTime EXCEPTION;
6212: e_PairOrSpecial EXCEPTION;

Line 6209: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;

6205: l_default_type fnd_descr_flex_column_usages.default_type%TYPE;
6206: l_default_value fnd_descr_flex_column_usages.default_value%TYPE;
6207: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
6208: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
6209: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
6210: l_segment_name fnd_descr_flex_column_usages.end_user_column_name%TYPE;
6211: e_DateTime EXCEPTION;
6212: e_PairOrSpecial EXCEPTION;
6213: e_TableValidated EXCEPTION;

Line 6296: FROM fnd_flex_validation_tables

6292: queue_non_forms_warnings(fnd_message.get());
6293: WHEN e_TableValidated THEN
6294: SELECT additional_where_clause,additional_quickpick_columns
6295: INTO l_additional_where_clause,l_additional_quickpick_columns
6296: FROM fnd_flex_validation_tables
6297: WHERE flex_value_set_id = l_value_set_id;
6298: IF (l_additional_quickpick_columns is not null) THEN
6299: parse_bind_names(l_additional_quickpick_columns, l_non_forms_warn_table_type, l_num_binds);
6300: IF (l_num_binds > 0) THEN

Line 6444: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;

6440:
6441: l_application_short_name fnd_application.application_short_name%TYPE;
6442: l_application_name fnd_application_tl.application_name%TYPE;
6443: l_id_flex_structure_code fnd_id_flex_structures.id_flex_structure_code%TYPE;
6444: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
6445: l_nsegments NUMBER;
6446: l_message VARCHAR2(1000);
6447: l_validation_type VARCHAR2(1000);
6448: l_format_type VARCHAR2(1000);

Line 6496: select additional_quickpick_columns into l_additional_quickpick_columns from fnd_flex_validation_tables where flex_value_set_id=l_segtype.value_set_id;

6492: end if;
6493:
6494: if (l_vset_r.validation_type = 'F') then
6495:
6496: select additional_quickpick_columns into l_additional_quickpick_columns from fnd_flex_validation_tables where flex_value_set_id=l_segtype.value_set_id;
6497:
6498: if (l_additional_quickpick_columns is not null) then
6499: parse_bind_names(l_additional_quickpick_columns, l_table_of_varchar2_32000, l_num_binds);
6500: if (l_num_binds > 0) then