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_TARGET_PVT dependencies on BIS_DIMENSION_LEVEL_PUB

Line 63: ( p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

59: -- returns the record with the G_MISS_CHAR/G_MISS_NUM replaced
60: -- by null
61: --
62: PROCEDURE SetNULL
63: ( p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
64: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
65: );
66:
67: --

Line 64: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

60: -- by null
61: --
62: PROCEDURE SetNULL
63: ( p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
64: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
65: );
66:
67: --
68: PROCEDURE SetNULL

Line 69: ( p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

65: );
66:
67: --
68: PROCEDURE SetNULL
69: ( p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
70: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
71: )
72: IS
73: BEGIN

Line 70: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

66:
67: --
68: PROCEDURE SetNULL
69: ( p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
70: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
71: )
72: IS
73: BEGIN
74:

Line 2487: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

2483: --
2484: PROCEDURE Retrieve_Measure_Dim_Values
2485: ( p_api_version IN NUMBER
2486: , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
2487: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
2488: , p_User_ID IN NUMBER := NULL
2489: , p_User_Name IN VARCHAR2 := NULL
2490: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
2491: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type

Line 2500: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

2496: --
2497: l_ind2 NUMBER;
2498: l_user_id NUMBER(15);
2499: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
2500: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
2501: l_Measure_Security_Tbl BIS_MEASURE_SECURITY_PUB.Measure_Security_Tbl_Type;
2502: l_Responsibility_Tbl BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_Type;
2503: l_Dim_Level_Value_Tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;
2504: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 2528: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level

2524: , x_return_status => x_return_status
2525: , x_error_Tbl => x_error_Tbl
2526: );
2527: --
2528: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level
2529: ( p_api_version => 1.0
2530: , p_Dimension_Level_Rec => p_Dimension_Level_Rec
2531: , x_Dimension_Level_Rec => l_Dimension_Level_Rec
2532: , x_return_status => x_return_status

Line 3173: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

3169: IS
3170:
3171: l_dimension_level_number NUMBER;
3172: l_target_level_rec BIS_Target_Level_PUB.Target_Level_rec_Type;
3173: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
3174: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
3175: l_dim_level_value_tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;
3176: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3177:

Line 3345: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

3341: IS
3342:
3343: l_dimension_level_number NUMBER;
3344: l_target_level_rec BIS_Target_Level_PUB.Target_Level_rec_Type;
3345: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
3346: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
3347: l_dim_level_value_tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;
3348: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
3349:

Line 3448: l_dim_level_rec BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;

3444: IS
3445: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
3446: l_measure_rec BIS_MEASURE_PUB.MEASURE_REC_TYPE;
3447: l_measure_rec_p BIS_MEASURE_PUB.MEASURE_REC_TYPE;
3448: l_dim_level_rec BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;
3449: l_dim_level_value_rec BIS_DIM_lEVEL_VALUE_PUB.DIM_LEVEL_VALUE_REC_TYPE;
3450: l_target_level_id NUMBER;
3451: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3452: l_target_rec_p BIS_TARGET_PUB.TARGET_REC_TYPE;

Line 3453: l_dim_level_rec_p BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;

3449: l_dim_level_value_rec BIS_DIM_lEVEL_VALUE_PUB.DIM_LEVEL_VALUE_REC_TYPE;
3450: l_target_level_id NUMBER;
3451: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3452: l_target_rec_p BIS_TARGET_PUB.TARGET_REC_TYPE;
3453: l_dim_level_rec_p BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;
3454: l_dim_level_value_rec_p BIS_DIM_lEVEL_VALUE_PUB.DIM_LEVEL_VALUE_REC_TYPE;
3455:
3456: l_dim1_id NUMBER;
3457: l_dim2_id NUMBER;

Line 3496: SELECT level_id , NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_NAME(level_id),name)

3492: l_dim7_level_name VARCHAR2(32000);
3493:
3494:
3495: CURSOR c_dim_lvl(p_dim_level_short_name in varchar2) IS
3496: SELECT level_id , NVL(BIS_DIMENSION_LEVEL_PUB.GET_CUSTOMIZED_NAME(level_id),name)
3497: FROM bis_levels_vl
3498: WHERE short_name=p_dim_level_short_name;
3499:
3500: BEGIN

Line 3574: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

3570: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension1_level_id)= FND_API.G_TRUE) THEN
3571: SetNULL(l_dim_level_rec,l_dim_level_rec);
3572: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension1_level_id;
3573: l_dim_level_rec_p := l_dim_level_rec;
3574: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version
3575: ,p_Dimension_Level_Rec => l_dim_level_rec_p
3576: ,x_Dimension_Level_Rec => l_dim_level_rec
3577: ,x_return_status => x_return_status
3578: ,x_error_Tbl => x_error_tbl

