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

Line 39: bsc_mo_helper_pkg.do_ddl(l_stmt, ad_ddl.create_table, g_ddl_table_name);

35: l_index VARCHAR2(1000) := 'CREATE UNIQUE INDEX '||g_ddl_table_name||'_U1 ON '||g_ddl_table_name||' (bucket_id, object_name)';
36: l_error VARCHAR2(1000);
37: BEGIN
38: IF bsc_mo_helper_pkg.tableexists(g_ddl_table_name)=false THEN
39: bsc_mo_helper_pkg.do_ddl(l_stmt, ad_ddl.create_table, g_ddl_table_name);
40: bsc_mo_helper_pkg.do_ddl(l_index, ad_ddl.create_index, g_ddl_table_name||'_U1');
41: ELSE
42: execute immediate 'truncate table '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.'||g_ddl_table_name;
43: END IF;

Line 40: bsc_mo_helper_pkg.do_ddl(l_index, ad_ddl.create_index, g_ddl_table_name||'_U1');

36: l_error VARCHAR2(1000);
37: BEGIN
38: IF bsc_mo_helper_pkg.tableexists(g_ddl_table_name)=false THEN
39: bsc_mo_helper_pkg.do_ddl(l_stmt, ad_ddl.create_table, g_ddl_table_name);
40: bsc_mo_helper_pkg.do_ddl(l_index, ad_ddl.create_index, g_ddl_table_name||'_U1');
41: ELSE
42: execute immediate 'truncate table '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.'||g_ddl_table_name;
43: END IF;
44:

Line 309: BSC_MO_HELPER_PKG.do_ddl('drop index '||p_object_name, ad_ddl.drop_index, p_object_name);

305: return;
306: END IF;
307: IF (p_object_type = 'INDEX') THEN
308: begin
309: BSC_MO_HELPER_PKG.do_ddl('drop index '||p_object_name, ad_ddl.drop_index, p_object_name);
310: exception when others then
311: null;
312: end;
313: BSC_MO_HELPER_PKG.Do_DDL (p_ddl, ad_ddl.create_index, p_object_name);

Line 313: BSC_MO_HELPER_PKG.Do_DDL (p_ddl, ad_ddl.create_index, p_object_name);

309: BSC_MO_HELPER_PKG.do_ddl('drop index '||p_object_name, ad_ddl.drop_index, p_object_name);
310: exception when others then
311: null;
312: end;
313: BSC_MO_HELPER_PKG.Do_DDL (p_ddl, ad_ddl.create_index, p_object_name);
314: ELSIF p_object_type='TABLE' THEN
315: BEGIN
316: BSC_MO_HELPER_PKG.Do_DDL (p_ddl, ad_ddl.create_table, p_object_name);
317: exception when others then

Line 316: BSC_MO_HELPER_PKG.Do_DDL (p_ddl, ad_ddl.create_table, p_object_name);

312: end;
313: BSC_MO_HELPER_PKG.Do_DDL (p_ddl, ad_ddl.create_index, p_object_name);
314: ELSIF p_object_type='TABLE' THEN
315: BEGIN
316: BSC_MO_HELPER_PKG.Do_DDL (p_ddl, ad_ddl.create_table, p_object_name);
317: exception when others then
318: if sqlcode = -955 then --already exists for some reason, so drop and recreate
319: BSC_MO_HELPER_PKG.Do_DDL ('drop table '||p_object_name, ad_ddl.drop_table, p_object_name);
320: BSC_MO_HELPER_PKG.Do_DDL (p_ddl, ad_ddl.create_table, p_object_name);

Line 319: BSC_MO_HELPER_PKG.Do_DDL ('drop table '||p_object_name, ad_ddl.drop_table, p_object_name);

315: BEGIN
316: BSC_MO_HELPER_PKG.Do_DDL (p_ddl, ad_ddl.create_table, p_object_name);
317: exception when others then
318: if sqlcode = -955 then --already exists for some reason, so drop and recreate
319: BSC_MO_HELPER_PKG.Do_DDL ('drop table '||p_object_name, ad_ddl.drop_table, p_object_name);
320: BSC_MO_HELPER_PKG.Do_DDL (p_ddl, ad_ddl.create_table, p_object_name);
321: else
322: raise;
323: end if;

Line 320: BSC_MO_HELPER_PKG.Do_DDL (p_ddl, ad_ddl.create_table, p_object_name);

