1 PACKAGE JTF_NOTES_SECURITY_PVT AUTHID CURRENT_USER as
2 /* $Header: jtfvnss.pls 115.4 2003/08/15 21:57:33 akaran ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_NOTES_SECURITY_PVT';
5
6 G_FUNCTION_CREATE CONSTANT VARCHAR2(30) := 'JTF_NOTE_CREATE';
7 G_FUNCTION_SELECT CONSTANT VARCHAR2(30) := 'JTF_NOTE_SELECT';
8 G_FUNCTION_DELETE CONSTANT VARCHAR2(30) := 'JTF_NOTE_DELETE';
9 G_FUNCTION_UPDATE_NOTE CONSTANT VARCHAR2(30) := 'JTF_NOTE_UPDATE_NOTES';
10 G_FUNCTION_UPDATE_NOTE_DTLS CONSTANT VARCHAR2(30) := 'JTF_NOTE_UPDATE_NOTE_DETAILS';
11 G_FUNCTION_UPDATE_SEC CONSTANT VARCHAR2(30) := 'JTF_NOTE_UPDATE_SECONDARY';
12 G_FUNCTION_TYPE_SELECT CONSTANT VARCHAR2(30) := 'JTF_NOTE_TYPE_SELECT';
13 G_OBJECT_NOTE CONSTANT VARCHAR2(30) := 'JTF_NOTES';
14 G_OBJECT_NOTE_TYPE CONSTANT VARCHAR2(30) := 'JTF_NOTE_TYPES';
15
16
17 PROCEDURE check_notes_access
18 -- --------------------------------------------------------------------------
19 -- Start of notes
20 -- API Name : check_notes_access
21 -- Type : Private
22 -- Usage : Check notes access using AOL security
23 -- Version : Initial version 1.0
24 --
25 --
26 -- End of notes
27 -- --------------------------------------------------------------------------
28 ( p_api_version IN NUMBER
29 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
30 , p_note_id IN NUMBER
31 , x_select_predicate IN OUT NOCOPY VARCHAR2
32 , x_note_type_predicate IN OUT NOCOPY VARCHAR2
33 , x_select_access IN OUT NOCOPY NUMBER
34 , x_create_access IN OUT NOCOPY NUMBER
35 , x_update_note_access IN OUT NOCOPY NUMBER
36 , x_update_note_details_access IN OUT NOCOPY NUMBER
37 , x_update_secondary_access IN OUT NOCOPY NUMBER
38 , x_delete_access IN OUT NOCOPY NUMBER
39 , x_return_status OUT NOCOPY VARCHAR2
40 , x_msg_count OUT NOCOPY NUMBER
41 , x_msg_data OUT NOCOPY VARCHAR2
42 );
43
44
45 PROCEDURE get_security_predicate
46 -- --------------------------------------------------------------------------
47 -- Start of notes
48 -- API Name : get_security_predicate
49 -- Type : Private
50 -- Usage : Get Security Predicate for a given function
51 -- Version : Initial version 1.0
52 --
53 --
54 -- End of notes
55 -- --------------------------------------------------------------------------
56 ( p_api_version IN NUMBER
57 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
58 , p_object_name IN VARCHAR2 DEFAULT NULL
59 , p_function IN VARCHAR2 DEFAULT NULL
60 , p_grant_instance_type IN VARCHAR2 DEFAULT 'UNIVERSAL'
61 , p_user_name IN VARCHAR2 DEFAULT NULL
62 , p_statement_type IN VARCHAR2 DEFAULT 'OTHER'
63 , p_table_alias IN VARCHAR2 DEFAULT NULL
64 , x_predicate OUT NOCOPY VARCHAR2
65 , x_return_status OUT NOCOPY VARCHAR2
66 , x_msg_count OUT NOCOPY NUMBER
67 , x_msg_data OUT NOCOPY VARCHAR2
68 );
69
70
71 PROCEDURE get_functions
72 -- --------------------------------------------------------------------------
73 -- Start of notes
74 -- API Name : get_functions
75 -- Type : Private
76 -- Usage : Get All security functions on which the logged in user has access
77 -- Version : Initial version 1.0
78 --
79 --
80 -- End of notes
81 -- --------------------------------------------------------------------------
82 ( p_api_version IN NUMBER
83 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
84 , p_object_name IN VARCHAR2
85 , p_instance_pk1_value IN VARCHAR2 DEFAULT NULL
86 , p_instance_pk2_value IN VARCHAR2 DEFAULT NULL
87 , p_instance_pk3_value IN VARCHAR2 DEFAULT NULL
88 , p_instance_pk4_value IN VARCHAR2 DEFAULT NULL
89 , p_instance_pk5_value IN VARCHAR2 DEFAULT NULL
90 , p_user_name IN VARCHAR2 DEFAULT NULL
91 , x_return_status OUT NOCOPY VARCHAR2
92 , x_privilege_tbl OUT NOCOPY FND_DATA_SECURITY.FND_PRIVILEGE_NAME_TABLE_TYPE
93 , x_msg_count OUT NOCOPY NUMBER
94 , x_msg_data OUT NOCOPY VARCHAR2
95 );
96
97
98 PROCEDURE check_function
99 -- --------------------------------------------------------------------------
100 -- Start of notes
101 -- API Name : check_function
102 -- Type : Private
103 -- Usage : Check if the logged in user has access on a given Security function
104 -- Version : Initial version 1.0
105 --
106 --
107 -- End of notes
108 -- --------------------------------------------------------------------------
109 ( p_api_version IN NUMBER
110 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
111 , p_function IN VARCHAR2
112 , p_object_name IN VARCHAR2
113 , p_instance_pk1_value IN VARCHAR2 DEFAULT NULL
114 , p_instance_pk2_value IN VARCHAR2 DEFAULT NULL
115 , p_instance_pk3_value IN VARCHAR2 DEFAULT NULL
116 , p_instance_pk4_value IN VARCHAR2 DEFAULT NULL
117 , p_instance_pk5_value IN VARCHAR2 DEFAULT NULL
118 , p_user_name IN VARCHAR2 DEFAULT NULL
119 , x_return_status OUT NOCOPY VARCHAR2
120 , x_grant OUT NOCOPY NUMBER -- 1 yes, 0 no
121 , x_msg_count OUT NOCOPY NUMBER
122 , x_msg_data OUT NOCOPY VARCHAR2
123 );
124
125
126 PROCEDURE check_note_type
127 -- --------------------------------------------------------------------------
128 -- Start of notes
129 -- API Name : check_note_type
130 -- Type : Private
131 -- Usage : Check if the logged in user has access on the given note type
132 -- Version : Initial version 1.0
133 --
134 --
135 -- End of notes
136 -- --------------------------------------------------------------------------
137 ( p_api_version IN NUMBER
138 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
139 , p_note_type IN VARCHAR2
140 , x_return_status OUT NOCOPY VARCHAR2
141 , x_grant OUT NOCOPY NUMBER -- 1 yes, 0 no
142 , x_msg_count OUT NOCOPY NUMBER
143 , x_msg_data OUT NOCOPY VARCHAR2
144 );
145
146 FUNCTION check_update_sec_access
147 -- --------------------------------------------------------------------------
148 -- Start of notes
149 -- API Name : check_update_sec_access
150 -- Type : Private
151 -- Usage : Check notes access using AOL security
152 -- Version : Initial version 1.0
153 --
154 --
155 -- End of notes
156 -- --------------------------------------------------------------------------
157 ( p_note_id IN NUMBER
158 ) RETURN INTEGER;
159
160 FUNCTION check_update_prim_access
161 -- --------------------------------------------------------------------------
162 -- Start of notes
163 -- API Name : check_update_prim_access
164 -- Type : Private
165 -- Usage : Check notes access using AOL security
166 -- Version : Initial version 1.0
167 --
168 --
169 -- End of notes
170 -- --------------------------------------------------------------------------
171 ( p_note_id IN NUMBER
172 ) RETURN INTEGER;
173
174 FUNCTION check_delete_access
175 -- --------------------------------------------------------------------------
176 -- Start of notes
177 -- API Name : check_udelete_access
178 -- Type : Private
179 -- Usage : Check delete notes access using AOL security
180 -- Version : Initial version 1.0
181 --
182 --
183 -- End of notes
184 -- --------------------------------------------------------------------------
185 ( p_note_id IN NUMBER
186 ) RETURN INTEGER;
187
188 END JTF_NOTES_SECURITY_PVT;