14.8.2 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.

• Constructing or Querying an Action Item
  Compare programmatic and SQL-based ways to build action item JSON.
• Retrieving Action Items with Paging
  Retrieve matching action items in a predictable order and return paged JSON results.
• Modifying Action Items with Pre/Post Logic
  Coordinate JSON parsing, business logic, and table changes for action item CRUD operations.
• Inspecting the Core Action Item API Body
  Inspect the full core API package body that coordinates JSON parsing, data changes, and validation.