[Home] [Help]
PACKAGE: APPS.BIS_PMV_ACTUAL_PUB
Source
1 package BIS_PMV_ACTUAL_PUB AUTHID CURRENT_USER as
2 /* $Header: BISPACLS.pls 115.12 2002/11/20 18:51:18 kiprabha noship $ */
3
4 PROCEDURE GET_ACTUAL_VALUE
5 (p_region_code IN VARCHAR2
6 ,p_function_name IN VARCHAR2 DEFAULT NULL
7 ,p_user_id IN VARCHAR2 DEFAULT NULL
8 ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
9 ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
10 ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
11 ,p_param_ids IN VARCHAR2 DEFAULT 'N'
12 ,p_actual_attribute_code IN VARCHAR2
13 ,p_compareto_attribute_code IN VARCHAR2 DEFAULT NULL
14 ,x_actual_value OUT NOCOPY VARCHAR2
15 ,x_compareto_value OUT NOCOPY VARCHAR2
16 ,x_return_status OUT NOCOPY VARCHAR2
17 ,x_msg_count OUT NOCOPY NUMBER
18 ,x_msg_data OUT NOCOPY VARCHAR2
19 );
20 PROCEDURE GET_ACTUAL_VALUE
21 (p_region_code IN VARCHAR2
22 ,p_function_name IN VARCHAR2 DEFAULT NULL
23 ,p_user_id IN VARCHAR2 DEFAULT NULL
24 ,p_page_id IN VARCHAR2 DEFAULT NULL
25 ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
26 ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
27 ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
28 ,p_param_ids IN VARCHAR2 DEFAULT 'N'
29 ,p_actual_attribute_code IN VARCHAR2
30 ,p_compareto_attribute_code IN VARCHAR2 DEFAULT NULL
31 ,p_ranking_level IN VARCHAR2
32 ,x_actual_value OUT NOCOPY BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE
33 ,x_return_status OUT NOCOPY VARCHAR2
34 ,x_msg_count OUT NOCOPY NUMBER
35 ,x_msg_data OUT NOCOPY VARCHAR2
36 );
37 PROCEDURE GET_ACTUAL_VALUE
38 (p_region_code IN VARCHAR2
39 ,p_function_name IN VARCHAR2 DEFAULT NULL
40 ,p_user_id IN VARCHAR2 DEFAULT NULL
41 ,p_page_id IN VARCHAR2 DEFAULT NULL
42 ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
43 ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
44 ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
45 ,p_param_ids IN VARCHAR2 DEFAULT 'N'
46 ,p_measure_attribute_codes IN BIS_PMV_ACTUAL_PVT.MEASURE_ATTR_CODES_TYPE
47 ,p_ranking_level IN VARCHAR2
48 ,x_measure_tbl OUT NOCOPY BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE
49 ,x_return_status OUT NOCOPY VARCHAR2
50 ,x_msg_count OUT NOCOPY NUMBER
51 ,x_msg_data OUT NOCOPY VARCHAR2
52 );
53
54 END BIS_PMV_ACTUAL_PUB;