DBA Data[Home] [Help]

APPS.WF_DIGITAL_SECURITY_PRIVATE dependencies on WF_DIG_CAS

Line 555: FROM wf_dig_cas

551: if(p_crl_url is not null) then
552: --check whether the corresponding CA name and CA_URL exists
553: SELECT ca_name, ca_url
554: INTO v_ca_name, v_crl_url
555: FROM wf_dig_cas
556: WHERE ca_name = p_ca_name
557: and ca_url = p_crl_url;
558: END if;
559:

Line 563: INSERT INTO wf_dig_cas (ca_name,ca_url)

559:
560: --if url exists do nothing. else insert an entry
561: EXCEPTION
562: WHEN NO_DATA_FOUND THEN
563: INSERT INTO wf_dig_cas (ca_name,ca_url)
564: VALUES(p_ca_name,p_crl_url);
565: commit;
566: end;
567: