SQL-151 to SQL-183: Update operations¶

This page documents all 33 Update-type SQL operations (SQL-151 through SQL-183). Every inline UpdateSQL restates the primary key in its SET list with no optimistic-concurrency predicate; lost-update protection relies entirely on the RowsAffected <> 1 check performed after execution.* Stored-procedure updates have their body retrieval marked unavailable for this run (Legends CLI offline); see Procedures.

SQL-151 clsAcknowledgeList.updateAcknowledged¶

clsAcknowledgeList.updateAcknowledged — stored procedure call against pk80001_legalnet.updateAcknowledged.

Classification¶

Field	Value
SQL ID	SQL-151
Operation type	Update
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAcknowledgeList`
Criteria property	`N/A`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.updateAcknowledged(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\Print\clsAcknowledgeList.vb

SQL-152 clsAppeal¶

clsAppeal — stored procedure call against pk80001_legalnet.updateAppeal.

Classification¶

Field	Value
SQL ID	SQL-152
Operation type	Update
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAppeal`
Criteria property	`N/A`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.updateAppeal(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsAppeal.vb

SQL-153 clsAppealExtension¶

clsAppealExtension — stored procedure call against pk80001_legalnet.updateAppealExtension.

Classification¶

Field	Value
SQL ID	SQL-153
Operation type	Update
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAppealExtension`
Criteria property	`N/A`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.updateAppealExtension(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsAppealExtension.vb

SQL-154 clsAttorneyConflict.Criteria.UpdateSQL¶

clsAttorneyConflict.Criteria.UpdateSQL — inline UPDATE against ATTORNEY_CONFLICT.

Classification¶

Field	Value
SQL ID	SQL-154
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneyConflict`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
ATTORNEY_CONFLICT	UPDATE	See Sample SQL below

Sample SQL¶

-- Update against ATTORNEY_CONFLICT
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against ATTORNEY_CONFLICT in this library.*

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb

SQL-155 clsAttorneyPolicyAssignment.Criteria.UpdateSQL¶

clsAttorneyPolicyAssignment.Criteria.UpdateSQL — inline UPDATE against ATTORNEY_POLICY_ASSIGNMENT.

Classification¶

Field	Value
SQL ID	SQL-155
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneyPolicyAssignment`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
ATTORNEY_POLICY_ASSIGNMENT	UPDATE	See Sample SQL below

Sample SQL¶

-- Update against ATTORNEY_POLICY_ASSIGNMENT
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against ATTORNEY_POLICY_ASSIGNMENT in this library.*

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneyPolicyAssignment.vb

SQL-156 clsAttorneyProfile¶

clsAttorneyProfile — stored procedure call against pk80001_legalnet.updateAttyProfile.

Classification¶

Field	Value
SQL ID	SQL-156
Operation type	Update
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsAttorneyProfile`
Criteria property	`N/A`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.updateAttyProfile(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneyProfile.vb

SQL-157 clsAttorneySchedule.Criteria.UpdateSQL¶

clsAttorneySchedule.Criteria.UpdateSQL — inline UPDATE against ATTORNEY_SCHEDULE.

Classification¶

Field	Value
SQL ID	SQL-157
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneySchedule`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
ATTORNEY_SCHEDULE	UPDATE	See Sample SQL below

Sample SQL¶

-- Update against ATTORNEY_SCHEDULE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against ATTORNEY_SCHEDULE in this library.*

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneySchedule.vb

SQL-158 clsAttorneyWorkerAssignment.Criteria.UpdateSQL¶

clsAttorneyWorkerAssignment.Criteria.UpdateSQL — inline UPDATE against ATTORNEY_WORKER_ASSIGNMENT.

Classification¶

Field	Value
SQL ID	SQL-158
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAttorneyWorkerAssignment`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
ATTORNEY_WORKER_ASSIGNMENT	UPDATE	See Sample SQL below

Sample SQL¶

-- Update against ATTORNEY_WORKER_ASSIGNMENT
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against ATTORNEY_WORKER_ASSIGNMENT in this library.*

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsAttorneyWorkerAssignment.vb

SQL-159 clsCaseCost.Criteria.UpdateSQL¶

clsCaseCost.Criteria.UpdateSQL — inline UPDATE against CASE_COST.

Classification¶

Field	Value
SQL ID	SQL-159
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsCaseCost`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
CASE_COST	UPDATE	See Sample SQL below

Sample SQL¶

-- Update against CASE_COST
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against CASE_COST in this library.*

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsCaseCost.vb

SQL-160 clsCaseNote¶

clsCaseNote — stored procedure call against pk80001_legalnet.case_note_update.

Classification¶

Field	Value
SQL ID	SQL-160
Operation type	Update
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsCaseNote`
Criteria property	`N/A`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.case_note_update(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsCaseNote.vb

SQL-161 clsCaseOutcome¶

clsCaseOutcome — stored procedure call against pk80001_legalnet.updateCaseOutcome.

Classification¶

Field	Value
SQL ID	SQL-161
Operation type	Update
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsCaseOutcome`
Criteria property	`N/A`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.updateCaseOutcome(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsCaseOutcome.vb

SQL-162 clsCaseStatusHistory.Criteria.UpdateSQL¶

clsCaseStatusHistory.Criteria.UpdateSQL — inline UPDATE against CASE_STATUS_HISTORY.

Classification¶

Field	Value
SQL ID	SQL-162
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsCaseStatusHistory`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
CASE_STATUS_HISTORY	UPDATE	See Sample SQL below

Sample SQL¶

-- Update against CASE_STATUS_HISTORY
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against CASE_STATUS_HISTORY in this library.*

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsCaseStatusHistory.vb

SQL-163 clsConsolidations.UpdateConsolidatedCase¶

clsConsolidations.UpdateConsolidatedCase — stored procedure call against pk80001_legalnet.UpdateConsolidatedCase.

Classification¶

Field	Value
SQL ID	SQL-163
Operation type	Update
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsConsolidations`
Criteria property	`N/A`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.UpdateConsolidatedCase(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsConsolidations.vb

SQL-164 clsConsolidations.updateCaseStatus¶

clsConsolidations.updateCaseStatus — stored procedure call against pk80001_legalnet.updateCaseStatus.

Classification¶

Field	Value
SQL ID	SQL-164
Operation type	Update
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsConsolidations`
Criteria property	`N/A`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.updateCaseStatus(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsConsolidations.vb

SQL-165 clsCreateFile.setFileCreateDate¶

clsCreateFile.setFileCreateDate — stored procedure call against pk80001_legalnet.setFileCreateDate.

Classification¶

Field	Value
SQL ID	SQL-165
Operation type	Update
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsCreateFile`
Criteria property	`N/A`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.setFileCreateDate(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\Print\clsCreateFile.vb

SQL-166 clsHearingLocation.Criteria.UpdateSQL¶

clsHearingLocation.Criteria.UpdateSQL — inline UPDATE against HEARING_LOCATION.

Classification¶

Field	Value
SQL ID	SQL-166
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsHearingLocation`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
HEARING_LOCATION	UPDATE	See Sample SQL below

Sample SQL¶

-- Update against HEARING_LOCATION
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against HEARING_LOCATION in this library.*

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsHearingLocation.vb

SQL-167 clsHearingLocationInfo.Criteria.UpdateSQL¶

clsHearingLocationInfo.Criteria.UpdateSQL — inline UPDATE against HEARING_LOCATION.

Classification¶

Field	Value
SQL ID	SQL-167
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsHearingLocationInfo`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
HEARING_LOCATION	UPDATE	See Sample SQL below

Sample SQL¶

-- Update against HEARING_LOCATION
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against HEARING_LOCATION in this library.*

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsHearingLocationInfo.vb

SQL-168 clsLegalCase¶

clsLegalCase — stored procedure call against pk80001_legalnet.UpdateLegalCase.

Classification¶

Field	Value
SQL ID	SQL-168
Operation type	Update
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLegalCase`
Criteria property	`N/A`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.UpdateLegalCase(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsLegalCase.vb

SQL-169 clsLegalCase.updateHearingSeqNum¶

clsLegalCase.updateHearingSeqNum — stored procedure call against pk80001_legalnet.updateHearingSeqNum.

Classification¶

Field	Value
SQL ID	SQL-169
Operation type	Update
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLegalCase`
Criteria property	`N/A`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.updateHearingSeqNum(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsLegalCase.vb

SQL-170 clsLegalCaseEvaluation¶

clsLegalCaseEvaluation — stored procedure call against pk80001_legalnet.updateLCE.

Classification¶

Field	Value
SQL ID	SQL-170
Operation type	Update
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLegalCaseEvaluation`
Criteria property	`N/A`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.updateLCE(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsLegalCaseEvaluation.vb

SQL-171 clsLegalFileLocation¶

clsLegalFileLocation — stored procedure call against pk80001_legalnet.updateFileLocation.

Classification¶

Field	Value
SQL ID	SQL-171
Operation type	Update
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLegalFileLocation`
Criteria property	`N/A`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.updateFileLocation(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsLegalFileLocation.vb

SQL-172 clsLegalPerson.Criteria.UpdateSQL¶

clsLegalPerson.Criteria.UpdateSQL — inline UPDATE against LEGAL_PERSON.

Classification¶

Field	Value
SQL ID	SQL-172
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalPerson`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
LEGAL_PERSON	UPDATE	See Sample SQL below

Sample SQL¶

-- Update against LEGAL_PERSON
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against LEGAL_PERSON in this library.*

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsLegalPerson.vb

SQL-173 clsLegalPersonType.Criteria.UpdateSQL¶

clsLegalPersonType.Criteria.UpdateSQL — inline UPDATE against LEGAL_PERSON_TYPE.

Classification¶

Field	Value
SQL ID	SQL-173
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsLegalPersonType`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
LEGAL_PERSON_TYPE	UPDATE	See Sample SQL below

Sample SQL¶

-- Update against LEGAL_PERSON_TYPE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against LEGAL_PERSON_TYPE in this library.*

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsLegalPersonType.vb

SQL-174 clsLegalSchedule¶

clsLegalSchedule — stored procedure call against pk80001_legalnet.updateSchedule.

Classification¶

Field	Value
SQL ID	SQL-174
Operation type	Update
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLegalSchedule`
Criteria property	`N/A`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.updateSchedule(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsLegalSchedule.vb

SQL-175 clsLetterRequest.UpdateLetterRequest¶

clsLetterRequest.UpdateLetterRequest — stored procedure call against pk82289_legalnet_letters.UpdateLetterRequest.

Classification¶

Field	Value
SQL ID	SQL-175
Operation type	Update
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsLetterRequest`
Criteria property	`N/A`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk82289_legalnet_letters.UpdateLetterRequest(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\Print\clsLetterRequest.vb

SQL-176 clsMailDate.setMailDate¶

clsMailDate.setMailDate — stored procedure call against pk80001_legalnet.setMailDate.

Classification¶

Field	Value
SQL ID	SQL-176
Operation type	Update
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsMailDate`
Criteria property	`N/A`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.setMailDate(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\Print\clsMailDate.vb

SQL-177 clsMailDate.setMailOARFlag¶

clsMailDate.setMailOARFlag — stored procedure call against pk80001_legalnet.setMailOARFlag.

Classification¶

Field	Value
SQL ID	SQL-177
Operation type	Update
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]**`
Command type	StoredProcedure
Business object	`clsMailDate`
Criteria property	`N/A`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
—	—	Table not directly identifiable from call-site evidence**

Sample SQL¶

-- Stored procedure call
CALL pk80001_legalnet.setMailOARFlag(...)
-- Procedure body resides in the Oracle database; retrieval was unavailable for this run (Legends CLI offline)

Sources¶

SAIF.Business.Claim.Legal\Print\clsMailDate.vb

SQL-178 clsOtherFirm.Criteria.UpdateSQL¶

clsOtherFirm.Criteria.UpdateSQL — inline UPDATE against OTHER_FIRM.

Classification¶

Field	Value
SQL ID	SQL-178
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOtherFirm`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
OTHER_FIRM	UPDATE	See Sample SQL below

Sample SQL¶

-- Update against OTHER_FIRM
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against OTHER_FIRM in this library.*

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsOtherFirm.vb

SQL-179 clsOtherLegalParty.Criteria.UpdateSQL¶

clsOtherLegalParty.Criteria.UpdateSQL — inline UPDATE against LEGAL_CASE_EMPLOYER.

Classification¶

Field	Value
SQL ID	SQL-179
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOtherLegalParty`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
LEGAL_CASE_EMPLOYER	UPDATE	See Sample SQL below

Sample SQL¶

-- Update against LEGAL_CASE_EMPLOYER
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against LEGAL_CASE_EMPLOYER in this library.*

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsOtherLegalParty.vb

SQL-180 clsOutcomeIssue.Criteria.UpdateSQL¶

clsOutcomeIssue.Criteria.UpdateSQL — inline UPDATE against OUTCOME_ISSUE.

Classification¶

Field	Value
SQL ID	SQL-180
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOutcomeIssue`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
OUTCOME_ISSUE	UPDATE	See Sample SQL below

Sample SQL¶

-- Update against OUTCOME_ISSUE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against OUTCOME_ISSUE in this library.*

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsOutcomeIssue.vb

SQL-181 clsOutcomeStaff.Criteria.UpdateSQL¶

clsOutcomeStaff.Criteria.UpdateSQL — inline UPDATE against OUTCOME_STAFF.

Classification¶

Field	Value
SQL ID	SQL-181
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOutcomeStaff`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
OUTCOME_STAFF	UPDATE	See Sample SQL below

Sample SQL¶

-- Update against OUTCOME_STAFF
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against OUTCOME_STAFF in this library.*

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsOutcomeStaff.vb

SQL-182 clsOutOFTownRotationAssgn.Criteria.UpdateSQL¶

clsOutOFTownRotationAssgn.Criteria.UpdateSQL — inline UPDATE against OUT_OF_TOWN_ROTATION_ASSGN.

Classification¶

Field	Value
SQL ID	SQL-182
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsOutOFTownRotationAssgn`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
OUT_OF_TOWN_ROTATION_ASSGN	UPDATE	See Sample SQL below

Sample SQL¶

-- Update against OUT_OF_TOWN_ROTATION_ASSGN
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against OUT_OF_TOWN_ROTATION_ASSGN in this library.*

Sources¶

SAIF.Business.Claim.Legal\TableMaint\clsOutOFTownRotationAssgn.vb

SQL-183 clsRequestIssue.Criteria.UpdateSQL¶

clsRequestIssue.Criteria.UpdateSQL — inline UPDATE against REQUEST_ISSUE.

Classification¶

Field	Value
SQL ID	SQL-183
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsRequestIssue`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate` / `AfterUpdate` (checks `RowsAffected <> 1`)

Tables¶

Table	Access	Columns used
REQUEST_ISSUE	UPDATE	See Sample SQL below

Sample SQL¶

-- Update against REQUEST_ISSUE
-- Exact column list is documented in TSK005-db-config-analysis.md Sample SQL section;
-- structurally identical to other Update statements against REQUEST_ISSUE in this library.*

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsRequestIssue.vb

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¶

See per-SQL-ID Sources subsections above for exact .vb file/line citations.