12: x_role_id OUT NOCOPY NUMBER,
13: x_return_status OUT NOCOPY VARCHAR2) IS
14: l_rs VARCHAR2(1);
15: l_role WSH_RU_ROLES_PVT.Role_Type;
16: l_privilege WSH_RU_ROLE_PRIVILEGES_PVT.Role_Privilege_Type;
17: l_role_id NUMBER(15);
18: i NUMBER;
19: l_dummy_rowid VARCHAR2(18);
20: l_dummy_id NUMBER(15);
111: -- Debug Statements
112: --
113: IF l_debug_on THEN
114: WSH_DEBUG_SV.log(l_module_name,'PRIVILEGE_CODE',l_privilege.PRIVILEGE_CODE);
115: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_RU_ROLE_PRIVILEGES_PVT.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
116: END IF;
117: --
118: WSH_RU_ROLE_PRIVILEGES_PVT.Insert_Row(
119: p_role_privilege_record => l_privilege,
114: WSH_DEBUG_SV.log(l_module_name,'PRIVILEGE_CODE',l_privilege.PRIVILEGE_CODE);
115: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_RU_ROLE_PRIVILEGES_PVT.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
116: END IF;
117: --
118: WSH_RU_ROLE_PRIVILEGES_PVT.Insert_Row(
119: p_role_privilege_record => l_privilege,
120: x_rowid => l_dummy_rowid,
121: x_role_privilege_id => l_dummy_id,
122: x_return_status => l_rs);
204: x_return_status OUT NOCOPY VARCHAR2) IS
205: --
206: l_rs VARCHAR2(1);
207: l_role WSH_RU_ROLES_PVT.Role_Type;
208: l_privilege WSH_RU_ROLE_PRIVILEGES_PVT.Role_Privilege_Type;
209: l_role_id NUMBER(15);
210: i NUMBER;
211: l_dummy_rowid VARCHAR2(18);
212: l_dummy_id NUMBER(15);
268: --
269: return;
270: END IF;
271:
272: WSH_RU_ROLE_PRIVILEGES_PVT.Delete_Role_Privileges(
273: p_role_id => p_role_def_record.ROLE_ID,
274: x_return_status => l_rs);
275:
276: IF l_rs <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
303: -- Debug Statements
304: --
305: IF l_debug_on THEN
306: WSH_DEBUG_SV.log(l_module_name,'PRIVILEGE_CODE',l_privilege.PRIVILEGE_CODE);
307: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_RU_ROLE_PRIVILEGES_PVT.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
308: END IF;
309: --
310: WSH_RU_ROLE_PRIVILEGES_PVT.Insert_Row(
311: p_role_privilege_record => l_privilege,
306: WSH_DEBUG_SV.log(l_module_name,'PRIVILEGE_CODE',l_privilege.PRIVILEGE_CODE);
307: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_RU_ROLE_PRIVILEGES_PVT.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
308: END IF;
309: --
310: WSH_RU_ROLE_PRIVILEGES_PVT.Insert_Row(
311: p_role_privilege_record => l_privilege,
312: x_rowid => l_dummy_rowid,
313: x_role_privilege_id => l_dummy_id,
314: x_return_status => l_rs);