APPS.BIS_PORTLET_PMREGION dependencies on ICX_PORTLET_CUSTOMIZATIONS

Line 5: ICX_PORTLET_CUSTOMIZATIONS -- This will be available for anyone to use

1: package body BIS_PORTLET_PMREGION as
2: /* $Header: BISPPMRB.pls 120.2 2005/11/11 04:45:16 visuri noship $ */
3:
4: /* Customization tables
5: ICX_PORTLET_CUSTOMIZATIONS -- This will be available for anyone to use
6: REFERENCE_PATH NOT NULL VARCHAR2(1000)
7: PLUG_ID NUMBER -- Not use in this portlet
8: APPLICATION_ID NUMBER
9: RESPONSIBILITY_ID NUMBER

Line 776: from ICX_PORTLET_CUSTOMIZATIONS

772: -- IF icx_portlet.validateSession THEN
773: BEGIN
774: select PLUG_ID
775: into l_plug_id
776: from ICX_PORTLET_CUSTOMIZATIONS
777: where REFERENCE_PATH = p_reference_path;
778: EXCEPTION
779: when no_data_found then
780: l_plug_id := -1;

Line 794: FROM ICX_PORTLET_CUSTOMIZATIONS

790: WHERE PLUG_ID = l_plug_id;
791:
792:
793: DELETE
794: FROM ICX_PORTLET_CUSTOMIZATIONS
795: WHERE REFERENCE_PATH = p_reference_path;
796: END IF;
797: -- END IF; -- icx_portlet.validateSession
798:

Line 4029: UPDATE icx_portlet_customizations

4025:
4026: -- 2418741 owa_util.redirect_url(p_back_url);
4027:
4028: IF (p_reference_path IS NOT NULL) THEN
4029: UPDATE icx_portlet_customizations
4030: SET caching_key = TO_CHAR(NVL(caching_key, 0) + 1)
4031: WHERE reference_path = p_reference_path;
4032: COMMIT;
4033: END IF;

Line 5714: FROM ICX_PORTLET_CUSTOMIZATIONS

5710: l_ref_path VARCHAR2(100);
5711:
5712: CURSOR c_ipc IS
5713: SELECT REFERENCE_PATH
5714: FROM ICX_PORTLET_CUSTOMIZATIONS
5715: WHERE PLUG_ID = p_plug_id;
5716:
5717: BEGIN
5718: