1 package BIS_ACTUAL_PUB AUTHID CURRENT_USER AS
2 /* $Header: BISPACVS.pls 115.19 2002/12/20 11:25:53 mahrao ship $ */
3
4
5 TYPE Actual_Rec_Type IS RECORD
6 ( Actual_ID NUMBER
7 ,Target_Level_ID NUMBER
8 ,Target_Level_Name VARCHAR2(100)
9 ,Target_Level_Short_Name VARCHAR2(80)
10 ,Org_Level_value_ID VARCHAR2(250)
11 ,Org_Level_value_Name VARCHAR2(250)
12 ,Time_Level_Value_ID VARCHAR2(250)
13 ,Time_Level_Value_Name VARCHAR2(250)
14 ,Dim1_Level_Value_ID VARCHAR2(250)
15 ,Dim1_Level_Value_Name VARCHAR2(250)
16 ,Dim2_Level_Value_ID VARCHAR2(250)
17 ,Dim2_Level_Value_Name VARCHAR2(250)
18 ,Dim3_Level_Value_ID VARCHAR2(250)
19 ,Dim3_Level_Value_Name VARCHAR2(250)
20 ,Dim4_Level_Value_ID VARCHAR2(250)
21 ,Dim4_Level_Value_Name VARCHAR2(250)
22 ,Dim5_Level_Value_ID VARCHAR2(250)
23 ,Dim5_Level_Value_Name VARCHAR2(250)
24 ,Dim6_level_Value_id VARCHAR2(250)
25 ,Dim6_Level_Value_Name VARCHAR2(250)
26 ,Dim7_Level_Value_ID VARCHAR2(250)
27 ,Dim7_Level_Value_Name VARCHAR2(250)
28 ,Responsibility_ID NUMBER
29 ,Responsibility_Short_Name VARCHAR2(100)
30 ,Responsibility_Name VARCHAR2(240)
31 ,Actual NUMBER
32 ,Report_Url VARCHAR2(2000) -- 1-1enh
33 ,Comparison_actual_value NUMBER -- 1-1enh
34 );
35
36 /*
37 TYPE Actual_Rec_Type IS RECORD
38 ( Target_Level_ID NUMBER := FND_API.G_MISS_NUM
39 ,Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR
40 ,Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR
41 ,Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
42 ,Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
43 ,Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
44 ,Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
45 ,Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
46 ,Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
47 ,Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
48 ,Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
49 ,Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
50 ,Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
51 ,Dim6_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
52 ,Dim6_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
53 ,Dim7_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
54 ,Dim7_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
55 ,Responsibility_ID NUMBER := FND_API.G_MISS_NUM
56 ,Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR
57 ,Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR
58 ,Actual NUMBER := FND_API.G_MISS_NUM
59 );
60 */
61
62 TYPE Actual_Tbl_Type IS TABLE OF Actual_Rec_Type
63 INDEX BY BINARY_INTEGER;
64
65
66 -- Retrieves the KPIs users have selected to monitor on the personal homepage
67 -- or in the summary report. This should be called before calling Post_Actual.
68 PROCEDURE Retrieve_User_Selections
69 ( p_api_version IN NUMBER
70 ,p_Target_Level_Rec
71 IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
72 ,x_Indicator_Region_Tbl
73 OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type
74 ,x_return_status OUT NOCOPY VARCHAR2
75 ,x_msg_count OUT NOCOPY NUMBER
76 ,x_msg_data OUT NOCOPY VARCHAR2
77 ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
78 );
79
80
81 -- Posts actual value into BIS table.
82 PROCEDURE Post_Actual
83 ( p_api_version IN NUMBER
84 ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
85 ,p_commit IN VARCHAR2 Default FND_API.G_FALSE
86 ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
87 ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
88 ,x_return_status OUT NOCOPY VARCHAR2
89 ,x_msg_count OUT NOCOPY NUMBER
90 ,x_msg_data OUT NOCOPY VARCHAR2
91 ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
92 );
93
94 -- Retrieves actual value for the specified set of dimension values
95 -- i.e. for a specific organization, time period, etc.
96 -- If information about dimension values are not required, set all_info
97 -- to FALSE.
98 PROCEDURE Retrieve_Actual
99 ( p_api_version IN NUMBER
100 ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
101 ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
102 ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
103 ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
104 ,x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
105 ,x_return_status OUT NOCOPY VARCHAR2
106 ,x_msg_count OUT NOCOPY NUMBER
107 ,x_msg_data OUT NOCOPY VARCHAR2
108 ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
109 );
110
111
112 -- Retrieves all actual values for the specified Indicator Level
113 -- i.e. all organizations, all time periods, etc.
114 -- If information about dimension values are not required, set all_info
115 -- to FALSE.
116 PROCEDURE Retrieve_Actuals
117 ( p_api_version IN NUMBER
118 ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
119 ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
120 ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
121 ,p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
122 ,x_Actual_Tbl OUT NOCOPY BIS_ACTUAL_PUB.Actual_Tbl_Type
123 ,x_return_status OUT NOCOPY VARCHAR2
124 ,x_msg_count OUT NOCOPY NUMBER
125 ,x_msg_data OUT NOCOPY VARCHAR2
126 ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
127 );
128
129
130 -- Retrieves the most current actual value for the specified set
131 -- of dimension values. (time level value not necessary.)
132 -- If information about dimension values are not required, set all_info
133 -- to FALSE.
134 PROCEDURE Retrieve_Latest_Actual
135 ( p_api_version IN NUMBER
136 ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
137 ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
138 ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
139 ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
140 ,x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
141 ,x_return_status OUT NOCOPY VARCHAR2
142 ,x_msg_count OUT NOCOPY NUMBER
143 ,x_msg_data OUT NOCOPY VARCHAR2
144 ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
145 );
146
147
148 -- Retrieves the most current actual values for the specified Indicator Level
149 -- i.e. for all organizations, etc. (time level value not necessary.)
150 -- If information about dimension values are not required, set all_info
151 -- to FALSE.
152 PROCEDURE Retrieve_Latest_Actuals
153 ( p_api_version IN NUMBER
154 ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
155 ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
156 ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
157 ,p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
158 ,x_Actual_Tbl OUT NOCOPY BIS_ACTUAL_PUB.Actual_Tbl_Type
159 ,x_return_status OUT NOCOPY VARCHAR2
160 ,x_msg_count OUT NOCOPY NUMBER
161 ,x_msg_data OUT NOCOPY VARCHAR2
162 ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
163 );
164
165
166 PROCEDURE Validate_Actual
167 ( p_api_version IN NUMBER
168 , p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
169 , p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
170 , p_event IN VARCHAR2
171 , p_user_id IN NUMBER
172 , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
173 , x_return_status OUT NOCOPY VARCHAR2
174 , x_msg_count OUT NOCOPY NUMBER
175 , x_msg_data OUT NOCOPY VARCHAR2
176 ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
177 );
178
179
180 END BIS_ACTUAL_PUB;