APPS.FND_FLEX_DIAGNOSE dependencies on FND_FLEX_VALIDATION_RULE_STATS

Line 4021: FROM fnd_flex_validation_rule_stats

4017: END;
4018:
4019: BEGIN
4020: DELETE
4021: FROM fnd_flex_validation_rule_stats
4022: WHERE application_id = p_kff_str.application_id
4023: AND id_flex_code = p_kff_str.id_flex_code
4024: AND id_flex_num = p_kff_str.id_flex_num;
4025: EXCEPTION

Line 4028: 'Unable to delete from FND_FLEX_VALIDATION_RULE_STATS. ' ||

4024: AND id_flex_num = p_kff_str.id_flex_num;
4025: EXCEPTION
4026: WHEN OTHERS THEN
4027: x_message :=
4028: 'Unable to delete from FND_FLEX_VALIDATION_RULE_STATS. ' ||
4029: Sqlerrm;
4030: GOTO return_error;
4031: END;
4032:

Line 4036: INTO fnd_flex_validation_rule_stats

4032:
4033: IF (l_l_count > 0) THEN
4034: BEGIN
4035: INSERT
4036: INTO fnd_flex_validation_rule_stats
4037: (application_id,
4038: id_flex_code,
4039: id_flex_num,
4040: creation_date, created_by,

Line 4053: 'Unable to insert into FND_FLEX_VALIDATION_RULE_STATS. ' ||

4049: 0, 0, 0);
4050: EXCEPTION
4051: WHEN OTHERS THEN
4052: x_message :=
4053: 'Unable to insert into FND_FLEX_VALIDATION_RULE_STATS. ' ||
4054: Sqlerrm;
4055: GOTO return_error;
4056: END;
4057: END IF;

Line 4121: UPDATE fnd_flex_validation_rule_stats fvrs SET

4117: GOTO return_error;
4118: END IF;
4119:
4120: BEGIN
4121: UPDATE fnd_flex_validation_rule_stats fvrs SET
4122: last_update_date = Sysdate,
4123: last_updated_by = 1,
4124: rule_count = l_r_count,
4125: include_line_count = l_i_count,

Line 4132: x_message := 'Unable to update FND_FLEX_VALIDATION_RULE_STATS. ' ||

4128: AND id_flex_code = p_kff_str.id_flex_code
4129: AND id_flex_num = p_kff_str.id_flex_num;
4130: EXCEPTION
4131: WHEN OTHERS THEN
4132: x_message := 'Unable to update FND_FLEX_VALIDATION_RULE_STATS. ' ||
4133: Sqlerrm;
4134: GOTO return_error;
4135: END;
4136: