/******************************************************************************
    Package:  spr_seedlot

    Purpose:  Package contains database operations and validations for
              the SEEDLOT table.

    Revision History

    Person             Date        Comments
    -----------------  ----------  ------------------------------------------
    Pangaea            2005-06-01  Generated
    R.A.Robb           2005-09-15  PT#28014 - Custom lots get GW of 2, make
                                   % Contrib calcs weighted, add seedlot_split_ind,
                                   misc bug fixes
    R.A.Robb           2005-09-30  PT#28159 - fixes for setting delcaration user
                                   and timestamp
    R.A.Robb           2005-10-24  PT#28334 - new tables for class A Area of Use
                                   derivation
                                   PT#28216 - added geography_error_ind
    R.A.Robb           2005-11-13  PT#28587 - interim rule (until GW-D,GW-R calcs
                                   added - if GW-G has been blanked and another
                                   GW value exists do not replaced.
    R.A.Robb           2005-11-23  PT#28637 - correct issue in load_array where
                                   previously queried value was loaded when a
                                   current test result was not found
    R.A.Robb           2005-12-27  PT#28861 - add coancestry
    B.Kyle             2005-12-27  PT#28803 - Added validate_seedlot_class_code
    R.A.Robb           2006-02-04  PT#28783 - new pt_tested_area_of_use structure
                                   PT#29343 - relax edits on collection
                                   elev/lat/long for non-BC source, A lots
    E.Wong             2006-08-10  Rls 3.1 - SMP Calculation modifications.
    E.Wong             2006-08-26  Added calculation of GW-D and GW-R.
    E.Wong             2006-08-31  Rls 3.2 - Addition of GW-M field.
    E.Wong             2007-04-12  Rls 3.3 - PT#35233 - blanking of GW fields if one
                                             of the GW fields has data is not working.
                                             Need to be able to SAVE a blank GW.
    E.Wong             2007-11-27  Rls 4.2 - PT#39514 - Allow non-ministry users who
                                             are Original Owners the ability to view
                                             their seedlot.
    E.Wong             2008-01-15  PT#36085 - add elev range edit for B class
    E.Wong             2008-11-06  PT#42313 - Added functionality to clone a
                                   seedlot record.
    E.Wong             2008-12-08  PT#42437 - Add functions to return the current BGC
                                   and the current SPZ values for a seedlot.
    E.Wong             2009-01-19  PT#42313 - Allow user to enter a new seedlot
                                   number to set the clone lot to.  Added
                                   validations of the new seedlot number.
    E.Wong             2009-01-27  PT#42313 - Allow overwriting of existing seedlot
                                   that is in INC status for copy functionality.
    E.Wong             2009-03-10  PT#43998 - Remove restriction to copy functionality
                                   that allows seedlots to be created only in 52xxx
                                   and 62xxx set.
    R.A.Robb           2009-03-20  Added new functions, get_original_tpg,
                                   get_original_potential_trees.
    E.Wong             2009-03-26  PT#43998 - Retain seedlot test records from the
                                   seedlot being overwritten by copy seedlot.
    R.A.Robb           2009-03-26  PT#42896 - New functions to check whether a seedlot
                                   is Class B+ or B non-superior provenance.
    R.A.Robb           2009-03-31  PT#42759 - New function get_original_germ_pct.
    E.Wong             2009-11-22  PT#44836 - GW calculation on the SPR001SeedlotReg page
                                   was leaving-out the non-orchard pollen contam value,
                                   when loading the PT info, causing a miscalculation.
******************************************************************************/