[Home] [Help]
481: */
482:
483: SELECT mtl_material_transactions_s.nextval
484: INTO l_lot_set_id
485: FROM dual;
486:
487: IF l_lot_quantity <> -1 THEN
488: IF l_debug_level > 0 THEN
489: oe_debug_pub.add(' Lot number => ' || l_lot , 5 ) ;
544: l_short_quantity := l_short_quantity - l_lot_quantity ;
545: l_qty_to_be_reserved := l_lot_quantity;
546: END IF;
547:
548: -- dual uom2 can not be changed INVCONV
549:
550: l_short_quantity2 := l_short_quantity2 - nvl(l_lot_quantity2,0);
551: l_add_to_shipped2 := l_add_to_shipped2 + nvl(l_lot_quantity2,0);
552: l_qty2_to_be_reserved := l_lot_quantity2; -- INVCONV
957:
958:
959: /* SELECT oe_transactions_iface_s.nextval
960: INTO l_source_line_id
961: FROM dual; */
962:
963: -- Change for #2736818
964: l_source_line_id := p_line_rec.line_id; -- Sales Order Line ID
965: l_lot_set_id := p_transaction_header_id;
1030: THEN
1031:
1032: SELECT mtl_material_transactions_s.nextval
1033: INTO l_serial_set_id
1034: FROM dual;
1035:
1036: DECLARE
1037: --modified the following cursor for bug 6012741
1038: CURSOR get_received_serial_number IS
1109: oe_debug_pub.add( 'in for loop s.n control code = 6' , 1 ) ;
1110: END IF;
1111: SELECT to_char(oe_mtl_sn_interface_s.nextval)
1112: INTO v_serial_number_temp
1113: FROM dual ;
1114: IF p_as_alpha_prefix is not null THEN
1115: v_serial_number := p_as_alpha_prefix || v_serial_number_temp;
1116: ELSE
1117: v_serial_number := v_serial_number_temp;