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.
PACKAGE: APPS.BIS_PMF_PORTLET_UTIL

Source


1 package BIS_PMF_PORTLET_UTIL as
2 /* $Header: BISPDBPS.pls 120.0 2005/06/01 18:08:52 appldev noship $ */
3 --
4 -- Data Types: Records
5 --
6 TYPE measure_source_rec_type IS RECORD (
7   measure_id  		NUMBER := NULL
8 , region_code  		VARCHAR2(240):=NULL
9 , region_attribute 	VARCHAR2(240):=NULL
10 , comp_region_code  	VARCHAR2(240):=NULL
11 , comp_region_attribute VARCHAR2(240):=NULL
12 , function_name  	VARCHAR2(240):=NULL
13 , increase_in_measure  	VARCHAR2(1):=NULL
14 , enable_link           VARCHAR2(1):='N' -- 2440739
15 );
16 
17 
18 TYPE measure_source_tbl_type IS TABLE OF measure_source_rec_type INDEX BY BINARY_INTEGER;
19 
20 
21 TYPE number_scale_rec_type IS RECORD( -- For auto scaling
22   symbol_thousand VARCHAR2(100) := NULL
23  ,symbol_million  VARCHAR2(100) := NULL
24 );
25 
26 --===========================================================
27 
28 
29 c_amp       CONSTANT varchar2(1) := '&';
30 
31 c_I CONSTANT VARCHAR2(1) := 'I';
32 c_IP CONSTANT VARCHAR2(2) := 'IP';
33 c_F CONSTANT VARCHAR2(1) := 'F';
34 c_FP CONSTANT VARCHAR2(2) := 'FP';
35 c_K CONSTANT VARCHAR2(1) := 'K';
36 c_M CONSTANT VARCHAR2(1) := 'M';
37 c_B CONSTANT VARCHAR2(1) := 'B';
38 c_T CONSTANT VARCHAR2(1) := 'T';
39 
40 --Auto Scaling
41 c_ten_million_round CONSTANT NUMBER := 9999500;
42 c_ten_thousand CONSTANT NUMBER := 10000;
43 c_auto_fmt CONSTANT VARCHAR2(10) := '9G990';
44 c_dc_number_format CONSTANT VARCHAR2(2) := '.,';
45 c_dec_group_sep CONSTANT VARCHAR2(2) := 'DG';
46 c_enable_auto_scale CONSTANT VARCHAR2(1) := 'Y';
47 c_disable_auto_scale CONSTANT VARCHAR2(1) := 'N';
48 c_AS CONSTANT VARCHAR2(2) := 'AU'; -- constant for auto scale currency
49 c_sym_thousand_msg VARCHAR2(100) := 'BIS_PMF_SYM_THOUSAND'; -- symbol for thousand - 'K'
50 c_sym_million_msg VARCHAR2(100) := 'BIS_PMF_SYM_MILLION'; -- symbol for million - 'M'
51 
52 -- !!! NLS Issue
53 c_thousand CONSTANT NUMBER := 1000;
54 c_million CONSTANT NUMBER := 1000000;
55 c_billion CONSTANT NUMBER := 1000000000;
56 c_trillion CONSTANT NUMBER := 1000000000000;
57 
58 c_eq  CONSTANT VARCHAR2(1) := '=';
59 c_percent  CONSTANT VARCHAR2(1) := '%';
60 c_squote  CONSTANT VARCHAR2(2) := '''';
61 
62 
63 --==========================================================================
64 
65 FUNCTION getValue(
66   p_key        IN VARCHAR2
67  ,p_parameters IN VARCHAR2
68  ,p_delimiter  IN VARCHAR2 := c_amp
69 ) RETURN VARCHAR2;
70 
71 
72 --============================================================
73 
74 FUNCTION get_pl_value(
75   p_key        IN VARCHAR2
76  ,p_parameters IN VARCHAR2
77 ) RETURN VARCHAR2;
78 
79 
80 
81 --============================================================
82 FUNCTION get_function_name(
83   p_reference_path IN VARCHAR2
84   ) RETURN VARCHAR2;
85 
86 
87 --============================================================
88 FUNCTION has_demo_rows(
89   p_plug_id IN pls_integer
90 ) RETURN BOOLEAN;
91 
92 
93 --============================================================
94 FUNCTION is_demo_on RETURN BOOLEAN;
95 
96 --===========================================================
97 FUNCTION get_row_style(
98   p_row_style IN VARCHAR2
99 ) RETURN VARCHAR2;
100 
101 
102 
103 --===========================================================
104 FUNCTION has_customized_rows(
105   p_plug_id       IN PLS_INTEGER
106  ,p_user_id       IN PLS_INTEGER
107  ,x_owner_user_id OUT NOCOPY PLS_INTEGER
108 ) RETURN BOOLEAN;
109 
110 
111 --===========================================================
112 FUNCTION is_authorized(
113   p_cur_user_id     IN PLS_INTEGER
114  ,p_target_level_id IN PLS_INTEGER
115  ,x_resp_id         OUT NOCOPY VARCHAR2
116 ) RETURN BOOLEAN;
117 
118 
119 --===========================================================
120 FUNCTION is_authorized(
121   p_cur_user_id     IN PLS_INTEGER
122  ,p_target_level_id IN PLS_INTEGER
123 ) RETURN BOOLEAN;
124 
125 
126 
127 --===========================================================
128 FUNCTION has_rows(
129   p_plug_id       IN PLS_INTEGER
130  ,x_owner_user_id OUT NOCOPY PLS_INTEGER
131 ) RETURN BOOLEAN;
132 
133 
134 --===========================================================
135 PROCEDURE clean_user_ind_sel(
136   p_plug_id IN NUMBER
137 ) ;
138 
139 
140 --============================================================
141 FUNCTION getAKFormatValue(
142   p_measure_id IN NUMBER
143  ,p_val        IN NUMBER
144   ) RETURN VARCHAR2;
145 
146 
147 --=============================================================
148 
149 FUNCTION getAKFormatValue(
150   p_measure_id     IN NUMBER
151  ,p_region_code    IN VARCHAR2
152  ,p_attribute_code IN VARCHAR2
153  ,p_val            IN NUMBER
154  ) RETURN VARCHAR2;
155 
156 --===========================================================
157 
158 PROCEDURE get_rank_level_info(
159   p_dim_level_sname      IN VARCHAR2
160   ,p_is_debug            IN BOOLEAN
161   ,x_view_name           OUT NOCOPY VARCHAR2
162   ,x_is_pa_child_related OUT NOCOPY BOOLEAN
163   ,x_is_date_present     OUT NOCOPY BOOLEAN
164   ,x_debug_text          IN OUT NOCOPY VARCHAR2
165 );
166 
167 --===========================================================
168 
169 PROCEDURE get_rank_level_info(
170   p_dim_level_sname      IN VARCHAR2
171  ,x_view_name           OUT NOCOPY VARCHAR2
172  ,x_is_pa_child_related OUT NOCOPY VARCHAR2 -- 'Y' or 'N'
173  ,x_is_date_present     OUT NOCOPY VARCHAR2 -- 'Y' or 'N'
174 );
175 
176 --===========================================================
177 
178 PROCEDURE get_parent_value(
179   p_view_name        IN VARCHAR2
180  ,p_current_value_id IN VARCHAR2
181  ,p_as_of_date       IN DATE
182  ,x_parent_id        OUT NOCOPY VARCHAR2
183  ,x_parent_value     OUT NOCOPY VARCHAR2
184 );
185 
186 --===========================================================
187 
188 PROCEDURE get_parent_value(
189   p_view_name        IN VARCHAR2
190  ,p_current_value_id IN VARCHAR2
191  ,p_is_debug         IN BOOLEAN
192  ,p_as_of_date       IN DATE
193  ,p_is_date_present  IN BOOLEAN
194  ,x_parent_id        OUT NOCOPY VARCHAR2
195  ,x_parent_value     OUT NOCOPY VARCHAR2
196  ,x_debug_text       IN OUT NOCOPY VARCHAR2
197 );
198 --===========================================================
199 
200 PROCEDURE retrieve_dim_level_value(
201   p_dim_level_id          IN NUMBER
202  ,p_dim_level_value_id    IN VARCHAR2
203  ,x_dim_level_value_name  OUT NOCOPY VARCHAR2
204  ,x_return_status         OUT NOCOPY VARCHAR2
205 );
206 
207 --============================================================
208 PROCEDURE get_region_code(
209   p_measure_id     IN NUMBER
210  ,x_region_code    OUT NOCOPY VARCHAR2
211  ,x_attribute_code OUT NOCOPY VARCHAR2
212 );
213 
214 
215 --============================================================
216 PROCEDURE get_region_code(
217   p_measure_id  IN NUMBER
218  ,x_msource_rec OUT NOCOPY BIS_PMF_PORTLET_UTIL.measure_source_rec_type
219 );
220 
221 --============================================================
222 FUNCTION get_formatted_value(
223    p_val                 IN NUMBER
224   ,p_display_format      IN VARCHAR2
225   ,p_display_type        IN VARCHAR2
226   ,p_enable_auto_scaling IN VARCHAR2
227   ,p_number_scale_rec    IN number_scale_rec_type --2615025
228   ,x_scale               OUT NOCOPY VARCHAR2
229 ) RETURN VARCHAR2;
230 
231 --============================================================
232 PROCEDURE get_ak_display_format(
233   p_region_code    IN VARCHAR2
234  ,p_attribute_code IN VARCHAR2
235  ,x_display_format OUT NOCOPY VARCHAR2
236  ,x_display_type   OUT NOCOPY VARCHAR2
237 );
238 
239 --==========================================================================
240 
241 FUNCTION isFunctionFormat(
242   p_val IN VARCHAR2
243 ) RETURN BOOLEAN;
244 
245 --===========================================================
246 FUNCTION is_get_fnd_profile(
247   p_fnd_profile_name IN VARCHAR2
248  ,p_default IN VARCHAR2
249 ) RETURN BOOLEAN;
250 
251 --============================================================
252 PROCEDURE add_debug_text(
253   p_text       IN VARCHAR
254  ,x_debug_text IN OUT NOCOPY VARCHAR2
255 );
256 
257 --============================================================
258 FUNCTION getAutoScaleValue(
259    p_val              IN NUMBER
260   ,p_number_scale_rec IN number_scale_rec_type
261   ,x_scale            OUT NOCOPY VARCHAR2
262 ) RETURN VARCHAR2;
263 
264 --=============================================================
265 FUNCTION get_nls_numeric_format(
266   p_val         IN NUMBER
267  ,p_format_mask IN VARCHAR2
268 )RETURN VARCHAR2;
269 --============================================================
270 
271 FUNCTION exec(
272   p_call IN VARCHAR2
273 ) RETURN VARCHAR2;
274 
275 --===========================================================
276 FUNCTION get_fnd_profile_value(
277   p_fnd_profile_name IN VARCHAR2
278  ,p_default IN VARCHAR2 := NULL
279 ) RETURN VARCHAR2;
280 
281 --============================================================
282 
283 FUNCTION getFormatValue(
284   p_val         IN NUMBER
285  ,p_format_mask IN VARCHAR2
286   ) RETURN VARCHAR2;
287 --============================================================
288 FUNCTION get_application_name(
289   p_type       IN VARCHAR2
290  ,p_parameters IN VARCHAR2
291 ) RETURN VARCHAR2;
292 
293 --============================================================
294 FUNCTION get_application_id(
295   p_type       IN VARCHAR2
296  ,p_parameters IN VARCHAR2
297 ) RETURN VARCHAR2;
298 
299 
300 end BIS_PMF_PORTLET_UTIL;