TYPES OF TRIGGERS

Oracle ebusiness  suite

Question of the Day!!  

                

Module: Oracle Technical

Question:  What are the TYPES OF TRIGGERS ?

Ans: Following are the triggers type:

A.   REPORTS TRIGGERS ARE

i. Before parameter form

ii. After parameter form

iii.            Before report 

iv.            Between pages

v.            After report 

a.   Table /View Triggers

i. Before/After Insert/update/Delete (DML)

b.   System Event Triggers

i. DDL on schema and database (DDL) 

Create/Alter/Drop   

B.   Form Triggers

Different types of form triggers:

1.   Key triggers

2.   Navigational Triggers

3.   Transactional Triggers

4.   Message Triggers

5.   Error Triggers

6.   Query Based Triggers

Main Events are as under:

i. Pre-Logon

ii. On-Logon

iii.            Post-Logon

iv.            Pre-Form

v.            Pre-Block

vi.            Pre-Record 

vii.           Pre-Text-Item

viii.          When-New-Form-Instance

ix.            When-New-Block-Instance

x.            When-New-Record-Instance

xi.            When-New-Item-Instance

xii.           When-Validate-Item

xiii.          Post-Text-Item called

xiv.          When-New-Item-Instance

xv.           When-CheckBox-Changed

xvi.          When-Validate-Item

xvii.         When-New-Item-Instance

xviii.        When-Radio-Changed

xix.          Value of Radio Button

xx.           When-New-Item-Instance

xxi.          When-List-Changed

xxii.         Value in List Item PUN

xxiii.        When-New-Item-Instance

xxiv.        Push Button pressed...

xxv.         When-Validate-Record

xxvi.        Post-Record

xxvii.       Post-Block

xxviii.       Post-Form

xxix.        Pre-Logout

xxx.         On-LogOut

xxxi.        Post-LogOut