APPS.BSC_CUSTOM_VIEW_PUB SQL Statements

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

Line: 4

 This procedure will delete the custom view from the tab.
 The entry will be deleted from the following tables.
    1.BSC_TAB_VIEWS_B
    2.BSC_TAB_VIEWS_TL
    3.BSC_TAB_VIEW_KPI_TL
    4.BSC_TAB_VIEW_LABELS_B
    5.BSC_TAB_VIEW_LABELS_TL
    6.BSC_SYS_IMAGES_MAP_TL
    7.BSC_SYS_IMAGES (need for cascading)

 /******************************************************************************/
PROCEDURE delete_Custom_View
(
   p_commit                     IN              VARCHAR2   := FND_API.G_FALSE
  ,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
  ,p_time_stamp                 IN              VARCHAR2    := NULL
) IS

 l_CustView_Rec           BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;

Line: 59

        FND_MESSAGE.SET_NAME('BSC','BSC_RES_VIEW_NOT_DELETE');

Line: 81

	 	FND_MESSAGE.SET_NAME('BSC','BSC_DELETE_CUSTOMVIEW_ERR');

Line: 100

     BSC_CUSTOM_VIEW_PVT.delete_Custom_View
     (
          p_CustView_Rec    => l_CustView_Rec
         ,x_return_status   => x_return_status
         ,x_msg_count       => x_msg_count
         ,x_msg_data        => x_msg_data
     );

Line: 135

            x_msg_data      :=  x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';

Line: 137

            x_msg_data      :=  SQLERRM||' at BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';

Line: 144

            x_msg_data      :=  x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';

Line: 146

            x_msg_data      :=  SQLERRM||' at BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';

Line: 150

END delete_Custom_View;

Line: 435

  Delete_Custom_View_Links
  Decription :- This procedure will UnAssign the custom views for the tab.
                It means it will set the enabled_flag =0 in BSC_TAB_VIEWS_B table
                for tree view, detail_view and custom views.
                For scorecard view, strategy map view it will set KPI_MODEL =0
                and BSC_MODEL =0 in BSC_TABS_B table.
  Input      :- Comma separated views ids which needs to be Assigned.
  Created by :- ashankar 27-Oct-2003
/*******************************************************************************/
PROCEDURE Delete_Custom_View_Links
  (
      p_commit                 IN              VARCHAR2  := FND_API.G_FALSE
    , p_tab_id                 IN              NUMBER
    , p_obj_id                 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: 459

     BSC_CUSTOM_VIEW_PVT.Delete_Custom_View_Links
     (
           p_commit         =>  p_commit
         , p_tab_id         =>  p_tab_id
         , p_obj_id         =>  p_obj_id
         , x_return_status  =>  x_return_status
         , x_msg_count      =>  x_msg_count
         , x_msg_data       =>  x_msg_data
     );

Line: 500

            x_msg_data      :=  x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Delete_Custom_View_Links ';

Line: 502

            x_msg_data      :=  SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Delete_Custom_View_Links ';

Line: 509

            x_msg_data      :=  x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.Delete_Custom_View_Links ';

Line: 511

            x_msg_data      :=  SQLERRM||' at BSC_CUSTOM_VIEW_PUB.Delete_Custom_View_Links ';

Line: 514

 END Delete_Custom_View_Links;