DBA Data[Home] [Help]

APPS.BIS_TARGET_PVT dependencies on BIS_TARGET_LEVEL_PUB

Line 402: , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type

398: -- if information about dimension values are not required, set all_info
399: -- to FALSE.
400: PROCEDURE Retrieve_Targets
401: ( p_api_version IN NUMBER
402: , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
403: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
404: , x_Target_Tbl OUT NOCOPY BIS_TARGET_PUB.Target_Tbl_Type
405: , x_return_status OUT NOCOPY VARCHAR2
406: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 416: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;

412: FROM bisfv_targets bisfv_targets
413: WHERE bisfv_targets.TARGET_LEVEL_ID = p_Target_Level_ID;
414: --
415: l_ind NUMBER := 0;
416: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
417: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
418:
419: --
420: BEGIN

Line 568: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;

564: IS
565: --
566: l_bisfv_targets_rec bisfv_targets%ROWTYPE;
567: l_bisbv_target_levels_rec bisbv_target_levels%ROWTYPE;
568: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
569: l_plan_id NUMBER;
570: l_Business_Plan_Rec BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type;
571: l_org_level_value_id VARCHAR2(250);
572: l_time_level_value_id VARCHAR2(250);

Line 576: l_Target_Level_Rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;

572: l_time_level_value_id VARCHAR2(250);
573: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
574:
575: l_Business_Plan_Rec_p BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type;
576: l_Target_Level_Rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
577: --
578: BEGIN
579:
580: x_target_Rec := p_target_rec;

Line 2486: , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type

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

Line 2499: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;

2495: IS
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;

Line 2519: BIS_TARGET_LEVEL_PUB.Retrieve_Target_Level

2515: ELSE
2516: l_user_id := p_User_ID;
2517: END IF;
2518: --
2519: BIS_TARGET_LEVEL_PUB.Retrieve_Target_Level
2520: ( p_api_version => 1.0
2521: , p_Target_Level_Rec => p_Target_Level_Rec
2522: , p_all_info => FND_API.G_FALSE
2523: , x_Target_Level_Rec => l_Target_Level_Rec

Line 3172: l_target_level_rec BIS_Target_Level_PUB.Target_Level_rec_Type;

3168: )
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;

Line 3344: l_target_level_rec BIS_Target_Level_PUB.Target_Level_rec_Type;

3340: )
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;

Line 3437: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

3433: -- and the Measure Short Name
3434:
3435: PROCEDURE Retrieve_Target_From_ShNms
3436: ( p_api_version IN NUMBER
3437: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
3438: , p_Target_Rec IN BIS_TARGET_PUB.TARGET_REC_TYPE
3439: , x_Target_Level_Rec IN OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
3440: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.TARGET_REC_TYPE
3441: , x_return_status OUT NOCOPY VARCHAR2

Line 3439: , x_Target_Level_Rec IN OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type

3435: PROCEDURE Retrieve_Target_From_ShNms
3436: ( p_api_version IN NUMBER
3437: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
3438: , p_Target_Rec IN BIS_TARGET_PUB.TARGET_REC_TYPE
3439: , x_Target_Level_Rec IN OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
3440: , x_Target_Rec IN OUT NOCOPY BIS_TARGET_PUB.TARGET_REC_TYPE
3441: , x_return_status OUT NOCOPY VARCHAR2
3442: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3443: )

Line 3445: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;

3441: , x_return_status OUT NOCOPY VARCHAR2
3442: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3443: )
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;