APPS.CSM_SR_EVENT_PKG dependencies on DBMS_XMLGEN

Line 1649: qrycontext DBMS_XMLGEN.ctxHandle;

1645: AND inv.INCIDENT_ID = c_incident_id ;
1646:
1647: l_xml CLOB;
1648: l_xml_blob BLOB;
1649: qrycontext DBMS_XMLGEN.ctxHandle;
1650: l_dest_offset NUMBER := 1;
1651: l_Src_offset NUMBER := 1;
1652: l_language NUMBER := 0;
1653: l_warning NUMBER := 0;

Line 1701: qrycontext := DBMS_XMLGEN.newcontext(l_SQL_TEXT) ;

1697: inv.AFTER_WARRANTY_COST, inv.CHARGE_LINE_TYPE, inv.BILL_TO_PARTY_ID
1698: FROM CS_ESTIMATE_DETAILS inv WHERE INV.ORIGINAL_SOURCE_CODE = ''SR''
1699: AND inv.INCIDENT_ID = ' || l_INCIDENT_ID ;
1700: --Execute the SQL query
1701: qrycontext := DBMS_XMLGEN.newcontext(l_SQL_TEXT) ;
1702:
1703: l_xml := DBMS_XMLGEN.getxml (qrycontext);
1704:
1705: IF DBMS_LOB.GETLENGTH(l_xml) > 0 THEN

Line 1703: l_xml := DBMS_XMLGEN.getxml (qrycontext);

1699: AND inv.INCIDENT_ID = ' || l_INCIDENT_ID ;
1700: --Execute the SQL query
1701: qrycontext := DBMS_XMLGEN.newcontext(l_SQL_TEXT) ;
1702:
1703: l_xml := DBMS_XMLGEN.getxml (qrycontext);
1704:
1705: IF DBMS_LOB.GETLENGTH(l_xml) > 0 THEN
1706: --Convert the XML output into BLOB and store it in the DB
1707: dbms_lob.createtemporary(l_xml_blob,TRUE);