[Home] [Help]
PACKAGE: APPS.OZF_OFFER_PVT
Source
1 Package OZF_Offer_Pvt AUTHID CURRENT_USER AS
2 /* $Header: ozfvofrs.pls 120.14 2011/03/03 11:40:37 nirprasa ship $ */
3 --G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_offer_PVT';
4
5 TYPE ozf_qp_reln_rec_type IS RECORD
6 (
7 qp_list_line_id NUMBER
8 , offer_discount_line_id NUMBER
9 , pricing_attribute_id NUMBER
10 , off_discount_product_id NUMBER
11 );
12
13 TYPE ozf_qp_reln_TBL_type IS TABLE OF ozf_qp_reln_rec_type
14 INDEX BY BINARY_INTEGER;
15
16 TYPE Modifier_LIST_Rec_Type IS RECORD
17 (
18 OFFER_ID NUMBER := Fnd_Api.g_miss_num
19 ,QP_LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
20 ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
21 ,OFFER_CODE VARCHAR2(100) := Fnd_Api.g_miss_char
22 ,ACTIVITY_MEDIA_ID NUMBER := Fnd_Api.g_miss_num
23 ,REUSABLE VARCHAR2(1) := Fnd_Api.g_miss_char
24 ,USER_STATUS_ID NUMBER := Fnd_Api.g_miss_num
25 ,OWNER_ID NUMBER := Fnd_Api.g_miss_num
26 ,WF_ITEM_KEY VARCHAR2(120) := Fnd_Api.g_miss_char
27 ,CUSTOMER_REFERENCE VARCHAR2(240) := Fnd_Api.g_miss_char
28 ,BUYING_GROUP_CONTACT_ID NUMBER := Fnd_Api.g_miss_num
29 ,OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
30 ,PERF_DATE_FROM DATE := Fnd_Api.g_miss_date
31 ,PERF_DATE_TO DATE := Fnd_Api.g_miss_date
32 ,STATUS_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
33 ,STATUS_DATE DATE := Fnd_Api.g_miss_date
34 ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
35 ,ORDER_VALUE_DISCOUNT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
36 ,LUMPSUM_AMOUNT NUMBER := Fnd_Api.g_miss_num
37 ,LUMPSUM_PAYMENT_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
38 ,CUSTOM_SETUP_ID NUMBER := Fnd_Api.g_miss_num
39 ,OFFER_AMOUNT NUMBER := FND_API.g_miss_num
40 ,BUDGET_AMOUNT_TC NUMBER := Fnd_Api.g_miss_num
41 ,BUDGET_AMOUNT_FC NUMBER := Fnd_Api.g_miss_num
42 ,TRANSACTION_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
43 ,FUNCTIONAL_CURRENCY_CODE VARCHAR2(15) := Fnd_Api.g_miss_char
44 ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
45 ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
46 ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
47 ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
48 ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
49 ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
50 ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
51 ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
52 ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
53 ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
54 ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
55 ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
56 ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
57 ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
58 ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
59 ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
60 ,CURRENCY_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
61 ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
62 ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
63 ,LIST_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
64 ,DISCOUNT_LINES_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
65 ,NAME VARCHAR2(240) := Fnd_Api.g_miss_char
66 ,DESCRIPTION VARCHAR2(2000) := Fnd_Api.g_miss_char
67 ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
68 ,ASK_FOR_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
69 ,START_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date
70 ,END_DATE_ACTIVE_FIRST DATE := Fnd_Api.g_miss_date
71 ,ACTIVE_DATE_FIRST_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
72 ,START_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date
73 ,END_DATE_ACTIVE_SECOND DATE := Fnd_Api.g_miss_date
74 ,ACTIVE_DATE_SECOND_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
75 ,ACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
76 ,MAX_NO_OF_USES NUMBER := Fnd_Api.g_miss_num
77 ,BUDGET_SOURCE_ID NUMBER := Fnd_Api.g_miss_num
78 ,BUDGET_SOURCE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
79 ,OFFER_USED_BY_ID NUMBER := Fnd_Api.g_miss_num
80 ,OFFER_USED_BY VARCHAR2(30) := Fnd_Api.g_miss_char
81 ,QL_QUALIFIER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
82 ,QL_QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num
83 ,DISTRIBUTION_TYPE VARCHAR2(30) := FND_API.g_miss_char
84 ,AMOUNT_LIMIT_ID NUMBER := FND_API.g_miss_num
85 ,USES_LIMIT_ID NUMBER := FND_API.g_miss_num
86 ,OFFER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
87 ,MODIFIER_OPERATION VARCHAR2(30) := FND_API.g_miss_char
88 ,BUDGET_OFFER_YN VARCHAR2(1) := FND_API.g_miss_char
89 ,BREAK_TYPE VARCHAR2(30) := FND_API.g_miss_char
90 ,RETROACTIVE VARCHAR2(1) := FND_API.g_miss_char
91 ,VOLUME_OFFER_TYPE VARCHAR2(30) := FND_API.g_miss_char
92 ,CONFIDENTIAL_FLAG VARCHAR2(1) := FND_API.g_miss_char
93 ,COMMITTED_AMOUNT_EQ_MAX VARCHAR2(1) := FND_API.g_miss_char
94 ,SOURCE_FROM_PARENT VARCHAR2(1) := FND_API.g_miss_char
95 ,BUYER_NAME VARCHAR2(240) := FND_API.g_miss_char
96 ,TIER_LEVEL VARCHAR2(30) := FND_API.g_miss_char
97 ,NA_RULE_HEADER_ID NUMBER := FND_API.g_miss_num
98 ,SALES_METHOD_FLAG VARCHAR2(1) := FND_API.g_miss_char
99 ,GLOBAL_FLAG VARCHAR2(1) := FND_API.g_miss_char
100 ,ORIG_ORG_ID NUMBER := FND_API.g_miss_num
101 ,na_qualifier_type VARCHAR2(30) := FND_API.g_miss_char
102 ,na_qualifier_id NUMBER := FND_API.g_miss_num
103 ,PERCENT_DISCOUNT NUMBER := FND_API.g_miss_num); /*nirprasa added for ER 11806714*/
104
105 TYPE Modifier_Line_Rec_Type IS RECORD
106 (
107 OFFER_LINE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
108 ,OPERATION VARCHAR2(30) := FND_API.g_miss_char
109 ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
110 ,LIST_LINE_NO VARCHAR2(30) := Fnd_Api.g_miss_char
111 ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
112 ,LIST_LINE_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
113 ,OPERAND NUMBER := Fnd_Api.g_miss_num
114 ,START_DATE_ACTIVE DATE := FND_API.g_miss_date
115 ,END_DATE_ACTIVE DATE := FND_API.g_miss_date
116 ,ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char
117 ,INACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
118 ,QD_OPERAND NUMBER := Fnd_Api.g_miss_num
119 ,QD_ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char
120 ,QD_RELATED_DEAL_LINES_ID NUMBER := Fnd_Api.g_miss_num
121 ,QD_OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
122 ,QD_ESTIMATED_QTY_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char
123 ,QD_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
124 ,QD_ESTIMATED_AMOUNT_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char
125 ,ESTIM_GL_VALUE NUMBER := Fnd_Api.g_miss_num
126 ,BENEFIT_PRICE_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
127 ,BENEFIT_LIMIT NUMBER := Fnd_Api.g_miss_num
128 ,BENEFIT_QTY NUMBER := Fnd_Api.g_miss_num
129 ,BENEFIT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
130 ,SUBSTITUTION_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
131 ,SUBSTITUTION_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
132 ,SUBSTITUTION_VAL VARCHAR2(240) := Fnd_Api.g_miss_char
133 ,PRICE_BREAK_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
134 ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num
135 ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
136 ,PRODUCT_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
137 ,PRODUCT_ATTR_VAL VARCHAR2(240) := Fnd_Api.g_miss_char
138 ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
139 ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
140 ,PRICING_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
141 ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
142 ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
143 ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
144 ,ORDER_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
145 ,ORDER_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
146 ,QUALIFIER_ID NUMBER := FND_API.g_miss_num
147 ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
148 ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
149 ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
150 ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
151 ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
152 ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
153 ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
154 ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
155 ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
156 ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
157 ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
158 ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
159 ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
160 ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
161 ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
162 ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
163 ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
164 ,MAX_QTY_PER_ORDER NUMBER := Fnd_Api.g_miss_num
165 ,MAX_QTY_PER_ORDER_ID NUMBER := Fnd_Api.g_miss_num
166 ,MAX_QTY_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num
167 ,MAX_QTY_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num
168 ,MAX_QTY_PER_RULE NUMBER := Fnd_Api.g_miss_num
169 ,MAX_QTY_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num
170 ,MAX_ORDERS_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num
171 ,MAX_ORDERS_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num
172 ,MAX_AMOUNT_PER_RULE NUMBER := Fnd_Api.g_miss_num
173 ,MAX_AMOUNT_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num
174 ,ESTIMATE_QTY_UOM VARCHAR2(3) := Fnd_Api.g_miss_char
175 ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
176 ,price_by_formula_id NUMBER := FND_API.G_MISS_NUM
177 ,generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
178 ,price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
179 ,limit_exceed_action_code VARCHAR2(240) := FND_API.G_MISS_CHAR
180 );
181
182 TYPE modifier_line_tbl_type IS TABLE OF MODIFIER_LINE_REC_TYPE
183 INDEX BY BINARY_INTEGER;
184
185 TYPE Pricing_ATTR_Rec_Type IS RECORD
186 (
187 LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
188 ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
189 ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num
190 ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
191 ,PRODUCT_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
192 ,PRODUCT_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char
193 ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
197 ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
194 ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
195 ,PRICING_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
196 ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
198 ,MODIFIERS_INDEX NUMBER := Fnd_Api.g_miss_num
199 ,OPERATION VARCHAR2(20) := Fnd_Api.g_miss_char
200 );
201
202 TYPE pricing_attR_tbl_type IS TABLE OF Pricing_ATTR_Rec_Type
203 INDEX BY BINARY_INTEGER;
204
205 TYPE qualifiers_Rec_Type IS RECORD
206 (
207 QUALIFIER_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
208 ,QUALIFIER_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
209 ,QUALIFIER_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char
210 ,QUALIFIER_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
211 ,COMPARISON_OPERATOR_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
212 ,QUALIFIER_GROUPING_NO NUMBER := Fnd_Api.g_miss_num
213 ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
214 ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
215 ,QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num
216 ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
217 ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
218 ,ACTIVITY_MARKET_SEGMENT_ID NUMBER := Fnd_Api.g_miss_num
219 ,OPERATION VARCHAR2(30) := Fnd_Api.g_miss_char
220 ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
221 ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
222 ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
223 ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
224 ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
225 ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
226 ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
227 ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
228 ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
229 ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
230 ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
231 ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
232 ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
233 ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
234 ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
235 ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
236 );
237
238 TYPE qualifiers_tbl_type IS TABLE OF qualifiers_rec_type
239 INDEX BY BINARY_INTEGER;
240
241 TYPE Advanced_Option_Rec_Type IS RECORD
242 (
243 LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
244 ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
245 ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
246 ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
247 ,PRICING_PHASE_ID NUMBER := Fnd_Api.g_miss_num
248 ,INCOMPATIBILITY_GRP_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
249 ,PRODUCT_PRECEDENCE NUMBER := Fnd_Api.g_miss_num
250 ,PRICING_GROUP_SEQUENCE NUMBER := Fnd_Api.g_miss_num
251 ,PRINT_ON_INVOICE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
252 ,autopay_flag VARCHAR2(1) := FND_API.g_miss_char
253 ,autopay_days NUMBER := FND_API.G_miss_num
254 ,autopay_method VARCHAR2(30) := FND_API.g_miss_char
255 ,autopay_party_attr VARCHAR2(30) := FND_API.g_miss_char
256 ,autopay_party_id NUMBER := FND_API.g_miss_num
257 );
258
259
260 ---------------------------------------------------------------------
261 -- PROCEDURE
262 -- process_modifiers_
263 --
264 -- HISTORY
265 -- 20-MAY-2000 Satish Karumuri Created.
266 ---------------------------------------------------------------------
267
268 PROCEDURE process_modifiers
269 (
270 p_init_msg_list IN VARCHAR2
271 ,p_api_version IN NUMBER
272 ,p_commit IN VARCHAR2
273 ,x_return_status OUT NOCOPY VARCHAR2
274 ,x_msg_count OUT NOCOPY NUMBER
275 ,x_msg_data OUT NOCOPY VARCHAR2
276 ,p_offer_type IN VARCHAR2
277 ,p_modifier_list_rec IN MODIFIER_LIST_REC_TYPE
278 ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
279 ,x_qp_list_header_id OUT NOCOPY NUMBER
280 ,x_error_location OUT NOCOPY NUMBER
281 );
282
283 PROCEDURE create_offer_tiers
284 (
285 p_init_msg_list IN VARCHAR2
286 ,p_api_version IN NUMBER
287 ,p_commit IN VARCHAR2
288 ,x_return_status OUT NOCOPY VARCHAR2
289 ,x_msg_count OUT NOCOPY NUMBER
290 ,x_msg_data OUT NOCOPY VARCHAR2
291 ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
292 ,x_error_location OUT NOCOPY NUMBER
293 -- ,x_modifiers_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
294 -- ,x_pricing_attr_tbl OUT NOCOPY qp_modifiers_pub.pricing_attr_tbl_type
295 );
296
297 PROCEDURE process_market_qualifiers
298 (
299 p_init_msg_list IN VARCHAR2
300 ,p_api_version IN NUMBER
301 ,p_commit IN VARCHAR2
302 ,x_return_status OUT NOCOPY VARCHAR2
303 ,x_msg_count OUT NOCOPY NUMBER
304 ,x_msg_data OUT NOCOPY VARCHAR2
305 ,p_qualifiers_tbl IN QUALIFIERS_TBL_TYPE
306 ,x_error_location OUT NOCOPY NUMBER
307 ,x_qualifiers_tbl OUT NOCOPY qp_qualifier_rules_pub.qualifiers_tbl_type
308 );
309
310 PROCEDURE process_market_qualifiers
311 (
315 ,x_return_status OUT NOCOPY VARCHAR2
312 p_init_msg_list IN VARCHAR2
313 ,p_api_version IN NUMBER
314 ,p_commit IN VARCHAR2
316 ,x_msg_count OUT NOCOPY NUMBER
317 ,x_msg_data OUT NOCOPY VARCHAR2
318 ,p_qualifiers_tbl IN QUALIFIERS_TBL_TYPE
319 ,x_error_location OUT NOCOPY NUMBER
320 );
321
322 PROCEDURE process_exclusions
323 (
324 p_init_msg_list IN VARCHAR2
325 ,p_api_version IN NUMBER
326 ,p_commit IN VARCHAR2
327 ,x_return_status OUT NOCOPY VARCHAR2
328 ,x_msg_count OUT NOCOPY NUMBER
329 ,x_msg_data OUT NOCOPY VARCHAR2
330 ,p_pricing_attr_tbl IN PRICING_ATTR_TBL_TYPE
331 ,x_error_location OUT NOCOPY NUMBER
332 );
333
334 PROCEDURE process_adv_options
335 (
336 p_init_msg_list IN VARCHAR2
337 ,p_api_version IN NUMBER
338 ,p_commit IN VARCHAR2
339 ,x_return_status OUT NOCOPY VARCHAR2
340 ,x_msg_count OUT NOCOPY NUMBER
341 ,x_msg_data OUT NOCOPY VARCHAR2
342 ,p_advanced_options_rec IN ADVANCED_OPTION_REC_TYPE
343 );
344
345 PROCEDURE activate_offer
346 (
347 x_return_status OUT NOCOPY VARCHAR2
348 ,x_msg_count OUT NOCOPY NUMBER
349 ,x_msg_data OUT NOCOPY VARCHAR2
350 ,p_qp_list_header_id IN NUMBER
351 ,p_new_status_id IN NUMBER
352 );
353
354
355 PROCEDURE validate_lumpsum_offer
356 (
357 p_init_msg_list IN VARCHAR2
358 ,x_return_status OUT NOCOPY VARCHAR2
359 ,x_msg_count OUT NOCOPY NUMBER
360 ,x_msg_data OUT NOCOPY VARCHAR2
361 ,p_qp_list_header_id IN NUMBER
362 );
363
364 PROCEDURE Activate_Offer_Over(
365 p_init_msg_list IN VARCHAR2,
366 p_api_version IN NUMBER,
367 p_commit IN VARCHAR2,
368 x_return_status OUT NOCOPY VARCHAR2,
369 x_msg_count OUT NOCOPY NUMBER,
370 x_msg_data OUT NOCOPY VARCHAR2,
371 p_called_from IN VARCHAR2,
372 p_offer_rec IN modifier_list_rec_type,
373 x_amount_error OUT NOCOPY VARCHAR2
374 );
375
376 PROCEDURE Update_Offer_Status
377 (
378 p_commit IN VARCHAR2
379 ,x_return_status OUT NOCOPY VARCHAR2
380 ,x_msg_count OUT NOCOPY NUMBER
381 ,x_msg_data OUT NOCOPY VARCHAR2
382 ,p_modifier_list_rec IN modifier_list_rec_type
383 );
384
385 FUNCTION find_territories
386 (
387 aso_party_id IN NUMBER
388 ,oe_sold_to_org IN NUMBER
389 ) RETURN Qp_Attr_Mapping_Pub.t_multirecord;
390
391 FUNCTION find_sections
392 (
393 aso_inventory_item_id IN NUMBER
394 ,oe_inventory_item_id IN NUMBER
395 ) RETURN Qp_Attr_Mapping_Pub.t_multirecord;
396
397
398 FUNCTION get_commited_amount(p_list_header_id IN NUMBER) RETURN NUMBER;
399 FUNCTION get_recal_commited_amount(p_list_header_id IN NUMBER) RETURN NUMBER;
400 FUNCTION get_paid_amount(p_list_header_id IN NUMBER) RETURN NUMBER;
401 FUNCTION get_earned_amount(p_list_header_id IN NUMBER) RETURN NUMBER;
402 FUNCTION discount_lines_exist(p_list_header_id IN NUMBER) RETURN NUMBER;
403
404 PROCEDURE process_qp_list_lines
405 (
406 x_return_status OUT NOCOPY VARCHAR2
407 ,x_msg_count OUT NOCOPY NUMBER
408 ,x_msg_data OUT NOCOPY VARCHAR2
409 ,p_offer_type IN VARCHAR2
410 ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
411 ,p_list_header_id IN NUMBER
412 ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
413 ,x_error_location OUT NOCOPY NUMBER
414 );
415
416 FUNCTION get_qualifier_name(p_qualifier_type IN VARCHAR2 , p_qualifier_id IN NUMBER) RETURN VARCHAR2;
417
418 FUNCTION get_formula_name(p_formula_id IN NUMBER) RETURN VARCHAR2;
419 FUNCTION get_offer_discount_id(p_offer_id IN NUMBER) RETURN VARCHAR2;
420 --FUNCTION get_order_amount(p_list_header_id IN NUMBER) RETURN NUMBER;
421
422 PROCEDURE push_discount_rules_to_qp
423 (
424 p_init_msg_list IN VARCHAR2
425 ,p_api_version IN NUMBER
426 ,p_commit IN VARCHAR2
427 ,x_return_status OUT NOCOPY VARCHAR2
428 ,x_msg_count OUT NOCOPY NUMBER
429 ,x_msg_data OUT NOCOPY VARCHAR2
430 , p_qp_list_header_id IN NUMBER
431 , x_error_location OUT NOCOPY NUMBER
432 );
433
434 PROCEDURE process_offer_activation
435 (
436 p_api_version_number IN NUMBER
437 , p_init_msg_list IN VARCHAR2
438 , p_commit IN VARCHAR2
439 , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
440 , x_return_status OUT NOCOPY VARCHAR2
441 , x_msg_count OUT NOCOPY NUMBER
442 , x_msg_data OUT NOCOPY VARCHAR2
443 , p_offer_rec IN Modifier_LIST_Rec_Type
444 );
445
446
447 PROCEDURE raise_offer_event(p_offer_id IN NUMBER,
448 p_adjustment_id IN NUMBER :=NULL);
449
450 FUNCTION getOfferType(p_listHeaderId NUMBER) RETURN VARCHAR2;
451 FUNCTION getDiscountLevel(p_listHeaderId IN NUMBER) RETURN VARCHAR2;
452 FUNCTION getPricingPhase(p_listHeaderId IN NUMBER) RETURN VARCHAR2;
453
454 PROCEDURE processPbhLine
455 (
456 x_return_status OUT NOCOPY VARCHAR2
457 ,x_msg_count OUT NOCOPY NUMBER
458 ,x_msg_data OUT NOCOPY VARCHAR2
462 -- ,x_error_location OUT NOCOPY NUMBER
459 ,p_offerType IN VARCHAR2
460 ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
461 ,x_modifiersTbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
463 );
464 PROCEDURE process_header_tiers
465 ( x_return_status OUT NOCOPY VARCHAR2
466 ,x_msg_count OUT NOCOPY NUMBER
467 ,x_msg_data OUT NOCOPY VARCHAR2
468 ,p_offer_type IN VARCHAR2
469 ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
470 ,x_modifiers_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
471 ,x_error_location OUT NOCOPY NUMBER
472 );
473
474 PROCEDURE pushDiscountRuleToQp
475 (
476 x_return_status OUT NOCOPY VARCHAR2
477 ,x_msg_count OUT NOCOPY NUMBER
478 ,x_msg_data OUT NOCOPY VARCHAR2
479 , p_qp_list_header_id IN NUMBER
480 , p_offDiscountProductId IN NUMBER
481 , x_error_location OUT NOCOPY NUMBER
482 , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
483 , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
484 );
485 PROCEDURE pushDiscountRuleToQpAndRelate
486 (
487 x_return_status OUT NOCOPY VARCHAR2
488 ,x_msg_count OUT NOCOPY NUMBER
489 ,x_msg_data OUT NOCOPY VARCHAR2
490 , p_qp_list_header_id IN NUMBER
491 , p_offDiscountProductId IN NUMBER
492 , x_error_location OUT NOCOPY NUMBER
493 , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
494 , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
495 );
496 PROCEDURE process_sd_modifiers(
497 p_sdr_header_id IN NUMBER
498 ,p_init_msg_list IN VARCHAR2 :=FND_API.g_true
499 ,p_api_version IN NUMBER
500 ,p_commit IN VARCHAR2 :=FND_API.g_false
501 ,x_return_status OUT NOCOPY VARCHAR2
502 ,x_msg_count OUT NOCOPY NUMBER
503 ,x_msg_data OUT NOCOPY VARCHAR2
504 ,x_qp_list_header_id IN OUT NOCOPY NUMBER
505 ,x_error_location OUT NOCOPY NUMBER
506 );
507
508
509 END OZF_Offer_Pvt;