APPS.BSC_CUSTOM_VIEW_PVT dependencies on BSC_TAB_VIEWS_TL

Line 662: This procedure will create a new record into the BSC_TAB_VIEWS_B and BSC_TAB_VIEWS_TL table.

658: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION OTHERS '||x_msg_data);
659: END Assign_Unassign_Views;
660:
661: /******************************************************************************************
662: This procedure will create a new record into the BSC_TAB_VIEWS_B and BSC_TAB_VIEWS_TL table.
663:
664: /******************************************************************************************/
665:
666: PROCEDURE Create_Tab_View

Line 720: INSERT INTO BSC_TAB_VIEWS_TL

716: ,SYSDATE
717: ,fnd_global.LOGIN_ID
718: );
719:
720: INSERT INTO BSC_TAB_VIEWS_TL
721: ( tab_id
722: ,tab_view_id
723: ,language
724: ,source_lang

Line 748: FROM BSC_TAB_VIEWS_TL T

744: FROM FND_LANGUAGES L
745: WHERE L.INSTALLED_FLAG IN ('I', 'B')
746: AND NOT EXISTS
747: ( SELECT NULL
748: FROM BSC_TAB_VIEWS_TL T
749: WHERE T.tab_id = l_Tab_View_Rec.Bsc_Tab_Id
750: AND T.tab_view_id = l_Tab_View_Rec.Bsc_Tab_View_Id
751: AND T.LANGUAGE = L.LANGUAGE_CODE);
752:

Line 1304: 2.BSC_TAB_VIEWS_TL

1300: This is required for Granular locking purpose.
1301:
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

Line 1428: FROM BSC_TAB_VIEWS_TL

1424: WHERE tab_id = l_CustView_Rec.Bsc_Tab_Id
1425: AND tab_view_id = l_CustView_Rec.Bsc_Tab_View_Id;
1426:
1427: DELETE
1428: FROM BSC_TAB_VIEWS_TL
1429: WHERE tab_id = l_CustView_Rec.Bsc_Tab_Id
1430: AND tab_view_id = l_CustView_Rec.Bsc_Tab_View_Id;
1431:
1432: