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 5275: fnd_columns fc, fnd_flex_validation_tables ffvt

5271: ffvt.id_column_size vset_id_column_size,
5272: fc.column_type column_type,
5273: fc.width column_size
5274: FROM fnd_id_flex_segments fifsg, fnd_flex_value_sets ffvs,
5275: fnd_columns fc, fnd_flex_validation_tables ffvt
5276: WHERE fifsg.application_id = p_application_id
5277: AND fifsg.id_flex_code = p_id_flex_code
5278: AND fifsg.id_flex_num = p_id_flex_num
5279: AND fifsg.enabled_flag = 'Y'

Line 5943: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

5939: e_DefaultTypeField EXCEPTION;
5940: e_DefaultTypeSQL EXCEPTION;
5941: l_reference_field fnd_descriptive_flexs.default_context_field_name%TYPE;
5942: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
5943: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5944: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
5945: l_num_binds NUMBER;
5946: l_segement_name fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
5947: BEGIN

Line 5944: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;

5940: e_DefaultTypeSQL EXCEPTION;
5941: l_reference_field fnd_descriptive_flexs.default_context_field_name%TYPE;
5942: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
5943: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5944: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
5945: l_num_binds NUMBER;
5946: l_segement_name fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
5947: BEGIN
5948:

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

5946: l_segement_name fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
5947: BEGIN
5948:
5949:
5950: SELECT fnd_flex_value_sets.validation_type,fnd_flex_validation_tables.additional_where_clause,
5951: fnd_flex_validation_tables.additional_quickpick_columns,
5952: fnd_descriptive_flexs.default_context_field_name,fnd_flex_value_sets.flex_value_set_name
5953: INTO l_validation_type,l_additional_where_clause,l_additional_quickpick_columns,
5954: l_reference_field,l_value_set_name

Line 5951: fnd_flex_validation_tables.additional_quickpick_columns,

5947: BEGIN
5948:
5949:
5950: SELECT fnd_flex_value_sets.validation_type,fnd_flex_validation_tables.additional_where_clause,
5951: fnd_flex_validation_tables.additional_quickpick_columns,
5952: fnd_descriptive_flexs.default_context_field_name,fnd_flex_value_sets.flex_value_set_name
5953: INTO l_validation_type,l_additional_where_clause,l_additional_quickpick_columns,
5954: l_reference_field,l_value_set_name
5955: FROM fnd_flex_value_sets,fnd_descriptive_flexs,fnd_flex_validation_tables

Line 5955: FROM fnd_flex_value_sets,fnd_descriptive_flexs,fnd_flex_validation_tables

5951: fnd_flex_validation_tables.additional_quickpick_columns,
5952: fnd_descriptive_flexs.default_context_field_name,fnd_flex_value_sets.flex_value_set_name
5953: INTO l_validation_type,l_additional_where_clause,l_additional_quickpick_columns,
5954: l_reference_field,l_value_set_name
5955: FROM fnd_flex_value_sets,fnd_descriptive_flexs,fnd_flex_validation_tables
5956: WHERE fnd_flex_value_sets.flex_value_set_id (+)= fnd_descriptive_flexs.context_override_value_set_id
5957: AND fnd_flex_value_sets.flex_value_set_id = fnd_flex_validation_tables.flex_value_set_id(+)
5958: AND fnd_descriptive_flexs.application_id = p_application_id
5959: AND fnd_descriptive_flexs.descriptive_flexfield_name = p_descriptive_flexfield_name;

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

5953: INTO l_validation_type,l_additional_where_clause,l_additional_quickpick_columns,
5954: l_reference_field,l_value_set_name
5955: FROM fnd_flex_value_sets,fnd_descriptive_flexs,fnd_flex_validation_tables
5956: WHERE fnd_flex_value_sets.flex_value_set_id (+)= fnd_descriptive_flexs.context_override_value_set_id
5957: AND fnd_flex_value_sets.flex_value_set_id = fnd_flex_validation_tables.flex_value_set_id(+)
5958: AND fnd_descriptive_flexs.application_id = p_application_id
5959: AND fnd_descriptive_flexs.descriptive_flexfield_name = p_descriptive_flexfield_name;
5960:
5961: BEGIN -- Check context segment's value set's warnings

Line 6015: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

6011: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
6012: l_default_type fnd_descr_flex_column_usages.default_type%TYPE;
6013: l_default_value fnd_descr_flex_column_usages.default_value%TYPE;
6014: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
6015: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
6016: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
6017: l_segment_name fnd_descr_flex_column_usages.end_user_column_name%TYPE;
6018: e_DateTime EXCEPTION;
6019: e_PairOrSpecial EXCEPTION;

Line 6016: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;

6012: l_default_type fnd_descr_flex_column_usages.default_type%TYPE;
6013: l_default_value fnd_descr_flex_column_usages.default_value%TYPE;
6014: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
6015: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
6016: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
6017: l_segment_name fnd_descr_flex_column_usages.end_user_column_name%TYPE;
6018: e_DateTime EXCEPTION;
6019: e_PairOrSpecial EXCEPTION;
6020: e_TableValidated EXCEPTION;

Line 6103: FROM fnd_flex_validation_tables

6099: queue_non_forms_warnings(fnd_message.get());
6100: WHEN e_TableValidated THEN
6101: SELECT additional_where_clause,additional_quickpick_columns
6102: INTO l_additional_where_clause,l_additional_quickpick_columns
6103: FROM fnd_flex_validation_tables
6104: WHERE flex_value_set_id = l_value_set_id;
6105: IF (l_additional_quickpick_columns is not null) THEN
6106: parse_bind_names(l_additional_quickpick_columns, l_non_forms_warn_table_type, l_num_binds);
6107: IF (l_num_binds > 0) THEN

Line 6251: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;

6247:
6248: l_application_short_name fnd_application.application_short_name%TYPE;
6249: l_application_name fnd_application_tl.application_name%TYPE;
6250: l_id_flex_structure_code fnd_id_flex_structures.id_flex_structure_code%TYPE;
6251: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
6252: l_nsegments NUMBER;
6253: l_message VARCHAR2(1000);
6254: l_validation_type VARCHAR2(1000);
6255: l_format_type VARCHAR2(1000);

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

6299: end if;
6300:
6301: if (l_vset_r.validation_type = 'F') then
6302:
6303: select additional_quickpick_columns into l_additional_quickpick_columns from fnd_flex_validation_tables where flex_value_set_id=l_segtype.value_set_id;
6304:
6305: if (l_additional_quickpick_columns is not null) then
6306: parse_bind_names(l_additional_quickpick_columns, l_table_of_varchar2_32000, l_num_binds);
6307: if (l_num_binds > 0) then