-- -------------------------------------------------------------------------------------
-- Name.....: DBA_Migration_Notes.txt
-- Purpose..: DBA Migration Notes, FTARPT version 02_02_07
-- -------------------------------------------------------------------------------------
-- <Mar 20 2006> <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 Packages
   FTARPT_REPORT_PACKAGE.pkg

2) Create new Function (require Public Synonyms)
   FTARPT_GET_DISTRICT_NO.FNC

3) Update existing Function
   FTARPT_V_CHECK_FILE_LIST.fnc   

4) Crate new Views (require Public Synonyms)
   V_FTARPT_P07_CUT_PERMIT_HIST.VW


5) Create New procedures (require Public Synonyms)
   FTARPT_P07_CUT_PERMIT_HIST.PRC
   FTARPT_PD_BILLING_TYPE.PRC
   FTARPT_PD_LOG_SALE_GRADE1.PRC
   FTARPT_PD_LOG_SALE_GRADE.PRC
   FTARPT_PD_SALE_METHOD.PRC
   FTARPT_PD_SALVAGE_TYPE.prc
   FTARPT_V_CHECK_FOREST_FILE_ID.prc

6) Update Existing procedures 
   FTARPT_CUT_BLOCKS_WITH_SPATIAL.prc
   FTARPT_ROAD_PRMT_WITH_SPATIAL.prc

7)
   roles_users\Grant_roles.sql

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

-  generate public synonym list
-  review for invalids

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

