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:
81: SUBTYPE dff_flx_type IS fnd_descriptive_flexs%ROWTYPE;
82: SUBTYPE dff_flx_tl_type IS fnd_descriptive_flexs_tl%ROWTYPE;
83: SUBTYPE dff_ref_type IS fnd_default_context_fields%ROWTYPE;
1816: BEGIN
1817: l_func_name := g_api_name || 'get_vst_vlh(F)';
1818: SELECT *
1819: INTO x_vst_vlh
1820: FROM fnd_flex_value_norm_hierarchy
1821: WHERE flex_value_set_id = p_vst_val.flex_value_set_id
1822: AND parent_flex_value = p_vst_val.flex_value
1823: AND range_attribute = p_range_attribute
1824: AND child_flex_value_low = p_child_flex_value_low
4149: --
4150: IF (g_numof_changes > 0) THEN
4151: SELECT COUNT(*)
4152: INTO l_count
4153: FROM fnd_flex_value_norm_hierarchy
4154: WHERE flex_value_set_id =
4155: (SELECT flex_value_set_id
4156: FROM fnd_flex_value_sets
4157: WHERE flex_value_set_name = p_flex_value_set_name);
5696: --
5697: IF (g_debug_on) THEN
5698: debug(l_func_name, 'Updating VSET_VALUE_HIERARCHY.(no-TL)');
5699: END IF;
5700: UPDATE fnd_flex_value_norm_hierarchy SET
5701: last_updated_by = l_file_who.last_updated_by,
5702: last_update_date = l_file_who.last_update_date,
5703: last_update_login = l_file_who.last_update_login,
5704: start_date_active = To_date(p_start_date_active, g_date_mask),
5712: IF (SQL%notfound) THEN
5713: IF (g_debug_on) THEN
5714: debug(l_func_name, 'Inserting VSET_VALUE_HIERARCHY.(no-TL)');
5715: END IF;
5716: INSERT INTO fnd_flex_value_norm_hierarchy
5717: (
5718: flex_value_set_id,
5719: parent_flex_value,
5720: range_attribute,