<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
                version="1.0">
  <!--
    language id is given as a parameter to xsl transformation
    -->
  <xsl:param name="langid"/>
  <!--
    transform .dlf to Oracle canonical XML:
      <ROWSET>
        <ROW>
          <column_name1>value11</column_name1>
          <column_name2>value12</column_name2>
          <column_name3>value13</column_name3>
          :
        </ROW>
        <ROW>
          <column_name1>value21</column_name1>
          <column_name2>value22</column_name2>
          <column_name3>value23</column_name3>
          :
        </ROW>
        :
      </ROWSET>
    -->
  <xsl:template match="/">
    <ROWSET>
    <xsl:for-each select="table/dataset/row">
      <ROW>
        <xsl:apply-templates />
        <LANGUAGE><xsl:value-of select="$langid"/></LANGUAGE>
      </ROW>
    </xsl:for-each>
    </ROWSET>
  </xsl:template>
  <xsl:template match="col[@name='id#']">
      <ID_x0023_><xsl:value-of select="."/></ID_x0023_>
  </xsl:template>
  <xsl:template match="col[@name='name']">
      <NAME><xsl:value-of select="."/></NAME>
  </xsl:template>
  <xsl:template match="col[@name='value']">
      <VALUE><xsl:value-of select="."/></VALUE>
  </xsl:template>
  <xsl:template match="col[@name='description']">
      <DESCRIPTION><xsl:value-of select="."/></DESCRIPTION>
  </xsl:template>
</xsl:stylesheet>
