1 PACKAGE AMS_DMPerformance_PUB AUTHID CURRENT_USER AS
2 /* $Header: amspdpfs.pls 115.2 2002/01/07 18:52:09 pkm ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_DMPerformance_PUB
7 -- Purpose
8 --
9 -- History
10 -- 22-Jan-2001 choang Added overload procedure create_performance for
11 -- ODM Accelerator integration.
12 -- 07-Jan-2002 choang Removed security group id
13 --
14 -- NOTE
15 --
16 -- End of Comments
17 -- ===============================================================
18
19 -- Default number of records fetch per call
20 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
21 --===================================================================
22 -- Start of Comments
23 -- -------------------------------------------------------
24 -- Record name
25 -- performance_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- performance_id
29 -- last_update_date
30 -- last_updated_by
31 -- creation_date
32 -- created_by
33 -- last_update_login
34 -- object_version_number
35 -- predicted_value
36 -- actual_value
37 -- evaluated_records
38 -- total_records_predicted
39 -- model_id
40 --
41 -- Required
42 --
43 -- Defaults
44 --
45 -- Note: This is automatic generated record definition, it includes all columns
46 -- defined in the table, developer must manually add or delete some of the attributes.
47 --
48 -- End of Comments
49
50 --===================================================================
51 TYPE performance_rec_type IS RECORD
52 (
53 performance_id NUMBER := FND_API.G_MISS_NUM,
54 last_update_date DATE := FND_API.G_MISS_DATE,
55 last_updated_by NUMBER := FND_API.G_MISS_NUM,
56 creation_date DATE := FND_API.G_MISS_DATE,
57 created_by NUMBER := FND_API.G_MISS_NUM,
58 last_update_login NUMBER := FND_API.G_MISS_NUM,
59 object_version_number NUMBER := FND_API.G_MISS_NUM,
60 predicted_value VARCHAR2(100) := FND_API.G_MISS_CHAR,
61 actual_value VARCHAR2(100) := FND_API.G_MISS_CHAR,
62 evaluated_records NUMBER := FND_API.G_MISS_NUM,
63 total_records_predicted NUMBER := FND_API.G_MISS_NUM,
64 model_id NUMBER := FND_API.G_MISS_NUM
65 );
66
67 g_miss_performance_rec performance_rec_type;
68 TYPE performance_tbl_type IS TABLE OF performance_rec_type INDEX BY BINARY_INTEGER;
69 g_miss_performance_tbl performance_tbl_type;
70
71 TYPE performance_sort_rec_type IS RECORD
72 (
73 -- Please define your own sort by record here.
74 last_update_date NUMBER := NULL
75 );
76
77 -- ==============================================================================
78 -- Start of Comments
79 -- ==============================================================================
80 -- API Name
81 -- Create_Performance
82 -- Type
83 -- Public
84 -- Pre-Req
85 --
86 -- Parameters
87 --
88 -- IN
89 -- p_api_version_number IN NUMBER Required
90 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
91 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
92 -- p_performance_rec IN performance_rec_type Required
93 --
94 -- OUT
95 -- x_return_status OUT VARCHAR2
96 -- x_msg_count OUT NUMBER
97 -- x_msg_data OUT VARCHAR2
98 -- Version : Current version 1.0
99 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
100 -- and basic operation, developer must manually add parameters and business logic as necessary.
101 --
102 -- End of Comments
103 -- ==============================================================================
104 --
105
106 PROCEDURE Create_Performance(
107 p_api_version_number IN NUMBER,
108 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109 p_commit IN VARCHAR2 := FND_API.G_FALSE,
110
111 x_return_status OUT VARCHAR2,
112 x_msg_count OUT NUMBER,
113 x_msg_data OUT VARCHAR2,
114
115 p_performance_rec IN performance_rec_type := g_miss_performance_rec,
116 x_performance_id OUT NUMBER
117 );
118
119 -- ==============================================================================
120 -- Start of Comments
121 -- ==============================================================================
122 -- API Name
123 -- Update_Performance
124 -- Type
125 -- Public
126 -- Pre-Req
127 --
128 -- Parameters
129 --
130 -- IN
131 -- p_api_version_number IN NUMBER Required
132 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
133 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
134 -- p_performance_rec IN performance_rec_type Required
135 --
136 -- OUT
137 -- x_return_status OUT VARCHAR2
138 -- x_msg_count OUT NUMBER
139 -- x_msg_data OUT VARCHAR2
140 -- Version : Current version 1.0
141 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
142 -- and basic operation, developer must manually add parameters and business logic as necessary.
143 --
144 -- End of Comments
145 -- ==============================================================================
146 --
147
148 PROCEDURE Update_Performance(
149 p_api_version_number IN NUMBER,
150 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
151 p_commit IN VARCHAR2 := FND_API.G_FALSE,
152
153 x_return_status OUT VARCHAR2,
154 x_msg_count OUT NUMBER,
155 x_msg_data OUT VARCHAR2,
156
157 p_performance_rec IN performance_rec_type,
158 x_object_version_number OUT NUMBER
159 );
160
161 -- ==============================================================================
162 -- Start of Comments
163 -- ==============================================================================
164 -- API Name
165 -- Delete_Performance
166 -- Type
167 -- Public
168 -- Pre-Req
169 --
170 -- Parameters
171 --
172 -- IN
173 -- p_api_version_number IN NUMBER Required
174 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
175 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
176 -- p_PERFORMANCE_ID IN NUMBER
177 -- p_object_version_number IN NUMBER Optional Default = NULL
178 --
179 -- OUT
180 -- x_return_status OUT VARCHAR2
181 -- x_msg_count OUT NUMBER
182 -- x_msg_data OUT VARCHAR2
183 -- Version : Current version 1.0
184 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
185 -- and basic operation, developer must manually add parameters and business logic as necessary.
186 --
187 -- End of Comments
188 -- ==============================================================================
189 --
190
191 PROCEDURE Delete_Performance(
192 p_api_version_number IN NUMBER,
193 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
194 p_commit IN VARCHAR2 := FND_API.G_FALSE,
195 x_return_status OUT VARCHAR2,
196 x_msg_count OUT NUMBER,
197 x_msg_data OUT VARCHAR2,
198 p_performance_id IN NUMBER,
199 p_object_version_number IN NUMBER
200 );
201
202 -- ==============================================================================
203 -- Start of Comments
204 -- ==============================================================================
205 -- API Name
206 -- Lock_Performance
207 -- Type
208 -- Public
209 -- Pre-Req
210 --
211 -- Parameters
212 --
213 -- IN
214 -- p_api_version_number IN NUMBER Required
215 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
216 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
217 -- p_performance_rec IN performance_rec_type Required
218 --
219 -- OUT
220 -- x_return_status OUT VARCHAR2
221 -- x_msg_count OUT NUMBER
222 -- x_msg_data OUT VARCHAR2
223 -- Version : Current version 1.0
224 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
225 -- and basic operation, developer must manually add parameters and business logic as necessary.
226 --
227 -- End of Comments
228 -- ==============================================================================
229 --
230
231 PROCEDURE Lock_Performance(
232 p_api_version_number IN NUMBER,
233 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234 x_return_status OUT VARCHAR2,
235 x_msg_count OUT NUMBER,
236 x_msg_data OUT VARCHAR2,
237
238 p_performance_id IN NUMBER,
239 p_object_version IN NUMBER
240 );
241
242
243 -- ==============================================================================
244 -- Start of Comments
245 -- ==============================================================================
246 -- API Name
247 -- Create_Performance
248 -- Type
249 -- Public
250 -- Pre-Req
251 --
252 -- Parameters
253 --
254 -- IN
255 -- p_model_id IN NUMBER
256 -- p_predicted_value IN VARCHAR2
257 -- p_actual_value IN VARCHAR2
258 -- p_evaluated_records IN NUMBER
259 -- p_total_records_predicted IN NUMBER
260 --
261 -- OUT
262 -- x_performance_id OUT NUMBER
263 -- x_return_status OUT VARCHAR2
264 --
265 -- End of Comments
266 -- ==============================================================================
267 PROCEDURE Create_Performance (
268 p_model_id IN NUMBER,
269 p_predicted_value IN VARCHAR2,
270 p_actual_value IN VARCHAR2,
271 p_evaluated_records IN NUMBER,
272 p_total_records_predicted IN NUMBER,
273 x_performance_id OUT NUMBER,
274 x_return_status OUT VARCHAR2
275 );
276
278 END AMS_DMPerformance_PUB;
277