APPS.GL_CHART_OF_ACCOUNTS_API_PKG dependencies on FND_FLEX_VALUES

Line 1468: UPDATE FND_FLEX_VALUES

1464: RAISE invalid_value;
1465: END IF;
1466:
1467: IF (v_flex_value <> v_storage_value) THEN
1468: UPDATE FND_FLEX_VALUES
1469: SET flex_value = v_storage_value
1470: WHERE flex_value_id = v_flex_value_id;
1471: END IF;
1472:

Line 1653: FND_FLEX_VALUES v

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:
1657: BEGIN

Line 1693: FROM FND_FLEX_VALUES

1689: -- is userenv('LANG').
1690: --
1691: SELECT parent_flex_value_low
1692: INTO v_parent_flex_value_low
1693: FROM FND_FLEX_VALUES
1694: WHERE flex_value_id = v_flex_value_id;
1695:
1696: SELECT count(*)
1697: INTO v_count

Line 1698: FROM FND_FLEX_VALUES_VL

1694: WHERE flex_value_id = v_flex_value_id;
1695:
1696: SELECT count(*)
1697: INTO v_count
1698: FROM FND_FLEX_VALUES_VL
1699: WHERE flex_value_set_id = v_flex_value_set_id
1700: AND flex_value_meaning = v_flex_value_meaning
1701: AND ((v_parent_flex_value_low IS null) OR
1702: (parent_flex_value_low =

Line 1731: UPDATE FND_FLEX_VALUES_TL

1727: RAISE invalid_value_meaning;
1728: END IF;
1729:
1730: IF (v_flex_value_meaning <> v_storage_value) THEN
1731: UPDATE FND_FLEX_VALUES_TL
1732: SET flex_value_meaning = v_storage_value
1733: WHERE flex_value_id = v_flex_value_id
1734: AND language = v_language;
1735: END IF;

Line 2397: from fnd_flex_values

2393:
2394: --is the p_parent a parent value?
2395: cursor parent_value_cursor is
2396: select 'x'
2397: from fnd_flex_values
2398: where flex_value_set_id = p_value_set_id
2399: and flex_value = p_parent
2400: and summary_flag = 'Y';
2401:

Line 2405: FROM fnd_flex_values

2401:
2402: --find all flex values in a given range
2403: cursor child_values_cursor is
2404: SELECT flex_value
2405: FROM fnd_flex_values
2406: WHERE flex_value_set_id = p_value_set_id
2407: AND flex_value BETWEEN p_child_low AND p_child_high
2408: ORDER by flex_value;
2409: