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_VALUE_SETS

Line 30: TYPE vst_cache_storage_table_type IS TABLE OF fnd_flex_value_sets%ROWTYPE

26:
27: -- --------------------------------------------------
28: -- vst : Value set cache.
29: -- --------------------------------------------------
30: TYPE vst_cache_storage_table_type IS TABLE OF fnd_flex_value_sets%ROWTYPE
31: INDEX BY BINARY_INTEGER;
32:
33: vst_cache_controller fnd_plsql_cache.cache_1to1_controller_type;
34: vst_cache_storage vst_cache_storage_table_type;

Line 4537: l_vset fnd_flex_value_sets%ROWTYPE;

4533: l_error_message fnd_flex_value_rules_tl.error_message%TYPE;
4534:
4535: l_sql VARCHAR2(32000);
4536:
4537: l_vset fnd_flex_value_sets%ROWTYPE;
4538: l_lock_handle VARCHAR2(128) := NULL;
4539: l_vsc_code VARCHAR2(10);
4540:
4541: --

Line 4695: FROM fnd_flex_value_sets

4691: ELSE
4692: BEGIN
4693: SELECT *
4694: INTO l_vset
4695: FROM fnd_flex_value_sets
4696: WHERE 'AFFFSSVB.pls : $Revision: 120.28.12020000.2 $ : check_value_security' IS NOT NULL
4697: AND flex_value_set_id = p_flex_value_set_id;
4698: EXCEPTION
4699: WHEN OTHERS THEN

Line 5367: l_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;

5363: PROCEDURE raise_vst_updated(p_flex_value_set_id IN NUMBER)
5364: IS
5365: l_parameters wf_parameter_list_t := wf_parameter_list_t();
5366:
5367: l_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
5368: BEGIN
5369: SELECT flex_value_set_name
5370: INTO l_flex_value_set_name
5371: FROM fnd_flex_value_sets

Line 5371: FROM fnd_flex_value_sets

