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 6125: l_title fnd_descriptive_flexs_tl.title%TYPE;

6121: IS
6122: l_non_forms_warn_table_type table_of_varchar2_32000;
6123: l_application_short_name fnd_application.application_short_name%TYPE;
6124: l_application_name fnd_application_tl.application_name%TYPE;
6125: l_title fnd_descriptive_flexs_tl.title%TYPE;
6126: l_meaning fnd_lookup_values_vl.meaning%TYPE;
6127: l_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
6128: l_srs_flag BOOLEAN;
6129:

Line 6134: l_reference_field fnd_descriptive_flexs.default_context_field_name%TYPE;

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

Line 6145: fnd_descriptive_flexs.default_context_field_name,fnd_flex_value_sets.flex_value_set_name

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

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

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

Line 6151: AND fnd_descriptive_flexs.application_id = p_application_id

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

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

Line 6387: FROM fnd_descriptive_flexs_vl

6383: WHERE application_id = p_application_id;
6384:
6385: SELECT title
6386: INTO l_title
6387: FROM fnd_descriptive_flexs_vl
6388: WHERE application_id = p_application_id
6389: AND descriptive_flexfield_name=p_descriptive_flexfield_name;
6390:
6391: IF p_descriptive_flexfield_name LIKE '$SRS$.%' THEN