DECLARE
xslclob clob;
BEGIN
    XX_HTMLDB.TEMP_ITEM_XML(p_item_id => :P10_PRODUCTID);
    xslclob := '<?xml version="1.0"?><xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><xsl:output method="html" omit-xml-declaration="no" encoding="UTF-8" indent="yes" /><xsl:template match="ROWSET/ROW"><div id="ProductImageBox"><div id="ProductImage" style="position: relative;"><a alt="Y-Neck Poplin Top 8401 New Prices!* " class="zoomer" style="outline-style: none; text-decoration: none; cursor: crosshair; display: block; position: relative; height: 590px; width: 408px;" title=""><xsl:attribute name="href">http://www.americandawn.com/LARose/istoreimages/<xsl:value-of select="ITEM" />.jpg</xsl:attribute><img width="408" height="590" border="0" alt="Y-Neck Poplin Top 8401 New Prices!* " id="imgMain" title=""><xsl:attribute name="src">http://www.americandawn.com/LARose/istoreimages/<xsl:value-of select="ITEM" />.jpg</xsl:attribute></img></a></div><div id="ProductImageZoom"><a class="Overlay" rel="#zoom_overlay" href=""><img border="0" alt="" src="http://scrubsandbeyond.com/App_Themes/ScrubsandBeyond/graphics/zoom_icon.gif" /><strong>click to view larger image or roll over to view detail</strong></a></div></div><div id="ProductInfoBox"><h1><xsl:value-of select="DESCRIPTION" /></h1><strong>91571</strong><br /><div class="prices"><span class="was">$14.03</span></div><p>Item Description</p><div class="steps" id="_ctl17_ColorStep"><span class="header">1. Select a Color: </span><select onchange="changeImageDD(''77264''); return false;" id="_ctl17_ddSelectAColor" name="_ctl17:ddSelectAColor"><option value="Black">Black</option><option value="Scuba blue">Scuba blue</option><option value="White">White</option></select><div class="swatches"><a onclick="changeImage(''77264'', ''/App_Themes/ScrubsandBeyond/itmimg/91571_black.jpg'', ''Black'', '''', ''Landau'', ''LAN'', ''XL'', ''1'', ''91571''); return false;" href="#"><span title="Black" style="background: none repeat scroll 0% 0% rgb(35, 31, 32);" class="colorsquare"></span></a><a onclick="changeImage(''77264'', ''/App_Themes/ScrubsandBeyond/itmimg/91571_scubablue.jpg'', ''Scuba blue'', '''', ''Landau'', ''LAN'', ''M'', ''1'', ''91571''); return false;" href="#"><span title="Scuba blue" style="background: none repeat scroll 0% 0% rgb(0, 170, 186);" class="colorsquare"></span></a><a onclick="changeImage(''77264'', ''/App_Themes/ScrubsandBeyond/itmimg/91571_white.jpg'', ''White'', '''', ''Landau'', ''LAN'', ''L'', ''1'', ''91571''); return false;" href="#"><span title="White" style="background: none repeat scroll 0% 0% rgb(255, 255, 255); border: 1px solid rgb(204, 204, 204);" class="colorsquare white"></span></a></div><div class="clear"></div><div class="swatches"> </div></div><div class="steps" id="_ctl17_SizeStep"><span class="header">2. Select a Size: </span><select onchange="checkSize(); return false;" id="_ctl17_ddSizeList" name="_ctl17:ddSizeList"><option value="">Select a Size</option><option qtyonhand="0" value="73865">XS - Available: 2/18</option><option qtyonhand="3" value="74014">S - In Stock</option><option qtyonhand="0" value="73996">M - Available: 2/18</option><option qtyonhand="0" value="73952">L - Available: 2/18</option><option qtyonhand="0" value="73951">XL - Available: 2/18</option><option qtyonhand="0" value="74107">2X - Available: 2/18</option></select> <span id="currentPrice">$<xsl:value-of select="ITEM_COST" /></span><br /></div><div class="steps" id="_ctl17_QtyStep"><span class="header">3. Select a Quantity: </span><select id="_ctl17_ddQtyToOrder" name="_ctl17:ddQtyToOrder"><option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option><option value="6">6</option><option value="7">7</option><option value="8">8</option><option value="9">9</option><option value="10">10</option></select> <span id="currentPrice"></span><br /></div><div id="ProductDetail"><span id="sCartAlert"></span><div id="AddToCart"><a title="Add to Cart"><xsl:attribute name="href">https://www.americandawn.com/pls/larose/f?p=1110:13:244500114712599::::P13_CATEGORY_ID:<xsl:value-of select="INVENTORY_ITEM_ID" /></xsl:attribute><img src="http://scrubsandbeyond.com/App_Themes/ScrubsandBeyond/graphics/add_to_cart_btn.gif" /></a></div></div><div class="clear"></div></div></xsl:template></xsl:stylesheet>';
    SELECT xmltype(DBMS_XMLQUERY.getxml('select * from HTMLDB_ISTORE_ITEMS MSI where INVENTORY_ITEM_ID = '||p_item_id).transform(xmltype(xslclob)).getclobval) FROM dual;
END;