1 PACKAGE WF_Dig_Sig_Evidence_Store AUTHID CURRENT_USER AS
2 /* $Header: WFDSEVSS.pls 115.5 2003/01/13 04:09:23 vshanmug ship $ */
3
4 --
5 -- Function
6 -- GetMostRecentSigID
7 --
8 -- Purpose
9 -- Finds most recently created Sig_ID for a given object Type/ID
10 -- (e.g. WF_NTF 1234).
11 --
12 -- Returns: SIG_ID for success; -1 if not successful.
13 --
14 --
15
16 Function GetMostRecentSigID(
17 SigObjType VARCHAR2,
18 SigObjID VARCHAR2) return number;
19
20 --
21 -- Function
22 -- GetCertID
23 --
24 -- Purpose
25 -- Finds Cert_ID for a given Sig ID
26 --
27 -- Returns: Cert_ID for success; -1 if not successful.
28 --
29 --
30
31 Function GetCertID(SigID NUMBER) return number;
32
33 --
34 -- Function
35 -- GetSigFlavor
36 --
37 -- Purpose
38 -- Finds SigFlavor for a given Sig ID
39 --
40 -- Returns: SigFlavor for success; null if not successful.
41 --
42 --
43
44 Function GetSigFlavor(SigID NUMBER) return Varchar2;
45
46 --
47 -- Function
48 -- GetSigPolicy
49 --
50 -- Purpose
51 -- Finds SigPolicy for a given Sig ID
52 --
53 -- Returns: SigPolicy for success; null if not successful.
54 --
55 --
56
57 Function GetSigPolicy(SigID NUMBER) return Varchar2;
58
59 --
60 -- Procedure
61 -- GetSignature
62 --
63 -- Purpose
64 -- Finds Signature for a given Sig ID
65 --
66
67 Procedure GetSignature(SigID NUMBER, Sig out nocopy Clob);
68
69 --
70 -- Procedure
71 -- GetSigObjectInfo
72 --
73 -- Purpose
74 -- Finds Object Info for a given Sig ID
75 --
76
77 Procedure GetSigObjectInfo(SigID NUMBER, ObjType out nocopy Varchar2,
78 ObjID out nocopy varchar2, ObjText out nocopy CLOB);
79
80 --
81 -- Procedure
82 -- GetSigStatusInfo
83 --
84 -- Purpose
85 -- Finds Status Info for a given Sig ID
86 --
87
88 Procedure GetSigStatusInfo(SigID NUMBER, SigStatus out nocopy Number,
89 CreationDate out nocopy Date,
90 SignedDate out nocopy Date,
91 VerifiedDate out nocopy Date,
92 LastAttValDate out nocopy Date,
93 ValidatedDate out nocopy Date,
94 Ebuf out nocopy Varchar2,
95 Estack out nocopy Varchar2);
96
97 --
98 -- Procedure
99 -- GetReqSignerInfo
100 --
101 -- Purpose
102 -- Finds Requested Signer Info for a given Sig ID
103 --
104
105 Procedure GetReqSignerInfo(SigID NUMBER, SignerType out nocopy Varchar2,
106 SignerID out nocopy varchar2);
107
108 --
109 -- Procedure
110 -- GetActualSignerInfo
111 --
112 -- Purpose
113 -- Finds Actual Signer Info for a given Sig ID
114 --
115
116 Procedure GetActualSignerInfo(SigID NUMBER, SignerType out nocopy Varchar2,
117 SignerID out nocopy varchar2);
118
119 --
120 -- Function
121 -- GetCertType
122 --
123 -- Purpose
124 -- Finds Cert_Type for a given Cert ID
125 --
126 -- Returns: CertType for success; null if not successful.
127 --
128 --
129
130 Function GetCertType(CertID NUMBER) return Varchar2;
131
132
133 END WF_Dig_Sig_Evidence_Store;