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_VALIDATION_RULE_LINES

Line 41: SUBTYPE kff_cvl_type IS fnd_flex_validation_rule_lines%ROWTYPE;

37: SUBTYPE kff_qlv_type IS fnd_segment_attribute_values%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:

Line 682: FROM fnd_flex_validation_rule_lines

678: IS
679: BEGIN
680: SELECT *
681: INTO x_kff_cvl
682: FROM fnd_flex_validation_rule_lines
683: WHERE application_id = p_kff_cvr.application_id
684: AND id_flex_code = p_kff_cvr.id_flex_code
685: AND id_flex_num = p_kff_cvr.id_flex_num
686: AND flex_validation_rule_name = p_kff_cvr.flex_validation_rule_name

Line 691: x_message := msg_uts('FND_FLEX_VALIDATION_RULE_LINES',

687: AND rule_line_id = p_rule_line_id;
688: RETURN(TRUE);
689: EXCEPTION
690: WHEN OTHERS THEN
691: x_message := msg_uts('FND_FLEX_VALIDATION_RULE_LINES',
692: 'application_id', p_kff_cvr.application_id,
693: 'id_flex_code', p_kff_cvr.id_flex_code,
694: 'id_flex_num', p_kff_cvr.id_flex_num,
695: 'flex_validation_rule_name', p_kff_cvr.flex_validation_rule_name,

Line 3626: FROM fnd_flex_validation_rule_lines

3622: include_exclude_indicator || '/' ||
3623: concatenated_segments_low || '/' ||
3624: concatenated_segments_high
3625: INTO l_return
3626: FROM fnd_flex_validation_rule_lines
3627: WHERE application_id = p_application_id
3628: AND id_flex_code = p_id_flex_code
3629: AND id_flex_num = p_id_flex_num
3630: AND flex_validation_rule_name = p_flex_validation_rule_name

Line 3955: FROM fnd_flex_validation_rule_lines

3951: l_e_count NUMBER;
3952:
3953: CURSOR kff_cvl_cur(p_kff_str kff_str_type) IS
3954: SELECT *
3955: FROM fnd_flex_validation_rule_lines
3956: WHERE application_id = p_kff_str.application_id
3957: AND id_flex_code = p_kff_str.id_flex_code
3958: AND id_flex_num = p_kff_str.id_flex_num
3959: ORDER BY flex_validation_rule_name;

Line 3980: FROM fnd_flex_validation_rule_lines

3976:
3977: BEGIN
3978: SELECT COUNT(*)
3979: INTO l_l_count
3980: FROM fnd_flex_validation_rule_lines
3981: WHERE application_id = p_kff_str.application_id
3982: AND id_flex_code = p_kff_str.id_flex_code
3983: AND id_flex_num = p_kff_str.id_flex_num;
3984: EXCEPTION

Line 3987: 'Unable to count FND_FLEX_VALIDATION_RULE_LINES. ' || Sqlerrm;

3983: AND id_flex_num = p_kff_str.id_flex_num;
3984: EXCEPTION
3985: WHEN OTHERS THEN
3986: x_message :=
3987: 'Unable to count FND_FLEX_VALIDATION_RULE_LINES. ' || Sqlerrm;
3988: GOTO return_error;
3989: END;
3990:
3991: BEGIN

Line 5020: FROM fnd_flex_validation_rule_lines

5016: -- Rules without lines.
5017: --
5018: SELECT COUNT(*)
5019: INTO l_count
5020: FROM fnd_flex_validation_rule_lines
5021: WHERE application_id = l_kff_cvr.application_id
5022: AND id_flex_code = l_kff_cvr.id_flex_code
5023: AND id_flex_num = l_kff_cvr.id_flex_num
5024: AND flex_validation_rule_name = l_kff_cvr.flex_validation_rule_name;

Line 5086: FROM fnd_flex_validation_rule_lines fvrl

5082: -- Lines without Rule.
5083: --
5084: BEGIN
5085: DELETE
5086: FROM fnd_flex_validation_rule_lines fvrl
5087: WHERE application_id = p_application_id
5088: AND id_flex_code = p_id_flex_code
5089: AND id_flex_num = p_id_flex_num
5090: AND flex_validation_rule_name = p_flex_validation_rule_name

Line 5104: 'Unable to delete from FND_FLEX_VALIDATION_RULE_LINES. ' ||

5100: GOTO return_success;
5101: EXCEPTION
5102: WHEN OTHERS THEN
5103: x_message :=
5104: 'Unable to delete from FND_FLEX_VALIDATION_RULE_LINES. ' ||
5105: Sqlerrm;
5106: GOTO return_error;
5107: END;
5108: END IF;

Line 5169: UPDATE fnd_flex_validation_rule_lines SET

5165: l_kff_cvl.include_exclude_indicator := 'I';
5166: END IF;
5167:
5168: BEGIN
5169: UPDATE fnd_flex_validation_rule_lines SET
5170: enabled_flag = l_kff_cvl.enabled_flag,
5171: include_exclude_indicator = l_kff_cvl.include_exclude_indicator,
5172: last_update_date = Sysdate,
5173: last_updated_by = 1

Line 5184: 'Unable to update FND_FLEX_VALIDATION_RULE_LINES. ' || Sqlerrm;

5180: GOTO return_success;
5181: EXCEPTION
5182: WHEN OTHERS THEN
5183: x_message :=
5184: 'Unable to update FND_FLEX_VALIDATION_RULE_LINES. ' || Sqlerrm;
5185: GOTO return_error;
5186: END;
5187: END IF;
5188:

Line 5202: FROM fnd_flex_validation_rule_lines fvrl

5198: AND flex_validation_rule_name = p_flex_validation_rule_name
5199: AND rule_line_id = p_rule_line_id
5200: AND NOT EXISTS
5201: (SELECT null
5202: FROM fnd_flex_validation_rule_lines fvrl
5203: WHERE firl.rule_line_id = fvrl.rule_line_id
5204: AND firl.enabled_flag = fvrl.enabled_flag
5205: AND fvrl.include_exclude_indicator = 'I');
5206: x_message := SQL%rowcount || ' row(s) deleted.';

Line 5230: FROM fnd_flex_validation_rule_lines fvrl

5226: AND flex_validation_rule_name = p_flex_validation_rule_name
5227: AND rule_line_id = p_rule_line_id
5228: AND NOT EXISTS
5229: (SELECT null
5230: FROM fnd_flex_validation_rule_lines fvrl
5231: WHERE ferl.rule_line_id = fvrl.rule_line_id
5232: AND ferl.enabled_flag = fvrl.enabled_flag
5233: AND fvrl.include_exclude_indicator = 'E');
5234: x_message := SQL%rowcount || ' row(s) deleted.';