125: -- Procecure : CREATE_UPDATE_VEHICLE_TYPE (public API)
126: -- Purpose : Create or update a Vehicle Type
127: -- 1) Insert/Update FTE_VEHICLE_TYPES
128: -- 2) Insert/Update/Delete FTE_VEHICLE_FEATURES
129: -- 3) Call INV_ITEM_GRP.CREATE_ITEM/UPDATE_ITEM
130: -- to create/update an inventory master item
131:
132: PROCEDURE CREATE_UPDATE_VEHICLE_TYPE
133: (
184: x_error_table OUT NOCOPY STRINGARRAY,
185: x_vehicle_type_id OUT NOCOPY NUMBER
186: )
187: IS
188: newItem INV_ITEM_GRP.Item_rec_type;
189: savedItem INV_ITEM_GRP.Item_rec_type;
190: errorTable INV_ITEM_GRP.Error_tbl_type;
191: errorRec INV_ITEM_GRP.Error_rec_type;
192: i NUMBER := 0;
185: x_vehicle_type_id OUT NOCOPY NUMBER
186: )
187: IS
188: newItem INV_ITEM_GRP.Item_rec_type;
189: savedItem INV_ITEM_GRP.Item_rec_type;
190: errorTable INV_ITEM_GRP.Error_tbl_type;
191: errorRec INV_ITEM_GRP.Error_rec_type;
192: i NUMBER := 0;
193:
186: )
187: IS
188: newItem INV_ITEM_GRP.Item_rec_type;
189: savedItem INV_ITEM_GRP.Item_rec_type;
190: errorTable INV_ITEM_GRP.Error_tbl_type;
191: errorRec INV_ITEM_GRP.Error_rec_type;
192: i NUMBER := 0;
193:
194: --l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
187: IS
188: newItem INV_ITEM_GRP.Item_rec_type;
189: savedItem INV_ITEM_GRP.Item_rec_type;
190: errorTable INV_ITEM_GRP.Error_tbl_type;
191: errorRec INV_ITEM_GRP.Error_rec_type;
192: i NUMBER := 0;
193:
194: --l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
195: l_debug_on CONSTANT BOOLEAN := TRUE;
303:
304: IF l_debug_on THEN
305: WSH_DEBUG_SV.LOGMSG(l_module_name, 'BeforeCreate');
306: END IF;
307: INV_ITEM_GRP.Create_Item(p_Item_rec => newItem,
308: x_Item_rec => savedItem,
309: x_return_status => x_return_status,
310: x_Error_tbl => errorTable);
311: IF l_debug_on THEN
364: IF l_debug_on THEN
365: WSH_DEBUG_SV.LOGMSG(l_module_name, 'BeforeUpdate');
366: END IF;
367: newItem.INVENTORY_ITEM_ID := p_inventory_item_id;
368: INV_ITEM_GRP.Update_Item(p_Item_rec => newItem,
369: x_Item_rec => savedItem,
370: x_return_status => x_return_status,
371: x_Error_tbl => errorTable);
372: IF l_debug_on THEN