1 PACKAGE BIS_RL_PKG AUTHID CURRENT_USER AS
2 /* $Header: BISVEXLS.pls 120.4 2006/07/28 06:44:23 nkishore ship $ */
3 -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \
4 -- dbdrv: checkfile(115.34=120.4):~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 | BISVEXLS.pls |
13 REM | |
14 REM | DESCRIPTION |
15 REM | This is the Related Links Pkg. for PMV. |
16 REM | |
17 REM | HISTORY |
18 REM | amkular, 06/25/1999, Initial Creation |
19 REM | nkishore, 12/10/2002, Added updateRelatedLink_Wrapper, |
20 REM | reorderRelatedLinks, getAllRespFuncnSQLWrapper |
21 REM | ansingh 12/24/02 Added Wrappers for Preseeding RL Enhancement |
22 REM | ansingh 01/08/03 Added function isUserIdInLinkParams |
23 REM | mdamle 03/12/04 Enh 3503753 - Site level custom. for links |
24 REM | mdamle 05/28/04 Added delete API to be called from LCT file |
25 REM | mdamle 08/09/04 Bug# 3813449 - New API to copy links to dup rpt|
26 REM +=======================================================================+
27 */
28
29 -- mdamle 03/12/04 - Enh 3503753 - Site level custom. for links
30 CUSTOM_SITE_LEVEL CONSTANT VARCHAR2(4) := 'SITE';
31 CUSTOM_RESP_LEVEL CONSTANT VARCHAR2(4) := 'RESP';
32 CUSTOM_ORG_LEVEL CONSTANT VARCHAR2(3) := 'ORG';
33 CUSTOM_APP_LEVEL CONSTANT VARCHAR2(3) := 'APP';
34 CUSTOM_FUNCTION_LEVEL CONSTANT VARCHAR2(8) := 'FUNCTION';
35 CUSTOM_USER_LEVEL CONSTANT VARCHAR2(4) := 'USER';
36
37 procedure FavoriteCreate
38 ;
39
40 procedure FavoriteRename
41 ;
42
43 PROCEDURE Build_Related_Information_HTML
44 ( p_image_directory IN VARCHAR2
45 ,p_ICX_Report_Link IN VARCHAR2
46 ,p_function_id IN NUMBER
47 ,p_Responsibility_id IN NUMBER
48 ,p_user_id IN NUMBER
49 ,p_session_id IN VARCHAR2
50 ,x_HTML IN OUT NOCOPY VARCHAR2
51 ,p_function_name in varchar2 default null);
52
53 c_ampersand constant varchar2(1) := '&';
54
55 -- mdamle 03/12/2001 - Related Links
56 PROCEDURE addRelatedlink_Wrapper( p_user_id IN VARCHAR2,
57 p_resp_id IN VARCHAR2,
58 p_function_id IN VARCHAR2,
59 p_linked_function_id IN VARCHAR2,
60 p_user_link_name IN VARCHAR2,
61 p_link_type IN VARCHAR2,
62 p_url IN VARCHAR2,
63 p_custom_Level IN VARCHAR2, -- mdamle 03/12/04 - Enh 3503753 - Site level custom. for links - custom table
64 p_custom_level_value IN VARCHAR2); -- mdamle 03/12/04 - Enh 3503753 - Site level custom. for links - custom table
65
66
67 -- mdamle 03/12/2001 - Related Links Wrapper for Java
68 procedure getRespSQLWrapper
69 ( p_user_id IN PLS_INTEGER
70 , p_resp_sql OUT NOCOPY varchar2
71 ) ;
72
73 -- mdamle 03/12/2001 - Related Links Wrapper for Java
74 procedure deleteRelatedLink_Wrapper(
75 p_related_link_id pls_integer
76 ,p_isPreseed IN VARCHAR2 ); -- mdamle 03/12/04 - Enh 3503753 - Site level custom. for links
77
78 --serao 02/25/02 - for relatedlink portlet
79 PROCEDURE add_rl_from_function (
80 pFunction_name IN VARCHAR2,
81 pUserId In NUMBER,
82 pPlugId IN NUMBER
83 ) ;
84
85 --ansingh
86 procedure PRESEED_TO_NORMAL_WRAPPER(p_user_id in varchar2,
87 p_resp_id in varchar2,
88 p_function_id in varchar2,
89 p_related_link_id in varchar2,
90 p_user_link_name in varchar2,
91 p_link_type in varchar2,
92 p_url in varchar2);
93
94 --nbarik added for Updating the Related LInks
95 -- mdamle 03/12/04 - Enh 3503753 - Site level custom. for links
96 PROCEDURE UPDATERELATEDLINK_WRAPPER(
97 p_related_link_id IN PLS_INTEGER,
98 p_related_link_name IN VARCHAR2,
99 p_user_url IN VARCHAR2 DEFAULT NULL,
100 p_isPreseed IN VARCHAR2);
101
102
103 --nbarik
104 procedure reorderRelatedLinks(p_content_string in varchar2,
105 p_isPreseed IN VARCHAR2); -- mdamle 03/12/04 - Enh 3503753 - Site level custom. for links
106
107
108 --msaran: SQL Literals project
109 procedure getRespFuncnSQLWrap
110 ( p_user_id IN PLS_INTEGER
111 , p_resp_id IN PLS_INTEGER
112 , p_report_function_id IN PLS_INTEGER
113 , p_search_criteria IN VARCHAR2
114 , p_funcn_sql OUT NOCOPY VARCHAR2
115 , p_bind_count OUT NOCOPY NUMBER
116 , p_bind_string OUT NOCOPY VARCHAR2
117 );
118
119 --msaran: SQL Literals project
120 procedure getAllRespFuncnSQLWrap
121 ( p_user_id IN PLS_INTEGER
122 , p_resp_id IN VARCHAR2
123 , p_report_function_id IN PLS_INTEGER
124 , p_search_criteria IN VARCHAR2
125 , p_funcn_sql OUT NOCOPY VARCHAR2
126 , p_bind_count OUT NOCOPY NUMBER
127 , p_bind_string OUT NOCOPY VARCHAR2
128 );
129
130 --msaran: SQL Literals project
131 procedure getAllRespRLPortletsSQLWrap
132 ( p_user_id IN PLS_INTEGER
133 , p_resp_id IN VARCHAR2
134 , p_report_function_id IN PLS_INTEGER
135 , p_search_criteria IN VARCHAR2
136 , p_funcn_sql OUT NOCOPY VARCHAR2
137 , p_bind_count OUT NOCOPY NUMBER
138 , p_bind_string OUT NOCOPY VARCHAR2
139 );
140
141 --msaran: SQL Literals project
142 procedure getRespRLPortletsSQLWrap
143 ( p_user_id IN PLS_INTEGER
144 , p_resp_id IN VARCHAR2
145 , p_report_function_id IN PLS_INTEGER
146 , p_search_criteria IN VARCHAR2
147 , p_funcn_sql OUT NOCOPY VARCHAR2
148 , p_bind_count OUT NOCOPY NUMBER
149 , p_bind_string OUT NOCOPY VARCHAR2
150 );
151
152 --ansingh
153 FUNCTION isUserIdInLinkParams (p_userId IN VARCHAR2,
154 p_linkParams IN VARCHAR2
155 ) RETURN VARCHAR2;
156
157 --serao ,06/03
158 -- mdamle 03/12/04 - Enh 3503753 - Site level custom. for links
159 PROCEDURE copyLinksFromPrevLevel (
160 p_report_function_id IN VARCHAR2,
161 p_user_id IN VARCHAR2,
162 p_custom_level IN VARCHAR2,
163 p_custom_level_value IN VARCHAR2,
164 p_plug_id IN VARCHAR2 := NULL
165 );
166
167 -- mdamle 03/12/04 - Enh 3503753 - Site level custom. for links
168 PROCEDURE insertCustomLinks(
169 p_related_link_id in number,
170 p_display_sequence in number,
171 p_function_id in number,
172 p_responsibility_id in number,
173 p_security_group_id in number,
174 p_responsibility_app_id in number,
175 p_linked_function_id in number,
176 p_link_type in varchar2,
177 p_user_url in varchar2,
178 p_user_link_name in varchar2,
179 p_level_site_id in number,
180 p_level_resp_id in number,
181 p_level_app_id in number,
182 p_level_org_id in number,
183 p_level_function_id in number,
184 p_level_user_id in number,
185 p_user_id in number);
186
187 function getPreviousCustomizationLevel(
188 p_function_id in number
189 ,p_custom_level in varchar2) RETURN VARCHAR2;
190
191 -- mdamle 05/28/2004 - Delete API to be called from LCT file
192 procedure delete_function_links (
193 p_function_id IN number
194 ,x_return_status OUT NOCOPY VARCHAR2
195 ,x_msg_count OUT NOCOPY NUMBER
196 ,x_msg_data OUT NOCOPY VARCHAR2
197 );
198
199
200 -- mdamle 05/28/2004 - Load API to be called from LCT file
201 procedure load_row (
202 p_function_id IN NUMBER
203 ,p_user_id IN NUMBER
204 ,p_link_type IN VARCHAR2
205 ,p_linked_function_id IN NUMBER
206 ,p_user_url IN VARCHAR2
207 ,p_resp_id IN NUMBER
208 ,p_sec_grp_id IN NUMBer
209 ,p_resp_app_id IN NUMBER
210 ,p_display_sequence IN NUMBER
211 ,p_user_link_name IN VARCHAR2
212 ,p_login_id IN NUMBER
213 ,x_return_status OUT NOCOPY VARCHAR2
214 ,x_msg_count OUT NOCOPY NUMBER
215 ,x_msg_data OUT NOCOPY VARCHAR2
216 );
217
218 -- mdamle 05/28/2004 - Translate API to be called from LCT file
219 procedure translate_row (
220 p_function_id IN NUMBER
221 ,p_display_sequence IN VARCHAR2
222 ,p_user_link_name IN VARCHAR2
223 ,p_user_id IN NUMBER
224 ,p_login_id IN NUMBER
225 ,x_return_status OUT NOCOPY VARCHAR2
226 ,x_msg_count OUT NOCOPY NUMBER
227 ,x_msg_data OUT NOCOPY VARCHAR2
228 );
229
230 procedure copy_report_links (
231 p_source_function_id IN number
232 ,p_dest_function_id IN number
233 ,p_user_id IN number
234 ,x_return_status OUT NOCOPY VARCHAR2
235 ,x_msg_count OUT NOCOPY NUMBER
236 ,x_msg_data OUT NOCOPY VARCHAR2
237 );
238
239 PROCEDURE Add_Language;
240
241 END BIS_RL_PKG;