APPS.BSC_LAUNCH_PAD_PVT dependencies on BSC_APPS

Line 660: h_user_id := BSC_APPS.fnd_global_user_id;

656: -- Get user id
657: -- Ref: bug#3482442 In corner cases this query can return more than one
658: -- row and it will fail. AUDSID is not PK. After meeting with
659: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
660: h_user_id := BSC_APPS.fnd_global_user_id;
661:
662: -- Migrate menus with functions
663: h_sql := 'SELECT DISTINCT M.MENU_NAME, M.USER_MENU_NAME, T.LINK_ID'||
664: ' FROM BSC_TAB_VIEW_LABELS_B T, FND_MENUS_VL@'||x_src_db_link||' M'||

Line 971: BSC_APPS.Execute_Immediate(h_sql);

967: WHERE t.user_menu_name = s.user_menu_name AND
968: l.link_id = s.menu_id),
969: -1))
970: WHERE label_type = 2';
971: BSC_APPS.Execute_Immediate(h_sql);
972:
973: RETURN TRUE;
974:
975: EXCEPTION

Line 1027: h_user_id := BSC_APPS.fnd_global_user_id;

1023: -- Get user id
1024: -- Ref: bug#3482442 In corner cases this query can return more than one
1025: -- row and it will fail. AUDSID is not PK. After meeting with
1026: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
1027: h_user_id := BSC_APPS.fnd_global_user_id;
1028:
1029: -- Get the top menu id of the source responsibility
1030: h_sql := 'SELECT MENU_ID'||
1031: ' FROM FND_RESPONSIBILITY_VL@'||x_src_db_link||