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 AK_REGION_ITEMS

Line 146: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE

142: ( p_varchar2 IN VARCHAR2 )
143: RETURN VARCHAR2;
144:
145: FUNCTION isColumnMappedAlready(
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

Line 147: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type

143: RETURN VARCHAR2;
144:
145: FUNCTION isColumnMappedAlready(
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

Line 148: ,p_attribute_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type

144:
145: FUNCTION isColumnMappedAlready(
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;

Line 149: ,p_attribute_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type

145: FUNCTION isColumnMappedAlready(
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:

Line 5121: p_region_code IN Ak_Region_Items.REGION_CODE%TYPE

5117: END updt_pm_owner;
5118:
5119: --sawu: bug#3859267: common function to check if a particular ak_region_item is mapped already
5120: FUNCTION isColumnMappedAlready(
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

Line 5122: ,p_region_app_id IN Ak_Region_Items.REGION_APPLICATION_ID%Type

5118:
5119: --sawu: bug#3859267: common function to check if a particular ak_region_item is mapped already
5120: FUNCTION isColumnMappedAlready(
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

Line 5123: ,p_attribute_code IN Ak_Region_Items.ATTRIBUTE_CODE%Type

5119: --sawu: bug#3859267: common function to check if a particular ak_region_item is mapped already
5120: FUNCTION isColumnMappedAlready(
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

Line 5124: ,p_attribute_app_id IN Ak_Region_Items.ATTRIBUTE_APPLICATION_ID%Type

5120: FUNCTION isColumnMappedAlready(
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;

Line 5129: l_attribute1 Ak_Region_Items.Attribute1%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;
5131: BEGIN
5132: SELECT attribute1, attribute2 into l_attribute1, l_attribute2
5133: FROM Ak_Region_Items

Line 5133: FROM Ak_Region_Items

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
5135: AND region_application_id = p_region_app_id
5136: AND attribute_code = p_attribute_code
5137: AND attribute_application_id = p_attribute_app_id;

Line 5164: l_region_code Ak_Region_Items.REGION_CODE%TYPE;

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

Line 5165: l_source_column Ak_Region_Items.ATTRIBUTE_CODE%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;
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);

Line 5195: l_region_code Ak_Region_Items.REGION_CODE%TYPE;

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

Line 5196: l_compare_column Ak_Region_Items.ATTRIBUTE_CODE%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;
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);