UPDATE epct_turbine_schedule
SET --TURBINE_STATUS = upper(SCH(i).P_TURBINE_STATUS),
 planned_turbine_start_date = To_date(Sch(i),'mm/dd/yyyy'),
       actual_turbine_start_date = To_date(Sch(i),'mm/dd/yyyy'),
       planned_turbine_finish_date = To_date(Sch(i),'mm/dd/yyyy'),
       actual_turbine_finish_date = To_date(Sch(i),'mm/dd/yyyy'),
       last_updated_by = Sch(i),
       last_updation_date = SYSDATE,
       pole_id = p_pole_id,
       country_id = p_country_id,
       customer_id = p_wmf_customer_seq_id,
       service_area = Upper(p_service_area),
       sam = Sch(i),
       code = Sch(i),
       type_value = p_type,
       user1 = Sch(i),
       user2 = Sch(i),
       user3 = Sch(i),
       user4 = Sch(i),
       user5 = Sch(i),
       lat = p_lat,
       cpt = p_cpt,
       pct = Sch(i),
       project_ips_cms_seq_id = p_wmf_project_ips_cms_seq_id
WHERE  Upper(scope_id) = Upper(Sch(i))
       AND turbine_serial_number = Sch(i)AND Upper(logical_delete_flag) = 'N'; 

SELECT COUNT (*)
				INTO P_TURBINE_COUNT
				FROM EPCT_TURBINE_SCHEDULE
				WHERE SCOPE_ID = SCH(i).P_SCOPE_ID
				AND TURBINE_SERIAL_NUMBER = SCH(i).P_TURBINE_SERIAL_NUMBER
				AND TO_DATE (PLANNED_TURBINE_START_DATE, 'mm/dd/yyyy') = TO_DATE (SCH(i).P_PLANNED_TURBINE_START_DATE, 'mm/dd/yyyy')
				AND TO_DATE (ACTUAL_TURBINE_START_DATE, 'mm/dd/yyyy') = TO_DATE (SCH(i).P_ACTUAL_TURBINE_START_DATE, 'mm/dd/yyyy')
				AND TO_DATE (PLANNED_TURBINE_FINISH_DATE, 'mm/dd/yyyy') = TO_DATE (SCH(i).P_PLANNED_TURBINE_FINISH_DATE, 'mm/dd/yyyy')
				AND TO_DATE (ACTUAL_TURBINE_FINISH_DATE, 'mm/dd/yyyy') = TO_DATE (SCH(i).P_ACTUAL_TURBINE_FINISH_DATE, 'mm/dd/yyyy')
				AND CODE = SCH(i).P_CODE
				AND PCT = SCH(i).P_PCT
				AND SAM = SCH(i).P_SAM
				AND USER1 = SCH(i).P_USER1
				AND USER2 = SCH(i).P_USER2
				AND	USER3 = SCH(i).P_USER3
				AND	USER4 = SCH(i).P_USER4
				AND	USER5 = SCH(i).P_USER5
				AND LOGICAL_DELETE_FLAG = 'N';
If (P_TURBINE_COUNT>0) then 

UPDATE EPCT_TURBINE_SCHEDULE
SET 
PLANNED_TURBINE_START_DATE =TO_DATE(SCHi).P_PLANNED_TURBINE_START_DATE, 'mm/dd/yyyy'),
ACTUAL_TURBINE_START_DATE =TO_DATE (SCH(i).P_ACTUAL_TURBINE_START_DATE, 'mm/dd/yyyy'),
PLANNED_TURBINE_FINISH_DATE =TO_DATE (SCH(i).P_PLANNED_TURBINE_FINISH_DATE, 'mm/dd/yyyy'),
ACTUAL_TURBINE_FINISH_DATE =TO_DATE (SCH(i).P_ACTUAL_TURBINE_FINISH_DATE, 'mm/dd/yyyy'),
LAST_UPDATED_BY = SCH(i).P_UPDATED_BY,
LAST_UPDATION_DATE = SYSDATE,
POLE_ID = P_POLE_ID,
COUNTRY_ID = P_COUNTRY_ID,
CUSTOMER_ID = P_WMF_CUSTOMER_SEQ_ID,
SERVICE_AREA = upper(P_SERVICE_AREA),
SAM = SCH(i).P_SAM,
CODE = SCH(i).P_CODE,
TYPE_VALUE =P_TYPE,
USER1 = SCH(i).P_USER1,
USER2 = SCH(i).P_USER2,
USER3 = SCH(i).P_USER3,
USER4 = SCH(i).P_USER4,
USER5 = SCH(i).P_USER5,
LAT = P_LAT,
CPT  =  P_CPT,
PCT = SCH(i).P_PCT,
PROJECT_IPS_CMS_SEQ_ID = P_WMF_PROJECT_IPS_CMS_SEQ_ID
  WHERE SCOPE_ID= SCH(i).P_SCOPE_ID AND 
        TURBINE_SERIAL_NUMBER = SCH(i).P_TURBINE_SERIAL_NUMBER  
        AND LOGICAL_DELETE_FLAG= 'N';
