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_PMV_ACTUAL_PVT

Line 114: , P_TIME_PARAMETER IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE

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
118: , p_time_level_value_id IN VARCHAR2

Line 115: , P_PARAMETER IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE

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
118: , p_time_level_value_id IN VARCHAR2
119: , x_Rpt_Link OUT NOCOPY VARCHAR2

Line 164: ,P_TIME_PARAMETER_REC_TYPE IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE

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
165: ,P_PARAMETER_TBL_TYPE IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
166: ,X_PARAMETER_TBL_TYPE IN OUT NOCOPY BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_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

Line 165: ,P_PARAMETER_TBL_TYPE IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_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
165: ,P_PARAMETER_TBL_TYPE IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
166: ,X_PARAMETER_TBL_TYPE IN OUT NOCOPY BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_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

Line 166: ,X_PARAMETER_TBL_TYPE IN OUT NOCOPY BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE

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
165: ,P_PARAMETER_TBL_TYPE IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
166: ,X_PARAMETER_TBL_TYPE IN OUT NOCOPY BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_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

Line 167: ,X_TIME_PARAMETER_REC_TYPE IN OUT NOCOPY BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE

163: ,p_Time_Level_value_id IN VARCHAR
164: ,P_TIME_PARAMETER_REC_TYPE IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
165: ,P_PARAMETER_TBL_TYPE IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
166: ,X_PARAMETER_TBL_TYPE IN OUT NOCOPY BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_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

Line 206: ( P_PARAMETER_TBL_TYPE IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE

202:
203: --
204:
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

Line 207: ,P_TIME_PARAMETER_REC_TYPE IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE

203: --
204:
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

Line 230: , P_PARAMETER_TBL_TYPE IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE

226:
227: PROCEDURE get_view_by_level (
228: p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
229: , p_Time_Level_short_name IN VARCHAR2
230: , P_PARAMETER_TBL_TYPE IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
231: , x_view_by_level_short_name OUT NOCOPY VARCHAR2
232: , x_return_status OUT NOCOPY VARCHAR2
233: ) ;
234:

Line 290: L_PARAMETER_TBL_TYPE BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;

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;
293: l_time_parameter_rec_type_p BIS_PMV_ACTUAL_PVT.time_parameter_rec_type;
294:

Line 291: l_parameter_tbl_type_p BIS_PMV_ACTUAL_PVT.parameter_tbl_type;

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;
293: l_time_parameter_rec_type_p BIS_PMV_ACTUAL_PVT.time_parameter_rec_type;
294:
295: CURSOR cr_performance_measures(pi_measure_short_name VARCHAR2) IS

Line 292: L_TIME_PARAMETER_REC_TYPE BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE;

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;
293: l_time_parameter_rec_type_p BIS_PMV_ACTUAL_PVT.time_parameter_rec_type;
294:
295: CURSOR cr_performance_measures(pi_measure_short_name VARCHAR2) IS
296: SELECT comparison_source, ACTUAL_DATA_SOURCE

Line 293: l_time_parameter_rec_type_p BIS_PMV_ACTUAL_PVT.time_parameter_rec_type;

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;
293: l_time_parameter_rec_type_p BIS_PMV_ACTUAL_PVT.time_parameter_rec_type;
294:
295: CURSOR cr_performance_measures(pi_measure_short_name VARCHAR2) IS
296: SELECT comparison_source, ACTUAL_DATA_SOURCE
297: FROM bisbv_performance_measures

Line 522: , P_PARAMETER_TBL_TYPE IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE

518:
519: PROCEDURE get_view_by_level (
520: p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
521: , p_Time_Level_short_name IN VARCHAR2
522: , P_PARAMETER_TBL_TYPE IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
523: , x_view_by_level_short_name OUT NOCOPY VARCHAR2
524: , x_return_status OUT NOCOPY VARCHAR2
525: ) IS
526:

Line 1748: , P_TIME_PARAMETER IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE

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
1752: , p_time_level_value_id IN VARCHAR2

Line 1749: , P_PARAMETER IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE

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
1752: , p_time_level_value_id IN VARCHAR2
1753: , x_Rpt_Link OUT NOCOPY VARCHAR2

Line 2985: ,P_TIME_PARAMETER_REC_TYPE IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE

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
2986: ,P_PARAMETER_TBL_TYPE IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
2987: ,X_PARAMETER_TBL_TYPE IN OUT NOCOPY BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_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

Line 2986: ,P_PARAMETER_TBL_TYPE IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_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
2986: ,P_PARAMETER_TBL_TYPE IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
2987: ,X_PARAMETER_TBL_TYPE IN OUT NOCOPY BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_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

Line 2987: ,X_PARAMETER_TBL_TYPE IN OUT NOCOPY BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE

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
2986: ,P_PARAMETER_TBL_TYPE IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
2987: ,X_PARAMETER_TBL_TYPE IN OUT NOCOPY BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_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

Line 2988: ,X_TIME_PARAMETER_REC_TYPE IN OUT NOCOPY BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE

2984: ,p_Time_Level_value_id IN VARCHAR
2985: ,P_TIME_PARAMETER_REC_TYPE IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
2986: ,P_PARAMETER_TBL_TYPE IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
2987: ,X_PARAMETER_TBL_TYPE IN OUT NOCOPY BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_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

Line 2998: l_PARAMETER_TBL_TYPE BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE;

2994: ,x_return_status OUT NOCOPY VARCHAR2
2995: ) is
2996:
2997: l_dim_level_id NUMBER;
2998: l_PARAMETER_TBL_TYPE BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_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

Line 2999: l_TIME_PARAMETER_REC_TYPE BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE;

2995: ) is
2996:
2997: l_dim_level_id NUMBER;
2998: l_PARAMETER_TBL_TYPE BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_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;

Line 3176: ( P_PARAMETER_TBL_TYPE IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE

3172:
3173: --
3174:
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

Line 3177: ,P_TIME_PARAMETER_REC_TYPE IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE

3173: --
3174:
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