Version 2.1.16 09-May-2010 1. Fixed issue with error status not updating 2. Fixed issue with very small number using exponent not loading or comparing correctly 3. Changed resource form, removing issue when loaded resource doesn't exist causing a form Version 2.1.15 18-March-2010 1. Toolbar and Menu improvements Version 2.1.14 09-March-2010 1. Wizard not reseting upload error exists flag. 2. Bug in cboschedule in the operation resources form. 3. Session ID duplicate variable causing large block not to load 4. If delete group isnt used form had deletegroup error Version 2.1.13 07-March-2010 1. Updated get_resource cbos to use cbo.column 2. Fixed download resources downloading to the wrong column for item/lot information 3. Changed uploader to upload resources within operations for cleaner design 4. Changed Get functions to use more bind variables. Version 2.1.12 05-March-2010 1. Update get revisions code to look at implemented ECOs only 2. Fixed large block not returning error based on row ID error being returned Version 2.1.11 02-March-2010 1. Changed download to use bind variables 2. Changed checkboxes and yes no to by multilingual 3. Changed downloader to use right to cell function 4. Put in multilingual date conversion. 5. Put in euro number decimal conversion Version 2.1.10 01-March-2010 1. Added in check for MSC ATP as r11.5.7 doesnt support this 2. updated geninvsupport for 11.5.7, fixed alias bug 3. Fixed issue with download and assembly form where current default organization is invalid causing array index issue. 4. Fixed issue with cost type not joining on the correct column Version 2.1.9 04-December-2009 1. Fixed bug where org access bind variable too long for 8i database 2. Added check for invalid organization to then automatically default to Version 2.1.8 04-November-2009 1. Reapplied InvGen, Gen modules, removing reference to mfg_lookups which caused r11.5.9 issues. 2. Fixed end of load messages bug 3. Changed how cancel messages works 4. Applied change so fields change color when then error before Oracle PL/SQL validation 5. Updated common modules 6. Fixed loading issues with incorrect load numbers. Set wizard to ignore accepted records but load everything else. 7. Added in cacheRow p_currentrow/revertrow to fix excel 2007 bug. Version 2.1.7 14-September-2009 1. Updated sign on tool bar lovs Version 2.1.6 22-July-2009 1. Removed POW button. 2. Fixed mandatory field bug 3. Changed Setup Sheet to new sheet with new URL Version 2.1.5 13-May-2009 1. Fixed issue with calls to old AWsheet etc in download and upload 2. Changed download module to show all alternates when item range is blank or item range entered. Version 2.1.4 01-April-2009 1. Fixed type mismatch issue when loading Version 2.1.3 10-March-2009 1. Fixed issue where resources wouldnt load. 2. Updated resource caching to work correctly, loading existing resources at time routing is returned (if it exists) Version 2.1.2 07-March-2009 1. Fixed issue with speed of returning resource SQL being slow 2. Added DFF button to Routing, Operation and Resource forms 3. Fixed bug in get next resource sequence ID where max value from db could be bigger than in S/S but S/S value taking precedence 4. Fixed toggle resources populating fields when no data in the line 5. Added set focus on columns when users zoom between forms Version 2.1.1 04-March-2009 1. Changed font and colour for form zooms to match Bom wizard 2. Removed tools -> references Ref Edit Control. Causing wizard to blow up on vb std commands Version 2.1.0 20-January-2009 1. Changed upload_revision variable to be within routing header details 2. Fixed upload trying to upload referenced operation columns which cant be modified. 3. Fixed revision design to not allow user specific revision if item revision doesnt exist or routing revision doesnt exist. 4. Updated Routing Header form to not default a revision when creating a new routing (Unless item revision exists) 5. Updated Routing Header form to use ItemInformation record type 6. Changed way Department and Resources are queried, now using enhanced caching to speed load times 7. Added toggle functionality to the wizard forms 8. Fixed issue with sysdate and decimal places using comma vs full stop. Version 2.0.2 24-December-2008 1. Updated Gensupport package to download dates with time in a generic format Version 2.0.1 27-October-2008 1. Updated XMLHTTP package Version 2.0.0 02-September-2008 1. Updated gensupport and invsupport modules 2. Added in new activation key functionality and modules Version 1.5.2 08-August-2008 1. updated invGenModule and frmUserProfile Version 1.5.1 11-June-2008 1. Bug in get_organization_id, i < myubound org info instead of i <=, missing last org off the list. Version 1.5.0 09-June-2008 1. Updated Invgensupport and mfgsupport modules 2. Incorporated record types for the assembly and the routing header all thru the wizard 3. Updated the set status column stuff. 4. Added New Operation Column 5. Changed OpResources form to handle other language lovs Version 1.4.2 06-June-2008 1. Fixed issue with cost_type download sql in frmcosttype Version 1.4.1 19-May-2008 1. Updated download to allow from row 10 instead of 11. 2. Changed mtl_system_items view back to _kfv as the other view was missing from some customer instances. Version 1.4.0 14-May-2008 1. Added right click mouse menu to wizard. 2. Updated wizard to use _vl tables where possible due to issue with multi lingual install 3. Updated MFG and Common modules from Bom wizard. 4. Added download to new sheet functionality 5. Added cost type changes to download costing information 6. Added download memory of previous downloads to the header form so the prev used header is passed as the default to the download form. 7. Fixed issue with download departments code. Version 1.3.1 06-May-2008 1. Fixed issue with common routings not working due to component validation. Version 1.3.0 01-May-2008 1. Added in cost details for the assembly 2. Added in cost rates for the resources Version 1.2.1 14-March-2008 1. Fixed issue with frmRoutingOperationsResource form updating the spreadsheet when cancelling. Version 1.2.0 14-March-2008 1. Added descriptive colomns for Assembly, Department and resource 2. Updated frmHeader, frmOperations and frmResources to update descriptive elements 3. Removed apps_initialize and combined it with cache_lov and renamed to post_login_process 4. Updated the way the wizard works with messages to use bom_lists instead of mtl_errormessages 5. Changed tool bars to only show DFF face buttons when the DFF exists. Version 1.1.9 02-March-2008 1. Updated MFGcommon, removed reference to oldxml package 2. Added additional translation message information. 3. Fixed issue where user uploads routing, then makes additional change where the date stamp of the initial load didnt include the time portion of the stamp. Updated exists_routing_operations to update the load variable with the date incl the time stamp from the database. 4. changed wizard to allow null in the effective date, which will then default to the upload date 5. Added in functionality to include loading the completion subinv and completion locator. Version 1.1.8 04-February-2008 1. Fixed issue where usage/rate at resource wouldnt accept zero. Version 1.1.7 19-January-2008 1. Build cascade functionality for exploder 2. Updated exploder to check bill of material for the routing alternate exists Version 1.1.6 19-January-2008 1. Update locator to not use CCID 2. Updated Gensupport to only bring back Bom or Rtg specific error messages Version 1.1.5 16-January-2008 1. fixed locator issue in routing header form 2. fixed writetocell issue in download 3. fixed download Attributes that were off by a factor of one ie attr 1 going to attr2 column Version 1.1.4 14-January-2008 1. Fixed issue with downloading not allowing alternate explosion Version 1.1.3 12-January-2008 1. Removed public macros 2. Stopped Excel asking for changes to be saved on exit when no changes made Version 1.1.2 11-January-2008 1. Licence Key validation on entry required upgrading Version 1.1.1 11-January-2008 1. Updated GenSupport for build proc and build rec to handle date value SYSDATE Version 1.1.0 29-December-2007 1. Moved toolbar code to its own module, created MFGsupport module for RTG and BOM common code. Moved more4apps generic stuff to GenSupport module. 2. Created Bom exploder to explode the components of the bom and downloading the routings for the assemblies downloaded. Version 1.0.11 13-December-22007 1. Updated form header and download KFF for items to show the item description in the LOV. 2. Updated error with standard rate and schedule resource where they were not uploading correctly. 3. Moved toolbar code to its own module Version 1.0.10 11-December-2007 1. Added in functionality to default download fields from previous downloads 2. Reinstated user defined required field functionality, removed in prevVersion. 3. Fixed bug with upload of Schedule Resource flag. Version 1.0.9 04-December-2007 1. Updated DFF and KFF modules 2. Fixed error with small block missing begin and end 3. Updated error where operation sequence data is not being reset Version 1.0.8 26-November-2007 1. Changed download form to change the implementation date when the revision changes. 2. Updated upload selected record to give the option to allow the user to upload without having to manually delete error messages. 3. Changed download assembly to only list items with a routing rather than all items 4. Fixed bug where operation and resource arrays were holding old data 5. Fixed exists_component where it was comparing value with null rather than default value for the field, when the field didnt have a value 6. Changed OrgInfo sql to check the org_access_view for security on inv organizations 7. Fixed code in operations form where referenced check box would not send data back to the form, when changing the operation code to null. 8. Changed operations form, so the department is viewable but not enterable if the operation code is entered. Since you cannot change depts with std ops. 9. Fixed download and header forms to return the current org_code to settings123 so you dont have to choose the org code each time. 10.Fixed issue where upload of resource was applying the resource to the wrong line. 11.Updated wizard to set ORGANIZATION_ID when running flexfield table based validation. Update done to supply mod_flex the default organization_id for KFF and DFF validation. 12.Got rid of l_default_org_id as it was causing confusion and not really required. 13.Fixed various errors in the way revisions and the current revision was working. 14.Changed SQL for standard operations to only include non process mfg std operation codes 15.Changed Download so when you download From - To it removes the revision. Version 1.0.7 07-November-2007 1. Changed the way revisions are downloaded 2. Fixed bug with header form not selecting current revision from spreadsheet 3. Changed download form to only allow assembly command button and assembly to details if the assembly field has been entered. Version 1.0.6 20-September-2007 1. Added in delete group and delete resource functionality 2. Reimported choose org after bug found in bom wizard with it 3. Moved Validate Operation to within Validate Routing, updated rejection error counter to be invoked when an error is found while doing the validation, not just when the pl/sql runs. 4. Changed resources form so resource change automatically defaults when the user changes the resource. Version 1.0.5 10-September-2007 1. Rebuilt revisions to use a combobox in the routing form. Version 1.0.4 21-August-2007 1. Fixed DFF forms to point to the correct tables. 2. Found code error when opening resources form causing type mismatch. 3. Updated revisions form to stop allowing the creation of revisions that already exists (ie exists for the future). Version 1.0.3 06-July-2007 1. Updated tool bar tip for toggling popup messages 2. Changed frmRevision to validate New revision to after update to allow multi character revisions 3. Fixed download revision string not being set correctly 4. Fixed Download of common to show correctly, with common option box for routing operations Version 1.0.2 20-June-2007 1. Added in toolbar option for login form type (SSO or normal) 2. Added download item from/to functionality Version 1.0.1 20-June-2007 1. Added in defaulting resource sequence when standard operation in use. 2. Fixed tab order issue with resource and operations form 3. Fixed DFF not downloading 4. Fixed cancel toolbar not cancelling load 5. Added toggle button to show/hide popup messages. 6. Created check in resources form to make sure the sequence number doesnt exist for a std operation already. 7. Fixed download resource not decoding value_id to meaning for basis 8. Fixed percentage offset not working correctly in resources form 9. Validate resources procedure was not being called. Included this. 10. Removed redundant code in resource form by using validate resource before opening the form, this catches generic problems before going to the database. 11. Fixed Error in UOM for resources shows OSP value instead of UOM Version 1.0.0 Initial Version