1 PACKAGE hri_edw_dim_events AS
2 /* $Header: hriedevt.pkh 120.0 2005/05/29 07:08:19 appldev noship $ */
3
4 PROCEDURE add_global( p_user_event_type IN VARCHAR2
5 , p_threshold_units IN VARCHAR2
6 , p_global_threshold_value IN NUMBER
7 , p_global_enabled_flag IN VARCHAR2);
8
9 PROCEDURE set_global( p_user_event_type IN VARCHAR2
10 , p_value IN NUMBER );
11
12 PROCEDURE enable_global( p_user_event_type IN VARCHAR2 );
13
14 PROCEDURE disable_global( p_user_event_type IN VARCHAR2 );
15
16 PROCEDURE add_event( p_user_event_type IN VARCHAR2
17 , p_event_code IN VARCHAR2
18 , p_event_threshold IN NUMBER );
19
20 PROCEDURE drop_event( p_user_event_type IN VARCHAR2
21 , p_event_code IN VARCHAR2 );
22
23 PROCEDURE load_hrhy_row( p_event_id IN NUMBER,
24 p_owner IN VARCHAR2,
25 p_hierarchy IN VARCHAR2,
26 p_level_number IN NUMBER,
27 p_event_code IN VARCHAR2,
28 p_parent_event_id IN NUMBER,
29 p_reason_type IN VARCHAR2,
30 p_user_event_type IN VARCHAR2 );
31
32 PROCEDURE load_user_row( p_user_event_type IN VARCHAR2,
33 p_event_code IN VARCHAR2,
34 p_owner IN VARCHAR2,
35 p_threshold_value IN NUMBER,
36 p_threshold_units IN VARCHAR2,
37 p_glbl_thr_value IN NUMBER,
38 p_global_flag IN VARCHAR2 );
39
40 PROCEDURE load_cmbn_row( p_combination_id IN NUMBER,
41 p_owner IN VARCHAR2,
42 p_gain_event_id IN NUMBER,
43 p_loss_event_id IN NUMBER,
44 p_rec_event_id IN NUMBER,
45 p_sep_event_id IN NUMBER,
46 p_reason_type IN VARCHAR2,
47 p_facts IN VARCHAR2,
48 p_description IN VARCHAR2 );
49
50 END hri_edw_dim_events;