[Home] [Help]
PACKAGE: APPS.OE_UPG_SO
Source
1 PACKAGE OE_Upg_SO AUTHID CURRENT_USER as
2 /* $Header: OEXIUSOS.pls 120.1 2011/12/21 07:06:48 rmoharan 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 clob,
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_TAX_EXEMPT_FLAG Varchar2(1);
51 G_CUSTOMER_ID Number;
52 G_FREIGHT_TERMS_CODE Varchar2(30);
53 G_TERMS_ID Number;
54 G_INVOICE_TO_SITE_USE_ID Number;
55 G_SOURCE_DOCUMENT_ID Number;
56 G_LINE_ID_CHANGE_FLAG Varchar2(1);
57 G_LAST_LINE_NUMBER Number;
58 G_COPIED_FLAG Varchar2(1);
59 G_AUTO_FLAG Varchar2(1);
60 G_COPIED_LINE_FLAG Varchar2(1);
61 G_EARLIEST_SCHEDULE_LIMIT Number;
62 G_LATEST_SCHEDULE_LIMIT Number;
63 G_ORIG_LINE_ID Number;
64 G_PURCHASE_ORDER_NUM Varchar2(50);
65 G_SALESREP_ID Number;
66 G_MTL_SALES_ORDER_ID Number;
67 G_ERROR_ALERT Varchar2(1);
68 G_ORDER_SOURCE_ID Number;
69 G_ERROR_LOCATION NUMBER;
70 G_CANCELLED_FLAG Varchar2(1);
71 G_ORDER_TYPE_ID Number;
72 G_ORDER_CATEGORY_CODE Varchar2(30);
73 G_ORIG_SYS_DOCUMENT_REF Varchar2(50);
74
75 v_reference_line_Id number;
76 v_reference_header_id number;
77 v_ins_return_quantity number;
78 v_avl_return_quantity number;
79 v_bal_return_quantity number;
80 v_return_new_line_id number;
81 v_return_new_line_number number;
82 v_return_lctr number;
83 v_return_created_line_id number;
84 v_line_exit_flag number;
85 v_cust_trx_attribute6 number;
86 v_customer_trx_id number;
87 v_received_quantity number;
88 v_actual_ordered_quantity number;
89
90 r_uom_code Varchar2(3);
91 r_inventory_item_id number;
92 r_warehouse_id number;
93 r_inventory_item_id_2 number;
94 r_uom_code_2 varchar2(3);
95 r_warehouse_id_2 number;
96 r_ato_model boolean := FALSE;
97 r_ato_option boolean := FALSE;
98 r_no_config_item boolean := FALSE;
99 r_line_set_id number;
100 r_shipment_number number := 1;
101 r_ato_flag varchar2(1);
102 r_option_flag varchar2(1);
103 r_original_item_type_code varchar2(30);
104 r_lctr number;
105
106 TYPE Line_rec_type IS RECORD
107 (
108 line_id number,
109 org_id number,
110 header_id number,
111 line_number number,
112 date_requested_current date,
113 promise_date date,
114 schedule_date date,
115 ordered_quantity number,
116 cancelled_quantity number,
117 shipped_quantity number,
118 tax_exempt_number varchar2(80),
119 tax_exempt_reason_code varchar2(30),
120 warehouse_id number,
121 ship_to_site_use_id number,
122 ship_to_contact_id number,
123 customer_item_id number,
124 demand_stream_id number,
125 customer_dock_code varchar2(50),
126 customer_job varchar2(50),
127 customer_production_line varchar2(50),
128 customer_model_serial_number varchar2(50),
129 project_id number,
130 task_id number,
131 inventory_item_id number,
132 tax_code varchar2(50),
133 demand_class_code varchar2(30),
134 price_list_id number,
135 agreement_id number,
136 shipment_priority_code varchar2(30),
137 ship_method_code varchar2(30),
138 invoicing_rule_id number,
139 accounting_rule_id number,
140 original_system_line_reference varchar2(50),
141 selling_price number,
142 list_price number,
143 context varchar2(30),
144 attribute1 varchar2(150),
145 attribute2 varchar2(150),
146 attribute3 varchar2(150),
147 attribute4 varchar2(150),
148 attribute5 varchar2(150),
149 attribute6 varchar2(150),
150 attribute7 varchar2(150),
151 attribute8 varchar2(150),
152 attribute9 varchar2(150),
153 attribute10 varchar2(150),
154 attribute11 varchar2(150),
155 attribute12 varchar2(150),
156 attribute13 varchar2(150),
157 attribute14 varchar2(150),
158 attribute15 varchar2(150),
159 industry_context varchar2(30),
160 industry_attribute1 varchar2(150),
161 industry_attribute2 varchar2(150),
162 industry_attribute3 varchar2(150),
163 industry_attribute4 varchar2(150),
164 industry_attribute5 varchar2(150),
165 industry_attribute6 varchar2(150),
166 industry_attribute7 varchar2(150),
167 industry_attribute8 varchar2(150),
168 industry_attribute9 varchar2(150),
169 industry_attribute10 varchar2(150),
170 industry_attribute11 varchar2(150),
171 industry_attribute12 varchar2(150),
172 industry_attribute13 varchar2(150),
173 industry_attribute14 varchar2(150),
174 industry_attribute15 varchar2(150),
175 global_attribute_category varchar2(30),
176 global_attribute1 varchar2(150),
177 global_attribute2 varchar2(150),
178 global_attribute3 varchar2(150),
179 global_attribute4 varchar2(150),
180 global_attribute5 varchar2(150),
181 global_attribute6 varchar2(150),
182 global_attribute7 varchar2(150),
183 global_attribute8 varchar2(150),
184 global_attribute9 varchar2(150),
185 global_attribute10 varchar2(150),
186 global_attribute11 varchar2(150),
187 global_attribute12 varchar2(150),
188 global_attribute13 varchar2(150),
189 global_attribute14 varchar2(150),
190 global_attribute15 varchar2(150),
191 global_attribute16 varchar2(150),
192 global_attribute17 varchar2(150),
193 global_attribute18 varchar2(150),
194 global_attribute19 varchar2(150),
195 global_attribute20 varchar2(150),
196 pricing_context varchar2(30),
197 pricing_attribute1 varchar2(150),
198 pricing_attribute2 varchar2(150),
199 pricing_attribute3 varchar2(150),
200 pricing_attribute4 varchar2(150),
201 pricing_attribute5 varchar2(150),
202 pricing_attribute6 varchar2(150),
203 pricing_attribute7 varchar2(150),
204 pricing_attribute8 varchar2(150),
205 pricing_attribute9 varchar2(150),
206 pricing_attribute10 varchar2(150),
207 creation_date date,
208 created_by number,
209 last_update_date date,
210 last_updated_by number,
211 last_update_login number,
212 program_application_id number,
213 program_id number,
214 program_update_date date,
215 request_id number,
216 parent_line_id number,
217 link_to_line_id number,
218 component_sequence_id number,
219 component_code varchar2(1000),
220 item_type_code varchar2(30),
221 source_type_code varchar2(30),
222 transaction_reason_code varchar2(30),
223 latest_acceptable_date date,
224 dep_plan_required_flag varchar2(1),
225 schedule_status_code varchar2(30),
226 configuration_item_flag varchar2(1),
227 ship_set_number number,
228 option_flag varchar2(1),
229 unit_code varchar2(3),
230 line_detail_id number,
231 credit_invoice_line_id number,
232 included_item_flag varchar2(1),
233 ato_line_id number,
234 line_category_code varchar2(30),
235 planning_priority number,
236 return_reference_type_Code varchar2(30),
237 line_type_code varchar2(30),
238 return_reference_id number,
239 open_flag varchar2(1),
240 ship_model_complete_flag varchar2(1),
241 standard_component_freeze_date date,
242 booked_Flag varchar2(1),
243 shipping_interfaced_flag varchar2(1),
244 fulfilled_flag varchar2(1),
245 invoice_interface_status_code varchar2(30),
246 intermediate_ship_to_id number,
247 rla_schedule_type_code varchar2(30),
248 transaction_type_code varchar2(30),
249 transaction_comments varchar2(2000),
250 selling_percent number,
251 customer_product_id number,
252 cp_service_id number,
253 serviced_quantity number,
254 service_duration number,
255 service_start_date date,
256 service_end_date date,
257 service_coterminate_flag varchar2(1),
258 service_period_conversion_rate number,
259 service_mass_txn_temp_id number,
260 service_parent_line_id number,
261 service_txn_reason_code varchar2(30),
262 service_txn_comments varchar2(2000),
263 unit_selling_percent number,
264 unit_list_percent number,
265 unit_percent_base_price number,
266 service_number number,
267 serviced_line_id number,
268 service_context varchar2(30),
269 service_attribute1 varchar2(240),
270 service_attribute2 varchar2(240),
271 service_attribute3 varchar2(240),
272 service_attribute4 varchar2(240),
273 service_attribute5 varchar2(240),
274 service_attribute6 varchar2(240),
275 service_attribute7 varchar2(240),
276 service_attribute8 varchar2(240),
277 service_attribute9 varchar2(240),
278 service_attribute10 varchar2(240),
279 service_attribute11 varchar2(240),
280 service_attribute12 varchar2(240),
281 service_attribute13 varchar2(240),
282 service_attribute14 varchar2(240),
283 service_attribute15 varchar2(240),
284 service_period varchar2(3),
285 list_percent number,
286 percent_base_price number,
287 picking_line_id number,
288 planning_prod_seq_number varchar2(50),
289 actual_departure_date date,
290 delivery number,
291 tp_context varchar2(30),
292 tp_attribute1 varchar2(240),
293 tp_attribute2 varchar2(240),
294 tp_attribute3 varchar2(240),
295 tp_attribute4 varchar2(240),
296 tp_attribute5 varchar2(240),
297 tp_attribute6 varchar2(240),
298 tp_attribute7 varchar2(240),
299 tp_attribute8 varchar2(240),
300 tp_attribute9 varchar2(240),
304 tp_attribute13 varchar2(240),
301 tp_attribute10 varchar2(240),
302 tp_attribute11 varchar2(240),
303 tp_attribute12 varchar2(240),
305 tp_attribute14 varchar2(240),
306 tp_attribute15 varchar2(240),
307 flow_status_code varchar2(30),
308 re_source_flag varchar2(1),
309 source_document_type_id number,
310 source_document_id number,
311 source_document_line_id number,
312 service_reference_type_code varchar2(30),
313 service_reference_line_id number,
314 service_reference_system_id number,
315 calculate_price_flag varchar2(1),
316 marketing_source_code_id number,
317 shippable_flag varchar2(1),
318 fulfillment_method_code varchar2(30),
319 revenue_amount number,
320 fulfillment_date date,
321 visible_demand_flag varchar2(1),
322 cancelled_flag varchar2(1),
323 line_type_id number,
324 fulfilled_quantity number,
325 invoiced_quantity number,
326 shipping_quantity_uom varchar2(3),
327 top_model_line_id number
328 );
329
330 G_LINE_REC Line_Rec_type;
331
332 TYPE LOG_rec_type IS RECORD
333 (
334 Header_id number,
335 Old_Line_ID number,
336 Old_Line_Detail_ID number,
337 New_Line_ID number,
338 Picking_line_id number,
339 New_Line_Number number,
340 Return_Qty_Available number,
341 MTL_Sales_Order_ID number,
342 comments varchar2(240),
343 Creation_Date date,
344 Last_Update_Date date,
345 Delivery Number
346 );
347
348 G_LOG_REC Log_Rec_type;
349
350 Procedure Upgrade_Price_adjustments
351 ( L_level_flag IN Varchar2 );
352
353 Procedure Upgrade_Sales_Credits
354 ( L_level_flag IN Varchar2 );
355
356 Procedure Upgrade_Cancellations;
357
358 Procedure Upgrade_Create_Order_lines;
359
360 Procedure Upgrade_Create_Order_Headers
361 ( L_Line_Type IN Varchar2 ,
362 L_Slab IN Number);
363
364 Procedure Upgrade_Insert_Lines_History;
365
366 Procedure Upgrade_Insert_Upgrade_Log;
367
368 Procedure Upgrade_Process_Distbns
369 ( L_total_slabs IN Number);
370
371 Procedure Upgrade_Insert_Distbn_Record
372 (
373 L_slab IN Varchar2,
374 L_start_Header_id IN Number,
375 L_end_Header_Id IN Number,
376 L_type_var IN Varchar2
377 );
378 Procedure Upgrade_Insert_Errors
379 (
380 L_header_id IN Varchar2,
381 L_comments IN varchar2
382 );
383
384 Procedure Upgrade_Create_Line_Sets;
385 Procedure Upgrade_Upd_Serv_Ref_line_id;
386 PROCEDURE insert_multiple_models;
387
388 Procedure Insert_Return_Included_Items(p_line_id NUMBER,
389 module varchar2 default null);
390 Procedure Process_Upgraded_Returns;
391 Procedure Fix_Returns_Splits;
392
393 End OE_Upg_SO;