APPS.FND_FLEX_DIAGNOSE dependencies on FND_FLEX_VALUES

Line 25: SUBTYPE vst_val_type IS fnd_flex_values%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:
29: SUBTYPE dff_flx_type IS fnd_descriptive_flexs%ROWTYPE;

Line 384: FROM fnd_flex_values

380: IS
381: BEGIN
382: SELECT *
383: INTO x_vst_val
384: FROM fnd_flex_values
385: WHERE flex_value_set_id = p_vst_set.flex_value_set_id
386: AND flex_value_id = p_flex_value_id;
387: RETURN(TRUE);
388: EXCEPTION

Line 390: x_message := msg_uts('FND_FLEX_VALUES',

386: AND flex_value_id = p_flex_value_id;
387: RETURN(TRUE);
388: EXCEPTION
389: WHEN OTHERS THEN
390: x_message := msg_uts('FND_FLEX_VALUES',
391: 'flex_value_set_id', p_vst_set.flex_value_set_id,
392: 'flex_value_id', p_flex_value_id);
393: RETURN(FALSE);
394: END fetch_vst_val;

Line 1302: FROM fnd_flex_values_vl

1298: enabled_flag || '/' ||
1299: flex_value_meaning || '/' ||
1300: Nvl(description, '')
1301: INTO l_return
1302: FROM fnd_flex_values_vl
1303: WHERE flex_value_set_id = p_flex_value_set_id
1304: AND flex_value_id = p_flex_value_id;
1305: RETURN(line_return(l_return));
1306: EXCEPTION

Line 2224: FROM fnd_flex_values fv

2220: -- Values without set.
2221: --
2222: BEGIN
2223: DELETE
2224: FROM fnd_flex_values fv
2225: WHERE flex_value_set_id = p_flex_value_set_id
2226: AND flex_value_id = p_flex_value_id
2227: AND NOT EXISTS
2228: (SELECT null

Line 2236: 'Unable to delete from FND_FLEX_VALUES. ' || Sqlerrm;

2232: GOTO return_success;
2233: EXCEPTION
2234: WHEN OTHERS THEN
2235: x_message :=
2236: 'Unable to delete from FND_FLEX_VALUES. ' || Sqlerrm;
2237: GOTO return_error;
2238: END;
2239: END IF;
2240:

Line 2275: UPDATE fnd_flex_values fv SET

2271: l_vst_val.summary_flag := 'N';
2272: END IF;
2273:
2274: BEGIN
2275: UPDATE fnd_flex_values fv SET
2276: start_date_active = l_vst_val.start_date_active,
2277: end_date_active = l_vst_val.end_date_active,
2278: enabled_flag = l_vst_val.enabled_flag,
2279: summary_flag = l_vst_val.summary_flag,

Line 2288: x_message := 'Unable to update FND_FLEX_VALUES. ' || Sqlerrm;

2284: x_message := SQL%rowcount || ' row(s) updated.';
2285: GOTO return_success;
2286: EXCEPTION
2287: WHEN OTHERS THEN
2288: x_message := 'Unable to update FND_FLEX_VALUES. ' || Sqlerrm;
2289: GOTO return_error;
2290: END;
2291: END IF;
2292:

Line 2363: FROM fnd_flex_values fv

2359: AND child_flex_value_low = p_child_flex_value_low
2360: AND child_flex_value_high = p_child_flex_value_high
2361: AND NOT EXISTS
2362: (SELECT null
2363: FROM fnd_flex_values fv
2364: WHERE fv.flex_value_set_id = fvnh.flex_value_set_id
2365: AND fv.flex_value = fvnh.parent_flex_value);
2366: x_message := SQL%rowcount || ' row(s) deleted.';
2367: GOTO return_success;