DBA Data[Home] [Help]

APPS.BSC_MIGRATION dependencies on BSC_DBGEN_STD_METADATA

Line 8065: h_list(1) := BSC_DBGEN_STD_METADATA.BSC_I_ROWID_TABLE;

8061: h_list dbms_sql.varchar2_table;
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:

Line 8082: h_list(1) := BSC_DBGEN_STD_METADATA.BSC_B_PRJ_TABLE;

8078: h_list dbms_sql.varchar2_table;
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:

Line 8099: h_list(1) := BSC_DBGEN_STD_METADATA.BSC_PARTITION;

8095: h_list dbms_sql.varchar2_table;
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:

Line 8154: h_batch_column := UPPER(BSC_DBGEN_STD_METADATA.BSC_BATCH_COLUMN_NAME);

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
8157: h_num_key_columns := 0;
8158: IF NOT BSC_UPDATE_UTIL.Get_Information_Key_Columns(x_base_table,

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