SQL-030 SP73341 external client lookup

This stored procedure call retrieves an external client email address through the Oracle lookup path when the service-team member is resolved by system user information.

Classification

Field	Value
SQL ID	SQL-030
Operation type	Read
Execution method	StoredProc
Database	Oracle
Schema	[unqualified]**
Command type	StoredProcedure
Business object	clsTeamAssignment
Criteria property	GetExternalEmailAddress
Lifecycle method	InitializeEmailAddressUsingSystemUser

Parameters

Parameter	Direction	Type	Max length	Description
:in_mailid	Input	String	8	External or system mail identifier used for lookup.
:in_last_name	Input	String	40	Last name used to refine the external client lookup.
:out_external_email	ReturnValue	String	100	External email address returned by the stored procedure.

Tables

Table	Access	Columns used
N/A — Stored procedure	SELECT	Procedure body resides in the database.

Sample SQL

-- Oracle stored procedure call (CommandType.StoredProcedure, Scalar)
-- clsTeamAssignment.InitializeEmailAddressUsingSystemUser
CALL sp73341_external_client_lookup(
  :in_mailid,
  :in_last_name,
  :out_external_email)   -- ParameterDirection.ReturnValue, max length 100

The procedure body resides in the Oracle database; it was not retrievable for this run.

Operations and processes

• Retrieve service team

Business rules

• BR-VP-022: Team member email address derivation

Sources

• SAIF.Business.View.Policy/clsTeamAssignment.vb