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 6012: l_default_type fnd_descr_flex_column_usages.default_type%TYPE;

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

Line 6013: l_default_value fnd_descr_flex_column_usages.default_value%TYPE;

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

Line 6017: l_segment_name fnd_descr_flex_column_usages.end_user_column_name%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;
6019: e_PairOrSpecial EXCEPTION;
6020: e_TableValidated EXCEPTION;
6021: e_DefaultTypeField EXCEPTION;

Line 6026: fnd_descr_flex_column_usages.default_type,

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

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'

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

Line 6034: AND fnd_descr_flex_column_usages.APPLICATION_ID = p_application_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'
6037: AND fnd_descr_flex_column_usages.DESCRIPTIVE_FLEX_CONTEXT_CODE = p_context_code;
6038:

Line 6035: AND fnd_descr_flex_column_usages.DESCRIPTIVE_FLEXFIELD_NAME = p_descriptive_flexfield_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'
6037: AND fnd_descr_flex_column_usages.DESCRIPTIVE_FLEX_CONTEXT_CODE = p_context_code;
6038:
6039: BEGIN -- Check segment's defaulting logic

Line 6036: AND fnd_descr_flex_column_usages.ENABLED_FLAG = 'Y'

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

Line 6037: AND fnd_descr_flex_column_usages.DESCRIPTIVE_FLEX_CONTEXT_CODE = p_context_code;

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'
6037: AND fnd_descr_flex_column_usages.DESCRIPTIVE_FLEX_CONTEXT_CODE = p_context_code;
6038:
6039: BEGIN -- Check segment's defaulting logic
6040: IF l_default_type = 'F' THEN -- If default type is field
6041: RAISE e_DefaultTypeField;

Line 6168: FROM fnd_descr_flex_column_usages

6164: END compute_segment_warnings;
6165: BEGIN
6166: FOR v_EnabledSegments IN
6167: (SELECT application_column_name
6168: FROM fnd_descr_flex_column_usages
6169: WHERE application_id = p_application_id
6170: AND descriptive_flexfield_name = p_descriptive_flexfield_name
6171: AND descriptive_flex_context_code = p_context_code
6172: AND enabled_flag = 'Y')