[Home] [Help]
1699: fetch getUserID into userId;
1700: close getUserID;
1701: -- First verifty if the new userId has the valid permission
1702: -- Check if the user is the SYSADMIN
1703: JTF_AUTH_SECURITY_PKG.CHECK_PERMISSION (
1704: x_flag => l_permission_flag,
1705: x_return_status => l_return_status,
1706: p_user_name => WF_ENGINE.context_text,
1707: p_permission_name => 'JTF_REG_APPROVAL');
1710: end if;
1711:
1712: if (l_permission_flag = 0) then
1713: -- Not a SYSADMIN, check if the user is a Primary User
1714: JTF_AUTH_SECURITY_PKG.CHECK_PERMISSION (
1715: x_flag => l_permission_flag,
1716: x_return_status => l_return_status,
1717: p_user_name => WF_ENGINE.context_text,
1718: p_permission_name => 'JTF_PRIMARY_USER_SUMMARY');
1722: end if;
1723:
1724: if (l_permission_flag = 0) then
1725: -- Not a Primary User, check if the user is an Owner
1726: JTF_AUTH_SECURITY_PKG.CHECK_PERMISSION (
1727: x_flag => l_permission_flag,
1728: x_return_status => l_return_status,
1729: p_user_name => WF_ENGINE.context_text,
1730: p_permission_name => 'JTF_APPROVER');