APPS.FND_FLEX_DIAGNOSE dependencies on FND_FLEX_HIERARCHIES

Line 24: SUBTYPE vst_rlg_type IS fnd_flex_hierarchies%ROWTYPE;

20: SUBTYPE vst_evt_type IS fnd_flex_validation_events%ROWTYPE;
21: SUBTYPE vst_scr_type IS fnd_flex_value_rules%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:

Line 363: FROM fnd_flex_hierarchies

359: IS
360: BEGIN
361: SELECT *
362: INTO x_vst_rlg
363: FROM fnd_flex_hierarchies
364: WHERE flex_value_set_id = p_vst_set.flex_value_set_id
365: AND hierarchy_id = p_hierarchy_id;
366: RETURN(TRUE);
367: EXCEPTION

Line 369: x_message := msg_uts('FND_FLEX_HIERARCHIES',

365: AND hierarchy_id = p_hierarchy_id;
366: RETURN(TRUE);
367: EXCEPTION
368: WHEN OTHERS THEN
369: x_message := msg_uts('FND_FLEX_HIERARCHIES',
370: 'flex_value_set_id', p_vst_set.flex_value_set_id,
371: 'hierarchy_id', p_hierarchy_id);
372: RETURN(FALSE);
373: END fetch_vst_rlg;

Line 1326: FROM fnd_flex_hierarchies_vl

1322: SELECT To_char(hierarchy_id) || '/' ||
1323: hierarchy_name || '/' ||
1324: Nvl(description,'')
1325: INTO l_return
1326: FROM fnd_flex_hierarchies_vl
1327: WHERE flex_value_set_id = p_flex_value_set_id
1328: AND hierarchy_id = p_hierarchy_id;
1329: RETURN(line_return(l_return));
1330: EXCEPTION

Line 2314: FROM fnd_flex_hierarchies fh

2310: -- Rollup group without set.
2311: --
2312: BEGIN
2313: DELETE
2314: FROM fnd_flex_hierarchies fh
2315: WHERE flex_value_set_id = p_flex_value_set_id
2316: AND hierarchy_id = p_hierarchy_id
2317: AND NOT EXISTS
2318: (SELECT null

Line 2326: 'Unable to delete from FND_FLEX_HIERARCHIES. ' || Sqlerrm;

2322: GOTO return_success;
2323: EXCEPTION
2324: WHEN OTHERS THEN
2325: x_message :=
2326: 'Unable to delete from FND_FLEX_HIERARCHIES. ' || Sqlerrm;
2327: GOTO return_error;
2328: END;
2329: END IF;
2330: