APPS.WSH_RU_ROLE_PRIVILEGES_PVT dependencies on WSH_ROLE_PRIVILEGES

Line 14: SELECT wsh_role_privileges_s.nextval FROM DUAL;

10: x_role_privilege_id OUT NOCOPY NUMBER,
11: x_return_status OUT NOCOPY VARCHAR2) IS
12:
13: CURSOR c_new_role_privilege_id IS
14: SELECT wsh_role_privileges_s.nextval FROM DUAL;
15:
16: CURSOR c_role_privilege_rowid(x_role_privilege_id IN NUMBER) IS
17: SELECT rowid FROM WSH_ROLE_PRIVILEGES WHERE role_privilege_id = x_role_privilege_id;
18:

Line 17: SELECT rowid FROM WSH_ROLE_PRIVILEGES WHERE role_privilege_id = x_role_privilege_id;

13: CURSOR c_new_role_privilege_id IS
14: SELECT wsh_role_privileges_s.nextval FROM DUAL;
15:
16: CURSOR c_role_privilege_rowid(x_role_privilege_id IN NUMBER) IS
17: SELECT rowid FROM WSH_ROLE_PRIVILEGES WHERE role_privilege_id = x_role_privilege_id;
18:
19: l_role_privilege_id NUMBER(15) := NULL;
20: l_rowid VARCHAR2(18) := '';
21:

Line 57: INSERT INTO WSH_ROLE_PRIVILEGES (

53: ;
54: END IF;
55: END IF;
56:
57: INSERT INTO WSH_ROLE_PRIVILEGES (
58: ROLE_PRIVILEGE_ID,
59: ROLE_ID,
60: PRIVILEGE_CODE,
61: CREATED_BY,

Line 110: SELECT * FROM WSH_ROLE_PRIVILEGES

106: p_rowid IN VARCHAR2,
107: p_role_privilege_record IN Role_Privilege_Type) IS
108:
109: CURSOR c_lock_role_privilege IS
110: SELECT * FROM WSH_ROLE_PRIVILEGES
111: WHERE rowid = p_rowid
112: FOR UPDATE OF ROLE_PRIVILEGE_ID NOWAIT;
113:
114: l_db_rec c_lock_role_privilege%ROWTYPE;

Line 237: UPDATE WSH_ROLE_PRIVILEGES

233: --
234: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
235: END IF;
236: --
237: UPDATE WSH_ROLE_PRIVILEGES
238: SET
239: ROLE_ID = p_role_privilege_record.ROLE_ID,
240: PRIVILEGE_CODE = p_role_privilege_record.PRIVILEGE_CODE,
241: CREATED_BY = p_role_privilege_record.CREATED_BY,

Line 298: DELETE FROM WSH_ROLE_PRIVILEGES

294: --
295: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
296: END IF;
297: --
298: DELETE FROM WSH_ROLE_PRIVILEGES
299: WHERE rowid = p_rowid;
300: IF SQL%NOTFOUND THEN
301: RAISE NO_DATA_FOUND;
302: END IF;

Line 324: -- to that role from wsh_role_privileges.

320: END Delete_Row;
321:
322:
323: -- This will delete all the data access privileges attached
324: -- to that role from wsh_role_privileges.
325: -- Following are the data access privileges.
326: -- TRIP_VIEW, TRIP_EDIT, STOP_VIEW, STOP_EDIT, DLVY_VIEW,
327: -- DLVY_EDIT, DLVB_VIEW, DLVB_EDIT', GENR_VIEW, GENR_EDIT
328:

Line 356: DELETE FROM WSH_ROLE_PRIVILEGES

352: --
353: WSH_DEBUG_SV.log(l_module_name,'P_ROLE_ID',P_ROLE_ID);
354: END IF;
355: --
356: DELETE FROM WSH_ROLE_PRIVILEGES
357: WHERE role_id = p_role_id
358: AND privilege_code
359: IN('TRIP_VIEW','TRIP_EDIT',
360: 'STOP_VIEW','STOP_EDIT',