DBA Data[Home] [Help]

APPS.BIS_TARGET_LEVEL_PVT dependencies on BIS_MEASURE_PUB

Line 76: , p_measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE

72:
73: PROCEDURE Level_Correspond_To_Dim -- Procedure added for 2486702
74: (
75: p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
76: , p_measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE
77: , x_return_status OUT NOCOPY VARCHAR2
78: , x_return_msg OUT NOCOPY VARCHAR2
79: );
80:

Line 98: ( p_measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE

94: RETURN NUMBER;
95:
96:
97: PROCEDURE GET_MEASURE_DIMS_ARRAY -- Procedure added for 2486702
98: ( p_measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE
99: , x_dim_tbl_type OUT NOCOPY dim_tbl_type
100: , x_num_dims OUT NOCOPY NUMBER
101: , x_return_status OUT NOCOPY VARCHAR2
102: , x_return_msg OUT NOCOPY VARCHAR2

Line 372: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;

368:
369: l_target_level_id number;
370:
371: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
372: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
373: l_target_level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
374: l_return_status VARCHAR2(100);
375: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
376: l_Measure_Rec_p BIS_MEASURE_PUB.Measure_Rec_Type;

Line 376: l_Measure_Rec_p BIS_MEASURE_PUB.Measure_Rec_Type;

372: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
373: l_target_level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
374: l_return_status VARCHAR2(100);
375: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
376: l_Measure_Rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
377: l_Dimension_Level_Rec_p BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
378:
379: BEGIN
380: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Measure_ID)

Line 922: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

918: END Create_Target_Level;
919: --
920: PROCEDURE Count_Target_Levels
921: ( p_api_version IN NUMBER
922: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
923: , x_count OUT NOCOPY NUMBER
924: , x_return_status OUT NOCOPY VARCHAR2
925: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
926: )

Line 965: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type

961: -- FALSE
962: PROCEDURE Retrieve_Target_Levels
963: ( p_api_version IN NUMBER
964: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
965: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
966: , x_Target_Level_tbl OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Tbl_Type
967: , x_return_status OUT NOCOPY VARCHAR2
968: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
969: )

Line 3730: l_measure_rec BIS_MEASURE_PUB.MEASURE_REC_TYPE;

3726: , x_return_status OUT NOCOPY VARCHAR2
3727: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3728: )
3729: IS
3730: l_measure_rec BIS_MEASURE_PUB.MEASURE_REC_TYPE;
3731: l_measure_rec_p BIS_MEASURE_PUB.MEASURE_REC_TYPE;
3732: l_dim_level_rec BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;
3733: l_dim_level_rec_p BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;
3734: l_target_level_id NUMBER;

Line 3731: l_measure_rec_p BIS_MEASURE_PUB.MEASURE_REC_TYPE;

3727: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3728: )
3729: IS
3730: l_measure_rec BIS_MEASURE_PUB.MEASURE_REC_TYPE;
3731: l_measure_rec_p BIS_MEASURE_PUB.MEASURE_REC_TYPE;
3732: l_dim_level_rec BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;
3733: l_dim_level_rec_p BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;
3734: l_target_level_id NUMBER;
3735: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 3786: BIS_MEASURE_PUB.RETRIEVE_MEASURE( p_api_version => p_api_version

3782: l_measure_rec.measure_id := p_target_level_rec.measure_id;
3783: END IF;
3784: --Populate the measure record with all the relevant values
3785: l_measure_rec_p := l_measure_rec;
3786: BIS_MEASURE_PUB.RETRIEVE_MEASURE( p_api_version => p_api_version
3787: ,p_measure_rec => l_measure_rec_p
3788: ,p_all_info =>FND_API.G_TRUE
3789: ,x_measure_rec => l_measure_rec
3790: ,x_return_status => x_return_status

Line 4294: l_measure_rec BIS_MEASURE_PUB.MEASURE_REC_TYPE;

4290: x_return_status OUT NOCOPY VARCHAR2,
4291: x_return_msg OUT NOCOPY VARCHAR2
4292: ) IS
4293: l_measure_id NUMBER;
4294: l_measure_rec BIS_MEASURE_PUB.MEASURE_REC_TYPE;
4295: l_measure_rec_p BIS_MEASURE_PUB.MEASURE_REC_TYPE;
4296: l_return_status VARCHAR2(100);
4297: l_return_msg VARCHAR2(3000);
4298: l_level_short_nm bis_levels.short_name%TYPE;

Line 4295: l_measure_rec_p BIS_MEASURE_PUB.MEASURE_REC_TYPE;

4291: x_return_msg OUT NOCOPY VARCHAR2
4292: ) IS
4293: l_measure_id NUMBER;
4294: l_measure_rec BIS_MEASURE_PUB.MEASURE_REC_TYPE;
4295: l_measure_rec_p BIS_MEASURE_PUB.MEASURE_REC_TYPE;
4296: l_return_status VARCHAR2(100);
4297: l_return_msg VARCHAR2(3000);
4298: l_level_short_nm bis_levels.short_name%TYPE;
4299: l_dim_short_nm bis_dimensions.short_name%TYPE;

Line 4365: , p_measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE

4361:
4362: PROCEDURE Level_Correspond_To_Dim -- Procedure added for 2486702
4363: (
4364: p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
4365: , p_measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE
4366: , x_return_status OUT NOCOPY VARCHAR2
4367: , x_return_msg OUT NOCOPY VARCHAR2
4368: ) IS
4369:

Line 4586: ( p_measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE

4582:
4583:
4584:
4585: PROCEDURE GET_MEASURE_DIMS_ARRAY -- Procedure added for 2486702
4586: ( p_measure_rec IN BIS_MEASURE_PUB.MEASURE_REC_TYPE
4587: , x_dim_tbl_type OUT NOCOPY dim_tbl_type
4588: , x_num_dims OUT NOCOPY NUMBER
4589: , x_return_status OUT NOCOPY VARCHAR2
4590: , x_return_msg OUT NOCOPY VARCHAR2