[Home] [Help]
PACKAGE BODY: APPS.BIS_PMV_ACTUAL_PUB
Source
1 package body BIS_PMV_ACTUAL_PUB as
2 /* $Header: BISPACLB.pls 115.14 2003/12/31 10:13:17 ksadagop 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 ) IS
20 BEGIN
21
22 BIS_PMV_ACTUAL_PVT.GET_ACTUAL_VALUE
23 (p_region_code => p_region_code
24 ,p_function_name => p_function_name
25 ,p_user_id => p_user_id
26 ,p_responsibility_id => p_responsibility_id
27 ,p_time_parameter => p_time_parameter
28 ,p_parameters => p_parameters
29 ,p_param_ids => p_param_ids
30 ,p_actual_attribute_code => p_actual_attribute_code
31 ,p_compareto_attribute_code => p_compareto_attribute_code
32 ,x_actual_value => x_actual_value
33 ,x_compareto_value => x_compareto_value
34 ,x_return_status => x_return_status
35 ,x_msg_count => x_msg_count
36 ,x_msg_data => x_msg_data
37 );
38
39 END GET_ACTUAL_VALUE;
40 PROCEDURE GET_ACTUAL_VALUE
41 (p_region_code IN VARCHAR2
42 ,p_function_name IN VARCHAR2 DEFAULT NULL
43 ,p_user_id IN VARCHAR2 DEFAULT NULL
44 ,p_page_id IN VARCHAR2 DEFAULT NULL
45 ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
46 ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
47 ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
48 ,p_param_ids IN VARCHAR2 DEFAULT 'N'
49 ,p_actual_attribute_code IN VARCHAR2
50 ,p_compareto_attribute_code IN VARCHAR2 DEFAULT NULL
51 ,p_ranking_level IN VARCHAR2
52 ,x_actual_value OUT NOCOPY BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE
53 ,x_return_status OUT NOCOPY VARCHAR2
54 ,x_msg_count OUT NOCOPY NUMBER
55 ,x_msg_data OUT NOCOPY VARCHAR2
56 )
57 IS
58 l_msg_data varchar2(32767);
59 BEGIN
60 --IF (fnd_profile.value('BIS_SQL_TRACE') = 'Y') then
61 x_msg_data := 'Invoking Get Actual method.. *';
62 --END IF;
63 BIS_PMV_ACTUAL_PVT.GET_ACTUAL_VALUE
64 (p_region_code => p_region_code
65 ,p_function_name => p_function_name
66 ,p_user_id => p_user_id
67 ,p_page_id => p_page_id
68 ,p_responsibility_id => p_responsibility_id
69 ,p_time_parameter => p_time_parameter
70 ,p_parameters => p_parameters
71 ,p_param_ids => p_param_ids
72 ,p_actual_attribute_code => p_actual_attribute_code
73 ,p_compareto_attribute_code => p_compareto_attribute_code
74 ,p_ranking_level => p_ranking_level
75 ,x_actual_value => x_actual_value
76 ,x_return_status => x_return_status
77 ,x_msg_count => x_msg_count
78 ,x_msg_data => l_msg_data
79 );
80 x_msg_data := x_msg_data || l_msg_data;
81 END;
82
83 PROCEDURE GET_ACTUAL_VALUE
84 (p_region_code IN VARCHAR2
85 ,p_function_name IN VARCHAR2 DEFAULT NULL
86 ,p_user_id IN VARCHAR2 DEFAULT NULL
87 ,p_page_id IN VARCHAR2 DEFAULT NULL
88 ,p_responsibility_id IN VARCHAR2 DEFAULT NULL
89 ,p_time_parameter IN BIS_PMV_ACTUAL_PVT.TIME_PARAMETER_REC_TYPE
90 ,p_parameters IN BIS_PMV_ACTUAL_PVT.PARAMETER_TBL_TYPE
91 ,p_param_ids IN VARCHAR2 DEFAULT 'N'
92 ,p_measure_attribute_codes IN BIS_PMV_ACTUAL_PVT.MEASURE_ATTR_CODES_TYPE
93 ,p_ranking_level IN VARCHAR2
94 ,x_measure_tbl OUT NOCOPY BIS_PMV_ACTUAL_PVT.ACTUAL_VALUE_TBL_TYPE
95 ,x_return_status OUT NOCOPY VARCHAR2
96 ,x_msg_count OUT NOCOPY NUMBER
97 ,x_msg_data OUT NOCOPY VARCHAR2
98 ) IS
99 BEGIN
100 BIS_PMV_ACTUAL_PVT.GET_ACTUAL_VALUE
101 (p_region_code => p_region_code
102 ,p_function_name => p_function_name
103 ,p_user_id => p_user_id
104 ,p_page_id => p_page_id
105 ,p_responsibility_id => p_responsibility_id
106 ,p_time_parameter => p_time_parameter
107 ,p_parameters => p_parameters
108 ,p_param_ids => p_param_ids
109 ,p_measure_attribute_codes => p_measure_attribute_codes
110 ,p_ranking_level => p_ranking_level
111 ,x_measure_tbl => x_measure_tbl
112 ,x_return_status => x_return_status
113 ,x_msg_count => x_msg_count
114 ,x_msg_data => x_msg_data
115 );
116 END;
117
118 END BIS_PMV_ACTUAL_PUB;