eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_MIGRATION dependencies on BSC_SYS_INIT

Line 56: --This value is gotten from BSC_SYS_INIT in the source

52: g_migrated_functions t_array_of_varchar2;
53: g_num_migrated_functions NUMBER := 0;
54:
55: --BSC-MV Note: variable to store the summarization level from the source.
56: --This value is gotten from BSC_SYS_INIT in the source
57: -- g_adv_sum_level = NULL means current architecture.
58: -- g_adv_sum_level <> NULL means BSC-MV/V architecture
59: g_adv_sum_level NUMBER := NULL;
60:

Line 276: delete from bsc_sys_init

272: -- Fix bug#3831534 It will grant Designer Role (update Acess) to all design user
273: -- (user with BSC_Manager or BSC_DESIGNER)
274: h_property_code := 'GRANT_ROLE_TAB';
275:
276: delete from bsc_sys_init
277: where property_code = h_property_code;
278: commit;
279:
280: IF NOT BSC_UPGRADES_GENERIC.upgrade_role_to_tabs(h_error_msg) THEN

Line 3625: /*--bug fix 5680620m bsc_sys_init is a special case and will be

3621: g_metadata_tables(g_num_metadata_tables).level_column := 'SOURCE_CODE';
3622: g_metadata_tables(g_num_metadata_tables).level_condition := 'SOURCE_TYPE = 2';
3623: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3624: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE; --Only 1 flag per table
3625: /*--bug fix 5680620m bsc_sys_init is a special case and will be
3626: handled separately
3627: g_num_metadata_tables := g_num_metadata_tables + 1;
3628: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_INIT';
3629: g_metadata_tables(g_num_metadata_tables).level := 0;

Line 3628: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_INIT';

3624: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE; --Only 1 flag per table
3625: /*--bug fix 5680620m bsc_sys_init is a special case and will be
3626: handled separately
3627: g_num_metadata_tables := g_num_metadata_tables + 1;
3628: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_INIT';
3629: g_metadata_tables(g_num_metadata_tables).level := 0;
3630: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3631: g_metadata_tables(g_num_metadata_tables).level_condition := 'PROPERTY_CODE <> ''EDW_INSTALLED''';
3632: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;

Line 5115: bsc_sys_init WHERE property_code = 'TARGET_STATUS';

5111: +============================================================================*/
5112: FUNCTION get_previous_migration_status RETURN boolean IS
5113: CURSOR cTable IS
5114: SELECT property_value FROM
5115: bsc_sys_init WHERE property_code = 'TARGET_STATUS';
5116:
5117: l_value VARCHAR2(400);
5118: BEGIN
5119: OPEN cTable;

Line 5555: -- Read sum level from bsc_sys_init

5551: --BSC-MV Note: Get the advanced summarization level of the source.
5552: --The profile in the target system will be overwritten with the value
5553: --in the source.
5554: IF g_src_apps_flag THEN
5555: -- Read sum level from bsc_sys_init
5556: h_sql := 'SELECT property_value'||
5557: ' FROM bsc_sys_init@'||g_db_link||
5558: ' WHERE property_code = :1';
5559: OPEN h_cursor FOR h_sql USING h_sum_level_prop_code;

Line 5557: ' FROM bsc_sys_init@'||g_db_link||

5553: --in the source.
5554: IF g_src_apps_flag THEN
5555: -- Read sum level from bsc_sys_init
5556: h_sql := 'SELECT property_value'||
5557: ' FROM bsc_sys_init@'||g_db_link||
5558: ' WHERE property_code = :1';
5559: OPEN h_cursor FOR h_sql USING h_sum_level_prop_code;
5560: FETCH h_cursor INTO g_adv_sum_level;
5561: IF h_cursor%NOTFOUND THEN

Line 5573: OPEN h_cursor FOR h_sql USING 'BSC_SYS_INIT';

5569: -- Get BSC schema name in the source system
5570: IF g_src_apps_flag THEN
5571: h_sql := 'SELECT table_owner FROM user_synonyms@'||g_db_link||
5572: ' WHERE table_name = :1';
5573: OPEN h_cursor FOR h_sql USING 'BSC_SYS_INIT';
5574: FETCH h_cursor INTO h_src_bsc_schema;
5575: IF h_cursor%NOTFOUND THEN
5576: g_src_bsc_schema := NULL;
5577: ELSE

Line 5639: UPDATE bsc_sys_init

