PACKAGE: APPS.BSC_CORRUPT_OBJECTS_RPT

Source

1 PACKAGE BSC_CORRUPT_OBJECTS_RPT AS
2 /* $Header: BSCCOBJS.pls 120.1.12000000.1 2007/08/09 09:54:35 appldev noship $ */
3 g_dang_measure_sql1 CONSTANT VARCHAR2(400) := ' SELECT indicator_id, short_name, actual_data_source_type, actual_data_source, dataset_id,'||
4                                              ' creation_date, last_update_date,  created_by, last_updated_by FROM BIS_INDICATORS BI '||
5                                              ' WHERE BI.DATASET_ID IS NULL OR NOT EXISTS (SELECT 1 FROM BSC_SYS_DATASETS_B BSD WHERE '||
6                                              ' BSD.DATASET_ID = BI.DATASET_ID)';
7 
8 g_dang_measure_sql2 CONSTANT VARCHAR2(200) := 'SELECT * FROM BSC_SYS_DATASETS_B BSD WHERE NOT EXISTS (SELECT 1 FROM BIS_INDICATORS BI '||
9                                            ' WHERE BSD.DATASET_ID = BI.DATASET_ID)';
10 
11 g_dang_measure_sql3 CONSTANT VARCHAR2(400) := 'SELECT measure_id, mc.measure_col "DB_MEASURE_COL", me2.measure_col "MEAS_MEASURE_COL" '||
12                                              ' FROM bsc_db_measure_cols_vl mc, bsc_sys_measures me2 WHERE NOT EXISTS (SELECT 1 FROM '||
13                                              ' bsc_sys_measures me WHERE me.measure_col = mc.measure_col) AND '||
14                                              ' me2.measure_col LIKE ''%''||mc.measure_col ||''%'' ' ;
15 
16 g_dang_per_sql CONSTANT VARCHAR2(400) := 'SELECT periodicity_id, source, num_of_periods, calendar_id, periodicity_type, period_type_id, '||
17                                        'xtd_pattern,short_name FROM bsc_sys_periodicities_vl pe WHERE short_name IS NULL OR NOT EXISTS '||
18                                        '(SELECT 1 FROM bsc_sys_dim_levels_b dl WHERE dl.short_name = pe.short_name)';
19 g_dang_cal_sql CONSTANT VARCHAR2(400) := 'SELECT calendar_id,edw_flag, fiscal_year, current_year, creation_date, last_update_date, created_by,'||
20                                          ' last_updated_by FROM bsc_sys_calendars_vl pe WHERE short_name IS NULL OR NOT EXISTS (SELECT 1 '||
21                                          ' FROM bsc_sys_dim_groups_vl dim WHERE dim.short_name = pe.short_name)';
22 g_dang_rpt_sql CONSTANT VARCHAR2(200) := 'SELECT * FROM bsc_kpis_b WHERE short_name IS NOT NULL AND NOT EXISTS (SELECT 1 '||
23                                          ' FROM ak_regions WHERE short_name = region_code)';
24 g_dang_tab_sql CONSTANT VARCHAR2(400) := 'SELECT tab_id, short_name, name, tab_index, parent_tab_id, creation_date, last_update_date,'||
25                                          'created_by, last_updated_by FROM bsc_tabs_vl WHERE short_name IS NOT NULL AND NOT EXISTS '||
26                                          ' (SELECT 1 FROM ak_regions WHERE short_name = region_code)';
27 
28 
29 PROCEDURE init;
30 PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL);
31 PROCEDURE cleanup;
32 PROCEDURE runtest(inputs IN JTF_DIAG_INPUTTBL,
33 report OUT NOCOPY JTF_DIAG_REPORT,
34 reportClob OUT NOCOPY CLOB);
35 PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2);
36 PROCEDURE getTestName(name OUT NOCOPY VARCHAR2);
37 PROCEDURE getTestDesc(descStr OUT NOCOPY VARCHAR2);
38 FUNCTION getTestMode RETURN INTEGER;
39 END;