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 DUAL

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 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 4768: h_sql := 'SELECT BSC_SYS_CALENDAR_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';

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.
4768: h_sql := 'SELECT BSC_SYS_CALENDAR_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';
4769: OPEN h_cursor FOR h_sql;
4770: FETCH h_cursor INTO h_src_currval;
4771: CLOSE h_cursor;
4772:

Line 4773: SELECT BSC_SYS_CALENDAR_ID_S.NEXTVAL INTO h_currval FROM DUAL;

4769: OPEN h_cursor FOR h_sql;
4770: FETCH h_cursor INTO h_src_currval;
4771: CLOSE h_cursor;
4772:
4773: SELECT BSC_SYS_CALENDAR_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4774: IF h_src_currval > h_currval THEN
4775: h_interval := h_src_currval - h_currval;
4776:
4777: h_sql := 'ALTER SEQUENCE BSC_SYS_CALENDAR_ID_S INCREMENT BY '||h_interval;

Line 4780: SELECT BSC_SYS_CALENDAR_ID_S.NEXTVAL INTO h_currval FROM DUAL;

4776:
4777: h_sql := 'ALTER SEQUENCE BSC_SYS_CALENDAR_ID_S INCREMENT BY '||h_interval;
4778: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_CALENDAR_ID_S');
4779:
4780: SELECT BSC_SYS_CALENDAR_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4781:
4782: h_sql := 'ALTER SEQUENCE BSC_SYS_CALENDAR_ID_S INCREMENT BY 1';
4783: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_CALENDAR_ID_S');
4784: END IF;

Line 4788: h_sql := 'SELECT BSC_SYS_PERIODICITY_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';

4784: END IF;
4785:
4786: -- 4. Reset sequence BSC_SYS_PERIODICITY_ID_S to start with at least the same current value of the sequence
4787: -- in the source system.
4788: h_sql := 'SELECT BSC_SYS_PERIODICITY_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';
4789: OPEN h_cursor FOR h_sql;
4790: FETCH h_cursor INTO h_src_currval;
4791: CLOSE h_cursor;
4792:

Line 4793: SELECT BSC_SYS_PERIODICITY_ID_S.NEXTVAL INTO h_currval FROM DUAL;

4789: OPEN h_cursor FOR h_sql;
4790: FETCH h_cursor INTO h_src_currval;
4791: CLOSE h_cursor;
4792:
4793: SELECT BSC_SYS_PERIODICITY_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4794: IF h_src_currval > h_currval THEN
4795: h_interval := h_src_currval - h_currval;
4796:
4797: h_sql := 'ALTER SEQUENCE BSC_SYS_PERIODICITY_ID_S INCREMENT BY '||h_interval;

Line 4800: SELECT BSC_SYS_PERIODICITY_ID_S.NEXTVAL INTO h_currval FROM DUAL;

4796:
4797: h_sql := 'ALTER SEQUENCE BSC_SYS_PERIODICITY_ID_S INCREMENT BY '||h_interval;
4798: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_PERIODICITY_ID_S');
4799:
4800: SELECT BSC_SYS_PERIODICITY_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4801:
4802: h_sql := 'ALTER SEQUENCE BSC_SYS_PERIODICITY_ID_S INCREMENT BY 1';
4803: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_PERIODICITY_ID_S');
4804: END IF;

Line 4852: h_sql := 'SELECT BSC_KPI_COMMENTS_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';

4848: END IF;
4849:
4850: -- 7. Reset sequence BSC_KPI_COMMENTS_ID_S to start with at least the same current value of the sequence
4851: -- in the source system.
4852: h_sql := 'SELECT BSC_KPI_COMMENTS_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';
4853: OPEN h_cursor FOR h_sql;
4854: FETCH h_cursor INTO h_src_currval;
4855: CLOSE h_cursor;
4856:

Line 4857: SELECT BSC_KPI_COMMENTS_ID_S.NEXTVAL INTO h_currval FROM DUAL;

4853: OPEN h_cursor FOR h_sql;
4854: FETCH h_cursor INTO h_src_currval;
4855: CLOSE h_cursor;
4856:
4857: SELECT BSC_KPI_COMMENTS_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4858: IF h_src_currval > h_currval THEN
4859: h_interval := h_src_currval - h_currval;
4860:
4861: h_sql := 'ALTER SEQUENCE BSC_KPI_COMMENTS_ID_S INCREMENT BY '||h_interval;

Line 4864: SELECT BSC_KPI_COMMENTS_ID_S.NEXTVAL INTO h_currval FROM DUAL;

