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

• Populating PL/SQL Records from JSON
  Parse action item JSON into PL/SQL records for the parent row and team members.
• Saving Action Item Data to Tables
  Save action item records and team members with insert, update, or delete logic.
• Defaulting and Validating Pre/Post-Save
  Apply defaults before saving, then validate saved parent and child rows before commit.
• Coordinating the API Helper Code
  Coordinate JSON parsing, pre-save logic, table changes, post-save checks, and response generation.