1 PACKAGE BSC_CAUSE_EFFECT_UI_WRAPPER AUTHID CURRENT_USER AS
2 /* $Header: BSCCAEWS.pls 115.5 2003/02/12 14:25:35 adrao ship $ */
3
4 --
5 -- Global Types
6 --
7 TYPE t_array_of_number IS TABLE OF NUMBER
8 INDEX BY BINARY_INTEGER;
9
10 TYPE t_array_of_varchar2 IS TABLE OF VARCHAR2(32000)
11 INDEX BY BINARY_INTEGER;
12
13 TYPE time_parameter_rec_type IS RECORD
14 (dimension VARCHAR2(32000)
15 ,dimension_level VARCHAR2(32000)
16 ,time_from VARCHAR2(32000)
17 ,time_to VARCHAR2(32000)
18
19 );
20
21 TYPE dim_parameter_rec_type IS RECORD
22 (dimension VARCHAR2(32000)
23 ,dimension_level VARCHAR2(32000)
24 ,dimension_level_value VARCHAR2(32000)
25 );
26
27 TYPE dim_parameter_tbl_type IS TABLE OF dim_parameter_rec_type INDEX BY
28 BINARY_INTEGER;
29
30
31 PROCEDURE Apply_Cause_Effect_Rels(
32 p_indicator IN NUMBER
33 ,p_level IN VARCHAR2
34 ,p_causes_lst IN VARCHAR2
35 ,p_effects_lst IN VARCHAR2
36 ,x_return_status OUT NOCOPY VARCHAR2
37 ,x_msg_count OUT NOCOPY NUMBER
38 ,x_msg_data OUT NOCOPY VARCHAR2
39 );
40
41 FUNCTION Exists_Measure_Dataset(
42 p_measure_short_name IN VARCHAR2
43 ) RETURN BOOLEAN;
44
45 FUNCTION Get_Dataset_Id(
46 p_measure_short_name IN VARCHAR2
47 ) RETURN NUMBER;
48
49 FUNCTION Decompose_Numeric_List(
50 x_string IN VARCHAR2,
51 x_number_array IN OUT NOCOPY t_array_of_number,
52 x_separator IN VARCHAR2
53 ) RETURN NUMBER;
54
55 FUNCTION Decompose_Varchar2_List(
56 x_string IN VARCHAR2,
57 x_array IN OUT NOCOPY t_array_of_varchar2,
58 x_separator IN VARCHAR2
59 ) RETURN NUMBER;
60
61 FUNCTION Item_Belong_To_Array_Number(
62 x_item IN NUMBER,
63 x_array IN t_array_of_number,
64 x_num_items IN NUMBER
65 ) RETURN BOOLEAN;
66
67 FUNCTION Item_Belong_To_Array_Varchar2(
68 x_item IN VARCHAR2,
69 x_array IN t_array_of_varchar2,
70 x_num_items IN NUMBER
71 ) RETURN BOOLEAN;
72
73 FUNCTION Get_Indicator_Name(
74 p_indicator IN VARCHAR2,
75 p_level IN VARCHAR2
76 ) RETURN VARCHAR2;
77
78
79 PROCEDURE Get_Indicator_Link(
80 p_user_id IN NUMBER
81 ,p_indicator IN NUMBER
82 ,p_level IN VARCHAR2
83 ,p_page_id IN VARCHAR2 DEFAULT NULL
84 ,p_page_dim_params IN VARCHAR2 DEFAULT NULL
85 ,p_page_time_param IN VARCHAR2 DEFAULT NULL
86 ,p_view_by_param IN VARCHAR2 DEFAULT NULL
87 ,x_indicator_link OUT NOCOPY VARCHAR2
88 ,x_return_status OUT NOCOPY VARCHAR2
89 ,x_msg_count OUT NOCOPY NUMBER
90 ,x_msg_data OUT NOCOPY VARCHAR2
91 );
92
93 PROCEDURE Decompose_Page_Parameters(
94 p_page_dim_params IN VARCHAR2
95 , p_page_time_param IN VARCHAR2
96 , x_page_dim_parameters OUT NOCOPY dim_parameter_tbl_type
97 , x_page_time_param OUT NOCOPY time_parameter_rec_type
98 );
99
100 FUNCTION Get_Page_Dim_Param_Index(
101 p_page_dim_params IN dim_parameter_tbl_type
102 , p_dimension IN VARCHAR2
103 , p_dimension_level IN VARCHAR2
104 ) RETURN NUMBER;
105
106 FUNCTION has_Function_Access(
107 p_user_id IN NUMBER
108 , p_function_name IN VARCHAR2
109 ) RETURN BOOLEAN;
110
111 END BSC_CAUSE_EFFECT_UI_WRAPPER;