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_VALUE_TO_ID

Source


1 PACKAGE OE_Value_To_Id AUTHID CURRENT_USER AS
2 /* $Header: OEXSVIDS.pls 120.4.12020000.2 2013/01/07 07:42:04 sujithku ship $ */
3 
4 --  Procedure Get_Attr_Tbl;
5 --
6 --  Used by generator to avoid overriding or duplicating existing
7 --  conversion functions.
8 --
9 --  DO NOT MODIFY
10 
11 PROCEDURE Get_Attr_Tbl;
12 
13 --  Prototypes for Value_To_Id functions.
14 
15 --  START GEN value_to_id
16 
17 --  Generator will append new prototypes before end generate comment.
18 FUNCTION Key_Flex
19 (   p_key_flex_code                 IN  VARCHAR2
20 ,   p_structure_number              IN  NUMBER
21 ,   p_appl_short_name               IN  VARCHAR2
22 ,   p_segment_array                 IN  FND_FLEX_EXT.SegmentArray
23 ) RETURN NUMBER;
24 
25 --  Accounting_Rule
26 
27 FUNCTION Accounting_Rule
28 (   p_accounting_rule               IN  VARCHAR2
29 ) RETURN NUMBER;
30 
31 --  Agreement
32 
33 FUNCTION Agreement
34 (   p_agreement                     IN  VARCHAR2
35 ) RETURN NUMBER;
36 
37 --  Conversion_Type
38 
39 FUNCTION Conversion_Type
40 (   p_conversion_type               IN  VARCHAR2
41 ) RETURN VARCHAR2;
42 
43 --  Deliver_To_Contact
44 
45 FUNCTION Deliver_To_Contact
46 (   p_deliver_to_contact            IN  VARCHAR2
47 ,   p_deliver_to_org_id             IN  NUMBER
48 ) RETURN NUMBER;
49 
50 --  Deliver_To_Org
51 
52 FUNCTION Deliver_To_Org
53 (   p_deliver_to_address1           IN  VARCHAR2
54 ,   p_deliver_to_address2           IN  VARCHAR2
55 ,   p_deliver_to_address3           IN  VARCHAR2
56 ,   p_deliver_to_address4           IN  VARCHAR2
57 ,   p_deliver_to_location           IN  VARCHAR2
58 ,   p_deliver_to_org                IN  VARCHAR2
59 ,   p_sold_to_org_id                IN  NUMBER
60 ,   p_deliver_to_city               IN VARCHAR2 DEFAULT NULL
61 ,   p_deliver_to_state              IN VARCHAR2 DEFAULT NULL
62 ,   p_deliver_to_postal_code        IN VARCHAR2 DEFAULT NULL
63 ,   p_deliver_to_country            IN VARCHAR2 DEFAULT NULL
64 ,   p_deliver_to_customer_id        IN number   default null
65 ) RETURN NUMBER;
66 
67 --  Fob_Point
68 
69 FUNCTION Fob_Point
70 (   p_fob_point                     IN  VARCHAR2
71 ) RETURN VARCHAR2;
72 
73 --  Freight_Terms
74 
75 FUNCTION Freight_Terms
76 (   p_freight_terms                 IN  VARCHAR2
77 ) RETURN VARCHAR2;
78 
79 --  Invoice_To_Contact
80 
81 FUNCTION Invoice_To_Contact
82 (   p_invoice_to_contact            IN  VARCHAR2
83 ,   p_invoice_to_org_id             IN  NUMBER
84 ) RETURN NUMBER;
85 
86 --  Invoice_To_Org
87 
88 FUNCTION Invoice_To_Org
89 (   p_invoice_to_address1           IN  VARCHAR2
90 ,   p_invoice_to_address2           IN  VARCHAR2
91 ,   p_invoice_to_address3           IN  VARCHAR2
92 ,   p_invoice_to_address4           IN  VARCHAR2
93 ,   p_invoice_to_location           IN  VARCHAR2
94 ,   p_invoice_to_org                IN  VARCHAR2
95 ,   p_sold_to_org_id                IN  NUMBER
96 ,   p_invoice_to_city               IN VARCHAR2 DEFAULT NULL
97 ,   p_invoice_to_state              IN VARCHAR2 DEFAULT NULL
98 ,   p_invoice_to_postal_code        IN VARCHAR2 DEFAULT NULL
99 ,   p_invoice_to_country            IN VARCHAR2 DEFAULT NULL
100 ,   p_invoice_to_customer_id        IN number   default null
101 ) RETURN NUMBER;
102 
103 --  Invoicing_Rule
104 
105 FUNCTION Invoicing_Rule
106 (   p_invoicing_rule                IN  VARCHAR2
107 ) RETURN NUMBER;
108 
109 --  Order_Source
110 
111 FUNCTION Order_Source
112 (   p_order_source                  IN  VARCHAR2
113 ) RETURN NUMBER;
114 
115 --  Order_Type
116 
117 FUNCTION Order_Type
118 (   p_order_type                    IN  VARCHAR2
119 ) RETURN NUMBER;
120 
121 --  Payment_Term
122 
123 FUNCTION Payment_Term
124 (   p_payment_term                  IN  VARCHAR2
125 ) RETURN NUMBER;
126 
127 --  Price_List
128 
129 FUNCTION Price_List
130 (   p_price_list                    IN  VARCHAR2
131 ) RETURN NUMBER;
132 
133 --  Shipment_Priority
134 
135 FUNCTION Shipment_Priority
136 (   p_shipment_priority             IN  VARCHAR2
137 ) RETURN VARCHAR2;
138 
139 --  Ship_From_Org
140 
141 FUNCTION Ship_From_Org
142 (   p_ship_from_address1            IN  VARCHAR2
143 ,   p_ship_from_address2            IN  VARCHAR2
144 ,   p_ship_from_address3            IN  VARCHAR2
145 ,   p_ship_from_address4            IN  VARCHAR2
146 ,   p_ship_from_location            IN  VARCHAR2
147 ,   p_ship_from_org                 IN  VARCHAR2
148 ) RETURN NUMBER;
149 
150 --  Ship_To_Contact
151 
152 FUNCTION Ship_To_Contact
153 (   p_ship_to_contact               IN  VARCHAR2
154 ,   p_ship_to_org_id                IN  NUMBER
155 ) RETURN NUMBER;
156 
157 FUNCTION Inventory_Org
158 (   p_inventory_org               IN  VARCHAR2
159 ) RETURN NUMBER;
160 
161 --  Ship_To_Org
162 
163 FUNCTION Ship_To_Org
164 (   p_ship_to_address1              IN  VARCHAR2
165 ,   p_ship_to_address2              IN  VARCHAR2
166 ,   p_ship_to_address3              IN  VARCHAR2
167 ,   p_ship_to_address4              IN  VARCHAR2
168 ,   p_ship_to_location              IN  VARCHAR2
169 ,   p_ship_to_org                   IN  VARCHAR2
170 ,   p_sold_to_org_id                IN  NUMBER
171 ,   p_ship_to_city                  IN VARCHAR2 DEFAULT NULL
172 ,   p_ship_to_state                 IN VARCHAR2 DEFAULT NULL
173 ,   p_ship_to_postal_code           IN VARCHAR2 DEFAULT NULL
174 ,   p_ship_to_country               IN VARCHAR2 DEFAULT NULL
175 ,   p_ship_to_customer_id        IN number   default null
176 ) RETURN NUMBER;
177 
178 
179 --  Intermediate_Ship_To_Contact
180 
181 FUNCTION Intermed_Ship_To_Contact
182 (   p_intermed_ship_to_contact               IN  VARCHAR2
183 ,   p_intermed_ship_to_org_id                IN  NUMBER
184 ) RETURN NUMBER;
185 
186 --  Intermediate_Ship_To_Org
187 
188 FUNCTION Intermed_Ship_To_Org
189 (   p_intermed_ship_to_address1              IN  VARCHAR2
190 ,   p_intermed_ship_to_address2              IN  VARCHAR2
191 ,   p_intermed_ship_to_address3              IN  VARCHAR2
192 ,   p_intermed_ship_to_address4              IN  VARCHAR2
193 ,   p_intermed_ship_to_location              IN  VARCHAR2
194 ,   p_intermed_ship_to_org                   IN  VARCHAR2
195 ,   p_sold_to_org_id                         IN  NUMBER
196 ,   p_intermed_ship_to_city                  IN VARCHAR2 DEFAULT NULL
197 ,   p_intermed_ship_to_state                 IN VARCHAR2 DEFAULT NULL
198 ,   p_intermed_ship_to_postal_code           IN VARCHAR2 DEFAULT NULL
199 ,   p_intermed_ship_to_country               IN VARCHAR2 DEFAULT NULL
200 ) RETURN NUMBER;
201 
202 --  Sold_To_Contact
203 
204 FUNCTION Sold_To_Contact
205 (   p_sold_to_contact               IN  VARCHAR2
206 ,   p_sold_to_org_id                IN  NUMBER
207 ) RETURN NUMBER;
208 
209 --  Sold_To_Org
210 
211 FUNCTION Sold_To_Org
212 (   p_sold_to_org                   IN  VARCHAR2
213 ,   p_customer_number               IN  VARCHAR2
214 ) RETURN NUMBER;
215 
216 
217 FUNCTION site_customer
218 (   p_site_customer                   IN  VARCHAR2
219 ,   p_site_customer_number               IN  VARCHAR2
220 ,   p_type                            in varchar2
221 ) RETURN NUMBER;
222 
223 --  Tax_Exempt
224 
225 FUNCTION Tax_Exempt
226 (   p_tax_exempt                    IN  VARCHAR2
227 ) RETURN VARCHAR2;
228 
229 --  Tax_Exempt_Reason
230 
231 FUNCTION Tax_Exempt_Reason
232 (   p_tax_exempt_reason             IN  VARCHAR2
233 ) RETURN VARCHAR2;
234 
235 --  Tax_Point
236 
237 FUNCTION Tax_Point
238 (   p_tax_point                     IN  VARCHAR2
239 ) RETURN VARCHAR2;
240 
241 --  Discount
242 
243 FUNCTION Discount
244 (   p_discount                      IN  VARCHAR2
245 ) RETURN NUMBER;
246 
247 --  Salesrep
248 
249 FUNCTION Salesrep
250 (   p_salesrep                      IN  VARCHAR2
251 ) RETURN NUMBER;
252 
253 FUNCTION sales_credit_type
254 (   p_sales_credit_type            IN  VARCHAR2
255 ) RETURN NUMBER;
256 
257 --  Demand_Bucket_Type
258 
259 FUNCTION Demand_Bucket_Type
260 (   p_demand_bucket_type            IN  VARCHAR2
261 ) RETURN VARCHAR2;
262 
263 --  Inventory_Item
264 
265 FUNCTION Inventory_Item
266 (   p_inventory_item                IN  VARCHAR2
267 ) RETURN NUMBER;
268 
269 --  Item_Type
270 
271 FUNCTION Item_Type
272 (   p_item_type                     IN  VARCHAR2
273 ) RETURN VARCHAR2;
274 
275 --  Line_Type
276 
277 FUNCTION Line_Type
278 (   p_line_type                     IN  VARCHAR2
279 ) RETURN NUMBER;
280 
281 --  Project
282 
283 FUNCTION Project
284 (   p_project                       IN  VARCHAR2
285 ) RETURN NUMBER;
286 
287 --  Rla_Schedule_Type
288 
289 FUNCTION Rla_Schedule_Type
290 (   p_rla_schedule_type             IN  VARCHAR2
291 ) RETURN VARCHAR2;
292 
293 --  Task
294 
295 FUNCTION Task
296 (   p_task                          IN  VARCHAR2
297 ) RETURN NUMBER;
298 
299 --  Over_Ship_Reason
300 
301 FUNCTION Over_Ship_Reason
302 (   p_over_ship_reason              IN  VARCHAR2
303 ) RETURN VARCHAR2;
304 
305 --  Return_Reason
306 
307 FUNCTION Return_Reason
308 (   p_return_reason                 IN  VARCHAR2
309 ) RETURN VARCHAR2;
310 
311 --  Veh_Cus_Item_cum_key
312 
313 FUNCTION Veh_Cus_Item_cum_Key
314 (   p_veh_cus_item_cum_key          IN  VARCHAR2
315 ) RETURN NUMBER;
316 
317 --  Payment_Type
318 
319 FUNCTION Payment_Type
320 (   p_payment_type                  IN  VARCHAR2
321 ) RETURN VARCHAR2;
322 
323 --  Credit_Card
324 
325 FUNCTION Credit_Card
326 (   p_credit_card                   IN  VARCHAR2
327 ) RETURN VARCHAR2;
328 
329 -- Commitment
330 
331 FUNCTION Commitment
332 (   p_commitment                   IN  VARCHAR2
333 ) RETURN NUMBER;
334 
335 
336 
337 /* Pricing Contract Functions: Begin */
338 
339 --  Currency
340 
341 FUNCTION Currency
342 (   p_currency                      IN  VARCHAR2
343 ) RETURN VARCHAR2;
344 
345 --  Agreement_Contact
346 
347 FUNCTION Agreement_Contact
348 (   p_Agreement_Contact                      IN  VARCHAR2
349 ) RETURN VARCHAR2;
350 
351 --  Agreement_Type
352 
353 FUNCTION Agreement_Type
354 (   p_Agreement_Type                      IN  VARCHAR2
355 ) RETURN VARCHAR2;
356 
357 --  Customer
358 
359 FUNCTION Customer
360 (   p_Customer                      IN  VARCHAR2
361 ) RETURN VARCHAR2;
362 
363 --  Invoice_Contact
364 
365 FUNCTION Invoice_Contact
366 (   p_Invoice_Contact                      IN  VARCHAR2
367 ) RETURN VARCHAR2;
368 
369 --  Invoice_To_Site_Use
370 
371 FUNCTION Invoice_To_Site_Use
372 (   p_Invoice_To_Site_Use                      IN  VARCHAR2
373 ) RETURN VARCHAR2;
374 
375 --  override_arule
376 
377 FUNCTION override_arule
381 --  override_irule
378 (   p_override_arule                      IN  VARCHAR2
379 ) RETURN VARCHAR2;
380 
382 
383 FUNCTION override_irule
384 (   p_override_irule                      IN  VARCHAR2
385 ) RETURN VARCHAR2;
386 
387 --  Revision_Reason
388 
389 FUNCTION Revision_Reason
390 (   p_Revision_Reason                      IN  VARCHAR2
391 ) RETURN VARCHAR2;
392 
393 --  Ship_Method
394 
395 FUNCTION Ship_Method
396 (   p_Ship_Method                      IN  VARCHAR2
397 ) RETURN VARCHAR2;
398 
399 --  Term
400 
401 FUNCTION Term
402 (   p_Term                      IN  VARCHAR2
403 ) RETURN VARCHAR2;
404 
405 --  Secondary_Price_List
406 
407 FUNCTION Secondary_Price_List
408 (   p_secondary_price_list          IN  VARCHAR2
409 ) RETURN NUMBER;
410 
411 --  Terms
412 
413 FUNCTION Terms
414 (   p_terms                         IN  VARCHAR2
415 ) RETURN NUMBER;
416 
417 --  Automatic_Discount
418 
419 FUNCTION Automatic_Discount
420 (   p_automatic_discount            IN  VARCHAR2
421 ) RETURN VARCHAR2;
422 
423 --  Discount_Lines
424 
425 FUNCTION Discount_Lines
426 (   p_discount_lines                IN  VARCHAR2
427 ) RETURN VARCHAR2;
428 
429 --  Discount_Type
430 
431 FUNCTION Discount_Type
432 (   p_discount_type                 IN  VARCHAR2
433 ) RETURN VARCHAR2;
434 
435 --  Manual_Discount
436 
437 FUNCTION Manual_Discount
438 (   p_manual_discount               IN  VARCHAR2
439 ) RETURN VARCHAR2;
440 
441 --  Override_Allowed
442 
443 FUNCTION Override_Allowed
444 (   p_override_allowed              IN  VARCHAR2
445 ) RETURN VARCHAR2;
446 
447 --  Prorate
448 
449 FUNCTION Prorate
450 (   p_prorate                       IN  VARCHAR2
451 ) RETURN VARCHAR2;
452 
453 --  Method
454 
455 FUNCTION Method
456 (   p_method                        IN  VARCHAR2
457 ) RETURN VARCHAR2;
458 
459 --  Price_List_Line
460 
461 FUNCTION Price_List_Line
462 (   p_price_list_line               IN  VARCHAR2
463 ) RETURN NUMBER;
464 
465 --  Pricing_Rule
466 
467 FUNCTION Pricing_Rule
468 (   p_pricing_rule                  IN  VARCHAR2
469 ) RETURN NUMBER;
470 
471 --  Reprice
472 
473 FUNCTION Reprice
474 (   p_reprice                       IN  VARCHAR2
475 ) RETURN VARCHAR2;
476 
477 --  Unit
478 
479 FUNCTION Unit
480 (   p_unit                          IN  VARCHAR2
481 ) RETURN VARCHAR2;
482 
483 --  Customer_Class
484 
485 FUNCTION Customer_Class
486 (   p_customer_class                IN  VARCHAR2
487 ) RETURN VARCHAR2;
488 
489 --  Discount_Customer
490 
491 FUNCTION Discount_Customer
492 (   p_discount_customer             IN  VARCHAR2
493 ) RETURN NUMBER;
494 
495 --  Site_Use
496 
497 FUNCTION Site_Use
498 (   p_site_use                      IN  VARCHAR2
499 ) RETURN NUMBER;
500 
501 --  Entity
502 
503 FUNCTION Entity
504 (   p_entity                        IN  VARCHAR2
505 ) RETURN NUMBER;
506 
507 --  Method_Type
508 
509 FUNCTION Method_Type
510 (   p_method_type                   IN  VARCHAR2
511 ) RETURN VARCHAR2;
512 
513 /* Pricing Contract Functions: End */
514 
515 --  Lot_Serial
516 
517 FUNCTION Lot_Serial
518 (   p_lot_serial                    IN  VARCHAR2
519 ) RETURN NUMBER;
520 
521 --  Appear_On_Ack
522 
523 FUNCTION Appear_On_Ack
524 (   p_appear_on_ack                 IN  VARCHAR2
525 ) RETURN VARCHAR2;
526 
527 --  Appear_On_Invoice
528 
529 FUNCTION Appear_On_Invoice
530 (   p_appear_on_invoice             IN  VARCHAR2
531 ) RETURN VARCHAR2;
532 
533 --  Charge
534 
535 FUNCTION Charge
536 (   p_charge                        IN  VARCHAR2
537 ) RETURN NUMBER;
538 
539 --  Charge_Type
540 
541 FUNCTION Charge_Type
542 (   p_charge_type                   IN  VARCHAR2
543 ) RETURN NUMBER;
544 
545 --  Cost_Or_Charge
546 
547 FUNCTION Cost_Or_Charge
548 (   p_cost_or_charge                IN  VARCHAR2
549 ) RETURN VARCHAR2;
550 
551 --  Departure
552 
553 FUNCTION Departure
554 (   p_departure                     IN  VARCHAR2
555 ) RETURN NUMBER;
556 
557 --  Estimated
558 
559 FUNCTION Estimated
560 (   p_estimated                     IN  VARCHAR2
561 ) RETURN VARCHAR2;
562 
563 --  Invoiced
564 
565 FUNCTION Invoiced
566 (   p_invoiced                      IN  VARCHAR2
567 ) RETURN VARCHAR2;
568 
569 --  Parent_Charge
570 
571 FUNCTION Parent_Charge
572 (   p_parent_charge                 IN  VARCHAR2
573 ) RETURN NUMBER;
574 
575 --  Returnable
576 
577 FUNCTION Returnable
578 (   p_returnable                    IN  VARCHAR2
579 ) RETURN VARCHAR2;
580 
581 --  Tax_Group
582 /* eBTax changes
583 FUNCTION Tax_Group
584 (   p_tax_group                     IN  VARCHAR2
585 ) RETURN VARCHAR2;
586 */
587 
588 FUNCTION Flow_Status
589 (  p_flow_status	IN	VARCHAR2
590 ) RETURN VARCHAR2;
591 
592 FUNCTION Freight_Carrier
593 (  p_freight_carrier	IN	VARCHAR2
594 ,  p_ship_from_org_id    IN	NUMBER
595 ) RETURN VARCHAR2;
596 
597 FUNCTION Sales_Channel
598 (  p_sales_channel	IN	VARCHAR2
599 ) RETURN VARCHAR2;
600 
601 
602 FUNCTION Customer_Location
603 (   p_sold_to_location_address1              IN  VARCHAR2
604 ,   p_sold_to_location_address2              IN  VARCHAR2
605 ,   p_sold_to_location_address3              IN  VARCHAR2
606 ,   p_sold_to_location_address4              IN  VARCHAR2
607 ,   p_sold_to_location                       IN  VARCHAR2
608 ,   p_sold_to_org_id                         IN  NUMBER
609 ,   p_sold_to_location_city                  IN VARCHAR2 DEFAULT NULL
610 ,   p_sold_to_location_state                 IN VARCHAR2 DEFAULT NULL
611 ,   p_sold_to_location_postal_code           IN VARCHAR2 DEFAULT NULL
612 ,   p_sold_to_location_country               IN VARCHAR2 DEFAULT NULL
613 ) RETURN NUMBER;
614 
615 --serla begin
616 FUNCTION Payment_Collection_Event_Name
617 (  p_payment_collection_event      IN      VARCHAR2
618 ) RETURN VARCHAR2;
619 
620 FUNCTION Receipt_Method
621 (  p_receipt_method      IN      VARCHAR2
622 ) RETURN NUMBER;
623 --serla end
624 
625 --distributed orders
626 FUNCTION END_CUSTOMER
627 (  p_end_customer        IN VARCHAR2
628 ,  p_end_customer_number IN VARCHAR2
629 ) RETURN NUMBER;
630 
631 FUNCTION END_CUSTOMER_CONTACT
632 (  p_end_customer_contact IN VARCHAR2
633 ,  p_end_customer_id      IN NUMBER
634 ) RETURN NUMBER;
635 
636 FUNCTION END_CUSTOMER_SITE
637 (   p_end_customer_site_address1              IN  VARCHAR2
638 ,   p_end_customer_site_address2              IN  VARCHAR2
639 ,   p_end_customer_site_address3              IN  VARCHAR2
640 ,   p_end_customer_site_address4              IN  VARCHAR2
641 ,   p_end_customer_site_location              IN  VARCHAR2
642 ,   p_end_customer_site_org                   IN  VARCHAR2
643 ,   p_end_customer_id                         IN  NUMBER
644 ,   p_end_customer_site_city                  IN  VARCHAR2 DEFAULT NULL
645 ,   p_end_customer_site_state                 IN  VARCHAR2 DEFAULT NULL
646 ,   p_end_customer_site_postalcode            IN  VARCHAR2 DEFAULT NULL
647 ,   p_end_customer_site_country               IN  VARCHAR2 DEFAULT NULL
648 ,   p_end_customer_site_use_code              IN  VARCHAR2 DEFAULT NULL
649 ) RETURN NUMBER;
650 
651 FUNCTION IB_Owner
652 (   p_ib_owner                      IN  VARCHAR2
653 ) RETURN VARCHAR2;
654 
655 FUNCTION IB_Installed_At_Location
656 (   p_ib_installed_at_location  IN  VARCHAR2
657 ) RETURN VARCHAR2;
658 
659 FUNCTION IB_Current_Location
660 (   p_ib_current_location  IN  VARCHAR2
661 ) RETURN VARCHAR2;
662 
663 -- Added for bug 8478559
664 FUNCTION Payment_Percentage
665 (  p_payment_percentage IN NUMBER
666 ) RETURN NUMBER;
667 -- End of bug 8478559
668 
669 
670 FUNCTION OPERATING_UNIT
671 (  p_operating_unit    IN  VARCHAR2
672 ) RETURN NUMBER;
673 
674 --sol_ord_er #16014165
675 
676 FUNCTION Billing_Profile
677 ( p_service_bill_profile IN VARCHAR2
678 ) RETURN NUMBER;
679 
680 FUNCTION Billing_Option
681 ( p_service_bill_option IN VARCHAR2
682 ) RETURN VARCHAR2;
683 
684 FUNCTION Subscription_Template
685 ( p_service_subs_template IN VARCHAR2
686 ) RETURN NUMBER;
687 
688 FUNCTION Coverage_Template
689 ( p_service_cov_template IN VARCHAR2
690 ) RETURN NUMBER;
691 
692 --sol_ord_er #16014165 end
693 
694 --  END GEN value_to_id
695 
696 END OE_Value_To_Id;