1 PACKAGE cn_user_access_pvt AUTHID CURRENT_USER AS
2 --$Header: cnvurass.pls 115.6 2002/11/25 19:08:41 nkodkani ship $
3 TYPE user_access_rec_type IS record
4 (user_access_id number,
5 user_id number,
6 comp_group_id number,
7 org_code varchar(30),
8 access_code varchar(30),
9 attribute_category varchar2(30),
10 attribute1 varchar2(150),
11 attribute2 varchar2(150),
12 attribute3 varchar2(150),
13 attribute4 varchar2(150),
14 attribute5 varchar2(150),
15 attribute6 varchar2(150),
16 attribute7 varchar2(150),
17 attribute8 varchar2(150),
18 attribute9 varchar2(150),
19 attribute10 varchar2(150),
20 attribute11 varchar2(150),
21 attribute12 varchar2(150),
22 attribute13 varchar2(150),
23 attribute14 varchar2(150),
24 attribute15 varchar2(150),
25 object_version_number number);
26
27 TYPE user_access_tbl_type IS
28 TABLE OF user_access_rec_type INDEX BY BINARY_INTEGER;
29
30 TYPE user_access_sum_rec_type IS RECORD
31 (user_id number,
32 full_name varchar2(240),
33 user_name varchar2(100));
34
35 TYPE user_access_sum_tbl_type IS
36 TABLE OF user_access_sum_rec_type INDEX BY BINARY_INTEGER;
37
38 -- Start of comments
39 -- API name : Create_User_Access
40 -- Pre-reqs : None.
41 -- IN : standard params
42 -- p_rec of table rec type
43 -- OUT : standard params
44 -- x_user_access_id
45 -- Version : 1.0
46 --
47 -- End of comments
48
49 PROCEDURE Create_User_Access
50 (p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52 p_commit IN VARCHAR2 := FND_API.G_FALSE,
53 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54 p_rec IN user_access_rec_type,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 x_user_access_id OUT NOCOPY NUMBER);
59
60 -- Start of comments
61 -- API name : Update_User_Access
62 -- Pre-reqs : None.
63 -- IN : standard params
64 -- p_rec of table rec type
65 -- OUT : standard params
66 -- Version : 1.0
67 --
68 -- End of comments
69
70 PROCEDURE Update_User_Access
71 (p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73 p_commit IN VARCHAR2 := FND_API.G_FALSE,
74 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75 p_rec IN user_access_rec_type,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2);
79
80 -- Start of comments
81 -- API name : Delete_User_Access
82 -- Pre-reqs : None.
83 -- IN : standard params
84 -- p_user_access_id
85 -- OUT : standard params
86 -- Version : 1.0
87 --
88 -- End of comments
89
90 PROCEDURE Delete_User_Access
91 (p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
93 p_commit IN VARCHAR2 := FND_API.G_FALSE,
94 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95 p_user_access_id IN NUMBER,
96 p_object_version_number IN NUMBER,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2);
100
101 -- Start of comments
102 -- API name : Get_Accesses - Private
103 -- Pre-reqs : None.
104 -- IN : range params
105 -- OUT : x_result_tbl
106 -- Version : Current version 1.0
107 --
108 -- End of comments
109
110 PROCEDURE Get_Accesses
111 (p_range_low IN NUMBER,
112 p_range_high IN NUMBER,
113 x_total_rows OUT NOCOPY NUMBER,
114 x_result_tbl OUT NOCOPY user_access_sum_tbl_type);
115
116 -- Start of comments
117 -- API name : Get_Access_Details - Private
118 -- Pre-reqs : None.
119 -- IN : p_user_id
120 -- OUT : x_result_tbl
121 -- Version : Current version 1.0
122 --
123 -- End of comments
124
125 PROCEDURE Get_Access_Details
126 (p_user_id IN NUMBER,
127 x_result_tbl OUT NOCOPY user_access_tbl_type);
128
129 END CN_USER_ACCESS_PVT;