APPS.EGO_ODI_PUB dependencies on EGO_ODI_WS_XSL

Line 5128: --in table EGO_ODI_WS_XSL and pointed by the web service name specified.

5124:
5125:
5126: --This function reads the ODI output XML from table EGO_PUB_WS_OUTPUT using
5127: --the provided session_id and transforms it using the XSL information stored
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

Line 5154: --table EGO_ODI_WS_XSL for specified web service

5150:
5151: xmlclob := p_xml_input;
5152:
5153: --selecting XLS transformation data from
5154: --table EGO_ODI_WS_XSL for specified web service
5155: select x.xslcontent.getclobval()
5156: into xslclob
5157: from EGO_ODI_WS_XSL x
5158: where web_service_name = p_web_service_name;

Line 5157: from EGO_ODI_WS_XSL x

5153: --selecting XLS transformation data from
5154: --table EGO_ODI_WS_XSL for specified web service
5155: select x.xslcontent.getclobval()
5156: into xslclob
5157: from EGO_ODI_WS_XSL x
5158: where web_service_name = p_web_service_name;
5159:
5160: myParser := dbms_xmlparser.newParser;
5161: dbms_xmlparser.parseclob(myParser, xmlclob);

Line 5437: --table EGO_ODI_WS_XSL for specified web service

5433: --YJAIN
5434: -- Optimizing parsing statement for transformation of XML
5435:
5436: --selecting XLS transformation data from
5437: --table EGO_ODI_WS_XSL for specified web service
5438: select x.xslcontent.getclobval()
5439: into xslclob
5440: from EGO_ODI_WS_XSL x
5441: where web_service_name = p_web_service_name;

Line 5440: from EGO_ODI_WS_XSL x

5436: --selecting XLS transformation data from
5437: --table EGO_ODI_WS_XSL for specified web service
5438: select x.xslcontent.getclobval()
5439: into xslclob
5440: from EGO_ODI_WS_XSL x
5441: where web_service_name = p_web_service_name;
5442:
5443: myParser := dbms_xmlparser.newParser;
5444: