APPS.BSC_PORTLET_UI_WRAPPER dependencies on BSC_USER_KPIGRAPH_PLUGS

Line 416: l_sql := 'SELECT plug_id FROM bsc_user_kpigraph_plugs'||

412: END IF;
413:
414: -- Get the plug_id. We need to continue using it because
415: -- it is part of the key of the table.
416: l_sql := 'SELECT plug_id FROM bsc_user_kpigraph_plugs'||
417: ' WHERE reference_path = :1';
418: OPEN l_cursor FOR l_sql USING p_reference_path;
419: FETCH l_cursor INTO l_plug_id;
420: IF l_cursor%NOTFOUND THEN

Line 433: bsc_user_kpigraph_plugs

429: COUNT(*)
430: INTO
431: l_count
432: FROM
433: bsc_user_kpigraph_plugs
434: WHERE
435: -- user_id = p_user_id AND -- BUG 4136961, user level customization is not supported.
436: reference_path = p_reference_path;
437:

Line 443: bsc_user_kpigraph_plugs

439:
440: IF l_count > 0 THEN
441: -- Update record
442: UPDATE
443: bsc_user_kpigraph_plugs
444: SET
445: responsibility_id = p_resp_id,
446: parameter_string = l_parameters,
447: last_update_date = SYSDATE,

Line 454: INSERT INTO bsc_user_kpigraph_plugs (

450: -- user_id = p_user_id AND -- BUG 4136961, user level customization is not supported.
451: reference_path = p_reference_path;
452: ELSE
453: -- Insert
454: INSERT INTO bsc_user_kpigraph_plugs (
455: user_id,
456: plug_id,
457: reference_path,
458: responsibility_id,

Line 554: l_sql := 'SELECT plug_id FROM bsc_user_kpigraph_plugs'||

550: END IF;
551:
552: -- Get the plug_id. We need to continue using it because
553: -- it is part of the key of the table.
554: l_sql := 'SELECT plug_id FROM bsc_user_kpigraph_plugs'||
555: ' WHERE reference_path = :1';
556: OPEN l_cursor FOR l_sql USING p_reference_path;
557: FETCH l_cursor INTO l_plug_id;
558: IF l_cursor%NOTFOUND THEN

Line 571: bsc_user_kpigraph_plugs

567: COUNT(*)
568: INTO
569: l_count
570: FROM
571: bsc_user_kpigraph_plugs
572: WHERE
573: -- user_id = p_user_id AND -- BUG 4136961, user level customization is not supported.
574: reference_path = p_reference_path;
575:

Line 581: bsc_user_kpigraph_plugs

577:
578: IF l_count > 0 THEN
579: -- Update record
580: UPDATE
581: bsc_user_kpigraph_plugs
582: SET
583: responsibility_id = p_resp_id,
584: indicator = p_kpi_code,
585: parameter_string = l_parameters,

Line 593: INSERT INTO bsc_user_kpigraph_plugs (

589: -- user_id = p_user_id AND -- BUG 4136961, user level customization is not supported.
590: reference_path = p_reference_path;
591: ELSE
592: -- Insert
593: INSERT INTO bsc_user_kpigraph_plugs (
594: user_id,
595: plug_id,
596: reference_path,
597: responsibility_id,

Line 796: bsc_user_kpigraph_plugs

792: last_update_date
793: INTO
794: last_update_date_from_portlet
795: FROM
796: bsc_user_kpigraph_plugs
797: WHERE
798: user_id = p_user_id AND
799: reference_path = p_reference_path ;
800:

Line 808: --Update bsc_user_kpigraph_plugs

804: IF(last_update_date_from_designer > last_update_date_from_portlet) THEN
805:
806: l_parameters := 'pTabId='||p_tab_id||'&'||'pViewId='||p_view_id;
807:
808: --Update bsc_user_kpigraph_plugs
809: UPDATE
810: bsc_user_kpigraph_plugs
811: SET
812: responsibility_id = p_resp_id,

Line 810: bsc_user_kpigraph_plugs

806: l_parameters := 'pTabId='||p_tab_id||'&'||'pViewId='||p_view_id;
807:
808: --Update bsc_user_kpigraph_plugs
809: UPDATE
810: bsc_user_kpigraph_plugs
811: SET
812: responsibility_id = p_resp_id,
813: parameter_string = l_parameters,
814: last_update_date = SYSDATE,