DBA Data[Home] [Help]

APPS.FND_FLEX_LOADER_APIS dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

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

Line 1820: FROM fnd_flex_value_norm_hierarchy

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

Line 4153: FROM fnd_flex_value_norm_hierarchy

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);

Line 5700: UPDATE fnd_flex_value_norm_hierarchy SET

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),

Line 5716: INSERT INTO fnd_flex_value_norm_hierarchy

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,