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_REGIONS

Line 16: ( Region_Code ak_regions.region_code%TYPE

12: c_region_in_webhtmlcall VARCHAR2(40) := 'BISVIEWER.SHOWREPORT(';
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

Line 18: , Database_Object_name ak_regions.DATABASE_OBJECT_NAME%TYPE

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)
22: );

Line 209: ,p_actual_region_code IN ak_regions.REGION_CODE%TYPE

205: PROCEDURE print_Parameter_Table_Values
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: ) ;

Line 281: l_compare_region_appl_id ak_regions.REGION_APPLICATION_ID%TYPE;

277: l_Rpt_Link VARCHAR2(32000); -- 2164190
278: l_return_status1 VARCHAR2(3000); -- 2164190
279: l_error_msg VARCHAR2(32000); -- 2164190
280:
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;

Line 284: l_compare_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;

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

Line 287: l_actual_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;

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

Line 586: l_database_object_name ak_regions.DATABASE_OBJECT_NAME%TYPE;

582: l_object_tbl object_tbl_type;
583: l_object_attribute_tbl object_attribute_tbl_type ;
584: l_Measure_Inst_DB_Obj_tbl Measure_Instance_DB_Obj_Tbl;
585: l_measure_inst_db_obj_tbl_p Measure_Instance_DB_Obj_Tbl;
586: l_database_object_name ak_regions.DATABASE_OBJECT_NAME%TYPE;
587: l_measure_short_name bisbv_performance_measures.measure_short_name%type;
588: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
589: l_target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
590: l_Measure_Instance BIS_MEASURE_PUB.Measure_Instance_type;

Line 601: l_compare_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;

597: l_compare_value NUMBER;
598: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;
599: l_return_status VARCHAR2(32000);
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:

Line 602: l_compare_region_appl_id ak_regions.REGION_APPLICATION_ID%TYPE;

598: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;
599: l_return_status VARCHAR2(32000);
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:

Line 794: l_actual_region_code ak_regions.REGION_CODE%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR;

790: )
791: IS
792:
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:

Line 795: l_actual_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE;

791: IS
792:
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

Line 812: ( pi_region_code ak_regions.REGION_CODE%TYPE

808: WHERE attribute_code = pi_actual_region_item
809: AND region_code = pi_actual_region_code;
810:
811: CURSOR cr_region_objects
812: ( pi_region_code ak_regions.REGION_CODE%TYPE
813: , pi_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE
814: ) IS
815: SELECT *
816: FROM ak_regions

Line 813: , pi_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE

809: AND region_code = pi_actual_region_code;
810:
811: CURSOR cr_region_objects
812: ( pi_region_code ak_regions.REGION_CODE%TYPE
813: , pi_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE
814: ) IS
815: SELECT *
816: FROM ak_regions
817: WHERE region_code = pi_region_code

Line 816: FROM ak_regions

812: ( pi_region_code ak_regions.REGION_CODE%TYPE
813: , pi_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE
814: ) IS
815: SELECT *
816: FROM ak_regions
817: WHERE region_code = pi_region_code
818: AND region_application_id = pi_region_application_id
819: ORDER BY CREATION_DATE asc;
820:

Line 876: l_region_code ak_regions.REGION_CODE%TYPE := FND_API.G_MISS_CHAR;

872: )
873: IS
874:
875: l_object_tbl object_tbl_type;
876: l_region_code ak_regions.REGION_CODE%TYPE := FND_API.G_MISS_CHAR;
877: l_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE;
878:
879: CURSOR cr_region_objects
880: ( p_region_code ak_regions.REGION_CODE%TYPE

Line 877: l_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE;

873: IS
874:
875: l_object_tbl object_tbl_type;
876: l_region_code ak_regions.REGION_CODE%TYPE := FND_API.G_MISS_CHAR;
877: l_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE;
878:
879: CURSOR cr_region_objects
880: ( p_region_code ak_regions.REGION_CODE%TYPE
881: , p_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE

Line 880: ( p_region_code ak_regions.REGION_CODE%TYPE

876: l_region_code ak_regions.REGION_CODE%TYPE := FND_API.G_MISS_CHAR;
877: l_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE;
878:
879: CURSOR cr_region_objects
880: ( p_region_code ak_regions.REGION_CODE%TYPE
881: , p_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE
882: )
883: IS
884: SELECT *

Line 881: , p_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE

877: l_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE;
878:
879: CURSOR cr_region_objects
880: ( p_region_code ak_regions.REGION_CODE%TYPE
881: , p_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE
882: )
883: IS
884: SELECT *
885: FROM ak_regions r

Line 885: FROM ak_regions r

881: , p_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE
882: )
883: IS
884: SELECT *
885: FROM ak_regions r
886: WHERE r.region_code = p_region_code
887: AND r.region_application_id = p_region_application_id
888: ORDER BY CREATION_DATE asc;
889:

Line 997: ( p_region_code ak_regions.REGION_CODE%TYPE

993: l_dimension_level_rec_p BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
994: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
995:
996: CURSOR cr_attribute
997: ( p_region_code ak_regions.REGION_CODE%TYPE
998: , p_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE
999: , p_dimension_level_short_name
1000: bisbv_dimension_levels.DIMENSION_LEVEL_SHORT_NAME%TYPE
1001: )

Line 998: , p_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE

994: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
995:
996: CURSOR cr_attribute
997: ( p_region_code ak_regions.REGION_CODE%TYPE
998: , p_region_application_id ak_regions.REGION_APPLICATION_ID%TYPE
999: , p_dimension_level_short_name
1000: bisbv_dimension_levels.DIMENSION_LEVEL_SHORT_NAME%TYPE
1001: )
1002: IS

Line 1809: l_report_region_code ak_regions.region_code%TYPE; -- l_actual_region_code VARCHAR2(32000);

1805: l_Dim_Level_Value_Rec_oltp BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
1806: l_dimension_level_number NUMBER;
1807:
1808: -- 2841680
1809: l_report_region_code ak_regions.region_code%TYPE; -- l_actual_region_code VARCHAR2(32000);
1810: l_rpt_params fnd_form_functions_vl.parameters%TYPE;
1811: l_error_msg VARCHAR2(1000);
1812:
1813:

Line 2108: l_report_region_code ak_regions.region_code %TYPE;

2104: , x_error_msg OUT NOCOPY VARCHAR2
2105: ) IS
2106: l_num1 NUMBER;
2107: l_num2 NUMBER;
2108: l_report_region_code ak_regions.region_code %TYPE;
2109: l_params fnd_form_functions.parameters%TYPE;
2110: l_web_html_call fnd_form_functions.web_html_call%TYPE;
2111:
2112: BEGIN

Line 3179: ,p_actual_region_code IN ak_regions.REGION_CODE%TYPE

3175: PROCEDURE print_Parameter_Table_Values
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