5367: l_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
5368: BEGIN
5369: SELECT flex_value_set_name
5370: INTO l_flex_value_set_name
5371: FROM fnd_flex_value_sets
5372: WHERE flex_value_set_id = p_flex_value_set_id;
5373:
5374: wf_event.addparametertolist(p_name => 'FLEX_VALUE_SET_NAME',
5375: p_value => l_flex_value_set_name,

Line 5467: FROM fnd_id_flex_segments fifsg, fnd_flex_value_sets ffvs,

5463: ffvt.id_column_type vset_id_column_type,
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

Line 6127: l_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;

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

Line 6135: l_validation_type fnd_flex_value_sets.validation_type%TYPE;

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;
6139: l_segement_name fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;

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 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 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 6203: l_format_type fnd_flex_value_sets.format_type%TYPE;

6199: PROCEDURE compute_segment_warnings(p_application_column_name IN VARCHAR2)
6200: IS
6201: l_num_binds NUMBER;
6202: i NUMBER;
6203: l_format_type fnd_flex_value_sets.format_type%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;

Line 6204: l_validation_type fnd_flex_value_sets.validation_type%TYPE;

6200: IS
6201: l_num_binds NUMBER;
6202: i NUMBER;
6203: l_format_type fnd_flex_value_sets.format_type%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;

Line 6207: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

6203: l_format_type fnd_flex_value_sets.format_type%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;

Line 6218: SELECT fnd_flex_value_sets.validation_type,fnd_flex_value_sets.format_type,

6214: e_DefaultTypeField EXCEPTION;
6215: e_DEfaultTypeSQL EXCEPTION;
6216: BEGIN
6217:
6218: SELECT fnd_flex_value_sets.validation_type,fnd_flex_value_sets.format_type,
6219: fnd_descr_flex_column_usages.default_type,
6220: fnd_descr_flex_column_usages.default_value,fnd_flex_value_sets.flex_value_set_id,
6221: fnd_flex_value_sets.flex_value_set_name,fnd_descr_flex_column_usages.end_user_column_name
6222: INTO l_validation_type,l_format_type,l_default_type,l_default_value,l_value_set_id,

Line 6220: fnd_descr_flex_column_usages.default_value,fnd_flex_value_sets.flex_value_set_id,

6216: BEGIN
6217:
6218: SELECT fnd_flex_value_sets.validation_type,fnd_flex_value_sets.format_type,
6219: fnd_descr_flex_column_usages.default_type,
6220: fnd_descr_flex_column_usages.default_value,fnd_flex_value_sets.flex_value_set_id,
6221: fnd_flex_value_sets.flex_value_set_name,fnd_descr_flex_column_usages.end_user_column_name
6222: INTO l_validation_type,l_format_type,l_default_type,l_default_value,l_value_set_id,
6223: l_value_set_name,l_segment_name
6224: FROM fnd_descr_flex_column_usages,fnd_flex_value_sets

Line 6221: fnd_flex_value_sets.flex_value_set_name,fnd_descr_flex_column_usages.end_user_column_name

6217:
6218: SELECT fnd_flex_value_sets.validation_type,fnd_flex_value_sets.format_type,
6219: fnd_descr_flex_column_usages.default_type,
6220: fnd_descr_flex_column_usages.default_value,fnd_flex_value_sets.flex_value_set_id,
6221: fnd_flex_value_sets.flex_value_set_name,fnd_descr_flex_column_usages.end_user_column_name
6222: INTO l_validation_type,l_format_type,l_default_type,l_default_value,l_value_set_id,
6223: l_value_set_name,l_segment_name
6224: FROM fnd_descr_flex_column_usages,fnd_flex_value_sets
6225: WHERE fnd_descr_flex_column_usages.flex_value_set_id = fnd_flex_value_sets.flex_value_set_id (+)

Line 6224: FROM fnd_descr_flex_column_usages,fnd_flex_value_sets

6220: fnd_descr_flex_column_usages.default_value,fnd_flex_value_sets.flex_value_set_id,
6221: fnd_flex_value_sets.flex_value_set_name,fnd_descr_flex_column_usages.end_user_column_name
6222: INTO l_validation_type,l_format_type,l_default_type,l_default_value,l_value_set_id,
6223: l_value_set_name,l_segment_name
6224: FROM fnd_descr_flex_column_usages,fnd_flex_value_sets
6225: WHERE fnd_descr_flex_column_usages.flex_value_set_id = fnd_flex_value_sets.flex_value_set_id (+)
6226: AND fnd_descr_flex_column_usages.application_column_name = p_application_column_name
6227: AND fnd_descr_flex_column_usages.APPLICATION_ID = p_application_id
6228: AND fnd_descr_flex_column_usages.DESCRIPTIVE_FLEXFIELD_NAME = p_descriptive_flexfield_name

Line 6225: WHERE fnd_descr_flex_column_usages.flex_value_set_id = fnd_flex_value_sets.flex_value_set_id (+)

6221: fnd_flex_value_sets.flex_value_set_name,fnd_descr_flex_column_usages.end_user_column_name
6222: INTO l_validation_type,l_format_type,l_default_type,l_default_value,l_value_set_id,
6223: l_value_set_name,l_segment_name
6224: FROM fnd_descr_flex_column_usages,fnd_flex_value_sets
6225: WHERE fnd_descr_flex_column_usages.flex_value_set_id = fnd_flex_value_sets.flex_value_set_id (+)
6226: AND fnd_descr_flex_column_usages.application_column_name = p_application_column_name
6227: AND fnd_descr_flex_column_usages.APPLICATION_ID = p_application_id
6228: AND fnd_descr_flex_column_usages.DESCRIPTIVE_FLEXFIELD_NAME = p_descriptive_flexfield_name
6229: AND fnd_descr_flex_column_usages.ENABLED_FLAG = 'Y'