10: g_adv_sum_profile number;
11: g_init boolean;
12: --procedures-------------------------------------------------------
13: procedure implement_kpi_aw(
14: p_kpi_list dbms_sql.varchar2_table,
15: p_options varchar2
16: );
17: procedure implement_kpi_aw(
18: p_kpi_list dbms_sql.varchar2_table,
14: p_kpi_list dbms_sql.varchar2_table,
15: p_options varchar2
16: );
17: procedure implement_kpi_aw(
18: p_kpi_list dbms_sql.varchar2_table,
19: p_options varchar2,
20: p_affected_kpi out nocopy dbms_sql.varchar2_table
21: );
22: procedure implement_kpi_aw(
16: );
17: procedure implement_kpi_aw(
18: p_kpi_list dbms_sql.varchar2_table,
19: p_options varchar2,
20: p_affected_kpi out nocopy dbms_sql.varchar2_table
21: );
22: procedure implement_kpi_aw(
23: p_kpi_list dbms_sql.varchar2_table,
24: p_affected_kpi out nocopy dbms_sql.varchar2_table
19: p_options varchar2,
20: p_affected_kpi out nocopy dbms_sql.varchar2_table
21: );
22: procedure implement_kpi_aw(
23: p_kpi_list dbms_sql.varchar2_table,
24: p_affected_kpi out nocopy dbms_sql.varchar2_table
25: );
26: procedure set_up(p_options varchar2);
27: procedure create_dim(
20: p_affected_kpi out nocopy dbms_sql.varchar2_table
21: );
22: procedure implement_kpi_aw(
23: p_kpi_list dbms_sql.varchar2_table,
24: p_affected_kpi out nocopy dbms_sql.varchar2_table
25: );
26: procedure set_up(p_options varchar2);
27: procedure create_dim(
28: p_dim_level_list dbms_sql.varchar2_table,
24: p_affected_kpi out nocopy dbms_sql.varchar2_table
25: );
26: procedure set_up(p_options varchar2);
27: procedure create_dim(
28: p_dim_level_list dbms_sql.varchar2_table,
29: p_options varchar2
30: );
31: procedure drop_kpi(p_kpi_list dbms_sql.varchar2_table,p_options varchar2);
32: procedure drop_kpi(p_kpi_list dbms_sql.varchar2_table);
27: procedure create_dim(
28: p_dim_level_list dbms_sql.varchar2_table,
29: p_options varchar2
30: );
31: procedure drop_kpi(p_kpi_list dbms_sql.varchar2_table,p_options varchar2);
32: procedure drop_kpi(p_kpi_list dbms_sql.varchar2_table);
33: procedure upgrade(p_options varchar2);
34: procedure upgrade(p_new_version number,p_old_version number);
35: --procedures-------------------------------------------------------
28: p_dim_level_list dbms_sql.varchar2_table,
29: p_options varchar2
30: );
31: procedure drop_kpi(p_kpi_list dbms_sql.varchar2_table,p_options varchar2);
32: procedure drop_kpi(p_kpi_list dbms_sql.varchar2_table);
33: procedure upgrade(p_options varchar2);
34: procedure upgrade(p_new_version number,p_old_version number);
35: --procedures-------------------------------------------------------
36: procedure init_all;