[Home] [Help]
PACKAGE BODY: APPS.MTL_DEMAND_INTERFACE_PKG
Source
1 PACKAGE BODY MTL_DEMAND_INTERFACE_PKG as
2 /* $Header: INVDVINB.pls 120.1 2005/07/01 12:17:18 appldev ship $ */
3
4 PROCEDURE Lock_Row( X_ROWID VARCHAR2,
5 X_SCHEDULE_GROUP_ID NUMBER,
6 X_DEMAND_SOURCE_TYPE NUMBER,
7 X_DEMAND_SOURCE_HEADER_ID NUMBER,
8 X_DEMAND_SOURCE_LINE VARCHAR2,
9 X_DEMAND_SOURCE_DELIVERY VARCHAR2,
10 X_ATP_CHECK NUMBER,
11 X_ACTION_CODE NUMBER,
12 X_VALIDATE_ROWS NUMBER,
13 X_TRANSACTION_MODE NUMBER,
14 X_PROCESS_FLAG NUMBER,
15 X_SINGLE_LOT_FLAG NUMBER,
16 X_DETAIL_RESERVE_FLAG NUMBER,
17 X_RESERVE_LEVEL NUMBER,
18 X_CHECK_ATR NUMBER,
19 X_ERROR_CODE NUMBER,
20 X_ERR_EXPLANATION VARCHAR2,
21 X_REQUIREMENT_DATE DATE,
22 X_LINE_ITEM_UNIT_OF_MEASURE VARCHAR2,
23 X_LINE_ITEM_UOM VARCHAR2,
24 X_LINE_ITEM_QUANTITY NUMBER,
25 X_LINE_ITEM_RESERVATION_QTY NUMBER,
26 X_PRIMARY_UOM VARCHAR2,
27 X_PRIMARY_UOM_QUANTITY NUMBER,
28 X_RESERVATION_QUANTITY NUMBER,
29 X_ATP_RULE_ID NUMBER,
30 X_ORGANIZATION_ID NUMBER,
31 X_ORGANIZATION_NAME VARCHAR2,
32 X_INVENTORY_ITEM_ID NUMBER,
33 X_ITEM_SEGMENT1 VARCHAR2,
34 X_ITEM_SEGMENT2 VARCHAR2,
35 X_ITEM_SEGMENT3 VARCHAR2,
36 X_ITEM_SEGMENT4 VARCHAR2,
37 X_ITEM_SEGMENT5 VARCHAR2,
38 X_ITEM_SEGMENT6 VARCHAR2,
39 X_ITEM_SEGMENT7 VARCHAR2,
40 X_ITEM_SEGMENT8 VARCHAR2,
41 X_ITEM_SEGMENT9 VARCHAR2,
42 X_ITEM_SEGMENT10 VARCHAR2,
43 X_ITEM_SEGMENT11 VARCHAR2,
44 X_ITEM_SEGMENT12 VARCHAR2,
45 X_ITEM_SEGMENT13 VARCHAR2,
46 X_ITEM_SEGMENT14 VARCHAR2,
47 X_ITEM_SEGMENT15 VARCHAR2,
48 X_ITEM_SEGMENT16 VARCHAR2,
49 X_ITEM_SEGMENT17 VARCHAR2,
50 X_ITEM_SEGMENT18 VARCHAR2,
51 X_ITEM_SEGMENT19 VARCHAR2,
52 X_ITEM_SEGMENT20 VARCHAR2,
53 X_DEMAND_HEADER_SEGMENT1 VARCHAR2,
54 X_DEMAND_HEADER_SEGMENT2 VARCHAR2,
55 X_DEMAND_HEADER_SEGMENT3 VARCHAR2,
56 X_DEMAND_HEADER_SEGMENT4 VARCHAR2,
57 X_DEMAND_HEADER_SEGMENT5 VARCHAR2,
58 X_DEMAND_HEADER_SEGMENT6 VARCHAR2,
59 X_DEMAND_HEADER_SEGMENT7 VARCHAR2,
60 X_DEMAND_HEADER_SEGMENT8 VARCHAR2,
61 X_DEMAND_HEADER_SEGMENT9 VARCHAR2,
62 X_DEMAND_HEADER_SEGMENT10 VARCHAR2,
63 X_DEMAND_HEADER_SEGMENT11 VARCHAR2,
64 X_DEMAND_HEADER_SEGMENT12 VARCHAR2,
65 X_DEMAND_HEADER_SEGMENT13 VARCHAR2,
66 X_DEMAND_HEADER_SEGMENT14 VARCHAR2,
67 X_DEMAND_HEADER_SEGMENT15 VARCHAR2,
68 X_DEMAND_HEADER_SEGMENT16 VARCHAR2,
69 X_DEMAND_HEADER_SEGMENT17 VARCHAR2,
70 X_DEMAND_HEADER_SEGMENT18 VARCHAR2,
71 X_DEMAND_HEADER_SEGMENT19 VARCHAR2,
72 X_DEMAND_HEADER_SEGMENT20 VARCHAR2,
73 X_DEMAND_HEADER_SEGMENT21 VARCHAR2,
74 X_DEMAND_HEADER_SEGMENT22 VARCHAR2,
75 X_DEMAND_HEADER_SEGMENT23 VARCHAR2,
76 X_DEMAND_HEADER_SEGMENT24 VARCHAR2,
77 X_DEMAND_HEADER_SEGMENT25 VARCHAR2,
78 X_DEMAND_HEADER_SEGMENT26 VARCHAR2,
79 X_DEMAND_HEADER_SEGMENT27 VARCHAR2,
80 X_DEMAND_HEADER_SEGMENT28 VARCHAR2,
81 X_DEMAND_HEADER_SEGMENT29 VARCHAR2,
82 X_DEMAND_HEADER_SEGMENT30 VARCHAR2,
83 X_EXTERNAL_SOURCE_CODE VARCHAR2,
84 X_EXTERNAL_SOURCE_LINE_ID NUMBER,
85 X_SUPPLY_SOURCE_TYPE NUMBER,
86 X_SUPPLY_HEADER_ID NUMBER,
87 X_USER_LINE_NUM VARCHAR2,
88 X_USER_DELIVERY VARCHAR2,
89 X_REVISION VARCHAR2,
90 X_LOT_NUMBER VARCHAR2,
91 X_SERIAL_NUMBER VARCHAR2,
92 X_SUBINVENTORY VARCHAR2,
93 X_LOCATOR_ID NUMBER,
94 X_LOC_SEGMENT1 VARCHAR2,
95 X_LOC_SEGMENT2 VARCHAR2,
96 X_LOC_SEGMENT3 VARCHAR2,
97 X_LOC_SEGMENT4 VARCHAR2,
98 X_LOC_SEGMENT5 VARCHAR2,
99 X_LOC_SEGMENT6 VARCHAR2,
100 X_LOC_SEGMENT7 VARCHAR2,
101 X_LOC_SEGMENT8 VARCHAR2,
102 X_LOC_SEGMENT9 VARCHAR2,
103 X_LOC_SEGMENT10 VARCHAR2,
104 X_LOC_SEGMENT11 VARCHAR2,
105 X_LOC_SEGMENT12 VARCHAR2,
106 X_LOC_SEGMENT13 VARCHAR2,
107 X_LOC_SEGMENT14 VARCHAR2,
108 X_LOC_SEGMENT15 VARCHAR2,
109 X_LOC_SEGMENT16 VARCHAR2,
110 X_LOC_SEGMENT17 VARCHAR2,
111 X_LOC_SEGMENT18 VARCHAR2,
112 X_LOC_SEGMENT19 VARCHAR2,
113 X_LOC_SEGMENT20 VARCHAR2,
114 X_AUTODETAIL_GROUP_ID NUMBER,
115 X_COMPONENT_SEQUENCE_ID NUMBER,
116 X_PARENT_COMPONENT_SEQ_ID NUMBER,
117 X_RTO_MODEL_SOURCE_LINE VARCHAR2,
118 X_CONFIG_STATUS NUMBER,
119 X_OLD_REVISION VARCHAR2,
120 X_OLD_LOT_NUMBER VARCHAR2,
121 X_OLD_SUBINVENTORY VARCHAR2,
122 X_OLD_LOCATOR_ID NUMBER,
123 X_OLD_LOC_SEGMENT1 VARCHAR2,
124 X_OLD_LOC_SEGMENT2 VARCHAR2,
125 X_OLD_LOC_SEGMENT3 VARCHAR2,
126 X_OLD_LOC_SEGMENT4 VARCHAR2,
127 X_OLD_LOC_SEGMENT5 VARCHAR2,
128 X_OLD_LOC_SEGMENT6 VARCHAR2,
129 X_OLD_LOC_SEGMENT7 VARCHAR2,
130 X_OLD_LOC_SEGMENT8 VARCHAR2,
131 X_OLD_LOC_SEGMENT9 VARCHAR2,
132 X_OLD_LOC_SEGMENT10 VARCHAR2,
133 X_OLD_LOC_SEGMENT11 VARCHAR2,
134 X_OLD_LOC_SEGMENT12 VARCHAR2,
135 X_OLD_LOC_SEGMENT13 VARCHAR2,
136 X_OLD_LOC_SEGMENT14 VARCHAR2,
137 X_OLD_LOC_SEGMENT15 VARCHAR2,
138 X_OLD_LOC_SEGMENT16 VARCHAR2,
139 X_OLD_LOC_SEGMENT17 VARCHAR2,
140 X_OLD_LOC_SEGMENT18 VARCHAR2,
141 X_OLD_LOC_SEGMENT19 VARCHAR2,
142 X_OLD_LOC_SEGMENT20 VARCHAR2,
143 X_DEMAND_CLASS VARCHAR2,
144 X_CUSTOMER_ID NUMBER,
145 X_TERRITORY_ID NUMBER,
146 X_BILL_TO_SITE_USE_ID NUMBER,
147 X_SHIP_TO_SITE_USE_ID NUMBER,
148 X_LOT_EXPIRATION_CUTOFF_DATE DATE,
149 X_PARTIALS_ALLOWED_FLAG NUMBER,
150 X_REQUEST_DATE_ATP_QUANTITY NUMBER,
151 X_EARLIEST_ATP_DATE DATE,
152 X_EARLIEST_ATP_DATE_QUANTITY NUMBER,
153 X_REQUEST_ATP_DATE DATE,
154 X_REQUEST_ATP_DATE_QUANTITY NUMBER,
155 X_GROUP_AVAILABLE_DATE DATE,
156 X_ATP_LEAD_TIME NUMBER,
157 X_INFINITE_TIME_FENCE_DATE DATE,
158 X_GROUP_ATP_CHECK NUMBER,
159 X_BOM_LEVEL NUMBER,
160 X_EXPLOSION_EFFECTIVITY_DATE DATE,
161 X_ATTRIBUTE_CATEGORY VARCHAR2,
162 X_ATTRIBUTE1 VARCHAR2,
163 X_ATTRIBUTE2 VARCHAR2,
164 X_ATTRIBUTE3 VARCHAR2,
165 X_ATTRIBUTE4 VARCHAR2,
166 X_ATTRIBUTE5 VARCHAR2,
167 X_ATTRIBUTE6 VARCHAR2,
168 X_ATTRIBUTE7 VARCHAR2,
169 X_ATTRIBUTE8 VARCHAR2,
170 X_ATTRIBUTE9 VARCHAR2,
171 X_ATTRIBUTE10 VARCHAR2,
172 X_ATTRIBUTE11 VARCHAR2,
173 X_ATTRIBUTE12 VARCHAR2,
174 X_ATTRIBUTE13 VARCHAR2,
175 X_ATTRIBUTE14 VARCHAR2,
176 X_ATTRIBUTE15 VARCHAR2,
177 X_C_COLUMN1 VARCHAR2,
178 X_C_COLUMN2 VARCHAR2,
179 X_C_COLUMN3 VARCHAR2,
180 X_C_COLUMN4 VARCHAR2,
181 X_C_COLUMN5 VARCHAR2,
182 X_C_COLUMN6 VARCHAR2,
183 X_C_COLUMN7 VARCHAR2,
184 X_C_COLUMN8 VARCHAR2,
185 X_N_COLUMN1 NUMBER,
186 X_N_COLUMN2 NUMBER,
187 X_N_COLUMN3 NUMBER,
188 X_N_COLUMN4 NUMBER,
189 X_N_COLUMN5 NUMBER,
190 X_D_COLUMN1 DATE,
191 X_D_COLUMN2 DATE,
192 X_D_COLUMN3 DATE,
193 X_D_COLUMN4 DATE,
194 X_D_COLUMN5 DATE,
195 X_TRANSACTION_PROCESS_ORDER NUMBER,
196 X_DEMAND_ID NUMBER,
197 X_DEMAND_SOURCE_NAME VARCHAR2,
198 X_DEMAND_TYPE NUMBER,
199 X_AVAILABLE_TO_RESERVE NUMBER,
200 X_QUANTITY_ON_HAND NUMBER,
201 X_ATP_COMPONENTS_FLAG NUMBER,
202 X_ATP_CALENDAR_ORGANIZATION_ID NUMBER,
203 X_AUTODETAIL_EXPENSE_SUBINV NUMBER
204 ) IS
205 CURSOR C IS
206 SELECT *
207 FROM mtl_demand_interface
208 WHERE rowid = X_Rowid
209 FOR UPDATE NOWAIT;
210 Recinfo C%ROWTYPE;
211 RECORD_CHANGED EXCEPTION;
212
213 BEGIN
214 OPEN C;
215 FETCH C INTO Recinfo;
216 if (C%NOTFOUND) then
217 CLOSE C;
218 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
219 APP_EXCEPTION.Raise_Exception;
220 end if;
221 CLOSE C;
222 if not (
223 ( (Recinfo.schedule_group_id = X_schedule_group_id)
224 OR ( (Recinfo.schedule_group_id IS NULL)
225 AND (X_schedule_group_id IS NULL)))
226 AND ( (Recinfo.Demand_Source_Type = X_Demand_Source_Type)
227 OR ( (Recinfo.Demand_Source_Type IS NULL)
228 AND (X_Demand_Source_Type IS NULL)))
229 AND ( (Recinfo.Demand_Source_Header_Id = X_Demand_Source_Header_Id)
230 OR ( (Recinfo.Demand_Source_Header_Id IS NULL)
231 AND (X_Demand_Source_Header_Id IS NULL)))
232 AND ( (Recinfo.Demand_Source_Line = X_Demand_Source_Line)
233 OR ( (Recinfo.Demand_Source_Line IS NULL)
234 AND (X_Demand_Source_Line IS NULL)))
238 AND ( (Recinfo.Atp_Check = X_Atp_Check)
235 AND ( (Recinfo.Demand_Source_Delivery = X_Demand_Source_Delivery)
236 OR ( (Recinfo.Demand_Source_Delivery IS NULL)
237 AND (X_Demand_Source_Delivery IS NULL)))
239 OR ( (Recinfo.Atp_Check IS NULL)
240 AND (X_Atp_Check IS NULL)))
241 AND ( (Recinfo.Action_Code = X_Action_Code)
242 OR ( (Recinfo.Action_Code IS NULL)
243 AND (X_Action_Code IS NULL)))
244 AND ( (Recinfo.Validate_Rows = X_Validate_Rows)
245 OR ( (Recinfo.Validate_Rows IS NULL)
246 AND (X_Validate_Rows IS NULL)))
247 AND ( (Recinfo.Transaction_Mode = X_Transaction_Mode)
248 OR ( (Recinfo.Transaction_Mode IS NULL)
249 AND (X_Transaction_Mode IS NULL)))
250 AND ( (Recinfo.Process_Flag = X_Process_Flag)
251 OR ( (Recinfo.Process_Flag IS NULL)
252 AND (X_Process_Flag IS NULL)))
253 AND ( (Recinfo.Single_Lot_Flag = X_Single_Lot_Flag)
254 OR ( (Recinfo.Single_Lot_Flag IS NULL)
255 AND (X_Single_Lot_Flag IS NULL)))
256 AND ( (Recinfo.Detail_Reserve_Flag = X_Detail_Reserve_Flag)
257 OR ( (Recinfo.Detail_Reserve_Flag IS NULL)
258 AND (X_Detail_Reserve_Flag IS NULL)))
259 AND ( (Recinfo.Reserve_Level = X_Reserve_Level)
260 OR ( (Recinfo.Reserve_Level IS NULL)
261 AND (X_Reserve_Level IS NULL)))
262 AND ( (Recinfo.Check_Atr = X_Check_Atr)
263 OR ( (Recinfo.Check_Atr IS NULL)
264 AND (X_Check_Atr IS NULL)))
265 AND ( (Recinfo.Error_Code = X_Error_Code)
266 OR ( (Recinfo.Error_Code IS NULL)
267 AND (X_Error_Code IS NULL)))
268 AND ( (Recinfo.Err_Explanation = X_Err_Explanation)
269 OR ( (Recinfo.Err_Explanation IS NULL)
270 AND (X_Err_Explanation IS NULL)))
271 AND ( (Recinfo.Requirement_Date = X_Requirement_Date)
272 OR ( (Recinfo.Requirement_Date IS NULL)
273 AND (X_Requirement_Date IS NULL)))
274 AND ( (Recinfo.Line_Item_Unit_of_Measure = X_Line_Item_Unit_of_Measure)
275 OR ( (Recinfo.Line_Item_Unit_of_Measure IS NULL)
276 AND (X_Line_Item_Unit_of_Measure IS NULL)))
277 AND ( (Recinfo.Line_Item_UOM = X_Line_Item_UOM)
278 OR ( (Recinfo.Line_Item_UOM IS NULL)
279 AND (X_Line_Item_UOM IS NULL)))
280 AND (Recinfo.Line_Item_Quantity = X_Line_Item_Quantity)
281 AND ( (Recinfo.Line_Item_Reservation_Qty = X_Line_Item_Reservation_Qty)
282 OR ( (Recinfo.Line_Item_Reservation_Qty IS NULL)
283 AND (X_Line_Item_Reservation_Qty IS NULL)))
284 AND ( (Recinfo.Primary_UOM = X_Primary_UOM)
285 OR ( (Recinfo.Primary_UOM IS NULL)
286 AND (X_Primary_UOM IS NULL)))
287 AND ( (Recinfo.Primary_UOM_Quantity = X_Primary_UOM_Quantity)
288 OR ( (Recinfo.Primary_UOM_Quantity IS NULL)
289 AND (X_Primary_UOM_Quantity IS NULL)))
290 AND ( (Recinfo.Reservation_Quantity = X_Reservation_Quantity)
291 OR ( (Recinfo.Reservation_Quantity IS NULL)
292 AND (X_Reservation_Quantity IS NULL)))
293 AND ( (Recinfo.ATP_Rule_Id = X_ATP_Rule_Id)
294 OR ( (Recinfo.ATP_Rule_Id IS NULL)
295 AND (X_ATP_Rule_Id IS NULL)))
296 AND ( (Recinfo.Organization_Id = X_Organization_Id)
297 OR ( (Recinfo.Organization_Id IS NULL)
298 AND (X_Organization_Id IS NULL)))
299 AND ( (Recinfo.Organization_Name = X_Organization_Name)
300 OR ( (Recinfo.Organization_Name IS NULL)
301 AND (X_Organization_Name IS NULL)))
302 AND ( (Recinfo.Inventory_Item_Id = X_Inventory_Item_Id)
303 OR ( (Recinfo.Inventory_Item_Id IS NULL)
304 AND (X_Inventory_Item_Id IS NULL)))
305 AND ( (Recinfo.Item_Segment1 = X_Item_Segment1)
306 OR ( (Recinfo.Item_Segment1 IS NULL)
307 AND (X_Item_Segment1 IS NULL)))
308 AND ( (Recinfo.Item_Segment2 = X_Item_Segment2)
309 OR ( (Recinfo.Item_Segment2 IS NULL)
310 AND (X_Item_Segment2 IS NULL)))
311 AND ( (Recinfo.Item_Segment3 = X_Item_Segment3)
312 OR ( (Recinfo.Item_Segment3 IS NULL)
313 AND (X_Item_Segment3 IS NULL)))
314 AND ( (Recinfo.Item_Segment4 = X_Item_Segment4)
315 OR ( (Recinfo.Item_Segment4 IS NULL)
316 AND (X_Item_Segment4 IS NULL)))
317 AND ( (Recinfo.Item_Segment5 = X_Item_Segment5)
318 OR ( (Recinfo.Item_Segment5 IS NULL)
319 AND (X_Item_Segment5 IS NULL)))
320 AND ( (Recinfo.Item_Segment6 = X_Item_Segment6)
321 OR ( (Recinfo.Item_Segment6 IS NULL)
322 AND (X_Item_Segment6 IS NULL)))
323 AND ( (Recinfo.Item_Segment7 = X_Item_Segment7)
324 OR ( (Recinfo.Item_Segment7 IS NULL)
325 AND (X_Item_Segment7 IS NULL)))
326 AND ( (Recinfo.Item_Segment8 = X_Item_Segment8)
327 OR ( (Recinfo.Item_Segment8 IS NULL)
328 AND (X_Item_Segment8 IS NULL)))
329 AND ( (Recinfo.Item_Segment9 = X_Item_Segment9)
330 OR ( (Recinfo.Item_Segment9 IS NULL)
331 AND (X_Item_Segment9 IS NULL)))
332 AND ( (Recinfo.Item_Segment10 = X_Item_Segment10)
336 OR ( (Recinfo.Item_Segment11 IS NULL)
333 OR ( (Recinfo.Item_Segment10 IS NULL)
334 AND (X_Item_Segment10 IS NULL)))
335 AND ( (Recinfo.Item_Segment11 = X_Item_Segment11)
337 AND (X_Item_Segment11 IS NULL)))
338 AND ( (Recinfo.Item_Segment12 = X_Item_Segment12)
339 OR ( (Recinfo.Item_Segment12 IS NULL)
340 AND (X_Item_Segment12 IS NULL)))
341 AND ( (Recinfo.Item_Segment13 = X_Item_Segment13)
342 OR ( (Recinfo.Item_Segment13 IS NULL)
343 AND (X_Item_Segment13 IS NULL)))
344 AND ( (Recinfo.Item_Segment14 = X_Item_Segment14)
345 OR ( (Recinfo.Item_Segment14 IS NULL)
346 AND (X_Item_Segment14 IS NULL)))
347 AND ( (Recinfo.Item_Segment15 = X_Item_Segment15)
348 OR ( (Recinfo.Item_Segment15 IS NULL)
349 AND (X_Item_Segment15 IS NULL)))
350 AND ( (Recinfo.Item_Segment16 = X_Item_Segment16)
351 OR ( (Recinfo.Item_Segment16 IS NULL)
352 AND (X_Item_Segment16 IS NULL)))
353 AND ( (Recinfo.Item_Segment17 = X_Item_Segment17)
354 OR ( (Recinfo.Item_Segment17 IS NULL)
355 AND (X_Item_Segment17 IS NULL)))
356 AND ( (Recinfo.Item_Segment18 = X_Item_Segment18)
357 OR ( (Recinfo.Item_Segment18 IS NULL)
358 AND (X_Item_Segment18 IS NULL)))
359 AND ( (Recinfo.Item_Segment19 = X_Item_Segment19)
360 OR ( (Recinfo.Item_Segment19 IS NULL)
361 AND (X_Item_Segment19 IS NULL)))
362 AND ( (Recinfo.Item_Segment20 = X_Item_Segment20)
363 OR ( (Recinfo.Item_Segment20 IS NULL)
364 AND (X_Item_Segment20 IS NULL)))
365 AND ( (Recinfo.Demand_Header_Segment1 = X_Demand_Header_Segment1)
366 OR ( (Recinfo.Demand_Header_Segment1 IS NULL)
367 AND (X_Demand_Header_Segment1 IS NULL)))
368 AND ( (Recinfo.Demand_Header_Segment2 = X_Demand_Header_Segment2)
369 OR ( (Recinfo.Demand_Header_Segment2 IS NULL)
370 AND (X_Demand_Header_Segment2 IS NULL)))
371 AND ( (Recinfo.Demand_Header_Segment3 = X_Demand_Header_Segment3)
372 OR ( (Recinfo.Demand_Header_Segment3 IS NULL)
373 AND (X_Demand_Header_Segment3 IS NULL)))
374 AND ( (Recinfo.Demand_Header_Segment4 = X_Demand_Header_Segment4)
375 OR ( (Recinfo.Demand_Header_Segment4 IS NULL)
376 AND (X_Demand_Header_Segment4 IS NULL)))
377 AND ( (Recinfo.Demand_Header_Segment5 = X_Demand_Header_Segment5)
378 OR ( (Recinfo.Demand_Header_Segment5 IS NULL)
379 AND (X_Demand_Header_Segment5 IS NULL)))
380 AND ( (Recinfo.Demand_Header_Segment6 = X_Demand_Header_Segment6)
381 OR ( (Recinfo.Demand_Header_Segment6 IS NULL)
382 AND (X_Demand_Header_Segment6 IS NULL)))
383 AND ( (Recinfo.Demand_Header_Segment7 = X_Demand_Header_Segment7)
384 OR ( (Recinfo.Demand_Header_Segment7 IS NULL)
385 AND (X_Demand_Header_Segment7 IS NULL)))
386 AND ( (Recinfo.Demand_Header_Segment8 = X_Demand_Header_Segment8)
387 OR ( (Recinfo.Demand_Header_Segment8 IS NULL)
388 AND (X_Demand_Header_Segment8 IS NULL)))
389 AND ( (Recinfo.Demand_Header_Segment9 = X_Demand_Header_Segment9)
390 OR ( (Recinfo.Demand_Header_Segment9 IS NULL)
391 AND (X_Demand_Header_Segment9 IS NULL)))
392 AND ( (Recinfo.Demand_Header_Segment10 = X_Demand_Header_Segment10)
393 OR ( (Recinfo.Demand_Header_Segment10 IS NULL)
394 AND (X_Demand_Header_Segment10 IS NULL)))
395 ) then
396 RAISE RECORD_CHANGED;
397 end if;
398 if not (
399 ( (Recinfo.Demand_Header_Segment11 = X_Demand_Header_Segment11)
400 OR ( (Recinfo.Demand_Header_Segment11 IS NULL)
401 AND (X_Demand_Header_Segment11 IS NULL)))
402 AND ( (Recinfo.Demand_Header_Segment12 = X_Demand_Header_Segment12)
403 OR ( (Recinfo.Demand_Header_Segment12 IS NULL)
404 AND (X_Demand_Header_Segment12 IS NULL)))
405 AND ( (Recinfo.Demand_Header_Segment13 = X_Demand_Header_Segment13)
406 OR ( (Recinfo.Demand_Header_Segment13 IS NULL)
407 AND (X_Demand_Header_Segment13 IS NULL)))
408 AND ( (Recinfo.Demand_Header_Segment14 = X_Demand_Header_Segment14)
409 OR ( (Recinfo.Demand_Header_Segment14 IS NULL)
410 AND (X_Demand_Header_Segment14 IS NULL)))
411 AND ( (Recinfo.Demand_Header_Segment15 = X_Demand_Header_Segment15)
412 OR ( (Recinfo.Demand_Header_Segment15 IS NULL)
413 AND (X_Demand_Header_Segment15 IS NULL)))
414 AND ( (Recinfo.Demand_Header_Segment16 = X_Demand_Header_Segment16)
415 OR ( (Recinfo.Demand_Header_Segment16 IS NULL)
416 AND (X_Demand_Header_Segment16 IS NULL)))
417 AND ( (Recinfo.Demand_Header_Segment17 = X_Demand_Header_Segment17)
418 OR ( (Recinfo.Demand_Header_Segment17 IS NULL)
419 AND (X_Demand_Header_Segment17 IS NULL)))
420 AND ( (Recinfo.Demand_Header_Segment18 = X_Demand_Header_Segment18)
421 OR ( (Recinfo.Demand_Header_Segment18 IS NULL)
422 AND (X_Demand_Header_Segment18 IS NULL)))
423 AND ( (Recinfo.Demand_Header_Segment19 = X_Demand_Header_Segment19)
424 OR ( (Recinfo.Demand_Header_Segment19 IS NULL)
425 AND (X_Demand_Header_Segment19 IS NULL)))
429 AND ( (Recinfo.Demand_Header_Segment21 = X_Demand_Header_Segment21)
426 AND ( (Recinfo.Demand_Header_Segment20 = X_Demand_Header_Segment20)
427 OR ( (Recinfo.Demand_Header_Segment20 IS NULL)
428 AND (X_Demand_Header_Segment20 IS NULL)))
430 OR ( (Recinfo.Demand_Header_Segment21 IS NULL)
431 AND (X_Demand_Header_Segment21 IS NULL)))
432 AND ( (Recinfo.Demand_Header_Segment22 = X_Demand_Header_Segment22)
433 OR ( (Recinfo.Demand_Header_Segment22 IS NULL)
434 AND (X_Demand_Header_Segment22 IS NULL)))
435 AND ( (Recinfo.Demand_Header_Segment23 = X_Demand_Header_Segment23)
436 OR ( (Recinfo.Demand_Header_Segment23 IS NULL)
437 AND (X_Demand_Header_Segment23 IS NULL)))
438 AND ( (Recinfo.Demand_Header_Segment24 = X_Demand_Header_Segment24)
439 OR ( (Recinfo.Demand_Header_Segment24 IS NULL)
440 AND (X_Demand_Header_Segment24 IS NULL)))
441 AND ( (Recinfo.Demand_Header_Segment25 = X_Demand_Header_Segment25)
442 OR ( (Recinfo.Demand_Header_Segment25 IS NULL)
443 AND (X_Demand_Header_Segment25 IS NULL)))
444 AND ( (Recinfo.Demand_Header_Segment26 = X_Demand_Header_Segment26)
445 OR ( (Recinfo.Demand_Header_Segment26 IS NULL)
446 AND (X_Demand_Header_Segment26 IS NULL)))
447 AND ( (Recinfo.Demand_Header_Segment27 = X_Demand_Header_Segment27)
448 OR ( (Recinfo.Demand_Header_Segment27 IS NULL)
449 AND (X_Demand_Header_Segment27 IS NULL)))
450 AND ( (Recinfo.Demand_Header_Segment28 = X_Demand_Header_Segment28)
451 OR ( (Recinfo.Demand_Header_Segment28 IS NULL)
452 AND (X_Demand_Header_Segment28 IS NULL)))
453 AND ( (Recinfo.Demand_Header_Segment29 = X_Demand_Header_Segment29)
454 OR ( (Recinfo.Demand_Header_Segment29 IS NULL)
455 AND (X_Demand_Header_Segment29 IS NULL)))
456 AND ( (Recinfo.Demand_Header_Segment30 = X_Demand_Header_Segment30)
457 OR ( (Recinfo.Demand_Header_Segment30 IS NULL)
458 AND (X_Demand_Header_Segment30 IS NULL)))
459 ) then
460 RAISE RECORD_CHANGED;
461 end if;
462 if not (
463 ( (Recinfo.External_Source_Code = X_External_Source_Code)
464 OR ( (Recinfo.External_Source_Code IS NULL)
465 AND (X_External_Source_Code IS NULL)))
466 AND ( (Recinfo.External_Source_Line_Id = X_External_Source_Line_Id)
467 OR ( (Recinfo.External_Source_Line_Id IS NULL)
468 AND (X_External_Source_Line_Id IS NULL)))
469 AND ( (Recinfo.Supply_Source_Type = X_Supply_Source_Type)
470 OR ( (Recinfo.Supply_Source_Type IS NULL)
471 AND (X_Supply_Source_Type IS NULL)))
472 AND ( (Recinfo.Supply_Header_Id = X_Supply_Header_Id)
473 OR ( (Recinfo.Supply_Header_Id IS NULL)
474 AND (X_Supply_Header_Id IS NULL)))
475 AND ( (Recinfo.User_Line_Num = X_User_Line_Num)
476 OR ( (Recinfo.User_Line_Num IS NULL)
477 AND (X_User_Line_Num IS NULL)))
478 AND ( (Recinfo.User_Delivery = X_User_Delivery)
479 OR ( (Recinfo.User_Delivery IS NULL)
480 AND (X_User_Delivery IS NULL)))
481 AND ( (Recinfo.Revision = X_Revision)
482 OR ( (Recinfo.Revision IS NULL)
483 AND (X_Revision IS NULL)))
484 AND ( (Recinfo.Lot_Number = X_Lot_Number)
485 OR ( (Recinfo.Lot_Number IS NULL)
486 AND (X_Lot_Number IS NULL)))
487 AND ( (Recinfo.Serial_Number = X_Serial_Number)
488 OR ( (Recinfo.Serial_Number IS NULL)
489 AND (X_Serial_Number IS NULL)))
490 AND ( (Recinfo.Subinventory = X_Subinventory)
491 OR ( (Recinfo.Subinventory IS NULL)
492 AND (X_Subinventory IS NULL)))
493 AND ( (Recinfo.Locator_Id = X_Locator_Id)
494 OR ( (Recinfo.Locator_Id IS NULL)
495 AND (X_Locator_Id IS NULL)))
496 AND ( (Recinfo.Loc_Segment1 = X_Loc_Segment1)
497 OR ( (Recinfo.Loc_Segment1 IS NULL)
498 AND (X_Loc_Segment1 IS NULL)))
499 AND ( (Recinfo.Loc_Segment2 = X_Loc_Segment2)
500 OR ( (Recinfo.Loc_Segment2 IS NULL)
501 AND (X_Loc_Segment2 IS NULL)))
502 AND ( (Recinfo.Loc_Segment3 = X_Loc_Segment3)
503 OR ( (Recinfo.Loc_Segment3 IS NULL)
504 AND (X_Loc_Segment3 IS NULL)))
505 AND ( (Recinfo.Loc_Segment4 = X_Loc_Segment4)
506 OR ( (Recinfo.Loc_Segment4 IS NULL)
507 AND (X_Loc_Segment4 IS NULL)))
508 AND ( (Recinfo.Loc_Segment5 = X_Loc_Segment5)
509 OR ( (Recinfo.Loc_Segment5 IS NULL)
510 AND (X_Loc_Segment5 IS NULL)))
511 AND ( (Recinfo.Loc_Segment6 = X_Loc_Segment6)
512 OR ( (Recinfo.Loc_Segment6 IS NULL)
513 AND (X_Loc_Segment6 IS NULL)))
514 AND ( (Recinfo.Loc_Segment7 = X_Loc_Segment7)
515 OR ( (Recinfo.Loc_Segment7 IS NULL)
516 AND (X_Loc_Segment7 IS NULL)))
517 AND ( (Recinfo.Loc_Segment8 = X_Loc_Segment8)
518 OR ( (Recinfo.Loc_Segment8 IS NULL)
519 AND (X_Loc_Segment8 IS NULL)))
520 AND ( (Recinfo.Loc_Segment9 = X_Loc_Segment9)
521 OR ( (Recinfo.Loc_Segment9 IS NULL)
522 AND (X_Loc_Segment9 IS NULL)))
526 AND ( (Recinfo.Loc_Segment11 = X_Loc_Segment11)
523 AND ( (Recinfo.Loc_Segment10 = X_Loc_Segment10)
524 OR ( (Recinfo.Loc_Segment10 IS NULL)
525 AND (X_Loc_Segment10 IS NULL)))
527 OR ( (Recinfo.Loc_Segment11 IS NULL)
528 AND (X_Loc_Segment11 IS NULL)))
529 AND ( (Recinfo.Loc_Segment12 = X_Loc_Segment12)
530 OR ( (Recinfo.Loc_Segment12 IS NULL)
531 AND (X_Loc_Segment12 IS NULL)))
532 AND ( (Recinfo.Loc_Segment13 = X_Loc_Segment13)
533 OR ( (Recinfo.Loc_Segment13 IS NULL)
534 AND (X_Loc_Segment13 IS NULL)))
535 AND ( (Recinfo.Loc_Segment14 = X_Loc_Segment14)
536 OR ( (Recinfo.Loc_Segment14 IS NULL)
537 AND (X_Loc_Segment14 IS NULL)))
538 AND ( (Recinfo.Loc_Segment15 = X_Loc_Segment15)
539 OR ( (Recinfo.Loc_Segment15 IS NULL)
540 AND (X_Loc_Segment15 IS NULL)))
541 AND ( (Recinfo.Loc_Segment16 = X_Loc_Segment16)
542 OR ( (Recinfo.Loc_Segment16 IS NULL)
543 AND (X_Loc_Segment16 IS NULL)))
544 AND ( (Recinfo.Loc_Segment17 = X_Loc_Segment17)
545 OR ( (Recinfo.Loc_Segment17 IS NULL)
546 AND (X_Loc_Segment17 IS NULL)))
547 AND ( (Recinfo.Loc_Segment18 = X_Loc_Segment18)
548 OR ( (Recinfo.Loc_Segment18 IS NULL)
549 AND (X_Loc_Segment18 IS NULL)))
550 AND ( (Recinfo.Loc_Segment19 = X_Loc_Segment19)
551 OR ( (Recinfo.Loc_Segment19 IS NULL)
552 AND (X_Loc_Segment19 IS NULL)))
553 AND ( (Recinfo.Loc_Segment20 = X_Loc_Segment20)
554 OR ( (Recinfo.Loc_Segment20 IS NULL)
555 AND (X_Loc_Segment20 IS NULL)))
556 AND ( (Recinfo.Autodetail_Group_Id = X_Autodetail_Group_Id)
557 OR ( (Recinfo.Autodetail_Group_Id IS NULL)
558 AND (X_Autodetail_Group_Id IS NULL)))
559 AND ( (Recinfo.Component_Sequence_Id = X_Component_Sequence_Id)
560 OR ( (Recinfo.Component_Sequence_Id IS NULL)
561 AND (X_Component_Sequence_Id IS NULL)))
562 AND ( (Recinfo.Parent_Component_Seq_Id = X_Parent_Component_Seq_Id)
563 OR ( (Recinfo.Parent_Component_Seq_Id IS NULL)
564 AND (X_Parent_Component_Seq_Id IS NULL)))
565 AND ( (Recinfo.RTO_Model_Source_Line = X_RTO_Model_Source_Line)
566 OR ( (Recinfo.RTO_Model_Source_Line IS NULL)
567 AND (X_RTO_Model_Source_Line IS NULL)))
568 AND ( (Recinfo.Config_Status = X_Config_Status)
569 OR ( (Recinfo.Config_Status IS NULL)
570 AND (X_Config_Status IS NULL)))
571 AND ( (Recinfo.Old_Revision = X_Old_Revision)
572 OR ( (Recinfo.Old_Revision IS NULL)
573 AND (X_Old_Revision IS NULL)))
574 AND ( (Recinfo.Old_Lot_Number = X_Old_Lot_Number)
575 OR ( (Recinfo.Old_Lot_Number IS NULL)
576 AND (X_Old_Lot_Number IS NULL)))
577 AND ( (Recinfo.Old_Subinventory = X_Old_Subinventory)
578 OR ( (Recinfo.Old_Subinventory IS NULL)
579 AND (X_Old_Subinventory IS NULL)))
580 AND ( (Recinfo.Old_Locator_Id = X_Old_Locator_Id)
581 OR ( (Recinfo.Old_Locator_Id IS NULL)
582 AND (X_Old_Locator_Id IS NULL)))
583 ) then
584 RAISE RECORD_CHANGED;
585 end if;
586 if not (
587 ( (Recinfo.Old_Loc_Segment1 = X_Old_Loc_Segment1)
588 OR ( (Recinfo.Old_Loc_Segment1 IS NULL)
589 AND (X_Old_Loc_Segment1 IS NULL)))
590 AND ( (Recinfo.Old_Loc_Segment2 = X_Old_Loc_Segment2)
591 OR ( (Recinfo.Old_Loc_Segment2 IS NULL)
592 AND (X_Old_Loc_Segment2 IS NULL)))
593 AND ( (Recinfo.Old_Loc_Segment3 = X_Old_Loc_Segment3)
594 OR ( (Recinfo.Old_Loc_Segment3 IS NULL)
595 AND (X_Old_Loc_Segment3 IS NULL)))
596 AND ( (Recinfo.Old_Loc_Segment4 = X_Old_Loc_Segment4)
597 OR ( (Recinfo.Old_Loc_Segment4 IS NULL)
598 AND (X_Old_Loc_Segment4 IS NULL)))
599 AND ( (Recinfo.Old_Loc_Segment5 = X_Old_Loc_Segment5)
600 OR ( (Recinfo.Old_Loc_Segment5 IS NULL)
601 AND (X_Old_Loc_Segment5 IS NULL)))
602 AND ( (Recinfo.Old_Loc_Segment6 = X_Old_Loc_Segment6)
603 OR ( (Recinfo.Old_Loc_Segment6 IS NULL)
604 AND (X_Old_Loc_Segment6 IS NULL)))
605 AND ( (Recinfo.Old_Loc_Segment7 = X_Old_Loc_Segment7)
606 OR ( (Recinfo.Old_Loc_Segment7 IS NULL)
607 AND (X_Old_Loc_Segment7 IS NULL)))
608 AND ( (Recinfo.Old_Loc_Segment8 = X_Old_Loc_Segment8)
609 OR ( (Recinfo.Old_Loc_Segment8 IS NULL)
610 AND (X_Old_Loc_Segment8 IS NULL)))
611 AND ( (Recinfo.Old_Loc_Segment9 = X_Old_Loc_Segment9)
612 OR ( (Recinfo.Old_Loc_Segment9 IS NULL)
613 AND (X_Old_Loc_Segment9 IS NULL)))
614 AND ( (Recinfo.Old_Loc_Segment10 = X_Old_Loc_Segment10)
615 OR ( (Recinfo.Old_Loc_Segment10 IS NULL)
616 AND (X_Old_Loc_Segment10 IS NULL)))
617 AND ( (Recinfo.Old_Loc_Segment11 = X_Old_Loc_Segment11)
618 OR ( (Recinfo.Old_Loc_Segment11 IS NULL)
619 AND (X_Old_Loc_Segment11 IS NULL)))
620 AND ( (Recinfo.Old_Loc_Segment12 = X_Old_Loc_Segment12)
621 OR ( (Recinfo.Old_Loc_Segment12 IS NULL)
625 AND (X_Old_Loc_Segment13 IS NULL)))
622 AND (X_Old_Loc_Segment12 IS NULL)))
623 AND ( (Recinfo.Old_Loc_Segment13 = X_Old_Loc_Segment13)
624 OR ( (Recinfo.Old_Loc_Segment13 IS NULL)
626 AND ( (Recinfo.Old_Loc_Segment14 = X_Old_Loc_Segment14)
627 OR ( (Recinfo.Old_Loc_Segment14 IS NULL)
628 AND (X_Old_Loc_Segment14 IS NULL)))
629 AND ( (Recinfo.Old_Loc_Segment15 = X_Old_Loc_Segment15)
630 OR ( (Recinfo.Old_Loc_Segment15 IS NULL)
631 AND (X_Old_Loc_Segment15 IS NULL)))
632 AND ( (Recinfo.Old_Loc_Segment16 = X_Old_Loc_Segment16)
633 OR ( (Recinfo.Old_Loc_Segment16 IS NULL)
634 AND (X_Old_Loc_Segment16 IS NULL)))
635 AND ( (Recinfo.Old_Loc_Segment17 = X_Old_Loc_Segment17)
636 OR ( (Recinfo.Old_Loc_Segment17 IS NULL)
637 AND (X_Old_Loc_Segment17 IS NULL)))
638 AND ( (Recinfo.Old_Loc_Segment18 = X_Old_Loc_Segment18)
639 OR ( (Recinfo.Old_Loc_Segment18 IS NULL)
640 AND (X_Old_Loc_Segment18 IS NULL)))
641 AND ( (Recinfo.Old_Loc_Segment19 = X_Old_Loc_Segment19)
642 OR ( (Recinfo.Old_Loc_Segment19 IS NULL)
643 AND (X_Old_Loc_Segment19 IS NULL)))
644 AND ( (Recinfo.Old_Loc_Segment20 = X_Old_Loc_Segment20)
645 OR ( (Recinfo.Old_Loc_Segment20 IS NULL)
646 AND (X_Old_Loc_Segment20 IS NULL)))
647 AND ( (Recinfo.Demand_Class = X_Demand_Class)
648 OR ( (Recinfo.Demand_Class IS NULL)
649 AND (X_Demand_Class IS NULL)))
650 AND ( (Recinfo.Customer_Id = X_Customer_Id)
651 OR ( (Recinfo.Customer_Id IS NULL)
652 AND (X_Customer_Id IS NULL)))
653 AND ( (Recinfo.Territory_Id = X_Territory_Id)
654 OR ( (Recinfo.Territory_Id IS NULL)
655 AND (X_Territory_Id IS NULL)))
656 AND ( (Recinfo.Bill_to_Site_Use_Id = X_Bill_to_Site_Use_Id)
657 OR ( (Recinfo.Bill_to_Site_Use_Id IS NULL)
658 AND (X_Bill_to_Site_Use_Id IS NULL)))
659 AND ( (Recinfo.Ship_to_Site_Use_Id = X_Ship_to_Site_Use_Id)
660 OR ( (Recinfo.Ship_to_Site_Use_Id IS NULL)
661 AND (X_Ship_to_Site_Use_Id IS NULL)))
662 AND ( (Recinfo.Lot_Expiration_Cutoff_Date = X_Lot_Expiration_Cutoff_Date)
663 OR ( (Recinfo.Lot_Expiration_Cutoff_Date IS NULL)
664 AND (X_Lot_Expiration_Cutoff_Date IS NULL)))
665 AND ( (Recinfo.Partials_Allowed_Flag = X_Partials_Allowed_Flag)
666 OR ( (Recinfo.Partials_Allowed_Flag IS NULL)
667 AND (X_Partials_Allowed_Flag IS NULL)))
668 AND ( (Recinfo.Request_Date_ATP_Quantity = X_Request_Date_ATP_Quantity)
669 OR ( (Recinfo.Request_Date_ATP_Quantity IS NULL)
670 AND (X_Request_Date_ATP_Quantity IS NULL)))
671 AND ( (Recinfo.Earliest_ATP_Date = X_Earliest_ATP_Date)
672 OR ( (Recinfo.Earliest_ATP_Date IS NULL)
673 AND (X_Earliest_ATP_Date IS NULL)))
674 AND ( (Recinfo.Earliest_ATP_Date_Quantity = X_Earliest_ATP_Date_Quantity)
675 OR ( (Recinfo.Earliest_ATP_Date_Quantity IS NULL)
676 AND (X_Earliest_ATP_Date_Quantity IS NULL)))
677 AND ( (Recinfo.Request_ATP_Date = X_Request_ATP_Date)
678 OR ( (Recinfo.Request_ATP_Date IS NULL)
679 AND (X_Request_ATP_Date IS NULL)))
680 AND ( (Recinfo.Request_ATP_Date_Quantity = X_Request_ATP_Date_Quantity)
681 OR ( (Recinfo.Request_ATP_Date_Quantity IS NULL)
682 AND (X_Request_ATP_Date_Quantity IS NULL)))
683 AND ( (Recinfo.Group_Available_Date = X_Group_Available_Date)
684 OR ( (Recinfo.Group_Available_Date IS NULL)
685 AND (X_Group_Available_Date IS NULL)))
686 AND ( (Recinfo.ATP_Lead_Time = X_ATP_Lead_Time)
687 OR ( (Recinfo.ATP_Lead_Time IS NULL)
688 AND (X_ATP_Lead_Time IS NULL)))
689 AND ( (Recinfo.Infinite_Time_Fence_Date = X_Infinite_Time_Fence_Date)
690 OR ( (Recinfo.Infinite_Time_Fence_Date IS NULL)
691 AND (X_Infinite_Time_Fence_Date IS NULL)))
692 AND ( (Recinfo.Group_ATP_Check = X_Group_ATP_Check)
693 OR ( (Recinfo.Group_ATP_Check IS NULL)
694 AND (X_Group_ATP_Check IS NULL)))
695 AND ( (Recinfo.BOM_Level = X_BOM_Level)
696 OR ( (Recinfo.BOM_Level IS NULL)
697 AND (X_BOM_Level IS NULL)))
698 AND ( (Recinfo.Explosion_Effectivity_Date = X_Explosion_Effectivity_Date)
699 OR ( (Recinfo.Explosion_Effectivity_Date IS NULL)
700 AND (X_Explosion_Effectivity_Date IS NULL)))
701 AND ( (Recinfo.Attribute_Category = X_Attribute_Category)
702 OR ( (Recinfo.Attribute_Category IS NULL)
703 AND (X_Attribute_Category IS NULL)))
704 ) then
705 RAISE RECORD_CHANGED;
706 end if;
707 if not (
708 ( (Recinfo.Attribute1 = X_Attribute1)
709 OR ( (Recinfo.Attribute1 IS NULL)
710 AND (X_Attribute1 IS NULL)))
711 AND ( (Recinfo.Attribute2 = X_Attribute2)
712 OR ( (Recinfo.Attribute2 IS NULL)
713 AND (X_Attribute2 IS NULL)))
714 AND ( (Recinfo.Attribute3 = X_Attribute3)
715 OR ( (Recinfo.Attribute3 IS NULL)
716 AND (X_Attribute3 IS NULL)))
717 AND ( (Recinfo.Attribute4 = X_Attribute4)
721 OR ( (Recinfo.Attribute5 IS NULL)
718 OR ( (Recinfo.Attribute4 IS NULL)
719 AND (X_Attribute4 IS NULL)))
720 AND ( (Recinfo.Attribute5 = X_Attribute5)
722 AND (X_Attribute5 IS NULL)))
723 AND ( (Recinfo.Attribute6 = X_Attribute6)
724 OR ( (Recinfo.Attribute6 IS NULL)
725 AND (X_Attribute6 IS NULL)))
726 AND ( (Recinfo.Attribute7 = X_Attribute7)
727 OR ( (Recinfo.Attribute7 IS NULL)
728 AND (X_Attribute7 IS NULL)))
729 AND ( (Recinfo.Attribute8 = X_Attribute8)
730 OR ( (Recinfo.Attribute8 IS NULL)
731 AND (X_Attribute8 IS NULL)))
732 AND ( (Recinfo.Attribute9 = X_Attribute9)
733 OR ( (Recinfo.Attribute9 IS NULL)
734 AND (X_Attribute9 IS NULL)))
735 AND ( (Recinfo.Attribute10 = X_Attribute10)
736 OR ( (Recinfo.Attribute10 IS NULL)
737 AND (X_Attribute10 IS NULL)))
738 AND ( (Recinfo.Attribute11 = X_Attribute11)
739 OR ( (Recinfo.Attribute11 IS NULL)
740 AND (X_Attribute11 IS NULL)))
741 AND ( (Recinfo.Attribute12 = X_Attribute12)
742 OR ( (Recinfo.Attribute12 IS NULL)
743 AND (X_Attribute12 IS NULL)))
744 AND ( (Recinfo.Attribute13 = X_Attribute13)
745 OR ( (Recinfo.Attribute13 IS NULL)
746 AND (X_Attribute13 IS NULL)))
747 AND ( (Recinfo.Attribute14 = X_Attribute14)
748 OR ( (Recinfo.Attribute14 IS NULL)
749 AND (X_Attribute14 IS NULL)))
750 AND ( (Recinfo.Attribute15 = X_Attribute15)
751 OR ( (Recinfo.Attribute15 IS NULL)
752 AND (X_Attribute15 IS NULL)))
753 AND ( (Recinfo.C_Column1 = X_C_Column1)
754 OR ( (Recinfo.C_Column1 IS NULL)
755 AND (X_C_Column1 IS NULL)))
756 AND ( (Recinfo.C_Column2 = X_C_Column2)
757 OR ( (Recinfo.C_Column2 IS NULL)
758 AND (X_C_Column2 IS NULL)))
759 AND ( (Recinfo.C_Column3 = X_C_Column3)
760 OR ( (Recinfo.C_Column3 IS NULL)
761 AND (X_C_Column3 IS NULL)))
762 AND ( (Recinfo.C_Column4 = X_C_Column4)
763 OR ( (Recinfo.C_Column4 IS NULL)
764 AND (X_C_Column4 IS NULL)))
765 AND ( (Recinfo.C_Column5 = X_C_Column5)
766 OR ( (Recinfo.C_Column5 IS NULL)
767 AND (X_C_Column5 IS NULL)))
768 AND ( (Recinfo.C_Column6 = X_C_Column6)
769 OR ( (Recinfo.C_Column6 IS NULL)
770 AND (X_C_Column6 IS NULL)))
771 AND ( (Recinfo.C_Column7 = X_C_Column7)
772 OR ( (Recinfo.C_Column7 IS NULL)
773 AND (X_C_Column7 IS NULL)))
774 AND ( (Recinfo.C_Column8 = X_C_Column8)
775 OR ( (Recinfo.C_Column8 IS NULL)
776 AND (X_C_Column8 IS NULL)))
777 AND ( (Recinfo.N_Column1 = X_N_Column1)
778 OR ( (Recinfo.N_Column1 IS NULL)
779 AND (X_N_Column2 IS NULL)))
780 AND ( (Recinfo.N_Column2 = X_N_Column2)
781 OR ( (Recinfo.N_Column2 IS NULL)
782 AND (X_N_Column3 IS NULL)))
783 AND ( (Recinfo.N_Column3 = X_N_Column3)
784 OR ( (Recinfo.N_Column3 IS NULL)
785 AND (X_N_Column3 IS NULL)))
786 AND ( (Recinfo.N_Column4 = X_N_Column4)
787 OR ( (Recinfo.N_Column4 IS NULL)
788 AND (X_N_Column4 IS NULL)))
789 AND ( (Recinfo.N_Column5 = X_N_Column5)
790 OR ( (Recinfo.N_Column5 IS NULL)
791 AND (X_N_Column5 IS NULL)))
792 AND ( (Recinfo.D_Column1 = X_D_Column1)
793 OR ( (Recinfo.D_Column1 IS NULL)
794 AND (X_D_Column2 IS NULL)))
795 AND ( (Recinfo.D_Column2 = X_D_Column2)
796 OR ( (Recinfo.D_Column2 IS NULL)
797 AND (X_D_Column3 IS NULL)))
798 AND ( (Recinfo.D_Column3 = X_D_Column3)
799 OR ( (Recinfo.D_Column3 IS NULL)
800 AND (X_D_Column3 IS NULL)))
801 AND ( (Recinfo.D_Column4 = X_D_Column4)
802 OR ( (Recinfo.D_Column4 IS NULL)
803 AND (X_D_Column4 IS NULL)))
804 AND ( (Recinfo.D_Column5 = X_D_Column5)
805 OR ( (Recinfo.D_Column5 IS NULL)
806 AND (X_D_Column5 IS NULL)))
807 AND ( (Recinfo.Transaction_Process_Order = X_Transaction_Process_Order)
808 OR ( (Recinfo.Transaction_Process_Order IS NULL)
809 AND (X_Transaction_Process_Order IS NULL)))
810 AND ( (Recinfo.Demand_Id = X_Demand_Id)
811 OR ( (Recinfo.Demand_Id IS NULL)
812 AND (X_Demand_Id IS NULL)))
813 AND ( (Recinfo.Demand_Source_Name = X_Demand_Source_Name)
814 OR ( (Recinfo.Demand_Source_Name IS NULL)
815 AND (X_Demand_Source_Name IS NULL)))
816 AND ( (Recinfo.Demand_Type = X_Demand_Type)
817 OR ( (Recinfo.Demand_Type IS NULL)
818 AND (X_Demand_Type IS NULL)))
819 AND ( (Recinfo.Available_to_Reserve = X_Available_to_Reserve)
820 OR ( (Recinfo.Available_to_Reserve IS NULL)
821 AND (X_Available_to_Reserve IS NULL)))
822 AND ( (Recinfo.Quantity_on_Hand = X_Quantity_on_Hand)
823 OR ( (Recinfo.Quantity_on_Hand IS NULL)
827 AND (X_ATP_Components_Flag IS NULL)))
824 AND (X_Quantity_on_Hand IS NULL)))
825 AND ( (Recinfo.ATP_Components_Flag = X_ATP_Components_Flag)
826 OR ( (Recinfo.ATP_Components_Flag IS NULL)
828 AND ( (Recinfo.ATP_Calendar_Organization_Id = X_ATP_Calendar_Organization_Id)
829 OR ( (Recinfo.ATP_Calendar_Organization_Id IS NULL)
830 AND (X_ATP_Calendar_Organization_Id IS NULL)))
831 AND ( (Recinfo.Autodetail_Expense_Subinv_Flag = X_Autodetail_Expense_Subinv)
832 OR ( (Recinfo.Autodetail_Expense_Subinv_Flag IS NULL)
833 AND (X_Autodetail_Expense_Subinv IS NULL)))
834 ) then
835 RAISE RECORD_CHANGED;
836 end if;
837 exception
838 WHEN RECORD_CHANGED then
839 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
840 APP_EXCEPTION.Raise_Exception;
841 WHEN OTHERS then
842 raise;
843 END Lock_Row;
844
845
846 PROCEDURE Update_Row( X_ROWID VARCHAR2,
847 X_SCHEDULE_GROUP_ID NUMBER,
848 X_DEMAND_SOURCE_TYPE NUMBER,
849 X_DEMAND_SOURCE_HEADER_ID NUMBER,
850 X_DEMAND_SOURCE_LINE VARCHAR2,
851 X_DEMAND_SOURCE_DELIVERY VARCHAR2,
852 X_ATP_CHECK NUMBER,
853 X_ACTION_CODE NUMBER,
854 X_VALIDATE_ROWS NUMBER,
855 X_TRANSACTION_MODE NUMBER,
856 X_PROCESS_FLAG NUMBER,
857 X_SINGLE_LOT_FLAG NUMBER,
858 X_DETAIL_RESERVE_FLAG NUMBER,
859 X_RESERVE_LEVEL NUMBER,
860 X_CHECK_ATR NUMBER,
861 X_LAST_UPDATE_DATE DATE,
862 X_LAST_UPDATED_BY NUMBER,
863 X_LAST_UPDATE_LOGIN NUMBER,
864 X_ERROR_CODE NUMBER,
865 X_ERR_EXPLANATION VARCHAR2,
866 X_REQUIREMENT_DATE DATE,
867 X_LINE_ITEM_UNIT_OF_MEASURE VARCHAR2,
868 X_LINE_ITEM_UOM VARCHAR2,
869 X_LINE_ITEM_QUANTITY NUMBER,
870 X_LINE_ITEM_RESERVATION_QTY NUMBER,
871 X_PRIMARY_UOM VARCHAR2,
872 X_PRIMARY_UOM_QUANTITY NUMBER,
873 X_RESERVATION_QUANTITY NUMBER,
874 X_ATP_RULE_ID NUMBER,
875 X_ORGANIZATION_ID NUMBER,
876 X_ORGANIZATION_NAME VARCHAR2,
877 X_INVENTORY_ITEM_ID NUMBER,
878 X_ITEM_SEGMENT1 VARCHAR2,
879 X_ITEM_SEGMENT2 VARCHAR2,
880 X_ITEM_SEGMENT3 VARCHAR2,
881 X_ITEM_SEGMENT4 VARCHAR2,
882 X_ITEM_SEGMENT5 VARCHAR2,
883 X_ITEM_SEGMENT6 VARCHAR2,
884 X_ITEM_SEGMENT7 VARCHAR2,
885 X_ITEM_SEGMENT8 VARCHAR2,
886 X_ITEM_SEGMENT9 VARCHAR2,
887 X_ITEM_SEGMENT10 VARCHAR2,
888 X_ITEM_SEGMENT11 VARCHAR2,
889 X_ITEM_SEGMENT12 VARCHAR2,
890 X_ITEM_SEGMENT13 VARCHAR2,
891 X_ITEM_SEGMENT14 VARCHAR2,
892 X_ITEM_SEGMENT15 VARCHAR2,
893 X_ITEM_SEGMENT16 VARCHAR2,
894 X_ITEM_SEGMENT17 VARCHAR2,
895 X_ITEM_SEGMENT18 VARCHAR2,
896 X_ITEM_SEGMENT19 VARCHAR2,
897 X_ITEM_SEGMENT20 VARCHAR2,
898 X_DEMAND_HEADER_SEGMENT1 VARCHAR2,
899 X_DEMAND_HEADER_SEGMENT2 VARCHAR2,
900 X_DEMAND_HEADER_SEGMENT3 VARCHAR2,
901 X_DEMAND_HEADER_SEGMENT4 VARCHAR2,
902 X_DEMAND_HEADER_SEGMENT5 VARCHAR2,
903 X_DEMAND_HEADER_SEGMENT6 VARCHAR2,
904 X_DEMAND_HEADER_SEGMENT7 VARCHAR2,
905 X_DEMAND_HEADER_SEGMENT8 VARCHAR2,
906 X_DEMAND_HEADER_SEGMENT9 VARCHAR2,
907 X_DEMAND_HEADER_SEGMENT10 VARCHAR2,
908 X_DEMAND_HEADER_SEGMENT11 VARCHAR2,
909 X_DEMAND_HEADER_SEGMENT12 VARCHAR2,
910 X_DEMAND_HEADER_SEGMENT13 VARCHAR2,
911 X_DEMAND_HEADER_SEGMENT14 VARCHAR2,
912 X_DEMAND_HEADER_SEGMENT15 VARCHAR2,
913 X_DEMAND_HEADER_SEGMENT16 VARCHAR2,
914 X_DEMAND_HEADER_SEGMENT17 VARCHAR2,
915 X_DEMAND_HEADER_SEGMENT18 VARCHAR2,
916 X_DEMAND_HEADER_SEGMENT19 VARCHAR2,
917 X_DEMAND_HEADER_SEGMENT20 VARCHAR2,
918 X_DEMAND_HEADER_SEGMENT21 VARCHAR2,
919 X_DEMAND_HEADER_SEGMENT22 VARCHAR2,
920 X_DEMAND_HEADER_SEGMENT23 VARCHAR2,
921 X_DEMAND_HEADER_SEGMENT24 VARCHAR2,
922 X_DEMAND_HEADER_SEGMENT25 VARCHAR2,
923 X_DEMAND_HEADER_SEGMENT26 VARCHAR2,
924 X_DEMAND_HEADER_SEGMENT27 VARCHAR2,
925 X_DEMAND_HEADER_SEGMENT28 VARCHAR2,
926 X_DEMAND_HEADER_SEGMENT29 VARCHAR2,
927 X_DEMAND_HEADER_SEGMENT30 VARCHAR2,
928 X_EXTERNAL_SOURCE_CODE VARCHAR2,
929 X_EXTERNAL_SOURCE_LINE_ID NUMBER,
933 X_USER_DELIVERY VARCHAR2,
930 X_SUPPLY_SOURCE_TYPE NUMBER,
931 X_SUPPLY_HEADER_ID NUMBER,
932 X_USER_LINE_NUM VARCHAR2,
934 X_REVISION VARCHAR2,
935 X_LOT_NUMBER VARCHAR2,
936 X_SERIAL_NUMBER VARCHAR2,
937 X_SUBINVENTORY VARCHAR2,
938 X_LOCATOR_ID NUMBER,
939 X_LOC_SEGMENT1 VARCHAR2,
940 X_LOC_SEGMENT2 VARCHAR2,
941 X_LOC_SEGMENT3 VARCHAR2,
942 X_LOC_SEGMENT4 VARCHAR2,
943 X_LOC_SEGMENT5 VARCHAR2,
944 X_LOC_SEGMENT6 VARCHAR2,
945 X_LOC_SEGMENT7 VARCHAR2,
946 X_LOC_SEGMENT8 VARCHAR2,
947 X_LOC_SEGMENT9 VARCHAR2,
948 X_LOC_SEGMENT10 VARCHAR2,
949 X_LOC_SEGMENT11 VARCHAR2,
950 X_LOC_SEGMENT12 VARCHAR2,
951 X_LOC_SEGMENT13 VARCHAR2,
952 X_LOC_SEGMENT14 VARCHAR2,
953 X_LOC_SEGMENT15 VARCHAR2,
954 X_LOC_SEGMENT16 VARCHAR2,
955 X_LOC_SEGMENT17 VARCHAR2,
956 X_LOC_SEGMENT18 VARCHAR2,
957 X_LOC_SEGMENT19 VARCHAR2,
958 X_LOC_SEGMENT20 VARCHAR2,
959 X_AUTODETAIL_GROUP_ID NUMBER,
960 X_COMPONENT_SEQUENCE_ID NUMBER,
961 X_PARENT_COMPONENT_SEQ_ID NUMBER,
962 X_RTO_MODEL_SOURCE_LINE VARCHAR2,
963 X_CONFIG_STATUS NUMBER,
964 X_OLD_REVISION VARCHAR2,
965 X_OLD_LOT_NUMBER VARCHAR2,
966 X_OLD_SUBINVENTORY VARCHAR2,
967 X_OLD_LOCATOR_ID NUMBER,
968 X_OLD_LOC_SEGMENT1 VARCHAR2,
969 X_OLD_LOC_SEGMENT2 VARCHAR2,
970 X_OLD_LOC_SEGMENT3 VARCHAR2,
971 X_OLD_LOC_SEGMENT4 VARCHAR2,
972 X_OLD_LOC_SEGMENT5 VARCHAR2,
973 X_OLD_LOC_SEGMENT6 VARCHAR2,
974 X_OLD_LOC_SEGMENT7 VARCHAR2,
975 X_OLD_LOC_SEGMENT8 VARCHAR2,
976 X_OLD_LOC_SEGMENT9 VARCHAR2,
977 X_OLD_LOC_SEGMENT10 VARCHAR2,
978 X_OLD_LOC_SEGMENT11 VARCHAR2,
979 X_OLD_LOC_SEGMENT12 VARCHAR2,
980 X_OLD_LOC_SEGMENT13 VARCHAR2,
981 X_OLD_LOC_SEGMENT14 VARCHAR2,
982 X_OLD_LOC_SEGMENT15 VARCHAR2,
983 X_OLD_LOC_SEGMENT16 VARCHAR2,
984 X_OLD_LOC_SEGMENT17 VARCHAR2,
985 X_OLD_LOC_SEGMENT18 VARCHAR2,
986 X_OLD_LOC_SEGMENT19 VARCHAR2,
987 X_OLD_LOC_SEGMENT20 VARCHAR2,
988 X_DEMAND_CLASS VARCHAR2,
989 X_CUSTOMER_ID NUMBER,
990 X_TERRITORY_ID NUMBER,
991 X_BILL_TO_SITE_USE_ID NUMBER,
992 X_SHIP_TO_SITE_USE_ID NUMBER,
993 X_LOT_EXPIRATION_CUTOFF_DATE DATE,
994 X_PARTIALS_ALLOWED_FLAG NUMBER,
995 X_REQUEST_DATE_ATP_QUANTITY NUMBER,
996 X_EARLIEST_ATP_DATE DATE,
997 X_EARLIEST_ATP_DATE_QUANTITY NUMBER,
998 X_REQUEST_ATP_DATE DATE,
999 X_REQUEST_ATP_DATE_QUANTITY NUMBER,
1000 X_GROUP_AVAILABLE_DATE DATE,
1001 X_ATP_LEAD_TIME NUMBER,
1002 X_INFINITE_TIME_FENCE_DATE DATE,
1003 X_GROUP_ATP_CHECK NUMBER,
1004 X_BOM_LEVEL NUMBER,
1005 X_EXPLOSION_EFFECTIVITY_DATE DATE,
1006 X_ATTRIBUTE_CATEGORY VARCHAR2,
1007 X_ATTRIBUTE1 VARCHAR2,
1008 X_ATTRIBUTE2 VARCHAR2,
1009 X_ATTRIBUTE3 VARCHAR2,
1010 X_ATTRIBUTE4 VARCHAR2,
1011 X_ATTRIBUTE5 VARCHAR2,
1012 X_ATTRIBUTE6 VARCHAR2,
1013 X_ATTRIBUTE7 VARCHAR2,
1014 X_ATTRIBUTE8 VARCHAR2,
1015 X_ATTRIBUTE9 VARCHAR2,
1016 X_ATTRIBUTE10 VARCHAR2,
1017 X_ATTRIBUTE11 VARCHAR2,
1018 X_ATTRIBUTE12 VARCHAR2,
1019 X_ATTRIBUTE13 VARCHAR2,
1020 X_ATTRIBUTE14 VARCHAR2,
1021 X_ATTRIBUTE15 VARCHAR2,
1022 X_C_COLUMN1 VARCHAR2,
1023 X_C_COLUMN2 VARCHAR2,
1024 X_C_COLUMN3 VARCHAR2,
1025 X_C_COLUMN4 VARCHAR2,
1026 X_C_COLUMN5 VARCHAR2,
1027 X_C_COLUMN6 VARCHAR2,
1028 X_C_COLUMN7 VARCHAR2,
1029 X_C_COLUMN8 VARCHAR2,
1030 X_N_COLUMN1 NUMBER,
1031 X_N_COLUMN2 NUMBER,
1035 X_D_COLUMN1 DATE,
1032 X_N_COLUMN3 NUMBER,
1033 X_N_COLUMN4 NUMBER,
1034 X_N_COLUMN5 NUMBER,
1036 X_D_COLUMN2 DATE,
1037 X_D_COLUMN3 DATE,
1038 X_D_COLUMN4 DATE,
1039 X_D_COLUMN5 DATE,
1040 X_TRANSACTION_PROCESS_ORDER NUMBER,
1041 X_DEMAND_ID NUMBER,
1042 X_DEMAND_SOURCE_NAME VARCHAR2,
1043 X_DEMAND_TYPE NUMBER,
1044 X_AVAILABLE_TO_RESERVE NUMBER,
1045 X_QUANTITY_ON_HAND NUMBER,
1046 X_ATP_COMPONENTS_FLAG NUMBER,
1047 X_ATP_CALENDAR_ORGANIZATION_ID NUMBER,
1048 X_AUTODETAIL_EXPENSE_SUBINV NUMBER
1049
1050 ) IS
1051 BEGIN
1052 UPDATE mtl_demand_interface
1053 SET
1054 SCHEDULE_GROUP_ID = X_Schedule_Group_Id,
1055 DEMAND_SOURCE_TYPE = X_DEMAND_SOURCE_TYPE,
1056 DEMAND_SOURCE_HEADER_ID = X_DEMAND_SOURCE_HEADER_ID,
1057 DEMAND_SOURCE_LINE = X_DEMAND_SOURCE_LINE,
1058 DEMAND_SOURCE_DELIVERY = X_DEMAND_SOURCE_DELIVERY,
1059 ATP_CHECK = X_ATP_CHECK,
1060 ACTION_CODE = X_ACTION_CODE,
1061 VALIDATE_ROWS = X_VALIDATE_ROWS,
1062 TRANSACTION_MODE = X_TRANSACTION_MODE,
1063 PROCESS_FLAG = X_PROCESS_FLAG,
1064 SINGLE_LOT_FLAG = X_SINGLE_LOT_FLAG,
1065 DETAIL_RESERVE_FLAG = X_DETAIL_RESERVE_FLAG,
1066 RESERVE_LEVEL = X_RESERVE_LEVEL,
1067 CHECK_ATR = X_CHECK_ATR,
1068 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1069 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1070 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
1071 ERROR_CODE = X_ERROR_CODE,
1072 ERR_EXPLANATION = X_ERR_EXPLANATION,
1073 REQUIREMENT_DATE = X_REQUIREMENT_DATE,
1074 LINE_ITEM_UNIT_OF_MEASURE = X_LINE_ITEM_UNIT_OF_MEASURE,
1075 LINE_ITEM_UOM = X_LINE_ITEM_UOM,
1076 LINE_ITEM_QUANTITY = X_LINE_ITEM_QUANTITY,
1077 LINE_ITEM_RESERVATION_QTY = X_LINE_ITEM_RESERVATION_QTY,
1078 PRIMARY_UOM = X_PRIMARY_UOM,
1079 PRIMARY_UOM_QUANTITY = X_PRIMARY_UOM_QUANTITY,
1080 RESERVATION_QUANTITY = X_RESERVATION_QUANTITY,
1081 ATP_RULE_ID = X_ATP_RULE_ID,
1082 ORGANIZATION_ID = X_ORGANIZATION_ID,
1083 ORGANIZATION_NAME = X_ORGANIZATION_NAME,
1084 INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
1085 ITEM_SEGMENT1 = X_ITEM_SEGMENT1,
1086 ITEM_SEGMENT2 = X_ITEM_SEGMENT2,
1087 ITEM_SEGMENT3 = X_ITEM_SEGMENT3,
1088 ITEM_SEGMENT4 = X_ITEM_SEGMENT4,
1089 ITEM_SEGMENT5 = X_ITEM_SEGMENT5,
1090 ITEM_SEGMENT6 = X_ITEM_SEGMENT6,
1091 ITEM_SEGMENT7 = X_ITEM_SEGMENT7,
1092 ITEM_SEGMENT8 = X_ITEM_SEGMENT8,
1093 ITEM_SEGMENT9 = X_ITEM_SEGMENT9,
1094 ITEM_SEGMENT10 = X_ITEM_SEGMENT10,
1095 ITEM_SEGMENT11 = X_ITEM_SEGMENT11,
1096 ITEM_SEGMENT12 = X_ITEM_SEGMENT12,
1097 ITEM_SEGMENT13 = X_ITEM_SEGMENT13,
1098 ITEM_SEGMENT14 = X_ITEM_SEGMENT14,
1099 ITEM_SEGMENT15 = X_ITEM_SEGMENT15,
1100 ITEM_SEGMENT16 = X_ITEM_SEGMENT16,
1101 ITEM_SEGMENT17 = X_ITEM_SEGMENT17,
1102 ITEM_SEGMENT18 = X_ITEM_SEGMENT18,
1103 ITEM_SEGMENT19 = X_ITEM_SEGMENT19,
1104 ITEM_SEGMENT20 = X_ITEM_SEGMENT20,
1105 DEMAND_HEADER_SEGMENT1 = X_DEMAND_HEADER_SEGMENT1,
1106 DEMAND_HEADER_SEGMENT2 = X_DEMAND_HEADER_SEGMENT2,
1107 DEMAND_HEADER_SEGMENT3 = X_DEMAND_HEADER_SEGMENT3,
1108 DEMAND_HEADER_SEGMENT4 = X_DEMAND_HEADER_SEGMENT4,
1109 DEMAND_HEADER_SEGMENT5 = X_DEMAND_HEADER_SEGMENT5,
1110 DEMAND_HEADER_SEGMENT6 = X_DEMAND_HEADER_SEGMENT6,
1111 DEMAND_HEADER_SEGMENT7 = X_DEMAND_HEADER_SEGMENT7,
1112 DEMAND_HEADER_SEGMENT8 = X_DEMAND_HEADER_SEGMENT8,
1113 DEMAND_HEADER_SEGMENT9 = X_DEMAND_HEADER_SEGMENT9,
1114 DEMAND_HEADER_SEGMENT10 = X_DEMAND_HEADER_SEGMENT10,
1115 DEMAND_HEADER_SEGMENT11 = X_DEMAND_HEADER_SEGMENT11,
1116 DEMAND_HEADER_SEGMENT12 = X_DEMAND_HEADER_SEGMENT12,
1117 DEMAND_HEADER_SEGMENT13 = X_DEMAND_HEADER_SEGMENT13,
1118 DEMAND_HEADER_SEGMENT14 = X_DEMAND_HEADER_SEGMENT14,
1119 DEMAND_HEADER_SEGMENT15 = X_DEMAND_HEADER_SEGMENT15,
1120 DEMAND_HEADER_SEGMENT16 = X_DEMAND_HEADER_SEGMENT16,
1121 DEMAND_HEADER_SEGMENT17 = X_DEMAND_HEADER_SEGMENT17,
1122 DEMAND_HEADER_SEGMENT18 = X_DEMAND_HEADER_SEGMENT18,
1123 DEMAND_HEADER_SEGMENT19 = X_DEMAND_HEADER_SEGMENT19,
1124 DEMAND_HEADER_SEGMENT20 = X_DEMAND_HEADER_SEGMENT20,
1125 DEMAND_HEADER_SEGMENT21 = X_DEMAND_HEADER_SEGMENT21,
1126 DEMAND_HEADER_SEGMENT22 = X_DEMAND_HEADER_SEGMENT22,
1127 DEMAND_HEADER_SEGMENT23 = X_DEMAND_HEADER_SEGMENT23,
1128 DEMAND_HEADER_SEGMENT24 = X_DEMAND_HEADER_SEGMENT24,
1129 DEMAND_HEADER_SEGMENT25 = X_DEMAND_HEADER_SEGMENT25,
1130 DEMAND_HEADER_SEGMENT26 = X_DEMAND_HEADER_SEGMENT26,
1131 DEMAND_HEADER_SEGMENT27 = X_DEMAND_HEADER_SEGMENT27,
1132 DEMAND_HEADER_SEGMENT28 = X_DEMAND_HEADER_SEGMENT28,
1133 DEMAND_HEADER_SEGMENT29 = X_DEMAND_HEADER_SEGMENT29,
1134 DEMAND_HEADER_SEGMENT30 = X_DEMAND_HEADER_SEGMENT30,
1135 EXTERNAL_SOURCE_CODE = X_EXTERNAL_SOURCE_CODE,
1136 EXTERNAL_SOURCE_LINE_ID = X_EXTERNAL_SOURCE_LINE_ID ,
1137 SUPPLY_SOURCE_TYPE = X_SUPPLY_SOURCE_TYPE,
1138 SUPPLY_HEADER_ID = X_SUPPLY_HEADER_ID,
1139 USER_LINE_NUM = X_USER_LINE_NUM,
1140 USER_DELIVERY = X_USER_DELIVERY,
1141 REVISION = X_REVISION,
1142 LOT_NUMBER = X_LOT_NUMBER,
1143 SERIAL_NUMBER = X_SERIAL_NUMBER,
1144 SUBINVENTORY = X_SUBINVENTORY,
1145 LOCATOR_ID = X_LOCATOR_ID,
1146 LOC_SEGMENT1 = X_LOC_SEGMENT1,
1147 LOC_SEGMENT2 = X_LOC_SEGMENT2,
1151 LOC_SEGMENT6 = X_LOC_SEGMENT6,
1148 LOC_SEGMENT3 = X_LOC_SEGMENT3,
1149 LOC_SEGMENT4 = X_LOC_SEGMENT4,
1150 LOC_SEGMENT5 = X_LOC_SEGMENT5,
1152 LOC_SEGMENT7 = X_LOC_SEGMENT7,
1153 LOC_SEGMENT8 = X_LOC_SEGMENT8,
1154 LOC_SEGMENT9 = X_LOC_SEGMENT9,
1155 LOC_SEGMENT10 = X_LOC_SEGMENT10,
1156 LOC_SEGMENT11 = X_LOC_SEGMENT11,
1157 LOC_SEGMENT12 = X_LOC_SEGMENT12,
1158 LOC_SEGMENT13 = X_LOC_SEGMENT13,
1159 LOC_SEGMENT14 = X_LOC_SEGMENT14,
1160 LOC_SEGMENT15 = X_LOC_SEGMENT15,
1161 LOC_SEGMENT16 = X_LOC_SEGMENT16,
1162 LOC_SEGMENT17 = X_LOC_SEGMENT17,
1163 LOC_SEGMENT18 = X_LOC_SEGMENT18,
1164 LOC_SEGMENT19 = X_LOC_SEGMENT19,
1165 LOC_SEGMENT20 = X_LOC_SEGMENT20,
1166 AUTODETAIL_GROUP_ID = X_AUTODETAIL_GROUP_ID,
1167 COMPONENT_SEQUENCE_ID = X_COMPONENT_SEQUENCE_ID,
1168 PARENT_COMPONENT_SEQ_ID = X_PARENT_COMPONENT_SEQ_ID,
1169 RTO_MODEL_SOURCE_LINE = X_RTO_MODEL_SOURCE_LINE,
1170 CONFIG_STATUS = X_CONFIG_STATUS,
1171 OLD_REVISION = X_OLD_REVISION,
1172 OLD_LOT_NUMBER = X_OLD_LOT_NUMBER,
1173 OLD_SUBINVENTORY = X_OLD_SUBINVENTORY,
1174 OLD_LOCATOR_ID = X_OLD_LOCATOR_ID,
1175 OLD_LOC_SEGMENT1 = X_OLD_LOC_SEGMENT1,
1176 OLD_LOC_SEGMENT2 = X_OLD_LOC_SEGMENT2,
1177 OLD_LOC_SEGMENT3 = X_OLD_LOC_SEGMENT3,
1178 OLD_LOC_SEGMENT4 = X_OLD_LOC_SEGMENT4,
1179 OLD_LOC_SEGMENT5 = X_OLD_LOC_SEGMENT5,
1180 OLD_LOC_SEGMENT6 = X_OLD_LOC_SEGMENT6,
1181 OLD_LOC_SEGMENT7 = X_OLD_LOC_SEGMENT7,
1182 OLD_LOC_SEGMENT8 = X_OLD_LOC_SEGMENT8,
1183 OLD_LOC_SEGMENT9 = X_OLD_LOC_SEGMENT9,
1184 OLD_LOC_SEGMENT10 = X_OLD_LOC_SEGMENT10,
1185 OLD_LOC_SEGMENT11 = X_OLD_LOC_SEGMENT11,
1186 OLD_LOC_SEGMENT12 = X_OLD_LOC_SEGMENT12,
1187 OLD_LOC_SEGMENT13 = X_OLD_LOC_SEGMENT13,
1188 OLD_LOC_SEGMENT14 = X_OLD_LOC_SEGMENT14,
1189 OLD_LOC_SEGMENT15 = X_OLD_LOC_SEGMENT15,
1190 OLD_LOC_SEGMENT16 = X_OLD_LOC_SEGMENT16,
1191 OLD_LOC_SEGMENT17 = X_OLD_LOC_SEGMENT17,
1192 OLD_LOC_SEGMENT18 = X_OLD_LOC_SEGMENT18,
1193 OLD_LOC_SEGMENT19 = X_OLD_LOC_SEGMENT19,
1194 OLD_LOC_SEGMENT20 = X_OLD_LOC_SEGMENT20,
1195 DEMAND_CLASS = X_DEMAND_CLASS,
1196 CUSTOMER_ID = X_CUSTOMER_ID,
1197 TERRITORY_ID = X_TERRITORY_ID,
1198 BILL_TO_SITE_USE_ID = X_BILL_TO_SITE_USE_ID,
1199 SHIP_TO_SITE_USE_ID = X_SHIP_TO_SITE_USE_ID,
1200 LOT_EXPIRATION_CUTOFF_DATE = X_LOT_EXPIRATION_CUTOFF_DATE,
1201 PARTIALS_ALLOWED_FLAG = X_PARTIALS_ALLOWED_FLAG,
1202 REQUEST_DATE_ATP_QUANTITY = X_REQUEST_DATE_ATP_QUANTITY ,
1203 EARLIEST_ATP_DATE = X_EARLIEST_ATP_DATE,
1204 EARLIEST_ATP_DATE_QUANTITY = X_EARLIEST_ATP_DATE_QUANTITY ,
1205 REQUEST_ATP_DATE = X_REQUEST_ATP_DATE,
1206 REQUEST_ATP_DATE_QUANTITY = X_REQUEST_ATP_DATE_QUANTITY,
1207 GROUP_AVAILABLE_DATE = X_GROUP_AVAILABLE_DATE,
1208 ATP_LEAD_TIME = X_ATP_LEAD_TIME,
1209 INFINITE_TIME_FENCE_DATE = X_INFINITE_TIME_FENCE_DATE,
1210 GROUP_ATP_CHECK = X_GROUP_ATP_CHECK,
1211 BOM_LEVEL = X_BOM_LEVEL,
1212 EXPLOSION_EFFECTIVITY_DATE = X_EXPLOSION_EFFECTIVITY_DATE ,
1213 ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
1214 ATTRIBUTE1 = X_ATTRIBUTE1,
1215 ATTRIBUTE2 = X_ATTRIBUTE2,
1216 ATTRIBUTE3 = X_ATTRIBUTE3,
1217 ATTRIBUTE4 = X_ATTRIBUTE4,
1218 ATTRIBUTE5 = X_ATTRIBUTE5,
1219 ATTRIBUTE6 = X_ATTRIBUTE6,
1220 ATTRIBUTE7 = X_ATTRIBUTE7,
1221 ATTRIBUTE8 = X_ATTRIBUTE8,
1222 ATTRIBUTE9 = X_ATTRIBUTE9,
1223 ATTRIBUTE10 = X_ATTRIBUTE10,
1224 ATTRIBUTE11 = X_ATTRIBUTE11,
1225 ATTRIBUTE12 = X_ATTRIBUTE12,
1226 ATTRIBUTE13 = X_ATTRIBUTE13,
1227 ATTRIBUTE14 = X_ATTRIBUTE14,
1228 ATTRIBUTE15 = X_ATTRIBUTE15,
1229 C_COLUMN1 = X_C_COLUMN1,
1230 C_COLUMN2 = X_C_COLUMN2,
1231 C_COLUMN3 = X_C_COLUMN3,
1232 C_COLUMN4 = X_C_COLUMN4,
1233 C_COLUMN5 = X_C_COLUMN5,
1234 C_COLUMN6 = X_C_COLUMN6,
1235 C_COLUMN7 = X_C_COLUMN7,
1236 C_COLUMN8 = X_C_COLUMN8,
1237 N_COLUMN1 = X_N_COLUMN1,
1238 N_COLUMN2 = X_N_COLUMN2,
1239 N_COLUMN3 = X_N_COLUMN3,
1240 N_COLUMN4 = X_N_COLUMN4,
1241 N_COLUMN5 = X_N_COLUMN5,
1242 D_COLUMN1 = X_D_COLUMN1 ,
1243 D_COLUMN2 = X_D_COLUMN2,
1244 D_COLUMN3 = X_D_COLUMN3,
1245 D_COLUMN4 = X_D_COLUMN4,
1246 D_COLUMN5 = X_D_COLUMN5,
1247 TRANSACTION_PROCESS_ORDER = X_TRANSACTION_PROCESS_ORDER,
1248 DEMAND_ID = X_DEMAND_ID,
1249 DEMAND_SOURCE_NAME = X_DEMAND_SOURCE_NAME,
1250 DEMAND_TYPE = X_DEMAND_TYPE,
1251 AVAILABLE_TO_RESERVE = X_AVAILABLE_TO_RESERVE,
1252 QUANTITY_ON_HAND = X_QUANTITY_ON_HAND,
1253 ATP_COMPONENTS_FLAG = X_ATP_COMPONENTS_FLAG,
1254 ATP_CALENDAR_ORGANIZATION_ID = X_ATP_CALENDAR_ORGANIZATION_ID,
1255 AUTODETAIL_EXPENSE_SUBINV_FLAG = X_AUTODETAIL_EXPENSE_SUBINV
1256 WHERE rowid = X_Rowid;
1257 if (SQL%NOTFOUND) then
1258 Raise NO_DATA_FOUND;
1259 end if;
1260 END Update_Row;
1261
1262 END MTL_DEMAND_INTERFACE_PKG;