APPS.BSC_PMD_OPT_DOC_UTIL dependencies on BSC_DB_TABLES_DISPLAY

Line 8: G_MASTER_DISPLAY_TABLE VARCHAR2(100):= 'BSC_DB_TABLES_DISPLAY';

4: G_BSC_SCHEMA VARCHAR2(100) := BSC_APPS.get_user_schema('BSC');
5: G_APPS_SCHEMA VARCHAR2(100) := BSC_APPS.get_user_schema('APPS');
6:
7: G_REL_DISPLAY_TABLE VARCHAR2(100):= 'BSC_DB_TABLES_RELS_DISPLAY';
8: G_MASTER_DISPLAY_TABLE VARCHAR2(100):= 'BSC_DB_TABLES_DISPLAY';
9: G_T_COLLAPSE_TEMP VARCHAR2(100):= G_BSC_SCHEMA||'.BSC_T_COLLAPSE_TEMP';
10:
11: TYPE table_mv_pair IS record(table_name varchar2(30), mv_name varchar2(30), mv_type varchar2(10));
12: TYPE table_mv_pair_tab IS TABLE OF table_mv_pair INDEX BY PLS_INTEGER;

Line 32: UPDATE bsc_db_tables_display

28:
29: Procedure POPULATE_DISPLAY_TYPE
30: IS
31: BEGIN
32: UPDATE bsc_db_tables_display
33: set DISPLAY_TYPE = 'TABLE'
34: where PHYSICAL_TYPE = 'TABLE';
35:
36: UPDATE bsc_db_tables_display

Line 36: UPDATE bsc_db_tables_display

32: UPDATE bsc_db_tables_display
33: set DISPLAY_TYPE = 'TABLE'
34: where PHYSICAL_TYPE = 'TABLE';
35:
36: UPDATE bsc_db_tables_display
37: set DISPLAY_TYPE = 'ANALYTICAL_WORKSPACES'
38: where PHYSICAL_TYPE = 'VIEW'
39: and TABLE_NAME_DISPLAY LIKE 'BSC\_S%' ESCAPE '\'
40: and exists (SELECT 1

Line 50: UPDATE bsc_db_tables_display

46: INSTR(TABLE_NAME_DISPLAY,'_',1,3)-INSTR(TABLE_NAME_DISPLAY,'_',1,2)-1))
47: and PROPERTY_CODE = 'IMPLEMENTATION_TYPE'
48: and PROPERTY_VALUE = 2);
49:
50: UPDATE bsc_db_tables_display
51: set DISPLAY_TYPE = 'VIEW'
52: where PHYSICAL_TYPE = 'VIEW'
53: and (TABLE_NAME_DISPLAY NOT LIKE 'BSC\_S%' ESCAPE '\'
54: or not exists (SELECT 1

Line 64: UPDATE bsc_db_tables_display

60: INSTR(TABLE_NAME_DISPLAY,'_',1,3)-INSTR(TABLE_NAME_DISPLAY,'_',1,2)-1))
61: and PROPERTY_CODE = 'IMPLEMENTATION_TYPE'
62: and PROPERTY_VALUE = 2));
63:
64: UPDATE bsc_db_tables_display
65: set DISPLAY_TYPE = 'MATERIALIZED_VIEW'
66: where PHYSICAL_TYPE = 'MATERIALIZED VIEW';
67: commit;
68: END;

Line 495: UPDATE BSC_DB_TABLES_DISPLAY

491: P_OLD IN VARCHAR2,
492: P_NEW IN VARCHAR2
493: ) IS
494: BEGIN
495: UPDATE BSC_DB_TABLES_DISPLAY
496: SET TABLE_NAME_DISPLAY = P_NEW
497: WHERE TABLE_NAME_DISPLAY = P_OLD;
498: --AND P_NEW like 'BSC_S_%'
499: --AND P_OLD like 'BSC_S_%';