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_IMAGE_ID_S

Line 4742: -- 2. Reset sequence BSC_SYS_IMAGE_ID_S to start with at least the same current value of the sequence

4738: ' NOT ('||h_effect_cond||')';
4739: BSC_APPS.Execute_Immediate(h_sql);
4740: COMMIT;
4741:
4742: -- 2. Reset sequence BSC_SYS_IMAGE_ID_S to start with at least the same current value of the sequence
4743: -- in the source system.
4744: -- Bug resetting sequences: We cannot drop the sequence to reset the start value because the packages
4745: -- using the sequence will become invalid.
4746: -- We will use alter sequence and NEXTVAL to reset the start value is the current value

Line 4748: h_sql := 'SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';

4744: -- Bug resetting sequences: We cannot drop the sequence to reset the start value because the packages
4745: -- using the sequence will become invalid.
4746: -- We will use alter sequence and NEXTVAL to reset the start value is the current value
4747: -- in the source system is greater than the current value in the target system.
4748: h_sql := 'SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';
4749: OPEN h_cursor FOR h_sql;
4750: FETCH h_cursor INTO h_src_currval;
4751: CLOSE h_cursor;
4752:

Line 4753: SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL INTO h_currval FROM DUAL;

4749: OPEN h_cursor FOR h_sql;
4750: FETCH h_cursor INTO h_src_currval;
4751: CLOSE h_cursor;
4752:
4753: SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4754: IF h_src_currval > h_currval THEN
4755: h_interval := h_src_currval - h_currval;
4756:
4757: h_sql := 'ALTER SEQUENCE BSC_SYS_IMAGE_ID_S INCREMENT BY '||h_interval;

Line 4757: h_sql := 'ALTER SEQUENCE BSC_SYS_IMAGE_ID_S INCREMENT BY '||h_interval;

4753: SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4754: IF h_src_currval > h_currval THEN
4755: h_interval := h_src_currval - h_currval;
4756:
4757: h_sql := 'ALTER SEQUENCE BSC_SYS_IMAGE_ID_S INCREMENT BY '||h_interval;
4758: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_IMAGE_ID_S');
4759:
4760: SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4761:

Line 4758: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_IMAGE_ID_S');

4754: IF h_src_currval > h_currval THEN
4755: h_interval := h_src_currval - h_currval;
4756:
4757: h_sql := 'ALTER SEQUENCE BSC_SYS_IMAGE_ID_S INCREMENT BY '||h_interval;
4758: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_IMAGE_ID_S');
4759:
4760: SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4761:
4762: h_sql := 'ALTER SEQUENCE BSC_SYS_IMAGE_ID_S INCREMENT BY 1';

Line 4760: SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL INTO h_currval FROM DUAL;

4756:
4757: h_sql := 'ALTER SEQUENCE BSC_SYS_IMAGE_ID_S INCREMENT BY '||h_interval;
4758: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_IMAGE_ID_S');
4759:
4760: SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4761:
4762: h_sql := 'ALTER SEQUENCE BSC_SYS_IMAGE_ID_S INCREMENT BY 1';
4763: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_IMAGE_ID_S');
4764: END IF;

Line 4762: h_sql := 'ALTER SEQUENCE BSC_SYS_IMAGE_ID_S INCREMENT BY 1';

4758: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_IMAGE_ID_S');
4759:
4760: SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4761:
4762: h_sql := 'ALTER SEQUENCE BSC_SYS_IMAGE_ID_S INCREMENT BY 1';
4763: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_IMAGE_ID_S');
4764: END IF;
4765:
4766: -- 3. Reset sequence BSC_SYS_CALENDAR_ID_S to start with at least the same current value of the sequence

Line 4763: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_IMAGE_ID_S');

4759:
4760: SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4761:
4762: h_sql := 'ALTER SEQUENCE BSC_SYS_IMAGE_ID_S INCREMENT BY 1';
4763: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_IMAGE_ID_S');
4764: END IF;
4765:
4766: -- 3. Reset sequence BSC_SYS_CALENDAR_ID_S to start with at least the same current value of the sequence
4767: -- in the source system.

Line 9691: SELECT bsc_sys_image_id_s.nextval

9687: END IF;
9688:
9689: IF(l_table_name='BSC_SYS_IMAGES_MAP_TL' AND UPPER(l_arr_columns(i)) = 'IMAGE_ID') THEN
9690:
9691: SELECT bsc_sys_image_id_s.nextval
9692: INTO l_next_image_id
9693: FROM dual;
9694:
9695: l_sql:= l_sql || l_next_image_id || ' AS ' || l_arr_columns(i);