APPS.WF_DIGITAL_SECURITY_PRIVATE dependencies on DUAL

Line 60: P_STATUS, sysdate from dual;

56: select
57: P_SIG_ID, P_SIG_OBJ_TYPE, P_SIG_OBJ_ID, P_PLAINTEXT,
58: P_Requested_Signer_Type, P_Requested_Signer_ID,
59: P_Sig_Flavor, P_Sig_Policy,
60: P_STATUS, sysdate from dual;
61:
62: commit;
63:
64: P_returncode := 0;

Line 528: from dual;

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;
531:
532: return nextID;

Line 642: FROM DUAL;

638:
639: --get the next value from the sequence for the cert_id
640: SELECT wf_dig_certs_s.nextval
641: INTO seqVal
642: FROM DUAL;
643:
644: --insert the certificate into the table
645: insert into WF_DIG_CERTS(CERT, CERT_ID, CERT_TYPE, PARENT_CERT_ID,
646: OWNER_ID, OWNER_DOMAIN, VALID, SOT_FLAG,

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)