DBA Data[Home] [Help]

APPS.GCS_VALUE_SET_PKG dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

Line 156: INSERT INTO fnd_flex_value_norm_hierarchy ( flex_value_set_id,

152: p_entity_id,
153: p_eff_date)
154: LOOP
155:
156: INSERT INTO fnd_flex_value_norm_hierarchy ( flex_value_set_id,
157: parent_flex_value,
158: range_attribute,
159: child_flex_value_low,
160: child_flex_value_high,

Line 238: DELETE fnd_flex_value_norm_hierarchy

234: INTO l_flex_value_set_id
235: FROM fnd_flex_value_sets
236: WHERE flex_value_set_name = 'FCH_ICM_ENTITY_VALUE_SET';
237:
238: DELETE fnd_flex_value_norm_hierarchy
239: WHERE flex_value_set_id = l_flex_value_set_id;
240:
241: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
242: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.create_entity_value_set_hier.recurse_hierarchy', '<>');