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.

APPS.HRI_EDW_DIM_EVENTS dependencies on HRI_EDW_USER_EVENTS

Line 10: FROM hri_edw_user_events

6: RETURN NUMBER IS
7:
8: CURSOR row_exists_cur IS
9: SELECT 1
10: FROM hri_edw_user_events
11: WHERE user_event_type = 'GLOBAL_' || p_user_event_type;
12:
13: l_temp NUMBER;
14:

Line 34: UPDATE hri_edw_user_events

30: IS
31:
32: BEGIN
33:
34: UPDATE hri_edw_user_events
35: SET global_enabled_flag = p_value
36: WHERE user_event_type = p_user_event_type
37: OR user_event_type = 'GLOBAL_' || p_user_event_type;
38:

Line 52: UPDATE hri_edw_user_events

48:
49: l_global_exists := global_exists( p_user_event_type );
50:
51: IF (l_global_exists > 0) THEN
52: UPDATE hri_edw_user_events
53: SET global_threshold_value = p_value
54: WHERE user_event_type = 'GLOBAL_' || p_user_event_type
55: OR user_event_type = p_user_event_type;
56: END IF;

Line 76: INSERT INTO hri_edw_user_events

72:
73: l_global_exists := global_exists( p_user_event_type );
74:
75: IF (l_global_exists = 0) THEN
76: INSERT INTO hri_edw_user_events
77: ( user_event_id
78: , user_event_type
79: , threshold_units
80: , global_threshold_value

Line 83: ( hri_edw_user_events_s.nextval

79: , threshold_units
80: , global_threshold_value
81: , global_enabled_flag)
82: VALUES
83: ( hri_edw_user_events_s.nextval
84: , 'GLOBAL_' || p_user_event_type
85: , p_threshold_units
86: , p_global_threshold_value
87: , p_global_enabled_flag);

Line 139: FROM hri_edw_user_events glb

135: CURSOR global_values_cur IS
136: SELECT glb.global_threshold_value
137: ,glb.global_enabled_flag
138: ,glb.threshold_units
139: FROM hri_edw_user_events glb
140: WHERE glb.user_event_type = 'GLOBAL_' || p_user_event_type
141: AND NOT EXISTS (SELECT 1
142: FROM hri_edw_user_events evt
143: WHERE evt.user_event_type = p_user_event_type

Line 142: FROM hri_edw_user_events evt

138: ,glb.threshold_units
139: FROM hri_edw_user_events glb
140: WHERE glb.user_event_type = 'GLOBAL_' || p_user_event_type
141: AND NOT EXISTS (SELECT 1
142: FROM hri_edw_user_events evt
143: WHERE evt.user_event_type = p_user_event_type
144: AND evt.event_code = p_event_code);
145:
146:

Line 155: INSERT INTO hri_edw_user_events

151: l_global_enabled_flag, l_threshold_units;
152: IF (global_values_cur%NOTFOUND OR global_values_cur%NOTFOUND IS NULL) THEN
153: CLOSE global_values_cur;
154: ELSE
155: INSERT INTO hri_edw_user_events
156: ( user_event_id
157: , user_event_type
158: , event_code
159: , threshold_value

Line 164: ( hri_edw_user_events_s.nextval

160: , threshold_units
161: , global_threshold_value
162: , global_enabled_flag)
163: VALUES
164: ( hri_edw_user_events_s.nextval
165: , p_user_event_type
166: , p_event_code
167: , p_event_threshold
168: , l_threshold_units

Line 183: DELETE FROM hri_edw_user_events

179: IS
180:
181: BEGIN
182:
183: DELETE FROM hri_edw_user_events
184: WHERE user_event_type = p_user_event_type
185: AND event_code = p_event_code;
186:
187: RETURN;

Line 280: FROM hri_edw_user_events

276: ,threshold_value
277: ,threshold_units
278: ,global_threshold_value
279: ,global_enabled_flag
280: FROM hri_edw_user_events
281: WHERE user_event_type = p_user_event_type
282: AND (event_code = p_event_code OR event_code IS NULL);
283:
284: BEGIN

Line 295: INSERT INTO hri_edw_user_events

291: l_glbl_thr_value,
292: l_global_flag;
293: IF (row_exists_cur%NOTFOUND OR row_exists_cur%NOTFOUND IS NULL) THEN
294: CLOSE row_exists_cur;
295: INSERT INTO hri_edw_user_events
296: ( user_event_id
297: , user_event_type
298: , event_code
299: , threshold_value

Line 304: ( hri_edw_user_events_s.nextval

300: , threshold_units
301: , global_threshold_value
302: , global_enabled_flag )
303: values
304: ( hri_edw_user_events_s.nextval
305: , p_user_event_type
306: , p_event_code
307: , p_threshold_value
308: , p_threshold_units

Line 313: UPDATE hri_edw_user_events

309: , p_glbl_thr_value
310: , p_global_flag );
311: ELSE
312: CLOSE row_exists_cur;
313: UPDATE hri_edw_user_events
314: SET threshold_value = p_threshold_value
315: , threshold_units = p_threshold_units
316: , global_threshold_value = p_glbl_thr_value
317: , global_enabled_flag = p_global_flag