APPS.WSH_RU_ROLES_PVT dependencies on WSH_ROLES

Line 16: SELECT role_id FROM WSH_ROLES WHERE name = p_role_record.name;

12:
13: wsh_duplicate_name EXCEPTION;
14:
15: CURSOR c_dup_role_name IS
16: SELECT role_id FROM WSH_ROLES WHERE name = p_role_record.name;
17:
18: CURSOR c_new_role_id IS
19: SELECT wsh_roles_s.nextval FROM DUAL;
20:

Line 19: SELECT wsh_roles_s.nextval FROM DUAL;

15: CURSOR c_dup_role_name IS
16: SELECT role_id FROM WSH_ROLES WHERE name = p_role_record.name;
17:
18: CURSOR c_new_role_id IS
19: SELECT wsh_roles_s.nextval FROM DUAL;
20:
21: CURSOR c_role_rowid(x_role_id IN NUMBER) IS
22: SELECT rowid FROM WSH_ROLES WHERE role_id = x_role_id;
23:

Line 22: SELECT rowid FROM WSH_ROLES WHERE role_id = x_role_id;

18: CURSOR c_new_role_id IS
19: SELECT wsh_roles_s.nextval FROM DUAL;
20:
21: CURSOR c_role_rowid(x_role_id IN NUMBER) IS
22: SELECT rowid FROM WSH_ROLES WHERE role_id = x_role_id;
23:
24: l_role_id NUMBER(15) := NULL;
25: l_dup_id NUMBER(15) := NULL;
26: l_rowid VARCHAR2(18) := '';

Line 71: INSERT INTO WSH_ROLES (

67: FETCH c_new_role_id INTO l_role_id;
68: CLOSE c_new_role_id;
69: END IF;
70:
71: INSERT INTO WSH_ROLES (
72: ROLE_ID,
73: NAME,
74: DESCRIPTION,
75: CREATED_BY,

Line 143: SELECT * FROM WSH_ROLES

139: p_rowid IN VARCHAR2,
140: p_role_record IN Role_Type) IS
141:
142: CURSOR c_lock_role IS
143: SELECT * FROM WSH_ROLES
144: WHERE rowid = p_rowid
145: FOR UPDATE OF ROLE_ID NOWAIT;
146:
147: l_db_rec c_lock_role%ROWTYPE;

Line 270: SELECT role_id FROM WSH_ROLES

266: x_return_status OUT NOCOPY VARCHAR2) IS
267: --
268:
269: CURSOR c_dup_role_name IS
270: SELECT role_id FROM WSH_ROLES
271: WHERE name = p_role_record.name
272: AND ROLE_ID <> p_role_record.ROLE_ID;
273:
274: l_dup_id NUMBER;

Line 311: UPDATE WSH_ROLES

307: ELSE
308: CLOSE c_dup_role_name;
309: END IF;
310:
311: UPDATE WSH_ROLES
312: SET
313: ROLE_ID = p_role_record.ROLE_ID,
314: NAME = p_role_record.NAME,
315: DESCRIPTION = p_role_record.DESCRIPTION,

Line 395: DELETE FROM WSH_ROLES

391: --
392: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
393: END IF;
394: --
395: DELETE FROM WSH_ROLES
396: WHERE rowid = p_rowid;
397: IF SQL%NOTFOUND THEN
398: RAISE NO_DATA_FOUND;
399: END IF;