APPS.WSH_RU_ACTIONS dependencies on WSH_RU_ROLES_PVT

Line 15: l_role WSH_RU_ROLES_PVT.Role_Type;

11: x_rowid OUT NOCOPY VARCHAR2,
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);

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

63: --
64: -- Debug Statements
65: --
66: IF l_debug_on THEN
67: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_RU_ROLES_PVT.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
68: END IF;
69: --
70: WSH_RU_ROLES_PVT.Insert_Row(
71: p_role_record => l_role,

Line 70: WSH_RU_ROLES_PVT.Insert_Row(

66: IF l_debug_on THEN
67: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_RU_ROLES_PVT.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
68: END IF;
69: --
70: WSH_RU_ROLES_PVT.Insert_Row(
71: p_role_record => l_role,
72: x_rowid => x_rowid,
73: x_role_id => l_role_id,
74: x_return_status => l_rs);

Line 155: l_role WSH_RU_ROLES_PVT.Role_Type;

151: PROCEDURE Lock_Role_Definition(
152: p_role_def_record IN Role_Definition_Type,
153: p_row_id IN VARCHAR2) IS
154: --
155: l_role WSH_RU_ROLES_PVT.Role_Type;
156: l_debug_on BOOLEAN;
157: --
158: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'LOCK_ROLE_DEFINITION';
159: --

Line 187: wsh_ru_roles_pvt.lock_row(

183: l_role.LAST_UPDATE_DATE := p_role_def_record.LAST_UPDATE_DATE;
184: l_role.LAST_UPDATE_LOGIN := p_role_def_record.LAST_UPDATE_LOGIN;
185:
186: --
187: wsh_ru_roles_pvt.lock_row(
188: p_rowid => p_row_id,
189: p_role_record => l_role
190: );
191:

Line 207: l_role WSH_RU_ROLES_PVT.Role_Type;

203: p_role_def_record IN OUT NOCOPY Role_Definition_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);

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

247: --
248: -- Debug Statements
249: --
250: IF l_debug_on THEN
251: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_RU_ROLES_PVT.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
252: END IF;
253: --
254: WSH_RU_ROLES_PVT.Update_Row(
255: p_role_record => l_role,

Line 254: WSH_RU_ROLES_PVT.Update_Row(

250: IF l_debug_on THEN
251: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_RU_ROLES_PVT.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
252: END IF;
253: --
254: WSH_RU_ROLES_PVT.Update_Row(
255: p_role_record => l_role,
256: p_rowid => NULL,
257: x_return_status => l_rs);
258: