APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on XMLTYPE

Line 243: l_xml XMLTYPE;

239: x_extract_doc OUT NOCOPY CLOB
240: )
241: IS
242: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Create_Payer_Notif_Extract_1_0';
243: l_xml XMLTYPE;
244: l_where_clause VARCHAR2(4000);
245: l_extract_query VARCHAR2(4000) :=
246: 'select XMLElement("FundsCapturePayerNotification", ' ||
247: ' XMLElement("FormatProgramRequestID", fnd_global.CONC_REQUEST_ID), ' ||

Line 357: x_extract_doc := XMLType.getClobVal(l_xml);

353: -- l_fromPSON, l_toPSON,
354: -- l_delivery_method, p_format_code,
355: -- l_trxn_id;
356:
357: x_extract_doc := XMLType.getClobVal(l_xml);
358:
359: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
360: debug_level => FND_LOG.LEVEL_PROCEDURE,
361: module => l_Debug_Module);

Line 441: XMLType.getClobVal(instruction)

437: FND_FILE.PUT_LINE(FND_FILE.LOG, l_Debug_Module || 'call to iby_xml_batch_fci_1_0_v START' || ':TimeStamp:' ||systimestamp);
438: --Bug# 13640788
439: -- Removed Optimizer hints as per the pef team sugestion
440: SELECT
441: XMLType.getClobVal(instruction)
442: INTO x_extract_doc
443: FROM iby_xml_batch_fci_1_0_v
444: WHERE mbatchid=p_txn_id
445: AND rownum=1;

Line 448: XMLType.getClobVal(instruction)

444: WHERE mbatchid=p_txn_id
445: AND rownum=1;
446: ELSE
447: SELECT
448: XMLType.getClobVal(instruction)
449: INTO x_extract_doc
450: FROM iby_xml_online_fci_1_0_v
451: WHERE trxnmid=p_txn_id
452: AND rownum=1;

Line 502: RETURN XMLTYPE

498: END Create_Extract_1_0;
499:
500: -- obselete per bug 5115161
501: FUNCTION Get_Ins_PayeeAcctAgg(p_mbatch_id IN NUMBER)
502: RETURN XMLTYPE
503: IS
504:
505: l_payeeacct_agg XMLTYPE;
506: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Ins_PayeeAcctAgg';

Line 505: l_payeeacct_agg XMLTYPE;

501: FUNCTION Get_Ins_PayeeAcctAgg(p_mbatch_id IN NUMBER)
502: RETURN XMLTYPE
503: IS
504:
505: l_payeeacct_agg XMLTYPE;
506: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Ins_PayeeAcctAgg';
507:
508: -- the cursors should be kept in-sync with IBY_XML_FNDCPT_ACCT_1_0_V
509: -- electronic payer notification

Line 1367: RETURN XMLType

1363:
1364:
1365: FUNCTION get_mandate_details
1366: ( p_mandate_id IN iby_debit_authorizations.debit_authorization_id%TYPE )
1367: RETURN XMLType
1368: IS
1369: l_doc_rec XMLType;
1370:
1371: CURSOR l_mandate

Line 1369: l_doc_rec XMLType;

1365: FUNCTION get_mandate_details
1366: ( p_mandate_id IN iby_debit_authorizations.debit_authorization_id%TYPE )
1367: RETURN XMLType
1368: IS
1369: l_doc_rec XMLType;
1370:
1371: CURSOR l_mandate
1372: (c_mandate_id iby_debit_authorizations.debit_authorization_id%TYPE) IS
1373: SELECT MandateDetails from (