APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on XMLTYPE

Line 151: l_xml XMLTYPE;

147: x_extract_doc OUT NOCOPY CLOB
148: )
149: IS
150: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Create_Payer_Notif_Extract_1_0';
151: l_xml XMLTYPE;
152: l_where_clause VARCHAR2(4000);
153: l_extract_query VARCHAR2(4000) :=
154: 'select XMLElement("FundsCapturePayerNotification", ' ||
155: ' XMLElement("FormatProgramRequestID", fnd_global.CONC_REQUEST_ID), ' ||

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

255: -- l_fromPSON, l_toPSON,
256: -- l_delivery_method, p_format_code,
257: -- l_trxn_id;
258:
259: x_extract_doc := XMLType.getClobVal(l_xml);
260:
261: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
262: debug_level => FND_LOG.LEVEL_PROCEDURE,
263: module => l_Debug_Module);

Line 335: SELECT XMLType.getClobVal(instruction)

331: IF ((p_req_type = 'ORAPMTCLOSEBATCH')
332: OR (p_req_type = 'ORAPMTEFTCLOSEBATCH')
333: OR (p_req_type = 'ORAPMTPDCCLOSEBATCH')) THEN
334:
335: SELECT XMLType.getClobVal(instruction)
336: INTO x_extract_doc
337: FROM iby_xml_batch_fci_1_0_v
338: WHERE mbatchid=p_txn_id
339: AND rownum=1;

Line 341: SELECT XMLType.getClobVal(instruction)

337: FROM iby_xml_batch_fci_1_0_v
338: WHERE mbatchid=p_txn_id
339: AND rownum=1;
340: ELSE
341: SELECT XMLType.getClobVal(instruction)
342: INTO x_extract_doc
343: FROM iby_xml_online_fci_1_0_v
344: WHERE trxnmid=p_txn_id
345: AND rownum=1;

Line 394: RETURN XMLTYPE

390: END Create_Extract_1_0;
391:
392: -- obselete per bug 5115161
393: FUNCTION Get_Ins_PayeeAcctAgg(p_mbatch_id IN NUMBER)
394: RETURN XMLTYPE
395: IS
396:
397: l_payeeacct_agg XMLTYPE;
398: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Ins_PayeeAcctAgg';

Line 397: l_payeeacct_agg XMLTYPE;

393: FUNCTION Get_Ins_PayeeAcctAgg(p_mbatch_id IN NUMBER)
394: RETURN XMLTYPE
395: IS
396:
397: l_payeeacct_agg XMLTYPE;
398: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Ins_PayeeAcctAgg';
399:
400: -- the cursors should be kept in-sync with IBY_XML_FNDCPT_ACCT_1_0_V
401: -- electronic payer notification