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_PMF_REG_SERVICE_PVT dependencies on BIS_TARGET_LEVEL_PUB

Line 179: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type

175: );
176:
177: Procedure Get_current_Target
178: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type
179: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type
180: --, p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
181: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
182: , x_return_status OUT NOCOPY VARCHAR2
183: );

Line 187: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type

183: );
184:
185: Procedure Get_Previous_Target
186: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type
187: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type
188: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
189: , x_return_status OUT NOCOPY VARCHAR2
190: );
191:

Line 195: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type

191:
192:
193: Procedure update_total_time
194: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type
195: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type
196: --, p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
197: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
198: , x_return_status OUT NOCOPY VARCHAR2
199: );

Line 223: , x_target_level_tbl OUT NOCOPY BIS_TARGET_LEVEL_PUB.Target_Level_Tbl_type

219: ,p_parameter6_value IN varchar2 default null
220: ,p_parameter7_level IN varchar2 default null
221: ,p_parameter7_value IN varchar2 default null
222: , p_viewby_level_id IN varchar2 default null
223: , x_target_level_tbl OUT NOCOPY BIS_TARGET_LEVEL_PUB.Target_Level_Tbl_type
224: , x_target_tbl OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
225: , x_return_status OUT NOCOPY VARCHAR2
226: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
227: );

Line 293: ( p_Target_Level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

289: OUT NOCOPY BIS_CONCURRENT_MANAGER_PVT.PMF_Request_rec_Type
290: );
291:
292: PROCEDURE Verify_Target_Level
293: ( p_Target_Level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
294: , p_parameter1_level IN varchar2 default null
295: , p_parameter2_level IN varchar2 default null
296: , p_parameter3_level IN varchar2 default null
297: , p_parameter4_level IN varchar2 default null

Line 302: , x_Target_Level_rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type

298: , p_parameter5_level IN varchar2 default null
299: , p_parameter6_level IN varchar2 default null
300: , p_parameter7_level IN varchar2 default null
301: , p_viewby_level_id IN varchar2 default null
302: , x_Target_Level_rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
303: );
304:
305: PROCEDURE Verify_Target
306: ( p_Target_rec IN BIS_Target_PUB.Target_Rec_Type

Line 318: ( p_Target_Level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

314: , x_Target_rec OUT NOCOPY BIS_Target_PUB.Target_Rec_Type
315: );
316:
317: FUNCTION has_Dimension_Levels
318: ( p_Target_Level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
319: , p_parameter1_level IN varchar2 default null
320: , p_parameter2_level IN varchar2 default null
321: , p_parameter3_level IN varchar2 default null
322: , p_parameter4_level IN varchar2 default null

Line 413: l_target_level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;

409: )
410: IS
411:
412: l_report_data_tbl report_data_tbl_type;
413: l_target_level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
414: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
415: l_dimension_level_number NUMBER;
416: l_param_set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
417: l_param_set_tbl_new BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

Line 436: l_target_level_rec_p BIS_Target_Level_PUB.Target_Level_Rec_Type;

432: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
433: l_measure_short_name VARCHAR2(32000);
434: l_measure_name VARCHAR2(32000);
435: l_Measure_Rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
436: l_target_level_rec_p BIS_Target_Level_PUB.Target_Level_Rec_Type;
437: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
438: l_alert_based_on VARCHAR2(10);
439: BEGIN
440:

Line 973: l_target_level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;

969: ,x_request_id OUT NOCOPY varchar2
970: )
971: IS
972:
973: l_target_level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
974: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
975: l_dimension_level_number NUMBER;
976: l_param_set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
977: l_param_set_tbl_new BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

Line 1212: l_target_level_tbl BIS_TARGET_LEVEL_PUB.Target_Level_Tbl_type;

1208: )
1209: IS
1210:
1211: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;
1212: l_target_level_tbl BIS_TARGET_LEVEL_PUB.Target_Level_Tbl_type;
1213: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1214: l_Alert_Request_rec BIS_ALERT_SERVICE_PVT.Alert_Request_rec_Type;
1215: l_Alert_Request_tbl BIS_ALERT_SERVICE_PVT.Alert_Request_tbl_Type;
1216: l_Concurrent_Request_Tbl BIS_CONCURRENT_MANAGER_PVT.PMF_Request_Tbl_Type;

Line 1690: l_Target_Level_tbl BIS_Target_Level_PUB.Target_Level_Tbl_Type;

1686: )
1687: IS
1688:
1689: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
1690: l_Target_Level_tbl BIS_Target_Level_PUB.Target_Level_Tbl_Type;
1691: l_target_tbl_tmp BIS_TARGET_PUB.Target_Tbl_type;
1692: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;
1693: l_Indicator_Region_Tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
1694:

Line 2067: l_Target_Level_rec BIS_Target_Level_PUB.Target_Level_rec_Type;

2063: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2064: )
2065: IS
2066:
2067: l_Target_Level_rec BIS_Target_Level_PUB.Target_Level_rec_Type;
2068: l_target_tbl_tmp BIS_TARGET_PUB.Target_Tbl_type;
2069: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;
2070: l_target_count NUMBER := 0;
2071: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

Line 2074: l_Target_Level_rec_p BIS_Target_Level_PUB.Target_Level_rec_Type;

2070: l_target_count NUMBER := 0;
2071: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
2072: l_dimension_level_number NUMBER;
2073: l_current_row VARCHAR2(10);
2074: l_Target_Level_rec_p BIS_Target_Level_PUB.Target_Level_rec_Type;
2075: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2076: l_Target_tbl_tmp_p BIS_TARGET_PUB.Target_Tbl_type;
2077: Begin
2078:

