[Home] [Help]
PACKAGE: APPS.OE_UPG_SO_NEW
Source
1 PACKAGE OE_UPG_SO_NEW as
2 /* $Header: OEXNUSOS.pls 120.1.12000000.1 2007/01/16 21:55:27 appldev ship $ */
3
4
5 TYPE Canc_rec_type IS RECORD
6 (
7 can_header_id number,
8 can_line_id number,
9 can_created_by number,
10 can_creation_date date,
11 can_last_updated_by number,
12 can_last_update_date date,
13 can_last_update_login number,
14 can_program_application_id number(15),
15 can_program_id number(15),
16 can_program_update_date date,
17 can_request_id number(15),
18 can_cancel_code varchar2(30),
19 can_cancelled_by number,
20 can_cancel_date date,
21 can_cancelled_quantity number,
22 can_cancel_comment varchar2(32000),
23 can_context varchar2(30),
24 can_attribute1 varchar2(150),
25 can_attribute2 varchar2(150),
26 can_attribute3 varchar2(150),
27 can_attribute4 varchar2(150),
28 can_attribute5 varchar2(150),
29 can_attribute6 varchar2(150),
30 can_attribute7 varchar2(150),
31 can_attribute8 varchar2(150),
32 can_attribute9 varchar2(150),
33 can_attribute10 varchar2(150),
34 can_attribute11 varchar2(150),
35 can_attribute12 varchar2(150),
36 can_attribute13 varchar2(150),
37 can_attribute14 varchar2(150),
38 can_attribute15 varchar2(150)
39 );
40
41 G_CANC_REC Canc_Rec_type;
42 G_HDR_CANC_REC Canc_Rec_type;
43
44 G_ORD_CANC_FLAG Varchar2(1);
45 G_HDR_CANC_FLAG Varchar2(1);
46 G_HEADER_ID Number;
47 G_LINE_ID Number;
48 G_OLD_LINE_ID Number;
49 G_SET_ID Number;
50 G_INCLUDE_SHIP_SET varchar2(1) := 'N' ;
51 G_TAX_EXEMPT_FLAG Varchar2(1);
52 G_CUSTOMER_ID Number;
53 G_FREIGHT_TERMS_CODE Varchar2(30);
54 G_TERMS_ID Number;
55 G_ACCOUNTING_RULE_ID Number;
56 G_INVOICING_RULE_ID Number;
57 G_INVOICE_TO_SITE_USE_ID Number;
58 G_LINE_ID_CHANGE_FLAG Varchar2(1);
59 G_LAST_LINE_NUMBER Number;
60 G_COPIED_FLAG Varchar2(1);
61 G_AUTO_FLAG Varchar2(1);
62 G_COPIED_LINE_FLAG Varchar2(1);
63 G_EARLIEST_SCHEDULE_LIMIT Number;
64 G_LATEST_SCHEDULE_LIMIT Number;
65 G_ORIG_LINE_ID Number;
66 G_PURCHASE_ORDER_NUM Varchar2(50);
67 G_SALESREP_ID Number;
68 G_MTL_SALES_ORDER_ID Number;
69 G_ERROR_ALERT Varchar2(1);
70 G_ERROR_LOCATION NUMBER;
71 G_CANCELLED_FLAG Varchar2(1);
72 G_ORDER_TYPE_ID Number;
73 G_ORDER_CATEGORY_CODE Varchar2(30);
74 G_INTERNAL_ORDER Varchar2(1);
75 -- Fix bug 1661010
76 G_SHIP_TO_SITE_USE_ID Number;
77
78 v_reference_line_Id number;
79 v_reference_header_id number;
80 v_ins_return_quantity number;
81 v_avl_return_quantity number;
82 v_bal_return_quantity number;
83 v_return_new_line_id number;
84 v_return_new_line_number number;
85 v_return_lctr number;
86 v_return_created_line_id number;
87 v_line_exit_flag number;
88 v_cust_trx_attribute6 number;
89 v_customer_trx_id number;
90 v_received_quantity number;
91 v_actual_ordered_quantity number;
92 v_master_org_for_single_org number := NULL;
93
94 r_uom_code Varchar2(3);
95 r_inventory_item_id number;
96 r_warehouse_id number;
97 r_inventory_item_id_2 number;
98 r_uom_code_2 varchar2(3);
99 r_warehouse_id_2 number;
100 r_ato_model boolean := FALSE;
101 r_ato_option boolean := FALSE;
102 r_no_config_item boolean := FALSE;
103 r_line_set_id number;
104 r_shipment_number number := 1;
105 r_ato_flag varchar2(1);
106 r_option_flag varchar2(1);
107 r_original_item_type_code varchar2(30);
108 r_lctr number;
109
110 TYPE Line_rec_type IS RECORD
111 (
112 line_id number,
113 org_id number,
114 header_id number,
115 line_number number,
116 date_requested_current date,
117 promise_date date,
118 schedule_date date,
119 ordered_quantity number,
120 cancelled_quantity number,
121 shipped_quantity number,
122 tax_exempt_number varchar2(80),
123 tax_exempt_reason_code varchar2(30),
124 warehouse_id number,
125 subinventory varchar2(10),
126 ship_to_site_use_id number,
127 ship_to_contact_id number,
128 customer_item_id number,
129 demand_stream_id number,
130 customer_dock_code varchar2(50),
131 customer_job varchar2(50),
132 customer_production_line varchar2(50),
133 customer_model_serial_number varchar2(50),
134 project_id number,
135 task_id number,
136 inventory_item_id number,
137 tax_code varchar2(50),
138 demand_class_code varchar2(30),
139 price_list_id number,
140 agreement_id number,
141 shipment_priority_code varchar2(30),
142 ship_method_code varchar2(30),
143 invoicing_rule_id number,
144 accounting_rule_id number,
145 original_system_line_reference varchar2(50),
146 selling_price number,
147 list_price number,
148 context varchar2(30),
149 attribute1 varchar2(150),
150 attribute2 varchar2(150),
151 attribute3 varchar2(150),
152 attribute4 varchar2(150),
153 attribute5 varchar2(150),
154 attribute6 varchar2(150),
155 attribute7 varchar2(150),
156 attribute8 varchar2(150),
157 attribute9 varchar2(150),
158 attribute10 varchar2(150),
159 attribute11 varchar2(150),
160 attribute12 varchar2(150),
161 attribute13 varchar2(150),
162 attribute14 varchar2(150),
163 attribute15 varchar2(150),
164 industry_context varchar2(30),
165 industry_attribute1 varchar2(150),
166 industry_attribute2 varchar2(150),
167 industry_attribute3 varchar2(150),
168 industry_attribute4 varchar2(150),
169 industry_attribute5 varchar2(150),
170 industry_attribute6 varchar2(150),
171 industry_attribute7 varchar2(150),
172 industry_attribute8 varchar2(150),
173 industry_attribute9 varchar2(150),
174 industry_attribute10 varchar2(150),
175 industry_attribute11 varchar2(150),
176 industry_attribute12 varchar2(150),
177 industry_attribute13 varchar2(150),
178 industry_attribute14 varchar2(150),
179 industry_attribute15 varchar2(150),
180 global_attribute_category varchar2(30),
181 global_attribute1 varchar2(150),
182 global_attribute2 varchar2(150),
183 global_attribute3 varchar2(150),
184 global_attribute4 varchar2(150),
185 global_attribute5 varchar2(150),
186 global_attribute6 varchar2(150),
187 global_attribute7 varchar2(150),
188 global_attribute8 varchar2(150),
189 global_attribute9 varchar2(150),
190 global_attribute10 varchar2(150),
191 global_attribute11 varchar2(150),
192 global_attribute12 varchar2(150),
193 global_attribute13 varchar2(150),
194 global_attribute14 varchar2(150),
195 global_attribute15 varchar2(150),
196 global_attribute16 varchar2(150),
197 global_attribute17 varchar2(150),
198 global_attribute18 varchar2(150),
199 global_attribute19 varchar2(150),
200 global_attribute20 varchar2(150),
201 pricing_context varchar2(30),
202 pricing_attribute1 varchar2(150),
203 pricing_attribute2 varchar2(150),
204 pricing_attribute3 varchar2(150),
205 pricing_attribute4 varchar2(150),
206 pricing_attribute5 varchar2(150),
207 pricing_attribute6 varchar2(150),
208 pricing_attribute7 varchar2(150),
209 pricing_attribute8 varchar2(150),
210 pricing_attribute9 varchar2(150),
211 pricing_attribute10 varchar2(150),
212 pricing_attribute11 varchar2(150),
213 pricing_attribute12 varchar2(150),
214 pricing_attribute13 varchar2(150),
215 pricing_attribute14 varchar2(150),
216 pricing_attribute15 varchar2(150),
217 creation_date date,
218 created_by number,
219 last_update_date date,
220 last_updated_by number,
221 last_update_login number,
222 program_application_id number,
223 program_id number,
224 program_update_date date,
225 request_id number,
226 parent_line_id number,
227 link_to_line_id number,
228 component_sequence_id number,
229 component_code varchar2(1000),
230 item_type_code varchar2(30),
231 source_type_code varchar2(30),
232 transaction_reason_code varchar2(30),
233 latest_acceptable_date date,
234 dep_plan_required_flag varchar2(1),
235 schedule_status_code varchar2(30),
236 configuration_item_flag varchar2(1),
237 ship_set_number number,
238 option_flag varchar2(1),
239 unit_code varchar2(3),
240 line_detail_id number,
241 credit_invoice_line_id number,
242 included_item_flag varchar2(1),
243 ato_line_id number,
244 line_category_code varchar2(30),
245 planning_priority number,
246 return_reference_type_Code varchar2(30),
247 line_type_code varchar2(30),
248 return_reference_id number,
249 open_flag varchar2(1),
250 ship_model_complete_flag varchar2(1),
251 standard_component_freeze_date date,
252 booked_Flag varchar2(1),
253 shipping_interfaced_flag varchar2(1),
254 fulfilled_flag varchar2(1),
255 invoice_interface_status_code varchar2(30),
256 intermediate_ship_to_id number,
257 rla_schedule_type_code varchar2(30),
258 transaction_type_code varchar2(30),
259 transaction_comments varchar2(2000),
260 selling_percent number,
261 customer_product_id number,
262 cp_service_id number,
263 serviced_quantity number,
264 service_duration number,
265 service_start_date date,
266 service_end_date date,
267 service_coterminate_flag varchar2(1),
268 service_period_conversion_rate number,
269 service_mass_txn_temp_id number,
270 service_parent_line_id number,
271 service_txn_reason_code varchar2(30),
272 service_txn_comments varchar2(2000),
273 unit_selling_percent number,
274 unit_list_percent number,
275 unit_percent_base_price number,
276 service_number number,
277 serviced_line_id number,
278 service_context varchar2(30),
279 service_attribute1 varchar2(240),
280 service_attribute2 varchar2(240),
281 service_attribute3 varchar2(240),
282 service_attribute4 varchar2(240),
283 service_attribute5 varchar2(240),
284 service_attribute6 varchar2(240),
285 service_attribute7 varchar2(240),
286 service_attribute8 varchar2(240),
287 service_attribute9 varchar2(240),
288 service_attribute10 varchar2(240),
289 service_attribute11 varchar2(240),
290 service_attribute12 varchar2(240),
291 service_attribute13 varchar2(240),
292 service_attribute14 varchar2(240),
293 service_attribute15 varchar2(240),
294 service_period varchar2(3),
295 list_percent number,
296 percent_base_price number,
297 picking_line_id number,
298 planning_prod_seq_number varchar2(50),
299 actual_departure_date date,
300 delivery number,
301 tp_context varchar2(30),
302 tp_attribute1 varchar2(240),
303 tp_attribute2 varchar2(240),
304 tp_attribute3 varchar2(240),
305 tp_attribute4 varchar2(240),
306 tp_attribute5 varchar2(240),
307 tp_attribute6 varchar2(240),
308 tp_attribute7 varchar2(240),
309 tp_attribute8 varchar2(240),
310 tp_attribute9 varchar2(240),
314 tp_attribute13 varchar2(240),
311 tp_attribute10 varchar2(240),
312 tp_attribute11 varchar2(240),
313 tp_attribute12 varchar2(240),
315 tp_attribute14 varchar2(240),
316 tp_attribute15 varchar2(240),
317 flow_status_code varchar2(30),
318 re_source_flag varchar2(1),
319 source_document_type_id number,
320 source_document_id number,
321 source_document_line_id number,
322 service_reference_type_code varchar2(30),
323 service_reference_line_id number,
324 service_reference_system_id number,
325 calculate_price_flag varchar2(1),
326 marketing_source_code_id number,
327 shippable_flag varchar2(1),
328 fulfillment_method_code varchar2(30),
329 revenue_amount number,
330 fulfillment_date date,
331 visible_demand_flag varchar2(1),
332 cancelled_flag varchar2(1),
333 line_type_id number,
334 fulfilled_quantity number,
335 invoiced_quantity number,
336 shipping_quantity_uom varchar2(3),
337 tax_date date,
338 sort_order VARCHAR2(240),
339 option_number number,
340 order_source_id number,
341 orig_sys_document_ref VARCHAR2(50),
342 terms_id number,
343 commitment_id number,
344 split_from_line_id NUMBER -- 3103312
345 );
346
347 G_LINE_REC Line_Rec_type;
348
349 TYPE LOG_rec_type IS RECORD
350 (
351 Header_id number,
352 Old_Line_ID number,
353 Old_Line_Detail_ID number,
354 New_Line_ID number,
355 Picking_line_id number,
356 New_Line_Number number,
357 Return_Qty_Available number,
358 MTL_Sales_Order_ID number,
359 comments varchar2(240),
360 Creation_Date date,
361 Last_Update_Date date,
362 Delivery Number
363 );
364
365 G_LOG_REC Log_Rec_type;
366
367 TYPE get_update_rec_type IS RECORD
368 (
369 line_id NUMBER
370 , item_type_code VARCHAR2(30)
371 , top_model_line_id NUMBER
372 , ato_line_id NUMBER
373 , shippable_flag VARCHAR2(1)
374 , shipped_quantity NUMBER
375 , line_number NUMBER
376 , shipment_number NUMBER
377 , model_remnant_flag VARCHAR2(1)
378 , link_to_line_id NUMBER
379 , line_category_code VARCHAR2(30)
380 , fulfilled_quantity NUMBER
381 , fulfilled_flag NUMBER
382 , fulfillment_date DATE
383 , actual_shipment_date DATE
384 , ordered_quantity NUMBER
385 , service_reference_line_id NUMBER
386 , option_number NUMBER
387 , component_number NUMBER
388 );
389
390 TYPE get_update_tbl_type IS TABLE OF get_update_rec_type
391 INDEX BY BINARY_INTEGER;
392
393 TYPE update_rec_type IS RECORD
394 (
395 line_number NUMBER
396 , shipment_number NUMBER
397 , option_number NUMBER
398 , component_number NUMBER
399 , model_remnant_flag VARCHAR2(1)
400 , ordered_quantity NUMBER
401 , actual_shipment_date DATE
402 , shipped_quantity NUMBER
403 , fulfilled_quantity NUMBER
404 , fulfilled_flag VARCHAR2(1)
405 , fulfillment_date DATE
406 , temp_update_flag VARCHAR2(1)
407 , service_reference_line_id NUMBER
408 , top_model_line_id NUMBER
409 , ato_line_id NUMBER
410 , item_type_code VARCHAR2(30)
411 , shippable_flag VARCHAR2(1)
412 , unit_selling_price NUMBER
413 , unit_list_price NUMBER
414 , ship_set_id NUMBER
415 );
416
417 TYPE update_tbl_type IS TABLE OF update_rec_type
418 INDEX BY BINARY_INTEGER;
419 Procedure Upgrade_Price_adjustments
420 ( L_level_flag IN Varchar2 );
421
422 Procedure Upgrade_Sales_Credits
423 ( L_level_flag IN Varchar2 );
424
425 Procedure Upgrade_Cancellations;
426
427 Procedure Upgrade_Create_Order_lines;
428
429 Procedure Upgrade_Create_Order_Headers
430 ( L_Line_Type IN Varchar2 ,
431 L_Slab IN Number);
432
433 Procedure Upgrade_Insert_Lines_History;
434
435 Procedure Upgrade_Insert_Upgrade_Log;
436
437 Procedure Upgrade_Process_Distbns
438 ( L_total_slabs IN Number,
439 L_type IN varchar2);
440
441 Procedure Upgrade_holds_Distbns
442 ( L_total_slabs IN Number );
443
444 Procedure Upgrade_Freight_Distbns
445 ( L_total_slabs IN Number );
446
447 PROCEDURE upgrade_inst_detail_distbns
448 ( p_number_of_slabs IN NUMBER );
449
450 Procedure Upgrade_Insert_Distbn_Record
451 (
452 L_slab IN Varchar2,
453 L_start_Header_id IN Number,
454 L_end_Header_Id IN Number,
455 L_type_var IN Varchar2
456 );
457 Procedure Upgrade_Insert_Errors
458 (
459 L_header_id IN Varchar2,
460 L_comments IN varchar2
461 );
462
463 Procedure Upgrade_Create_Line_Sets;
464 Procedure Upgrade_Upd_Serv_Ref_line_id;
465 PROCEDURE insert_multiple_models;
466 PROCEDURE update_after_insert;
467 PROCEDURE update_remnant_flag;
468
469 Procedure Insert_Return_Included_Items(p_line_id NUMBER,
470 module varchar2 default null);
471 Procedure Process_Upgraded_Returns(p_header_id in NUMBER);
472 Procedure Return_Fulfillment_Sets(p_header_id in NUMBER);
473
474 End OE_UPG_SO_NEW;