[Home] [Help]
PACKAGE: APPS.BIS_RG_SCHEDULES_PVT
Source
1 PACKAGE BIS_RG_SCHEDULES_PVT AUTHID CURRENT_USER as
2 /* $Header: BISVSCHS.pls 120.0.12000000.3 2007/02/06 07:46:49 akoduri ship $ */
3 -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \
4 -- dbdrv: checkfile(115.24=120.0.12000000.3):~PROD:~PATH:~FILE
5 ----------------------------------------------------------------------------
6 -- PACKAGE: BIS_SCHEDULE_PVT
7 -- --
8 -- DESCRIPTION: Private package to create records in BIS_SCHEDULER
9 --
10 -- --
11 -- MODIFICATIONS --
12 -- Date User Modification
13 -- XX-XXX-XX XXXXXXXX Modifications made, which procedures changed & --
14 -- list bug number, if fixing a bug. --
15 -- --
16 -- 02-25-00 amkulkar Initial creation --
17 -- 07-03-01 mdamle Scheduling Enhancements --
18 -- 09/04/01 mdamle Scheduling Enhancements - Phase II - Multiple --
19 -- Preferences per schedule --
20 -- 09/19/01 mdamle Trap File_ID creation error --
21 -- 12/12/01 mdamle Changes for Live Portlet --
22 -- 12/27/01 mdamle Added updateTitleInPortal --
23 -- 01/16/02 mdamle Added updateExternalSource --
24 -- 12/10/02 nkishore Added creating_schedule, updating_schedule --
25 -- 01/25/07 akoduri Bug#5752469 Issue with Cancel & Apply buttons --
26 -- in portal --
27 -- 02/06/07 akoduri GSCC Error while building R12 ARU --
28 ----------------------------------------------------------------------------
29 PROCEDURE CREATE_SCHEDULE
30 (p_plug_id IN NUMBER DEFAULT NULL
31 ,p_user_id IN VARCHAR2
32 ,p_function_name IN VARCHAR2
33 ,p_responsibility_id IN VARCHAR2
34 ,p_title IN VARCHAR2 DEFAULT NULL
35 ,p_graph_type IN NUMBER DEFAULT NULL
36 ,p_concurrent_request_id IN NUMBER DEFAULT NULL
37 -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
38 ,p_file_id IN OUT NOCOPY NUMBER
39 ,p_Request_Type IN VARCHAR2 DEFAULT NULL
40 ,x_Schedule_id OUT NOCOPY NUMBER
41 ,x_return_Status OUT NOCOPY VARCHAR2
42 ,x_msg_Data OUT NOCOPY VARCHAR2
43 ,x_msg_count OUT NOCOPY NUMBER
44 -- mdamle 12/12/01 - Changes for Live Portlet
45 ,p_live_portlet IN VARCHAR2 DEFAULT 'N'
46 --jprabhud - 12/20/02 - NLS Bug 2320171 Graph Fonts and Mutli-Byte characters
47 ,p_context_values IN VARCHAR2 DEFAULT NULL
48
49 );
50
51 /* serao, 06/03, This creates a schedule for the create schedule call with the same signature but does not do a commit.
52 Called by Related Links Functionality
53 */
54 PROCEDURE CREATE_SCHEDULE_NO_COMMIT
55 (p_plug_id IN NUMBER DEFAULT NULL
56 ,p_user_id IN VARCHAR2
57 ,p_function_name IN VARCHAR2
58 ,p_responsibility_id IN VARCHAR2
59 ,p_title IN VARCHAR2 DEFAULT NULL
60 ,p_graph_type IN NUMBER DEFAULT NULL
61 ,p_request_type IN VARCHAR2 DEFAULT NULL
62 ,x_schedule_id OUT NOCOPY NUMBER
63 -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
64 ,x_file_id OUT NOCOPY NUMBER
65 ,x_return_Status OUT NOCOPY VARCHAR2
66 ,x_msg_Data OUT NOCOPY VARCHAR2
67 ,x_msg_count OUT NOCOPY NUMBER
68 -- mdamle 12/12/01 - Changes for Live Portlet
69 ,p_live_portlet IN VARCHAR2 DEFAULT 'N'
70 );
71
72 PROCEDURE CREATE_SCHEDULE
73 (p_plug_id IN NUMBER DEFAULT NULL
74 ,p_user_id IN VARCHAR2
75 ,p_function_name IN VARCHAR2
76 ,p_responsibility_id IN VARCHAR2
77 ,p_title IN VARCHAR2 DEFAULT NULL
78 ,p_graph_type IN NUMBER DEFAULT NULL
79 ,p_Request_Type IN VARCHAR2 DEFAULT NULL
80 ,x_Schedule_id OUT NOCOPY NUMBER
81 -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
82 ,x_file_id OUT NOCOPY NUMBER
83 ,x_return_Status OUT NOCOPY VARCHAR2
84 ,x_msg_Data OUT NOCOPY VARCHAR2
85 ,x_msg_count OUT NOCOPY NUMBER
86 -- mdamle 12/12/01 - Changes for Live Portlet
87 ,p_live_portlet IN VARCHAR2 DEFAULT 'N'
88 );
89 PROCEDURE CREATE_SCHEDULE
90 (p_plug_id IN NUMBER DEFAULT NULL
91 ,p_user_id IN VARCHAR2
92 ,p_function_name IN VARCHAR2
93 ,p_responsibility_id IN VARCHAR2
94 ,p_title IN VARCHAR2 DEFAULT NULL
95 ,p_graph_type IN NUMBER DEFAULT NULL
96 ,p_concurrent_request_id IN NUMBER DEFAULT NULL
97 -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
98 ,p_file_id IN OUT NOCOPY NUMBER
99 ,p_session_id IN VARCHAR2 DEFAULT NULL
100 ,p_report_region_code IN VARCHAR2 DEFAULT NULL
101 ,p_Request_Type IN VARCHAR2 DEFAULT NULL
102 ,x_Schedule_id OUT NOCOPY NUMBER
103 ,x_return_Status OUT NOCOPY VARCHAR2
104 ,x_msg_Data OUT NOCOPY VARCHAR2
105 ,x_msg_count OUT NOCOPY NUMBER
106 -- mdamle 12/12/01 - Changes for Live Portlet
107 ,p_live_portlet IN VARCHAR2 DEFAULT 'N'
108 --jprabhud - 12/20/02 - NLS Bug 2320171 Graph Fonts and Mutli-Byte characters
109 ,p_context_values IN VARCHAR2 DEFAULT NULL
110 );
111
112 --nkishore Customize UI Enhancement Creating Schedule
113 PROCEDURE CREATING_SCHEDULE
114 (p_plug_id IN NUMBER DEFAULT NULL
115 ,p_user_id IN VARCHAR2
116 ,p_function_name IN VARCHAR2
117 ,p_responsibility_id IN VARCHAR2
118 ,p_title IN VARCHAR2 DEFAULT NULL
119 ,p_graph_type IN NUMBER DEFAULT NULL
120 ,p_concurrent_request_id IN NUMBER DEFAULT NULL
121 -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
122 ,p_file_id IN OUT NOCOPY NUMBER
123 ,p_session_id IN VARCHAR2 DEFAULT NULL
124 ,p_report_region_code IN VARCHAR2 DEFAULT NULL
125 ,p_Request_Type IN VARCHAR2 DEFAULT NULL
126 ,x_Schedule_id OUT NOCOPY NUMBER
127 ,x_return_Status OUT NOCOPY VARCHAR2
128 ,x_msg_Data OUT NOCOPY VARCHAR2
129 ,x_msg_count OUT NOCOPY NUMBER
130 --jprabhud - 12/20/02 - NLS Bug 2320171 Graph Fonts and Mutli-Byte characters
131 ,p_context_values IN VARCHAR2 DEFAULT NULL
132 );
133
134 PROCEDURE UPDATE_SCHEUDLE
135 (p_schedule_id IN NUMBER
136 ,p_user_id IN VARCHAR2 DEFAULT NULL
137 ,p_function_name IN VARCHAR2 DEFAULT NULL
138 ,p_title IN VARCHAR2 DEFAULT NULL
139 ,p_graph_type IN NUMBER DEFAULT NULL
140 ,p_concurrent_Request_id IN NUMBER DEFAULT NULL
141 ,p_file_id IN NUMBER DEFAULT NULL
142 ,x_return_Status OUT NOCOPY VARCHAR2
143 ,x_msg_data OUT NOCOPY VARCHAR2
144 ,x_msg_count OUT NOCOPY NUMBER
145 -- mdamle 07/03/01 - Scheduling Enhancements
146 ,p_parameters IN VARCHAR2 default null
147 );
148
149 --nkishore Customize UI Enhancement Updating Schedule
150 PROCEDURE UPDATING_SCHEDULE
151 (p_schedule_id IN NUMBER
152 ,p_user_id IN VARCHAR2
153 ,p_function_name IN VARCHAR2
154 ,p_session_id IN VARCHAR2
155 ,x_return_Status OUT NOCOPY VARCHAR2
156 ,x_msg_data OUT NOCOPY VARCHAR2
157 ,x_msg_count OUT NOCOPY NUMBER
158 );
159
160 PROCEDURE UPDATE_SCHEDULE
161 (p_schedule_id IN NUMBER
162 ,p_concurrent_Request_id IN NUMBER
163 ,x_return_Status OUT NOCOPY VARCHAR2
164 ,x_msg_Data OUT NOCOPY VARCHAR2
165 ,x_msg_count OUT NOCOPY NUMBER
166 -- mdamle 07/03/01 - Scheduling Enhancements
167 ,p_parameters IN VARCHAR2 default null
168 ,p_commit IN VARCHAR2 DEFAULT 'Y'
169 );
170
171 FUNCTION GET_FILE_ID
172 (p_request_Type in VARCHAR2)
173 RETURN NUMBER;
174 PROCEDURE IS_SCHEDULED
175 (p_user_id IN VARCHAR2
176 ,p_function_name IN VARCHAR2
177 ,p_report_region_code IN VARCHAR2 DEFAULT NULL
178 ,p_session_id IN VARCHAR2 DEFAULT NULL
179 ,p_parameter1 IN VARCHAR2 DEFAULT NULL
180 ,p_parameter2 IN VARCHAR2 DEFAULT NULL
181 ,p_parameter3 IN VARCHAR2 DEFAULT NULL
182 ,p_parameter4 IN VARCHAR2 DEFAULT NULL
183 ,p_parameter5 IN VARCHAR2 DEFAULT NULL
184 ,p_parameter6 IN VARCHAR2 DEFAULT NULL
185 ,p_parameter7 IN VARCHAR2 DEFAULT NULL
186 ,p_parameter8 IN VARCHAR2 DEFAULT NULL
187 ,p_parameter9 IN VARCHAR2 DEFAULT NULL
188 ,p_parameter10 IN VARCHAR2 DEFAULT NULL
189 ,p_parameter11 IN VARCHAR2 DEFAULT NULL
190 ,p_parameter12 IN VARCHAR2 DEFAULT NULL
191 ,p_parameter13 IN VARCHAR2 DEFAULT NULL
192 ,p_parameter14 IN VARCHAR2 DEFAULT NULL
193 ,p_parameter15 IN VARCHAR2 DEFAULT NULL
194 ,p_timetoparameter IN VARCHAR2 DEFAULT NULL
195 ,p_timefromparameter IN VARCHAR2 DEFAULT NULL
196 ,p_viewby IN VARCHAR2 DEFAULT NULL
197 ,x_Scheduled OUT NOCOPY VARCHAR2
198 );
199 PROCEDURE SAVE_COMPONENT
200 (p_file_id IN NUMBER
201 ,p_Request_Type IN VARCHAR2
202 );
203
204 PROCEDURE UPDATE_LAST_UPDATE
205 (p_schedule_id IN NUMBER
206 ,x_return_Status OUT NOCOPY VARCHAR2
207 ,x_msg_Data OUT NOCOPY VARCHAR2
208 ,x_msg_count OUT NOCOPY NUMBER
209 );
210
211 -- mdamle 07/03/2001 - Scheduling Enhancements
212 FUNCTION getUserType
213 return varchar2;
214
215 -- mdamle 07/03/2001 - Scheduling Enhancements
216 FUNCTION getDefaultSchedule
217 (pRegionCode IN VARCHAR2
218 ,pViewBy IN VARCHAR2 DEFAULT NULL
219 ) return varchar2;
220
221 -- mdamle 07/03/2001 - Scheduling Enhancements
222 PROCEDURE showDefaultSchedulePage
223 (pRegionCode IN VARCHAR2
224 ,pFunctionName IN VARCHAR2
225 ,pResponsibilityId IN VARCHAR2
226 ,pApplicationId IN VARCHAR2
227 ,pSessionId IN VARCHAR2
228 ,pUserId IN VARCHAR2
229 ,pViewBy IN VARCHAR2
230 ,pReportTitle IN VARCHAR2 default NULL
231 ,pRequestType IN VARCHAR2 default NULL
232 ,pPlugId IN VARCHAR2 default NULL
233 ,pParmPrint IN VARCHAR2 default NULL
234 ,pGraphType IN VARCHAR2 default NULL
235 );
236
237 -- mdamle 07/03/01 - Scheduling Enhancements
238 FUNCTION getDuplicateSchedule
239 (pFunctionName IN VARCHAR2
240 ,pParameters IN VARCHAR2
241 ,pSchedule IN VARCHAR2
242 ,pPlugId IN VARCHAR2 default NULL
243 ) return number;
244
245 -- mdamle 07/03/01 - Scheduling Enhancements
246 PROCEDURE subscribeToReport
247 (pRegionCode IN VARCHAR2
248 ,pFunctionName IN VARCHAR2
249 ,pResponsibilityId IN VARCHAR2
250 ,pApplicationId IN VARCHAR2
251 ,pSessionId IN VARCHAR2
252 ,pUserId IN VARCHAR2
253 ,pSchedule IN VARCHAR2
254 ,pRequestType IN VARCHAR2
255 ,pReportTitle IN VARCHAR2
256 ,pPlugId IN VARCHAR2 default NULL
257 -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
258 ,pGraphType IN VARCHAR2
259 );
260
261 -- mdamle 07/03/01 - Scheduling Enhancements
262 FUNCTION getParameterString
263 (pFunctionName IN VARCHAR2
264 ,pUserId IN VARCHAR2
265 ,pSessionId IN VARCHAR2
266 ) return varchar2;
267
268 -- mdamle 07/03/01 - Scheduling Enhancements
269 PROCEDURE unSubscribeFromReport
270 (pScheduleID IN number
271 ,pPlugId IN number default NULL
272 );
273
274 -- mdamle 07/03/01 - Scheduling Enhancements
275 PROCEDURE scheduleFunction
276 (pRegionCode IN VARCHAR2
277 ,pFunctionName IN VARCHAR2
278 ,pResponsibilityId IN VARCHAR2
279 ,pApplicationId IN VARCHAR2
280 ,pSessionId IN VARCHAR2
281 ,pUserId IN VARCHAR2
282 ,pSchedule IN VARCHAR2
283 ,pRequestType IN VARCHAR2
284 ,pReportTitle IN VARCHAR2
285 ,pMode IN VARCHAR2 default 'UPDATE'
286 ,pPlugId IN VARCHAR2 default NULL
287 ,pParmPrint IN VARCHAR2 default NULL
288 ,pSubscribedSchedule IN VARCHAR2 default NULL
289 -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
290 ,pGraphType IN VARCHAR2 default NULL);
291
292
293
294 -- mdamle 08/20/01 - Scheduling Enhancements
295 procedure addUserToRole(
296 pUserId IN number
297 ,pRole IN varchar2);
298
299 -- aleung 08/21/01 - autoincrement feature
300 procedure updateIncrementDate(p_concurrent_Request_id IN NUMBER);
301
302 -- mdamle 09/04/01 Scheduling Enhancements - Phase II - Purge
303 procedure delete_schedule(pScheduleId IN NUMBER);
304
305 -- mdamle 09/04/01 Scheduling Enhancements - Phase II - Purge
306 procedure delete_old_schedule(pScheduleId IN NUMBER);
307
308 -- mdamle 09/04/01 Scheduling Enhancements - Phase II - Purge Portlet Data
309 procedure delete_portlet(
310 pPlugId IN NUMBER
311 ,pUserId IN NUMBER
312 -- jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS -- added xGraphFileId
313 ,xGraphFileId OUT NOCOPY VARCHAR2);
314
315 -- mdamle 09/04/01 Scheduling Enhancements - Phase II - Purge Portlet Data
316 procedure delete_old_portlet(
317 pPlugId IN NUMBER
318 ,pUserId IN NUMBER
319 ,pKeepLatest IN BOOLEAN default false);
320
321 -- mdamle 09/04/01 Scheduling Enhancements - Phase II - Purge Portlet Data
322 procedure delete_Notification_Data;
323
324 -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
325 PROCEDURE create_schedule_preferences(
326 p_schedule_id IN NUMBER
327 ,p_user_id IN VARCHAR2
328 ,p_plug_id IN NUMBER
329 ,p_title IN VARCHAR2
330 ,p_graph_type IN VARCHAR2
331 ,p_request_type IN VARCHAR2
332 ,p_file_id IN OUT NOCOPY NUMBER
333 -- mdamle 12/12/01 - Changes for Live Portlet
334 ,p_live_portlet IN VARCHAR2 DEFAULT 'N'
335 -- jprabhud 09/24/02 - Enh. 2470068 DB Graph HTML - Reusing file Ids to store graphs - added function name
336 ,p_function_name IN VARCHAR2 DEFAULT NULL
337 --jprabhud - 12/20/02 - NLS Bug 2320171 Graph Fonts and Mutli-Byte characters - passed in p_context_values
338 ,p_context_values IN VARCHAR2 DEFAULT NULL
339 );
340
341 -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
342 PROCEDURE delete_schedule_preferences
343 ( pScheduleId IN number
344 ,pUserId IN number default NULL
345 ,pPlugId IN number default NULL
346 );
347
348 -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
349 PROCEDURE cancelRequest(pRequestId IN NUMBER);
350
351 -- mdamle 09/19/01 - Trap File_ID creation error
352 procedure fndLobsError( pResponsibilityId IN number
353 ,pSessionId IN number
354 ,pReportName IN varchar2);
355
356 -- mdamle 12/27/01
357 procedure updateTitleInPortal( p_schedule_id IN NUMBER,
358 p_plug_id IN NUMBER,
359 p_title IN VARCHAR2);
360
361 procedure savePortletSettings( p_schedule_id in varchar2,
362 p_request_type in varchar2,
363 p_graph_type in varchar2,
364 p_title in varchar2,
365 p_user_id in varchar2,
366 p_plug_id in varchar2);
367
368
369 -- mdamle 01/16/2002
370 procedure updateExternalSource( p_schedule_id in varchar2,
371 p_file_id in varchar2,
372 p_external_source_id in varchar2);
373
374 -- serao -1/17/2002
375 procedure expireExistingFile(
376 p_schedule_id in varchar2,
377 p_file_id in varchar2,
378 o_external_source_id OUT NOCOPY VARCHAR2
379 );
380
381 PROCEDURE getSchedulePageDetails
382 (pRegionCode IN VARCHAR2
383 ,pFunctionName IN VARCHAR2
384 ,pResponsibilityId IN VARCHAR2
385 ,pApplicationId IN VARCHAR2
386 ,pSessionId IN VARCHAR2
387 ,pUserId IN VARCHAR2
388 ,pViewBy IN VARCHAR2
389 ,pReportTitle IN VARCHAR2 default NULL
390 ,pRequestType IN VARCHAR2 default NULL
391 ,pPlugId IN VARCHAR2 default NULL
392 ,pParmPrint IN VARCHAR2 default NULL
393 ,pGraphType IN VARCHAR2 default NULL
394 ,xPageFunctionId OUT NOCOPY NUMBER
395 ,xSessionId OUT NOCOPY NUMBER
396 ,xRespId OUT NOCOPY VARCHAR2
397 ,xApplicationId OUT NOCOPY VARCHAR2
398 ,xParams OUT NOCOPY VARCHAR2
399 ,xsecurityGroupId OUT NOCOPY NUMBER
400 ,xWebHtmlCall OUT NOCOPY VARCHAR2
401 );
402
403
404 END BIS_RG_SCHEDULES_PVT;