Now that we have created the forms objects, it is time to start adding some code. We need to add code to perform inserts, updates, and deletes. As we have based the form on views, we need to trigger the events and then we need to write code to call database procedures to transact data. There are four triggers we need to create on each block where we need to perform transactions. In this example, the only block where we want to do any transactions is the PER_SOCIETIES
block. When we insert data, we will also need to increment a sequence number for the SOCIETY_ID
column. We will need to perform the following tasks to trigger and code database transactions within our form:
Creating a program unit package specification
Creating a program unit package body
Creating
ON-INSERT, ON-UPDATE, ON-DELETE
, andON-LOCK
triggersCreating
PRE-INSERT
andPRE-UPDATE
triggers to set the WHO columns
We have created a sequence as we need to generate a unique SOCIETY_ID
before...