Changeset 20553

Show
Ignore:
Timestamp:
03/09/10 00:54:20 (5 months ago)
Author:
ritesh
Message:

- changes for adding new tokens.
- and UI related changes

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • trunk/core/db/oracle/create-scripts/versions/9.2.0/update_system_properties.sql

    r20533 r20553  
    13291329values (2000, 'en', 'text', 'prm.schedule.taskedit.warning.warning.title', 'Workplan Warning', 'A', 0, 1, null); 
    13301330 
     1331insert into pn_property (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB) 
     1332values (2000, 'en', 'text', 'prm.business.setup.chargecode.link', 'Manage Charge Codes', 'A', 0, 1, null); 
     1333 
    13311334insert into PN_PROPERTY (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB) 
    13321335values (2000, 'en', 'text', 'prm.schedule.properties.inlineeditwarning.label', 'Enable inline editing warning message', 'A', 0, 1, null); 
     1336 
     1337insert into pn_property (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB) 
     1338values (2000, 'en', 'text', 'prm.business.setup.chargecode.label', 'Create, edit or delete charge codes for this business', 'A', 0, 1, null); 
    13331339 
    13341340insert into PN_PROPERTY (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB) 
     
    14311437values (2000, 'en', 'text', 'prm.schedule.workingtimecalendar.defaultbase.name', '{0} Base Calendar', 'A', 0, 1, null); 
    14321438       
     1439insert into pn_property (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB) 
     1440values (2000, 'en', 'text', 'prm.business.chargecode.leftheader.viewchargecode.label', 'View Charge Codes', 'A', 0, 1, null); 
     1441 
     1442insert into pn_property (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB) 
     1443values (2000, 'en', 'text', 'prm.business.chargecode.create.button.label', 'New Charge Code', 'A', 0, 1, null); 
     1444 
     1445insert into pn_property (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB) 
     1446values (2000, 'en', 'text', 'prm.business.chargecode.modify.button.label', 'Edit Charge Code', 'A', 0, 1, null); 
     1447 
     1448insert into pn_property (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB) 
     1449values (2000, 'en', 'text', 'prm.business.chargecode.delete.button.label', 'Delete Charge Code', 'A', 0, 1, null); 
     1450 
     1451insert into pn_property (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB) 
     1452values (2000, 'en', 'text', 'prm.business.chargecode.chargecodetable.header.chargecodeno.label', 'Charge Code no.', 'A', 0, 1, null); 
     1453 
     1454insert into pn_property (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB) 
     1455values (2000, 'en', 'text', 'prm.business.chargecode.chargecodetable.header.chargecodename.label', 'Charge Code Name', 'A', 0, 1, null); 
     1456 
     1457insert into pn_property (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB) 
     1458values (2000, 'en', 'text', 'prm.business.chargecode.chargecodetable.header.chargecodedescription.label', 'Charge Code Description', 'A', 0, 1, null); 
     1459 
     1460insert into pn_property (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB) 
     1461values (2000, 'en', 'text', 'prm.business.chargecode.save.page.title', 'Save Charge Code', 'A', 0, 1, null); 
     1462 
     1463insert into pn_property (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB) 
     1464values (2000, 'en', 'text', 'prm.business.chargecode.edit.page.title', 'Edit Charge Code', 'A', 0, 1, null); 
     1465 
     1466insert into pn_property (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB) 
     1467values (2000, 'en', 'text', 'all.global.popup.button.submit.caption', 'Submit', 'A', 0, 1, null); 
     1468 
     1469insert into pn_property (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB) 
     1470values (2000, 'en', 'text', 'all.global.popup.button.cancle.caption', 'Cancel', 'A', 0, 1, null); 
     1471 
     1472insert into pn_property (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB) 
     1473values (2000, 'en', 'text', 'prm.business.chargecode.label', 'Charge Code', 'A', 0, 1, null); 
     1474 
     1475insert into pn_property (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB) 
     1476values (2000, 'en', 'text', 'prm.schedule.list.chargecode.column', 'Charge Code', 'A', 0, 1, null); 
     1477 
     1478insert into pn_property (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB) 
     1479values (2000, 'en', 'text', 'prm.business.chargecode.dropdownlist.defaultoption.label', 'none', 'A', 0, 1, null); 
     1480 
    14331481prompt Enabling foreign key constraints for PN_PROPERTY... 
    14341482alter table PN_PROPERTY enable constraint PN_PROPERTY_FK2;