eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_FLEX_DIAGNOSE dependencies on FND_FLEX_VALUE_RULE_USAGES

Line 23: SUBTYPE vst_scu_type IS fnd_flex_value_rule_usages%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;
27: SUBTYPE vst_fvh_type IS fnd_flex_value_hierarchies%ROWTYPE;

Line 338: FROM fnd_flex_value_rule_usages

334: IS
335: BEGIN
336: SELECT *
337: INTO x_vst_scu
338: FROM fnd_flex_value_rule_usages
339: WHERE flex_value_set_id = p_vst_scr.flex_value_set_id
340: AND flex_value_rule_id = p_vst_scr.flex_value_rule_id
341: AND application_id = p_application_id
342: AND responsibility_id = p_responsibility_id;

Line 346: x_message := msg_uts('FND_FLEX_VALUE_RULE_USAGES',

342: AND responsibility_id = p_responsibility_id;
343: RETURN(TRUE);
344: EXCEPTION
345: WHEN OTHERS THEN
346: x_message := msg_uts('FND_FLEX_VALUE_RULE_USAGES',
347: 'flex_value_set_id', p_vst_scr.flex_value_set_id,
348: 'flex_value_rule_id', p_vst_scr.flex_value_rule_id,
349: 'application_id', p_application_id,
350: 'responsibility_id', p_responsibility_id);

Line 1269: FROM fnd_flex_value_rule_usages

1265: SELECT To_char(flex_value_rule_id) || '/' ||
1266: To_char(application_id) || '/' ||
1267: To_char(responsibility_id)
1268: INTO l_return
1269: FROM fnd_flex_value_rule_usages
1270: WHERE flex_value_set_id = p_flex_value_set_id
1271: AND flex_value_rule_id = p_flex_value_rule_id
1272: AND application_id = p_application_id
1273: AND responsibility_id = p_responsibility_id;

Line 2109: FROM fnd_flex_value_rule_usages fvru

2105: -- Security usage without rule.
2106: --
2107: BEGIN
2108: DELETE
2109: FROM fnd_flex_value_rule_usages fvru
2110: WHERE flex_value_set_id = p_flex_value_set_id
2111: AND flex_value_rule_id = p_flex_value_rule_id
2112: AND application_id = p_application_id
2113: AND responsibility_id = p_responsibility_id

Line 2124: 'Unable to delete from FND_FLEX_VALUE_RULE_USAGES. ' || Sqlerrm;

2120: GOTO return_success;
2121: EXCEPTION
2122: WHEN OTHERS THEN
2123: x_message :=
2124: 'Unable to delete from FND_FLEX_VALUE_RULE_USAGES. ' || Sqlerrm;
2125: GOTO return_error;
2126: END;
2127: END IF;
2128:

Line 2156: FROM fnd_flex_value_rule_usages fvru

2152: -- Security usage with invalid application id.
2153: --
2154: BEGIN
2155: DELETE
2156: FROM fnd_flex_value_rule_usages fvru
2157: WHERE flex_value_set_id = l_vst_scu.flex_value_set_id
2158: AND flex_value_rule_id = l_vst_scu.flex_value_rule_id
2159: AND application_id = l_vst_scu.application_id
2160: AND responsibility_id = l_vst_scu.responsibility_id

Line 2170: 'Unable to delete from FND_FLEX_VALUE_RULE_USAGES. ' || Sqlerrm;

2166: GOTO return_success;
2167: EXCEPTION
2168: WHEN OTHERS THEN
2169: x_message :=
2170: 'Unable to delete from FND_FLEX_VALUE_RULE_USAGES. ' || Sqlerrm;
2171: GOTO return_error;
2172: END;
2173: END IF;
2174:

Line 2181: FROM fnd_flex_value_rule_usages fvru

2177: -- Security usage with invalid responsibility id.
2178: --
2179: BEGIN
2180: DELETE
2181: FROM fnd_flex_value_rule_usages fvru
2182: WHERE flex_value_set_id = l_vst_scu.flex_value_set_id
2183: AND flex_value_rule_id = l_vst_scu.flex_value_rule_id
2184: AND application_id = l_vst_scu.application_id
2185: AND responsibility_id = l_vst_scu.responsibility_id

Line 2196: 'Unable to delete from FND_FLEX_VALUE_RULE_USAGES. ' || Sqlerrm;

2192: GOTO return_success;
2193: EXCEPTION
2194: WHEN OTHERS THEN
2195: x_message :=
2196: 'Unable to delete from FND_FLEX_VALUE_RULE_USAGES. ' || Sqlerrm;
2197: GOTO return_error;
2198: END;
2199: END IF;
2200: