APPS.WF_DIGITAL_SECURITY_PRIVATE dependencies on WF_DIG_SIGS

Line 30: -- Creates a new row in WF_DIG_SIGS

26: -- Procedure
27: -- Create_Signature_Entry
28: --
29: -- Purpose
30: -- Creates a new row in WF_DIG_SIGS
31: --
32: -- Returns: 0 for success; -1 if not successful.
33: --
34: --

Line 51: insert into WF_DIG_SIGS

47:
48: PRAGMA AUTONOMOUS_TRANSACTION;
49:
50: begin
51: insert into WF_DIG_SIGS
52: (SIG_ID, SIG_OBJ_TYPE, SIG_OBJ_ID, PLAINTEXT,
53: Requested_Signer_Type, Requested_Signer_ID,
54: Sig_Flavor, Sig_Policy,
55: STATUS, CREATION_DATE)

Line 74: -- Updates row in WF_DIG_SIGS

70: -- Procedure
71: -- Update_Signed_Sig
72: --
73: -- Purpose
74: -- Updates row in WF_DIG_SIGS
75: --
76: -- Returns: 0 for success; -1 if not successful.
77: --
78: --

Line 89: UPDATE WF_DIG_SIGS

85:
86: PRAGMA AUTONOMOUS_TRANSACTION;
87:
88: begin
89: UPDATE WF_DIG_SIGS
90: SET SIGNATURE = P_SIGNATURE,
91: STATUS = P_STATUS,
92: SIGNED_DATE = sysdate
93: where SIG_ID = P_SIG_ID;

Line 107: -- Updates row in WF_DIG_SIGS

103: -- Procedure
104: -- Update_Verified_Sig
105: --
106: -- Purpose
107: -- Updates row in WF_DIG_SIGS
108: --
109: -- Returns: 0 for success; -1 if not successful.
110: --
111: --

Line 122: UPDATE WF_DIG_SIGS

118:
119: PRAGMA AUTONOMOUS_TRANSACTION;
120:
121: begin
122: UPDATE WF_DIG_SIGS
123: SET CERT_ID = P_CERT_ID,
124: STATUS = P_STATUS,
125: VERIFIED_DATE = sysdate
126: where SIG_ID = P_SIG_ID;

Line 140: -- Updates a row in WF_DIG_SIGS

136: -- Procedure
137: -- Update_Validated_Sig
138: --
139: -- Purpose
140: -- Updates a row in WF_DIG_SIGS
141: --
142: -- Returns: 0 for success; -1 if not successful.
143: --
144: --

Line 154: UPDATE WF_DIG_SIGS

150:
151: PRAGMA AUTONOMOUS_TRANSACTION;
152:
153: begin
154: UPDATE WF_DIG_SIGS
155: SET STATUS = P_STATUS,
156: Last_Validation_Attempt = sysdate,
157: Validated_complete_date = Decode(P_STATUS,
158: WF_DIGITAL_SECURITY_PRIVATE.STAT_VALIDATED, sysdate, null)

Line 173: -- Updates a row in WF_DIG_SIGS

169: -- Procedure
170: -- Update_Sig_Error
171: --
172: -- Purpose
173: -- Updates a row in WF_DIG_SIGS
174: --
175: -- Returns: 0 for success; -1 if not successful.
176: --
177: --

Line 188: UPDATE WF_DIG_SIGS

184:
185: PRAGMA AUTONOMOUS_TRANSACTION;
186:
187: begin
188: UPDATE WF_DIG_SIGS
189: SET STATUS = P_STATUS,
190: ERRBUF = to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') || ': ' || P_ERRBUF,
191: ERRSTACK = DECODE(ERRSTACK, NULL, ERRBUF,
192: ERRBUF || WF_CORE.NEWLINE || ERRSTACK)

Line 281: From WF_Dig_Sigs

277:
278: begin
279: Select Requested_Signer_Type, Requested_Signer_ID
280: into P_reqSignerType, P_reqSignerID
281: From WF_Dig_Sigs
282: Where P_Signature_ID = Sig_ID;
283: Exception
284: when others then
285: P_reqSignerType := ' ';

Line 296: -- the WF_DIG_SIGS table.

292: --
293: -- Purpose
294: -- Determines if actual signer is authorized to sign for requested
295: -- signer. E.g. Does the user have the desired responsibility. Updates
296: -- the WF_DIG_SIGS table.
297: --
298: -- Returns: .
299: -- Outcome = either "AUTHORIZED" or "FAILED".
300: --

Line 328: From WF_Dig_Sigs S

324: begin
325: /* get info from sig table */
326: Select Cert_ID, Requested_Signer_Type, Requested_Signer_ID, Signed_Date
327: into act_cert_id, req_type, req_id, sig_date
328: From WF_Dig_Sigs S
329: where SIG_ID = P_SIGNATURE_ID;
330:
331: /* get info from cert table */
332: Select Owner_domain, Owner_ID

Line 402: UPDATE WF_DIG_SIGS

398: mystatus := WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED;
399: end if;
400:
401: /* update the table */
402: UPDATE WF_DIG_SIGS
403: SET STATUS = MyStatus
404: where SIG_ID = P_SIGNATURE_ID;
405:
406: /* let calling code know what happened */

Line 417: UPDATE WF_DIG_SIGS

413: commit;
414:
415: exception when others then P_Outcome := 'FAILED';
416:
417: UPDATE WF_DIG_SIGS
418: SET STATUS = WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED
419: where SIG_ID = P_SIGNATURE_ID;
420: commit;
421: end;

Line 447: From WF_Dig_Sigs

443: P_Signature_Mode out nocopy Varchar2) is
444: begin
445: Select Sig_Flavor
446: into P_Flavor
447: From WF_Dig_Sigs
448: Where P_Signature_ID = Sig_ID;
449:
450: Get_SPI_Info(P_Flavor, P_BSR, P_Verifier, P_Validator, P_CertMapper,
451: P_Validator_Store, P_Validation_Mode,

Line 513: -- Yanks an ID off of the sequence WF_DIG_SIGS_S

509: -- Function
510: -- Get_Next_Sig_ID
511: --
512: -- Purpose
513: -- Yanks an ID off of the sequence WF_DIG_SIGS_S
514: --
515: -- Returns: ID or -1 if not successful.
516: --
517: --

Line 526: SELECT WF_DIG_SIGS_S.nextval

522: nextID number := -1;
523:
524: begin
525: begin
526: SELECT WF_DIG_SIGS_S.nextval
527: into nextID
528: from dual;
529: exception when others then null;
530: end;

Line 785: SELECT WF_DIG_SIGS_S.nextval into v_seqVal from dual;

781: end loop;
782: close crl_cursor;
783:
784: /* No match found: Get the next sequence number */
785: SELECT WF_DIG_SIGS_S.nextval into v_seqVal from dual;
786:
787: /* insert the data into the table */
788: Insert Into WF_DIG_CRLS
789: (CRL_ID, ISSUE_DATE, CRL_DATA, ISSUER, NEXT_ISSUE_DATE)

Line 814: from wf_dig_sigs

810:
811: begin
812: Select Plaintext, Signature
813: into PText, Sig
814: from wf_dig_sigs
815: where Sig_Id = SigID;
816:
817: exception
818: when others then

Line 834: delete from wf_dig_sigs

830:
831: Procedure Purge_Signature_By_Sig_ID(SigID NUMBER) is
832:
833: begin
834: delete from wf_dig_sigs
835: where Sig_ID = SigID;
836: end;
837:
838: --

Line 849: delete from wf_dig_sigs

845:
846: Procedure Purge_Signature_By_Obj_ID(Obj_Type varchar2, Obj_ID varchar2) is
847:
848: begin
849: delete from wf_dig_sigs
850: where SIG_OBJ_TYPE = Obj_Type
851: and SIG_OBJ_ID =Obj_ID;
852: end;
853:

Line 868: delete from wf_dig_sigs

864:
865: begin
866: IF (Obj_IDs.count >0) then
867: FORALL j IN Obj_IDs.FIRST..Obj_IDs.LAST
868: delete from wf_dig_sigs
869: where SIG_OBJ_TYPE = Obj_Type
870: and SIG_OBJ_ID =Obj_IDs(j);
871: END IF;
872: end;