APPS.IBY_EXTRACTGEN_PVT SQL Statements

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

Line: 79

      SELECT gen_code_package,gen_code_entry_point
      FROM iby_extracts_vl
      WHERE (extract_code=ci_extract_code)
        AND (extract_version=ci_extract_version)
        AND (gen_code_language='PLSQL');

Line: 89

      SELECT value
        INTO l_numeric_char_mask
        FROM V$NLS_PARAMETERS
       WHERE parameter='NLS_NUMERIC_CHARACTERS';

Line: 369

                p_reselect        => l_param_7,
                p_sys_key                => HEXTORAW(l_param_8),
                x_extract_doc            => x_extract_doc
             );

Line: 425

    SELECT attribute_category
      FROM hz_parties
     WHERE party_id = p_party_id;

Line: 450

      SELECT attribute_category
      INTO l_attribute_category
      FROM IBY_PAYMENT_METHODS_B
      WHERE payment_method_code = p_entity_code;

Line: 459

      SELECT attribute_category
      INTO l_attribute_category
      FROM IBY_SYS_PMT_PROFILES_B
      WHERE system_profile_code = p_entity_code;

Line: 468

      SELECT attribute_category
      INTO l_attribute_category
      FROM IBY_PAY_INSTRUCTIONS_ALL
      WHERE payment_instruction_id = p_entity_id;

Line: 477

      SELECT attribute_category
      INTO l_attribute_category
      FROM IBY_PAYMENTS_ALL
      WHERE payment_id = p_entity_id;

Line: 486

      SELECT attribute_category
      INTO l_attribute_category
      FROM IBY_DOCS_PAYABLE_ALL
      WHERE document_payable_id = p_entity_id;

Line: 495

      SELECT attribute_category
      INTO l_attribute_category
      FROM IBY_FORMATS_B
      WHERE format_code = p_entity_code;

Line: 504

      SELECT attribute_category
      INTO l_attribute_category
      FROM IBY_BEPKEYS
      WHERE bep_account_id = p_entity_id;

Line: 513

      SELECT attribute_category
      INTO l_attribute_category
      FROM XLE_FIRSTPARTY_INFORMATION_V
      WHERE legal_entity_id = p_entity_id;

Line: 533

      SELECT attribute_category
      INTO l_attribute_category
      FROM HZ_PARTIES
      WHERE party_id = p_entity_id;

Line: 542

      SELECT attribute_category
      INTO l_attribute_category
      FROM CE_BANK_ACCOUNTS
      WHERE bank_account_id = p_entity_id;

Line: 551

      SELECT attribute_category
      INTO l_attribute_category
      FROM IBY_EXT_BANK_ACCOUNTS
      WHERE ext_bank_account_id = p_entity_id;

Line: 560

      SELECT attribute_category
      INTO l_attribute_category
      FROM PO_VENDORS
      WHERE VENDOR_ID = p_entity_id;

Line: 569

      SELECT attribute_category
      INTO l_attribute_category
      FROM PO_VENDOR_SITES_ALL
      WHERE VENDOR_SITE_ID = p_entity_id;

Line: 579

      SELECT attribute_category
      INTO l_attribute_category
      FROM iby_docs_payable_all idp
	    WHERE idp.document_payable_id = p_entity_id;

Line: 585

	  Select XMLConcat(XMLElement("AttributeCategory", attribute_category),
		 XMLElement("Attribute1", attribute1), XMLElement("Attribute2", attribute2),
		 XMLElement("Attribute3", attribute3), XMLElement("Attribute4", attribute4),
		 XMLElement("Attribute5", attribute5), XMLElement("Attribute6", attribute6),
		 XMLElement("Attribute7", attribute7), XMLElement("Attribute8", attribute8),
		 XMLElement("Attribute9", attribute9), XMLElement("Attribute10", attribute10),
		 XMLElement("Attribute11", attribute11), XMLElement("Attribute12", attribute12),
		 XMLElement("Attribute13", attribute13), XMLElement("Attribute14", attribute14),
		 XMLElement("Attribute15", attribute15))
	 INTO l_dffs
	 From iby_docs_payable_all idp
	 WHERE idp.document_payable_id = p_entity_id;

Line: 599

	  Select XMLConcat(XMLElement("AttributeCategory", attribute_category),
		 XMLElement("Attribute1", TRANSLATE(attribute1,l_conc_invalid_chars,l_conc_replacement_chars)),
		 XMLElement("Attribute2", TRANSLATE(attribute2,l_conc_invalid_chars,l_conc_replacement_chars)),
		 XMLElement("Attribute3", TRANSLATE(attribute3,l_conc_invalid_chars,l_conc_replacement_chars)),
		 XMLElement("Attribute4", TRANSLATE(attribute4,l_conc_invalid_chars,l_conc_replacement_chars)),
		 XMLElement("Attribute5", TRANSLATE(attribute5,l_conc_invalid_chars,l_conc_replacement_chars)),
		 XMLElement("Attribute6", TRANSLATE(attribute6,l_conc_invalid_chars,l_conc_replacement_chars)),
		 XMLElement("Attribute7", TRANSLATE(attribute7,l_conc_invalid_chars,l_conc_replacement_chars)),
		 XMLElement("Attribute8", TRANSLATE(attribute8,l_conc_invalid_chars,l_conc_replacement_chars)),
		 XMLElement("Attribute9", TRANSLATE(attribute9,l_conc_invalid_chars,l_conc_replacement_chars)),
		 XMLElement("Attribute10", TRANSLATE(attribute10,l_conc_invalid_chars,l_conc_replacement_chars)),
		 XMLElement("Attribute11", TRANSLATE(attribute11,l_conc_invalid_chars,l_conc_replacement_chars)),
		 XMLElement("Attribute12", TRANSLATE(attribute12,l_conc_invalid_chars,l_conc_replacement_chars)),
		 XMLElement("Attribute13", TRANSLATE(attribute13,l_conc_invalid_chars,l_conc_replacement_chars)),
		 XMLElement("Attribute14", TRANSLATE(attribute14,l_conc_invalid_chars,l_conc_replacement_chars)),
		 XMLElement("Attribute15", TRANSLATE(attribute15,l_conc_invalid_chars,l_conc_replacement_chars)))
	 INTO l_dffs
	 From iby_docs_payable_all idp
	 WHERE idp.document_payable_id = p_entity_id;

Line: 627

    l_queryString := 'Select XMLConcat(XMLElement("AttributeCategory", attribute_category), ';

Line: 704

        SELECT x.filename
          INTO l_filename
          FROM (SELECT SUBSTR(fcr.outfile_name,INSTR(fcr.outfile_name,'/',-1)+1) filename,
                       rank() over(partition by pi.payment_instruction_id order by pcc.request_id desc) c_rank
                  FROM iby_process_conc_requests pcc,
                       fnd_concurrent_requests fcr,
                       iby_pay_instructions_all pi,
                       iby_acct_pmt_profiles_b ap,
                       iby_sys_pmt_profiles_b sp,
                       iby_formats_b f
                 WHERE pcc.object_type = 'PAYMENT_INSTRUCTION'
                   AND pcc.request_id = fcr.request_id
                   AND pcc.object_id = pi.payment_instruction_id
                   AND ap.payment_profile_id = pi.payment_profile_id
                   AND ap.system_profile_code = sp.system_profile_code
                   AND f.format_code = sp.payment_format_code
                   AND f.format_template_code = p_template_code
                   AND pi.payment_instruction_id = TO_NUMBER(p_pay_instruction)) x
         WHERE x.c_rank=1;