APPS.INV_SERIAL_NUMBER_ATTR dependencies on MTL_SERIAL_NUMBERS

Line 75: FROM mtl_serial_numbers

71:
72: BEGIN
73: SELECT 1
74: INTO l_tempvar
75: FROM mtl_serial_numbers
76: WHERE inventory_item_id = p_inventory_item_id
77: AND serial_number = p_serial_number
78: AND current_status in (1,3,4); --Bug4493227
79: EXCEPTION

Line 97: l_dflex_r.flexfield_name := 'MTL_SERIAL_NUMBERS';

93:
94: IF p_attribute_category IS NULL THEN
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

Line 102: print_debug('Found contexts for the Flexfield 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;
104:
105: /* From the l_contexts_dr, get the position of the global context */
106: l_global_context := l_contexts_dr.global_context;

Line 126: l_dflex_r.flexfield_name := 'MTL_SERIAL_NUMBERS';

122: /* Populate the flex field record */
123: IF l_default_attr_category IS NOT NULL THEN
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

Line 131: print_debug('Found contexts for the Flexfield 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;
133:
134: /* From the l_contexts_dr, get the position of the global context */
135: l_global_context := l_contexts_dr.global_context;

Line 311: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'MTL_SERIAL_NUMBERS', values_or_ids => 'I', validation_date => SYSDATE) THEN

307: l_chk_flag := 0;
308: END LOOP;*/
309:
310: /*Make a call to FND_FLEX_DESCVAL.validate_desccols */
311: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'MTL_SERIAL_NUMBERS', values_or_ids => 'I', validation_date => SYSDATE) THEN
312: IF g_debug = 1 THEN
313: print_debug('Value set validation successful');
314: END IF;
315: ELSE

Line 359: UPDATE mtl_serial_numbers

355: print_debug('updating MSN with attributes');
356: print_debug('item_id = ' ||p_inventory_item_id||', serial_number = ' ||p_serial_number);
357: END IF;
358:
359: UPDATE mtl_serial_numbers
360: SET
361: attribute_category = l_default_attr_category
362: , attribute1 = DECODE(l_inv_attributes_tbl(1), g_miss_char, NULL, NULL, attribute1, l_inv_attributes_tbl(1))
363: , attribute2 = DECODE(l_inv_attributes_tbl(2), g_miss_char, NULL, NULL, attribute2, l_inv_attributes_tbl(2))