# `Sp_quoquotation_SubmitUndo` (procedure)

> @author:zhucx 
		     @date: 
				 @describe:


- **Type:** PROCEDURE
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sProInParam` | `varchar(10000)` |
| 2 | IN | `sMakePerson` | `varchar(100)` |
| 3 | IN | `sBrId` | `varchar(100)` |
| 4 | IN | `sSuId` | `varchar(100)` |
| 5 | OUT | `sReturn` | `varchar(1000)` |
| 6 | OUT | `sCode` | `int` |

## Body

_Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURE `Sp_quoquotation_SubmitUndo`'`._

## Narrative

**Business context:** 销售管理 → 报价&估计管理 → 报价单 (quoquotationmaster) — toolbar button "撤回送审/Withdraw" that reverses `Sp_quoquotation_Submit` by clearing `bSubmit=0, tSubmit=SYSDATE()`, returning the quote to the editable pre-submission state.

**What it does:** Validates `sProInParam` length, then iterates `$.params[*].value[*].sId` and runs `UPDATE quoquotationmaster SET bSubmit=0, tSubmit=SYSDATE() WHERE sId=p_sId AND sBrandsId=sBrId AND sSubsidiaryId=sSuId`. No further side-effects.

**Invocation:** Standard generic-dispatch button handler dispatched by `GenericProcedureCallServiceImpl.doGenericProcedureCall()` (POST `/procedureCall/doGenericProcedureCall`) when the 报价单 grid's 撤回送审 button is clicked. No `gdsmodule` hook or DB-side binding.