Changed the message for ENRO_PRTY_FK. This was being thrown when attempting to delete a party associated with an enquiry.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3870 248e525c-4dfb-0310-94bc-949c084e9493
Add processing to make it clearer which application build has been produced and to link the schema with the correct application (AssociateSchema.sql, SetSubstitution.sql, bulk_load.sql and InstallMIP.cmd)
Changes to schema: METERS now have 'MESC_CODE'. Associated changes in the bulk_load routines and initial changes to mip_quotation.pck (needs confirmation testing).
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3830 248e525c-4dfb-0310-94bc-949c084e9493
Changes to constraint messages in comsg.ctl.
Attempt to associate the new schema with the workspace in AssociateSchema.sql.
Change schema contract sizes to 35 characters
Add a DEBUG parameter to the Ruby constants.rb
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3759 248e525c-4dfb-0310-94bc-949c084e9493
Amend Qmax values defined within MESC.ctl
Fix bulk_load errors related to loading drawings through MIP_FILES
Amend mip_quotation to produce labour costs where meter size or service pressure is not a cost constraint.
Amend mip_quotation email messages.
Perform additional compilations during install to account for dependency links.
Make meter dimensions optional (mip.tab)
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3721 248e525c-4dfb-0310-94bc-949c084e9493
Add constraint to regi_enqu_exclusions to prevent both enquiry and additional items being recorded on the same row.
Allow schema to be passed to apex_auto_install.rb.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3666 248e525c-4dfb-0310-94bc-949c084e9493
Changed additional_items.lead_time to number field.
Removed 'WORKSPACE_IMAGE' references from NG theme.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3637 248e525c-4dfb-0310-94bc-949c084e9493
Modified mip_bulk_load.pck to convert '"' to 'inch' in meter size codes imported from LABOUR_COSTS.csv.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3527 248e525c-4dfb-0310-94bc-949c084e9493
Add tripartite_agreement_message to mip_quotation.pck (supported by mip_tripartite.pck). Produces a message when enquiry does not meet tripartite requirements.
Removed extraneous role types for Seed/prtp.ctl and Seed/rt.ctl.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3497 248e525c-4dfb-0310-94bc-949c084e9493
Data/Seed and Data/Test: Correction to apau.ctl to remove duplicates.
Modules/compile.sql: Correction to 'report' query.
Schema/ext...: Check whether external tables have been defined before attempting to drop them.
Schema/v_...: Force creation of views that rely on PL/SQL code. Explicitly name the column returned by V_QUOTE_DETAILS.vw so that the comments can be applied.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3452 248e525c-4dfb-0310-94bc-949c084e9493
New and amended ERDs.
Schema
Added support for documents.
Added modules to costs.
Data
Added document role types.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2983 248e525c-4dfb-0310-94bc-949c084e9493
Massaged the test data so that some base users get added to the test schema, duplicated the seed party data upload so that the Advantica user still exists
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2897 248e525c-4dfb-0310-94bc-949c084e9493
Replaced Access_Controls with APEX_AUTHORISATION
Created POSTCODES, ERROR_LOGS and SYSTEM_CONFIGURATION.
Added missing columns to ENQUIRIES, REGULATORS, etc.
Added views V_PROFILE_RT_CODE_FOR_ENRO.vw, V_PARTY_RELATIONSHIPS.vw, V_LATEST_RT_CODE_FOR_ENRO.vw.
Modules:
Added cout_err.pck, cout_system_configuration.pck.
Data:
Added Data/Demo files
Added Data/Seed files for postcodes, regions and DatabaseItemToFunctionalSpecificationReference.csv
Documentation:
Added Documentation/pldoc for plsqldoc-generated files.
Added Documentation/SupportingDocumentation/Regions to hold region definition information.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2890 248e525c-4dfb-0310-94bc-949c084e9493
