DBA Data[Home] [Help]

APPS.BSC_BIS_DIM_REL_PUB dependencies on BSC_DB_TABLES

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 3456: --DBMS_OUTPUT.PUT_LINE('INSERT INTO BSC_DB_TABLES');

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');
3457: SELECT COUNT(*) INTO l_count
3458: FROM BSC_DB_TABLES
3459: WHERE Table_Name = l_input_table;
3460: --DBMS_OUTPUT.PUT_LINE('INSERT INTO BSC_DB_TABLES '||l_count);

Line 3458: FROM BSC_DB_TABLES

3454: WHERE Source_Table_Name = l_input_table;
3455: END IF;
3456: --DBMS_OUTPUT.PUT_LINE('INSERT INTO BSC_DB_TABLES');
3457: SELECT COUNT(*) INTO l_count
3458: FROM BSC_DB_TABLES
3459: WHERE Table_Name = l_input_table;
3460: --DBMS_OUTPUT.PUT_LINE('INSERT INTO BSC_DB_TABLES '||l_count);
3461: IF (l_count = 0) THEN
3462: INSERT INTO BSC_DB_TABLES

Line 3460: --DBMS_OUTPUT.PUT_LINE('INSERT INTO BSC_DB_TABLES '||l_count);

3456: --DBMS_OUTPUT.PUT_LINE('INSERT INTO BSC_DB_TABLES');
3457: SELECT COUNT(*) INTO l_count
3458: FROM BSC_DB_TABLES
3459: WHERE Table_Name = l_input_table;
3460: --DBMS_OUTPUT.PUT_LINE('INSERT INTO BSC_DB_TABLES '||l_count);
3461: IF (l_count = 0) THEN
3462: INSERT INTO BSC_DB_TABLES
3463: (Table_Name, Table_Type, Periodicity_Id,
3464: Source_Data_Type, Source_File_Name)

Line 3462: INSERT INTO BSC_DB_TABLES

3458: FROM BSC_DB_TABLES
3459: WHERE Table_Name = l_input_table;
3460: --DBMS_OUTPUT.PUT_LINE('INSERT INTO BSC_DB_TABLES '||l_count);
3461: IF (l_count = 0) THEN
3462: INSERT INTO BSC_DB_TABLES
3463: (Table_Name, Table_Type, Periodicity_Id,
3464: Source_Data_Type, Source_File_Name)
3465: VALUES (l_input_table, 2, 0, 0, NULL);
3466: END IF;

Line 3587: --DBMS_OUTPUT.PUT_LINE('DELETE TABLES BSC_DB_TABLES '||l_input_table);

3583: l_sql_stmt := 'DROP TABLE '||l_input_table;
3584: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||l_sql_stmt||'>');
3585: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.drop_table, l_input_table);
3586: END IF;
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

Line 3588: DELETE FROM BSC_DB_TABLES

3584: --DBMS_OUTPUT.PUT_LINE('l_sql_stmt <'||l_sql_stmt||'>');
3585: BSC_APPS.DO_DDL(l_sql_stmt, ad_ddl.drop_table, l_input_table);
3586: END IF;
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;

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');