[Home] [Help]
PACKAGE: APPS.OZF_OFFER_PVT
Source
1 Package OZF_Offer_Pvt AS
2 /* $Header: ozfvofrs.pls 120.13 2008/01/11 06:36:17 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
104 TYPE Modifier_Line_Rec_Type IS RECORD
105 (
106 OFFER_LINE_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
107 ,OPERATION VARCHAR2(30) := FND_API.g_miss_char
108 ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
109 ,LIST_LINE_NO VARCHAR2(30) := Fnd_Api.g_miss_char
110 ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
111 ,LIST_LINE_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
112 ,OPERAND NUMBER := Fnd_Api.g_miss_num
113 ,START_DATE_ACTIVE DATE := FND_API.g_miss_date
114 ,END_DATE_ACTIVE DATE := FND_API.g_miss_date
115 ,ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char
116 ,INACTIVE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
117 ,QD_OPERAND NUMBER := Fnd_Api.g_miss_num
118 ,QD_ARITHMETIC_OPERATOR VARCHAR2(30) := Fnd_Api.g_miss_char
119 ,QD_RELATED_DEAL_LINES_ID NUMBER := Fnd_Api.g_miss_num
120 ,QD_OBJECT_VERSION_NUMBER NUMBER := Fnd_Api.g_miss_num
121 ,QD_ESTIMATED_QTY_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char
122 ,QD_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
123 ,QD_ESTIMATED_AMOUNT_IS_MAX VARCHAR2(1) := Fnd_Api.g_miss_char
124 ,ESTIM_GL_VALUE NUMBER := Fnd_Api.g_miss_num
125 ,BENEFIT_PRICE_LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
126 ,BENEFIT_LIMIT NUMBER := Fnd_Api.g_miss_num
127 ,BENEFIT_QTY NUMBER := Fnd_Api.g_miss_num
128 ,BENEFIT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
129 ,SUBSTITUTION_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
130 ,SUBSTITUTION_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
131 ,SUBSTITUTION_VAL VARCHAR2(240) := Fnd_Api.g_miss_char
132 ,PRICE_BREAK_TYPE_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
133 ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num
134 ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
135 ,PRODUCT_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
136 ,PRODUCT_ATTR_VAL VARCHAR2(240) := Fnd_Api.g_miss_char
137 ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
138 ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
139 ,PRICING_ATTR VARCHAR2(30) := Fnd_Api.g_miss_char
140 ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
141 ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
142 ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
143 ,ORDER_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
144 ,ORDER_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
145 ,QUALIFIER_ID NUMBER := FND_API.g_miss_num
146 ,COMMENTS VARCHAR2(2000) := Fnd_Api.g_miss_char
147 ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
148 ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
149 ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
150 ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
151 ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
152 ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
153 ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
154 ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
155 ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
156 ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
157 ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
158 ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
159 ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
160 ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
161 ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
162 ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
163 ,MAX_QTY_PER_ORDER NUMBER := Fnd_Api.g_miss_num
164 ,MAX_QTY_PER_ORDER_ID NUMBER := Fnd_Api.g_miss_num
165 ,MAX_QTY_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num
166 ,MAX_QTY_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num
167 ,MAX_QTY_PER_RULE NUMBER := Fnd_Api.g_miss_num
168 ,MAX_QTY_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num
169 ,MAX_ORDERS_PER_CUSTOMER NUMBER := Fnd_Api.g_miss_num
170 ,MAX_ORDERS_PER_CUSTOMER_ID NUMBER := Fnd_Api.g_miss_num
171 ,MAX_AMOUNT_PER_RULE NUMBER := Fnd_Api.g_miss_num
172 ,MAX_AMOUNT_PER_RULE_ID NUMBER := Fnd_Api.g_miss_num
173 ,ESTIMATE_QTY_UOM VARCHAR2(3) := Fnd_Api.g_miss_char
174 ,generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
175 ,price_by_formula_id NUMBER := FND_API.G_MISS_NUM
176 ,generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
177 ,price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
178 ,limit_exceed_action_code VARCHAR2(240) := FND_API.G_MISS_CHAR
179 );
180
181 TYPE modifier_line_tbl_type IS TABLE OF MODIFIER_LINE_REC_TYPE
182 INDEX BY BINARY_INTEGER;
183
184 TYPE Pricing_ATTR_Rec_Type IS RECORD
185 (
186 LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
187 ,EXCLUDER_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
188 ,PRICING_ATTRIBUTE_ID NUMBER := Fnd_Api.g_miss_num
189 ,PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
190 ,PRODUCT_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
191 ,PRODUCT_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char
192 ,PRODUCT_UOM_CODE VARCHAR2(3) := Fnd_Api.g_miss_char
193 ,PRICING_ATTRIBUTE_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
194 ,PRICING_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
195 ,PRICING_ATTR_VALUE_FROM VARCHAR2(240) := Fnd_Api.g_miss_char
196 ,PRICING_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
197 ,MODIFIERS_INDEX NUMBER := Fnd_Api.g_miss_num
198 ,OPERATION VARCHAR2(20) := Fnd_Api.g_miss_char
199 );
200
201 TYPE pricing_attR_tbl_type IS TABLE OF Pricing_ATTR_Rec_Type
202 INDEX BY BINARY_INTEGER;
203
204 TYPE qualifiers_Rec_Type IS RECORD
205 (
206 QUALIFIER_CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
207 ,QUALIFIER_ATTRIBUTE VARCHAR2(30) := Fnd_Api.g_miss_char
208 ,QUALIFIER_ATTR_VALUE VARCHAR2(240) := Fnd_Api.g_miss_char
209 ,QUALIFIER_ATTR_VALUE_TO VARCHAR2(240) := Fnd_Api.g_miss_char
210 ,COMPARISON_OPERATOR_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
211 ,QUALIFIER_GROUPING_NO NUMBER := Fnd_Api.g_miss_num
212 ,LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
213 ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
214 ,QUALIFIER_ID NUMBER := Fnd_Api.g_miss_num
215 ,START_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
216 ,END_DATE_ACTIVE DATE := Fnd_Api.g_miss_date
217 ,ACTIVITY_MARKET_SEGMENT_ID NUMBER := Fnd_Api.g_miss_num
218 ,OPERATION VARCHAR2(30) := Fnd_Api.g_miss_char
219 ,CONTEXT VARCHAR2(30) := Fnd_Api.g_miss_char
220 ,ATTRIBUTE1 VARCHAR2(240) := Fnd_Api.g_miss_char
221 ,ATTRIBUTE2 VARCHAR2(240) := Fnd_Api.g_miss_char
222 ,ATTRIBUTE3 VARCHAR2(240) := Fnd_Api.g_miss_char
223 ,ATTRIBUTE4 VARCHAR2(240) := Fnd_Api.g_miss_char
224 ,ATTRIBUTE5 VARCHAR2(240) := Fnd_Api.g_miss_char
225 ,ATTRIBUTE6 VARCHAR2(240) := Fnd_Api.g_miss_char
226 ,ATTRIBUTE7 VARCHAR2(240) := Fnd_Api.g_miss_char
227 ,ATTRIBUTE8 VARCHAR2(240) := Fnd_Api.g_miss_char
228 ,ATTRIBUTE9 VARCHAR2(240) := Fnd_Api.g_miss_char
229 ,ATTRIBUTE10 VARCHAR2(240) := Fnd_Api.g_miss_char
230 ,ATTRIBUTE11 VARCHAR2(240) := Fnd_Api.g_miss_char
231 ,ATTRIBUTE12 VARCHAR2(240) := Fnd_Api.g_miss_char
232 ,ATTRIBUTE13 VARCHAR2(240) := Fnd_Api.g_miss_char
233 ,ATTRIBUTE14 VARCHAR2(240) := Fnd_Api.g_miss_char
234 ,ATTRIBUTE15 VARCHAR2(240) := Fnd_Api.g_miss_char
235 );
236
237 TYPE qualifiers_tbl_type IS TABLE OF qualifiers_rec_type
238 INDEX BY BINARY_INTEGER;
239
240 TYPE Advanced_Option_Rec_Type IS RECORD
241 (
242 LIST_LINE_ID NUMBER := Fnd_Api.g_miss_num
243 ,LIST_HEADER_ID NUMBER := Fnd_Api.g_miss_num
244 ,OFFER_TYPE VARCHAR2(30) := Fnd_Api.g_miss_char
245 ,MODIFIER_LEVEL_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
246 ,PRICING_PHASE_ID NUMBER := Fnd_Api.g_miss_num
247 ,INCOMPATIBILITY_GRP_CODE VARCHAR2(30) := Fnd_Api.g_miss_char
248 ,PRODUCT_PRECEDENCE NUMBER := Fnd_Api.g_miss_num
249 ,PRICING_GROUP_SEQUENCE NUMBER := Fnd_Api.g_miss_num
250 ,PRINT_ON_INVOICE_FLAG VARCHAR2(1) := Fnd_Api.g_miss_char
251 ,autopay_flag VARCHAR2(1) := FND_API.g_miss_char
252 ,autopay_days NUMBER := FND_API.G_miss_num
253 ,autopay_method VARCHAR2(30) := FND_API.g_miss_char
254 ,autopay_party_attr VARCHAR2(30) := FND_API.g_miss_char
255 ,autopay_party_id NUMBER := FND_API.g_miss_num
256 );
257
258
259 ---------------------------------------------------------------------
260 -- PROCEDURE
261 -- process_modifiers_
262 --
263 -- HISTORY
264 -- 20-MAY-2000 Satish Karumuri Created.
265 ---------------------------------------------------------------------
266
267 PROCEDURE process_modifiers
268 (
269 p_init_msg_list IN VARCHAR2
270 ,p_api_version IN NUMBER
271 ,p_commit IN VARCHAR2
272 ,x_return_status OUT NOCOPY VARCHAR2
273 ,x_msg_count OUT NOCOPY NUMBER
274 ,x_msg_data OUT NOCOPY VARCHAR2
275 ,p_offer_type IN VARCHAR2
279 ,x_error_location OUT NOCOPY NUMBER
276 ,p_modifier_list_rec IN MODIFIER_LIST_REC_TYPE
277 ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
278 ,x_qp_list_header_id OUT NOCOPY NUMBER
280 );
281
282 PROCEDURE create_offer_tiers
283 (
284 p_init_msg_list IN VARCHAR2
285 ,p_api_version IN NUMBER
286 ,p_commit IN VARCHAR2
287 ,x_return_status OUT NOCOPY VARCHAR2
288 ,x_msg_count OUT NOCOPY NUMBER
289 ,x_msg_data OUT NOCOPY VARCHAR2
290 ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
291 ,x_error_location OUT NOCOPY NUMBER
292 -- ,x_modifiers_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
293 -- ,x_pricing_attr_tbl OUT NOCOPY qp_modifiers_pub.pricing_attr_tbl_type
294 );
295
296 PROCEDURE process_market_qualifiers
297 (
298 p_init_msg_list IN VARCHAR2
299 ,p_api_version IN NUMBER
300 ,p_commit IN VARCHAR2
301 ,x_return_status OUT NOCOPY VARCHAR2
302 ,x_msg_count OUT NOCOPY NUMBER
303 ,x_msg_data OUT NOCOPY VARCHAR2
304 ,p_qualifiers_tbl IN QUALIFIERS_TBL_TYPE
305 ,x_error_location OUT NOCOPY NUMBER
306 ,x_qualifiers_tbl OUT NOCOPY qp_qualifier_rules_pub.qualifiers_tbl_type
307 );
308
309 PROCEDURE process_market_qualifiers
310 (
311 p_init_msg_list IN VARCHAR2
312 ,p_api_version IN NUMBER
313 ,p_commit IN VARCHAR2
314 ,x_return_status OUT NOCOPY VARCHAR2
315 ,x_msg_count OUT NOCOPY NUMBER
316 ,x_msg_data OUT NOCOPY VARCHAR2
317 ,p_qualifiers_tbl IN QUALIFIERS_TBL_TYPE
318 ,x_error_location OUT NOCOPY NUMBER
319 );
320
321 PROCEDURE process_exclusions
322 (
323 p_init_msg_list IN VARCHAR2
324 ,p_api_version IN NUMBER
325 ,p_commit IN VARCHAR2
326 ,x_return_status OUT NOCOPY VARCHAR2
327 ,x_msg_count OUT NOCOPY NUMBER
328 ,x_msg_data OUT NOCOPY VARCHAR2
329 ,p_pricing_attr_tbl IN PRICING_ATTR_TBL_TYPE
330 ,x_error_location OUT NOCOPY NUMBER
331 );
332
333 PROCEDURE process_adv_options
334 (
335 p_init_msg_list IN VARCHAR2
336 ,p_api_version IN NUMBER
337 ,p_commit IN VARCHAR2
338 ,x_return_status OUT NOCOPY VARCHAR2
339 ,x_msg_count OUT NOCOPY NUMBER
340 ,x_msg_data OUT NOCOPY VARCHAR2
341 ,p_advanced_options_rec IN ADVANCED_OPTION_REC_TYPE
342 );
343
344 PROCEDURE activate_offer
345 (
346 x_return_status OUT NOCOPY VARCHAR2
347 ,x_msg_count OUT NOCOPY NUMBER
348 ,x_msg_data OUT NOCOPY VARCHAR2
349 ,p_qp_list_header_id IN NUMBER
350 ,p_new_status_id IN NUMBER
351 );
352
353
354 PROCEDURE validate_lumpsum_offer
355 (
356 p_init_msg_list IN VARCHAR2
357 ,x_return_status OUT NOCOPY VARCHAR2
358 ,x_msg_count OUT NOCOPY NUMBER
359 ,x_msg_data OUT NOCOPY VARCHAR2
360 ,p_qp_list_header_id IN NUMBER
361 );
362
363 PROCEDURE Activate_Offer_Over(
364 p_init_msg_list IN VARCHAR2,
365 p_api_version IN NUMBER,
366 p_commit IN VARCHAR2,
367 x_return_status OUT NOCOPY VARCHAR2,
368 x_msg_count OUT NOCOPY NUMBER,
369 x_msg_data OUT NOCOPY VARCHAR2,
370 p_called_from IN VARCHAR2,
371 p_offer_rec IN modifier_list_rec_type,
372 x_amount_error OUT NOCOPY VARCHAR2
373 );
374
375 PROCEDURE Update_Offer_Status
376 (
377 p_commit IN VARCHAR2
378 ,x_return_status OUT NOCOPY VARCHAR2
379 ,x_msg_count OUT NOCOPY NUMBER
380 ,x_msg_data OUT NOCOPY VARCHAR2
381 ,p_modifier_list_rec IN modifier_list_rec_type
382 );
383
384 FUNCTION find_territories
385 (
386 aso_party_id IN NUMBER
387 ,oe_sold_to_org IN NUMBER
388 ) RETURN Qp_Attr_Mapping_Pub.t_multirecord;
389
390 FUNCTION find_sections
391 (
392 aso_inventory_item_id IN NUMBER
393 ,oe_inventory_item_id IN NUMBER
394 ) RETURN Qp_Attr_Mapping_Pub.t_multirecord;
395
396
397 FUNCTION get_commited_amount(p_list_header_id IN NUMBER) RETURN NUMBER;
398 FUNCTION get_recal_commited_amount(p_list_header_id IN NUMBER) RETURN NUMBER;
399 FUNCTION get_paid_amount(p_list_header_id IN NUMBER) RETURN NUMBER;
400 FUNCTION get_earned_amount(p_list_header_id IN NUMBER) RETURN NUMBER;
401 FUNCTION discount_lines_exist(p_list_header_id IN NUMBER) RETURN NUMBER;
402
403 PROCEDURE process_qp_list_lines
404 (
405 x_return_status OUT NOCOPY VARCHAR2
406 ,x_msg_count OUT NOCOPY NUMBER
407 ,x_msg_data OUT NOCOPY VARCHAR2
408 ,p_offer_type IN VARCHAR2
409 ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
410 ,p_list_header_id IN NUMBER
411 ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
412 ,x_error_location OUT NOCOPY NUMBER
413 );
414
415 FUNCTION get_qualifier_name(p_qualifier_type IN VARCHAR2 , p_qualifier_id IN NUMBER) RETURN VARCHAR2;
416
417 FUNCTION get_formula_name(p_formula_id IN NUMBER) RETURN VARCHAR2;
418 FUNCTION get_offer_discount_id(p_offer_id IN NUMBER) RETURN VARCHAR2;
419 --FUNCTION get_order_amount(p_list_header_id IN NUMBER) RETURN NUMBER;
420
421 PROCEDURE push_discount_rules_to_qp
422 (
423 p_init_msg_list IN VARCHAR2
424 ,p_api_version IN NUMBER
425 ,p_commit IN VARCHAR2
426 ,x_return_status OUT NOCOPY VARCHAR2
427 ,x_msg_count OUT NOCOPY NUMBER
428 ,x_msg_data OUT NOCOPY VARCHAR2
429 , p_qp_list_header_id IN NUMBER
430 , x_error_location OUT NOCOPY NUMBER
431 );
432
433 PROCEDURE process_offer_activation
434 (
435 p_api_version_number IN NUMBER
436 , p_init_msg_list IN VARCHAR2
437 , p_commit IN VARCHAR2
438 , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
439 , x_return_status OUT NOCOPY VARCHAR2
440 , x_msg_count OUT NOCOPY NUMBER
441 , x_msg_data OUT NOCOPY VARCHAR2
442 , p_offer_rec IN Modifier_LIST_Rec_Type
443 );
444
445
446 PROCEDURE raise_offer_event(p_offer_id IN NUMBER,
447 p_adjustment_id IN NUMBER :=NULL);
448
449 FUNCTION getOfferType(p_listHeaderId NUMBER) RETURN VARCHAR2;
450 FUNCTION getDiscountLevel(p_listHeaderId IN NUMBER) RETURN VARCHAR2;
451 FUNCTION getPricingPhase(p_listHeaderId IN NUMBER) RETURN VARCHAR2;
452
453 PROCEDURE processPbhLine
454 (
455 x_return_status OUT NOCOPY VARCHAR2
456 ,x_msg_count OUT NOCOPY NUMBER
457 ,x_msg_data OUT NOCOPY VARCHAR2
458 ,p_offerType IN VARCHAR2
459 ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
460 ,x_modifiersTbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
461 -- ,x_error_location OUT NOCOPY NUMBER
462 );
463 PROCEDURE process_header_tiers
464 ( x_return_status OUT NOCOPY VARCHAR2
465 ,x_msg_count OUT NOCOPY NUMBER
466 ,x_msg_data OUT NOCOPY VARCHAR2
467 ,p_offer_type IN VARCHAR2
468 ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
469 ,x_modifiers_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
470 ,x_error_location OUT NOCOPY NUMBER
471 );
472
473 PROCEDURE pushDiscountRuleToQp
474 (
475 x_return_status OUT NOCOPY VARCHAR2
476 ,x_msg_count OUT NOCOPY NUMBER
477 ,x_msg_data OUT NOCOPY VARCHAR2
478 , p_qp_list_header_id IN NUMBER
479 , p_offDiscountProductId IN NUMBER
480 , x_error_location OUT NOCOPY NUMBER
481 , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
482 , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
483 );
484 PROCEDURE pushDiscountRuleToQpAndRelate
485 (
486 x_return_status OUT NOCOPY VARCHAR2
487 ,x_msg_count OUT NOCOPY NUMBER
488 ,x_msg_data OUT NOCOPY VARCHAR2
489 , p_qp_list_header_id IN NUMBER
490 , p_offDiscountProductId IN NUMBER
491 , x_error_location OUT NOCOPY NUMBER
495 PROCEDURE process_sd_modifiers(
492 , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
493 , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
494 );
496 p_sdr_header_id IN NUMBER
497 ,p_init_msg_list IN VARCHAR2 :=FND_API.g_true
498 ,p_api_version IN NUMBER
499 ,p_commit IN VARCHAR2 :=FND_API.g_false
500 ,x_return_status OUT NOCOPY VARCHAR2
501 ,x_msg_count OUT NOCOPY NUMBER
502 ,x_msg_data OUT NOCOPY VARCHAR2
503 ,x_qp_list_header_id IN OUT NOCOPY NUMBER
504 ,x_error_location OUT NOCOPY NUMBER
505 );
506
507
508 END OZF_Offer_Pvt;