APPS.BSC_BIS_DIM_OBJ_PUB dependencies on BSC_DB_TABLES_RELS

Line 4437: --insert into BSC_DB_TABLES_RELS & BSC_DB_TABLES

4433: ' AND T.LANGUAGE = L.LANGUAGE_CODE) ';
4434:
4435: EXECUTE IMMEDIATE l_sql_stmt USING i_project;
4436: END LOOP;
4437: --insert into BSC_DB_TABLES_RELS & BSC_DB_TABLES
4438:
4439: INSERT INTO BSC_DB_TABLES_RELS
4440: (Table_Name, Source_Table_Name, Relation_Type)
4441: VALUES (l_master_table, l_input_table, 0);

Line 4439: INSERT INTO BSC_DB_TABLES_RELS

4435: EXECUTE IMMEDIATE l_sql_stmt USING i_project;
4436: END LOOP;
4437: --insert into BSC_DB_TABLES_RELS & BSC_DB_TABLES
4438:
4439: INSERT INTO BSC_DB_TABLES_RELS
4440: (Table_Name, Source_Table_Name, Relation_Type)
4441: VALUES (l_master_table, l_input_table, 0);
4442:
4443: INSERT INTO BSC_DB_TABLES

Line 4747: --update BSC_DB_TABLES_RELS

4743: END LOOP;
4744: l_sql_stmt := 'DROP TABLE '||p_Dim_Level_Rec_Old.Bsc_Level_Name;
4745:
4746: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, p_Dim_Level_Rec_Old.Bsc_Level_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4747: --update BSC_DB_TABLES_RELS
4748: UPDATE BSC_DB_TABLES_RELS
4749: SET Table_Name = l_master_table
4750: WHERE Source_Table_Name = l_input_table;
4751: END IF;

Line 4748: UPDATE BSC_DB_TABLES_RELS

4744: l_sql_stmt := 'DROP TABLE '||p_Dim_Level_Rec_Old.Bsc_Level_Name;
4745:
4746: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, p_Dim_Level_Rec_Old.Bsc_Level_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4747: --update BSC_DB_TABLES_RELS
4748: UPDATE BSC_DB_TABLES_RELS
4749: SET Table_Name = l_master_table
4750: WHERE Source_Table_Name = l_input_table;
4751: END IF;
4752: IF (l_Create_View) THEN

Line 4954: --update BSC_DB_TABLES_RELS

4950: l_sql_stmt := 'DROP TABLE '||l_old_mas_name;
4951: -- -----
4952: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_old_mas_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4953:
4954: --update BSC_DB_TABLES_RELS
4955: UPDATE BSC_DB_TABLES_RELS
4956: SET Table_Name = l_master_table
4957: WHERE Source_Table_Name = l_input_table;
4958: END IF;

Line 4955: UPDATE BSC_DB_TABLES_RELS

4951: -- -----
4952: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_old_mas_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4953:
4954: --update BSC_DB_TABLES_RELS
4955: UPDATE BSC_DB_TABLES_RELS
4956: SET Table_Name = l_master_table
4957: WHERE Source_Table_Name = l_input_table;
4958: END IF;
4959: --if level_pk_col is different than change the names of table columns