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