APPS.FND_VSET dependencies on FND_FLEX_VALUES

Line 6: enabled IN fnd_flex_values.enabled_flag%TYPE)

2: /* $Header: AFFFVDUB.pls 120.3.12010000.1 2008/07/25 14:14:50 appldev ship $ */
3:
4:
5: CURSOR value_c(valueset IN valueset_r,
6: enabled IN fnd_flex_values.enabled_flag%TYPE)
7: RETURN value_dr
8: IS
9: SELECT /* $Header: AFFFVDUB.pls 120.3.12010000.1 2008/07/25 14:14:50 appldev ship $ */
10: flex_value,

Line 14: FROM fnd_flex_values_vl

10: flex_value,
11: flex_value, description,
12: start_date_active, end_date_active,
13: parent_flex_value_low
14: FROM fnd_flex_values_vl
15: WHERE flex_value_set_id = valueset.vsid
16: AND enabled_flag = enabled
17: ORDER BY 1;
18:

Line 21: enabled IN fnd_flex_values.enabled_flag%TYPE)

17: ORDER BY 1;
18:
19:
20: CURSOR value_d(valueset IN valueset_r,
21: enabled IN fnd_flex_values.enabled_flag%TYPE)
22: RETURN value_dr
23: IS
24: SELECT /* $Header: AFFFVDUB.pls 120.3.12010000.1 2008/07/25 14:14:50 appldev ship $ */
25: flex_value,

Line 29: FROM fnd_flex_values_vl

25: flex_value,
26: flex_value_meaning, description,
27: start_date_active, end_date_active,
28: parent_flex_value_low
29: FROM fnd_flex_values_vl
30: WHERE flex_value_set_id = valueset.vsid
31: AND enabled_flag = enabled
32: ORDER BY 1;
33:

Line 97: PROCEDURE get_valueset(valueset_id IN fnd_flex_values.flex_value_set_id%TYPE,

93: RETURN rv;
94: END;
95:
96:
97: PROCEDURE get_valueset(valueset_id IN fnd_flex_values.flex_value_set_id%TYPE,
98: valueset OUT nocopy valueset_r,
99: format OUT nocopy valueset_dr)
100: IS
101: vset valueset_r;

Line 335: test(103473); /* fnd_flex_values */

331:
332: PROCEDURE test_table IS
333: BEGIN
334: -- test(103473); /* applications */
335: test(103473); /* fnd_flex_values */
336: END;
337:
338: BEGIN
339: debug_mode := FALSE;