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_COMPUTED_ACTUAL_PVT dependencies on AK_REGION_ITEMS

Line 17: , Attribute_code ak_region_items.attribute_code%TYPE

13:
14:
15: TYPE Measure_Instance_DB_Obj_Rec IS RECORD
16: ( Region_Code ak_regions.region_code%TYPE
17: , Attribute_code ak_region_items.attribute_code%TYPE
18: , Database_Object_name ak_regions.DATABASE_OBJECT_NAME%TYPE
19: , Database_Obj_Column_Name ak_region_items.ATTRIBUTE4%TYPE
20: , Database_Obj_Column_Type ak_region_items.ATTRIBUTE1%TYPE
21: , Column_Value VARCHAR2(32000)

Line 19: , Database_Obj_Column_Name ak_region_items.ATTRIBUTE4%TYPE

15: TYPE Measure_Instance_DB_Obj_Rec IS RECORD
16: ( Region_Code ak_regions.region_code%TYPE
17: , Attribute_code ak_region_items.attribute_code%TYPE
18: , Database_Object_name ak_regions.DATABASE_OBJECT_NAME%TYPE
19: , Database_Obj_Column_Name ak_region_items.ATTRIBUTE4%TYPE
20: , Database_Obj_Column_Type ak_region_items.ATTRIBUTE1%TYPE
21: , Column_Value VARCHAR2(32000)
22: );
23:

Line 20: , Database_Obj_Column_Type ak_region_items.ATTRIBUTE1%TYPE

16: ( Region_Code ak_regions.region_code%TYPE
17: , Attribute_code ak_region_items.attribute_code%TYPE
18: , Database_Object_name ak_regions.DATABASE_OBJECT_NAME%TYPE
19: , Database_Obj_Column_Name ak_region_items.ATTRIBUTE4%TYPE
20: , Database_Obj_Column_Type ak_region_items.ATTRIBUTE1%TYPE
21: , Column_Value VARCHAR2(32000)
22: );
23:
24: TYPE Measure_Instance_DB_Obj_Tbl IS TABLE OF Measure_Instance_DB_Obj_rec

Line 210: ,p_actual_region_item IN ak_region_items.region_code%TYPE

206: ( P_PARAMETER_TBL_TYPE IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
207: ,P_TIME_PARAMETER_REC_TYPE IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
208: ,p_view_by_lvl_sht_name IN VARCHAR2
209: ,p_actual_region_code IN ak_regions.REGION_CODE%TYPE
210: ,p_actual_region_item IN ak_region_items.region_code%TYPE
211: ,p_compare_region_item IN ak_region_items.region_code%TYPE
212: ,x_return_status OUT NOCOPY VARCHAR2
213: ) ;
214:

Line 211: ,p_compare_region_item IN ak_region_items.region_code%TYPE

207: ,P_TIME_PARAMETER_REC_TYPE IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
208: ,p_view_by_lvl_sht_name IN VARCHAR2
209: ,p_actual_region_code IN ak_regions.REGION_CODE%TYPE
210: ,p_actual_region_item IN ak_region_items.region_code%TYPE
211: ,p_compare_region_item IN ak_region_items.region_code%TYPE
212: ,x_return_status OUT NOCOPY VARCHAR2
213: ) ;
214:
215: --

Line 285: l_compare_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;

281: l_compare_region_appl_id ak_regions.REGION_APPLICATION_ID%TYPE;
282: L_COMPARISION_SOURCE VARCHAR2(300);
283: L_ACTUAL_DATA_SOURCE VARCHAR2(300);
284: l_compare_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
285: l_compare_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
286:
287: l_actual_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
288: l_actual_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
289:

Line 288: l_actual_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;

284: l_compare_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
285: l_compare_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
286:
287: l_actual_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
288: l_actual_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
289:
290: L_PARAMETER_TBL_TYPE BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;
291: l_parameter_tbl_type_p BIS_PMV_ACTUAL_PVT.parameter_tbl_type;
292: L_TIME_PARAMETER_REC_TYPE BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE;

Line 604: l_compare_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;

600:
601: l_compare_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
602: l_compare_region_appl_id ak_regions.REGION_APPLICATION_ID%TYPE;
603: L_COMPARISION_SOURCE VARCHAR2(300);
604: l_compare_region_item ak_region_items.region_code%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
605:
606:
607: CURSOR cr_performance_measures(pi_measure_short_name VARCHAR2) IS
608: SELECT comparison_source

Line 797: l_actual_region_item ak_region_items.item_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;

793: l_object_tbl object_tbl_type;
794: l_actual_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
795: l_actual_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE;
796: l_actual_data_source VARCHAR2(300);
797: l_actual_region_item ak_region_items.item_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;
798:
799: CURSOR cr_performance_measures(pi_measure_short_name VARCHAR2) IS
800: SELECT actual_data_source
801: FROM bisbv_performance_measures

Line 804: CURSOR cr_region_items(pi_actual_region_item ak_region_items.item_name%TYPE

800: SELECT actual_data_source
801: FROM bisbv_performance_measures
802: WHERE measure_short_name = pi_measure_short_name;
803:
804: CURSOR cr_region_items(pi_actual_region_item ak_region_items.item_name%TYPE
805: ,pi_actual_region_code ak_region_items.region_code%TYPE) IS
806: SELECT region_application_id
807: FROM ak_region_items
808: WHERE attribute_code = pi_actual_region_item

Line 805: ,pi_actual_region_code ak_region_items.region_code%TYPE) IS

801: FROM bisbv_performance_measures
802: WHERE measure_short_name = pi_measure_short_name;
803:
804: CURSOR cr_region_items(pi_actual_region_item ak_region_items.item_name%TYPE
805: ,pi_actual_region_code ak_region_items.region_code%TYPE) IS
806: SELECT region_application_id
807: FROM ak_region_items
808: WHERE attribute_code = pi_actual_region_item
809: AND region_code = pi_actual_region_code;

Line 807: FROM ak_region_items

803:
804: CURSOR cr_region_items(pi_actual_region_item ak_region_items.item_name%TYPE
805: ,pi_actual_region_code ak_region_items.region_code%TYPE) IS
806: SELECT region_application_id
807: FROM ak_region_items
808: WHERE attribute_code = pi_actual_region_item
809: AND region_code = pi_actual_region_code;
810:
811: CURSOR cr_region_objects

Line 892: FROM ak_region_items i

888: ORDER BY CREATION_DATE asc;
889:
890: CURSOR cr_region_item IS
891: SELECT region_code, region_application_id
892: FROM ak_region_items i
893: WHERE i.ATTRIBUTE1 = 'MEASURE'
894: AND i.ATTRIBUTE2 = p_measure_short_name;
895:
896: BEGIN

Line 1004: FROM ak_region_items

1000: bisbv_dimension_levels.DIMENSION_LEVEL_SHORT_NAME%TYPE
1001: )
1002: IS
1003: SELECT *
1004: FROM ak_region_items
1005: WHERE REGION_CODE = p_region_code
1006: AND REGION_APPLICATION_ID = p_region_application_id
1007: AND ATTRIBUTE1 = 'DIMENSION LEVEL'
1008: AND get_dim_level_short_name(ATTRIBUTE2)

Line 1057: FROM ak_region_items

1053:
1054: BEGIN
1055: Select *
1056: INTO l_object_attribute_tbl(l_object_attribute_tbl.COUNT+1)
1057: FROM ak_region_items
1058: WHERE REGION_CODE = p_object_tbl(1).region_code
1059: AND REGION_APPLICATION_ID = p_object_tbl(1).region_application_id
1060: AND ATTRIBUTE1 = 'MEASURE'
1061: AND ATTRIBUTE2 = p_measure_short_name;

Line 1073: FROM ak_region_items

1069:
1070: BEGIN
1071: Select *
1072: INTO l_object_attribute_tbl(l_object_attribute_tbl.COUNT+1)
1073: FROM ak_region_items
1074: WHERE REGION_CODE = p_object_tbl(1).region_code
1075: AND REGION_APPLICATION_ID = p_object_tbl(1).region_application_id
1076: AND ATTRIBUTE1 = 'MEASURE'
1077: AND ATTRIBUTE_CODE = p_compare_region_item;

Line 2178: FROM ak_region_items

2174:
2175: BEGIN
2176:
2177: SELECT ATTRIBUTE9 into l_function
2178: FROM ak_region_items
2179: WHERE region_code = p_Measure_Instance_Obj_rec.region_code
2180: AND ATTRIBUTE_CODE = p_Measure_Instance_Obj_rec.attribute_code;
2181:
2182: BIS_UTILITIES_PUB.put_line(p_text =>'Aggregate function used to compute actual: '||l_function);

Line 3180: ,p_actual_region_item IN ak_region_items.region_code%TYPE

3176: ( P_PARAMETER_TBL_TYPE IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
3177: ,P_TIME_PARAMETER_REC_TYPE IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
3178: ,p_view_by_lvl_sht_name IN VARCHAR2
3179: ,p_actual_region_code IN ak_regions.REGION_CODE%TYPE
3180: ,p_actual_region_item IN ak_region_items.region_code%TYPE
3181: ,p_compare_region_item IN ak_region_items.region_code%TYPE
3182: ,x_return_status OUT NOCOPY VARCHAR2
3183: ) is
3184:

Line 3181: ,p_compare_region_item IN ak_region_items.region_code%TYPE

3177: ,P_TIME_PARAMETER_REC_TYPE IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
3178: ,p_view_by_lvl_sht_name IN VARCHAR2
3179: ,p_actual_region_code IN ak_regions.REGION_CODE%TYPE
3180: ,p_actual_region_item IN ak_region_items.region_code%TYPE
3181: ,p_compare_region_item IN ak_region_items.region_code%TYPE
3182: ,x_return_status OUT NOCOPY VARCHAR2
3183: ) is
3184:
3185: l_print_text VARCHAR2(32000);