eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_CUSTOM_VIEW_UI_WRAPPER SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4


PROCEDURE add_or_update_kpi_trend(
  p_tab_id            IN NUMBER
 ,p_tab_view_id       IN NUMBER
 ,p_object_id         IN NUMBER
 ,p_text_flag         IN NUMBER
 ,p_label_text        IN VARCHAR2
 ,p_font_size         IN NUMBER
 ,p_font_style        IN NUMBER
 ,p_font_color        IN NUMBER
 ,p_left              IN NUMBER
 ,p_top               IN NUMBER
 ,p_width             IN NUMBER
 ,p_height            IN NUMBER
 ,p_kpi_id            IN NUMBER
 ,p_function_id       IN NUMBER
 ,x_return_status     OUT NOCOPY VARCHAR2
 ,x_msg_count         OUT NOCOPY NUMBER
 ,x_msg_data          OUT NOCOPY VARCHAR2
);

Line: 60


   SELECT label_id
   FROM BSC_TAB_VIEW_LABELS_B
   WHERE tab_id = p_tab_id
   AND tab_view_id = p_tab_view_id
   ORDER BY label_id;

Line: 75


    UPDATE BSC_TAB_VIEW_LABELS_B
    SET label_id = l_count
    WHERE tab_id = p_tab_id
    AND tab_view_id = p_tab_view_id
    AND label_id = l_label_cur.label_id;

Line: 81


    UPDATE BSC_TAB_VIEW_LABELS_TL
    SET label_id = l_count
    WHERE tab_id = p_tab_id
    AND tab_view_id = p_tab_view_id
    AND label_id = l_label_cur.label_id;

Line: 110


  DELETE FROM BSC_TAB_VIEW_LABELS_TL
  WHERE TAB_ID = p_tab_id
  AND TAB_VIEW_ID = p_tab_view_id;

Line: 114


  DELETE FROM BSC_TAB_VIEW_LABELS_B
  WHERE TAB_ID = p_tab_id
  AND TAB_VIEW_ID = p_tab_view_id;

Line: 118


  DELETE FROM BSC_TAB_VIEW_KPI_TL
  WHERE TAB_ID = p_tab_id
  AND TAB_VIEW_ID = p_tab_view_id;

Line: 148


   SELECT indicator
   FROM bsc_tab_view_kpi_vl
   WHERE tab_id = p_tab_id
   AND tab_view_id = p_tab_view_id;

Line: 155


   SELECT label_id
   FROM bsc_tab_view_labels_vl
   WHERE tab_id = p_tab_id
   AND tab_view_id = p_tab_view_id;

Line: 183


      BSC_TAB_VIEW_KPI_PKG.DELETE_ROW (
        X_TAB_ID => p_tab_id,
        X_TAB_VIEW_ID => p_tab_view_id,
        X_INDICATOR => l_kpi_cur.indicator
      );

Line: 195


      BSC_TAB_VIEW_LABELS_PKG.DELETE_ROW (
        X_TAB_ID => p_tab_id,
        X_TAB_VIEW_ID => p_tab_view_id,
        X_LABEL_ID => l_label_cur.label_id
      );

Line: 211


PROCEDURE add_or_update_kpi_actual(
  p_tab_id            IN NUMBER
 ,p_tab_view_id       IN NUMBER
 ,p_object_id         IN NUMBER
 ,p_text_flag         IN NUMBER
 ,p_label_text        IN VARCHAR2
 ,p_font_size         IN NUMBER
 ,p_font_style        IN NUMBER
 ,p_font_color        IN NUMBER
 ,p_left              IN NUMBER
 ,p_top               IN NUMBER
 ,p_width             IN NUMBER
 ,p_height            IN NUMBER
 ,p_kpi_id            IN NUMBER
 ,p_function_id       IN NUMBER
 ,x_return_status     OUT NOCOPY VARCHAR2
 ,x_msg_count         OUT NOCOPY NUMBER
 ,x_msg_data          OUT NOCOPY VARCHAR2
) IS
BEGIN
  SAVEPOINT RollBackPt;

Line: 235


  BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
    p_tab_id => p_tab_id
   ,p_tab_view_id => p_tab_view_id
   ,p_object_id => p_object_id
   ,p_object_type => c_type_kpi_actual
   ,p_label_text => p_label_text
   ,p_text_flag => p_text_flag
   ,p_font_color => p_font_color
   ,p_font_size => p_font_size
   ,p_font_style => p_font_style
   ,p_left => p_left
   ,p_top => p_top
   ,p_width => p_width
   ,p_height => p_height
   ,p_note_text => NULL
   ,p_link_id => p_kpi_id
   ,p_function_id => p_function_id
   ,x_return_status => x_return_status
   ,x_msg_count => x_msg_count
   ,x_msg_data => x_msg_data
  );

Line: 262


END add_or_update_kpi_actual;

Line: 265


PROCEDURE add_or_update_kpi_change(
  p_tab_id            IN NUMBER
 ,p_tab_view_id       IN NUMBER
 ,p_object_id         IN NUMBER
 ,p_text_flag         IN NUMBER
 ,p_label_text        IN VARCHAR2
 ,p_font_size         IN NUMBER
 ,p_font_style        IN NUMBER
 ,p_font_color        IN NUMBER
 ,p_left              IN NUMBER
 ,p_top               IN NUMBER
 ,p_width             IN NUMBER
 ,p_height            IN NUMBER
 ,p_kpi_id            IN NUMBER
 ,p_function_id       IN NUMBER
 ,x_return_status     OUT NOCOPY VARCHAR2
 ,x_msg_count         OUT NOCOPY NUMBER
 ,x_msg_data          OUT NOCOPY VARCHAR2
) IS
BEGIN
  SAVEPOINT RollBackPt;

Line: 289


  BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
    p_tab_id => p_tab_id
   ,p_tab_view_id => p_tab_view_id
   ,p_object_id => p_object_id
   ,p_object_type => c_type_kpi_change
   ,p_label_text => p_label_text
   ,p_text_flag => p_text_flag
   ,p_font_color => p_font_color
   ,p_font_size => p_font_size
   ,p_font_style => p_font_style
   ,p_left => p_left
   ,p_top => p_top
   ,p_width => p_width
   ,p_height => p_height
   ,p_note_text => NULL
   ,p_link_id => p_kpi_id
   ,p_function_id => p_function_id
   ,x_return_status => x_return_status
   ,x_msg_count => x_msg_count
   ,x_msg_data => x_msg_data
  );

Line: 316


END add_or_update_kpi_change;

Line: 319


