APPS.BSC_MIGRATION dependencies on BSC_SYS_DATASET_ID_S

Line 4975: -- 14. Reset sequence BSC_SYS_DATASET_ID_S to start with at least the same current value of the sequence

4971: h_sql := 'ALTER SEQUENCE BSC_SYS_DIM_GROUP_ID_S INCREMENT BY 1';
4972: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_DIM_GROUP_ID_S');
4973: END IF;
4974:
4975: -- 14. Reset sequence BSC_SYS_DATASET_ID_S to start with at least the same current value of the sequence
4976: -- in the source system.
4977: h_sql := 'SELECT BSC_SYS_DATASET_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';
4978: OPEN h_cursor FOR h_sql;
4979: FETCH h_cursor INTO h_src_currval;

Line 4977: h_sql := 'SELECT BSC_SYS_DATASET_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';

4973: END IF;
4974:
4975: -- 14. Reset sequence BSC_SYS_DATASET_ID_S to start with at least the same current value of the sequence
4976: -- in the source system.
4977: h_sql := 'SELECT BSC_SYS_DATASET_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';
4978: OPEN h_cursor FOR h_sql;
4979: FETCH h_cursor INTO h_src_currval;
4980: CLOSE h_cursor;
4981:

Line 4982: SELECT BSC_SYS_DATASET_ID_S.NEXTVAL INTO h_currval FROM DUAL;

4978: OPEN h_cursor FOR h_sql;
4979: FETCH h_cursor INTO h_src_currval;
4980: CLOSE h_cursor;
4981:
4982: SELECT BSC_SYS_DATASET_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4983: IF h_src_currval > h_currval THEN
4984: h_interval := h_src_currval - h_currval;
4985:
4986: h_sql := 'ALTER SEQUENCE BSC_SYS_DATASET_ID_S INCREMENT BY '||h_interval;

Line 4986: h_sql := 'ALTER SEQUENCE BSC_SYS_DATASET_ID_S INCREMENT BY '||h_interval;

4982: SELECT BSC_SYS_DATASET_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4983: IF h_src_currval > h_currval THEN
4984: h_interval := h_src_currval - h_currval;
4985:
4986: h_sql := 'ALTER SEQUENCE BSC_SYS_DATASET_ID_S INCREMENT BY '||h_interval;
4987: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_DATASET_ID_S');
4988:
4989: SELECT BSC_SYS_DATASET_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4990:

Line 4987: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_DATASET_ID_S');

4983: IF h_src_currval > h_currval THEN
4984: h_interval := h_src_currval - h_currval;
4985:
4986: h_sql := 'ALTER SEQUENCE BSC_SYS_DATASET_ID_S INCREMENT BY '||h_interval;
4987: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_DATASET_ID_S');
4988:
4989: SELECT BSC_SYS_DATASET_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4990:
4991: h_sql := 'ALTER SEQUENCE BSC_SYS_DATASET_ID_S INCREMENT BY 1';

Line 4989: SELECT BSC_SYS_DATASET_ID_S.NEXTVAL INTO h_currval FROM DUAL;

4985:
4986: h_sql := 'ALTER SEQUENCE BSC_SYS_DATASET_ID_S INCREMENT BY '||h_interval;
4987: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_DATASET_ID_S');
4988:
4989: SELECT BSC_SYS_DATASET_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4990:
4991: h_sql := 'ALTER SEQUENCE BSC_SYS_DATASET_ID_S INCREMENT BY 1';
4992: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_DATASET_ID_S');
4993: END IF;

Line 4991: h_sql := 'ALTER SEQUENCE BSC_SYS_DATASET_ID_S INCREMENT BY 1';

4987: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_DATASET_ID_S');
4988:
4989: SELECT BSC_SYS_DATASET_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4990:
4991: h_sql := 'ALTER SEQUENCE BSC_SYS_DATASET_ID_S INCREMENT BY 1';
4992: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_DATASET_ID_S');
4993: END IF;
4994:
4995: -- 15. Reset sequence BSC_SYS_MEASURE_ID_S to start with at least the same current value of the sequence

Line 4992: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_DATASET_ID_S');

4988:
4989: SELECT BSC_SYS_DATASET_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4990:
4991: h_sql := 'ALTER SEQUENCE BSC_SYS_DATASET_ID_S INCREMENT BY 1';
4992: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_DATASET_ID_S');
4993: END IF;
4994:
4995: -- 15. Reset sequence BSC_SYS_MEASURE_ID_S to start with at least the same current value of the sequence
4996: -- in the source system.