APPS.WF_DIGITAL_SECURITY_PRIVATE dependencies on WF_DIG_SIGS_S

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 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)