APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on XMLAGG

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

244: l_where_clause VARCHAR2(4000);
245: l_extract_query VARCHAR2(4000) :=
246: 'select XMLElement("FundsCapturePayerNotification", ' ||
247: ' XMLElement("FormatProgramRequestID", fnd_global.CONC_REQUEST_ID), ' ||
248: ' XMLAgg(xml_order.FNDCPT_ORDER)) ' ||
249: ' from iby_trxn_summaries_all txn, IBY_XML_FNDCPT_ORDER_PN_1_0_V xml_order ' ||
250: ' where txn.trxnmid = xml_order.trxnmid ' ||
251: ' and nvl(txn.payer_notification_required, ''N'') = ''Y'' ';
252:

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

511: SELECT
512: XMLElement("PayeeAccount",
513: XMLElement("PaymentSystemAccount",
514: XMLElement("AccountName",txn.bepkey),
515: Extract(XMLAgg(XMLElement("OptionSet",opts.account_options)),
516: 'OptionSet[1]/*')
517: ),
518: CASE WHEN (NOT xml_bank.instrid IS NULL) THEN
519: Extract(XMLAgg(XMLElement("BankAccount",xml_bank.bank_account_content)),

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

515: Extract(XMLAgg(XMLElement("OptionSet",opts.account_options)),
516: 'OptionSet[1]/*')
517: ),
518: CASE WHEN (NOT xml_bank.instrid IS NULL) THEN
519: Extract(XMLAgg(XMLElement("BankAccount",xml_bank.bank_account_content)),
520: '/BankAccount[1]')
521: END,
522: XMLElement("Payee",
523: XMLElement("Name",payee.name),

Line 564: XMLAgg(xml_order.fndcpt_order)

560: XMLElement("Code",MAX(txn.currencynamecode))
561: )
562: )
563: ),
564: XMLAgg(xml_order.fndcpt_order)
565: )--,
566: --txn.mbatchid,
567: --txn.payeeinstrid
568: FROM

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

590: SELECT
591: XMLElement("PayeeAccount",
592: XMLElement("PaymentSystemAccount",
593: XMLElement("AccountName",txn.bepkey),
594: Extract(XMLAgg(XMLElement("OptionSet",opts.account_options)),
595: 'OptionSet[1]/*')
596: ),
597: CASE WHEN (NOT xml_bank.instrid IS NULL) THEN
598: Extract(XMLAgg(XMLElement("BankAccount",xml_bank.bank_account_content)),

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

594: Extract(XMLAgg(XMLElement("OptionSet",opts.account_options)),
595: 'OptionSet[1]/*')
596: ),
597: CASE WHEN (NOT xml_bank.instrid IS NULL) THEN
598: Extract(XMLAgg(XMLElement("BankAccount",xml_bank.bank_account_content)),
599: '/BankAccount[1]')
600: END,
601: XMLElement("Payee",
602: XMLElement("Name",payee.name),

Line 643: XMLAgg(xml_order.fndcpt_order)

639: XMLElement("Code",MAX(txn.currencynamecode))
640: )
641: )
642: ),
643: XMLAgg(xml_order.fndcpt_order)
644: )--,
645: --txn.mbatchid,
646: --txn.payeeinstrid
647: FROM