Added line: 5194
+- Input[@CanonicalImage = null, @ExcludedLinesCount = 0, @ExcludedRangesCount = 0]
      +- ObjectNameDeclaration[@CanonicalImage = "UPDATE_PLANNED_HRS", @Image = "update_planned_hrs"]
      |  +- ID[@CanonicalImage = "UPDATE_PLANNED_HRS", @Image = "update_planned_hrs"]
Added line: 9913
      +- DeclarativeSection[@CanonicalImage = null]
Added line: 8888
      |  |  +- ProgramUnit[@CanonicalImage = null, @MethodName = "set_new_planned", @Name = "set_new_planned", @ObjectName = null]
      |  |     +- MethodDeclarator[@CanonicalImage = "SET_NEW_PLANNED", @Image = "set_new_planned", @ParameterCount = 1]
      |  |     |  +- ObjectNameDeclaration[@CanonicalImage = "SET_NEW_PLANNED", @Image = "set_new_planned"]
      |  |     |  |  +- ID[@CanonicalImage = "SET_NEW_PLANNED", @Image = "set_new_planned"]
Added line: 501
Added line: 436
      |  |     |  +- FormalParameters[@CanonicalImage = "(P_EMP_ID,P_PROJECT_ID,P_HOURS)", @Image = "(p_emp_id,p_project_id,p_hours)"]
Added line: 6195
      |  |     |     +- FormalParameter[@CanonicalImage = "P_EMP_ID", @Image = "p_emp_id", @In = true, @NoCopy = false, @Out = false]
      |  |     |     |  +- ID[@CanonicalImage = "P_EMP_ID", @Image = "p_emp_id"]
      |  |     |     |  +- Datatype[@CanonicalImage = "NUMBER", @Image = "NUMBER", @TypeImage = "NUMBER"]
Added line: 7942
Added line: 1566
Added line: 8490
      |  |     |     |     +- ScalarDataTypeName[@CanonicalImage = "NUMBER", @Image = "NUMBER"]
Added line: 8812
      |  |     |     +- FormalParameter[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id", @In = true, @NoCopy = false, @Out = false]
Added line: 7424
Added line: 1789
      |  |     |     |  +- ID[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id"]
      |  |     |     |  +- Datatype[@CanonicalImage = "NUMBER", @Image = "NUMBER", @TypeImage = "NUMBER"]
      |  |     |     |     +- ScalarDataTypeName[@CanonicalImage = "NUMBER", @Image = "NUMBER"]
Added line: 2254
      |  |     |     +- FormalParameter[@CanonicalImage = "P_HOURS", @Image = "p_hours", @In = true, @NoCopy = false, @Out = false]
      |  |     |        +- ID[@CanonicalImage = "P_HOURS", @Image = "p_hours"]
      |  |     |        +- Datatype[@CanonicalImage = "NUMBER", @Image = "NUMBER", @TypeImage = "NUMBER"]
      |  |     |           +- ScalarDataTypeName[@CanonicalImage = "NUMBER", @Image = "NUMBER"]
      |  |     +- Statement[@CanonicalImage = null]
      |  |     |  +- UnlabelledStatement[@CanonicalImage = null]
Added line: 6048
      |  |     |     +- UpdateStatement[@CanonicalImage = null]
Added line: 9471
Added line: 5110
      |  |     |        +- DMLTableExpressionClause[@CanonicalImage = null]
      |  |     |        |  +- TableName[@CanonicalImage = "EMPLOYEE_ON_ACTIVITY", @Image = "employee_on_activity"]
      |  |     |        |     +- ID[@CanonicalImage = "EMPLOYEE_ON_ACTIVITY", @Image = "employee_on_activity"]
      |  |     |        +- TableAlias[@CanonicalImage = "EA", @Image = "ea"]
      |  |     |        |  +- ID[@CanonicalImage = "EA", @Image = "ea"]
      |  |     |        +- UpdateSetClause[@CanonicalImage = null]
Added line: 2094
Added line: 644
      |  |     |        |  +- TableName[@CanonicalImage = "EA", @Image = "ea"]
      |  |     |        |  |  +- ID[@CanonicalImage = "EA", @Image = "ea"]
      |  |     |        |  +- Column[@CanonicalImage = "EA_PLANNED_HOURS", @Image = "ea_planned_hours"]
      |  |     |        |  |  +- ID[@CanonicalImage = "EA_PLANNED_HOURS", @Image = "ea_planned_hours"]
      |  |     |        |     +- PrimaryPrefix[@CanonicalImage = "P_HOURS", @Image = "p_hours", @SelfModifier = false]
      |  |     |        |        +- SimpleExpression[@CanonicalImage = "P_HOURS", @Image = "p_hours"]
Added line: 737
Added line: 9687
      |  |     |        |           +- Column[@CanonicalImage = "P_HOURS", @Image = "p_hours"]
      |  |     |        |              +- ID[@CanonicalImage = "P_HOURS", @Image = "p_hours"]
Added line: 1712
Added line: 1261
Added line: 625
      |  |     |           +- Condition[@CanonicalImage = null]
      |  |     |              +- CompoundCondition[@CanonicalImage = null, @Type = "AND"]
      |  |     |                 +- ComparisonCondition[@CanonicalImage = null, @Operator = "="]
Added line: 9136
      |  |     |                 |  +- SqlExpression[@CanonicalImage = "EA.EA_EMP_ID", @Image = "ea.ea_emp_id"]
      |  |     |                 |  |  +- PrimaryPrefix[@CanonicalImage = "EA.EA_EMP_ID", @Image = "ea.ea_emp_id", @SelfModifier = false]
Added line: 8107
Added line: 2896
      |  |     |                 |  |     +- SimpleExpression[@CanonicalImage = "EA.EA_EMP_ID", @Image = "ea.ea_emp_id"]
      |  |     |                 |  |        +- TableName[@CanonicalImage = "EA", @Image = "ea"]
      |  |     |                 |  |        |  +- ID[@CanonicalImage = "EA", @Image = "ea"]
      |  |     |                 |  |        +- Column[@CanonicalImage = "EA_EMP_ID", @Image = "ea_emp_id"]
Added line: 9535
Added line: 9616
      |  |     |                 |  |           +- ID[@CanonicalImage = "EA_EMP_ID", @Image = "ea_emp_id"]
Added line: 1780
Added line: 5252
Added line: 3547
      |  |     |                 |  +- SqlExpression[@CanonicalImage = "P_EMP_ID", @Image = "p_emp_id"]
      |  |     |                 |     +- PrimaryPrefix[@CanonicalImage = "P_EMP_ID", @Image = "p_emp_id", @SelfModifier = false]
      |  |     |                 |        +- SimpleExpression[@CanonicalImage = "P_EMP_ID", @Image = "p_emp_id"]
      |  |     |                 |           +- Column[@CanonicalImage = "P_EMP_ID", @Image = "p_emp_id"]
      |  |     |                 |              +- ID[@CanonicalImage = "P_EMP_ID", @Image = "p_emp_id"]
      |  |     |                 +- Condition[@CanonicalImage = null]
      |  |     |                    +- CompoundCondition[@CanonicalImage = null, @Type = null]
      |  |     |                       +- ComparisonCondition[@CanonicalImage = null, @Operator = "="]
      |  |     |                          +- SqlExpression[@CanonicalImage = "EA.EA_PROJ_ID", @Image = "ea.ea_proj_id"]
Added line: 3765
      |  |     |                          |  +- PrimaryPrefix[@CanonicalImage = "EA.EA_PROJ_ID", @Image = "ea.ea_proj_id", @SelfModifier = false]
Added line: 7164
Added line: 5213
      |  |     |                          |     +- SimpleExpression[@CanonicalImage = "EA.EA_PROJ_ID", @Image = "ea.ea_proj_id"]
      |  |     |                          |        +- TableName[@CanonicalImage = "EA", @Image = "ea"]
      |  |     |                          |        |  +- ID[@CanonicalImage = "EA", @Image = "ea"]
      |  |     |                          |        +- Column[@CanonicalImage = "EA_PROJ_ID", @Image = "ea_proj_id"]
      |  |     |                          |           +- ID[@CanonicalImage = "EA_PROJ_ID", @Image = "ea_proj_id"]
      |  |     |                          +- SqlExpression[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id"]
Added line: 6885
Added line: 7228
      |  |     |                             +- PrimaryPrefix[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id", @SelfModifier = false]
Added line: 3173
      |  |     |                                +- SimpleExpression[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id"]
Added line: 2278
      |  |     |                                   +- Column[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id"]
      |  |     |                                      +- ID[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id"]
Added line: 2927
      |  |     +- ExceptionHandler[@CanonicalImage = null]
Added line: 8850
      |  |     |  |  +- UnqualifiedID[@CanonicalImage = "NO_DATA_FOUND", @Image = "NO_DATA_FOUND"]
Added line: 427
Added line: 1174
Added line: 9388
Added line: 6930
      |  |     |  +- Statement[@CanonicalImage = null]
Added line: 4375
Added line: 5361
      |  |     |     +- UnlabelledStatement[@CanonicalImage = null]
      |  |     |        +- Expression[@CanonicalImage = "RAISE_APPLICATION_ERROR", @Image = "RAISE_APPLICATION_ERROR"]
      |  |     |           +- PrimaryPrefix[@CanonicalImage = "RAISE_APPLICATION_ERROR", @Image = "RAISE_APPLICATION_ERROR", @SelfModifier = false]
      |  |     |              +- FunctionCall[@CanonicalImage = "RAISE_APPLICATION_ERROR", @Image = "RAISE_APPLICATION_ERROR"]
Added line: 4851
Added line: 1556
      |  |     |                 +- FunctionName[@CanonicalImage = "RAISE_APPLICATION_ERROR", @Image = "RAISE_APPLICATION_ERROR"]
      |  |     |                 |  +- ID[@CanonicalImage = "RAISE_APPLICATION_ERROR", @Image = "RAISE_APPLICATION_ERROR"]
Added line: 3876
      |  |     |                 +- Arguments[@ArgumentCount = 2, @CanonicalImage = null]
Added line: 2553
      |  |     |                    +- ArgumentList[@CanonicalImage = null]
      |  |     |                       +- Argument[@CanonicalImage = null]
Added line: 8507
      |  |     |                       |  +- Expression[@CanonicalImage = "-20100", @Image = " -20100"]
      |  |     |                       |     +- PrimaryPrefix[@CanonicalImage = "20100", @Image = "20100", @SelfModifier = false]
Added line: 5651
Added line: 4310
Added line: 2527
      |  |     |                       |        +- Literal[@CanonicalImage = "20100", @Image = "20100"]
      |  |     |                       |           +- NumericLiteral[@CanonicalImage = "20100", @Image = "20100"]
Added line: 7114
      |  |     |                       +- Argument[@CanonicalImage = null]
      |  |     |                          +- Expression[@CanonicalImage = "\'NO SUCH EMPLOYEE OR PROJECT\'", @Image = "\'No such employee or project\'"]
      |  |     |                             +- PrimaryPrefix[@CanonicalImage = "\'NO SUCH EMPLOYEE OR PROJECT\'", @Image = "\'No such employee or project\'", @SelfModifier = false]
      |  |     +- ID[@CanonicalImage = "SET_NEW_PLANNED", @Image = "set_new_planned"]
Added line: 1885
Added line: 2948
Added line: 9683
      |  +- DeclarativeUnit[@CanonicalImage = null]
      |        +- MethodDeclarator[@CanonicalImage = "EXISTING_PLANNED", @Image = "existing_planned", @ParameterCount = 1]
      |        |  +- ObjectNameDeclaration[@CanonicalImage = "EXISTING_PLANNED", @Image = "existing_planned"]
Added line: 1263
      |        |  |  +- ID[@CanonicalImage = "EXISTING_PLANNED", @Image = "existing_planned"]
      |        |  +- FormalParameters[@CanonicalImage = "(P_EMP_ID,P_PROJECT_ID)", @Image = "(p_emp_id,p_project_id)"]
      |        |  |  |  +- ID[@CanonicalImage = "P_EMP_ID", @Image = "p_emp_id"]
      |        |  |  |  +- Datatype[@CanonicalImage = "NUMBER", @Image = "NUMBER", @TypeImage = "NUMBER"]
      |        |  |  |     +- ScalarDataTypeName[@CanonicalImage = "NUMBER", @Image = "NUMBER"]
      |        |  |  +- FormalParameter[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id", @In = true, @NoCopy = false, @Out = false]
      |        |  |     +- ID[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id"]
Added line: 8680
Added line: 289
      |        |  |     +- Datatype[@CanonicalImage = "NUMBER", @Image = "NUMBER", @TypeImage = "NUMBER"]
      |        |  |        +- ScalarDataTypeName[@CanonicalImage = "NUMBER", @Image = "NUMBER"]
      |        |  +- Datatype[@CanonicalImage = "NUMBER", @Image = "NUMBER", @TypeImage = "NUMBER"]
      |        |     +- ScalarDataTypeName[@CanonicalImage = "NUMBER", @Image = "NUMBER"]
      |        +- DeclarativeSection[@CanonicalImage = null]
      |        |  +- DeclarativeUnit[@CanonicalImage = null]
Added line: 9455
Added line: 4616
Added line: 8627
      |        |     +- VariableOrConstantDeclaration[@CanonicalImage = null]
      |        |        +- VariableOrConstantDeclarator[@CanonicalImage = "EXISTING_HOURS NUMBER(4)", @Image = "existing_hours NUMBER(4)"]
Added line: 6379
      |        |           +- VariableOrConstantDeclaratorId[@Array = false, @ArrayDepth = 0, @CanonicalImage = "EXISTING_HOURS", @Image = "existing_hours"]
      |        |           |  +- ID[@CanonicalImage = "EXISTING_HOURS", @Image = "existing_hours"]
Added line: 1514
      |        |           +- Datatype[@CanonicalImage = "NUMBER(4)", @Image = "NUMBER(4)", @TypeImage = "NUMBER(4)"]
Added line: 4260
      |        |              +- ScalarDataTypeName[@CanonicalImage = "NUMBER(4)", @Image = "NUMBER(4)"]
Added line: 2924
      |        |                 +- NumericLiteral[@CanonicalImage = "4", @Image = "4"]
      |        +- Statement[@CanonicalImage = null]
Added line: 571
      |        |  +- UnlabelledStatement[@CanonicalImage = null]
      |        |     +- SelectIntoStatement[@All = false, @CanonicalImage = null, @Distinct = false, @Unique = false]
Added line: 3282
      |        |        +- SelectList[@CanonicalImage = null]
      |        |        |  +- SqlExpression[@CanonicalImage = "EA.EA_PLANNED_HOURS", @Image = "ea.ea_planned_hours"]
Added line: 9825
      |        |        |     +- PrimaryPrefix[@CanonicalImage = "EA.EA_PLANNED_HOURS", @Image = "ea.ea_planned_hours", @SelfModifier = false]
Added line: 4918
Added line: 2676
      |        |        |        +- SimpleExpression[@CanonicalImage = "EA.EA_PLANNED_HOURS", @Image = "ea.ea_planned_hours"]
Added line: 132
      |        |        |           +- TableName[@CanonicalImage = "EA", @Image = "ea"]
Added line: 9999
Added line: 8108
Added line: 2586
      |        |        |           |  +- ID[@CanonicalImage = "EA", @Image = "ea"]
      |        |        |           +- Column[@CanonicalImage = "EA_PLANNED_HOURS", @Image = "ea_planned_hours"]
      |        |        |              +- ID[@CanonicalImage = "EA_PLANNED_HOURS", @Image = "ea_planned_hours"]
Added line: 187
Added line: 8207
      |        |        +- IntoClause[@CanonicalImage = null]
      |        |        |  +- VariableName[@CanonicalImage = "EXISTING_HOURS", @Image = "existing_hours"]
      |        |        +- FromClause[@CanonicalImage = null]
      |        |        |  +- TableReference[@CanonicalImage = null]
Added line: 5961
Added line: 947
      |        |        |     +- TableName[@CanonicalImage = "EMPLOYEE_ON_ACTIVITY", @Image = "employee_on_activity"]
      |        |        |     |  +- ID[@CanonicalImage = "EMPLOYEE_ON_ACTIVITY", @Image = "employee_on_activity"]
      |        |        |     +- TableAlias[@CanonicalImage = "EA", @Image = "ea"]
Added line: 3022
      |        |        +- WhereClause[@CanonicalImage = null]
Added line: 5848
      |        |           +- Condition[@CanonicalImage = null]
Added line: 8346
Added line: 324
Added line: 3474
      |        |              +- CompoundCondition[@CanonicalImage = null, @Type = "AND"]
      |        |                 |  |  +- PrimaryPrefix[@CanonicalImage = "EA.EA_EMP_ID", @Image = "ea.ea_emp_id", @SelfModifier = false]
      |        |                 |  |     +- SimpleExpression[@CanonicalImage = "EA.EA_EMP_ID", @Image = "ea.ea_emp_id"]
Added line: 949
      |        |                 |  |        +- TableName[@CanonicalImage = "EA", @Image = "ea"]
      |        |                 |  |        |  +- ID[@CanonicalImage = "EA", @Image = "ea"]
      |        |                 |  |        +- Column[@CanonicalImage = "EA_EMP_ID", @Image = "ea_emp_id"]
      |        |                 |  |           +- ID[@CanonicalImage = "EA_EMP_ID", @Image = "ea_emp_id"]
Added line: 895
Added line: 4651
Added line: 1039
      |        |                 |  +- SqlExpression[@CanonicalImage = "P_EMP_ID", @Image = "p_emp_id"]
      |        |                 |     +- PrimaryPrefix[@CanonicalImage = "P_EMP_ID", @Image = "p_emp_id", @SelfModifier = false]
Added line: 6306
      |        |                 |        +- SimpleExpression[@CanonicalImage = "P_EMP_ID", @Image = "p_emp_id"]
      |        |                 |           +- Column[@CanonicalImage = "P_EMP_ID", @Image = "p_emp_id"]
      |        |                 |              +- ID[@CanonicalImage = "P_EMP_ID", @Image = "p_emp_id"]
Added line: 5708
Added line: 3782
      |        |                 +- Condition[@CanonicalImage = null]
      |        |                    +- CompoundCondition[@CanonicalImage = null, @Type = null]
Added line: 6973
      |        |                       +- ComparisonCondition[@CanonicalImage = null, @Operator = "="]
      |        |                          +- SqlExpression[@CanonicalImage = "EA.EA_PROJ_ID", @Image = "ea.ea_proj_id"]
      |        |                          |  +- PrimaryPrefix[@CanonicalImage = "EA.EA_PROJ_ID", @Image = "ea.ea_proj_id", @SelfModifier = false]
      |        |                          |     +- SimpleExpression[@CanonicalImage = "EA.EA_PROJ_ID", @Image = "ea.ea_proj_id"]
      |        |                          |        +- TableName[@CanonicalImage = "EA", @Image = "ea"]
      |        |                          |        |  +- ID[@CanonicalImage = "EA", @Image = "ea"]
      |        |                          |        +- Column[@CanonicalImage = "EA_PROJ_ID", @Image = "ea_proj_id"]
      |        |                          |           +- ID[@CanonicalImage = "EA_PROJ_ID", @Image = "ea_proj_id"]
      |        |                          +- SqlExpression[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id"]
Added line: 3149
Added line: 1567
      |        |                             +- PrimaryPrefix[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id", @SelfModifier = false]
      |        |                                +- SimpleExpression[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id"]
Added line: 5138
      |        |                                   +- Column[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id"]
Added line: 8297
      |        |                                      +- ID[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id"]
      |        +- Statement[@CanonicalImage = null]
      |        |  +- UnlabelledStatement[@CanonicalImage = null]
      |        |     +- ReturnStatement[@CanonicalImage = null]
Added line: 2327
      |        |        +- Expression[@CanonicalImage = "(EXISTING_HOURS)", @Image = "(existing_hours)"]
      |        |           +- PrimaryPrefix[@CanonicalImage = "(EXISTING_HOURS)", @Image = "(existing_hours)", @SelfModifier = false]
      |        |                 +- PrimaryPrefix[@CanonicalImage = "EXISTING_HOURS", @Image = "existing_hours", @SelfModifier = false]
Added line: 941
Added line: 6900
      |        |                    +- SimpleExpression[@CanonicalImage = "EXISTING_HOURS", @Image = "existing_hours"]
      |        |                       +- Column[@CanonicalImage = "EXISTING_HOURS", @Image = "existing_hours"]
      |        |                          +- ID[@CanonicalImage = "EXISTING_HOURS", @Image = "existing_hours"]
      |        +- ExceptionHandler[@CanonicalImage = null]
Added line: 6177
Added line: 8087
      |        |  +- QualifiedName[@CanonicalImage = "OTHERS", @Image = "OTHERS"]
      |        |  |  +- UnqualifiedID[@CanonicalImage = "OTHERS", @Image = "OTHERS"]
      |        |  +- Statement[@CanonicalImage = null]
Added line: 142
Added line: 9812
      |        |     +- UnlabelledStatement[@CanonicalImage = null]
      |        |        +- Expression[@CanonicalImage = "NULL", @Image = "NULL"]
Added line: 4807
      |        |           +- PrimaryPrefix[@CanonicalImage = "NULL", @Image = "NULL", @SelfModifier = false]
      |        |              +- Literal[@CanonicalImage = "NULL", @Image = "NULL"]
Added line: 5544
      |        |                 +- NullLiteral[@CanonicalImage = "NULL", @Image = "NULL"]
      |        +- ID[@CanonicalImage = "EXISTING_PLANNED", @Image = "existing_planned"]
      +- ID[@CanonicalImage = "UPDATE_PLANNED_HRS", @Image = "update_planned_hrs"]
