Changeset 17921

Show
Ignore:
Timestamp:
08/20/08 16:55:59 (3 months ago)
Author:
puno
Message:

assignor id changes are applied to 8.5.0 update.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/core/db/oracle/create-scripts/versions/8.5.0/new/packages/schedule.bdy

    r17792 r17921  
    554554    i_modified_by in NUMBER, 
    555555    i_record_status IN VARCHAR2, 
    556     i_assignor_id IN NUMBER, 
    557556    o_status OUT NUMBER 
    558557) 
    …… 
    604603 
    605604        INSERT INTO pn_assignment 
    606             (space_id, person_id, assignor_id, object_id, status_id, percent_allocated, role, 
     605            (space_id, person_id, object_id, status_id, percent_allocated, role, 
    607606             is_primary_owner, start_date, end_date, actual_start, actual_finish, 
    608607             estimated_finish, work, work_units, work_complete, 
    …… 
    610609             modified_date, record_status, date_created) 
    611610          VALUES 
    612             (i_space_id, i_person_id, i_assignor_id, i_object_id, i_status_id, i_percent, i_role, 
     611            (i_space_id, i_person_id, i_object_id, i_status_id, i_percent, i_role, 
    613612            i_primary_owner, i_start_date, i_end_date, i_actual_start, 
    614613            i_actual_finish, i_estimated_finish, i_work, i_work_units, 
    …… 
    639638                  modified_by = i_modified_by, 
    640639                  modified_date = SYSDATE, 
    641                   record_status = i_record_status, 
    642                   assignor_id = i_assignor_id 
     640                  record_status = i_record_status 
    643641              WHERE space_id = i_space_id 
    644642                AND person_id = i_person_id 

  • trunk/core/db/oracle/create-scripts/versions/8.5.0/new/packages/schedule.spc

    r17792 r17921  
    3333    i_modified_by in NUMBER, 
    3434    i_record_status IN VARCHAR2, 
    35     i_assignor_id IN NUMBER, 
    3635    o_status OUT NUMBER 
    3736); 

  • trunk/core/db/oracle/create-scripts/versions/8.5.0/new/tables/tables.sql

    r17792 r17921  
    518518  ACTUAL_START        DATE, 
    519519  ACTUAL_FINISH       DATE, 
    520   ESTIMATED_FINISH    DATE, 
    521   ASSIGNOR_ID           NUMBER(20) 
     520  ESTIMATED_FINISH    DATE 
     521--  ASSIGNOR_ID         NUMBER(20) 
    522522) 
    523523; 
    …… 
    533533  add constraint RECORD_STATUS_VALID54 
    534534  check (record_status in ('A','P','D','H')); 
    535 ALTER TABLE PN_ASSIGNMENT 
    536   ADD CONSTRAINT ASSIGNMENT_FK3 FOREIGN KEY (ASSIGNOR_ID) 
    537   REFERENCES PN_PERSON (PERSON_ID); 
    538 CREATE INDEX ASSIGNMENT_IDX5 ON PN_ASSIGNMENT (ASSIGNOR_ID)  TABLESPACE INDEX01;   
     535-- ALTER TABLE PN_ASSIGNMENT 
     536--  ADD CONSTRAINT ASSIGNMENT_FK3 FOREIGN KEY (ASSIGNOR_ID) 
     537--  REFERENCES PN_PERSON (PERSON_ID); 
     538-- CREATE INDEX ASSIGNMENT_IDX5 ON PN_ASSIGNMENT (ASSIGNOR_ID)  TABLESPACE INDEX01;   
    539539create index ASSIGNMENT_IDX1 on PN_ASSIGNMENT (OBJECT_ID) TABLESPACE INDEX01; 
    540540create index ASSIGNMENT_IDX2 on PN_ASSIGNMENT (PERSON_ID) TABLESPACE INDEX01; 

  • trunk/core/db/oracle/create-scripts/versions/8.5.0/prm_db_patch_8.5.0.sql

    r17919 r17921  
    1717 
    1818PROMPT ================================================================================ 
    19 PROMPT == Apply Changes 
     19PROMPT == Tables 
    2020PROMPT ================================================================================ 
     21 
     22PROMPT Altering PN_ASSIGNMENT table 
     23@versions/8.5.0/tables/alter_pn_assignment.sql 
     24COMMIT; 
     25 
    2126 
    2227