# `Sp_Quotation_CalcDataPackStd` (procedure) - **Type:** PROCEDURE - **Deterministic:** NO - **SQL data access:** CONTAINS SQL ## Parameters | # | Mode | Name | Type | |---|---|---|---| | 1 | IN | `sGuid` | `varchar(100)` | | 2 | IN | `bChangeRate` | `int` | | 3 | IN | `sLoginId` | `varchar(100)` | | 4 | IN | `sBrId` | `varchar(100)` | | 5 | IN | `sSuId` | `varchar(100)` | | 6 | OUT | `sCode` | `int` | | 7 | OUT | `sReturn` | `varchar(5000)` | ## Body _Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURE `Sp_Quotation_CalcDataPackStd`'`._ ## Narrative **Business context:** 销售管理 → 销售单据 — standard packaging-quotation price calculator. The packaging variant of `Sp_Quotation_CalcDataStd`: same staging-table contract (`QuoQuotationmaster_Tmp` / slave / control / material / process / param), additional 包装控件 (pack-control) tables, and adjustments for multi-product packs. **What it does:** Walks slave/control/material/process/print-process cursors against the Quo*_Tmp staging set. Reads element rates from `eleproduct`, `EleMaterials`, `EleProcess`, applies form-level overrides from `sysformsetting`, system toggles from `SysSystemSettings`, and constants via `Sp_Sis_GetConst`/`Sp_System_ReplaceField`. Writes the computed per-row money/qty into `QuoQuotationMaterials_Tmp`, `QuoQuotationProcess_Tmp`, `QuoQuotationControl_Tmp`, `QuoQuotationSlave_Tmp`; rolls up totals into `quoquotationmaster_tmp`. Includes a pack-rate handling block (`p_bRateTransformSet`) absent from `_CalcDataStd`. **Invocation:** Registered in `CaclProNameEnum.SP_QUOTATION_PACKSTD`/`SP_QUOTATION_CALCDATASETSTD` family. Dispatched by `BusinessBaseServiceImpl` when a form's `gdsmodule.sCalcProName='Sp_Quotation_CalcDataPackStd'`. No current `sCalcProName` row binds to this name — the live pack-quote form (新报价单, `101251240115016076506222050`) routes through `Sp_Quotation_CalcDataPack`, which calls this proc indirectly via `workOrderCalcDataPackService.doCalcDataPackStd`. Install: `script/标版/30100101/Sp_Quotation_CalcDataPackStd.sql`.