Back to OIM Explorer

dbo.QER_FGICultureForPerson

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 3.325 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_FGIConfigparmValue source text reference

References

dbo.QBM_FGIConfigparmValue

Referenced By

No direct source references extracted.

Complete Source

1CREATE FUNCTION dbo.QER_FGICultureForPerson(2  @UID_Person varchar(38)3) RETURNS varchar(384)5AS6BEGIN7  DECLARE @uid_dialogcountry varchar(38)8  DECLARE @uid_dialogState varchar(38)9  DECLARE @uid_locality varchar(38)10  DECLARE @uid_department varchar(38)11  DECLARE @uid_ProfitCenter varchar(38)12  DECLARE @UID_DialogCulture varchar(38)13  SELECT14    TOP 1 @uid_dialogcountry = uid_dialogcountry,15    @uid_dialogState = uid_dialogState,16    @uid_locality = uid_locality,17    @uid_department = uid_department,18    @uid_ProfitCenter = uid_ProfitCenter,19    @UID_DialogCulture = UID_DialogCulture20  FROM person21  WHERE22    uid_person = @uid_person23  IF @UID_DialogCulture IS NULL24  BEGIN25    SELECT TOP 1 @UID_DialogCulture = shc.UID_DialogCulture26    FROM dialogstatehasCulture shc27    WHERE28      shc.UID_DialogState = @uid_dialogState29    ORDER BY shc.SortOrder30    IF @UID_DialogCulture IS NULL31    BEGIN32      SELECT TOP 1 @UID_DialogCulture = shc.UID_DialogCulture33      FROM dialogCountryhasCulture shc34      WHERE35        shc.UID_DialogCountry = @uid_dialogCountry36      ORDER BY shc.SortOrder37    END38  END39  IF @uid_locality > ' ' AND @UID_DialogCulture IS NULL40  BEGIN41    SELECT42      TOP 1 @UID_DialogCulture = UID_DialogCulture,43      @uid_dialogcountry = uid_dialogcountry,44      @uid_dialogState = uid_dialogState45    FROM BaseTree46    WHERE47      uid_org = @uid_locality48    IF @UID_DialogCulture IS NULL49    BEGIN50      SELECT TOP 1 @UID_DialogCulture = shc.UID_DialogCulture51      FROM dialogstatehasCulture shc52      WHERE53        shc.UID_DialogState = @uid_dialogState54      ORDER BY shc.SortOrder55      IF @UID_DialogCulture IS NULL56      BEGIN57        SELECT TOP 1 @UID_DialogCulture = shc.UID_DialogCulture58        FROM dialogCountryhasCulture shc59        WHERE60          shc.UID_DialogCountry = @uid_dialogCountry61        ORDER BY shc.SortOrder62      END63    END64  END65  IF @uid_Department > ' ' AND @UID_DialogCulture IS NULL66  BEGIN67    SELECT68      TOP 1 @UID_DialogCulture = UID_DialogCulture,69      @uid_dialogcountry = uid_dialogcountry,70      @uid_dialogState = uid_dialogState71    FROM BaseTree72    WHERE73      uid_org = @uid_Department74    IF @UID_DialogCulture IS NULL75    BEGIN76      SELECT TOP 1 @UID_DialogCulture = shc.UID_DialogCulture77      FROM dialogstatehasCulture shc78      WHERE79        shc.UID_DialogState = @uid_dialogState80      ORDER BY shc.SortOrder81      IF @UID_DialogCulture IS NULL82      BEGIN83        SELECT TOP 1 @UID_DialogCulture = shc.UID_DialogCulture84        FROM dialogCountryhasCulture shc85        WHERE86          shc.UID_DialogCountry = @uid_dialogCountry87        ORDER BY shc.SortOrder88      END89    END90  END91  IF @uid_ProfitCenter > ' ' AND @UID_DialogCulture IS NULL92  BEGIN93    SELECT94      TOP 1 @UID_DialogCulture = UID_DialogCulture,95      @uid_dialogcountry = uid_dialogcountry,96      @uid_dialogState = uid_dialogState97    FROM BaseTree98    WHERE99      uid_org = @uid_ProfitCenter100    IF @UID_DialogCulture IS NULL101    BEGIN102      SELECT TOP 1 @UID_DialogCulture = shc.UID_DialogCulture103      FROM dialogstatehasCulture shc104      WHERE105        shc.UID_DialogState = @uid_dialogState106      ORDER BY shc.SortOrder107      IF @UID_DialogCulture IS NULL108      BEGIN109        SELECT TOP 1 @UID_DialogCulture = shc.UID_DialogCulture110        FROM dialogCountryhasCulture shc111        WHERE112          shc.UID_DialogCountry = @uid_dialogCountry113        ORDER BY shc.SortOrder114      END115    END116  END117  IF @UID_DialogCulture IS NULL118  BEGIN119    SELECT TOP 1 @UID_DialogCulture = cu.UID_DialogCulture120    FROM QBMCulture cu121    WHERE122      cu.Ident_DialogCulture =123    LEFT(dbo.QBM_FGIConfigparmValue('Common\MailNotification\DefaultCulture'),124    16)125  END126  IF isnull(@UID_DialogCulture,127  '') = ''128  BEGIN129    SELECT @UID_DialogCulture = 'QBM-Cult-en-US'130  END131  ende:132  RETURN(@UID_DialogCulture)133END

