Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\wf\sql\WFDSEVSS.pls
REM dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \ REM dbdrv: checkfile:~PROD:~PATH:~FILE --=========================================================================-- -- Copyright (c)2001 Oracle Corporation, Redwood Shores, California, USA -- -- All rights reserved. -- --=========================================================================-- -- FILENAME -- -- WFDSEVSS.pls -- -- -- -- DESCRIPTION -- -- Evidence Store for Digital/Electronic Signatures. -- -- -- -- PROCEDURES -- -- -- -- -- -- NOTES -- -- -- -- HISTORY -- -- 8/11/02 M Fisher created. -- -- -- -- -- --=========================================================================-- SET verify off whenever sqlerror EXIT failure ROLLBACK; WHENEVER OSERROR EXIT FAILURE ROLLBACK; CREATE OR REPLACE PACKAGE WF_Dig_Sig_Evidence_Store AS /* $Header: WFDSEVSS.pls 26.1 2003/01/13 04:19:39 vshanmug ship $ */ -- -- Function -- GetMostRecentSigID -- -- Purpose -- Finds most recently created Sig_ID for a given object Type/ID -- (e.g. WF_NTF 1234). -- -- Returns: SIG_ID for success; -1 if not successful. -- -- Function GetMostRecentSigID( SigObjType VARCHAR2, SigObjID VARCHAR2) return number; -- -- Function -- GetCertID -- -- Purpose -- Finds Cert_ID for a given Sig ID -- -- Returns: Cert_ID for success; -1 if not successful. -- -- Function GetCertID(SigID NUMBER) return number; -- -- Function -- GetSigFlavor -- -- Purpose -- Finds SigFlavor for a given Sig ID -- -- Returns: SigFlavor for success; null if not successful. -- -- Function GetSigFlavor(SigID NUMBER) return Varchar2; -- -- Function -- GetSigPolicy -- -- Purpose -- Finds SigPolicy for a given Sig ID -- -- Returns: SigPolicy for success; null if not successful. -- -- Function GetSigPolicy(SigID NUMBER) return Varchar2; -- -- Procedure -- GetSignature -- -- Purpose -- Finds Signature for a given Sig ID -- Procedure GetSignature(SigID NUMBER, Sig out nocopy Clob); -- -- Procedure -- GetSigObjectInfo -- -- Purpose -- Finds Object Info for a given Sig ID -- Procedure GetSigObjectInfo(SigID NUMBER, ObjType out nocopy Varchar2, ObjID out nocopy varchar2, ObjText out nocopy CLOB); -- -- Procedure -- GetSigStatusInfo -- -- Purpose -- Finds Status Info for a given Sig ID -- Procedure GetSigStatusInfo(SigID NUMBER, SigStatus out nocopy Number, CreationDate out nocopy Date, SignedDate out nocopy Date, VerifiedDate out nocopy Date, LastAttValDate out nocopy Date, ValidatedDate out nocopy Date, Ebuf out nocopy Varchar2, Estack out nocopy Varchar2); -- -- Procedure -- GetReqSignerInfo -- -- Purpose -- Finds Requested Signer Info for a given Sig ID -- Procedure GetReqSignerInfo(SigID NUMBER, SignerType out nocopy Varchar2, SignerID out nocopy varchar2); -- -- Procedure -- GetActualSignerInfo -- -- Purpose -- Finds Actual Signer Info for a given Sig ID -- Procedure GetActualSignerInfo(SigID NUMBER, SignerType out nocopy Varchar2, SignerID out nocopy varchar2); -- -- Function -- GetCertType -- -- Purpose -- Finds Cert_Type for a given Cert ID -- -- Returns: CertType for success; null if not successful. -- -- Function GetCertType(CertID NUMBER) return Varchar2; END WF_Dig_Sig_Evidence_Store; / COMMIT; exit;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de