DBA Data[Home] [Help]

APPS.BSC_BIS_MEASURE_PUB dependencies on AK_REGION_ITEMS

Line 320: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type := -1

316: ,p_dataset_color_method IN NUMBER := NULL
317: ,p_dataset_autoscale_flag IN NUMBER := NULL
318: ,p_dataset_projection_flag IN NUMBER := NULL
319: ,p_measure_short_name IN VARCHAR2
320: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type := -1
321: ,p_source_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
322: ,p_compare_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
323: ,p_measure_act_data_src_type IN VARCHAR2 := NULL
324: ,p_measure_act_data_src IN VARCHAR2 := NULL

Line 321: ,p_source_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1

317: ,p_dataset_autoscale_flag IN NUMBER := NULL
318: ,p_dataset_projection_flag IN NUMBER := NULL
319: ,p_measure_short_name IN VARCHAR2
320: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type := -1
321: ,p_source_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
322: ,p_compare_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
323: ,p_measure_act_data_src_type IN VARCHAR2 := NULL
324: ,p_measure_act_data_src IN VARCHAR2 := NULL
325: ,p_measure_comparison_source IN VARCHAR2 := NULL

Line 322: ,p_compare_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1

318: ,p_dataset_projection_flag IN NUMBER := NULL
319: ,p_measure_short_name IN VARCHAR2
320: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type := -1
321: ,p_source_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
322: ,p_compare_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
323: ,p_measure_act_data_src_type IN VARCHAR2 := NULL
324: ,p_measure_act_data_src IN VARCHAR2 := NULL
325: ,p_measure_comparison_source IN VARCHAR2 := NULL
326: ,p_measure_operation IN VARCHAR2 := c_SUM

Line 504: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type := -1

500: ,p_dataset_color_method IN NUMBER := NULL
501: ,p_dataset_autoscale_flag IN NUMBER := NULL
502: ,p_dataset_projection_flag IN NUMBER := NULL
503: ,p_measure_short_name IN VARCHAR2
504: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type := -1
505: ,p_source_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
506: ,p_compare_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
507: ,p_measure_act_data_src_type IN VARCHAR2 := NULL
508: ,p_measure_act_data_src IN VARCHAR2 := NULL

Line 505: ,p_source_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1

501: ,p_dataset_autoscale_flag IN NUMBER := NULL
502: ,p_dataset_projection_flag IN NUMBER := NULL
503: ,p_measure_short_name IN VARCHAR2
504: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type := -1
505: ,p_source_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
506: ,p_compare_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
507: ,p_measure_act_data_src_type IN VARCHAR2 := NULL
508: ,p_measure_act_data_src IN VARCHAR2 := NULL
509: ,p_measure_comparison_source IN VARCHAR2 := NULL

Line 506: ,p_compare_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1

502: ,p_dataset_projection_flag IN NUMBER := NULL
503: ,p_measure_short_name IN VARCHAR2
504: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type := -1
505: ,p_source_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
506: ,p_compare_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
507: ,p_measure_act_data_src_type IN VARCHAR2 := NULL
508: ,p_measure_act_data_src IN VARCHAR2 := NULL
509: ,p_measure_comparison_source IN VARCHAR2 := NULL
510: ,p_measure_operation IN VARCHAR2 := c_SUM

Line 662: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type := -1

658: ,p_dataset_color_method IN NUMBER := NULL
659: ,p_dataset_autoscale_flag IN NUMBER := NULL
660: ,p_dataset_projection_flag IN NUMBER := NULL
661: ,p_measure_short_name IN VARCHAR2
662: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type := -1
663: ,p_source_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
664: ,p_compare_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
665: ,p_measure_act_data_src_type IN VARCHAR2 := NULL
666: ,p_measure_act_data_src IN VARCHAR2 := NULL

Line 663: ,p_source_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1

659: ,p_dataset_autoscale_flag IN NUMBER := NULL
660: ,p_dataset_projection_flag IN NUMBER := NULL
661: ,p_measure_short_name IN VARCHAR2
662: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type := -1
663: ,p_source_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
664: ,p_compare_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
665: ,p_measure_act_data_src_type IN VARCHAR2 := NULL
666: ,p_measure_act_data_src IN VARCHAR2 := NULL
667: ,p_measure_comparison_source IN VARCHAR2 := NULL

Line 664: ,p_compare_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1

660: ,p_dataset_projection_flag IN NUMBER := NULL
661: ,p_measure_short_name IN VARCHAR2
662: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type := -1
663: ,p_source_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
664: ,p_compare_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
665: ,p_measure_act_data_src_type IN VARCHAR2 := NULL
666: ,p_measure_act_data_src IN VARCHAR2 := NULL
667: ,p_measure_comparison_source IN VARCHAR2 := NULL
668: ,p_measure_operation IN VARCHAR2 := c_SUM

