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

2) Create new function
   install_scripts\fnc.sql

3) Update existing procedures and create new procedures
   install_scripts\prc.sql

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

   Functions:
   FTARPT_GET_FORMAT_CLIENT_NAME

   Procedures:
   FTARPT_ESF001
   FTARPT_ESF002
   FTARPT_PD_OPEN_CATEGORY
   FTARPT_PD_PAYMENT_METHOD

5) Create Grants
   roles_users\grants.sql

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

-  generate public synonym list
-  review for invalids

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

