1 package BIS_PORTLET_PMREGION as
2 /* $Header: BISPPMRS.pls 120.1 2005/10/28 08:15:25 visuri noship $ */
3
4 c_amp CONSTANT varchar2(1) := '&';
5 -- *****************************************************
6 -- Main - entry point
7 -- This is the same procedure in BIS_LOV_PUB
8 -- but working for Oracle Portal
9 -- ****************************************************
10 /*procedure bis_lov_pub_main
11 ( p_procname in varchar2 default NULL
12 , p_qrycnd in varchar2 default NULL
13 , p_jsfuncname in varchar2 default NULl
14 , p_startnum in pls_integer default NULL
15 , p_rowcount in pls_integer default NULL
16 , p_totalcount in pls_integer default NULL
17 , p_search_str in varchar2 default NULL
18 --, p_sql in varchar2 default NULL
19 , p_dim_level_id in number default NULL
20 , p_user_id in pls_integer default NULL
21 , p_sqlcount in varchar2 default NULL
22 , p_coldata in BIS_LOV_PUB.colinfo_table
23 , p_rel_dim_lev_id in varchar2 default NULL
24 , p_rel_dim_lev_val_id in varchar2 default NULL
25 , p_rel_dim_lev_g_var in varchar2 default NULL
26 , Z in pls_integer default NULL
27 );*/
28
29 procedure build_html_banner (
30 title IN VARCHAR2,
31 help_target IN VARCHAR2,
32 menu_link IN VARCHAR2
33 );
34
35 PROCEDURE build_html_banner ( ------------ VERSION 5 (definition of)
36 icx_report_images IN VARCHAR2,
37 more_info_directory IN VARCHAR2,
38 nls_language_code IN VARCHAR2,
39 title IN VARCHAR2,
40 menu_link IN VARCHAR2,
41 related_reports_exist IN BOOLEAN,
42 parameter_page IN BOOLEAN,
43 HTML_Banner OUT NOCOPY VARCHAR2
44 );
45
46 /**
47 * Deregister a usage of a portlet on a page.
48 *
49 * The framework will call upon this function when a portlet is
50 * removed from a page. This provides the Portlet an opportunity to
51 * perform instance-level cleanup such as the removal of end-user
52 * and default customizations.
53 *
54 * @param p_reference_path Reference to instance customization
55 */
56 PROCEDURE deregister(
57 p_reference_path in VARCHAR2
58 );
59
60
61
62 -- *******************************************************
63 -- Procedure creates the SQL query
64 -- This is the same procedure in BIS_INTERMEDIATE_LOV_PVT
65 -- but working for Oracle Portal
66 -- *******************************************************
67 /*procedure dim_level_values_query
68 (p_qrycnd in varchar2 default NULL
69 ,p_jsfuncname in varchar2 default NULL
70 ,p_startnum in pls_integer default NULL
71 ,p_rowcount in pls_integer default NULL
72 ,p_totalcount in pls_integer default NULL
73 ,p_search_str in varchar2 default NULL
74 ,Z in pls_integer default NULL
75 ,p_dim1_lbl in varchar2 default NULL -- 1797465
76 );*/
77
78
79 /**
80 * Display portlet
81 */
82 procedure display(
83 p_session_id in NUMBER,
84 p_plug_id in pls_integer,
85 p_user_id in integer
86 ,x_html_buffer OUT NOCOPY VARCHAR2
87 ,x_html_clob OUT NOCOPY CLOB
88 );
89
90
91 -- ********************************************************
92 -- Procedure that allows Editing/renaming of indicators
93 -- *********************************************************
94 /*procedure editDimensions(
95 U in varchar2,
96 Z in pls_integer
97 );*/
98
99
100
101 -- ****************************************************
102 -- Frame that paints the LOVdata
103 -- This is the same procedure in BIS_LOV_PUB.lov_data
104 -- but working for Oracle Portal
105 -- ****************************************************
106 /*procedure lov_data
107 ( p_startnum in pls_integer default NULL
108 , p_rowcount in pls_integer default NULL
109 , p_totalavailable in pls_integer default NULL
110 --, p_sql in varchar2 default NULL
111 , p_dim_level_id in number default NULL
112 , p_user_id in pls_integer default NULL
113 , p_search_str in varchar2 default NULL
114 , p_head in BIS_LOV_PUB.colstore_table
115 , p_value in BIS_LOV_PUB.colstore_table
116 , p_link in BIS_LOV_PUB.colstore_table
117 , p_disp in BIS_LOV_PUB.colstore_table
118 , p_rel_dim_lev_id in varchar2 default NULL
119 , p_rel_dim_lev_val_id in varchar2 default NULL
120 , p_rel_dim_lev_g_var in varchar2 default NULL
121 , Z in pls_integer default NULL
122 );*/
123
124
125
126 -- *********************************************
127 -- Procedure to choose the Indicator levels
128 -- *********************************************
129 /*procedure setIndicators(
130 Z in pls_integer
131 ,p_back_url in varchar2
132 ,p_selections_tbl IN Selected_Values_Tbl_Type
133 );*/
134
135 /*procedure setIndicators(
136 Z in pls_integer
137 ,p_back_url in varchar2
138 ,p_selections_tbl IN Selected_Values_Tbl_Type
139 ,p_reference_path IN VARCHAR2
140 );*/
141
142 PROCEDURE SetSetOfBookVar(
143 p_user_id IN integer
144 , p_formName IN VARCHAR2
145 , p_index IN VARCHAR2
146 , x_sobString OUT NOCOPY VARCHAR2
147 );
148
149
150
151 -- ************************************************************
152 -- Show the Dimensions Page
153 -- ************************************************************
154 /*procedure showDimensions( Z in PLS_INTEGER
155 ,p_back_url in VARCHAR2
156 ,p_indlevel in VARCHAR2 default NULL
157 ,p_ind_level_id in PLS_INTEGER default NULL
158 ,p_displaylabels_tbl in Selected_Values_Tbl_Type
159 ,p_selections_tbl in Selected_Values_Tbl_Type
160 ,p_reference_path IN VARCHAR2
161 );*/
162
163
164 /*procedure strDimensions(
165 W in varchar2 DEFAULT NULL
166 ,Z in pls_integer
167 ,p_back_url in varchar2
168 ,p_displaylabels_tbl in Selected_Values_Tbl_Type
169 ,p_reference_path IN VARCHAR2
170 );*/
171
172 --============================================================
173 -- Following apis are used for pre-seeded portlets implmentations
174 -- 12-DEC-01 juwang modified
175 --============================================================
176
177 --============================================================
178 FUNCTION get_menu_name(
179 p_reference_path IN VARCHAR2
180 ) RETURN VARCHAR2;
181
182 --============================================================
183 FUNCTION get_menu_name(
184 p_plug_id IN NUMBER
185 ) RETURN VARCHAR2;
186
187
188 --============================================================
189 FUNCTION get_functionid_from_refpath(
190 p_reference_path IN VARCHAR2
191 ) RETURN NUMBER;
192
193 --============================================================
194
195 FUNCTION getTargetLevelId(
196 p_parameters IN VARCHAR2
197 ,x_return_status OUT NOCOPY VARCHAR2
198 ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
199 ) RETURN NUMBER;
200
201
202 --============================================================
203 FUNCTION getDefaultPlanId(
204 x_return_status OUT NOCOPY VARCHAR2
205 ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
206 ) RETURN NUMBER;
207
208
209
210 --============================================================
211 FUNCTION getPlanId(
212 p_parameters IN VARCHAR2
213 ,p_default_plan_id IN NUMBER
214 ,x_return_status OUT NOCOPY VARCHAR2
215 ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
216 ) RETURN NUMBER;
217
218
219
220 --============================================================
221 PROCEDURE saveAsMeasures(
222 p_parameters IN VARCHAR2
223 ,p_plug_id IN NUMBER
224 ,p_user_id IN NUMBER
225 ,p_user_fname IN VARCHAR2
226 ,p_default_plan_id IN NUMBER
227 ,x_return_status OUT NOCOPY VARCHAR2
228 ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
229 );
230
231 --============================================================
232 PROCEDURE copyMeasureDefs(
233 p_reference_path IN VARCHAR2
234 ,p_plug_id IN NUMBER
235 ,p_user_id IN NUMBER
236 ,x_return_status OUT NOCOPY VARCHAR2
237 ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
238 );
239
240
241 --============================================================
242 FUNCTION createParameters(
243 p_ind_sel IN NUMBER
244 ) RETURN VARCHAR2;
245
246
247
248
249 --===========================================================
250 FUNCTION use_current_period(
251 p_target_rec IN BIS_TARGET_PUB.Target_Rec_Type
252 ,p_time_dimension_index IN NUMBER
253 ,p_current_period_id IN VARCHAR2
254 ,x_last_period_id OUT NOCOPY VARCHAR2
255 ) RETURN BOOLEAN;
256
257
258
259 --===========================================================
260 PROCEDURE insert_row(
261 p_plug_id IN NUMBER
262 ,p_seq_id IN NUMBER
263 ,p_label IN VARCHAR2
264 ,p_status IN NUMBER
265 ,p_value IN VARCHAR2
266 ,p_change IN VARCHAR2
267 ,p_arrow IN NUMBER
268 ,p_user_id IN NUMBER
269 ,x_return_status OUT NOCOPY VARCHAR2
270 );
271
272
273 --===========================================================
274 PROCEDURE insert_row(
275 p_plug_id IN NUMBER
276 ,p_seq_id IN NUMBER
277 ,p_label IN VARCHAR2
278 ,p_param_data IN VARCHAR2
279 ,p_user_id IN NUMBER
280 ,x_return_status OUT NOCOPY VARCHAR2
281 );
282
283 --===========================================================
284
285 PROCEDURE free_clob(
286 x_clob IN OUT NOCOPY CLOB
287 );
288
289
290 --===========================================================
291 -- end of change by juwang
292 --===========================================================
293
294 PROCEDURE get_pm_portlet_html(
295 p_plug_id IN INTEGER
296 ,p_reference_path IN VARCHAR2
297 ,x_html_buffer OUT NOCOPY VARCHAR2
298 ,x_html_clob OUT NOCOPY CLOB
299 );
300
301 end BIS_PORTLET_PMREGION;