DBA Data[Home] [Help]

APPS.FND_FLEX_DSC_API dependencies on FND_API

Line 1637: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

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

Line 1638: p_sequence_number IN NUMBER DEFAULT fnd_api.g_miss_num,

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,

Line 1639: p_enabled 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,

Line 1640: p_displayed 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,

Line 1642: p_value_set 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,

Line 1643: p_default_type 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

Line 1644: p_default_value 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
1648: p_display_size IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 1645: p_required 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,
1649: p_description_size IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 1646: p_security_enabled IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

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,

Line 1648: p_display_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,

Line 1649: p_description_size IN NUMBER DEFAULT fnd_api.g_miss_num,

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,

Line 1650: p_concat_desc_size IN NUMBER DEFAULT fnd_api.g_miss_num,

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,

Line 1651: p_lov_prompt 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)

Line 1652: p_window_prompt 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

Line 1653: p_range IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

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;

Line 1654: p_srw_parameter IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

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;

Line 1655: p_runtime_property_function IN VARCHAR2 DEFAULT fnd_api.g_miss_char)

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;

Line 1725: IF (p_description = fnd_api.g_miss_char) THEN

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;

Line 1731: IF (p_sequence_number = fnd_api.g_miss_num) THEN

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;

Line 1737: IF (p_enabled = fnd_api.g_miss_char) THEN

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;

Line 1744: IF (p_displayed = fnd_api.g_miss_char) THEN

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;

Line 1751: IF (p_value_set = fnd_api.g_miss_char) THEN

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

Line 1843: IF (p_default_type = fnd_api.g_miss_char OR p_default_type is NULL) THEN

1839: END;
1840: END IF;
1841:
1842: -- Bug 13457601 Added "OR p_default_type is NULL"
1843: IF (p_default_type = fnd_api.g_miss_char OR p_default_type is NULL) THEN
1844: NULL;
1845: ELSE
1846: fnd_flex_types.validate_default_type(p_default_type);
1847: l_default_type := p_default_type;

Line 1850: IF (p_default_value = fnd_api.g_miss_char) THEN

1846: fnd_flex_types.validate_default_type(p_default_type);
1847: l_default_type := p_default_type;
1848: END IF;
1849:
1850: IF (p_default_value = fnd_api.g_miss_char) THEN
1851: NULL;
1852: ELSE
1853: l_default_value := p_default_value;
1854: END IF;

Line 1856: IF (p_required = fnd_api.g_miss_char) THEN

1852: ELSE
1853: l_default_value := p_default_value;
1854: END IF;
1855:
1856: IF (p_required = fnd_api.g_miss_char) THEN
1857: NULL;
1858: ELSE
1859: fnd_flex_types.validate_yes_no_flag(p_required);
1860: l_required := p_required;

Line 1863: IF (p_security_enabled = fnd_api.g_miss_char) THEN

1859: fnd_flex_types.validate_yes_no_flag(p_required);
1860: l_required := p_required;
1861: END IF;
1862:
1863: IF (p_security_enabled = fnd_api.g_miss_char) THEN
1864: NULL;
1865: ELSE
1866: fnd_flex_types.validate_yes_no_flag(p_security_enabled);
1867: l_security_enabled := p_security_enabled;

Line 1870: IF (p_display_size = fnd_api.g_miss_num) THEN

1866: fnd_flex_types.validate_yes_no_flag(p_security_enabled);
1867: l_security_enabled := p_security_enabled;
1868: END IF;
1869:
1870: IF (p_display_size = fnd_api.g_miss_num) THEN
1871: NULL;
1872: ELSE
1873: l_display_size := p_display_size;
1874: END IF;

Line 1876: IF (p_description_size = fnd_api.g_miss_num) THEN

1872: ELSE
1873: l_display_size := p_display_size;
1874: END IF;
1875:
1876: IF (p_description_size = fnd_api.g_miss_num) THEN
1877: NULL;
1878: ELSE
1879: l_description_size := p_description_size;
1880: END IF;

Line 1882: IF (p_concat_desc_size = fnd_api.g_miss_num) THEN

1878: ELSE
1879: l_description_size := p_description_size;
1880: END IF;
1881:
1882: IF (p_concat_desc_size = fnd_api.g_miss_num) THEN
1883: NULL;
1884: ELSE
1885: l_concat_desc_size := p_concat_desc_size;
1886: END IF;

Line 1888: IF (p_lov_prompt = fnd_api.g_miss_char) THEN

1884: ELSE
1885: l_concat_desc_size := p_concat_desc_size;
1886: END IF;
1887:
1888: IF (p_lov_prompt = fnd_api.g_miss_char) THEN
1889: NULL;
1890: ELSE
1891: l_lov_prompt := p_lov_prompt;
1892: END IF;

Line 1894: IF (p_window_prompt = fnd_api.g_miss_char) THEN

1890: ELSE
1891: l_lov_prompt := p_lov_prompt;
1892: END IF;
1893:
1894: IF (p_window_prompt = fnd_api.g_miss_char) THEN
1895: NULL;
1896: ELSE
1897: l_window_prompt := p_window_prompt;
1898: END IF;

Line 1900: IF (p_runtime_property_function = fnd_api.g_miss_char) THEN

1896: ELSE
1897: l_window_prompt := p_window_prompt;
1898: END IF;
1899:
1900: IF (p_runtime_property_function = fnd_api.g_miss_char) THEN
1901: NULL;
1902: ELSE
1903: l_runtime_property_function := p_runtime_property_function;
1904: END IF;

Line 1906: IF (p_range = fnd_api.g_miss_char) THEN

1902: ELSE
1903: l_runtime_property_function := p_runtime_property_function;
1904: END IF;
1905:
1906: IF (p_range = fnd_api.g_miss_char) THEN
1907: NULL;
1908: ELSE
1909: BEGIN
1910: IF (p_range IS NOT NULL) THEN

Line 3134: l_default_type := fnd_api.g_miss_char;

3130: (end_user_column_name = p_segment_name)));
3131:
3132: -- Set the the default_type and defaul_value to be NULL bug8586864
3133:
3134: l_default_type := fnd_api.g_miss_char;
3135: l_default_value := fnd_api.g_miss_char;
3136:
3137: fnd_descr_flex_col_usage_pkg.update_row
3138: (x_application_id => l_application_id,

Line 3135: l_default_value := fnd_api.g_miss_char;

3131:
3132: -- Set the the default_type and defaul_value to be NULL bug8586864
3133:
3134: l_default_type := fnd_api.g_miss_char;
3135: l_default_value := fnd_api.g_miss_char;
3136:
3137: fnd_descr_flex_col_usage_pkg.update_row
3138: (x_application_id => l_application_id,
3139: x_descriptive_flexfield_name => p_flexfield_name,