[Home] [Help]
PACKAGE: APPS.BSC_PORTLET_UI_WRAPPER
Source
1 PACKAGE BSC_PORTLET_UI_WRAPPER AS
2 /* $Header: BSCPORWS.pls 120.4 2007/02/08 14:29:20 ppandey ship $ */
3
4
5 /************************************************************************************
6 ************************************************************************************/
7
8 FUNCTION Encode_String(
9 p_string IN VARCHAR2
10 ,p_escape IN VARCHAR2 := '%'
11 ,p_reserved IN VARCHAR2 := '%=&;'
12 ,p_encoded IN VARCHAR2 := 'PEAS'
13 ) RETURN VARCHAR2;
14
15 /************************************************************************************
16 ************************************************************************************/
17
18 FUNCTION Clean_String(
19 p_string IN VARCHAR2
20 ) RETURN VARCHAR2;
21
22 /************************************************************************************
23 ************************************************************************************/
24
25 PROCEDURE Get_Page_Params(
26 p_user_id IN NUMBER
27 ,p_page_id IN VARCHAR2
28 ,x_page_params OUT NOCOPY VARCHAR2
29 ,x_return_status OUT NOCOPY VARCHAR2
30 ,x_msg_count OUT NOCOPY NUMBER
31 ,x_msg_data OUT NOCOPY VARCHAR2
32 );
33
34 /************************************************************************************
35 ************************************************************************************/
36
37 PROCEDURE Get_Ranking_Parameter (
38 p_page_id IN VARCHAR2
39 ,p_user_id IN NUMBER
40 ,x_ranking_param OUT NOCOPY VARCHAR2
41 ,x_return_status OUT NOCOPY VARCHAR2
42 ,x_msg_count OUT NOCOPY NUMBER
43 ,x_msg_data OUT NOCOPY VARCHAR2
44 );
45
46 /************************************************************************************
47 ************************************************************************************/
48
49 PROCEDURE Validate_Responsibility(
50 p_user_id IN NUMBER
51 ,p_resp_id IN NUMBER
52 ,x_valid OUT NOCOPY VARCHAR2
53 ,x_return_status OUT NOCOPY VARCHAR2
54 ,x_msg_count OUT NOCOPY NUMBER
55 ,x_msg_data OUT NOCOPY VARCHAR2
56 );
57
58 /************************************************************************************
59 ************************************************************************************/
60
61 PROCEDURE Show_Info_Page(
62 p_info_key IN VARCHAR2
63 );
64
65 /************************************************************************************
66 ************************************************************************************/
67
68 PROCEDURE Show_Custom_View_Image(
69 p_tab_code IN VARCHAR2,
70 p_tab_view IN VARCHAR2,
71 p_resp_id IN VARCHAR2,
72 p_mime_type IN VARCHAR2 := 'image/gif'
73 );
74
75
76 /************************************************************************************
77 ************************************************************************************/
78
79 PROCEDURE Apply_CustomView_Parameters (
80 p_user_id IN VARCHAR2,
81 p_reference_path IN VARCHAR2,
82 p_resp_id IN VARCHAR2,
83 p_tab_id IN VARCHAR2,
84 p_view_id IN VARCHAR2,
85 p_portlet_name IN VARCHAR2,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2
89 );
90
91 /************************************************************************************
92 ************************************************************************************/
93
94 PROCEDURE Apply_Graph_Parameters (
95 p_user_id IN VARCHAR2,
96 p_reference_path IN VARCHAR2,
97 p_resp_id IN VARCHAR2,
98 p_tab_id IN VARCHAR2,
99 p_kpi_code IN VARCHAR2,
100 p_view_id IN VARCHAR2,
101 p_portlet_name IN VARCHAR2,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2
105 );
106
107 /************************************************************************************
108 ************************************************************************************/
109
110 PROCEDURE Apply_Kpi_List_Parameters(
111 p_user_id IN NUMBER,
112 p_plug_id IN NUMBER,
113 p_reference_path IN VARCHAR2,
114 p_resp_id IN NUMBER,
115 p_details_flag IN NUMBER,
116 p_group_flag IN NUMBER,
117 p_kpi_measure_details_flag IN NUMBER,
118 p_createy_by IN NUMBER,
119 p_last_updated_by IN NUMBER,
120 p_porlet_name IN VARCHAR2,
121 p_number_array IN BSC_NUM_LIST,
122 p_o_ret_status OUT NOCOPY NUMBER,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2
126 );
127 /************************************************************************************
128 ************************************************************************************/
129
130 PROCEDURE checkUpdateCustView(
131 p_commit IN VARCHAR2,
132 p_user_id IN VARCHAR2,
133 p_reference_path IN VARCHAR2,
134 p_tab_id IN VARCHAR2,
135 p_view_id IN VARCHAR2,
136 p_resp_id IN VARCHAR2,
137 x_return_status OUT NOCOPY VARCHAR2
138 );
139 /************************************************************************************
140 ************************************************************************************/
141
142 FUNCTION Get_CustView_Measure_Name(
143 p_region_code IN VARCHAR
144 ,p_dataset_id IN NUMBER
145 ) RETURN VARCHAR2;
146
147 END BSC_PORTLET_UI_WRAPPER;