DBA Data[Home] [Help]

APPS.BIS_TREND_PLUG dependencies on FND_LOBS

Line 203: -- mdamle 04/05/2001 - Get Graph and Table HTML from FND_LOBS

199: ||'>');
200:
201: end get_graph_from_URL;
202:
203: -- mdamle 04/05/2001 - Get Graph and Table HTML from FND_LOBS
204: procedure Show(p_session_id in pls_integer default NULL,
205: p_plug_id in pls_integer default NULL,
206: p_display_name varchar2 default NULL,
207: p_delete in varchar2 default 'N')

Line 271: delete fnd_lobs where file_id = vGraphFileId;

267: -- Delete Portlet data and schedule info now that portlet is deleted
268: -- jprabhud 09/24/02 - Enh. 2470068 DB Graph HTML - Reusing file Ids to store graphs - passed in vGraphFileId
269: bis_rg_schedules_pvt.delete_portlet(p_plug_id, l_user_id,vGraphFileId);
270: if vGraphFileId is not null then
271: delete fnd_lobs where file_id = vGraphFileId;
272: end if;
273:
274:
275: else

Line 299: FROM bis_scheduler s, bis_schedule_preferences sp, fnd_form_functions ff, fnd_lobs l

295: , l_parameters
296: , l_fn_responsibility_id
297: , l_schedule_id
298: , l_file_content_type
299: FROM bis_scheduler s, bis_schedule_preferences sp, fnd_form_functions ff, fnd_lobs l
300: WHERE sp.USER_ID = l_user_id
301: AND sp.PLUG_ID = p_plug_id
302: AND sp.schedule_id = s.schedule_id
303: AND ff.function_name = s.function_name