[Home] [Help]
492: */
493:
494: SELECT mtl_material_transactions_s.nextval
495: INTO l_lot_set_id
496: FROM dual;
497:
498: IF l_lot_quantity <> -1 THEN
499: IF l_debug_level > 0 THEN
500: oe_debug_pub.add(' Lot number => ' || l_lot , 5 ) ;
566: l_short_quantity := l_short_quantity - l_lot_quantity ;
567: l_qty_to_be_reserved := l_lot_quantity;
568: END IF;
569:
570: -- dual uom2 can not be changed INVCONV
571:
572: l_short_quantity2 := l_short_quantity2 - nvl(l_lot_quantity2,0);
573: l_add_to_shipped2 := l_add_to_shipped2 + nvl(l_lot_quantity2,0);
574: l_qty2_to_be_reserved := l_lot_quantity2; -- INVCONV
982:
983:
984: /* SELECT oe_transactions_iface_s.nextval
985: INTO l_source_line_id
986: FROM dual; */
987:
988: -- Change for #2736818
989: l_source_line_id := p_line_rec.line_id; -- Sales Order Line ID
990: l_lot_set_id := p_transaction_header_id;
1055: THEN
1056:
1057: SELECT mtl_material_transactions_s.nextval
1058: INTO l_serial_set_id
1059: FROM dual;
1060:
1061: DECLARE
1062: --modified the following cursor for bug 6012741
1063: CURSOR get_received_serial_number IS
1134: oe_debug_pub.add( 'in for loop s.n control code = 6' , 1 ) ;
1135: END IF;
1136: SELECT to_char(oe_mtl_sn_interface_s.nextval)
1137: INTO v_serial_number_temp
1138: FROM dual ;
1139: IF p_as_alpha_prefix is not null THEN
1140: v_serial_number := p_as_alpha_prefix || v_serial_number_temp;
1141: ELSE
1142: v_serial_number := v_serial_number_temp;