APPS.FND_FLEX_VAL_API dependencies on FND_FLEX_VALUE_SETS_S

Line 606: VALUES(fnd_flex_value_sets_s.nextval,

602:
603: dependant_default_value,/* note spelling */
604: dependant_default_meaning,/* note spelling */
605: parent_flex_value_set_id)
606: VALUES(fnd_flex_value_sets_s.nextval,
607: value_set_name,
608: validation_type,
609: security_enabled_flag,
610: longlist_flag,

Line 635: fnd_flex_value_sets_s.CURRVAL INTO rv

631: println('created value set (type ' || validation_type || ') '
632: || value_set_name);
633:
634: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
635: fnd_flex_value_sets_s.CURRVAL INTO rv
636: FROM dual;
637: RETURN rv;
638: EXCEPTION
639: when dup_val_on_index THEN

Line 1603: fnd_flex_value_sets SET

1599:
1600: /* rename the new value set, and change the id */
1601: BEGIN
1602: UPDATE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1603: fnd_flex_value_sets SET
1604: flex_value_set_id = old_value_set_id,
1605: flex_value_set_name = old_value_set
1606: WHERE flex_value_set_id = new_value_set_id;
1607: END;

Line 1628: fnd_flex_value_sets SET

1624: WHEN no_data_found THEN NULL;
1625: END;
1626: BEGIN
1627: UPDATE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1628: fnd_flex_value_sets SET
1629: parent_flex_value_set_id = old_value_set_id
1630: WHERE parent_flex_value_set_id = new_value_set_id;
1631: EXCEPTION
1632: WHEN no_data_found THEN NULL;

Line 1752: fnd_flex_value_sets SET

1748:
1749: BEGIN
1750: IF(customer_mode) THEN
1751: UPDATE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1752: fnd_flex_value_sets SET
1753: maximum_size = valueset_r.maximum_size,
1754: number_precision = valueset_r.number_precision,
1755: last_update_date = last_update_date_i,
1756: last_updated_by = last_updated_by_i,

Line 1761: fnd_flex_value_sets SET

1757: last_update_login = last_update_login_i
1758: WHERE flex_value_set_id = valueset_r.flex_value_set_id;
1759: ELSE
1760: UPDATE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1761: fnd_flex_value_sets SET
1762: maximum_size = valueset_r.maximum_size,
1763: number_precision = valueset_r.number_precision
1764: WHERE flex_value_set_id = valueset_r.flex_value_set_id;
1765: END IF;