[Home] [Help]
PACKAGE: APPS.QP_ID_TO_VALUE
Source
1 PACKAGE QP_Id_To_Value AUTHID CURRENT_USER AS
2 /* $Header: QPXSIDVS.pls 120.1 2005/07/15 15:43:13 appldev 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 FUNCTION Automatic
20 ( p_automatic_flag IN VARCHAR2
21 ) RETURN VARCHAR2;
22
23 FUNCTION Currency
24 ( p_currency_code IN VARCHAR2
25 ) RETURN VARCHAR2;
26
27 FUNCTION Discount_Lines
28 ( p_discount_lines_flag IN VARCHAR2
29 ) RETURN VARCHAR2;
30
31 FUNCTION Freight_Terms
32 ( p_freight_terms_code IN VARCHAR2
33 ) RETURN VARCHAR2;
34
35 FUNCTION List_Header
36 ( p_list_header_id IN NUMBER
37 ) RETURN VARCHAR2;
38
39 FUNCTION List_Type
40 ( p_list_type_code IN VARCHAR2
41 ) RETURN VARCHAR2;
42
43 FUNCTION Prorate
44 ( p_prorate_flag IN VARCHAR2
45 ) RETURN VARCHAR2;
46
47 FUNCTION Ship_Method
48 ( p_ship_method_code IN VARCHAR2
49 ) RETURN VARCHAR2;
50
51 FUNCTION Terms
52 ( p_terms_id IN NUMBER
53 ) RETURN VARCHAR2;
54
55 --Begin code added by rchellam for OKC
56 FUNCTION Agreement_Source
57 ( p_agreement_source_code IN VARCHAR2
58 ) RETURN VARCHAR2;
59 --End code added by rchellam for OKC
60
61 FUNCTION Base_Uom
62 ( p_base_uom_code IN VARCHAR2
63 ) RETURN VARCHAR2;
64
65 FUNCTION Generate_Using_Formula
66 ( p_generate_using_formula_id IN NUMBER
67 ) RETURN VARCHAR2;
68
69 /* FUNCTION Gl_Class
70 ( p_gl_class_id IN NUMBER
71 ) RETURN VARCHAR2; */
72
73 FUNCTION Inventory_Item
74 ( p_inventory_item_id IN NUMBER
75 ) RETURN VARCHAR2;
76
77 FUNCTION List_Line
78 ( p_list_line_id IN NUMBER
79 ) RETURN VARCHAR2;
80
81 FUNCTION List_Line_Type
82 ( p_list_line_type_code IN VARCHAR2
83 ) RETURN VARCHAR2;
84
85 FUNCTION List_Price_Uom
86 ( p_list_price_uom_code IN VARCHAR2
87 ) RETURN VARCHAR2;
88
89 FUNCTION Modifier_Level
90 ( p_modifier_level_code IN VARCHAR2
91 ) RETURN VARCHAR2;
92
93 FUNCTION Organization
94 ( p_organization_id IN NUMBER
95 ) RETURN VARCHAR2;
96
97 FUNCTION Organization
98 ( p_organization_flag IN VARCHAR2
99 ) RETURN VARCHAR2;
100
101 FUNCTION Override
102 ( p_override_flag IN VARCHAR2
103 ) RETURN VARCHAR2;
104
105 FUNCTION Price_Break_Type
106 ( p_price_break_type_code IN VARCHAR2
107 ) RETURN VARCHAR2;
108
109 FUNCTION Price_By_Formula
110 ( p_price_by_formula_id IN NUMBER
111 ) RETURN VARCHAR2;
112
113 FUNCTION Primary_Uom
114 ( p_primary_uom_flag IN VARCHAR2
115 ) RETURN VARCHAR2;
116
117 FUNCTION Print_On_Invoice
118 ( p_print_on_invoice_flag IN VARCHAR2
119 ) RETURN VARCHAR2;
120
121 /*FUNCTION Rebate_Subtype
122 ( p_rebate_subtype_code IN VARCHAR2
123 ) RETURN VARCHAR2; */
124
125 FUNCTION Rebate_Transaction_Type
126 ( p_rebate_trxn_type_code IN VARCHAR2
127 ) RETURN VARCHAR2;
128
129 FUNCTION Related_Item
130 ( p_related_item_id IN NUMBER
131 ) RETURN VARCHAR2;
132
133 FUNCTION Relationship_Type
134 ( p_relationship_type_id IN NUMBER
135 ) RETURN VARCHAR2;
136
137 FUNCTION Reprice
138 ( p_reprice_flag IN VARCHAR2
139 ) RETURN VARCHAR2;
140
141 FUNCTION Revision_Reason
142 ( p_revision_reason_code IN VARCHAR2
143 ) RETURN VARCHAR2;
144
145 /*FUNCTION Comparison_Operator
146 ( p_comparison_operator_code IN VARCHAR2
147 ) RETURN VARCHAR2;*/
148
149 FUNCTION Created_From_Rule
150 ( p_created_from_rule_id IN NUMBER
151 ) RETURN VARCHAR2;
152
153 FUNCTION Excluder
154 ( p_excluder_flag IN VARCHAR2
155 ) RETURN VARCHAR2;
156
157 /*FUNCTION Qualifier
158 ( p_qualifier_id IN NUMBER
159 ) RETURN VARCHAR2;*/
160
161 FUNCTION Qualifier_Rule
162 ( p_qualifier_rule_id IN NUMBER
163 ) RETURN VARCHAR2;
164
165 FUNCTION Accumulate
166 ( p_accumulate_flag IN VARCHAR2
167 ) RETURN VARCHAR2;
168
169 FUNCTION Pricing_Attribute
170 ( p_pricing_attribute_id IN NUMBER
171 ) RETURN VARCHAR2;
172
173 FUNCTION Product_Uom
174 ( p_product_uom_code IN VARCHAR2
175 ) RETURN VARCHAR2;
176
177 FUNCTION Header
178 ( p_header_id IN NUMBER
179 ) RETURN VARCHAR2;
180
181 FUNCTION Line
182 ( p_line_id IN NUMBER
183 ) RETURN VARCHAR2;
184
185 FUNCTION Order_Price_Attrib
186 ( p_order_price_attrib_id IN NUMBER
187 ) RETURN VARCHAR2;
188
189 FUNCTION Price_Formula
190 ( p_price_formula_id IN NUMBER
191 ) RETURN VARCHAR2;
192
193 FUNCTION Price_Formula_Line
194 ( p_price_formula_line_id IN NUMBER
195 ) RETURN VARCHAR2;
196
197 FUNCTION Price_Formula_Line_Type
198 ( p_formula_line_type_code IN VARCHAR2
199 ) RETURN VARCHAR2;
200
201 FUNCTION Price_List_Line
202 ( p_price_list_line_id IN NUMBER
203 ) RETURN VARCHAR2;
204
205 FUNCTION Price_Modifier_List
206 ( p_price_modifier_list_id IN NUMBER
207 ) RETURN VARCHAR2;
208
209 FUNCTION Arithmetic_Operator
210 ( p_arithmetic_operator IN VARCHAR2
211 ) RETURN VARCHAR2;
212
213 -- Agreement Related functions
214 FUNCTION Accounting_Rule
215 ( p_accounting_rule_id IN NUMBER
216 ) RETURN VARCHAR2;
217
218
219 FUNCTION Agreement_Contact
220 ( p_agreement_contact_id IN NUMBER
221 ) RETURN VARCHAR2;
222
223 FUNCTION Agreement
224 ( p_agreement_id IN NUMBER
225 ) RETURN VARCHAR2;
226
227
228
229 FUNCTION Agreement_Type
230 ( p_agreement_type_code IN VARCHAR2
231 ) RETURN VARCHAR2;
232
233
234 FUNCTION Customer
235 ( p_sold_to_org_id IN NUMBER
236 ) RETURN VARCHAR2;
237
238 /* FUNCTION Freight_Terms
239 ( p_freight_terms_code IN VARCHAR2
240 ) RETURN VARCHAR2; */
241
242
243 FUNCTION Invoice_Contact
244 ( p_invoice_contact_id IN NUMBER
245 ) RETURN VARCHAR2;
246
247 FUNCTION Invoice_To_Site_Use
248 ( p_invoice_to_org_id IN NUMBER
249 ) RETURN VARCHAR2;
250
251
252
253 FUNCTION Invoicing_Rule
254 ( p_invoicing_rule_id IN NUMBER
255 ) RETURN VARCHAR2;
256
257 ---**
258
259 FUNCTION Override_Arule
260 ( p_override_arule_flag IN VARCHAR2
261 ) RETURN VARCHAR2;
262
263
264
265 FUNCTION Override_Irule
266 ( p_override_irule_flag IN VARCHAR2
267 ) RETURN VARCHAR2;
268
269 FUNCTION Price_List
270 ( p_price_list_id IN NUMBER
271 ) RETURN VARCHAR2;
272
273 /* FUNCTION Override_Irule
274 ( p_override_irule_flag IN VARCHAR2
275 ) RETURN VARCHAR2; */
276
277 /* FUNCTION Revision_Reason
278 ( p_revision_reason_code IN VARCHAR2
279 ) RETURN VARCHAR2; */
280
281 FUNCTION Salesrep
282 ( p_salesrep_id IN NUMBER
283 ) RETURN VARCHAR2;
284
285
286 /* FUNCTION Ship_Method
287 ( p_ship_method_code IN VARCHAR2
288 ) RETURN VARCHAR2; */
289
290 ---**
291
292 FUNCTION Term
293 ( p_term_id IN NUMBER
294 ) RETURN VARCHAR2;
295
296
297
298
299
300
301
302
303 FUNCTION Limit_Exceed_Action
304 ( p_limit_exceed_action_code IN VARCHAR2
305 ) RETURN VARCHAR2;
306
307 FUNCTION Limit
308 ( p_limit_id IN NUMBER
309 ) RETURN VARCHAR2;
310
311 FUNCTION Limit_Level
312 ( p_limit_level_code IN VARCHAR2
313 ) RETURN VARCHAR2;
314
315 FUNCTION Comparison_Operator
316 ( p_comparison_operator_code IN VARCHAR2
317 ) RETURN VARCHAR2;
318
319 FUNCTION Limit_Attribute
320 ( p_limit_attribute_id IN NUMBER
321 ) RETURN VARCHAR2;
322
323 FUNCTION Limit_Balance
324 ( p_limit_balance_id IN NUMBER
325 ) RETURN VARCHAR2;
326
327 FUNCTION Base_Currency
328 ( p_base_currency_code IN VARCHAR2
329 ) RETURN VARCHAR2;
330
331 FUNCTION Currency_Header
332 ( p_currency_header_id IN NUMBER
333 ) RETURN VARCHAR2;
334
335 FUNCTION Base_Markup_Formula
336 ( p_base_markup_formula_id IN NUMBER
337 ) RETURN VARCHAR2;
338
339 FUNCTION Row
340 ( p_row_id IN ROWID
341 ) RETURN VARCHAR2;
342
343 FUNCTION Currency_Detail
344 ( p_currency_detail_id IN NUMBER
345 ) RETURN VARCHAR2;
346
347 FUNCTION Markup_Formula
348 ( p_markup_formula_id IN NUMBER
349 ) RETURN VARCHAR2;
350
351 FUNCTION To_Currency
352 ( p_to_currency_code IN VARCHAR2
353 ) RETURN VARCHAR2;
354
355 FUNCTION Enabled
356 ( p_enabled_flag IN VARCHAR2
357 ) RETURN VARCHAR2;
358
359 FUNCTION Prc_Context
360 ( p_prc_context_id IN NUMBER
361 ) RETURN VARCHAR2;
362
363 FUNCTION Seeded
364 ( p_seeded_flag IN VARCHAR2
365 ) RETURN VARCHAR2;
366
367 FUNCTION Seeded_Valueset
368 ( p_seeded_valueset_id IN NUMBER
369 ) RETURN VARCHAR2;
370
371 FUNCTION Segment
372 ( p_segment_id IN NUMBER
373 ) RETURN VARCHAR2;
374
375 FUNCTION User_Valueset
376 ( p_user_valueset_id IN NUMBER
377 ) RETURN VARCHAR2;
378
379 FUNCTION Lookup
380 ( p_lookup_code IN VARCHAR2
381 ) RETURN VARCHAR2;
382
383 FUNCTION Pte
384 ( p_pte_code IN VARCHAR2
385 ) RETURN VARCHAR2;
386
387 FUNCTION Request_Type
388 ( p_request_type_code IN VARCHAR2
389 ) RETURN VARCHAR2;
390
391 FUNCTION Pte_Source_System
392 ( p_pte_source_system_id IN NUMBER
393 ) RETURN VARCHAR2;
394
395 FUNCTION Segment_Pte
396 ( p_segment_pte_id IN NUMBER
397 ) RETURN VARCHAR2;
398
399 FUNCTION Attribute_Sourcing
400 ( p_attribute_sourcing_id IN NUMBER
401 ) RETURN VARCHAR2;
402
403 FUNCTION Functional_Area
404 ( p_functional_area_id IN NUMBER
405 ) RETURN VARCHAR2;
406
407 FUNCTION Pte_Sourcesystem_Fnarea
408 ( p_pte_sourcesystem_fnarea_id IN NUMBER
409 ) RETURN VARCHAR2;
410 -- END GEN Id_To_Value
411
412 END QP_Id_To_Value;