Results Reports version 01_00_03 March 19, 2004.

In DBQ01

Oracle

Use the RESULTSRPT Database Access.xls spreadsheet 
The grant statements for Procedures
 has been generated and the grant statements are in the output tab.

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


1) Create New Table
   Create Public Synonyms for these

@S:\Test\resultsrpt\Oracle\01_00_03\ddl\tab\PRIVATE_LAND_VOL_HA_RATIO_CONV.tab

2) Create New Function that is used by a view
   Create Public Synonym for this

@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\CRS_GET_OPENING_CLIENT.FNC

3) Create New View
   Create Public Synonym for this

@S:\Test\resultsrpt\Oracle\01_00_03\ddl\vw\V_OPENING_TENURE.VW

4) Update Existing Functions

@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_FTASCLT_CLIENT_LOCN.FNC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_FTASCLT_CLIENT_NUMBER.FNC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_GET_FOR_COVR_SPEC_DATA.FNC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_GET_SL_ACC_TREE.FNC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_GET_SL_PREF_TREE.FNC

5) Create New Functions 
   Create Public Synonyms for these

@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\CRS_GET_OPENING_CLIENT.FNC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_ADD_YEARS.FNC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_GET_BLOCK_STATUS.FNC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_GET_CLIENT_NAME.FNC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_GET_COMMENCEMENT_DATE.FNC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_GET_MARK_STATUS.FNC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_GET_SILV_METHOD_DESCR.FNC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_GET_SSU_MILESTONE_DT2.FNC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_LAND_STATUS_FFGROUP.FNC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_LAND_STATUS_PLANTED.FNC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_LAND_STATUS_PLANTFAIL.FNC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_OSHDR_CLIENT_LOCN_CODE.FNC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_OSHDR_CLIENT_NUMBER.FNC

6) Create New Functions that call other functions
   Create Public Synonyms for these

@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_LAND_STATUS_NATURAL.FNC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_LAND_STATUS_REGENFAIL.FNC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_LAND_STATUS_NEWDENUDE.FNC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\fnc\RSLTRPT_LAND_STATUS_NPRECLASS.FNC


7) Update Existing Procedures

@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_DECLARATION.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_FG_15MONTH_IND.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_OPENING_SUMMARY.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_OPENING_SUMMARY_STOCK.PRC

8) Create New Procedures
   Create Public Synonyms for these

@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_AREA_HV_BY_SILV.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_AREA_PL_BY_RSPONSBILTY.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_FERTILIZATION_ON_CROWN.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_NSR_CROWN_LAND.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_OPENING_SUMM_CMT_ATU.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_OPENING_SUMM_CMT_OPEN.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_OPENING_SUMM_CMT_SMS.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_OPENING_SUMM_CMT_SSU.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_PRUNING_ON_CROWN.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_RDD001.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_RDD002.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_RDD003.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_RDD004.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_RDD005.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_RDD006.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_RDD007.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_RDD008.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_RDD009.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_RDD010.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_RDD011.PRC
@S:\Test\resultsrpt\Oracle\01_00_03\ddl\prc\RSLTRPT_REGEN_FG_DUE_YEAR.PRC



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

1) @S:\test\resultsrpt\Oracle\01_00_02\install_scripts\packages.sql
2) @S:\test\resultsrpt\Oracle\01_00_02\install_scripts\functions.sql
3) @S:\test\resultsrpt\Oracle\01_00_02\install_scripts\procedures.sql

Create Public synonyms

4) @S:\test\resultsrpt\Oracle\01_00_02\roles_users\grants.sql
