eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OE_OE_AVAILABILITY

Source


1 PACKAGE oe_oe_availability AUTHID CURRENT_USER AS
2 /* $Header: OEXFAVAS.pls 120.1 2011/06/21 11:33:12 nilegupt ship $ */
3 
4 
5 
6 TYPE source_orgs_rec IS RECORD
7          ( org_id number,
8            instance_id number,
9            ship_method varchar2(30),
10            delivery_lead_time number,
11            freight_carrier varchar2(30),
12            instance_code varchar2(5),
13            attribute1 varchar2(100),
14            attribute2 varchar2(100),
15            attribute3 varchar2(100),
16            attribute4 varchar2(100),
17            attribute5 varchar2(100),
18            attribute6 number,
19            attribute7 number,
20            attribute8 number,
21            attribute9 number,
22            attribute10 number,
23            attribute11 date,
24            attribute12 date,
25            attribute13 date,
26            attribute14 date,
27            attribute15 date
28          );
29 
30 TYPE source_orgs_table IS TABLE OF source_orgs_rec index by binary_integer;
31 
32 TYPE panda_rec is RECORD
33        (
34 	   p_inventory_item_id      number,
35 	   p_qty                    number,
36 	   p_uom                    varchar2(20),
37 	   p_request_date           date,
38 	   p_customer_id            number,
39 	   p_item_identifier_type   varchar2(40),
40 	   p_agreement_id           number,
41 	   p_price_list_id          number,
42 	   p_ship_to_org_id         number,
43 	   p_invoice_to_org_id      number,
44 	   p_ship_from_org_id       number,
45 	   p_pricing_date           date,
46 	   p_order_type_id          number,
47 	   p_ordered_item_id        number, -- added this to fix the bug 3661905
48 	   p_currency               varchar2(20),
49 	   p_pricing_context        varchar2(30),
50 	   p_pricing_attribute1     varchar2(240),
51 	   p_pricing_attribute2     varchar2(240),
52 	   p_pricing_attribute3     varchar2(240),
53 	   p_pricing_attribute4     varchar2(240),
54 	   p_pricing_attribute5     varchar2(240),
55 	   p_pricing_attribute6     varchar2(240),
56 	   p_pricing_attribute7     varchar2(240),
57 	   p_pricing_attribute8     varchar2(240),
58 	   p_pricing_attribute9     varchar2(240),
59 	   p_pricing_attribute10    varchar2(240),
60 	   p_pricing_attribute11    varchar2(240),
61 	   p_pricing_attribute12    varchar2(240),
62 	   p_pricing_attribute13    varchar2(240),
63 	   p_pricing_attribute14    varchar2(240),
64 	   p_pricing_attribute15    varchar2(240),
65 	   p_pricing_attribute16    varchar2(240),
66 	   p_pricing_attribute17    varchar2(240),
67 	   p_pricing_attribute18    varchar2(240),
68 	   p_pricing_attribute19    varchar2(240),
69 	   p_pricing_attribute20    varchar2(240),
70 	   p_pricing_attribute21    varchar2(240),
71 	   p_pricing_attribute22    varchar2(240),
72 	   p_pricing_attribute23    varchar2(240),
73 	   p_pricing_attribute24    varchar2(240),
74 	   p_pricing_attribute25    varchar2(240),
75 	   p_pricing_attribute26    varchar2(240),
76 	   p_pricing_attribute27    varchar2(240),
77 	   p_pricing_attribute28    varchar2(240),
78 	   p_pricing_attribute29    varchar2(240),
79 	   p_pricing_attribute30    varchar2(240),
80 	   p_pricing_attribute31    varchar2(240),
81 	   p_pricing_attribute32    varchar2(240),
82 	   p_pricing_attribute33    varchar2(240),
83 	   p_pricing_attribute34    varchar2(240),
84 	   p_pricing_attribute35    varchar2(240),
85 	   p_pricing_attribute36    varchar2(240),
86 	   p_pricing_attribute37    varchar2(240),
87 	   p_pricing_attribute38    varchar2(240),
88 	   p_pricing_attribute39    varchar2(240),
89 	   p_pricing_attribute40    varchar2(240),
90 	   p_pricing_attribute41    varchar2(240),
91 	   p_pricing_attribute42    varchar2(240),
92 	   p_pricing_attribute43    varchar2(240),
93 	   p_pricing_attribute44    varchar2(240),
94 	   p_pricing_attribute45    varchar2(240),
95 	   p_pricing_attribute46    varchar2(240),
96 	   p_pricing_attribute47    varchar2(240),
97 	   p_pricing_attribute48    varchar2(240),
98 	   p_pricing_attribute49    varchar2(240),
99 	   p_pricing_attribute50    varchar2(240),
100 	   p_pricing_attribute51    varchar2(240),
101 	   p_pricing_attribute52    varchar2(240),
102 	   p_pricing_attribute53    varchar2(240),
103 	   p_pricing_attribute54    varchar2(240),
104 	   p_pricing_attribute55    varchar2(240),
105 	   p_pricing_attribute56    varchar2(240),
106 	   p_pricing_attribute57    varchar2(240),
107 	   p_pricing_attribute58    varchar2(240),
108 	   p_pricing_attribute59    varchar2(240),
109 	   p_pricing_attribute60    varchar2(240),
110 	   p_pricing_attribute61    varchar2(240),
111 	   p_pricing_attribute62    varchar2(240),
112 	   p_pricing_attribute63    varchar2(240),
113 	   p_pricing_attribute64    varchar2(240),
114 	   p_pricing_attribute65    varchar2(240),
115 	   p_pricing_attribute66    varchar2(240),
116 	   p_pricing_attribute67    varchar2(240),
117 	   p_pricing_attribute68    varchar2(240),
118 	   p_pricing_attribute69    varchar2(240),
119 	   p_pricing_attribute70    varchar2(240),
120 	   p_pricing_attribute71    varchar2(240),
121 	   p_pricing_attribute72    varchar2(240),
122 	   p_pricing_attribute73    varchar2(240),
123 	   p_pricing_attribute74    varchar2(240),
124 	   p_pricing_attribute75    varchar2(240),
125 	   p_pricing_attribute76    varchar2(240),
126 	   p_pricing_attribute77    varchar2(240),
127 	   p_pricing_attribute78    varchar2(240),
128 	   p_pricing_attribute79    varchar2(240),
129 	   p_pricing_attribute80    varchar2(240),
130 	   p_pricing_attribute81    varchar2(240),
131 	   p_pricing_attribute82    varchar2(240),
132 	   p_pricing_attribute83    varchar2(240),
133 	   p_pricing_attribute84    varchar2(240),
134 	   p_pricing_attribute85    varchar2(240),
135 	   p_pricing_attribute86    varchar2(240),
136 	   p_pricing_attribute87    varchar2(240),
137 	   p_pricing_attribute88    varchar2(240),
138 	   p_pricing_attribute89    varchar2(240),
139 	   p_pricing_attribute90    varchar2(240),
140 	   p_pricing_attribute91    varchar2(240),
141 	   p_pricing_attribute92    varchar2(240),
142 	   p_pricing_attribute93    varchar2(240),
143 	   p_pricing_attribute94    varchar2(240),
144 	   p_pricing_attribute95    varchar2(240),
145 	   p_pricing_attribute96    varchar2(240),
146 	   p_pricing_attribute97    varchar2(240),
147 	   p_pricing_attribute98    varchar2(240),
148 	   p_pricing_attribute99    varchar2(240),
149 	   p_pricing_attribute100   varchar2(240),
150 	   p_char_attribute1        varchar2(240),
151 	   p_char_attribute2        varchar2(240),
152 	   p_char_attribute3        varchar2(240),
153 	   p_char_attribute4        varchar2(240),
154 	   p_char_attribute5        varchar2(240),
155 	   p_char_attribute6        varchar2(240),
156 	   p_char_attribute7        varchar2(240),
157 	   p_char_attribute8        varchar2(240),
158 	   p_char_attribute9        varchar2(240),
159 	   p_char_attribute10       varchar2(240),
160 	   p_num_attribute1         number,
161 	   p_num_attribute2         number,
162 	   p_num_attribute3         number,
163 	   p_num_attribute4         number,
164 	   p_num_attribute5         number,
165 	   p_num_attribute6         number,
166 	   p_num_attribute7         number,
167 	   p_num_attribute8         number,
168 	   p_num_attribute9         number,
169 	   p_num_attribute10        number,
170            p_date_attribute1        date,
171 	   p_date_attribute2        date,
172 	   p_date_attribute3        date,
173 	   p_date_attribute4        date,
174 	   p_date_attribute5        DATE,
175      p_conversion_type_code   VARCHAR2(30),  --added for bug12541442
176      p_conversion_rate        number       --added for bug12541442
177       );
178 
179 TYPE panda_rec_table IS TABLE OF panda_rec index by binary_integer;
180 
181 g_panda_rec_table panda_rec_table;
182 Procedure Call_MRP_ATP(
183                in_global_orgs  in varchar2,
184                in_ship_from_org_id in number,
185 out_available_qty out nocopy varchar2,
186 
187 out_ship_from_org_id out nocopy number,
188 
189 out_available_date out nocopy date,
190 
191 out_qty_uom out nocopy varchar2,
192 
193 x_out_message out nocopy varchar2,
194 
195 x_return_status OUT NOCOPY VARCHAR2,
196 
197 x_msg_count OUT NOCOPY NUMBER,
198 
199 x_msg_data OUT NOCOPY VARCHAR2,
200 
201 x_error_message out nocopy varchar2
202 
203                       );
204 
205 
206 PROCEDURE  defaulting(
207             in_source in varchar2
208             ,in_org_id in varchar2
209             ,in_item_id in number
210             ,in_customer_id in number
211             ,in_ship_to_org_id in number
212             ,in_bill_to_org_id in number
213             ,in_agreement_id in number
214             ,in_order_type_id in number
215 ,out_wsh_id out nocopy number
216 
217 ,out_uom out nocopy varchar2
218 
219 ,out_item_type_code out nocopy varchar2
220 
221 ,out_price_list_id out nocopy number
222 
223 ,out_conversion_type out nocopy varchar2
224 
225                      );
226 
227 Procedure Check_Results_from_rec (
228            in_global_orgs    in varchar2
229           ,p_atp_rec         IN  MRP_ATP_PUB.ATP_Rec_Typ
230 ,x_return_status OUT NOCOPY VARCHAR2
231 
232 ,x_msg_count OUT NOCOPY NUMBER
233 
234 ,x_msg_data OUT NOCOPY VARCHAR2
235 
236 ,x_error_message out nocopy varchar2
237 
238                                   );
239 
240 Procedure Initialize_mrp_record(
241           p_x_atp_rec IN  OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ
242          ,l_count     IN  NUMBER);
243 
244 Procedure Query_Qty_Tree(
245                          p_org_id            IN NUMBER,
246                          p_item_id           IN NUMBER,
247                          p_sch_date          IN DATE DEFAULT NULL,
248 x_on_hand_qty OUT NOCOPY NUMBER,
249 
250 x_avail_to_reserve OUT NOCOPY NUMBER);
251 
252 
253 
254 PROCEDURE get_ship_from_org(in_org_id in number,
255 out_code out nocopy varchar2,
256 
257 out_name out nocopy varchar2
258 
259                            );
260 
261 PROCEDURE copy_Header_to_request(
262               p_request_type_code in varchar2
263              ,p_calculate_price_flag in varchar2
264              ,px_req_line_tbl   in out nocopy	QP_PREQ_GRP.LINE_TBL_TYPE
265               );
266 
267 
268 PROCEDURE copy_Line_to_request(
269               px_req_line_tbl   in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
270              ,p_pricing_event   in    varchar2
271              ,p_Request_Type_Code in	varchar2
272              ,p_honor_price_flag in VARCHAR2 Default 'Y'
273              ,p_line_index in number
274 		);
275 
276 
277 PROCEDURE set_pricing_control_record (
278              l_Control_Rec  in out nocopy QP_PREQ_GRP.CONTROL_RECORD_TYPE
279             ,in_pricing_event in varchar2);
280 
281 
282 
283 PROCEDURE build_context_for_line(
284              p_req_line_tbl_count in number,
285              p_price_request_code in varchar2,
286              p_item_type_code in varchar2,
287              p_Req_line_attr_tbl in out nocopy  QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
288              p_Req_qual_tbl in out  nocopy  QP_PREQ_GRP.QUAL_TBL_TYPE,
289              p_line_index in number
290             );
291 
292 
293 
294 PROCEDURE build_context_for_header(
295              p_req_line_tbl_count in number,
296              p_price_request_code in varchar2,
297              p_item_type_code in varchar2,
298              p_Req_line_attr_tbl in out nocopy  QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
299              p_Req_qual_tbl in out  nocopy  QP_PREQ_GRP.QUAL_TBL_TYPE
300             );
301 
302 
303 PROCEDURE copy_attribs_to_Req(
304          p_line_index number
305         ,px_Req_line_attr_tbl in out nocopy  QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
306         ,px_Req_qual_tbl in out  nocopy  QP_PREQ_GRP.QUAL_TBL_TYPE
307         ,p_pricing_contexts_Tbl  QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
308         ,p_qualifier_contexts_Tbl  QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
309                              );
310 PROCEDURE append_attr_to_TTables(px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE);
311 
312 PROCEDURE  Append_attributes(
313            p_header_id number default null
314           ,p_Line_id number default null
315           ,p_line_index number
316           ,px_Req_line_attr_tbl in out nocopy  QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
317           ,px_Req_qual_tbl in out nocopy  QP_PREQ_GRP.QUAL_TBL_TYPE
318           ,p_g_line_index in number  );
319 
320 PROCEDURE Reset_All_Tbls;
321 procedure Populate_Temp_Table;
322 PROCEDURE populate_results(
323 x_line_tbl  out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
324 x_line_qual_tbl  out nocopy  QP_PREQ_GRP.QUAL_TBL_TYPE,
325 x_line_attr_tbl  out nocopy  QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
326 x_LINE_DETAIL_tbl out nocopy  QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
327 x_LINE_DETAIL_qual_tbl    out nocopy  QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
328 x_LINE_DETAIL_attr_tbl   out   nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
329 x_related_lines_tbl       out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE
330 );
331 
332 PROCEDURE price_item(
333 out_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
334 out_Req_line_attr_tbl         in out nocopy  QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
335 out_Req_LINE_DETAIL_attr_tbl  in out nocopy  QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
336 out_Req_LINE_DETAIL_tbl        in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
337 out_Req_related_lines_tbl      in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
338 out_Req_qual_tbl               in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
339 out_Req_LINE_DETAIL_qual_tbl   in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
340 out_child_detail_type out nocopy varchar2
341                     );
342 
343 PROCEDURE pass_values_to_backend(
344 				in_panda_rec_table in panda_rec_table
345 				 );
346 
347 
348 PROCEDURE process_pricing_errors(
349                 in_line_type_code in varchar2,
350                 in_status_code    in varchar2,
351                 in_status_text    in varchar2,
352                 in_ordered_item    in varchar2,
353                 in_uom    in varchar2,
354                 in_unit_price    in number,
355                 in_adjusted_unit_price    in number,
356                 in_process_code    in varchar2 ,
357                 in_price_flag    in varchar2,
358                 in_price_list_id in number,
359 l_return_status out nocopy varchar2,
360 
361 l_msg_count out nocopy number,
362 
363 l_msg_data out nocopy varchar2
364 
365                 );
366 
367 Function Get_Rounding_factor(p_list_header_id number) return number;
368 
369 
370 Function Get_qp_lookup_meaning( in_lookup_code in varchar2,
371                                 in_lookup_type in varchar2) return varchar2;
372 
373 PROCEDURE Get_modifier_name( in_list_header_id in number
374 ,out_name out nocopy varchar2
375 
376 ,out_description out nocopy varchar2
377 
378 ,out_end_date out nocopy date
379 
380 ,out_start_date out nocopy date
381 
382 ,out_currency out nocopy varchar2
383 
384 ,out_ask_for_flag out nocopy varchar2
385 
386                            );
387 
388 FUNCTION get_pricing_attribute(
389                        in_CONTEXT_NAME in varchar2,
390                        in_ATTRIBUTE_NAME in varchar2
391                                ) return varchar2;
392 
393 
394 PROCEDURE get_Price_List_info(
395                           p_price_list_id IN  NUMBER,
396 out_name out nocopy varchar2,
397 
398 out_end_date out nocopy date,
399 
400 out_start_date out nocopy date,
401 
402 out_automatic_flag out nocopy varchar2,
403 
404 out_rounding_factor out nocopy varchar2,
405 
406 out_terms_id out nocopy number,
407 
408 out_gsa_indicator out nocopy varchar2,
409 
410 out_currency out nocopy varchar2,
411 
412 out_freight_terms_code out nocopy varchar2);
413 
414 
415 
416 PROCEDURE  get_item_information(
417             in_inventory_item_id in number
418            ,in_org_id in number
419 ,out_item_status out nocopy varchar2
420 
421 ,out_wsh out nocopy varchar2
422 
423 ,out_wsh_name out nocopy varchar2
424 
425 ,out_category out nocopy varchar2
426 
427 ,out_lead_time out nocopy number
428 
429 ,out_cost out nocopy number
430 
431 ,out_primary_uom out nocopy varchar2
432 
433 ,out_user_item_type out nocopy varchar2
434 
435 ,out_make_or_buy out nocopy varchar2
436 
437 ,out_weight_uom out nocopy varchar2
438 
439 ,out_unit_weight out nocopy number
440 
441 ,out_volume_uom out nocopy varchar2
442 
443 ,out_unit_volume out nocopy number
444 
445 ,out_min_order_quantity out nocopy number
446 
447 ,out_max_order_quantity out nocopy number
448 
449 ,out_fixed_order_quantity out nocopy number
450 
451 ,out_customer_order_flag out nocopy varchar2
452 
453 ,out_internal_order_flag out nocopy varchar2
454 
455 ,out_stockable out nocopy varchar2
456 
457 ,out_reservable out nocopy varchar2
458 
459 ,out_returnable out nocopy varchar2
460 
461 ,out_shippable out nocopy varchar2
462 
463 ,out_orderable_on_web out nocopy varchar2
464 
465 ,out_taxable out nocopy varchar2
466 
467 ,out_serviceable out nocopy varchar2
468 
469 ,out_atp_flag out nocopy varchar2
470 
471           );
472 
473 PROCEDURE print_time(in_place in varchar2);
474 
475 PROCEDURE print_time2;
476 
477 
478 PROCEDURE Get_list_line_details( in_list_line_id in number
479 ,out_end_date out nocopy date
480 
481 ,out_start_date out nocopy date
482 
483 ,out_list_line_type_Code out nocopy varchar2
484 
485 ,out_modifier_level_code out nocopy varchar2
486 
487                            );
488 
489 PROCEDURE get_global_availability(
490                        in_customer_id in number
491                       ,in_customer_site_id in number
492                       ,in_inventory_item_id in number
493                       ,in_org_id            in number
494 ,x_return_status out nocopy varchar2
495 
496 ,x_msg_data out nocopy varchar2
497 
498 ,x_msg_count out nocopy number
499 
500 ,l_source_orgs_table out nocopy source_orgs_table
501 
502                                  );
503 
504 
505 PROCEDURE different_uom(
506                         in_org_id in number
507                        ,in_ordered_uom in varchar2
508                        ,in_pricing_uom in varchar2
509 ,out_conversion_rate out nocopy number
510 
511                        );
512 
513 FUNCTION get_conversion_rate(in_uom_code in varchar2,
514                               in_base_uom in varchar2
515                              ) RETURN number;
516 
517 
518 PROCEDURE Call_mrp_and_inventory(
519                         in_org_id in number
520 ,out_on_hand_qty out nocopy number
521 
522 ,out_reservable_qty out nocopy number
523 
524 ,out_available_qty out nocopy varchar2
525 
526 ,out_available_date out nocopy date
527 
528 ,out_error_message out nocopy varchar2
529 
530 ,out_qty_uom out nocopy varchar2
531 
532                                 );
533 
534 PROCEDURE set_mrp_debug(out_mrp_file out nocopy varchar2);
535 
536 
537 
538 PROCEDURE copy_fields_to_globals(
539                 in_inventory_item_id      in number,
540                 in_qty                    in number,
541                 in_uom                    in varchar2,
542                 in_request_date           in date,
543                 in_customer_id            in number,
544                 in_item_identifier_type   in varchar2,
545                 in_agreement_id           in number,
546                 in_price_list_id          in number,
547                 in_ship_to_org_id         in number,
548                 in_invoice_to_org_id      in number,
549                 in_ship_from_org_id       in number,
550                 in_pricing_date           in date,
551                 in_order_type_id          in number,
552                 in_currency               in varchar2,
553                 in_pricing_context        in varchar2,
554                 in_pricing_attribute1     in varchar2,
555                 in_pricing_attribute2     in varchar2,
556                 in_pricing_attribute3     in varchar2,
557                 in_pricing_attribute4     in varchar2,
558                 in_pricing_attribute5     in varchar2,
559                 in_pricing_attribute6     in varchar2,
560                 in_pricing_attribute7     in varchar2,
561                 in_pricing_attribute8     in varchar2,
562                 in_pricing_attribute9     in varchar2,
563                 in_pricing_attribute10    in varchar2,
564                 in_pricing_attribute11    in varchar2,
565                 in_pricing_attribute12    in varchar2,
566                 in_pricing_attribute13    in varchar2,
567                 in_pricing_attribute14    in varchar2,
568                 in_pricing_attribute15    in varchar2,
569                 in_pricing_attribute16    in varchar2,
570                 in_pricing_attribute17    in varchar2,
571                 in_pricing_attribute18    in varchar2,
572                 in_pricing_attribute19    in varchar2,
573                 in_pricing_attribute20    in varchar2,
574                 in_pricing_attribute21    in varchar2,
575                 in_pricing_attribute22    in varchar2,
576                 in_pricing_attribute23    in varchar2,
577                 in_pricing_attribute24    in varchar2,
578                 in_pricing_attribute25    in varchar2,
579                 in_pricing_attribute26    in varchar2,
580                 in_pricing_attribute27    in varchar2,
581                 in_pricing_attribute28    in varchar2,
582                 in_pricing_attribute29    in varchar2,
583                 in_pricing_attribute30    in varchar2,
584                 in_pricing_attribute31    in varchar2,
585                 in_pricing_attribute32    in varchar2,
586                 in_pricing_attribute33    in varchar2,
587                 in_pricing_attribute34    in varchar2,
588                 in_pricing_attribute35    in varchar2,
589                 in_pricing_attribute36    in varchar2,
590                 in_pricing_attribute37    in varchar2,
591                 in_pricing_attribute38    in varchar2,
592                 in_pricing_attribute39    in varchar2,
593                 in_pricing_attribute40    in varchar2,
594                 in_pricing_attribute41    in varchar2,
595                 in_pricing_attribute42    in varchar2,
596                 in_pricing_attribute43    in varchar2,
597                 in_pricing_attribute44    in varchar2,
598                 in_pricing_attribute45    in varchar2,
599                 in_pricing_attribute46    in varchar2,
600                 in_pricing_attribute47    in varchar2,
601                 in_pricing_attribute48    in varchar2,
602                 in_pricing_attribute49    in varchar2,
603                 in_pricing_attribute50    in varchar2,
604                 in_pricing_attribute51    in varchar2,
605                 in_pricing_attribute52    in varchar2,
606                 in_pricing_attribute53    in varchar2,
607                 in_pricing_attribute54    in varchar2,
608                 in_pricing_attribute55    in varchar2,
609                 in_pricing_attribute56    in varchar2,
610                 in_pricing_attribute57    in varchar2,
611                 in_pricing_attribute58    in varchar2,
612                 in_pricing_attribute59    in varchar2,
613                 in_pricing_attribute60    in varchar2,
614                 in_pricing_attribute61    in varchar2,
615                 in_pricing_attribute62    in varchar2,
616                 in_pricing_attribute63    in varchar2,
617                 in_pricing_attribute64    in varchar2,
618                 in_pricing_attribute65    in varchar2,
619                 in_pricing_attribute66    in varchar2,
620                 in_pricing_attribute67    in varchar2,
621                 in_pricing_attribute68    in varchar2,
622                 in_pricing_attribute69    in varchar2,
623                 in_pricing_attribute70    in varchar2,
624                 in_pricing_attribute71    in varchar2,
625                 in_pricing_attribute72    in varchar2,
626                 in_pricing_attribute73    in varchar2,
627                 in_pricing_attribute74    in varchar2,
628                 in_pricing_attribute75    in varchar2,
629                 in_pricing_attribute76    in varchar2,
630                 in_pricing_attribute77    in varchar2,
631                 in_pricing_attribute78    in varchar2,
632                 in_pricing_attribute79    in varchar2,
633                 in_pricing_attribute80    in varchar2,
634                 in_pricing_attribute81    in varchar2,
635                 in_pricing_attribute82    in varchar2,
636                 in_pricing_attribute83    in varchar2,
637                 in_pricing_attribute84    in varchar2,
638                 in_pricing_attribute85    in varchar2,
639                 in_pricing_attribute86    in varchar2,
640                 in_pricing_attribute87    in varchar2,
641                 in_pricing_attribute88    in varchar2,
642                 in_pricing_attribute89    in varchar2,
643                 in_pricing_attribute90    in varchar2,
644                 in_pricing_attribute91    in varchar2,
645                 in_pricing_attribute92    in varchar2,
646                 in_pricing_attribute93    in varchar2,
647                 in_pricing_attribute94    in varchar2,
648                 in_pricing_attribute95    in varchar2,
649                 in_pricing_attribute96    in varchar2,
650                 in_pricing_attribute97    in varchar2,
651                 in_pricing_attribute98    in varchar2,
652                 in_pricing_attribute99    in varchar2,
653                 in_pricing_attribute100   in VARCHAR2,
654                 in_conversion_type_code   IN VARCHAR2 DEFAULT NULL,    --added for bug 12541442
655                 in_conversion_rate        IN NUMBER   DEFAULT NULL);   --added for bug 12541442
656 
657 END oe_oe_availability;