5 Generate Notification Trigger

This topic provides systematic instructions to generate new or modify the existing Notification Trigger.

1. Log in to the Development Workbench.
   Development Workbench For Universal Banking screen displays.

   Figure 5-1 Development Workbench For Universal Banking

   
   

   
   Description of "Figure 5-1 Development Workbench For Universal Banking"

   
   
2. Click on the Notification Triggers option under the Browser menu.
3. To add a new Notification Trigger, follow the steps given below:
   1. Specify the details in the Notification Trigger- New screen and save the Notification Trigger.

      Figure 5-2 Notification Trigger- New

      
      

      
      Description of "Figure 5-2 Notification Trigger- New"

      
      

      Table 5-1 Notification Trigger- New

      Field	Description
      Trigger Code	A unique value for a notification trigger. The naming conversion should start with TRG_XXXX. This is a mandatory field. This attribute signifies the trigger code created as part of the trigger creation step in OTD. Each notification will be linked to a trigger code.
      Description	This is an information field. Specify a meaningful description of Trigger.
      Firing Time	Specify when the trigger needs to be fired. The user can create only Before and After triggers for tables. (INSTEAD OF triggers are only available for views; typically they are used to implement view updates.) (After/Before).
      Each Record	Specify for each row required or not. If For Each Row option is specified, the trigger is row-level; otherwise, the trigger is statement-level. (Yes/No)
      Base Table	The base table on which, the trigger is built. This is a mandatory field. Select a valid table from available LOV next to the field.
      Pk Cols	Enter Primary key fields of table in tilde (~) separated format. This is a mandatory field.
      Pk Types	Enter the Primary key type of the corresponding primary key field. This is a mandatory field.
      Selected Columns and Data Types	Defunct
      Trigger When Clause	A simple when clause for the notification trigger. A trigger restriction can be specified in the WHEN clause, enclosed by parentheses. The trigger restriction is a SQL condition that must be satisfied for Oracle to fire the trigger. This condition cannot contain sub queries. Without the WHEN clause, the trigger is fired for each row.
      Notification Codes	If the trigger is associated with a specific notification code, then the particular notification code has to be provided in the field. If the trigger is shared across many Notifications, the field can be left empty.

      An Information window displays with confirming the message of successful generation of new Notification Trigger.

      Figure 5-3 Information

      
      

      
      Description of "Figure 5-3 Information"

      
      

      On successful save, Notification Trigger generates two files (gwtr#_<trg-code>.trg and GWTM_NOTIFICATION_TRIGGERS__<trg-code>.INC) that user needs to compile them in FLEXCUBE schema.
4. To modify the existing Notification Trigger, follow the steps given below:
   1. In Notification Trigger screen, click on the browse icon at Trigger Code option.
      Trigger Code window displays.

      Figure 5-4 Trigger Code

      
      

      
      Description of "Figure 5-4 Trigger Code"

      
      
   2. Enter the trigger to be modified in the Trigger code field and click on Search button.
   3. Select the Trigger Code from the list.
      Notification Trigger screen displays with the selected Trigger code.

      Figure 5-5 Notification Trigger

      
      

      
      Description of "Figure 5-5 Notification Trigger"

      
      
   4. Specify the new details to modify the existing one and save the Notification Trigger.

      Figure 5-6 Notification Trigger- Modify

      An Information window displays with confirming the message of successful modification of the Notification Trigger.

      Figure 5-7 Information

      
      

      
      Description of "Figure 5-7 Information"