APPS.FND_FLEX_HIERARCHY_COMPILER dependencies on FND_FLEX_VALUE_SETS

Line 80: SUBTYPE vset_type IS fnd_flex_value_sets%ROWTYPE;

76: --
77: g_parent_path_values varchar2_array;
78: g_parent_path_value_count NUMBER;
79:
80: SUBTYPE vset_type IS fnd_flex_value_sets%ROWTYPE;
81: g_vset vset_type;
82: g_user_id NUMBER := -1;
83: g_insert_count NUMBER := 0;
84: g_commit_size NUMBER := 500;

Line 403: FROM fnd_flex_value_sets

399: --
400: SELECT /* $Header: AFFFCHYB.pls 120.4 2011/11/08 19:05:50 hgeorgi ship $ */
401: *
402: INTO x_vset
403: FROM fnd_flex_value_sets
404: WHERE flex_value_set_id = To_number(p_flex_value_set);
405:
406: RETURN;
407:

Line 417: FROM fnd_flex_value_sets

413: BEGIN
414: SELECT /* $Header: AFFFCHYB.pls 120.4 2011/11/08 19:05:50 hgeorgi ship $ */
415: *
416: INTO x_vset
417: FROM fnd_flex_value_sets
418: WHERE flex_value_set_name = p_flex_value_set;
419:
420: RETURN;
421:

Line 428: 'No data found in FND_FLEX_VALUE_SETS',

424: --
425: -- NAME didn't work too.
426: --
427: raise_exception_error(error_no_value_set,
428: 'No data found in FND_FLEX_VALUE_SETS',
429: 'for flex value set ' || p_flex_value_set);
430: END;
431: END get_vset;
432:

Line 1501: ' FROM fnd_flex_value_sets v ' ||

1497:
1498: l_value_set_id_sql :=
1499: ('SELECT /* Header: AFFFSV2B.pls 120.2.12000000.1 2007/01/18 13:18:43 appldev ship $ */ ' ||
1500: ' v.flex_value_set_id ' ||
1501: ' FROM fnd_flex_value_sets v ' ||
1502: ' WHERE EXISTS ' ||
1503: ' (SELECT null ' ||
1504: ' FROM fnd_flex_value_norm_hierarchy h ' ||
1505: ' WHERE h.flex_value_set_id = v.flex_value_set_id)');