DBA Data[Home] [Help]

APPS.WF_DIGITAL_SECURITY_PRIVATE dependencies on DBMS_LOB

Line 724: I := DBMS_LOB.Compare(V_Certificate, P_Certificate);

720: fetch cert_cursor into V_Cert_ID, V_Certificate;
721: exit when Cert_Cursor%NOTFOUND;
722:
723: -- Compare the obtained certificate with the given certificate
724: I := DBMS_LOB.Compare(V_Certificate, P_Certificate);
725:
726: --if comparison is success return the certificate id
727: if (i = 0) then
728: return V_Cert_ID;

Line 778: if (dbms_lob.compare(V_CRL, P_CRL) = 0) then

774: exit when crl_cursor%NOTFOUND;
775:
776: /* compare the value of the input crl and crl obtained from table
777: if they are the same return the existing CRL_ID */
778: if (dbms_lob.compare(V_CRL, P_CRL) = 0) then
779: return V_CRLID;
780: end if;
781: end loop;
782: close crl_cursor;