DBA Data[Home] [Help]

APPS.OKL_ACCOUNTING_UTIL dependencies on FND_FLEX_VALUES

Line 54: l_parent_value_low FND_FLEX_VALUES.PARENT_FLEX_VALUE_LOW%TYPE;

50: l_seg_desc VARCHAR2(2000);
51: --Bug# 12336692
52: l_concate_desc VARCHAR2(2000);
53: l_parent_id fnd_flex_value_sets.parent_flex_value_set_id%TYPE;
54: l_parent_value_low FND_FLEX_VALUES.PARENT_FLEX_VALUE_LOW%TYPE;
55:
56: -- Changed by Santonyr on 13-May-2004
57: -- Fixed Bug Number 3628755
58:

Line 60: (segment_value fnd_flex_values_vl.flex_value%TYPE,

56: -- Changed by Santonyr on 13-May-2004
57: -- Fixed Bug Number 3628755
58:
59: TYPE segment_rec_type IS RECORD
60: (segment_value fnd_flex_values_vl.flex_value%TYPE,
61: flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE
62: );
63:
64: TYPE segment_table_type IS TABLE OF segment_rec_type INDEX BY BINARY_INTEGER;

Line 84: FROM fnd_flex_values_vl

80: l_flex_value_set_id NUMBER,
81: l_segment_value VARCHAR2)
82: IS
83: SELECT description
84: FROM fnd_flex_values_vl
85: WHERE flex_value_set_id = l_flex_value_set_id
86: AND flex_value = l_segment_value;
87:
88:

Line 97: FROM fnd_flex_values_vl

93: l_segment_value VARCHAR2,
94: l_parent_value_low VARCHAR2
95: ) IS
96: SELECT description
97: FROM fnd_flex_values_vl
98: WHERE flex_value_set_id = l_flex_value_set_id
99: AND flex_value = l_segment_value
100: AND parent_flex_value_low = l_parent_value_low;
101: