PACKAGE: APPS.WSH_RU_ROLE_PRIVILEGES_PVT

Source

1 PACKAGE WSH_RU_ROLE_PRIVILEGES_PVT AUTHID CURRENT_USER AS
2 /* $Header: WSHRPTHS.pls 115.3 2003/09/16 22:47:38 sperera ship $ */
3 
4   TYPE Role_Privilege_Type IS RECORD (
5 	ROLE_PRIVILEGE_ID	NUMBER(15),
6 	ROLE_ID			NUMBER(15),
7 	PRIVILEGE_CODE		VARCHAR2(30),
8 	CREATED_BY		NUMBER(15),
9 	CREATION_DATE		DATE,
10 	LAST_UPDATED_BY		NUMBER(15),
11 	LAST_UPDATE_DATE	DATE,
12 	LAST_UPDATE_LOGIN	NUMBER(15)
13   );
14 
15   PROCEDURE Insert_Row(
16 	p_role_privilege_record	IN  Role_Privilege_Type,
17 	x_rowid		OUT NOCOPY  VARCHAR2,
18 	x_role_privilege_id	OUT NOCOPY  NUMBER,
19 	x_return_status OUT NOCOPY  VARCHAR2);
20 
21   PROCEDURE Lock_Row(
22 	p_rowid		IN VARCHAR2,
23 	p_role_privilege_record	IN Role_Privilege_Type);
24 
25   PROCEDURE Update_Row(
26 	p_rowid		IN  VARCHAR2,
27 	p_role_privilege_record	IN  Role_Privilege_Type,
28 	x_return_status OUT NOCOPY  VARCHAR2);
29 
30   PROCEDURE Delete_Row(
31 	p_rowid		IN  VARCHAR2,
32 	x_return_status OUT NOCOPY  VARCHAR2);
33 
34   PROCEDURE Delete_Role_Privileges(
35         p_role_id       IN NUMBER,
36         x_return_status OUT NOCOPY VARCHAR2);
37 
38 
39 
40 END WSH_RU_ROLE_PRIVILEGES_PVT;