PROCEDURE add_or_update_kpi_label(
  p_tab_id            IN NUMBER
 ,p_tab_view_id       IN NUMBER
 ,p_object_id         IN NUMBER
 ,p_text_flag         IN NUMBER
 ,p_label_text        IN VARCHAR2
 ,p_font_size         IN NUMBER
 ,p_font_style        IN NUMBER
 ,p_font_color        IN NUMBER
 ,p_left              IN NUMBER
 ,p_top               IN NUMBER
 ,p_width             IN NUMBER
 ,p_height            IN NUMBER
 ,p_kpi_id            IN NUMBER
 ,p_function_id       IN NUMBER
 ,x_return_status     OUT NOCOPY VARCHAR2
 ,x_msg_count         OUT NOCOPY NUMBER
 ,x_msg_data          OUT NOCOPY VARCHAR2
) IS
BEGIN
  SAVEPOINT RollBackPt;

Line: 343


  BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
    p_tab_id => p_tab_id
   ,p_tab_view_id => p_tab_view_id
   ,p_object_id => p_object_id
   ,p_object_type => c_type_kpi
   ,p_label_text => p_label_text
   ,p_text_flag => p_text_flag
   ,p_font_color => p_font_color
   ,p_font_size => p_font_size
   ,p_font_style => p_font_style
   ,p_left => p_left
   ,p_top => p_top
   ,p_width => p_width
   ,p_height => p_height
   ,p_note_text => NULL
   ,p_link_id => p_kpi_id
   ,p_function_id => p_function_id
   ,x_return_status => x_return_status
   ,x_msg_count => x_msg_count
   ,x_msg_data => x_msg_data
  );

Line: 370


END add_or_update_kpi_label;

Line: 376


PROCEDURE add_or_update_kpi(
  p_tab_id            IN NUMBER
 ,p_tab_view_id       IN NUMBER
 ,p_object_id         IN NUMBER
 ,p_kpi_id            IN NUMBER
 ,p_text_flag         IN NUMBER
 ,p_font_size         IN NUMBER
 ,p_font_style        IN NUMBER
 ,p_font_color        IN NUMBER
 ,p_hotspot_left      IN NUMBER
 ,p_hotspot_top       IN NUMBER
 ,p_hotspot_width     IN NUMBER
 ,p_hotspot_height    IN NUMBER
 ,p_alarm_left        IN NUMBER
 ,p_alarm_top         IN NUMBER
 ,p_alarm_width       IN NUMBER
 ,p_alarm_height      IN NUMBER
 ,p_actual_object_id  IN NUMBER
 ,p_actual_flag       IN NUMBER
 ,p_actual_left       IN NUMBER
 ,p_actual_top        IN NUMBER
 ,p_actual_width      IN NUMBER
 ,p_actual_height     IN NUMBER
 ,p_change_object_id  IN NUMBER
 ,p_change_flag       IN NUMBER
 ,p_change_left       IN NUMBER
 ,p_change_top        IN NUMBER
 ,p_change_width      IN NUMBER
 ,p_change_height     IN NUMBER
 ,p_link_function_id  IN NUMBER
 ,p_trend_object_id   IN NUMBER
 ,p_trend_flag        IN NUMBER
 ,p_trend_left        IN NUMBER
 ,p_trend_top         IN NUMBER
 ,p_trend_width       IN NUMBER
 ,p_trend_height      IN NUMBER
 ,x_return_status     OUT NOCOPY VARCHAR2
 ,x_msg_count         OUT NOCOPY NUMBER
 ,x_msg_data          OUT NOCOPY VARCHAR2
) IS
BEGIN
  SAVEPOINT RollBackPt;

Line: 423


  add_or_update_kpi_label(
    p_tab_id => p_tab_id
   ,p_tab_view_id => p_tab_view_id
   ,p_object_id => p_object_id
   ,p_text_flag => p_text_flag
   ,p_label_text => c_kpi
   ,p_font_size => p_font_size
   ,p_font_color => p_font_color
   ,p_font_style => p_font_style
   ,p_left => p_hotspot_left
   ,p_top => p_hotspot_top
   ,p_width => p_hotspot_width
   ,p_height => p_hotspot_height
   ,p_kpi_id => p_kpi_id
   ,p_function_id => p_link_function_id
   ,x_return_status => x_return_status
   ,x_msg_count => x_msg_count
   ,x_msg_data => x_msg_data
  );

Line: 444


  BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_kpi(
    p_tab_id => p_tab_id
   ,p_tab_view_id => p_tab_view_id
   ,p_kpi_id => p_kpi_id
   ,p_text_flag => p_text_flag
   ,p_font_size => p_font_size
   ,p_font_style => p_font_style
   ,p_font_color => p_font_color
   ,p_hotspot_left => p_hotspot_left
   ,p_hotspot_top => p_hotspot_top
   ,p_hotspot_width => p_hotspot_width
   ,p_hotspot_height => p_hotspot_height
   ,p_alarm_left => p_alarm_left
   ,p_alarm_top => p_alarm_top
   ,p_alarm_width => p_alarm_width
   ,p_alarm_height => p_alarm_height
   ,x_return_status => x_return_status
   ,x_msg_count => x_msg_count
   ,x_msg_data => x_msg_data
  );

Line: 466


  add_or_update_kpi_actual(
    p_tab_id => p_tab_id
   ,p_tab_view_id => p_tab_view_id
   ,p_object_id => p_actual_object_id
   ,p_text_flag => p_actual_flag
   ,p_label_text => c_kpi_actual
   ,p_font_size => p_font_size
   ,p_font_color => p_font_color
   ,p_font_style => p_font_style
   ,p_left => p_actual_left
   ,p_top => p_actual_top
   ,p_width => p_actual_width
   ,p_height => p_actual_height
   ,p_kpi_id => p_kpi_id
   ,p_function_id => p_link_function_id
   ,x_return_status => x_return_status
   ,x_msg_count => x_msg_count
   ,x_msg_data => x_msg_data
  );

Line: 487


  add_or_update_kpi_change(
    p_tab_id => p_tab_id
   ,p_tab_view_id => p_tab_view_id
   ,p_object_id => p_change_object_id
   ,p_text_flag => p_change_flag
   ,p_label_text => c_kpi_change
   ,p_font_size => p_font_size
   ,p_font_color => p_font_color
   ,p_font_style => p_font_style
   ,p_left => p_change_left
   ,p_top => p_change_top
   ,p_width => p_change_width
   ,p_height => p_change_height
   ,p_kpi_id => p_kpi_id
   ,p_function_id=> p_link_function_id
   ,x_return_status => x_return_status
   ,x_msg_count => x_msg_count
   ,x_msg_data => x_msg_data
  );

Line: 509


 add_or_update_kpi_trend(
    p_tab_id => p_tab_id
   ,p_tab_view_id => p_tab_view_id
   ,p_object_id => p_trend_object_id
   ,p_text_flag => p_trend_flag
   ,p_label_text => c_kpi_trend
   ,p_font_size => p_font_size
   ,p_font_color => p_font_color
   ,p_font_style => p_font_style
   ,p_left => p_trend_left
   ,p_top => p_trend_top
   ,p_width => p_trend_width
   ,p_height => p_trend_height
   ,p_kpi_id => p_kpi_id
   ,p_function_id=> p_link_function_id
   ,x_return_status => x_return_status
   ,x_msg_count => x_msg_count
   ,x_msg_data => x_msg_data
  );

Line: 535


END add_or_update_kpi;

Line: 539


PROCEDURE add_or_update_label(
  p_tab_id            IN NUMBER
 ,p_tab_view_id       IN NUMBER
 ,p_object_id         IN NUMBER
 ,p_label_text        IN VARCHAR2
 ,p_font_size         IN NUMBER
 ,p_font_style        IN NUMBER
 ,p_font_color        IN NUMBER
 ,p_left              IN NUMBER
 ,p_top               IN NUMBER
 ,p_width             IN NUMBER
 ,p_height            IN NUMBER
 ,x_return_status     OUT NOCOPY VARCHAR2
 ,x_msg_count         OUT NOCOPY NUMBER
 ,x_msg_data          OUT NOCOPY VARCHAR2
) IS
BEGIN
  SAVEPOINT RollBackPt;

Line: 560


  BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
    p_tab_id => p_tab_id
   ,p_tab_view_id => p_tab_view_id
   ,p_object_id => p_object_id
   ,p_object_type => c_type_label
   ,p_label_text => p_label_text
   ,p_text_flag => 1
   ,p_font_color => p_font_color
   ,p_font_size => p_font_size
   ,p_font_style => p_font_style
   ,p_left => p_left
   ,p_top => p_top
   ,p_width => p_width
   ,p_height => p_height
   ,p_note_text => NULL
   ,p_link_id => NULL
   ,p_function_id => NULL
   ,x_return_status => x_return_status
   ,x_msg_count => x_msg_count
   ,x_msg_data => x_msg_data
  );

Line: 587


END add_or_update_label;

Line: 590


PROCEDURE add_or_update_hotspot(
  p_tab_id            IN NUMBER
 ,p_tab_view_id       IN NUMBER
 ,p_object_id         IN NUMBER
 ,p_label_text        IN VARCHAR2
 ,p_left              IN NUMBER
 ,p_top               IN NUMBER
 ,p_width             IN NUMBER
 ,p_height            IN NUMBER
 ,x_return_status     OUT NOCOPY VARCHAR2
 ,x_msg_count         OUT NOCOPY NUMBER
 ,x_msg_data          OUT NOCOPY VARCHAR2
) IS
BEGIN
  SAVEPOINT RollBackPt;

Line: 608


  BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
    p_tab_id => p_tab_id
   ,p_tab_view_id => p_tab_view_id
   ,p_object_id => p_object_id
   ,p_object_type => c_type_hotspot
   ,p_label_text => p_label_text
   ,p_text_flag => 0
   ,p_font_color => 1
   ,p_font_size => 1
   ,p_font_style => 1
   ,p_left => p_left
   ,p_top => p_top
   ,p_width => p_width
   ,p_height => p_height
   ,p_note_text => NULL
   ,p_link_id => NULL
   ,p_function_id => NULL
   ,x_return_status => x_return_status
   ,x_msg_count => x_msg_count
   ,x_msg_data => x_msg_data
  );

Line: 635


END add_or_update_hotspot;

Line: 638


PROCEDURE add_or_update_custom_view_link(
  p_tab_id            IN NUMBER
 ,p_tab_view_id       IN NUMBER
 ,p_object_id         IN NUMBER
 ,p_text_flag         IN NUMBER
 ,p_label_text        IN VARCHAR2
 ,p_font_size         IN NUMBER
 ,p_font_style        IN NUMBER
 ,p_font_color        IN NUMBER
 ,p_left              IN NUMBER
 ,p_top               IN NUMBER
 ,p_width             IN NUMBER
 ,p_height            IN NUMBER
 ,p_link_tab_view_id  IN NUMBER
 ,x_return_status     OUT NOCOPY VARCHAR2
 ,x_msg_count         OUT NOCOPY NUMBER
 ,x_msg_data          OUT NOCOPY VARCHAR2
) IS
BEGIN
  SAVEPOINT RollBackPt;

Line: 661


  BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
    p_tab_id => p_tab_id
   ,p_tab_view_id => p_tab_view_id
   ,p_object_id => p_object_id
   ,p_object_type => c_type_link
   ,p_label_text => p_label_text
   ,p_text_flag => p_text_flag
   ,p_font_color => p_font_color
   ,p_font_size => p_font_size
   ,p_font_style => p_font_style
   ,p_left => p_left
   ,p_top => p_top
   ,p_width => p_width
   ,p_height => p_height
   ,p_note_text => NULL
   ,p_link_id => p_link_tab_view_id
   ,p_function_id => NULL
   ,x_return_status => x_return_status
   ,x_msg_count => x_msg_count
   ,x_msg_data => x_msg_data
  );

Line: 688


END add_or_update_custom_view_link;

Line: 691


PROCEDURE add_or_update_launch_pad(
  p_tab_id            IN NUMBER
 ,p_tab_view_id       IN NUMBER
 ,p_object_id         IN NUMBER
 ,p_label_text        IN VARCHAR2
 ,p_note_text         IN VARCHAR2
 ,p_left              IN NUMBER
 ,p_top               IN NUMBER
 ,p_width             IN NUMBER
 ,p_height            IN NUMBER
 ,p_menu_id           IN NUMBER
 ,x_return_status     OUT NOCOPY VARCHAR2
 ,x_msg_count         OUT NOCOPY NUMBER
 ,x_msg_data          OUT NOCOPY VARCHAR2
) IS
BEGIN
  SAVEPOINT RollBackPt;

Line: 711


  BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
    p_tab_id => p_tab_id
   ,p_tab_view_id => p_tab_view_id
   ,p_object_id => p_object_id
   ,p_object_type => c_type_launch_pad
   ,p_label_text => p_label_text
   ,p_text_flag => 0
   ,p_font_color => -16777216
   ,p_font_size => 1
   ,p_font_style => 0
   ,p_left => p_left
   ,p_top => p_top
   ,p_width => p_width
   ,p_height => p_height
   ,p_note_text => p_note_text
   ,p_link_id => p_menu_id
   ,p_function_id => NULL
   ,x_return_status => x_return_status
   ,x_msg_count => x_msg_count
   ,x_msg_data => x_msg_data
  );

Line: 738


END add_or_update_launch_pad;

Line: 741


PROCEDURE add_or_update_measure(
  p_tab_id             IN NUMBER
 ,p_tab_view_id        IN NUMBER
 ,p_text_object_id     IN NUMBER
 ,p_text_flag          IN NUMBER
 ,p_font_size          IN NUMBER
 ,p_font_style         IN NUMBER
 ,p_font_color         IN NUMBER
 ,p_text_left          IN NUMBER
 ,p_text_top           IN NUMBER
 ,p_text_width         IN NUMBER
 ,p_text_height        IN NUMBER
 ,p_slider_object_id   IN NUMBER
 ,p_slider_flag        IN NUMBER
 ,p_slider_left        IN NUMBER
 ,p_slider_top         IN NUMBER
 ,p_slider_width       IN NUMBER
 ,p_slider_height      IN NUMBER
 ,p_actual_object_id   IN NUMBER
 ,p_actual_flag        IN NUMBER
 ,p_actual_left        IN NUMBER
 ,p_actual_top         IN NUMBER
 ,p_actual_width       IN NUMBER
 ,p_actual_height      IN NUMBER
 ,p_change_object_id   IN NUMBER
 ,p_change_flag        IN NUMBER
 ,p_change_left        IN NUMBER
 ,p_change_top         IN NUMBER
 ,p_change_width       IN NUMBER
 ,p_change_height      IN NUMBER
 ,p_indicator_id       IN NUMBER
 ,p_function_id        IN NUMBER
 ,x_return_status      OUT NOCOPY VARCHAR2
 ,x_msg_count          OUT NOCOPY NUMBER
 ,x_msg_data           OUT NOCOPY VARCHAR2
) IS
BEGIN
  SAVEPOINT RollBackPt;

Line: 783


  BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
    p_tab_id => p_tab_id
   ,p_tab_view_id => p_tab_view_id
   ,p_object_id => p_text_object_id
   ,p_object_type => c_type_measure
   ,p_label_text => c_measure
   ,p_text_flag => p_text_flag
   ,p_font_color => p_font_color
   ,p_font_size => p_font_size
   ,p_font_style => p_font_style
   ,p_left => p_text_left
   ,p_top => p_text_top
   ,p_width => p_text_width
   ,p_height => p_text_height
   ,p_note_text => NULL
   ,p_link_id => p_indicator_id
   ,p_function_id => p_function_id
   ,x_return_status => x_return_status
   ,x_msg_count => x_msg_count
   ,x_msg_data => x_msg_data
  );

Line: 806


  BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
    p_tab_id => p_tab_id
   ,p_tab_view_id => p_tab_view_id
   ,p_object_id => p_actual_object_id
   ,p_object_type => c_type_measure_actual
   ,p_label_text => c_measure_actual
   ,p_text_flag => p_actual_flag
   ,p_font_color => p_font_color
   ,p_font_size => p_font_size
   ,p_font_style => p_font_style
   ,p_left => p_actual_left
   ,p_top => p_actual_top
   ,p_width => p_actual_width
   ,p_height => p_actual_height
   ,p_note_text => NULL
   ,p_link_id => p_indicator_id
   ,p_function_id => p_function_id
   ,x_return_status => x_return_status
   ,x_msg_count => x_msg_count
   ,x_msg_data => x_msg_data
  );

Line: 829


  BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
    p_tab_id => p_tab_id
   ,p_tab_view_id => p_tab_view_id
   ,p_object_id => p_change_object_id
   ,p_object_type => c_type_measure_change
   ,p_label_text => c_measure_change
   ,p_text_flag => p_change_flag
   ,p_font_color => p_font_color
   ,p_font_size => p_font_size
   ,p_font_style => p_font_style
   ,p_left => p_change_left
   ,p_top => p_change_top
   ,p_width => p_change_width
   ,p_height => p_change_height
   ,p_note_text => NULL
   ,p_link_id => p_indicator_id
   ,p_function_id => p_function_id
   ,x_return_status => x_return_status
   ,x_msg_count => x_msg_count
   ,x_msg_data => x_msg_data
  );

Line: 852


  BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
    p_tab_id => p_tab_id
   ,p_tab_view_id => p_tab_view_id
   ,p_object_id => p_slider_object_id
   ,p_object_type => c_type_measure_slider
   ,p_label_text => c_measure_slider
   ,p_text_flag => p_slider_flag
   ,p_font_color => p_font_color
   ,p_font_size => p_font_size
   ,p_font_style => p_font_style
   ,p_left => p_slider_left
   ,p_top => p_slider_top
   ,p_width => p_slider_width
   ,p_height => p_slider_height
   ,p_note_text => NULL
   ,p_link_id => p_indicator_id
   ,p_function_id => p_function_id
   ,x_return_status => x_return_status
   ,x_msg_count => x_msg_count
   ,x_msg_data => x_msg_data
  );

Line: 879


END add_or_update_measure;

Line: 882


PROCEDURE add_or_update_tab_view_label(
  p_tab_id            IN NUMBER
 ,p_tab_view_id       IN NUMBER
 ,p_object_id         IN NUMBER
 ,p_object_type       IN NUMBER
 ,p_label_text        IN VARCHAR2
 ,p_text_flag         IN NUMBER
 ,p_font_color        IN NUMBER
 ,p_font_size         IN NUMBER
 ,p_font_style        IN NUMBER
 ,p_left              IN NUMBER
 ,p_top               IN NUMBER
 ,p_width             IN NUMBER
 ,p_height            IN NUMBER
 ,p_note_text         IN VARCHAR2
 ,p_link_id           IN NUMBER
 ,p_function_id       IN NUMBER
 ,x_return_status     OUT NOCOPY VARCHAR2
 ,x_msg_count         OUT NOCOPY NUMBER
 ,x_msg_data          OUT NOCOPY VARCHAR2
) IS
 l_str                VARCHAR2(100);

Line: 911


  SELECT count(1) INTO l_count
  FROM bsc_tab_view_labels_vl
  WHERE tab_id = p_tab_id
  AND tab_view_id = p_tab_view_id
  AND label_id = p_object_id;

Line: 921


    SELECT max(label_id)+1 INTO l_object_id
    FROM bsc_tab_view_labels_vl
    WHERE tab_id = p_tab_id
    AND tab_view_id = p_tab_view_id;

