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_DESCRIPTIVE_FLEXS

Line 5932: l_title fnd_descriptive_flexs_tl.title%TYPE;

5928: IS
5929: l_non_forms_warn_table_type table_of_varchar2_32000;
5930: l_application_short_name fnd_application.application_short_name%TYPE;
5931: l_application_name fnd_application_tl.application_name%TYPE;
5932: l_title fnd_descriptive_flexs_tl.title%TYPE;
5933: l_meaning fnd_lookup_values_vl.meaning%TYPE;
5934: l_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
5935: l_srs_flag BOOLEAN;
5936:

Line 5941: l_reference_field fnd_descriptive_flexs.default_context_field_name%TYPE;

5937: PROCEDURE compute_context_segment_warn(p_application_id in NUMBER)
5938: IS
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;

Line 5952: fnd_descriptive_flexs.default_context_field_name,fnd_flex_value_sets.flex_value_set_name

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
5956: WHERE fnd_flex_value_sets.flex_value_set_id (+)= fnd_descriptive_flexs.context_override_value_set_id

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 5956: WHERE fnd_flex_value_sets.flex_value_set_id (+)= fnd_descriptive_flexs.context_override_value_set_id

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;
5960:

Line 5958: AND fnd_descriptive_flexs.application_id = p_application_id

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
5962:

Line 5959: AND fnd_descriptive_flexs.descriptive_flexfield_name = p_descriptive_flexfield_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
5962:
5963: IF l_validation_type = 'F' THEN -- If table validated valueset

Line 6194: FROM fnd_descriptive_flexs_vl

6190: WHERE application_id = p_application_id;
6191:
6192: SELECT title
6193: INTO l_title
6194: FROM fnd_descriptive_flexs_vl
6195: WHERE application_id = p_application_id
6196: AND descriptive_flexfield_name=p_descriptive_flexfield_name;
6197:
6198: IF p_descriptive_flexfield_name LIKE '$SRS$.%' THEN