@Overtake

Overtake an object that is defined in a lower layer of code.

Category: layer_control

In some occasions, the standard code cannot be overridden by simply adding code before and/or after the underlying layer is executed. (see @Override) An overtake simply replaces the underlying layers of code with the code you specify.

Example of overtaking a PL/SQL method

In this example, the WHERE-clause is different from the Base code and the standard method does not provide the right functionality. This version of the method will be used instead and no code from Base layer and below is executed.

@Overtake Core
FUNCTION Get_Night_End (
   expense_rule_ IN VARCHAR2,
   allowance_id_ IN VARCHAR2,
   account_date_ IN DATE DEFAULT SYSDATE ) RETURN DATE
IS
   temp_ allowance_tab.night_end%TYPE;
   CURSOR get_attr IS
      SELECT night_end
      FROM allowance_tab
      WHERE expense_rule = expense_rule_
      AND   allowance_id = allowance_id_
      AND   TRUNC(account_date_) BETWEEN valid_from AND valid_to;
   night_end_ DATE;   
BEGIN
   OPEN get_attr;
   FETCH get_attr INTO temp_;
   CLOSE get_attr;
   night_end_:= TO_DATE(temp_,'HH24:MI');
   RETURN night_end_;    
END Get_Night_End;

This page is generated from IFS Developer Studio at 2021-03-10 14:56.