APPS.BSC_PORTLET_KPILISTCUST dependencies on ICX_PORTLET_CUSTOMIZATIONS

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

1: package body BSC_PORTLET_KPILISTCUST as
2: /* $Header: BSCPKCB.pls 120.4 2007/02/08 14:11:56 ppandey ship $ */
3:
4: /* Customization table
5: ICX_PORTLET_CUSTOMIZATIONS -- This will be available for anyone to use
6: REFERENCE_PATH NOT NULL VARCHAR2(100)
7: PLUG_ID NUMBER -- Not use in this portlet
8: APPLICATION_ID NUMBER
9: RESPONSIBILITY_ID NUMBER

Line 80: FROM icx_portlet_customizations p

76: l_resp_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;
77:
78: CURSOR c_kg_p IS
79: SELECT p.RESPONSIBILITY_ID
80: FROM icx_portlet_customizations p
81: WHERE
82: p.PLUG_ID = p_plug_id;
83:
84:

Line 305: -- table: ICX_PORTLET_CUSTOMIZATIONS

301: -- update_icx_portlet_cust - changed signature for reference_path
302: --
303: -- PURPOSE
304: -- This procedure is used internally. It is used to update
305: -- table: ICX_PORTLET_CUSTOMIZATIONS
306: --
307: -- PARAMETERS
308: --
309: -- HISTORY

Line 326: ICX_PORTLET_CUSTOMIZATIONS

322: -- Added by Aditya for bug #2891539
323: -- Remove cacheing everytime the portlet is cust.
324:
325: UPDATE
326: ICX_PORTLET_CUSTOMIZATIONS
327: SET
328: CACHING_KEY = TO_CHAR(TO_NUMBER(NVL(caching_key, 0))+1)
329: , RESPONSIBILITY_ID = p_resp_id
330: , TITLE = p_portlet_name

Line 346: -- table: ICX_PORTLET_CUSTOMIZATIONS

342: -- update_icx_portlet_cust
343: --
344: -- PURPOSE
345: -- This procedure is used internally. It is used to update
346: -- table: ICX_PORTLET_CUSTOMIZATIONS
347: --
348: -- PARAMETERS
349: --
350: -- HISTORY

Line 428: -- table: ICX_PORTLET_CUSTOMIZATIONS

424: -- insert_param_id
425: --
426: -- PURPOSE
427: -- This procedure is used internally. It is used to update
428: -- table: ICX_PORTLET_CUSTOMIZATIONS
429: --
430: -- PARAMETERS
431: --
432: -- HISTORY

Line 551: -- update ICX_PORTLET_CUSTOMIZATIONS

547: insert_row(p_plug_id, p_reference_path, p_details_flag, p_group_flag, p_kpi_measure_details_flag, sysdate, p_last_updated_by);
548: END IF; -- (l_count > 0)
549:
550: -------------------------------------
551: -- update ICX_PORTLET_CUSTOMIZATIONS
552: -------------------------------------
553: --DBMS_OUTPUT.PUT_LINE('update_icx_portlet_cust');
554: update_icx_portlet_cust(p_plug_id, p_reference_path, p_resp_id, p_porlet_name);
555: --DBMS_OUTPUT.PUT_LINE('update_indicators');

Line 628: icx_portlet_customizations p

624:
625: CURSOR c_kg_p IS
626: SELECT p.RESPONSIBILITY_ID, NVL(k.DETAILS_FLAG, 0), NVL(k.GROUP_FLAG, 0), p.TITLE, NVL(k.kpi_measure_details_flag, 0)
627: FROM bsc_user_kpilist_plugs k,
628: icx_portlet_customizations p
629: WHERE
630: p.PLUG_ID = p_plug_id AND
631: k.PLUG_ID(+)= p.PLUG_ID;
632: