APPS.BSC_MIGRATION dependencies on BSC_INDICATOR_ID_S

Line 5035: -- 17. Reset sequence BSC_INDICATOR_ID_S to start with at least the same current value of the sequence

5031: h_sql := 'ALTER SEQUENCE BSC_DB_MEASURE_GROUPS_S INCREMENT BY 1';
5032: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_DB_MEASURE_GROUPS_S');
5033: END IF;
5034:
5035: -- 17. Reset sequence BSC_INDICATOR_ID_S to start with at least the same current value of the sequence
5036: -- in the source system.
5037: h_sql := 'SELECT BSC_INDICATOR_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';
5038: OPEN h_cursor FOR h_sql;
5039: FETCH h_cursor INTO h_src_currval;

Line 5037: h_sql := 'SELECT BSC_INDICATOR_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';

5033: END IF;
5034:
5035: -- 17. Reset sequence BSC_INDICATOR_ID_S to start with at least the same current value of the sequence
5036: -- in the source system.
5037: h_sql := 'SELECT BSC_INDICATOR_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';
5038: OPEN h_cursor FOR h_sql;
5039: FETCH h_cursor INTO h_src_currval;
5040: CLOSE h_cursor;
5041:

Line 5042: SELECT BSC_INDICATOR_ID_S.NEXTVAL INTO h_currval FROM DUAL;

5038: OPEN h_cursor FOR h_sql;
5039: FETCH h_cursor INTO h_src_currval;
5040: CLOSE h_cursor;
5041:
5042: SELECT BSC_INDICATOR_ID_S.NEXTVAL INTO h_currval FROM DUAL;
5043: IF h_src_currval > h_currval THEN
5044: h_interval := h_src_currval - h_currval;
5045:
5046: h_sql := 'ALTER SEQUENCE BSC_INDICATOR_ID_S INCREMENT BY '||h_interval;

Line 5046: h_sql := 'ALTER SEQUENCE BSC_INDICATOR_ID_S INCREMENT BY '||h_interval;

5042: SELECT BSC_INDICATOR_ID_S.NEXTVAL INTO h_currval FROM DUAL;
5043: IF h_src_currval > h_currval THEN
5044: h_interval := h_src_currval - h_currval;
5045:
5046: h_sql := 'ALTER SEQUENCE BSC_INDICATOR_ID_S INCREMENT BY '||h_interval;
5047: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_INDICATOR_ID_S');
5048:
5049: SELECT BSC_INDICATOR_ID_S.NEXTVAL INTO h_currval FROM DUAL;
5050:

Line 5047: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_INDICATOR_ID_S');

5043: IF h_src_currval > h_currval THEN
5044: h_interval := h_src_currval - h_currval;
5045:
5046: h_sql := 'ALTER SEQUENCE BSC_INDICATOR_ID_S INCREMENT BY '||h_interval;
5047: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_INDICATOR_ID_S');
5048:
5049: SELECT BSC_INDICATOR_ID_S.NEXTVAL INTO h_currval FROM DUAL;
5050:
5051: h_sql := 'ALTER SEQUENCE BSC_INDICATOR_ID_S INCREMENT BY 1';

Line 5049: SELECT BSC_INDICATOR_ID_S.NEXTVAL INTO h_currval FROM DUAL;

5045:
5046: h_sql := 'ALTER SEQUENCE BSC_INDICATOR_ID_S INCREMENT BY '||h_interval;
5047: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_INDICATOR_ID_S');
5048:
5049: SELECT BSC_INDICATOR_ID_S.NEXTVAL INTO h_currval FROM DUAL;
5050:
5051: h_sql := 'ALTER SEQUENCE BSC_INDICATOR_ID_S INCREMENT BY 1';
5052: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_INDICATOR_ID_S');
5053: END IF;

Line 5051: h_sql := 'ALTER SEQUENCE BSC_INDICATOR_ID_S INCREMENT BY 1';

5047: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_INDICATOR_ID_S');
5048:
5049: SELECT BSC_INDICATOR_ID_S.NEXTVAL INTO h_currval FROM DUAL;
5050:
5051: h_sql := 'ALTER SEQUENCE BSC_INDICATOR_ID_S INCREMENT BY 1';
5052: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_INDICATOR_ID_S');
5053: END IF;
5054:
5055: -- 18. Reset sequence BSC_KPI_MEASURE_S to start with at least the same current value of the sequence

Line 5052: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_INDICATOR_ID_S');

5048:
5049: SELECT BSC_INDICATOR_ID_S.NEXTVAL INTO h_currval FROM DUAL;
5050:
5051: h_sql := 'ALTER SEQUENCE BSC_INDICATOR_ID_S INCREMENT BY 1';
5052: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_INDICATOR_ID_S');
5053: END IF;
5054:
5055: -- 18. Reset sequence BSC_KPI_MEASURE_S to start with at least the same current value of the sequence
5056: -- in the source system.