DBA Data[Home] [Help]

APPS.BSC_DIMENSION_KEYS_PKG dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 8: g_periodicities BIS_PMV_PAGE_PARAMETER_TBL;

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;

Line 16: g_dimensions BIS_PMV_PAGE_PARAMETER_TBL;

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(

Line 17: g_measures BIS_PMV_PAGE_PARAMETER_TBL;

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

Line 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();

Line 23: g_periodicities := 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();

Line 25: g_dimensions := 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:

Line 27: g_measures := BIS_PMV_PAGE_PARAMETER_TBL();

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

Line 320: l_parameters BIS_PMV_PAGE_PARAMETER_TBL;

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();

Line 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

Line 400: p_parameters BIS_PMV_PAGE_PARAMETER_TBL,

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: --