exec CPEC.dbo.zDP_SVC00950SS_1 'CPEC01','TEST 1'
exec CPEC.dbo.zDP_IV00102SS_1 'TEST ITEM',2,'TJOWERS01'
exec CPEC.dbo.zDP_IV00102SS_1 'TEST ITEM',1,''
exec CPEC.dbo.zDP_SVC00951SS_1 'TEST ITEM'
exec CPEC.dbo.zDP_SVC00998F_1 NULL,NULL
exec DYNAMICS.dbo.zDP_SY02100SS_1 7,949,6,0
exec CPEC.dbo.zDP_SVC00710SS_1 'TJOWERS01','',1,'0000004190','TEST ITEM',16384,0
BEGIN DECLARE @num int EXEC CPEC.dbo.zDP_SVC00710SI '0000004190', 1, 'TEST ITEM', 16384, 'Do not use or inventory. Testing purposes only', 'TJOWERS01', 99.00000, '', 'TJOWERS01', 99.00000, 'EACH', 0.00000, 0.00000, '', '', 0, 1, '', 0, '', '', '', 2, '', '1900.01.01', 0, '', 0, @num OUT SELECT @num END
BEGIN DECLARE @num int EXEC CPEC.dbo.zDP_SVC00203SI 2, '0000004190', 1, 16384, 'P', 'BO', 'TJOWERS01', 'TEST ITEM', 'C', 'Do not use or inventory. Testing purposes only', 'TJOWERS01', 'EACH', 99.00000, 0.00000, 99.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, '1900.01.01', '00:00:00', '1900.01.01', '00:00:00', '', '', '', 0.00000, 0, '', 0, 100.00000, 100.00000, 100.00000, '1900.01.01', '', 0.00000, 0, '', 0.00000, 0, 0, 0, 'CPEC', 2, '', 0, '', 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, '', 0, '', 0, 0.00000, @num OUT SELECT @num END  

declare @p1 int
set @p1=4
exec sp_prepexec @p1 output,N'@P1 char(4),@P2 char(4),@P3 char(12),@P4 smallint',N'BEGIN UPDATE CPEC.dbo.SVC00200 SET SRVSTAT = @P1 WHERE SRVSTAT = @P2 AND CALLNBR = @P3 AND SRVRECTYPE = @P4 SELECT @@rowcount END ','BO  ','ENT ','0000004190  ',2
select @p1

Second run adding a Part in GP

-- SVC_Inventory_Requirements_Work	SVC00710
-- SVC_Service_MSTR_Line	SVC00203

BEGIN DECLARE @num int EXEC CPEC.dbo.zDP_SVC00710SI '0000004190', 1, 'TEST ITEM', 49152, 'Do not use or inventory. Testing purposes only', 'TJOWERS01', 99.00000, '', 'TJOWERS01', 99.00000, 'EACH', 0.00000, 0.00000, '', '', 0, 1, '', 0, '', '', '', 2, '', '1900.01.01', 0, '', 0, @num OUT SELECT @num END

BEGIN DECLARE @num int EXEC CPEC.dbo.zDP_SVC00203SI 2, '0000004190', 1, 49152, 'P', 'BO', 'TJOWERS01', 'TEST ITEM', 'C', 'Do not use or inventory. Testing purposes only', 'TJOWERS01', 'EACH', 99.00000, 0.00000, 99.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, '1900.01.01', '00:00:00', '1900.01.01', '00:00:00', '', '', '', 0.00000, 0, '', 0, 100.00000, 100.00000, 100.00000, '1900.01.01', '', 0.00000, 0, '', 0.00000, 0, 0, 0, 'CPEC', 2, '', 0, '', 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, '', 0, '', 0, 0.00000, @num OUT SELECT @num END 

...
BEGIN DECLARE @stored_proc_name char(38) DECLARE @retstat int DECLARE @param7 int DECLARE @param8 char(11) set nocount on SELECT @param7 = 0 SELECT @param8 = 'TJOWERS01' SELECT @stored_proc_name = 'CPEC.dbo.SVC_Get_ServiceDistLocAccount' EXEC @retstat = @stored_proc_name 2, '0000004190', 1, 49152, 'P', 5, @param7 OUT, @param8 OUT SELECT @retstat, @param7, @param8 set nocount on END 
...

BEGIN DECLARE @stored_proc_name char(38) DECLARE @retstat int set nocount on SELECT @stored_proc_name = 'CPEC.dbo.SVC_Create_Srv_Audit_UserDate' EXEC @retstat = @stored_proc_name '0000004190', 2, 'BO', 'tjowers', 'Part Record Added/Updated', '2013.06.27' SELECT @retstat set nocount on END 

SELECT COUNT(SRVRECTYPE) FROM CPEC.dbo.SVC00203 WHERE SRVRECTYPE = 2 AND CALLNBR >= '0000004190' AND CALLNBR <= '0000004190' AND EQPLINE = 1 AND LINITMTYP >= 'P' AND LINITMTYP <= 'P'

SELECT COUNT(SRVRECTYPE) FROM CPEC.dbo.SVC00203 WHERE SRVRECTYPE = 2 AND CALLNBR = '0000004190' AND EQPLINE = 1 AND LINITMTYP = 'L' AND CMPNTSEQ = 0 
SELECT COUNT(SRVRECTYPE) FROM CPEC.dbo.SVC00203 WHERE SRVRECTYPE = 2 AND CALLNBR = '0000004190' AND EQPLINE = 1 AND LINITMTYP = 'A' AND CMPNTSEQ = 0 
SELECT COUNT(SRVRECTYPE) FROM CPEC.dbo.SVC00203 WHERE SRVRECTYPE = 2 AND CALLNBR = '0000004190' AND EQPLINE = 1 AND LINITMTYP = 'E' AND CMPNTSEQ = 0