PACKAGE: APPS.WSH_RU_ROLES_PVT

Source

1 PACKAGE WSH_RU_ROLES_PVT AUTHID CURRENT_USER AS
2 /* $Header: WSHROTHS.pls 115.2 2002/11/12 01:50:24 nparikh ship $ */
3 
4   TYPE Role_Type IS RECORD (
5 	ROLE_ID			NUMBER(15),
6 	NAME			VARCHAR2(30),
7 	DESCRIPTION		VARCHAR2(240),
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_record	IN  Role_Type,
17 	x_rowid		OUT NOCOPY  VARCHAR2,
18 	x_role_id	OUT NOCOPY  NUMBER,
19 	x_return_status OUT NOCOPY  VARCHAR2);
20 
21   PROCEDURE Lock_Row(
22 	p_rowid		IN VARCHAR2,
23 	p_role_record	IN Role_Type);
24 
25   PROCEDURE Update_Row(
26 	p_rowid		IN  VARCHAR2,
27 	p_role_record	IN  Role_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 END WSH_RU_ROLES_PVT;