APPS.FND_FLEX_VAL_API dependencies on FND_FLEX_HIERARCHIES

Line 1460: FROM fnd_flex_hierarchies_TL

1456: --
1457: -- Delete Value hierarchies.
1458: --
1459: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1460: FROM fnd_flex_hierarchies_TL
1461: WHERE flex_value_set_id = l_value_set_id;
1462:
1463: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1464: FROM fnd_flex_hierarchies

Line 1464: FROM fnd_flex_hierarchies

1460: FROM fnd_flex_hierarchies_TL
1461: WHERE flex_value_set_id = l_value_set_id;
1462:
1463: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1464: FROM fnd_flex_hierarchies
1465: WHERE flex_value_set_id = l_value_set_id;
1466:
1467: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1468: FROM fnd_flex_value_hierarchies

Line 2734: FROM fnd_flex_hierarchies

2730:
2731: BEGIN
2732: SELECT hierarchy_id
2733: INTO x_hierarchy_id
2734: FROM fnd_flex_hierarchies
2735: WHERE flex_value_set_id = l_vset.flex_value_set_id
2736: AND hierarchy_code = p_hierarchy_code;
2737: EXCEPTION
2738: WHEN OTHERS THEN

Line 2873: l_hierarchy_code fnd_flex_hierarchies.hierarchy_code%TYPE;

2869: 'Structured Hierarchy Level can only be specified for Parent Values.');
2870: END IF;
2871:
2872: DECLARE
2873: l_hierarchy_code fnd_flex_hierarchies.hierarchy_code%TYPE;
2874: BEGIN
2875: SELECT hierarchy_code
2876: INTO l_hierarchy_code
2877: FROM fnd_flex_hierarchies

Line 2877: FROM fnd_flex_hierarchies

2873: l_hierarchy_code fnd_flex_hierarchies.hierarchy_code%TYPE;
2874: BEGIN
2875: SELECT hierarchy_code
2876: INTO l_hierarchy_code
2877: FROM fnd_flex_hierarchies
2878: WHERE flex_value_set_id = p_vset.flex_value_set_id
2879: AND hierarchy_id = p_value.structured_hierarchy_level;
2880: EXCEPTION
2881: WHEN OTHERS THEN