[Home] [Help]
1232: colon pls_integer;
1233:
1234: cursor c_role (l_name in varchar2) is
1235: select substrb(nvl(wrt.display_name,wr.display_name),1,360)
1236: from wf_local_roles wr, wf_local_roles_tl wrt
1237: where wr.name = l_name
1238: and wr.orig_system = wrt.orig_system (+)
1239: and wr.orig_system_id = wrt.orig_system_id (+)
1240: and wr.name = wrt.name (+)
1244:
1245: cursor corig_role (l_name in varchar2, l_origSys in varchar2,
1246: l_origSysID in number) is
1247: select substrb(nvl(wrt.display_name,wr.display_name),1,360)
1248: from wf_local_roles wr, wf_local_roles_tl wrt
1249: where wr.orig_system = l_origSys
1250: and wr.orig_system_id = l_origSysID
1251: and wr.name = l_name
1252: and wr.orig_system = wrt.orig_system (+)
1585: --If MLS language support is enabled for this orig_system
1586: --then sync the data to _TL table aswell.
1587: if ((WF_DIRECTORY.IsMLSEnabled(l_origSys) = TRUE) AND
1588: (userenv('LANG') <> 'US')) then
1589: insert into WF_LOCAL_ROLES_TL
1590: ( NAME,
1591: ORIG_SYSTEM,
1592: ORIG_SYSTEM_ID,
1593: PARTITION_ID,
2040: if ((WF_DIRECTORY.IsMLSEnabled(l_origSys) = TRUE ) AND
2041: (userenv('LANG') <> 'US')) then
2042: --If the orig_system is MLS enabled then sync the dat into
2043: --the _TL table aswell.
2044: insert into WF_LOCAL_ROLES_TL
2045: ( NAME,
2046: ORIG_SYSTEM,
2047: ORIG_SYSTEM_ID,
2048: PARTITION_ID,
3416: and USER_FLAG = 'Y';
3417:
3418:
3419: --Update the _TL table
3420: update WF_LOCAL_ROLES_TL
3421: set DISPLAY_NAME = nvl(SetUserAttr.display_name, DISPLAY_NAME),
3422: DESCRIPTION = SetUserAttr.description,
3423: -- <7298384> always keep CREATED_BY and CREATION_DATE in update
3424: -- CREATED_BY = nvl(SetUserAttr.created_by, created_by),
3434:
3435: if (sql%rowcount = 0) then
3436: --No record exist for this lang in _TL table
3437: --so insert a record
3438: insert into WF_LOCAL_ROLES_TL (NAME,
3439: DISPLAY_NAME,
3440: DESCRIPTION,
3441: ORIG_SYSTEM,
3442: ORIG_SYSTEM_ID,
3532: and PARTITION_ID = l_partitionID
3533: and USER_FLAG = 'Y';
3534:
3535: --then lets update the _TL table
3536: update WF_LOCAL_ROLES_TL
3537: set DISPLAY_NAME = nvl(SetUserAttr.display_name, DISPLAY_NAME),
3538: DESCRIPTION = SetUserAttr.description
3539: -- <7298384> no overwrite mode, so keeping previous values
3540: -- CREATED_BY = nvl(SetUserAttr.created_by, CREATED_BY),
3554: --The issue is that if the passed values or param
3555: --are null we would be inserting 'US' language
3556: --display name and description
3557:
3558: insert into WF_LOCAL_ROLES_TL (NAME,
3559: DISPLAY_NAME,
3560: DESCRIPTION,
3561: ORIG_SYSTEM,
3562: ORIG_SYSTEM_ID,
3862: end if;
3863:
3864: --Update the _TL table for the display_name and
3865: --description
3866: update WF_LOCAL_ROLES_TL
3867: set DISPLAY_NAME = nvl(SetRoleAttr.display_name,
3868: DISPLAY_NAME),
3869: DESCRIPTION = SetRoleAttr.description,
3870: OWNER_TAG = nvl(SetRoleAttr.owner_tag,
3890: --are null we would be inserting 'US' language
3891: --display name as its non-nullable was max we can do is to
3892: --add a 'NON_TRANSLATED' string or something to recognize.
3893:
3894: insert into WF_LOCAL_ROLES_TL (NAME,
3895: DISPLAY_NAME,
3896: DESCRIPTION,
3897: ORIG_SYSTEM,
3898: ORIG_SYSTEM_ID,
4012: end if;
4013:
4014: --Update the _TL table for the display_name and
4015: --description
4016: update WF_LOCAL_ROLES_TL
4017: set DISPLAY_NAME = nvl(SetRoleAttr.display_name,
4018: DISPLAY_NAME),
4019: DESCRIPTION = nvl(SetRoleAttr.description,DESCRIPTION),
4020: OWNER_TAG = nvl(SetRoleAttr.owner_tag,
4039: --The issue is that if the passed values or param
4040: --are null we would be inserting 'US' language
4041: --display name as its non-nullable
4042:
4043: insert into WF_LOCAL_ROLES_TL (NAME,
4044: DISPLAY_NAME,
4045: DESCRIPTION,
4046: ORIG_SYSTEM,
4047: ORIG_SYSTEM_ID,