APPS.FND_FLEX_DIAGNOSE dependencies on FND_FLEX_VALUE_HIERARCHIES

Line 27: SUBTYPE vst_fvh_type IS fnd_flex_value_hierarchies%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;
31: SUBTYPE dff_seg_type IS fnd_descr_flex_column_usages%ROWTYPE;

Line 1389: FROM fnd_flex_value_hierarchies

1385: SELECT parent_flex_value || '/' ||
1386: child_flex_value_low || '/' ||
1387: child_flex_value_high
1388: INTO l_return
1389: FROM fnd_flex_value_hierarchies
1390: WHERE flex_value_set_id = p_flex_value_set_id
1391: AND parent_flex_value = p_parent_flex_value
1392: AND child_flex_value_low = p_child_flex_value_low
1393: AND child_flex_value_high = p_child_flex_value_high;

Line 2400: FROM fnd_flex_value_hierarchies fvh

2396: -- Denorm Hierarchy without norm hierarchy.
2397: --
2398: BEGIN
2399: DELETE
2400: FROM fnd_flex_value_hierarchies fvh
2401: WHERE flex_value_set_id = p_flex_value_set_id
2402: AND parent_flex_value = p_parent_flex_value
2403: AND child_flex_value_low = p_child_flex_value_low
2404: AND child_flex_value_high = p_child_flex_value_high

Line 2415: 'Unable to delete from FND_FLEX_VALUE_HIERARCHIES. ' ||

2411: GOTO return_success;
2412: EXCEPTION
2413: WHEN OTHERS THEN
2414: x_message :=
2415: 'Unable to delete from FND_FLEX_VALUE_HIERARCHIES. ' ||
2416: Sqlerrm;
2417: GOTO return_error;
2418: END;
2419: END IF;