316: BSC_MO_HELPER_PKG.Do_DDL (p_ddl, ad_ddl.create_table, p_object_name);
317: exception when others then
318: if sqlcode = -955 then --already exists for some reason, so drop and recreate
319: BSC_MO_HELPER_PKG.Do_DDL ('drop table '||p_object_name, ad_ddl.drop_table, p_object_name);
320: BSC_MO_HELPER_PKG.Do_DDL (p_ddl, ad_ddl.create_table, p_object_name);
321: else
322: raise;
323: end if;
324: END;

Line 714: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.alter_table, BaseTable.Name);

710: IF bsc_mo_helper_pkg.tableExists(BaseTable.Name) THEN
711: IF Not bsc_mo_helper_pkg.table_column_exists(BaseTable.Name, 'PERIODICITY_ID') THEN
712: --Add periodicity_id
713: l_stmt := 'ALTER TABLE ' || BaseTable.Name || ' ADD PERIODICITY_ID NUMBER';
714: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.alter_table, BaseTable.Name);
715:
716: --Update periodicity_id
717: l_stmt := 'UPDATE ' || BaseTable.Name||' SET PERIODICITY_ID =:1 ';
718: EXECUTE IMMEDIATE l_stmt using BaseTable.Periodicity;

Line 722: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.alter_table, BaseTable.Name);

718: EXECUTE IMMEDIATE l_stmt using BaseTable.Periodicity;
719:
720: --Set periodicity_id NOT NULL
721: l_stmt := 'ALTER TABLE ' || BaseTable.Name || ' MODIFY PERIODICITY_ID NOT NULL';
722: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.alter_table, BaseTable.Name);
723:
724: --Drop existing indexes
725: OPEN cDropIndexes(BaseTable.Name, BSC_METADATA_OPTIMIZER_PKG.gBSCSchema);
726: LOOP

Line 731: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.drop_index, IndexName);

727: FETCH cDropIndexes INTO IndexName;
728: EXIT WHEN cDropIndexes%NOTFOUND;
729: --Drop index
730: l_stmt := 'DROP INDEX ' || IndexName;
731: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.drop_index, IndexName);
732: END LOOP;
733: CLOSE cDropIndexes;
734: --Re-create index to include PERIODICITY_ID
735: IndexName := BaseTable.Name || '_U1';

Line 754: bsc_mo_helper_pkg.do_ddl('drop index '||IndexName, ad_ddl.drop_index, IndexName);

750: IndexedColumns := IndexedColumns ||l_zero_code_cols;
751: IndexedColumns := substr(IndexedColumns, 1, Length(IndexedColumns)-1);
752: begin
753: -- just for safety, in case of corrupt left over tables
754: bsc_mo_helper_pkg.do_ddl('drop index '||IndexName, ad_ddl.drop_index, IndexName);
755: -- ignore all exceptions here
756: exception when others then
757: null;
758: end;

Line 762: bsc_mo_helper_pkg.Do_DDL (l_stmt, ad_ddl.create_index, IndexName);

758: end;
759: l_stmt := 'CREATE UNIQUE INDEX '|| IndexName||
760: ' ON ' || BaseTable.Name || ' (' || IndexedColumns || ') '||
761: ' TABLESPACE '||BSC_METADATA_OPTIMIZER_PKG.gBaseIndexTbsName||' ' || BSC_METADATA_OPTIMIZER_PKG.gStorageClause;
762: bsc_mo_helper_pkg.Do_DDL (l_stmt, ad_ddl.create_index, IndexName);
763: END IF;
764: END IF;
765: -- Bug#:5214589
766: -- Alter B_PRJ Table if required

Line 773: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.alter_table, BaseTable.Name);

769: if (l_prj_table is not null) then
770: IF Not bsc_mo_helper_pkg.table_column_exists(l_prj_table, 'PERIODICITY_ID') THEN
771: --Add periodicity_id
772: l_stmt := 'ALTER TABLE ' || l_prj_table || ' ADD PERIODICITY_ID NUMBER';
773: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.alter_table, BaseTable.Name);
774: --Update periodicity_id
775: l_stmt := 'UPDATE ' || l_prj_table||' SET PERIODICITY_ID =:1 ';
776: EXECUTE IMMEDIATE l_stmt using BaseTable.Periodicity;
777: --Set periodicity_id NOT NULL

Line 779: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.alter_table, BaseTable.Name);

