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_ID_TO_VALUE

Source


1 PACKAGE OE_Id_To_Value AUTHID CURRENT_USER AS
2 /* $Header: OEXSIDVS.pls 120.3.12020000.2 2013/01/07 06:35:33 sujithku ship $ */
3 
4 --  Procedure Get_Attr_Tbl;
5 --
6 --  Used by generator to avoid overriding or duplicating existing
7 --  Id_To_Value functions.
8 --
9 --  DO NOT MODIFY
10 
11 PROCEDURE Get_Attr_Tbl;
12 
13 --  Prototypes for Id_To_Value functions.
14 
15 --  START GEN Id_To_Value
16 
17 --  Generator will append new prototypes before end generate comment.
18 
19 /* Process Order Functions: Begin */
20 
21 FUNCTION Conversion_Type
22 (   p_conversion_type_code          IN  VARCHAR2
23 ) RETURN VARCHAR2;
24 
25 FUNCTION Deliver_To_Contact
26 (   p_deliver_to_contact_id         IN  NUMBER
27 ) RETURN VARCHAR2;
28 
29 FUNCTION Inventory_Org
30 (   p_inventory_org_id         IN  NUMBER
31 ) RETURN VARCHAR2;
32 
33 PROCEDURE Deliver_To_Org
34 (   p_deliver_to_org_id             IN  NUMBER
35 ,   x_deliver_to_address1           OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36 ,   x_deliver_to_address2           OUT NOCOPY /* file.sql.39 change */ VARCHAR2
37 ,   x_deliver_to_address3           OUT NOCOPY /* file.sql.39 change */ VARCHAR2
38 ,   x_deliver_to_address4           OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39 ,   x_deliver_to_location           OUT NOCOPY /* file.sql.39 change */ VARCHAR2
40 ,   x_deliver_to_org                OUT NOCOPY /* file.sql.39 change */ VARCHAR2
41 ,   x_deliver_to_city               OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42 ,   x_deliver_to_state              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
43 ,   x_deliver_to_postal_code        OUT NOCOPY /* file.sql.39 change */ VARCHAR2
44 ,   x_deliver_to_country            OUT NOCOPY /* file.sql.39 change */ VARCHAR2
45 );
46 
47 FUNCTION Fob_Point
48 (   p_fob_point_code                IN  VARCHAR2
49 ) RETURN VARCHAR2;
50 
51 FUNCTION Invoice_To_Contact
52 (   p_invoice_to_contact_id         IN  NUMBER
53 ) RETURN VARCHAR2;
54 
55 PROCEDURE Invoice_To_Org
56 (   p_invoice_to_org_id             IN  NUMBER
57 ,   x_invoice_to_address1           OUT NOCOPY /* file.sql.39 change */ VARCHAR2
58 ,   x_invoice_to_address2           OUT NOCOPY /* file.sql.39 change */ VARCHAR2
59 ,   x_invoice_to_address3           OUT NOCOPY /* file.sql.39 change */ VARCHAR2
60 ,   x_invoice_to_address4           OUT NOCOPY /* file.sql.39 change */ VARCHAR2
61 ,   x_invoice_to_location           OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62 ,   x_invoice_to_org                OUT NOCOPY /* file.sql.39 change */ VARCHAR2
63 ,   x_invoice_to_city               OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64 ,   x_invoice_to_state              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
65 ,   x_invoice_to_postal_code        OUT NOCOPY /* file.sql.39 change */ VARCHAR2
66 ,   x_invoice_to_country            OUT NOCOPY /* file.sql.39 change */ VARCHAR2
67 );
68 
69 FUNCTION Order_Source
70 (   p_order_source_id               IN  NUMBER
71 ) RETURN VARCHAR2;
72 
73 FUNCTION Order_Type
74 (   p_order_type_id                 IN  NUMBER
75 ) RETURN VARCHAR2;
76 
77 FUNCTION Payment_Term
78 (   p_payment_term_id               IN  NUMBER
79 ) RETURN VARCHAR2;
80 
81 FUNCTION Shipment_Priority
82 (   p_shipment_priority_code        IN  VARCHAR2
83 ) RETURN VARCHAR2;
84 
85 FUNCTION Demand_Class
86 (   p_demand_class_code        IN  VARCHAR2
87 ) RETURN VARCHAR2;
88 
89 PROCEDURE Ship_From_Org
90 (   p_ship_from_org_id              IN  NUMBER
91 ,   x_ship_from_address1            OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92 ,   x_ship_from_address2            OUT NOCOPY /* file.sql.39 change */ VARCHAR2
93 ,   x_ship_from_address3            OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94 ,   x_ship_from_address4            OUT NOCOPY /* file.sql.39 change */ VARCHAR2
95 ,   x_ship_from_location            OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96 ,   x_ship_from_org                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97 );
98 
99 FUNCTION Ship_To_Contact
100 (   p_ship_to_contact_id            IN  NUMBER
101 ) RETURN VARCHAR2;
102 
103 PROCEDURE Ship_To_Org
104 (   p_ship_to_org_id                IN  NUMBER
105 ,   x_ship_to_address1              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
106 ,   x_ship_to_address2              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
107 ,   x_ship_to_address3              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108 ,   x_ship_to_address4              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
109 ,   x_ship_to_location              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
110 ,   x_ship_to_org                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
111 ,   x_ship_to_city                  OUT NOCOPY /* file.sql.39 change */ VARCHAR2
112 ,   x_ship_to_state                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113 ,   x_ship_to_postal_code           OUT NOCOPY /* file.sql.39 change */ VARCHAR2
114 ,   x_ship_to_country               OUT NOCOPY /* file.sql.39 change */ VARCHAR2
115 );
116 
117 
118 FUNCTION Intermed_Ship_To_Contact
119 (   p_intermed_ship_to_contact_id    IN  NUMBER
120 ) RETURN VARCHAR2;
121 
122 
123 PROCEDURE Intermed_Ship_To_Org
124 (   p_intermed_ship_to_org_id       IN  NUMBER
125 ,   x_intermed_ship_to_address1     OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126 ,   x_intermed_ship_to_address2     OUT NOCOPY /* file.sql.39 change */ VARCHAR2
127 ,   x_intermed_ship_to_address3     OUT NOCOPY /* file.sql.39 change */ VARCHAR2
128 ,   x_intermed_ship_to_address4     OUT NOCOPY /* file.sql.39 change */ VARCHAR2
129 ,   x_intermed_ship_to_location     OUT NOCOPY /* file.sql.39 change */ VARCHAR2
130 ,   x_intermed_ship_to_org          OUT NOCOPY /* file.sql.39 change */ VARCHAR2
131 ,   x_intermed_ship_to_city         OUT NOCOPY /* file.sql.39 change */ VARCHAR2
132 ,   x_intermed_ship_to_state        OUT NOCOPY /* file.sql.39 change */ VARCHAR2
133 ,   x_intermed_ship_to_postal_code  OUT NOCOPY /* file.sql.39 change */ VARCHAR2
134 ,   x_intermed_ship_to_country      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
135 );
136 
137 
138 FUNCTION Sold_To_Contact
139 (   p_sold_to_contact_id            IN  NUMBER
140 ) RETURN VARCHAR2;
141 
142 PROCEDURE    Sold_To_Org
143 (   p_sold_to_org_id	IN  NUMBER
144 ,   x_org		OUT NOCOPY /* file.sql.39 change */ VARCHAR2
145 ,   x_customer_number	OUT NOCOPY /* file.sql.39 change */ VARCHAR2
146 );
147 
148 --Overloded procedure added for Ac. Desc, Registry ID Project
149 PROCEDURE    Sold_To_Org
150 (   p_sold_to_org_id	IN  NUMBER  	,
151 x_org OUT NOCOPY VARCHAR2 ,
152 x_customer_number OUT NOCOPY VARCHAR2 ,
153 x_account_description OUT NOCOPY VARCHAR2,
154 x_registry_id OUT NOCOPY VARCHAR2
155 );
156 	--added for Ac. Desc, Registry ID Project
157 
158 FUNCTION Tax_Exempt
159 (   p_tax_exempt_flag               IN  VARCHAR2
160 ) RETURN VARCHAR2;
161 
162 FUNCTION Tax_Exempt_Reason
163 (   p_tax_exempt_reason_code        IN  VARCHAR2
164 ) RETURN VARCHAR2;
165 
166 FUNCTION Tax_Point
167 (   p_tax_point_code                IN  VARCHAR2
168 ) RETURN VARCHAR2;
169 
170 FUNCTION Demand_Bucket_Type
171 (   p_demand_bucket_type_code       IN  VARCHAR2
172 ) RETURN VARCHAR2;
173 
174 FUNCTION Item_Type
175 (   p_item_type_code                IN  VARCHAR2
176 ) RETURN VARCHAR2;
177 
178 FUNCTION Line_Type
179 (   p_line_type_id                  IN  NUMBER
180 ) RETURN VARCHAR2;
181 
182 FUNCTION Project
183 (   p_project_id                    IN  NUMBER
184 ) RETURN VARCHAR2;
185 
186 FUNCTION Rla_Schedule_Type
187 (   p_rla_schedule_type_code        IN  VARCHAR2
188 ) RETURN VARCHAR2;
189 
190 FUNCTION Task
191 (   p_task_id                       IN  NUMBER
192 ) RETURN VARCHAR2;
193 
194 FUNCTION Over_Ship_Reason
195 (   p_over_ship_reason_code                  IN VARCHAR2
196 ) RETURN VARCHAR2;
197 
198 FUNCTION Order_Date_Type
199 (   p_order_date_type_code               IN VARCHAR2
200 ) RETURN VARCHAR2;
201 
202 PROCEDURE Reference_Line
203 (   p_reference_Line_id       IN NUMBER
204 ,   x_ref_order_number        OUT NOCOPY /* file.sql.39 change */ NUMBER
205 ,   x_ref_line_number         OUT NOCOPY /* file.sql.39 change */ NUMBER
206 ,   x_ref_shipment_number     OUT NOCOPY /* file.sql.39 change */ NUMBER
207 ,   x_ref_option_number       OUT NOCOPY /* file.sql.39 change */ NUMBER
208 ,   x_ref_component_number    OUT NOCOPY /* file.sql.39 change */ NUMBER
209 );
210 
211 PROCEDURE Reference_Cust_Trx_Line
212 (   p_reference_cust_trx_line_id         IN NUMBER
213 ,   x_ref_invoice_number                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
214 ,   x_ref_invoice_line_number            OUT NOCOPY /* file.sql.39 change */ NUMBER
215 );
216 
217 FUNCTION Credit_Invoice_Line
218 (   p_credit_invoice_line_id             IN NUMBER
219 ) RETURN VARCHAR2;
220 
221 FUNCTION Source_Type
222 (   p_source_type_code                   IN VARCHAR2
223 ) RETURN VARCHAR2;
224 
225 FUNCTION Return_Reason
226 (   p_return_reason_code                  IN VARCHAR2
227 ) RETURN VARCHAR2;
228 
229 FUNCTION Veh_Cus_Item_Cum_Key
230 (   p_veh_cus_item_cum_key_id                  IN  NUMBER
231 ) RETURN VARCHAR2;
232 
233 FUNCTION Payment_Type
234 (   p_payment_type_code            IN  VARCHAR2
235 ) RETURN VARCHAR2;
236 
237 FUNCTION Credit_Card
238 (   p_credit_card_code            IN  VARCHAR2
239 ) RETURN VARCHAR2;
240 
241 FUNCTION Commitment
242 (   p_commitment_id            IN NUMBER
243 ) RETURN VARCHAR2;
244 
245 FUNCTION Delivery
246 (   p_delivery_id                  IN  NUMBER
247 ) RETURN VARCHAR2;
248 
249 /* Process Order Functions: End */
250 
251 /* Pricing Contract Functions: Begin */
252 
253 FUNCTION Agreement
254 (   p_agreement_id                  IN  NUMBER
255 ) RETURN VARCHAR2;
256 
257 FUNCTION Discount
258 (   p_discount_id                   IN  NUMBER
259 ) RETURN VARCHAR2;
260 
261 FUNCTION Price_List
262 (   p_price_list_id                 IN  NUMBER
263 ) RETURN VARCHAR2;
264 
265 FUNCTION New_Modifier_List
266 (   p_new_modifier_list_id                 IN  NUMBER
267 ) RETURN VARCHAR2;
268 
269 FUNCTION Accounting_Rule
270 (   p_accounting_rule_id            IN  NUMBER
271 ) RETURN VARCHAR2;
272 
273 
274 FUNCTION Calculate_Price_Flag
275 (   p_calculate_price_flag            IN  VARCHAR2
276 ) RETURN VARCHAR2;
277 
278 
279 ---**
280 
281 FUNCTION Agreement_Contact
282 (   p_agreement_contact_id          IN  NUMBER
283 ) RETURN VARCHAR2;
284 
285 ---**
286 
287 FUNCTION Agreement_Type
288 (   p_agreement_type_code           IN  VARCHAR2
289 ) RETURN VARCHAR2;
290 
291 ---**
292 
293 FUNCTION Customer
294 (   p_sold_to_org_id                   IN  NUMBER
295 ) RETURN VARCHAR2;
296 
297 FUNCTION Freight_Terms
298 (   p_freight_terms_code            IN  VARCHAR2
299 ) RETURN VARCHAR2;
300 
301 ---**
302 
303 FUNCTION Invoice_Contact
304 (   p_invoice_contact_id            IN  NUMBER
305 ) RETURN VARCHAR2;
306 
307 ---**
308 
309 FUNCTION Invoice_To_Site_Use
310 (   p_invoice_to_org_id        IN  NUMBER
311 ) RETURN VARCHAR2;
312 
313 FUNCTION Invoicing_Rule
314 (   p_invoicing_rule_id             IN  NUMBER
315 ) RETURN VARCHAR2;
316 
317 ---**
318 
319 FUNCTION Override_Arule
320 (   p_override_arule_flag           IN  VARCHAR2
321 ) RETURN VARCHAR2;
322 
323 ---**
324 
325 FUNCTION Override_Irule
326 (   p_override_irule_flag           IN  VARCHAR2
327 ) RETURN VARCHAR2;
328 
329 ---**
330 
331 FUNCTION Revision_Reason
332 (   p_revision_reason_code          IN  VARCHAR2
333 ) RETURN VARCHAR2;
334 
335 FUNCTION Salesrep
336 (   p_salesrep_id                   IN  NUMBER
337 ) RETURN VARCHAR2;
338 
339 FUNCTION sales_credit_type
340 (   p_sales_credit_type_id         IN  NUMBER
341 ) RETURN VARCHAR2;
342 
343 ---**
344 
345 FUNCTION Ship_Method
346 (   p_ship_method_code              IN  VARCHAR2
347 ) RETURN VARCHAR2;
348 
349 ---**
350 
351 FUNCTION Term
352 (   p_term_id                       IN  NUMBER
353 ) RETURN VARCHAR2;
354 
355 ---**
356 
357 FUNCTION Currency
358 (   p_currency_code                 IN  VARCHAR2
359 ) RETURN VARCHAR2;
360 
361 ---**
362 
363 FUNCTION Secondary_Price_List
364 (   p_secondary_price_list_id       IN  NUMBER
365 ) RETURN VARCHAR2;
366 
367 ---**
368 
369 FUNCTION Terms
370 (   p_terms_id                      IN  NUMBER
371 ) RETURN VARCHAR2;
372 
373 ---**
374 
375 FUNCTION Automatic_Discount
376 (   p_automatic_discount_flag       IN  VARCHAR2
377 ) RETURN VARCHAR2;
378 
379 ---**
380 
381 FUNCTION Discount_Lines
382 (   p_discount_lines_flag           IN  VARCHAR2
383 ) RETURN VARCHAR2;
384 
385 ---**
386 
387 FUNCTION Discount_Type
388 (   p_discount_type_code            IN  VARCHAR2
389 ) RETURN VARCHAR2;
390 
391 ---**
392 
393 FUNCTION Manual_Discount
394 (   p_manual_discount_flag          IN  VARCHAR2
395 ) RETURN VARCHAR2;
396 
397 ---**
398 
399 FUNCTION Override_Allowed
400 (   p_override_allowed_flag         IN  VARCHAR2
401 ) RETURN VARCHAR2;
402 
403 ---**
404 
405 FUNCTION Prorate
406 (   p_prorate_flag                  IN  VARCHAR2
407 ) RETURN VARCHAR2;
408 
409 FUNCTION Customer_Item
410 (   p_customer_item_id              IN  NUMBER
411 ) RETURN VARCHAR2;
412 
413 FUNCTION Inventory_Item
414 (   p_inventory_item_id             IN  NUMBER
415 ) RETURN VARCHAR2;
416 
417 ---**
418 
419 FUNCTION Method
420 (   p_method_code                   IN  VARCHAR2
421 ) RETURN VARCHAR2;
422 
423 ---**
424 
425 FUNCTION Price_List_Line
426 (   p_price_list_line_id            IN  NUMBER
427 ) RETURN VARCHAR2;
428 
429 ---**
430 
431 FUNCTION Pricing_Rule
432 (   p_pricing_rule_id               IN  NUMBER
433 ) RETURN VARCHAR2;
434 
435 ---**
436 
437 FUNCTION Reprice
438 (   p_reprice_flag                  IN  VARCHAR2
439 ) RETURN VARCHAR2;
440 
441 ---**
442 
443 FUNCTION Unit
444 (   p_unit_code                     IN  VARCHAR2
445 ) RETURN VARCHAR2;
446 
447 ---**
448 
449 FUNCTION Customer_Class
450 (   p_customer_class_code           IN  VARCHAR2
451 ) RETURN VARCHAR2;
455 FUNCTION Discount_Customer
452 
453 ---**
454 
456 (   p_discount_customer_id          IN  NUMBER
457 ) RETURN VARCHAR2;
458 
459 ---**
460 
461 FUNCTION Site_Use
462 (   p_site_use_id                   IN  NUMBER
463 ) RETURN VARCHAR2;
464  ---**
465 
466 FUNCTION Entity
467 (   p_entity_id                     IN  NUMBER
468 ) RETURN VARCHAR2;
469 
470 ---**
471 
472 FUNCTION Method_Type
473 (   p_method_type_code              IN  VARCHAR2
474 ) RETURN VARCHAR2;
475 
476 ---**
477 
478 FUNCTION Charge_Type
479 (   p_charge_type_id                IN  NUMBER
480 ) RETURN VARCHAR2;
481 
482 /*FUNCTION Tax_Group
483 (   p_tax_code                      IN  VARCHAR2
484 ) RETURN VARCHAR2;*/
485 
486 
487 FUNCTION Flow_Status
488 ( p_flow_status_code	IN VARCHAR2
489 ) RETURN VARCHAR2;
490 
491 FUNCTION Freight_Carrier
492 ( p_freight_carrier_code	IN 	VARCHAR2
493 , p_ship_from_org_id 	IN	NUMBER
494 ) RETURN VARCHAR2;
495 
496 FUNCTION Sales_Channel
497 ( p_sales_channel_code	IN VARCHAR2
498 ) RETURN VARCHAR2;
499 
500 PROCEDURE Ship_To_Customer_Name
501 (   p_ship_to_org_id                IN  NUMBER
502 ,   x_ship_to_customer_name         OUT NOCOPY /* file.sql.39 change */ VARCHAR2
503 );
504 
505 PROCEDURE Invoice_To_Customer_Name
506 (   p_invoice_to_org_id                IN  NUMBER
507 ,   x_invoice_to_customer_name         OUT NOCOPY /* file.sql.39 change */ VARCHAR2
508 );
509 
510 PROCEDURE  Item_Identifier
511 ( p_Item_Identifier_type IN  VARCHAR2
512 , x_Item_Identifier      OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
513 
514 PROCEDURE  Ordered_Item
515 ( p_Item_Identifier_type IN VARCHAR2
516 , p_inventory_item_id    IN NUMBER
517 , p_organization_id      IN NUMBER
518 , p_ordered_item_id      IN NUMBER
519 , p_sold_to_org_id       IN NUMBER
520 , p_ordered_item         IN VARCHAR2
521 , x_ordered_item         OUT NOCOPY /* file.sql.39 change */ VARCHAR2
522 , x_inventory_item       OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
523 
524 PROCEDURE  Item_relationship_type
525 ( p_Item_relationship_type IN  NUMBER
526 , x_Item_relationship_type_dsp      OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
527 
528 FUNCTION Transaction_Phase
529 (   p_Transaction_Phase_code            IN  VARCHAR2
530 ) RETURN VARCHAR2;
531 
532 FUNCTION User_Status
533 (   p_user_status_code            IN  VARCHAR2
534 ) RETURN VARCHAR2;
535 
536 PROCEDURE Customer_Location
537 (   p_sold_to_site_use_id                     IN  NUMBER
538 ,   x_sold_to_location_address1              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
539 ,   x_sold_to_location_address2              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
540 ,   x_sold_to_location_address3              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
541 ,   x_sold_to_location_address4              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
542 ,   x_sold_to_location                       OUT NOCOPY /* file.sql.39 change */ VARCHAR2
543 ,   x_sold_to_location_city                  OUT NOCOPY /* file.sql.39 change */ VARCHAR2
544 ,   x_sold_to_location_state                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
545 ,   x_sold_to_location_postal                OUT NOCOPY /* file.sql.39 change */ VARCHAR2
546 ,   x_sold_to_location_country               OUT NOCOPY /* file.sql.39 change */ VARCHAR2
547 );
548 
549 PROCEDURE Get_Contact_Details
550 ( p_contact_id          IN NUMBER
551  ,x_contact_name        OUT NOCOPY VARCHAR2
552  ,x_phone_line_type     OUT NOCOPY VARCHAR2
553  ,x_phone_number        OUT NOCOPY VARCHAR2
554  ,x_email_address       OUT NOCOPY VARCHAR2);
555 
556 --serla begin
557 FUNCTION payment_collection_event_name
558 (   p_payment_collection_event            IN  VARCHAR2
559 ) RETURN VARCHAR2;
560 
561 FUNCTION Receipt_Method
562 (   p_receipt_method            IN  NUMBER
563 ) RETURN VARCHAR2;
564 
565 --SG{
566 FUNCTION get_sales_group_name
567 (p_sales_group_id IN NUMBER
568 )RETURN VARCHAR2;
569 --SG}
570 
571 --distributed orders
572 PROCEDURE End_Customer
573 (   p_end_customer_id 	        IN  NUMBER
574 ,   x_end_customer_name	        OUT NOCOPY /* file.sql.39 change */ VARCHAR2
575 ,   x_end_customer_number	OUT NOCOPY /* file.sql.39 change */ VARCHAR2
576 );
577 
578 FUNCTION end_customer_Contact
579 (   p_end_customer_contact_id            IN  NUMBER
580 ) RETURN VARCHAR2;
581 
582 PROCEDURE end_customer_site_use
583 (   p_end_customer_site_use_id           IN  NUMBER
584 ,   x_end_customer_address1              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
585 ,   x_end_customer_address2              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
586 ,   x_end_customer_address3              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
587 ,   x_end_customer_address4              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
588 ,   x_end_customer_location              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
589 ,   x_end_customer_city                  OUT NOCOPY /* file.sql.39 change */ VARCHAR2
590 ,   x_end_customer_state                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
591 ,   x_end_customer_postal_code           OUT NOCOPY /* file.sql.39 change */ VARCHAR2
592 ,   x_end_customer_country               OUT NOCOPY /* file.sql.39 change */ VARCHAR2
593 );
594 
595 FUNCTION IB_OWNER
596 (   p_ib_owner                     IN  VARCHAR2
597 ) RETURN VARCHAR2;
598 
599 FUNCTION IB_INSTALLED_AT_LOCATION
600 (   p_ib_installed_at_location     IN  VARCHAR2
601 ) RETURN VARCHAR2;
602 
603 FUNCTION IB_CURRENT_LOCATION
604 (   p_ib_current_location          IN  VARCHAR2
605 ) RETURN VARCHAR2;
606 
610 ) RETURN VARCHAR2;
607 --Recurring Charges
608 FUNCTION Charge_Periodicity
609 (   p_charge_periodicity_code          IN  VARCHAR2
611 
612 /*3605052*/
613 FUNCTION  SERVICE_PERIOD
614 (   p_service_period            IN    VARCHAR2
615     ,p_inventory_item_id         IN    NUMBER
616 ) RETURN VARCHAR2;
617 
618 FUNCTION  SERVICE_REFERENCE_TYPE        -- added for bug 5701246
619 (   p_service_reference_type_code            IN    VARCHAR2
620 ) RETURN VARCHAR2;
621 
622 
623 FUNCTION CHANGE_REASON
624 (   p_change_reason_code                     IN  VARCHAR2
625 ) RETURN VARCHAR2;
626 
627 --Customer Acceptance
628 Procedure Get_Contingency_Attributes
629 (   p_contingency_id                 IN  NUMBER
630    , x_contingency_name              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
631    , x_contingency_description       OUT NOCOPY /* file.sql.39 change */ VARCHAR2
632    , x_expiration_event_attribute    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
633 );
634 
635 Function Revrec_Event
636 (p_revrec_event_code  IN VARCHAR2) RETURN VARCHAR2;
637 
638 Function Accepted_By
639 (p_accepted_by  IN NUMBER) RETURN VARCHAR2;
640 
641 --sol_ord_er #16014165
642 
643 Function Billing_Profile
644 ( p_service_bill_profile_id IN NUMBER
645 ) RETURN VARCHAR2;
646 
647 Function Billing_Option
648 ( p_service_bill_option_code IN VARCHAR2
649 ) RETURN VARCHAR2;
650 
651 Function Subscription_Template
652 ( p_service_subs_template_id IN NUMBER
653 ) RETURN VARCHAR2;
654 
655 Function Coverage_Template
656 ( p_service_cov_template_id IN NUMBER
657 ) RETURN VARCHAR2;
658 
659 Function subscription_period
660 ( p_service_period IN VARCHAR2
661 ) RETURN VARCHAR2;
662 
663 --sol_ord_er #16014165 end
664 
665 END OE_Id_To_Value;