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 BSC_DBGEN_STD_METADATA

Line 377: l_stmt := 'CREATE TABLE ' || l_table_name||' (ROW_ID ROWID, '||BSC_DBGEN_STD_METADATA.BSC_BATCH_COLUMN_NAME||' NUMBER) '||p_storage_clause;

373:
374: BEGIN
375:
376: l_table_name := get_table_name(p_table.name||'_ROWID');
377: l_stmt := 'CREATE TABLE ' || l_table_name||' (ROW_ID ROWID, '||BSC_DBGEN_STD_METADATA.BSC_BATCH_COLUMN_NAME||' NUMBER) '||p_storage_clause;
378: handle_ddl(l_table_name, 'TABLE', l_stmt);
379: return l_table_name;
380: EXCEPTION WHEN OTHERS THEN
381: BSC_MO_HELPER_PKG.TerminateWithMsg('Exception in create_i_rowid_table, Table='||p_table.name||', stmt='||l_stmt||', error:'||sqlerrm);

Line 389: l_update_rec.property := p_property||BSC_DBGEN_STD_METADATA.BSC_ASSIGNMENT||p_value;

385: PROCEDURE add_to_update_tables_list(p_Table_name VARCHAR2, p_property VARCHAR2, p_value VARCHAR2) IS
386: l_update_rec rec_update_tables;
387: BEGIN
388: l_update_rec.table_name := p_table_name;
389: l_update_rec.property := p_property||BSC_DBGEN_STD_METADATA.BSC_ASSIGNMENT||p_value;
390: g_update_tables(g_update_tables.count+1) := l_update_rec;
391: EXCEPTION WHEN OTHERS THEN
392: BSC_MO_HELPER_PKG.TerminateWithMsg('Exception in add_to_update_tables_list, Table='||p_table_name|| ', property='||
393: p_property||', value='||p_value||', error:'||sqlerrm);

Line 457: add_to_update_tables_list(p_table_name, BSC_DBGEN_STD_METADATA.BSC_PARTITION,

453: IF (p_table_type = 'B') THEN
454: -- Bug 4765104, partition only when dim keys exist
455: if (b_keys_exist) then
456: l_table_misc_clause := bsc_metadata_optimizer_pkg.g_partition_clause;
457: add_to_update_tables_list(p_table_name, BSC_DBGEN_STD_METADATA.BSC_PARTITION,
458: bsc_metadata_optimizer_pkg.g_num_partitions);
459: end if;
460: l_table_misc_clause := l_table_misc_clause||' TABLESPACE '||TableTbsName ||
461: ' '||BSC_METADATA_OPTIMIZER_PKG.gStorageClause;

Line 463: add_to_update_tables_list(p_table_name, BSC_DBGEN_STD_METADATA.BSC_B_PRJ_TABLE, l_table_name);

459: end if;
460: l_table_misc_clause := l_table_misc_clause||' TABLESPACE '||TableTbsName ||
461: ' '||BSC_METADATA_OPTIMIZER_PKG.gStorageClause;
462: l_table_name := create_b_prj_table(p_table, columnList, l_table_misc_clause);
463: add_to_update_tables_list(p_table_name, BSC_DBGEN_STD_METADATA.BSC_B_PRJ_TABLE, l_table_name);
464: --bug fix 5647971 centralized logic to get index name
465: -- added api in helper package
466: l_index_name := BSC_MO_HELPER_PKG.generate_index_name(p_table_name,'B','1');
467: l_index_stmt := 'CREATE BITMAP INDEX '||l_index_name||' ON '||p_table_name||'(YEAR) TABLESPACE '||IndexTbsName||

Line 496: add_to_update_tables_list(p_table_name, BSC_DBGEN_STD_METADATA.BSC_I_ROWID_TABLE, l_table_name);

492: -- 11/16/2005, always generate rowid tables, after discussion with venu/mauricio.
493: --AND bsc_metadata_optimizer_pkg.g_num_partitions>1
494: l_table_name := create_i_rowid_table(p_table, ' TABLESPACE '||TableTbsName ||
495: ' '||BSC_METADATA_OPTIMIZER_PKG.gStorageClause);
496: add_to_update_tables_list(p_table_name, BSC_DBGEN_STD_METADATA.BSC_I_ROWID_TABLE, l_table_name);
497: END IF;
498:
499: IF l_primary_key IS NOT NULL THEN -- create normal index
500: if (p_table_name like 'BSC_S%_PT' ) then

Line 768: BSC_DBGEN_STD_METADATA.BSC_B_PRJ_TABLE);

764: END IF;
765: -- Bug#:5214589
766: -- Alter B_PRJ Table if required
767: l_prj_table := BSC_DBGEN_METADATA_READER.get_table_properties(BaseTable.Name,
768: BSC_DBGEN_STD_METADATA.BSC_B_PRJ_TABLE);
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';

Line 1122: l_prj_table := BSC_DBGEN_METADATA_READER.get_table_properties(l_origin_tables(j), BSC_DBGEN_STD_METADATA.BSC_B_PRJ_TABLE);

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
1122: l_prj_table := BSC_DBGEN_METADATA_READER.get_table_properties(l_origin_tables(j), BSC_DBGEN_STD_METADATA.BSC_B_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);

Line 1164: dbColumn.columnName := BSC_DBGEN_STD_METADATA.BSC_BATCH_COLUMN_NAME;

1160:
1161: BEGIN
1162: -- batch column
1163: dbColumn := dbColumn_null;
1164: dbColumn.columnName := BSC_DBGEN_STD_METADATA.BSC_BATCH_COLUMN_NAME;
1165: dbColumn.columnType := BSC_METADATA_OPTIMIZER_PKG.DTNumber;
1166: dbColumn.columnLength := 0;
1167: dbColumn.iskey := false;
1168: p_cols(p_cols.count) := dbColumn;

Line 1466: SET PROPERTIES=PROPERTIES||l_varchar_table2(i)||BSC_DBGEN_STD_METADATA.BSC_PROPERTY_SEPARATOR

1462: END LOOP;
1463: -- Update Table Properties
1464: FORALL i IN 1..g_update_tables.count
1465: UPDATE BSC_DB_TABLES
1466: SET PROPERTIES=PROPERTIES||l_varchar_table2(i)||BSC_DBGEN_STD_METADATA.BSC_PROPERTY_SEPARATOR
1467: WHERE table_name = l_varchar_table1(i);
1468:
1469: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1470: BSC_MO_HELPER_PKG.writeTmp('Completed CreateAllTables');