[Home] [Help]
PACKAGE: APPS.OE_ORDER_CACHE
Source
1 PACKAGE OE_Order_Cache AUTHID CURRENT_USER AS
2 /* $Header: OEXUCCHS.pls 120.6.12020000.2 2013/01/07 09:08:21 sujithku 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 -- sol_ord_er #16014165
242 , contract_item_type_code varchar2(100) := FND_API.G_MISS_CHAR
243
244 );
245
246
247 -- Item-Org record type
248
249 TYPE Item_Cost_Rec_Type IS RECORD
250 ( inventory_item_id NUMBER := FND_API.G_MISS_NUM
251 , organization_id NUMBER := FND_API.G_MISS_NUM
252 , material_cost NUMBER := FND_API.G_MISS_NUM
253 , material_overhead_cost NUMBER := FND_API.G_MISS_NUM
254 , resource_cost NUMBER := FND_API.G_MISS_NUM
255 , outside_processing_cost NUMBER := FND_API.G_MISS_NUM
256 , overhead_cost NUMBER := FND_API.G_MISS_NUM
257 );
258
259
260 TYPE Discount_Rec_Type IS RECORD
261 (
262 adjustment_name VARCHAR2(200) := fnd_api.g_miss_char,
263 discount_id NUMBER := fnd_api.g_miss_num,
264 discount_line_id NUMBER := fnd_api.g_miss_num,
265 percent NUMBER := fnd_api.g_miss_num,
266 amount NUMBER := fnd_api.g_miss_num,
267 price_adjustment_id NUMBER := fnd_api.g_miss_num
268 );
269
270
271 TYPE Set_Rec_Type IS RECORD
272 (
273 SET_ID NUMBER := fnd_api.g_miss_num
274 , SET_NAME VARCHAR2(30) := fnd_api.g_miss_char
275 , SET_TYPE VARCHAR2(30) := fnd_api.g_miss_char
276 , Header_Id NUMBER := fnd_api.g_miss_num
277 , Ship_from_org_id NUMBER := fnd_api.g_miss_num
278 , Ship_to_org_id NUMBER := fnd_api.g_miss_num
279 , Schedule_Ship_Date DATE := fnd_api.g_miss_date
280 , Schedule_Arrival_Date DATE := fnd_api.g_miss_date
281 , shipment_priority_code varchar2(30) := fnd_api.g_miss_char
282 , Freight_Carrier_Code VARCHAR2(30) := fnd_api.g_miss_char
283 , Shipping_Method_Code VARCHAR2(30) := fnd_api.g_miss_char
284 , Set_Status VARCHAR2(1) := fnd_api.g_miss_char
285 );
286
287 TYPE Modifiers_Rec_Type IS RECORD
288 ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
289 , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
290 , base_qty NUMBER := FND_API.G_MISS_NUM
291 , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
292 , inventory_item_id NUMBER := FND_API.G_MISS_NUM
293 , list_header_id NUMBER := FND_API.G_MISS_NUM
294 , list_line_id NUMBER := FND_API.G_MISS_NUM
295 , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
296 , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
297 , operand NUMBER := FND_API.G_MISS_NUM
298 , organization_id NUMBER := FND_API.G_MISS_NUM
299 , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
300 , percent_price NUMBER := FND_API.G_MISS_NUM
301 , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
302 , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
303 , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
304 , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
305 , rebate_transaction_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
306 , related_item_id NUMBER := FND_API.G_MISS_NUM
307 , relationship_type_id NUMBER := FND_API.G_MISS_NUM
308 , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
309 , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
310 , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
311 , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
312 , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
313 , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
314 , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
315 , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
316 , product_precedence NUMBER := FND_API.G_MISS_NUM
317 , expiration_date DATE := FND_API.G_MISS_DATE
318 , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
319 , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
320 , benefit_qty NUMBER := FND_API.G_MISS_NUM
321 , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
322 , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
323 , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
324 , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
325 );
326
327 Type Cust_Trx_Rec_Type is Record
328 (
329 cust_trx_type_id Number := FND_API.G_MISS_NUM
330 , tax_calculation_flag Varchar2(1) := FND_API.G_MISS_CHAR
331 , org_id NUMBER := FND_API.G_MISS_NUM -- MOAC Changes
332 );
333
334 Type Tax_Calc_Rec_Type is Record
335 (
336 line_type_id Number,
337 cust_trx_type_id Number,
338 tax_calculation_flag Varchar2(1)
339 );
340
341 TYPE Tax_Calc_Tbl_Type IS TABLE OF Tax_Calc_Rec_Type
342 INDEX BY BINARY_INTEGER;
343
344 -- begin bug 4200055
345 TYPE Payment_Term_Rec_Type IS RECORD (
346 TERM_ID Number := FND_API.G_MISS_NUM
347 ,NAME Varchar2(15) := FND_API.G_MISS_CHAR
348 ,START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
349 ,END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
350 );
351
352 g_payment_term_rec Payment_Term_rec_type ;
353 G_MISS_PAYMENT_TERM_REC Payment_Term_Rec_Type ;
354
355 FUNCTION Load_Payment_term
356 ( p_key IN NUMBER )
357 RETURN Payment_Term_Rec_Type;
358
359
360 TYPE Salesrep_Rec_Type IS RECORD (
361 SALESREP_ID Number := FND_API.G_MISS_NUM
362 ,NAME Varchar2(240):= FND_API.G_MISS_CHAR
363 ,STATUS Varchar2(30) := FND_API.G_MISS_CHAR
364 ,START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
365 ,END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
366 );
367
368 g_salesrep_rec Salesrep_rec_type ;
369 G_MISS_SALESREP_REC Salesrep_Rec_Type ;
370
371 FUNCTION Load_Salesrep_rec
372 ( p_key IN NUMBER )
373 RETURN Salesrep_Rec_Type;
374
375 -- end bug 4200055
376
377 -- Global variable representing missing variables of the types defined above.
378 -- line and adjustment records
379
380 G_MISS_ORDER_TYPE_REC Order_Type_Rec_Type ;
381 G_MISS_AGREEMENT_REC Agreement_Rec_Type ;
382 G_MISS_SHIP_TO_REC Ship_To_Org_Rec_Type ;
383 G_MISS_INVOICE_TO_REC Invoice_To_Org_Rec_Type ;
384 G_MISS_DELIVER_TO_REC Deliver_To_Org_Rec_Type ;
385 G_MISS_SOLD_TO_REC Sold_To_Org_Rec_Type ;
386 G_MISS_PRICE_LIST_REC Price_List_Rec_Type ;
387 G_MISS_SET_OF_BOOKS_REC Set_Of_Books_Rec_Type ;
388 G_MISS_ITEM_REC Item_Rec_Type ;
389 G_MISS_ITEM_COST_REC Item_Cost_Rec_Type ;
390 G_MISS_DISCOUNT_REC Discount_Rec_Type ;
391 G_MISS_CUST_TRX_TYPE_REC Cust_Trx_Rec_Type ;
392 G_CUST_TRX_LINE_TYPE_ID NUMBER := FND_API.G_MISS_NUM;
393
394
395 -- aksingh making this record visible for all apis
396 g_header_rec OE_Order_PUB.Header_Rec_Type;
397
398 ------------------------------------------------------------
399 -- Bug 1929163: Move global record types to specs so that
400 -- values can be accessed directly by all apis
401 ------------------------------------------------------------
402
403 g_order_type_rec Order_Type_Rec_Type;
404 g_line_type_rec line_Type_Rec_Type;
405 g_agreement_rec Agreement_Rec_Type;
406 g_ship_to_rec Ship_To_Org_Rec_Type;
407 g_invoice_to_rec Invoice_To_Org_Rec_Type;
408 g_deliver_to_rec Deliver_To_Org_Rec_Type;
409 g_sold_to_rec Sold_To_Org_Rec_Type;
410 g_price_list_rec Price_List_Rec_Type;
411 g_set_of_books_rec Set_Of_Books_Rec_Type;
412 g_item_rec Item_Rec_Type;
413 g_item_cost_rec Item_Cost_Rec_Type;
414 g_hdr_discount_rec Discount_rec_type;
415 g_line_discount_rec Discount_rec_type;
416 g_top_model_line_rec OE_Order_PUB.Line_Rec_Type;
417 g_Modifiers_Rec Modifiers_Rec_Type;
418 g_cust_trx_rec Cust_Trx_Rec_Type;
419
420 -- Global Records holding the set information
421 g_set_rec set_rec_type;
422 g_delivery_set_rec set_rec_type;
423 g_invoice_set_rec set_rec_type;
424 g_ship_set_rec set_rec_type;
425 g_fullfillment_set_rec set_rec_type;
426
427 -- Global records holding the tax calculation information
428 g_tax_calc_rec Tax_Calc_Rec_Type;
429 g_tax_calc_tbl Tax_Calc_Tbl_Type;
430
431 --
432 -- Globals to cahce if each flex is enabled or not.
433 -- Header Flex
434 g_hdr_desc_flex varchar2(1);
435 g_hdr_glb_flex varchar2(1);
436 g_hdr_tp_flex varchar2(1);
437 g_hdr_blkt_desc_flex varchar2(1);
438
439 -- Line flex
440 g_line_desc_flex varchar2(1);
441 g_line_glb_flex varchar2(1);
442 g_line_ind_flex varchar2(1);
443 g_line_tp_flex varchar2(1);
444 g_line_Ret_flex varchar2(1);
445 g_line_prc_flex varchar2(1);
446 g_line_blkt_desc_flex varchar2(1);
447
448 -- Procedures that load cached entities.
449 -- Overload load_order_type
450 PROCEDURE Load_Order_Type
451 (p_key IN NUMBER );
452
453 FUNCTION Load_Order_Type
454 ( p_key IN NUMBER )
455 RETURN Order_Type_Rec_Type;
456
457 ------------------------------------------------------------
458 -- Bug 1929163: overload load_line_type so that it can
459 -- be accessed both as a function and as a procedure
460 ------------------------------------------------------------
461 PROCEDURE Load_Line_Type
462 ( p_key IN NUMBER );
463
464 FUNCTION Load_Line_Type
465 ( p_key IN NUMBER )
466 RETURN Line_Type_Rec_Type;
467
468 FUNCTION Load_Agreement
469 ( p_key IN NUMBER )
470 RETURN Agreement_Rec_Type;
471
472 FUNCTION Load_Ship_To_Org
473 ( p_key IN NUMBER )
474 RETURN Ship_To_Org_Rec_Type;
475
476 FUNCTION Load_Invoice_To_Org
477 ( p_key IN NUMBER )
478 RETURN Invoice_to_Org_Rec_Type;
479
480 FUNCTION Load_Deliver_To_Org
481 ( p_key IN NUMBER )
482 RETURN Deliver_To_Org_Rec_Type;
483
484 FUNCTION Load_Sold_To_Org
485 ( p_key IN NUMBER )
486 RETURN Sold_To_Org_Rec_Type;
487
488 FUNCTION Load_Price_List
489 ( p_key IN NUMBER )
490 RETURN Price_List_Rec_Type;
491
492 FUNCTION Load_Set_Of_Books
493 RETURN Set_Of_Books_Rec_Type;
494
495 ------------------------------------------------------------
496 -- Bug 1929163: overload load_item so that it can be accessed
497 -- both as a function and as a procedure
498 ------------------------------------------------------------
499 PROCEDURE Load_Item
500 ( p_key1 IN NUMBER
501 , p_key2 IN NUMBER := FND_API.G_MISS_NUM
502 , p_key3 IN NUMBER DEFAULT NULL
503 );
504
505 FUNCTION Load_Item
506 ( p_key1 IN NUMBER
507 , p_key2 IN NUMBER := FND_API.G_MISS_NUM
508 , p_key3 IN NUMBER DEFAULT NULL)
509 RETURN Item_Rec_Type;
510
511 FUNCTION Load_Item_Cost
512 ( p_key1 IN NUMBER
513 , p_key2 IN NUMBER )
514 RETURN Item_Cost_Rec_Type;
515
516 ------------------------------------------------------------
517 -- Bug 1929163: overload load_top_model_line so that it can
518 -- be accessed both as a function and as a procedure
519 ------------------------------------------------------------
520 PROCEDURE Load_Order_Header
521 ( p_key IN NUMBER );
522
523 FUNCTION Load_Order_Header
524 ( p_key IN NUMBER )
525 RETURN OE_Order_PUB.Header_Rec_Type;
526
527 FUNCTION load_header_discount
528 ( p_hdr_adj_rec IN oe_order_pub.header_adj_rec_type)
529 RETURN OE_ORDER_PUB.HEADER_ADJ_REC_TYPE;
530
531 FUNCTION load_line_discount
532 ( p_line_adj_rec IN oe_order_pub.line_adj_rec_type)
533 RETURN OE_ORDER_PUB.LINE_ADJ_REC_TYPE;
534
535 ------------------------------------------------------------
536 -- Bug 1929163: overload load_top_model_line so that it can
537 -- be accessed both as a function and as a procedure
538 ------------------------------------------------------------
539 PROCEDURE Load_Top_Model_Line
540 ( p_key IN NUMBER );
541
542 FUNCTION Load_Top_Model_Line
543 ( p_key IN NUMBER)
544 RETURN OE_Order_PUB.Line_Rec_Type;
545
546 FUNCTION Load_Set
547 ( p_set_id IN NUMBER)
548 RETURN set_rec_type;
549
550 -- procedures that clear cached entities.
551
552 PROCEDURE Clear_All;
553
554 PROCEDURE Clear_Order_Type;
555
556 PROCEDURE Clear_Agreement;
557
558 PROCEDURE Clear_Ship_To_Org;
559
560 PROCEDURE Clear_Invoice_To_Org;
561
562 PROCEDURE Clear_Deliver_To_Org;
563
564 PROCEDURE Clear_Sold_To_Org;
565
566 PROCEDURE Clear_Price_List;
567
568 PROCEDURE Clear_Set_Of_Books;
569
570 PROCEDURE Clear_Item;
571
572 PROCEDURE Clear_Top_Model_Line(p_key IN NUMBER);
573
574 PROCEDURE Clear_Item_Cost;
575
576 PROCEDURE Set_Order_Header
577 (
578 p_header_rec IN OE_ORDER_PUB.Header_Rec_Type
579 );
580
581 PROCEDURE Clear_Order_Header;
582
583 PROCEDURE Clear_Discount;
584
585 --added for bug 4200055
586 PROCEDURE Clear_Salesrep ;
587 PROCEDURE Clear_Payment_Term ;
588 --end bug 4200055
589
590 FUNCTION GET_SET_OF_BOOKS
591 RETURN NUMBER;
592
593 FUNCTION Load_List_Lines
594 ( p_key IN NUMBER )
595 RETURN Modifiers_Rec_Type;
596
597 procedure Enforce_List_price
598 ( p_header_id number
599 , p_Line_Type_id Number
600 );
601
602 FUNCTION Load_Cust_Trx_Type
603 ( p_key IN NUMBER )
604 RETURN Cust_Trx_Rec_Type;
605
606 Procedure Load_Cust_Trx_Type
607 ( p_key IN NUMBER );
608
609 FUNCTION get_tax_calculation_flag
610 ( p_key IN NUMBER,
611 p_line_rec IN OE_ORDER_PUB.Line_Rec_Type )
612 RETURN Tax_Calc_Rec_Type;
613
614 FUNCTION IS_FLEX_ENABLED(p_flex_name IN VARCHAR2)
615 RETURN VARCHAR2 ;
616
617 FUNCTION LOAD_FLEX_ENABLED_FLAG(p_flex_name VARCHAR2)
618 RETURN VARCHAR2;
619
620
621 END OE_Order_Cache;