Line: 930


  BSC_TAB_VIEW_LABELS_PKG.INSERT_ROW (
    X_ROWID => l_str,
    X_TAB_ID => p_tab_id,
    X_TAB_VIEW_ID => p_tab_view_id,
      X_LABEL_ID => l_object_id,
      X_LABEL_TYPE => p_object_type,
      X_LINK_ID => p_link_id,
      X_NAME => p_label_text,
      X_NOTE => p_note_text,
      X_TEXT_FLAG => p_text_flag,
      X_LEFT_POSITION => p_left,
      X_TOP_POSITION => p_top,
      X_WIDTH => p_width,
      X_HEIGHT => p_height,
      X_FONT_SIZE => p_font_size,
      X_FONT_STYLE => p_font_style,
      X_FONT_COLOR => p_font_color,
      X_URL => null,
      X_FUNCTION_ID => p_function_id,
      X_CREATION_DATE => SYSDATE,
      X_CREATED_BY => fnd_global.user_id,
      X_LAST_UPDATE_DATE => SYSDATE,
      X_LAST_UPDATED_BY => fnd_global.user_id,
      X_LAST_UPDATE_LOGIN => fnd_global.login_id
    );

Line: 957


    BSC_TAB_VIEW_LABELS_PKG.UPDATE_ROW (
      X_TAB_ID => p_tab_id,
      X_TAB_VIEW_ID => p_tab_view_id,
    X_LABEL_ID => p_object_id,
    X_LABEL_TYPE => p_object_type,
    X_LINK_ID => p_link_id,
    X_NAME => p_label_text,
    X_NOTE => p_note_text,
    X_TEXT_FLAG => p_text_flag,
    X_LEFT_POSITION => p_left,
    X_TOP_POSITION => p_top,
    X_WIDTH => p_width,
    X_HEIGHT => p_height,
    X_FONT_SIZE => p_font_size,
    X_FONT_STYLE => p_font_style,
    X_FONT_COLOR => p_font_color,
    X_URL => null,
    X_FUNCTION_ID => p_function_id,
    X_CREATION_DATE => SYSDATE,
    X_CREATED_BY => fnd_global.user_id,
    X_LAST_UPDATE_DATE => SYSDATE,
    X_LAST_UPDATED_BY => fnd_global.user_id,
    X_LAST_UPDATE_LOGIN => fnd_global.login_id
  );

Line: 988


END add_or_update_tab_view_label;

Line: 991


PROCEDURE add_or_update_tab_view_kpi(
  p_tab_id            IN NUMBER
 ,p_tab_view_id       IN NUMBER
 ,p_kpi_id            IN NUMBER
 ,p_text_flag         IN NUMBER
 ,p_font_size         IN NUMBER
 ,p_font_style        IN NUMBER
 ,p_font_color        IN NUMBER
 ,p_hotspot_left      IN NUMBER
 ,p_hotspot_top       IN NUMBER
 ,p_hotspot_width     IN NUMBER
 ,p_hotspot_height    IN NUMBER
 ,p_alarm_left        IN NUMBER
 ,p_alarm_top         IN NUMBER
 ,p_alarm_width       IN NUMBER
 ,p_alarm_height      IN NUMBER
 ,x_return_status     OUT NOCOPY VARCHAR2
 ,x_msg_count         OUT NOCOPY NUMBER
 ,x_msg_data          OUT NOCOPY VARCHAR2
) IS
  l_count             NUMBER;

Line: 1018


  SELECT count(1) INTO l_count
  FROM BSC_TAB_VIEW_KPI_VL
  WHERE TAB_ID = p_tab_id
  AND TAB_VIEW_ID = p_tab_view_id
  AND INDICATOR = p_kpi_id;

Line: 1026


  BSC_TAB_VIEW_KPI_PKG.INSERT_ROW (
    X_ROWID => l_str,
    X_TAB_ID => p_tab_id,
    X_TAB_VIEW_ID => p_tab_view_id,
    X_INDICATOR => p_kpi_id,
    X_TEXT_FLAG => p_text_flag,
    X_LEFT_POSITION => p_hotspot_left,
    X_TOP_POSITION => p_hotspot_top,
    X_WIDTH => p_hotspot_width,
    X_HEIGHT => p_hotspot_height,
    X_FONT_SIZE => p_font_size,
    X_FONT_STYLE => p_font_style,
    X_FONT_COLOR => p_font_color,
    X_COLOR_LEFT_POSITION => p_alarm_left,
    X_COLOR_TOP_POSITION => p_alarm_top,
    X_COLOR_WIDTH => p_alarm_width,
    X_COLOR_HEIGHT => p_alarm_height,
    X_COLOR_SIZE => 0,
    X_CREATION_DATE => SYSDATE,
    X_CREATED_BY => fnd_global.user_id,
    X_LAST_UPDATE_DATE => SYSDATE,
    X_LAST_UPDATED_BY => fnd_global.user_id,
    X_LAST_UPDATE_LOGIN => fnd_global.login_id
  );

Line: 1052


    BSC_TAB_VIEW_KPI_PKG.UPDATE_ROW(
      X_TAB_ID => p_tab_id,
      X_TAB_VIEW_ID => p_tab_view_id,
      X_INDICATOR => p_kpi_id,
      X_TEXT_FLAG => p_text_flag,
      X_LEFT_POSITION => p_hotspot_left,
      X_TOP_POSITION => p_hotspot_top,
      X_WIDTH => p_hotspot_width,
      X_HEIGHT => p_hotspot_height,
      X_FONT_SIZE => p_font_size,
      X_FONT_STYLE => p_font_style,
      X_FONT_COLOR => p_font_color,
      X_COLOR_LEFT_POSITION => p_alarm_left,
      X_COLOR_TOP_POSITION => p_alarm_top,
      X_COLOR_WIDTH => p_alarm_width,
      X_COLOR_HEIGHT => p_alarm_height,
      X_COLOR_SIZE => 0,
      X_CREATION_DATE => SYSDATE,
      X_CREATED_BY => fnd_global.user_id,
      X_LAST_UPDATE_DATE => SYSDATE,
      X_LAST_UPDATED_BY => fnd_global.user_id,
      X_LAST_UPDATE_LOGIN => fnd_global.login_id
    );

Line: 1082


END add_or_update_tab_view_kpi;

Line: 1105


  SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL INTO l_next_image_id FROM dual;

Line: 1109


    BSC_SYS_IMAGES_PKG.INSERT_ROW (
      X_IMAGE_ID => l_next_image_id,
      X_FILE_NAME => p_file_name,
      X_DESCRIPTION => p_description,
      X_WIDTH => p_width,
      X_HEIGHT => p_height,
      X_MIME_TYPE => p_mime_type,
      X_CREATED_BY => fnd_global.user_id,
      X_LAST_UPDATED_BY => fnd_global.user_id,
      X_LAST_UPDATE_LOGIN => fnd_global.login_id
    );

Line: 1124


      x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;

Line: 1128


  BSC_SYS_IMAGES_MAP_PKG.INSERT_ROW (
    X_ROWID => l_str,
    X_SOURCE_TYPE => 1,
    X_SOURCE_CODE => p_tab_id,
    X_TYPE => p_tab_view_id,
    X_IMAGE_ID => l_next_image_id,
    X_CREATION_DATE => SYSDATE,
    X_CREATED_BY => fnd_global.user_id,
    X_LAST_UPDATE_DATE => SYSDATE,
    X_LAST_UPDATED_BY => fnd_global.user_id,
    X_LAST_UPDATE_LOGIN => fnd_global.login_id
  );

