[Home] [Help]
PACKAGE: APPS.OE_ORDER_CACHE
Source
1 PACKAGE OE_Order_Cache AS
2 /* $Header: OEXUCCHS.pls 120.6.12010000.1 2008/07/25 07:55:00 appldev ship $ */
3
4 -- Order Type record type.
5
6 Type Enforce_list_price_rec_type is Record
7 (
8 Line_Type_id Number
9 ,header_id Number
10 ,enforce_line_prices_flag Varchar2(1)
11 );
12
13 g_Enforce_list_price_rec Enforce_list_price_rec_Type;
14
15 TYPE Order_Type_Rec_Type IS RECORD
16 ( order_type_id NUMBER := FND_API.G_MISS_NUM
17 , name VARCHAR2(80) := FND_API.G_MISS_CHAR
18 , cust_trx_type_id NUMBER := FND_API.G_MISS_NUM
19 , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
20 , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
21 , price_list_id NUMBER := FND_API.G_MISS_NUM
22 , shipment_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR
23 , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
24 , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
25 , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
26 , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
27 , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
28 , order_number_source_id NUMBER := FND_API.G_MISS_NUM
29 , agreement_required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
30 , require_po_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31 , enforce_line_prices_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
32 , auto_scheduling_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
33 -- QUOTING changes
34 , quote_num_as_ord_num_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
35 , invoice_source_id NUMBER := FND_API.G_MISS_NUM
36 , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM
37 -- bug 4200055
38 , start_date_active DATE := FND_API.G_MISS_DATE
39 , end_date_active DATE := FND_API.G_MISS_DATE
40 , tax_calculation_event_code VARCHAR2(30) := FND_API.G_MISS_CHAR
41 );
42
43 TYPE Tax_Code_Cach IS RECORD(
44 ship_to_org_id NUMBER := FND_API.G_MISS_NUM
45 , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
46 , inventory_item_id NUMBER := FND_API.G_MISS_NUM
47 , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
48 , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
49 , tax_date DATE := fnd_api.g_miss_date
50 , trx_type_id NUMBER := FND_API.G_MISS_NUM
51 , tax_code VARCHAR2(50) := FND_API.G_MISS_CHAR
52 , tax_exempt_number VARCHAR2(80) := FND_API.G_MISS_CHAR
53 , tax_exempt_reason_code VARCHAR2(80) := FND_API.G_MISS_CHAR
54 , vat_tax_id NUMBER := FND_API.G_MISS_NUM
55 , amt_incl_tax_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
56 , amt_incl_tax_override VARCHAR2(1) := FND_API.G_MISS_CHAR
57 );
58
59 g_TAX_CODE_CACH Tax_Code_Cach;
60 g_TAX_EXEMPTION_CACH Tax_Code_Cach;
61
62
63 -- Line Type record type.
64
65 TYPE Line_Type_Rec_Type IS RECORD
66 ( Line_Type_id NUMBER := FND_API.G_MISS_NUM
67 , name VARCHAR2(80) := FND_API.G_MISS_CHAR
68 , cust_trx_type_id NUMBER := FND_API.G_MISS_NUM
69 , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
70 , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
71 , price_list_id NUMBER := FND_API.G_MISS_NUM
72 , shipment_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR
73 , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
74 , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
75 , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
76 , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
77 , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
78 , agreement_required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
79 , enforce_line_prices_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
80 , calculate_tax_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81 , order_category_code VARCHAR2(30) := FND_API.G_MISS_CHAR
82 , ship_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
83 , invoice_source_id NUMBER := FND_API.G_MISS_NUM
84 , non_delivery_invoice_source_id NUMBER := FND_API.G_MISS_NUM
85 --added for bug 4200055
86 , start_date_active DATE := FND_API.G_MISS_DATE
87 , end_date_active DATE := FND_API.G_MISS_DATE
88 , tax_calculation_event_code VARCHAR2(30) := FND_API.G_MISS_CHAR
89 );
90
91 -- Agreement record type.
92
93 TYPE Agreement_Rec_Type IS RECORD
94 ( agreement_id NUMBER := FND_API.G_MISS_NUM
95 , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
96 , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
97 , price_list_id NUMBER := FND_API.G_MISS_NUM
98 , cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR
99 , payment_term_id NUMBER := FND_API.G_MISS_NUM
100 , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
101 , invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM
102 , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
103 , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
104 );
105
106 -- Ship To record type
107
108 TYPE Ship_To_Org_Rec_Type IS RECORD
109 ( org_id NUMBER := FND_API.G_MISS_NUM
110 , price_list_id NUMBER := FND_API.G_MISS_NUM
111 , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
112 , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
113 , sold_from_org_id NUMBER := FND_API.G_MISS_NUM
114 , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
115 , payment_term_id NUMBER := FND_API.G_MISS_NUM
116 , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
117 , contact_id NUMBER := FND_API.G_MISS_NUM
118 , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
119 , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
120 );
121
122 -- Invoice To record type
123
124 TYPE Invoice_To_Org_Rec_Type IS RECORD
125 ( org_id NUMBER := FND_API.G_MISS_NUM
126 , price_list_id NUMBER := FND_API.G_MISS_NUM
127 , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
128 , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
129 , payment_term_id NUMBER := FND_API.G_MISS_NUM
130 , contact_id NUMBER := FND_API.G_MISS_NUM
131 , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
132 , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
133 -- addded for bug 4200055
134 , status VARCHAR2(1) := FND_API.G_MISS_CHAR
135 , address_status VARCHAR2(1) := FND_API.G_MISS_CHAR
136 , start_date_active DATE := FND_API.G_MISS_DATE
137 , end_date_active DATE := FND_API.G_MISS_DATE
138 );
139
140 -- Deliver To record type
141
142 TYPE Deliver_To_Org_Rec_Type IS RECORD
143 ( org_id NUMBER := FND_API.G_MISS_NUM
144 , price_list_id NUMBER := FND_API.G_MISS_NUM
145 , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
146 , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
147 , sold_from_org_id NUMBER := FND_API.G_MISS_NUM
148 , ship_from_org_id NUMBER := FND_API.G_MISS_NUM
149 , payment_term_id NUMBER := FND_API.G_MISS_NUM
150 , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
151 , contact_id NUMBER := FND_API.G_MISS_NUM
152 , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
153 , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
154 );
155
156 -- Sold To record type
157
158 TYPE Sold_To_Org_Rec_Type IS RECORD
159 ( org_id NUMBER := FND_API.G_MISS_NUM
160 , price_list_id NUMBER := FND_API.G_MISS_NUM
161 , fob_point_code VARCHAR2(30) := FND_API.G_MISS_CHAR
162 , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
163 , payment_term_id NUMBER := FND_API.G_MISS_NUM
164 , ship_to_org_id NUMBER := FND_API.G_MISS_NUM
165 , deliver_to_org_id NUMBER := FND_API.G_MISS_NUM
166 , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
167 , contact_id NUMBER := FND_API.G_MISS_NUM
168 , ship_partial_allowed VARCHAR2(1) := FND_API.G_MISS_CHAR
169 , shipping_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
170 , order_type_id NUMBER := FND_API.G_MISS_NUM
171 , sold_to_org_id NUMBER := FND_API.G_MISS_NUM -- MOAC Changes
172 );
173
174 -- Price List record type
175
176 TYPE Price_List_Rec_Type IS RECORD
177 ( price_list_id NUMBER := FND_API.G_MISS_NUM
178 , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
179 , payment_term_id NUMBER := FND_API.G_MISS_NUM
180 , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
181 , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
182 -- added for bug 4200055
183 , name VARCHAR2(240) := FND_API.G_MISS_CHAR
184 , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
185 , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
186 , start_date_active DATE := FND_API.G_MISS_DATE
187 , end_date_active DATE := FND_API.G_MISS_DATE
188 );
189
190 -- Set_Of_Books record type
191
192 TYPE Set_Of_Books_Rec_Type IS RECORD
193 ( set_of_books_id NUMBER := FND_API.G_MISS_NUM
194 , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
195 );
196
197 -- Item record type
198 -- OPM 02/JUN/00 - Add process control chatacteristics for dual um and grade
199
200 TYPE Item_Rec_Type IS RECORD
201 ( inventory_item_id NUMBER := FND_API.G_MISS_NUM
202 , organization_id NUMBER := FND_API.G_MISS_NUM
203 , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
204 , accounting_rule_id NUMBER := FND_API.G_MISS_NUM
205 , default_shipping_org NUMBER := FND_API.G_MISS_NUM
206 , ship_model_complete_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
207 , build_in_wip_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
208 , bom_item_type NUMBER := FND_API.G_MISS_NUM
209 , replenish_to_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
210 , primary_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
211 , pick_components_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
212 , shippable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
213 , service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
214 --, dualum_ind NUMBER := FND_API.G_MISS_NUM --INVCONV -
215 --, grade_ctl NUMBER := FND_API.G_MISS_NUM --INVCONV--
216 --, opm_item_um VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV -
217 --, opm_item_um2 VARCHAR2(4) := FND_API.G_MISS_CHAR --INVCONV-
218 --, opm_item_id NUMBER := FND_API.G_MISS_NUM --INVCONV-
219 , process_warehouse_flag VARCHAR2(1) := FND_API.G_MISS_CHAR --OPM
220 --, ont_pricing_qty_source NUMBER := FND_API.G_MISS_NUM --INVCONV OPM 2046190
221 , ont_pricing_qty_source VARCHAR2(30) := FND_API.G_MISS_CHAR --INVCONV
222 -- Pack J catchweight
223 , tracking_quantity_ind VARCHAR2(30) := FND_API.G_MISS_CHAR
224 , wms_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
225 , secondary_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
226 -- bug 4171642
227 , master_org_id NUMBER := FND_API.G_MISS_NUM
228 , customer_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
229 , internal_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
230 , returnable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
231 , restrict_subinventories_code NUMBER := FND_API.G_MISS_NUM
232 , indivisible_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
233 -- bug 4171642
234
235 -- INVCONV start
236 , secondary_default_ind VARCHAR2(30) := FND_API.G_MISS_CHAR
237 , lot_divisible_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
238 , grade_control_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
239 , lot_control_code NUMBER := FND_API.G_MISS_NUM
240 -- INVCONV end
241
242
243 );
244
245
246 -- Item-Org record type
247
248 TYPE Item_Cost_Rec_Type IS RECORD
249 ( inventory_item_id NUMBER := FND_API.G_MISS_NUM
250 , organization_id NUMBER := FND_API.G_MISS_NUM
251 , material_cost NUMBER := FND_API.G_MISS_NUM
252 , material_overhead_cost NUMBER := FND_API.G_MISS_NUM
253 , resource_cost NUMBER := FND_API.G_MISS_NUM
254 , outside_processing_cost NUMBER := FND_API.G_MISS_NUM
255 , overhead_cost NUMBER := FND_API.G_MISS_NUM
256 );
257
258
259 TYPE Discount_Rec_Type IS RECORD
260 (
261 adjustment_name VARCHAR2(200) := fnd_api.g_miss_char,
262 discount_id NUMBER := fnd_api.g_miss_num,
263 discount_line_id NUMBER := fnd_api.g_miss_num,
264 percent NUMBER := fnd_api.g_miss_num,
265 amount NUMBER := fnd_api.g_miss_num,
266 price_adjustment_id NUMBER := fnd_api.g_miss_num
267 );
268
269
270 TYPE Set_Rec_Type IS RECORD
271 (
272 SET_ID NUMBER := fnd_api.g_miss_num
273 , SET_NAME VARCHAR2(30) := fnd_api.g_miss_char
274 , SET_TYPE VARCHAR2(30) := fnd_api.g_miss_char
275 , Header_Id NUMBER := fnd_api.g_miss_num
276 , Ship_from_org_id NUMBER := fnd_api.g_miss_num
277 , Ship_to_org_id NUMBER := fnd_api.g_miss_num
278 , Schedule_Ship_Date DATE := fnd_api.g_miss_date
279 , Schedule_Arrival_Date DATE := fnd_api.g_miss_date
280 , shipment_priority_code varchar2(30) := fnd_api.g_miss_char
281 , Freight_Carrier_Code VARCHAR2(30) := fnd_api.g_miss_char
282 , Shipping_Method_Code VARCHAR2(30) := fnd_api.g_miss_char
283 , Set_Status VARCHAR2(1) := fnd_api.g_miss_char
284 );
285
286 TYPE Modifiers_Rec_Type IS RECORD
287 ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
288 , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
289 , base_qty NUMBER := FND_API.G_MISS_NUM
290 , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
291 , inventory_item_id NUMBER := FND_API.G_MISS_NUM
292 , list_header_id NUMBER := FND_API.G_MISS_NUM
293 , list_line_id NUMBER := FND_API.G_MISS_NUM
294 , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
295 , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
296 , operand NUMBER := FND_API.G_MISS_NUM
297 , organization_id NUMBER := FND_API.G_MISS_NUM
298 , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
299 , percent_price NUMBER := FND_API.G_MISS_NUM
300 , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
301 , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
302 , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
303 , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
304 , rebate_transaction_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
305 , related_item_id NUMBER := FND_API.G_MISS_NUM
306 , relationship_type_id NUMBER := FND_API.G_MISS_NUM
307 , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
308 , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
309 , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
310 , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
311 , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
312 , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
313 , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
314 , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
315 , product_precedence NUMBER := FND_API.G_MISS_NUM
316 , expiration_date DATE := FND_API.G_MISS_DATE
317 , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
321 , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
318 , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
319 , benefit_qty NUMBER := FND_API.G_MISS_NUM
320 , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
322 , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
323 , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
324 );
325
326 Type Cust_Trx_Rec_Type is Record
327 (
328 cust_trx_type_id Number := FND_API.G_MISS_NUM
329 , tax_calculation_flag Varchar2(1) := FND_API.G_MISS_CHAR
330 , org_id NUMBER := FND_API.G_MISS_NUM -- MOAC Changes
331 );
332
333 Type Tax_Calc_Rec_Type is Record
334 (
335 line_type_id Number,
336 cust_trx_type_id Number,
337 tax_calculation_flag Varchar2(1)
338 );
339
340 TYPE Tax_Calc_Tbl_Type IS TABLE OF Tax_Calc_Rec_Type
341 INDEX BY BINARY_INTEGER;
342
343 -- begin bug 4200055
344 TYPE Payment_Term_Rec_Type IS RECORD (
345 TERM_ID Number := FND_API.G_MISS_NUM
346 ,NAME Varchar2(15) := FND_API.G_MISS_CHAR
347 ,START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
348 ,END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
349 );
350
351 g_payment_term_rec Payment_Term_rec_type ;
352 G_MISS_PAYMENT_TERM_REC Payment_Term_Rec_Type ;
353
354 FUNCTION Load_Payment_term
355 ( p_key IN NUMBER )
356 RETURN Payment_Term_Rec_Type;
357
358
359 TYPE Salesrep_Rec_Type IS RECORD (
360 SALESREP_ID Number := FND_API.G_MISS_NUM
361 ,NAME Varchar2(240):= FND_API.G_MISS_CHAR
362 ,STATUS Varchar2(30) := FND_API.G_MISS_CHAR
363 ,START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
364 ,END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
365 );
366
367 g_salesrep_rec Salesrep_rec_type ;
368 G_MISS_SALESREP_REC Salesrep_Rec_Type ;
369
370 FUNCTION Load_Salesrep_rec
371 ( p_key IN NUMBER )
372 RETURN Salesrep_Rec_Type;
373
374 -- end bug 4200055
375
376 -- Global variable representing missing variables of the types defined above.
377 -- line and adjustment records
378
379 G_MISS_ORDER_TYPE_REC Order_Type_Rec_Type ;
380 G_MISS_AGREEMENT_REC Agreement_Rec_Type ;
381 G_MISS_SHIP_TO_REC Ship_To_Org_Rec_Type ;
382 G_MISS_INVOICE_TO_REC Invoice_To_Org_Rec_Type ;
383 G_MISS_DELIVER_TO_REC Deliver_To_Org_Rec_Type ;
384 G_MISS_SOLD_TO_REC Sold_To_Org_Rec_Type ;
385 G_MISS_PRICE_LIST_REC Price_List_Rec_Type ;
386 G_MISS_SET_OF_BOOKS_REC Set_Of_Books_Rec_Type ;
387 G_MISS_ITEM_REC Item_Rec_Type ;
388 G_MISS_ITEM_COST_REC Item_Cost_Rec_Type ;
389 G_MISS_DISCOUNT_REC Discount_Rec_Type ;
390 G_MISS_CUST_TRX_TYPE_REC Cust_Trx_Rec_Type ;
391 G_CUST_TRX_LINE_TYPE_ID NUMBER := FND_API.G_MISS_NUM;
392
393
394 -- aksingh making this record visible for all apis
395 g_header_rec OE_Order_PUB.Header_Rec_Type;
396
397 ------------------------------------------------------------
398 -- Bug 1929163: Move global record types to specs so that
399 -- values can be accessed directly by all apis
400 ------------------------------------------------------------
401
402 g_order_type_rec Order_Type_Rec_Type;
403 g_line_type_rec line_Type_Rec_Type;
404 g_agreement_rec Agreement_Rec_Type;
405 g_ship_to_rec Ship_To_Org_Rec_Type;
406 g_invoice_to_rec Invoice_To_Org_Rec_Type;
407 g_deliver_to_rec Deliver_To_Org_Rec_Type;
408 g_sold_to_rec Sold_To_Org_Rec_Type;
409 g_price_list_rec Price_List_Rec_Type;
410 g_set_of_books_rec Set_Of_Books_Rec_Type;
411 g_item_rec Item_Rec_Type;
412 g_item_cost_rec Item_Cost_Rec_Type;
413 g_hdr_discount_rec Discount_rec_type;
414 g_line_discount_rec Discount_rec_type;
415 g_top_model_line_rec OE_Order_PUB.Line_Rec_Type;
416 g_Modifiers_Rec Modifiers_Rec_Type;
417 g_cust_trx_rec Cust_Trx_Rec_Type;
418
419 -- Global Records holding the set information
420 g_set_rec set_rec_type;
421 g_delivery_set_rec set_rec_type;
422 g_invoice_set_rec set_rec_type;
423 g_ship_set_rec set_rec_type;
424 g_fullfillment_set_rec set_rec_type;
425
426 -- Global records holding the tax calculation information
427 g_tax_calc_rec Tax_Calc_Rec_Type;
428 g_tax_calc_tbl Tax_Calc_Tbl_Type;
429
430 --
431 -- Globals to cahce if each flex is enabled or not.
432 -- Header Flex
433 g_hdr_desc_flex varchar2(1);
434 g_hdr_glb_flex varchar2(1);
435 g_hdr_tp_flex varchar2(1);
436 g_hdr_blkt_desc_flex varchar2(1);
437
438 -- Line flex
439 g_line_desc_flex varchar2(1);
440 g_line_glb_flex varchar2(1);
441 g_line_ind_flex varchar2(1);
442 g_line_tp_flex varchar2(1);
443 g_line_Ret_flex varchar2(1);
444 g_line_prc_flex varchar2(1);
445 g_line_blkt_desc_flex varchar2(1);
446
447 -- Procedures that load cached entities.
448 -- Overload load_order_type
449 PROCEDURE Load_Order_Type
450 (p_key IN NUMBER );
451
452 FUNCTION Load_Order_Type
453 ( p_key IN NUMBER )
454 RETURN Order_Type_Rec_Type;
455
456 ------------------------------------------------------------
460 PROCEDURE Load_Line_Type
457 -- Bug 1929163: overload load_line_type so that it can
458 -- be accessed both as a function and as a procedure
459 ------------------------------------------------------------
461 ( p_key IN NUMBER );
462
463 FUNCTION Load_Line_Type
464 ( p_key IN NUMBER )
465 RETURN Line_Type_Rec_Type;
466
467 FUNCTION Load_Agreement
468 ( p_key IN NUMBER )
469 RETURN Agreement_Rec_Type;
470
471 FUNCTION Load_Ship_To_Org
472 ( p_key IN NUMBER )
473 RETURN Ship_To_Org_Rec_Type;
474
475 FUNCTION Load_Invoice_To_Org
476 ( p_key IN NUMBER )
477 RETURN Invoice_to_Org_Rec_Type;
478
479 FUNCTION Load_Deliver_To_Org
480 ( p_key IN NUMBER )
481 RETURN Deliver_To_Org_Rec_Type;
482
483 FUNCTION Load_Sold_To_Org
484 ( p_key IN NUMBER )
485 RETURN Sold_To_Org_Rec_Type;
486
487 FUNCTION Load_Price_List
488 ( p_key IN NUMBER )
489 RETURN Price_List_Rec_Type;
490
491 FUNCTION Load_Set_Of_Books
492 RETURN Set_Of_Books_Rec_Type;
493
494 ------------------------------------------------------------
495 -- Bug 1929163: overload load_item so that it can be accessed
496 -- both as a function and as a procedure
497 ------------------------------------------------------------
498 PROCEDURE Load_Item
499 ( p_key1 IN NUMBER
500 , p_key2 IN NUMBER := FND_API.G_MISS_NUM
501 , p_key3 IN NUMBER DEFAULT NULL
502 );
503
504 FUNCTION Load_Item
505 ( p_key1 IN NUMBER
506 , p_key2 IN NUMBER := FND_API.G_MISS_NUM
507 , p_key3 IN NUMBER DEFAULT NULL)
508 RETURN Item_Rec_Type;
509
510 FUNCTION Load_Item_Cost
511 ( p_key1 IN NUMBER
512 , p_key2 IN NUMBER )
513 RETURN Item_Cost_Rec_Type;
514
515 ------------------------------------------------------------
516 -- Bug 1929163: overload load_top_model_line so that it can
517 -- be accessed both as a function and as a procedure
518 ------------------------------------------------------------
519 PROCEDURE Load_Order_Header
520 ( p_key IN NUMBER );
521
522 FUNCTION Load_Order_Header
523 ( p_key IN NUMBER )
524 RETURN OE_Order_PUB.Header_Rec_Type;
525
526 FUNCTION load_header_discount
527 ( p_hdr_adj_rec IN oe_order_pub.header_adj_rec_type)
528 RETURN OE_ORDER_PUB.HEADER_ADJ_REC_TYPE;
529
530 FUNCTION load_line_discount
531 ( p_line_adj_rec IN oe_order_pub.line_adj_rec_type)
532 RETURN OE_ORDER_PUB.LINE_ADJ_REC_TYPE;
533
534 ------------------------------------------------------------
535 -- Bug 1929163: overload load_top_model_line so that it can
536 -- be accessed both as a function and as a procedure
537 ------------------------------------------------------------
538 PROCEDURE Load_Top_Model_Line
539 ( p_key IN NUMBER );
540
541 FUNCTION Load_Top_Model_Line
542 ( p_key IN NUMBER)
543 RETURN OE_Order_PUB.Line_Rec_Type;
544
545 FUNCTION Load_Set
546 ( p_set_id IN NUMBER)
547 RETURN set_rec_type;
548
549 -- procedures that clear cached entities.
550
551 PROCEDURE Clear_All;
552
553 PROCEDURE Clear_Order_Type;
554
555 PROCEDURE Clear_Agreement;
556
557 PROCEDURE Clear_Ship_To_Org;
558
559 PROCEDURE Clear_Invoice_To_Org;
560
561 PROCEDURE Clear_Deliver_To_Org;
562
563 PROCEDURE Clear_Sold_To_Org;
564
565 PROCEDURE Clear_Price_List;
566
567 PROCEDURE Clear_Set_Of_Books;
568
569 PROCEDURE Clear_Item;
570
571 PROCEDURE Clear_Top_Model_Line(p_key IN NUMBER);
572
573 PROCEDURE Clear_Item_Cost;
574
575 PROCEDURE Set_Order_Header
576 (
577 p_header_rec IN OE_ORDER_PUB.Header_Rec_Type
578 );
579
580 PROCEDURE Clear_Order_Header;
581
582 PROCEDURE Clear_Discount;
583
584 --added for bug 4200055
585 PROCEDURE Clear_Salesrep ;
586 PROCEDURE Clear_Payment_Term ;
587 --end bug 4200055
588
589 FUNCTION GET_SET_OF_BOOKS
590 RETURN NUMBER;
591
592 FUNCTION Load_List_Lines
593 ( p_key IN NUMBER )
594 RETURN Modifiers_Rec_Type;
595
596 procedure Enforce_List_price
597 ( p_header_id number
598 , p_Line_Type_id Number
599 );
600
601 FUNCTION Load_Cust_Trx_Type
602 ( p_key IN NUMBER )
603 RETURN Cust_Trx_Rec_Type;
604
605 Procedure Load_Cust_Trx_Type
606 ( p_key IN NUMBER );
607
608 FUNCTION get_tax_calculation_flag
609 ( p_key IN NUMBER,
610 p_line_rec IN OE_ORDER_PUB.Line_Rec_Type )
611 RETURN Tax_Calc_Rec_Type;
612
613 FUNCTION IS_FLEX_ENABLED(p_flex_name IN VARCHAR2)
614 RETURN VARCHAR2 ;
615
616 FUNCTION LOAD_FLEX_ENABLED_FLAG(p_flex_name VARCHAR2)
617 RETURN VARCHAR2;
618
619
620 END OE_Order_Cache;