[Home] [Help]
PACKAGE: APPS.OZF_OFFER_PERFORMANCE_PVT
Source
1 PACKAGE OZF_Offer_Performance_PVT AS
2 /* $Header: ozfvpers.pls 120.0 2005/06/01 02:20:58 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Offer_Performance_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 --===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- offer_perf_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- offer_performance_id
26 -- list_header_id
27 -- last_update_date
28 -- last_updated_by
29 -- creation_date
30 -- created_by
31 -- last_update_login
32 -- object_version_number
33 -- product_attribute_context
34 -- product_attribute
35 -- product_attr_value
36 -- channel_id
37 -- start_date
38 -- end_date
39 -- estimated_value
40 -- required_flag
41 -- attribute_category
42 -- attribute1
43 -- attribute2
44 -- attribute3
45 -- attribute4
46 -- attribute5
47 -- attribute6
48 -- attribute7
49 -- attribute8
50 -- attribute9
51 -- attribute10
52 -- attribute11
53 -- attribute12
54 -- attribute13
55 -- attribute14
56 -- attribute15
57 -- security_group_id
58 -- requirement_type
59 -- uom_code
60 -- description
61 --
62 -- Required
63 --
64 -- Defaults
65 --
66 -- Note: This is automatic generated record definition, it includes all columns
67 -- defined in the table, developer must manually add or delete some of the attributes.
68 --
69 -- End of Comments
70
71 --===================================================================
72 TYPE offer_perf_rec_type IS RECORD
73 (
74 offer_performance_id NUMBER := FND_API.G_MISS_NUM,
75 list_header_id NUMBER := FND_API.G_MISS_NUM,
76 last_update_date DATE := FND_API.G_MISS_DATE,
77 last_updated_by NUMBER := FND_API.G_MISS_NUM,
78 creation_date DATE := FND_API.G_MISS_DATE,
79 created_by NUMBER := FND_API.G_MISS_NUM,
80 last_update_login NUMBER := FND_API.G_MISS_NUM,
81 object_version_number NUMBER := FND_API.G_MISS_NUM,
82 product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR,
83 product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR,
84 product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR,
85 channel_id NUMBER := FND_API.G_MISS_NUM,
86 start_date DATE := FND_API.G_MISS_DATE,
87 end_date DATE := FND_API.G_MISS_DATE,
88 estimated_value NUMBER := FND_API.G_MISS_NUM,
89 required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
90 attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
91 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106 security_group_id NUMBER := FND_API.G_MISS_NUM,
107 requirement_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
108 uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109 description VARCHAR2(4000) := FND_API.G_MISS_CHAR
110 );
111
112 g_miss_offer_perf_rec offer_perf_rec_type;
113 TYPE offer_perf_tbl_type IS TABLE OF offer_perf_rec_type INDEX BY BINARY_INTEGER;
114 g_miss_offer_perf_tbl offer_perf_tbl_type;
115
116
117 -- ==============================================================================
118 -- Start of Comments
119 -- ==============================================================================
120 -- API Name
121 -- Create_Offer_Performance
122 -- Type
123 -- Private
124 -- Pre-Req
125 --
126 -- Parameters
127 --
128 -- IN
129 -- p_api_version_number IN NUMBER Required
130 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
131 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
132 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
133 -- p_offer_perf_rec IN offer_perf_rec_type Required
134 --
135 -- OUT
136 -- x_return_status OUT VARCHAR2
137 -- x_msg_count OUT NUMBER
138 -- x_msg_data OUT VARCHAR2
139 -- Version : Current version 1.0
140 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
141 -- and basic operation, developer must manually add parameters and business logic as necessary.
142 --
143 -- End of Comments
144 -- ==============================================================================
145 --
146
147 PROCEDURE Create_Offer_Performance(
148 p_api_version_number IN NUMBER,
149 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150 p_commit IN VARCHAR2 := FND_API.G_FALSE,
151 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
152
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156
157 p_offer_perf_rec IN offer_perf_rec_type := g_miss_offer_perf_rec,
158 x_offer_performance_id OUT NOCOPY NUMBER
159 );
160
161 -- ==============================================================================
162 -- Start of Comments
163 -- ==============================================================================
164 -- API Name
165 -- Update_Offer_Performance
166 -- Type
167 -- Private
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_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
177 -- p_offer_perf_rec IN offer_perf_rec_type Required
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 Update_Offer_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 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
196
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200
201 p_offer_perf_rec IN offer_perf_rec_type,
202 x_object_version_number OUT NOCOPY NUMBER
203 );
204
205 -- ==============================================================================
206 -- Start of Comments
207 -- ==============================================================================
208 -- API Name
209 -- Delete_Offer_Performance
210 -- Type
211 -- Private
212 -- Pre-Req
213 --
214 -- Parameters
215 --
216 -- IN
217 -- p_api_version_number IN NUMBER Required
218 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
219 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
220 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
221 -- p_OFFER_PERFORMANCE_ID IN NUMBER
222 -- p_object_version_number IN NUMBER Optional Default = NULL
223 --
224 -- OUT
225 -- x_return_status OUT VARCHAR2
226 -- x_msg_count OUT NUMBER
227 -- x_msg_data OUT VARCHAR2
228 -- Version : Current version 1.0
229 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
230 -- and basic operation, developer must manually add parameters and business logic as necessary.
231 --
232 -- End of Comments
233 -- ==============================================================================
234 --
235
236 PROCEDURE Delete_Offer_Performance(
237 p_api_version_number IN NUMBER,
238 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239 p_commit IN VARCHAR2 := FND_API.G_FALSE,
240 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241 x_return_status OUT NOCOPY VARCHAR2,
242 x_msg_count OUT NOCOPY NUMBER,
243 x_msg_data OUT NOCOPY VARCHAR2,
244 p_offer_performance_id IN NUMBER,
245 p_object_version_number IN NUMBER
246 );
247
248 -- ==============================================================================
249 -- Start of Comments
250 -- ==============================================================================
251 -- API Name
252 -- Lock_Offer_Performance
253 -- Type
254 -- Private
255 -- Pre-Req
256 --
257 -- Parameters
258 --
259 -- IN
260 -- p_api_version_number IN NUMBER Required
261 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
262 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
263 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
264 -- p_offer_perf_rec IN offer_perf_rec_type Required
265 --
266 -- OUT
267 -- x_return_status OUT VARCHAR2
268 -- x_msg_count OUT NUMBER
269 -- x_msg_data OUT VARCHAR2
270 -- Version : Current version 1.0
271 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
272 -- and basic operation, developer must manually add parameters and business logic as necessary.
273 --
274 -- End of Comments
275 -- ==============================================================================
276 --
277
278 PROCEDURE Lock_Offer_Performance(
279 p_api_version_number IN NUMBER,
280 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
281
282 x_return_status OUT NOCOPY VARCHAR2,
283 x_msg_count OUT NOCOPY NUMBER,
284 x_msg_data OUT NOCOPY VARCHAR2,
285
286 p_offer_performance_id IN NUMBER,
287 p_object_version IN NUMBER
288 );
289
290
291 -- Start of Comments
292 --
293 -- validation procedures
299 -- 2. We can also validate table instead of record. There will be an option for user to choose.
294 --
295 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
296 -- For create: G_CREATE, for update: G_UPDATE
297 -- Note: 1. This is automated generated item level validation procedure.
298 -- The actual validation detail is needed to be added.
300 -- End of Comments
301
302 PROCEDURE Validate_offer_performance(
303 p_api_version_number IN NUMBER,
304 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
305 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306 p_offer_perf_rec IN offer_perf_rec_type,
307 p_validation_mode IN VARCHAR2,
308 x_return_status OUT NOCOPY VARCHAR2,
309 x_msg_count OUT NOCOPY NUMBER,
310 x_msg_data OUT NOCOPY VARCHAR2
311 );
312
313 -- Start of Comments
314 --
315 -- validation procedures
316 --
317 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
318 -- For create: G_CREATE, for update: G_UPDATE
319 -- Note: 1. This is automated generated item level validation procedure.
320 -- The actual validation detail is needed to be added.
321 -- 2. Validate the unique keys, lookups here
322 -- End of Comments
323
324 PROCEDURE Check_offer_perf_Items (
325 P_offer_perf_rec IN offer_perf_rec_type,
326 p_validation_mode IN VARCHAR2,
327 x_return_status OUT NOCOPY VARCHAR2
328 );
329
330 -- Start of Comments
331 --
332 -- Record level validation procedures
333 --
334 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
335 -- For create: G_CREATE, for update: G_UPDATE
336 -- Note: 1. This is automated generated item level validation procedure.
337 -- The actual validation detail is needed to be added.
338 -- 2. Developer can manually added inter-field level validation.
339 -- End of Comments
340
341 PROCEDURE Validate_offer_perf_rec(
342 p_api_version_number IN NUMBER,
343 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
344 x_return_status OUT NOCOPY VARCHAR2,
345 x_msg_count OUT NOCOPY NUMBER,
346 x_msg_data OUT NOCOPY VARCHAR2,
347 p_offer_perf_rec IN offer_perf_rec_type
348 );
349
350
351 END OZF_Offer_Performance_PVT;