Open raw exported source

1   create   function dbo.QER_FGICultureForPerson (@UID_Person varchar(38) ) returns varchar(38) as begin declare @uid_dialogcountry varchar(38) 2declare @uid_dialogState varchar(38) declare @uid_locality varchar(38) declare @uid_department varchar(38) declare @uid_ProfitCenter varchar(38)  declare3 @UID_DialogCulture varchar(38) select top 1 @uid_dialogcountry = uid_dialogcountry , @uid_dialogState = uid_dialogState , @uid_locality = uid_locality4 , @uid_department = uid_department , @uid_ProfitCenter = uid_ProfitCenter  , @UID_DialogCulture = UID_DialogCulture from person where uid_person = @uid_person5  if @UID_DialogCulture is null begin  select top 1 @UID_DialogCulture = shc.UID_DialogCulture from dialogstatehasCulture shc where shc.UID_DialogState6 = @uid_dialogState order by shc.SortOrder if @UID_DialogCulture is null begin select top 1 @UID_DialogCulture = shc.UID_DialogCulture from dialogCountryhasCulture7 shc where shc.UID_DialogCountry = @uid_dialogCountry order by shc.SortOrder end  end if @uid_locality > ' ' and @UID_DialogCulture is null begin select8 top 1 @UID_DialogCulture = UID_DialogCulture, @uid_dialogcountry = uid_dialogcountry , @uid_dialogState = uid_dialogState from BaseTree where uid_org 9= @uid_locality if @UID_DialogCulture is null begin select top 1 @UID_DialogCulture = shc.UID_DialogCulture from dialogstatehasCulture shc where shc.UID_DialogState10 = @uid_dialogState order by shc.SortOrder if @UID_DialogCulture is null begin select top 1 @UID_DialogCulture = shc.UID_DialogCulture from dialogCountryhasCulture11 shc where shc.UID_DialogCountry = @uid_dialogCountry order by shc.SortOrder end end  end  if @uid_Department > ' ' and @UID_DialogCulture is null begin12 select top 1 @UID_DialogCulture = UID_DialogCulture, @uid_dialogcountry = uid_dialogcountry , @uid_dialogState = uid_dialogState from BaseTree where uid_org13 = @uid_Department if @UID_DialogCulture is null begin select top 1 @UID_DialogCulture = shc.UID_DialogCulture from dialogstatehasCulture shc where shc.UID_DialogState14 = @uid_dialogState order by shc.SortOrder if @UID_DialogCulture is null begin select top 1 @UID_DialogCulture = shc.UID_DialogCulture from dialogCountryhasCulture15 shc where shc.UID_DialogCountry = @uid_dialogCountry order by shc.SortOrder end end  end  if @uid_ProfitCenter > ' ' and @UID_DialogCulture is null begin16 select top 1 @UID_DialogCulture = UID_DialogCulture, @uid_dialogcountry = uid_dialogcountry , @uid_dialogState = uid_dialogState from BaseTree where uid_org17 = @uid_ProfitCenter if @UID_DialogCulture is null begin select top 1 @UID_DialogCulture = shc.UID_DialogCulture from dialogstatehasCulture shc where shc.UID_DialogState18 = @uid_dialogState order by shc.SortOrder if @UID_DialogCulture is null begin select top 1 @UID_DialogCulture = shc.UID_DialogCulture from dialogCountryhasCulture19 shc where shc.UID_DialogCountry = @uid_dialogCountry order by shc.SortOrder end end  end    if @UID_DialogCulture is null begin select top 1 @UID_DialogCulture20 = cu.UID_DialogCulture from QBMCulture cu where cu.Ident_DialogCulture = left(dbo.QBM_FGIConfigparmValue('Common\MailNotification\DefaultCulture'), 1621) end if isnull(@UID_DialogCulture, '') = '' begin select @UID_DialogCulture = 'QBM-Cult-en-US' end  ende: return (@UID_DialogCulture) end 22