[Home] [Help]
PACKAGE: APPS.WF_DIGITAL_SECURITY_PRIVATE
Source
1 PACKAGE WF_Digital_Security_Private AS
2 /* $Header: WFDSPVTS.pls 120.1 2005/07/02 03:13:36 appldev ship $ */
3 -----------------------------------------------------------------------------
4 -- Constants
5 -----------------------------------------------------------------------------
6
7 STAT_ERROR CONSTANT NUMBER := -1;
8 STAT_REQUESTED CONSTANT NUMBER := 100;
9 STAT_SIGNED CONSTANT NUMBER := 200;
10 STAT_VERIFIED CONSTANT NUMBER := 300;
11 STAT_AUTHORIZED CONSTANT NUMBER := 400;
12 STAT_VAL_ATTEMPTED CONSTANT NUMBER := 500;
13 STAT_VALIDATED CONSTANT NUMBER := 600;
14 STAT_REQUEST_FAILED CONSTANT NUMBER := -100;
15 STAT_SIGN_FAILED CONSTANT NUMBER := -200;
16 STAT_SIGN_CANCELLED CONSTANT NUMBER := -201;
17 STAT_VERIFY_FAILED CONSTANT NUMBER := -300;
18 STAT_AUTHORIZE_FAILED CONSTANT NUMBER := -400;
19 STAT_VALIDATE_FAILED CONSTANT NUMBER := -600;
20
21
22
23 -----------------------------------------------------------------------------
24 -- Type declaration
25 -----------------------------------------------------------------------------
26 TYPE objid_tab_type IS TABLE OF varchar2(20) INDEX BY BINARY_INTEGER;
27
28
29 -----------------------------------------------------------------------------
30 -- Routines
31 -----------------------------------------------------------------------------
32
33
34 --
35 -- Procedure
36 -- Create_Signature_Entry
37 --
38 -- Purpose
39 -- Creates a new row in WF_DIG_SIGS
40 --
41 -- Returns: 0 for success; -1 if not successful.
42 --
43 --
44
45 Procedure Create_Signature_Entry(
46 P_SIG_ID NUMBER,
47 P_SIG_OBJ_TYPE VARCHAR2,
48 P_SIG_OBJ_ID Varchar2,
49 P_PLAINTEXT CLOB,
50 P_REQUESTED_SIGNER_TYPE Varchar2,
51 P_REQUESTED_SIGNER_ID Varchar2,
52 P_Sig_Flavor Varchar2,
53 P_Sig_Policy Varchar2,
54 P_STATUS NUMBER,
55 P_returncode out nocopy number);
56
57 --
58 -- Function
59 -- Update_Signed_Sig
60 --
61 -- Purpose
62 -- Updates a row in WF_DIG_SIGS
63 --
64 -- Returns: 0 for success; -1 if not successful.
65 --
66 --
67
68 Procedure Update_Signed_Sig(
69 P_SIG_ID NUMBER,
70 P_SIGNATURE CLOB,
71 P_STATUS NUMBER,
72 P_returncode out nocopy number);
73
74 --
75 -- Procedure
76 -- Update_Verified_Sig
77 --
78 -- Purpose
79 -- Updates a row in WF_DIG_SIGS
80 --
81 -- Returns: 0 for success; -1 if not successful.
82 --
83 --
84
85 Procedure Update_Verified_Sig(
86 P_SIG_ID NUMBER,
87 P_CERT_ID NUMBER,
88 P_STATUS NUMBER,
89 P_returncode out nocopy number);
90
91 --
92 -- Procedure
93 -- Update_Validated_Sig
94 --
95 -- Purpose
96 -- Updates a row in WF_DIG_SIGS
97 --
98 -- Returns: 0 for success; -1 if not successful.
99 --
100 --
101
102 Procedure Update_Validated_Sig(
103 P_SIG_ID NUMBER,
104 P_STATUS NUMBER,
105 P_returncode out nocopy number);
106
107 --
108 -- Procedure
109 -- Update_Sig_Error
110 --
111 -- Purpose
112 -- Creates a new row in WF_DIG_SIGS
113 --
114 -- Returns: 0 for success; -1 if not successful.
115 --
116 --
117
118 Procedure Update_Sig_Error(
119 P_SIG_ID NUMBER,
120 P_STATUS NUMBER,
121 P_ERRBUF VARCHAR2,
122 P_returncode out nocopy number);
123
124 --
125 -- Function
126 -- PSIG_Cert_To_ID
127 --
128 -- Purpose
129 -- Registers a PSIG cert if it isn't already there.
130 --
131 -- Returns: cert ID or -1 if not successful.
132 --
133 --
134
135 Function PSIG_Cert_To_ID(
136 P_USER VARCHAR2) return number;
137
138 --
139 -- Procedure
140 -- Get_Requested_Signer
141 --
142 -- Purpose
143 -- Gets Requested Signer info for a sig.
144 --
145 -- Returns: -1 (for ID) if not successful.
146 --
147 --
148
149 Procedure Get_Requested_Signer( P_SIGNATURE_ID in Number,
150 P_reqSignerType out nocopy Varchar2,
151 P_reqSignerID out nocopy Varchar2);
152
153 --
154 -- Procedure
155 -- Authorize_Signature
156 --
157 -- Purpose
158 -- Determines if actual signer is authorized to sign for requested
159 -- signer. E.g. Does the user have the desired responsibility. Updates
160 -- the WF_DIG_SIGS table.
161 --
162 -- Returns: .
163 -- Outcome = either "AUTHORIZED" or "FAILED".
164 --
165 --
166
167 Procedure Authorize_Signature(P_SIGNATURE_ID In Number,
168 P_OUTCOME out nocopy Varchar2);
169
170
171 --
172 -- Procedure
173 -- Get_SPI_Info
174 --
175 -- Purpose
176 -- Gets SPI info for a sig ID.
177 --
178 -- Returns: nulls if not successful.
179 --
180 --
181
182 Procedure Get_SPI_Info( P_SIGNATURE_ID in Number,
183 P_Flavor out nocopy Varchar2,
184 P_BSR out nocopy Varchar2,
185 P_Verifier out nocopy Varchar2,
186 P_Validator out nocopy Varchar2,
187 P_CertMapper out nocopy Varchar2,
188 P_Validator_Store out nocopy Varchar2,
189 P_Validation_Mode out nocopy Varchar2,
190 P_Signature_Format out nocopy Varchar2,
191 P_Signature_Mode out nocopy Varchar2);
192 --
193 -- Procedure
194 -- Get_SPI_Info
195 --
196 -- Purpose
197 -- Gets SPI info for a Flavor.
198 --
199 -- Returns: nulls if not successful.
200 --
201 --
202
203 Procedure Get_SPI_Info( P_Flavor In Varchar2,
204 P_BSR out nocopy Varchar2,
205 P_Verifier out nocopy Varchar2,
206 P_Validator out nocopy Varchar2,
207 P_CertMapper out nocopy Varchar2,
208 P_Validator_Store out nocopy Varchar2,
209 P_Validation_Mode out nocopy Varchar2,
210 P_Signature_Format out nocopy Varchar2,
211 P_Signature_Mode out nocopy Varchar2);
212
213 --
214 -- Function
215 -- Get_Next_Sig_ID
216 --
217 -- Purpose
218 -- Yanks an ID off of the sequence WF_DIG_SIGS_S
219 --
220 -- Parameters
221 --
222 -- Returns: -1 if not successful.
223 --
224 --
225
226 Function Get_Next_Sig_ID return number;
227
228 --
229 --Bug No#3062359
230 --Function
231 -- Upload_Certificate
232 --
233 -- Purpose
234 -- Upload the given certificate data to the table
235 --
236 --Returns : ID or -1 if not successful
237 --
238 Function Upload_X509_Certificate(
239 p_cert clob,
240 p_cert_type varchar2,
241 p_parent_cert_id number,
242 p_owner_id varchar2,
243 p_owner_domain varchar2,
244 p_valid varchar2,
245 p_sot_flag varchar2,
246 p_intermediate_flag varchar2,
247 p_fingerprint varchar2,
248 p_expire date,
249 p_security_group_id varchar2,
250 p_subjectdn varchar2,
251 p_issuer varchar2,
252 p_crl_url varchar2
253 )
254 return number;
255
256 --
257 --Bug No#3062359
258 -- Function
259 -- X509_ID_To_Cert
260 --
261 -- Purpose
262 -- get a certificate from the given id
263 --
264 -- Returns: certificate if certificate exists for the id
265 --
266 --
267 Function X509_ID_To_Cert(p_cert_id number)return CLOB;
268
269 --Bug No#3062359
270 -- Function
271 -- X509_Cert_To_ID
272 --
273 -- Purpose
274 -- get the id of the certificate of given fingerprint and certificate data
275 --
276 -- Returns: id if certificate of given fingerprint and certificate matches
277 --
278 Function X509_Cert_To_ID(
279 p_certificate clob,
280 p_fingerprint varchar2)
281 return number;
282
283 -- Function
284 -- Store_CRL
285 --
286 -- Purpose
287 -- Stores the given CRL into WF_Dig_Crls. If the CRL already exists
288 -- then the crl_id of the existing CRL is returned. Otherwise, the new
289 -- CRL is stored and the CRL_ID is returned
290 --
291 -- Returns CRL_ID
292 --
293
294 Function Store_CRL (P_validation_Mode In Number,
295 P_Issuer In Varchar2,
296 P_Toi In Date,
297 P_Ton In Date,
298 P_CRL In CLOB) return number;
299
300 --
301 -- Procedure
302 -- GetVerifyData
303 --
304 -- Purpose
305 -- Finds plaintext, Signature for a given Sig ID
306 --
307
308 Procedure GetVerifyData (SigID NUMBER,
309 PText out nocopy Clob,
310 Sig out nocopy Clob);
311
312 --
313 -- Procedure
314 -- Purge_Signature_By_Sig_ID
315 --
316 -- Purpose
317 -- Removes Signature for a given Signature ID
318 --
319
320 Procedure Purge_Signature_By_Sig_ID(SigID NUMBER);
321
322
323 --
324 -- Procedure
325 -- Purge_Signature_By_Obj_ID
326 --
327 -- Purpose
328 -- Removes Signature for a given Object ID
329 --
330
331 Procedure Purge_Signature_By_Obj_ID(Obj_Type varchar2, Obj_ID varchar2);
332
333 --
334 -- Procedure
335 -- Purge_Signature_By_Obj_ID
336 --
337 -- Purpose
338 -- Removes Signature for a given set of object ids
339 --
340
341 Procedure Purge_Signature_By_Obj_ID(Obj_Type varchar2,
342 Obj_IDs objid_tab_type);
343
344 END WF_Digital_Security_Private;