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 AS
2 /* $Header: OEXFAVAS.pls 120.0.12010000.1 2008/07/25 07:47:50 appldev 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 
176 TYPE panda_rec_table IS TABLE OF panda_rec index by binary_integer;
177 
178 g_panda_rec_table panda_rec_table;
179 Procedure Call_MRP_ATP(
180                in_global_orgs  in varchar2,
181                in_ship_from_org_id in number,
182 out_available_qty out nocopy varchar2,
183 
184 out_ship_from_org_id out nocopy number,
185 
186 out_available_date out nocopy date,
187 
188 out_qty_uom out nocopy varchar2,
189 
190 x_out_message out nocopy varchar2,
191 
192 x_return_status OUT NOCOPY VARCHAR2,
193 
194 x_msg_count OUT NOCOPY NUMBER,
195 
196 x_msg_data OUT NOCOPY VARCHAR2,
197 
198 x_error_message out nocopy varchar2
199 
200                       );
201 
202 
203 PROCEDURE  defaulting(
204             in_source in varchar2
205             ,in_org_id in varchar2
206             ,in_item_id in number
207             ,in_customer_id in number
208             ,in_ship_to_org_id in number
209             ,in_bill_to_org_id in number
210             ,in_agreement_id in number
211             ,in_order_type_id in number
212 ,out_wsh_id out nocopy number
213 
214 ,out_uom out nocopy varchar2
215 
216 ,out_item_type_code out nocopy varchar2
217 
218 ,out_price_list_id out nocopy number
219 
220 ,out_conversion_type out nocopy varchar2
221 
222                      );
223 
224 Procedure Check_Results_from_rec (
225            in_global_orgs    in varchar2
226           ,p_atp_rec         IN  MRP_ATP_PUB.ATP_Rec_Typ
227 ,x_return_status OUT NOCOPY VARCHAR2
228 
229 ,x_msg_count OUT NOCOPY NUMBER
230 
231 ,x_msg_data OUT NOCOPY VARCHAR2
232 
233 ,x_error_message out nocopy varchar2
234 
235                                   );
236 
237 Procedure Initialize_mrp_record(
238           p_x_atp_rec IN  OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ
239          ,l_count     IN  NUMBER);
240 
241 Procedure Query_Qty_Tree(
242                          p_org_id            IN NUMBER,
243                          p_item_id           IN NUMBER,
244                          p_sch_date          IN DATE DEFAULT NULL,
245 x_on_hand_qty OUT NOCOPY NUMBER,
246 
247 x_avail_to_reserve OUT NOCOPY NUMBER);
248 
249 
250 
251 PROCEDURE get_ship_from_org(in_org_id in number,
252 out_code out nocopy varchar2,
253 
254 out_name out nocopy varchar2
255 
256                            );
257 
258 PROCEDURE copy_Header_to_request(
259               p_request_type_code in varchar2
260              ,p_calculate_price_flag in varchar2
261              ,px_req_line_tbl   in out nocopy	QP_PREQ_GRP.LINE_TBL_TYPE
262               );
263 
264 
265 PROCEDURE copy_Line_to_request(
266               px_req_line_tbl   in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
267              ,p_pricing_event   in    varchar2
268              ,p_Request_Type_Code in	varchar2
269              ,p_honor_price_flag in VARCHAR2 Default 'Y'
270              ,p_line_index in number
271 		);
272 
273 
274 PROCEDURE set_pricing_control_record (
275              l_Control_Rec  in out nocopy QP_PREQ_GRP.CONTROL_RECORD_TYPE
276             ,in_pricing_event in varchar2);
277 
278 
279 
280 PROCEDURE build_context_for_line(
281              p_req_line_tbl_count in number,
282              p_price_request_code in varchar2,
283              p_item_type_code in varchar2,
284              p_Req_line_attr_tbl in out nocopy  QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
285              p_Req_qual_tbl in out  nocopy  QP_PREQ_GRP.QUAL_TBL_TYPE,
286              p_line_index in number
287             );
288 
289 
290 
291 PROCEDURE build_context_for_header(
292              p_req_line_tbl_count in number,
293              p_price_request_code in varchar2,
294              p_item_type_code in varchar2,
295              p_Req_line_attr_tbl in out nocopy  QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
296              p_Req_qual_tbl in out  nocopy  QP_PREQ_GRP.QUAL_TBL_TYPE
297             );
298 
299 
300 PROCEDURE copy_attribs_to_Req(
301          p_line_index number
302         ,px_Req_line_attr_tbl in out nocopy  QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
303         ,px_Req_qual_tbl in out  nocopy  QP_PREQ_GRP.QUAL_TBL_TYPE
304         ,p_pricing_contexts_Tbl  QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
305         ,p_qualifier_contexts_Tbl  QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
306                              );
307 PROCEDURE append_attr_to_TTables(px_req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE);
308 
309 PROCEDURE  Append_attributes(
310            p_header_id number default null
311           ,p_Line_id number default null
312           ,p_line_index number
313           ,px_Req_line_attr_tbl in out nocopy  QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
314           ,px_Req_qual_tbl in out nocopy  QP_PREQ_GRP.QUAL_TBL_TYPE
315           ,p_g_line_index in number  );
316 
317 PROCEDURE Reset_All_Tbls;
318 procedure Populate_Temp_Table;
319 PROCEDURE populate_results(
320 x_line_tbl  out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
321 x_line_qual_tbl  out nocopy  QP_PREQ_GRP.QUAL_TBL_TYPE,
322 x_line_attr_tbl  out nocopy  QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
323 x_LINE_DETAIL_tbl out nocopy  QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
324 x_LINE_DETAIL_qual_tbl    out nocopy  QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
325 x_LINE_DETAIL_attr_tbl   out   nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
326 x_related_lines_tbl       out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE
327 );
328 
329 PROCEDURE price_item(
330 out_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE,
331 out_Req_line_attr_tbl         in out nocopy  QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
332 out_Req_LINE_DETAIL_attr_tbl  in out nocopy  QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
333 out_Req_LINE_DETAIL_tbl        in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
334 out_Req_related_lines_tbl      in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
335 out_Req_qual_tbl               in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
336 out_Req_LINE_DETAIL_qual_tbl   in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
337 out_child_detail_type out nocopy varchar2
338                     );
339 
340 PROCEDURE pass_values_to_backend(
341 				in_panda_rec_table in panda_rec_table
342 				 );
343 
344 
345 PROCEDURE process_pricing_errors(
346                 in_line_type_code in varchar2,
347                 in_status_code    in varchar2,
348                 in_status_text    in varchar2,
349                 in_ordered_item    in varchar2,
350                 in_uom    in varchar2,
351                 in_unit_price    in number,
352                 in_adjusted_unit_price    in number,
353                 in_process_code    in varchar2 ,
354                 in_price_flag    in varchar2,
355                 in_price_list_id in number,
356 l_return_status out nocopy varchar2,
357 
358 l_msg_count out nocopy number,
359 
360 l_msg_data out nocopy varchar2
361 
362                 );
363 
364 Function Get_Rounding_factor(p_list_header_id number) return number;
365 
366 
367 Function Get_qp_lookup_meaning( in_lookup_code in varchar2,
368                                 in_lookup_type in varchar2) return varchar2;
369 
373 ,out_description out nocopy varchar2
370 PROCEDURE Get_modifier_name( in_list_header_id in number
371 ,out_name out nocopy varchar2
372 
374 
375 ,out_end_date out nocopy date
376 
377 ,out_start_date out nocopy date
378 
379 ,out_currency out nocopy varchar2
380 
381 ,out_ask_for_flag out nocopy varchar2
382 
383                            );
384 
385 FUNCTION get_pricing_attribute(
386                        in_CONTEXT_NAME in varchar2,
387                        in_ATTRIBUTE_NAME in varchar2
388                                ) return varchar2;
389 
390 
391 PROCEDURE get_Price_List_info(
392                           p_price_list_id IN  NUMBER,
393 out_name out nocopy varchar2,
394 
395 out_end_date out nocopy date,
396 
397 out_start_date out nocopy date,
398 
399 out_automatic_flag out nocopy varchar2,
400 
401 out_rounding_factor out nocopy varchar2,
402 
403 out_terms_id out nocopy number,
404 
405 out_gsa_indicator out nocopy varchar2,
406 
407 out_currency out nocopy varchar2,
408 
409 out_freight_terms_code out nocopy varchar2);
410 
411 
412 
413 PROCEDURE  get_item_information(
414             in_inventory_item_id in number
415            ,in_org_id in number
416 ,out_item_status out nocopy varchar2
417 
418 ,out_wsh out nocopy varchar2
419 
420 ,out_wsh_name out nocopy varchar2
421 
422 ,out_category out nocopy varchar2
423 
424 ,out_lead_time out nocopy number
425 
426 ,out_cost out nocopy number
427 
428 ,out_primary_uom out nocopy varchar2
429 
430 ,out_user_item_type out nocopy varchar2
431 
432 ,out_make_or_buy out nocopy varchar2
433 
434 ,out_weight_uom out nocopy varchar2
435 
436 ,out_unit_weight out nocopy number
437 
438 ,out_volume_uom out nocopy varchar2
439 
440 ,out_unit_volume out nocopy number
441 
442 ,out_min_order_quantity out nocopy number
443 
444 ,out_max_order_quantity out nocopy number
445 
446 ,out_fixed_order_quantity out nocopy number
447 
448 ,out_customer_order_flag out nocopy varchar2
449 
450 ,out_internal_order_flag out nocopy varchar2
451 
452 ,out_stockable out nocopy varchar2
453 
454 ,out_reservable out nocopy varchar2
455 
456 ,out_returnable out nocopy varchar2
457 
458 ,out_shippable out nocopy varchar2
459 
460 ,out_orderable_on_web out nocopy varchar2
461 
462 ,out_taxable out nocopy varchar2
463 
464 ,out_serviceable out nocopy varchar2
465 
466 ,out_atp_flag out nocopy varchar2
467 
468           );
469 
470 PROCEDURE print_time(in_place in varchar2);
471 
472 PROCEDURE print_time2;
473 
474 
475 PROCEDURE Get_list_line_details( in_list_line_id in number
476 ,out_end_date out nocopy date
477 
478 ,out_start_date out nocopy date
479 
480 ,out_list_line_type_Code out nocopy varchar2
481 
482 ,out_modifier_level_code out nocopy varchar2
483 
484                            );
485 
486 PROCEDURE get_global_availability(
487                        in_customer_id in number
488                       ,in_customer_site_id in number
489                       ,in_inventory_item_id in number
490                       ,in_org_id            in number
491 ,x_return_status out nocopy varchar2
492 
493 ,x_msg_data out nocopy varchar2
494 
495 ,x_msg_count out nocopy number
496 
497 ,l_source_orgs_table out nocopy source_orgs_table
498 
499                                  );
500 
501 
502 PROCEDURE different_uom(
503                         in_org_id in number
504                        ,in_ordered_uom in varchar2
505                        ,in_pricing_uom in varchar2
506 ,out_conversion_rate out nocopy number
507 
508                        );
509 
510 FUNCTION get_conversion_rate(in_uom_code in varchar2,
511                               in_base_uom in varchar2
512                              ) RETURN number;
513 
514 
515 PROCEDURE Call_mrp_and_inventory(
516                         in_org_id in number
517 ,out_on_hand_qty out nocopy number
518 
519 ,out_reservable_qty out nocopy number
520 
521 ,out_available_qty out nocopy varchar2
522 
523 ,out_available_date out nocopy date
524 
525 ,out_error_message out nocopy varchar2
526 
527 ,out_qty_uom out nocopy varchar2
528 
529                                 );
530 
531 PROCEDURE set_mrp_debug(out_mrp_file out nocopy varchar2);
532 
533 
534 
535 PROCEDURE copy_fields_to_globals(
536                 in_inventory_item_id      in number,
537                 in_qty                    in number,
538                 in_uom                    in varchar2,
539                 in_request_date           in date,
540                 in_customer_id            in number,
541                 in_item_identifier_type   in varchar2,
542                 in_agreement_id           in number,
543                 in_price_list_id          in number,
544                 in_ship_to_org_id         in number,
548                 in_order_type_id          in number,
545                 in_invoice_to_org_id      in number,
546                 in_ship_from_org_id       in number,
547                 in_pricing_date           in date,
549                 in_currency               in varchar2,
550                 in_pricing_context        in varchar2,
551                 in_pricing_attribute1     in varchar2,
552                 in_pricing_attribute2     in varchar2,
553                 in_pricing_attribute3     in varchar2,
554                 in_pricing_attribute4     in varchar2,
555                 in_pricing_attribute5     in varchar2,
556                 in_pricing_attribute6     in varchar2,
557                 in_pricing_attribute7     in varchar2,
558                 in_pricing_attribute8     in varchar2,
559                 in_pricing_attribute9     in varchar2,
560                 in_pricing_attribute10    in varchar2,
561                 in_pricing_attribute11    in varchar2,
562                 in_pricing_attribute12    in varchar2,
563                 in_pricing_attribute13    in varchar2,
564                 in_pricing_attribute14    in varchar2,
565                 in_pricing_attribute15    in varchar2,
566                 in_pricing_attribute16    in varchar2,
567                 in_pricing_attribute17    in varchar2,
568                 in_pricing_attribute18    in varchar2,
569                 in_pricing_attribute19    in varchar2,
570                 in_pricing_attribute20    in varchar2,
571                 in_pricing_attribute21    in varchar2,
572                 in_pricing_attribute22    in varchar2,
573                 in_pricing_attribute23    in varchar2,
574                 in_pricing_attribute24    in varchar2,
575                 in_pricing_attribute25    in varchar2,
576                 in_pricing_attribute26    in varchar2,
577                 in_pricing_attribute27    in varchar2,
578                 in_pricing_attribute28    in varchar2,
579                 in_pricing_attribute29    in varchar2,
580                 in_pricing_attribute30    in varchar2,
581                 in_pricing_attribute31    in varchar2,
582                 in_pricing_attribute32    in varchar2,
583                 in_pricing_attribute33    in varchar2,
584                 in_pricing_attribute34    in varchar2,
585                 in_pricing_attribute35    in varchar2,
586                 in_pricing_attribute36    in varchar2,
587                 in_pricing_attribute37    in varchar2,
588                 in_pricing_attribute38    in varchar2,
589                 in_pricing_attribute39    in varchar2,
590                 in_pricing_attribute40    in varchar2,
591                 in_pricing_attribute41    in varchar2,
592                 in_pricing_attribute42    in varchar2,
593                 in_pricing_attribute43    in varchar2,
594                 in_pricing_attribute44    in varchar2,
595                 in_pricing_attribute45    in varchar2,
596                 in_pricing_attribute46    in varchar2,
597                 in_pricing_attribute47    in varchar2,
598                 in_pricing_attribute48    in varchar2,
599                 in_pricing_attribute49    in varchar2,
600                 in_pricing_attribute50    in varchar2,
601                 in_pricing_attribute51    in varchar2,
602                 in_pricing_attribute52    in varchar2,
603                 in_pricing_attribute53    in varchar2,
604                 in_pricing_attribute54    in varchar2,
605                 in_pricing_attribute55    in varchar2,
606                 in_pricing_attribute56    in varchar2,
607                 in_pricing_attribute57    in varchar2,
608                 in_pricing_attribute58    in varchar2,
609                 in_pricing_attribute59    in varchar2,
610                 in_pricing_attribute60    in varchar2,
611                 in_pricing_attribute61    in varchar2,
612                 in_pricing_attribute62    in varchar2,
613                 in_pricing_attribute63    in varchar2,
614                 in_pricing_attribute64    in varchar2,
615                 in_pricing_attribute65    in varchar2,
616                 in_pricing_attribute66    in varchar2,
617                 in_pricing_attribute67    in varchar2,
618                 in_pricing_attribute68    in varchar2,
619                 in_pricing_attribute69    in varchar2,
620                 in_pricing_attribute70    in varchar2,
621                 in_pricing_attribute71    in varchar2,
622                 in_pricing_attribute72    in varchar2,
623                 in_pricing_attribute73    in varchar2,
624                 in_pricing_attribute74    in varchar2,
625                 in_pricing_attribute75    in varchar2,
626                 in_pricing_attribute76    in varchar2,
627                 in_pricing_attribute77    in varchar2,
628                 in_pricing_attribute78    in varchar2,
629                 in_pricing_attribute79    in varchar2,
630                 in_pricing_attribute80    in varchar2,
631                 in_pricing_attribute81    in varchar2,
632                 in_pricing_attribute82    in varchar2,
633                 in_pricing_attribute83    in varchar2,
634                 in_pricing_attribute84    in varchar2,
635                 in_pricing_attribute85    in varchar2,
636                 in_pricing_attribute86    in varchar2,
637                 in_pricing_attribute87    in varchar2,
638                 in_pricing_attribute88    in varchar2,
639                 in_pricing_attribute89    in varchar2,
640                 in_pricing_attribute90    in varchar2,
644                 in_pricing_attribute94    in varchar2,
641                 in_pricing_attribute91    in varchar2,
642                 in_pricing_attribute92    in varchar2,
643                 in_pricing_attribute93    in varchar2,
645                 in_pricing_attribute95    in varchar2,
646                 in_pricing_attribute96    in varchar2,
647                 in_pricing_attribute97    in varchar2,
648                 in_pricing_attribute98    in varchar2,
649                 in_pricing_attribute99    in varchar2,
650                 in_pricing_attribute100   in varchar2
651                 );
652 
653 END oe_oe_availability;