eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_AK_REGION_PUB dependencies on BISBV_PERFORMANCE_MEASURES

Line 130: p_short_name IN Bisbv_Performance_Measures.MEASURE_SHORT_NAME%Type

126: END IS_COMPARE_TYPE;
127:
128: --return true if and only if given measure short name exists
129: FUNCTION VALIDATE_MEASURE(
130: p_short_name IN Bisbv_Performance_Measures.MEASURE_SHORT_NAME%Type
131: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
132: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
133: ) RETURN BOOLEAN
134: IS

Line 131: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE

127:
128: --return true if and only if given measure short name exists
129: FUNCTION VALIDATE_MEASURE(
130: p_short_name IN Bisbv_Performance_Measures.MEASURE_SHORT_NAME%Type
131: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
132: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
133: ) RETURN BOOLEAN
134: IS
135: l_result BOOLEAN := false;

Line 132: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE

128: --return true if and only if given measure short name exists
129: FUNCTION VALIDATE_MEASURE(
130: p_short_name IN Bisbv_Performance_Measures.MEASURE_SHORT_NAME%Type
131: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
132: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
133: ) RETURN BOOLEAN
134: IS
135: l_result BOOLEAN := false;
136: l_measure_name Bisbv_Performance_Measures.MEASURE_NAME%TYPE;

Line 136: l_measure_name Bisbv_Performance_Measures.MEASURE_NAME%TYPE;

132: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
133: ) RETURN BOOLEAN
134: IS
135: l_result BOOLEAN := false;
136: l_measure_name Bisbv_Performance_Measures.MEASURE_NAME%TYPE;
137:
138: CURSOR mea_cur IS
139: SELECT measure_name
140: FROM Bisbv_Performance_Measures

Line 140: FROM Bisbv_Performance_Measures

136: l_measure_name Bisbv_Performance_Measures.MEASURE_NAME%TYPE;
137:
138: CURSOR mea_cur IS
139: SELECT measure_name
140: FROM Bisbv_Performance_Measures
141: WHERE measure_short_name = p_short_name;
142:
143: BEGIN
144: IF (p_short_name IS NOT NULL) THEN

Line 167: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE

163: FUNCTION VALIDATE_COMPARE(
164: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
165: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
166: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
167: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
168: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
169: ) RETURN BOOLEAN
170: IS
171: l_result BOOLEAN := false;

Line 168: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE

164: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
165: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
166: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
167: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
168: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
169: ) RETURN BOOLEAN
170: IS
171: l_result BOOLEAN := false;
172:

Line 2898: l_measure_short_name Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE;

2894: , x_msg_data OUT NOCOPY VARCHAR2
2895: ) IS
2896:
2897: l_Region_Item_Rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
2898: l_measure_short_name Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE;
2899: l_measure_name Bisbv_Performance_Measures.MEASURE_NAME%TYPE;
2900: l_msg_data VARCHAR2(300);
2901: l_msg_count NUMBER;
2902: l_ret_status VARCHAR2(10);

Line 2899: l_measure_name Bisbv_Performance_Measures.MEASURE_NAME%TYPE;

2895: ) IS
2896:
2897: l_Region_Item_Rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
2898: l_measure_short_name Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE;
2899: l_measure_name Bisbv_Performance_Measures.MEASURE_NAME%TYPE;
2900: l_msg_data VARCHAR2(300);
2901: l_msg_count NUMBER;
2902: l_ret_status VARCHAR2(10);
2903:

Line 2952: l_measure_short_name Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE;

2948: , x_msg_data OUT NOCOPY VARCHAR2
2949: ) IS
2950:
2951: l_Region_Item_Rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
2952: l_measure_short_name Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE;
2953: l_measure_name Bisbv_Performance_Measures.MEASURE_NAME%TYPE;
2954: l_msg_data VARCHAR2(300);
2955: l_msg_count NUMBER;
2956: l_ret_status VARCHAR2(10);

Line 2953: l_measure_name Bisbv_Performance_Measures.MEASURE_NAME%TYPE;

2949: ) IS
2950:
2951: l_Region_Item_Rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
2952: l_measure_short_name Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE;
2953: l_measure_name Bisbv_Performance_Measures.MEASURE_NAME%TYPE;
2954: l_msg_data VARCHAR2(300);
2955: l_msg_count NUMBER;
2956: l_ret_status VARCHAR2(10);
2957: l_type VARCHAR2(30);

Line 3130: ,p_measure_short_name IN Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE

3126: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
3127: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
3128: ,p_source_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
3129: ,p_compare_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
3130: ,p_measure_short_name IN Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
3131: ) RETURN VARCHAR2
3132: IS
3133: ak_sc_modify BOOLEAN := TRUE;
3134: ak_cc_modify BOOLEAN := TRUE;

Line 3136: l_measure_short_name Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE;

3132: IS
3133: ak_sc_modify BOOLEAN := TRUE;
3134: ak_cc_modify BOOLEAN := TRUE;
3135: ak_modify VARCHAR2(10) := 'SCCC';
3136: l_measure_short_name Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE;
3137: l_measure_name Bisbv_Performance_Measures.MEASURE_NAME%TYPE;
3138:
3139: CURSOR attribute_cur(p_attr_code VARCHAR2) IS
3140: SELECT a.attribute2

Line 3137: l_measure_name Bisbv_Performance_Measures.MEASURE_NAME%TYPE;

3133: ak_sc_modify BOOLEAN := TRUE;
3134: ak_cc_modify BOOLEAN := TRUE;
3135: ak_modify VARCHAR2(10) := 'SCCC';
3136: l_measure_short_name Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE;
3137: l_measure_name Bisbv_Performance_Measures.MEASURE_NAME%TYPE;
3138:
3139: CURSOR attribute_cur(p_attr_code VARCHAR2) IS
3140: SELECT a.attribute2
3141: FROM ak_region_items a