4860:
4861: h_sql := 'ALTER SEQUENCE BSC_KPI_COMMENTS_ID_S INCREMENT BY '||h_interval;
4862: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_KPI_COMMENTS_ID_S');
4863:
4864: SELECT BSC_KPI_COMMENTS_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4865:
4866: h_sql := 'ALTER SEQUENCE BSC_KPI_COMMENTS_ID_S INCREMENT BY 1';
4867: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_KPI_COMMENTS_ID_S');
4868: END IF;

Line 4917: h_sql := 'SELECT BSC_INTERNAL_COLUMN_S.NEXTVAL@'||g_db_link||' FROM DUAL';

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.
4917: h_sql := 'SELECT BSC_INTERNAL_COLUMN_S.NEXTVAL@'||g_db_link||' FROM DUAL';
4918: OPEN h_cursor FOR h_sql;
4919: FETCH h_cursor INTO h_src_currval;
4920: CLOSE h_cursor;
4921:

Line 4922: SELECT BSC_INTERNAL_COLUMN_S.NEXTVAL INTO h_currval FROM DUAL;

4918: OPEN h_cursor FOR h_sql;
4919: FETCH h_cursor INTO h_src_currval;
4920: CLOSE h_cursor;
4921:
4922: SELECT BSC_INTERNAL_COLUMN_S.NEXTVAL INTO h_currval FROM DUAL;
4923: IF h_src_currval > h_currval THEN
4924: h_interval := h_src_currval - h_currval;
4925:
4926: h_sql := 'ALTER SEQUENCE BSC_INTERNAL_COLUMN_S INCREMENT BY '||h_interval;

Line 4929: SELECT BSC_INTERNAL_COLUMN_S.NEXTVAL INTO h_currval FROM DUAL;

4925:
4926: h_sql := 'ALTER SEQUENCE BSC_INTERNAL_COLUMN_S INCREMENT BY '||h_interval;
4927: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_INTERNAL_COLUMN_S');
4928:
4929: SELECT BSC_INTERNAL_COLUMN_S.NEXTVAL INTO h_currval FROM DUAL;
4930:
4931: h_sql := 'ALTER SEQUENCE BSC_INTERNAL_COLUMN_S INCREMENT BY 1';
4932: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_INTERNAL_COLUMN_S');
4933: END IF;

Line 4937: h_sql := 'SELECT BSC_SYS_DIM_LEVEL_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';

4933: END IF;
4934:
4935: -- 12. Reset sequence BSC_SYS_DIM_LEVEL_ID_S to start with at least the same current value of the sequence
4936: -- in the source system.
4937: h_sql := 'SELECT BSC_SYS_DIM_LEVEL_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';
4938: OPEN h_cursor FOR h_sql;
4939: FETCH h_cursor INTO h_src_currval;
4940: CLOSE h_cursor;
4941:

Line 4942: SELECT BSC_SYS_DIM_LEVEL_ID_S.NEXTVAL INTO h_currval FROM DUAL;

4938: OPEN h_cursor FOR h_sql;
4939: FETCH h_cursor INTO h_src_currval;
4940: CLOSE h_cursor;
4941:
4942: SELECT BSC_SYS_DIM_LEVEL_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4943: IF h_src_currval > h_currval THEN
4944: h_interval := h_src_currval - h_currval;
4945:
4946: h_sql := 'ALTER SEQUENCE BSC_SYS_DIM_LEVEL_ID_S INCREMENT BY '||h_interval;

Line 4949: SELECT BSC_SYS_DIM_LEVEL_ID_S.NEXTVAL INTO h_currval FROM DUAL;

4945:
4946: h_sql := 'ALTER SEQUENCE BSC_SYS_DIM_LEVEL_ID_S INCREMENT BY '||h_interval;
4947: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_DIM_LEVEL_ID_S');
4948:
4949: SELECT BSC_SYS_DIM_LEVEL_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4950:
4951: h_sql := 'ALTER SEQUENCE BSC_SYS_DIM_LEVEL_ID_S INCREMENT BY 1';
4952: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_DIM_LEVEL_ID_S');
4953: END IF;

Line 4957: h_sql := 'SELECT BSC_SYS_DIM_GROUP_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';

4953: END IF;
4954:
4955: -- 13. Reset sequence BSC_SYS_DIM_GROUP_ID_S to start with at least the same current value of the sequence
4956: -- in the source system.
4957: h_sql := 'SELECT BSC_SYS_DIM_GROUP_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';
4958: OPEN h_cursor FOR h_sql;
4959: FETCH h_cursor INTO h_src_currval;
4960: CLOSE h_cursor;
4961:

