<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:JulianDate="JulianDate" extension-element-prefixes="JulianDate" exclude-result-prefixes="JulianDate">
	<xsl:output indent="yes"/>
	<xsl:param name="FDATE">
		<FDATE>730488</FDATE>
	</xsl:param>
	<xsl:param name="TDATE">
		<TDATE>730637</TDATE>
	</xsl:param>
	<xsl:template match="/NATIONAL">
		<fo:root>
			<fo:layout-master-set>
				<fo:simple-page-master master-name="spm1" page-height="612.0pt" page-width="792.0pt"  margin-top="36.0pt" margin-bottom="36.0pt" margin-left="15.0pt" margin-right="15.0pt">
					<fo:region-before extent="90.0pt" overflow="visible" padding-before="36.0pt" padding-left="45.0pt" padding-right="45.0pt" precedence="true" region-name="header"/>
					<fo:region-body column-count="1" margin-top="45.0pt" margin-bottom="15.0pt" region-name="region-body"/>
					<fo:region-start extent="80pt" padding-left="20pt" reference-orientation="90" region-name="regstart"/>
					<fo:region-end extent="80pt" padding-left="20pt" reference-orientation="270" region-name="regend"/>
					<fo:region-after extent="15.0pt" overflow="visible" padding-after="5.0pt" padding-left="45.0pt" padding-right="45.0pt" precedence="true" region-name="footer"/>
				</fo:simple-page-master>
			</fo:layout-master-set>

			<fo:page-sequence master-reference="spm1">
				<fo:static-content flow-name="header">
					<fo:block>
						<fo:block background-color="white" color="black" font-family="Times" font-size="12.0pt" font-style="normal" font-weight="normal" linefeed-treatment="preserve" text-align="center" text-decoration="none" vertical-align="baseline">Pipeline Inventory Report</fo:block>
						<fo:block background-color="white" color="black" font-family="Times" font-size="12.0pt" font-style="normal" font-weight="normal" text-align="center" text-decoration="none" vertical-align="baseline">
Date: <xsl:value-of select="JulianDate:formatJulDate(number($FDATE))"/> - <xsl:value-of select="JulianDate:formatJulDate(number($TDATE))"/>
						</fo:block>
					</fo:block>
				</fo:static-content>
				<fo:static-content flow-name="footer">
						<fo:block text-align="right" background-color="white" color="black" font-family="Times" font-size="12.0pt" font-style="normal" font-weight="normal" text-decoration="none" vertical-align="baseline">
						Page <fo:page-number/> of <fo:page-number-citation ref-id="endofdoc"/>
						</fo:block>
				</fo:static-content>
				<fo:flow flow-name="region-body">
					<fo:block background-color="white" color="black" font-family="Times"  font-size="10.0pt" font-style="normal" font-weight="normal" text-align="center" text-decoration="none" text-indent="0pt" vertical-align="baseline" white-space-collapse="false">
						<fo:table table-omit-header-at-break="false">
					<fo:table-column column-width="59.75pt"/>
					<fo:table-column column-width="128.35pt"/>
					<fo:table-column column-width="158pt"/>
					<fo:table-column column-width="50.35pt"/>
					<fo:table-column column-width="47.0pt"/>
					<fo:table-column column-width="51.2pt"/>
					<fo:table-column column-width="51.2pt"/>
					<fo:table-column column-width="51.7pt"/>
					<fo:table-column column-width="51.7pt"/>
					<fo:table-column column-width="51.4pt"/>
					<fo:table-column column-width="51.15pt"/>
