-- -------------------------------------------------------------------------------------
-- Name.....: DBA_Migration_Notes.txt
-- Purpose..: DBA Migration Notes, FTARPT version 02_01_04
-- -------------------------------------------------------------------------------------
-- <Sep 14 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) Create new Procedures and Update existing Procedures
   install_scripts\prc.sql


2) create synonyms
   FTARPT_B04_CUT_BLOCK_OPENING is new and needs a public synonym

3) create grants
GRANT execute on FTARPT_B04_CUT_BLOCK_OPENING to CRS_FTARPT_REPORTS;
GRANT execute on FTARPT_B04_CUT_BLOCK_OPENING to CRS_FTARPT_LIC_REPORTS;
GRANT execute on FTARPT_B04_CUT_BLOCK_OPENING to CRS_WEB_INQUIRY;


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

-  generate public synonym list
-  review for invalids

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

