-- -------------------------------------------------------------------------------------
-- Name.....: DBA_Migration_Notes.txt
-- Purpose..: DBA Migration Notes, FTARPT version 01_00_05
-- -------------------------------------------------------------------------------------
-- <MAR 9 2004> <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 Views
   @S:\Test\ftarpt\Oracle\01_00_05\vw\V_FTARPT_P05_CASH_SALES_REPORT.VW

2) Create New Functions (Need Public Synonyms)
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_FRTR500_BONUS_BID.FNC
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_FRTR500_NET_CRUISE_VOL.FNC
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_FRTR500_UPSET_RATE.FNC
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_GET_CBID_CNT_D.fnc
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_GET_CBID_TOTAL_D.fnc
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_GET_FFID_CNT_D.fnc
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_GET_FFID_TOTAL_D.fnc
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_GET_MARKDES.fnc
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_GET_MGMT_UNIT_ID_DESC.fnc
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_GET_ORG_NUM.FNC
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_GET_PERMIT_LOCATION.fnc
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_GET_ROLLUP_DIST_NAME.fnc
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_GET_ROLLUP_REGN_NAME.fnc
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_GET_TMID_CNT_D.fnc
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_GET_TMID_TOTAL_D.fnc
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_GET_TOTAL_STATUS_CNT_D.fnc
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_V_DOFR001.FNC
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_V_FTAR085.FNC

3) Create New Functions that can other functions (Need Public Synonyms)
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_GET_TOT_CUTBLOCK_AREA_D.fnc
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_GET_TOT_NET_CRUISE_VL_D.fnc
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_GET_NCV_CB_TIMBER_CNT_D.fnc
   @S:\Test\ftarpt\Oracle\01_00_05\fnc\FTARPT_GET_ACT_AVG_VOLUME_D.fnc

4) Update Procedures
   @S:\Test\ftarpt\Oracle\01_00_05\prc\FTARPT_P05_CASH_SALES_REPORT.PRC
   @S:\Test\ftarpt\Oracle\01_00_05\prc\FTARPT_RAN01_GRAZING_TENURE.PRC
   @S:\Test\ftarpt\Oracle\01_00_05\prc\FTARPT_RAN02_HAYCUTNG_TENURE.PRC
   @S:\Test\ftarpt\Oracle\01_00_05\prc\FTARPT_RAN04_RANGE_UNIT.PRC
   @S:\Test\ftarpt\Oracle\01_00_05\prc\FTARPT_T03_TMARK_LISTING.PRC
   @S:\Test\ftarpt\Oracle\01_00_05\prc\FTARPT_T03_TMARK_LISTING_V2.PRC

5) Create New Procedures (Need Public Synonyms)
   @S:\Test\ftarpt\Oracle\01_00_05\prc\FTARPT_ACTIVE_MARK_LICENCE.prc
   @S:\Test\ftarpt\Oracle\01_00_05\prc\FTARPT_AVRG_STUMPAGE_PRICE_BID.prc
   @S:\Test\ftarpt\Oracle\01_00_05\prc\FTARPT_DELETED_EE_DATA.PRC
   @S:\Test\ftarpt\Oracle\01_00_05\prc\FTARPT_DIST_OVERRIDE_FACILITY.prc
   @S:\Test\ftarpt\Oracle\01_00_05\prc\FTARPT_FRTR500.PRC
   @S:\Test\ftarpt\Oracle\01_00_05\prc\FTARPT_TENURE_STAT_ANALYSIS_D.prc
   @S:\Test\ftarpt\Oracle\01_00_05\prc\FTARPT_TIMBER_MARK_DESIGNATE.prc
   @S:\Test\ftarpt\Oracle\01_00_05\prc\FTARPT_TIMBER_MARK_DETAILS.PRC

5) Grant priviledges
@S:\Test\ftarpt\Oracle\01_00_05\roles_users\grants.sql
-- -------------------------------------------------------------------------------------

-  generate public synonym list
-  review for invalids

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

