-- -------------------------------------------------------------------------------------
-- Name.....: DBA_Migration_Notes.txt
-- Purpose..: DBA Migration Notes, FTARPT version 02_01_10
-- -------------------------------------------------------------------------------------
-- <Feb 9 2005> <DRV> For migration into <test> (<DBQ01>)

These are required Pulldown and validation procedures and functions need to allow the 
reports to run in CRSRM


-- -------------------------------------------------------------------------------------
-- Migration Notes:


 - As per instructions: 
1) Update existing package
   @S:\Test\ftarpt\Oracle\02_01_10\ddl\pkg\FTARPT_REPORT_PACKAGE.pkg

4) Create New Procedures (Needs Public Synonyms)
   @S:\Test\ftarpt\Oracle\02_01_11\ddl\prc\CRS_TSO_ALL_CODE_PULLDOWN.PRC
   @S:\Test\ftarpt\Oracle\02_01_11\ddl\prc\CRS_TSO_ALL_NO_PULLDOWN.PRC
   @S:\Test\ftarpt\Oracle\02_01_11\ddl\prc\CRS_TSO_CODE_PULLDOWN.PRC
   @S:\Test\ftarpt\Oracle\02_01_11\ddl\prc\CRS_TSO_DISTRICT_REGION_CD_PD.PRC
   @S:\Test\ftarpt\Oracle\02_01_11\ddl\prc\CRS_TSO_DISTRICT_REGION_NO_PD.PRC
   @S:\Test\ftarpt\Oracle\02_01_11\ddl\prc\CRS_TSO_DIST_REGION_ALL_CD_PD.PRC
   @S:\Test\ftarpt\Oracle\02_01_11\ddl\prc\CRS_TSO_DIST_REGION_ALL_NO_PD.PRC
   @S:\Test\ftarpt\Oracle\02_01_11\ddl\prc\CRS_TSO_NO_PULLDOWN.PRC

5) Update exisitng Procedures
   @S:\Test\ftarpt\Oracle\02_01_11\ddl\prc\FTARPT_ESF_MESSAGE.PRC
   @S:\Test\ftarpt\Oracle\02_01_11\ddl\prc\FTARPT_CUT_BLOCKS_WITH_SPATIAL.prc

6) Grant Roles
See FTARPT Security Matrix.xls

-- -------------------------------------------------------------------------------------

-  generate public synonym list
-  review for invalids

-- -------------------------------------------------------------------------------------

