APPS.FND_FLEX_LOADER_APIS dependencies on FND_FLEX_VALUE_RULE_USAGES

Line 74: SUBTYPE vst_scu_type IS fnd_flex_value_rule_usages%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;
78: SUBTYPE vst_val_tl_type IS fnd_flex_values_tl%ROWTYPE;

Line 1575: FROM fnd_flex_value_rule_usages

1571: l_func_name := g_api_name || 'get_vst_scu(F)';
1572: IF (p_vst_set.validation_type = 'D') THEN
1573: SELECT *
1574: INTO x_vst_scu
1575: FROM fnd_flex_value_rule_usages
1576: WHERE application_id = p_resp.application_id
1577: AND responsibility_id = p_resp.responsibility_id
1578: AND flex_value_set_id = p_vst_scr.flex_value_set_id
1579: AND flex_value_rule_id = p_vst_scr.flex_value_rule_id

Line 1584: FROM fnd_flex_value_rule_usages

1580: AND parent_flex_value_low = p_vst_scr.parent_flex_value_low;
1581: ELSE
1582: SELECT *
1583: INTO x_vst_scu
1584: FROM fnd_flex_value_rule_usages
1585: WHERE application_id = p_resp.application_id
1586: AND responsibility_id = p_resp.responsibility_id
1587: AND flex_value_set_id = p_vst_scr.flex_value_set_id
1588: AND flex_value_rule_id = p_vst_scr.flex_value_rule_id;

Line 5026: UPDATE fnd_flex_value_rule_usages SET

5022: IF (g_debug_on) THEN
5023: debug(l_func_name, 'Updating VSET_SECURITY_USAGE.(no-TL)');
5024: END IF;
5025: IF (l_vst_set.validation_type = 'D') THEN
5026: UPDATE fnd_flex_value_rule_usages SET
5027: last_updated_by = l_file_who.last_updated_by,
5028: last_update_date = l_file_who.last_update_date,
5029: last_update_login = l_file_who.last_update_login,
5030: parent_flex_value_high = p_parent_flex_value_high

Line 5037: UPDATE fnd_flex_value_rule_usages SET

5033: AND flex_value_set_id = l_vst_set.flex_value_set_id
5034: AND flex_value_rule_id = l_vst_scr.flex_value_rule_id
5035: AND parent_flex_value_low = p_parent_flex_value_low;
5036: ELSE
5037: UPDATE fnd_flex_value_rule_usages SET
5038: last_updated_by = l_file_who.last_updated_by,
5039: last_update_date = l_file_who.last_update_date,
5040: last_update_login = l_file_who.last_update_login,
5041: parent_flex_value_low = p_parent_flex_value_low,

Line 5053: INSERT INTO fnd_flex_value_rule_usages

5049: IF (SQL%notfound) THEN
5050: IF (g_debug_on) THEN
5051: debug(l_func_name, 'Inserting VSET_SECURITY_USAGE.(no-TL)');
5052: END IF;
5053: INSERT INTO fnd_flex_value_rule_usages
5054: (
5055: application_id,
5056: responsibility_id,
5057: flex_value_set_id,