APPS.FND_FLEX_DIAGNOSE dependencies on FND_FLEX_EXCLUDE_RULE_LINES

Line 43: SUBTYPE kff_cve_type IS fnd_flex_exclude_rule_lines%ROWTYPE;

39: SUBTYPE kff_sha_type IS fnd_shorthand_flex_aliases%ROWTYPE;
40: SUBTYPE kff_cvr_type IS fnd_flex_validation_rules%ROWTYPE;
41: SUBTYPE kff_cvl_type IS fnd_flex_validation_rule_lines%ROWTYPE;
42: SUBTYPE kff_cvi_type IS fnd_flex_include_rule_lines%ROWTYPE;
43: SUBTYPE kff_cve_type IS fnd_flex_exclude_rule_lines%ROWTYPE;
44: SUBTYPE kff_fwp_type IS fnd_flex_workflow_processes%ROWTYPE;
45:
46: -- ***************************************************************************
47: -- * Helper functions.

Line 736: FROM fnd_flex_exclude_rule_lines

732: IS
733: BEGIN
734: SELECT *
735: INTO x_kff_cve
736: FROM fnd_flex_exclude_rule_lines
737: WHERE application_id = p_kff_cvr.application_id
738: AND id_flex_code = p_kff_cvr.id_flex_code
739: AND id_flex_num = p_kff_cvr.id_flex_num
740: AND flex_validation_rule_name = p_kff_cvr.flex_validation_rule_name

Line 745: x_message := msg_uts('FND_FLEX_EXCLUDE_RULE_LINES',

741: AND rule_line_id = p_rule_line_id;
742: RETURN(TRUE);
743: EXCEPTION
744: WHEN OTHERS THEN
745: x_message := msg_uts('FND_FLEX_EXCLUDE_RULE_LINES',
746: 'application_id', p_kff_cvr.application_id,
747: 'id_flex_code', p_kff_cvr.id_flex_code,
748: 'id_flex_num', p_kff_cvr.id_flex_num,
749: 'flex_validation_rule_name', p_kff_cvr.flex_validation_rule_name,

Line 4007: FROM fnd_flex_exclude_rule_lines

4003: END;
4004:
4005: BEGIN
4006: DELETE
4007: FROM fnd_flex_exclude_rule_lines
4008: WHERE application_id = p_kff_str.application_id
4009: AND id_flex_code = p_kff_str.id_flex_code
4010: AND id_flex_num = p_kff_str.id_flex_num;
4011: EXCEPTION

Line 4014: 'Unable to delete from FND_FLEX_EXCLUDE_RULE_LINES. ' ||

4010: AND id_flex_num = p_kff_str.id_flex_num;
4011: EXCEPTION
4012: WHEN OTHERS THEN
4013: x_message :=
4014: 'Unable to delete from FND_FLEX_EXCLUDE_RULE_LINES. ' ||
4015: Sqlerrm;
4016: GOTO return_error;
4017: END;
4018:

Line 4103: FROM fnd_flex_exclude_rule_lines

4099:
4100: BEGIN
4101: SELECT COUNT(*)
4102: INTO l_e_count
4103: FROM fnd_flex_exclude_rule_lines
4104: WHERE application_id = p_kff_str.application_id
4105: AND id_flex_code = p_kff_str.id_flex_code
4106: AND id_flex_num = p_kff_str.id_flex_num;
4107: EXCEPTION

Line 4110: 'Unable to count FND_FLEX_EXCLUDE_RULE_LINES. ' || Sqlerrm;

4106: AND id_flex_num = p_kff_str.id_flex_num;
4107: EXCEPTION
4108: WHEN OTHERS THEN
4109: x_message :=
4110: 'Unable to count FND_FLEX_EXCLUDE_RULE_LINES. ' || Sqlerrm;
4111: GOTO return_error;
4112: END;
4113:
4114: IF (l_i_count + l_e_count <> l_l_count) THEN

Line 5222: DELETE FROM fnd_flex_exclude_rule_lines ferl

5218: --
5219: -- Exclude Lines without actual Line.
5220: --
5221: BEGIN
5222: DELETE FROM fnd_flex_exclude_rule_lines ferl
5223: WHERE application_id = p_application_id
5224: AND id_flex_code = p_id_flex_code
5225: AND id_flex_num = p_id_flex_num
5226: AND flex_validation_rule_name = p_flex_validation_rule_name

Line 5239: 'Unable to delete from FND_FLEX_EXCLUDE_RULE_LINES. ' ||

5235: GOTO return_success;
5236: EXCEPTION
5237: WHEN OTHERS THEN
5238: x_message :=
5239: 'Unable to delete from FND_FLEX_EXCLUDE_RULE_LINES. ' ||
5240: Sqlerrm;
5241: GOTO return_error;
5242: END;
5243: END IF;