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_DSC_API dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 1657: l_application_id fnd_descr_flex_col_usage_vl.application_id%TYPE;

1653: p_range IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1654: p_srw_parameter IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1655: p_runtime_property_function IN VARCHAR2 DEFAULT fnd_api.g_miss_char)
1656: IS
1657: l_application_id fnd_descr_flex_col_usage_vl.application_id%TYPE;
1658: l_description fnd_descr_flex_col_usage_vl.description%TYPE;
1659: l_sequence_number fnd_descr_flex_col_usage_vl.column_seq_num%TYPE;
1660: l_enabled fnd_descr_flex_col_usage_vl.enabled_flag%TYPE;
1661: l_displayed fnd_descr_flex_col_usage_vl.display_flag%TYPE;

Line 1658: l_description fnd_descr_flex_col_usage_vl.description%TYPE;

1654: p_srw_parameter IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1655: p_runtime_property_function IN VARCHAR2 DEFAULT fnd_api.g_miss_char)
1656: IS
1657: l_application_id fnd_descr_flex_col_usage_vl.application_id%TYPE;
1658: l_description fnd_descr_flex_col_usage_vl.description%TYPE;
1659: l_sequence_number fnd_descr_flex_col_usage_vl.column_seq_num%TYPE;
1660: l_enabled fnd_descr_flex_col_usage_vl.enabled_flag%TYPE;
1661: l_displayed fnd_descr_flex_col_usage_vl.display_flag%TYPE;
1662: l_default_type fnd_descr_flex_col_usage_vl.default_type%TYPE;

Line 1659: l_sequence_number fnd_descr_flex_col_usage_vl.column_seq_num%TYPE;

1655: p_runtime_property_function IN VARCHAR2 DEFAULT fnd_api.g_miss_char)
1656: IS
1657: l_application_id fnd_descr_flex_col_usage_vl.application_id%TYPE;
1658: l_description fnd_descr_flex_col_usage_vl.description%TYPE;
1659: l_sequence_number fnd_descr_flex_col_usage_vl.column_seq_num%TYPE;
1660: l_enabled fnd_descr_flex_col_usage_vl.enabled_flag%TYPE;
1661: l_displayed fnd_descr_flex_col_usage_vl.display_flag%TYPE;
1662: l_default_type fnd_descr_flex_col_usage_vl.default_type%TYPE;
1663: l_default_value fnd_descr_flex_col_usage_vl.default_value%TYPE;

Line 1660: l_enabled fnd_descr_flex_col_usage_vl.enabled_flag%TYPE;

1656: IS
1657: l_application_id fnd_descr_flex_col_usage_vl.application_id%TYPE;
1658: l_description fnd_descr_flex_col_usage_vl.description%TYPE;
1659: l_sequence_number fnd_descr_flex_col_usage_vl.column_seq_num%TYPE;
1660: l_enabled fnd_descr_flex_col_usage_vl.enabled_flag%TYPE;
1661: l_displayed fnd_descr_flex_col_usage_vl.display_flag%TYPE;
1662: l_default_type fnd_descr_flex_col_usage_vl.default_type%TYPE;
1663: l_default_value fnd_descr_flex_col_usage_vl.default_value%TYPE;
1664: l_required fnd_descr_flex_col_usage_vl.required_flag%TYPE;

Line 1661: l_displayed fnd_descr_flex_col_usage_vl.display_flag%TYPE;

1657: l_application_id fnd_descr_flex_col_usage_vl.application_id%TYPE;
1658: l_description fnd_descr_flex_col_usage_vl.description%TYPE;
1659: l_sequence_number fnd_descr_flex_col_usage_vl.column_seq_num%TYPE;
1660: l_enabled fnd_descr_flex_col_usage_vl.enabled_flag%TYPE;
1661: l_displayed fnd_descr_flex_col_usage_vl.display_flag%TYPE;
1662: l_default_type fnd_descr_flex_col_usage_vl.default_type%TYPE;
1663: l_default_value fnd_descr_flex_col_usage_vl.default_value%TYPE;
1664: l_required fnd_descr_flex_col_usage_vl.required_flag%TYPE;
1665: l_security_enabled fnd_descr_flex_col_usage_vl.security_enabled_flag%TYPE;

Line 1662: l_default_type fnd_descr_flex_col_usage_vl.default_type%TYPE;

1658: l_description fnd_descr_flex_col_usage_vl.description%TYPE;
1659: l_sequence_number fnd_descr_flex_col_usage_vl.column_seq_num%TYPE;
1660: l_enabled fnd_descr_flex_col_usage_vl.enabled_flag%TYPE;
1661: l_displayed fnd_descr_flex_col_usage_vl.display_flag%TYPE;
1662: l_default_type fnd_descr_flex_col_usage_vl.default_type%TYPE;
1663: l_default_value fnd_descr_flex_col_usage_vl.default_value%TYPE;
1664: l_required fnd_descr_flex_col_usage_vl.required_flag%TYPE;
1665: l_security_enabled fnd_descr_flex_col_usage_vl.security_enabled_flag%TYPE;
1666: l_display_size fnd_descr_flex_col_usage_vl.display_size%TYPE;

Line 1663: l_default_value fnd_descr_flex_col_usage_vl.default_value%TYPE;

1659: l_sequence_number fnd_descr_flex_col_usage_vl.column_seq_num%TYPE;
1660: l_enabled fnd_descr_flex_col_usage_vl.enabled_flag%TYPE;
1661: l_displayed fnd_descr_flex_col_usage_vl.display_flag%TYPE;
1662: l_default_type fnd_descr_flex_col_usage_vl.default_type%TYPE;
1663: l_default_value fnd_descr_flex_col_usage_vl.default_value%TYPE;
1664: l_required fnd_descr_flex_col_usage_vl.required_flag%TYPE;
1665: l_security_enabled fnd_descr_flex_col_usage_vl.security_enabled_flag%TYPE;
1666: l_display_size fnd_descr_flex_col_usage_vl.display_size%TYPE;
1667: l_description_size fnd_descr_flex_col_usage_vl.maximum_description_len%TYPE;

Line 1664: l_required fnd_descr_flex_col_usage_vl.required_flag%TYPE;

1660: l_enabled fnd_descr_flex_col_usage_vl.enabled_flag%TYPE;
1661: l_displayed fnd_descr_flex_col_usage_vl.display_flag%TYPE;
1662: l_default_type fnd_descr_flex_col_usage_vl.default_type%TYPE;
1663: l_default_value fnd_descr_flex_col_usage_vl.default_value%TYPE;
1664: l_required fnd_descr_flex_col_usage_vl.required_flag%TYPE;
1665: l_security_enabled fnd_descr_flex_col_usage_vl.security_enabled_flag%TYPE;
1666: l_display_size fnd_descr_flex_col_usage_vl.display_size%TYPE;
1667: l_description_size fnd_descr_flex_col_usage_vl.maximum_description_len%TYPE;
1668: l_concat_desc_size fnd_descr_flex_col_usage_vl.concatenation_description_len%TYPE;

Line 1665: l_security_enabled fnd_descr_flex_col_usage_vl.security_enabled_flag%TYPE;

1661: l_displayed fnd_descr_flex_col_usage_vl.display_flag%TYPE;
1662: l_default_type fnd_descr_flex_col_usage_vl.default_type%TYPE;
1663: l_default_value fnd_descr_flex_col_usage_vl.default_value%TYPE;
1664: l_required fnd_descr_flex_col_usage_vl.required_flag%TYPE;
1665: l_security_enabled fnd_descr_flex_col_usage_vl.security_enabled_flag%TYPE;
1666: l_display_size fnd_descr_flex_col_usage_vl.display_size%TYPE;
1667: l_description_size fnd_descr_flex_col_usage_vl.maximum_description_len%TYPE;
1668: l_concat_desc_size fnd_descr_flex_col_usage_vl.concatenation_description_len%TYPE;
1669: l_lov_prompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;

Line 1666: l_display_size fnd_descr_flex_col_usage_vl.display_size%TYPE;

1662: l_default_type fnd_descr_flex_col_usage_vl.default_type%TYPE;
1663: l_default_value fnd_descr_flex_col_usage_vl.default_value%TYPE;
1664: l_required fnd_descr_flex_col_usage_vl.required_flag%TYPE;
1665: l_security_enabled fnd_descr_flex_col_usage_vl.security_enabled_flag%TYPE;
1666: l_display_size fnd_descr_flex_col_usage_vl.display_size%TYPE;
1667: l_description_size fnd_descr_flex_col_usage_vl.maximum_description_len%TYPE;
1668: l_concat_desc_size fnd_descr_flex_col_usage_vl.concatenation_description_len%TYPE;
1669: l_lov_prompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;
1670: l_window_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;

Line 1667: l_description_size fnd_descr_flex_col_usage_vl.maximum_description_len%TYPE;

1663: l_default_value fnd_descr_flex_col_usage_vl.default_value%TYPE;
1664: l_required fnd_descr_flex_col_usage_vl.required_flag%TYPE;
1665: l_security_enabled fnd_descr_flex_col_usage_vl.security_enabled_flag%TYPE;
1666: l_display_size fnd_descr_flex_col_usage_vl.display_size%TYPE;
1667: l_description_size fnd_descr_flex_col_usage_vl.maximum_description_len%TYPE;
1668: l_concat_desc_size fnd_descr_flex_col_usage_vl.concatenation_description_len%TYPE;
1669: l_lov_prompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;
1670: l_window_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
1671: l_range fnd_descr_flex_col_usage_vl.range_code%TYPE;

Line 1668: l_concat_desc_size fnd_descr_flex_col_usage_vl.concatenation_description_len%TYPE;

1664: l_required fnd_descr_flex_col_usage_vl.required_flag%TYPE;
1665: l_security_enabled fnd_descr_flex_col_usage_vl.security_enabled_flag%TYPE;
1666: l_display_size fnd_descr_flex_col_usage_vl.display_size%TYPE;
1667: l_description_size fnd_descr_flex_col_usage_vl.maximum_description_len%TYPE;
1668: l_concat_desc_size fnd_descr_flex_col_usage_vl.concatenation_description_len%TYPE;
1669: l_lov_prompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;
1670: l_window_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
1671: l_range fnd_descr_flex_col_usage_vl.range_code%TYPE;
1672: l_srw_parameter fnd_descr_flex_col_usage_vl.srw_param%TYPE;

Line 1669: l_lov_prompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;

1665: l_security_enabled fnd_descr_flex_col_usage_vl.security_enabled_flag%TYPE;
1666: l_display_size fnd_descr_flex_col_usage_vl.display_size%TYPE;
1667: l_description_size fnd_descr_flex_col_usage_vl.maximum_description_len%TYPE;
1668: l_concat_desc_size fnd_descr_flex_col_usage_vl.concatenation_description_len%TYPE;
1669: l_lov_prompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;
1670: l_window_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
1671: l_range fnd_descr_flex_col_usage_vl.range_code%TYPE;
1672: l_srw_parameter fnd_descr_flex_col_usage_vl.srw_param%TYPE;
1673: l_runtime_property_function fnd_descr_flex_col_usage_vl.runtime_property_function%TYPE;

Line 1670: l_window_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;

1666: l_display_size fnd_descr_flex_col_usage_vl.display_size%TYPE;
1667: l_description_size fnd_descr_flex_col_usage_vl.maximum_description_len%TYPE;
1668: l_concat_desc_size fnd_descr_flex_col_usage_vl.concatenation_description_len%TYPE;
1669: l_lov_prompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;
1670: l_window_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
1671: l_range fnd_descr_flex_col_usage_vl.range_code%TYPE;
1672: l_srw_parameter fnd_descr_flex_col_usage_vl.srw_param%TYPE;
1673: l_runtime_property_function fnd_descr_flex_col_usage_vl.runtime_property_function%TYPE;
1674: l_flex_value_set_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;

Line 1671: l_range fnd_descr_flex_col_usage_vl.range_code%TYPE;

1667: l_description_size fnd_descr_flex_col_usage_vl.maximum_description_len%TYPE;
1668: l_concat_desc_size fnd_descr_flex_col_usage_vl.concatenation_description_len%TYPE;
1669: l_lov_prompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;
1670: l_window_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
1671: l_range fnd_descr_flex_col_usage_vl.range_code%TYPE;
1672: l_srw_parameter fnd_descr_flex_col_usage_vl.srw_param%TYPE;
1673: l_runtime_property_function fnd_descr_flex_col_usage_vl.runtime_property_function%TYPE;
1674: l_flex_value_set_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
1675: dummy VARCHAR2(100);

Line 1672: l_srw_parameter fnd_descr_flex_col_usage_vl.srw_param%TYPE;

1668: l_concat_desc_size fnd_descr_flex_col_usage_vl.concatenation_description_len%TYPE;
1669: l_lov_prompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;
1670: l_window_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
1671: l_range fnd_descr_flex_col_usage_vl.range_code%TYPE;
1672: l_srw_parameter fnd_descr_flex_col_usage_vl.srw_param%TYPE;
1673: l_runtime_property_function fnd_descr_flex_col_usage_vl.runtime_property_function%TYPE;
1674: l_flex_value_set_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
1675: dummy VARCHAR2(100);
1676: l_segment_name fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;

Line 1673: l_runtime_property_function fnd_descr_flex_col_usage_vl.runtime_property_function%TYPE;

1669: l_lov_prompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;
1670: l_window_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
1671: l_range fnd_descr_flex_col_usage_vl.range_code%TYPE;
1672: l_srw_parameter fnd_descr_flex_col_usage_vl.srw_param%TYPE;
1673: l_runtime_property_function fnd_descr_flex_col_usage_vl.runtime_property_function%TYPE;
1674: l_flex_value_set_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
1675: dummy VARCHAR2(100);
1676: l_segment_name fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;
1677: l_column_name fnd_descr_flex_col_usage_vl.application_column_name%TYPE;