Line: 1150


PROCEDURE add_or_update_tab_view_bg (
  p_tab_id            IN NUMBER
 ,p_tab_view_id       IN NUMBER
 ,p_image_id          IN NUMBER
 ,p_file_name         IN VARCHAR2
 ,p_description       IN VARCHAR2
 ,p_width             IN NUMBER
 ,p_height            IN NUMBER
 ,p_mime_type         IN VARCHAR2
 ,x_image_id          OUT NOCOPY NUMBER
 ,x_return_status     OUT NOCOPY VARCHAR2
 ,x_msg_count         OUT NOCOPY NUMBER
 ,x_msg_data          OUT NOCOPY VARCHAR2
) IS
 l_count              NUMBER;

Line: 1173


  SELECT count(1) INTO l_count
  FROM BSC_SYS_IMAGES bsi, BSC_SYS_IMAGES_MAP_VL bsim
  WHERE bsim.source_code = p_tab_id
  AND bsim.type = p_tab_view_id
  AND bsim.image_id = p_image_id
  AND bsim.image_id = bsi.image_id;

Line: 1183


    SELECT count(1) INTO l_count
    FROM BSC_SYS_IMAGES_MAP_TL
    WHERE source_code = p_tab_id
    AND type = p_tab_view_id
    AND image_id = p_image_id
    AND source_lang = userenv('LANG');

Line: 1195


      UPDATE  BSC_SYS_IMAGES
      SET     FILE_NAME              =   p_file_name,
              DESCRIPTION            =   p_description,
              WIDTH                  =   p_width,
              HEIGHT                 =   p_height,
              MIME_TYPE              =   p_mime_type,
              LAST_UPDATE_DATE       =   SYSDATE,
              LAST_UPDATED_BY        =   fnd_global.user_id,
              LAST_UPDATE_LOGIN      =   fnd_global.login_id,
              FILE_BODY              =   EMPTY_BLOB()
      WHERE   IMAGE_ID               =   p_image_id
      AND     LAST_UPDATE_DATE      <=   SYSDATE;

Line: 1211


        x_msg_data := 'Update to BSC_SYS_IMAGES failed' || SQLERRM;

Line: 1215


    BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW (
      X_SOURCE_TYPE => 1,
      X_SOURCE_CODE => p_tab_id,
      X_TYPE => p_tab_view_id,
      X_IMAGE_ID => p_image_id,
      X_CREATION_DATE => SYSDATE,
      X_CREATED_BY => fnd_global.user_id,
      X_LAST_UPDATE_DATE => SYSDATE,
      X_LAST_UPDATED_BY => fnd_global.user_id,
      X_LAST_UPDATE_LOGIN => fnd_global.login_id
    );

Line: 1229


    SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL INTO l_next_image_id FROM dual;

Line: 1233


      BSC_SYS_IMAGES_PKG.INSERT_ROW (
        X_IMAGE_ID => l_next_image_id,
        X_FILE_NAME => p_file_name,
        X_DESCRIPTION => p_description,
        X_WIDTH => p_width,
        X_HEIGHT => p_height,
        X_MIME_TYPE => p_mime_type,
        X_CREATED_BY => fnd_global.user_id,
        X_LAST_UPDATED_BY => fnd_global.user_id,
        X_LAST_UPDATE_LOGIN => fnd_global.login_id
      );

Line: 1249


        x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;

Line: 1253


      BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW (
      X_SOURCE_TYPE => 1,
      X_SOURCE_CODE => p_tab_id,
      X_TYPE => p_tab_view_id,
      X_IMAGE_ID => l_next_image_id,
      X_CREATION_DATE => SYSDATE,
      X_CREATED_BY => fnd_global.user_id,
      X_LAST_UPDATE_DATE => SYSDATE,
      X_LAST_UPDATED_BY => fnd_global.user_id,
      X_LAST_UPDATE_LOGIN => fnd_global.login_id
    );

Line: 1288


END add_or_update_tab_view_bg;

Line: 1291


PROCEDURE add_or_update_tab_view (
  p_tab_id            IN NUMBER
 ,p_tab_view_id       IN NUMBER
 ,p_name              IN VARCHAR2
 ,p_func_area_short_name IN VARCHAR2
 ,p_internal_name     IN VARCHAR2
 ,p_description       IN VARCHAR2
 ,p_enable_flag       IN NUMBER
 ,p_create_form_func  IN VARCHAR2
 ,p_last_update_date  IN VARCHAR2
 ,x_return_status     OUT NOCOPY VARCHAR2
 ,x_msg_count         OUT NOCOPY NUMBER
 ,x_msg_data          OUT NOCOPY VARCHAR2
) IS
 l_count              NUMBER;

Line: 1322


    SELECT NVL(ENABLED_FLAG,1)
    INTO  l_enabled_flag
    FROM  BSC_TAB_VIEWS_VL
    WHERE tab_id = p_tab_id
    AND   tab_view_id = p_tab_view_id;

Line: 1329


    BSC_TAB_VIEWS_PKG.UPDATE_ROW(
      X_TAB_ID => p_tab_id,
      X_TAB_VIEW_ID => p_tab_view_id,
      X_ENABLED_FLAG => l_enabled_flag,
      X_NAME => p_name,
      X_HELP => p_description,
      X_LAST_UPDATE_DATE => SYSDATE,
      X_LAST_UPDATED_BY => fnd_global.user_id,
      X_LAST_UPDATE_LOGIN => fnd_global.login_id
    );

Line: 1341


      BSC_TAB_VIEWS_PKG.INSERT_ROW(
        X_ROWID => l_str,
        X_TAB_ID => p_tab_id,
        X_TAB_VIEW_ID => p_tab_view_id,
        X_ENABLED_FLAG => p_enable_flag,
        X_NAME => p_name,
        X_HELP => p_description,
        X_CREATION_DATE => SYSDATE,
        X_CREATED_BY => fnd_global.user_id,
        X_LAST_UPDATE_DATE => SYSDATE,
        X_LAST_UPDATED_BY => fnd_global.user_id,
        X_LAST_UPDATE_LOGIN => fnd_global.login_id
      );

Line: 1359


        x_msg_data := 'Insertion to BSC_TAB_VIEWS_PKG failed' || SQLERRM;

Line: 1363


    UPDATE  BSC_TABS_B
    SET     LAST_UPDATE_DATE        =   SYSDATE,
            LAST_UPDATED_BY         =   fnd_global.user_id,
            LAST_UPDATE_LOGIN       =   fnd_global.login_id
    WHERE   TAB_ID                  =   p_tab_id;