Line 3588: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

3584: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension2_level_id)= FND_API.G_TRUE) THEN
3585: SetNULL(l_dim_level_rec,l_dim_level_rec);
3586: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension2_level_id;
3587: l_dim_level_rec_p := l_dim_level_rec;
3588: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version
3589: ,p_Dimension_Level_Rec => l_dim_level_rec_p
3590: ,x_Dimension_Level_Rec => l_dim_level_rec
3591: ,x_return_status => x_return_status
3592: ,x_error_Tbl => x_error_tbl

Line 3602: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

3598: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension3_level_id)= FND_API.G_TRUE) THEN
3599: SetNULL(l_dim_level_rec,l_dim_level_rec);
3600: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension3_level_id;
3601: l_dim_level_rec_p := l_dim_level_rec;
3602: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version
3603: ,p_Dimension_Level_Rec => l_dim_level_rec_p
3604: ,x_Dimension_Level_Rec => l_dim_level_rec
3605: ,x_return_status => x_return_status
3606: ,x_error_Tbl => x_error_tbl

Line 3616: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

3612: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension4_level_id)= FND_API.G_TRUE) THEN
3613: SetNULL(l_dim_level_rec,l_dim_level_rec);
3614: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension4_level_id;
3615: l_dim_level_rec_p := l_dim_level_rec;
3616: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version
3617: ,p_Dimension_Level_Rec => l_dim_level_rec_p
3618: ,x_Dimension_Level_Rec => l_dim_level_rec
3619: ,x_return_status => x_return_status
3620: ,x_error_Tbl => x_error_tbl

Line 3630: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

3626: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension5_level_id)= FND_API.G_TRUE) THEN
3627: SetNULL(l_dim_level_rec,l_dim_level_rec);
3628: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension5_level_id;
3629: l_dim_level_rec_p := l_dim_level_rec;
3630: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version
3631: ,p_Dimension_Level_Rec => l_dim_level_rec_p
3632: ,x_Dimension_Level_Rec => l_dim_level_rec
3633: ,x_return_status => x_return_status
3634: ,x_error_Tbl => x_error_tbl

Line 3644: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

3640: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension6_level_id)= FND_API.G_TRUE) THEN
3641: SetNULL(l_dim_level_rec,l_dim_level_rec);
3642: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension6_level_id;
3643: l_dim_level_rec_p := l_dim_level_rec;
3644: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version
3645: ,p_Dimension_Level_Rec => l_dim_level_rec_p
3646: ,x_Dimension_Level_Rec => l_dim_level_rec
3647: ,x_return_status => x_return_status
3648: ,x_error_Tbl => x_error_tbl

Line 3658: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

3654: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension7_level_id)= FND_API.G_TRUE) THEN
3655: SetNULL(l_dim_level_rec,l_dim_level_rec);
3656: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension7_level_id;
3657: l_dim_level_rec_p := l_dim_level_rec;
3658: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version
3659: ,p_Dimension_Level_Rec => l_dim_level_rec_p
3660: ,x_Dimension_Level_Rec => l_dim_level_rec
3661: ,x_return_status => x_return_status
3662: ,x_error_Tbl => x_error_tbl