DBA Data[Home] [Help]

APPS.BIS_COMPUTED_ACTUAL_PVT dependencies on BIS_MEASURE_PUB

Line 112: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

108: , x_return_status OUT NOCOPY VARCHAR2
109: );
110:
111: PROCEDURE Save_Report_URL
112: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
113: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
114: , P_TIME_PARAMETER IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
115: , P_PARAMETER IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
116: , p_view_by_level IN VARCHAR2

Line 126: ( p_Measure_Instance IN BIS_MEASURE_PUB.Measure_Instance_type

122: );
123:
124:
125: PROCEDURE Form_Actual_Rec
126: ( p_Measure_Instance IN BIS_MEASURE_PUB.Measure_Instance_type
127: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
128: , p_actual_value IN NUMBER
129: , p_compare_value IN NUMBER
130: , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type

Line 241: , p_Measure_Instance IN BIS_MEASURE_PUB.Measure_Instance_type

237:
238: PROCEDURE Retrieve_Actual_from_PMV
239: ( p_api_version IN NUMBER
240: , p_all_info IN VARCHAR2 Default FND_API.G_TRUE
241: , p_Measure_Instance IN BIS_MEASURE_PUB.Measure_Instance_type
242: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
243: , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
244: , x_return_status OUT NOCOPY VARCHAR2
245: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 253: l_Measure_Instance BIS_MEASURE_PUB.Measure_Instance_type;

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);
257: l_DimLevelShortName VARCHAR2(32000);

Line 574: , p_Measure_Instance IN BIS_MEASURE_PUB.Measure_Instance_type

570: --
571: PROCEDURE Retrieve_Computed_Actual
572: ( p_api_version IN NUMBER
573: , p_all_info IN VARCHAR2 Default FND_API.G_TRUE
574: , p_Measure_Instance IN BIS_MEASURE_PUB.Measure_Instance_type
575: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
576: , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
577: , x_return_status OUT NOCOPY VARCHAR2
578: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 590: l_Measure_Instance BIS_MEASURE_PUB.Measure_Instance_type;

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);
594: l_where_clause VARCHAR2(32000);

Line 1746: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

1742:
1743: END Execute_Query;
1744:
1745: PROCEDURE Save_Report_URL
1746: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
1747: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
1748: , P_TIME_PARAMETER IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
1749: , P_PARAMETER IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
1750: , p_view_by_level IN VARCHAR2

Line 1764: l_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;

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);
1768: l_time_level_id NUMBER;

Line 1765: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_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);
1768: l_time_level_id NUMBER;
1769: l_time_level_short_name VARCHAR2(32000);

Line 1820: BIS_MEASURE_PUB.Retrieve_Measure

1816: --BIS_UTILITIES_PUB.put_line(p_text =>'In Save Reprot' );
1817: l_measure_rec.measure_id := p_measure_instance.measure_id;
1818:
1819: l_measure_rec_p := l_measure_rec;
1820: BIS_MEASURE_PUB.Retrieve_Measure
1821: ( p_api_version => 1.0
1822: , p_measure_rec => l_measure_rec_p
1823: , x_measure_rec => l_measure_rec
1824: , x_return_status => l_return_status

Line 2191: ( p_Measure_Instance IN BIS_MEASURE_PUB.Measure_Instance_type

2187: BIS_UTILITIES_PUB.put_line(p_text =>'Error IN Get_Aggregate_Function: '||sqlerrm);
2188: END;
2189:
2190: PROCEDURE Form_Actual_Rec
2191: ( p_Measure_Instance IN BIS_MEASURE_PUB.Measure_Instance_type
2192: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
2193: , p_actual_value IN NUMBER
2194: , p_compare_value IN NUMBER
2195: , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type