DBA Data[Home] [Help]

APPS.INVUPDAT dependencies on INVPUTLI

Line 44: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452

40: = 'Y'
41: and input_status = MTL_SYSTEM_ITEMS.inventory_item_status_code
42: for update of last_update_date NOWAIT;
43:
44: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
45: BEGIN
46:
47: OPEN lock_records;
48: FETCH lock_records into lock_variable;

Line 54: INVPUTLI.info('inside ');

50: /* Update the relevant attribute in the item master for all *
51: * items which match the update criteria. *
52: * while making sure that no interdependencies are violated */
53: IF l_inv_debug_level IN(101, 102) THEN
54: INVPUTLI.info('inside ');
55: END IF;
56:
57: FOR status_cursor_row in status_cursor(input_status) LOOP
58: IF l_inv_debug_level IN(101, 102) THEN

Line 59: INVPUTLI.info('inside for IISC ' || status_cursor_row.IISC);

55: END IF;
56:
57: FOR status_cursor_row in status_cursor(input_status) LOOP
58: IF l_inv_debug_level IN(101, 102) THEN
59: INVPUTLI.info('inside for IISC ' || status_cursor_row.IISC);
60: INVPUTLI.info('current attribute is ' ||current_attribute_name );
61: END IF;
62: if ( current_attribute_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG') then
63: update mtl_system_items msi

Line 60: INVPUTLI.info('current attribute is ' ||current_attribute_name );

56:
57: FOR status_cursor_row in status_cursor(input_status) LOOP
58: IF l_inv_debug_level IN(101, 102) THEN
59: INVPUTLI.info('inside for IISC ' || status_cursor_row.IISC);
60: INVPUTLI.info('current attribute is ' ||current_attribute_name );
61: END IF;
62: if ( current_attribute_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG') then
63: update mtl_system_items msi
64: set msi.stock_enabled_flag