Line 1674: l_flex_value_set_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;

1670: l_window_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
1671: l_range fnd_descr_flex_col_usage_vl.range_code%TYPE;
1672: l_srw_parameter fnd_descr_flex_col_usage_vl.srw_param%TYPE;
1673: l_runtime_property_function fnd_descr_flex_col_usage_vl.runtime_property_function%TYPE;
1674: l_flex_value_set_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
1675: dummy VARCHAR2(100);
1676: l_segment_name fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;
1677: l_column_name fnd_descr_flex_col_usage_vl.application_column_name%TYPE;
1678: l_column_type fnd_columns.column_type%TYPE;

Line 1676: l_segment_name fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;

1672: l_srw_parameter fnd_descr_flex_col_usage_vl.srw_param%TYPE;
1673: l_runtime_property_function fnd_descr_flex_col_usage_vl.runtime_property_function%TYPE;
1674: l_flex_value_set_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
1675: dummy VARCHAR2(100);
1676: l_segment_name fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;
1677: l_column_name fnd_descr_flex_col_usage_vl.application_column_name%TYPE;
1678: l_column_type fnd_columns.column_type%TYPE;
1679: l_column_width fnd_columns.width%TYPE;
1680: l_table_name fnd_descriptive_flexs.application_table_name%TYPE;

Line 1677: l_column_name fnd_descr_flex_col_usage_vl.application_column_name%TYPE;

1673: l_runtime_property_function fnd_descr_flex_col_usage_vl.runtime_property_function%TYPE;
1674: l_flex_value_set_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
1675: dummy VARCHAR2(100);
1676: l_segment_name fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;
1677: l_column_name fnd_descr_flex_col_usage_vl.application_column_name%TYPE;
1678: l_column_type fnd_columns.column_type%TYPE;
1679: l_column_width fnd_columns.width%TYPE;
1680: l_table_name fnd_descriptive_flexs.application_table_name%TYPE;
1681:

Line 1682: l_last_update_login fnd_descr_flex_col_usage_vl.last_update_login%TYPE

1678: l_column_type fnd_columns.column_type%TYPE;
1679: l_column_width fnd_columns.width%TYPE;
1680: l_table_name fnd_descriptive_flexs.application_table_name%TYPE;
1681:
1682: l_last_update_login fnd_descr_flex_col_usage_vl.last_update_login%TYPE
1683: := last_update_login_f;
1684: l_last_update_date fnd_descr_flex_col_usage_vl.last_update_date%TYPE
1685: := last_update_date_f;
1686: l_last_updated_by fnd_descr_flex_col_usage_vl.last_updated_by%TYPE

Line 1684: l_last_update_date fnd_descr_flex_col_usage_vl.last_update_date%TYPE

1680: l_table_name fnd_descriptive_flexs.application_table_name%TYPE;
1681:
1682: l_last_update_login fnd_descr_flex_col_usage_vl.last_update_login%TYPE
1683: := last_update_login_f;
1684: l_last_update_date fnd_descr_flex_col_usage_vl.last_update_date%TYPE
1685: := last_update_date_f;
1686: l_last_updated_by fnd_descr_flex_col_usage_vl.last_updated_by%TYPE
1687: := last_updated_by_f;
1688: BEGIN

Line 1686: l_last_updated_by fnd_descr_flex_col_usage_vl.last_updated_by%TYPE

1682: l_last_update_login fnd_descr_flex_col_usage_vl.last_update_login%TYPE
1683: := last_update_login_f;
1684: l_last_update_date fnd_descr_flex_col_usage_vl.last_update_date%TYPE
1685: := last_update_date_f;
1686: l_last_updated_by fnd_descr_flex_col_usage_vl.last_updated_by%TYPE
1687: := last_updated_by_f;
1688: BEGIN
1689: message_init;
1690: l_application_id := application_id_f(p_appl_short_name);

Line 1716: FROM fnd_descr_flex_col_usage_vl

1712: l_lov_prompt, l_window_prompt, l_range, l_srw_parameter,
1713: l_runtime_property_function,
1714: l_column_name,
1715: l_segment_name
1716: FROM fnd_descr_flex_col_usage_vl
1717: WHERE application_id = l_application_id
1718: AND descriptive_flexfield_name = p_flexfield_name
1719: AND descriptive_flex_context_code = p_context_code
1720: AND (((p_column_name IS NOT NULL) AND