4:
5: g_keys_table varchar2(100);
6: g_session_id number;
7: -- Non XTD
8: g_periodicities BIS_PMV_PAGE_PARAMETER_TBL;
9: -- XTD specific
10: g_xtd_type varchar2(100);
11: g_xtd_periodicity number;
12: g_xtd_date dbms_sql.varchar2_table;
12: g_xtd_date dbms_sql.varchar2_table;
13: g_xtd_period dbms_sql.number_table;
14: g_xtd_year dbms_sql.number_table;
15:
16: g_dimensions BIS_PMV_PAGE_PARAMETER_TBL;
17: g_measures BIS_PMV_PAGE_PARAMETER_TBL;
18: g_user_periods TabTimePeriods;
19:
20: PROCEDURE initialize_parameters(
13: g_xtd_period dbms_sql.number_table;
14: g_xtd_year dbms_sql.number_table;
15:
16: g_dimensions BIS_PMV_PAGE_PARAMETER_TBL;
17: g_measures BIS_PMV_PAGE_PARAMETER_TBL;
18: g_user_periods TabTimePeriods;
19:
20: PROCEDURE initialize_parameters(
21: p_parameters IN BIS_PMV_PAGE_PARAMETER_TBL) IS
17: g_measures BIS_PMV_PAGE_PARAMETER_TBL;
18: g_user_periods TabTimePeriods;
19:
20: PROCEDURE initialize_parameters(
21: p_parameters IN BIS_PMV_PAGE_PARAMETER_TBL) IS
22: BEGIN
23: g_periodicities := BIS_PMV_PAGE_PARAMETER_TBL();
24: g_periodicities.delete;
25: g_dimensions := BIS_PMV_PAGE_PARAMETER_TBL();
19:
20: PROCEDURE initialize_parameters(
21: p_parameters IN BIS_PMV_PAGE_PARAMETER_TBL) IS
22: BEGIN
23: g_periodicities := BIS_PMV_PAGE_PARAMETER_TBL();
24: g_periodicities.delete;
25: g_dimensions := BIS_PMV_PAGE_PARAMETER_TBL();
26: g_dimensions.delete;
27: g_measures := BIS_PMV_PAGE_PARAMETER_TBL();
21: p_parameters IN BIS_PMV_PAGE_PARAMETER_TBL) IS
22: BEGIN
23: g_periodicities := BIS_PMV_PAGE_PARAMETER_TBL();
24: g_periodicities.delete;
25: g_dimensions := BIS_PMV_PAGE_PARAMETER_TBL();
26: g_dimensions.delete;
27: g_measures := BIS_PMV_PAGE_PARAMETER_TBL();
28: g_measures.delete;
29:
23: g_periodicities := BIS_PMV_PAGE_PARAMETER_TBL();
24: g_periodicities.delete;
25: g_dimensions := BIS_PMV_PAGE_PARAMETER_TBL();
26: g_dimensions.delete;
27: g_measures := BIS_PMV_PAGE_PARAMETER_TBL();
28: g_measures.delete;
29:
30: FOR i IN 1..p_parameters.count LOOP
31: if p_parameters(i).Parameter_name='PERIODICITY' then
316: end;
317:
318: Procedure Limit_AW(p_kpi varchar2, p_dim_set number) is
319:
320: l_parameters BIS_PMV_PAGE_PARAMETER_TBL;
321: l_parameter BIS_PMV_PAGE_PARAMETER_REC;
322: b_pmv_measure boolean;
323: begin
324: l_parameters := BIS_PMV_PAGE_PARAMETER_TBL();
320: l_parameters BIS_PMV_PAGE_PARAMETER_TBL;
321: l_parameter BIS_PMV_PAGE_PARAMETER_REC;
322: b_pmv_measure boolean;
323: begin
324: l_parameters := BIS_PMV_PAGE_PARAMETER_TBL();
325: -- rearrange data for AW call
326: --dbms_output.put_line('going to check dimensions');
327: --dbms_output.put_line('count='||g_dimensions.count );
328: for i in 1..g_dimensions.count loop
396:
397: Procedure initialize_query (
398: p_kpi varchar2,
399: p_dim_set varchar2,
400: p_parameters BIS_PMV_PAGE_PARAMETER_TBL,
401: p_option_string varchar2,
402: p_error_message out nocopy varchar2
403: ) is
404: --