Back to OIM Explorer

dbo.CPL_FCVRuleGuidToProcName

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 358 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FGICodeName source text reference

References

Referenced By

Complete Source

SQL20 lines
1CREATE FUNCTION dbo.CPL_FCVRuleGuidToProcName(2  @UID_ComplianceRule varchar(38),3  @area varchar(16)4) RETURNS varchar(305)6AS7BEGIN8  DECLARE @erg varchar(30)9  SELECT @erg = dbo.QBM_FGICodeName('P' + CASE @area10  WHEN 'Rule' THEN11  'R'12  WHEN 'Person' THEN13  'P'14  WHEN 'ITShopOrder' THEN15  'I'16  ELSE '?'17  END,18  @UID_ComplianceRule) endLabel:19  RETURN(@erg)20END
Open raw exported source
SQL ยท Raw4 lines
1   create   function dbo.CPL_FCVRuleGuidToProcName(@UID_ComplianceRule varchar(38) , @area varchar(16)     ) returns varchar(30) as begin declare2 @erg varchar(30) select @erg = dbo.QBM_FGICodeName( 'P'  + case @area when 'Rule' then 'R' when 'Person' then 'P' when 'ITShopOrder' then 'I' else '?'3  end , @UID_ComplianceRule) endLabel: return(@erg) end 4