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 BIS_DIM_LEVEL_VALUE_PUB

Line 38: , p_dim_level_value_Tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

34: );
35:
36: PROCEDURE Get_Object_Attributes
37: ( p_measure_short_name IN VARCHAR2
38: , p_dim_level_value_Tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
39: , p_object_tbl IN object_tbl_type
40: , p_compare_region_item IN VARCHAR2
41: , p_compare_region_code IN VARCHAR2
42: , x_object_attribute_tbl OUT NOCOPY object_attribute_tbl_type

Line 54: ( p_dim_level_value_Tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

50: , x_return_status OUT NOCOPY VARCHAR2
51: );
52:
53: PROCEDURE Get_dimension_level_values
54: ( p_dim_level_value_Tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
55: , p_Measure_Inst_DB_Obj_tbl IN Measure_Instance_DB_Obj_Tbl
56: , x_Measure_Inst_DB_Obj_tbl OUT NOCOPY Measure_Instance_DB_Obj_Tbl
57: , x_return_status OUT NOCOPY VARCHAR2
58: );

Line 113: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

109: );
110:
111: PROCEDURE Save_Report_URL
112: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
113: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
114: , P_TIME_PARAMETER IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
115: , P_PARAMETER IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
116: , p_view_by_level IN VARCHAR2
117: , p_time_level_id IN NUMBER

Line 127: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

123:
124:
125: PROCEDURE Form_Actual_Rec
126: ( p_Measure_Instance IN BIS_MEASURE_PUB.Measure_Instance_type
127: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
128: , p_actual_value IN NUMBER
129: , p_compare_value IN NUMBER
130: , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
131: , x_return_status OUT NOCOPY VARCHAR2

Line 145: ( p_dim_level_value_Tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

141:
142: --
143:
144: PROCEDURE Get_dimension_level_value
145: ( p_dim_level_value_Tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
146: , p_dim_level_id IN VARCHAR2
147: , p_count IN NUMBER
148: , x_dimension_level_value_id OUT NOCOPY VARCHAR2
149: , x_dimension_level_value_NAME OUT NOCOPY VARCHAR2

Line 157: ,p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

153: --
154:
155: PROCEDURE get_Parameters_For_Actual
156: ( p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
157: ,p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
158: ,p_dimension_number IN NUMBER
159: ,p_count IN NUMBER
160: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
161: ,p_time_level_id IN NUMBER

Line 242: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

238: PROCEDURE Retrieve_Actual_from_PMV
239: ( p_api_version IN NUMBER
240: , p_all_info IN VARCHAR2 Default FND_API.G_TRUE
241: , p_Measure_Instance IN BIS_MEASURE_PUB.Measure_Instance_type
242: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
243: , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
244: , x_return_status OUT NOCOPY VARCHAR2
245: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
246: )

Line 255: l_dim_level_value_tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;

251: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
252: l_target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
253: l_Measure_Instance BIS_MEASURE_PUB.Measure_Instance_type;
254:
255: l_dim_level_value_tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;
256: l_DimShortName VARCHAR2(32000);
257: l_DimLevelShortName VARCHAR2(32000);
258:
259: l_DimLevelValueId VARCHAR2(32000);

Line 575: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

571: PROCEDURE Retrieve_Computed_Actual
572: ( p_api_version IN NUMBER
573: , p_all_info IN VARCHAR2 Default FND_API.G_TRUE
574: , p_Measure_Instance IN BIS_MEASURE_PUB.Measure_Instance_type
575: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
576: , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
577: , x_return_status OUT NOCOPY VARCHAR2
578: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
579: )

Line 591: l_dim_level_value_tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_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;
591: l_dim_level_value_tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;
592: l_select_clause VARCHAR2(32000);
593: l_from_clause VARCHAR2(32000);
594: l_where_clause VARCHAR2(32000);
595: l_group_by_clause VARCHAR2(32000);

Line 981: , p_dim_level_value_Tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

977: END Get_Object_Data_Source;
978:
979: PROCEDURE Get_Object_Attributes
980: ( p_measure_short_name IN VARCHAR2
981: , p_dim_level_value_Tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
982: , p_object_tbl IN object_tbl_type
983: , p_compare_region_item IN VARCHAR2
984: , p_compare_region_code IN VARCHAR2
985: , x_object_attribute_tbl OUT NOCOPY object_attribute_tbl_type

Line 991: l_dim_level_value_Tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;

987: )
988: IS
989:
990: l_object_attribute_tbl object_attribute_tbl_type ;
991: l_dim_level_value_Tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;
992: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_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:

Line 1198: ( p_dim_level_value_Tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

1194: END Get_Obj_Attribute_Data_Source;
1195:
1196:
1197: PROCEDURE Get_dimension_level_value
1198: ( p_dim_level_value_Tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
1199: , p_dim_level_id IN VARCHAR2
1200: , p_count IN NUMBER
1201: , x_dimension_level_value_id OUT NOCOPY VARCHAR2
1202: , x_dimension_level_value_NAME OUT NOCOPY VARCHAR2

Line 1209: l_dim_level_value_rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;

1205: IS
1206:
1207: l_dim_level_value_id VARCHAR2(80) := NULL;
1208: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1209: l_dim_level_value_rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
1210: l_dim_level_value_rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
1211:
1212: BEGIN
1213: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1210: l_dim_level_value_rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;

1206:
1207: l_dim_level_value_id VARCHAR2(80) := NULL;
1208: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1209: l_dim_level_value_rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
1210: l_dim_level_value_rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
1211:
1212: BEGIN
1213: x_return_status := FND_API.G_RET_STS_SUCCESS;
1214:

Line 1254: ( p_dim_level_value_Tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

1250: END Get_dimension_level_value;
1251:
1252:
1253: PROCEDURE Get_dimension_level_values
1254: ( p_dim_level_value_Tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
1255: , p_Measure_Inst_DB_Obj_tbl IN Measure_Instance_DB_Obj_Tbl
1256: , x_Measure_Inst_DB_Obj_tbl OUT NOCOPY Measure_Instance_DB_Obj_Tbl
1257: , x_return_status OUT NOCOPY VARCHAR2
1258: )

Line 1262: l_dim_level_value_Tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;

1258: )
1259: IS
1260:
1261: l_Measure_Inst_DB_Obj_tbl Measure_Instance_DB_Obj_Tbl ;
1262: l_dim_level_value_Tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;
1263: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1264: l_dimension_level_rec_p BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1265: l_time_dimension_level_tbl BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type;
1266: l_time_dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

Line 1747: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

1743: END Execute_Query;
1744:
1745: PROCEDURE Save_Report_URL
1746: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
1747: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
1748: , P_TIME_PARAMETER IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
1749: , P_PARAMETER IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
1750: , p_view_by_level IN VARCHAR2
1751: , p_time_level_id IN NUMBER

Line 1762: l_dim_level_value_rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;

1758:
1759: l_return_status VARCHAR2(32000);
1760: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1761: l_target_rec BIS_TARGET_PUB.Target_rec_type;
1762: l_dim_level_value_rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
1763: l_target_level_rec BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
1764: l_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;
1765: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
1766: sp VARCHAR2(32);

Line 1774: l_dim_level_value_tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;

1770: l_time_level_name VARCHAR2(32000);
1771: l_time_level_value VARCHAR2(32000);
1772: l_FROM VARCHAR2(32000);
1773: l_to VARCHAR2(32000);
1774: l_dim_level_value_tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;
1775: l_dimlevel_short_name VARCHAR2(32000);
1776: l_select_String VARCHAR2(32000);
1777: l_table_name VARCHAR2(32000);
1778: l_value_name VARCHAR2(32000);

Line 1805: l_Dim_Level_Value_Rec_oltp BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;

1801: l_save_report_URL EXCEPTION;
1802:
1803: l_Org_Level_Value_ID VARCHAR2(40);-- := '204';
1804: l_Org_Level_Short_name VARCHAR2(40);
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);

Line 2192: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

2188: END;
2189:
2190: PROCEDURE Form_Actual_Rec
2191: ( p_Measure_Instance IN BIS_MEASURE_PUB.Measure_Instance_type
2192: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
2193: , p_actual_value IN NUMBER
2194: , p_compare_value IN NUMBER
2195: , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
2196: , x_return_status OUT NOCOPY VARCHAR2

Line 2519: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;

2515: , x_return_status OUT NOCOPY VARCHAR2
2516: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2517: )
2518: IS
2519: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
2520: l_dim_level_value_rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
2521: l_Dim_Level_Value_Rec2 BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
2522: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
2523: l_target_level_rec_p BIS_Target_Level_PUB.Target_Level_Rec_Type;

Line 2520: l_dim_level_value_rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;

2516: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2517: )
2518: IS
2519: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
2520: l_dim_level_value_rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
2521: l_Dim_Level_Value_Rec2 BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
2522: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
2523: l_target_level_rec_p BIS_Target_Level_PUB.Target_Level_Rec_Type;
2524: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;

Line 2521: l_Dim_Level_Value_Rec2 BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;

2517: )
2518: IS
2519: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
2520: l_dim_level_value_rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
2521: l_Dim_Level_Value_Rec2 BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
2522: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
2523: l_target_level_rec_p BIS_Target_Level_PUB.Target_Level_Rec_Type;
2524: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;
2525: BEGIN

Line 2978: ,p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

2974: --
2975:
2976: PROCEDURE get_Parameters_For_Actual
2977: ( p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
2978: ,p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
2979: ,p_dimension_number IN NUMBER
2980: ,p_count IN NUMBER
2981: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
2982: ,p_time_level_id IN NUMBER