<!--							<fo:table-column column-width="proportional-column-width(59.75)"/>
							<fo:table-column column-width="proportional-column-width(128.35)"/>
							<fo:table-column column-width="proportional-column-width(128)"/>
							<fo:table-column column-width="proportional-column-width(50.35)"/>
							<fo:table-column column-width="proportional-column-width(47.0)"/>
							<fo:table-column column-width="proportional-column-width(59.2)"/>
							<fo:table-column column-width="proportional-column-width(59.2)"/>
							<fo:table-column column-width="proportional-column-width(57.7)"/>
							<fo:table-column column-width="proportional-column-width(54.7)"/>
							<fo:table-column column-width="proportional-column-width(58.4)"/>
						<fo:table-column column-width="proportional-column-width(61.15)"/>-->
							<fo:table-header>
								<fo:table-row>
									<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
										<fo:block font-weight="bold">FHA</fo:block>
									</fo:table-cell>
									<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
										<fo:block font-weight="bold">SACT</fo:block>
									</fo:table-cell>
									<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
										<fo:block font-weight="bold">Project Name</fo:block>
									</fo:table-cell>
									<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
										<fo:block font-weight="bold">Units</fo:block>
									</fo:table-cell>
									<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
										<fo:block font-weight="bold">Vacancy Rate</fo:block>
									</fo:table-cell>
									<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
										<fo:block font-weight="bold">Hearing Letter-Date</fo:block>
									</fo:table-cell>
									<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
										<fo:block font-weight="bold">MIP Date</fo:block> 
									</fo:table-cell>
									<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
										<fo:block font-weight="bold">HUD-Acq Date</fo:block>
									</fo:table-cell>
									<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
										<fo:block font-weight="bold">Acq Type</fo:block>
									</fo:table-cell>
									<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
										<fo:block font-weight="bold">Subsidized</fo:block>
									</fo:table-cell>
									<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
										<fo:block font-weight="bold">In Bankrupcy</fo:block>
									</fo:table-cell>
								</fo:table-row>
							</fo:table-header>
							<fo:table-body>
								<xsl:apply-templates select="REGION"/>
								<xsl:call-template name="printGroupAttributes">
									<xsl:with-param name="node" select="."/>
									<xsl:with-param name="label" select="'National'"/>
									<xsl:with-param name="name" select="''"/>
								</xsl:call-template>
							</fo:table-body>
						</fo:table>
					</fo:block>
					<fo:block id="endofdoc"/>
				</fo:flow>
			</fo:page-sequence>
		</fo:root>
	</xsl:template>
	<xsl:template match="REGION">
		<fo:table-row>
			<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:block text-align="start">Region:</fo:block>
			</fo:table-cell>
			<fo:table-cell number-columns-spanned="2" border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:block text-align="start">
					<xsl:value-of select="concat(@fha,' ',@name)"/>
				</fo:block>
			</fo:table-cell>
			<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:block text-align="start">
					
				</fo:block>
			</fo:table-cell>
			<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:block text-align="start">
					
				</fo:block>
			</fo:table-cell>
			<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:block text-align="start">
					
				</fo:block>
			</fo:table-cell>
			<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:block text-align="start">
					
				</fo:block>
			</fo:table-cell>
			<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:block text-align="start">
					
				</fo:block>
			</fo:table-cell>
			<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:block text-align="start">
					
				</fo:block>
			</fo:table-cell>
			<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:block text-align="start">
					
				</fo:block>
			</fo:table-cell>
			<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:block text-align="start">
					
				</fo:block>
			</fo:table-cell>
		</fo:table-row>
		<xsl:apply-templates select="ENTITY"/>
		<xsl:call-template name="printGroupAttributes">
			<xsl:with-param name="node" select="."/>
			<xsl:with-param name="label" select="'Region'"/>
			<xsl:with-param name="name" select="@name"/>
		</xsl:call-template>
	</xsl:template>
	<xsl:template match="ENTITY">
		<fo:table-row>
			<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:block text-align="start">Entity:</fo:block>
			</fo:table-cell>
			<fo:table-cell number-columns-spanned="2" border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:block text-align="start">
					<xsl:value-of select="concat(@fha,' ',@name)"/>
				</fo:block>
			</fo:table-cell>
			<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:block text-align="start">
					
				</fo:block>
			</fo:table-cell>
			<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:block text-align="start">
					
				</fo:block>
			</fo:table-cell>
			<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:block text-align="start">
					
				</fo:block>
			</fo:table-cell>
			<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:block text-align="start">
					
				</fo:block>
			</fo:table-cell>
			<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:block text-align="start">
					
				</fo:block>
			</fo:table-cell>
			<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:block text-align="start">
					
				</fo:block>
			</fo:table-cell>
			<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:block text-align="start">
					
				</fo:block>
			</fo:table-cell>
			<fo:table-cell border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:block text-align="start">
					
				</fo:block>
			</fo:table-cell>
		</fo:table-row>
		<xsl:apply-templates select="CASE"/>
		<xsl:call-template name="printGroupAttributes">
			<xsl:with-param name="node" select="."/>
			<xsl:with-param name="label" select="'Entity'"/>
			<xsl:with-param name="name" select="concat(@fha,' ',@name)"/>
		</xsl:call-template>
	</xsl:template>
	<xsl:template match="CASE">
		<fo:table-row background-color="#CCCCCC">
			<fo:table-cell xsl:use-attribute-sets="borders">
				<fo:block text-align="start">
					<xsl:value-of select="@fha"/>
				</fo:block>
			</fo:table-cell>
			<fo:table-cell xsl:use-attribute-sets="borders">
				<fo:block text-align="start">
					<xsl:value-of select="@sact"/>
				</fo:block>
			</fo:table-cell>
			<fo:table-cell xsl:use-attribute-sets="borders">
				<fo:block text-align="start">
					<xsl:value-of select="@name"/>
				</fo:block>
			</fo:table-cell>
			<fo:table-cell xsl:use-attribute-sets="borders">
				<fo:block text-align="start">
					<xsl:value-of select="@nounits"/>
				</fo:block>
			</fo:table-cell>
			<fo:table-cell xsl:use-attribute-sets="borders">
				<fo:block text-align="start">
					<xsl:value-of select="@vacancy"/>
				</fo:block>
			</fo:table-cell>
			<fo:table-cell xsl:use-attribute-sets="borders">
				<fo:block text-align="start">
					<xsl:value-of select="@hearingLetter"/>
				</fo:block>
			</fo:table-cell>
			<fo:table-cell xsl:use-attribute-sets="borders">
				<fo:block text-align="start">
					<xsl:value-of select="@mipDate"/>
				</fo:block>
			</fo:table-cell>
			<fo:table-cell xsl:use-attribute-sets="borders">
				<fo:block text-align="start">
					<xsl:value-of select="@acqDate"/>
				</fo:block>
			</fo:table-cell>
			<fo:table-cell xsl:use-attribute-sets="borders">
				<fo:block text-align="start">
					<xsl:value-of select="@acqType"/>
				</fo:block>
			</fo:table-cell>
			<fo:table-cell xsl:use-attribute-sets="borders">
				<fo:block text-align="start">
					<xsl:value-of select="@subsidized"/>
				</fo:block>
			</fo:table-cell>
			<fo:table-cell xsl:use-attribute-sets="borders">
				<fo:block text-align="start">
					<xsl:value-of select="@bankrupcy"/>
				</fo:block>
			</fo:table-cell>
		</fo:table-row>
	</xsl:template>
	<xsl:template name="printGroupAttributes">
		<xsl:param name="node"/>
		<xsl:param name="label"/>
		<xsl:param name="name"/>
		<xsl:for-each select="$node">
			<fo:table-row border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:table-cell>
					<fo:block text-align="start">
						<xsl:value-of select="$label"/>:</fo:block>
				</fo:table-cell>
				<fo:table-cell>
					<fo:block text-align="start">
						<xsl:value-of select="$name"/>
					</fo:block>
				</fo:table-cell>
				<fo:table-cell>
					<fo:block text-align="start">Cases: <xsl:value-of select="@cases"/>
				</fo:block>
				</fo:table-cell>
				<fo:table-cell>
					<fo:block text-align="start">Avg-Vac:</fo:block>
				</fo:table-cell>
				<fo:table-cell>
					<fo:block text-align="start">
						<xsl:value-of select="@vacancy"/>
					</fo:block>
				</fo:table-cell>
				<fo:table-cell>
					<fo:block text-align="start">FC:  <xsl:value-of select="@fcCount"/></fo:block>
				</fo:table-cell>
				<fo:table-cell>
					<fo:block text-align="start">MIP: <xsl:value-of select="@mipCount"/>
	</fo:block>
				</fo:table-cell>
				<fo:table-cell>
					<fo:block text-align="start">Owned: <xsl:value-of select="@ownedCount"/>
	</fo:block>
				</fo:table-cell>
				<fo:table-cell>
					<fo:block text-align="start">Sub: <xsl:value-of select="@subCount"/>
	</fo:block>
				</fo:table-cell>
				<fo:table-cell>
					<fo:block text-align="start">
						
					</fo:block>
				</fo:table-cell>
				<fo:table-cell>
					<fo:block text-align="start">
						
					</fo:block>
				</fo:table-cell>
			</fo:table-row>
			<fo:table-row  border-style="none" display-align="center" padding-bottom="0.75pt" padding-left="0.75pt" padding-right="0.75pt" padding-top="0.75pt">
				<fo:table-cell>
					<fo:block text-align="start">
						
					</fo:block>
				</fo:table-cell>
				<fo:table-cell>
					<fo:block text-align="start">
						
					</fo:block>
				</fo:table-cell>
				<fo:table-cell>
					<fo:block text-align="start">
						
					</fo:block>
				</fo:table-cell>
				<fo:table-cell>
					<fo:block text-align="start">
						
					</fo:block>
				</fo:table-cell>
				<fo:table-cell>
					<fo:block text-align="start">
						
					</fo:block>
				</fo:table-cell>
				<fo:table-cell>
					<fo:block text-align="start">Unit: <xsl:value-of select="@fcUnits"/></fo:block>
				</fo:table-cell>
				<fo:table-cell>
					<fo:block text-align="start">Unit: <xsl:value-of select="@mipUnits"/></fo:block>
				</fo:table-cell>
				<fo:table-cell>
					<fo:block text-align="start">Unit: <xsl:value-of select="@ownedUnits"/></fo:block>
				</fo:table-cell>
				<fo:table-cell>
					<fo:block text-align="start">Unit: <xsl:value-of select="@subUnits"/></fo:block>
				</fo:table-cell>
				<fo:table-cell>
					<fo:block text-align="start">
						
					</fo:block>
				</fo:table-cell>
				<fo:table-cell>
					<fo:block text-align="start">
						
					</fo:block>
				</fo:table-cell>
			</fo:table-row>
		</xsl:for-each>
	</xsl:template>
  <xsl:attribute-set name="borders">
 <xsl:attribute name="border-bottom-color">black</xsl:attribute>
 <xsl:attribute name="border-bottom-style">solid</xsl:attribute>
 <xsl:attribute name="border-bottom-width">0.75pt</xsl:attribute>
 <xsl:attribute name="border-left-color">black</xsl:attribute>
 <xsl:attribute name="border-left-style">solid</xsl:attribute>
 <xsl:attribute name="border-left-width">0.75pt</xsl:attribute>
 <xsl:attribute name="border-right-color">black</xsl:attribute>
 <xsl:attribute name="border-right-style">solid</xsl:attribute>
 <xsl:attribute name="border-right-width">0.75pt</xsl:attribute>
 <xsl:attribute name="border-top-color">black</xsl:attribute>
 <xsl:attribute name="border-top-style">solid</xsl:attribute>
 <xsl:attribute name="border-top-width">0.5pt</xsl:attribute>
 <xsl:attribute name="display-align">center</xsl:attribute>
 <xsl:attribute name="padding-bottom">0.75pt</xsl:attribute>
 <xsl:attribute name="padding-left">0.75pt</xsl:attribute>
 <xsl:attribute name="padding-right">0.75pt</xsl:attribute>
 <xsl:attribute name="padding-top">0.75pt</xsl:attribute>
   </xsl:attribute-set>
