-- -------------------------------------------------------------------------------------
-- Name.....: DBA_Migration_Notes.txt
-- Purpose..: DBA Migration Notes, FTARPT version 02_01_15
-- -------------------------------------------------------------------------------------
-- <Mar 2 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) Create new Function (require Public Synonyms)
   FTARPT_GET_DISTRICT_NO.FNC

2) Crate new Views (require Public Synonyms)
   V_FTARPT_F01R_LICENCE_DATES
   V_FTARPT_F02R_LIC_STATUS_REGST
   V_FTARPT_F03R_ALLOWABLE_AN_CUT
   V_FTARPT_F04R_MAILING_LIST_LIC
   V_FTARPT_F05R_LICENCE_CL_REGST
   V_FTARPT_F06R_ASSOCIATED_FILE
   V_FTARPT_F08R_LICENCE_OPENING2
   V_FTARPT_F09R_LICENCE_SALES
   V_FTARPT_R01R_ROAD_PERMIT_SECN
   V_FTARPT_R02R_ROAD_PERMIT_AMEN
   V_FTARPT_R03R_CURKM_UNDR_RDPRM

3) Update existing Views
   V_FTARPT_B01_CUT_BLOCK_STATUS.VW
   V_FTARPT_B02_CUT_BLOCK_AREAS.VW
   V_FTARPT_B03_CUT_BLOCK_DATES.VW
   V_FTARPT_F01_LICENCE_DATES.VW
   V_FTARPT_F02_LIC_STATUS_REGSTR.VW
   V_FTARPT_F03_ALLOWABLE_ANN_CUT.VW
   V_FTARPT_F04_MAILING_LIST_LIC.VW
   V_FTARPT_F05_LICENCE_CL_REGSTR.VW
   V_FTARPT_F06_ASSOCIATED_FILES.VW
   V_FTARPT_F07_LICENCE_OPENINGB.VW
   V_FTARPT_F08_LICENCE_OPENING2B.VW
   V_FTARPT_F09_LICENCE_SALES.VW
   V_FTARPT_P01_CUT_PERMIT_LISTNG.VW
   V_FTARPT_P02_CUT_PERMIT_DATES.VW
   V_FTARPT_P03_PRIV_MARK_REGISTR.VW
   V_FTARPT_P04_SMALL_BUS_MARKS.VW
   V_FTARPT_P05_CASH_SALES_REPORT.VW
   V_FTARPT_P06_CUT_PERMIT_HIST.VW
   V_FTARPT_P07_CUT_PERMIT_HIST.VW
   V_FTARPT_R01_ROAD_PERMIT_SECTN.VW
   V_FTARPT_R02_ROAD_PERMIT_AMEND.VW
   V_FTARPT_R03_CURKM_UNDR_RDPRMT.VW
   V_FTARPT_RAN01_GRAZING_TENURE.VW
   V_FTARPT_RAN02_HAYCUTNG_TENURE.VW
   V_FTARPT_RAN04_RANGE_UNIT.VW


4) Create New procedures (require Public Synonyms)
   FTARPT_P07_CUT_PERMIT_HIST
   FTARPT_PD_BILLING_TYPE
   FTARPT_PD_LOG_SALE_GRADE
   FTARPT_PD_LOG_SALE_GRADE1
   FTARPT_PD_SALE_METHOD

5) Update Existing procedures
   FTARPT_B01_CUT_BLOCK_STATUS.PRC
   FTARPT_B02_CUT_BLOCK_AREAS.PRC
   FTARPT_B03_CUT_BLOCK_DATES.PRC
   FTARPT_B04_CUT_BLOCK_OPENING.PRC
   FTARPT_CUT_BLOCKS_WITH_SPATIAL.prc
   FTARPT_F01_LICENCE_DATES.PRC
   FTARPT_F02_LIC_STATUS_REGSTR.PRC
   FTARPT_F03_ALLOWABLE_ANN_CUT.PRC
   FTARPT_F04_MAILING_LIST_LIC.PRC
   FTARPT_F05_LICENCE_CL_REGSTR.PRC
   FTARPT_F06_ASSOCIATED_FILES.PRC
   FTARPT_F07_LICENCE_OPENINGB.PRC
   FTARPT_F08_LICENCE_OPENING2B.PRC
   FTARPT_F09_LICENCE_SALES.PRC
   FTARPT_P01_CUT_PERMIT_LISTNG.PRC
   FTARPT_P02_CUT_PERMIT_DATES.PRC
   FTARPT_P03_PRIV_MARK_REGISTR.PRC
   FTARPT_P04_SMALL_BUS_MARKS.PRC
   FTARPT_P05_CASH_SALES_REPORT.PRC
   FTARPT_P06_CUT_PERMIT_HIST.PRC
   FTARPT_R01_ROAD_PERMIT_SECTN.PRC
   FTARPT_R02_ROAD_PERMIT_AMEND.PRC
   FTARPT_R03_CURKM_UNDR_RDPRMT.PRC
   FTARPT_RAN01_GRAZING_TENURE.PRC
   FTARPT_RAN02_HAYCUTNG_TENURE.PRC
   FTARPT_RAN04_RANGE_UNIT.PRC
   FTARPT_ROAD_PRMT_WITH_SPATIAL.prc

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

-  generate public synonym list
-  review for invalids

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

