46: l_api_name CONSTANT VARCHAR2(30) := 'FIND_ERROR_SEGMENT';
47: l_api_version CONSTANT NUMBER := 1.0;
48: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
49:
50: l_flexfield fnd_dflex.dflex_r;
51: l_flexinfo fnd_dflex.dflex_dr;
52: l_global_context fnd_dflex.context_r;
53: l_context fnd_dflex.context_r;
54: l_global_segments fnd_dflex.segments_dr;
47: l_api_version CONSTANT NUMBER := 1.0;
48: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
49:
50: l_flexfield fnd_dflex.dflex_r;
51: l_flexinfo fnd_dflex.dflex_dr;
52: l_global_context fnd_dflex.context_r;
53: l_context fnd_dflex.context_r;
54: l_global_segments fnd_dflex.segments_dr;
55: l_global_count number :=0;
48: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
49:
50: l_flexfield fnd_dflex.dflex_r;
51: l_flexinfo fnd_dflex.dflex_dr;
52: l_global_context fnd_dflex.context_r;
53: l_context fnd_dflex.context_r;
54: l_global_segments fnd_dflex.segments_dr;
55: l_global_count number :=0;
56: l_segments fnd_dflex.segments_dr;
49:
50: l_flexfield fnd_dflex.dflex_r;
51: l_flexinfo fnd_dflex.dflex_dr;
52: l_global_context fnd_dflex.context_r;
53: l_context fnd_dflex.context_r;
54: l_global_segments fnd_dflex.segments_dr;
55: l_global_count number :=0;
56: l_segments fnd_dflex.segments_dr;
57: l_segment_info seg_info_tbl_type;
50: l_flexfield fnd_dflex.dflex_r;
51: l_flexinfo fnd_dflex.dflex_dr;
52: l_global_context fnd_dflex.context_r;
53: l_context fnd_dflex.context_r;
54: l_global_segments fnd_dflex.segments_dr;
55: l_global_count number :=0;
56: l_segments fnd_dflex.segments_dr;
57: l_segment_info seg_info_tbl_type;
58: l_counter number :=0;
52: l_global_context fnd_dflex.context_r;
53: l_context fnd_dflex.context_r;
54: l_global_segments fnd_dflex.segments_dr;
55: l_global_count number :=0;
56: l_segments fnd_dflex.segments_dr;
57: l_segment_info seg_info_tbl_type;
58: l_counter number :=0;
59: l_check_segments BOOLEAN := TRUE;
60: l_exists varchar2(2);
64:
65: --
66: -- First get the flexfield information
67: --
68: fnd_dflex.get_flexfield(appl_short_name => p_appl_short_name,
69: flexfield_name => p_flexfield_name,
70: flexfield => l_flexfield,
71: flexinfo => l_flexinfo);
72: --
116: --
117: -- First set up the Global Data Elements flexfield context, which is
118: -- always called 'Global Data Elements', as is not translated.
119: --
120: l_global_context := fnd_dflex.make_context(flexfield => l_flexfield,
121: context_code => 'Global Data Elements');
122:
123: fnd_dflex.get_segments(context => l_global_context,
124: segments => l_global_segments,
119: --
120: l_global_context := fnd_dflex.make_context(flexfield => l_flexfield,
121: context_code => 'Global Data Elements');
122:
123: fnd_dflex.get_segments(context => l_global_context,
124: segments => l_global_segments,
125: enabled_only => true);
126:
127: if (l_global_segments.application_column_name.count > 0) then
148: -- Next get the specific information if the context is not global data elements
149: --
150: if (p_context_code is not null) then
151:
152: l_context := fnd_dflex.make_context(flexfield => l_flexfield,
153: context_code => p_context_code);
154: --
155: -- Retrieve the segment information for this context
156: --
153: context_code => p_context_code);
154: --
155: -- Retrieve the segment information for this context
156: --
157: fnd_dflex.get_segments(context => l_context,
158: segments => l_segments,
159: enabled_only => true);
160: --
161: -- Append the specific context segment information to the Global Segment Information
240: l_desc_col_name13 VARCHAR2(30) := p_segment_partial_name||'13';
241: l_desc_col_name14 VARCHAR2(30) := p_segment_partial_name||'14';
242: l_desc_col_name15 VARCHAR2(30) := p_segment_partial_name||'15';
243:
244: l_flexfield fnd_dflex.dflex_r;
245: l_flexinfo fnd_dflex.dflex_dr;
246:
247: -- --------------------------------------------------------------------------
248: -- |-----------------------< attribute_set_add_dtls >-----------------------|
241: l_desc_col_name14 VARCHAR2(30) := p_segment_partial_name||'14';
242: l_desc_col_name15 VARCHAR2(30) := p_segment_partial_name||'15';
243:
244: l_flexfield fnd_dflex.dflex_r;
245: l_flexinfo fnd_dflex.dflex_dr;
246:
247: -- --------------------------------------------------------------------------
248: -- |-----------------------< attribute_set_add_dtls >-----------------------|
249: -- --------------------------------------------------------------------------
586: --
587: if l_ne_column_value is not null then
588: --
589:
590: fnd_dflex.get_flexfield
591: (appl_short_name => p_appl_short_name,
592: flexfield_name => p_descflex_name,
593: flexfield => l_flexfield,
594: flexinfo => l_flexinfo);