APPS.FND_FLEX_DIAGNOSE dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

Line 26: SUBTYPE vst_fvn_type IS fnd_flex_value_norm_hierarchy%ROWTYPE;

22: SUBTYPE vst_scl_type IS fnd_flex_value_rule_lines%ROWTYPE;
23: SUBTYPE vst_scu_type IS fnd_flex_value_rule_usages%ROWTYPE;
24: SUBTYPE vst_rlg_type IS fnd_flex_hierarchies%ROWTYPE;
25: SUBTYPE vst_val_type IS fnd_flex_values%ROWTYPE;
26: SUBTYPE vst_fvn_type IS fnd_flex_value_norm_hierarchy%ROWTYPE;
27: SUBTYPE vst_fvh_type IS fnd_flex_value_hierarchies%ROWTYPE;
28:
29: SUBTYPE dff_flx_type IS fnd_descriptive_flexs%ROWTYPE;
30: SUBTYPE dff_ctx_type IS fnd_descr_flex_contexts%ROWTYPE;

Line 1354: FROM fnd_flex_value_norm_hierarchy

1350: range_attribute || '/' ||
1351: child_flex_value_low || '/' ||
1352: child_flex_value_high
1353: INTO l_return
1354: FROM fnd_flex_value_norm_hierarchy
1355: WHERE flex_value_set_id = p_flex_value_set_id
1356: AND parent_flex_value = p_parent_flex_value
1357: AND range_attribute = p_range_attribute
1358: AND child_flex_value_low = p_child_flex_value_low

Line 2355: FROM fnd_flex_value_norm_hierarchy fvnh

2351: -- Norm hierarchy without value.
2352: --
2353: BEGIN
2354: DELETE
2355: FROM fnd_flex_value_norm_hierarchy fvnh
2356: WHERE flex_value_set_id = p_flex_value_set_id
2357: AND parent_flex_value = p_parent_flex_value
2358: AND range_attribute = p_range_attribute
2359: AND child_flex_value_low = p_child_flex_value_low

Line 2371: 'Unable to delete from FND_FLEX_VALUE_NORM_HIERARCHY. ' ||

2367: GOTO return_success;
2368: EXCEPTION
2369: WHEN OTHERS THEN
2370: x_message :=
2371: 'Unable to delete from FND_FLEX_VALUE_NORM_HIERARCHY. ' ||
2372: Sqlerrm;
2373: GOTO return_error;
2374: END;
2375: END IF;

Line 2407: FROM fnd_flex_value_norm_hierarchy fvnh

2403: AND child_flex_value_low = p_child_flex_value_low
2404: AND child_flex_value_high = p_child_flex_value_high
2405: AND NOT EXISTS
2406: (SELECT null
2407: FROM fnd_flex_value_norm_hierarchy fvnh
2408: WHERE fvnh.flex_value_set_id = fvh.flex_value_set_id
2409: AND fvnh.parent_flex_value = fvh.parent_flex_value);
2410: x_message := SQL%rowcount || ' row(s) deleted.';
2411: GOTO return_success;