[Home] [Help]
PACKAGE: APPS.BIS_PMV_PARAMETERS_PVT
Source
1 package BIS_PMV_PARAMETERS_PVT AUTHID CURRENT_USER as
2 /* $Header: BISVPARS.pls 120.2 2006/03/27 12:53:21 nbarik noship $ */
3 -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \
4 -- dbdrv: checkfile(115.49=120.2):~PROD:~PATH:~FILE
5
6 /*
7 REM +=======================================================================+
8 REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |
9 REM | All rights reserved. |
10 REM +=======================================================================+
11 REM | FILENAME |
12 REM | BISVPARS.pls |
13 REM | |
14 REM | DESCRIPTION |
15 REM | This is the Parameters Pkg. for PMV. |
16 REM | |
17 REM | HISTORY |
18 REM | aleung, 09/21/2001, Initial Creation |
19 REM | nkishore, 12/10/2002, Added copy_ses_to_def_parameters |
20 REM | nkishore, 19/08/2003, BugFix 3099789 copy_time_params |
21 REM | nbarik 10/21/03 Bug Fix 3201277 |
22 REM | nbarik 02/19/04 Bug Fix 3441967 |
23 REM +=======================================================================+
24 */
25
26 G_ALL varchar2(3) := 'All';
27 ROLLING_DIMENSION_DESCRIPTION VARCHAR2(18):= '~ROLLING_DIMENSION';
28
29 TYPE time_parameter_rec_type IS RECORD
30 (parameter_name VARCHAR2(32000)
31 ,parameter_label VARCHAR2(32000)
32 ,from_value VARCHAR2(32000)
33 ,to_value VARCHAR2(32000)
34 ,from_description VARCHAR2(32000)
35 ,to_description VARCHAR2(32000)
36 ,dimension VARCHAR2(32000)
37 ,from_period DATE
38 ,to_period DATE
39 ,org_name VARCHAR2(32000)
40 ,org_value VARCHAR2(32000)
41 ,required_flag VARCHAR2(1)
42 ,default_flag VARCHAR2(1)
43 ,id_flag VARCHAR2(1)
44 );
45 TYPE time_parameter_tbl_type IS TABLE OF time_parameter_rec_type INDEX BY BINARY_INTEGER;
46
47 TYPE parameter_rec_type IS RECORD
48 (parameter_name VARCHAR2(32000)
49 ,parameter_label VARCHAR2(32000)
50 ,parameter_value VARCHAR2(32000)
51 ,parameter_description VARCHAR2(32000)
52 ,operator VARCHAR2(32000)
53 ,dimension VARCHAR2(32000)
54 ,lov_where VARCHAR2(2000)
55 ,period_date DATE
56 ,required_flag VARCHAR2(1)
57 ,default_flag VARCHAR2(1)
58 ,hierarchy_flag VARCHAR2(1)
59 ,id_flag VARCHAR2(1)
60 );
61 TYPE parameter_tbl_type IS TABLE OF parameter_rec_type INDEX BY BINARY_INTEGER;
62
63 TYPE parameter_group_rec_type IS RECORD
64 (
65 parameter_number NUMBER
66 , dimension VARCHAR2(80)
67 , attribute_name VARCHAR2(80)
68 -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
69 , lov_where VARCHAR2(150)
70 );
71 TYPE parameter_group_tbl_type IS TABLE OF parameter_group_rec_type INDEX BY BINARY_INTEGER;
72
73 PROCEDURE COPY_REMAINING_DEF_PARAMETERS
74 (pFunctionName IN VARCHAR2
75 ,pUserId IN VARCHAR2
76 ,pSessionId IN VARCHAR2
77 ,x_return_status OUT NOCOPY VARCHAR2
78 ,x_msg_count OUT NOCOPY NUMBER
79 ,x_msg_data OUT NOCOPY VARCHAR2
80 ) ;
81
82 --nkishore Customize UI Copy to Default Parameters
83 PROCEDURE COPY_SES_TO_DEF_PARAMETERS
84 (pFunctionName IN VARCHAR2
85 ,pUserId IN VARCHAR2
86 ,pSessionId IN VARCHAR2
87 ,x_return_status OUT NOCOPY VARCHAR2
88 ,x_msg_count OUT NOCOPY NUMBER
89 ,x_msg_data OUT NOCOPY VARCHAR2
90 );
91
92 PROCEDURE VALIDATE_AND_SAVE
93 (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
94 ,p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type
95 ,x_return_status OUT NOCOPY VARCHAR2
96 ,x_msg_count OUT NOCOPY NUMBER
97 ,x_msg_data OUT NOCOPY VARCHAR2
98 );
99
100 PROCEDURE VALIDATE_AND_SAVE_TIME
101 (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
102 ,p_time_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.time_parameter_rec_type
103 ,x_return_status OUT NOCOPY VARCHAR2
104 ,x_msg_count OUT NOCOPY NUMBER
105 ,x_msg_data OUT NOCOPY VARCHAR2
106 );
107
108 PROCEDURE VALIDATE_NONTIME_PARAMETER
109 (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
110 ,p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type
111 ,x_valid OUT NOCOPY VARCHAR2
112 ,x_return_status OUT NOCOPY VARCHAR2
113 ,x_msg_count OUT NOCOPY NUMBER
114 ,x_msg_data OUT NOCOPY VARCHAR2
115 );
116
117 PROCEDURE VALIDATE_TIME_PARAMETER
118 (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
119 ,p_time_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.time_parameter_rec_type
120 ,x_valid OUT NOCOPY VARCHAR2
121 ,x_return_status OUT NOCOPY VARCHAR2
122 ,x_msg_count OUT NOCOPY NUMBER
123 ,x_msg_data OUT NOCOPY VARCHAR2
124 );
125
126 PROCEDURE DECODE_ID_VALUE
127 (p_code IN VARCHAR2
128 ,p_index IN NUMBER
129 ,x_id OUT NOCOPY VARCHAR2
130 ,x_value OUT NOCOPY VARCHAR2
131 );
132
133 PROCEDURE CREATE_PARAMETER
134 (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
135 ,p_parameter_rec IN BIS_PMV_PARAMETERS_PVT.parameter_rec_type
136 ,x_return_status OUT NOCOPY VARCHAR2
137 ,x_msg_count OUT NOCOPY NUMBER
138 ,x_msg_Data OUT NOCOPY VARCHAR2
139 );
140
141 PROCEDURE RETRIEVE_PARAMETER
142 (p_user_session_rec IN BIS_PMV_SESSION_PVT.Session_rec_type
143 ,p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type
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 PROCEDURE RETRIEVE_PAGE_PARAMETER
151 (p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type
152 ,p_schedule_id IN NUMBER
153 ,p_user_session_rec IN BIS_PMV_SESSION_PVT.Session_rec_type
154 ,p_page_dims IN BISVIEWER.t_char
155 ,x_return_status OUT NOCOPY VARCHAR2
156 ,x_msg_count OUT NOCOPY NUMBER
157 ,x_msg_data OUT NOCOPY VARCHAR2
158 );
159
160 PROCEDURE RETRIEVE_KPI_PARAMETER
161 (p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type
162 ,p_user_session_rec IN BIS_PMV_SESSION_PVT.Session_rec_type
163 ,p_user_dims IN BISVIEWER.t_char
164 ,x_return_status OUT NOCOPY VARCHAR2
165 ,x_msg_count OUT NOCOPY NUMBER
166 ,x_msg_data OUT NOCOPY VARCHAR2
167 ) ;
168
169 PROCEDURE RETRIEVE_SCHEDULE_PARAMETER
170 (p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type
171 ,p_schedule_id IN NUMBER
172 ,x_return_status OUT NOCOPY VARCHAR2
173 ,x_msg_count OUT NOCOPY NUMBER
174 ,x_msg_data OUT NOCOPY VARCHAR2
175 );
176
177 PROCEDURE DELETE_PARAMETER
178 (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
179 ,p_parameter_name IN VARCHAR2
180 ,p_schedule_option IN VARCHAR2
181 ,x_return_status OUT NOCOPY VARCHAR2
182 ,x_msg_count OUT NOCOPY NUMBER
183 ,x_msg_data OUT NOCOPY VARCHAR2
184 );
185
186 PROCEDURE DELETE_SCHEDULE_PARAMETER
187 (p_parameter_name IN VARCHAR2
188 ,p_schedule_id IN NUMBER
189 ,x_return_status OUT NOCOPY VARCHAR2
190 ,x_msg_count OUT NOCOPY NUMBER
191 ,x_msg_data OUT NOCOPY VARCHAR2
192 );
193
194 PROCEDURE CREATE_SESSION_PARAMETERS
195 (p_user_param_tbl IN BIS_PMV_PARAMETERS_PVT.parameter_tbl_type
196 ,p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
197 ,x_return_status OUT NOCOPY VARCHAR2
198 ,x_msg_count OUT NOCOPY NUMBER
199 ,x_msg_data OUT NOCOPY VARCHAR2
200 );
201
202 PROCEDURE RETRIEVE_PAGE_PARAMETERS
203 (p_schedule_id IN NUMBER
204 ,p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
205 ,x_user_param_tbl OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_tbl_type
206 ,x_return_status OUT NOCOPY VARCHAR2
207 ,x_msg_count OUT NOCOPY NUMBER
208 ,x_msg_data OUT NOCOPY VARCHAR2
209 );
210
211 PROCEDURE RETRIEVE_KPI_PARAMETERS
212 (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
213 ,x_user_param_tbl OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_tbl_type
214 ,x_return_status OUT NOCOPY VARCHAR2
215 ,x_msg_count OUT NOCOPY NUMBER
216 ,x_msg_data OUT NOCOPY VARCHAR2
217 );
218
219 PROCEDURE RETRIEVE_PARAMLVL_PARAMETERS
220 (p_user_session_Rec IN BIS_PMV_SESSION_PVT.session_rec_type
221 ,x_paramportlet_param_tbl OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_tbl_Type
222 ,x_return_status OUT NOCOPY VARCHAR2
223 ,x_msg_count OUT NOCOPY NUMBER
224 ,x_msg_data OUT NOCOPY VARCHAR2
225 );
226 PROCEDURE RETRIEVE_SCHEDULE_PARAMETERS
227 (p_schedule_id IN NUMBER
228 ,x_user_param_tbl OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_tbl_type
229 ,x_return_status OUT NOCOPY VARCHAR2
230 ,x_msg_count OUT NOCOPY NUMBER
231 ,x_msg_data OUT NOCOPY VARCHAR2
232 );
233
234 PROCEDURE RETRIEVE_SESSION_PARAMETERS
235 (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
236 ,x_user_param_tbl OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_tbl_type
237 ,x_return_status OUT NOCOPY VARCHAR2
238 ,x_msg_count OUT NOCOPY NUMBER
239 ,x_msg_data OUT NOCOPY VARCHAR2
240 );
241
242 PROCEDURE RETRIEVE_DEFAULT_PARAMETERS
243 (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
244 ,x_user_param_tbl OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_tbl_type
245 ,x_return_status OUT NOCOPY VARCHAR2
246 ,x_msg_count OUT NOCOPY NUMBER
247 ,x_msg_data OUT NOCOPY VARCHAR2
248 );
249
250 PROCEDURE DELETE_SESSION_PARAMETERS
251 (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
252 ,p_schedule_option IN VARCHAR2
253 ,x_return_Status OUT NOCOPY VARCHAR2
254 ,x_msg_count OUT NOCOPY NUMBER
255 ,x_msg_data OUT NOCOPY VARCHAR2
256 );
257
258 PROCEDURE DELETE_PAGE_PARAMETERS
259 (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
260 ,x_return_status OUT NOCOPY VARCHAR2
261 ,x_msg_count OUT NOCOPY NUMBER
262 ,x_msg_data OUT NOCOPY VARCHAR2
263 );
264
265 PROCEDURE DELETE_DEFAULT_PARAMETERS
266 (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
267 ,x_return_status OUT NOCOPY VARCHAR2
268 ,x_msg_count OUT NOCOPY NUMBER
269 ,x_msg_data OUT NOCOPY VARCHAR2
270 );
271
272 PROCEDURE DELETE_SCHEDULE_PARAMETERS
273 (p_schedule_id IN NUMBER
274 ,x_return_status OUT NOCOPY VARCHAR2
275 ,x_msg_count OUT NOCOPY NUMBER
276 ,x_msg_data OUT NOCOPY VARCHAR2
277 );
278
279 PROCEDURE GET_NONTIME_VALIDATED_ID
280 (p_parameter_name in varchar2
281 ,p_parameter_value in varchar2
282 ,p_lov_where in varchar2 default null
283 ,p_region_code in varchar2
284 ,p_responsibility_id in varchar2
285 ,x_parameter_description out NOCOPY varchar2
286 ,x_return_status OUT NOCOPY VARCHAR2
287 ,x_msg_count OUT NOCOPY NUMBER
288 ,x_msg_data OUT NOCOPY VARCHAR2
289 );
290
291 PROCEDURE GET_NONTIME_VALIDATED_VALUE
292 (p_parameter_name in varchar2
293 ,p_parameter_description in varchar2
294 ,p_lov_where in varchar2 default null
295 ,p_region_code in varchar2
296 ,p_responsibility_id in varchar2
297 ,x_parameter_value out NOCOPY varchar2
298 ,x_return_status OUT NOCOPY VARCHAR2
299 ,x_msg_count OUT NOCOPY NUMBER
300 ,x_msg_data OUT NOCOPY VARCHAR2
301 );
302
303 PROCEDURE GET_TIME_VALIDATED_ID
304 (p_parameter_name IN VARCHAR2
305 ,p_parameter_value in varchar2
306 ,p_region_code in varchar2
307 ,p_org_name in varchar2
308 ,p_org_value in varchar2
309 ,p_responsibility_id in varchar2
310 ,x_parameter_description out NOCOPY varchar2
311 ,x_start_date out NOCOPY date
312 ,x_end_date out NOCOPY date
313 ,x_return_status OUT NOCOPY VARCHAR2
314 ,x_msg_count OUT NOCOPY NUMBER
315 ,x_msg_data OUT NOCOPY VARCHAR2
316 );
317
318 PROCEDURE GET_TIME_VALIDATED_VALUE
319 (p_parameter_name IN VARCHAR2
320 ,p_parameter_description in varchar2
321 ,p_region_code in varchar2
322 ,p_org_name in varchar2
323 ,p_org_value in varchar2
324 ,p_responsibility_id in varchar2
325 ,x_parameter_value out NOCOPY varchar2
326 ,x_start_date out NOCOPY date
327 ,x_end_date out NOCOPY date
328 ,x_return_status OUT NOCOPY VARCHAR2
329 ,x_msg_count OUT NOCOPY NUMBER
330 ,x_msg_data OUT NOCOPY VARCHAR2
331 );
332
333 PROCEDURE GET_TIME_INFO
334 (p_region_code in varchar2
335 ,p_responsibility_id in varchar2
336 ,p_parameter_name in varchar2
337 ,p_mode in varchar2
338 ,p_date in varchar2
339 ,x_time_description out NOCOPY varchar2
340 ,x_time_id out NOCOPY varchar2
341 ,x_start_date out NOCOPY date
342 ,x_end_date out NOCOPY date
343 ,x_return_status OUT NOCOPY VARCHAR2
344 ,x_msg_count OUT NOCOPY NUMBER
345 ,x_msg_data OUT NOCOPY VARCHAR2
346 );
347
348 PROCEDURE getLOVSQL
349 (p_parameter_name in varchar2
350 ,p_parameter_description in varchar2
351 ,p_sql_type in varchar2 default null
352 ,p_region_code in varchar2
353 ,p_responsibility_id in varchar2
354 ,x_sql_statement out NOCOPY varchar2
355 ,x_bind_sql out NOCOPY varchar2
356 ,x_bind_variables out NOCOPY varchar2
357 ,x_bind_count out NOCOPY number
358 ,x_return_status OUT NOCOPY VARCHAR2
359 ,x_msg_count OUT NOCOPY NUMBER
360 ,x_msg_data OUT NOCOPY VARCHAR2
361 );
362
363 PROCEDURE getTimeLovSql
364 (p_parameter_name in varchar2
365 ,p_parameter_description in varchar2
366 ,p_sql_type in varchar2 default null
367 ,p_date in varchar2 default null
368 ,p_region_code in varchar2
369 ,p_responsibility_id in varchar2
370 ,p_org_name in varchar2
371 ,p_org_value in varchar2
372 ,x_sql_statement out NOCOPY varchar2
373 ,x_bind_sql out NOCOPY varchar2
374 ,x_bind_variables out NOCOPY varchar2
375 ,x_bind_count out NOCOPY number
376 ,x_return_status OUT NOCOPY VARCHAR2
377 ,x_msg_count OUT NOCOPY NUMBER
378 ,x_msg_data OUT NOCOPY VARCHAR2
379 );
380
381 procedure saveParameters
382 (pRegionCode in varchar2,
386 pUserId in Varchar2 default null,
383 pFunctionName in varchar2,
384 pPageId in Varchar2 default null,
385 pSessionId in Varchar2 default null,
387 pResponsibilityId in Varchar2 default null,
388 pApplicationId in Varchar2 default null,
389 pOrgParam in number default 0,
390 pHierarchy1 in varchar2 default null,
391 pHierarchy2 in varchar2 default null,
392 pHierarchy3 in varchar2 default null,
393 pHierarchy4 in varchar2 default null,
394 pHierarchy5 in varchar2 default null,
395 pHierarchy6 in varchar2 default null,
396 pHierarchy7 in varchar2 default null,
397 pHierarchy8 in varchar2 default null,
398 pHierarchy9 in varchar2 default null,
399 pHierarchy10 in varchar2 default null,
400 pHierarchy11 in varchar2 default null,
401 pHierarchy12 in varchar2 default null,
402 pHierarchy13 in varchar2 default null,
403 pHierarchy14 in varchar2 default null,
404 pHierarchy15 in varchar2 default null,
405 pParameter1 in varchar2 default null,
406 pParameterValue1 in varchar2 default null,
407 pParameter2 in varchar2 default null,
408 pParameterValue2 in varchar2 default null,
409 pParameter3 in varchar2 default null,
410 pParameterValue3 in varchar2 default null,
411 pParameter4 in varchar2 default null,
412 pParameterValue4 in varchar2 default null,
413 pParameter5 in varchar2 default null,
414 pParameterValue5 in varchar2 default null,
415 pParameter6 in varchar2 default null,
416 pParameterValue6 in varchar2 default null,
417 pParameter7 in varchar2 default null,
418 pParameterValue7 in varchar2 default null,
419 pParameter8 in varchar2 default null,
420 pParameterValue8 in varchar2 default null,
421 pParameter9 in varchar2 default null,
422 pParameterValue9 in varchar2 default null,
423 pParameter10 in varchar2 default null,
424 pParameterValue10 in varchar2 default null,
425 pParameter11 in varchar2 default null,
426 pParameterValue11 in varchar2 default null,
427 pParameter12 in varchar2 default null,
428 pParameterValue12 in varchar2 default null,
429 pParameter13 in varchar2 default null,
430 pParameterValue13 in varchar2 default null,
431 pParameter14 in varchar2 default null,
432 pParameterValue14 in varchar2 default null,
433 pParameter15 in varchar2 default null,
434 pParameterValue15 in varchar2 default null,
435 pTimeParameter in varchar2 default null,
436 pTimeFromParameter in varchar2 default null,
437 pTimeToParameter in varchar2 default null,
438 pViewByValue in varchar2 default null,
439 pAddToDefault in varchar2 default null,
440 pParameter1Name in varchar2 default null,
441 pParameter2Name in varchar2 default null,
442 pParameter3Name in varchar2 default null,
443 pParameter4Name in varchar2 default null,
444 pParameter5Name in varchar2 default null,
445 pParameter6Name in varchar2 default null,
446 pParameter7Name in varchar2 default null,
447 pParameter8Name in varchar2 default null,
448 pParameter9Name in varchar2 default null,
449 pParameter10Name in varchar2 default null,
450 pParameter11Name in varchar2 default null,
451 pParameter12Name in varchar2 default null,
452 pParameter13Name in varchar2 default null,
453 pParameter14Name in varchar2 default null,
454 pParameter15Name in varchar2 default null,
455 pTimeParamName in varchar2 default null,
456 pParameterOperator1 in varchar2 default null,
457 pParameterOperator2 in varchar2 default null,
458 pParameterOperator3 in varchar2 default null,
459 pParameterOperator4 in varchar2 default null,
460 pParameterOperator5 in varchar2 default null,
461 pParameterOperator6 in varchar2 default null,
462 pParameterOperator7 in varchar2 default null,
463 pParameterOperator8 in varchar2 default null,
464 pParameterOperator9 in varchar2 default null,
465 pParameterOperator10 in varchar2 default null,
466 pParameterOperator11 in varchar2 default null,
467 pParameterOperator12 in varchar2 default null,
468 pParameterOperator13 in varchar2 default null,
469 pParameterOperator14 in varchar2 default null,
470 pParameterOperator15 in varchar2 default null,
471 pRequired1 in varchar2 default null,
472 pRequired2 in varchar2 default null,
473 pRequired3 in varchar2 default null,
474 pRequired4 in varchar2 default null,
475 pRequired5 in varchar2 default null,
476 pRequired6 in varchar2 default null,
477 pRequired7 in varchar2 default null,
478 pRequired8 in varchar2 default null,
479 pRequired9 in varchar2 default null,
480 pRequired10 in varchar2 default null,
481 pRequired11 in varchar2 default null,
482 pRequired12 in varchar2 default null,
483 pRequired13 in varchar2 default null,
484 pRequired14 in varchar2 default null,
485 pRequired15 in varchar2 default null,
486 pTimeRequired in varchar2 default null,
487 pLovWhere1 in varchar2 default null,
488 pLovWhere2 in varchar2 default null,
489 pLovWhere3 in varchar2 default null,
490 pLovWhere4 in varchar2 default null,
491 pLovWhere5 in varchar2 default null,
492 pLovWhere6 in varchar2 default null,
496 pLovWhere10 in varchar2 default null,
493 pLovWhere7 in varchar2 default null,
494 pLovWhere8 in varchar2 default null,
495 pLovWhere9 in varchar2 default null,
497 pLovWhere11 in varchar2 default null,
498 pLovWhere12 in varchar2 default null,
499 pLovWhere13 in varchar2 default null,
500 pLovWhere14 in varchar2 default null,
501 pLovWhere15 in varchar2 default null,
502 pAsOfDateValue in varchar2 default null,
503 pAsOfDateMode in varchar2 default null,
504 pSaveByIds in varchar2 default 'N',
505 x_return_status out NOCOPY VARCHAR2,
506 x_msg_count out NOCOPY NUMBER,
507 x_msg_data OUT NOCOPY VARCHAR2
508 );
509
510 PROCEDURE getParameterGroupsForRegion(
511 pRegionCode IN VARCHAR2,
512 xParameterGroup OUT NOCOPY parameter_group_tbl_type,
513 xTCTExists OUT NOCOPY BOOLEAN,
514 xNestedRegion OUT NOCOPY VARCHAR2,
515 xAsofDateExists OUT NOCOPY BOOLEAN
516 ) ;
517
518 PROCEDURE getAttrNamesInSameGroup (
519 pAttributeName IN VARCHAR2,
520 pDimension IN VARCHAR2,
521 pParameterGroup IN parameter_group_tbl_type,
522 xAttNameList OUT NOCOPY BISVIEWER.t_char
523 ) ;
524
525 PROCEDURE deletePageForGroup(
526 pUserId in varchar2,
527 pFunctionName in varchar2,
528 pPageId in varchar2,
529 pAttrNameList IN BISVIEWER.t_char,
530 pDimension IN VARCHAR2
531 ) ;
532
533 PROCEDURE deleteSessionForGroup(
534 pSessionId in varchar2,
535 pUserId in varchar2,
536 pFunctionName in varchar2,
537 pAttrNameList IN BISVIEWER.t_char,
538 pDimension IN VARCHAR2
539 ) ;
540
541 PROCEDURE overRideFromSchedule(pSessionId in varchar2,
542 pUserId in varchar2,
543 pFunctionName in varchar2,
544 pRegionCode in varchar2,
545 pScheduleId in varchar2 default null,
546 pRespId in varchar2 default null,
547 pParameterGroup IN parameter_group_tbl_type
548 ) ;
549 -- nbarik - 02/19/04 - BugFix 3441967 - Added x_IsPreFuncTCTExists and x_IsPreFuncCalcDatesExists
550 PROCEDURE overRideFromPreFunction(pSessionId in varchar2,
551 pUserId in varchar2,
552 pFunctionName in varchar2,
553 pRegionCode in varchar2,
554 pPreFunctionName in varchar2 default null,
555 pRespId in varchar2 default null,
556 pParameterGroup IN parameter_group_tbl_type,
557 pTCTExists in boolean default false
558 , x_IsPreFuncTCTExists OUT NOCOPY BOOLEAN
559 , x_IsPreFuncCalcDatesExists OUT NOCOPY BOOLEAN
560 ) ;
561
562 PROCEDURE overRideFromPage(pSessionId in varchar2,
563 pUserId in varchar2,
564 pFunctionName in varchar2,
565 pRegionCode in varchar2,
566 pPageId in varchar2 default null,
567 pRespId in varchar2 default null,
568 pParameterGroup IN parameter_group_tbl_type
569 ) ;
570
571 PROCEDURE overRideFromSavedDefault(pSessionId in varchar2,
572 pUserId in varchar2,
573 pFunctionName in varchar2,
574 pRegionCode in varchar2,
575 pRespId in varchar2 default null,
576 pParameterGroup IN parameter_group_tbl_type
577 ) ;
578
579 PROCEDURE COPY_FORM_FUNCTION_PARAMETERS
580 (pRegionCode IN VARCHAR2
581 ,pFunctionName IN VARCHAR2
582 ,pUserId IN VARCHAR2
583 ,pSessionId IN VARCHAR2
584 ,pResponsibilityId in varchar2 default NULL
585 ,pNestedRegionCode in varchar2 default NULL
586 ,pAsofdateExists in boolean default NULL
587 ,x_return_status OUT NOCOPY VARCHAR2
588 ,x_msg_count OUT NOCOPY NUMBER
589 ,x_msg_data OUT NOCOPY VARCHAR2
590 ) ;
591
592 -- jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS -- added xGraphFileId
593 PROCEDURE RETRIEVE_GRAPH_FILEID(p_user_id in varchar2,
594 p_schedule_id in varchar2,
595 p_attribute_name in varchar2,
596 p_function_name in varchar2,
597 x_graph_file_id out NOCOPY varchar2);
598
599 -- jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS -- added xGraphFileId
600 PROCEDURE SAVE_GRAPH_FILEID(p_user_id in varchar2,
601 p_schedule_id in varchar2,
602 p_attribute_name in varchar2,
603 p_function_name in varchar2,
604 p_graph_file_id in varchar2);
605
606 -- jprabhud - 12/20/02 - NLS Bug 2320171 Graph Fonts and Mutli-Byte characters
607 PROCEDURE RETRIEVE_CONTEXT_VALUES(p_user_id in varchar2,
608 p_schedule_id in varchar2,
609 p_attribute_name in varchar2,
610 p_function_name in varchar2,
611 x_context_values out NOCOPY varchar2);
612
613 -- jprabhud - 12/20/02 - NLS Bug 2320171 Graph Fonts and Mutli-Byte characters
614 PROCEDURE SAVE_CONTEXT_VALUES(p_user_id in varchar2,
615 p_schedule_id in varchar2,
616 p_attribute_name in varchar2,
617 p_function_name in varchar2,
618 p_context_values in varchar2);
619
620 function GET_LOV_WHERE(p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,
621 p_where_clause in VARCHAR2,
622 p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type) return varchar2;
623
624
625 PROCEDURE copyParamtersBetweenPages(
626 pSessionId IN VARCHAR2,
627 pFromPageId IN VARCHAR2,
628 pToPageId IN VARCHAR2,
629 pUserId IN VARCHAR2,
630 xParamRegionCode OUT NOCOPY VARCHAR2,
631 xParamFunctionName OUT NOCOPY VARCHAR2,
632 xParamGroup OUT NOCOPY parameter_group_tbl_type,
633 -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
634 x_DrillDefaultParameters OUT NOCOPY VARCHAR2,
635 x_return_status OUT NOCOPY VARCHAR2,
636 x_msg_count OUT NOCOPY NUMBER,
637 x_msg_data OUT NOCOPY VARCHAR2
638 );
639
640
641 procedure executeLovBindSQL
642 (p_bind_sql in varchar2
643 ,p_bind_variables in varchar2
644 ,p_time_flag in varchar2
645 ,x_parameter_id out NOCOPY varchar2
646 ,x_parameter_value out NOCOPY varchar2
647 ,x_start_date out NOCOPY date
648 ,x_end_date out NOCOPY date
649 ,x_return_status OUT NOCOPY VARCHAR2
650 ,x_msg_count OUT NOCOPY NUMBER
651 ,x_msg_data OUT NOCOPY VARCHAR2
652 );
653
654 procedure executeLovDynamicSQL
655 (p_bind_sql in varchar2
656 ,p_bind_values in BISVIEWER.t_char
657 ,p_time_flag in varchar2
658 ,x_parameter_id out NOCOPY varchar2
659 ,x_parameter_value out NOCOPY varchar2
660 ,x_start_date out NOCOPY date
661 ,x_end_date out NOCOPY date
662 ,x_return_status OUT NOCOPY VARCHAR2
663 ,x_msg_count OUT NOCOPY NUMBER
664 ,x_msg_data OUT NOCOPY VARCHAR2
665 );
666
667 PROCEDURE copyParamsFromReportToPage(
668 pFunctionName IN VARCHAR2,
669 pSessionId IN VARCHAR2,
670 pUserId IN VARCHAR2,
671 pToPageId IN VARCHAR2,
672 xParamRegionCode OUT NOCOPY VARCHAR2,
673 xParamFunctionName OUT NOCOPY VARCHAR2,
674 xParamGroup OUT NOCOPY parameter_group_tbl_type,
675 -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
676 x_DrillDefaultParameters OUT NOCOPY VARCHAR2,
677 x_return_status OUT NOCOPY VARCHAR2,
678 x_msg_count OUT NOCOPY NUMBER,
679 x_msg_data OUT NOCOPY VARCHAR2
680 ) ;
681
682 PROCEDURE COMPUTE_AND_SAVE_DATES(
683 pTimeAttribute IN VARCHAR2,
684 pTimeComparisonType IN VARCHAR2,
685 p_user_Session_rec BIS_PMV_SESSION_PVT.session_rec_type,
686 x_time_level_id OUT NOCOPY VARCHAR2,
687 x_time_level_value OUT NOCOPY VARCHAR2
688 );
689
690 --BugFix 3099789
691 --nbarik - 10/21/03 - Bug Fix 3201277 - Added x_time_attribute
692 -- nbarik - 02/19/04 - BugFix 3441967 - Added p_IsPreFuncTCTExists, p_IsPreFuncCalcDatesExists
693 PROCEDURE COPY_TIME_PARAMS(pSessionId in varchar2,
694 pUserId in varchar2,
695 pFunctionName in varchar2,
696 pRegionCode in varchar2,
697 pRespId in varchar2 default null,
698 pParameterGroup IN parameter_group_tbl_type,
699 pTCTExists in boolean default false,
700 p_IsPreFuncTCTExists IN BOOLEAN DEFAULT TRUE,
701 p_IsPreFuncCalcDatesExists IN BOOLEAN DEFAULT TRUE,
702 x_time_attribute OUT NOCOPY VARCHAR2
703 );
704 --Pass as of date as Date--3094234
705 PROCEDURE UPDATE_COMPUTED_DATES(
706 p_user_id IN NUMBER,
710 p_asof_date IN DATE,
707 p_page_id IN NUMBER,
708 p_function_name IN VARCHAR2,
709 p_time_comparison_type IN VARCHAR2,
711 p_time_level IN VARCHAR2,
712 x_prev_asof_Date OUT NOCOPY DATE,
713 x_curr_report_Start_date OUT NOCOPY DATE,
714 x_prev_report_Start_date OUT NOCOPY DATE,
715 x_curr_effective_start_date OUT NOCOPY DATE,
716 x_curr_effective_end_date OUT NOCOPY DATE,
717 x_time_level_id OUT NOCOPY VARCHAR2,
718 x_time_level_value OUT NOCOPY VARCHAR2,
719 x_prev_effective_start_date OUT NOCOPY DATE,
720 x_prev_effective_end_date OUT NOCOPY DATE,
721 x_prev_time_level_id OUT NOCOPY VARCHAR2,
722 x_prev_time_level_value OUT NOCOPY VARCHAR2,
723 x_prev_asof_Date_char OUT NOCOPY VARCHAR2,
724 x_curr_report_Start_date_char OUT NOCOPY VARCHAR2,
725 x_prev_report_Start_date_char OUT NOCOPY VARCHAR2,
726 x_curr_eff_start_date_char OUT NOCOPY VARCHAR2,
727 x_curr_eff_end_date_char OUT NOCOPY VARCHAR2,
728 x_prev_eff_start_date_char OUT NOCOPY VARCHAR2,
729 x_prev_eff_end_date_char OUT NOCOPY VARCHAR2,
730 x_return_status OUT NOCOPY VARCHAR2,
731 p_plug_id IN NUMBER DEFAULT 0
732 );
733
734
735 --nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
736 FUNCTION GET_DELEGATION_VALIDATED_VALUE(
737 pDelegationParam IN VARCHAR2
738 , pRegionCode IN VARCHAR2
739 ) RETURN VARCHAR2;
740
741 END BIS_PMV_PARAMETERS_PVT;