APPS.WF_DIGITAL_SECURITY_PRIVATE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 51

    insert into WF_DIG_SIGS
    (SIG_ID, SIG_OBJ_TYPE, SIG_OBJ_ID, PLAINTEXT,
	Requested_Signer_Type, Requested_Signer_ID,
        Sig_Flavor, Sig_Policy,
	STATUS, CREATION_DATE)
    select
    P_SIG_ID, P_SIG_OBJ_TYPE, P_SIG_OBJ_ID, P_PLAINTEXT,
	P_Requested_Signer_Type, P_Requested_Signer_ID,
        P_Sig_Flavor, P_Sig_Policy,
	P_STATUS, sysdate from dual;

Line: 80

Procedure Update_Signed_Sig(
	P_SIG_ID NUMBER,
	P_SIGNATURE CLOB,
	P_STATUS NUMBER,
	P_Returncode out nocopy number) is

  PRAGMA AUTONOMOUS_TRANSACTION;

Line: 89

    UPDATE WF_DIG_SIGS
    SET SIGNATURE = P_SIGNATURE,
        STATUS = P_STATUS,
        SIGNED_DATE = sysdate
    where SIG_ID = P_SIG_ID;

Line: 113

Procedure Update_Verified_Sig(
	P_SIG_ID NUMBER,
	P_CERT_ID NUMBER,
	P_STATUS NUMBER,
	P_Returncode out nocopy number) is

  PRAGMA AUTONOMOUS_TRANSACTION;

Line: 122

    UPDATE WF_DIG_SIGS
    SET CERT_ID = P_CERT_ID,
        STATUS = P_STATUS,
        VERIFIED_DATE = sysdate
    where SIG_ID = P_SIG_ID;

Line: 146

Procedure Update_Validated_Sig(
	P_SIG_ID NUMBER,
	P_STATUS NUMBER,
	P_Returncode out nocopy number) is

  PRAGMA AUTONOMOUS_TRANSACTION;

Line: 154

    UPDATE WF_DIG_SIGS
    SET STATUS = P_STATUS,
        Last_Validation_Attempt = sysdate,
        Validated_complete_date = Decode(P_STATUS,
		WF_DIGITAL_SECURITY_PRIVATE.STAT_VALIDATED, sysdate, null)
    where SIG_ID = P_SIG_ID;

Line: 179

Procedure Update_Sig_Error(
	P_SIG_ID NUMBER,
	P_STATUS NUMBER,
        P_ERRBUF VARCHAR2,
	P_Returncode out nocopy number) is

  PRAGMA AUTONOMOUS_TRANSACTION;

Line: 188

    UPDATE WF_DIG_SIGS
    SET STATUS = P_STATUS,
        ERRBUF = to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') || ': ' || P_ERRBUF,
        ERRSTACK = DECODE(ERRSTACK, NULL, ERRBUF,
			  	ERRBUF || WF_CORE.NEWLINE || ERRSTACK)
    where SIG_ID = P_SIG_ID;

Line: 221

      select cert_id
      into mycert_id
      from wf_dig_certs
      where cert_type = 'PSIG'
      and fingerprint = P_User;

Line: 233

      insert into wf_dig_certs (cert,cert_id,cert_type,parent_cert_id,
      		owner_id, owner_domain, valid, sot_flag, intermediate_flag,
		fingerprint, expire)
	(select P_User, wf_dig_certs_s.nextval,'PSIG', wf_dig_certs_s.currval,
		U.User_ID, 'U', 'Y', 'Y', 'N', P_User, null
	   from fnd_user U
	  where user_name = P_User
	    and not exists
             (select cert_id
              from wf_dig_certs
      	      where cert_type = 'PSIG'
      		and fingerprint = P_User)
	);

Line: 247

      select cert_id
        into mycert_id
        from wf_dig_certs
       where cert_type = 'PSIG'
         and fingerprint = P_User;

Line: 279

   Select Requested_Signer_Type, Requested_Signer_ID
   into P_reqSignerType, P_reqSignerID
   From WF_Dig_Sigs
   Where P_Signature_ID = Sig_ID;

Line: 326

    Select Cert_ID, Requested_Signer_Type, Requested_Signer_ID, Signed_Date
      into act_cert_id, req_type, req_id, sig_date
      From WF_Dig_Sigs S
     where SIG_ID = P_SIGNATURE_ID;

Line: 332

    Select Owner_domain, Owner_ID
      into act_type, act_id
      From WF_Dig_Certs
     where Cert_ID = act_cert_id;

Line: 340

        Select EMPLOYEE_ID
          into act_emp_id
          from fnd_user
         where USER_ID = act_id;

Line: 345

        Select count(*)
          into kount
          From WF_User_Roles R
         where R.USER_ORIG_SYSTEM in ('FND_USR', 'PER')
           and R.USER_ORIG_SYSTEM_ID = to_number(
		decode(R.User_Orig_System, 'PER', act_emp_id,
				           'FND_USR', act_id,
						      '-999'))
           and R.ROLE_NAME = req_id;

Line: 379

        Select count(*)
          into kount
          From Fnd_User_Resp_Groups R
         where R.USER_ID = resp_id
           and R.RESPONSIBILITY_APPLICATION_ID = resp_app_id
           and R.SECURITY_GROUP_ID = sec_grp_id
           and R.Responsibility_ID = to_number(req_id)
           and NVL(R.Start_date, sig_date) <= sig_date
           and NVL(R.End_date, sig_date) >= sig_date;

Line: 401

    /* update the table */
    UPDATE WF_DIG_SIGS
    SET STATUS = MyStatus
    where SIG_ID = P_SIGNATURE_ID;

Line: 417

    UPDATE WF_DIG_SIGS
    SET STATUS = WF_DIGITAL_SECURITY_PRIVATE.STAT_AUTHORIZE_FAILED
    where SIG_ID = P_SIGNATURE_ID;

Line: 445

   Select Sig_Flavor
   into P_Flavor
   From WF_Dig_Sigs
   Where P_Signature_ID = Sig_ID;

Line: 488

   Select BSR_SPI, Verify_SPI, Validate_SPI, Cert_Mapper, Validator_Store,
	Validation_Mode, Signature_Format, Signature_Mode
   into P_BSR, P_Verifier, P_Validator, P_CertMapper, P_Validator_Store,
	P_Validation_Mode, P_Signature_Format, P_Signature_Mode
   From WF_Dig_Sig_SPI_Flavors
   Where P_Flavor = Flavor;

Line: 526

    SELECT WF_DIG_SIGS_S.nextval
	into nextID
      from dual;

Line: 544

Procedure UPDATE_CRL_URL(p_ca_name varchar2,p_crl_url varchar2) as

        v_ca_name varchar2(255);

Line: 553

        SELECT ca_name, ca_url
          INTO v_ca_name, v_crl_url
          FROM wf_dig_cas
         WHERE ca_name = p_ca_name
           and ca_url = p_crl_url;

Line: 563

   INSERT INTO wf_dig_cas (ca_name,ca_url)
   VALUES(p_ca_name,p_crl_url);

Line: 610

	      UPDATE_CRL_URL(p_issuer,p_crl_url);

Line: 615

          select user_id into v_user_id
            from fnd_user
           where user_name = p_owner_id;

Line: 627

   	        SELECT owner_id
                  INTO existing_userid
	 	  FROM wf_dig_certs
		 WHERE cert_id = existing_certid;

Line: 640

        SELECT wf_dig_certs_s.nextval
	  INTO seqVal
          FROM DUAL;

Line: 645

	insert into WF_DIG_CERTS(CERT, CERT_ID, CERT_TYPE, PARENT_CERT_ID,
                  OWNER_ID, OWNER_DOMAIN, VALID, SOT_FLAG,
                  INTERMEDIATE_FLAG, FINGERPRINT, EXPIRE,
                  SECURITY_GROUP_ID, SUBJECTDN)
           values( p_cert, seqVal, p_cert_type, p_parent_cert_id,
                  v_user_id, p_owner_domain, p_valid, p_sot_flag,
                  p_intermediate_flag, p_fingerprint, p_expire,
                  p_security_group_id, p_subjectdn);

Line: 681

            select
            CERT into v_certificate
            from
            WF_DIG_CERTS
            where CERT_TYPE='X509' and CERT_ID=p_cert_id;

Line: 706

       select CERT_ID, CERT
         from WF_DIG_CERTS
        where CERT_TYPE = 'X509'
          and FINGERPRINT = P_Fingerprint;

Line: 758

      SELECT CRL_ID, CRL_Data
        FROM WF_Dig_CRLS
       WHERE Issue_Date = P_Toi
         and Issuer = P_Issuer
         and Next_Issue_Date = P_Ton;

Line: 785

   SELECT WF_DIG_SIGS_S.nextval into v_seqVal from dual;

Line: 787

   /* insert the data into the table */
   Insert Into WF_DIG_CRLS
        (CRL_ID, ISSUE_DATE, CRL_DATA, ISSUER, NEXT_ISSUE_DATE)
   Values (V_SeqVal, P_Toi, P_Crl, P_Issuer, P_Ton);

Line: 812

  Select Plaintext, Signature
    into PText, Sig
    from wf_dig_sigs
   where Sig_Id = SigID;

Line: 834

  delete from wf_dig_sigs
   where Sig_ID = SigID;

Line: 849

  delete from wf_dig_sigs
   where SIG_OBJ_TYPE = Obj_Type
     and SIG_OBJ_ID =Obj_ID;

Line: 868

	   delete from wf_dig_sigs
            where SIG_OBJ_TYPE = Obj_Type
                and SIG_OBJ_ID =Obj_IDs(j);