709: )VALUES
710: ( l_Tab_View_Rec.Bsc_Tab_Id
711: ,l_Tab_View_Rec.Bsc_Tab_View_Id
712: ,l_Tab_View_Rec.Bsc_Enabled_Flag
713: ,fnd_global.USER_ID
714: ,SYSDATE
715: ,fnd_global.USER_ID
716: ,SYSDATE
717: ,fnd_global.LOGIN_ID
711: ,l_Tab_View_Rec.Bsc_Tab_View_Id
712: ,l_Tab_View_Rec.Bsc_Enabled_Flag
713: ,fnd_global.USER_ID
714: ,SYSDATE
715: ,fnd_global.USER_ID
716: ,SYSDATE
717: ,fnd_global.LOGIN_ID
718: );
719:
713: ,fnd_global.USER_ID
714: ,SYSDATE
715: ,fnd_global.USER_ID
716: ,SYSDATE
717: ,fnd_global.LOGIN_ID
718: );
719:
720: INSERT INTO BSC_TAB_VIEWS_TL
721: ( tab_id
735: ,L.LANGUAGE_CODE
736: ,USERENV('LANG')
737: ,l_Tab_View_Rec.Bsc_Name
738: ,l_Tab_View_Rec.Bsc_Help
739: ,fnd_global.USER_ID
740: ,sysdate
741: ,fnd_global.USER_ID
742: ,sysdate
743: ,fnd_global.LOGIN_ID
737: ,l_Tab_View_Rec.Bsc_Name
738: ,l_Tab_View_Rec.Bsc_Help
739: ,fnd_global.USER_ID
740: ,sysdate
741: ,fnd_global.USER_ID
742: ,sysdate
743: ,fnd_global.LOGIN_ID
744: FROM FND_LANGUAGES L
745: WHERE L.INSTALLED_FLAG IN ('I', 'B')
739: ,fnd_global.USER_ID
740: ,sysdate
741: ,fnd_global.USER_ID
742: ,sysdate
743: ,fnd_global.LOGIN_ID
744: FROM FND_LANGUAGES L
745: WHERE L.INSTALLED_FLAG IN ('I', 'B')
746: AND NOT EXISTS
747: ( SELECT NULL