APPS.BSC_PORTLET_KPILISTCUST dependencies on BSC_USER_KPILIST_KPIS

Line 448: DELETE from bsc_user_kpilist_kpis

444:
445:
446: BEGIN
447:
448: DELETE from bsc_user_kpilist_kpis
449: WHERE plug_id = p_plug_id;
450:
451: INSERT INTO bsc_user_kpilist_kpis (
452: PLUG_ID,

Line 451: INSERT INTO bsc_user_kpilist_kpis (

447:
448: DELETE from bsc_user_kpilist_kpis
449: WHERE plug_id = p_plug_id;
450:
451: INSERT INTO bsc_user_kpilist_kpis (
452: PLUG_ID,
453: PARAM_LIST_ID,
454: CREATION_DATE,
455: CREATED_BY,

Line 490: -- FROM bsc_user_kpilist_kpis ek

486: bup. VIEW_TYPE = 1;
487:
488: -- bup.PARAM_LIST_ID NOT IN (
489: -- SELECT ek.PARAM_LIST_ID
490: -- FROM bsc_user_kpilist_kpis ek
491: -- WHERE ek.plug_id = p_plug_id
492: -- );
493: END insert_param_id;
494:

Line 667: FROM bsc_user_kpilist_kpis

663: CLOSE c_kg_p;
664:
665: -- checks if there is any selected kpis
666: SELECT COUNT(*) INTO l_num_sel_kpis
667: FROM bsc_user_kpilist_kpis
668: WHERE plug_id = p_plug_id;
669:
670:
671: IF (l_num_sel_kpis = 0 ) THEN