+- Input[@CanonicalImage = null, @ExcludedLinesCount = 0, @ExcludedRangesCount = 0]
   +- PackageBody[@CanonicalImage = "UPDATE_PLANNED_HRS", @Image = "update_planned_hrs", @ObjectName = "update_planned_hrs"]
      +- ObjectNameDeclaration[@CanonicalImage = "UPDATE_PLANNED_HRS", @Image = "update_planned_hrs"]
      |  +- ID[@CanonicalImage = "UPDATE_PLANNED_HRS", @Image = "update_planned_hrs"]
      +- DeclarativeSection[@CanonicalImage = null]
      |  +- DeclarativeUnit[@CanonicalImage = null]
      |  |  +- 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"]
      |  |     |  +- FormalParameters[@CanonicalImage = "(P_EMP_ID,P_PROJECT_ID,P_HOURS)", @Image = "(p_emp_id,p_project_id,p_hours)"]
      |  |     |     +- 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"]
      |  |     |     |     +- 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"]
      |  |     |     |  +- Datatype[@CanonicalImage = "NUMBER", @Image = "NUMBER", @TypeImage = "NUMBER"]
      |  |     |     |     +- ScalarDataTypeName[@CanonicalImage = "NUMBER", @Image = "NUMBER"]
      |  |     |     +- 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]
      |  |     |     +- UpdateStatement[@CanonicalImage = null]
      |  |     |        +- 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]
      |  |     |        |  +- 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"]
      |  |     |        |  +- Expression[@CanonicalImage = "P_HOURS", @Image = "p_hours"]
      |  |     |        |     +- PrimaryPrefix[@CanonicalImage = "P_HOURS", @Image = "p_hours", @SelfModifier = false]
      |  |     |        |        +- SimpleExpression[@CanonicalImage = "P_HOURS", @Image = "p_hours"]
      |  |     |        |           +- Column[@CanonicalImage = "P_HOURS", @Image = "p_hours"]
      |  |     |        |              +- ID[@CanonicalImage = "P_HOURS", @Image = "p_hours"]
      |  |     |        +- WhereClause[@CanonicalImage = null]
      |  |     |           +- Condition[@CanonicalImage = null]
      |  |     |              +- CompoundCondition[@CanonicalImage = null, @Type = "AND"]
      |  |     |                 +- ComparisonCondition[@CanonicalImage = null, @Operator = "="]
      |  |     |                 |  +- SqlExpression[@CanonicalImage = "EA.EA_EMP_ID", @Image = "ea.ea_emp_id"]
      |  |     |                 |  |  +- PrimaryPrefix[@CanonicalImage = "EA.EA_EMP_ID", @Image = "ea.ea_emp_id", @SelfModifier = false]
      |  |     |                 |  |     +- 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"]
      |  |     |                 |  |           +- ID[@CanonicalImage = "EA_EMP_ID", @Image = "ea_emp_id"]
      |  |     |                 |  +- 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"]
      |  |     |                          |  +- 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"]
      |  |     |                             +- PrimaryPrefix[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id", @SelfModifier = false]
      |  |     |                                +- SimpleExpression[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id"]
      |  |     |                                   +- Column[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id"]
      |  |     |                                      +- ID[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id"]
      |  |     +- ExceptionHandler[@CanonicalImage = null]
      |  |     |  +- QualifiedName[@CanonicalImage = "NO_DATA_FOUND", @Image = "NO_DATA_FOUND"]
      |  |     |  |  +- UnqualifiedID[@CanonicalImage = "NO_DATA_FOUND", @Image = "NO_DATA_FOUND"]
      |  |     |  +- Statement[@CanonicalImage = null]
      |  |     |     +- 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"]
      |  |     |                 +- FunctionName[@CanonicalImage = "RAISE_APPLICATION_ERROR", @Image = "RAISE_APPLICATION_ERROR"]
      |  |     |                 |  +- ID[@CanonicalImage = "RAISE_APPLICATION_ERROR", @Image = "RAISE_APPLICATION_ERROR"]
      |  |     |                 +- Arguments[@ArgumentCount = 2, @CanonicalImage = null]
      |  |     |                    +- ArgumentList[@CanonicalImage = null]
      |  |     |                       +- Argument[@CanonicalImage = null]
      |  |     |                       |  +- Expression[@CanonicalImage = "-20100", @Image = " -20100"]
      |  |     |                       |     +- PrimaryPrefix[@CanonicalImage = "20100", @Image = "20100", @SelfModifier = false]
      |  |     |                       |        +- Literal[@CanonicalImage = "20100", @Image = "20100"]
      |  |     |                       |           +- NumericLiteral[@CanonicalImage = "20100", @Image = "20100"]
      |  |     |                       +- 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]
      |  |     |                                +- Literal[@CanonicalImage = "\'NO SUCH EMPLOYEE OR PROJECT\'", @Image = "\'No such employee or project\'"]
      |  |     |                                   +- StringLiteral[@CanonicalImage = "\'NO SUCH EMPLOYEE OR PROJECT\'", @Image = "\'No such employee or project\'", @String = "No such employee or project"]
      |  |     +- ID[@CanonicalImage = "SET_NEW_PLANNED", @Image = "set_new_planned"]
      |  +- DeclarativeUnit[@CanonicalImage = null]
      |     +- ProgramUnit[@CanonicalImage = null, @MethodName = "existing_planned", @Name = "existing_planned", @ObjectName = null]
      |        +- MethodDeclarator[@CanonicalImage = "EXISTING_PLANNED", @Image = "existing_planned", @ParameterCount = 1]
      |        |  +- ObjectNameDeclaration[@CanonicalImage = "EXISTING_PLANNED", @Image = "existing_planned"]
      |        |  |  +- ID[@CanonicalImage = "EXISTING_PLANNED", @Image = "existing_planned"]
      |        |  +- FormalParameters[@CanonicalImage = "(P_EMP_ID,P_PROJECT_ID)", @Image = "(p_emp_id,p_project_id)"]
      |        |  |  +- 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"]
      |        |  |  |     +- 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"]
      |        |  |     +- 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]
      |        |     +- VariableOrConstantDeclaration[@CanonicalImage = null]
      |        |        +- VariableOrConstantDeclarator[@CanonicalImage = "EXISTING_HOURS NUMBER(4)", @Image = "existing_hours NUMBER(4)"]
      |        |           +- VariableOrConstantDeclaratorId[@Array = false, @ArrayDepth = 0, @CanonicalImage = "EXISTING_HOURS", @Image = "existing_hours"]
      |        |           |  +- ID[@CanonicalImage = "EXISTING_HOURS", @Image = "existing_hours"]
      |        |           +- Datatype[@CanonicalImage = "NUMBER(4)", @Image = "NUMBER(4)", @TypeImage = "NUMBER(4)"]
      |        |              +- ScalarDataTypeName[@CanonicalImage = "NUMBER(4)", @Image = "NUMBER(4)"]
      |        |                 +- NumericLiteral[@CanonicalImage = "4", @Image = "4"]
      |        +- Statement[@CanonicalImage = null]
      |        |  +- UnlabelledStatement[@CanonicalImage = null]
      |        |     +- SelectIntoStatement[@All = false, @CanonicalImage = null, @Distinct = false, @Unique = false]
      |        |        +- SelectList[@CanonicalImage = null]
      |        |        |  +- SqlExpression[@CanonicalImage = "EA.EA_PLANNED_HOURS", @Image = "ea.ea_planned_hours"]
      |        |        |     +- PrimaryPrefix[@CanonicalImage = "EA.EA_PLANNED_HOURS", @Image = "ea.ea_planned_hours", @SelfModifier = false]
      |        |        |        +- SimpleExpression[@CanonicalImage = "EA.EA_PLANNED_HOURS", @Image = "ea.ea_planned_hours"]
      |        |        |           +- 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"]
      |        |        +- IntoClause[@CanonicalImage = null]
      |        |        |  +- VariableName[@CanonicalImage = "EXISTING_HOURS", @Image = "existing_hours"]
      |        |        |     +- ID[@CanonicalImage = "EXISTING_HOURS", @Image = "existing_hours"]
      |        |        +- FromClause[@CanonicalImage = null]
      |        |        |  +- TableReference[@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"]
      |        |        +- WhereClause[@CanonicalImage = null]
      |        |           +- Condition[@CanonicalImage = null]
      |        |              +- CompoundCondition[@CanonicalImage = null, @Type = "AND"]
      |        |                 +- ComparisonCondition[@CanonicalImage = null, @Operator = "="]
      |        |                 |  +- SqlExpression[@CanonicalImage = "EA.EA_EMP_ID", @Image = "ea.ea_emp_id"]
      |        |                 |  |  +- PrimaryPrefix[@CanonicalImage = "EA.EA_EMP_ID", @Image = "ea.ea_emp_id", @SelfModifier = false]
      |        |                 |  |     +- 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"]
      |        |                 |  |           +- ID[@CanonicalImage = "EA_EMP_ID", @Image = "ea_emp_id"]
      |        |                 |  +- 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"]
      |        |                          |  +- 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"]
      |        |                             +- PrimaryPrefix[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id", @SelfModifier = false]
      |        |                                +- SimpleExpression[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id"]
      |        |                                   +- Column[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id"]
      |        |                                      +- ID[@CanonicalImage = "P_PROJECT_ID", @Image = "p_project_id"]
      |        +- Statement[@CanonicalImage = null]
      |        |  +- UnlabelledStatement[@CanonicalImage = null]
      |        |     +- ReturnStatement[@CanonicalImage = null]
      |        |        +- Expression[@CanonicalImage = "(EXISTING_HOURS)", @Image = "(existing_hours)"]
      |        |           +- PrimaryPrefix[@CanonicalImage = "(EXISTING_HOURS)", @Image = "(existing_hours)", @SelfModifier = false]
      |        |              +- Expression[@CanonicalImage = "EXISTING_HOURS", @Image = "existing_hours"]
      |        |                 +- PrimaryPrefix[@CanonicalImage = "EXISTING_HOURS", @Image = "existing_hours", @SelfModifier = false]
      |        |                    +- SimpleExpression[@CanonicalImage = "EXISTING_HOURS", @Image = "existing_hours"]
      |        |                       +- Column[@CanonicalImage = "EXISTING_HOURS", @Image = "existing_hours"]
      |        |                          +- ID[@CanonicalImage = "EXISTING_HOURS", @Image = "existing_hours"]
      |        +- ExceptionHandler[@CanonicalImage = null]
      |        |  +- QualifiedName[@CanonicalImage = "OTHERS", @Image = "OTHERS"]
      |        |  |  +- UnqualifiedID[@CanonicalImage = "OTHERS", @Image = "OTHERS"]
      |        |  +- Statement[@CanonicalImage = null]
      |        |     +- UnlabelledStatement[@CanonicalImage = null]
      |        |        +- Expression[@CanonicalImage = "NULL", @Image = "NULL"]
      |        |           +- PrimaryPrefix[@CanonicalImage = "NULL", @Image = "NULL", @SelfModifier = false]
      |        |              +- Literal[@CanonicalImage = "NULL", @Image = "NULL"]
      |        |                 +- NullLiteral[@CanonicalImage = "NULL", @Image = "NULL"]
      |        +- ID[@CanonicalImage = "EXISTING_PLANNED", @Image = "existing_planned"]
      +- ID[@CanonicalImage = "UPDATE_PLANNED_HRS", @Image = "update_planned_hrs"]
