SQL-001 pk80001_LEGALNET.insertLetterRequest¶

StoredProc (CommandType.StoredProcedure, IDataRequest via PortalRequest) for LegalManagerBase.

Classification¶

Field	Value
SQL ID	SQL-001
Operation type	Create (write)
Execution method	StoredProc (CommandType.StoredProcedure, IDataRequest via PortalRequest)
Database	Oracle
Schema	N/A
Command type	StoredProcedure
Business object	`LegalManagerBase`
Criteria property	N/A — no IBusinessCriteria
Lifecycle method	insertLetterRequest()

Parameters¶

Parameter	Direction	Type	Max length	Description
`letterTypeCode`	Input	String (VARCHAR2)	5	Letter type code identifying which LegalNet letter to generate
`aLegalCaseNum`	Input	Numeric (Decimal)	N/A	Legal case sequence number the letter request belongs to
`holdDate`	Input	DbType.Date	N/A	Hold-until date for the letter request; bound as a typed NULL date when the caller passes Date.MinValue (LegalManagerBase.vb:399-403)
`createUser`	Input	String (VARCHAR2)	30	User ID recorded as the creator of the letter request
`aClaimId`	Input	Numeric (Decimal)	N/A	Claim identifier the letter request is associated with
`requestNum`	InputOutput	Numeric (Long)	N/A	Returns the generated letter request number; read back via PortalRequest.DataRequest(0).ParmValue("requestNum")

Tables¶

Table	Access	Columns used
(procedure body opaque)	Stored procedure	N/A

Sample SQL¶

-- CommandType.StoredProcedure; procedure body resides in the Oracle database.
CALL pk80001_LEGALNET.insertLetterRequest(
  letterTypeCode => :letterTypeCode,
  aLegalCaseNum  => :aLegalCaseNum,
  holdDate       => :holdDate,
  createUser     => :createUser,
  aClaimId       => :aClaimId,
  requestNum     => :requestNum)  -- InputOutput

Operations and processes¶

Letter generation / print request (LegalManagerBase.insertLetterRequest), invoked by LegalNet letter and print workflows

Sources¶

SAIF.Application.Claim.Legal\LegalManagerBase.vb