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 AD_DDL

Line 784: --BSC_APPS.Do_DDL(h_sql, AD_DDL.TRUNCATE_TABLE, h_table);

780: IF BSC_APPS.Table_Exists(h_table) THEN
781: -- Fix perf bug#4583017: do not truncate, just drop.
782: -- Truncate table to release space --> Bug: DROP TABLE don't release the space immediately
783: --h_sql := 'TRUNCATE TABLE '||h_table;
784: --BSC_APPS.Do_DDL(h_sql, AD_DDL.TRUNCATE_TABLE, h_table);
785:
786: h_sql := 'DROP TABLE '||h_table;
787: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, h_table);
788: END IF;

Line 787: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, h_table);

783: --h_sql := 'TRUNCATE TABLE '||h_table;
784: --BSC_APPS.Do_DDL(h_sql, AD_DDL.TRUNCATE_TABLE, h_table);
785:
786: h_sql := 'DROP TABLE '||h_table;
787: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, h_table);
788: END IF;
789: ---------
790:
791: IF NOT g_src_apps_flag THEN

Line 923: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_TABLE, x_table);

919: h_sql := h_sql||' '||bsc_dbgen_metadata_reader.get_partition_clause;
920: END IF;
921: h_sql := h_sql||' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(x_tbs_type)||' '||h_storage;
922:
923: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_TABLE, x_table);
924: END IF;
925:
926: RETURN TRUE;
927:

Line 1719: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_INDEX, h_index_name);

1715: END IF;
1716:
1717: h_sql := h_sql||' PARALLEL NOLOGGING COMPUTE STATISTICS'||
1718: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(x_tbs_type)||' '||h_storage;
1719: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_INDEX, h_index_name);
1720: commit;
1721:
1722: -- Fix performance bug#3860149: do not leave the index in parallel
1723: -- Fix perf bug#4583017: Use NOLOGGING option

Line 1820: BSC_APPS.Do_DDL(h_sql, AD_DDL.TRUNCATE_TABLE, g_metadata_tables(h_i).table_name);

1816: BSC_APPS.Write_Line_Log(h_message, BSC_APPS.OUTPUT_FILE);
1817:
1818: -- Fix bug#4430901: Use truncate instead of delete
1819: h_sql := 'TRUNCATE TABLE '||g_metadata_tables(h_i).table_name;
1820: BSC_APPS.Do_DDL(h_sql, AD_DDL.TRUNCATE_TABLE, g_metadata_tables(h_i).table_name);
1821: COMMIT;
1822: END LOOP;
1823:
1824: RETURN TRUE;

Line 1908: --BSC_APPS.Do_DDL(h_sql, AD_DDL.TRUNCATE_TABLE, h_table);

1904:
1905: -- Fix perf bug#4583017: do not truncate, just drop.
1906: -- Truncate table to release space --> Bug: DROP TABLE don't release the space immediately
1907: --h_sql := 'TRUNCATE TABLE '||h_table;
1908: --BSC_APPS.Do_DDL(h_sql, AD_DDL.TRUNCATE_TABLE, h_table);
1909:
1910: h_sql := 'DROP TABLE '||h_table;
1911: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, h_table);
1912: END IF;

Line 1911: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, h_table);

1907: --h_sql := 'TRUNCATE TABLE '||h_table;
1908: --BSC_APPS.Do_DDL(h_sql, AD_DDL.TRUNCATE_TABLE, h_table);
1909:
1910: h_sql := 'DROP TABLE '||h_table;
1911: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, h_table);
1912: END IF;
1913:
1914: -- Drop the Vl view
1915: IF BSC_APPS.View_Exists(h_view) THEN

Line 1954: --BSC_APPS.Do_DDL(h_sql, AD_DDL.TRUNCATE_TABLE, h_table);

1950:
1951: -- Fix perf bug#4583017: do not truncate, just drop.
1952: -- Truncate table to release space --> Bug: DROP TABLE don't release the space immediately
1953: --h_sql := 'TRUNCATE TABLE '||h_table;
1954: --BSC_APPS.Do_DDL(h_sql, AD_DDL.TRUNCATE_TABLE, h_table);
1955:
1956: h_sql := 'DROP TABLE '||h_table;
1957: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, h_table);
1958: END IF;

Line 1957: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, h_table);

1953: --h_sql := 'TRUNCATE TABLE '||h_table;
1954: --BSC_APPS.Do_DDL(h_sql, AD_DDL.TRUNCATE_TABLE, h_table);
1955:
1956: h_sql := 'DROP TABLE '||h_table;
1957: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, h_table);
1958: END IF;
1959:
1960: FETCH c_mn_dim_tables INTO h_table;
1961: END LOOP;

Line 1995: --BSC_APPS.Do_DDL(h_sql, AD_DDL.TRUNCATE_TABLE, h_table);

1991:
1992: -- Fix perf bug#4583017: do not truncate, just drop.
1993: -- Truncate table to release space --> Bug: DROP TABLE don't release the space immediately
1994: --h_sql := 'TRUNCATE TABLE '||h_table;
1995: --BSC_APPS.Do_DDL(h_sql, AD_DDL.TRUNCATE_TABLE, h_table);
1996:
1997: h_sql := 'DROP TABLE '||h_table;
1998: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, h_table);
1999: END IF;

Line 1998: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, h_table);