Line: 1381


    BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_function
      (p_tab_id => p_tab_id,
       p_tab_view_id => p_tab_view_id,
       p_name => p_name,
       p_internal_name => p_internal_name,
       p_description => p_description,
       x_function_id => l_function_id,
       x_return_status => x_return_status ,
       x_msg_count => x_msg_count,
       x_msg_data => x_msg_data
      );

Line: 1434


END add_or_update_tab_view;

Line: 1438


PROCEDURE add_or_update_tab_view (
  p_tab_id                IN NUMBER
 ,p_tab_view_id           IN NUMBER
 ,p_name                  IN VARCHAR2
 ,p_func_area_short_name  IN VARCHAR2
 ,p_internal_name         IN VARCHAR2
 ,p_description           IN VARCHAR2
 ,p_enable_flag           IN NUMBER
 ,p_is_default_int_name   IN VARCHAR2
 ,p_create_form_func      IN VARCHAR2
 ,p_last_update_date      IN VARCHAR2
 ,x_return_status         OUT NOCOPY VARCHAR2
 ,x_msg_count             OUT NOCOPY NUMBER
 ,x_msg_data              OUT NOCOPY VARCHAR2
) IS
l_count         NUMBER;

Line: 1460


    SELECT COUNT(0)
    INTO l_count
    FROM FND_FORM_FUNCTIONS_VL
    WHERE FUNCTION_NAME = p_internal_name;

Line: 1477


  add_or_update_tab_view (
  p_tab_id          => p_tab_id
 ,p_tab_view_id     => p_tab_view_id
 ,p_name            => p_name
 ,p_func_area_short_name => p_func_area_short_name
 ,p_internal_name   => l_internal_name
 ,p_description     => p_description
 ,p_enable_flag     => p_enable_flag
 ,p_create_form_func => p_create_form_func
 ,p_last_update_date => p_last_update_date
 ,x_return_status   => x_return_status
 ,x_msg_count       => x_msg_count
 ,x_msg_data        => x_msg_data
);

Line: 1497


END add_or_update_tab_view;

Line: 1507


  SELECT count(tab_id) INTO l_count
  FROM bsc_tab_views_vl
  WHERE tab_id = p_tab_id AND tab_view_id = p_tab_view_id;

Line: 1525


 ,p_last_update_date   IN VARCHAR2
) RETURN NUMBER IS
  l_last_update_date   VARCHAR2(100);

Line: 1530


  SELECT to_char(last_update_date,'YY/MM/DD-HH24:MM:SS') into l_last_update_date
  FROM bsc_tab_views_vl
  WHERE tab_id = p_tab_id AND tab_view_id = p_tab_view_id;

Line: 1534


  IF (p_last_update_date <> l_last_update_date)
  THEN
   RETURN 1;

Line: 1583


procedure add_or_update_function (
  p_tab_id            IN NUMBER
 ,p_tab_view_id       IN NUMBER
 ,p_name              IN VARCHAR2
 ,p_internal_name     IN VARCHAR2 := NULL
 ,p_description       IN VARCHAR2
 ,x_function_id       OUT NOCOPY NUMBER
 ,x_return_status     OUT NOCOPY VARCHAR2
 ,x_msg_count         OUT NOCOPY NUMBER
 ,x_msg_data          OUT NOCOPY VARCHAR2
) is

l_rowid               VARCHAR2(30);

Line: 1612


    select count(FUNCTION_ID) into l_count
    from FND_FORM_FUNCTIONS
    where FUNCTION_NAME = l_function_name;

Line: 1618


        select FND_FORM_FUNCTIONS_S.NEXTVAL into l_new_function_id from dual;

Line: 1620


        FND_FORM_FUNCTIONS_PKG.INSERT_ROW(
            X_ROWID                  => l_ROWID,
            X_FUNCTION_ID            => l_new_function_id,
            X_WEB_HOST_NAME          => null,
            X_WEB_AGENT_NAME         => null,
            X_WEB_HTML_CALL          => C_FUNC_WEB_HTML_CALL,
            X_WEB_ENCRYPT_PARAMETERS => 'N',
            X_WEB_SECURED            => 'N',
            X_WEB_ICON               => null,
            X_OBJECT_ID              => null,
            X_REGION_APPLICATION_ID  => C_FUNC_REGION_APPLICATION_ID,
            X_REGION_CODE            => C_FUNC_REGION_CODE,
            X_FUNCTION_NAME          => l_function_name,
            X_APPLICATION_ID         => null,
            X_FORM_ID                => null,
            X_PARAMETERS             => l_parameters,
            X_TYPE                   => C_FUNC_TYPE,
            X_USER_FUNCTION_NAME     => p_name,
            X_DESCRIPTION            => p_description,
            X_CREATION_DATE          => sysdate,
            X_CREATED_BY             => fnd_global.user_id,
            X_LAST_UPDATE_DATE       => sysdate,
            X_LAST_UPDATED_BY        => fnd_global.user_id,
            X_LAST_UPDATE_LOGIN      => fnd_global.user_id,
            X_MAINTENANCE_MODE_SUPPORT => NULL,
            X_CONTEXT_DEPENDENCE       => NULL);

Line: 1651


        select FUNCTION_ID into x_function_id from FND_FORM_FUNCTIONS where FUNCTION_NAME = l_function_name;

Line: 1653


        FND_FORM_FUNCTIONS_PKG.UPDATE_ROW
        (
           X_FUNCTION_ID            => x_function_id
          ,X_WEB_HOST_NAME          => NULL
          ,X_WEB_AGENT_NAME         => NULL
          ,X_WEB_HTML_CALL          => C_FUNC_WEB_HTML_CALL
          ,X_WEB_ENCRYPT_PARAMETERS => 'N'
          ,X_WEB_SECURED            => 'N'
          ,X_WEB_ICON               => NULL
          ,X_OBJECT_ID              => NULL
          ,X_REGION_APPLICATION_ID  => C_FUNC_REGION_APPLICATION_ID
          ,X_REGION_CODE            => C_FUNC_REGION_CODE
          ,X_FUNCTION_NAME          => l_function_name
          ,X_APPLICATION_ID         => NULL
          ,X_FORM_ID                => NULL
          ,X_PARAMETERS             => l_parameters
          ,X_TYPE                   => C_FUNC_TYPE
          ,X_USER_FUNCTION_NAME     => p_name
          ,X_DESCRIPTION            => p_description
          ,X_LAST_UPDATE_DATE       => SYSDATE
          ,X_LAST_UPDATED_BY        => FND_GLOBAL.USER_ID
          ,X_LAST_UPDATE_LOGIN      => FND_GLOBAL.LOGIN_ID
        );

