SQL-001: Fetch next manual class paragraph number token¶
This document records the SQL used by clsManualClassParagraph in SAIF.Business.Policy.Rating.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-001 |
| Operation type | Sequence |
| Execution method | Data portal — criteria SQL |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsManualClassParagraph |
| Criteria property | CreateSQL |
| Lifecycle method | BeforeCreate / AfterCreate |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
— |
Input | Not specified | not specified | Bound parameter. |
Tables¶
| Table | Access | Columns used |
|---|---|---|
| DUAL | SEQUENCE | See sample SQL and source for column usage. |
Sample SQL¶
[!WARNING] Source uses the placeholder token
PARAGRAPH_NUM_NEXTVALrather than valid OracleNEXTVALsyntax.Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.
Sources¶
Business\SAIF.Business.Policy.Rating\clsManualClassParagraph.vb:355-360