DBA Data[Home] [Help]

APPS.INV_LOC_WMS_PUB dependencies on FND_DFLEX

Line 36: l_context_r fnd_dflex.context_r;

32: TYPE seg_name IS TABLE OF VARCHAR2(1000)
33: INDEX BY BINARY_INTEGER;
34:
35: l_context VARCHAR2(1000);
36: l_context_r fnd_dflex.context_r;
37: l_contexts_dr fnd_dflex.contexts_dr;
38: l_dflex_r fnd_dflex.dflex_r;
39: l_segments_dr fnd_dflex.segments_dr;
40: l_enabled_seg_name seg_name;

Line 37: l_contexts_dr fnd_dflex.contexts_dr;

33: INDEX BY BINARY_INTEGER;
34:
35: l_context VARCHAR2(1000);
36: l_context_r fnd_dflex.context_r;
37: l_contexts_dr fnd_dflex.contexts_dr;
38: l_dflex_r fnd_dflex.dflex_r;
39: l_segments_dr fnd_dflex.segments_dr;
40: l_enabled_seg_name seg_name;
41: l_wms_all_segs_tbl seg_name;

Line 38: l_dflex_r fnd_dflex.dflex_r;

34:
35: l_context VARCHAR2(1000);
36: l_context_r fnd_dflex.context_r;
37: l_contexts_dr fnd_dflex.contexts_dr;
38: l_dflex_r fnd_dflex.dflex_r;
39: l_segments_dr fnd_dflex.segments_dr;
40: l_enabled_seg_name seg_name;
41: l_wms_all_segs_tbl seg_name;
42: l_nsegments BINARY_INTEGER;

Line 39: l_segments_dr fnd_dflex.segments_dr;

35: l_context VARCHAR2(1000);
36: l_context_r fnd_dflex.context_r;
37: l_contexts_dr fnd_dflex.contexts_dr;
38: l_dflex_r fnd_dflex.dflex_r;
39: l_segments_dr fnd_dflex.segments_dr;
40: l_enabled_seg_name seg_name;
41: l_wms_all_segs_tbl seg_name;
42: l_nsegments BINARY_INTEGER;
43: l_global_context BINARY_INTEGER;

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

71:
72: l_dflex_r.application_id := 401;
73: l_dflex_r.flexfield_name := 'MTL_ITEM_LOCATIONS';
74: /* Get all contexts */
75: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
76:
77:
78: --DBMS_output.put_line('Found contexts for the Flexfield MTL_LOT_NUMBERS');
79:

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

89:
90: /* Prepare the context_r type for getting the segments associated with the global context */
91: l_context_r.flexfield := l_dflex_r;
92: l_context_r.context_code := l_context;
93: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
94:
95:
96: --DBMS_output.put_line('After successfully getting all the enabled segmenst for the Global Context ');
97:

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

174:
175: /* Prepare the context_r type */
176: l_context_r.flexfield := l_dflex_r;
177: l_context_r.context_code := l_context;
178: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
179: /* read through the segments */
180: l_nsegments := l_segments_dr.nsegments;
181:
182: --DBMS_output.put_line('No of segments enabled for context ' || l_context || ' are ' || l_nsegments);