Line 990: --sawu: 9/1/04: populates region_app_id and attribute_code_app_id for ak_region_items also

986: l_measure_rec.obsolete := p_measure_obsolete;
987: l_measure_rec.measure_type:= p_type;
988: l_measure_rec.is_validate := p_measure_is_validate;
989:
990: --sawu: 9/1/04: populates region_app_id and attribute_code_app_id for ak_region_items also
991: l_measure_rec.Region_App_Id := p_region_app_id;
992: l_measure_rec.Source_Column_App_Id := p_source_column_app_id;
993: l_measure_rec.Compare_Column_App_Id := p_compare_column_app_id;
994:

Line 1116: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type := -1

1112: ,p_dataset_color_method IN NUMBER := NULL
1113: ,p_dataset_autoscale_flag IN NUMBER := NULL
1114: ,p_dataset_projection_flag IN NUMBER := NULL
1115: ,p_measure_short_name IN VARCHAR2
1116: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type := -1
1117: ,p_source_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
1118: ,p_compare_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
1119: ,p_measure_act_data_src_type IN VARCHAR2 := NULL
1120: ,p_measure_act_data_src IN VARCHAR2 := NULL

Line 1117: ,p_source_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1

1113: ,p_dataset_autoscale_flag IN NUMBER := NULL
1114: ,p_dataset_projection_flag IN NUMBER := NULL
1115: ,p_measure_short_name IN VARCHAR2
1116: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type := -1
1117: ,p_source_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
1118: ,p_compare_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
1119: ,p_measure_act_data_src_type IN VARCHAR2 := NULL
1120: ,p_measure_act_data_src IN VARCHAR2 := NULL
1121: ,p_measure_comparison_source IN VARCHAR2 := NULL

Line 1118: ,p_compare_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1

1114: ,p_dataset_projection_flag IN NUMBER := NULL
1115: ,p_measure_short_name IN VARCHAR2
1116: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type := -1
1117: ,p_source_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
1118: ,p_compare_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
1119: ,p_measure_act_data_src_type IN VARCHAR2 := NULL
1120: ,p_measure_act_data_src IN VARCHAR2 := NULL
1121: ,p_measure_comparison_source IN VARCHAR2 := NULL
1122: ,p_measure_operation IN VARCHAR2 := c_SUM

Line 1485: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type := -1

1481: ,p_dataset_color_method IN NUMBER := NULL
1482: ,p_dataset_autoscale_flag IN NUMBER := NULL
1483: ,p_dataset_projection_flag IN NUMBER := NULL
1484: ,p_measure_short_name IN VARCHAR2
1485: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type := -1
1486: ,p_source_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
1487: ,p_compare_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
1488: ,p_measure_act_data_src_type IN VARCHAR2 := NULL
1489: ,p_measure_act_data_src IN VARCHAR2 := NULL

Line 1486: ,p_source_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1

1482: ,p_dataset_autoscale_flag IN NUMBER := NULL
1483: ,p_dataset_projection_flag IN NUMBER := NULL
1484: ,p_measure_short_name IN VARCHAR2
1485: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type := -1
1486: ,p_source_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
1487: ,p_compare_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
1488: ,p_measure_act_data_src_type IN VARCHAR2 := NULL
1489: ,p_measure_act_data_src IN VARCHAR2 := NULL
1490: ,p_measure_comparison_source IN VARCHAR2 := NULL

Line 1487: ,p_compare_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1

1483: ,p_dataset_projection_flag IN NUMBER := NULL
1484: ,p_measure_short_name IN VARCHAR2
1485: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type := -1
1486: ,p_source_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
1487: ,p_compare_column_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type := -1
1488: ,p_measure_act_data_src_type IN VARCHAR2 := NULL
1489: ,p_measure_act_data_src IN VARCHAR2 := NULL
1490: ,p_measure_comparison_source IN VARCHAR2 := NULL
1491: ,p_measure_operation IN VARCHAR2 := c_SUM

Line 1956: --sawu: 9/1/04: populates region_app_id and attribute_code_app_id for ak_region_items also

1952: l_measure_rec.obsolete := p_measure_obsolete;
1953: l_measure_rec.measure_type := p_type;
1954: l_measure_rec.is_validate := p_measure_is_validate;
1955:
1956: --sawu: 9/1/04: populates region_app_id and attribute_code_app_id for ak_region_items also
1957: l_measure_rec.Region_App_Id := p_region_app_id;
1958: l_measure_rec.Source_Column_App_Id := p_source_column_app_id;
1959: l_measure_rec.Compare_Column_App_Id := p_compare_column_app_id;
1960: