DBA Data[Home] [Help]

APPS.BIS_TARGET_PVT dependencies on BIS_DIM_LEVEL_VALUE_PUB

Line 2490: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type

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
2492: , x_return_status OUT NOCOPY VARCHAR2
2493: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2494: )

Line 2491: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_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
2492: , x_return_status OUT NOCOPY VARCHAR2
2493: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2494: )
2495: IS

Line 2503: l_Dim_Level_Value_Tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;

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;
2505:
2506: --
2507: BEGIN

Line 3164: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type

3160: --
3161: PROCEDURE Retrieve_Time_level_value
3162: ( p_api_version IN NUMBER
3163: , p_Target_Rec IN BIS_Target_PUB.Target_Rec_Type
3164: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
3165: , x_dimension_level_number OUT NOCOPY NUMBER
3166: , x_return_status OUT NOCOPY VARCHAR2
3167: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3168: )

Line 3174: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;

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:
3178:

Line 3175: l_dim_level_value_tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;

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:
3178:
3179: CURSOR cr_tar_dim_value(p_target_id NUMBER) IS

Line 3304: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;

3300: )
3301: IS
3302:
3303: l_Target_Rec BIS_Target_PUB.Target_Rec_Type;
3304: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
3305: l_dimension_level_number NUMBER;
3306: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3307: l_return_status VARCHAR2(32000);
3308:

Line 3336: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type

3332:
3333: PROCEDURE Retrieve_Org_level_value
3334: ( p_api_version IN NUMBER
3335: , p_Target_Rec IN BIS_Target_PUB.Target_Rec_Type
3336: , x_Dim_Level_Value_Rec OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
3337: , x_dimension_level_number OUT NOCOPY NUMBER
3338: , x_return_status OUT NOCOPY VARCHAR2
3339: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3340: )

Line 3346: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;

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:
3350:

Line 3347: l_dim_level_value_tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;

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:
3350:
3351: BEGIN

Line 3449: l_dim_level_value_rec BIS_DIM_lEVEL_VALUE_PUB.DIM_LEVEL_VALUE_REC_TYPE;

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;
3453: l_dim_level_rec_p BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;

Line 3454: l_dim_level_value_rec_p 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;
3458: l_dim3_id NUMBER;