text: INSERT INTO PROTO_CORRESP_TEMPL (PROTO_CORRESP_TEMPL_ID,PROTO_CORRESP_TYPE_CODE,COMMITTEE_ID,FILE_NAME,CORRESPONDENCE_TEMPLATE,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR)
      VALUES (SEQ_PROTO_CORRESP_TEMPL.NEXTVAL,(SELECT PROTO_CORRESP_TYPE_CODE FROM PROTO_CORRESP_TYPE WHERE DESCRIPTION = 'Agenda Report'),'DEFAULT','DEFAULT-9-AgendaReport.xsl',EMPTY_CLOB(),'admin',SYSDATE,SYS_GUID(),1)
  /
  DECLARE    data CLOB; buffer VARCHAR2(32000);
  BEGIN
  SELECT CORRESPONDENCE_TEMPLATE INTO data FROM PROTO_CORRESP_TEMPL WHERE PROTO_CORRESP_TYPE_CODE = (SELECT PROTO_CORRESP_TYPE_CODE FROM PROTO_CORRESP_TYPE WHERE DESCRIPTION = 'Agenda Report') AND COMMITTEE_ID = 'DEFAULT' FOR UPDATE;
  buffer := '<?xml version="1.0" encoding="UTF-8"?>
  <!--Designed and generated by Altova StyleVision Enterprise Edition 2008 rel. 2 - see http://www.altova.com/stylevision for more information.-->
  <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fn="http://www.w3.org/2005/xpath-functions" xmlns:n1="http://irb.mit.edu/irbnamespace" xmlns:xdt="http://www.w3.org/2005/xpath-datatypes" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:fo="http://www.w3.org/1999/XSL/Format">
      <xsl:output version="1.0" method="xml" encoding="UTF-8" indent="no"/>
      <xsl:param name="SV_OutputFormat" select="''PDF''"/>
      <xsl:variable name="XML" select="/"/>
      <xsl:variable name="fo:layout-master-set">
          <fo:layout-master-set>
              <fo:simple-page-master master-name="default-page" page-height="11in" page-width="8.5in" margin-left="0.6in" margin-right="0.6in">
                  <fo:region-body margin-top="0.79in" margin-bottom="0.79in"/>
              </fo:simple-page-master>
          </fo:layout-master-set>
      </xsl:variable>
      <xsl:template match="/">
          <fo:root>
              <xsl:copy-of select="$fo:layout-master-set"/>
              <fo:page-sequence master-reference="default-page" initial-page-number="1" format="1">
                  <fo:flow flow-name="xsl-region-body">
                      <fo:block>
                          <xsl:for-each select="$XML">
                              <fo:inline-container>
                                  <fo:block>
                                      <xsl:text>&#x2029;</xsl:text>
                                  </fo:block>
                              </fo:inline-container>
                              <fo:block font-weight="bold" text-align="center" margin="0pt">
                                  <fo:block>
                                      <fo:inline font-family="Arial" font-size="large" font-weight="bold">
                                          <xsl:text>Massachusetts Institute of Technology</xsl:text>
                                      </fo:inline>
                                  </fo:block>
                              </fo:block>
                              <fo:inline-container>
                                  <fo:block>
                                      <xsl:text>&#x2029;</xsl:text>
                                  </fo:block>
                              </fo:inline-container>
                              <fo:block text-align="center" margin="0pt">
                                  <fo:block>
                                      <fo:inline font-family="Arial" font-size="large" font-weight="bold">
                                          <xsl:text>Agenda</xsl:text>
                                      </fo:inline>
                                  </fo:block>
                              </fo:block>
                              <xsl:for-each select="n1:Schedule">
                                  <xsl:for-each select="n1:ScheduleMasterData">
                                      <xsl:for-each select="n1:CommitteeName">
                                          <fo:inline-container>
                                              <fo:block>
                                                  <xsl:text>&#x2029;</xsl:text>
                                              </fo:block>
                                          </fo:inline-container>
                                          <fo:block text-align="center" margin="0pt">
                                              <fo:block>
                                                  <xsl:variable name="value-of-template">
                                                      <xsl:apply-templates/>
                                                  </xsl:variable>
                                                  <xsl:choose>
                                                      <xsl:when test="contains(string($value-of-template),''&#x2029;'')">
                                                          <fo:block font-fa';
      DBMS_LOB.writeappend(data,LENGTH(buffer),buffer);
  END;
  /
  DECLARE    data CLOB; buffer VARCHAR2(32000);
  BEGIN
  SELECT CORRESPONDENCE_TEMPLATE INTO data FROM PROTO_CORRESP_TEMPL WHERE PROTO_CORRESP_TYPE_CODE = (SELECT PROTO_CORRESP_TYPE_CODE FROM PROTO_CORRESP_TYPE WHERE DESCRIPTION = 'Agenda Report') AND COMMITTEE_ID = 'DEFAULT' FOR UPDATE;
  buffer := 'mily="Arial" font-size="large" font-weight="bold" padding-bottom="2px" padding-top="2px">
                                                              <xsl:copy-of select="$value-of-template"/>
                                                          </fo:block>
                                                      </xsl:when>
                                                      <xsl:otherwise>
                                                          <fo:inline font-family="Arial" font-size="large" font-weight="bold" padding-bottom="2px" padding-top="2px">
                                                              <xsl:copy-of select="$value-of-template"/>
                                                          </fo:inline>
                                                      </xsl:otherwise>
                                                  </xsl:choose>
                                              </fo:block>
                                          </fo:block>
                                      </xsl:for-each>
                                  </xsl:for-each>
                              </xsl:for-each>
                              <xsl:for-each select="n1:Schedule">
                                  <xsl:for-each select="n1:ScheduleMasterData">
                                      <xsl:for-each select="n1:ScheduledTime">
                                          <fo:inline-container>
                                              <fo:block>
                                                  <xsl:text>&#x2029;</xsl:text>
                                              </fo:block>
                                          </fo:inline-container>
                                          <fo:block text-align="center" margin="0pt">
                                              <fo:block>
                                                  <fo:inline font-family="Arial" font-size="larger" font-weight="bold" margin-bottom=" ">
                                                      <xsl:value-of select="format-number(number(substring(string(string(.)), 1, 2)), ''00'')"/>
                                                      <xsl:text>:</xsl:text>
                                                      <xsl:value-of select="format-number(number(substring(string(string(.)), 4, 2)), ''00'')"/>
                                                  </fo:inline>
                                              </fo:block>
                                          </fo:block>
                                      </xsl:for-each>
                                  </xsl:for-each>
                              </xsl:for-each>
                              <xsl:for-each select="n1:Schedule">
                                  <xsl:for-each select="n1:ScheduleMasterData">
                                      <xsl:for-each select="n1:Place">
                                          <fo:inline-container>
                                              <fo:block>
                                                  <xsl:text>&#x2029;</xsl:text>
                                              </fo:block>
                                          </fo:inline-container>
                                          <fo:block text-align="center" margin="0pt">
                                              <fo:block>
                                                  <xsl:variable name="value-of-template">
                                                      <xsl:apply-templates/>
                                                  </xsl:variable>
                                                  <xsl:choose>
                                                      <xsl:when test="contains(string($value-of-template),''&#x2029;'')">
                                                          <fo:block font-family="Arial" font-size="large" font-weight="bold">
                                                              <xsl:copy-of select="$value-of-template"/>
                                                          </fo:block>
                                               ';
      DBMS_LOB.writeappend(data,LENGTH(buffer),buffer);
  END;
  /
  DECLARE    data CLOB; buffer VARCHAR2(32000);
  BEGIN
  SELECT CORRESPONDENCE_TEMPLATE INTO data FROM PROTO_CORRESP_TEMPL WHERE PROTO_CORRESP_TYPE_CODE = (SELECT PROTO_CORRESP_TYPE_CODE FROM PROTO_CORRESP_TYPE WHERE DESCRIPTION = 'Agenda Report') AND COMMITTEE_ID = 'DEFAULT' FOR UPDATE;
  buffer := '       </xsl:when>
                                                      <xsl:otherwise>
                                                          <fo:inline font-family="Arial" font-size="large" font-weight="bold">
                                                              <xsl:copy-of select="$value-of-template"/>
                                                          </fo:inline>
                                                      </xsl:otherwise>
                                                  </xsl:choose>
                                              </fo:block>
                                          </fo:block>
                                      </xsl:for-each>
                                  </xsl:for-each>
                              </xsl:for-each>
                              <fo:block/>
                              <fo:block/>
                              <fo:inline font-family="Arial" font-size="9pt" font-weight="bold" text-decoration="underline">
                                  <xsl:text>AGENDA ITEMS</xsl:text>
                              </fo:inline>
                              <fo:block/>
                              <fo:inline-container>
                                  <fo:block>
                                      <xsl:text>&#x2029;</xsl:text>
                                  </fo:block>
                              </fo:inline-container>
                              <fo:list-block font-family="Arial" font-size="9pt" margin-bottom="0" margin-top="0" provisional-distance-between-starts="7mm" provisional-label-separation="2mm">
                                  <fo:list-item>
                                      <fo:list-item-label end-indent="label-end()" text-align="right">
                                          <fo:block font-family="Courier">&#x2022;</fo:block>
                                      </fo:list-item-label>
                                      <fo:list-item-body start-indent="body-start()">
                                          <fo:block>
                                              <xsl:if test="string-length(  n1:Schedule/n1:PreviousSchedule/n1:ScheduleMasterData/n1:MeetingDate ) &gt; 0">
                                                  <fo:inline>
                                                      <xsl:text>Review the minutes of the meeting held on</xsl:text>
                                                  </fo:inline>
                                              </xsl:if>
                                              <fo:inline>
                                                  <xsl:text>&#160;</xsl:text>
                                              </fo:inline>
                                              <xsl:for-each select="n1:Schedule">
                                                  <xsl:for-each select="n1:PreviousSchedule">
                                                      <xsl:for-each select="n1:ScheduleMasterData">
                                                          <xsl:for-each select="n1:MeetingDate">
                                                              <xsl:if test="string-length(.) &gt; 0">
                                                                  <fo:inline>
                                                                      <xsl:value-of select="format-number(number(substring(string(string(.)), 6, 2)), ''00'')"/>
                                                                      <xsl:text>/</xsl:text>
                                                                      <xsl:value-of select="format-number(number(substring(string(string(.)), 9, 2)), ''00'')"/>
                                                                      <xsl:text>/</xsl:text>
                                                                      <xsl:value-of select="format-number(number(substring(string(string(string(.))), 1, 4)), ''0000'')"/>
                                                                  </fo:inline>
                                                                  <fo:inline>
                  ';
      DBMS_LOB.writeappend(data,LENGTH(buffer),buffer);
  END;
  /
  DECLARE    data CLOB; buffer VARCHAR2(32000);
  BEGIN
  SELECT CORRESPONDENCE_TEMPLATE INTO data FROM PROTO_CORRESP_TEMPL WHERE PROTO_CORRESP_TYPE_CODE = (SELECT PROTO_CORRESP_TYPE_CODE FROM PROTO_CORRESP_TYPE WHERE DESCRIPTION = 'Agenda Report') AND COMMITTEE_ID = 'DEFAULT' FOR UPDATE;
  buffer := '                                                    <xsl:text>.</xsl:text>
                                                                  </fo:inline>
                                                              </xsl:if>
                                                          </xsl:for-each>
                                                      </xsl:for-each>
                                                  </xsl:for-each>
                                              </xsl:for-each>
                                          </fo:block>
                                      </fo:list-item-body>
                                  </fo:list-item>
                                  <fo:list-item>
                                      <fo:list-item-label end-indent="label-end()" text-align="right">
                                          <fo:block font-family="Courier">&#x2022;</fo:block>
                                      </fo:list-item-label>
                                      <fo:list-item-body start-indent="body-start()">
                                          <fo:block>
                                              <xsl:if test="string-length(n1:Schedule/n1:NextSchedule/n1:ScheduleMasterData/n1:ScheduledDate) &gt; 0">
                                                  <fo:inline>
                                                      <xsl:text>The next meeting will be held on</xsl:text>
                                                  </fo:inline>
                                              </xsl:if>
                                              <fo:inline>
                                                  <xsl:text>&#160;</xsl:text>
                                              </fo:inline>
                                              <xsl:for-each select="n1:Schedule">
                                                  <xsl:for-each select="n1:NextSchedule">
                                                      <xsl:for-each select="n1:ScheduleMasterData">
                                                          <xsl:for-each select="n1:ScheduledDate">
                                                              <xsl:if test="string-length( . ) &gt;0">
                                                                  <fo:inline>
                                                                      <xsl:value-of select="format-number(number(substring(string(string(.)), 6, 2)), ''00'')"/>
                                                                      <xsl:text>/</xsl:text>
                                                                      <xsl:value-of select="format-number(number(substring(string(string(.)), 9, 2)), ''00'')"/>
                                                                      <xsl:text>/</xsl:text>
                                                                      <xsl:value-of select="format-number(number(substring(string(string(string(.))), 1, 4)), ''0000'')"/>
                                                                  </fo:inline>
                                                                  <fo:inline>
                                                                      <xsl:text>.</xsl:text>
                                                                  </fo:inline>
                                                              </xsl:if>
                                                          </xsl:for-each>
                                                      </xsl:for-each>
                                                  </xsl:for-each>
                                              </xsl:for-each>
                                              <fo:inline>
                                                  <xsl:text>&#160; </xsl:text>
                                              </fo:inline>
                                              <xsl:if test="string-length( n1:Schedule/n1:NextSchedule/n1:ScheduleMasterData/n1:Place  ) &gt; 0">
                                                  <fo:inline>
                                                      <';
      DBMS_LOB.writeappend(data,LENGTH(buffer),buffer);
  END;
  /
  DECLARE    data CLOB; buffer VARCHAR2(32000);
  BEGIN
  SELECT CORRESPONDENCE_TEMPLATE INTO data FROM PROTO_CORRESP_TEMPL WHERE PROTO_CORRESP_TYPE_CODE = (SELECT PROTO_CORRESP_TYPE_CODE FROM PROTO_CORRESP_TYPE WHERE DESCRIPTION = 'Agenda Report') AND COMMITTEE_ID = 'DEFAULT' FOR UPDATE;
  buffer := 'xsl:text>It is scheduled to be held in&#160; at</xsl:text>
                                                  </fo:inline>
                                              </xsl:if>
                                              <fo:inline>
                                                  <xsl:text>&#160; </xsl:text>
                                              </fo:inline>
                                              <xsl:for-each select="n1:Schedule">
                                                  <xsl:for-each select="n1:NextSchedule">
                                                      <xsl:for-each select="n1:ScheduleMasterData">
                                                          <xsl:for-each select="n1:Place">
                                                              <xsl:if test="string-length( . )  &gt;0">
                                                                  <xsl:variable name="value-of-template">
                                                                      <xsl:apply-templates/>
                                                                  </xsl:variable>
                                                                  <xsl:choose>
                                                                      <xsl:when test="contains(string($value-of-template),''&#x2029;'')">
                                                                          <fo:block>
                                                                              <xsl:copy-of select="$value-of-template"/>
                                                                          </fo:block>
                                                                      </xsl:when>
                                                                      <xsl:otherwise>
                                                                          <fo:inline>
                                                                              <xsl:copy-of select="$value-of-template"/>
                                                                          </fo:inline>
                                                                      </xsl:otherwise>
                                                                  </xsl:choose>
                                                                  <fo:inline>
                                                                      <xsl:text>.</xsl:text>
                                                                  </fo:inline>
                                                              </xsl:if>
                                                          </xsl:for-each>
                                                      </xsl:for-each>
                                                  </xsl:for-each>
                                              </xsl:for-each>
                                          </fo:block>
                                      </fo:list-item-body>
                                  </fo:list-item>
                              </fo:list-block>
                              <fo:block/>
                              <fo:inline font-family="Arial" font-size="9pt" font-weight="bold" text-decoration="underline">
                                  <xsl:text>PROTOCOLS SUBMITTED FOR REVIEW</xsl:text>
                              </fo:inline>
                              <fo:block/>
                              <fo:inline-container>
                                  <fo:block>
                                      <xsl:text>&#x2029;</xsl:text>
                                  </fo:block>
                              </fo:inline-container>
                              <fo:block font-family="Arial" font-size="9pt" font-variant="normal" margin="0pt">
                                  <fo:block>
                                      <xsl:for-each select="n1:Schedule">
                                          <xsl:for-each select="n1:ProtocolSubmission">
                                              <xsl:for-each select="n1:SubmissionDetails">
                                ';
      DBMS_LOB.writeappend(data,LENGTH(buffer),buffer);
  END;
  /
  DECLARE    data CLOB; buffer VARCHAR2(32000);
  BEGIN
  SELECT CORRESPONDENCE_TEMPLATE INTO data FROM PROTO_CORRESP_TEMPL WHERE PROTO_CORRESP_TYPE_CODE = (SELECT PROTO_CORRESP_TYPE_CODE FROM PROTO_CORRESP_TYPE WHERE DESCRIPTION = 'Agenda Report') AND COMMITTEE_ID = 'DEFAULT' FOR UPDATE;
  buffer := '                  <fo:block/>
                                                  <xsl:for-each select="n1:SubmissionTypeDesc">
                                                      <xsl:variable name="value-of-template">
                                                          <xsl:apply-templates/>
                                                      </xsl:variable>
                                                      <xsl:choose>
                                                          <xsl:when test="contains(string($value-of-template),''&#x2029;'')">
                                                              <fo:block font-family="Arial" font-size="9pt" font-weight="bold">
                                                                  <xsl:copy-of select="$value-of-template"/>
                                                              </fo:block>
                                                          </xsl:when>
                                                          <xsl:otherwise>
                                                              <fo:inline font-family="Arial" font-size="9pt" font-weight="bold">
                                                                  <xsl:copy-of select="$value-of-template"/>
                                                              </fo:inline>
                                                          </xsl:otherwise>
                                                      </xsl:choose>
                                                  </xsl:for-each>
                                              </xsl:for-each>
                                              <fo:block/>
                                              <fo:inline-container>
                                                  <fo:block>
                                                      <xsl:text>&#x2029;</xsl:text>
                                                  </fo:block>
                                              </fo:inline-container>
                                              <fo:block margin="0pt">
                                                  <fo:block>
                                                      <fo:inline-container>
                                                          <fo:block>
                                                              <xsl:text>&#x2029;</xsl:text>
                                                          </fo:block>
                                                      </fo:inline-container>
                                                      <fo:block margin="0pt">
                                                          <fo:block>
                                                              <xsl:for-each select="n1:ProtocolSummary">
                                                                  <xsl:for-each select="n1:ProtocolMasterData">
                                                                      <fo:inline>
                                                                          <xsl:text>&#160;</xsl:text>
                                                                      </fo:inline>
                                                                      <fo:inline-container>
                                                                          <fo:block>
                                                                              <xsl:text>&#x2029;</xsl:text>
                                                                          </fo:block>
                                                                      </fo:inline-container>
                                                                      <fo:table font-family="Arial" font-size="9pt" table-layout="fixed" width="100%" border-spacing="2pt">
                                                                          <fo:table-column column-width="70"/>
                                                                          <fo:table-column column-width="110"/>
                                                                          <fo:table-co';
      DBMS_LOB.writeappend(data,LENGTH(buffer),buffer);
  END;
  /
  DECLARE    data CLOB; buffer VARCHAR2(32000);
  BEGIN
  SELECT CORRESPONDENCE_TEMPLATE INTO data FROM PROTO_CORRESP_TEMPL WHERE PROTO_CORRESP_TYPE_CODE = (SELECT PROTO_CORRESP_TYPE_CODE FROM PROTO_CORRESP_TYPE WHERE DESCRIPTION = 'Agenda Report') AND COMMITTEE_ID = 'DEFAULT' FOR UPDATE;
  buffer := 'lumn column-width="111"/>
                                                                          <fo:table-column column-width="109"/>
                                                                          <fo:table-column column-width="109"/>
                                                                          <fo:table-body start-indent="0pt">
                                                                              <fo:table-row>
                                                                                  <fo:table-cell padding="2pt" display-align="before">
                                                                                      <fo:block>
                                                                                          <fo:inline font-weight="bold">
                                                                                              <xsl:text>Protocol #: </xsl:text>
                                                                                          </fo:inline>
                                                                                      </fo:block>
                                                                                  </fo:table-cell>
                                                                                  <fo:table-cell padding="2pt" display-align="before">
                                                                                      <fo:block>
                                                                                          <xsl:for-each select="n1:ProtocolNumber">
                                                                                              <xsl:variable name="value-of-template">
                                                                                                  <xsl:apply-templates/>
                                                                                              </xsl:variable>
                                                                                              <xsl:choose>
                                                                                                  <xsl:when test="contains(string($value-of-template),''&#x2029;'')">
                                                                                                      <fo:block>
                                                                                                          <xsl:copy-of select="$value-of-template"/>
                                                                                                      </fo:block>
                                                                                                  </xsl:when>
                                                                                                  <xsl:otherwise>
                                                                                                      <fo:inline>
                                                                                                          <xsl:copy-of select="$value-of-template"/>
                                                                                                      </fo:inline>
                                                                                                  </xsl:otherwise>
                                                                                              </xsl:choose>
                                                                                          </xsl:for-each>
                                                                                      </fo:block>
                                                                                  </fo:table-cell>
                                                                                  <fo:table-cell padding="2pt" display-align="before">
                                                                                      <fo:block>
                                                                                          <fo:inline ';
      DBMS_LOB.writeappend(data,LENGTH(buffer),buffer);
  END;
  /
  DECLARE    data CLOB; buffer VARCHAR2(32000);
  BEGIN
  SELECT CORRESPONDENCE_TEMPLATE INTO data FROM PROTO_CORRESP_TEMPL WHERE PROTO_CORRESP_TYPE_CODE = (SELECT PROTO_CORRESP_TYPE_CODE FROM PROTO_CORRESP_TYPE WHERE DESCRIPTION = 'Agenda Report') AND COMMITTEE_ID = 'DEFAULT' FOR UPDATE;
  buffer := 'font-family="Arial" font-size="9pt" font-weight="bold">
                                                                                              <xsl:text>Expiration Date:</xsl:text>
                                                                                          </fo:inline>
                                                                                      </fo:block>
                                                                                  </fo:table-cell>
                                                                                  <fo:table-cell padding="2pt" text-align="left" display-align="before">
                                                                                      <fo:block>
                                                                                          <xsl:for-each select="n1:ExpirationDate">
                                                                                              <fo:inline>
                                                                                                  <xsl:value-of select="format-number(number(substring(string(string(.)), 6, 2)), ''00'')"/>
                                                                                               <xsl:text>/</xsl:text>
                                                                                                  <xsl:value-of select="format-number(number(substring(string(string(.)), 9, 2)), ''00'')"/>
                                                                                                  <xsl:text>/</xsl:text>
                                                                                                  <xsl:value-of select="format-number(number(substring(string(string(string(.))), 1, 4)), ''0000'')"/>
                                                                                              </fo:inline>
                                                                                          </xsl:for-each>
                                                                                      </fo:block>
                                                                                  </fo:table-cell>
                                                                                  <fo:table-cell padding="2pt" text-align="left" display-align="before">
                                                                                      <fo:block/>
                                                                                  </fo:table-cell>
                                                                              </fo:table-row>
                                                                              <fo:table-row>
                                                                                  <fo:table-cell padding="2pt" display-align="before">
                                                                                      <fo:block>
                                                                                          <fo:inline font-weight="bold">
                                                                                              <xsl:text>Title:</xsl:text>
                                                                                          </fo:inline>
                                                                                      </fo:block>
                                                                                  </fo:table-cell>
                                                                                  <fo:table-cell number-columns-spanned="4" padding="2pt" text-align="left" display-align="before">
                                                                                      <fo:block>
                                                                                          <xsl:for-each select="n1:ProtocolTitle">
                                                                                              <xsl:variable name="value-of-template">
                  ';
      DBMS_LOB.writeappend(data,LENGTH(buffer),buffer);
  END;
  /
  DECLARE    data CLOB; buffer VARCHAR2(32000);
  BEGIN
  SELECT CORRESPONDENCE_TEMPLATE INTO data FROM PROTO_CORRESP_TEMPL WHERE PROTO_CORRESP_TYPE_CODE = (SELECT PROTO_CORRESP_TYPE_CODE FROM PROTO_CORRESP_TYPE WHERE DESCRIPTION = 'Agenda Report') AND COMMITTEE_ID = 'DEFAULT' FOR UPDATE;
  buffer := '                                                                                <xsl:apply-templates/>
                                                                                              </xsl:variable>
                                                                                              <xsl:choose>
                                                                                                  <xsl:when test="contains(string($value-of-template),''&#x2029;'')">
                                                                                                      <fo:block>
                                                                                                          <xsl:copy-of select="$value-of-template"/>
                                                                                                      </fo:block>
                                                                                                  </xsl:when>
                                                                                                  <xsl:otherwise>
                                                                                                      <fo:inline>
                                                                                                          <xsl:copy-of select="$value-of-template"/>
                                                                                                      </fo:inline>
                                                                                                  </xsl:otherwise>
                                                                                              </xsl:choose>
                                                                                          </xsl:for-each>
                                                                                      </fo:block>
                                                                                  </fo:table-cell>
                                                                              </fo:table-row>
                                                                          </fo:table-body>
                                                                      </fo:table>
                                                                  </xsl:for-each>
                                                              </xsl:for-each>
                                                          </fo:block>
                                                      </fo:block>
                                                      <xsl:for-each select="n1:ProtocolSummary">
                                                          <xsl:for-each select="n1:ProtocolMasterData"/>
                                                      </xsl:for-each>
                                                      <fo:inline-container>
                                                          <fo:block>
                                                              <xsl:text>&#x2029;</xsl:text>
                                                          </fo:block>
                                                      </fo:inline-container>
                                                      <fo:table font-family="Arial" font-size="9pt" table-layout="fixed" width="100%" border-spacing="2pt">
                                                          <fo:table-column column-width="70"/>
                                                          <fo:table-column column-width="187"/>
                                                          <fo:table-body start-indent="0pt">
                                                              <fo:table-row>
                                                                  <fo:table-cell padding="2pt" display-align="before">
                                                                      <fo:block>
                                                                          <fo:inline font-weight="bold">
                                                   ';
      DBMS_LOB.writeappend(data,LENGTH(buffer),buffer);
  END;
  /
  DECLARE    data CLOB; buffer VARCHAR2(32000);
  BEGIN
  SELECT CORRESPONDENCE_TEMPLATE INTO data FROM PROTO_CORRESP_TEMPL WHERE PROTO_CORRESP_TYPE_CODE = (SELECT PROTO_CORRESP_TYPE_CODE FROM PROTO_CORRESP_TYPE WHERE DESCRIPTION = 'Agenda Report') AND COMMITTEE_ID = 'DEFAULT' FOR UPDATE;
  buffer := '                           <xsl:text>PI:</xsl:text>
                                                                          </fo:inline>
                                                                      </fo:block>
                                                                  </fo:table-cell>
                                                                  <fo:table-cell padding="2pt" display-align="before">
                                                                      <fo:block>
                                                                          <xsl:for-each select="n1:ProtocolSummary">
                                                                              <xsl:for-each select="n1:Investigator">
                                                                                  <xsl:for-each select="n1:Person">
                                                                                      <xsl:for-each select="n1:Fullname">
                                                                                          <xsl:if test="../../n1:PI_flag  = &apos;true&apos;">
                                                                                              <xsl:variable name="value-of-template">
                                                                                                  <xsl:apply-templates/>
                                                                                              </xsl:variable>
                                                                                              <xsl:choose>
                                                                                                  <xsl:when test="contains(string($value-of-template),''&#x2029;'')">
                                                                                                      <fo:block>
                                                                                                          <xsl:copy-of select="$value-of-template"/>
                                                                                                      </fo:block>
                                                                                                  </xsl:when>
                                                                                                  <xsl:otherwise>
                                                                                                      <fo:inline>
                                                                                                          <xsl:copy-of select="$value-of-template"/>
                                                                                                      </fo:inline>
                                                                                                  </xsl:otherwise>
                                                                                              </xsl:choose>
                                                                                          </xsl:if>
                                                                                      </xsl:for-each>
                                                                                  </xsl:for-each>
                                                                              </xsl:for-each>
                                                                          </xsl:for-each>
                                                                      </fo:block>
                                                                  </fo:table-cell>
                                                              </fo:table-row>
                                                          </fo:table-body>
                                                      </fo:table>
                                                  </fo:block>
                                              </fo:block>
                                              <fo:block/>
                                              <fo:inline-container>
         ';
      DBMS_LOB.writeappend(data,LENGTH(buffer),buffer);
  END;
  /
  DECLARE    data CLOB; buffer VARCHAR2(32000);
  BEGIN
  SELECT CORRESPONDENCE_TEMPLATE INTO data FROM PROTO_CORRESP_TEMPL WHERE PROTO_CORRESP_TYPE_CODE = (SELECT PROTO_CORRESP_TYPE_CODE FROM PROTO_CORRESP_TYPE WHERE DESCRIPTION = 'Agenda Report') AND COMMITTEE_ID = 'DEFAULT' FOR UPDATE;
  buffer := '                                         <fo:block>
                                                      <xsl:text>&#x2029;</xsl:text>
                                                  </fo:block>
                                              </fo:inline-container>
                                              <fo:table table-layout="fixed" width="100%" border-spacing="2pt">
                                                  <fo:table-column column-width="70"/>
                                                  <fo:table-column column-width="25%"/>
                                                  <fo:table-column column-width="70"/>
                                                  <fo:table-column column-width="25%"/>
                                                  <fo:table-body start-indent="0pt">
                                                      <fo:table-row>
                                                          <fo:table-cell padding="2pt" display-align="before">
                                                              <fo:block>
                                                                  <fo:inline-container>
                                                                      <fo:block>
                                                                          <xsl:text>&#x2029;</xsl:text>
                                                                      </fo:block>
                                                                  </fo:inline-container>
                                                                  <fo:block white-space="pre" white-space-collapse="false" wrap-option="wrap" white-space-treatment="ignore-if-surrounding-linefeed" margin="0pt">
                                                                      <fo:block>
                                                                          <fo:inline font-weight="bold">
                                                                              <xsl:text>Primary Reviewers:</xsl:text>
                                                                          </fo:inline>
                                                                      </fo:block>
                                                                  </fo:block>
                                                              </fo:block>
                                                          </fo:table-cell>
                                                          <fo:table-cell padding="2pt" display-align="before">
                                                              <fo:block>
                                                                  <xsl:for-each select="n1:SubmissionDetails">
                                                                      <xsl:for-each select="n1:ProtocolReviewer">
                                                                          <xsl:for-each select="n1:Person">
                                                                              <xsl:for-each select="n1:Fullname">
                                                                                  <xsl:if test="../../n1:ReviewerTypeCode = 1">
                                                                                      <fo:inline-container>
                                                                                          <fo:block>
                                                                                              <xsl:text>&#x2029;</xsl:text>
                                                                                          </fo:block>
                                                                                      </fo:inline-container>
                                                                                      <fo:block white-space="pre" white-space-collapse="false" wrap-option="wrap" white-space-treatment="ignore-if-surrounding-linefeed" margin="0pt">
                                                                                          <fo:block>
                         ';
      DBMS_LOB.writeappend(data,LENGTH(buffer),buffer);
  END;
  /
  DECLARE    data CLOB; buffer VARCHAR2(32000);
  BEGIN
  SELECT CORRESPONDENCE_TEMPLATE INTO data FROM PROTO_CORRESP_TEMPL WHERE PROTO_CORRESP_TYPE_CODE = (SELECT PROTO_CORRESP_TYPE_CODE FROM PROTO_CORRESP_TYPE WHERE DESCRIPTION = 'Agenda Report') AND COMMITTEE_ID = 'DEFAULT' FOR UPDATE;
  buffer := '                                                                     <xsl:variable name="value-of-template">
                                                                                                  <xsl:apply-templates/>
                                                                                              </xsl:variable>
                                                                                              <xsl:choose>
                                                                                                  <xsl:when test="contains(string($value-of-template),''&#x2029;'')">
                                                                                                      <fo:block>
                                                                                                          <xsl:copy-of select="$value-of-template"/>
                                                                                                      </fo:block>
                                                                                                  </xsl:when>
                                                                                                  <xsl:otherwise>
                                                                                                      <fo:inline>
                                                                                                          <xsl:copy-of select="$value-of-template"/>
                                                                                                      </fo:inline>
                                                                                                  </xsl:otherwise>
                                                                                              </xsl:choose>
                                                                                          </fo:block>
                                                                                      </fo:block>
                                                                                  </xsl:if>
                                                                              </xsl:for-each>
                                                                          </xsl:for-each>
                                                                      </xsl:for-each>
                                                                  </xsl:for-each>
                                                              </fo:block>
                                                          </fo:table-cell>
                                                          <fo:table-cell padding="2pt" display-align="before">
                                                              <fo:block>
                                                                  <fo:inline font-weight="bold">
                                                                   <xsl:text>Secondary Reviewers:</xsl:text>
                                                                  </fo:inline>
                                                              </fo:block>
                                                          </fo:table-cell>
                                                          <fo:table-cell padding="2pt" display-align="before">
                                                              <fo:block>
                                                                  <xsl:for-each select="n1:SubmissionDetails">
                                                                      <xsl:for-each select="n1:ProtocolReviewer">
                                                                          <xsl:for-each select="n1:Person">
                                                                              <xsl:for-each select="n1:Fullname">
                                                                                  <xsl:if test="../../n1:ReviewerTypeCode = 2">
                                                                                      <fo:inli';
      DBMS_LOB.writeappend(data,LENGTH(buffer),buffer);
  END;
  /
  DECLARE    data CLOB; buffer VARCHAR2(32000);
  BEGIN
  SELECT CORRESPONDENCE_TEMPLATE INTO data FROM PROTO_CORRESP_TEMPL WHERE PROTO_CORRESP_TYPE_CODE = (SELECT PROTO_CORRESP_TYPE_CODE FROM PROTO_CORRESP_TYPE WHERE DESCRIPTION = 'Agenda Report') AND COMMITTEE_ID = 'DEFAULT' FOR UPDATE;
  buffer := 'ne-container>
                                                                                          <fo:block>
                                                                                              <xsl:text>&#x2029;</xsl:text>
                                                                                          </fo:block>
                                                                                      </fo:inline-container>
                                                                                      <fo:block white-space="pre" white-space-collapse="false" wrap-option="wrap" white-space-treatment="ignore-if-surrounding-linefeed" margin="0pt">
                                                                                          <fo:block>
                                                                                              <xsl:variable name="value-of-template">
                                                                                                  <xsl:apply-templates/>
                                                                                              </xsl:variable>
                                                                                              <xsl:choose>
                                                                                                  <xsl:when test="contains(string($value-of-template),''&#x2029;'')">
                                                                                                      <fo:block>
                                                                                                          <xsl:copy-of select="$value-of-template"/>
                                                                                                      </fo:block>
                                                                                                  </xsl:when>
                                                                                                  <xsl:otherwise>
                                                                                                      <fo:inline>
                                                                                                          <xsl:copy-of select="$value-of-template"/>
                                                                                                      </fo:inline>
                                                                                                  </xsl:otherwise>
                                                                                              </xsl:choose>
                                                                                          </fo:block>
                                                                                      </fo:block>
                                                                                  </xsl:if>
                                                                              </xsl:for-each>
                                                                          </xsl:for-each>
                                                                      </xsl:for-each>
                                                                  </xsl:for-each>
                                                              </fo:block>
                                                          </fo:table-cell>
                                                      </fo:table-row>
                                                  </fo:table-body>
                                              </fo:table>
                                              <fo:inline-container>
                                                  <fo:block>
                                                      <xsl:text>&#x2029;</xsl:text>
                                                  </fo:block>
                                              </fo:inline-container>
                                              <fo:table table-layout="fixed" width="100%" border-spacing="2pt">
                 ';
      DBMS_LOB.writeappend(data,LENGTH(buffer),buffer);
  END;
  /
  DECLARE    data CLOB; buffer VARCHAR2(32000);
  BEGIN
  SELECT CORRESPONDENCE_TEMPLATE INTO data FROM PROTO_CORRESP_TEMPL WHERE PROTO_CORRESP_TYPE_CODE = (SELECT PROTO_CORRESP_TYPE_CODE FROM PROTO_CORRESP_TYPE WHERE DESCRIPTION = 'Agenda Report') AND COMMITTEE_ID = 'DEFAULT' FOR UPDATE;
  buffer := '                                 <fo:table-column column-width="proportional-column-width(1)"/>
                                                  <fo:table-body start-indent="0pt">
                                                      <fo:table-row>
                                                          <fo:table-cell padding="2pt" display-align="center">
                                                              <fo:block/>
                                                          </fo:table-cell>
                                                      </fo:table-row>
                                                  </fo:table-body>
                                              </fo:table>
                                          </xsl:for-each>
                                      </xsl:for-each>
                                  </fo:block>
                              </fo:block>
                          </xsl:for-each>
                      </fo:block>
                      <fo:block id="SV_RefID_PageTotal"/>
                  </fo:flow>
              </fo:page-sequence>
          </fo:root>
      </xsl:template>
      <xsl:template match="n1:ProtocolSubmission">
          <fo:block/>
          <fo:block/>
      </xsl:template>
      <xsl:template match="n1:ProtocolSummary">
          <fo:block/>
      </xsl:template>
      <xsl:template match="n1:ResearchArea">
          <xsl:variable name="value-of-template">
              <xsl:apply-templates/>
          </xsl:variable>
          <xsl:choose>
              <xsl:when test="contains(string($value-of-template),''&#x2029;'')">
                  <fo:block>
                      <xsl:copy-of select="$value-of-template"/>
                  </fo:block>
              </xsl:when>
              <xsl:otherwise>
                  <fo:inline>
                      <xsl:copy-of select="$value-of-template"/>
                  </fo:inline>
              </xsl:otherwise>
          </xsl:choose>
      </xsl:template>
      <xsl:template name="double-backslash">
          <xsl:param name="text"/>
          <xsl:param name="text-length"/>
          <xsl:variable name="text-after-bs" select="substring-after($text, ''\'')"/>
          <xsl:variable name="text-after-bs-length" select="string-length($text-after-bs)"/>
          <xsl:choose>
              <xsl:when test="$text-after-bs-length = 0">
                  <xsl:choose>
                      <xsl:when test="substring($text, $text-length) = ''\''">
                          <xsl:value-of select="concat(substring($text,1,$text-length - 1), ''\\'')"/>
                      </xsl:when>
                      <xsl:otherwise>
                          <xsl:value-of select="$text"/>
                      </xsl:otherwise>
                  </xsl:choose>
              </xsl:when>
              <xsl:otherwise>
                  <xsl:value-of select="concat(substring($text,1,$text-length - $text-after-bs-length - 1), ''\\'')"/>
                  <xsl:call-template name="double-backslash">
                      <xsl:with-param name="text" select="$text-after-bs"/>
                      <xsl:with-param name="text-length" select="$text-after-bs-length"/>
                  </xsl:call-template>
              </xsl:otherwise>
          </xsl:choose>
      </xsl:template>
  </xsl:stylesheet>
  ';
      DBMS_LOB.writeappend(data,LENGTH(buffer),buffer);
  END;
  /
  