DBA Data[Home] [Help]

APPS.BSC_CUSTOM_VIEW_PVT dependencies on BSC_TAB_VIEW_LABELS_B

Line 1306: 4.BSC_TAB_VIEW_LABELS_B

1302: The entry will be deleted from the following tables.
1303: 1.BSC_TAB_VIEWS_B
1304: 2.BSC_TAB_VIEWS_TL
1305: 3.BSC_TAB_VIEW_KPI_TL
1306: 4.BSC_TAB_VIEW_LABELS_B
1307: 5.BSC_TAB_VIEW_LABELS_TL
1308: 6.BSC_SYS_IMAGES_MAP_TL
1309: 7.BSC_SYS_IMAGES (need for cascading)
1310: 8.Form functoins defined in each custom view upon creation in BSC_CUSTOM_VIEW_UI_WRAPPER.create_function

Line 1439: FROM BSC_TAB_VIEW_LABELS_B

1435: WHERE tab_id = l_CustView_Rec.Bsc_Tab_Id
1436: AND tab_view_id = l_CustView_Rec.Bsc_Tab_View_Id;
1437:
1438: DELETE
1439: FROM BSC_TAB_VIEW_LABELS_B
1440: WHERE tab_id = l_CustView_Rec.Bsc_Tab_Id
1441: AND tab_view_id = l_CustView_Rec.Bsc_Tab_View_Id;
1442:
1443: DELETE

Line 1444: FROM BSC_TAB_VIEW_LABELS_B

1440: WHERE tab_id = l_CustView_Rec.Bsc_Tab_Id
1441: AND tab_view_id = l_CustView_Rec.Bsc_Tab_View_Id;
1442:
1443: DELETE
1444: FROM BSC_TAB_VIEW_LABELS_B
1445: WHERE tab_id = l_CustView_Rec.Bsc_Tab_Id
1446: AND label_type = 1
1447: AND link_id = l_CustView_Rec.Bsc_Tab_View_Id;
1448:

Line 1564: FROM BSC_TAB_VIEW_LABELS_B

1560: CURSOR c_CachedData IS
1561: SELECT tab_id,
1562: tab_view_id,
1563: label_id
1564: FROM BSC_TAB_VIEW_LABELS_B
1565: WHERE tab_id = p_tab_id
1566: AND link_id = p_obj_id;
1567:
1568: BEGIN

Line 1610: BSC_TAB_VIEW_LABELS_B and _TL table.

1606: BSC_TAB_VIEW_LABLES_B and BSC_TAB_VIEW_LABLES_TL table with label_type
1607: as 4,5 and 6 corresponding to Objective label,Actual label and Change label.
1608:
1609: So when the objective is deleted we have to cascade these changes in
1610: BSC_TAB_VIEW_LABELS_B and _TL table.
1611:
1612: So following is the LOGIC
1613:
1614: To delete from TL table we need to cache the TAB_ID,TAB_VIEW_ID and LABEL_ID.

Line 1629: FROM BSC_TAB_VIEW_LABELS_B

1625: AND label_id = cd.label_id;
1626: END LOOP;
1627:
1628: DELETE
1629: FROM BSC_TAB_VIEW_LABELS_B
1630: WHERE tab_id = p_tab_id
1631: AND LINK_ID =p_obj_id;
1632:
1633: IF (p_commit = FND_API.G_TRUE) THEN