-- -------------------------------------------------------------------------------------
-- Name.....: DBA_Migration_Notes.txt
-- Purpose..: DBA Migration Notes, FTARPT version 02_01_10
-- -------------------------------------------------------------------------------------
-- <Feb 9 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) Update existing package
   @S:\Test\ftarpt\Oracle\02_01_10\ddl\pkg\FTARPT_REPORT_PACKAGE.pkg

2) Update Existing View
   @S:\Test\ftarpt\Oracle\02_01_10\ddl\vw\V_FTARPT_F08_LICENCE_OPENING2B.VW

3) Create New Functions (Needs Public Synonyms)
   @S:\Test\ftarpt\Oracle\02_01_10\ddl\fnc\CRS_URL_ENCODER.FNC

4) Create New Procedures (Needs Public Synonyms)
   @S:\Test\ftarpt\Oracle\02_01_10\ddl\prc\FTARPT_CUT_BLOCKS_WITH_SPATIAL.PRC
   @S:\Test\ftarpt\Oracle\02_01_10\ddl\prc\FTARPT_ESF_MESSAGE.PRC
   @S:\Test\ftarpt\Oracle\02_01_10\ddl\prc\FTARPT_PD_MGMT_UNIT.PRC
   @S:\Test\ftarpt\Oracle\02_01_10\ddl\prc\FTARPT_PD_SALE_TYPE.PRC

5) Update exisitng Procedures
   @S:\Test\ftarpt\Oracle\02_01_10\ddl\prc\FTARPT_ESF0011.PRC
   @S:\Test\ftarpt\Oracle\02_01_10\ddl\prc\FTARPT_F09_LICENCE_SALES.PRC


6) Grant Roles
GRANT execute on FTARPT_ESF_MESSAGE to CRS_WEB_INQUIRY;
GRANT execute on FTARPT_PD_MGMT_UNIT to CRS_WEB_INQUIRY;
GRANT execute on FTARPT_PD_SALE_TYPE to CRS_WEB_INQUIRY;
GRANT execute on FTARPT_ESF_MESSAGE to CRS_FTARPT_REPORTS;
GRANT execute on FTARPT_PD_MGMT_UNIT to CRS_FTARPT_REPORTS;
GRANT execute on FTARPT_PD_SALE_TYPE to CRS_FTARPT_REPORTS;
GRANT execute on FTARPT_ESF_MESSAGE to CRS_FTARPT_LIC_REPORTS;
GRANT execute on FTARPT_PD_MGMT_UNIT to CRS_FTARPT_LIC_REPORTS;
GRANT execute on FTARPT_PD_SALE_TYPE to CRS_FTARPT_LIC_REPORTS;
GRANT execute on CRS_URL_ENCODER to CRS_WEB_INQUIRY;


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

-  generate public synonym list
-  review for invalids

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

