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_MEASURE_PVT dependencies on BISBV_PERFORMANCE_MEASURES

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

146: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
147: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
148: ,p_attribute_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
149: ,p_attribute_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type
150: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
151: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
152: ) RETURN boolean;
153:
154: FUNCTION isCompareColumnMappedAlready(

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

147: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
148: ,p_attribute_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
149: ,p_attribute_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type
150: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
151: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
152: ) RETURN boolean;
153:
154: FUNCTION isCompareColumnMappedAlready(
155: p_Measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE

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

152: ) RETURN boolean;
153:
154: FUNCTION isCompareColumnMappedAlready(
155: p_Measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE
156: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
157: ) RETURN boolean;
158:
159: -- mdamle 07/18/2003 - Check if measure is being mapped to a source
160: -- that's already mapped to another measure.

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

159: -- mdamle 07/18/2003 - Check if measure is being mapped to a source
160: -- that's already mapped to another measure.
161: FUNCTION isSourceColumnMappedAlready(
162: p_Measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE
163: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
164: ) RETURN boolean;
165:
166:
167: -- rpenneru 12/27/2004 for enh#4080204

Line 1497: from bisbv_performance_measures

1493: l_Measure_Rec_p BIS_Measure_PUB.Measure_Rec_Type;
1494:
1495: cursor cr_all_measures is
1496: select measure_id, measure_short_name, measure_name
1497: from bisbv_performance_measures
1498: order by UPPER(MEASURE_NAME);
1499:
1500: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1501: BEGIN

Line 1620: from bisbv_performance_measures

1616: , x_Measure_rec.Dimension6_Id
1617: , x_Measure_rec.Dimension7_Id
1618: , x_Measure_rec.Unit_Of_Measure_Class
1619: , x_Measure_rec.Dataset_Id
1620: from bisbv_performance_measures
1621: where measure_id = p_Measure_Rec.Measure_ID;
1622: END IF;
1623: IF (p_Measure_Rec.Measure_Short_Name IS NOT NULL AND
1624: p_Measure_Rec.Measure_Id IS NULL) THEN

Line 1669: from bisbv_performance_measures

1665: , x_Measure_rec.Dimension6_Id
1666: , x_Measure_rec.Dimension7_Id
1667: , x_Measure_rec.Unit_Of_Measure_Class
1668: , x_Measure_rec.Dataset_Id
1669: from bisbv_performance_measures
1670: where measure_short_name = p_Measure_Rec.Measure_Short_Name; -- bug fix -- mahesh
1671: END IF;
1672: IF p_all_info = FND_API.G_TRUE THEN
1673:

Line 3963: FROM bisbv_Performance_Measures

3959:
3960: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_Measure_Short_Name)
3961: = FND_API.G_TRUE) then
3962: SELECT Measure_id into x_Measure_ID
3963: FROM bisbv_Performance_Measures
3964: WHERE Measure_short_name = p_Measure_Short_Name;
3965: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Measure_Name)
3966: = FND_API.G_TRUE) then
3967: SELECT Measure_id into x_Measure_ID

Line 3968: FROM bisbv_Performance_Measures

3964: WHERE Measure_short_name = p_Measure_Short_Name;
3965: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Measure_Name)
3966: = FND_API.G_TRUE) then
3967: SELECT Measure_id into x_Measure_ID
3968: FROM bisbv_Performance_Measures
3969: WHERE Measure_name = p_Measure_Name;
3970: else
3971: -- POLPULATE ERROR TABLE
3972: --added last two params

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

5121: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE
5122: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
5123: ,p_attribute_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
5124: ,p_attribute_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type
5125: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
5126: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
5127: ) RETURN boolean IS
5128: l_result boolean := false;
5129: l_attribute1 Ak_Region_Items.Attribute1%Type;

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

5122: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type
5123: ,p_attribute_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type
5124: ,p_attribute_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type
5125: ,x_measure_short_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE
5126: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
5127: ) RETURN boolean IS
5128: l_result boolean := false;
5129: l_attribute1 Ak_Region_Items.Attribute1%Type;
5130: l_attribute2 Bisbv_Performance_Measures.MEASURE_NAME%TYPE;

Line 5130: l_attribute2 Bisbv_Performance_Measures.MEASURE_NAME%TYPE;

5126: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
5127: ) RETURN boolean IS
5128: l_result boolean := false;
5129: l_attribute1 Ak_Region_Items.Attribute1%Type;
5130: l_attribute2 Bisbv_Performance_Measures.MEASURE_NAME%TYPE;
5131: BEGIN
5132: SELECT attribute1, attribute2 into l_attribute1, l_attribute2
5133: FROM Ak_Region_Items
5134: WHERE region_code = p_region_code

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

5157: -- mdamle 07/18/2003 - Check if measure is being mapped to a source
5158: -- that's already mapped to another measure.
5159: FUNCTION isSourceColumnMappedAlready(
5160: p_Measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE
5161: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
5162: ) RETURN boolean IS
5163: l_result boolean := false;
5164: l_region_code Ak_Region_Items.REGION_CODE%TYPE;
5165: l_source_column Ak_Region_Items.ATTRIBUTE_CODE%TYPE;

Line 5166: l_measure_short_name Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE;

5162: ) RETURN boolean IS
5163: l_result boolean := false;
5164: l_region_code Ak_Region_Items.REGION_CODE%TYPE;
5165: l_source_column Ak_Region_Items.ATTRIBUTE_CODE%TYPE;
5166: l_measure_short_name Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE;
5167: BEGIN
5168: IF (p_measure_rec.actual_data_source IS NOT NULL) THEN
5169: l_region_code := substr(p_measure_rec.actual_data_source, 1, instr(p_measure_rec.actual_data_source, '.') -1);
5170: l_source_column := substr(p_measure_rec.actual_data_source, instr(p_measure_rec.actual_data_source, '.') +1);

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

5188:
5189: --sawu: bug#3859267: need to validate compare-to column
5190: FUNCTION isCompareColumnMappedAlready(
5191: p_Measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE
5192: ,x_measure_name OUT NOCOPY Bisbv_Performance_Measures.MEASURE_NAME%TYPE
5193: ) RETURN boolean IS
5194: l_result boolean := false;
5195: l_region_code Ak_Region_Items.REGION_CODE%TYPE;
5196: l_compare_column Ak_Region_Items.ATTRIBUTE_CODE%TYPE;

Line 5197: l_measure_short_name Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE;

5193: ) RETURN boolean IS
5194: l_result boolean := false;
5195: l_region_code Ak_Region_Items.REGION_CODE%TYPE;
5196: l_compare_column Ak_Region_Items.ATTRIBUTE_CODE%TYPE;
5197: l_measure_short_name Bisbv_Performance_Measures.MEASURE_SHORT_NAME%TYPE;
5198: BEGIN
5199: IF (p_measure_rec.Comparison_Source IS NOT NULL) THEN
5200: l_region_code := substr(p_measure_rec.Comparison_Source, 1, instr(p_measure_rec.Comparison_Source, '.') -1);
5201: l_compare_column := substr(p_measure_rec.Comparison_Source, instr(p_measure_rec.Comparison_Source, '.') +1);