APPS.BIS_PMV_PORTAL_UTIL_PVT dependencies on BIS_SCHEDULE_PREFERENCES

Line 62: bis_schedule_preferences bs

58: CURSOR c_all_schedules(p_ref_path IN VARCHAR2) IS
59: SELECT bs.schedule_id, bs.plug_id
60: FROM
61: icx_portlet_customizations ipc,
62: bis_schedule_preferences bs
63: WHERE
64: bs.plug_id = ipc.plug_id and
65: ipc.reference_path = p_ref_path ;
66:

Line 72: bis_schedule_preferences bs

68: CURSOR c_user_schedules(p_ref_path IN VARCHAR2) IS
69: SELECT bs.schedule_id, bs.user_id, bs.plug_id
70: FROM
71: icx_portlet_customizations ipc,
72: bis_schedule_preferences bs
73: WHERE
74: bs.plug_id = ipc.plug_id AND
75: ipc.reference_path = p_ref_path AND
76: bs.user_id = g_user_id ;

Line 325: delete from bis_schedule_preferences

321:
322: IF (g_user_id = -1) OR (g_user_id IS NULL) THEN
323:
324: FORALL i in p_schedule_ids.FIRST..p_schedule_ids.LAST
325: delete from bis_schedule_preferences
326: where schedule_id = p_schedule_ids(i) ;
327:
328: FORALL i in p_schedule_ids.FIRST..p_schedule_ids.LAST
329: delete from bis_scheduler

Line 334: delete from bis_schedule_preferences

330: where schedule_id = p_schedule_ids(i) ;
331: ELSE
332:
333: FORALL i in p_schedule_ids.FIRST..p_schedule_ids.LAST
334: delete from bis_schedule_preferences
335: where schedule_id = p_schedule_ids(i)
336: and user_id = g_user_id;
337:
338: FORALL i in p_schedule_ids.FIRST..p_schedule_ids.LAST