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_ACTUAL_PUB

Line 130: , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type

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
132: );
133:
134: FUNCTION Get_Aggregate_Function

Line 160: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type

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
162: ,p_Time_Level_short_name IN VARCHAR
163: ,p_Time_Level_value_id IN VARCHAR
164: ,P_TIME_PARAMETER_REC_TYPE IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE

Line 171: ,x_Actual_Rec IN OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type

167: ,X_TIME_PARAMETER_REC_TYPE IN OUT NOCOPY BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
168: ,x_time_level_id IN OUT NOCOPY NUMBER
169: ,x_Time_Level_short_name IN OUT NOCOPY VARCHAR
170: ,x_Time_Level_value_id IN OUT NOCOPY VARCHAR
171: ,x_Actual_Rec IN OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
172: ,x_count IN OUT NOCOPY NUMBER
173: ,x_return_status OUT NOCOPY VARCHAR2
174: ) ;
175:

Line 243: , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type

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: )
247: IS

Line 265: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;

261:
262: l_actual_value NUMBER;
263: l_compare_value NUMBER;
264:
265: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;
266: l_actual_rec_p BIS_ACTUAL_PUB.Actual_Rec_Type;
267: l_return_status VARCHAR2(32000);
268:
269: l_count NUMBER := 1;

Line 266: l_actual_rec_p BIS_ACTUAL_PUB.Actual_Rec_Type;

262: l_actual_value NUMBER;
263: l_compare_value NUMBER;
264:
265: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;
266: l_actual_rec_p BIS_ACTUAL_PUB.Actual_Rec_Type;
267: l_return_status VARCHAR2(32000);
268:
269: l_count NUMBER := 1;
270: l_count_p NUMBER := 1;

Line 576: , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type

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: )
580: IS

Line 598: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;

594: l_where_clause VARCHAR2(32000);
595: l_group_by_clause VARCHAR2(32000);
596: l_actual_value NUMBER;
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;

Line 2195: , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type

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
2197: )
2198: IS
2199:

Line 2200: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;

2196: , x_return_status OUT NOCOPY VARCHAR2
2197: )
2198: IS
2199:
2200: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;
2201:
2202: BEGIN
2203:
2204: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2232: , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type

2228:
2229: PROCEDURE Validate_Computed_Actual
2230: ( p_api_version IN NUMBER
2231: , p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2232: , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
2233: , x_return_status OUT NOCOPY VARCHAR2
2234: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2235: )
2236: IS

Line 2496: , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type

2492:
2493: PROCEDURE Validate_Required_Fields
2494: ( p_api_version IN NUMBER
2495: , p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2496: , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
2497: , x_return_status OUT NOCOPY VARCHAR2
2498: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2499: )
2500: IS

Line 2513: , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type

2509: END Validate_Required_Fields;
2510:
2511: PROCEDURE Value_ID_Conversion
2512: ( p_api_version IN NUMBER
2513: , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
2514: , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
2515: , x_return_status OUT NOCOPY VARCHAR2
2516: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2517: )

Line 2514: , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type

2510:
2511: PROCEDURE Value_ID_Conversion
2512: ( p_api_version IN NUMBER
2513: , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
2514: , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
2515: , x_return_status OUT NOCOPY VARCHAR2
2516: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2517: )
2518: IS

Line 2524: l_Actual_Rec BIS_ACTUAL_PUB.Actual_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
2526:
2527: x_return_status := FND_API.G_RET_STS_SUCCESS;
2528: l_Actual_Rec := p_Actual_Rec;

Line 2981: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type

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
2983: ,p_Time_Level_short_name IN VARCHAR
2984: ,p_Time_Level_value_id IN VARCHAR
2985: ,P_TIME_PARAMETER_REC_TYPE IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE

Line 2992: ,x_Actual_Rec IN OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type

2988: ,X_TIME_PARAMETER_REC_TYPE IN OUT NOCOPY BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
2989: ,x_time_level_id IN OUT NOCOPY NUMBER
2990: ,x_Time_Level_short_name IN OUT NOCOPY VARCHAR
2991: ,x_Time_Level_value_id IN OUT NOCOPY VARCHAR
2992: ,x_Actual_Rec IN OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
2993: ,x_count IN OUT NOCOPY NUMBER
2994: ,x_return_status OUT NOCOPY VARCHAR2
2995: ) is
2996:

Line 3003: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;

2999: l_TIME_PARAMETER_REC_TYPE BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE;
3000: l_time_level_id NUMBER; -- 2164190
3001: l_Time_Level_short_name VARCHAR2(30); -- 2164190
3002: l_Time_Level_value_id VARCHAR2(80); -- 2164190
3003: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;
3004: l_count NUMBER;
3005: l_DimLevelValueId VARCHAR2(32000);
3006: l_DimLevelValueName VARCHAR2(32000);
3007: l_Actual_DimLevelValueId VARCHAR2(32000);