Changeset 20528

Timestamp:

03/04/10 08:40:10 (5 months ago)

Author:

nilesh

Message:

data base changes for adding new property in schedule column.
changes in schedule procedure for storing plan.
related changes in other procedure.
and adding some new tokens.

Files:

• trunk/core/db/oracle/create-scripts/versions/9.2.0/packages/methodology.bdy (modified) (1 diff)
• trunk/core/db/oracle/create-scripts/versions/9.2.0/packages/project.bdy (modified) (1 diff)
• trunk/core/db/oracle/create-scripts/versions/9.2.0/packages/schedule.bdy (modified) (4 diffs)
• trunk/core/db/oracle/create-scripts/versions/9.2.0/packages/schedule.spc (modified) (1 diff)
• trunk/core/db/oracle/create-scripts/versions/9.2.0/tables/alter_pn_plan.sql (modified) (1 diff)
• trunk/core/db/oracle/create-scripts/versions/9.2.0/update_system_properties.sql (modified) (1 diff)

trunk/core/db/oracle/create-scripts/versions/9.2.0/packages/methodology.bdy

@@ -388 +388 @@
-
-    /* ------------------ Schedule ----------------------- */
-
+1, 0, 8, 40, 20, 'PERSONAL', 
-
-

trunk/core/db/oracle/create-scripts/versions/9.2.0/packages/project.bdy

@@ -757 +757 @@
-    -- added by Robin 18-Apr-00
-    -- add plan default
-
+8, 40, 20, 'PERSONAL', 
-
-    if (p_create_share > 0) then

trunk/core/db/oracle/create-scripts/versions/9.2.0/packages/schedule.bdy

@@ -439 +439 @@
-    i_inline_editing_warning IN NUMBER,
-    i_un_assigned_workcapture IN NUMBER,
+    i_hours_per_day IN NUMBER,
+    i_hours_per_week IN NUMBER,
+    i_days_per_month IN NUMBER,
+    i_resource_calendar IN VARCHAR2,
-    io_plan_id IN OUT NUMBER
-)
@@ -476 +480 @@
-           baseline_start, baseline_end, modified_by, modified_date, default_task_calc_type_id,
-           earliest_start_date, earliest_finish_date, latest_start_date, latest_finish_date,
-
+
+
-        values
-          (io_plan_id, i_name, i_description, i_start_date, i_end_date,
@@ -483 +488 @@
-           i_earliest_start_date, i_earliest_finish_date, i_latest_start_date,
-           i_latest_finish_date, i_start_constraint_type, i_start_constraint_date,
-
+
+
-
-        insert into pn_space_has_plan
@@ -543 +549 @@
-          constraint_type_id = i_start_constraint_type,
-          constraint_date = i_start_constraint_date,
-
-
+
+
+
+
+
+
-        where
-          plan_id = io_plan_id;

trunk/core/db/oracle/create-scripts/versions/9.2.0/packages/schedule.spc

@@ -210 +210 @@
-    i_inline_editing_warning IN NUMBER,
-    i_un_assigned_workcapture IN NUMBER,
+    i_hours_per_day IN NUMBER,
+    i_hours_per_week IN NUMBER,
+    i_days_per_month IN NUMBER,
+    i_resource_calendar IN VARCHAR2,
-    io_plan_id IN OUT NUMBER
-);

trunk/core/db/oracle/create-scripts/versions/9.2.0/tables/alter_pn_plan.sql

@@ -23 +23 @@
-ADD (UN_ASSIGNED_WORKCAPTURE NUMBER(1,0) DEFAULT 0)
-/
+
+-- Alter table PN_PLAN to add HOURS_PER_DAY column
+ALTER TABLE PN_PLAN
+ADD (HOURS_PER_DAY NUMBER DEFAULT 8)
+/
+
+-- Alter table PN_PLAN to add HOURS_PER_WEEK column
+ALTER TABLE PN_PLAN
+ADD (HOURS_PER_WEEK NUMBER DEFAULT 40)
+/
+
+-- Alter table PN_PLAN to add DAYS_PER_MONTH column
+ALTER TABLE PN_PLAN
+ADD (DAYS_PER_MONTH NUMBER DEFAULT 20)
+/
+
+-- Alter table PN_PLAN to add RESOURCE_CALENDAR column
+ALTER TABLE PN_PLAN
+ADD (RESOURCE_CALENDAR VARCHAR2(50) DEFAULT 'PERSONAL')
+/

trunk/core/db/oracle/create-scripts/versions/9.2.0/update_system_properties.sql

@@ -1378 +1378 @@
-      p.property = 'prm.template.main.managetemplates.heading';
-      
+
+insert into PN_PROPERTY (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB)
+values (2000, 'en', 'text', 'prm.schedule.properties.hoursperday.mumericrequired.message', 'Hours Per Day should not be empty or non numeric value.', 'A', 0, 1, null);
+
+insert into PN_PROPERTY (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB)
+values (2000, 'en', 'text', 'prm.schedule.properties.hoursperweek.mumericrequired.message', 'Hours Per Week should not be empty or non numeric value.', 'A', 0, 1, null);
+
+insert into PN_PROPERTY (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB)
+values (2000, 'en', 'text', 'prm.schedule.properties.dayspermonth.mumericrequired.message', 'Days Per Month should not be empty or non numeric value.', 'A', 0, 1, null);
+
+insert into PN_PROPERTY (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB)
+values (2000, 'en', 'text', 'prm.schedule.properties.hoursperday.range.message', 'Hours Per Day value should be in range 0 to 24.', 'A', 0, 1, null);
+
+insert into PN_PROPERTY (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB)
+values (2000, 'en', 'text', 'prm.schedule.properties.hoursperweek.range.message', 'Hours Per Week value should be in range 0 to 168.', 'A', 0, 1, null);
+
+insert into PN_PROPERTY (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB)
+values (2000, 'en', 'text', 'prm.schedule.properties.daysspermonth.range.message', 'Days Per Month value should be in range 0 to 30', 'A', 0, 1, null);
+
+insert into PN_PROPERTY (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB)
+values (2000, 'en', 'text', 'prm.schedule.properties.workingtimes.required.message', 'Working Times values should not be empty.', 'A', 0, 1, null);
+
+insert into PN_PROPERTY (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB)
+values (2000, 'en', 'text', 'prm.schedule.properties.hoursperday.label', 'Hours Per Day:', 'A', 0, 1, null);
+
+insert into PN_PROPERTY (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB)
+values (2000, 'en', 'text', 'prm.schedule.properties.hoursperweek.label', 'Hours Per Week:', 'A', 0, 1, null);
+
+insert into PN_PROPERTY (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB)
+values (2000, 'en', 'text', 'prm.schedule.properties.dayspermonth.label', 'Days Per Month:', 'A', 0, 1, null);
+
+insert into PN_PROPERTY (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB)
+values (2000, 'en', 'text', 'prm.schedule.properties.workingtimes.channltitle', 'Working Times', 'A', 0, 1, null);
+
+insert into PN_PROPERTY (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB)
+values (2000, 'en', 'text', 'prm.schedule.properties.resourcecalendar.label', 'For Task Assignment Calculation:', 'A', 0, 1, null);
+
+insert into PN_PROPERTY (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB)
+values (2000, 'en', 'text', 'prm.schedule.properties.resourcecalendar.personaloption.label', 'Use resource personal working time calendar.', 'A', 0, 1, null);
+
+insert into PN_PROPERTY (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB)
+values (2000, 'en', 'text', 'prm.schedule.properties.resourcecalendar.scheduleoption.label', 'Use resource schedule working time calendar.', 'A', 0, 1, null);
+
-update pn_property p set
-          p.property_value = 'Templates'