APPS.FND_FLEX_VAL_API dependencies on FND_FLEX_VALUE_SETS_S

Line 617: VALUES(fnd_flex_value_sets_s.nextval,

613:
614: dependant_default_value,/* note spelling */
615: dependant_default_meaning,/* note spelling */
616: parent_flex_value_set_id)
617: VALUES(fnd_flex_value_sets_s.nextval,
618: value_set_name,
619: validation_type,
620: security_enabled_flag,
621: longlist_flag,

Line 646: fnd_flex_value_sets_s.CURRVAL INTO rv

642: println('created value set (type ' || validation_type || ') '
643: || value_set_name);
644:
645: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
646: fnd_flex_value_sets_s.CURRVAL INTO rv
647: FROM dual;
648: RETURN rv;
649: EXCEPTION
650: when dup_val_on_index THEN

Line 1614: fnd_flex_value_sets SET

1610:
1611: /* rename the new value set, and change the id */
1612: BEGIN
1613: UPDATE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1614: fnd_flex_value_sets SET
1615: flex_value_set_id = old_value_set_id,
1616: flex_value_set_name = old_value_set
1617: WHERE flex_value_set_id = new_value_set_id;
1618: END;

Line 1639: fnd_flex_value_sets SET

1635: WHEN no_data_found THEN NULL;
1636: END;
1637: BEGIN
1638: UPDATE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1639: fnd_flex_value_sets SET
1640: parent_flex_value_set_id = old_value_set_id
1641: WHERE parent_flex_value_set_id = new_value_set_id;
1642: EXCEPTION
1643: WHEN no_data_found THEN NULL;

Line 1763: fnd_flex_value_sets SET

1759:
1760: BEGIN
1761: IF(customer_mode) THEN
1762: UPDATE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1763: fnd_flex_value_sets SET
1764: maximum_size = valueset_r.maximum_size,
1765: number_precision = valueset_r.number_precision,
1766: last_update_date = last_update_date_i,
1767: last_updated_by = last_updated_by_i,

Line 1772: fnd_flex_value_sets SET

1768: last_update_login = last_update_login_i
1769: WHERE flex_value_set_id = valueset_r.flex_value_set_id;
1770: ELSE
1771: UPDATE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1772: fnd_flex_value_sets SET
1773: maximum_size = valueset_r.maximum_size,
1774: number_precision = valueset_r.number_precision
1775: WHERE flex_value_set_id = valueset_r.flex_value_set_id;
1776: END IF;