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

Line 3059: l_application_id fnd_descr_flex_col_usage_vl.application_id%TYPE;

3055: p_segment_name IN VARCHAR2 DEFAULT NULL,
3056: p_column_name IN VARCHAR2 DEFAULT NULL)
3057:
3058: IS
3059: l_application_id fnd_descr_flex_col_usage_vl.application_id%TYPE;
3060: l_description fnd_descr_flex_col_usage_vl.description%TYPE;
3061: l_sequence_number fnd_descr_flex_col_usage_vl.column_seq_num%TYPE;
3062: l_enabled fnd_descr_flex_col_usage_vl.enabled_flag%TYPE;
3063: l_displayed fnd_descr_flex_col_usage_vl.display_flag%TYPE;

Line 3060: l_description fnd_descr_flex_col_usage_vl.description%TYPE;

3056: p_column_name IN VARCHAR2 DEFAULT NULL)
3057:
3058: IS
3059: l_application_id fnd_descr_flex_col_usage_vl.application_id%TYPE;
3060: l_description fnd_descr_flex_col_usage_vl.description%TYPE;
3061: l_sequence_number fnd_descr_flex_col_usage_vl.column_seq_num%TYPE;
3062: l_enabled fnd_descr_flex_col_usage_vl.enabled_flag%TYPE;
3063: l_displayed fnd_descr_flex_col_usage_vl.display_flag%TYPE;
3064: l_default_type fnd_descr_flex_col_usage_vl.default_type%TYPE;

Line 3061: l_sequence_number fnd_descr_flex_col_usage_vl.column_seq_num%TYPE;

3057:
3058: IS
3059: l_application_id fnd_descr_flex_col_usage_vl.application_id%TYPE;
3060: l_description fnd_descr_flex_col_usage_vl.description%TYPE;
3061: l_sequence_number fnd_descr_flex_col_usage_vl.column_seq_num%TYPE;
3062: l_enabled fnd_descr_flex_col_usage_vl.enabled_flag%TYPE;
3063: l_displayed fnd_descr_flex_col_usage_vl.display_flag%TYPE;
3064: l_default_type fnd_descr_flex_col_usage_vl.default_type%TYPE;
3065: l_default_value fnd_descr_flex_col_usage_vl.default_value%TYPE;

Line 3062: l_enabled fnd_descr_flex_col_usage_vl.enabled_flag%TYPE;

3058: IS
3059: l_application_id fnd_descr_flex_col_usage_vl.application_id%TYPE;
3060: l_description fnd_descr_flex_col_usage_vl.description%TYPE;
3061: l_sequence_number fnd_descr_flex_col_usage_vl.column_seq_num%TYPE;
3062: l_enabled fnd_descr_flex_col_usage_vl.enabled_flag%TYPE;
3063: l_displayed fnd_descr_flex_col_usage_vl.display_flag%TYPE;
3064: l_default_type fnd_descr_flex_col_usage_vl.default_type%TYPE;
3065: l_default_value fnd_descr_flex_col_usage_vl.default_value%TYPE;
3066: l_required fnd_descr_flex_col_usage_vl.required_flag%TYPE;

Line 3063: l_displayed fnd_descr_flex_col_usage_vl.display_flag%TYPE;

3059: l_application_id fnd_descr_flex_col_usage_vl.application_id%TYPE;
3060: l_description fnd_descr_flex_col_usage_vl.description%TYPE;
3061: l_sequence_number fnd_descr_flex_col_usage_vl.column_seq_num%TYPE;
3062: l_enabled fnd_descr_flex_col_usage_vl.enabled_flag%TYPE;
3063: l_displayed fnd_descr_flex_col_usage_vl.display_flag%TYPE;
3064: l_default_type fnd_descr_flex_col_usage_vl.default_type%TYPE;
3065: l_default_value fnd_descr_flex_col_usage_vl.default_value%TYPE;
3066: l_required fnd_descr_flex_col_usage_vl.required_flag%TYPE;
3067: l_security_enabled fnd_descr_flex_col_usage_vl.security_enabled_flag%TYPE;

Line 3064: l_default_type fnd_descr_flex_col_usage_vl.default_type%TYPE;

3060: l_description fnd_descr_flex_col_usage_vl.description%TYPE;
3061: l_sequence_number fnd_descr_flex_col_usage_vl.column_seq_num%TYPE;
3062: l_enabled fnd_descr_flex_col_usage_vl.enabled_flag%TYPE;
3063: l_displayed fnd_descr_flex_col_usage_vl.display_flag%TYPE;
3064: l_default_type fnd_descr_flex_col_usage_vl.default_type%TYPE;
3065: l_default_value fnd_descr_flex_col_usage_vl.default_value%TYPE;
3066: l_required fnd_descr_flex_col_usage_vl.required_flag%TYPE;
3067: l_security_enabled fnd_descr_flex_col_usage_vl.security_enabled_flag%TYPE;
3068: l_display_size fnd_descr_flex_col_usage_vl.display_size%TYPE;

Line 3065: l_default_value fnd_descr_flex_col_usage_vl.default_value%TYPE;

3061: l_sequence_number fnd_descr_flex_col_usage_vl.column_seq_num%TYPE;
3062: l_enabled fnd_descr_flex_col_usage_vl.enabled_flag%TYPE;
3063: l_displayed fnd_descr_flex_col_usage_vl.display_flag%TYPE;
3064: l_default_type fnd_descr_flex_col_usage_vl.default_type%TYPE;
3065: l_default_value fnd_descr_flex_col_usage_vl.default_value%TYPE;
3066: l_required fnd_descr_flex_col_usage_vl.required_flag%TYPE;
3067: l_security_enabled fnd_descr_flex_col_usage_vl.security_enabled_flag%TYPE;
3068: l_display_size fnd_descr_flex_col_usage_vl.display_size%TYPE;
3069: l_description_size

Line 3066: l_required fnd_descr_flex_col_usage_vl.required_flag%TYPE;

3062: l_enabled fnd_descr_flex_col_usage_vl.enabled_flag%TYPE;
3063: l_displayed fnd_descr_flex_col_usage_vl.display_flag%TYPE;
3064: l_default_type fnd_descr_flex_col_usage_vl.default_type%TYPE;
3065: l_default_value fnd_descr_flex_col_usage_vl.default_value%TYPE;
3066: l_required fnd_descr_flex_col_usage_vl.required_flag%TYPE;
3067: l_security_enabled fnd_descr_flex_col_usage_vl.security_enabled_flag%TYPE;
3068: l_display_size fnd_descr_flex_col_usage_vl.display_size%TYPE;
3069: l_description_size
3070: fnd_descr_flex_col_usage_vl.maximum_description_len%TYPE;

Line 3067: l_security_enabled fnd_descr_flex_col_usage_vl.security_enabled_flag%TYPE;

3063: l_displayed fnd_descr_flex_col_usage_vl.display_flag%TYPE;
3064: l_default_type fnd_descr_flex_col_usage_vl.default_type%TYPE;
3065: l_default_value fnd_descr_flex_col_usage_vl.default_value%TYPE;
3066: l_required fnd_descr_flex_col_usage_vl.required_flag%TYPE;
3067: l_security_enabled fnd_descr_flex_col_usage_vl.security_enabled_flag%TYPE;
3068: l_display_size fnd_descr_flex_col_usage_vl.display_size%TYPE;
3069: l_description_size
3070: fnd_descr_flex_col_usage_vl.maximum_description_len%TYPE;
3071: l_concat_desc_size

Line 3068: l_display_size fnd_descr_flex_col_usage_vl.display_size%TYPE;

3064: l_default_type fnd_descr_flex_col_usage_vl.default_type%TYPE;
3065: l_default_value fnd_descr_flex_col_usage_vl.default_value%TYPE;
3066: l_required fnd_descr_flex_col_usage_vl.required_flag%TYPE;
3067: l_security_enabled fnd_descr_flex_col_usage_vl.security_enabled_flag%TYPE;
3068: l_display_size fnd_descr_flex_col_usage_vl.display_size%TYPE;
3069: l_description_size
3070: fnd_descr_flex_col_usage_vl.maximum_description_len%TYPE;
3071: l_concat_desc_size
3072: fnd_descr_flex_col_usage_vl.concatenation_description_len%TYPE;

Line 3070: fnd_descr_flex_col_usage_vl.maximum_description_len%TYPE;

3066: l_required fnd_descr_flex_col_usage_vl.required_flag%TYPE;
3067: l_security_enabled fnd_descr_flex_col_usage_vl.security_enabled_flag%TYPE;
3068: l_display_size fnd_descr_flex_col_usage_vl.display_size%TYPE;
3069: l_description_size
3070: fnd_descr_flex_col_usage_vl.maximum_description_len%TYPE;
3071: l_concat_desc_size
3072: fnd_descr_flex_col_usage_vl.concatenation_description_len%TYPE;
3073: l_lov_prompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;
3074: l_window_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;

Line 3072: fnd_descr_flex_col_usage_vl.concatenation_description_len%TYPE;

3068: l_display_size fnd_descr_flex_col_usage_vl.display_size%TYPE;
3069: l_description_size
3070: fnd_descr_flex_col_usage_vl.maximum_description_len%TYPE;
3071: l_concat_desc_size
3072: fnd_descr_flex_col_usage_vl.concatenation_description_len%TYPE;
3073: l_lov_prompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;
3074: l_window_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
3075: l_range fnd_descr_flex_col_usage_vl.range_code%TYPE;
3076: l_srw_parameter fnd_descr_flex_col_usage_vl.srw_param%TYPE;

Line 3073: l_lov_prompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;

3069: l_description_size
3070: fnd_descr_flex_col_usage_vl.maximum_description_len%TYPE;
3071: l_concat_desc_size
3072: fnd_descr_flex_col_usage_vl.concatenation_description_len%TYPE;
3073: l_lov_prompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;
3074: l_window_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
3075: l_range fnd_descr_flex_col_usage_vl.range_code%TYPE;
3076: l_srw_parameter fnd_descr_flex_col_usage_vl.srw_param%TYPE;
3077: l_runtime_property_function

Line 3074: l_window_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;

3070: fnd_descr_flex_col_usage_vl.maximum_description_len%TYPE;
3071: l_concat_desc_size
3072: fnd_descr_flex_col_usage_vl.concatenation_description_len%TYPE;
3073: l_lov_prompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;
3074: l_window_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
3075: l_range fnd_descr_flex_col_usage_vl.range_code%TYPE;
3076: l_srw_parameter fnd_descr_flex_col_usage_vl.srw_param%TYPE;
3077: l_runtime_property_function
3078: fnd_descr_flex_col_usage_vl.runtime_property_function%TYPE;

Line 3075: l_range fnd_descr_flex_col_usage_vl.range_code%TYPE;

3071: l_concat_desc_size
3072: fnd_descr_flex_col_usage_vl.concatenation_description_len%TYPE;
3073: l_lov_prompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;
3074: l_window_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
3075: l_range fnd_descr_flex_col_usage_vl.range_code%TYPE;
3076: l_srw_parameter fnd_descr_flex_col_usage_vl.srw_param%TYPE;
3077: l_runtime_property_function
3078: fnd_descr_flex_col_usage_vl.runtime_property_function%TYPE;
3079: l_flex_value_set_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;

Line 3076: l_srw_parameter fnd_descr_flex_col_usage_vl.srw_param%TYPE;

3072: fnd_descr_flex_col_usage_vl.concatenation_description_len%TYPE;
3073: l_lov_prompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;
3074: l_window_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
3075: l_range fnd_descr_flex_col_usage_vl.range_code%TYPE;
3076: l_srw_parameter fnd_descr_flex_col_usage_vl.srw_param%TYPE;
3077: l_runtime_property_function
3078: fnd_descr_flex_col_usage_vl.runtime_property_function%TYPE;
3079: l_flex_value_set_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
3080: dummy VARCHAR2(100);

Line 3078: fnd_descr_flex_col_usage_vl.runtime_property_function%TYPE;

3074: l_window_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
3075: l_range fnd_descr_flex_col_usage_vl.range_code%TYPE;
3076: l_srw_parameter fnd_descr_flex_col_usage_vl.srw_param%TYPE;
3077: l_runtime_property_function
3078: fnd_descr_flex_col_usage_vl.runtime_property_function%TYPE;
3079: l_flex_value_set_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
3080: dummy VARCHAR2(100);
3081: l_segment_name fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;
3082: l_column_name

Line 3079: l_flex_value_set_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;

3075: l_range fnd_descr_flex_col_usage_vl.range_code%TYPE;
3076: l_srw_parameter fnd_descr_flex_col_usage_vl.srw_param%TYPE;
3077: l_runtime_property_function
3078: fnd_descr_flex_col_usage_vl.runtime_property_function%TYPE;
3079: l_flex_value_set_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
3080: dummy VARCHAR2(100);
3081: l_segment_name fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;
3082: l_column_name
3083: fnd_descr_flex_col_usage_vl.application_column_name%TYPE;

Line 3081: l_segment_name fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;

3077: l_runtime_property_function
3078: fnd_descr_flex_col_usage_vl.runtime_property_function%TYPE;
3079: l_flex_value_set_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
3080: dummy VARCHAR2(100);
3081: l_segment_name fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;
3082: l_column_name
3083: fnd_descr_flex_col_usage_vl.application_column_name%TYPE;
3084: l_column_type fnd_columns.column_type%TYPE;
3085: l_column_width fnd_columns.width%TYPE;

Line 3083: fnd_descr_flex_col_usage_vl.application_column_name%TYPE;

3079: l_flex_value_set_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
3080: dummy VARCHAR2(100);
3081: l_segment_name fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;
3082: l_column_name
3083: fnd_descr_flex_col_usage_vl.application_column_name%TYPE;
3084: l_column_type fnd_columns.column_type%TYPE;
3085: l_column_width fnd_columns.width%TYPE;
3086: l_table_name fnd_descriptive_flexs.application_table_name%TYPE;
3087:

Line 3088: l_last_update_login fnd_descr_flex_col_usage_vl.last_update_login%TYPE

3084: l_column_type fnd_columns.column_type%TYPE;
3085: l_column_width fnd_columns.width%TYPE;
3086: l_table_name fnd_descriptive_flexs.application_table_name%TYPE;
3087:
3088: l_last_update_login fnd_descr_flex_col_usage_vl.last_update_login%TYPE
3089: := last_update_login_f;
3090: l_last_update_date fnd_descr_flex_col_usage_vl.last_update_date%TYPE
3091: := last_update_date_f;
3092: l_last_updated_by fnd_descr_flex_col_usage_vl.last_updated_by%TYPE

Line 3090: l_last_update_date fnd_descr_flex_col_usage_vl.last_update_date%TYPE

3086: l_table_name fnd_descriptive_flexs.application_table_name%TYPE;
3087:
3088: l_last_update_login fnd_descr_flex_col_usage_vl.last_update_login%TYPE
3089: := last_update_login_f;
3090: l_last_update_date fnd_descr_flex_col_usage_vl.last_update_date%TYPE
3091: := last_update_date_f;
3092: l_last_updated_by fnd_descr_flex_col_usage_vl.last_updated_by%TYPE
3093: := last_updated_by_f;
3094: BEGIN

Line 3092: l_last_updated_by fnd_descr_flex_col_usage_vl.last_updated_by%TYPE

3088: l_last_update_login fnd_descr_flex_col_usage_vl.last_update_login%TYPE
3089: := last_update_login_f;
3090: l_last_update_date fnd_descr_flex_col_usage_vl.last_update_date%TYPE
3091: := last_update_date_f;
3092: l_last_updated_by fnd_descr_flex_col_usage_vl.last_updated_by%TYPE
3093: := last_updated_by_f;
3094: BEGIN
3095: message_init;
3096: l_application_id := application_id_f(p_appl_short_name);

Line 3123: FROM fnd_descr_flex_col_usage_vl

3119: l_lov_prompt, l_window_prompt, l_range, l_srw_parameter,
3120: l_runtime_property_function,
3121: l_column_name,
3122: l_segment_name
3123: FROM fnd_descr_flex_col_usage_vl
3124: WHERE application_id = l_application_id
3125: AND descriptive_flexfield_name = p_flexfield_name
3126: AND descriptive_flex_context_code = p_context_code
3127: AND (((p_column_name IS NOT NULL) AND