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_CNCL_VALUE_TO_ID

Source


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