[Home] [Help]
57: --Added plug_id for Hanging Related Links -ansingh, BugFix 3123327 Removed Into clause
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 ;
67: --Added plug_id for Hanging Related Links -ansingh, BugFix 3123327 Removed Into clause
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
221: END IF ;
222:
223:
224: -- Fix for bug 3006533
225: -- Update the caching_key in icx_portlet_customizations
226:
227: FOR k in l_ref_path_tbl.FIRST..l_ref_path_tbl.LAST LOOP
228:
229: BIS_PMV_UTIL.stale_portlet_by_refPath(l_ref_path_tbl(k).ref_path) ;
460:
461: -- Note : 1. PAGE_ID for OA pages is of the form
462: -- -{MENU_ID}
463: -- Notice the '-' sign
464: -- 2. REFERENCE_PATHS present in ICX_PORTLET_CUSTOMIZATIONS are
465: -- of the form
466: -- %PAGE_ID%
467: -- where '%' represents a string of alpha-numeric characters
468: --BugFix 3417849 make ref_path_tbl as IN OUT
479: l_index NUMBER := 1;
480:
481: CURSOR c_all_ref_paths(p_page_id IN NUMBER) IS
482: select reference_path
483: from icx_portlet_customizations
484: where reference_path like '%' || p_page_id || '%' ;
485:
486:
487: BEGIN