APPS.FND_FLEX_LOADER_APIS dependencies on FND_FLEX_VALUE_RULE_LINES

Line 73: SUBTYPE vst_scl_type IS fnd_flex_value_rule_lines%ROWTYPE;

69: SUBTYPE vst_tbl_type IS fnd_flex_validation_tables%ROWTYPE;
70: SUBTYPE vst_evt_type IS fnd_flex_validation_events%ROWTYPE;
71: SUBTYPE vst_scr_type IS fnd_flex_value_rules%ROWTYPE;
72: SUBTYPE vst_scr_tl_type IS fnd_flex_value_rules_tl%ROWTYPE;
73: SUBTYPE vst_scl_type IS fnd_flex_value_rule_lines%ROWTYPE;
74: SUBTYPE vst_scu_type IS fnd_flex_value_rule_usages%ROWTYPE;
75: SUBTYPE vst_rgr_type IS fnd_flex_hierarchies%ROWTYPE;
76: SUBTYPE vst_rgr_tl_type IS fnd_flex_hierarchies_tl%ROWTYPE;
77: SUBTYPE vst_val_type IS fnd_flex_values%ROWTYPE;

Line 1491: FROM fnd_flex_value_rule_lines

1487: l_func_name := g_api_name || 'get_vst_scl(F)';
1488: IF (p_vst_set.validation_type = 'D') THEN
1489: SELECT *
1490: INTO x_vst_scl
1491: FROM fnd_flex_value_rule_lines
1492: WHERE flex_value_set_id = p_vst_scr.flex_value_set_id
1493: AND flex_value_rule_id = p_vst_scr.flex_value_rule_id
1494: AND parent_flex_value_low = p_vst_scr.parent_flex_value_low
1495: AND include_exclude_indicator = p_include_exclude_indicator

Line 1501: FROM fnd_flex_value_rule_lines

1497: AND flex_value_high = p_flex_value_high;
1498: ELSE
1499: SELECT *
1500: INTO x_vst_scl
1501: FROM fnd_flex_value_rule_lines
1502: WHERE flex_value_set_id = p_vst_scr.flex_value_set_id
1503: AND flex_value_rule_id = p_vst_scr.flex_value_rule_id
1504: AND include_exclude_indicator = p_include_exclude_indicator
1505: AND flex_value_low = p_flex_value_low

Line 4854: UPDATE fnd_flex_value_rule_lines SET

4850: IF (g_debug_on) THEN
4851: debug(l_func_name, 'Updating VSET_SECURITY_LINE.(no-TL)');
4852: END IF;
4853: IF (l_vst_set.validation_type = 'D') THEN
4854: UPDATE fnd_flex_value_rule_lines SET
4855: last_updated_by = l_file_who.last_updated_by,
4856: last_update_date = l_file_who.last_update_date,
4857: last_update_login = l_file_who.last_update_login,
4858: parent_flex_value_high = p_parent_flex_value_high

Line 4866: UPDATE fnd_flex_value_rule_lines SET

4862: AND include_exclude_indicator = p_include_exclude_indicator
4863: AND flex_value_low = p_flex_value_low
4864: AND flex_value_high = p_flex_value_high;
4865: ELSE
4866: UPDATE fnd_flex_value_rule_lines SET
4867: last_updated_by = l_file_who.last_updated_by,
4868: last_update_date = l_file_who.last_update_date,
4869: last_update_login = l_file_who.last_update_login,
4870: parent_flex_value_low = p_parent_flex_value_low,

Line 4883: INSERT INTO fnd_flex_value_rule_lines

4879: IF (SQL%notfound) THEN
4880: IF (g_debug_on) THEN
4881: debug(l_func_name, 'Inserting VSET_SECURITY_LINE.(no-TL)');
4882: END IF;
4883: INSERT INTO fnd_flex_value_rule_lines
4884: (
4885: flex_value_set_id,
4886: flex_value_rule_id,
4887: parent_flex_value_low,