dbo.ATT_TIDialogTable

1 create   trigger ATT_TIDialogTable on DialogTable  for Insert not for Replication as begin BEGIN TRY if exists (select top 1 1 from inserted) goto
2 start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')  if exists (select top 1 1 from inserted i where 
3dbo.QBM_FCVGUIDToModuleOwner(i.UID_DialogTable) = 'CCC' ) begin insert into ATTBaseObjectHasDecisionRule (UID_PWODecisionRule, UID_DialogTable, XObjectKey
4 , XUserInserted, XUserUpdated, XDateInserted, XDateUpdated) select x.UID_PWODecisionRule, i.UID_DialogTable , dbo.QBM_FCVElementToObjectKey2('ATTBaseObjectHasDecisionRule'
5, 'UID_DialogTable', i.UID_DialogTable, 'UID_PWODecisionRule', x.UID_PWODecisionRule) , i.XUserInserted, i.XUserUpdated, i.XDateInserted, i.XDateUpdated
6 from inserted i cross join (values ( 'ATT-PWODecisionRule-AS') , ('ATT-PWODecisionRule-CD') , ('ATT-PWODecisionRule-EX') , ('ATT-PWODecisionRule-OM') 
7, ('ATT-PWODecisionRule-OR') , ('ATT-PWODecisionRule-WC') ) as x (UID_PWODecisionRule) where dbo.QBM_FCVGUIDToModuleOwner(i.UID_DialogTable) = 'CCC' and
8 dbo.QBM_FGIPrepropConditionDeactiv('ATTESTATION') = 0 and not exists (select top 1 1 from ATTBaseObjectHasDecisionRule o where o.UID_DialogTable = i.UID_DialogTable
9 and o.UID_PWODecisionRule = x.UID_PWODecisionRule ) end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH
10 end 
11