Skip to content

PLSQL File

The plsql file (*.plsql) contains the business logic. This file is not directly deployable into the database and has to pass through the code generator which produces database deployable api and apy files. The plsql file can be empty if no additions or changes to the template generated base plsql file exist.

Base plsql file

In the Base plsql file the following are defined:

  • The Public record
  • All methods which come with the template
  • All methods which depend on the model files

Once the Base plsql file is generated it cannot be changed.

Core plsql file

In the core plsql file, R&D adds all extra business logic. In this file it is possible to:

  • Add new methods
  • Override base methods
  • Overtake base methods (R&D should avoid overtakes as much as possible)

Customization plsql file

In any customization plsql file, customization specific business logic is written. In these files it is possible to:

  • Add new methods
  • Override base methods
  • Overtake base methods (try to avoid overtakes as much as possible)
  • Override core methods
  • Overtake core methods (try to avoid overtakes as much as possible)
  • Override core methods
  • Overtake core methods (try to avoid overtakes as much as possible)