APPS.BSC_MIGRATION dependencies on BSC_DBGEN_METADATA_READER

Line 919: h_sql := h_sql||' '||bsc_dbgen_metadata_reader.get_partition_clause;

915: h_sql := 'CREATE TABLE '||x_table||' ('||
916: h_lst_columns||
917: ')';
918: IF x_with_partitions THEN
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);

Line 1162: h_max_partitions := bsc_dbgen_metadata_reader.get_max_partitions;

1158: END IF;
1159: END LOOP;
1160: CLOSE h_cursor;
1161: --rkumar:bug#5943112
1162: h_max_partitions := bsc_dbgen_metadata_reader.get_max_partitions;
1163:
1164: -- Data tables
1165: h_base_message := BSC_APPS.Get_Message('BSC_CREATING_TABLE');
1166:

Line 8066: h_values := BSC_DBGEN_METADATA_READER.Get_Table_Properties(x_table_name, h_list);

8062: h_values dbms_sql.varchar2_table;
8063: BEGIN
8064: h_list.delete;
8065: h_list(1) := BSC_DBGEN_STD_METADATA.BSC_I_ROWID_TABLE;
8066: h_values := BSC_DBGEN_METADATA_READER.Get_Table_Properties(x_table_name, h_list);
8067: RETURN h_values(1);
8068: END Get_RowId_Table_Name;
8069:
8070:

Line 8083: h_values := BSC_DBGEN_METADATA_READER.Get_Table_Properties(x_table_name, h_list);

8079: h_values dbms_sql.varchar2_table;
8080: BEGIN
8081: h_list.delete;
8082: h_list(1) := BSC_DBGEN_STD_METADATA.BSC_B_PRJ_TABLE;
8083: h_values := BSC_DBGEN_METADATA_READER.Get_Table_Properties(x_table_name, h_list);
8084: RETURN h_values(1);
8085: END Get_Proj_Table_Name;
8086:
8087:

Line 8100: h_values := BSC_DBGEN_METADATA_READER.Get_Table_Properties(x_table_name, h_list);

8096: h_values dbms_sql.varchar2_table;
8097: BEGIN
8098: h_list.delete;
8099: h_list(1) := BSC_DBGEN_STD_METADATA.BSC_PARTITION;
8100: h_values := BSC_DBGEN_METADATA_READER.Get_Table_Properties(x_table_name, h_list);
8101: RETURN TO_NUMBER(h_values(1));
8102: END Get_Num_Partitions;
8103:
8104:

Line 8152: h_max_partitions := bsc_dbgen_metadata_reader.get_max_partitions;

8148: BEGIN
8149:
8150: h_base_message := BSC_APPS.Get_Message('BSC_MIG_DATA');
8151:
8152: h_max_partitions := bsc_dbgen_metadata_reader.get_max_partitions;
8153: h_num_partitions := Get_Num_Partitions(x_base_table);
8154: h_batch_column := UPPER(BSC_DBGEN_STD_METADATA.BSC_BATCH_COLUMN_NAME);
8155:
8156: IF h_num_partitions <> h_max_partitions THEN

Line 8264: bsc_dbgen_metadata_reader.set_table_property(x_base_table, BSC_DBGEN_STD_METADATA.BSC_PARTITION, h_max_partitions);

8260: END LOOP;
8261:
8262: -- Update the property PARTITIONS in BSC_DB_TABLES for this base table
8263: IF h_num_key_columns > 0 THEN
8264: bsc_dbgen_metadata_reader.set_table_property(x_base_table, BSC_DBGEN_STD_METADATA.BSC_PARTITION, h_max_partitions);
8265: commit;
8266: END IF;
8267: ELSE
8268: -- No difference in the number of partitions. So we can just insert from select, no need to fix batch column