PACKAGE: APPS.BSC_OLAP_MAIN

Source

1 package BSC_OLAP_MAIN AS
2 /*$Header: BSCMAINS.pls 120.1 2005/09/08 14:06:45 arsantha noship $*/
3 
4 --program runtime parameters
5 g_debug boolean;
6 g_status boolean;
7 G_CLOB clob;
8 g_aw_workspace varchar2(200);
9 g_init_all varchar2(10);
10 g_status_message varchar2(4000);
11 g_options BSC_IM_UTILS.varchar_tabletype;
12 g_number_options number;
13 b_table_col_type_created boolean := false;  --Bug 3878968
14 g_col_type_table_name VARCHAR2(30):= 'BSC_TMP_COL_TYPE_'||userenv('SESSIONID');
15 
16 g_summary_table_tbs_clause varchar2(4000);
17 g_summary_index_tbs_clause varchar2(4000);
18 g_summary_table_tbs_name varchar(1000);
19 g_summary_index_tbs_name varchar2(1000);
20 --------------------PUBLIC API-------------------------------------
21 function implement_bsc_mv(
22 p_kpi varchar2,
23 p_option_string varchar2,
24 p_error_message out nocopy varchar2)return boolean;
25 function drop_bsc_mv(
26 p_kpi varchar2,
27 p_option_string varchar2,
28 p_error_message out nocopy varchar2)return boolean;
29 function drop_summary_mv(
30 p_mv varchar2,
31 p_option_string varchar2,
32 p_error_message out nocopy varchar2)return boolean;
33 function refresh_bsc_mv(
34 p_kpi varchar2,
35 p_option_string varchar2,
36 p_error_message out nocopy varchar2)return boolean ;
37 function refresh_summary_mv(
38 p_mv varchar2,
39 p_kpi varchar2,
40 p_option_string varchar2,
41 p_error_message out nocopy varchar2)return boolean;
42 --------------------------------------
43 function load_reporting_calendar(
44 p_apps varchar2,
45 p_option_string varchar2,
46 p_error_message out nocopy varchar2)return boolean;
47 --Fix bug#4027813: Added this function to load reporting calendar for only
48 --the specified calendar id
49 function load_reporting_calendar(
50 p_calendar_id number,
51 p_apps varchar2,
52 p_option_string varchar2,
53 p_error_message out nocopy varchar2)return boolean;
54 --------------------------------------
55 --for PMV to handle recursive dimensions
56 procedure get_list_of_rec_dim(
57 p_dim_list out nocopy bsc_varchar2_table_type,
58 p_num_dim_list out nocopy number,
59 p_error_message out nocopy varchar2);
60 procedure set_and_get_dim_sql(
61 p_dim_level_short_name bsc_varchar2_table_type,
62 p_dim_level_value bsc_varchar2_table_type,
63 p_num_dim_level number,
64 p_dim_level_sql out nocopy bsc_varchar2_table_type,
65 p_error_message out nocopy varchar2
66 );
67 --------------------------------------
68 procedure reset;
69 procedure open_file;
70 --------------------------------------
71 --functions--------------------------------------------------------
72 function get_time return varchar2 ;
73 function init_all(
74 p_options BSC_IM_UTILS.varchar_tabletype,
75 p_number_options number) return boolean;
76 --procedures-------------------------------------------------------
77 procedure write_to_log_file(p_message varchar2);
78 procedure write_to_log_file_n(p_message varchar2);
79 procedure write_to_debug_n(p_message varchar2);
80 procedure write_to_debug(p_message varchar2);
81 -------------------------------------------------------------------
82 procedure drop_tmp_col_type_table; --bug 3878968
83 --bug 3899523
84 function create_tmp_col_type_table(p_error_message out nocopy varchar2) return boolean;
85 END BSC_OLAP_MAIN;