[Home] [Help]
2239:
2240: SELECT '1' INTO v_dummy FROM
2241: rcv_transactions_interface rti,wms_lpn_contents wlc
2242: WHERE rti.interface_transaction_id = wlc.source_header_id
2243: AND rti.processing_status_code = 'WSH_INTERFACED'
2244: AND rti.to_organization_id = wlc.organization_id
2245: AND wlc.parent_lpn_id = p_lpn_id
2246: AND ROWNUM < 2 ;
2247:
2816: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
2817: l_lpn_id NUMBER ;
2818: l_wdd_exists NUMBER ;
2819: l_return_status VARCHAR2(1);
2820: l_shipping_attr wsh_interface.changedattributetabtype;
2821: l_wsh_dd_rec WSH_Glbl_Var_Strct_GRP.Delivery_Details_Rec_Type;
2822: l_lpn_attr WMS_Data_Type_Definitions_PUB.LPNRecordType;
2823:
2824:
3008: --l_shipping_attr(1).serial_number := l_serial_number;
3009: l_shipping_attr(i).lot_number := p_wdd_table(i).lot_number;
3010: l_shipping_attr(i).transfer_lpn_id := l_lpn_id ;
3011:
3012: wsh_interface.update_shipping_attributes(
3013: p_source_code => 'INV',
3014: p_changed_attributes => l_shipping_attr,
3015: x_return_status => l_return_status);
3016:
3083:
3084: SELECT 1 INTO v_dummy
3085: FROM rcv_transactions_interface rti,wms_license_plate_numbers wlpn
3086: WHERE rti.interface_transaction_id = p_rcv_trx_interface_id
3087: AND rti.processing_status_code = 'WSH_INTERFACED'
3088: AND rti.transfer_lpn_id = wlpn.lpn_id
3089: AND wlpn.lpn_context = 5
3090: AND rti.to_organization_id = wlpn.organization_id ;
3091:
3108:
3109: UPDATE rcv_transactions_interface SET transfer_lpn_id = l_lpn_id
3110: WHERE
3111: interface_transaction_id = p_rcv_trx_interface_id
3112: AND processing_status_code = 'WSH_INTERFACED' ;
3113:
3114: EXCEPTION
3115: WHEN NO_DATA_FOUND THEN
3116: IF (l_debug = 1) THEN
3401: SELECT transfer_lpn_id,
3402: SUM(quantity) rti_qty
3403: FROM rcv_transactions_interface
3404: WHERE group_id = p_rtv_order
3405: AND PROCESSING_STATUS_CODE = 'WSH_INTERFACED'
3406: AND transfer_lpn_id IS NOT NULL
3407: GROUP BY transfer_lpn_id;
3408: CURSOR get_unpack_lpn(p_lpn_id NUMBER, p_rti_qty NUMBER)
3409: IS