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.

[Home] [Help]

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 4508: l_vset fnd_flex_value_sets%ROWTYPE;

4504:
4505: l_sql VARCHAR2(32000);
4506: l_sql_dependent VARCHAR2(2000);
4507:
4508: l_vset fnd_flex_value_sets%ROWTYPE;
4509: l_lock_handle VARCHAR2(128) := NULL;
4510: l_vsc_code VARCHAR2(10);
4511:
4512: --

Line 4567: FROM fnd_flex_value_sets

4563: ELSE
4564: BEGIN
4565: SELECT *
4566: INTO l_vset
4567: FROM fnd_flex_value_sets
4568: WHERE 'AFFFSSVB.pls : $Revision: 120.13.12010000.3 $ : check_value_security' IS NOT NULL
4569: AND flex_value_set_id = p_flex_value_set_id;
4570: EXCEPTION
4571: WHEN OTHERS THEN

Line 5174: l_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;

5170: PROCEDURE raise_vst_updated(p_flex_value_set_id IN NUMBER)
5171: IS
5172: l_parameters wf_parameter_list_t := wf_parameter_list_t();
5173:
5174: l_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
5175: BEGIN
5176: SELECT flex_value_set_name
5177: INTO l_flex_value_set_name
5178: FROM fnd_flex_value_sets

Line 5178: FROM fnd_flex_value_sets

5174: l_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
5175: BEGIN
5176: SELECT flex_value_set_name
5177: INTO l_flex_value_set_name
5178: FROM fnd_flex_value_sets
5179: WHERE flex_value_set_id = p_flex_value_set_id;
5180:
5181: wf_event.addparametertolist(p_name => 'FLEX_VALUE_SET_NAME',
5182: p_value => l_flex_value_set_name,

Line 5274: FROM fnd_id_flex_segments fifsg, fnd_flex_value_sets ffvs,

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

Line 5934: l_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;

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

Line 5942: l_validation_type fnd_flex_value_sets.validation_type%TYPE;

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

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

6006: PROCEDURE compute_segment_warnings(p_application_column_name IN VARCHAR2)
6007: IS
6008: l_num_binds NUMBER;
6009: i NUMBER;
6010: l_format_type fnd_flex_value_sets.format_type%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;

Line 6011: l_validation_type fnd_flex_value_sets.validation_type%TYPE;

6007: IS
6008: l_num_binds NUMBER;
6009: i NUMBER;
6010: l_format_type fnd_flex_value_sets.format_type%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;

Line 6014: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

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

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

6021: e_DefaultTypeField EXCEPTION;
6022: e_DEfaultTypeSQL EXCEPTION;
6023: BEGIN
6024:
6025: SELECT fnd_flex_value_sets.validation_type,fnd_flex_value_sets.format_type,
6026: fnd_descr_flex_column_usages.default_type,
6027: fnd_descr_flex_column_usages.default_value,fnd_flex_value_sets.flex_value_set_id,
6028: fnd_flex_value_sets.flex_value_set_name,fnd_descr_flex_column_usages.end_user_column_name
6029: INTO l_validation_type,l_format_type,l_default_type,l_default_value,l_value_set_id,

Line 6027: fnd_descr_flex_column_usages.default_value,fnd_flex_value_sets.flex_value_set_id,

6023: BEGIN
6024:
6025: SELECT fnd_flex_value_sets.validation_type,fnd_flex_value_sets.format_type,
6026: fnd_descr_flex_column_usages.default_type,
6027: fnd_descr_flex_column_usages.default_value,fnd_flex_value_sets.flex_value_set_id,
6028: fnd_flex_value_sets.flex_value_set_name,fnd_descr_flex_column_usages.end_user_column_name
6029: INTO l_validation_type,l_format_type,l_default_type,l_default_value,l_value_set_id,
6030: l_value_set_name,l_segment_name
6031: FROM fnd_descr_flex_column_usages,fnd_flex_value_sets

Line 6028: fnd_flex_value_sets.flex_value_set_name,fnd_descr_flex_column_usages.end_user_column_name

6024:
6025: SELECT fnd_flex_value_sets.validation_type,fnd_flex_value_sets.format_type,
6026: fnd_descr_flex_column_usages.default_type,
6027: fnd_descr_flex_column_usages.default_value,fnd_flex_value_sets.flex_value_set_id,
6028: fnd_flex_value_sets.flex_value_set_name,fnd_descr_flex_column_usages.end_user_column_name
6029: INTO l_validation_type,l_format_type,l_default_type,l_default_value,l_value_set_id,
6030: l_value_set_name,l_segment_name
6031: FROM fnd_descr_flex_column_usages,fnd_flex_value_sets
6032: WHERE fnd_descr_flex_column_usages.flex_value_set_id = fnd_flex_value_sets.flex_value_set_id (+)

Line 6031: FROM fnd_descr_flex_column_usages,fnd_flex_value_sets

6027: fnd_descr_flex_column_usages.default_value,fnd_flex_value_sets.flex_value_set_id,
6028: fnd_flex_value_sets.flex_value_set_name,fnd_descr_flex_column_usages.end_user_column_name
6029: INTO l_validation_type,l_format_type,l_default_type,l_default_value,l_value_set_id,
6030: l_value_set_name,l_segment_name
6031: FROM fnd_descr_flex_column_usages,fnd_flex_value_sets
6032: WHERE fnd_descr_flex_column_usages.flex_value_set_id = fnd_flex_value_sets.flex_value_set_id (+)
6033: AND fnd_descr_flex_column_usages.application_column_name = p_application_column_name
6034: AND fnd_descr_flex_column_usages.APPLICATION_ID = p_application_id
6035: AND fnd_descr_flex_column_usages.DESCRIPTIVE_FLEXFIELD_NAME = p_descriptive_flexfield_name

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

6028: fnd_flex_value_sets.flex_value_set_name,fnd_descr_flex_column_usages.end_user_column_name
6029: INTO l_validation_type,l_format_type,l_default_type,l_default_value,l_value_set_id,
6030: l_value_set_name,l_segment_name
6031: FROM fnd_descr_flex_column_usages,fnd_flex_value_sets
6032: WHERE fnd_descr_flex_column_usages.flex_value_set_id = fnd_flex_value_sets.flex_value_set_id (+)
6033: AND fnd_descr_flex_column_usages.application_column_name = p_application_column_name
6034: AND fnd_descr_flex_column_usages.APPLICATION_ID = p_application_id
6035: AND fnd_descr_flex_column_usages.DESCRIPTIVE_FLEXFIELD_NAME = p_descriptive_flexfield_name
6036: AND fnd_descr_flex_column_usages.ENABLED_FLAG = 'Y'