APPS.FND_FLEX_LOADER_APIS dependencies on FND_FLEX_HIERARCHIES

Line 75: SUBTYPE vst_rgr_type IS fnd_flex_hierarchies%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;
79: SUBTYPE vst_vlh_type IS fnd_flex_value_norm_hierarchy%ROWTYPE;

Line 76: SUBTYPE vst_rgr_tl_type IS fnd_flex_hierarchies_tl%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;
79: SUBTYPE vst_vlh_type IS fnd_flex_value_norm_hierarchy%ROWTYPE;
80:

Line 1651: FROM fnd_flex_hierarchies

1647: BEGIN
1648: l_func_name := g_api_name || 'get_vst_rgr(F)';
1649: SELECT *
1650: INTO x_vst_rgr
1651: FROM fnd_flex_hierarchies
1652: WHERE flex_value_set_id = p_vst_set.flex_value_set_id
1653: AND hierarchy_code = p_hierarchy_code;
1654: RETURN TRUE;
1655: EXCEPTION

Line 1699: FROM fnd_flex_hierarchies_tl

1695: BEGIN
1696: l_func_name := g_api_name || 'get_vst_rgr_tl(F)';
1697: SELECT *
1698: INTO x_vst_rgr_tl
1699: FROM fnd_flex_hierarchies_tl
1700: WHERE flex_value_set_id = p_vst_rgr.flex_value_set_id
1701: AND hierarchy_id = p_vst_rgr.hierarchy_id
1702: AND language = p_language;
1703: RETURN TRUE;

Line 5174: fnd_flex_hierarchies_pkg.translate_row

5170:
5171: IF (g_debug_on) THEN
5172: debug(l_func_name, 'Translating VSET_ROLLUP_GROUP.(MLS)');
5173: END IF;
5174: fnd_flex_hierarchies_pkg.translate_row
5175: (x_flex_value_set_name => p_flex_value_set_name,
5176: x_hierarchy_code => p_hierarchy_code,
5177: x_who => l_file_who,
5178: x_hierarchy_name => p_hierarchy_name,

Line 5209: fnd_flex_hierarchies_pkg.load_row

5205:
5206: IF (g_debug_on) THEN
5207: debug(l_func_name, 'Uploading VSET_ROLLUP_GROUP.(MLS)');
5208: END IF;
5209: fnd_flex_hierarchies_pkg.load_row
5210: (x_flex_value_set_name => p_flex_value_set_name,
5211: x_hierarchy_code => p_hierarchy_code,
5212: x_who => l_file_who,
5213: x_hierarchy_name => p_hierarchy_name,