DBA Data[Home] [Help]

PACKAGE: APPS.WSH_RU_GRANTS_PVT

Source


1 PACKAGE WSH_RU_GRANTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: WSHGRTHS.pls 115.2 2002/11/12 01:35:37 nparikh ship $ */
3 
4   TYPE Grant_Type IS RECORD (
5 	GRANT_ID		NUMBER(15),
6 	USER_ID			NUMBER(15),
7 	ROLE_ID			NUMBER(15),
8 	ORGANIZATION_ID		NUMBER(15),
9 	START_DATE		DATE,
10 	END_DATE		DATE,
11 	CREATED_BY		NUMBER(15),
12 	CREATION_DATE		DATE,
13 	LAST_UPDATED_BY		NUMBER(15),
14 	LAST_UPDATE_DATE	DATE,
15 	LAST_UPDATE_LOGIN	NUMBER(15)
16   );
17 
18   PROCEDURE Insert_Row(
19 	p_grant_record	IN  Grant_Type,
20 	x_rowid		OUT NOCOPY  VARCHAR2,
21 	x_grant_id	OUT NOCOPY  NUMBER,
22 	x_return_status OUT NOCOPY  VARCHAR2);
23 
24   PROCEDURE Lock_Row(
25 	p_rowid		IN VARCHAR2,
26 	p_grant_record	IN Grant_Type);
27 
28   PROCEDURE Update_Row(
29 	p_rowid		IN  VARCHAR2,
30 	p_grant_record	IN  Grant_Type,
31 	x_return_status OUT NOCOPY  VARCHAR2);
32 
33   PROCEDURE Delete_Row(
34 	p_rowid		IN  VARCHAR2,
35 	x_return_status OUT NOCOPY  VARCHAR2);
36 
37 END WSH_RU_GRANTS_PVT;