478: );
479: END IF;
480:
481: -- Update display name
482: UPDATE icx_portlet_customizations
483: SET title = p_portlet_name, caching_key = to_char(to_number(caching_key)+1)
484: WHERE reference_path = p_reference_path;
485:
486: COMMIT;
615: p_user_id,
616: p_user_id
617: );
618:
619: UPDATE icx_portlet_customizations
620: SET plug_id = l_plug_id
621: WHERE reference_path = p_reference_path;
622:
623: END IF;
622:
623: END IF;
624:
625: -- Update display name
626: UPDATE icx_portlet_customizations
627: SET title = p_portlet_name, caching_key = to_char(to_number(caching_key)+1)
628: WHERE reference_path = p_reference_path;
629:
630: COMMIT;
818: reference_path = p_reference_path;
819:
820:
821: --Upadte icx customizations
822: UPDATE icx_portlet_customizations
823: SET caching_key = to_char(to_number(NVL(caching_key, 0))+1)
824: WHERE reference_path = p_reference_path;
825:
826: IF(l_commit = FND_API.G_TRUE) THEN