Line: 1693


end add_or_update_function;

Line: 1695


procedure delete_function (
  p_tab_id            IN NUMBER
 ,p_tab_view_id       IN NUMBER
 ,x_return_status     OUT NOCOPY VARCHAR2
 ,x_msg_count         OUT NOCOPY NUMBER
 ,x_msg_data          OUT NOCOPY VARCHAR2
) is

 l_function_id          NUMBER;

Line: 1709


 SELECT FUNCTION_ID, FUNCTION_NAME
 FROM   FND_FORM_FUNCTIONS
 WHERE  PARAMETERS LIKE l_param_search_string;

Line: 1723


      FND_FORM_FUNCTIONS_PKG.DELETE_ROW(l_function_id);

Line: 1725


      SELECT COUNT(0)
      INTO   l_count
      FROM   bis_form_function_extension_vl
      WHERE  object_name= l_object_name;

Line: 1753


        x_msg_data := 'BSC_CUSTOM_VIEW_UI_WRAPPER.delete_function: no Row Found: ' || SQLERRM;

Line: 1765


        x_msg_data := 'BSC_CUSTOM_VIEW_UI_WRAPPER.delete_function' || SQLERRM;

Line: 1768


end delete_function;

Line: 1778


  SELECT NVL(MAX(tab_view_id),1)
  INTO   l_view_id
  FROM   BSC_TAB_VIEWS_B
  WHERE tab_id =  p_tab_id;

Line: 1813


    l_last_update_date DATE;

Line: 1821


        SELECT LAST_UPDATE_DATE
        INTO l_last_update_date
        FROM AK_REGIONS
        WHERE REGION_CODE = p_report_sht_name
        AND REGION_APPLICATION_ID = p_Application_Id;

Line: 1827


        IF(p_time_stamp <> TO_CHAR(l_last_update_date, l_last_upd_format)) THEN
            FND_MSG_PUB.Initialize;

Line: 1840


    UPDATE AK_REGIONS A
    SET    A.LAST_UPDATE_DATE = l_Time_Stamp
    WHERE  A.REGION_CODE = p_report_sht_name
    AND REGION_APPLICATION_ID = p_Application_Id;

Line: 1846


    SELECT COUNT(0)
    INTO   l_count
    FROM   BSC_TABS_B
    WHERE  SHORT_NAME = p_report_sht_name;

Line: 1853


        SELECT Name
        INTO   l_tab_name
        FROM   AK_REGIONS_VL
        WHERE  REGION_CODE = p_report_sht_name;

Line: 1878


        SELECT  tab_Id
        INTO    l_tabId
        FROM    BSC_TABS_B
        WHERE   SHORT_NAME = p_report_sht_name;

Line: 1973


    SELECT DISTINCT NVL(V.ATTRIBUTE_LABEL_LONG,B.NAME) NAME,
           B.MEASURE_TYPE,
           D.SOURCE,
           v.attribute1 ITEM_TYPE
    FROM   BIS_INDICATORS_VL B,
           BSC_SYS_DATASETS_B D,
           AK_REGION_ITEMS_VL V,
           AK_REGIONS C
    WHERE C.REGION_CODE = V.REGION_CODE
    AND   V.ATTRIBUTE_CATEGORY ='BIS PM Viewer'
    AND   V.ATTRIBUTE1 LIKE '%MEASURE%'
    AND   V.ATTRIBUTE1 NOT IN ('COMPARE_TO_MEASURE_NO_TARGET','CHANGE_MEASURE_NO_TARGET')
    AND   NVL(B.MEASURE_TYPE,D.SOURCE) <>'CDS_SCORE'
    AND   V.ATTRIBUTE2 = B.SHORT_NAME
    AND   B.DATASET_ID = D.DATASET_ID
    AND   B.DATASET_ID = p_dataset_id
    AND   C.REGION_CODE = p_region_code;

Line: 1993


    SELECT V.NAME, V.MEASURE_TYPE, D.SOURCE
    FROM BIS_DISPLAY_MEASURES_V V,
         BIS_INDICATORS B,
         BSC_SYS_DATASETS_B D
    WHERE D.DATASET_ID = p_dataset_id
    AND D.DATASET_ID = B.DATASET_ID
    AND B.SHORT_NAME = V.SHORT_NAME;

Line: 2082


    SELECT ff.function_name,fa.short_name
    INTO   l_fun_name,l_short_name
    FROM   bis_form_function_extension ext,
           bis_functional_areas_vl fa,
           fnd_form_functions_vl ff
    WHERE
           ff.parameters LIKE '%pTabId_'||p_tab_id|| '&pViewId_'||p_tab_view_id||'%'
    AND    ext.functional_area_id = fa.functional_area_id (+)
    AND    ff.function_name = ext.object_name (+);

Line: 2102


 NAME        : add_or_update_kpi_trend
 DESCRIPTION : This api inserts trend information into BSC_TAB_VIEW_LABELS table for objectives.
/**************************************************/

PROCEDURE add_or_update_kpi_trend(
  p_tab_id            IN NUMBER
 ,p_tab_view_id       IN NUMBER
 ,p_object_id         IN NUMBER
 ,p_text_flag         IN NUMBER
 ,p_label_text        IN VARCHAR2
 ,p_font_size         IN NUMBER
 ,p_font_style        IN NUMBER
 ,p_font_color        IN NUMBER
 ,p_left              IN NUMBER
 ,p_top               IN NUMBER
 ,p_width             IN NUMBER
 ,p_height            IN NUMBER
 ,p_kpi_id            IN NUMBER
 ,p_function_id       IN NUMBER
 ,x_return_status     OUT NOCOPY VARCHAR2
 ,x_msg_count         OUT NOCOPY NUMBER
 ,x_msg_data          OUT NOCOPY VARCHAR2
) IS
BEGIN
  SAVEPOINT addorupdatekpitrend;

Line: 2130


  BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
    p_tab_id => p_tab_id
   ,p_tab_view_id => p_tab_view_id
   ,p_object_id => p_object_id
   ,p_object_type => c_type_kpi_trend
   ,p_label_text => p_label_text
   ,p_text_flag => p_text_flag
   ,p_font_color => p_font_color
   ,p_font_size => p_font_size
   ,p_font_style => p_font_style
   ,p_left => p_left
   ,p_top => p_top
   ,p_width => p_width
   ,p_height => p_height
   ,p_note_text => NULL
   ,p_link_id => p_kpi_id
   ,p_function_id => p_function_id
   ,x_return_status => x_return_status
   ,x_msg_count => x_msg_count
   ,x_msg_data => x_msg_data
  );

Line: 2154


    ROLLBACK TO addorupdatekpitrend;

Line: 2157


END add_or_update_kpi_trend;