1633: p_context_code IN VARCHAR2,
1634: p_segment_name IN VARCHAR2 DEFAULT NULL,
1635: p_column_name IN VARCHAR2 DEFAULT NULL,
1636: -- Data
1637: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1638: p_sequence_number IN NUMBER DEFAULT fnd_api.g_miss_num,
1639: p_enabled IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1640: p_displayed IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1641: -- Validation
1634: p_segment_name IN VARCHAR2 DEFAULT NULL,
1635: p_column_name IN VARCHAR2 DEFAULT NULL,
1636: -- Data
1637: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1638: p_sequence_number IN NUMBER DEFAULT fnd_api.g_miss_num,
1639: p_enabled IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1640: p_displayed IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1641: -- Validation
1642: p_value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1635: p_column_name IN VARCHAR2 DEFAULT NULL,
1636: -- Data
1637: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1638: p_sequence_number IN NUMBER DEFAULT fnd_api.g_miss_num,
1639: p_enabled IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1640: p_displayed IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1641: -- Validation
1642: p_value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1643: p_default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1636: -- Data
1637: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1638: p_sequence_number IN NUMBER DEFAULT fnd_api.g_miss_num,
1639: p_enabled IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1640: p_displayed IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1641: -- Validation
1642: p_value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1643: p_default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1644: p_default_value IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1638: p_sequence_number IN NUMBER DEFAULT fnd_api.g_miss_num,
1639: p_enabled IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1640: p_displayed IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1641: -- Validation
1642: p_value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1643: p_default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1644: p_default_value IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1645: p_required IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1646: p_security_enabled IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1639: p_enabled IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1640: p_displayed IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1641: -- Validation
1642: p_value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1643: p_default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1644: p_default_value IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1645: p_required IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1646: p_security_enabled IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1647: -- Sizes
1640: p_displayed IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1641: -- Validation
1642: p_value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1643: p_default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1644: p_default_value IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1645: p_required IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1646: p_security_enabled IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1647: -- Sizes
1648: p_display_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1641: -- Validation
1642: p_value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1643: p_default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1644: p_default_value IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1645: p_required IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1646: p_security_enabled IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1647: -- Sizes
1648: p_display_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1649: p_description_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1642: p_value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1643: p_default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1644: p_default_value IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1645: p_required IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1646: p_security_enabled IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1647: -- Sizes
1648: p_display_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1649: p_description_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1650: p_concat_desc_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1644: p_default_value IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1645: p_required IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1646: p_security_enabled IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1647: -- Sizes
1648: p_display_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1649: p_description_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1650: p_concat_desc_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1651: p_lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1652: p_window_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1645: p_required IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1646: p_security_enabled IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1647: -- Sizes
1648: p_display_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1649: p_description_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1650: p_concat_desc_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1651: p_lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1652: p_window_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1653: p_range IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1646: p_security_enabled IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1647: -- Sizes
1648: p_display_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1649: p_description_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1650: p_concat_desc_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1651: p_lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1652: p_window_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1653: p_range IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1654: p_srw_parameter IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1647: -- Sizes
1648: p_display_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1649: p_description_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1650: p_concat_desc_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1651: p_lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1652: p_window_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
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)
1648: p_display_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1649: p_description_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1650: p_concat_desc_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1651: p_lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1652: p_window_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
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
1649: p_description_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1650: p_concat_desc_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1651: p_lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1652: p_window_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
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;
1650: p_concat_desc_size IN NUMBER DEFAULT fnd_api.g_miss_num,
1651: p_lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1652: p_window_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
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;
1651: p_lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1652: p_window_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
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;
1721: (application_column_name = p_column_name)) OR
1722: ((p_segment_name IS NOT NULL) AND
1723: (end_user_column_name = p_segment_name)));
1724:
1725: IF (p_description = fnd_api.g_miss_char) THEN
1726: NULL;
1727: ELSE
1728: l_description := p_description;
1729: END IF;
1727: ELSE
1728: l_description := p_description;
1729: END IF;
1730:
1731: IF (p_sequence_number = fnd_api.g_miss_num) THEN
1732: NULL;
1733: ELSE
1734: l_sequence_number := p_sequence_number;
1735: END IF;
1733: ELSE
1734: l_sequence_number := p_sequence_number;
1735: END IF;
1736:
1737: IF (p_enabled = fnd_api.g_miss_char) THEN
1738: NULL;
1739: ELSE
1740: fnd_flex_types.validate_yes_no_flag(p_enabled);
1741: l_enabled := p_enabled;
1740: fnd_flex_types.validate_yes_no_flag(p_enabled);
1741: l_enabled := p_enabled;
1742: END IF;
1743:
1744: IF (p_displayed = fnd_api.g_miss_char) THEN
1745: NULL;
1746: ELSE
1747: fnd_flex_types.validate_yes_no_flag(p_displayed);
1748: l_displayed := p_displayed;
1747: fnd_flex_types.validate_yes_no_flag(p_displayed);
1748: l_displayed := p_displayed;
1749: END IF;
1750:
1751: IF (p_value_set = fnd_api.g_miss_char) THEN
1752: NULL;
1753: ELSE
1754: value_set_id_f(p_value_set,
1755: l_flex_value_set_id);
1838: RAISE bad_parameter;
1839: END;
1840: END IF;
1841:
1842: IF (p_default_type = fnd_api.g_miss_char) THEN
1843: NULL;
1844: ELSE
1845: fnd_flex_types.validate_default_type(p_default_type);
1846: l_default_type := p_default_type;
1845: fnd_flex_types.validate_default_type(p_default_type);
1846: l_default_type := p_default_type;
1847: END IF;
1848:
1849: IF (p_default_value = fnd_api.g_miss_char) THEN
1850: NULL;
1851: ELSE
1852: l_default_value := p_default_value;
1853: END IF;
1851: ELSE
1852: l_default_value := p_default_value;
1853: END IF;
1854:
1855: IF (p_required = fnd_api.g_miss_char) THEN
1856: NULL;
1857: ELSE
1858: fnd_flex_types.validate_yes_no_flag(p_required);
1859: l_required := p_required;
1858: fnd_flex_types.validate_yes_no_flag(p_required);
1859: l_required := p_required;
1860: END IF;
1861:
1862: IF (p_security_enabled = fnd_api.g_miss_char) THEN
1863: NULL;
1864: ELSE
1865: fnd_flex_types.validate_yes_no_flag(p_security_enabled);
1866: l_security_enabled := p_security_enabled;
1865: fnd_flex_types.validate_yes_no_flag(p_security_enabled);
1866: l_security_enabled := p_security_enabled;
1867: END IF;
1868:
1869: IF (p_display_size = fnd_api.g_miss_num) THEN
1870: NULL;
1871: ELSE
1872: l_display_size := p_display_size;
1873: END IF;
1871: ELSE
1872: l_display_size := p_display_size;
1873: END IF;
1874:
1875: IF (p_description_size = fnd_api.g_miss_num) THEN
1876: NULL;
1877: ELSE
1878: l_description_size := p_description_size;
1879: END IF;
1877: ELSE
1878: l_description_size := p_description_size;
1879: END IF;
1880:
1881: IF (p_concat_desc_size = fnd_api.g_miss_num) THEN
1882: NULL;
1883: ELSE
1884: l_concat_desc_size := p_concat_desc_size;
1885: END IF;
1883: ELSE
1884: l_concat_desc_size := p_concat_desc_size;
1885: END IF;
1886:
1887: IF (p_lov_prompt = fnd_api.g_miss_char) THEN
1888: NULL;
1889: ELSE
1890: l_lov_prompt := p_lov_prompt;
1891: END IF;
1889: ELSE
1890: l_lov_prompt := p_lov_prompt;
1891: END IF;
1892:
1893: IF (p_window_prompt = fnd_api.g_miss_char) THEN
1894: NULL;
1895: ELSE
1896: l_window_prompt := p_window_prompt;
1897: END IF;
1895: ELSE
1896: l_window_prompt := p_window_prompt;
1897: END IF;
1898:
1899: IF (p_runtime_property_function = fnd_api.g_miss_char) THEN
1900: NULL;
1901: ELSE
1902: l_runtime_property_function := p_runtime_property_function;
1903: END IF;
1901: ELSE
1902: l_runtime_property_function := p_runtime_property_function;
1903: END IF;
1904:
1905: IF (p_range = fnd_api.g_miss_char) THEN
1906: NULL;
1907: ELSE
1908: BEGIN
1909: IF (p_range IS NOT NULL) THEN