DBA Data[Home] [Help]

APPS.EGO_PUB_WS_UTIL dependencies on XMLTYPE

Line 2367: l_output_xml XmlType;

2363: l_web_service_name VARCHAR2(100) := p_web_service_name;
2364: l_entity_type VARCHAR2(100) := NULL;
2365: l_xml CLOB;
2366:
2367: l_output_xml XmlType;
2368: l_cr VARCHAR2(10) := fnd_global.local_chr(10);
2369: l_qm VARCHAR2(1) := '?'; -- Question mark in a string may be interpreted by ODI
2370:
2371: l_level_stack dbms_sql.number_table;

Line 2585: l_output_xml := XmlType(l_xml);

2581:
2582: l_entity_type_tag := '' || l_cr;
2583: dbms_lob.append(l_xml,to_clob(l_entity_type_tag));
2584:
2585: l_output_xml := XmlType(l_xml);
2586:
2587: -- Write final XML payload to output table in XML TYPE column
2588: -- with sequence id as zero
2589: -- This payload will be accessed using serviceutil.java with sequence_id

Line 2606: xml_odi = XmlType(l_xml),

2602: END;
2603: IF l_rec_count > 0 THEN
2604: UPDATE ego_pub_ws_output
2605: SET xmlcontent = l_output_xml,
2606: xml_odi = XmlType(l_xml),
2607: creation_date = sysdate
2608: WHERE session_id = l_session_id
2609: AND web_service_name = l_web_service_name;
2610: ELSE

Line 2626: XmlType(l_xml),

2622: l_web_service_name,
2623: l_entity_type,
2624: 0,
2625: l_output_xml,
2626: XmlType(l_xml),
2627: sysdate,
2628: 0);
2629: END IF;
2630: END IF;