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_DESCR_FLEX_COLUMN_USAGES

Line 6205: l_default_type fnd_descr_flex_column_usages.default_type%TYPE;

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;
6209: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;

Line 6206: l_default_value fnd_descr_flex_column_usages.default_value%TYPE;

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

Line 6210: l_segment_name fnd_descr_flex_column_usages.end_user_column_name%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;
6212: e_PairOrSpecial EXCEPTION;
6213: e_TableValidated EXCEPTION;
6214: e_DefaultTypeField EXCEPTION;

Line 6219: fnd_descr_flex_column_usages.default_type,

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,
6223: l_value_set_name,l_segment_name

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'

Line 6226: AND fnd_descr_flex_column_usages.application_column_name = p_application_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'
6230: AND fnd_descr_flex_column_usages.DESCRIPTIVE_FLEX_CONTEXT_CODE = p_context_code;

Line 6227: AND fnd_descr_flex_column_usages.APPLICATION_ID = p_application_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'
6230: AND fnd_descr_flex_column_usages.DESCRIPTIVE_FLEX_CONTEXT_CODE = p_context_code;
6231:

Line 6228: AND fnd_descr_flex_column_usages.DESCRIPTIVE_FLEXFIELD_NAME = p_descriptive_flexfield_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'
6230: AND fnd_descr_flex_column_usages.DESCRIPTIVE_FLEX_CONTEXT_CODE = p_context_code;
6231:
6232: BEGIN -- Check segment's defaulting logic

Line 6229: AND fnd_descr_flex_column_usages.ENABLED_FLAG = 'Y'

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'
6230: AND fnd_descr_flex_column_usages.DESCRIPTIVE_FLEX_CONTEXT_CODE = p_context_code;
6231:
6232: BEGIN -- Check segment's defaulting logic
6233: IF l_default_type = 'F' THEN -- If default type is field

Line 6230: AND fnd_descr_flex_column_usages.DESCRIPTIVE_FLEX_CONTEXT_CODE = p_context_code;

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'
6230: AND fnd_descr_flex_column_usages.DESCRIPTIVE_FLEX_CONTEXT_CODE = p_context_code;
6231:
6232: BEGIN -- Check segment's defaulting logic
6233: IF l_default_type = 'F' THEN -- If default type is field
6234: RAISE e_DefaultTypeField;

Line 6361: FROM fnd_descr_flex_column_usages

6357: END compute_segment_warnings;
6358: BEGIN
6359: FOR v_EnabledSegments IN
6360: (SELECT application_column_name
6361: FROM fnd_descr_flex_column_usages
6362: WHERE application_id = p_application_id
6363: AND descriptive_flexfield_name = p_descriptive_flexfield_name
6364: AND descriptive_flex_context_code = p_context_code
6365: AND enabled_flag = 'Y')