APPS.WF_DIGITAL_SECURITY_PRIVATE dependencies on WF_DIG_CRLS

Line 742: -- Stores the given CRL into WF_Dig_Crls. If the CRL already exists

738: -- Function
739: -- Store_CRL
740: --
741: -- Purpose
742: -- Stores the given CRL into WF_Dig_Crls. If the CRL already exists
743: -- then the crl_id of the existing CRL is returned. Otherwise, the new
744: -- CRL is stored and the CRL_ID is returned
745: --
746: -- Returns

Line 759: FROM WF_Dig_CRLS

755:
756: /* Cursor for getting the values from CRL table */
757: CURSOR CRL_Cursor IS
758: SELECT CRL_ID, CRL_Data
759: FROM WF_Dig_CRLS
760: WHERE Issue_Date = P_Toi
761: and Issuer = P_Issuer
762: and Next_Issue_Date = P_Ton;
763:

Line 788: Insert Into WF_DIG_CRLS

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)
790: Values (V_SeqVal, P_Toi, P_Crl, P_Issuer, P_Ton);
791:
792: Return V_SeqVal;