5635: END IF;
5636:
5637: -- At this point, the system is inconsistent until everything have been migrated
5638: -- So, we flag the system like if it is not in the latest version.
5639: UPDATE bsc_sys_init
5640: SET property_value = 'UNAPPLIED',
5641: last_updated_by = BSC_APPS.fnd_global_user_id,
5642: last_update_date = SYSDATE
5643: WHERE property_code = 'TARGET_STATUS';

Line 5692: DELETE BSC_SYS_INIT where PROPERTY_CODE <> 'PATCH_NUMBER';

5688: syncup_dataset_id_in_target;
5689:
5690: --for bug 5680620 handling of bsdc_sys_init table
5691: -- DELETE THE DATA FROM TABLE EXCEPT PATCH_NUMBER
5692: DELETE BSC_SYS_INIT where PROPERTY_CODE <> 'PATCH_NUMBER';
5693: --added commit for bug fix 6470015
5694: COMMIT;
5695:
5696: -- COPY ROWS FROM TARGET TO THIS TABLE.

Line 5697: h_lst_columns := Get_Lst_Table_Columns('BSC_SYS_INIT');

5693: --added commit for bug fix 6470015
5694: COMMIT;
5695:
5696: -- COPY ROWS FROM TARGET TO THIS TABLE.
5697: h_lst_columns := Get_Lst_Table_Columns('BSC_SYS_INIT');
5698: h_sql := 'INSERT /*+ append parallel(BSC_SYS_INIT)*/'||
5699: ' INTO BSC_SYS_INIT ('||h_lst_columns||')'||
5700: ' SELECT /*+ parallel(BSC_SYS_INIT)*/ '||h_lst_columns||
5701: ' FROM BSC_SYS_INIT'||'@'||g_db_link ||

Line 5698: h_sql := 'INSERT /+ append parallel(BSC_SYS_INIT)/'||

5694: COMMIT;
5695:
5696: -- COPY ROWS FROM TARGET TO THIS TABLE.
5697: h_lst_columns := Get_Lst_Table_Columns('BSC_SYS_INIT');
5698: h_sql := 'INSERT /*+ append parallel(BSC_SYS_INIT)*/'||
5699: ' INTO BSC_SYS_INIT ('||h_lst_columns||')'||
5700: ' SELECT /*+ parallel(BSC_SYS_INIT)*/ '||h_lst_columns||
5701: ' FROM BSC_SYS_INIT'||'@'||g_db_link ||
5702: ' WHERE PROPERTY_CODE <> ''PATCH_NUMBER'' AND PROPERTY_CODE <>''EDW_INSTALLED'' ';

Line 5699: ' INTO BSC_SYS_INIT ('||h_lst_columns||')'||

5695:
5696: -- COPY ROWS FROM TARGET TO THIS TABLE.
5697: h_lst_columns := Get_Lst_Table_Columns('BSC_SYS_INIT');
5698: h_sql := 'INSERT /*+ append parallel(BSC_SYS_INIT)*/'||
5699: ' INTO BSC_SYS_INIT ('||h_lst_columns||')'||
5700: ' SELECT /*+ parallel(BSC_SYS_INIT)*/ '||h_lst_columns||
5701: ' FROM BSC_SYS_INIT'||'@'||g_db_link ||
5702: ' WHERE PROPERTY_CODE <> ''PATCH_NUMBER'' AND PROPERTY_CODE <>''EDW_INSTALLED'' ';
5703: BSC_APPS.Execute_Immediate(h_sql);

Line 5700: ' SELECT /+ parallel(BSC_SYS_INIT)/ '||h_lst_columns||

5696: -- COPY ROWS FROM TARGET TO THIS TABLE.
5697: h_lst_columns := Get_Lst_Table_Columns('BSC_SYS_INIT');
5698: h_sql := 'INSERT /*+ append parallel(BSC_SYS_INIT)*/'||
5699: ' INTO BSC_SYS_INIT ('||h_lst_columns||')'||
5700: ' SELECT /*+ parallel(BSC_SYS_INIT)*/ '||h_lst_columns||
5701: ' FROM BSC_SYS_INIT'||'@'||g_db_link ||
5702: ' WHERE PROPERTY_CODE <> ''PATCH_NUMBER'' AND PROPERTY_CODE <>''EDW_INSTALLED'' ';
5703: BSC_APPS.Execute_Immediate(h_sql);
5704: COMMIT;

Line 5701: ' FROM BSC_SYS_INIT'||'@'||g_db_link ||

5697: h_lst_columns := Get_Lst_Table_Columns('BSC_SYS_INIT');
5698: h_sql := 'INSERT /*+ append parallel(BSC_SYS_INIT)*/'||
5699: ' INTO BSC_SYS_INIT ('||h_lst_columns||')'||
5700: ' SELECT /*+ parallel(BSC_SYS_INIT)*/ '||h_lst_columns||
5701: ' FROM BSC_SYS_INIT'||'@'||g_db_link ||
5702: ' WHERE PROPERTY_CODE <> ''PATCH_NUMBER'' AND PROPERTY_CODE <>''EDW_INSTALLED'' ';
5703: BSC_APPS.Execute_Immediate(h_sql);
5704: COMMIT;
5705:

Line 5708: -- I do it again because the records in BSC_SYS_INIT have been migrated from the source.

5704: COMMIT;
5705:
5706: -- At this point, the system is inconsistent until everything have been migrated
5707: -- So, we flag the system like if it is not in the latest version.
5708: -- I do it again because the records in BSC_SYS_INIT have been migrated from the source.
5709: UPDATE bsc_sys_init
5710: SET property_value = 'UNAPPLIED',
5711: last_updated_by = BSC_APPS.fnd_global_user_id,
5712: last_update_date = SYSDATE

Line 5709: UPDATE bsc_sys_init

5705:
5706: -- At this point, the system is inconsistent until everything have been migrated
5707: -- So, we flag the system like if it is not in the latest version.
5708: -- I do it again because the records in BSC_SYS_INIT have been migrated from the source.
5709: UPDATE bsc_sys_init
5710: SET property_value = 'UNAPPLIED',
5711: last_updated_by = BSC_APPS.fnd_global_user_id,
5712: last_update_date = SYSDATE
5713: WHERE property_code = 'TARGET_STATUS';

Line 6029: UPDATE bsc_sys_init

6025: RAISE e_unexpected_error;
6026: END IF;
6027:
6028: -- At this point, the system is consistent
6029: UPDATE bsc_sys_init
6030: SET property_value = 'APPLIED',
6031: last_updated_by = BSC_APPS.fnd_global_user_id,
6032: last_update_date = SYSDATE
6033: WHERE property_code = 'TARGET_STATUS';

Line 6785: ' FROM bsc_sys_init'||

6781: -- so as to use it later for log messages
6782:
6783: -- get the version of the target system
6784: h_sql := 'SELECT property_value'||
6785: ' FROM bsc_sys_init'||
6786: ' WHERE UPPER(property_code) = :1';
6787: OPEN h_cursor FOR h_sql USING 'PATCH_NUMBER';
6788: FETCH h_cursor INTO h_trg_version;
6789: IF h_cursor%NOTFOUND THEN

Line 6797: ' FROM bsc_sys_init@'||g_db_link||

6793: CLOSE h_cursor;
6794:
6795: -- get the version of the source system
6796: h_sql := 'SELECT property_value'||
6797: ' FROM bsc_sys_init@'||g_db_link||
6798: ' WHERE UPPER(property_code) = :1';
6799: OPEN h_cursor FOR h_sql USING 'PATCH_NUMBER';
6800: FETCH h_cursor INTO h_src_version;
6801: IF h_cursor%NOTFOUND THEN

Line 6813: ' FROM bsc_sys_init@'||g_db_link||

6809: END IF;
6810: CLOSE h_cursor;
6811:
6812: h_sql := 'SELECT property_value'||
6813: ' FROM bsc_sys_init@'||g_db_link||
6814: ' WHERE UPPER(property_code) = :1';
6815: OPEN h_cursor FOR h_sql USING 'PATCH_STATUS';
6816: FETCH h_cursor INTO h_status;
6817: IF h_cursor%NOTFOUND THEN

Line 6828: ' FROM bsc_sys_init'||

6824: RAISE e_src_invalid_version;
6825: END IF;
6826:
6827: h_sql := 'SELECT property_value'||
6828: ' FROM bsc_sys_init'||
6829: ' WHERE UPPER(property_code) = :1';
6830: OPEN h_cursor FOR h_sql USING 'PATCH_STATUS';
6831: FETCH h_cursor INTO h_status;
6832: IF h_cursor%FOUND THEN