SQL-025: Pk82033_ThirdParty.thrdparty_firm_insert

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

Classification

Field	Value
SQL ID	SQL-025
Operation type	Create
Execution method	StoredProc
Database	Oracle
Schema	[unqualified]**
Command type	StoredProcedure
Business object	Criteria
Criteria property	insertsql
Lifecycle method	Criteria create

Parameters

Parameter	Direction	Type	Max length	Description
:AdjusterName	Input	String	80	Source value AdjusterName
:AttorneyName	Input	String	80	Source value AttorneyName
:ContactName	Input	String	80	Source value ContactName
:CreateUser	Input	Number	30	Source value MyCriteria.DataPortalInfo.UserID
:CompanyCode	Input	String	5	Source value CompanyCode
: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
:CityName	Input	String	30	Source value CityName
:CountryCode	Input	String	5	Source value CountryCode
: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
:PhoneNum	Input	Number	25	Source value PhoneNum.Trim
:PhoneNum	Input	Number	25	Source value DbType.String

Tables

Table	Access	Columns used
dual	CREATE	See sample SQL.
v_firm_seq	CREATE	See sample SQL.
COMPANY	CREATE	See sample SQL.
THRDPARTY_FIRM	CREATE	See sample SQL.
ADDRESS	CREATE	See sample SQL.
company_address	CREATE	See sample SQL.

Sample SQL

BEGIN Pk82033_ThirdParty.thrdparty_firm_insert(:AdjusterName, :AttorneyName, :ContactName, :CreateUser, :CompanyCode, :CompanyName, :CompanyShortDescr, :TaxID, :AddressCode, :AddressLine1, :AddressLine2, :AddressLine3, :AddressLine4, :CityName, :CountryCode, :ForeignAddressFlag, :ForeignPostalCode, :inState, :ZipCode, :ZipCodeExt, :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