DBA Data[Home] [Help]

APPS.FTE_VEHICLE_PKG dependencies on INV_ITEM_GRP

Line 129: -- 3) Call INV_ITEM_GRP.CREATE_ITEM/UPDATE_ITEM

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: (

Line 188: newItem INV_ITEM_GRP.Item_rec_type;

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;

Line 189: savedItem INV_ITEM_GRP.Item_rec_type;

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:

Line 190: errorTable INV_ITEM_GRP.Error_tbl_type;

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;

Line 191: errorRec INV_ITEM_GRP.Error_rec_type;

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;

Line 307: INV_ITEM_GRP.Create_Item(p_Item_rec => newItem,

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

Line 368: INV_ITEM_GRP.Update_Item(p_Item_rec => newItem,

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