APPS.FII_LOB_MAINTAIN_PKG dependencies on FND_FLEX_VALUES

Line 98: from fnd_flex_values

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

Line 242: from fnd_flex_values

238: where flex_value_set_name = 'Financials Intelligence Internal Value Set';
239:
240: g_phase := 'Find the unassigned LOB ID from value set: '||G_FII_INT_VALUE_SET_ID;
241: select flex_value_id into G_UNASSIGNED_LOB_ID
242: from fnd_flex_values
243: where flex_value_set_id = G_FII_INT_VALUE_SET_ID
244: and flex_value = 'UNASSIGNED';
245:
246: -- --------------------------------------------------------

Line 619: fnd_flex_values ffv

615:
616: CURSOR direct_children_csr (p_parent_vs_id NUMBER, p_parent_node VARCHAR2) IS
617: SELECT ffv.flex_value_id, ffv.flex_value, ffv.flex_value_set_id
618: FROM FII_DIM_NORM_HIER_GT ffvnh,
619: fnd_flex_values ffv
620: WHERE ffvnh.child_flex_value_set_id = ffv.flex_value_set_id
621: AND (ffv.flex_value BETWEEN ffvnh.child_flex_value_low
622: AND ffvnh.child_flex_value_high)
623: AND ((ffvnh.range_attribute = 'P' and ffv.summary_flag = 'Y') OR

Line 638: from fnd_flex_values

634: -- FII_MESSAGE.Func_Ent ('FII_COM_MAINTAIN_PKG.INSERT_IMM_CHILD_NODES');
635: -- END IF;
636:
637: select flex_value_id into l_flex_value_id
638: from fnd_flex_values
639: where flex_value_set_id = p_vset_id
640: and flex_value = p_root_node;
641:
642: l_flex_value_set_id := p_vset_id;

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

739:
740: LOBDIM_parent_node := p_root_node;
741: LOBDIM_parent_vset_id := p_vset_id;
742:
743: g_phase := 'Get p_parent_id from FND_FLEX_VALUES';
744:
745: SELECT flex_value_id INTO p_parent_id
746: FROM FND_FLEX_VALUES
747: WHERE flex_value_set_id = p_vset_id

Line 746: FROM FND_FLEX_VALUES

742:
743: g_phase := 'Get p_parent_id from FND_FLEX_VALUES';
744:
745: SELECT flex_value_id INTO p_parent_id
746: FROM FND_FLEX_VALUES
747: WHERE flex_value_set_id = p_vset_id
748: AND flex_value = p_root_node;
749:
750: LOBDIM_parent_flex_id := p_parent_id;

Line 1044: -- by looking at column HIERARCHY_LEVEL of FND_FLEX_VALUES for the master value set.

1040:
1041:
1042: -- **************************************************************************
1043: -- Populate column next_level_lob_sort_order for pruned hierarchy FII_LOB_HIER_GT
1044: -- by looking at column HIERARCHY_LEVEL of FND_FLEX_VALUES for the master value set.
1045: -- This is for Oracle IT only currently.
1046:
1047: PROCEDURE Get_Sort_Order IS
1048:

Line 1061: from fnd_flex_values ffv

1057: update fii_lob_hier_gt h
1058: set h.next_level_lob_sort_order =
1059: (select decode(TRANSLATE(HIERARCHY_LEVEL, 'A0123456789', 'A'), NULL,
1060: to_number(HIERARCHY_LEVEL), to_number(NULL))
1061: from fnd_flex_values ffv
1062: where ffv.flex_value_set_id = G_MASTER_VALUE_SET_ID
1063: and ffv.flex_value_id = h.next_level_lob_id);
1064:
1065: IF (FIIDIM_Debug) THEN