PACKAGE: APPS.BIS_PMV_PORTAL_UTIL_PUB

Source

1 package BIS_PMV_PORTAL_UTIL_PUB AUTHID CURRENT_USER as
2 /* $Header: BISPPUTS.pls 120.0 2005/06/01 14:39:12 appldev noship $ */
3 -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \
4 -- dbdrv: checkfile(115.9=120.0):~PROD:~PATH:~FILE
5 PROCEDURE GET_RANKING_PARAMETER(
6  p_page_id            IN    VARCHAR2
7 ,p_user_id            IN    VARCHAR2
8 ,x_ranking_param      OUT    NOCOPY VARCHAR2
9 ,x_return_Status      OUT    NOCOPY VARCHAR2
10 ,x_msg_count          OUT    NOCOPY NUMBER
11 ,x_msg_data           OUT    NOCOPY VARCHAR2
12 );
13 PROCEDURE GET_TIME_LEVEL_LABEL
14 (p_page_id           IN     VARCHAR2
15 ,p_user_id           IN     VARCHAR2
16 ,x_time_level_label  OUT    NOCOPY VARCHAR2
17 ,x_return_Status     OUT    NOCOPY VARCHAR2
18 ,x_msg_count         OUT    NOCOPY NUMBER
19 ,x_msg_data          OUT    NOCOPY VARCHAR2
20 );
21 FUNCTION getTimeLevelLabel (
22 p_page_id           IN     VARCHAR2
23 ,p_user_id           IN     VARCHAR2
24 ,p_session_id           IN     VARCHAR2
25 ,p_function_name           IN     VARCHAR2
26 ) RETURN VARCHAR2;
27 
28 PROCEDURE getAsOfDateAndLabel(
29   pAsOfDate IN VARCHAR2,
30   xAsOfDate OUT NOCOPY VARCHAR2,
31   xAsOfDateLabel OUT NOCOPY VARCHAR2
32 ) ;
33 
34 PROCEDURE get_rank_level_and_num_values(
35 p_page_id            IN    VARCHAR2
36 ,p_user_id            IN VARCHAR2
37 ,p_responsibility_id IN VARCHAR2
38 ,x_ranking_param OUT NOCOPY VARCHAR2
39 ,x_number_values      OUT    NOCOPY NUMBER
40 ,x_return_Status      OUT    NOCOPY VARCHAR2
41 ,x_msg_count          OUT    NOCOPY NUMBER
42 ,x_msg_data           OUT    NOCOPY VARCHAR2
43 ) ;
44 
45 -- jprabhud - 04/23/04 - Bug 3573468
46 PROCEDURE clean_portlets
47 (
48 	 p_user_name in VARCHAR2 DEFAULT NULL-- jprabhud - 04/23/04 - Bug 3573468
49 	,p_page_id in NUMBER DEFAULT NULL-- jprabhud - 04/23/04 - Bug 3573468
50 	,p_page_name in VARCHAR2 DEFAULT NULL-- jprabhud - 04/23/04 - Bug 3573468
51 	,p_function_name in VARCHAR2 DEFAULT NULL-- jprabhud - 04/23/04 - Bug 3573468
52 	,x_return_status  OUT NOCOPY VARCHAR2
53 	,x_msg_count   OUT NOCOPY NUMBER
54 	,x_msg_data    OUT NOCOPY VARCHAR2
55 ) ;
56 
57 
58 --KPI Portlet Pesonalization -ansingh
59 PROCEDURE GET_RANK_LEVEL_SHRT_NAME
60 (  p_region_code					IN  VARCHAR2,
61 	 x_rank_level_shrt_name	OUT NOCOPY VARCHAR2,
62 	 x_return_status        OUT NOCOPY VARCHAR2,
63 	 x_msg_count            OUT NOCOPY NUMBER,
64 	 x_msg_data             OUT NOCOPY VARCHAR2
65 );
66 
67 
68 END BIS_PMV_PORTAL_UTIL_PUB;