[Home] [Help]
PACKAGE: APPS.OE_OE_PRICING_AVAILABILITY
Source
1 PACKAGE oe_oe_pricing_availability AS
2 /* $Header: OEXFPRAS.pls 120.1.12010000.3 2008/11/26 16:12:07 vmachett ship $ */
3
4
5 --added for bug 3559935
6
7 TYPE User_Attribute_Rec_Type IS RECORD
8 ( context_name VARCHAR2(30)
9 , attribute_name VARCHAR2(240)
10 );
11
12 TYPE User_Attribute_Tbl_Type IS TABLE OF User_Attribute_Rec_Type INDEX BY BINARY_INTEGER;
13
14 --end 3559935
15
16 --added for bug 3245976
17
18 g_mrp_error_msg varchar2(1000) :=NULL;
19 g_mrp_error_msg_flag char(1) :='F';
20
21 --end bug 3245976
22 --start 3440778
23 TYPE agreement_rec IS RECORD
24 (
25 agreement_name VARCHAR2(300)
26 ,agreement_id NUMBER
27 ,agreement_type VARCHAR2(30)
28 ,price_list_name VARCHAR2(240)
29 ,customer_name VARCHAR2(360)
30 ,payment_term_name VARCHAR2(15)
31 ,start_date_active DATE
32 ,end_date_active DATE
33 );
34
35 TYPE agreement_tbl IS TABLE OF agreement_rec INDEX BY BINARY_INTEGER;
36 -- end bug 3440778
37 TYPE PA_Header_Rec_Type IS RECORD
38 ( accounting_rule_id NUMBER
39 , agreement_id NUMBER
40 , attribute1 VARCHAR2(240)
41 , attribute10 VARCHAR2(240)
42 , attribute11 VARCHAR2(240)
43 , attribute12 VARCHAR2(240)
44 , attribute13 VARCHAR2(240)
45 , attribute14 VARCHAR2(240)
46 , attribute15 VARCHAR2(240)
47 , attribute16 VARCHAR2(240)
48 , attribute17 VARCHAR2(240)
49 , attribute18 VARCHAR2(240)
50 , attribute19 VARCHAR2(240)
51 , attribute2 VARCHAR2(240)
52 , attribute20 VARCHAR2(240)
53 , attribute3 VARCHAR2(240)
54 , attribute4 VARCHAR2(240)
55 , attribute5 VARCHAR2(240)
56 , attribute6 VARCHAR2(240)
57 , attribute7 VARCHAR2(240)
58 , attribute8 VARCHAR2(240)
59 , attribute9 VARCHAR2(240)
60 , booked_flag VARCHAR2(1)
61 , cancelled_flag VARCHAR2(1)
62 , context VARCHAR2(30)
63 , conversion_rate NUMBER
64 , conversion_rate_date DATE
65 , conversion_type_code VARCHAR2(30)
66 , customer_preference_set_code VARCHAR2(30)
67 , created_by NUMBER
68 , creation_date DATE
69 , cust_po_number VARCHAR2(50)
70 , deliver_to_contact_id NUMBER
71 , deliver_to_org_id NUMBER
72 , demand_class_code VARCHAR2(30)
73 , earliest_schedule_limit NUMBER
74 , expiration_date DATE
75 , fob_point_code VARCHAR2(30)
76 , freight_carrier_code VARCHAR2(30)
77 , freight_terms_code VARCHAR2(30)
78 , global_attribute1 VARCHAR2(240)
79 , global_attribute10 VARCHAR2(240)
80 , global_attribute11 VARCHAR2(240)
81 , global_attribute12 VARCHAR2(240)
82 , global_attribute13 VARCHAR2(240)
83 , global_attribute14 VARCHAR2(240)
84 , global_attribute15 VARCHAR2(240)
85 , global_attribute16 VARCHAR2(240)
86 , global_attribute17 VARCHAR2(240)
87 , global_attribute18 VARCHAR2(240)
88 , global_attribute19 VARCHAR2(240)
89 , global_attribute2 VARCHAR2(240)
90 , global_attribute20 VARCHAR2(240)
91 , global_attribute3 VARCHAR2(240)
92 , global_attribute4 VARCHAR2(240)
93 , global_attribute5 VARCHAR2(240)
94 , global_attribute6 VARCHAR2(240)
95 , global_attribute7 VARCHAR2(240)
96 , global_attribute8 VARCHAR2(240)
97 , global_attribute9 VARCHAR2(240)
98 , global_attribute_category VARCHAR2(30)
99 , TP_CONTEXT VARCHAR2(30)
100 , TP_ATTRIBUTE1 VARCHAR2(240)
101 , TP_ATTRIBUTE2 VARCHAR2(240)
102 , TP_ATTRIBUTE3 VARCHAR2(240)
103 , TP_ATTRIBUTE4 VARCHAR2(240)
104 , TP_ATTRIBUTE5 VARCHAR2(240)
105 , TP_ATTRIBUTE6 VARCHAR2(240)
106 , TP_ATTRIBUTE7 VARCHAR2(240)
107 , TP_ATTRIBUTE8 VARCHAR2(240)
108 , TP_ATTRIBUTE9 VARCHAR2(240)
109 , TP_ATTRIBUTE10 VARCHAR2(240)
110 , TP_ATTRIBUTE11 VARCHAR2(240)
111 , TP_ATTRIBUTE12 VARCHAR2(240)
112 , TP_ATTRIBUTE13 VARCHAR2(240)
113 , TP_ATTRIBUTE14 VARCHAR2(240)
114 , TP_ATTRIBUTE15 VARCHAR2(240)
115 , header_id NUMBER
116 , invoice_to_contact_id NUMBER
117 , invoice_to_org_id NUMBER
118 , invoicing_rule_id NUMBER
119 , last_updated_by NUMBER
120 , last_update_date DATE
121 , last_update_login NUMBER
122 , latest_schedule_limit NUMBER
123 , open_flag VARCHAR2(1)
124 , order_category_code VARCHAR2(30)
125 , ordered_date DATE
126 , order_date_type_code VARCHAR2(30)
127 , order_number NUMBER
128 , order_source_id NUMBER
129 , order_type_id NUMBER
130 , org_id NUMBER
131 , orig_sys_document_ref VARCHAR2(50)
132 , partial_shipments_allowed VARCHAR2(1)
133 , payment_term_id NUMBER
134 , price_list_id NUMBER
135 , price_request_code VARCHAR2(240) --PROMOTIONS SEP/01
136 , pricing_date DATE
137 , program_application_id NUMBER
138 , program_id NUMBER
139 , program_update_date DATE
140 , request_date DATE
141 , request_id NUMBER
142 , return_reason_code VARCHAR2(30)
143 , salesrep_id NUMBER
144 , sales_channel_code VARCHAR2(30)
145 , shipment_priority_code VARCHAR2(30)
146 , shipping_method_code VARCHAR2(30)
147 , ship_from_org_id NUMBER
148 , ship_tolerance_above NUMBER
149 , ship_tolerance_below NUMBER
150 , ship_to_contact_id NUMBER
151 , ship_to_org_id NUMBER
152 , sold_from_org_id NUMBER
153 , sold_to_contact_id NUMBER
154 , sold_to_org_id NUMBER
155 , sold_to_phone_id NUMBER
156 , source_document_id NUMBER
157 , source_document_type_id NUMBER
158 , tax_exempt_flag VARCHAR2(30)
159 , tax_exempt_number VARCHAR2(80)
160 , tax_exempt_reason_code VARCHAR2(30)
161 , tax_point_code VARCHAR2(30)
162 , transactional_curr_code VARCHAR2(15)
163 , version_number NUMBER
164 , return_status VARCHAR2(1)
165 , db_flag VARCHAR2(1)
166 , operation VARCHAR2(30)
167 , first_ack_code VARCHAR2(30)
168 , first_ack_date DATE
169 , last_ack_code VARCHAR2(30)
170 , last_ack_date DATE
171 , change_reason VARCHAR2(30)
172 , change_comments VARCHAR2(2000)
173 , change_sequence VARCHAR2(50)
174 , change_request_code VARCHAR2(30)
175 , ready_flag VARCHAR2(1)
176 , status_flag VARCHAR2(1)
177 , force_apply_flag VARCHAR2(1)
178 , drop_ship_flag VARCHAR2(1)
179 , customer_payment_term_id NUMBER
180 , payment_type_code VARCHAR2(30)
181 , payment_amount NUMBER
182 , check_number VARCHAR2(50)
183 , credit_card_code VARCHAR2(80)
184 , credit_card_holder_name VARCHAR2(80)
185 , credit_card_number VARCHAR2(80)
186 , credit_card_expiration_date DATE
187 , credit_card_approval_code VARCHAR2(80)
188 , credit_card_approval_date DATE
189 , shipping_instructions VARCHAR2(2000)
190 , packing_instructions VARCHAR2(2000)
191 , flow_status_code VARCHAR2(30)
192 , booked_date DATE
193 , marketing_source_code_id NUMBER
194 , upgraded_flag VARCHAR2(1)
195 , lock_control NUMBER
196 , ship_to_edi_location_code VARCHAR2(40)
197 , sold_to_edi_location_code VARCHAR2(40)
198 , bill_to_edi_location_code VARCHAR2(40)
199 , ship_from_edi_location_code VARCHAR2(40) -- Ship From Bug 2116166
200 , SHIP_FROM_ADDRESS_ID Number
201 , SOLD_TO_ADDRESS_ID Number
202 , SHIP_TO_ADDRESS_ID Number
203 , INVOICE_ADDRESS_ID Number
204 , SHIP_TO_ADDRESS_CODE Varchar2(40)
205 , xml_message_id Number
206 , ship_to_customer_id NUMBER
207 , invoice_to_customer_id NUMBER
208 , deliver_to_customer_id NUMBER
209 , accounting_rule_duration NUMBER
210 , xml_transaction_type_code Varchar2(30)
211 , Blanket_Number NUMBER
212 , Line_Set_Name VARCHAR2(30)
213 , Fulfillment_Set_Name VARCHAR2(30)
214 , Default_Fulfillment_Set VARCHAR2(1)
215 -- Quoting project related fields
216 , quote_date date
217 , quote_number number
218 , sales_document_name varchar2(240)
219 , transaction_phase_code varchar2(30)
220 , user_status_code varchar2(30)
221 , draft_submitted_flag varchar2(1)
222 , source_document_version_number number
223 , sold_to_site_use_id number
224 --automatic account creation
225 , sold_to_party_id NUMBER
226 , sold_to_org_contact_id NUMBER
227 , ship_to_party_id NUMBER
228 , ship_to_party_site_id NUMBER
229 , ship_to_party_site_use_id NUMBER
230 , deliver_to_party_id NUMBER
231 , deliver_to_party_site_id NUMBER
232 , deliver_to_party_site_use_id NUMBER
233 , invoice_to_party_id NUMBER
234 , invoice_to_party_site_id NUMBER
235 , invoice_to_party_site_use_id NUMBER
236 , ship_to_customer_party_id NUMBER
237 , deliver_to_customer_party_id NUMBER
238 , invoice_to_customer_party_id NUMBER
239 , ship_to_org_contact_id NUMBER
240 , deliver_to_org_contact_id NUMBER
241 , invoice_to_org_contact_id NUMBER,
242 p_char_attribute1 varchar2(240),
243 p_char_attribute2 varchar2(240),
244 p_char_attribute3 varchar2(240),
245 p_char_attribute4 varchar2(240),
246 p_char_attribute5 varchar2(240),
247 p_char_attribute6 varchar2(240),
248 p_char_attribute7 varchar2(240),
249 p_char_attribute8 varchar2(240),
250 p_char_attribute9 varchar2(240),
251 p_char_attribute10 varchar2(240),
252 p_num_attribute1 number,
253 p_num_attribute2 number,
254 p_num_attribute3 number,
255 p_num_attribute4 number,
256 p_num_attribute5 number,
257 p_num_attribute6 number,
258 p_num_attribute7 number,
259 p_num_attribute8 number,
260 p_num_attribute9 number,
261 p_num_attribute10 number,
262 p_date_attribute1 date,
263 p_date_attribute2 date,
264 p_date_attribute3 date,
265 p_date_attribute4 date,
266 p_date_attribute5 date
267 );
268
269 TYPE PA_Header_Tbl_Type IS TABLE OF PA_Header_Rec_Type
270 INDEX BY BINARY_INTEGER;
271
272 -- Header_Adj record type
273
274 TYPE PA_H_Adj_Rec_Type IS RECORD
275 ( attribute1 VARCHAR2(240)
276 , attribute10 VARCHAR2(240)
277 , attribute11 VARCHAR2(240)
278 , attribute12 VARCHAR2(240)
279 , attribute13 VARCHAR2(240)
280 , attribute14 VARCHAR2(240)
281 , attribute15 VARCHAR2(240)
282 , attribute2 VARCHAR2(240)
283 , attribute3 VARCHAR2(240)
284 , attribute4 VARCHAR2(240)
285 , attribute5 VARCHAR2(240)
286 , attribute6 VARCHAR2(240)
287 , attribute7 VARCHAR2(240)
288 , attribute8 VARCHAR2(240)
289 , attribute9 VARCHAR2(240)
290 , automatic_flag VARCHAR2(1)
291 , context VARCHAR2(30)
292 , created_by NUMBER
293 , creation_date DATE
294 , discount_id NUMBER
295 , discount_line_id NUMBER
296 , header_id NUMBER
297 , last_updated_by NUMBER
298 , last_update_date DATE
299 , last_update_login NUMBER
300 , line_id NUMBER
301 , percent NUMBER
302 , price_adjustment_id NUMBER
303 , program_application_id NUMBER
304 , program_id NUMBER
305 , program_update_date DATE
306 , request_id NUMBER
307 , return_status VARCHAR2(1)
308 , db_flag VARCHAR2(1)
309 , operation VARCHAR2(30)
310 , orig_sys_discount_ref VARCHAR2(50)
311 , change_request_code VARCHAR2(30)
312 , status_flag VARCHAR2(1)
313 , list_header_id number
314 , list_line_id number
315 , list_line_type_code varchar2(30)
316 , modifier_mechanism_type_code varchar2(30)
317 , modified_from varchar2(240)
318 , modified_to varchar2(240)
319 , updated_flag varchar2(1)
320 , update_allowed varchar2(1)
321 , applied_flag varchar2(1)
322 , change_reason_code varchar2(30)
323 , change_reason_text varchar2(2000)
324 , operand number
325 , operand_per_pqty number
326 , arithmetic_operator varchar2(30)
327 , cost_id number
328 , tax_code varchar2(50)
329 , tax_exempt_flag varchar2(1)
330 , tax_exempt_number varchar2(80)
331 , tax_exempt_reason_code varchar2(30)
332 , parent_adjustment_id number
333 , invoiced_flag varchar2(1)
334 , estimated_flag varchar2(1)
335 , inc_in_sales_performance varchar2(1)
336 , split_action_code varchar2(30)
337 , adjusted_amount number
338 , adjusted_amount_per_pqty number
339 , pricing_phase_id number
340 , charge_type_code varchar2(30)
341 , charge_subtype_code varchar2(30)
342 , list_line_no varchar2(240)
343 , source_system_code varchar2(30)
344 , benefit_qty number
345 , benefit_uom_code varchar2(3)
346 , print_on_invoice_flag varchar2(1)
347 , expiration_date date
348 , rebate_transaction_type_code varchar2(30)
349 , rebate_transaction_reference varchar2(80)
350 , rebate_payment_system_code varchar2(30)
351 , redeemed_date date
352 , redeemed_flag varchar2(1)
353 , accrual_flag varchar2(1)
354 , range_break_quantity number
355 , accrual_conversion_rate number
356 , pricing_group_sequence number
357 , modifier_level_code varchar2(30)
358 , price_break_type_code varchar2(30)
359 , substitution_attribute varchar2(30)
360 , proration_type_code varchar2(30)
361 , credit_or_charge_flag varchar2(1)
362 , include_on_returns_flag varchar2(1)
363 , ac_attribute1 VARCHAR2(240)
367 , ac_attribute13 VARCHAR2(240)
364 , ac_attribute10 VARCHAR2(240)
365 , ac_attribute11 VARCHAR2(240)
366 , ac_attribute12 VARCHAR2(240)
368 , ac_attribute14 VARCHAR2(240)
369 , ac_attribute15 VARCHAR2(240)
370 , ac_attribute2 VARCHAR2(240)
371 , ac_attribute3 VARCHAR2(240)
372 , ac_attribute4 VARCHAR2(240)
373 , ac_attribute5 VARCHAR2(240)
374 , ac_attribute6 VARCHAR2(240)
375 , ac_attribute7 VARCHAR2(240)
376 , ac_attribute8 VARCHAR2(240)
377 , ac_attribute9 VARCHAR2(240)
378 , ac_context VARCHAR2(150)
379 , lock_control NUMBER
380 , invoiced_amount NUMBER,
381 p_char_attribute1 varchar2(240),
382 p_char_attribute2 varchar2(240),
383 p_char_attribute3 varchar2(240),
384 p_char_attribute4 varchar2(240),
385 p_char_attribute5 varchar2(240),
386 p_char_attribute6 varchar2(240),
387 p_char_attribute7 varchar2(240),
388 p_char_attribute8 varchar2(240),
389 p_char_attribute9 varchar2(240),
390 p_char_attribute10 varchar2(240),
391 p_num_attribute1 number,
392 p_num_attribute2 number,
393 p_num_attribute3 number,
394 p_num_attribute4 number,
395 p_num_attribute5 number,
396 p_num_attribute6 number,
397 p_num_attribute7 number,
398 p_num_attribute8 number,
399 p_num_attribute9 number,
400 p_num_attribute10 number,
401 p_date_attribute1 date,
402 p_date_attribute2 date,
403 p_date_attribute3 date,
404 p_date_attribute4 date,
405 p_date_attribute5 date
406 );
407
408 TYPE PA_H_Adj_Tbl_Type IS TABLE OF PA_H_Adj_Rec_Type
409 INDEX BY BINARY_INTEGER;
410
411
412 Type PA_H_Adj_AsRec_Type is RECORD
413 (
414 price_adj_assoc_id number
415 , line_id number
416 , Line_Index number
417 , price_adjustment_id number
418 , Adj_index NUMBER
419 , rltd_Price_Adj_Id number
420 , Rltd_Adj_Index NUMBER
421 , creation_date date
422 , created_by number
423 , last_update_date date
424 , last_updated_by number
425 , last_update_login number
426 , program_application_id number
427 , program_id number
428 , program_update_date date
429 , request_id number
430 , return_status VARCHAR2(1)
431 , db_flag VARCHAR2(1)
432 , operation VARCHAR2(30)
433 , lock_control NUMBER,
434 p_char_attribute1 varchar2(240),
435 p_char_attribute2 varchar2(240),
436 p_char_attribute3 varchar2(240),
437 p_char_attribute4 varchar2(240),
438 p_char_attribute5 varchar2(240),
439 p_char_attribute6 varchar2(240),
440 p_char_attribute7 varchar2(240),
441 p_char_attribute8 varchar2(240),
442 p_char_attribute9 varchar2(240),
443 p_char_attribute10 varchar2(240),
444 p_num_attribute1 number,
445 p_num_attribute2 number,
446 p_num_attribute3 number,
447 p_num_attribute4 number,
448 p_num_attribute5 number,
449 p_num_attribute6 number,
450 p_num_attribute7 number,
451 p_num_attribute8 number,
452 p_num_attribute9 number,
453 p_num_attribute10 number,
454 p_date_attribute1 date,
455 p_date_attribute2 date,
456 p_date_attribute3 date,
457 p_date_attribute4 date,
458 p_date_attribute5 date
459 );
460
461
462 TYPE PA_H_Adj_AsTbl_Type is TABLE of PA_H_Adj_Asrec_Type
463 INDEX by BINARY_INTEGER;
464
465
466
467 -- Header_Price_Att_Rec_Type
468
469 TYPE PA_H_PAtt_Rec_Type IS RECORD
470 ( order_price_attrib_id number
471 , header_id number
472 , line_id number
473 , creation_date date
474 , created_by number
475 , last_update_date date
476 , last_updated_by number
477 , last_update_login number
478 , program_application_id number
479 , program_id number
480 , program_update_date date
481 , request_id number
482 , flex_title varchar2(60)
483 , pricing_context varchar2(30)
484 , pricing_attribute1 varchar2(240)
485 , pricing_attribute2 varchar2(240)
486 , pricing_attribute3 varchar2(240)
487 , pricing_attribute4 varchar2(240)
488 , pricing_attribute5 varchar2(240)
489 , pricing_attribute6 varchar2(240)
490 , pricing_attribute7 varchar2(240)
491 , pricing_attribute8 varchar2(240)
492 , pricing_attribute9 varchar2(240)
493 , pricing_attribute10 varchar2(240)
494 , pricing_attribute11 varchar2(240)
495 , pricing_attribute12 varchar2(240)
496 , pricing_attribute13 varchar2(240)
497 , pricing_attribute14 varchar2(240)
498 , pricing_attribute15 varchar2(240)
499 , pricing_attribute16 varchar2(240)
500 , pricing_attribute17 varchar2(240)
504 , pricing_attribute21 varchar2(240)
501 , pricing_attribute18 varchar2(240)
502 , pricing_attribute19 varchar2(240)
503 , pricing_attribute20 varchar2(240)
505 , pricing_attribute22 varchar2(240)
506 , pricing_attribute23 varchar2(240)
507 , pricing_attribute24 varchar2(240)
508 , pricing_attribute25 varchar2(240)
509 , pricing_attribute26 varchar2(240)
510 , pricing_attribute27 varchar2(240)
511 , pricing_attribute28 varchar2(240)
512 , pricing_attribute29 varchar2(240)
513 , pricing_attribute30 varchar2(240)
514 , pricing_attribute31 varchar2(240)
515 , pricing_attribute32 varchar2(240)
516 , pricing_attribute33 varchar2(240)
517 , pricing_attribute34 varchar2(240)
518 , pricing_attribute35 varchar2(240)
519 , pricing_attribute36 varchar2(240)
520 , pricing_attribute37 varchar2(240)
521 , pricing_attribute38 varchar2(240)
522 , pricing_attribute39 varchar2(240)
523 , pricing_attribute40 varchar2(240)
524 , pricing_attribute41 varchar2(240)
525 , pricing_attribute42 varchar2(240)
526 , pricing_attribute43 varchar2(240)
527 , pricing_attribute44 varchar2(240)
528 , pricing_attribute45 varchar2(240)
529 , pricing_attribute46 varchar2(240)
530 , pricing_attribute47 varchar2(240)
531 , pricing_attribute48 varchar2(240)
532 , pricing_attribute49 varchar2(240)
533 , pricing_attribute50 varchar2(240)
534 , pricing_attribute51 varchar2(240)
535 , pricing_attribute52 varchar2(240)
536 , pricing_attribute53 varchar2(240)
537 , pricing_attribute54 varchar2(240)
538 , pricing_attribute55 varchar2(240)
539 , pricing_attribute56 varchar2(240)
540 , pricing_attribute57 varchar2(240)
541 , pricing_attribute58 varchar2(240)
542 , pricing_attribute59 varchar2(240)
543 , pricing_attribute60 varchar2(240)
544 , pricing_attribute61 varchar2(240)
545 , pricing_attribute62 varchar2(240)
546 , pricing_attribute63 varchar2(240)
547 , pricing_attribute64 varchar2(240)
548 , pricing_attribute65 varchar2(240)
549 , pricing_attribute66 varchar2(240)
550 , pricing_attribute67 varchar2(240)
551 , pricing_attribute68 varchar2(240)
552 , pricing_attribute69 varchar2(240)
553 , pricing_attribute70 varchar2(240)
554 , pricing_attribute71 varchar2(240)
555 , pricing_attribute72 varchar2(240)
556 , pricing_attribute73 varchar2(240)
557 , pricing_attribute74 varchar2(240)
558 , pricing_attribute75 varchar2(240)
559 , pricing_attribute76 varchar2(240)
560 , pricing_attribute77 varchar2(240)
561 , pricing_attribute78 varchar2(240)
562 , pricing_attribute79 varchar2(240)
563 , pricing_attribute80 varchar2(240)
564 , pricing_attribute81 varchar2(240)
565 , pricing_attribute82 varchar2(240)
566 , pricing_attribute83 varchar2(240)
567 , pricing_attribute84 varchar2(240)
568 , pricing_attribute85 varchar2(240)
569 , pricing_attribute86 varchar2(240)
570 , pricing_attribute87 varchar2(240)
571 , pricing_attribute88 varchar2(240)
572 , pricing_attribute89 varchar2(240)
573 , pricing_attribute90 varchar2(240)
574 , pricing_attribute91 varchar2(240)
575 , pricing_attribute92 varchar2(240)
576 , pricing_attribute93 varchar2(240)
577 , pricing_attribute94 varchar2(240)
578 , pricing_attribute95 varchar2(240)
579 , pricing_attribute96 varchar2(240)
580 , pricing_attribute97 varchar2(240)
581 , pricing_attribute98 varchar2(240)
582 , pricing_attribute99 varchar2(240)
583 , pricing_attribute100 varchar2(240)
584 , context varchar2(30)
585 , attribute1 varchar2(240)
586 , attribute2 varchar2(240)
587 , attribute3 varchar2(240)
588 , attribute4 varchar2(240)
589 , attribute5 varchar2(240)
590 , attribute6 varchar2(240)
591 , attribute7 varchar2(240)
592 , attribute8 varchar2(240)
596 , attribute12 varchar2(240)
593 , attribute9 varchar2(240)
594 , attribute10 varchar2(240)
595 , attribute11 varchar2(240)
597 , attribute13 varchar2(240)
598 , attribute14 varchar2(240)
599 , attribute15 varchar2(240)
600 , Override_Flag varchar2(1)
601 , return_status VARCHAR2(1)
602 , db_flag VARCHAR2(1)
603 , operation VARCHAR2(30)
604 , lock_control NUMBER
605 , orig_sys_atts_ref VARCHAR2(50) --1433292
606 , change_request_code VARCHAR2(30),
607 p_char_attribute1 varchar2(240),
608 p_char_attribute2 varchar2(240),
609 p_char_attribute3 varchar2(240),
610 p_char_attribute4 varchar2(240),
611 p_char_attribute5 varchar2(240),
612 p_char_attribute6 varchar2(240),
613 p_char_attribute7 varchar2(240),
614 p_char_attribute8 varchar2(240),
615 p_char_attribute9 varchar2(240),
616 p_char_attribute10 varchar2(240),
617 p_num_attribute1 number,
618 p_num_attribute2 number,
619 p_num_attribute3 number,
620 p_num_attribute4 number,
621 p_num_attribute5 number,
622 p_num_attribute6 number,
623 p_num_attribute7 number,
624 p_num_attribute8 number,
625 p_num_attribute9 number,
626 p_num_attribute10 number,
627 p_date_attribute1 date,
628 p_date_attribute2 date,
629 p_date_attribute3 date,
630 p_date_attribute4 date,
631 p_date_attribute5 date
632
633 )
634 ;
635
636 TYPE PA_H_PAtt_Tbl_Type is TABLE of PA_H_PAtt_rec_Type
637 INDEX by BINARY_INTEGER;
638
639 Type PA_H_Adj_Att_Rec_Type is RECORD
640 ( price_adj_attrib_id number
641 , price_adjustment_id number
642 , Adj_index NUMBER
643 , flex_title varchar2(60)
644 , pricing_context varchar2(30)
645 , pricing_attribute varchar2(30)
646 , creation_date date
647 , created_by number
648 , last_update_date date
649 , last_updated_by number
650 , last_update_login number
651 , program_application_id number
652 , program_id number
653 , program_update_date date
654 , request_id number
655 , pricing_attr_value_from varchar2(240)
656 , pricing_attr_value_to varchar2(240)
657 , comparison_operator varchar2(30)
658 , return_status VARCHAR2(1)
659 , db_flag VARCHAR2(1)
660 , operation VARCHAR2(30)
661 , lock_control NUMBER,
662 p_char_attribute1 varchar2(240),
663 p_char_attribute2 varchar2(240),
664 p_char_attribute3 varchar2(240),
665 p_char_attribute4 varchar2(240),
666 p_char_attribute5 varchar2(240),
667 p_char_attribute6 varchar2(240),
668 p_char_attribute7 varchar2(240),
669 p_char_attribute8 varchar2(240),
670 p_char_attribute9 varchar2(240),
671 p_char_attribute10 varchar2(240),
672 p_num_attribute1 number,
673 p_num_attribute2 number,
674 p_num_attribute3 number,
675 p_num_attribute4 number,
676 p_num_attribute5 number,
677 p_num_attribute6 number,
678 p_num_attribute7 number,
679 p_num_attribute8 number,
680 p_num_attribute9 number,
681 p_num_attribute10 number,
682 p_date_attribute1 date,
683 p_date_attribute2 date,
684 p_date_attribute3 date,
685 p_date_attribute4 date,
686 p_date_attribute5 date
687 );
688
689
690 TYPE PA_H_Adj_Att_Tbl_Type is TABLE of PA_H_Adj_Att_rec_Type
691 INDEX by BINARY_INTEGER;
692
693
694 -- Line record type
695
696 TYPE PA_Line_Rec_Type IS RECORD
697 ( accounting_rule_id NUMBER
698 , actual_arrival_date DATE
699 , actual_shipment_date DATE
700 , agreement_id NUMBER
701 , arrival_set_id NUMBER
702 , ato_line_id NUMBER
703 , attribute1 VARCHAR2(240)
704 , attribute10 VARCHAR2(240)
705 , attribute11 VARCHAR2(240)
706 , attribute12 VARCHAR2(240)
707 , attribute13 VARCHAR2(240)
708 , attribute14 VARCHAR2(240)
709 , attribute15 VARCHAR2(240)
710 , attribute16 VARCHAR2(240)
711 , attribute17 VARCHAR2(240)
712 , attribute18 VARCHAR2(240)
713 , attribute19 VARCHAR2(240)
714 , attribute2 VARCHAR2(240)
715 , attribute20 VARCHAR2(240)
716 , attribute3 VARCHAR2(240)
717 , attribute4 VARCHAR2(240)
718 , attribute5 VARCHAR2(240)
719 , attribute6 VARCHAR2(240)
720 , attribute7 VARCHAR2(240)
721 , attribute8 VARCHAR2(240)
722 , attribute9 VARCHAR2(240)
723 , authorized_to_ship_flag VARCHAR2(1)
724 , auto_selected_quantity NUMBER
725 , booked_flag VARCHAR2(1)
726 , cancelled_flag VARCHAR2(1)
727 , cancelled_quantity NUMBER
728 , cancelled_quantity2 NUMBER
729 , commitment_id NUMBER
730 , component_code VARCHAR2(1000)
731 , component_number NUMBER
732 , component_sequence_id NUMBER
733 , config_header_id NUMBER
734 , config_rev_nbr NUMBER
735 , config_display_sequence NUMBER
736 , configuration_id NUMBER
737 , context VARCHAR2(30)
738 , created_by NUMBER
739 , creation_date DATE
740 , credit_invoice_line_id NUMBER
741 , customer_dock_code VARCHAR2(50)
742 , customer_job VARCHAR2(50)
743 , customer_production_line VARCHAR2(50)
744 , customer_trx_line_id NUMBER
745 , cust_model_serial_number VARCHAR2(50)
746 , cust_po_number VARCHAR2(50)
747 , cust_production_seq_num VARCHAR2(50)
748 , delivery_lead_time NUMBER
749 , deliver_to_contact_id NUMBER
750 , deliver_to_org_id NUMBER
751 , demand_bucket_type_code VARCHAR2(30)
752 , demand_class_code VARCHAR2(30)
753 , dep_plan_required_flag VARCHAR2(1)
754 , earliest_acceptable_date DATE
755 , end_item_unit_number VARCHAR2(30)
756 , explosion_date DATE
757 , fob_point_code VARCHAR2(30)
758 , freight_carrier_code VARCHAR2(30)
759 , freight_terms_code VARCHAR2(30)
760 , fulfilled_quantity NUMBER
761 , fulfilled_quantity2 NUMBER
762 , global_attribute1 VARCHAR2(240)
763 , global_attribute10 VARCHAR2(240)
764 , global_attribute11 VARCHAR2(240)
765 , global_attribute12 VARCHAR2(240)
766 , global_attribute13 VARCHAR2(240)
767 , global_attribute14 VARCHAR2(240)
768 , global_attribute15 VARCHAR2(240)
769 , global_attribute16 VARCHAR2(240)
770 , global_attribute17 VARCHAR2(240)
771 , global_attribute18 VARCHAR2(240)
772 , global_attribute19 VARCHAR2(240)
773 , global_attribute2 VARCHAR2(240)
774 , global_attribute20 VARCHAR2(240)
775 , global_attribute3 VARCHAR2(240)
776 , global_attribute4 VARCHAR2(240)
777 , global_attribute5 VARCHAR2(240)
778 , global_attribute6 VARCHAR2(240)
779 , global_attribute7 VARCHAR2(240)
780 , global_attribute8 VARCHAR2(240)
781 , global_attribute9 VARCHAR2(240)
782 , global_attribute_category VARCHAR2(30)
783 , header_id NUMBER
784 , industry_attribute1 VARCHAR2(240)
785 , industry_attribute10 VARCHAR2(240)
786 , industry_attribute11 VARCHAR2(240)
787 , industry_attribute12 VARCHAR2(240)
788 , industry_attribute13 VARCHAR2(240)
789 , industry_attribute14 VARCHAR2(240)
790 , industry_attribute15 VARCHAR2(240)
791 , industry_attribute16 VARCHAR2(240)
792 , industry_attribute17 VARCHAR2(240)
793 , industry_attribute18 VARCHAR2(240)
794 , industry_attribute19 VARCHAR2(240)
795 , industry_attribute20 VARCHAR2(240)
796 , industry_attribute21 VARCHAR2(240)
797 , industry_attribute22 VARCHAR2(240)
798 , industry_attribute23 VARCHAR2(240)
799 , industry_attribute24 VARCHAR2(240)
800 , industry_attribute25 VARCHAR2(240)
801 , industry_attribute26 VARCHAR2(240)
802 , industry_attribute27 VARCHAR2(240)
803 , industry_attribute28 VARCHAR2(240)
804 , industry_attribute29 VARCHAR2(240)
805 , industry_attribute30 VARCHAR2(240)
806 , industry_attribute2 VARCHAR2(240)
807 , industry_attribute3 VARCHAR2(240)
808 , industry_attribute4 VARCHAR2(240)
809 , industry_attribute5 VARCHAR2(240)
810 , industry_attribute6 VARCHAR2(240)
811 , industry_attribute7 VARCHAR2(240)
812 , industry_attribute8 VARCHAR2(240)
813 , industry_attribute9 VARCHAR2(240)
814 , industry_context VARCHAR2(30)
815 , TP_CONTEXT VARCHAR2(30)
816 , TP_ATTRIBUTE1 VARCHAR2(240)
817 , TP_ATTRIBUTE2 VARCHAR2(240)
818 , TP_ATTRIBUTE3 VARCHAR2(240)
819 , TP_ATTRIBUTE4 VARCHAR2(240)
820 , TP_ATTRIBUTE5 VARCHAR2(240)
821 , TP_ATTRIBUTE6 VARCHAR2(240)
822 , TP_ATTRIBUTE7 VARCHAR2(240)
823 , TP_ATTRIBUTE8 VARCHAR2(240)
824 , TP_ATTRIBUTE9 VARCHAR2(240)
825 , TP_ATTRIBUTE10 VARCHAR2(240)
826 , TP_ATTRIBUTE11 VARCHAR2(240)
827 , TP_ATTRIBUTE12 VARCHAR2(240)
828 , TP_ATTRIBUTE13 VARCHAR2(240)
829 , TP_ATTRIBUTE14 VARCHAR2(240)
830 , TP_ATTRIBUTE15 VARCHAR2(240)
831 , intermed_ship_to_org_id NUMBER
832 , intermed_ship_to_contact_id NUMBER
833 , inventory_item_id NUMBER
834 , invoice_interface_status_code VARCHAR2(30)
835 , invoice_to_contact_id NUMBER
836 , invoice_to_org_id NUMBER
837 , invoicing_rule_id NUMBER
838 , ordered_item VARCHAR2(2000)
839 , item_revision VARCHAR2(3)
840 , item_type_code VARCHAR2(30)
841 , last_updated_by NUMBER
842 , last_update_date DATE
843 , last_update_login NUMBER
844 , latest_acceptable_date DATE
845 , line_category_code VARCHAR2(30)
846 , line_id NUMBER
847 , line_number NUMBER
848 , line_type_id NUMBER
849 , link_to_line_ref VARCHAR2(50)
850 , link_to_line_id NUMBER
851 , link_to_line_index NUMBER
852 , model_group_number NUMBER
853 , mfg_component_sequence_id NUMBER
854 , mfg_lead_time NUMBER
855 , open_flag VARCHAR2(1)
856 , option_flag VARCHAR2(1)
857 , option_number NUMBER
858 , ordered_quantity NUMBER
859 , ordered_quantity2 NUMBER
860 , order_quantity_uom VARCHAR2(3)
861 , ordered_quantity_uom2 VARCHAR2(3)
862 , org_id NUMBER
863 , orig_sys_document_ref VARCHAR2(50)
864 , orig_sys_line_ref VARCHAR2(50)
865 , over_ship_reason_code VARCHAR2(30)
866 , over_ship_resolved_flag VARCHAR2(1)
867 , payment_term_id NUMBER
868 , planning_priority NUMBER
869 , preferred_grade VARCHAR2(150) -- -- INVCONV 4091955
870 , price_list_id NUMBER
871 , price_request_code VARCHAR2(240) --PROMOTIONS SEP/01
872 , pricing_attribute1 VARCHAR2(240)
873 , pricing_attribute10 VARCHAR2(240)
874 , pricing_attribute2 VARCHAR2(240)
875 , pricing_attribute3 VARCHAR2(240)
876 , pricing_attribute4 VARCHAR2(240)
877 , pricing_attribute5 VARCHAR2(240)
878 , pricing_attribute6 VARCHAR2(240)
879 , pricing_attribute7 VARCHAR2(240)
880 , pricing_attribute8 VARCHAR2(240)
881 , pricing_attribute9 VARCHAR2(240)
882 , pricing_context VARCHAR2(240)
883 , pricing_date DATE
884 , pricing_quantity NUMBER
885 , pricing_quantity_uom VARCHAR2(3)
886 , program_application_id NUMBER
887 , program_id NUMBER
888 , program_update_date DATE
889 , project_id NUMBER
890 , promise_date DATE
891 , re_source_flag VARCHAR2(1)
892 , reference_customer_trx_line_id NUMBER
893 , reference_header_id NUMBER
894 , reference_line_id NUMBER
895 , reference_type VARCHAR2(30)
896 , request_date DATE
897 , request_id NUMBER
898 , reserved_quantity NUMBER
899 , return_attribute1 VARCHAR2(240)
900 , return_attribute10 VARCHAR2(240)
901 , return_attribute11 VARCHAR2(240)
902 , return_attribute12 VARCHAR2(240)
903 , return_attribute13 VARCHAR2(240)
904 , return_attribute14 VARCHAR2(240)
905 , return_attribute15 VARCHAR2(240)
906 , return_attribute2 VARCHAR2(240)
907 , return_attribute3 VARCHAR2(240)
908 , return_attribute4 VARCHAR2(240)
909 , return_attribute5 VARCHAR2(240)
910 , return_attribute6 VARCHAR2(240)
911 , return_attribute7 VARCHAR2(240)
912 , return_attribute8 VARCHAR2(240)
913 , return_attribute9 VARCHAR2(240)
914 , return_context VARCHAR2(30)
915 , return_reason_code VARCHAR2(30)
916 , rla_schedule_type_code VARCHAR2(30)
917 , salesrep_id NUMBER
918 , schedule_arrival_date DATE
919 , schedule_ship_date DATE
920 , schedule_action_code VARCHAR2(30)
921 , schedule_status_code VARCHAR2(30)
922 , shipment_number NUMBER
923 , shipment_priority_code VARCHAR2(30)
924 , shipped_quantity NUMBER
925 , shipped_quantity2 NUMBER
926 , shipping_interfaced_flag VARCHAR2(1)
927 , shipping_method_code VARCHAR2(30)
928 , shipping_quantity NUMBER
929 , shipping_quantity2 NUMBER
930 , shipping_quantity_uom VARCHAR2(3)
931 , shipping_quantity_uom2 VARCHAR2(3)
932 , ship_from_org_id NUMBER
933 , ship_model_complete_flag VARCHAR2(30)
934 , ship_set_id NUMBER
935 , fulfillment_set_id NUMBER
936 , ship_tolerance_above NUMBER
937 , ship_tolerance_below NUMBER
938 , ship_to_contact_id NUMBER
939 , ship_to_org_id NUMBER
940 , sold_to_org_id NUMBER
941 , sold_from_org_id NUMBER
942 , sort_order VARCHAR2(2000)
943 , source_document_id NUMBER
944 , source_document_line_id NUMBER
945 , source_document_type_id NUMBER
946 , source_type_code VARCHAR2(30)
947 , split_from_line_id NUMBER
948 , task_id NUMBER
949 , tax_code VARCHAR2(50)
950 , tax_date DATE
951 , tax_exempt_flag VARCHAR2(30)
952 , tax_exempt_number VARCHAR2(80)
953 , tax_exempt_reason_code VARCHAR2(30)
954 , tax_point_code VARCHAR2(30)
955 , tax_rate NUMBER
956 , tax_value NUMBER
957 , top_model_line_ref VARCHAR2(50)
958 , top_model_line_id NUMBER
959 , top_model_line_index NUMBER
960 , unit_list_price NUMBER
961 , unit_list_price_per_pqty NUMBER
962 , unit_selling_price NUMBER
963 , unit_selling_price_per_pqty NUMBER
964 , veh_cus_item_cum_key_id NUMBER
965 , visible_demand_flag VARCHAR2(1)
966 , return_status VARCHAR2(1)
967 , db_flag VARCHAR2(1)
968 , operation VARCHAR2(30)
969 , first_ack_code VARCHAR2(30)
970 , first_ack_date DATE
971 , last_ack_code VARCHAR2(30)
972 , last_ack_date DATE
973 , change_reason VARCHAR2(30)
974 , change_comments VARCHAR2(2000)
975 , arrival_set VARCHAR2(30)
976 , ship_set VARCHAR2(30)
977 , fulfillment_set VARCHAR2(30)
978 , order_source_id NUMBER
979 , orig_sys_shipment_ref VARCHAR2(50)
980 , change_sequence VARCHAR2(50)
981 , change_request_code VARCHAR2(30)
982 , status_flag VARCHAR2(1)
983 , drop_ship_flag VARCHAR2(1)
984 , customer_line_number VARCHAR2(50)
985 , customer_shipment_number VARCHAR2(50)
986 , customer_item_net_price NUMBER
987 , customer_payment_term_id NUMBER
988 , ordered_item_id NUMBER
989 , item_identifier_type VARCHAR2(25)
990 , shipping_instructions VARCHAR2(2000)
991 , packing_instructions VARCHAR2(2000)
992 , calculate_price_flag VARCHAR2(1)
993 , invoiced_quantity NUMBER
994 , service_txn_reason_code VARCHAR2(30)
995 , service_txn_comments VARCHAR2(2000)
996 , service_duration NUMBER
997 , service_period VARCHAR2(3)
998 , service_start_date DATE
999 , service_end_date DATE
1000 , service_coterminate_flag VARCHAR2(1)
1001 , unit_list_percent NUMBER
1002 , unit_selling_percent NUMBER
1003 , unit_percent_base_price NUMBER
1004 , service_number NUMBER
1005 , service_reference_type_code VARCHAR2(30)
1006 , service_reference_line_id NUMBER
1007 , service_reference_system_id NUMBER
1008 , service_ref_order_number NUMBER
1009 , service_ref_line_number NUMBER
1010 , service_reference_order VARCHAR2(50)
1011 , service_reference_line VARCHAR2(50)
1012 , service_reference_system VARCHAR2(50)
1013 , service_ref_shipment_number NUMBER
1014 , service_ref_option_number NUMBER
1015 , service_line_index NUMBER
1016 , Line_set_id NUMBER
1017 , split_by VARCHAR2(240)
1018 , Split_Action_Code VARCHAR2(30)
1019 , shippable_flag VARCHAR2(1)
1020 , model_remnant_flag VARCHAR2(1)
1021 , flow_status_code VARCHAR2(30)
1022 , fulfilled_flag VARCHAR2(1)
1023 , fulfillment_method_code VARCHAR2(30)
1024 , revenue_amount NUMBER
1025 , marketing_source_code_id NUMBER
1026 , fulfillment_date DATE
1027 , semi_processed_flag BOOLEAN
1028 , upgraded_flag VARCHAR2(1)
1029 , lock_control NUMBER
1030 , subinventory VARCHAR2(10)
1031 , split_from_line_ref VARCHAR2(50)
1032 , split_from_shipment_ref VARCHAR2(50)
1033 , ship_to_edi_location_code VARCHAR2(40)
1034 , Bill_to_Edi_Location_Code VARCHAR2(40) -- Ship From Bug 2116166
1035 , ship_from_edi_location_code VARCHAR2(40)
1036 , Ship_from_address_id NUMBER
1037 , Sold_to_address_id NUMBER
1038 , Ship_to_address_id NUMBER
1039 , Invoice_address_id NUMBER
1040 , Ship_to_address_code VARCHAR2(40)
1041 , Original_Inventory_Item_Id NUMBER
1042 , Original_item_identifier_Type VARCHAR2(30)
1043 , Original_ordered_item_id NUMBER
1044 , Original_ordered_item VARCHAR2(2000)
1045 , Item_substitution_type_code VARCHAR2(30)
1046 , Late_Demand_Penalty_Factor NUMBER
1047 , Override_atp_date_code VARCHAR2(30)
1048 , ship_to_customer_id NUMBER
1052 , unit_cost NUMBER
1049 , invoice_to_customer_id NUMBER
1050 , deliver_to_customer_id NUMBER
1051 , accounting_rule_duration NUMBER
1053 , user_item_description VARCHAR2(1000)
1054 , xml_transaction_type_code Varchar2(30)
1055 , item_relationship_type NUMBER
1056 , Blanket_Number NUMBER
1057 , Blanket_Line_Number NUMBER
1058 , Blanket_Version_Number NUMBER
1059 , cso_response_flag VARCHAR2(1)
1060 , Firm_demand_flag VARCHAR2(1)
1061 , Earliest_ship_date DATE
1062 -- Quoting project related fields
1063 , transaction_phase_code varchar2(30)
1064 , source_document_version_number number
1065 -- End Quoting project related fields
1066 -- automatic account creation
1067 , ship_to_party_id NUMBER
1068 , ship_to_party_site_id NUMBER
1069 , ship_to_party_site_use_id NUMBER
1070 , deliver_to_party_id NUMBER
1071 , deliver_to_party_site_id NUMBER
1072 , deliver_to_party_site_use_id NUMBER
1073 , invoice_to_party_id NUMBER
1074 , invoice_to_party_site_id NUMBER
1075 , invoice_to_party_site_use_id NUMBER
1076 , ship_to_customer_party_id NUMBER
1077 , deliver_to_customer_party_id NUMBER
1078 , invoice_to_customer_party_id NUMBER
1079 , ship_to_org_contact_id NUMBER
1080 , deliver_to_org_contact_id NUMBER
1081 , invoice_to_org_contact_id NUMBER,
1082 p_char_attribute1 varchar2(240),
1083 p_char_attribute2 varchar2(240),
1084 p_char_attribute3 varchar2(240),
1085 p_char_attribute4 varchar2(240),
1086 p_char_attribute5 varchar2(240),
1087 p_char_attribute6 varchar2(240),
1088 p_char_attribute7 varchar2(240),
1089 p_char_attribute8 varchar2(240),
1090 p_char_attribute9 varchar2(240),
1091 p_char_attribute10 varchar2(240),
1092 p_num_attribute1 number,
1093 p_num_attribute2 number,
1094 p_num_attribute3 number,
1095 p_num_attribute4 number,
1096 p_num_attribute5 number,
1097 p_num_attribute6 number,
1098 p_num_attribute7 number,
1099 p_num_attribute8 number,
1100 p_num_attribute9 number,
1101 p_num_attribute10 number,
1102 p_date_attribute1 date,
1103 p_date_attribute2 date,
1104 p_date_attribute3 date,
1105 p_date_attribute4 date,
1106 p_date_attribute5 date
1107 );
1108
1109 TYPE PA_Line_Tbl_Type IS TABLE OF PA_Line_Rec_Type
1110 INDEX BY BINARY_INTEGER;
1111
1112
1113 -- Line_Adj record type
1114
1115 TYPE PA_LAdj_Rec_Type IS RECORD
1116 ( attribute1 VARCHAR2(240)
1117 , attribute10 VARCHAR2(240)
1118 , attribute11 VARCHAR2(240)
1119 , attribute12 VARCHAR2(240)
1120 , attribute13 VARCHAR2(240)
1121 , attribute14 VARCHAR2(240)
1122 , attribute15 VARCHAR2(240)
1123 , attribute2 VARCHAR2(240)
1124 , attribute3 VARCHAR2(240)
1125 , attribute4 VARCHAR2(240)
1126 , attribute5 VARCHAR2(240)
1127 , attribute6 VARCHAR2(240)
1128 , attribute7 VARCHAR2(240)
1129 , attribute8 VARCHAR2(240)
1130 , attribute9 VARCHAR2(240)
1131 , automatic_flag VARCHAR2(1)
1132 , context VARCHAR2(30)
1133 , created_by NUMBER
1134 , creation_date DATE
1135 , discount_id NUMBER
1136 , discount_line_id NUMBER
1137 , header_id NUMBER
1138 , last_updated_by NUMBER
1139 , last_update_date DATE
1140 , last_update_login NUMBER
1141 , line_id NUMBER
1142 , percent NUMBER
1143 , price_adjustment_id NUMBER
1144 , program_application_id NUMBER
1145 , program_id NUMBER
1146 , program_update_date DATE
1147 , request_id NUMBER
1148 , return_status VARCHAR2(1)
1149 , db_flag VARCHAR2(1)
1150 , operation VARCHAR2(30)
1151 , line_index NUMBER
1152 , orig_sys_discount_ref VARCHAR2(50)
1153 , change_request_code VARCHAR2(30)
1154 , status_flag VARCHAR2(1)
1155 , list_header_id NUMBER
1156 , list_line_id NUMBER
1157 , list_line_type_code VARCHAR2(30)
1158 , modifier_mechanism_type_code VARCHAR2(30)
1159 , modified_from VARCHAR2(240)
1160 , modified_to VARCHAR2(240)
1161 , updated_flag VARCHAR2(1)
1162 , update_allowed VARCHAR2(1)
1163 , applied_flag VARCHAR2(1)
1164 , change_reason_code VARCHAR2(30)
1165 , change_reason_text VARCHAR2(2000)
1166 , operand NUMBER
1167 , operand_per_pqty NUMBER
1168 , arithmetic_operator VARCHAR2(30)
1169 , cost_id NUMBER
1170 , tax_code VARCHAR2(50)
1171 , tax_exempt_flag VARCHAR2(1)
1172 , tax_exempt_number VARCHAR2(80)
1173 , tax_exempt_reason_code VARCHAR2(30)
1174 , parent_adjustment_id NUMBER
1175 , invoiced_flag VARCHAR2(1)
1176 , estimated_flag VARCHAR2(1)
1177 , inc_in_sales_performance VARCHAR2(1)
1178 , split_action_code VARCHAR2(30)
1179 , adjusted_amount NUMBER
1180 , adjusted_amount_per_pqty NUMBER
1181 , pricing_phase_id NUMBER
1182 , charge_type_code VARCHAR2(30)
1183 , charge_subtype_code VARCHAR2(30)
1184 , list_line_no varchar2(240)
1185 , source_system_code varchar2(30)
1186 , benefit_qty number
1187 , benefit_uom_code varchar2(3)
1188 , print_on_invoice_flag varchar2(1)
1189 , expiration_date date
1190 , rebate_transaction_type_code varchar2(30)
1191 , rebate_transaction_reference varchar2(80)
1192 , rebate_payment_system_code varchar2(30)
1193 , redeemed_date date
1194 , redeemed_flag varchar2(1)
1195 , accrual_flag varchar2(1)
1196 , range_break_quantity number
1197 , accrual_conversion_rate number
1198 , pricing_group_sequence number
1199 , modifier_level_code varchar2(30)
1200 , price_break_type_code varchar2(30)
1201 , substitution_attribute varchar2(30)
1202 , proration_type_code varchar2(30)
1203 , credit_or_charge_flag varchar2(1)
1204 , include_on_returns_flag varchar2(1)
1205 , ac_attribute1 VARCHAR2(240)
1206 , ac_attribute10 VARCHAR2(240)
1207 , ac_attribute11 VARCHAR2(240)
1208 , ac_attribute12 VARCHAR2(240)
1209 , ac_attribute13 VARCHAR2(240)
1210 , ac_attribute14 VARCHAR2(240)
1211 , ac_attribute15 VARCHAR2(240)
1212 , ac_attribute2 VARCHAR2(240)
1213 , ac_attribute3 VARCHAR2(240)
1214 , ac_attribute4 VARCHAR2(240)
1215 , ac_attribute5 VARCHAR2(240)
1216 , ac_attribute6 VARCHAR2(240)
1217 , ac_attribute7 VARCHAR2(240)
1218 , ac_attribute8 VARCHAR2(240)
1219 , ac_attribute9 VARCHAR2(240)
1220 , ac_context VARCHAR2(150)
1221 , lock_control NUMBER
1222 , group_value NUMBER
1223 , invoiced_amount NUMBER,
1224 p_char_attribute1 varchar2(240),
1225 p_char_attribute2 varchar2(240),
1226 p_char_attribute3 varchar2(240),
1227 p_char_attribute4 varchar2(240),
1228 p_char_attribute5 varchar2(240),
1229 p_char_attribute6 varchar2(240),
1230 p_char_attribute7 varchar2(240),
1231 p_char_attribute8 varchar2(240),
1232 p_char_attribute9 varchar2(240),
1233 p_char_attribute10 varchar2(240),
1234 p_num_attribute1 number,
1235 p_num_attribute2 number,
1236 p_num_attribute3 number,
1237 p_num_attribute4 number,
1238 p_num_attribute5 number,
1239 p_num_attribute6 number,
1240 p_num_attribute7 number,
1241 p_num_attribute8 number,
1242 p_num_attribute9 number,
1243 p_num_attribute10 number,
1244 p_date_attribute1 date,
1245 p_date_attribute2 date,
1246 p_date_attribute3 date,
1247 p_date_attribute4 date,
1248 p_date_attribute5 date
1249 );
1250
1251 TYPE PA_LAdj_Tbl_Type IS TABLE OF PA_LAdj_Rec_Type
1252 INDEX BY BINARY_INTEGER;
1253
1254 -- Line_Price_Att_Rec_Type
1255
1256 TYPE PA_Line_PAtt_Rec_Type IS RECORD
1257 ( order_price_attrib_id number
1258 , header_id number
1259 , line_id number
1260 , line_index number
1261 , creation_date date
1262 , created_by number
1263 , last_update_date date
1264 , last_updated_by number
1265 , last_update_login number
1266 , program_application_id number
1267 , program_id number
1268 , program_update_date date
1269 , request_id number
1270 , flex_title varchar2(60)
1271 , pricing_context varchar2(30)
1272 , pricing_attribute1 varchar2(240)
1273 , pricing_attribute2 varchar2(240)
1274 , pricing_attribute3 varchar2(240)
1275 , pricing_attribute4 varchar2(240)
1276 , pricing_attribute5 varchar2(240)
1277 , pricing_attribute6 varchar2(240)
1278 , pricing_attribute7 varchar2(240)
1279 , pricing_attribute8 varchar2(240)
1280 , pricing_attribute9 varchar2(240)
1281 , pricing_attribute10 varchar2(240)
1282 , pricing_attribute11 varchar2(240)
1283 , pricing_attribute12 varchar2(240)
1284 , pricing_attribute13 varchar2(240)
1285 , pricing_attribute14 varchar2(240)
1286 , pricing_attribute15 varchar2(240)
1287 , pricing_attribute16 varchar2(240)
1288 , pricing_attribute17 varchar2(240)
1289 , pricing_attribute18 varchar2(240)
1290 , pricing_attribute19 varchar2(240)
1291 , pricing_attribute20 varchar2(240)
1292 , pricing_attribute21 varchar2(240)
1293 , pricing_attribute22 varchar2(240)
1294 , pricing_attribute23 varchar2(240)
1298 , pricing_attribute27 varchar2(240)
1295 , pricing_attribute24 varchar2(240)
1296 , pricing_attribute25 varchar2(240)
1297 , pricing_attribute26 varchar2(240)
1299 , pricing_attribute28 varchar2(240)
1300 , pricing_attribute29 varchar2(240)
1301 , pricing_attribute30 varchar2(240)
1302 , pricing_attribute31 varchar2(240)
1303 , pricing_attribute32 varchar2(240)
1304 , pricing_attribute33 varchar2(240)
1305 , pricing_attribute34 varchar2(240)
1306 , pricing_attribute35 varchar2(240)
1307 , pricing_attribute36 varchar2(240)
1308 , pricing_attribute37 varchar2(240)
1309 , pricing_attribute38 varchar2(240)
1310 , pricing_attribute39 varchar2(240)
1311 , pricing_attribute40 varchar2(240)
1312 , pricing_attribute41 varchar2(240)
1313 , pricing_attribute42 varchar2(240)
1314 , pricing_attribute43 varchar2(240)
1315 , pricing_attribute44 varchar2(240)
1316 , pricing_attribute45 varchar2(240)
1317 , pricing_attribute46 varchar2(240)
1318 , pricing_attribute47 varchar2(240)
1319 , pricing_attribute48 varchar2(240)
1320 , pricing_attribute49 varchar2(240)
1321 , pricing_attribute50 varchar2(240)
1322 , pricing_attribute51 varchar2(240)
1323 , pricing_attribute52 varchar2(240)
1324 , pricing_attribute53 varchar2(240)
1325 , pricing_attribute54 varchar2(240)
1326 , pricing_attribute55 varchar2(240)
1327 , pricing_attribute56 varchar2(240)
1328 , pricing_attribute57 varchar2(240)
1329 , pricing_attribute58 varchar2(240)
1330 , pricing_attribute59 varchar2(240)
1331 , pricing_attribute60 varchar2(240)
1332 , pricing_attribute61 varchar2(240)
1333 , pricing_attribute62 varchar2(240)
1334 , pricing_attribute63 varchar2(240)
1335 , pricing_attribute64 varchar2(240)
1336 , pricing_attribute65 varchar2(240)
1337 , pricing_attribute66 varchar2(240)
1338 , pricing_attribute67 varchar2(240)
1339 , pricing_attribute68 varchar2(240)
1340 , pricing_attribute69 varchar2(240)
1341 , pricing_attribute70 varchar2(240)
1342 , pricing_attribute71 varchar2(240)
1343 , pricing_attribute72 varchar2(240)
1344 , pricing_attribute73 varchar2(240)
1345 , pricing_attribute74 varchar2(240)
1346 , pricing_attribute75 varchar2(240)
1347 , pricing_attribute76 varchar2(240)
1348 , pricing_attribute77 varchar2(240)
1349 , pricing_attribute78 varchar2(240)
1350 , pricing_attribute79 varchar2(240)
1351 , pricing_attribute80 varchar2(240)
1352 , pricing_attribute81 varchar2(240)
1353 , pricing_attribute82 varchar2(240)
1354 , pricing_attribute83 varchar2(240)
1355 , pricing_attribute84 varchar2(240)
1356 , pricing_attribute85 varchar2(240)
1357 , pricing_attribute86 varchar2(240)
1358 , pricing_attribute87 varchar2(240)
1359 , pricing_attribute88 varchar2(240)
1360 , pricing_attribute89 varchar2(240)
1361 , pricing_attribute90 varchar2(240)
1362 , pricing_attribute91 varchar2(240)
1363 , pricing_attribute92 varchar2(240)
1364 , pricing_attribute93 varchar2(240)
1365 , pricing_attribute94 varchar2(240)
1366 , pricing_attribute95 varchar2(240)
1367 , pricing_attribute96 varchar2(240)
1368 , pricing_attribute97 varchar2(240)
1369 , pricing_attribute98 varchar2(240)
1370 , pricing_attribute99 varchar2(240)
1371 , pricing_attribute100 varchar2(240)
1372 , context varchar2(30)
1373 , attribute1 varchar2(240)
1374 , attribute2 varchar2(240)
1375 , attribute3 varchar2(240)
1376 , attribute4 varchar2(240)
1377 , attribute5 varchar2(240)
1378 , attribute6 varchar2(240)
1379 , attribute7 varchar2(240)
1380 , attribute8 varchar2(240)
1381 , attribute9 varchar2(240)
1382 , attribute10 varchar2(240)
1383 , attribute11 varchar2(240)
1384 , attribute12 varchar2(240)
1385 , attribute13 varchar2(240)
1386 , attribute14 varchar2(240)
1387 , attribute15 varchar2(240)
1388 , Override_Flag varchar2(1)
1389 , return_status VARCHAR2(1)
1390 , db_flag VARCHAR2(1)
1391 , operation VARCHAR2(30)
1392 , lock_control NUMBER
1393 , orig_sys_atts_ref VARCHAR2(50) -- 1433292
1394 , change_request_code VARCHAR2(30),
1395 p_char_attribute1 varchar2(240),
1396 p_char_attribute2 varchar2(240),
1397 p_char_attribute3 varchar2(240),
1398 p_char_attribute4 varchar2(240),
1399 p_char_attribute5 varchar2(240),
1400 p_char_attribute6 varchar2(240),
1401 p_char_attribute7 varchar2(240),
1402 p_char_attribute8 varchar2(240),
1403 p_char_attribute9 varchar2(240),
1404 p_char_attribute10 varchar2(240),
1405 p_num_attribute1 number,
1406 p_num_attribute2 number,
1407 p_num_attribute3 number,
1408 p_num_attribute4 number,
1409 p_num_attribute5 number,
1410 p_num_attribute6 number,
1411 p_num_attribute7 number,
1412 p_num_attribute8 number,
1413 p_num_attribute9 number,
1414 p_num_attribute10 number,
1415 p_date_attribute1 date,
1416 p_date_attribute2 date,
1417 p_date_attribute3 date,
1418 p_date_attribute4 date,
1419 p_date_attribute5 date
1420 );
1421
1422 TYPE PA_Line_PAtt_Tbl_Type is TABLE of PA_Line_PAtt_rec_Type
1426 ( price_adj_attrib_id number
1423 INDEX by BINARY_INTEGER;
1424
1425 Type PA_LAdj_Att_Rec_Type is RECORD
1427 , price_adjustment_id number
1428 , Adj_index number
1429 , flex_title varchar2(60)
1430 , pricing_context varchar2(30)
1431 , pricing_attribute varchar2(30)
1432 , creation_date date
1433 , created_by number
1434 , last_update_date date
1435 , last_updated_by number
1436 , last_update_login number
1437 , program_application_id number
1438 , program_id number
1439 , program_update_date date
1440 , request_id number
1441 , pricing_attr_value_from varchar2(240)
1442 , pricing_attr_value_to varchar2(240)
1443 , comparison_operator varchar2(30)
1444 , return_status VARCHAR2(1)
1445 , db_flag VARCHAR2(1)
1446 , operation VARCHAR2(30)
1447 , lock_control NUMBER,
1448 p_char_attribute1 varchar2(240),
1449 p_char_attribute2 varchar2(240),
1450 p_char_attribute3 varchar2(240),
1451 p_char_attribute4 varchar2(240),
1452 p_char_attribute5 varchar2(240),
1453 p_char_attribute6 varchar2(240),
1454 p_char_attribute7 varchar2(240),
1455 p_char_attribute8 varchar2(240),
1456 p_char_attribute9 varchar2(240),
1457 p_char_attribute10 varchar2(240),
1458 p_num_attribute1 number,
1459 p_num_attribute2 number,
1460 p_num_attribute3 number,
1461 p_num_attribute4 number,
1462 p_num_attribute5 number,
1463 p_num_attribute6 number,
1464 p_num_attribute7 number,
1465 p_num_attribute8 number,
1466 p_num_attribute9 number,
1467 p_num_attribute10 number,
1468 p_date_attribute1 date,
1469 p_date_attribute2 date,
1470 p_date_attribute3 date,
1471 p_date_attribute4 date,
1472 p_date_attribute5 date
1473 );
1474
1475
1476 TYPE PA_LAdj_Att_Tbl_Type is TABLE of PA_LAdj_Att_rec_Type
1477 INDEX by BINARY_INTEGER;
1478
1479 -- Line_Adj_Assoc_Rec_Type
1480
1481 Type PA_L_Adj_AssRec_Type is RECORD
1482 ( price_adj_assoc_id number
1483 , line_id number
1484 , Line_index number
1485 , price_adjustment_id number
1486 , Adj_index number
1487 , rltd_Price_Adj_Id number
1488 , Rltd_Adj_Index NUMBER
1489 , creation_date date
1490 , created_by number
1491 , last_update_date date
1492 , last_updated_by number
1493 , last_update_login number
1494 , program_application_id number
1495 , program_id number
1496 , program_update_date date
1497 , request_id number
1498 , return_status VARCHAR2(1)
1499 , db_flag VARCHAR2(1)
1500 , operation VARCHAR2(30)
1501 , lock_control NUMBER,
1502 p_char_attribute1 varchar2(240),
1503 p_char_attribute2 varchar2(240),
1504 p_char_attribute3 varchar2(240),
1505 p_char_attribute4 varchar2(240),
1506 p_char_attribute5 varchar2(240),
1507 p_char_attribute6 varchar2(240),
1508 p_char_attribute7 varchar2(240),
1509 p_char_attribute8 varchar2(240),
1510 p_char_attribute9 varchar2(240),
1511 p_char_attribute10 varchar2(240),
1512 p_num_attribute1 number,
1513 p_num_attribute2 number,
1514 p_num_attribute3 number,
1515 p_num_attribute4 number,
1516 p_num_attribute5 number,
1517 p_num_attribute6 number,
1518 p_num_attribute7 number,
1519 p_num_attribute8 number,
1520 p_num_attribute9 number,
1521 p_num_attribute10 number,
1522 p_date_attribute1 date,
1523 p_date_attribute2 date,
1524 p_date_attribute3 date,
1525 p_date_attribute4 date,
1526 p_date_attribute5 date);
1527
1528
1529 TYPE PA_L_Adj_AssTbl_Type is TABLE of PA_L_Adj_Assrec_Type
1530 INDEX by BINARY_INTEGER;
1531
1532 TYPE QP_LINE_REC_TYPE IS RECORD
1533 (REQUEST_TYPE_CODE VARCHAR2(30):=NULL,
1534 PRICING_EVENT VARCHAR2(30):=NULL,
1535 HEADER_ID NUMBER :=NULL,
1536 LINE_INDEX NUMBER :=NULL,
1537 LINE_ID NUMBER :=NULL,
1538 LINE_TYPE_CODE VARCHAR2(30):=NULL,
1539 PRICING_EFFECTIVE_DATE DATE :=NULL,
1540 ACTIVE_DATE_FIRST DATE :=NULL,
1541 ACTIVE_DATE_FIRST_TYPE VARCHAR2(30):=NULL,
1542 ACTIVE_DATE_SECOND DATE :=NULL,
1543 ACTIVE_DATE_SECOND_TYPE VARCHAR2(30):=NULL,
1544 LINE_QUANTITY NUMBER :=NULL,
1545 LINE_UOM_CODE VARCHAR2(30):=NULL,
1546 UOM_QUANTITY NUMBER :=NULL,
1547 PRICED_QUANTITY NUMBER :=NULL,
1548 PRICED_UOM_CODE VARCHAR2(30):=NULL,
1549 CURRENCY_CODE VARCHAR2(30):=NULL,
1550 UNIT_PRICE NUMBER :=NULL,
1551 PERCENT_PRICE NUMBER :=NULL,
1552 ADJUSTED_UNIT_PRICE NUMBER :=NULL,
1553 UPDATED_ADJUSTED_UNIT_PRICE NUMBER :=NULL,
1554 PARENT_PRICE NUMBER :=NULL,
1555 PARENT_QUANTITY NUMBER :=NULL,
1559 PRICE_FLAG VARCHAR2(1) :=NULL,
1556 ROUNDING_FACTOR NUMBER :=NULL,
1557 PARENT_UOM_CODE VARCHAR2(30):=NULL,
1558 PRICING_PHASE_ID NUMBER :=NULL,
1560 PROCESSED_CODE VARCHAR2(240) :=NULL,
1561 PRICE_REQUEST_CODE VARCHAR2(240) :=NULL,
1562 HOLD_CODE VARCHAR2(240) := NULL,
1563 HOLD_TEXT VARCHAR2(2000) := NULL,
1564 STATUS_CODE VARCHAR2(30):=NULL,
1565 STATUS_TEXT VARCHAR2(2000):=NULL,
1566 USAGE_PRICING_TYPE VARCHAR2(30) := NULL,
1567 LINE_CATEGORY VARCHAR2(30) := NULL,
1568 CONTRACT_START_DATE DATE := NULL, /* shulin */
1569 CONTRACT_END_DATE DATE := NULL, /* shulin */
1570 LINE_UNIT_PRICE NUMBER := NULL, /* shu_latest */
1571 EXTENDED_PRICE NUMBER := NULL, /* block pricing */
1572 LIST_PRICE_OVERRIDE_FLAG VARCHAR2(1) := NULL /* po integration */
1573 );
1574
1575 TYPE QP_LINE_TBL_TYPE IS TABLE OF QP_LINE_REC_TYPE INDEX BY BINARY_INTEGER;
1576
1577 TYPE QP_QUAL_REC_TYPE IS RECORD
1578 (LINE_INDEX NUMBER ,
1579 QUALIFIER_CONTEXT VARCHAR2(30) ,
1580 QUALIFIER_ATTRIBUTE VARCHAR2(30) ,
1581 QUALIFIER_ATTR_VALUE_FROM VARCHAR2(240) ,
1582 QUALIFIER_ATTR_VALUE_TO VARCHAR2(240) ,
1583 COMPARISON_OPERATOR_CODE VARCHAR2(30) ,
1584 VALIDATED_FLAG VARCHAR2(1) ,
1585 STATUS_CODE VARCHAR2(30):=NULL,
1586 STATUS_TEXT VARCHAR2(240):=NULL
1587 );
1588
1589
1590 TYPE QP_QUAL_TBL_TYPE IS TABLE OF QP_QUAL_REC_TYPE INDEX BY BINARY_INTEGER;
1591
1592 TYPE QP_LINE_ATTR_REC_TYPE IS RECORD
1593 (LINE_INDEX NUMBER :=NULL,
1594 PRICING_CONTEXT VARCHAR2(30):=NULL,
1595 PRICING_ATTRIBUTE VARCHAR2(30):=NULL,
1596 PRICING_ATTR_VALUE_FROM VARCHAR2(240):=NULL,
1597 PRICING_ATTR_VALUE_TO VARCHAR2(240):=NULL,
1598 VALIDATED_FLAG VARCHAR2(1):=NULL,
1599 STATUS_CODE VARCHAR2(30):=NULL,
1600 STATUS_TEXT VARCHAR2(240):=NULL
1601 );
1602
1603 TYPE QP_LINE_ATTR_TBL_TYPE IS TABLE OF QP_LINE_ATTR_REC_TYPE INDEX BY BINARY_INTEGER;
1604
1605 TYPE QP_LINE_DETAIL_REC_TYPE IS RECORD
1606 (LINE_DETAIL_INDEX NUMBER,
1607 LINE_DETAIL_ID NUMBER,
1608 LINE_DETAIL_TYPE_CODE VARCHAR2(30),
1609 LINE_INDEX NUMBER,
1610 LIST_HEADER_ID NUMBER,
1611 LIST_LINE_ID NUMBER,
1612 LIST_LINE_TYPE_CODE VARCHAR2(30),
1613 SUBSTITUTION_TYPE_CODE VARCHAR2(30), --obsoleting
1614 SUBSTITUTION_FROM VARCHAR2(240), --obsoleting
1615 SUBSTITUTION_TO VARCHAR2(240),
1616 AUTOMATIC_FLAG VARCHAR2(1),
1617 OPERAND_CALCULATION_CODE VARCHAR2(30), --added for pricing engine internal use only
1618 OPERAND_VALUE NUMBER, --added for pricing engine internal use only
1619 PRICING_GROUP_SEQUENCE NUMBER, --added for pricing engine internal use only
1620 PRICE_BREAK_TYPE_CODE VARCHAR2(30), --added for pricing engine internal use only
1621 CREATED_FROM_LIST_TYPE_CODE VARCHAR2(30),
1622 PRICING_PHASE_ID NUMBER,
1623 LIST_PRICE NUMBER,
1624 LINE_QUANTITY NUMBER,
1625 ADJUSTMENT_AMOUNT NUMBER,
1626 APPLIED_FLAG VARCHAR2(1),
1627 MODIFIER_LEVEL_CODE VARCHAR2(30),
1628 STATUS_CODE VARCHAR2(30):=NULL,
1629 STATUS_TEXT VARCHAR2(2000):=NULL,
1630 --new addition might need to add
1631 SUBSTITUTION_ATTRIBUTE VARCHAR2(240),
1632 ACCRUAL_FLAG VARCHAR2(1),
1633 LIST_LINE_NO VARCHAR2(240),
1634 ESTIM_GL_VALUE NUMBER,
1635 ACCRUAL_CONVERSION_RATE NUMBER,
1636 --Pass throuh components
1637 OVERRIDE_FLAG VARCHAR2(1),
1638 PRINT_ON_INVOICE_FLAG VARCHAR2(1),
1639 INVENTORY_ITEM_ID NUMBER,
1640 ORGANIZATION_ID NUMBER,
1641 RELATED_ITEM_ID NUMBER,
1642 RELATIONSHIP_TYPE_ID NUMBER,
1643 --ACCRUAL_QTY NUMBER,
1644 --ACCRUAL_UOM_CODE VARCHAR2(3),
1645 ESTIM_ACCRUAL_RATE NUMBER,
1646 EXPIRATION_DATE DATE,
1647 BENEFIT_PRICE_LIST_LINE_ID NUMBER,
1648 RECURRING_FLAG VARCHAR2(1),
1649 RECURRING_VALUE NUMBER, -- block pricing
1650 BENEFIT_LIMIT NUMBER,
1651 CHARGE_TYPE_CODE VARCHAR2(30),
1652 CHARGE_SUBTYPE_CODE VARCHAR2(30),
1653 INCLUDE_ON_RETURNS_FLAG VARCHAR2(1),
1654 BENEFIT_QTY NUMBER,
1655 BENEFIT_UOM_CODE VARCHAR2(3),
1656 PRORATION_TYPE_CODE VARCHAR2(30),
1657 SOURCE_SYSTEM_CODE VARCHAR2(30),
1658 REBATE_TRANSACTION_TYPE_CODE VARCHAR2(30),
1659 SECONDARY_PRICELIST_IND VARCHAR2(1),
1660 GROUP_VALUE NUMBER, -- This is used for LUMPSUM calculation for LINEGRP kind of modifiers
1661 COMMENTS VARCHAR2(2000),
1662 UPDATED_FLAG VARCHAR2(1),
1663 PROCESS_CODE VARCHAR2(30),
1664 LIMIT_CODE VARCHAR2(30),
1665 LIMIT_TEXT VARCHAR2(240),
1666 FORMULA_ID NUMBER,
1667 CALCULATION_CODE VARCHAR2(30) --This indicates if it is back_calcadj
1668 ,ROUNDING_FACTOR NUMBER, /* Vivek */
1669 currency_detail_id NUMBER, /* Vivek */
1670 currency_header_id NUMBER, /* Vivek */
1671 selling_rounding_factor NUMBER, /* Vivek */
1672 order_currency VARCHAR2(30), /* Vivek */
1673 pricing_effective_date DATE, /* Vivek */
1674 base_currency_code VARCHAR2(30), /* Vivek */
1675 --added for aso
1679 break_uom_context VARCHAR2(30), /* Proration*/
1676 change_reason_code VARCHAR2(30),
1677 change_reason_text VARCHAR2(2000),
1678 break_uom_code VARCHAR2(3), /* Proration*/
1680 break_uom_attribute VARCHAR2(30) /* Proration*/
1681 );
1682
1683 TYPE QP_LINE_DETAIL_TBL_TYPE IS TABLE OF QP_LINE_DETAIL_REC_TYPE INDEX BY BINARY_INTEGER;
1684
1685 TYPE QP_LINE_DQUAL_REC_TYPE IS RECORD
1686 (LINE_DETAIL_INDEX NUMBER,
1687 QUALIFIER_CONTEXT VARCHAR2(30),
1688 QUALIFIER_ATTRIBUTE VARCHAR2(30),
1689 QUALIFIER_ATTR_VALUE_FROM VARCHAR2(240),
1690 QUALIFIER_ATTR_VALUE_TO VARCHAR2(240),
1691 COMPARISON_OPERATOR_CODE VARCHAR2(30),
1692 VALIDATED_FLAG VARCHAR2(1),
1693 STATUS_CODE VARCHAR2(30):=NULL,
1694 STATUS_TEXT VARCHAR2(240):=NULL
1695 );
1696
1697 TYPE QP_LINE_DQUAL_TBL_TYPE IS TABLE OF QP_LINE_DQUAL_REC_TYPE INDEX BY BINARY_INTEGER;
1698
1699 TYPE QP_LINE_DATTR_REC_TYPE IS RECORD
1700 (LINE_DETAIL_INDEX NUMBER,
1701 --added for usage pricing as line_index is a not null column in tmp table
1702 LINE_INDEX NUMBER,
1703 PRICING_CONTEXT VARCHAR2(30),
1704 PRICING_ATTRIBUTE VARCHAR2(30),
1705 PRICING_ATTR_VALUE_FROM VARCHAR2(240),
1706 PRICING_ATTR_VALUE_TO VARCHAR2(240),
1707 VALIDATED_FLAG VARCHAR2(1),
1708 STATUS_CODE VARCHAR2(30):=NULL,
1709 STATUS_TEXT VARCHAR2(240):=NULL
1710 );
1711
1712 TYPE QP_LINE_DATTR_TBL_TYPE IS TABLE OF QP_LINE_DATTR_REC_TYPE INDEX BY BINARY_INTEGER;
1713
1714 TYPE QP_RLTD_LINES_REC_TYPE IS RECORD
1715 (LINE_INDEX NUMBER,
1716 LINE_DETAIL_INDEX NUMBER,
1717 RELATIONSHIP_TYPE_CODE VARCHAR2(30),
1718 RELATED_LINE_INDEX NUMBER,
1719 RELATED_LINE_DETAIL_INDEX NUMBER,
1720 STATUS_CODE VARCHAR2(30):=NULL,
1721 STATUS_TEXT VARCHAR2(240):=NULL);
1722
1723 TYPE QP_RLTD_LINES_TBL_TYPE IS TABLE OF QP_RLTD_LINES_REC_TYPE INDEX BY BINARY_INTEGER;
1724
1725 TYPE QP_CONTROL_RECORD_TYPE IS RECORD
1726 (PRICING_EVENT VARCHAR2(30),
1727 CALCULATE_FLAG VARCHAR2(30),
1728 SIMULATION_FLAG VARCHAR2(1),
1729 ROUNDING_FLAG VARCHAR2(1),
1730 GSA_CHECK_FLAG VARCHAR2(1),
1731 GSA_DUP_CHECK_FLAG VARCHAR2(1),
1732 TEMP_TABLE_INSERT_FLAG VARCHAR2(1),
1733 MANUAL_DISCOUNT_FLAG VARCHAR2(1),
1734 DEBUG_FLAG VARCHAR2(1), --'Y' to turn on debugging
1735 SOURCE_ORDER_AMOUNT_FLAG VARCHAR2(1),
1736 PUBLIC_API_CALL_FLAG VARCHAR2(1),
1737 MANUAL_ADJUSTMENTS_CALL_FLAG VARCHAR2(1),
1738 GET_FREIGHT_FLAG VARCHAR2(1),
1739 --cleanup changes
1740 REQUEST_TYPE_CODE VARCHAR2(30),
1741 VIEW_CODE VARCHAR2(50),
1742 CHECK_CUST_VIEW_FLAG VARCHAR2(1),
1743 --changed lines call changes
1744 FULL_PRICING_CALL VARCHAR2(1), -- to indicate if passing all/changed lines
1745 USE_MULTI_CURRENCY VARCHAR2(1) default 'N' -- vivek, 'Y' to use multi currency
1746 ,USER_CONVERSION_RATE NUMBER default NULL -- vivek
1747 ,USER_CONVERSION_TYPE VARCHAR2(30) default NULL -- vivek
1748 ,FUNCTION_CURRENCY VARCHAR2(30) default NULL -- vivek
1749 );
1750
1751
1752 TYPE source_orgs_rec IS RECORD
1753 ( org_id number,
1754 instance_id number,
1755 ship_method varchar2(30),
1756 delivery_lead_time number,
1757 freight_carrier varchar2(30),
1758 instance_code varchar2(5),
1759 attribute1 varchar2(100),
1760 attribute2 varchar2(100),
1761 attribute3 varchar2(100),
1762 attribute4 varchar2(100),
1763 attribute5 varchar2(100),
1764 attribute6 number,
1765 attribute7 number,
1766 attribute8 number,
1767 attribute9 number,
1768 attribute10 number,
1769 attribute11 date,
1770 attribute12 date,
1771 attribute13 date,
1772 attribute14 date,
1773 attribute15 date
1774 );
1775
1776 TYPE source_orgs_table IS TABLE OF source_orgs_rec index by binary_integer;
1777 TYPE NUMBER_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1778 TYPE panda_rec is RECORD
1779 (
1780 p_line_id number,
1781 p_inventory_item_id number,
1782 p_qty number,
1783 p_uom varchar2(20),
1784 p_request_date date,
1785 p_customer_id number,
1786 p_item_identifier_type varchar2(40),
1787 p_agreement_id number,
1788 p_price_list_id number,
1789 p_ship_to_org_id number,
1790 p_invoice_to_org_id number,
1791 p_ship_from_org_id number,
1792 p_pricing_date date,
1793 p_order_type_id number,
1794 p_ordered_item_id number,
1795 p_line_type_id number,
1796 p_currency varchar2(20),
1797 p_pricing_context varchar2(30),
1798 p_pricing_attribute1 varchar2(240),
1799 p_pricing_attribute2 varchar2(240),
1800 p_pricing_attribute3 varchar2(240),
1801 p_pricing_attribute4 varchar2(240),
1802 p_pricing_attribute5 varchar2(240),
1803 p_pricing_attribute6 varchar2(240),
1804 p_pricing_attribute7 varchar2(240),
1805 p_pricing_attribute8 varchar2(240),
1806 p_pricing_attribute9 varchar2(240),
1807 p_pricing_attribute10 varchar2(240),
1811 p_pricing_attribute14 varchar2(240),
1808 p_pricing_attribute11 varchar2(240),
1809 p_pricing_attribute12 varchar2(240),
1810 p_pricing_attribute13 varchar2(240),
1812 p_pricing_attribute15 varchar2(240),
1813 p_pricing_attribute16 varchar2(240),
1814 p_pricing_attribute17 varchar2(240),
1815 p_pricing_attribute18 varchar2(240),
1816 p_pricing_attribute19 varchar2(240),
1817 p_pricing_attribute20 varchar2(240),
1818 p_pricing_attribute21 varchar2(240),
1819 p_pricing_attribute22 varchar2(240),
1820 p_pricing_attribute23 varchar2(240),
1821 p_pricing_attribute24 varchar2(240),
1822 p_pricing_attribute25 varchar2(240),
1823 p_pricing_attribute26 varchar2(240),
1824 p_pricing_attribute27 varchar2(240),
1825 p_pricing_attribute28 varchar2(240),
1826 p_pricing_attribute29 varchar2(240),
1827 p_pricing_attribute30 varchar2(240),
1828 p_pricing_attribute31 varchar2(240),
1829 p_pricing_attribute32 varchar2(240),
1830 p_pricing_attribute33 varchar2(240),
1831 p_pricing_attribute34 varchar2(240),
1832 p_pricing_attribute35 varchar2(240),
1833 p_pricing_attribute36 varchar2(240),
1834 p_pricing_attribute37 varchar2(240),
1835 p_pricing_attribute38 varchar2(240),
1836 p_pricing_attribute39 varchar2(240),
1837 p_pricing_attribute40 varchar2(240),
1838 p_pricing_attribute41 varchar2(240),
1839 p_pricing_attribute42 varchar2(240),
1840 p_pricing_attribute43 varchar2(240),
1841 p_pricing_attribute44 varchar2(240),
1842 p_pricing_attribute45 varchar2(240),
1843 p_pricing_attribute46 varchar2(240),
1844 p_pricing_attribute47 varchar2(240),
1845 p_pricing_attribute48 varchar2(240),
1846 p_pricing_attribute49 varchar2(240),
1847 p_pricing_attribute50 varchar2(240),
1848 p_pricing_attribute51 varchar2(240),
1849 p_pricing_attribute52 varchar2(240),
1850 p_pricing_attribute53 varchar2(240),
1851 p_pricing_attribute54 varchar2(240),
1852 p_pricing_attribute55 varchar2(240),
1853 p_pricing_attribute56 varchar2(240),
1854 p_pricing_attribute57 varchar2(240),
1855 p_pricing_attribute58 varchar2(240),
1856 p_pricing_attribute59 varchar2(240),
1857 p_pricing_attribute60 varchar2(240),
1858 p_pricing_attribute61 varchar2(240),
1859 p_pricing_attribute62 varchar2(240),
1860 p_pricing_attribute63 varchar2(240),
1861 p_pricing_attribute64 varchar2(240),
1862 p_pricing_attribute65 varchar2(240),
1863 p_pricing_attribute66 varchar2(240),
1864 p_pricing_attribute67 varchar2(240),
1865 p_pricing_attribute68 varchar2(240),
1866 p_pricing_attribute69 varchar2(240),
1867 p_pricing_attribute70 varchar2(240),
1868 p_pricing_attribute71 varchar2(240),
1869 p_pricing_attribute72 varchar2(240),
1870 p_pricing_attribute73 varchar2(240),
1871 p_pricing_attribute74 varchar2(240),
1872 p_pricing_attribute75 varchar2(240),
1873 p_pricing_attribute76 varchar2(240),
1874 p_pricing_attribute77 varchar2(240),
1875 p_pricing_attribute78 varchar2(240),
1876 p_pricing_attribute79 varchar2(240),
1877 p_pricing_attribute80 varchar2(240),
1878 p_pricing_attribute81 varchar2(240),
1879 p_pricing_attribute82 varchar2(240),
1880 p_pricing_attribute83 varchar2(240),
1881 p_pricing_attribute84 varchar2(240),
1882 p_pricing_attribute85 varchar2(240),
1883 p_pricing_attribute86 varchar2(240),
1884 p_pricing_attribute87 varchar2(240),
1885 p_pricing_attribute88 varchar2(240),
1886 p_pricing_attribute89 varchar2(240),
1887 p_pricing_attribute90 varchar2(240),
1888 p_pricing_attribute91 varchar2(240),
1889 p_pricing_attribute92 varchar2(240),
1890 p_pricing_attribute93 varchar2(240),
1891 p_pricing_attribute94 varchar2(240),
1892 p_pricing_attribute95 varchar2(240),
1893 p_pricing_attribute96 varchar2(240),
1894 p_pricing_attribute97 varchar2(240),
1895 p_pricing_attribute98 varchar2(240),
1896 p_pricing_attribute99 varchar2(240),
1897 p_pricing_attribute100 varchar2(240),
1898 p_char_attribute1 varchar2(240),
1899 p_char_attribute2 varchar2(240),
1900 p_char_attribute3 varchar2(240),
1901 p_char_attribute4 varchar2(240),
1902 p_char_attribute5 varchar2(240),
1903 p_char_attribute6 varchar2(240),
1904 p_char_attribute7 varchar2(240),
1905 p_char_attribute8 varchar2(240),
1906 p_char_attribute9 varchar2(240),
1907 p_char_attribute10 varchar2(240),
1908 p_num_attribute1 number,
1909 p_num_attribute2 number,
1910 p_num_attribute3 number,
1911 p_num_attribute4 number,
1912 p_num_attribute5 number,
1913 p_num_attribute6 number,
1914 p_num_attribute7 number,
1915 p_num_attribute8 number,
1916 p_num_attribute9 number,
1917 p_num_attribute10 number,
1918 p_date_attribute1 date,
1919 p_date_attribute2 date,
1920 p_date_attribute3 date,
1921 p_date_attribute4 date,
1922 p_date_attribute5 date );
1923
1924 TYPE panda_rec_table IS TABLE OF panda_rec index by binary_integer;
1925
1926 g_panda_rec_table panda_rec_table;
1927
1928 TYPE Default_rec is record
1929 (
1930 org_id number,
1931 sold_to_org_id number,
1932 inventory_item_id number,
1933 item_type_code varchar2(30),
1934 user_id number,
1935 created_by number,
1936 ship_to_org_id number,
1937 order_quantity_uom varchar2(3),
1938 line_type_id number,
1939 invoice_to_org_id number,
1940 demand_Class_code varchar2(30),
1941 agreement_id number,
1942 order_type_id number,
1943 price_list_id number,
1944 ship_From_org_id number,
1945 transactional_Curr_Code varchar2(15),
1946 request_date date,
1947 conversion_type_code varchar2(40), --Bug 7347299
1948 p_char_attribute1 varchar2(15),
1949 p_char_attribute2 varchar2(15),
1950 p_char_attribute3 varchar2(15),
1951 p_char_attribute4 varchar2(15),
1952 p_char_attribute5 varchar2(15),
1953 p_number_attribute1 number,
1954 p_number_attribute2 number,
1955 p_number_attribute3 number,
1956 p_number_attribute4 number,
1957 p_number_attribute5 number,
1958 p_date_attribute1 date,
1959 p_date_attribute2 date,
1960 p_date_attribute3 date,
1961 p_date_attribute4 date,
1962 p_date_attribute5 date);
1963
1964 TYPE Promotions_rec is RECORD(
1965 p_line_id number,
1966 p_type varchar2(20), -- promotion or coupon
1967 p_level varchar2(20), -- to store Order or Line Level
1968 p_pricing_attribute1 varchar2(240),
1969 p_pricing_attribute2 varchar2(240),
1970 p_pricing_attribute3 varchar2(240)
1971 );
1972
1973
1974 TYPE Promotions_tbl is TABLE of Promotions_rec index by binary_integer;
1975
1976
1977 TYPE Manual_adj_rec is RECORD
1978 (
1979 p_line_id number,
1980 modifier_number Varchar2(240)
1981 ,list_line_type_code Varchar2(30)
1982 ,operator Varchar2(30)
1983 ,operand Varchar2(30)
1984 ,list_line_id Number
1985 ,list_header_id Number
1986 ,pricing_phase_id Number
1987 ,automatic_flag Varchar2(1)
1988 ,modifier_level_code Varchar2(30)
1989 ,override_flag Varchar2(1)
1990 ,adjusted_amount Number
1991 ,line_detail_type_code Varchar2(30)
1992 ,price_break_type_code Varchar2(30)
1993 ,charge_type_code Varchar2(30)
1994 ,charge_subtype_code Varchar2(30)
1995 ,PRICING_GROUP_SEQUENCE NUMBER -- added for showing bucket field in Manual Adjustment LOV Bug 3644867
1996 );
1997
1998
1999 Type Manual_modifier_tbl is TABLE of Manual_adj_rec index by binary_integer;
2000
2001 Type Modifier_attributes is RECORD
2002 (p_line_id number,
2003 p_list_line_id number,
2004 p_context varchar2(30),
2005 p_attribute varchar2(100),
2006 p_attr_value_from number,
2007 p_attr_value_to number);
2008
2009 Type Modifier_attributes_tbl is TABLE of Modifier_attributes index by binary_integer;
2010
2011 Type Modifier_assoc is RECORD
2012 (p_line_id number,
2013 line_Detail_index number,
2014 rltd_line_detail_index number);
2015
2016 Type Modifier_assoc_tbl is TABLE of Modifier_assoc index by binary_integer;
2017
2018 Procedure Pass_Modifiers_to_backend(in_manual_adj_tbl in Manual_modifier_tbl,
2019 in_modf_rel_tbl in Modifier_assoc_Tbl,
2020 in_modf_attr_tbl in Modifier_attributes_Tbl);
2021 Procedure Enforce_price_list(in_order_type_id in number,
2022 out_enforce_price_flag out nocopy varchar2);
2023
2024
2025 Procedure Delete_manual_modifiers;
2026
2027 Procedure Call_MRP_ATP(
2028 in_global_orgs in varchar2,
2029 in_ship_from_org_id in number,
2030 out_available_qty out nocopy varchar2,
2031 out_ship_from_org_id out nocopy number,
2032 out_available_date out nocopy date,
2033 out_qty_uom out nocopy varchar2,
2034 x_out_message out nocopy varchar2,
2035 x_return_status OUT NOCOPY VARCHAR2,
2036 x_msg_count OUT NOCOPY NUMBER,
2037 x_msg_data OUT NOCOPY VARCHAR2,
2038 x_error_message out nocopy varchar2
2039 );
2040
2041 PROCEDURE get_item_name(
2042 l_inv_item_id in number,
2043 out_inv_item_name out nocopy varchar2);
2044
2045
2046 PROCEDURE get_item_type(in_item_type_code in varchar2,
2047 out_meaning out nocopy varchar2
2048 );
2049 Procedure Pass_Upgrade_information(in_upgrade_item_exists varchar2,
2050 in_upgrade_item_id in number,
2051 in_upgrade_order_qty_uom in varchar2,
2052 in_upgrade_ship_from_org_id in number);
2053 PROCEDURE get_upgrade_item_details(l_inv_item_id in number,
2054 out_inv_item_name out nocopy varchar2,
2055 out_inv_desc out nocopy varchar2,
2056 out_inv_item_type out nocopy varchar2);
2057
2058 PROCEDURE Insert_Manual_Adjustment(in_line_id in number,
2059 in_line_index in number);
2060
2061 PROCEDURE Delete_Applied_Manual_Adj(in_line_id in number,
2062 in_list_line_id in number,
2063 in_list_header_id in number);
2064
2065
2066 PROCEDURE get_oid_information(l_list_line_no in number,
2067 out_inv_item_name out nocopy varchar2);
2068 PROCEDURE get_terms_details(
2069 in_substitution_attribute in varchar2,
2070 in_substitution_to in varchar2,
2071 out_benefit_method out nocopy varchar2,
2072 out_benefit_value out nocopy varchar2);
2073
2074 PROCEDURE get_coupon_details(in_list_line_id in number,
2075 in_list_header_id in number,
2076 out_benefit out nocopy varchar2,
2077 out_benefit_method out nocopy varchar2,
2078 out_benefit_value out nocopy varchar2,
2079 out_benefit_item out nocopy varchar2);
2080
2081 PROCEDURE defaulting(
2082 in_source in varchar2,
2083 in_out_default_rec in out NOCOPY /* file.sql.39 change */ default_rec
2084 ) ;
2085 PROCEDURE get_order_type(in_order_type_id in number,
2086 out_name out nocopy varchar2
2087
2088 );
2089 PROCEDURE get_sold_to_org(in_org_id in number,
2090 out_name out nocopy varchar2,
2091 out_cust_id out nocopy number
2092 );
2093 --bug 5621717
2094 PROCEDURE get_sold_to_org(in_org_id in number,
2095 out_name out nocopy varchar2,
2096 out_cust_id out nocopy varchar2
2097 );
2098
2099 PROCEDURE get_currency_name(in_transactional_curr_code in varchar2,
2100 out_name out nocopy varchar2
2101
2102 );
2103
2104 PROCEDURE get_demand_class(in_demand_class_code in varchar2,
2105 out_name out nocopy varchar2
2106
2107 );
2108 PROCEDURE get_ship_to_org(in_org_id in number,
2109 out_name out nocopy varchar2
2110
2111 );
2112 PROCEDURE get_invoice_to_org(in_bill_to_org_id in number,
2113 out_name out nocopy varchar2 );
2114
2115 PROCEDURE get_agreement_name(in_agreement_id in number,
2116 out_name out nocopy varchar2
2117
2118 );
2119
2120
2121 PROCEDURE defaulting(
2122 in_source in varchar2
2123 ,in_org_id in varchar2
2124 ,in_item_id in number
2125 ,in_customer_id in number
2126 ,in_ship_to_org_id in number
2127 ,in_bill_to_org_id in number
2128 ,in_agreement_id in number
2129 ,in_order_type_id in number
2130 ,out_wsh_id out nocopy number
2131 ,out_uom out nocopy varchar2
2132 ,out_item_type_code out nocopy varchar2
2133 ,out_price_list_id out nocopy number
2134 ,out_conversion_type out nocopy varchar2
2135 );
2136
2137
2138 Procedure Query_Qty_Tree(
2139 p_org_id IN NUMBER,
2140 p_item_id IN NUMBER,
2141 p_sch_date IN DATE DEFAULT NULL,
2142 x_on_hand_qty OUT NOCOPY NUMBER,
2143
2144 x_avail_to_reserve OUT NOCOPY NUMBER);
2145
2146
2147
2148 PROCEDURE get_ship_from_org(in_org_id in number,
2149 out_code out nocopy varchar2,
2150
2151 out_name out nocopy varchar2
2152
2153 );
2154
2155
2156
2157 PROCEDURE Reset_All_Tbls;
2158 procedure Populate_Temp_Table;
2159
2160 PROCEDURE populate_results(
2161 x_line_tbl out NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
2162 x_line_qual_tbl out NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
2163 x_line_attr_tbl out NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
2164 x_LINE_DETAIL_tbl out NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
2165 x_LINE_DETAIL_qual_tbl out NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
2166 x_LINE_DETAIL_attr_tbl out NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
2167 x_related_lines_tbl out NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE
2168 );
2169
2170 PROCEDURE price_item(
2171 out_req_line_tbl in out NOCOPY /* file.sql.39 change */ OE_OE_PRICING_AVAILABILITY.QP_LINE_TBL_TYPE,
2172 out_Req_line_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_ATTR_TBL_TYPE,
2173 out_Req_LINE_DETAIL_attr_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DATTR_TBL_TYPE,
2174 out_Req_LINE_DETAIL_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DETAIL_TBL_TYPE,
2175 out_Req_related_lines_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_RLTD_LINES_TBL_TYPE,
2176 out_Req_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_QUAL_TBL_TYPE,
2177 out_Req_LINE_DETAIL_qual_tbl in out nocopy OE_OE_PRICING_AVAILABILITY.QP_LINE_DQUAL_TBL_TYPE,
2178 out_child_detail_type out nocopy varchar2
2179 );
2180
2181 PROCEDURE pass_values_to_backend(
2182 in_panda_rec_table in panda_rec_table
2183 );
2184
2185 PROCEDURE process_pricing_errors(
2186 in_line_type_code in varchar2,
2187 in_status_code in varchar2,
2188 in_status_text in varchar2,
2189 in_ordered_item in varchar2,
2190 in_uom in varchar2,
2191 in_unit_price in number,
2192 in_adjusted_unit_price in number,
2193 in_process_code in varchar2 ,
2194 in_price_flag in varchar2,
2195 in_price_list_id in number,
2196 l_return_status out nocopy varchar2,
2197 l_msg_count out nocopy number,
2198 l_msg_data out nocopy varchar2
2199 );
2200
2201 Function Get_Rounding_factor(p_list_header_id number) return number;
2202
2203
2204 Function Get_qp_lookup_meaning( in_lookup_code in varchar2,
2205 in_lookup_type in varchar2) return varchar2;
2206
2207 PROCEDURE Get_modifier_name(
2208 in_list_header_id in number
2209 ,out_name out nocopy varchar2
2210 ,out_description out nocopy varchar2
2211 ,out_end_date out nocopy date
2212 ,out_start_date out nocopy date
2213 ,out_currency out nocopy varchar2
2214 ,out_ask_for_flag out nocopy varchar2
2215 );
2216
2217 FUNCTION get_pricing_attribute(
2218 in_CONTEXT_NAME in varchar2,
2219 in_ATTRIBUTE_NAME in varchar2
2220 ) return varchar2;
2221
2222
2223 PROCEDURE get_Price_List_info(
2224 p_price_list_id IN NUMBER,
2225 out_name out nocopy varchar2,
2226 out_end_date out nocopy date,
2227 out_start_date out nocopy date,
2228 out_automatic_flag out nocopy varchar2,
2229 out_rounding_factor out nocopy varchar2,
2230 out_terms_id out nocopy number,
2231 out_gsa_indicator out nocopy varchar2,
2232 out_currency out nocopy varchar2,
2233 out_freight_terms_code out nocopy varchar2);
2234
2235
2236 PROCEDURE get_item_information(
2237 in_inventory_item_id in number
2238 ,in_org_id in number
2239 ,out_item_status out nocopy varchar2
2240 ,out_wsh out nocopy varchar2
2241 ,out_wsh_name out nocopy varchar2
2242 ,out_category out nocopy varchar2
2243 ,out_lead_time out nocopy number
2244 ,out_cost out nocopy number
2245 ,out_primary_uom out nocopy varchar2
2246 ,out_user_item_type out nocopy varchar2
2247 ,out_make_or_buy out nocopy varchar2
2248 ,out_weight_uom out nocopy varchar2
2249 ,out_unit_weight out nocopy number
2250 ,out_volume_uom out nocopy varchar2
2251 ,out_unit_volume out nocopy number
2252 ,out_min_order_quantity out nocopy number
2253 ,out_max_order_quantity out nocopy number
2254 ,out_fixed_order_quantity out nocopy number
2255 ,out_customer_order_flag out nocopy varchar2
2256 ,out_internal_order_flag out nocopy varchar2
2257 ,out_stockable out nocopy varchar2
2258 ,out_reservable out nocopy varchar2
2259 ,out_returnable out nocopy varchar2
2260 ,out_shippable out nocopy varchar2
2261 ,out_orderable_on_web out nocopy varchar2
2262 ,out_taxable out nocopy varchar2
2263 ,out_serviceable out nocopy varchar2
2264 ,out_atp_flag out nocopy varchar2
2265 ,out_bom_item_type out nocopy varchar2
2266 ,out_replenish_to_order_flag out nocopy varchar2
2267 ,out_build_in_wip_flag out nocopy varchar2
2268 ,out_default_so_source_type out nocopy varchar2
2269 );
2270
2271 PROCEDURE print_time(in_place in varchar2);
2272
2273 PROCEDURE print_time2;
2274
2275
2276 PROCEDURE Get_list_line_details(
2277 in_list_line_id in number
2278 ,out_end_date out nocopy date
2279 ,out_start_date out nocopy date
2280 ,out_list_line_type_Code out nocopy varchar2
2281 ,out_modifier_level_code out nocopy varchar2
2282
2283 );
2284
2285 PROCEDURE get_global_availability(
2286 in_customer_id in number
2287 ,in_customer_site_id in number
2288 ,in_inventory_item_id in number
2289 ,in_org_id in number
2290 ,x_return_status out nocopy varchar2
2291 ,x_msg_data out nocopy varchar2
2292 ,x_msg_count out nocopy number
2293 ,l_source_orgs_table out nocopy source_orgs_table
2294 );
2295
2296
2297 PROCEDURE different_uom(
2298 in_org_id in number
2299 ,in_ordered_uom in varchar2
2300 ,in_pricing_uom in varchar2
2301 ,out_conversion_rate out nocopy number
2302
2303 );
2304
2305 FUNCTION get_conversion_rate(in_uom_code in varchar2,
2306 in_base_uom in varchar2
2307 ) RETURN number;
2308
2309
2310 PROCEDURE Call_mrp_and_inventory(
2311 in_org_id in number
2312 ,out_on_hand_qty out nocopy number
2313 ,out_reservable_qty out nocopy number
2314 ,out_available_qty out nocopy varchar2
2315 ,out_available_date out nocopy date
2316 ,out_error_message out nocopy varchar2
2317 ,out_qty_uom out nocopy varchar2
2318 );
2319
2320 PROCEDURE set_mrp_debug(out_mrp_file out nocopy varchar2);
2321
2322
2323 PROCEDURE Create_Order(
2324 in_order in varchar2,
2325 in_header_rec oe_oe_pricing_availability.PA_Header_Tbl_Type,
2326 in_line_tbl Oe_Oe_Pricing_Availability.PA_Line_Tbl_Type,
2327 in_Header_Adj_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Tbl_Type,
2328 in_Line_Adj_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Tbl_Type,
2329 in_Header_price_Att_tbl Oe_Oe_Pricing_Availability.PA_H_PAtt_Tbl_Type,
2330 in_Header_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_Att_Tbl_Type,
2334 in_Line_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_L_Adj_AssTbl_Type,
2331 in_Header_Adj_Assoc_tbl Oe_Oe_Pricing_Availability.PA_H_Adj_AsTbl_Type,
2332 in_Line_price_Att_tbl Oe_Oe_Pricing_Availability.PA_Line_PAtt_Tbl_Type,
2333 in_Line_Adj_Att_tbl Oe_Oe_Pricing_Availability.PA_LAdj_Att_Tbl_Type,
2335 out_order_number out NOCOPY varchar2,
2336 out_header_id out NOCOPY number,
2337 out_order_total out NOCOPY number,
2338 out_order_amount out nocopy number,
2339 out_order_charges out nocopy number,
2340 out_order_discount out nocopy number,
2341 out_order_tax out nocopy number,
2342 out_item out nocopy varchar2,
2343 out_currency out nocopy varchar2,
2344 x_msg_count OUT NOCOPY NUMBER,
2345 x_msg_data OUT NOCOPY VARCHAR2,
2346 x_return_status OUT NOCOPY VARCHAR2
2347 );
2348
2349
2350 PROCEDURE pass_promotions_to_backend (in_promotions_tbl in promotions_tbl,
2351 in_line_id in number);
2352
2353 PROCEDURE get_atp_flag(
2354 in_inventory_item_id in number
2355 ,in_org_id in number
2356 ,out_atp_flag out NOCOPY /* file.sql.39 change */ varchar2
2357 ,out_default_source_type out NOCOPY /* file.sql.39 change */ varchar2
2358 );
2359
2360 FUNCTION Is_AdPricing_inst return varchar2;
2361
2362 --added for bug 3559935
2363 PROCEDURE RESET_DEBUG_LEVEL;
2364
2365 PROCEDURE SET_DEBUG_LEVEL (p_debug_level IN NUMBER);
2366
2367 PROCEDURE Get_Form_Startup_Values(Item_Id_Flex_Code IN VARCHAR2,
2368 Item_Id_Flex_Num OUT NOCOPY NUMBER);
2369
2370 Procedure get_user_item_Pricing_Contexts(
2371 p_request_type_code IN VARCHAR2,
2372 x_user_attribs_tbl OUT NOCOPY USER_ATTRIBUTE_TBL_TYPE);
2373
2374 --end 3559935
2375
2376 --added for bug 3245976
2377
2378 FUNCTION GET_MRP_ERR_MSG RETURN VARCHAR;
2379 FUNCTION GET_MRP_ERR_MSG_FLAG RETURN CHAR;
2380 --end bug 3245976
2381
2382 /* start bug 3440778 , Created to convert the reference to other products serverside code inside OEXPRAVA pld into a local call. to OE_OE_PRICING_AVAILABILITY package*/
2383
2384 FUNCTION Get_Cost (p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE DEFAULT OE_Order_Pub.G_MISS_LINE_REC
2385 ,p_request_rec IN Oe_Order_Pub.Request_Rec_Type DEFAULT Oe_Order_Pub.G_MISS_REQUEST_REC
2386 ,p_order_currency IN VARCHAR2 Default NULL
2387 ,p_sob_currency IN VARCHAR2 Default NULL
2388 ,p_inventory_item_id IN NUMBER Default NULL
2389 ,p_ship_from_org_id IN NUMBER Default NULL
2390 ,p_conversion_Type_code IN VARCHAR2 Default NULL
2391 ,p_conversion_rate IN NUMBER Default NULL
2392 ,p_item_type_code IN VARCHAR2 Default 'STANDARD'
2393 ,p_header_flag IN Boolean Default FALSE) RETURN NUMBER;
2394
2395 PROCEDURE Get_Agreement
2396 (
2397 p_sold_to_org_id IN NUMBER DEFAULT NULL
2398 ,p_transaction_type_id IN NUMBER DEFAULT NULL
2399 ,p_pricing_effective_date IN DATE
2400 ,p_agreement_tbl OUT NOCOPY agreement_tbl
2401 );
2402
2403 -- round_price.p_operand_type could be 'A' for adjustment amount or 'S' for item price
2404 PROCEDURE round_price
2405 (
2406 p_operand IN NUMBER
2407 ,p_rounding_factor IN NUMBER
2408 ,p_use_multi_currency IN VARCHAR2
2409 ,p_price_list_id IN NUMBER
2410 ,p_currency_code IN VARCHAR2
2411 ,p_pricing_effective_date IN DATE
2412 ,x_rounded_operand IN OUT NOCOPY NUMBER
2413 ,x_status_code IN OUT NOCOPY VARCHAR2
2414 ,p_operand_type IN VARCHAR2 default 'S'
2415 );
2416
2417 -- end bug 3440778
2418 FUNCTION IS_PRICING_AVAILIBILITY RETURN VARCHAR2 ; --bug#7380336
2419 END oe_oe_pricing_availability;