APPS.INV_SERIAL_NUMBER_ATTR dependencies on FND_DFLEX

Line 31: l_context_r fnd_dflex.context_r;

27:
28: l_tempvar NUMBER;
29: l_default_attr_category VARCHAR2(240);
30: l_context VARCHAR2(1000);
31: l_context_r fnd_dflex.context_r;
32: l_contexts_dr fnd_dflex.contexts_dr;
33: l_dflex_r fnd_dflex.dflex_r;
34: l_segments_dr fnd_dflex.segments_dr;
35: l_enabled_seg_name seg_name;

Line 32: l_contexts_dr fnd_dflex.contexts_dr;

28: l_tempvar NUMBER;
29: l_default_attr_category VARCHAR2(240);
30: l_context VARCHAR2(1000);
31: l_context_r fnd_dflex.context_r;
32: l_contexts_dr fnd_dflex.contexts_dr;
33: l_dflex_r fnd_dflex.dflex_r;
34: l_segments_dr fnd_dflex.segments_dr;
35: l_enabled_seg_name seg_name;
36: l_inv_attributes_tbl seg_name;

Line 33: l_dflex_r fnd_dflex.dflex_r;

29: l_default_attr_category VARCHAR2(240);
30: l_context VARCHAR2(1000);
31: l_context_r fnd_dflex.context_r;
32: l_contexts_dr fnd_dflex.contexts_dr;
33: l_dflex_r fnd_dflex.dflex_r;
34: l_segments_dr fnd_dflex.segments_dr;
35: l_enabled_seg_name seg_name;
36: l_inv_attributes_tbl seg_name;
37: l_nsegments BINARY_INTEGER;

Line 34: l_segments_dr fnd_dflex.segments_dr;

30: l_context VARCHAR2(1000);
31: l_context_r fnd_dflex.context_r;
32: l_contexts_dr fnd_dflex.contexts_dr;
33: l_dflex_r fnd_dflex.dflex_r;
34: l_segments_dr fnd_dflex.segments_dr;
35: l_enabled_seg_name seg_name;
36: l_inv_attributes_tbl seg_name;
37: l_nsegments BINARY_INTEGER;
38: l_global_context BINARY_INTEGER;

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

95: --Get default attribute_category context
96: l_dflex_r.application_id := 401;
97: l_dflex_r.flexfield_name := 'MTL_SERIAL_NUMBERS';
98: /* Get all contexts */
99: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
100:
101: IF g_debug = 1 THEN
102: print_debug('Found contexts for the Flexfield MTL_SERIAL_NUMBERS');
103: END IF;

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

124: --AND p_attributes_tbl.COUNT > 0 THEN
125: l_dflex_r.application_id := 401;
126: l_dflex_r.flexfield_name := 'MTL_SERIAL_NUMBERS';
127: /* Get all contexts */
128: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
129:
130: IF g_debug = 1 THEN
131: print_debug('Found contexts for the Flexfield MTL_SERIAL_NUMBERS');
132: END IF;

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

148: /* Prepare the context_r type for getting the segments associated with the global context */
149: l_context_r.flexfield := l_dflex_r;
150: l_context_r.context_code := l_context;
151:
152: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
153:
154: IF g_debug = 1 THEN
155: print_debug('After successfully getting all the enabled segments for the Global Context ');
156: END IF;

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

233:
234: /* Prepare the context_r type */
235: l_context_r.flexfield := l_dflex_r;
236: l_context_r.context_code := l_context;
237: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
238: /* read through the segments */
239: l_nsegments := l_segments_dr.nsegments;
240: IF g_debug = 1 THEN
241: print_debug('No of segments enabled for context ' || l_context || ' are ' || l_nsegments);