DBA Data[Home] [Help]

APPS.INV_LOC_WMS_PUB dependencies on FND_DFLEX

Line 88: l_context_r fnd_dflex.context_r;

84: TYPE seg_name IS TABLE OF VARCHAR2(1000)
85: INDEX BY BINARY_INTEGER;
86:
87: l_context VARCHAR2(1000);
88: l_context_r fnd_dflex.context_r;
89: l_contexts_dr fnd_dflex.contexts_dr;
90: l_dflex_r fnd_dflex.dflex_r;
91: l_segments_dr fnd_dflex.segments_dr;
92: l_enabled_seg_name seg_name;

Line 89: l_contexts_dr fnd_dflex.contexts_dr;

85: INDEX BY BINARY_INTEGER;
86:
87: l_context VARCHAR2(1000);
88: l_context_r fnd_dflex.context_r;
89: l_contexts_dr fnd_dflex.contexts_dr;
90: l_dflex_r fnd_dflex.dflex_r;
91: l_segments_dr fnd_dflex.segments_dr;
92: l_enabled_seg_name seg_name;
93: l_wms_all_segs_tbl seg_name;

Line 90: l_dflex_r fnd_dflex.dflex_r;

86:
87: l_context VARCHAR2(1000);
88: l_context_r fnd_dflex.context_r;
89: l_contexts_dr fnd_dflex.contexts_dr;
90: l_dflex_r fnd_dflex.dflex_r;
91: l_segments_dr fnd_dflex.segments_dr;
92: l_enabled_seg_name seg_name;
93: l_wms_all_segs_tbl seg_name;
94: l_nsegments BINARY_INTEGER;

Line 91: l_segments_dr fnd_dflex.segments_dr;

87: l_context VARCHAR2(1000);
88: l_context_r fnd_dflex.context_r;
89: l_contexts_dr fnd_dflex.contexts_dr;
90: l_dflex_r fnd_dflex.dflex_r;
91: l_segments_dr fnd_dflex.segments_dr;
92: l_enabled_seg_name seg_name;
93: l_wms_all_segs_tbl seg_name;
94: l_nsegments BINARY_INTEGER;
95: l_global_context BINARY_INTEGER;

Line 127: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);

123:
124: l_dflex_r.application_id := 401;
125: l_dflex_r.flexfield_name := 'MTL_ITEM_LOCATIONS';
126: /* Get all contexts */
127: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
128:
129:
130: --DBMS_output.put_line('Found contexts for the Flexfield MTL_LOT_NUMBERS');
131:

Line 145: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);

141:
142: /* Prepare the context_r type for getting the segments associated with the global context */
143: l_context_r.flexfield := l_dflex_r;
144: l_context_r.context_code := l_context;
145: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
146:
147:
148: --DBMS_output.put_line('After successfully getting all the enabled segmenst for the Global Context ');
149:

Line 230: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);

226:
227: /* Prepare the context_r type */
228: l_context_r.flexfield := l_dflex_r;
229: l_context_r.context_code := l_context;
230: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
231: /* read through the segments */
232: l_nsegments := l_segments_dr.nsegments;
233:
234: --DBMS_output.put_line('No of segments enabled for context ' || l_context || ' are ' || l_nsegments);