APPS.FND_FLEX_DIAGNOSE dependencies on FND_FLEX_VALUE_RULES

Line 21: SUBTYPE vst_scr_type IS fnd_flex_value_rules%ROWTYPE;

17:
18: SUBTYPE vst_set_type IS fnd_flex_value_sets%ROWTYPE;
19: SUBTYPE vst_tbl_type IS fnd_flex_validation_tables%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;

Line 285: FROM fnd_flex_value_rules

281: IS
282: BEGIN
283: SELECT *
284: INTO x_vst_scr
285: FROM fnd_flex_value_rules
286: WHERE flex_value_set_id = p_vst_set.flex_value_set_id
287: AND flex_value_rule_id = p_flex_value_rule_id;
288: RETURN(TRUE);
289: EXCEPTION

Line 291: x_message := msg_uts('FND_FLEX_VALUE_RULES',

287: AND flex_value_rule_id = p_flex_value_rule_id;
288: RETURN(TRUE);
289: EXCEPTION
290: WHEN OTHERS THEN
291: x_message := msg_uts('FND_FLEX_VALUE_RULES',
292: 'flex_value_set_id', p_vst_set.flex_value_set_id,
293: 'flex_value_rule_id', p_flex_value_rule_id);
294: RETURN(FALSE);
295: END fetch_vst_scr;

Line 1206: FROM fnd_flex_value_rules_vl

1202: flex_value_rule_name || '/' ||
1203: Nvl(parent_flex_value_low,'') || '/' ||
1204: error_message
1205: INTO l_return
1206: FROM fnd_flex_value_rules_vl
1207: WHERE flex_value_set_id = p_flex_value_set_id
1208: AND flex_value_rule_id = p_flex_value_rule_id;
1209: RETURN(line_return(l_return));
1210: EXCEPTION

Line 1971: FROM fnd_flex_value_rules fvr

1967: -- Security rules without set.
1968: --
1969: BEGIN
1970: DELETE
1971: FROM fnd_flex_value_rules fvr
1972: WHERE flex_value_set_id = p_flex_value_set_id
1973: AND flex_value_rule_id = p_flex_value_rule_id
1974: AND NOT EXISTS
1975: (SELECT null

Line 1983: 'Unable to delete from FND_FLEX_VALUE_RULES. ' || Sqlerrm;

1979: GOTO return_success;
1980: EXCEPTION
1981: WHEN OTHERS THEN
1982: x_message :=
1983: 'Unable to delete from FND_FLEX_VALUE_RULES. ' || Sqlerrm;
1984: GOTO return_error;
1985: END;
1986: END IF;
1987:

Line 2023: FROM fnd_flex_value_rules fvr

2019: AND flex_value_low = p_flex_value_low
2020: AND flex_value_high = p_flex_value_high
2021: AND NOT EXISTS
2022: (SELECT null
2023: FROM fnd_flex_value_rules fvr
2024: WHERE fvr.flex_value_set_id = fvrl.flex_value_set_id
2025: AND fvr.flex_value_rule_id = fvrl.flex_value_rule_id);
2026: x_message := SQL%rowcount || ' row(s) deleted.';
2027: GOTO return_success;

Line 2077: 'Unable to delete from FND_FLEX_VALUE_RULES. ' || Sqlerrm;

2073: GOTO return_success;
2074: EXCEPTION
2075: WHEN OTHERS THEN
2076: x_message :=
2077: 'Unable to delete from FND_FLEX_VALUE_RULES. ' || Sqlerrm;
2078: GOTO return_error;
2079: END;
2080: END IF;
2081: END IF;

Line 2116: FROM fnd_flex_value_rules fvr

2112: AND application_id = p_application_id
2113: AND responsibility_id = p_responsibility_id
2114: AND NOT EXISTS
2115: (SELECT null
2116: FROM fnd_flex_value_rules fvr
2117: WHERE fvr.flex_value_set_id = fvru.flex_value_set_id
2118: AND fvr.flex_value_rule_id = fvru.flex_value_rule_id);
2119: x_message := SQL%rowcount || ' row(s) deleted.';
2120: GOTO return_success;