2867: IF (l_debug = 1) THEN
2868: print_debug('EXPLODE_LPN - Case for explosion without LPN_GROUP_ID. Updating for RTI: '||l_lpn_grp_null.interface_transaction_id,1);
2869: END IF;
2870:
2871: SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL
2872: INTO l_lpn_grp_id
2873: FROM DUAL;
2874:
2875: UPDATE rcv_transactions_interface
2950: IF (l_debug = 1) THEN
2951: print_debug('EXPLODE_LPN - SHIP Updating lpn_group for SHIPMENT: '||l_asn_lpn_grp_null.shipment_num,1);
2952: END IF;
2953:
2954: SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL
2955: INTO l_lpn_grp_id
2956: FROM DUAL;
2957:
2958: UPDATE rcv_transactions_interface