[Home] [Help]
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;
102: SUBTYPE kff_fqa_type IS fnd_segment_attribute_values%ROWTYPE;
103:
2754: BEGIN
2755: l_func_name := g_api_name || 'get_kff_cvl(F)';
2756: SELECT *
2757: INTO x_kff_cvl
2758: FROM fnd_flex_validation_rule_lines
2759: WHERE application_id = p_kff_cvr.application_id
2760: AND id_flex_code = p_kff_cvr.id_flex_code
2761: AND id_flex_num = p_kff_cvr.id_flex_num
2762: AND flex_validation_rule_name = p_kff_cvr.flex_validation_rule_name
7652: WHERE application_id = p_application_id
7653: AND id_flex_code = p_id_flex_code
7654: AND id_flex_num = p_id_flex_num_old;
7655:
7656: UPDATE fnd_flex_validation_rule_lines
7657: SET id_flex_num = p_id_flex_num_new
7658: WHERE application_id = p_application_id
7659: AND id_flex_code = p_id_flex_code
7660: AND id_flex_num = p_id_flex_num_old;
9637: --
9638: IF (g_debug_on) THEN
9639: debug(l_func_name, 'Translating KFF_CVR_LINE.(non-MLS)');
9640: END IF;
9641: UPDATE fnd_flex_validation_rule_lines SET
9642: last_updated_by = l_file_who.last_updated_by,
9643: last_update_date = l_file_who.last_update_date,
9644: last_update_login = l_file_who.last_update_login,
9645: description = Nvl(p_description, description)
9686:
9687: IF (g_debug_on) THEN
9688: debug(l_func_name, 'Updating KFF_CVR_LINE.(non-MLS)');
9689: END IF;
9690: UPDATE fnd_flex_validation_rule_lines SET
9691: last_updated_by = l_file_who.last_updated_by,
9692: last_update_date = l_file_who.last_update_date,
9693: last_update_login = l_file_who.last_update_login,
9694: enabled_flag = p_enabled_flag,
9707: END IF;
9708: --
9709: -- rule_line_id is populated by fnd_flex_val_rule_lines_t1 trigger.
9710: --
9711: INSERT INTO fnd_flex_validation_rule_lines
9712: (
9713: application_id,
9714: id_flex_code,
9715: id_flex_num,