APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on XMLAGG

Line 156: ' XMLAgg(xml_order.FNDCPT_ORDER)) ' ||

152: l_where_clause VARCHAR2(4000);
153: l_extract_query VARCHAR2(4000) :=
154: 'select XMLElement("FundsCapturePayerNotification", ' ||
155: ' XMLElement("FormatProgramRequestID", fnd_global.CONC_REQUEST_ID), ' ||
156: ' XMLAgg(xml_order.FNDCPT_ORDER)) ' ||
157: ' from iby_trxn_summaries_all txn, IBY_XML_FNDCPT_ORDER_PN_1_0_V xml_order ' ||
158: ' where txn.trxnmid = xml_order.trxnmid ' ||
159: ' and nvl(txn.payer_notification_required, ''N'') = ''Y'' ';
160:

Line 407: Extract(XMLAgg(XMLElement("OptionSet",opts.account_options)),

403: SELECT
404: XMLElement("PayeeAccount",
405: XMLElement("PaymentSystemAccount",
406: XMLElement("AccountName",txn.bepkey),
407: Extract(XMLAgg(XMLElement("OptionSet",opts.account_options)),
408: 'OptionSet[1]/*')
409: ),
410: CASE WHEN (NOT xml_bank.instrid IS NULL) THEN
411: Extract(XMLAgg(XMLElement("BankAccount",xml_bank.bank_account_content)),

Line 411: Extract(XMLAgg(XMLElement("BankAccount",xml_bank.bank_account_content)),

407: Extract(XMLAgg(XMLElement("OptionSet",opts.account_options)),
408: 'OptionSet[1]/*')
409: ),
410: CASE WHEN (NOT xml_bank.instrid IS NULL) THEN
411: Extract(XMLAgg(XMLElement("BankAccount",xml_bank.bank_account_content)),
412: '/BankAccount[1]')
413: END,
414: XMLElement("Payee",
415: XMLElement("Name",payee.name),

Line 456: XMLAgg(xml_order.fndcpt_order)

452: XMLElement("Code",MAX(txn.currencynamecode))
453: )
454: )
455: ),
456: XMLAgg(xml_order.fndcpt_order)
457: )--,
458: --txn.mbatchid,
459: --txn.payeeinstrid
460: FROM

Line 486: Extract(XMLAgg(XMLElement("OptionSet",opts.account_options)),

482: SELECT
483: XMLElement("PayeeAccount",
484: XMLElement("PaymentSystemAccount",
485: XMLElement("AccountName",txn.bepkey),
486: Extract(XMLAgg(XMLElement("OptionSet",opts.account_options)),
487: 'OptionSet[1]/*')
488: ),
489: CASE WHEN (NOT xml_bank.instrid IS NULL) THEN
490: Extract(XMLAgg(XMLElement("BankAccount",xml_bank.bank_account_content)),

Line 490: Extract(XMLAgg(XMLElement("BankAccount",xml_bank.bank_account_content)),

486: Extract(XMLAgg(XMLElement("OptionSet",opts.account_options)),
487: 'OptionSet[1]/*')
488: ),
489: CASE WHEN (NOT xml_bank.instrid IS NULL) THEN
490: Extract(XMLAgg(XMLElement("BankAccount",xml_bank.bank_account_content)),
491: '/BankAccount[1]')
492: END,
493: XMLElement("Payee",
494: XMLElement("Name",payee.name),

Line 535: XMLAgg(xml_order.fndcpt_order)

531: XMLElement("Code",MAX(txn.currencynamecode))
532: )
533: )
534: ),
535: XMLAgg(xml_order.fndcpt_order)
536: )--,
537: --txn.mbatchid,
538: --txn.payeeinstrid
539: FROM