775: l_stmt := 'UPDATE ' || l_prj_table||' SET PERIODICITY_ID =:1 ';
776: EXECUTE IMMEDIATE l_stmt using BaseTable.Periodicity;
777: --Set periodicity_id NOT NULL
778: l_stmt := 'ALTER TABLE ' || l_prj_table || ' MODIFY PERIODICITY_ID NOT NULL';
779: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.alter_table, BaseTable.Name);
780: END IF;
781: end if;
782: EXCEPTION WHEN OTHERS THEN
783: l_error := sqlerrm;

Line 1117: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.alter_table, l_origin_tables(j));

1113: null;
1114: ELSIF Not bsc_mo_helper_pkg.table_column_exists(l_origin_tables(j), p_table.data(i).fieldName) THEN
1115: l_stmt := 'ALTER TABLE ' || l_origin_tables(j) || ' ADD '||p_table.data(i).fieldName||' NUMBER';
1116: bsc_mo_helper_pkg.writeTmp(l_stmt, FND_LOG.LEVEL_STATEMENT, false);
1117: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.alter_table, l_origin_tables(j));
1118: --IF B table is being altered,, B_PRJ table also needs to b altered
1119: END IF;
1120: IF BSC_MO_LOADER_CONFIG_PKG.isBasicTable(l_origin_tables(j)) THEN
1121: -- Alter B_PRJ Table if required

Line 1127: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.alter_table, l_prj_table);

1123: if (l_prj_table is not null) then
1124: IF Not bsc_mo_helper_pkg.table_column_exists(l_prj_table, p_table.data(i).fieldName) THEN
1125: l_stmt := 'ALTER TABLE ' || l_prj_table || ' ADD '||p_table.data(i).fieldName||' NUMBER';
1126: bsc_mo_helper_pkg.writeTmp(l_stmt, FND_LOG.LEVEL_STATEMENT, false);
1127: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.alter_table, l_prj_table);
1128: END IF;
1129: end if;
1130: l_stmt := 'ALTER MATERIALIZED VIEW LOG ON ' || BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.'||l_origin_tables(j)
1131: || ' ADD ('||p_table.data(i).fieldName||')';

Line 1611: --BSC_MO_HELPER_PKG.Do_DDL('drop table '||l_table_name, ad_ddl.drop_table, l_table_name);

1607: FETCH cv INTO l_object_name, l_object_ddl, l_object_type;
1608: EXIT WHEN cv%NOTFOUND;
1609: BEGIN
1610: null;
1611: --BSC_MO_HELPER_PKG.Do_DDL('drop table '||l_table_name, ad_ddl.drop_table, l_table_name);
1612: EXCEPTION WHEN OTHERS THEN
1613: null;
1614: END;
1615:

Line 1618: BSC_MO_HELPER_PKG.Do_DDL(l_object_ddl, ad_ddl.create_table, l_object_name);

1614: END;
1615:
1616: BEGIN
1617: IF (l_object_type='TABLE') THEN
1618: BSC_MO_HELPER_PKG.Do_DDL(l_object_ddl, ad_ddl.create_table, l_object_name);
1619: ELSE
1620: BSC_MO_HELPER_PKG.Do_DDL(l_object_ddl, ad_ddl.create_index, l_object_name);
1621: END IF;
1622: writelog(l_object_type ||' '||l_object_name||' created successfully.');

Line 1620: BSC_MO_HELPER_PKG.Do_DDL(l_object_ddl, ad_ddl.create_index, l_object_name);

1616: BEGIN
1617: IF (l_object_type='TABLE') THEN
1618: BSC_MO_HELPER_PKG.Do_DDL(l_object_ddl, ad_ddl.create_table, l_object_name);
1619: ELSE
1620: BSC_MO_HELPER_PKG.Do_DDL(l_object_ddl, ad_ddl.create_index, l_object_name);
1621: END IF;
1622: writelog(l_object_type ||' '||l_object_name||' created successfully.');
1623: EXCEPTION WHEN OTHERS THEN
1624: l_error := sqlerrm;

Line 1927: bsc_mo_helper_pkg.do_ddl('drop table '||g_ddl_table_name, ad_ddl.drop_table, g_ddl_table_name);

1923: END IF;
1924: END IF;
1925: */
1926: END IF;
1927: bsc_mo_helper_pkg.do_ddl('drop table '||g_ddl_table_name, ad_ddl.drop_table, g_ddl_table_name);
1928:
1929: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1930: bsc_mo_helper_pkg.writeTmp('Compl spawn_child_processes, system time is '||to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
1931: END IF;