APPS.BSC_BIS_DIM_REL_PUB dependencies on BSC_DB_TABLES_RELS

Line 3439: --insert into BSC_DB_TABLES_RELS & BSC_DB_TABLES

3435: --DBMS_OUTPUT.PUT_LINE(SUBSTR(l_sql_stmt, 601, 200));
3436: --DBMS_OUTPUT.PUT_LINE(SUBSTR(l_sql_stmt, 801, 200));
3437: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_table, l_input_table);
3438: END IF;
3439: --insert into BSC_DB_TABLES_RELS & BSC_DB_TABLES
3440: --DBMS_OUTPUT.PUT_LINE('INSERT INTO BSC_DB_TABLES_RELS');
3441: SELECT COUNT(*) INTO l_count
3442: FROM BSC_DB_TABLES_RELS
3443: WHERE Source_Table_Name = l_input_table;

Line 3440: --DBMS_OUTPUT.PUT_LINE('INSERT INTO BSC_DB_TABLES_RELS');

3436: --DBMS_OUTPUT.PUT_LINE(SUBSTR(l_sql_stmt, 801, 200));
3437: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.create_table, l_input_table);
3438: END IF;
3439: --insert into BSC_DB_TABLES_RELS & BSC_DB_TABLES
3440: --DBMS_OUTPUT.PUT_LINE('INSERT INTO BSC_DB_TABLES_RELS');
3441: SELECT COUNT(*) INTO l_count
3442: FROM BSC_DB_TABLES_RELS
3443: WHERE Source_Table_Name = l_input_table;
3444: --DBMS_OUTPUT.PUT_LINE('INSERT INTO BSC_DB_TABLES_RELS '||l_count);

Line 3442: FROM BSC_DB_TABLES_RELS

3438: END IF;
3439: --insert into BSC_DB_TABLES_RELS & BSC_DB_TABLES
3440: --DBMS_OUTPUT.PUT_LINE('INSERT INTO BSC_DB_TABLES_RELS');
3441: SELECT COUNT(*) INTO l_count
3442: FROM BSC_DB_TABLES_RELS
3443: WHERE Source_Table_Name = l_input_table;
3444: --DBMS_OUTPUT.PUT_LINE('INSERT INTO BSC_DB_TABLES_RELS '||l_count);
3445: --DBMS_OUTPUT.PUT_LINE('l_master_table '||l_master_table);
3446: --DBMS_OUTPUT.PUT_LINE('l_input_table '||l_input_table);

Line 3444: --DBMS_OUTPUT.PUT_LINE('INSERT INTO BSC_DB_TABLES_RELS '||l_count);

3440: --DBMS_OUTPUT.PUT_LINE('INSERT INTO BSC_DB_TABLES_RELS');
3441: SELECT COUNT(*) INTO l_count
3442: FROM BSC_DB_TABLES_RELS
3443: WHERE Source_Table_Name = l_input_table;
3444: --DBMS_OUTPUT.PUT_LINE('INSERT INTO BSC_DB_TABLES_RELS '||l_count);
3445: --DBMS_OUTPUT.PUT_LINE('l_master_table '||l_master_table);
3446: --DBMS_OUTPUT.PUT_LINE('l_input_table '||l_input_table);
3447: IF (l_count = 0) THEN
3448: INSERT INTO BSC_DB_TABLES_RELS

Line 3448: INSERT INTO BSC_DB_TABLES_RELS

3444: --DBMS_OUTPUT.PUT_LINE('INSERT INTO BSC_DB_TABLES_RELS '||l_count);
3445: --DBMS_OUTPUT.PUT_LINE('l_master_table '||l_master_table);
3446: --DBMS_OUTPUT.PUT_LINE('l_input_table '||l_input_table);
3447: IF (l_count = 0) THEN
3448: INSERT INTO BSC_DB_TABLES_RELS
3449: (Table_Name, Source_Table_Name, Relation_Type)
3450: VALUES (l_master_table, l_input_table, 0);
3451: ELSE
3452: UPDATE BSC_DB_TABLES_RELS

Line 3452: UPDATE BSC_DB_TABLES_RELS

3448: INSERT INTO BSC_DB_TABLES_RELS
3449: (Table_Name, Source_Table_Name, Relation_Type)
3450: VALUES (l_master_table, l_input_table, 0);
3451: ELSE
3452: UPDATE BSC_DB_TABLES_RELS
3453: SET Table_Name = l_master_table
3454: WHERE Source_Table_Name = l_input_table;
3455: END IF;
3456: --DBMS_OUTPUT.PUT_LINE('INSERT INTO BSC_DB_TABLES');

Line 3591: DELETE FROM BSC_DB_TABLES_RELS

3587: --DBMS_OUTPUT.PUT_LINE('DELETE TABLES BSC_DB_TABLES '||l_input_table);
3588: DELETE FROM BSC_DB_TABLES
3589: WHERE Table_Name = l_input_table;
3590:
3591: DELETE FROM BSC_DB_TABLES_RELS
3592: WHERE Source_Table_Name = l_input_table;
3593:
3594: x_return_status := FND_API.G_RET_STS_SUCCESS;
3595: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIMENSION_PUB.Drop_M_To_N_Unused_Tabs Procedure');