11 Commits

Author SHA1 Message Date
PriestJ
8466a74378 Added control file for exception messages as they were not getting added to the build.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3727 248e525c-4dfb-0310-94bc-949c084e9493
2008-02-27 10:52:14 +00:00
hardya
2b3d0c909c Added support for 'friendly' database constraint messages.
Changed SUPP role type description following training session.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3628 248e525c-4dfb-0310-94bc-949c084e9493
2008-02-19 11:30:44 +00:00
hardya
68f300c2ca Fixes made for #102, #103, #49, #108
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3504 248e525c-4dfb-0310-94bc-949c084e9493
2008-02-08 16:23:12 +00:00
PriestJ
f9672916f0 ah made changes to build scripts to fix a few errors
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3416 248e525c-4dfb-0310-94bc-949c084e9493
2008-01-29 13:11:12 +00:00
hardya
13c9c0ca97 Changes made to support Bulk Load.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3255 248e525c-4dfb-0310-94bc-949c084e9493
2008-01-15 18:45:58 +00:00
hardya
812592d3b1 Added syco.ctl to populate the system_configuration table.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3011 248e525c-4dfb-0310-94bc-949c084e9493
2007-12-18 10:10:39 +00:00
PriestJ
4e275aa855 Altered install scripts to add a base user in the seed data. Also altered install script to correctly accept a 6th parameter. Edited mip_security.authorize so that if no data is returned the system returns false.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2894 248e525c-4dfb-0310-94bc-949c084e9493
2007-11-27 18:39:27 +00:00
hardya
cb7b890a92 Data:
Replace multiple Data/Seed 'role_types' files with Data/Seed/rt.ctl

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2892 248e525c-4dfb-0310-94bc-949c084e9493
2007-11-27 15:26:44 +00:00
hardya
2920f4d016 Scheme Changes:
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
2007-11-27 11:48:13 +00:00
hardya
010740d3ce Added table BYPASS_REASONS
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2850 248e525c-4dfb-0310-94bc-949c084e9493
2007-11-13 15:24:20 +00:00
hardya
f5e160010b New tables:
PASSWORDS - holds history of passwords for parties
 ACCESS_CONTROLS - hold page, item / role information for authorization purposes.

Modified tables:
 ENQUIRIES - meter size removed. Replaced by foreign key to METER_SIZE_CODES.
 COSTS - includes AICO_CODE and DESCRIPTION for use as cost details for Additional Items.

General modifications:
 Yes/No columns modified to VARCHAR2(3)

Modules:
 Added mip_security.pck. Supports Authentication and Authorization (update of the original POC version)

Respository:
 Created new directory structure to hold persistent data. Currently includes Data/Seed for base table values and Data/Demo to populate various party and relationship tables.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2838 248e525c-4dfb-0310-94bc-949c084e9493
2007-11-12 12:07:25 +00:00