取消采购订单行SQL

PO_DOCUMENT_CONTROL_PUB.CONTROL_DOCUMENT(P_API_VERSION      => 1.0

                                             , --版本信息，目前为1.0

                                              P_INIT_MSG_LIST    => 'T'

                                             ,P_COMMIT           => 'T'

                                             ,X_RETURN_STATUS    => X_RETURN_STATUS

                                             , -- 返回接口运行结果，S为成功，E为错误，U为未知错误

                                             P_DOC_TYPE         => 'PO'

                                             ,P_DOC_SUBTYPE      => 'STANDARD'

                                             , -- 取消标准PO

                                              P_DOC_ID           => v1.po_header_id

                                             ,P_DOC_NUM          => NULL

                                             , -- Po_header_id和单据编码任选一个参数即可

                                             P_RELEASE_ID       => NULL

                                             ,P_RELEASE_NUM      => NULL

                                             ,P_DOC_LINE_ID      => v1.po_line_id

                                             ,P_DOC_LINE_NUM     => NULL

                                             ,P_DOC_LINE_LOC_ID  => v1.line_location_id  --po_line_location_id

                                             ,P_DOC_SHIPMENT_NUM => NULL

                                             ,P_ACTION           => 'CANCEL'

                                             , --固定值

                                             P_ACTION_DATE      => NULL

                                             ,P_CANCEL_REASON    => NULL

                                             , --Cancel原因

                                             P_CANCEL_REQS_FLAG => NULL

                                             ,P_PRINT_FLAG       => NULL

                                             ,P_NOTE_TO_VENDOR   => NULL

                                             ,P_USE_GLDATE       => 'N');