</xsl:stylesheet><!-- Stylus Studio meta-information - (c)1998-2001 eXcelon Corp.
<metaInformation>
<scenarios ><scenario default="no" name="Scenario1" userelativepaths="yes" url="pipelineInventoryCalc.xml" htmlbaseurl="" processortype="internal" commandline="" additionalpath="" additionalclasspath="" postprocessortype="custom" postprocesscommandline="C:\java\fop&#x2D;0.20.3\fop.bat %1 %2" postprocessadditionalpath="" postprocessgeneratedext=".pdf"/><scenario default="yes" name="saxon" userelativepaths="yes" url="pipelineInventoryCalc.xml" htmlbaseurl="" processortype="custom" commandline="java  net.sf.saxon.Transform  %1 %2" additionalpath="" additionalclasspath="C:\java\saxon7&#x2D;1\saxon7.jar;C:\java\projects\DynAccSys\xml" postprocessortype="custom" postprocesscommandline="C:\java\fop&#x2D;0.20.3\fop.bat &#x2D;fo %1 &#x2D;pdf %2" postprocessadditionalpath="" postprocessgeneratedext=".pdf"/></scenarios><MapperInfo  srcSchemaPath="" srcSchemaRoot="" srcSchemaPathIsRelative="yes" destSchemaPath="" destSchemaRoot="" destSchemaPathIsRelative="yes" />
</metaInformation>
-->
