DBA Data[Home] [Help]

APPS.OKL_ACCOUNTING_UTIL dependencies on FND_FLEX_VALUES

Line 53: l_parent_value_low FND_FLEX_VALUES.PARENT_FLEX_VALUE_LOW%TYPE;

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

Line 59: (segment_value fnd_flex_values_vl.flex_value%TYPE,

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

Line 83: FROM fnd_flex_values_vl

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

Line 96: FROM fnd_flex_values_vl

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