APPS.GML_MOBILE_RECEIPT dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 308: -- This api creates a record in the MTL_TRANSACTION_LOTS_INTERFACE

304:
305: END Get_Location_Lov;
306:
307:
308: -- This api creates a record in the MTL_TRANSACTION_LOTS_INTERFACE
309: -- It checks if the p_transaction_temp_id is null, if it is, then it
310: -- generates a new id and returns that.
311: PROCEDURE insert_lot(
312: p_transaction_interface_id IN OUT NOCOPY NUMBER

Line 340: FROM mtl_transaction_lots_interface

336: IF p_transaction_interface_id IS NOT NULL THEN
337: BEGIN
338: SELECT 1
339: INTO l_lot_count
340: FROM mtl_transaction_lots_interface
341: WHERE transaction_interface_id = p_transaction_interface_id
342: AND Ltrim(Rtrim(lot_number)) = Ltrim(Rtrim(p_lot_number))
343: AND Ltrim(Rtrim(sublot_num)) = Ltrim(Rtrim(p_sublot_number))
344: AND ROWNUM = 1;

Line 354: UPDATE mtl_transaction_lots_interface

350: END;
351:
352:
353: IF l_lot_count = 1 THEN
354: UPDATE mtl_transaction_lots_interface
355: SET transaction_quantity = transaction_quantity + p_transaction_qty
356: , primary_quantity = primary_quantity + p_primary_qty
357: , reason_code = p_reason_code
358: WHERE transaction_interface_id = p_transaction_interface_id

Line 382: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE (

378: INTO p_product_transaction_id
379: FROM sys.dual;
380: END IF;
381:
382: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE (
383: transaction_interface_id
384: , last_update_date
385: , last_updated_by
386: , creation_date