DBA Data[Home] [Help]

APPS.FND_FLEX_LOADER_APIS dependencies on FND_FLEX_VALIDATION_RULE_LINES

Line 99: SUBTYPE kff_cvl_type IS fnd_flex_validation_rule_lines%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;
102: SUBTYPE kff_fqa_type IS fnd_segment_attribute_values%ROWTYPE;
103:

Line 2758: FROM fnd_flex_validation_rule_lines

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

Line 7662: UPDATE fnd_flex_validation_rule_lines

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;
7661:
7662: UPDATE fnd_flex_validation_rule_lines
7663: SET id_flex_num = p_id_flex_num_new
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;

Line 9647: UPDATE fnd_flex_validation_rule_lines SET

9643: --
9644: IF (g_debug_on) THEN
9645: debug(l_func_name, 'Translating KFF_CVR_LINE.(non-MLS)');
9646: END IF;
9647: UPDATE fnd_flex_validation_rule_lines SET
9648: last_updated_by = l_file_who.last_updated_by,
9649: last_update_date = l_file_who.last_update_date,
9650: last_update_login = l_file_who.last_update_login,
9651: description = Nvl(p_description, description)

Line 9696: UPDATE fnd_flex_validation_rule_lines SET

9692:
9693: IF (g_debug_on) THEN
9694: debug(l_func_name, 'Updating KFF_CVR_LINE.(non-MLS)');
9695: END IF;
9696: UPDATE fnd_flex_validation_rule_lines SET
9697: last_updated_by = l_file_who.last_updated_by,
9698: last_update_date = l_file_who.last_update_date,
9699: last_update_login = l_file_who.last_update_login,
9700: enabled_flag = p_enabled_flag,

Line 9717: INSERT INTO fnd_flex_validation_rule_lines

9713: END IF;
9714: --
9715: -- rule_line_id is populated by fnd_flex_val_rule_lines_t1 trigger.
9716: --
9717: INSERT INTO fnd_flex_validation_rule_lines
9718: (
9719: application_id,
9720: id_flex_code,
9721: id_flex_num,