end if;

CREATE TABLE EPCT_TURBINE_SCHEDULE
(
  SCOPE_ID                     VARCHAR2(10 BYTE),
  POLE_ID                      NUMBER(10),
  COUNTRY_ID                   NUMBER(10),
  CUSTOMER_ID                  NUMBER(10),
  SERVICE_AREA                 VARCHAR2(60 BYTE),
  SITE_ID                      NUMBER(10),
  TURBINE_SERIAL_NUMBER        VARCHAR2(30 BYTE),
  TURBINE_TYPE                 VARCHAR2(20 BYTE),
  ACTUAL_TURBINE_FINISH_DATE   DATE,
  ACTUAL_TURBINE_START_DATE    DATE,
  TURBINE_STATUS               VARCHAR2(20 BYTE),
  TURBINE_DOWN_TIME            VARCHAR2(20 BYTE),
  LOGICAL_DELETE_FLAG          CHAR(1 BYTE)     NOT NULL,
  CREATED_BY                   NUMBER(10)       NOT NULL,
  CREATION_DATE                DATE             DEFAULT SYSDATE               NOT NULL,
  LAST_UPDATED_BY              NUMBER(10)       NOT NULL,
  LAST_UPDATION_DATE           DATE             DEFAULT SYSDATE               NOT NULL,
  PLANNED_TURBINE_START_DATE   DATE,
  PLANNED_TURBINE_FINISH_DATE  DATE,
  SCHEDULE_TYPE_ID             NUMBER(5),
  SCHEDULE_RESPONSE_ID         NUMBER(5),
  SAM                          VARCHAR2(100 BYTE),
  CODE                         NUMBER(5),
  USER1                        VARCHAR2(100 BYTE),
  USER2                        VARCHAR2(100 BYTE),
  USER3                        VARCHAR2(100 BYTE),
  USER4                        VARCHAR2(100 BYTE),
  USER5                        VARCHAR2(100 BYTE),
  LAT                          NUMBER(5),
  CPT                          NUMBER(5),
  PCT                          NUMBER(5),
  PROJECT_IPS_CMS_SEQ_ID       NUMBER(10),
  TYPE_VALUE                   VARCHAR2(50 BYTE)
)
TABLESPACE EPIC_TABLES
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MINEXTENTS       1
            MAXEXTENTS       2147483645
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE INDEX TURBINE_SCHEDULE_INDEX ON EPCT_TURBINE_SCHEDULE
(TURBINE_SERIAL_NUMBER, SCOPE_ID, LOGICAL_DELETE_FLAG)
LOGGING
TABLESPACE EPIC_INDEXES
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MINEXTENTS       1
            MAXEXTENTS       2147483645
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;


ALTER TABLE EPCT_TURBINE_SCHEDULE ADD (
  CONSTRAINT EPCT_TURBINE_SCHEDULE_R01 
 FOREIGN KEY (SCOPE_ID) 
 REFERENCES EPCT_TOP_ISSUE_SCOPE_MAP (SCOPE_ID));

bcm@bcm-laptop:~$ tkprof
Usage: tkprof tracefile outputfile [explain= ] [table= ]
              [print= ] [insert= ] [sys= ] [sort= ]
  table=schema.tablename   Use 'schema.tablename' with 'explain=' option.
  explain=user/password    Connect to ORACLE and issue EXPLAIN PLAN.
  print=integer    List only the first 'integer' SQL statements.
  aggregate=yes|no
  insert=filename  List SQL statements and data inside INSERT statements.
  sys=no           TKPROF does not list SQL statements run as user SYS.
  record=filename  Record non-recursive statements found in the trace file.
  waits=yes|no     Record summary for any wait events found in the trace file.
  sort=option      Set of zero or more of the following sort options:
    prscnt  number of times parse was called
    prscpu  cpu time parsing
    prsela  elapsed time parsing
    prsdsk  number of disk reads during parse
    prsqry  number of buffers for consistent read during parse
    prscu   number of buffers for current read during parse
    prsmis  number of misses in library cache during parse
    execnt  number of execute was called
    execpu  cpu time spent executing
    exeela  elapsed time executing
    exedsk  number of disk reads during execute
    exeqry  number of buffers for consistent read during execute
    execu   number of buffers for current read during execute
    exerow  number of rows processed during execute
    exemis  number of library cache misses during execute
    fchcnt  number of times fetch was called
    fchcpu  cpu time spent fetching
    fchela  elapsed time fetching
    fchdsk  number of disk reads during fetch
    fchqry  number of buffers for consistent read during fetch
    fchcu   number of buffers for current read during fetch
    fchrow  number of rows fetched
    userid  userid of user that parsed the cursor