APPS.GL_CHART_OF_ACCOUNTS_API_PKG dependencies on FND_FLEX_VALUE_SETS

Line 384: FROM FND_FLEX_VALUE_SETS

380: uppercase_only_flag,
381: numeric_mode_enabled_flag,
382: minimum_value,
383: maximum_value
384: FROM FND_FLEX_VALUE_SETS
385: WHERE flex_value_set_id = v_flex_value_set_id;
386:
387: -- Validate the application_column_name
388: CURSOR c_check_column_name IS

Line 922: -- (FND_FLEX_VALUE_SETS table)

918:
919: --
920: -- Procedure
921: -- validate_value_set
922: -- (FND_FLEX_VALUE_SETS table)
923: -- Purpose
924: -- Do the validation for one particular value set
925: -- History
926: -- 10.09.2000 O Monnier Created.

Line 985: UPDATE FND_FLEX_VALUE_SETS

981: RAISE invalid_dependant_value;
982: END IF;
983:
984: IF (v_dependant_default_value <> v_storage_value) THEN
985: UPDATE FND_FLEX_VALUE_SETS
986: SET dependant_default_value = v_storage_value
987: WHERE flex_value_set_id = v_flex_value_set_id;
988: END IF;
989: END IF;

Line 1010: UPDATE FND_FLEX_VALUE_SETS

1006: v_is_minimum_value_valid := FALSE;
1007: END IF;
1008:
1009: IF (v_minimum_value <> v_storage_value) THEN
1010: UPDATE FND_FLEX_VALUE_SETS
1011: SET minimum_value = v_storage_value
1012: WHERE flex_value_set_id = v_flex_value_set_id;
1013: END IF;
1014: END IF;

Line 1035: UPDATE FND_FLEX_VALUE_SETS

1031: v_is_maximum_value_valid := FALSE;
1032: END IF;
1033:
1034: IF (v_maximum_value <> v_storage_value) THEN
1035: UPDATE FND_FLEX_VALUE_SETS
1036: SET maximum_value = v_storage_value
1037: WHERE flex_value_set_id = v_flex_value_set_id;
1038: END IF;
1039: END IF;

Line 1391: FROM FND_FLEX_VALUE_SETS

1387: uppercase_only_flag,
1388: numeric_mode_enabled_flag,
1389: minimum_value,
1390: maximum_value
1391: FROM FND_FLEX_VALUE_SETS
1392: WHERE flex_value_set_id = v_flex_value_set_id;
1393:
1394: -- Retrieve the value attribute type information required for the validation.
1395: CURSOR c_value_attribute_type IS

Line 1652: FROM FND_FLEX_VALUE_SETS vs,

1648: vs.uppercase_only_flag,
1649: vs.numeric_mode_enabled_flag,
1650: vs.minimum_value,
1651: vs.maximum_value
1652: FROM FND_FLEX_VALUE_SETS vs,
1653: FND_FLEX_VALUES v
1654: WHERE v.flex_value_id = v_flex_value_id
1655: AND v.flex_value_set_id = vs.flex_value_set_id;
1656:

Line 1924: FND_FLEX_VALUE_SETS fv

1920: --
1921: SELECT NVL((sum(fv.maximum_size) + count(fs.application_column_name) - 1),0)
1922: INTO v_count
1923: FROM FND_ID_FLEX_SEGMENTS fs,
1924: FND_FLEX_VALUE_SETS fv
1925: WHERE fs.application_id = v_application_id
1926: AND fs.id_flex_code = v_id_flex_code
1927: AND fs.id_flex_num = v_id_flex_num
1928: AND fv.flex_value_set_id (+) = fs.flex_value_set_id;

Line 2475: from fnd_flex_value_sets

2471:
2472: -- In case we need the value set name
2473: cursor vset_name_cursor is
2474: select flex_value_set_name
2475: from fnd_flex_value_sets
2476: where flex_value_set_id = p_flex_value_set_id;
2477: vset_name varchar2(100);
2478:
2479: BEGIN