[Home] [Help]
PACKAGE: APPS.BIS_INDICATOR_REGION_UI_PVT
Source
1 package bis_indicator_region_ui_pvt as
2 /* $Header: BISVRUIS.pls 120.1 2005/10/28 08:17:36 visuri noship $ */
3 c_counter CONSTANT pls_integer := 150;
4 c_amp CONSTANT varchar2(1) := '&';
5 c_OR CONSTANT varchar2(2) := '||';
6 -- mdamle 01/15/2001
7 c_hash CONSTANT varchar2(1) := '#';
8 c_at CONSTANT varchar2(1) := '@';
9 c_plus CONSTANT varchar2(1) := '+';
10
11 c_minus CONSTANT varchar2(1) := '-';
12 c_asterisk CONSTANT varchar2(1) := '*';
13
14 -- gramasam 24/11/03
15 c_encode_space CONSTANT varchar2(3) := '%20';
16
17 -- Declare strings for all the prompts or labels
18 c_available_tarlevels CONSTANT varchar2(32000) := BIS_UTILITIES_PVT.getPrompt('BIS_AVAILABLE_TARLEVELS');
19 c_tarlevel_setup CONSTANT varchar2(32000) := BIS_UTILITIES_PVT.getPrompt('BIS_TARLEVEL_SETUP');
20 c_dim_and_plan CONSTANT varchar2(32000) := BIS_UTILITIES_PVT.getPrompt('BIS_DIM_AND_PLAN');
21 c_display_homepage CONSTANT varchar2(32000) := BIS_UTILITIES_PVT.getPrompt('BIS_DISPLAY_HOMEPAGE');
22 --c_tarlevels_homepage CONSTANT varchar2(32000) := BIS_UTILITIES_PVT.getPrompt('BIS_TARLEVELS_HOMEPAGE');
23 c_tarlevels_homepage CONSTANT varchar2(32000) := BIS_UTILITIES_PVT.getPrompt('BIS_MEASURE_HOMEPAGE');
24 c_displabel CONSTANT varchar2(32000) := BIS_UTILITIES_PVT.getPrompt('BIS_DISPLABEL');
25 c_plan CONSTANT varchar2(32000) := BIS_UTILITIES_PVT.getPrompt('BIS_PLAN');
26 c_organization CONSTANT varchar2(32000) := BIS_UTILITIES_PVT.getPrompt('BIS_ORGANIZATION');
27 --c_tarlevel CONSTANT varchar2(32000) := BIS_UTILITIES_PVT.getPrompt('BIS_TARLEVEL');
28 c_tarlevel CONSTANT varchar2(32000) := BIS_UTILITIES_PVT.getPrompt('BIS_MEASURE');
29 c_choose CONSTANT varchar2(32000) := BIS_UTILITIES_PVT.getPrompt('BIS_CHOOSE');
30 c_cancel CONSTANT varchar2(32000) := BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL');
31
32 type object is RECORD (name varchar2(32000),
33 id varchar2(200));
34 type my_table_type is TABLE of varchar2(32000) INDEX BY BINARY_INTEGER;
35 --type Selected_Values_Tbl_Type is TABLE of varchar2(32000) INDEX BY BINARY_INTEGER;
36 type no_duplicates_tbl_Type is TABLE of object INDEX BY BINARY_INTEGER;
37
38
39 -- meastmon 05/10/2001
40 PROCEDURE getCurrentPeriodInfo(
41 p_ind_selection_id IN NUMBER,
42 p_target_level_id IN NUMBER,
43 p_time_dimension_level_id IN NUMBER,
44 x_current_period_id OUT NOCOPY VARCHAR2,
45 x_current_period_name OUT NOCOPY VARCHAR2
46 );
47
48 -- meastmon 05/14/2001
49 PROCEDURE getNextPeriodInfo(
50 p_ind_selection_id IN NUMBER,
51 p_target_level_id IN NUMBER,
52 p_time_dimension_level_id IN NUMBER,
53 p_current_period_id IN VARCHAR2,
54 p_current_period_name IN VARCHAR2,
55 x_next_period_id OUT NOCOPY VARCHAR2,
56 x_next_period_name OUT NOCOPY VARCHAR2
57 );
58
59 -- meastmon 05/14/2001
60 FUNCTION getTargetURL(
61 p_session_id IN pls_integer,
62 p_ind_selection_id IN NUMBER,
63 p_target_level_id IN NUMBER,
64 p_time_dimension_index IN NUMBER,
65 p_time_dimension_level_id IN NUMBER,
66 p_current_period_id IN VARCHAR2,
67 p_current_period_name IN VARCHAR2,
68 p_plan_id IN NUMBER
69 ) RETURN VARCHAR2;
70
71
72 procedure display( p_session_id in pls_integer default NULL
73 ,p_plug_id in pls_integer default NULL
74 ,p_display_name in varchar2 default NULL
75 ,p_delete in varchar2 default 'N');
76
77 procedure setIndicators( Z in pls_integer default NULL
78 ,p_selections_tbl in Selected_Values_Tbl_Type
79 ,p_back_url IN VARCHAR2
80 ,p_reference_path IN VARCHAR2
81 ,x_string OUT NOCOPY VARCHAR2);
82
83 procedure showDimensions( Z in pls_integer
84 ,p_indlevel in varchar2 default NULL
85 ,p_ind_level_id in pls_integer default NULL
86 ,p_displaylabels_tbl in Selected_Values_Tbl_Type
87 ,p_selections_tbl in Selected_Values_Tbl_Type
88 ,p_back_url IN VARCHAR2
89 ,p_reference_path IN VARCHAR2
90 ,x_str_object out nocopy CLOB
91 );
92
93 procedure strDimensions(W in varchar2 default NULL
94 ,Z in pls_integer
95 ,p_displaylabels_tbl in Selected_Values_Tbl_Type
96 ,p_back_url in VARCHAR2
97 ,p_reference_path in VARCHAR2);
98
99 procedure editDimensions(U in varchar2
100 ,Z in pls_integer
101 ,x_string out nocopy varchar2);
102
103 procedure removeDuplicates(p_original_tbl in no_duplicates_tbl_Type
104 -- ,p_value in pls_integer default NULL
105 ,p_value in varchar2 default NULL
106 ,x_unique_tbl out NOCOPY no_duplicates_tbl_Type);
107
108 PROCEDURE clearSelect
109 ( p_formName IN VARCHAR2
110 , p_elementTable IN BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
111 , x_clearString OUT NOCOPY VARCHAR2
112 );
113
114 PROCEDURE SetSetOfBookVar(
115 p_user_id IN integer
116 , p_formName IN VARCHAR2
117 , p_index IN VARCHAR2
118 , x_sobString OUT NOCOPY VARCHAR2
119 );
120
121 -- mdamle 01/15/2001
122 function getPerformanceMeasureName(
123 p_target_level_id IN number
124 ) return varchar2;
125
126 -- mdamle 01/15/2001
127 function getOrgSeqNum(
128 p_target_level_id IN number
129 ) return number;
130
131 -- mdamle 01/15/2001
132 function getTimeSeqNum(
133 p_target_level_id IN number
134 ) return number;
135
136 -- mdamle 01/15/2001
137 function getOrgLevelID(
138 p_target_level_id IN number
139 ) return number;
140
141 -- sbuenits 02/16/2001
142 FUNCTION region_content (
143 p_target_level_id IN NUMBER,
144 p_org_level_value IN VARCHAR2,
145 p_dimension1_level_value IN VARCHAR2,
146 p_dimension2_level_value IN VARCHAR2,
147 p_dimension3_level_value IN VARCHAR2,
148 p_dimension4_level_value IN VARCHAR2,
149 p_dimension5_level_value IN VARCHAR2,
150 p_dimension6_level_value IN VARCHAR2,
151 p_dimension7_level_value IN VARCHAR2,
152 p_plan_id IN NUMBER,
153 separator IN VARCHAR2
154 ) return VARCHAR2;
155
156 PROCEDURE pmr_content (
157 p_target_level_id IN NUMBER,
158 p_org_level_value IN VARCHAR2,
159 p_dimension1_level_value IN VARCHAR2,
160 p_dimension2_level_value IN VARCHAR2,
161 p_dimension3_level_value IN VARCHAR2,
162 p_dimension4_level_value IN VARCHAR2,
163 p_dimension5_level_value IN VARCHAR2,
164 p_dimension6_level_value IN VARCHAR2,
165 p_dimension7_level_value IN VARCHAR2,
166 p_plan_id IN NUMBER,
167 actual_id OUT NOCOPY NUMBER,
168 actual OUT NOCOPY NUMBER,
169 target_id OUT NOCOPY NUMBER,
170 target OUT NOCOPY NUMBER,
171 range1_high OUT NOCOPY NUMBER,
172 range1_low OUT NOCOPY NUMBER,
173 range2_high OUT NOCOPY NUMBER,
174 range2_low OUT NOCOPY NUMBER,
175 role1_id OUT NOCOPY NUMBER,
176 role2_id OUT NOCOPY NUMBER,
177 time_level_value_id OUT NOCOPY VARCHAR2,
178 status OUT NOCOPY VARCHAR2,
179 is_in_range OUT NOCOPY VARCHAR2
180 );
181 ---added build_html_banner def here
182 --rmohanty
183 PROCEDURE Build_HTML_Banner
184 ( title IN VARCHAR2,
185 help_target IN VARCHAR2
186 );
187
188 PROCEDURE Build_HTML_Banner
189 ( rdf_filename IN VARCHAR2,
190 title IN VARCHAR2,
191 menu_link IN VARCHAR2,
192 related_reports_exist IN BOOLEAN,
193 parameter_page IN BOOLEAN,
194 HTML_Banner OUT NOCOPY VARCHAR2
195 );
196
197 PROCEDURE Build_HTML_Banner
198 ( rdf_filename IN VARCHAR2,
199 title IN VARCHAR2,
200 menu_link IN VARCHAR2,
201 HTML_Banner OUT NOCOPY VARCHAR2
202 );
203
204 PROCEDURE Build_HTML_Banner (icx_report_images IN VARCHAR2,
205 more_info_directory IN VARCHAR2,
206 nls_language_code IN VARCHAR2,
207 title IN VARCHAR2,
208 menu_link IN VARCHAR2,
209 HTML_Banner OUT NOCOPY VARCHAR2);
210
211 PROCEDURE Build_HTML_Banner (icx_report_images IN VARCHAR2,
212 more_info_directory IN VARCHAR2,
213 nls_language_code IN VARCHAR2,
214 title IN VARCHAR2,
215 menu_link IN VARCHAR2,
216 related_reports_exist IN BOOLEAN,
217 parameter_page IN BOOLEAN,
218 HTML_Banner OUT NOCOPY VARCHAR2);
219
220 -- overlapping procedures that produce banner with two icons
221
222 PROCEDURE Build_HTML_Banner( title IN VARCHAR2,
223 help_target IN VARCHAR2,
224 icon_show IN BOOLEAN);
225
226 PROCEDURE Build_HTML_Banner
227 ( rdf_filename IN VARCHAR2,
228 title IN VARCHAR2,
229 menu_link IN VARCHAR2,
230 icon_show IN BOOLEAN,
231 HTML_Banner OUT NOCOPY VARCHAR2
232 );
233
234 PROCEDURE Build_HTML_Banner
235 ( rdf_filename IN VARCHAR2,
236 title IN VARCHAR2,
237 menu_link IN VARCHAR2,
238 related_reports_exist IN BOOLEAN,
239 parameter_page IN BOOLEAN,
240 icon_show IN BOOLEAN,
241 HTML_Banner OUT NOCOPY VARCHAR2
242 );
243
244 PROCEDURE Build_HTML_Banner (icx_report_images IN VARCHAR2,
245 more_info_directory IN VARCHAR2,
246 nls_language_code IN VARCHAR2,
247 title IN VARCHAR2,
248 menu_link IN VARCHAR2,
249 icon_show IN BOOLEAN,
250 HTML_Banner OUT NOCOPY VARCHAR2);
251
252 PROCEDURE Build_HTML_Banner (icx_report_images IN VARCHAR2,
253 more_info_directory IN VARCHAR2,
254 nls_language_code IN VARCHAR2,
255 title IN VARCHAR2,
256 menu_link IN VARCHAR2,
257 related_reports_exist IN BOOLEAN,
258 parameter_page IN BOOLEAN,
259 icon_show IN BOOLEAN,
260 HTML_Banner OUT NOCOPY VARCHAR2);
261
262 -- End of overlapping procedures declarations
263 PROCEDURE Get_Translated_Icon_Text (Icon_Code IN VARCHAR2,
264 Icon_Meaning OUT NOCOPY VARCHAR2,
265 Icon_Description OUT NOCOPY VARCHAR2);
266 FUNCTION Get_Images_Server RETURN VARCHAR2;
267
268 FUNCTION Get_NLS_Language RETURN VARCHAR2;
269
270 PROCEDURE Get_Image_file_structure (icx_report_images IN VARCHAR2,
271 nls_language_code IN VARCHAR2,
272 report_image OUT NOCOPY VARCHAR2);
273
274
275 PROCEDURE getAKRegionItemLongLabel (akRegionItemData IN VARCHAR2,
276 longlabel OUT NOCOPY VARCHAR2);
277 ---
278
279 --===========================================================
280 -- juwang bug#2184804
281 --===========================================================
282 FUNCTION use_current_period(
283 p_target_rec IN BIS_TARGET_PUB.Target_Rec_Type
284 ,p_time_dimension_index IN NUMBER
285 ,p_current_period_id IN VARCHAR2
286 ,x_last_period_id OUT NOCOPY VARCHAR2
287 ) RETURN BOOLEAN;
288
289
290 --============================================================
291 FUNCTION getAKFormatValue(
292 p_measure_id IN NUMBER
293 ,p_val IN NUMBER
294 ) RETURN VARCHAR2;
295
296
297 end bis_indicator_region_ui_pvt;