DBA Data[Home] [Help]

APPS.FND_FLEX_LOADER_APIS dependencies on FND_FLEX_VALIDATION_RULES

Line 97: SUBTYPE kff_cvr_type IS fnd_flex_validation_rules%ROWTYPE;

93: SUBTYPE kff_str_type IS fnd_id_flex_structures%ROWTYPE;
94: SUBTYPE kff_str_tl_type IS fnd_id_flex_structures_tl%ROWTYPE;
95: SUBTYPE kff_wfp_type IS fnd_flex_workflow_processes%ROWTYPE;
96: SUBTYPE kff_sha_type IS fnd_shorthand_flex_aliases%ROWTYPE;
97: SUBTYPE kff_cvr_type IS fnd_flex_validation_rules%ROWTYPE;
98: SUBTYPE kff_cvr_tl_type IS fnd_flex_vdation_rules_tl%ROWTYPE;
99: SUBTYPE kff_cvl_type IS fnd_flex_validation_rule_lines%ROWTYPE;
100: SUBTYPE kff_seg_type IS fnd_id_flex_segments%ROWTYPE;
101: SUBTYPE kff_seg_tl_type IS fnd_id_flex_segments_tl%ROWTYPE;

Line 2669: FROM fnd_flex_validation_rules

2665: BEGIN
2666: l_func_name := g_api_name || 'get_kff_cvr(F)';
2667: SELECT *
2668: INTO x_kff_cvr
2669: FROM fnd_flex_validation_rules
2670: WHERE application_id = p_kff_str.application_id
2671: AND id_flex_code = p_kff_str.id_flex_code
2672: AND id_flex_num = p_kff_str.id_flex_num
2673: AND flex_validation_rule_name = p_flex_validation_rule_name;

Line 7668: UPDATE fnd_flex_validation_rules

7664: WHERE application_id = p_application_id
7665: AND id_flex_code = p_id_flex_code
7666: AND id_flex_num = p_id_flex_num_old;
7667:
7668: UPDATE fnd_flex_validation_rules
7669: SET id_flex_num = p_id_flex_num_new
7670: WHERE application_id = p_application_id
7671: AND id_flex_code = p_id_flex_code
7672: AND id_flex_num = p_id_flex_num_old;

Line 9350: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VALIDATION_RULES_T1');

9346: l_vc2 VARCHAR2(32000);
9347: BEGIN
9348: l_func_name := g_api_name || 'check_cvr_triggers()';
9349: l_vc2 := NULL;
9350: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VALIDATION_RULES_T1');
9351: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VALIDATION_RULES_T2');
9352: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VALIDATION_RULES_T3');
9353: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VAL_RULE_LINES_T1');
9354: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VAL_RULE_LINES_T2');

Line 9351: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VALIDATION_RULES_T2');

9347: BEGIN
9348: l_func_name := g_api_name || 'check_cvr_triggers()';
9349: l_vc2 := NULL;
9350: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VALIDATION_RULES_T1');
9351: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VALIDATION_RULES_T2');
9352: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VALIDATION_RULES_T3');
9353: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VAL_RULE_LINES_T1');
9354: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VAL_RULE_LINES_T2');
9355: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VAL_RULE_LINES_T3');

Line 9352: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VALIDATION_RULES_T3');

9348: l_func_name := g_api_name || 'check_cvr_triggers()';
9349: l_vc2 := NULL;
9350: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VALIDATION_RULES_T1');
9351: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VALIDATION_RULES_T2');
9352: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VALIDATION_RULES_T3');
9353: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VAL_RULE_LINES_T1');
9354: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VAL_RULE_LINES_T2');
9355: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VAL_RULE_LINES_T3');
9356: l_vc2 := l_vc2 || check_cvr_trigger('FND_FLEX_VAL_RULE_LINES_T4');