Line 4962: SELECT BSC_SYS_DIM_GROUP_ID_S.NEXTVAL INTO h_currval FROM DUAL;

4958: OPEN h_cursor FOR h_sql;
4959: FETCH h_cursor INTO h_src_currval;
4960: CLOSE h_cursor;
4961:
4962: SELECT BSC_SYS_DIM_GROUP_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4963: IF h_src_currval > h_currval THEN
4964: h_interval := h_src_currval - h_currval;
4965:
4966: h_sql := 'ALTER SEQUENCE BSC_SYS_DIM_GROUP_ID_S INCREMENT BY '||h_interval;

Line 4969: SELECT BSC_SYS_DIM_GROUP_ID_S.NEXTVAL INTO h_currval FROM DUAL;

4965:
4966: h_sql := 'ALTER SEQUENCE BSC_SYS_DIM_GROUP_ID_S INCREMENT BY '||h_interval;
4967: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_DIM_GROUP_ID_S');
4968:
4969: SELECT BSC_SYS_DIM_GROUP_ID_S.NEXTVAL INTO h_currval FROM DUAL;
4970:
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;

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 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 4997: h_sql := 'SELECT BSC_SYS_MEASURE_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';

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.
4997: h_sql := 'SELECT BSC_SYS_MEASURE_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';
4998: OPEN h_cursor FOR h_sql;
4999: FETCH h_cursor INTO h_src_currval;
5000: CLOSE h_cursor;
5001:

Line 5002: SELECT BSC_SYS_MEASURE_ID_S.NEXTVAL INTO h_currval FROM DUAL;

4998: OPEN h_cursor FOR h_sql;
4999: FETCH h_cursor INTO h_src_currval;
5000: CLOSE h_cursor;
5001:
5002: SELECT BSC_SYS_MEASURE_ID_S.NEXTVAL INTO h_currval FROM DUAL;
5003: IF h_src_currval > h_currval THEN
5004: h_interval := h_src_currval - h_currval;
5005:
5006: h_sql := 'ALTER SEQUENCE BSC_SYS_MEASURE_ID_S INCREMENT BY '||h_interval;

Line 5009: SELECT BSC_SYS_MEASURE_ID_S.NEXTVAL INTO h_currval FROM DUAL;

5005:
5006: h_sql := 'ALTER SEQUENCE BSC_SYS_MEASURE_ID_S INCREMENT BY '||h_interval;
5007: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_MEASURE_ID_S');
5008:
5009: SELECT BSC_SYS_MEASURE_ID_S.NEXTVAL INTO h_currval FROM DUAL;
5010:
5011: h_sql := 'ALTER SEQUENCE BSC_SYS_MEASURE_ID_S INCREMENT BY 1';
5012: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_MEASURE_ID_S');
5013: END IF;

Line 5017: h_sql := 'SELECT BSC_DB_MEASURE_GROUPS_S.NEXTVAL@'||g_db_link||' FROM DUAL';

5013: END IF;
5014:
5015: -- 16. Reset sequence BSC_DB_MEASURE_GROUPS_S to start with at least the same current value of the sequence
5016: -- in the source system.
5017: h_sql := 'SELECT BSC_DB_MEASURE_GROUPS_S.NEXTVAL@'||g_db_link||' FROM DUAL';
5018: OPEN h_cursor FOR h_sql;
5019: FETCH h_cursor INTO h_src_currval;
5020: CLOSE h_cursor;
5021:

Line 5022: SELECT BSC_DB_MEASURE_GROUPS_S.NEXTVAL INTO h_currval FROM DUAL;

5018: OPEN h_cursor FOR h_sql;
5019: FETCH h_cursor INTO h_src_currval;
5020: CLOSE h_cursor;
5021:
5022: SELECT BSC_DB_MEASURE_GROUPS_S.NEXTVAL INTO h_currval FROM DUAL;
5023: IF h_src_currval > h_currval THEN
5024: h_interval := h_src_currval - h_currval;
5025:
5026: h_sql := 'ALTER SEQUENCE BSC_DB_MEASURE_GROUPS_S INCREMENT BY '||h_interval;

Line 5029: SELECT BSC_DB_MEASURE_GROUPS_S.NEXTVAL INTO h_currval FROM DUAL;

5025:
5026: h_sql := 'ALTER SEQUENCE BSC_DB_MEASURE_GROUPS_S INCREMENT BY '||h_interval;
5027: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_DB_MEASURE_GROUPS_S');
5028:
5029: SELECT BSC_DB_MEASURE_GROUPS_S.NEXTVAL INTO h_currval FROM DUAL;
5030:
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;

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 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 5057: h_sql := 'SELECT BSC_KPI_MEASURE_S.NEXTVAL@'||g_db_link||' FROM DUAL';

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.
5057: h_sql := 'SELECT BSC_KPI_MEASURE_S.NEXTVAL@'||g_db_link||' FROM DUAL';
5058: OPEN h_cursor FOR h_sql;
5059: FETCH h_cursor INTO h_src_currval;
5060: CLOSE h_cursor;
5061:

Line 5062: SELECT BSC_KPI_MEASURE_S.NEXTVAL INTO h_currval FROM DUAL;

5058: OPEN h_cursor FOR h_sql;
5059: FETCH h_cursor INTO h_src_currval;
5060: CLOSE h_cursor;
5061:
5062: SELECT BSC_KPI_MEASURE_S.NEXTVAL INTO h_currval FROM DUAL;
5063: IF h_src_currval > h_currval THEN
5064: h_interval := h_src_currval - h_currval;
5065:
5066: h_sql := 'ALTER SEQUENCE BSC_KPI_MEASURE_S INCREMENT BY '||h_interval;

Line 5069: SELECT BSC_KPI_MEASURE_S.NEXTVAL INTO h_currval FROM DUAL;

5065:
5066: h_sql := 'ALTER SEQUENCE BSC_KPI_MEASURE_S INCREMENT BY '||h_interval;
5067: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_KPI_MEASURE_S');
5068:
5069: SELECT BSC_KPI_MEASURE_S.NEXTVAL INTO h_currval FROM DUAL;
5070:
5071: h_sql := 'ALTER SEQUENCE BSC_KPI_MEASURE_S INCREMENT BY 1';
5072: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_KPI_MEASURE_S');
5073: END IF;

Line 5077: h_sql := 'SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';

5073: END IF;
5074:
5075: -- 18. Reset sequence BSC_COLOR_RANGE_ID_S to start with at least the same current value of the sequence
5076: -- in the source system.
5077: h_sql := 'SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL@'||g_db_link||' FROM DUAL';
5078: OPEN h_cursor FOR h_sql;
5079: FETCH h_cursor INTO h_src_currval;
5080: CLOSE h_cursor;
5081:

Line 5082: SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL INTO h_currval FROM DUAL;

5078: OPEN h_cursor FOR h_sql;
5079: FETCH h_cursor INTO h_src_currval;
5080: CLOSE h_cursor;
5081:
5082: SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL INTO h_currval FROM DUAL;
5083: IF h_src_currval > h_currval THEN
5084: h_interval := h_src_currval - h_currval;
5085:
5086: h_sql := 'ALTER SEQUENCE BSC_COLOR_RANGE_ID_S INCREMENT BY '||h_interval;

Line 5089: SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL INTO h_currval FROM DUAL;

5085:
5086: h_sql := 'ALTER SEQUENCE BSC_COLOR_RANGE_ID_S INCREMENT BY '||h_interval;
5087: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_COLOR_RANGE_ID_S');
5088:
5089: SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL INTO h_currval FROM DUAL;
5090:
5091: h_sql := 'ALTER SEQUENCE BSC_COLOR_RANGE_ID_S INCREMENT BY 1';
5092: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_COLOR_RANGE_ID_S');
5093: END IF;

Line 8743: SELECT fnd_form_functions_s.nextval INTO h_function_id FROM DUAL;

8739: END IF;
8740: CLOSE c_function_id;
8741:
8742: -- Create the form function in the target
8743: SELECT fnd_form_functions_s.nextval INTO h_function_id FROM DUAL;
8744:
8745: FND_FORM_FUNCTIONS_PKG.INSERT_ROW (
8746: X_ROWID => h_rowid,
8747: X_FUNCTION_ID => h_function_id,

Line 9693: FROM dual;

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);
9696: ELSIF(l_table_name='BSC_SYS_IMAGES' AND UPPER(l_arr_columns(i)) = 'IMAGE_ID' )THEN
9697:

Line 9756: FROM dual;

9752: SELECT
9753: FND_FORM_FUNCTIONS_S.NEXTVAL
9754: INTO
9755: l_New_Function_Id
9756: FROM dual;
9757:
9758: FOR h_i IN 1..l_Table_Number LOOP
9759: IF(l_kpi_metadata_tables(h_i).duplicate_data = bsc_utility.YES AND
9760: l_kpi_metadata_tables(h_i).table_type=BSC_SIMULATION_VIEW_PVT.C_AK_TABLE) THEN