[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;