Line 2195: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type

2191:
2192:
2193: Procedure Get_Previous_Target
2194: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type
2195: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type
2196: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
2197: , x_return_status OUT NOCOPY VARCHAR2
2198: )
2199: IS

Line 2335: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type

2331:
2332:
2333: Procedure Get_Current_Target
2334: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type
2335: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type
2336: --, p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
2337: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
2338: , x_return_status OUT NOCOPY VARCHAR2
2339: )

Line 2488: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type

2484:
2485:
2486: Procedure update_total_time
2487: ( p_Target_tbl IN BIS_TARGET_PUB.Target_Tbl_type
2488: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_rec_Type
2489: --, p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
2490: , x_target_tbl IN OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
2491: , x_return_status OUT NOCOPY VARCHAR2
2492: )

Line 2866: , x_target_level_tbl OUT NOCOPY BIS_TARGET_LEVEL_PUB.Target_Level_Tbl_type

2862: , p_parameter6_value IN varchar2 default null
2863: , p_parameter7_level IN varchar2 default null
2864: , p_parameter7_value IN varchar2 default null
2865: , p_viewby_level_id IN varchar2 default null
2866: , x_target_level_tbl OUT NOCOPY BIS_TARGET_LEVEL_PUB.Target_Level_Tbl_type
2867: , x_target_tbl OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_type
2868: , x_return_status OUT NOCOPY VARCHAR2
2869: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2870: )

Line 2874: l_Target_Level_tbl BIS_Target_Level_PUB.Target_Level_Tbl_Type;

2870: )
2871: IS
2872:
2873: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
2874: l_Target_Level_tbl BIS_Target_Level_PUB.Target_Level_Tbl_Type;
2875: l_Target_Level_rec BIS_Target_Level_PUB.Target_Level_rec_Type;
2876: l_Target_Level_tbl_tmp BIS_Target_Level_PUB.Target_Level_Tbl_Type;
2877: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;
2878: l_target_rec BIS_TARGET_PUB.Target_rec_type;

Line 2875: l_Target_Level_rec BIS_Target_Level_PUB.Target_Level_rec_Type;

2871: IS
2872:
2873: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
2874: l_Target_Level_tbl BIS_Target_Level_PUB.Target_Level_Tbl_Type;
2875: l_Target_Level_rec BIS_Target_Level_PUB.Target_Level_rec_Type;
2876: l_Target_Level_tbl_tmp BIS_Target_Level_PUB.Target_Level_Tbl_Type;
2877: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;
2878: l_target_rec BIS_TARGET_PUB.Target_rec_type;
2879: l_target_tbl_tmp BIS_TARGET_PUB.Target_Tbl_type;

Line 2876: l_Target_Level_tbl_tmp BIS_Target_Level_PUB.Target_Level_Tbl_Type;

2872:
2873: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
2874: l_Target_Level_tbl BIS_Target_Level_PUB.Target_Level_Tbl_Type;
2875: l_Target_Level_rec BIS_Target_Level_PUB.Target_Level_rec_Type;
2876: l_Target_Level_tbl_tmp BIS_Target_Level_PUB.Target_Level_Tbl_Type;
2877: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;
2878: l_target_rec BIS_TARGET_PUB.Target_rec_type;
2879: l_target_tbl_tmp BIS_TARGET_PUB.Target_Tbl_type;
2880: l_return_status VARCHAR2(32000);

Line 3306: ( p_Target_Level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

3302:
3303: END Form_Parameter_Set;
3304:
3305: PROCEDURE Verify_Target_Level
3306: ( p_Target_Level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
3307: , p_parameter1_level IN varchar2 default null
3308: , p_parameter2_level IN varchar2 default null
3309: , p_parameter3_level IN varchar2 default null
3310: , p_parameter4_level IN varchar2 default null

Line 3315: , x_Target_Level_rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type

3311: , p_parameter5_level IN varchar2 default null
3312: , p_parameter6_level IN varchar2 default null
3313: , p_parameter7_level IN varchar2 default null
3314: , p_viewby_level_id IN varchar2 default null
3315: , x_Target_Level_rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
3316: )
3317: IS
3318:
3319: l_Target_Level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;

Line 3319: l_Target_Level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;

3315: , x_Target_Level_rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
3316: )
3317: IS
3318:
3319: l_Target_Level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
3320: sameViewBy BOOLEAN;
3321: viewByLevelNum NUMBER;
3322: l_viewBy_level_id NUMBER;
3323: l_return_status VARCHAR2(32000);

Line 3326: l_Target_Level_rec_p BIS_Target_Level_PUB.Target_Level_Rec_Type;

3322: l_viewBy_level_id NUMBER;
3323: l_return_status VARCHAR2(32000);
3324: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3325: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
3326: l_Target_Level_rec_p BIS_Target_Level_PUB.Target_Level_Rec_Type;
3327:
3328: BEGIN
3329:
3330: -- if no viewBy, check if target level's

Line 3576: ( p_Target_Level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

3572: END Verify_Target;
3573:
3574:
3575: FUNCTION has_Dimension_Levels
3576: ( p_Target_Level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
3577: , p_parameter1_level IN varchar2 default null
3578: , p_parameter2_level IN varchar2 default null
3579: , p_parameter3_level IN varchar2 default null
3580: , p_parameter4_level IN varchar2 default null