-- -------------------------------------------------------------------------------------
-- Name.....: DBA_Migration_Notes.txt
-- Purpose..: DBA Migration Notes, FTARPT version 02_00_02
-- -------------------------------------------------------------------------------------
-- <Aug 4 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 existing views and Create new views 
   ddl\vw\V_FTARPT_F07_LICENCE_OPENING.VW
   ddl\vw\V_FTARPT_F08_LICENCE_OPENING2.VW

2) Create new functions
   ddl\fnc\FTARPT_GET_FOREST_COVER_AREA.FNC
   ddl\fnc\FTARPT_GET_NET_AREA.FNC

3) Update existing procedures and create new procedures
   ddl\prc\FTARPT_B02_CUT_BLOCK_AREAS.PRC
   ddl\prc\FTARPT_F07_LICENCE_OPENING.PRC
   ddl\prc\FTARPT_F08_LICENCE_OPENING2.PRC

4) Create Public Synonyms
   The following objects are new and require grants and public synonyms:

   Views:
   V_FTARPT_F08_LICENCE_OPENING2

   Functions:
   FTARPT_GET_FOREST_COVER_AREA
   FTARPT_GET_NET_AREA

   Procedures:
   FTARPT_F08_LICENCE_OPENING2

5) Create Grants

   GRANT select on V_FTARPT_F08_LICENCE_OPENING2 to CRS_WEB_INQUIRY;

   GRANT execute on FTARPT_GET_FOREST_COVER_AREA to CRS_WEB_INQUIRY;
   GRANT execute on FTARPT_GET_NET_AREA to CRS_WEB_INQUIRY;

   GRANT execute on FTARPT_F08_LICENCE_OPENING2 to CRS_FTARPT_REPORTS;
   GRANT execute on FTARPT_F08_LICENCE_OPENING2 to CRS_FTARPT_LIC_REPORTS;
   GRANT execute on FTARPT_F08_LICENCE_OPENING2 to CRS_WEB_INQUIRY;

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

-  generate public synonym list
-  review for invalids

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