1994: --h_sql := 'TRUNCATE TABLE '||h_table;
1995: --BSC_APPS.Do_DDL(h_sql, AD_DDL.TRUNCATE_TABLE, h_table);
1996:
1997: h_sql := 'DROP TABLE '||h_table;
1998: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, h_table);
1999: END IF;
2000:
2001: -- BSC-MV Note: I am commenting this code. EDW is not supported and
2002: -- this code affect the performance.

Line 2035: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, h_table);

2031: h_message := BSC_APPS.Replace_Token(h_base_message, 'TABLE', h_table);
2032: BSC_APPS.Write_Line_Log(h_message, BSC_APPS.OUTPUT_FILE);
2033:
2034: h_sql := 'DROP TABLE '||h_table;
2035: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, h_table);
2036: END IF;
2037: END IF;
2038: FETCH c_rowid_tables INTO h_table;
2039: END LOOP;

Line 2052: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, h_table);

2048: h_message := BSC_APPS.Replace_Token(h_base_message, 'TABLE', h_table);
2049: BSC_APPS.Write_Line_Log(h_message, BSC_APPS.OUTPUT_FILE);
2050:
2051: h_sql := 'DROP TABLE '||h_table;
2052: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, h_table);
2053: END IF;
2054: END IF;
2055: FETCH c_proj_tables INTO h_table;
2056: END LOOP;

Line 2121: --BSC_APPS.Do_DDL(h_sql, AD_DDL.TRUNCATE_TABLE, h_table);

2117:
2118: -- Fix perf bug#4583017: do not truncate, just drop.
2119: -- Truncate table to release space --> Bug: DROP TABLE don't release the space immediately
2120: --h_sql := 'TRUNCATE TABLE '||h_table;
2121: --BSC_APPS.Do_DDL(h_sql, AD_DDL.TRUNCATE_TABLE, h_table);
2122:
2123: h_sql := 'DROP TABLE '||h_table;
2124: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, h_table);
2125: END IF;

Line 2124: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, h_table);

2120: --h_sql := 'TRUNCATE TABLE '||h_table;
2121: --BSC_APPS.Do_DDL(h_sql, AD_DDL.TRUNCATE_TABLE, h_table);
2122:
2123: h_sql := 'DROP TABLE '||h_table;
2124: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, h_table);
2125: END IF;
2126: END LOOP;
2127: CLOSE h_cursor;
2128:

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 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 4778: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_CALENDAR_ID_S');

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;
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';

Line 4783: 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;
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.

Line 4798: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_PERIODICITY_ID_S');

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;
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';

Line 4803: 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;
4805:
4806: -- 5. Migrate custom links
4807: IF BSC_APPS.APPS_ENV AND g_src_apps_flag THEN

Line 4862: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_KPI_COMMENTS_ID_S');

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;
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';

Line 4867: 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;
4869:
4870: -- 8. Add TAB_ID -1 in BSC_TAB_IND_GROUPS_B and BSC_TAB_IND_GROUPS_TL
4871: INSERT INTO BSC_TAB_IND_GROUPS_TL (TAB_ID,CSF_ID,IND_GROUP_ID,LANGUAGE,SOURCE_LANG,NAME,HELP)

Line 4927: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_INTERNAL_COLUMN_S');

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;
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';

Line 4932: 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;
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.

Line 4947: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_DIM_LEVEL_ID_S');

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;
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';

Line 4952: 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;
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.

Line 4967: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_DIM_GROUP_ID_S');

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;
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';

Line 4972: 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;
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.

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 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.

Line 5007: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_SYS_MEASURE_ID_S');

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;
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';

Line 5012: 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;
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.

Line 5027: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_DB_MEASURE_GROUPS_S');

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;
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';

Line 5032: 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;
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.

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 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.

Line 5067: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_KPI_MEASURE_S');

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;
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';

Line 5072: 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;
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.

Line 5087: BSC_APPS.Do_DDL(h_sql, AD_DDL.ALTER_SEQUENCE, 'BSC_COLOR_RANGE_ID_S');

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;
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';

Line 5092: 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;
5094:
5095: RETURN TRUE;
5096:

Line 5180: BSC_APPS.Do_DDL(l_stmt, AD_DDL.CREATE_TABLE, c_comments_bak);

5176: CMT.INDICATOR = TGT.INDICATOR';
5177: e_unexpected_error EXCEPTION;
5178: BEGIN
5179:
5180: BSC_APPS.Do_DDL(l_stmt, AD_DDL.CREATE_TABLE, c_comments_bak);
5181: EXCEPTION
5182: WHEN OTHERS THEN
5183: BSC_MESSAGE.Add (x_message => SQLERRM,
5184: x_source => 'BSC_MIGRATION.create_comment_backup_table');

Line 5234: BSC_APPS.Do_DDL('DROP TABLE '||c_comments_bak, AD_DDL.DROP_TABLE, c_comments_bak);

5230: END IF;
5231:
5232: IF (get_previous_migration_status) THEN
5233: IF table_exists(c_comments_bak, BSC_APPS.bsc_apps_schema) THEN
5234: BSC_APPS.Do_DDL('DROP TABLE '||c_comments_bak, AD_DDL.DROP_TABLE, c_comments_bak);
5235: END IF;
5236: create_comment_backup_table;
5237: ELSE
5238: IF NOT table_exists(c_comments_bak, BSC_APPS.bsc_apps_schema) THEN