APPS.INV_TRANSACTIONS dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 144: --INSERTING VALUES INTO MTL_TRANSACTION_LOTS_INTERFACE

140: p_serial_number_control_code IN NUMBER)
141:
142: IS
143: BEGIN
144: --INSERTING VALUES INTO MTL_TRANSACTION_LOTS_INTERFACE
145:
146: IF p_serial_number_control_code <>1 AND p_serial_number_control_code <>6 THEN
147:
148: Insert into MTL_TRANSACTION_LOTS_INTERFACE

Line 148: Insert into MTL_TRANSACTION_LOTS_INTERFACE

144: --INSERTING VALUES INTO MTL_TRANSACTION_LOTS_INTERFACE
145:
146: IF p_serial_number_control_code <>1 AND p_serial_number_control_code <>6 THEN
147:
148: Insert into MTL_TRANSACTION_LOTS_INTERFACE
149: (
150: transaction_interface_id,
151: Source_Code,
152: Source_Line_Id,

Line 176: Insert into MTL_TRANSACTION_LOTS_INTERFACE

172: p_Transaction_Quantity,
173: G_Serial_Id
174: );
175: ELSE
176: Insert into MTL_TRANSACTION_LOTS_INTERFACE
177: (
178: transaction_interface_id,
179: Source_Code,
180: Source_Line_Id,

Line 540: UPDATE MTL_TRANSACTION_LOTS_INTERFACE SET

536: IF (p_transaction_action_id = 2 or p_transaction_action_id =3
537: or p_transaction_action_id = 1) AND
538: (p_serial_number_control_code <>1 AND p_serial_number_control_code <>6) THEN
539:
540: UPDATE MTL_TRANSACTION_LOTS_INTERFACE SET
541: transaction_quantity = p_txn_qty
542: WHERE Transaction_Interface_Id = G_Interface_Id;
543:
544: END IF;

Line 602: --update MTL_TRANSACTION_LOTS_INTERFACE table

598: x_lot_done,
599: x_Status,
600: x_Message);
601:
602: --update MTL_TRANSACTION_LOTS_INTERFACE table
603: IF x_Status = 'C' THEN
604:
605: UPDATE MTL_TRANSACTION_LOTS_INTERFACE SET
606: transaction_quantity = p_current_lot_qty

Line 605: UPDATE MTL_TRANSACTION_LOTS_INTERFACE SET

601:
602: --update MTL_TRANSACTION_LOTS_INTERFACE table
603: IF x_Status = 'C' THEN
604:
605: UPDATE MTL_TRANSACTION_LOTS_INTERFACE SET
606: transaction_quantity = p_current_lot_qty
607: WHERE Transaction_Interface_Id = G_Interface_Id
608: AND Lot_Number = p_Lot_Number;
609: END IF;