558: ) RETURN BOOLEAN;
559:
560: --return true if and only if given measure short name exists
561: FUNCTION VALIDATE_MEASURE(
562: p_short_name IN Bisbv_Performance_Measures.MEASURE_SHORT_NAME%Type
563: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
564: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
565: ) RETURN BOOLEAN;
566:
559:
560: --return true if and only if given measure short name exists
561: FUNCTION VALIDATE_MEASURE(
562: p_short_name IN Bisbv_Performance_Measures.MEASURE_SHORT_NAME%Type
563: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
564: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
565: ) RETURN BOOLEAN;
566:
567: --return true if any only if p_compare_code refers to a valid entry in ak_region_items which
560: --return true if and only if given measure short name exists
561: FUNCTION VALIDATE_MEASURE(
562: p_short_name IN Bisbv_Performance_Measures.MEASURE_SHORT_NAME%Type
563: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
564: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
565: ) RETURN BOOLEAN;
566:
567: --return true if any only if p_compare_code refers to a valid entry in ak_region_items which
568: --subsequently refers to a valid measure
569: FUNCTION VALIDATE_COMPARE(
570: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
571: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
572: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
573: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
574: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
575: ) RETURN BOOLEAN;
576:
577: FUNCTION AK_DATA_SET(
570: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
571: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
572: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
573: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
574: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
575: ) RETURN BOOLEAN;
576:
577: FUNCTION AK_DATA_SET(
578: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
578: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
579: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
580: ,p_source_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
581: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
582: ,p_measure_short_name IN Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
583: ) RETURN VARCHAR2;
584:
585: --return 'T' if given report is view based, 'F' otherwise
586: FUNCTION IS_VIEW_BASED_REPORT(