PACKAGE: APPS.ALR_DBTRIGGER

Source

1 package ALR_DBTRIGGER AUTHID CURRENT_USER as
2 /* $Header: ALREDBTS.pls 120.5.12020000.1 2012/07/02 10:58:45 appldev ship $ */
3 
4 
5    procedure CREATE_EVENT_DB_TRIGGER(
6 		APPL_ID in number,
7 		ALR_ID in number,
8 		TBL_APPLID in number,
9 		TBL_NAME in varchar2,
10 		OID in number,
11 		INSERT_FLAG in varchar2,
12 		UPDATE_FLAG in varchar2,
13 		DELETE_FLAG in varchar2,
14 		IS_ENABLE in varchar2);
15 
16    procedure ALTER_EVENT_DB_TRIGGER(
17 		APPL_ID in number,
18 		ALR_ID in number,
19 		TBL_APPLID in number,
20 		TBL_NAME in varchar2,
21 		OID in number,
22 		INSERT_FLAG in varchar2,
23 		UPDATE_FLAG in varchar2,
24 		DELETE_FLAG in varchar2,
25 		IS_ENABLE in varchar2);
26 
27    procedure DELETE_EVENT_DB_TRIGGER(
28 		APPL_ID in number,
29 		ALR_ID in number,
30 		OID in number);
31 
32    procedure PRE_UPDATE_EVENT_ALERT(
33 		APPL_ID in number,
34 		ALR_ID in number,
35 		NEW_TABLE_APPLID in number,
36 		NEW_TABLE_NAME in varchar2,
37 		NEW_INSERT_FLAG in varchar2,
38 		NEW_UPDATE_FLAG in varchar2,
39 		NEW_DELETE_FLAG in varchar2,
40 		NEW_IS_ENABLE in varchar2);
41 
42 end ALR_DBTRIGGER;