APPS.WF_DIG_SIG_EVIDENCE_STORE dependencies on WF_DIG_SIGS

Line 23: from wf_dig_sigs

19:
20: /* cursor to get most recent activity */
21: cursor cursig(ObjType varchar2, ObjID number) is
22: Select SIG_ID
23: from wf_dig_sigs
24: where Sig_Obj_Type = ObjType
25: and Sig_Obj_ID = ObjID
26: order by sig_id desc;
27:

Line 61: from wf_dig_sigs

57:
58: begin
59: Select nvl(Cert_ID,-1)
60: into retval
61: from wf_dig_sigs
62: where Sig_Id = SigID;
63:
64: return retval;
65: exception

Line 87: from wf_dig_sigs

83:
84: begin
85: Select Sig_Flavor
86: into retval
87: from wf_dig_sigs
88: where Sig_Id = SigID;
89:
90: return retval;
91: exception

Line 113: from wf_dig_sigs

109:
110: begin
111: Select Sig_Policy
112: into retval
113: from wf_dig_sigs
114: where Sig_Id = SigID;
115:
116: return retval;
117: exception

Line 135: from wf_dig_sigs

131:
132: begin
133: Select Signature
134: into Sig
135: from wf_dig_sigs
136: where Sig_Id = SigID;
137:
138: exception
139: when others then Sig := null;

Line 157: from wf_dig_sigs

153:
154: begin
155: Select Sig_Obj_Type, Sig_Obj_ID, Plaintext
156: into ObjType, ObjID, ObjText
157: from wf_dig_sigs
158: where Sig_Id = SigID;
159:
160: exception
161: when others then

Line 191: from wf_dig_sigs

187: Select Status, Creation_Date, Signed_Date, Verified_Date,
188: Last_Validation_Attempt, Validated_Complete_Date, Errbuf, ErrStack
189: into SigStatus, CreationDate, SignedDate, VerifiedDate,
190: LastAttValDate, ValidatedDate, Ebuf, Estack
191: from wf_dig_sigs
192: where Sig_Id = SigID;
193:
194: exception
195: when others then

Line 222: from wf_dig_sigs

218:
219: begin
220: Select Requested_Signer_Type, Requested_Signer_ID
221: into SignerType, SignerID
222: from wf_dig_sigs
223: where Sig_Id = SigID;
224:
225: exception
226: when others then

Line 247: from wf_dig_sigs S, wf_dig_certs C

243:
244: begin
245: Select c.Owner_domain, c.Owner_ID
246: into SignerType, SignerID
247: from wf_dig_sigs S, wf_dig_certs C
248: where S.Sig_Id = SigID
249: and S.cert_id = C.cert_id;
250:
251: exception