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.QP_VALUE_TO_ID

Source


1 PACKAGE QP_Value_To_Id AUTHID CURRENT_USER AS
2 /* $Header: QPXSVIDS.pls 120.2 2005/07/15 15:52:27 appldev 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 --  Automatic
26 
27 FUNCTION Automatic
28 (   p_automatic                     IN  VARCHAR2
29 ) RETURN VARCHAR2;
30 
31 --  Currency
32 
33 FUNCTION Currency
34 (   p_currency                      IN  VARCHAR2
35 ) RETURN VARCHAR2;
36 
37 --  Discount_Lines
38 
39 FUNCTION Discount_Lines
40 (   p_discount_lines                IN  VARCHAR2
41 ) RETURN VARCHAR2;
42 
43 --  Freight_Terms
44 
45 FUNCTION Freight_Terms
46 (   p_freight_terms                 IN  VARCHAR2
47 ) RETURN VARCHAR2;
48 
49 --  List_Header
50 
51 FUNCTION List_Header
52 (   p_list_header                   IN  VARCHAR2
53 ) RETURN NUMBER;
54 
55 --  List_Type
56 
57 FUNCTION List_Type
58 (   p_list_type                     IN  VARCHAR2
59 ) RETURN VARCHAR2;
60 
61 --  Prorate
62 
63 FUNCTION Prorate
64 (   p_prorate                       IN  VARCHAR2
65 ) RETURN VARCHAR2;
66 
67 --  Ship_Method
68 
69 FUNCTION Ship_Method
70 (   p_ship_method                   IN  VARCHAR2
71 ) RETURN VARCHAR2;
72 
73 --Begin code added by rchellam for OKC
74 --Agreement_Source
75 
76 FUNCTION Agreement_Source
77 (   p_agreement_source              IN  VARCHAR2
78 ) RETURN VARCHAR2;
79 --End code added by rchellam for OKC
80 
81 --  Terms
82 
83 FUNCTION Terms
84 (   p_terms                         IN  VARCHAR2
85 ) RETURN NUMBER;
86 
87 --  Base_Uom
88 
89 FUNCTION Base_Uom
90 (   p_base_uom                      IN  VARCHAR2
91 ) RETURN VARCHAR2;
92 
93 --  Generate_Using_Formula
94 
95 FUNCTION Generate_Using_Formula
96 (   p_generate_using_formula        IN  VARCHAR2
97 ) RETURN NUMBER;
98 
99 --  Gl_Class
100 
101 /* FUNCTION Gl_Class
102 (   p_gl_class                      IN  VARCHAR2
103 ) RETURN NUMBER;  */
104 
105 --  Inventory_Item
106 
107 FUNCTION Inventory_Item
108 (   p_inventory_item                IN  VARCHAR2
109 ) RETURN NUMBER;
110 
111 --  List_Line
112 
113 FUNCTION List_Line
114 (   p_list_line                     IN  VARCHAR2
115 ) RETURN NUMBER;
116 
117 --  List_Line_Type
118 
119 FUNCTION List_Line_Type
120 (   p_list_line_type                IN  VARCHAR2
121 ) RETURN VARCHAR2;
122 
123 --  List_Price_Uom
124 
125 FUNCTION List_Price_Uom
126 (   p_list_price_uom                IN  VARCHAR2
127 ) RETURN VARCHAR2;
128 
129 --  Modifier_Level
130 
131 FUNCTION Modifier_Level
132 (   p_modifier_level                IN  VARCHAR2
133 ) RETURN VARCHAR2;
134 
135 --  Organization
136 
137 FUNCTION Organization
138 (   p_organization                  IN  VARCHAR2
139 ) RETURN NUMBER;
140 
141 --  Override
142 
143 FUNCTION Override
144 (   p_override                      IN  VARCHAR2
145 ) RETURN VARCHAR2;
146 
147 --  Price_Break_Type
148 
149 FUNCTION Price_Break_Type
150 (   p_price_break_type              IN  VARCHAR2
151 ) RETURN VARCHAR2;
152 
153 --  Price_By_Formula
154 
155 FUNCTION Price_By_Formula
156 (   p_price_by_formula              IN  VARCHAR2
157 ) RETURN NUMBER;
158 
159 --  Primary_Uom
160 
161 FUNCTION Primary_Uom
162 (   p_primary_uom                   IN  VARCHAR2
163 ) RETURN VARCHAR2;
164 
165 --  Print_On_Invoice
166 
167 FUNCTION Print_On_Invoice
168 (   p_print_on_invoice              IN  VARCHAR2
169 ) RETURN VARCHAR2;
170 
171 --  Rebate_Subtype
172 
173 /* FUNCTION Rebate_Subtype
174 (   p_rebate_subtype                IN  VARCHAR2
175 ) RETURN VARCHAR2;  */
176 
177 --  Rebate_Transaction_Type
178 
179 FUNCTION Rebate_Transaction_Type
180 (   p_rebate_transaction_type       IN  VARCHAR2
181 ) RETURN VARCHAR2;
182 
183 --  Related_Item
184 
185 FUNCTION Related_Item
186 (   p_related_item                  IN  VARCHAR2
187 ) RETURN NUMBER;
188 
189 --  Relationship_Type
190 
191 FUNCTION Relationship_Type
192 (   p_relationship_type             IN  VARCHAR2
193 ) RETURN NUMBER;
194 
195 --  Reprice
196 
197 FUNCTION Reprice
198 (   p_reprice                       IN  VARCHAR2
199 ) RETURN VARCHAR2;
200 
201 --  Revision_Reason
202 
203 --  Comparison_Operator
204 
205 /*FUNCTION Comparison_Operator
206 (   p_comparison_operator           IN  VARCHAR2
207 ) RETURN VARCHAR2;*/
208 
209 --  Created_From_Rule
210 
211 FUNCTION Created_From_Rule
212 (   p_created_from_rule             IN  VARCHAR2
213 ) RETURN NUMBER;
214 
215 --  Excluder
216 
217 FUNCTION Excluder
218 (   p_excluder                      IN  VARCHAR2
219 ) RETURN VARCHAR2;
220 
221 --  Qualifier
222 
223 /*FUNCTION Qualifier
224 (   p_qualifier                     IN  VARCHAR2
225 ) RETURN NUMBER;*/
226 
227 --  Qualifier_Rule
228 
229 FUNCTION Qualifier_Rule
230 (   p_qualifier_rule                IN  VARCHAR2
231 ) RETURN NUMBER;
232 
233 --  Accumulate
234 
235 FUNCTION Accumulate
236 (   p_accumulate                    IN  VARCHAR2
237 ) RETURN VARCHAR2;
238 
239 --  Pricing_Attribute
240 
241 FUNCTION Pricing_Attribute
242 (   p_pricing_attribute_desc        IN  VARCHAR2,
243     p_context                       IN  VARCHAR2
244 ) RETURN VARCHAR2;
245 
246 --  Pricing_Attr_Value_From
247 
248 FUNCTION Pricing_Attr_Value_From
249 (   p_pricing_attr_value_from_desc  IN  VARCHAR2,
250     p_context                       IN  VARCHAR2,
251     p_attribute                     IN  VARCHAR2
252 ) RETURN VARCHAR2;
253 
254 --  Pricing_Attr_Value_To
255 
256 FUNCTION Pricing_Attr_Value_To
257 (   p_pricing_attr_value_to_desc    IN  VARCHAR2,
258     p_context                       IN  VARCHAR2,
259     p_attribute                     IN  VARCHAR2
260 ) RETURN VARCHAR2;
261 
262 --  Qualifier_Attribute
263 
264 FUNCTION Qualifier_Attribute
265 (   p_qualifier_attribute_desc      IN  VARCHAR2,
266     p_context                       IN  VARCHAR2
267 ) RETURN VARCHAR2;
268 
269 --  Qualifier_Attr_Value
270 
271 FUNCTION Qualifier_Attr_Value
272 (   p_qualifier_attr_value_desc     IN  VARCHAR2,
273     p_context                       IN  VARCHAR2,
274     p_attribute                     IN  VARCHAR2
275 ) RETURN VARCHAR2;
276 
277 --  Qualifier_Attr_Value_To
278 
279 FUNCTION Qualifier_Attr_Value_To
280 (   p_qualifier_attr_value_to_desc     IN  VARCHAR2,
281     p_context                       IN  VARCHAR2,
282     p_attribute                     IN  VARCHAR2
283 ) RETURN VARCHAR2;
284 
285 --  Product_Uom
286 
287 FUNCTION Product_Uom
288 (   p_product_uom                   IN  VARCHAR2
289 ) RETURN VARCHAR2;
290 
291 --  Header
292 
293 FUNCTION Header
294 (   p_header                        IN  VARCHAR2
295 ) RETURN NUMBER;
296 
297 --  Line
298 
299 FUNCTION Line
300 (   p_line                          IN  VARCHAR2
301 ) RETURN NUMBER;
302 
303 --  Order_Price_Attrib
304 
305 FUNCTION Order_Price_Attrib
306 (   p_order_price_attrib            IN  VARCHAR2
307 ) RETURN NUMBER;
308 
309 
310 
311 --  Price_Formula
312 
313 FUNCTION Price_Formula
314 (   p_price_formula                 IN  VARCHAR2
315 ) RETURN NUMBER;
316 
317 --  Price_Formula_Line
318 
319 FUNCTION Price_Formula_Line
320 (   p_price_formula_line            IN  VARCHAR2
321 ) RETURN NUMBER;
322 
323 --  Price_Formula_Line_Type
324 
325 FUNCTION Price_Formula_Line_Type
326 (   p_price_formula_line_type       IN  VARCHAR2
327 ) RETURN VARCHAR2;
328 
329 --  Price_List_Line
330 
331 FUNCTION Price_List_Line
332 (   p_price_list_line               IN  VARCHAR2
333 ) RETURN NUMBER;
334 
335 --  Price_Modifier_List
336 
337 FUNCTION Price_Modifier_List
338 (   p_price_modifier_list           IN  VARCHAR2
339 ) RETURN NUMBER;
340 
341 --  Limit_Exceed_Action
342 
343 FUNCTION Limit_Exceed_Action
344 (   p_limit_exceed_action           IN  VARCHAR2
345 ) RETURN VARCHAR2;
346 
347 --  Limit
348 
349 FUNCTION Limit
350 (   p_limit                         IN  VARCHAR2
351 ) RETURN NUMBER;
352 
353 --  Limit_Level
354 
355 FUNCTION Limit_Level
356 (   p_limit_level                   IN  VARCHAR2
357 ) RETURN VARCHAR2;
358 
359 --  Comparison_Operator
360 
361 FUNCTION Comparison_Operator
362 (   p_comparison_operator           IN  VARCHAR2
363 ) RETURN VARCHAR2;
364 
365 --  Limit_Attribute
366 
367 FUNCTION Limit_Attribute
368 (   p_limit_attribute               IN  VARCHAR2
369 ) RETURN NUMBER;
370 
371 --  Limit_Balance
372 
373 FUNCTION Limit_Balance
374 (   p_limit_balance                 IN  VARCHAR2
375 ) RETURN NUMBER;
376 
377 --  Base_Currency
378 
379 FUNCTION Base_Currency
380 (   p_base_currency                 IN  VARCHAR2
381 ) RETURN VARCHAR2;
382 
383 --  Currency_Header
384 
385 FUNCTION Currency_Header
386 (   p_currency_header               IN  VARCHAR2
387 ) RETURN NUMBER;
388 
389 --  Row
390 
391 /* Commented by Sunil
392 FUNCTION Row
393 (   p_row                           IN  VARCHAR2
394 ) RETURN ROWID;
395    Commented by Sunil */
396 
397 --  Currency_Detail
398 
399 FUNCTION Currency_Detail
400 (   p_currency_detail               IN  VARCHAR2
401 ) RETURN NUMBER;
402 
403 --  Markup_Formula
404 
405 FUNCTION Markup_Formula
406 (   p_markup_formula                IN  VARCHAR2
407 ) RETURN NUMBER;
408 
409 --  Base Markup_Formula
410 
411 FUNCTION Base_Markup_Formula
412 (   p_base_markup_formula                IN  VARCHAR2
413 ) RETURN NUMBER;
414 
415 --  To_Currency
416 
417 FUNCTION To_Currency
418 (   p_to_currency                   IN  VARCHAR2
419 ) RETURN VARCHAR2;
420 
421 --  Enabled
422 
423 FUNCTION Enabled
424 (   p_enabled                       IN  VARCHAR2
425 ) RETURN VARCHAR2;
426 
427 --  Prc_Context
428 
429 FUNCTION Prc_Context
430 (   p_prc_context                   IN  VARCHAR2
431 ) RETURN NUMBER;
432 
433 --  Seeded
434 
435 FUNCTION Seeded
436 (   p_seeded                        IN  VARCHAR2
437 ) RETURN VARCHAR2;
438 
439 --  Seeded_Valueset
440 
441 FUNCTION Seeded_Valueset
442 (   p_seeded_valueset               IN  VARCHAR2
443 ) RETURN NUMBER;
444 
445 --  Segment
446 
447 FUNCTION Segment
448 (   p_segment                       IN  VARCHAR2
449 ) RETURN NUMBER;
450 
451 --  User_Valueset
452 
453 FUNCTION User_Valueset
454 (   p_user_valueset                 IN  VARCHAR2
455 ) RETURN NUMBER;
456 
457 --  Lookup
458 
459 FUNCTION Lookup
460 (   p_lookup                        IN  VARCHAR2
461 ) RETURN VARCHAR2;
462 
463 --  Pte
464 
465 FUNCTION Pte
466 (   p_pte                           IN  VARCHAR2
467 ) RETURN VARCHAR2;
468 
469 --  Request_Type
470 
471 FUNCTION Request_Type
472 (   p_request_type                  IN  VARCHAR2
473 ) RETURN VARCHAR2;
474 
475 --  Pte_Source_System
476 
477 FUNCTION Pte_Source_System
478 (   p_pte_source_system             IN  VARCHAR2
479 ) RETURN NUMBER;
480 
481 --  Segment_Pte
482 
483 FUNCTION Segment_Pte
484 (   p_segment_pte                   IN  VARCHAR2
485 ) RETURN NUMBER;
486 
487 --  Attribute_Sourcing
488 
489 FUNCTION Attribute_Sourcing
490 (   p_attribute_sourcing            IN  VARCHAR2
491 ) RETURN NUMBER;
492 
493 --  Functional_Area
494 
495 FUNCTION Functional_Area
496 (   p_functional_area               IN  VARCHAR2
497 ) RETURN NUMBER;
498 
499 --  Pte_Sourcesystem_Fnarea
500 
501 FUNCTION Pte_Sourcesystem_Fnarea
502 (   p_pte_sourcesystem_fnarea       IN  VARCHAR2
503 ) RETURN NUMBER;
504 --  END GEN value_to_id
505 
506 FUNCTION Accounting_Rule
507 (   p_accounting_rule               IN  VARCHAR2
508 ) RETURN NUMBER;
509 
510 
511 
512 FUNCTION Agreement_Contact
513 (   p_Agreement_Contact                      IN  VARCHAR2
514 ) RETURN VARCHAR2;
515 
516 
517 FUNCTION Agreement
518 (   p_agreement                     IN  VARCHAR2
519 ) RETURN NUMBER;
520 
521 
522 FUNCTION Agreement_Type
523 (   p_Agreement_Type                      IN  VARCHAR2
524 ) RETURN VARCHAR2;
525 
526 
527 
528 
529 FUNCTION Customer
530 (   p_Customer                      IN  VARCHAR2
531 ) RETURN VARCHAR2;
532 
533 
534 
535 FUNCTION Invoice_Contact
536 (   p_Invoice_Contact                      IN  VARCHAR2
537 ) RETURN VARCHAR2;
538 
539 FUNCTION Invoice_To_Site_Use
540 (   p_Invoice_To_Site_Use                      IN  VARCHAR2
541 ) RETURN VARCHAR2;
542 
543 
544 FUNCTION Invoicing_Rule
545 (   p_invoicing_rule                IN  VARCHAR2
546 ) RETURN NUMBER;
547 
548 FUNCTION override_arule
549 (   p_override_arule                      IN  VARCHAR2
550 ) RETURN VARCHAR2;
551 
552 
553 
554 FUNCTION override_irule
555 (   p_override_irule                      IN  VARCHAR2
556 ) RETURN VARCHAR2;
557 
558 
559 
560 FUNCTION Price_List
561 (   p_price_list                    IN  VARCHAR2
562 ) RETURN NUMBER;
563 
564 
565 
566 FUNCTION Revision_Reason
567 (   p_Revision_Reason                      IN  VARCHAR2
568 ) RETURN VARCHAR2;
569 
570 
571 
572 FUNCTION Salesrep
573 (   p_salesrep                      IN  VARCHAR2
574 ) RETURN NUMBER;
575 
576 
577 
578 FUNCTION Term
579 (   p_Term                      IN  VARCHAR2
580 ) RETURN VARCHAR2;
581 
582 
583 PROCEDURE Flex_Meaning_To_Value_Id (p_flexfield_name IN VARCHAR2,
584     p_context        IN VARCHAR2,
585     p_segment        IN VARCHAR2,
586     p_meaning        IN VARCHAR2,
587     x_value         OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
588     x_id            OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
589     x_format_type   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
590 );
591 
592 
593 END QP_Value_To_Id;