146:
147:
148: -- Bug 5367283 Added the following variables
149:
150: l_context_r fnd_dflex.context_r;
151: l_contexts_dr fnd_dflex.contexts_dr;
152: l_dflex_r fnd_dflex.dflex_r;
153: l_segments_dr fnd_dflex.segments_dr;
154: l_context VARCHAR2(1000);
147:
148: -- Bug 5367283 Added the following variables
149:
150: l_context_r fnd_dflex.context_r;
151: l_contexts_dr fnd_dflex.contexts_dr;
152: l_dflex_r fnd_dflex.dflex_r;
153: l_segments_dr fnd_dflex.segments_dr;
154: l_context VARCHAR2(1000);
155: l_global_context BINARY_INTEGER;
148: -- Bug 5367283 Added the following variables
149:
150: l_context_r fnd_dflex.context_r;
151: l_contexts_dr fnd_dflex.contexts_dr;
152: l_dflex_r fnd_dflex.dflex_r;
153: l_segments_dr fnd_dflex.segments_dr;
154: l_context VARCHAR2(1000);
155: l_global_context BINARY_INTEGER;
156: wms_context_index NUMBER;
149:
150: l_context_r fnd_dflex.context_r;
151: l_contexts_dr fnd_dflex.contexts_dr;
152: l_dflex_r fnd_dflex.dflex_r;
153: l_segments_dr fnd_dflex.segments_dr;
154: l_context VARCHAR2(1000);
155: l_global_context BINARY_INTEGER;
156: wms_context_index NUMBER;
157:
698: l_dflex_r.flexfield_name := 'Lot Attributes';
699:
700: -- Get all contexts
701:
702: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
703:
704: -- From the l_contexts_dr, get the position of the global context
705:
706: l_global_context := NULL;
714: l_context_r.context_code := l_context;
715:
716: -- Get the segments for the context
717:
718: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
719:
720: -- Loop through the global segments
721:
722: FOR wms_context_index IN 1 .. l_segments_dr.nsegments LOOP