DBA Data[Home] [Help]

APPS.BIS_COMPUTED_ACTUAL_PVT dependencies on BIS_TARGET_LEVEL_PUB

Line 156: ( p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type

152:
153: --
154:
155: PROCEDURE get_Parameters_For_Actual
156: ( p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
157: ,p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
158: ,p_dimension_number IN NUMBER
159: ,p_count IN NUMBER
160: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type

Line 228: p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type

224:
225: --
226:
227: PROCEDURE get_view_by_level (
228: p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
229: , p_Time_Level_short_name IN VARCHAR2
230: , P_PARAMETER_TBL_TYPE IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
231: , x_view_by_level_short_name OUT NOCOPY VARCHAR2
232: , x_return_status OUT NOCOPY VARCHAR2

Line 251: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;

247: IS
248:
249: l_Measure_Inst_DB_Obj_tbl Measure_Instance_DB_Obj_Tbl;
250: l_measure_short_name bisbv_performance_measures.measure_short_name%type;
251: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
252: l_target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
253: l_Measure_Instance BIS_MEASURE_PUB.Measure_Instance_type;
254:
255: l_dim_level_value_tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;

Line 252: l_target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;

248:
249: l_Measure_Inst_DB_Obj_tbl Measure_Instance_DB_Obj_Tbl;
250: l_measure_short_name bisbv_performance_measures.measure_short_name%type;
251: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
252: l_target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
253: l_Measure_Instance BIS_MEASURE_PUB.Measure_Instance_type;
254:
255: l_dim_level_value_tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;
256: l_DimShortName VARCHAR2(32000);

Line 520: p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type

516:
517:
518:
519: PROCEDURE get_view_by_level (
520: p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
521: , p_Time_Level_short_name IN VARCHAR2
522: , P_PARAMETER_TBL_TYPE IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
523: , x_view_by_level_short_name OUT NOCOPY VARCHAR2
524: , x_return_status OUT NOCOPY VARCHAR2

Line 588: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;

584: l_Measure_Inst_DB_Obj_tbl Measure_Instance_DB_Obj_Tbl;
585: l_measure_inst_db_obj_tbl_p Measure_Instance_DB_Obj_Tbl;
586: l_database_object_name ak_regions.DATABASE_OBJECT_NAME%TYPE;
587: l_measure_short_name bisbv_performance_measures.measure_short_name%type;
588: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
589: l_target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
590: l_Measure_Instance BIS_MEASURE_PUB.Measure_Instance_type;
591: l_dim_level_value_tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;
592: l_select_clause VARCHAR2(32000);

Line 589: l_target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;

585: l_measure_inst_db_obj_tbl_p Measure_Instance_DB_Obj_Tbl;
586: l_database_object_name ak_regions.DATABASE_OBJECT_NAME%TYPE;
587: l_measure_short_name bisbv_performance_measures.measure_short_name%type;
588: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
589: l_target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
590: l_Measure_Instance BIS_MEASURE_PUB.Measure_Instance_type;
591: l_dim_level_value_tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;
592: l_select_clause VARCHAR2(32000);
593: l_from_clause VARCHAR2(32000);

Line 1763: l_target_level_rec BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;

1759: l_return_status VARCHAR2(32000);
1760: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1761: l_target_rec BIS_TARGET_PUB.Target_rec_type;
1762: l_dim_level_value_rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
1763: l_target_level_rec BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
1764: l_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;
1765: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
1766: sp VARCHAR2(32);
1767: l_link VARCHAR2(32000);

Line 2522: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;

2518: IS
2519: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
2520: l_dim_level_value_rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
2521: l_Dim_Level_Value_Rec2 BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
2522: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
2523: l_target_level_rec_p BIS_Target_Level_PUB.Target_Level_Rec_Type;
2524: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;
2525: BEGIN
2526:

Line 2523: l_target_level_rec_p BIS_Target_Level_PUB.Target_Level_Rec_Type;

2519: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
2520: l_dim_level_value_rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
2521: l_Dim_Level_Value_Rec2 BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
2522: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
2523: l_target_level_rec_p BIS_Target_Level_PUB.Target_Level_Rec_Type;
2524: l_Actual_Rec BIS_ACTUAL_PUB.Actual_Rec_Type;
2525: BEGIN
2526:
2527: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2977: ( p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type

2973:
2974: --
2975:
2976: PROCEDURE get_Parameters_For_Actual
2977: ( p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
2978: ,p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
2979: ,p_dimension_number IN NUMBER
2980: ,p_count IN NUMBER
2981: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type