DBA Data[Home] [Help]

APPS.WMS_PARAMETER_PVT dependencies on FND_DFLEX

Line 229: l_flexfield fnd_dflex.dflex_r;

225: , x_flex_data_type_code OUT NOCOPY NUMBER
226: , x_flex_name OUT NOCOPY VARCHAR2
227: , x_flex_description OUT NOCOPY VARCHAR2
228: ) IS
229: l_flexfield fnd_dflex.dflex_r;
230: l_flexinfo fnd_dflex.dflex_dr;
231: l_contexts fnd_dflex.contexts_dr;
232: l_context fnd_dflex.context_r;
233: l_segments fnd_dflex.segments_dr;

Line 230: l_flexinfo fnd_dflex.dflex_dr;

226: , x_flex_name OUT NOCOPY VARCHAR2
227: , x_flex_description OUT NOCOPY VARCHAR2
228: ) IS
229: l_flexfield fnd_dflex.dflex_r;
230: l_flexinfo fnd_dflex.dflex_dr;
231: l_contexts fnd_dflex.contexts_dr;
232: l_context fnd_dflex.context_r;
233: l_segments fnd_dflex.segments_dr;
234: l_segment_index BINARY_INTEGER;

Line 231: l_contexts fnd_dflex.contexts_dr;

227: , x_flex_description OUT NOCOPY VARCHAR2
228: ) IS
229: l_flexfield fnd_dflex.dflex_r;
230: l_flexinfo fnd_dflex.dflex_dr;
231: l_contexts fnd_dflex.contexts_dr;
232: l_context fnd_dflex.context_r;
233: l_segments fnd_dflex.segments_dr;
234: l_segment_index BINARY_INTEGER;
235: l_context_index BINARY_INTEGER;

Line 232: l_context fnd_dflex.context_r;

228: ) IS
229: l_flexfield fnd_dflex.dflex_r;
230: l_flexinfo fnd_dflex.dflex_dr;
231: l_contexts fnd_dflex.contexts_dr;
232: l_context fnd_dflex.context_r;
233: l_segments fnd_dflex.segments_dr;
234: l_segment_index BINARY_INTEGER;
235: l_context_index BINARY_INTEGER;
236: l_global_context_idx BINARY_INTEGER;

Line 233: l_segments fnd_dflex.segments_dr;

229: l_flexfield fnd_dflex.dflex_r;
230: l_flexinfo fnd_dflex.dflex_dr;
231: l_contexts fnd_dflex.contexts_dr;
232: l_context fnd_dflex.context_r;
233: l_segments fnd_dflex.segments_dr;
234: l_segment_index BINARY_INTEGER;
235: l_context_index BINARY_INTEGER;
236: l_global_context_idx BINARY_INTEGER;
237: l_valueset_dr fnd_vset.valueset_dr;

Line 253: fnd_dflex.get_flexfield(

249: inv_pp_debug.send_message_to_pipe('x_if_flex_then_available: '|| x_if_flex_then_available);
250: END IF;
251:
252: --
253: fnd_dflex.get_flexfield(
254: appl_short_name => p_application_short_name
255: , flexfield_name => p_flexfield_name
256: , flexfield => l_flexfield
257: , flexinfo => l_flexinfo

Line 260: fnd_dflex.get_contexts(flexfield => l_flexfield, contexts => l_contexts);

256: , flexfield => l_flexfield
257: , flexinfo => l_flexinfo
258: );
259: --
260: fnd_dflex.get_contexts(flexfield => l_flexfield, contexts => l_contexts);
261: --
262: -- we only want the global and enabled context
263: l_global_context_idx := l_contexts.global_context;
264:

Line 279: fnd_dflex.get_segments(l_context, l_segments, TRUE);

275: l_context.context_code := l_contexts.context_code(l_global_context_idx);
276: l_context.flexfield := l_flexfield;
277: --
278: -- get segments
279: fnd_dflex.get_segments(l_context, l_segments, TRUE);
280: --
281: l_segment_index := 0;
282:
283: FOR l_index IN 1 .. l_segments.nsegments LOOP

Line 306: fnd_dflex.get_segments(l_context, l_segments, TRUE);

302: AND l_seg <> l_contexts.global_context THEN
303: inv_pp_debug.send_message_to_pipe('context ENABLED and not GLOBAL');
304: l_context.context_code := l_contexts.context_code(l_seg);
305: l_context.flexfield := l_flexfield;
306: fnd_dflex.get_segments(l_context, l_segments, TRUE);
307:
308: FOR l_index IN 1 .. l_segments.nsegments LOOP
309: IF l_segments.application_column_name(l_index) = p_column_name THEN
310: l_segment_index := l_index;