APPS.BIS_PMV_UTIL dependencies on ICX_PORTLET_CUSTOMIZATIONS

Line 715: update icx_portlet_customizations

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

Line 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)';

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

Line 817: UPDATE icx_portlet_customizations

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:

Line 829: UPDATE icx_portlet_customizations

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: