APPS.EGO_ODI_PUB dependencies on XMLTYPE

Line 5132: RETURN XmlType

5128: --in table EGO_ODI_WS_XSL and pointed by the web service name specified.
5129: --The function returns the transformed XML into a clob variable.
5130: FUNCTION Transform_XML(p_xml_input IN CLOB,
5131: p_web_service_name IN VARCHAR2)
5132: RETURN XmlType
5133: IS
5134:
5135: indoc VARCHAR2(2000);
5136: xsldoc VARCHAR2(2000);

Line 5175: RETURN XmlType(outclob);

5171:
5172: DBMS_LOB.CreateTemporary(outCLOB, TRUE);
5173: dbms_xmldom.writetoclob(outnode,outclob);
5174:
5175: RETURN XmlType(outclob);
5176:
5177: END Transform_XML;
5178:
5179:

Line 5200: l_output_xml XmlType;

5196: l_web_service_name VARCHAR2(100) := p_web_service_name;
5197: l_entity_type VARCHAR2(100) := NULL;
5198: l_xml CLOB;
5199:
5200: l_output_xml XmlType;
5201: l_cr VARCHAR2(10) := fnd_global.local_chr(10);
5202: l_qm VARCHAR2(1) := '?'; -- Question mark in a string may be interpreted by ODI
5203:
5204: l_level_stack dbms_sql.number_table;

Line 5578: l_output_xml := XmlType(outclob);

5574: outdomdocf := dbms_xslprocessor.processxsl(proc, xsl, indomdoc);
5575: outnode := dbms_xmldom.makenode(outdomdocf);
5576: DBMS_LOB.CreateTemporary(outCLOB, TRUE);
5577: dbms_xmldom.writetoclob(outnode,outclob);
5578: l_output_xml := XmlType(outclob);
5579: --l_output_xml := Transform_XML(l_xml, p_web_service_name);
5580: -- YJAIN
5581: ELSE
5582: l_output_xml := XmlType(l_xml);

Line 5582: l_output_xml := XmlType(l_xml);

5578: l_output_xml := XmlType(outclob);
5579: --l_output_xml := Transform_XML(l_xml, p_web_service_name);
5580: -- YJAIN
5581: ELSE
5582: l_output_xml := XmlType(l_xml);
5583: END IF;
5584:
5585: -- Write final XML payload to output table in XML TYPE column
5586: -- with sequence id as zero

Line 5603: XmlType(l_xml),

5599: p_odi_session_id,
5600: p_web_service_name,
5601: 0,
5602: l_output_xml,
5603: XmlType(l_xml),
5604: sysdate,
5605: 0);
5606:
5607: --End YJ

Line 5710: l_output_xml := XmlType(outclob);

5706: outdomdocf := dbms_xslprocessor.processxsl(proc, xsl, indomdoc);
5707: outnode := dbms_xmldom.makenode(outdomdocf);
5708: DBMS_LOB.CreateTemporary(outCLOB, TRUE);
5709: dbms_xmldom.writetoclob(outnode,outclob);
5710: l_output_xml := XmlType(outclob);
5711: --l_output_xml := Transform_XML(l_xml, p_web_service_name);
5712: -- YJAIN
5713:
5714: ELSE

Line 5715: l_output_xml := xmltype (l_xml);

5711: --l_output_xml := Transform_XML(l_xml, p_web_service_name);
5712: -- YJAIN
5713:
5714: ELSE
5715: l_output_xml := xmltype (l_xml);
5716: END IF;
5717:
5718:
5719: --EMTAPIA: Start added for bug 11831151, if special ordering of output XML is required (e.. master items are before child items)

Line 5733: VALUES (l_session_id, p_odi_session_id, p_web_service_name, l_sequence, l_output_xml, xmltype (l_xml), SYSDATE, 0);

5729:
5730: -- Write XML payload to output table for each top level entity with
5731: -- sequence_id.
5732: INSERT INTO ego_pub_ws_output (session_id, odi_session_id, web_service_name, sequence_id, xmlcontent, xml_odi, creation_date, created_by)
5733: VALUES (l_session_id, p_odi_session_id, p_web_service_name, l_sequence, l_output_xml, xmltype (l_xml), SYSDATE, 0);
5734:
5735: --Re-Initialize all variable
5736: l_xml := NULL;
5737: l_previous_level := -1;

Line 5877: xmltype(l_chunk_detail),

5873: VALUES (l_session_id,
5874: l_odi_session_id,
5875: l_web_service_name,
5876: 0,
5877: xmltype(l_chunk_detail),
5878: XmlType(l_chunk_detail),
5879: sysdate,
5880: 0);
5881:

Line 5878: XmlType(l_chunk_detail),

5874: l_odi_session_id,
5875: l_web_service_name,
5876: 0,
5877: xmltype(l_chunk_detail),
5878: XmlType(l_chunk_detail),
5879: sysdate,
5880: 0);
5881:
5882: END IF;--End IF l_return_payload='TRUE'