-- -------------------------------------------------------------------------------------
-- Name.....: DBA_Migration_Notes.txt
-- Purpose..: DBA Migration Notes, FTARPT version 02_00_03
-- -------------------------------------------------------------------------------------
-- <Aug 5 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
   install_scripts\vw.sql

2) Update existing procedures
   install_scripts\prc.sql

3) The following are new and require public synonyms
   New Views
   V_FTARPT_F09_LICENCE_SALES

   New Procedures
   FTARPT_ESF0010
   FTARPT_ESF0011
   FTARPT_ESF003
   FTARPT_ESF004
   FTARPT_ESF005
   FTARPT_ESF006
   FTARPT_F09_LICENCE_SALES
   FTARPT_PD_CASCADE_SPLIT
   FTARPT_PD_ESF_STATUS
   FTARPT_PD_OPEN_CATEGORY_CODE
   FTARPT_PD_SALES_OFFICE
   FTARPT_PD_TENURE_APPLICT_PURP
   FTARPT_PD_TENURE_APPLICT_STATE
   FTARPT_PD_TENURE_APPLICT_TYPE


4) Run Grants for new Views and Functions
   roles_users\new_grants.sql

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

-  generate public synonym list
-  review for invalids

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

