APPS.FND_FLEX_DIAGNOSE dependencies on FND_FLEX_VALUE_RULE_LINES

Line 22: SUBTYPE vst_scl_type IS fnd_flex_value_rule_lines%ROWTYPE;

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;
26: SUBTYPE vst_fvn_type IS fnd_flex_value_norm_hierarchy%ROWTYPE;

Line 308: FROM fnd_flex_value_rule_lines

304: IS
305: BEGIN
306: SELECT *
307: INTO x_vst_scl
308: FROM fnd_flex_value_rule_lines
309: WHERE flex_value_set_id = p_vst_scr.flex_value_set_id
310: AND flex_value_rule_id = p_vst_scr.flex_value_rule_id
311: AND include_exclude_indicator = p_include_exclude_indicator
312: AND Nvl(flex_value_low, '$FLEX$.NULL') =

Line 319: x_message := msg_uts('FND_FLEX_VALUE_RULE_LINES',

315: Nvl(p_flex_value_high, '$FLEX$.NULL');
316: RETURN(TRUE);
317: EXCEPTION
318: WHEN OTHERS THEN
319: x_message := msg_uts('FND_FLEX_VALUE_RULE_LINES',
320: 'flex_value_set_id', p_vst_scr.flex_value_set_id,
321: 'flex_value_rule_id', p_vst_scr.flex_value_rule_id,
322: 'include_exclude_indicator', p_include_exclude_indicator,
323: 'flex_value_low', p_flex_value_low,

Line 1234: FROM fnd_flex_value_rule_lines

1230: Nvl(parent_flex_value_low,'') || '/' ||
1231: Nvl(flex_value_low, '') || '/' ||
1232: Nvl(flex_value_high, '')
1233: INTO l_return
1234: FROM fnd_flex_value_rule_lines
1235: WHERE flex_value_set_id = p_flex_value_set_id
1236: AND flex_value_rule_id = p_flex_value_rule_id
1237: AND include_exclude_indicator = p_include_exclude_indicator
1238: AND Nvl(flex_value_low, '$FLEX$.NULL') =

Line 2015: FROM fnd_flex_value_rule_lines fvrl

2011: -- Security lines without rules.
2012: --
2013: BEGIN
2014: DELETE
2015: FROM fnd_flex_value_rule_lines fvrl
2016: WHERE flex_value_set_id = p_flex_value_set_id
2017: AND flex_value_rule_id = p_flex_value_rule_id
2018: AND include_exclude_indicator = p_include_exclude_indicator
2019: AND flex_value_low = p_flex_value_low

Line 2031: 'Unable to delete from FND_FLEX_VALUE_RULE_LINES. ' || Sqlerrm;

2027: GOTO return_success;
2028: EXCEPTION
2029: WHEN OTHERS THEN
2030: x_message :=
2031: 'Unable to delete from FND_FLEX_VALUE_RULE_LINES. ' || Sqlerrm;
2032: GOTO return_error;
2033: END;
2034: END IF;
2035:

Line 2066: FROM fnd_flex_value_rule_lines fvrl

2062: IF (NOT lookup_code_exists('INCLUDE_EXCLUDE',
2063: l_vst_scl.include_exclude_indicator)) THEN
2064: BEGIN
2065: DELETE
2066: FROM fnd_flex_value_rule_lines fvrl
2067: WHERE flex_value_set_id = l_vst_scl.flex_value_set_id
2068: AND flex_value_rule_id = l_vst_scl.flex_value_rule_id
2069: AND include_exclude_indicator=l_vst_scl.include_exclude_indicator
2070: AND flex_value_low = l_vst_scl.flex_value_low