APPS.FND_FLEX_DIAGNOSE dependencies on FND_FLEX_INCLUDE_RULE_LINES

Line 42: SUBTYPE kff_cvi_type IS fnd_flex_include_rule_lines%ROWTYPE;

38: SUBTYPE kff_sgq_type IS fnd_value_attribute_types%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: -- ***************************************************************************

Line 709: FROM fnd_flex_include_rule_lines

705: IS
706: BEGIN
707: SELECT *
708: INTO x_kff_cvi
709: FROM fnd_flex_include_rule_lines
710: WHERE application_id = p_kff_cvr.application_id
711: AND id_flex_code = p_kff_cvr.id_flex_code
712: AND id_flex_num = p_kff_cvr.id_flex_num
713: AND flex_validation_rule_name = p_kff_cvr.flex_validation_rule_name

Line 718: x_message := msg_uts('FND_FLEX_INCLUDE_RULE_LINES',

714: AND rule_line_id = p_rule_line_id;
715: RETURN(TRUE);
716: EXCEPTION
717: WHEN OTHERS THEN
718: x_message := msg_uts('FND_FLEX_INCLUDE_RULE_LINES',
719: 'application_id', p_kff_cvr.application_id,
720: 'id_flex_code', p_kff_cvr.id_flex_code,
721: 'id_flex_num', p_kff_cvr.id_flex_num,
722: 'flex_validation_rule_name', p_kff_cvr.flex_validation_rule_name,

Line 3993: FROM fnd_flex_include_rule_lines

3989: END;
3990:
3991: BEGIN
3992: DELETE
3993: FROM fnd_flex_include_rule_lines
3994: WHERE application_id = p_kff_str.application_id
3995: AND id_flex_code = p_kff_str.id_flex_code
3996: AND id_flex_num = p_kff_str.id_flex_num;
3997: EXCEPTION

Line 4000: 'Unable to delete from FND_FLEX_INCLUDE_RULE_LINES. ' ||

3996: AND id_flex_num = p_kff_str.id_flex_num;
3997: EXCEPTION
3998: WHEN OTHERS THEN
3999: x_message :=
4000: 'Unable to delete from FND_FLEX_INCLUDE_RULE_LINES. ' ||
4001: Sqlerrm;
4002: GOTO return_error;
4003: END;
4004:

Line 4089: FROM fnd_flex_include_rule_lines

4085:
4086: BEGIN
4087: SELECT COUNT(*)
4088: INTO l_i_count
4089: FROM fnd_flex_include_rule_lines
4090: WHERE application_id = p_kff_str.application_id
4091: AND id_flex_code = p_kff_str.id_flex_code
4092: AND id_flex_num = p_kff_str.id_flex_num;
4093: EXCEPTION

Line 4096: 'Unable to count FND_FLEX_INCLUDE_RULE_LINES. ' || Sqlerrm;

4092: AND id_flex_num = p_kff_str.id_flex_num;
4093: EXCEPTION
4094: WHEN OTHERS THEN
4095: x_message :=
4096: 'Unable to count FND_FLEX_INCLUDE_RULE_LINES. ' || Sqlerrm;
4097: GOTO return_error;
4098: END;
4099:
4100: BEGIN

Line 5194: DELETE FROM fnd_flex_include_rule_lines firl

5190: --
5191: -- Include Lines without actual Line.
5192: --
5193: BEGIN
5194: DELETE FROM fnd_flex_include_rule_lines firl
5195: WHERE application_id = p_application_id
5196: AND id_flex_code = p_id_flex_code
5197: AND id_flex_num = p_id_flex_num
5198: AND flex_validation_rule_name = p_flex_validation_rule_name

Line 5211: 'Unable to delete from FND_FLEX_INCLUDE_RULE_LINES. ' ||

5207: GOTO return_success;
5208: EXCEPTION
5209: WHEN OTHERS THEN
5210: x_message :=
5211: 'Unable to delete from FND_FLEX_INCLUDE_RULE_LINES. ' ||
5212: Sqlerrm;
5213: GOTO return_error;
5214: END;
5215: END IF;