[Home] [Help]
PACKAGE: APPS.OE_VALUE_TO_ID
Source
1 PACKAGE OE_Value_To_Id AS
2 /* $Header: OEXSVIDS.pls 120.3 2005/09/25 10:52:14 redupuga 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
378 ( p_override_arule IN VARCHAR2
379 ) RETURN VARCHAR2;
380
381 -- override_irule
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
477 -- Unit
474 ( p_reprice IN VARCHAR2
475 ) RETURN VARCHAR2;
476
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
664 FUNCTION OPERATING_UNIT
665 ( p_operating_unit IN VARCHAR2
666 ) RETURN NUMBER;
667
668 -- END GEN value_to_id
669
670 END OE_Value_To_Id;