965: );
966:
967: end if;
968:
969: l_debug_stmt := 'Insert Into BSC_DB_TABLES_RELS, Dim_level_id=' ||
970: to_char(G_Pro_Tbl(i_dimension).Dim_level_id);
971: Insert Into BSC_DB_TABLES_RELS (
972: TABLE_NAME,
973: SOURCE_TABLE_NAME)
967: end if;
968:
969: l_debug_stmt := 'Insert Into BSC_DB_TABLES_RELS, Dim_level_id=' ||
970: to_char(G_Pro_Tbl(i_dimension).Dim_level_id);
971: Insert Into BSC_DB_TABLES_RELS (
972: TABLE_NAME,
973: SOURCE_TABLE_NAME)
974: Values (
975: G_Pro_Tbl(i_dimension).Table_name,
975: G_Pro_Tbl(i_dimension).Table_name,
976: 'BSC_DI_' || G_Pro_Tbl(i_dimension).Dim_level_id
977: );
978:
979: l_debug_stmt := 'Insert Into BSC_DB_TABLES, Dim_level_id=' ||
980: to_char(G_Pro_Tbl(i_dimension).Dim_level_id);
981: Insert Into BSC_DB_TABLES (
982: TABLE_NAME,
983: TABLE_TYPE,
977: );
978:
979: l_debug_stmt := 'Insert Into BSC_DB_TABLES, Dim_level_id=' ||
980: to_char(G_Pro_Tbl(i_dimension).Dim_level_id);
981: Insert Into BSC_DB_TABLES (
982: TABLE_NAME,
983: TABLE_TYPE,
984: PERIODICITY_ID,
985: SOURCE_DATA_TYPE,