SQL-020 Retrieve assigned attorney's manager email address¶
Scalar query that invokes the pk80001_LEGALNET.get_atty_mngr_email PL/SQL function via a scalar query against DUAL to look up the email address of the assigned attorney's manager, for a Defense Evaluation Form (DEF) reminder email. Invoked from clsScheduleManager.SendDEFEmail.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-020 |
| Operation type | Read |
| Execution method | Inline SQL, runtime string concatenation, scalar function call (SqlHelper.ScalarQuery(Of String)) |
| Database | Oracle |
| Command type | Text |
| Business object | N/A (Application layer) |
| Criteria property | N/A (Application layer) |
| Lifecycle method | N/A (Application layer) |
| Application class | clsScheduleManager |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
caseSeqNum |
N/A — concatenated literal, not a bind parameter* | Decimal (& caseSeqNum &) |
N/A | Case sequence number concatenated directly into the SQL text (see Sample SQL below) rather than bound via :ParamName — same pattern/caveat as SQL-019*. |
Tables¶
| Table | Access | Columns used |
|---|---|---|
| DUAL | SELECT | N/A (pseudo-table; scalar function target) |
The pk80001_LEGALNET.get_atty_mngr_email PL/SQL function body resides in the Oracle database and was not retrieved for this run (see Procedures).
Sample SQL¶
-- caseSeqNum is concatenated directly into the SQL text at runtime (not an Oracle bind variable)
SELECT pk80001_LEGALNET.get_atty_mngr_email(<caseSeqNum>)
FROM DUAL
<caseSeqNum> denotes runtime string concatenation ("select pk80001_LEGALNET.get_atty_mngr_email(" & caseSeqNum & ") from dual"), not an Oracle bind variable*. This is a PL/SQL function invoked inline within a scalar query; the function body resides in the Oracle database and was not retrieved for this run.
Operations and processes¶
Business rules¶
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¶
SAIF.Application.Claim.Legal\LegalNet\clsScheduleManager.vb