DBA Data[Home] [Help]

APPS.WSH_RU_ACTIONS dependencies on WSH_RU_ROLE_PRIVILEGES_PVT

Line 16: l_privilege WSH_RU_ROLE_PRIVILEGES_PVT.Role_Privilege_Type;

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);

Line 115: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_RU_ROLE_PRIVILEGES_PVT.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);

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,

Line 118: WSH_RU_ROLE_PRIVILEGES_PVT.Insert_Row(

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);

Line 208: l_privilege WSH_RU_ROLE_PRIVILEGES_PVT.Role_Privilege_Type;

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);

Line 272: WSH_RU_ROLE_PRIVILEGES_PVT.Delete_Role_Privileges(

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

Line 307: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_RU_ROLE_PRIVILEGES_PVT.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);

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,

Line 310: WSH_RU_ROLE_PRIVILEGES_PVT.Insert_Row(

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);