708: /*OPEN c_username;
709: FETCH c_username INTO l_user_name;
710: CLOSE c_username;
711: --Call the ICX provided API to stale this portlet
712: icx_portlet.updateCacheByUserFunc(l_user_name, pfunctionname);*/
713: --UntIl we get the correct API from ICX we are going to do it ourselves.
714:
715: update icx_portlet_customizations
716: set caching_key = TO_CHAR(TO_NUMBER(NVL(caching_key,'0'))+1)
711: --Call the ICX provided API to stale this portlet
712: icx_portlet.updateCacheByUserFunc(l_user_name, pfunctionname);*/
713: --UntIl we get the correct API from ICX we are going to do it ourselves.
714:
715: update icx_portlet_customizations
716: set caching_key = TO_CHAR(TO_NUMBER(NVL(caching_key,'0'))+1)
717: where user_id = puserid and
718: plug_id = pPlugId;
719: EXCEPTION
725: PROCEDURE update_portlets_bypage(p_page_id in varchar2) IS
726: l_append_title varchar2(2000);
727: l_function varchar2(2000);
728: BEGIN
729: l_function := 'update icx_portlet_customizations set caching_key = TO_CHAR(TO_NUMBER(NVL(caching_key,''0''))+1) where reference_path in (select name from wwpob_portlet_instance$ where page_id=:1)';
730:
731: execute immediate l_function using p_page_id;
732:
733: EXCEPTION
813: PROCEDURE stale_portlet_by_refPath (
814: pReferencePath IN VARCHAR2)
815: IS
816: BEGIN
817: UPDATE icx_portlet_customizations
818: SET caching_key = TO_CHAR(TO_NUMBER(NVL(caching_key,'0'))+1)
819: WHERE reference_path = pReferencePath;
820: END stale_portlet_by_refPath;
821:
825: PROCEDURE STALE_PORTLET_BY_PLUGID (pPlugId IN VARCHAR2)
826: IS
827: BEGIN
828:
829: UPDATE icx_portlet_customizations
830: SET caching_key = TO_CHAR(TO_NUMBER(NVL(caching_key,'0'))+1)
831: WHERE plug_id = pPlugId;
832:
833:
942: ) IS
943: lUrl VARCHAR2(2000);
944: BEGIN
945:
946: lUrl := icx_portlet.createExecLink(
947: p_application_id => pApplication_id,
948: p_responsibility_id => pResponsibility_id,
949: p_security_group_id => pSecurity_group_id,
950: p_function_id => pFunction_id,