APPS.BSC_MIGRATION dependencies on BSC_TABS_B

Line 3799: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_TABS_B';

3795: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3796: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3797:
3798: g_num_metadata_tables := g_num_metadata_tables + 1;
3799: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_TABS_B';
3800: g_metadata_tables(g_num_metadata_tables).level := 1;
3801: g_metadata_tables(g_num_metadata_tables).level_column := 'TAB_ID';
3802: g_metadata_tables(g_num_metadata_tables).level_condition := NULL;
3803: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;

Line 4883: -- 9. Fix OWNER_ID in BSC_TABS_B according to users in the target system.

4879: MIN(NAME_JUSTIFICATION),MIN(LEFT_POSITION),MIN(TOP_POSITION),MIN(WIDTH),MIN(HEIGHT),SHORT_NAME
4880: FROM BSC_TAB_IND_GROUPS_B
4881: GROUP BY -1,CSF_ID,IND_GROUP_ID,SHORT_NAME;
4882:
4883: -- 9. Fix OWNER_ID in BSC_TABS_B according to users in the target system.
4884: -- Update this column in the target system with the USER_ID from FND_USER
4885: -- whose USER_NAME is the same in the source system.
4886: -- If a USER_ID do not have a corresponding USER_ID in the target system,
4887: -- it will be set to the USER_ID of the SYSADMIN user.

Line 4892: h_sql := 'UPDATE bsc_tabs_b c

4888: IF BSC_APPS.APPS_ENV THEN
4889: -- Target system is APPS
4890: IF g_src_apps_flag THEN
4891: -- Source system is APPS
4892: h_sql := 'UPDATE bsc_tabs_b c
4893: SET owner_id = NVL((SELECT u.user_id
4894: FROM fnd_user u, fnd_user@'||g_db_link||' s
4895: WHERE u.user_name = s.user_name AND
4896: c.owner_id = s.user_id), :1)';

Line 4900: h_sql := 'UPDATE bsc_tabs_b

4896: c.owner_id = s.user_id), :1)';
4897: execute immediate h_sql using g_sysadmin_user_id;
4898: ELSE
4899: -- Source system is Personal
4900: h_sql := 'UPDATE bsc_tabs_b
4901: SET owner_id = :1';
4902: execute immediate h_sql using g_sysadmin_user_id;
4903: END IF;
4904: END IF;

Line 4906: -- 10. Set PARENT_TAB_ID to NULL in BSC_TABS_B for tabs whose parent was not migrated.

4902: execute immediate h_sql using g_sysadmin_user_id;
4903: END IF;
4904: END IF;
4905:
4906: -- 10. Set PARENT_TAB_ID to NULL in BSC_TABS_B for tabs whose parent was not migrated.
4907: UPDATE bsc_tabs_b
4908: SET parent_tab_id = NULL
4909: WHERE
4910: parent_tab_id NOT IN (

Line 4907: UPDATE bsc_tabs_b

4903: END IF;
4904: END IF;
4905:
4906: -- 10. Set PARENT_TAB_ID to NULL in BSC_TABS_B for tabs whose parent was not migrated.
4907: UPDATE bsc_tabs_b
4908: SET parent_tab_id = NULL
4909: WHERE
4910: parent_tab_id NOT IN (
4911: SELECT tab_id

Line 4912: FROM bsc_tabs_b

4908: SET parent_tab_id = NULL
4909: WHERE
4910: parent_tab_id NOT IN (
4911: SELECT tab_id
4912: FROM bsc_tabs_b
4913: );
4914:
4915: -- 11. Reset sequence BSC_INTERNAL_COLUMN_S to start with at least the same current value of the sequence
4916: -- in the source system.