Modifying Action Items with Pre/Post Logic

Coordinate JSON parsing, business logic, and table changes for action item CRUD operations.

The INSERT_OBJECT, UPDATE_OBJECT, and DELETE_OBJECT functions coordinate the processing of the incoming JSON document to:

• Populate PL/SQL records with the JSON action item and team member data

• Apply before save and after save logic to compute defaults and validate what’s needed

• Save the valid data to ACTION_ITEMS and ACTION_ITEM_TEAM_MEMBERS tables.