SQL-080: Pk82033_ThirdParty.thrdparty_firm_update

This SQL artifact supports Criteria by executing a update operation through StoredProc.

Classification

Field	Value
SQL ID	SQL-080
Operation type	Update
Execution method	StoredProc
Database	Oracle
Schema	[unqualified]**
Command type	StoredProcedure
Business object	Criteria
Criteria property	updatesql
Lifecycle method	Criteria update

Parameters

Parameter	Direction	Type	Max length	Description
:AdjusterName	Input	String	80	Source value AdjusterName
:AttorneyName	Input	String	80	Source value AttorneyName
:CompanySeqNum	Input	Number	N/A	Source value CompanySeqNum
:ContactName	Input	String	80	Source value ContactName
:FirmSeqNum	Input	Number	N/A	Source value ThrdpartyFirmSeqNum
:CompanyName	Input	String	100	Source value "Will be Deleted"
:CompanyName	Input	String	100	Source value CompanyName
:CompanyShortDescr	Input	Unknown	10	Source value CompanyShortDescr
:TaxID	Input	Number	11	Source value TaxID
:AddressCode	Input	String	5	Source value AddressCode
:AddressLine1	Input	Unknown	40	Source value AddressLine1
:AddressLine2	Input	Unknown	40	Source value AddressLine2
:AddressLine3	Input	Unknown	40	Source value AddressLine3
:AddressLine4	Input	Unknown	40	Source value AddressLine4
:AddressSeqNum	Input	Number	N/A	Source value AddressSeqNum
:CityName	Input	String	30	Source value CityName
:CountryCode	Input	String	5	Source value CountryCode
:UpdateUser	Input	Date	30	Source value MyCriteria.DataPortalInfo.UserID
:UpdateNum	Input	Date	N/A	Source value UpdateNum
:ForeignAddressFlag	Input	String	1	Source value m_ForeignAddressFlag
:ForeignPostalCode	Input	String	15	Source value ForeignPostalCode
:inState	Input	Unknown	2	Source value State
:ZipCode	Input	String	5	Source value ZipCode
:ZipCodeExt	Input	String	4	Source value ZipCodeExt
:PhoneSeqNum	Input	Number	N/A	Source value PhoneSeqNum
:PhoneNum	Input	Number	25	Source value PhoneNum.Trim
:PhoneNum	Input	Number	25	Source value DbType.String

Tables

Table	Access	Columns used
dual	UPDATE	See sample SQL.
company_phone	UPDATE	See sample SQL.
phone	UPDATE	See sample SQL.
v_phone_seq	UPDATE	See sample SQL.
v_fax_seq	UPDATE	See sample SQL.
THRDPARTY_FIRM	UPDATE	See sample SQL.
COMPANY	UPDATE	See sample SQL.
ADDRESS	UPDATE	See sample SQL.

Sample SQL

BEGIN Pk82033_ThirdParty.thrdparty_firm_update(:AdjusterName, :AttorneyName, :CompanySeqNum, :ContactName, :FirmSeqNum, :CompanyName, :CompanyName, :CompanyShortDescr, :TaxID, :AddressCode, :AddressLine1, :AddressLine2, :AddressLine3, :AddressLine4, :AddressSeqNum, :CityName, :CountryCode, :UpdateUser, :UpdateNum, :ForeignAddressFlag, :ForeignPostalCode, :inState, :ZipCode, :ZipCodeExt, :PhoneSeqNum, :PhoneNum, :PhoneNum); END;
-- Stored procedure body retrieved from Oracle package WCIS_DBA.Pk82033_ThirdParty.

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.Claim.ThirdParty\clsThrdPartyFirm.vb