DBA Data[Home] [Help]

APPS.FII_COM_MAINTAIN_PKG dependencies on FND_FLEX_VALUES

Line 101: from fnd_flex_values

97: FII_MESSAGE.Func_Ent (func_name => 'Get_Flex_Value');
98: end if;
99:
100: select flex_value into l_flex_value
101: from fnd_flex_values
102: where flex_value_id = p_flex_value_id;
103:
104: if FIIDIM_Debug then
105: FII_MESSAGE.Func_Succ (func_name => 'Get_Flex_Value');

Line 593: fnd_flex_values ffv

589: IS
590:
591: SELECT ffv.flex_value_id, ffv.flex_value, ffv.flex_value_set_id, attribute_sort_order sort_order
592: FROM FII_DIM_NORM_HIER_GT ffvnh,
593: fnd_flex_values ffv
594: WHERE ffvnh.child_flex_value_set_id = ffv.flex_value_set_id
595: AND (ffv.flex_value BETWEEN ffvnh.child_flex_value_low
596: AND ffvnh.child_flex_value_high)
597: AND ((ffvnh.range_attribute = 'P' and ffv.summary_flag = 'Y') OR

Line 609: from fnd_flex_values

605:
606: BEGIN
607:
608: select flex_value_id, attribute_sort_order into l_flex_value_id, l_sort_order
609: from fnd_flex_values
610: where flex_value_set_id = p_vset_id
611: and flex_value = p_root_node;
612:
613: l_flex_value_set_id := p_vset_id;

Line 726: g_phase := 'Get p_parent_id from FND_FLEX_VALUES';

722:
723: CODIM_parent_node := p_root_node;
724: CODIM_parent_vset_id := p_vset_id;
725:
726: g_phase := 'Get p_parent_id from FND_FLEX_VALUES';
727:
728: SELECT flex_value_id INTO p_parent_id
729: FROM FND_FLEX_VALUES
730: WHERE flex_value_set_id = p_vset_id

Line 729: FROM FND_FLEX_VALUES

725:
726: g_phase := 'Get p_parent_id from FND_FLEX_VALUES';
727:
728: SELECT flex_value_id INTO p_parent_id
729: FROM FND_FLEX_VALUES
730: WHERE flex_value_set_id = p_vset_id
731: AND flex_value = p_root_node;
732:
733: CODIM_parent_flex_id := p_parent_id;