[Home] [Help]
PACKAGE: APPS.BSC_BIS_WRAPPER_PUB
Source
1 PACKAGE BSC_BIS_WRAPPER_PUB AUTHID CURRENT_USER AS
2 /* $Header: BSCPBISS.pls 115.9 2003/02/12 14:26:14 adrao ship $ */
3
4
5 TYPE Dim_level_Rec_Type IS RECORD
6 ( dimension_short_name VARCHAR2(200) := NULL
7 ,level_short_name VARCHAR2(200) := NULL
8 ,level_value_id VARCHAR2(32000) := NULL
9 ,level_value_name VARCHAR2(32000) := NULL
10 );
11
12 TYPE Dim_level_Rec_Tbl_Type IS TABLE of Dim_level_Rec_Type
13 INDEX BY BINARY_INTEGER;
14
15 TYPE Page_Parameter_Rec_Type IS RECORD
16 ( parameter_name VARCHAR2(32000) := NULL
17 ,value_id VARCHAR2(32000) := NULL
18 ,value_name VARCHAR2(32000) := NULL
19 );
20
21 TYPE Page_Parameter_Rec_Tbl_Type IS TABLE OF Page_Parameter_Rec_Type
22 INDEX BY BINARY_INTEGER;
23
24 TYPE Kpi_Info_Rec_Type IS RECORD
25 ( kpi_code NUMBER := NULL
26 ,analysis_option0 NUMBER := NULL
27 ,analysis_option1 NUMBER := NULL
28 ,analysis_option2 NUMBER := NULL
29 ,series_id NUMBER := NULL
30 ,dataset_id NUMBER := NULL
31 ,dataset_source VARCHAR2(2000) := NULL
32 ,measure_short_name VARCHAR2(2000) := NULL
33 ,measure_dbi_flag VARCHAR2(1) := NULL
34 ,measure_id NUMBER := NULL
35 ,region_code VARCHAR2(2000) := NULL
36 ,function_name VARCHAR2(2000) := NULL
37 ,actual_attribute_code VARCHAR2(2000) := NULL
38 ,compareto_attribute_code VARCHAR2(2000) := NULL
39 ,format_id NUMBER := NULL
40 ,dimset_id NUMBER := NULL
41 ,dim1_short_name VARCHAR2(200) := NULL
42 ,dim2_short_name VARCHAR2(200) := NULL
43 ,dim3_short_name VARCHAR2(200) := NULL
44 ,dim4_short_name VARCHAR2(200) := NULL
45 ,dim5_short_name VARCHAR2(200) := NULL
46 ,dim6_short_name VARCHAR2(200) := NULL
47 ,dim7_short_name VARCHAR2(200) := NULL
48 ,actual_value VARCHAR2(2000) := NULL
49 ,target_value VARCHAR2(2000) := NULL
50 ,insert_update_flag VARCHAR2(1) := NULL
51 );
52
53 TYPE Kpi_Info_Rec_Tbl_Type IS TABLE OF Kpi_Info_Rec_Type
54 INDEX BY BINARY_INTEGER;
55
56 TYPE t_array_of_varchar2 IS TABLE OF VARCHAR2(32000)
57 INDEX BY BINARY_INTEGER;
58
59 /************************************************************************************
60 Get_Actual_Value by KPi
61 ************************************************************************************/
62 FUNCTION Get_Actual_Value_By_Kpi(
63 p_kpi_code IN NUMBER,
64 p_user_id IN VARCHAR2,
65 p_responsibility_id IN VARCHAR2
66 ) RETURN VARCHAR2;
67 PRAGMA RESTRICT_REFERENCES(Get_Actual_Value_By_Kpi, WNDS);
68
69 /************************************************************************************
70 Get_Actual_Value by KPi Analysis option Comb
71 ************************************************************************************/
72 FUNCTION Get_Actual_Value(
73 p_kpi_code IN NUMBER,
74 p_analysis_option0 IN NUMBER,
75 p_analysis_option1 IN NUMBER,
76 p_analysis_option2 IN NUMBER,
77 p_series_id IN NUMBER,
78 p_user_id IN VARCHAR2,
79 p_responsibility_id IN VARCHAR2
80 ) RETURN VARCHAR2;
81 PRAGMA RESTRICT_REFERENCES(Get_Actual_Value, WNDS);
82
83 /************************************************************************************
84 Get_Current_Period by KPi
85 ************************************************************************************/
86 FUNCTION Get_Current_Period_By_Kpi(
90 /************************************************************************************
87 p_kpi_code IN NUMBER
88 ) RETURN VARCHAR2;
89
91 Get_Current_Period by KPi Analysis option Comb
92 ************************************************************************************/
93 FUNCTION Get_Current_Period(
94 p_kpi_code IN NUMBER,
95 p_analysis_option0 IN NUMBER,
96 p_analysis_option1 IN NUMBER,
97 p_analysis_option2 IN NUMBER,
98 p_series_id IN NUMBER
99 ) RETURN VARCHAR2;
100
104 FUNCTION Get_DBI_Current_Period(
101 /************************************************************************************
102 Get_DBI_Current_Period
103 ************************************************************************************/
105 p_dimension_short_name IN VARCHAR2,
106 p_level_short_name IN VARCHAR2,
107 p_as_of_date IN VARCHAR2
108
109 ) RETURN VARCHAR2;
110
111 /************************************************************************************
112 Get Target Value by KPi
113 ************************************************************************************/
114 FUNCTION Get_Target_Value_By_Kpi(
115 p_kpi_code IN NUMBER,
116 p_user_id IN VARCHAR2,
117 p_responsibility_id IN VARCHAR2
118 ) RETURN VARCHAR2;
119 PRAGMA RESTRICT_REFERENCES(Get_Target_Value_By_Kpi, WNDS);
120
121 /************************************************************************************
122 Get Target Value by KPi Analysis option Comb
123 ************************************************************************************/
124 FUNCTION Get_Target_Value(
125 p_kpi_code IN NUMBER,
126 p_analysis_option0 IN NUMBER,
127 p_analysis_option1 IN NUMBER,
128 p_analysis_option2 IN NUMBER,
129 p_series_id IN NUMBER,
130 p_user_id IN VARCHAR2,
131 p_responsibility_id IN VARCHAR2
132 ) RETURN VARCHAR2;
133 PRAGMA RESTRICT_REFERENCES(Get_Target_Value, WNDS);
134
135 /************************************************************************************
136 Populate bsc_bis_measures_data for the given tab
140 p_page_id IN VARCHAR2,
137 ************************************************************************************/
138 PROCEDURE Populate_Measure_Data(
139 p_tab_id IN NUMBER,
141 p_user_id IN VARCHAR2,
142 p_responsibility_id IN VARCHAR2,
143 p_caching_key IN VARCHAR2,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2
147 );
148
149
150 END BSC_BIS_WRAPPER_PUB;