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_TAB_TPLATE dependencies on AD_DDL

Line 1827: BEGIN BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.DROP_SEQUENCE, 'BSC_SYS_DIM_LEVEL_ID_S'); EXCEPTION WHEN OTHERS THEN NULL; END;

1823: DBMS_SQL.CLOSE_CURSOR(h_cursor);
1824: h_max_id := h_max_id + 1;
1825:
1826: l_sql_stmt := 'DROP SEQUENCE BSC_SYS_DIM_LEVEL_ID_S';
1827: BEGIN BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.DROP_SEQUENCE, 'BSC_SYS_DIM_LEVEL_ID_S'); EXCEPTION WHEN OTHERS THEN NULL; END;
1828: l_sql_stmt := 'CREATE SEQUENCE BSC_SYS_DIM_LEVEL_ID_S START WITH '||h_max_id;
1829: BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.CREATE_SEQUENCE, 'BSC_SYS_DIM_LEVEL_ID_S');
1830:
1831: -- Reset sequence BSC_SYS_DIM_GROUP_ID_S

Line 1829: BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.CREATE_SEQUENCE, 'BSC_SYS_DIM_LEVEL_ID_S');

1825:
1826: l_sql_stmt := 'DROP SEQUENCE BSC_SYS_DIM_LEVEL_ID_S';
1827: BEGIN BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.DROP_SEQUENCE, 'BSC_SYS_DIM_LEVEL_ID_S'); EXCEPTION WHEN OTHERS THEN NULL; END;
1828: l_sql_stmt := 'CREATE SEQUENCE BSC_SYS_DIM_LEVEL_ID_S START WITH '||h_max_id;
1829: BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.CREATE_SEQUENCE, 'BSC_SYS_DIM_LEVEL_ID_S');
1830:
1831: -- Reset sequence BSC_SYS_DIM_GROUP_ID_S
1832: l_sql_stmt := 'SELECT NVL(MAX(DIM_GROUP_ID),0) FROM BSC_SYS_DIM_GROUPS_TL';
1833: h_cursor := DBMS_SQL.OPEN_CURSOR;

Line 1847: BEGIN BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.DROP_SEQUENCE, 'BSC_SYS_DIM_GROUP_ID_S'); EXCEPTION WHEN OTHERS THEN NULL; END;

1843: DBMS_SQL.CLOSE_CURSOR(h_cursor);
1844: h_max_id := h_max_id + 1;
1845:
1846: l_sql_stmt := 'DROP SEQUENCE BSC_SYS_DIM_GROUP_ID_S';
1847: BEGIN BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.DROP_SEQUENCE, 'BSC_SYS_DIM_GROUP_ID_S'); EXCEPTION WHEN OTHERS THEN NULL; END;
1848: l_sql_stmt := 'CREATE SEQUENCE BSC_SYS_DIM_GROUP_ID_S START WITH '||h_max_id;
1849: BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.CREATE_SEQUENCE, 'BSC_SYS_DIM_GROUP_ID_S');
1850:
1851:

Line 1849: BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.CREATE_SEQUENCE, 'BSC_SYS_DIM_GROUP_ID_S');

1845:
1846: l_sql_stmt := 'DROP SEQUENCE BSC_SYS_DIM_GROUP_ID_S';
1847: BEGIN BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.DROP_SEQUENCE, 'BSC_SYS_DIM_GROUP_ID_S'); EXCEPTION WHEN OTHERS THEN NULL; END;
1848: l_sql_stmt := 'CREATE SEQUENCE BSC_SYS_DIM_GROUP_ID_S START WITH '||h_max_id;
1849: BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.CREATE_SEQUENCE, 'BSC_SYS_DIM_GROUP_ID_S');
1850:
1851:
1852: -- Reset sequence BSC_SYS_DATASET_ID_S
1853: l_sql_stmt := 'SELECT NVL(MAX(DATASET_ID),0) FROM BSC_SYS_DATASETS_B';

Line 1868: BEGIN BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.DROP_SEQUENCE, 'BSC_SYS_DATASET_ID_S'); EXCEPTION WHEN OTHERS THEN NULL; END;

1864: DBMS_SQL.CLOSE_CURSOR(h_cursor);
1865: h_max_id := h_max_id + 1;
1866:
1867: l_sql_stmt := 'DROP SEQUENCE BSC_SYS_DATASET_ID_S';
1868: BEGIN BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.DROP_SEQUENCE, 'BSC_SYS_DATASET_ID_S'); EXCEPTION WHEN OTHERS THEN NULL; END;
1869: l_sql_stmt := 'CREATE SEQUENCE BSC_SYS_DATASET_ID_S START WITH '||h_max_id;
1870: BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.CREATE_SEQUENCE, 'BSC_SYS_DATASET_ID_S');
1871:
1872: -- Reset sequence BSC_SYS_MEASURE_ID_S

Line 1870: BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.CREATE_SEQUENCE, 'BSC_SYS_DATASET_ID_S');

1866:
1867: l_sql_stmt := 'DROP SEQUENCE BSC_SYS_DATASET_ID_S';
1868: BEGIN BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.DROP_SEQUENCE, 'BSC_SYS_DATASET_ID_S'); EXCEPTION WHEN OTHERS THEN NULL; END;
1869: l_sql_stmt := 'CREATE SEQUENCE BSC_SYS_DATASET_ID_S START WITH '||h_max_id;
1870: BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.CREATE_SEQUENCE, 'BSC_SYS_DATASET_ID_S');
1871:
1872: -- Reset sequence BSC_SYS_MEASURE_ID_S
1873: l_sql_stmt := 'SELECT NVL(MAX(MEASURE_ID),0) FROM BSC_SYS_MEASURES';
1874: h_cursor := DBMS_SQL.OPEN_CURSOR;

Line 1888: BEGIN BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.DROP_SEQUENCE, 'BSC_SYS_MEASURE_ID_S'); EXCEPTION WHEN OTHERS THEN NULL; END;

1884: DBMS_SQL.CLOSE_CURSOR(h_cursor);
1885: h_max_id := h_max_id + 1;
1886:
1887: l_sql_stmt := 'DROP SEQUENCE BSC_SYS_MEASURE_ID_S';
1888: BEGIN BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.DROP_SEQUENCE, 'BSC_SYS_MEASURE_ID_S'); EXCEPTION WHEN OTHERS THEN NULL; END;
1889: l_sql_stmt := 'CREATE SEQUENCE BSC_SYS_MEASURE_ID_S START WITH '||h_max_id;
1890: BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.CREATE_SEQUENCE, 'BSC_SYS_MEASURE_ID_S');
1891:
1892:

Line 1890: BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.CREATE_SEQUENCE, 'BSC_SYS_MEASURE_ID_S');

1886:
1887: l_sql_stmt := 'DROP SEQUENCE BSC_SYS_MEASURE_ID_S';
1888: BEGIN BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.DROP_SEQUENCE, 'BSC_SYS_MEASURE_ID_S'); EXCEPTION WHEN OTHERS THEN NULL; END;
1889: l_sql_stmt := 'CREATE SEQUENCE BSC_SYS_MEASURE_ID_S START WITH '||h_max_id;
1890: BSC_APPS.Do_DDL(l_sql_stmt, AD_DDL.CREATE_SEQUENCE, 'BSC_SYS_MEASURE_ID_S');
1891:
1892:
1893: /* --END 2828685 SYNCH SEQUENCES */
1894: