Stored Procedures for BOD shredding

Stored procedures are used to shred the BOD XML messages. Stored procedures are installed in the MS SQL Server database. The name of the database is IEVMS_LN.

The integration uses the following stored procedures:

Stored procedure	BOD	SQL Server Table
sp_evms_ln_shredCodeDef	CodeDefinition	CODE
sp_evms_ln_shredCodeDef	CodeDefinition	CODE_LC
sp_evms_ln_shredCurExchRate	CurrencyExchangeRateMaster	CUR_EXCH_RATE
sp_evms_ln_shredFnclClndrPrd	FinancialCalendar	FNCL_CLNDR_PRD
sp_evms_ln_shredFnclClndrPrd	FinancialCalendar	FNCL_CLNDR_PRD_LC
sp_evms_ln_shredItemMaster	ItemMaster	ITEM
sp_evms_ln_shredItemMaster	ItemMaster	ITEM_LC
sp_evms_ln_shredLaborCostMaster	LaborCostMaster	LABOR_COST
sp_evms_ln_shredLaborCostMaster	LaborCostMaster	LABOR_COST_LC
sp_evms_ln_shredPerson	Person	PERSON
sp_evms_ln_shredPerson	Person	PERSON_LC
sp_evms_ln_shredProjectBudget	ProjectBudget	PROJECT_BDGT
sp_evms_ln_shredProjectBudget	ProjectBudget	PROJECT_BDGT_LC
sp_evms_ln_shredProjectCosts	ProjectCosts	PROJECT_COSTS
sp_evms_ln_shredProjectCosts	ProjectCosts	PROJECT_COSTS_LC
sp_evms_ln_shredProjectMaster	ProjectMaster	PROJECT
		PROJECT_LC
		PROJECT_ACTVTY
		PROJECT_ACTVTY_LC
		PROJECT_BSLN_LINE
		PROJECT_BSLN_LINE_LC
sp_evms_ln_shredProjectProgress	ProjectProgress	PROJECT_PRGRS
sp_evms_ln_shredProjectProgress	ProjectProgress	PROJECT_PRGRS_LC
sp_evms_ln_shredSundryCostMaster	SundryCostMaster	SUNDRY_COST
sp_evms_ln_shredSundryCostMaster	SundryCostMaster	SUNDRY_COST_LC
sp_evms_ln_shredProjectContract	ContractMaster	PROJECT_CONTRACT_HEADER
		PROJECT_CONTRACT_HEADER_LC
		PROJECT_CONTRACT_LINE
		PROJECT_CONTRACT_LINE_LC
sp_evms_ln_shredProjectRevenue	ProjectRevenue	PROJECT_REVENUE
sp_evms_ln_shredProjectRevenue	ProjectRevenue	PROJECT_REVENUE_LC
sp_evms_ln_UserDefinedStructure	LnUserDefinedStructure	LN_USER_DEFINED_STRUCTURE_LINE
sp_evms_ln_UserDefinedStructure	LnUserDefinedStructure	LN_USER_DEFINED_STRUCTURE_LINE_LC