8365: IS
8366: TYPE seg_name IS TABLE OF VARCHAR2(1000)
8367: INDEX BY BINARY_INTEGER;
8368: l_context VARCHAR2(1000);
8369: l_context_r fnd_dflex.context_r;
8370: l_contexts_dr fnd_dflex.contexts_dr;
8371: l_dflex_r fnd_dflex.dflex_r;
8372: l_segments_dr fnd_dflex.segments_dr;
8373: l_enabled_seg_name seg_name;
8366: TYPE seg_name IS TABLE OF VARCHAR2(1000)
8367: INDEX BY BINARY_INTEGER;
8368: l_context VARCHAR2(1000);
8369: l_context_r fnd_dflex.context_r;
8370: l_contexts_dr fnd_dflex.contexts_dr;
8371: l_dflex_r fnd_dflex.dflex_r;
8372: l_segments_dr fnd_dflex.segments_dr;
8373: l_enabled_seg_name seg_name;
8374: l_wms_all_segs_tbl seg_name;
8367: INDEX BY BINARY_INTEGER;
8368: l_context VARCHAR2(1000);
8369: l_context_r fnd_dflex.context_r;
8370: l_contexts_dr fnd_dflex.contexts_dr;
8371: l_dflex_r fnd_dflex.dflex_r;
8372: l_segments_dr fnd_dflex.segments_dr;
8373: l_enabled_seg_name seg_name;
8374: l_wms_all_segs_tbl seg_name;
8375: l_nsegments BINARY_INTEGER;
8368: l_context VARCHAR2(1000);
8369: l_context_r fnd_dflex.context_r;
8370: l_contexts_dr fnd_dflex.contexts_dr;
8371: l_dflex_r fnd_dflex.dflex_r;
8372: l_segments_dr fnd_dflex.segments_dr;
8373: l_enabled_seg_name seg_name;
8374: l_wms_all_segs_tbl seg_name;
8375: l_nsegments BINARY_INTEGER;
8376: l_global_context BINARY_INTEGER;
8479:
8480: print_debug('BEFORE SETTING THE ATTRIBUTES CONTEXT',4);
8481:
8482: /* Get all contexts */
8483: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
8484:
8485: print_debug('Found contexts for the Flexfield MTL_LOT_NUMBERS',4);
8486:
8487: /* From the l_contexts_dr, get the position of the global context */
8496:
8497: l_context_r.flexfield := l_dflex_r;
8498: l_context_r.context_code := l_context;
8499:
8500: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
8501:
8502: print_debug('After successfully getting all the enabled segmenst for the Global Context ',4);
8503:
8504: /* read through the segments */
8549: /* Prepare the context_r type */
8550: l_context_r.flexfield := l_dflex_r;
8551: l_context_r.context_code := l_context;
8552:
8553: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
8554:
8555: /* read through the segments */
8556: l_nsegments := l_segments_dr.nsegments;
8557: