[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
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');
SELECT value
INTO l_numeric_char_mask
FROM V$NLS_PARAMETERS
WHERE parameter='NLS_NUMERIC_CHARACTERS';
p_reselect => l_param_7,
p_sys_key => HEXTORAW(l_param_8),
x_extract_doc => x_extract_doc
);
SELECT attribute_category
FROM hz_parties
WHERE party_id = p_party_id;
SELECT attribute_category
INTO l_attribute_category
FROM IBY_PAYMENT_METHODS_B
WHERE payment_method_code = p_entity_code;
SELECT attribute_category
INTO l_attribute_category
FROM IBY_SYS_PMT_PROFILES_B
WHERE system_profile_code = p_entity_code;
SELECT attribute_category
INTO l_attribute_category
FROM IBY_PAY_INSTRUCTIONS_ALL
WHERE payment_instruction_id = p_entity_id;
SELECT attribute_category
INTO l_attribute_category
FROM IBY_PAY_SERVICE_REQUESTS
WHERE payment_service_request_id = p_entity_id;
SELECT attribute_category
INTO l_attribute_category
FROM IBY_PAYMENTS_ALL
WHERE payment_id = p_entity_id;
SELECT attribute_category
INTO l_attribute_category
FROM AP_CHECKS_ALL
WHERE payment_id = p_entity_id;
SELECT attribute_category
INTO l_attribute_category
FROM IBY_DOCS_PAYABLE_ALL
WHERE document_payable_id = p_entity_id;
SELECT attribute_category
INTO l_attribute_category
FROM IBY_FORMATS_B
WHERE format_code = p_entity_code;
SELECT attribute_category
INTO l_attribute_category
FROM IBY_BEPKEYS
WHERE bep_account_id = p_entity_id;
SELECT attribute_category
INTO l_attribute_category
FROM XLE_FIRSTPARTY_INFORMATION_V
WHERE legal_entity_id = p_entity_id;
SELECT attribute_category
INTO l_attribute_category
FROM HZ_PARTIES
WHERE party_id = p_entity_id;
SELECT attribute_category
INTO l_attribute_category
FROM CE_BANK_ACCOUNTS
WHERE bank_account_id = p_entity_id;
SELECT attribute_category
INTO l_attribute_category
FROM IBY_EXT_BANK_ACCOUNTS
WHERE ext_bank_account_id = p_entity_id;
SELECT attribute_category
INTO l_attribute_category
FROM IBY_PMT_INSTR_USES_ALL
WHERE instrument_payment_use_id = p_entity_id;
SELECT attribute_category
INTO l_attribute_category
FROM PO_VENDORS
WHERE VENDOR_ID = p_entity_id;
SELECT attribute_category
INTO l_attribute_category
FROM PO_VENDOR_SITES_ALL
WHERE VENDOR_SITE_ID = p_entity_id;
SELECT attribute_category
INTO l_attribute_category
FROM iby_docs_payable_all idp
WHERE idp.document_payable_id = p_entity_id;
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;
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;
l_queryString := 'Select XMLConcat(XMLElement("AttributeCategory", attribute_category), ';
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;
SELECT count(1) into l_cnt
FROM FND_DESCR_FLEX_COLUMN_USAGES COL, FND_DESCR_FLEX_CONTEXTS CON
WHERE COL.DESCRIPTIVE_FLEXFIELD_NAME = p_flex_field_name and
col.application_id = p_application_id and
col.application_id = con.application_id and
con.descriptive_flexfield_name = col.descriptive_flexfield_name and
con.descriptive_flex_context_code = col.descriptive_flex_context_code and
con.enabled_flag = 'Y' and col.enabled_flag = 'Y';