Examining Core Action Item API Logic

The ACTION_ITEMS_API package is the heart of the Action Items REST API.

It implements the five public procedures the ORDS template handlers call via ACTION_ITEMS_API_REST:

• get_object – to retrieve a single action item by ID

• get_objects – to list or search action items with paging support

• insert_object – to create a new action item

• update_object – to update an existing action item by ID

• delete_object – to delete an existing action item by ID.

Each procedure uses other interesting private helper routines whole roles are important to understand before digging into the full code of the package body.