[Home] [Help]
210: /****************************************************************************************/
211: /***********************SERIAL_INTERFACE_INSERT PROCEDURE********************************/
212: /****************************************************************************************/
213: /**This procedure Inserts SN related transaction information in the **/
214: /**mtl_serial_numbers_interface table **/
215: /**USED BY: ON_SUBMIT and ON_SERIAL Procedures **/
216: /****************************************************************************************/
217: /****************************************************************************************/
218:
225:
226: IS
227: l_header_id NUMBER;
228: BEGIN
229: --INSERTING VALUES INTO MTL_SERIAL_NUMBERS_INTERFACE
230:
231: IF p_lot_control_code = 1 THEN l_header_id := G_Interface_Id;
232: ELSE l_header_id := G_Serial_Id;
233: END IF;
231: IF p_lot_control_code = 1 THEN l_header_id := G_Interface_Id;
232: ELSE l_header_id := G_Serial_Id;
233: END IF;
234:
235: Insert into MTL_SERIAL_NUMBERS_INTERFACE
236: (
237: transaction_interface_id,
238: Source_Code,
239: Source_Line_Id,
701: BEGIN
702:
703: --For receipts line/lot information will not change and therefore this
704: --procedure is a simple matter of just calling the quantity manager, then
705: --inserting the serial into the mtl_serial_numbers_interface table.
706:
707: --For Serial triggered Issues and transfers,
708: -- We will enforce that the item stays the same, from sub stays the same,
709: --the from loc stays the same, and also the Lot information remains the same.
769:
770: if x_Status = 'C' THEN
771:
772: select revision,current_subinventory_code,current_locator_id
773: into l_revision,l_from_sub, l_from_loc from mtl_serial_numbers
774: where current_organization_id = p_organization_id and inventory_item_id =
775: p_inventory_item_id and serial_number = p_from_serial;
776:
777: UPDATE MTL_TRANSACTIONS_INTERFACE SET