eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.ALR_ALERTS_PKG

Source


1 package ALR_ALERTS_PKG AUTHID CURRENT_USER as
2 /* $Header: ALRALRTS.pls 120.3.12010000.1 2008/07/27 06:58:22 appldev ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out nocopy VARCHAR2,
5   X_APPLICATION_ID in NUMBER,
6   X_ALERT_ID in NUMBER,
7   X_ALERT_NAME in VARCHAR2,
8   X_ALERT_CONDITION_TYPE in VARCHAR2,
9   X_ENABLED_FLAG in VARCHAR2,
10   X_START_DATE_ACTIVE in DATE,
11   X_END_DATE_ACTIVE in DATE,
12   X_TABLE_ID in NUMBER,
13   X_TABLE_APPLICATION_ID in NUMBER,
14   X_DESCRIPTION in VARCHAR2,
15   X_FREQUENCY_TYPE in VARCHAR2,
16   X_WEEKLY_CHECK_DAY in VARCHAR2,
17   X_MONTHLY_CHECK_DAY_NUM in NUMBER,
18   X_DAYS_BETWEEN_CHECKS in NUMBER,
19   X_CHECK_BEGIN_DATE in DATE,
20   X_DATE_LAST_CHECKED in DATE,
21   X_INSERT_FLAG in VARCHAR2,
22   X_UPDATE_FLAG in VARCHAR2,
23   X_DELETE_FLAG in VARCHAR2,
24   X_MAINTAIN_HISTORY_DAYS in NUMBER,
25   X_CHECK_TIME in NUMBER,
26   X_CHECK_START_TIME in NUMBER,
27   X_CHECK_END_TIME in NUMBER,
28   X_SECONDS_BETWEEN_CHECKS in NUMBER,
29   X_CHECK_ONCE_DAILY_FLAG in VARCHAR2,
30   X_SQL_STATEMENT_TEXT in LONG,
31   X_ONE_TIME_ONLY_FLAG in NUMBER,
32   X_TABLE_NAME in VARCHAR2,
33   X_CREATION_DATE in DATE,
34   X_CREATED_BY in NUMBER,
35   X_LAST_UPDATE_DATE in DATE,
36   X_LAST_UPDATED_BY in NUMBER,
37   X_LAST_UPDATE_LOGIN in NUMBER);
38 procedure LOAD_ROW (
39   X_APPLICATION_SHORT_NAME in VARCHAR2,
40   X_ALERT_NAME in VARCHAR2,
41   X_OWNER in VARCHAR2,
42   X_ALERT_CONDITION_TYPE in VARCHAR2,
43   X_ENABLED_FLAG in VARCHAR2,
44   X_START_DATE_ACTIVE in VARCHAR2,
45   X_END_DATE_ACTIVE in VARCHAR2,
46   X_TABLE_APPLICATION_SHORT_NAME in VARCHAR2,
47   X_DESCRIPTION in VARCHAR2,
48   X_FREQUENCY_TYPE in VARCHAR2,
49   X_WEEKLY_CHECK_DAY in VARCHAR2,
50   X_MONTHLY_CHECK_DAY_NUM in VARCHAR2,
51   X_DAYS_BETWEEN_CHECKS in VARCHAR2,
52   X_CHECK_BEGIN_DATE in VARCHAR2,
53   X_DATE_LAST_CHECKED in VARCHAR2,
54   X_INSERT_FLAG in VARCHAR2,
55   X_UPDATE_FLAG in VARCHAR2,
56   X_DELETE_FLAG in VARCHAR2,
57   X_MAINTAIN_HISTORY_DAYS in VARCHAR2,
58   X_CHECK_TIME in VARCHAR2,
59   X_CHECK_START_TIME in VARCHAR2,
60   X_CHECK_END_TIME in VARCHAR2,
61   X_SECONDS_BETWEEN_CHECKS in VARCHAR2,
62   X_CHECK_ONCE_DAILY_FLAG in VARCHAR2,
63   X_SQL_STATEMENT_TEXT in VARCHAR2,
64   X_ONE_TIME_ONLY_FLAG in VARCHAR2,
65   X_TABLE_NAME in VARCHAR2,
66   X_LAST_UPDATE_DATE in VARCHAR2,
67   X_CUSTOM_MODE in VARCHAR2
68 );
69 procedure LOCK_ROW (
70   X_APPLICATION_ID in NUMBER,
71   X_ALERT_ID in NUMBER,
72   X_ALERT_NAME in VARCHAR2,
73   X_ALERT_CONDITION_TYPE in VARCHAR2,
74   X_ENABLED_FLAG in VARCHAR2,
75   X_START_DATE_ACTIVE in DATE,
76   X_END_DATE_ACTIVE in DATE,
77   X_TABLE_ID in NUMBER,
78   X_TABLE_APPLICATION_ID in NUMBER,
79   X_DESCRIPTION in VARCHAR2,
80   X_FREQUENCY_TYPE in VARCHAR2,
81   X_WEEKLY_CHECK_DAY in VARCHAR2,
82   X_MONTHLY_CHECK_DAY_NUM in NUMBER,
83   X_DAYS_BETWEEN_CHECKS in NUMBER,
84   X_CHECK_BEGIN_DATE in DATE,
85   X_DATE_LAST_CHECKED in DATE,
86   X_INSERT_FLAG in VARCHAR2,
87   X_UPDATE_FLAG in VARCHAR2,
88   X_DELETE_FLAG in VARCHAR2,
89   X_MAINTAIN_HISTORY_DAYS in NUMBER,
90   X_CHECK_TIME in NUMBER,
91   X_CHECK_START_TIME in NUMBER,
92   X_CHECK_END_TIME in NUMBER,
93   X_SECONDS_BETWEEN_CHECKS in NUMBER,
94   X_CHECK_ONCE_DAILY_FLAG in VARCHAR2,
95   X_SQL_STATEMENT_TEXT in LONG,
96   X_ONE_TIME_ONLY_FLAG in NUMBER,
97   X_TABLE_NAME in VARCHAR2
98 );
99 procedure UPDATE_ROW (
100   X_APPLICATION_ID in NUMBER,
101   X_ALERT_ID in NUMBER,
102   X_ALERT_NAME in VARCHAR2,
103   X_ALERT_CONDITION_TYPE in VARCHAR2,
104   X_ENABLED_FLAG in VARCHAR2,
105   X_START_DATE_ACTIVE in DATE,
106   X_END_DATE_ACTIVE in DATE,
107   X_TABLE_ID in NUMBER,
108   X_TABLE_APPLICATION_ID in NUMBER,
109   X_DESCRIPTION in VARCHAR2,
110   X_FREQUENCY_TYPE in VARCHAR2,
111   X_WEEKLY_CHECK_DAY in VARCHAR2,
112   X_MONTHLY_CHECK_DAY_NUM in NUMBER,
113   X_DAYS_BETWEEN_CHECKS in NUMBER,
114   X_CHECK_BEGIN_DATE in DATE,
115   X_DATE_LAST_CHECKED in DATE,
116   X_INSERT_FLAG in VARCHAR2,
117   X_UPDATE_FLAG in VARCHAR2,
118   X_DELETE_FLAG in VARCHAR2,
119   X_MAINTAIN_HISTORY_DAYS in NUMBER,
120   X_CHECK_TIME in NUMBER,
121   X_CHECK_START_TIME in NUMBER,
122   X_CHECK_END_TIME in NUMBER,
123   X_SECONDS_BETWEEN_CHECKS in NUMBER,
124   X_CHECK_ONCE_DAILY_FLAG in VARCHAR2,
125   X_SQL_STATEMENT_TEXT in LONG,
126   X_ONE_TIME_ONLY_FLAG in NUMBER,
127   X_TABLE_NAME in VARCHAR2,
128   X_LAST_UPDATE_DATE in DATE,
129   X_LAST_UPDATED_BY in NUMBER,
130   X_LAST_UPDATE_LOGIN in NUMBER
131 );
132 procedure DELETE_ROW (
133   X_APPLICATION_ID in NUMBER,
134   X_ALERT_ID in NUMBER
135 );
136 end ALR_ALERTS_PKG;