[Home] [Help]
PACKAGE: APPS.OZF_OFFER_ADJ_LINE_PVT
Source
1 PACKAGE OZF_Offer_Adj_Line_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvoals.pls 120.2 2006/05/22 19:03:50 rssharma noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Offer_Adj_Line_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
16 -- Mon May 22 2006:12/0 PM RSSHARMA Expose debug_message method
17 -- End of Comments
18 -- ===============================================================
19
20 -- Default number of records fetch per call
21 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
22 --===================================================================
23 -- Start of Comments
24 -- -------------------------------------------------------
25 -- Record name
26 -- offadj_line_rec_type
27 -- -------------------------------------------------------
28 -- Parameters:
29 -- offer_adjustment_line_id
30 -- offer_adjustment_id
31 -- list_line_id
32 -- arithmetic_operator
33 -- original_discount
34 -- modified_discount
35 -- last_update_date
36 -- last_updated_by
37 -- creation_date
38 -- created_by
39 -- last_update_login
40 -- object_version_number
41 -- list_header_id
42 -- accrual_flag
43 -- list_line_id_td
44 -- original_discount_td
45 -- modified_discount_td
46 -- quantity
47 --
48 -- Required
49 --
50 -- Defaults
51 --
52 -- Note: This is automatic generated record definition, it includes all columns
53 -- defined in the table, developer must manually add or delete some of the attributes.
54 --
55 -- End of Comments
56
57 --===================================================================
58 TYPE offadj_line_rec_type IS RECORD
59 (
60 offer_adjustment_line_id NUMBER,
61 offer_adjustment_id NUMBER,
62 list_line_id NUMBER,
63 arithmetic_operator VARCHAR2(30),
64 original_discount NUMBER,
65 modified_discount NUMBER,
66 last_update_date DATE,
67 last_updated_by NUMBER,
68 creation_date DATE,
69 created_by NUMBER,
70 last_update_login NUMBER,
71 object_version_number NUMBER,
72 list_header_id NUMBER,
73 accrual_flag VARCHAR2(1),
74 list_line_id_td NUMBER,
75 original_discount_td NUMBER,
76 modified_discount_td NUMBER,
77 quantity NUMBER,
78 created_from_adjustments VARCHAR2(1),
79 discount_end_date DATE
80 );
81
82 g_miss_offadj_line_rec offadj_line_rec_type := NULL;
83 TYPE offadj_line_tbl_type IS TABLE OF offadj_line_rec_type INDEX BY BINARY_INTEGER;
84 g_miss_offadj_line_tbl offadj_line_tbl_type;
85
86
87
88 TYPE offadj_new_line_rec_type IS RECORD
89 (
90 offer_adjustment_line_id NUMBER,
91 offer_adjustment_id NUMBER,
92 list_header_id NUMBER,
93 list_line_id NUMBER,
94 list_line_type_code VARCHAR2(30),
95 operand NUMBER,
96 arithmetic_operator VARCHAR2(30),
97 product_attr VARCHAR2(30),
98 product_attr_val VARCHAR2(240),
99 product_uom_code VARCHAR2(30),
100 pricing_attr VARCHAR2(30),
101 pricing_attr_value_from VARCHAR2(240),
102 pricing_attr_value_to VARCHAR2(240),
103 pricing_attribute_id NUMBER,
104 order_value_from NUMBER,
105 order_value_to NUMBER,
106 qualifier_id NUMBER,
107 inactive_flag VARCHAR2(1),
108 max_qty_per_order_id NUMBER,
109 max_qty_per_customer_id NUMBER,
110 max_qty_per_rule_id NUMBER,
111 max_orders_per_customer_id NUMBER,
112 max_amount_per_rule_id NUMBER,
113 qd_arithmetic_operator VARCHAR2(30),
114 qd_operand NUMBER,
115 qd_estimated_qty_is_max VARCHAR2(1),
116 qd_estimated_amount_is_max VARCHAR2(1),
117 price_by_formula_id NUMBER,
118 operation VARCHAR2(30),
119 benefit_price_list_line_id NUMBER,
120 benefit_uom_code VARCHAR2(30),
121 benefit_qty NUMBER,
122 last_update_date DATE,
123 last_updated_by NUMBER,
124 creation_date DATE,
125 created_by NUMBER,
126 last_update_login NUMBER,
127 object_version_number NUMBER,
128 start_date_active DATE,
129 end_date_active DATE,
130 attribute1 VARCHAR2(240),
131 attribute2 VARCHAR2(240),
132 attribute3 VARCHAR2(240),
133 attribute4 VARCHAR2(240),
134 attribute5 VARCHAR2(240),
135 attribute6 VARCHAR2(240),
136 attribute7 VARCHAR2(240),
137 attribute8 VARCHAR2(240),
138 attribute9 VARCHAR2(240),
139 attribute10 VARCHAR2(240),
140 attribute11 VARCHAR2(240),
141 attribute12 VARCHAR2(240),
142 attribute13 VARCHAR2(240),
143 attribute14 VARCHAR2(240),
144 attribute15 VARCHAR2(240),
145 context VARCHAR2(30),
146 discount_end_date DATE
147 );
148 g_miss_offadj_new_line_rec offadj_new_line_rec_type := NULL;
149 TYPE offadj_New_line_tbl_type IS TABLE OF offadj_new_line_rec_type INDEX BY BINARY_INTEGER;
150
151
152 -- ==============================================================================
153 -- Start of Comments
154 -- ==============================================================================
155 -- API Name
156 -- Create_Offer_Adj_Line
157 -- Type
158 -- Private
159 -- Pre-Req
160 --
161 -- Parameters
162 --
163 -- IN
164 -- p_api_version_number IN NUMBER Required
165 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
166 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
167 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
168 -- p_offadj_line_rec IN offadj_line_rec_type Required
169 --
170 -- OUT
171 -- x_return_status OUT VARCHAR2
172 -- x_msg_count OUT NUMBER
173 -- x_msg_data OUT VARCHAR2
174 -- Version : Current version 1.0
175 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
176 -- and basic operation, developer must manually add parameters and business logic as necessary.
177 --
178 -- History
179 --
180 -- NOTE
181 --
182 -- End of Comments
183 -- ==============================================================================
184
185 PROCEDURE Create_Offer_Adj_Line(
186 p_api_version_number IN NUMBER,
187 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188 p_commit IN VARCHAR2 := FND_API.G_FALSE,
189 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
190
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_msg_data OUT NOCOPY VARCHAR2,
194
195 p_offadj_line_rec IN offadj_line_rec_type := g_miss_offadj_line_rec,
196 x_offer_adjustment_line_id OUT NOCOPY NUMBER
197 );
198
199
200 PROCEDURE Create_New_Offer_Adj_Line(
201 p_api_version_number IN NUMBER,
202 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203 p_commit IN VARCHAR2 := FND_API.G_FALSE,
204 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209
210 -- p_offadj_line_rec IN offadj_line_rec_type := g_miss_offadj_line_rec,
211 p_list_line_rec IN offadj_new_line_rec_type := g_miss_offadj_new_line_rec,
212 x_offer_adjustment_line_id OUT NOCOPY NUMBER
213 );
214
215 -- ==============================================================================
216 -- Start of Comments
217 -- ==============================================================================
218 -- API Name
219 -- Update_Offer_Adj_Line
220 -- Type
221 -- Private
222 -- Pre-Req
223 --
224 -- Parameters
225 --
226 -- IN
227 -- p_api_version_number IN NUMBER Required
228 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
229 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
230 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
231 -- p_offadj_line_rec IN offadj_line_rec_type Required
232 --
233 -- OUT
234 -- x_return_status OUT VARCHAR2
235 -- x_msg_count OUT NUMBER
236 -- x_msg_data OUT VARCHAR2
237 -- Version : Current version 1.0
238 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
239 -- and basic operation, developer must manually add parameters and business logic as necessary.
240 --
241 -- History
242 --
243 -- NOTE
244 --
245 -- End of Comments
246 -- ==============================================================================
247
248 PROCEDURE Update_Offer_Adj_Line(
249 p_api_version_number IN NUMBER,
250 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
251 p_commit IN VARCHAR2 := FND_API.G_FALSE,
252 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
253
254 x_return_status OUT NOCOPY VARCHAR2,
255 x_msg_count OUT NOCOPY NUMBER,
256 x_msg_data OUT NOCOPY VARCHAR2,
257
258 p_offadj_line_rec IN offadj_line_rec_type,
259 x_object_version_number OUT NOCOPY NUMBER
260 );
261
262
263 PROCEDURE Update_New_Offer_Adj_Line(
264 p_api_version_number IN NUMBER,
265 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
266 p_commit IN VARCHAR2 := FND_API.G_FALSE,
267 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268
269 x_return_status OUT NOCOPY VARCHAR2,
270 x_msg_count OUT NOCOPY NUMBER,
271 x_msg_data OUT NOCOPY VARCHAR2,
272
273 -- p_offadj_line_rec IN offadj_line_rec_type,
274 p_list_line_rec IN offadj_new_line_rec_type,
275 x_object_version_number OUT NOCOPY NUMBER
276 );
277
278 -- ==============================================================================
279 -- Start of Comments
280 -- ==============================================================================
281 -- API Name
282 -- Delete_Offer_Adj_Line
283 -- Type
284 -- Private
285 -- Pre-Req
286 --
287 -- Parameters
288 --
289 -- IN
290 -- p_api_version_number IN NUMBER Required
291 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
292 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
293 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
294 -- p_offer_adjustment_line_id IN NUMBER
295 -- p_object_version_number IN NUMBER Optional Default = NULL
296 --
297 -- OUT
298 -- x_return_status OUT VARCHAR2
299 -- x_msg_count OUT NUMBER
300 -- x_msg_data OUT VARCHAR2
301 -- Version : Current version 1.0
302 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
303 -- and basic operation, developer must manually add parameters and business logic as necessary.
304 --
305 -- History
306 --
307 -- NOTE
308 --
309 -- End of Comments
310 -- ==============================================================================
311
312 PROCEDURE Delete_Offer_Adj_Line(
313 p_api_version_number IN NUMBER,
314 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
315 p_commit IN VARCHAR2 := FND_API.G_FALSE,
316 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
317 x_return_status OUT NOCOPY VARCHAR2,
318 x_msg_count OUT NOCOPY NUMBER,
319 x_msg_data OUT NOCOPY VARCHAR2,
320 p_offer_adjustment_line_id IN NUMBER,
321 p_object_version_number IN NUMBER
322 );
323
324 -- ==============================================================================
325 -- Start of Comments
326 -- ==============================================================================
327 -- API Name
328 -- Lock_Offer_Adj_Line
329 -- Type
330 -- Private
331 -- Pre-Req
332 --
333 -- Parameters
334 --
335 -- IN
336 -- p_api_version_number IN NUMBER Required
337 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
338 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
339 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
340 -- p_offadj_line_rec IN offadj_line_rec_type Required
341 --
342 -- OUT
343 -- x_return_status OUT VARCHAR2
344 -- x_msg_count OUT NUMBER
345 -- x_msg_data OUT VARCHAR2
346 -- Version : Current version 1.0
347 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
348 -- and basic operation, developer must manually add parameters and business logic as necessary.
349 --
350 -- History
351 --
352 -- NOTE
353 --
354 -- End of Comments
355 -- ==============================================================================
356
357 PROCEDURE Lock_Offer_Adj_Line(
358 p_api_version_number IN NUMBER,
359 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
360
361 x_return_status OUT NOCOPY VARCHAR2,
362 x_msg_count OUT NOCOPY NUMBER,
363 x_msg_data OUT NOCOPY VARCHAR2,
364
365 p_offer_adjustment_line_id IN NUMBER,
366 p_object_version IN NUMBER
367 );
368
369
370 -- ==============================================================================
371 -- Start of Comments
372 -- ==============================================================================
373 -- API Name
374 -- Validate_Offer_Adj_Line
375 --
376 -- Version : Current version 1.0
377 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
378 -- For create: G_CREATE, for update: G_UPDATE
379 -- Note: 1. This is automated generated item level validation procedure.
380 -- The actual validation detail is needed to be added.
381 -- 2. We can also validate table instead of record. There will be an option for user to choose.
382 --
383 -- History
384 --
385 -- NOTE
386 --
387 -- End of Comments
388 -- ==============================================================================
389
390
391 PROCEDURE Validate_Offer_Adj_Line(
392 p_api_version_number IN NUMBER,
393 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
394 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
395 p_offadj_line_rec IN offadj_line_rec_type,
396 p_validation_mode IN VARCHAR2,
397 x_return_status OUT NOCOPY VARCHAR2,
398 x_msg_count OUT NOCOPY NUMBER,
399 x_msg_data OUT NOCOPY VARCHAR2
400 );
401
402 -- ==============================================================================
403 -- Start of Comments
404 -- ==============================================================================
405 -- API Name
406 -- Offadj_Line_Items
407 --
408 -- Version : Current version 1.0
409 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
410 -- For create: G_CREATE, for update: G_UPDATE
411 -- Note: 1. This is automated generated item level validation procedure.
412 -- The actual validation detail is needed to be added.
413 -- 2. Validate the unique keys, lookups here
414 --
415 -- History
416 --
417 -- NOTE
418 --
419 -- End of Comments
420 -- ==============================================================================
421
422
423 PROCEDURE Check_Offadj_Line_Items (
424 P_offadj_line_rec IN offadj_line_rec_type,
425 p_validation_mode IN VARCHAR2,
426 x_return_status OUT NOCOPY VARCHAR2
427 );
428
429 -- ==============================================================================
430 -- Start of Comments
431 -- ==============================================================================
432 -- API Name
433 -- Validate_Offadj_Line_Rec
434 --
435 -- Version : Current version 1.0
436 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
437 -- For create: G_CREATE, for update: G_UPDATE
438 -- Note: 1. This is automated generated item level validation procedure.
439 -- The actual validation detail is needed to be added.
440 -- 2. Developer can manually added inter-field level validation.
441 --
442 -- History
443 --
444 -- NOTE
445 --
446 -- End of Comments
447 -- ==============================================================================
448
449
450 PROCEDURE Validate_Offadj_Line_Rec (
451 p_api_version_number IN NUMBER,
452 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
453 x_return_status OUT NOCOPY VARCHAR2,
454 x_msg_count OUT NOCOPY NUMBER,
455 x_msg_data OUT NOCOPY VARCHAR2,
456 p_offadj_line_rec IN offadj_line_rec_type
457 );
458
459 PROCEDURE debug_message(
460 p_message_text IN VARCHAR2
461 );
462
463 FUNCTION get_price_list_name(p_list_line_id IN NUMBER)
464 RETURN VARCHAR2 ;
465 END OZF_Offer_Adj_Line_PVT;