[Home] [Help]
1090: colon pls_integer;
1091:
1092: cursor c_role (l_name in varchar2) is
1093: select substrb(nvl(wrt.display_name,wr.display_name),1,360)
1094: from wf_local_roles wr, wf_local_roles_tl wrt
1095: where wr.name = l_name
1096: and wr.orig_system = wrt.orig_system (+)
1097: and wr.orig_system_id = wrt.orig_system_id (+)
1098: and wr.name = wrt.name (+)
1102:
1103: cursor corig_role (l_name in varchar2, l_origSys in varchar2,
1104: l_origSysID in number) is
1105: select substrb(nvl(wrt.display_name,wr.display_name),1,360)
1106: from wf_local_roles wr, wf_local_roles_tl wrt
1107: where wr.orig_system = l_origSys
1108: and wr.orig_system_id = l_origSysID
1109: and wr.name = l_name
1110: and wr.orig_system = wrt.orig_system (+)
1443: --If MLS language support is enabled for this orig_system
1444: --then sync the data to _TL table aswell.
1445: if ((WF_DIRECTORY.IsMLSEnabled(l_origSys) = TRUE) AND
1446: (userenv('LANG') <> 'US')) then
1447: insert into WF_LOCAL_ROLES_TL
1448: ( NAME,
1449: ORIG_SYSTEM,
1450: ORIG_SYSTEM_ID,
1451: PARTITION_ID,
1898: if ((WF_DIRECTORY.IsMLSEnabled(l_origSys) = TRUE ) AND
1899: (userenv('LANG') <> 'US')) then
1900: --If the orig_system is MLS enabled then sync the dat into
1901: --the _TL table aswell.
1902: insert into WF_LOCAL_ROLES_TL
1903: ( NAME,
1904: ORIG_SYSTEM,
1905: ORIG_SYSTEM_ID,
1906: PARTITION_ID,
3268: and USER_FLAG = 'Y';
3269:
3270:
3271: --Update the _TL table
3272: update WF_LOCAL_ROLES_TL
3273: set DISPLAY_NAME = nvl(SetUserAttr.display_name, DISPLAY_NAME),
3274: DESCRIPTION = SetUserAttr.description,
3275: -- <7298384> always keep CREATED_BY and CREATION_DATE in update
3276: -- CREATED_BY = nvl(SetUserAttr.created_by, created_by),
3286:
3287: if (sql%rowcount = 0) then
3288: --No record exist for this lang in _TL table
3289: --so insert a record
3290: insert into WF_LOCAL_ROLES_TL (NAME,
3291: DISPLAY_NAME,
3292: DESCRIPTION,
3293: ORIG_SYSTEM,
3294: ORIG_SYSTEM_ID,
3384: and PARTITION_ID = l_partitionID
3385: and USER_FLAG = 'Y';
3386:
3387: --then lets update the _TL table
3388: update WF_LOCAL_ROLES_TL
3389: set DISPLAY_NAME = nvl(SetUserAttr.display_name, DISPLAY_NAME),
3390: DESCRIPTION = SetUserAttr.description
3391: -- <7298384> no overwrite mode, so keeping previous values
3392: -- CREATED_BY = nvl(SetUserAttr.created_by, CREATED_BY),
3406: --The issue is that if the passed values or param
3407: --are null we would be inserting 'US' language
3408: --display name and description
3409:
3410: insert into WF_LOCAL_ROLES_TL (NAME,
3411: DISPLAY_NAME,
3412: DESCRIPTION,
3413: ORIG_SYSTEM,
3414: ORIG_SYSTEM_ID,
3714: end if;
3715:
3716: --Update the _TL table for the display_name and
3717: --description
3718: update WF_LOCAL_ROLES_TL
3719: set DISPLAY_NAME = nvl(SetRoleAttr.display_name,
3720: DISPLAY_NAME),
3721: DESCRIPTION = SetRoleAttr.description,
3722: OWNER_TAG = nvl(SetRoleAttr.owner_tag,
3742: --are null we would be inserting 'US' language
3743: --display name as its non-nullable was max we can do is to
3744: --add a 'NON_TRANSLATED' string or something to recognize.
3745:
3746: insert into WF_LOCAL_ROLES_TL (NAME,
3747: DISPLAY_NAME,
3748: DESCRIPTION,
3749: ORIG_SYSTEM,
3750: ORIG_SYSTEM_ID,
3864: end if;
3865:
3866: --Update the _TL table for the display_name and
3867: --description
3868: update WF_LOCAL_ROLES_TL
3869: set DISPLAY_NAME = nvl(SetRoleAttr.display_name,
3870: DISPLAY_NAME),
3871: DESCRIPTION = nvl(SetRoleAttr.description,DESCRIPTION),
3872: OWNER_TAG = nvl(SetRoleAttr.owner_tag,
3891: --The issue is that if the passed values or param
3892: --are null we would be inserting 'US' language
3893: --display name as its non-nullable
3894:
3895: insert into WF_LOCAL_ROLES_TL (NAME,
3896: DISPLAY_NAME,
3897: DESCRIPTION,
3898: ORIG_SYSTEM,
3899: ORIG_SYSTEM_ID,