Custom IBY_FD_EXTRACT_EXT_PUB.Get_Doc_Ext_Agg Please help
Hi All
I need Remiitance_message1 in my SEPA xml output
So I customized Get_Doc_Ext_Agg:
Get_Doc_Ext_Agg(p_document_payable_id IN NUMBER)
RETURN XMLTYPE
IS
XMLTYPE;
CURSOR l_doc_ext_csr (p_document_payable_id IN NUMBER) IS
SELECT XMLCONCAT(
XMLElement("IIK",
XMLElement("MESSAGE1",REMITTANCE_MESSAGE1),
XMLElement("MESSAGE2",REMITTANCE_MESSAGE2))
)
FROM iby_docs_payable_all
document_payable_id=p_document_payable_id;
BEGIN
OPEN l_doc_ext_csr(p_document_payable_id);
FETCH l_doc_ext_csr INTO l_doc_ext_agg;
CLOSE l_doc_ext_csr;
RETURN l_doc_ext_agg;
END Get_Doc_Ext_Agg