[Home] [Help]
PACKAGE BODY: APPS.MTL_CYCLE_COUNT_HEADERS_PKG
Source
1 PACKAGE BODY MTL_CYCLE_COUNT_HEADERS_PKG as
2 /* $Header: INVADCYB.pls 120.1 2005/06/19 05:43:32 appldev $ */
3 --Added NOCOPY hint to X_Rowid IN OUT parameter to comply with
4 --GSCC File.Sql.39 standard Bug:4410902
5 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
6 X_Cycle_Count_Header_Id NUMBER,
7 X_Organization_Id NUMBER,
8 X_Last_Update_Date DATE,
9 X_Last_Updated_By NUMBER,
10 X_Creation_Date DATE,
11 X_Created_By NUMBER,
12 X_Last_Update_Login NUMBER,
13 X_Cycle_Count_Header_Name VARCHAR2,
14 X_Inventory_Adjustment_Account NUMBER,
15 X_Orientation_Code NUMBER,
16 X_Abc_Assignment_Group_Id NUMBER,
17 X_Onhand_Visible_Flag NUMBER,
18 X_Days_Until_Late NUMBER,
19 X_Autoschedule_Enabled_Flag NUMBER,
20 X_Schedule_Interval_Time NUMBER,
21 X_Zero_Count_Flag NUMBER,
22 X_Header_Last_Schedule_Date DATE,
23 X_Header_Next_Schedule_Date DATE,
24 X_Disable_Date DATE,
25 X_Approval_Option_Code NUMBER,
26 X_Automatic_Recount_Flag NUMBER,
27 X_Next_User_Count_Sequence NUMBER,
28 X_Unscheduled_Count_Entry NUMBER,
29 X_Cycle_Count_Calendar VARCHAR2,
30 X_Calendar_Exception_Set NUMBER,
31 X_Approval_Tolerance_Positive NUMBER,
32 X_Approval_Tolerance_Negative NUMBER,
33 X_Cost_Tolerance_Positive NUMBER,
34 X_Cost_Tolerance_Negative NUMBER,
35 X_Hit_Miss_Tolerance_Positive NUMBER,
36 X_Hit_Miss_Tolerance_Negative NUMBER,
37 X_Abc_Initialization_Status NUMBER,
38 X_Description VARCHAR2,
39 X_Attribute_Category VARCHAR2,
40 X_Attribute1 VARCHAR2,
41 X_Attribute2 VARCHAR2,
42 X_Attribute3 VARCHAR2,
43 X_Attribute4 VARCHAR2,
44 X_Attribute5 VARCHAR2,
45 X_Attribute6 VARCHAR2,
46 X_Attribute7 VARCHAR2,
47 X_Attribute8 VARCHAR2,
48 X_Attribute9 VARCHAR2,
49 X_Attribute10 VARCHAR2,
50 X_Attribute11 VARCHAR2,
51 X_Attribute12 VARCHAR2,
52 X_Attribute13 VARCHAR2,
53 X_Attribute14 VARCHAR2,
54 X_Attribute15 VARCHAR2,
55 X_Maximum_Auto_Recounts NUMBER,
56 X_Serial_Count_Option NUMBER,
57 X_Serial_Detail_Option NUMBER,
58 X_Serial_Adjustment_Option NUMBER,
59 X_Serial_Discrepancy_Option NUMBER
60 , X_Container_Enabled_Flag NUMBER DEFAULT NULL
61 , X_Container_Adjustment_Option NUMBER DEFAULT NULL
62 , X_Container_Discrepancy_Option NUMBER DEFAULT NULL
63 ) IS
64 CURSOR C IS SELECT rowid FROM mtl_cycle_count_headers
65 WHERE cycle_count_header_id = X_Cycle_Count_Header_Id;
66
67 BEGIN
68 INSERT INTO mtl_cycle_count_headers(
69 cycle_count_header_id,
70 organization_id,
71 last_update_date,
72 last_updated_by,
73 creation_date,
74 created_by,
75 last_update_login,
76 cycle_count_header_name,
77 inventory_adjustment_account,
78 orientation_code,
79 abc_assignment_group_id,
80 onhand_visible_flag,
81 days_until_late,
82 autoschedule_enabled_flag,
83 schedule_interval_time,
84 zero_count_flag,
85 header_last_schedule_date,
86 header_next_schedule_date,
87 disable_date,
88 approval_option_code,
89 automatic_recount_flag,
90 next_user_count_sequence,
91 unscheduled_count_entry,
92 cycle_count_calendar,
93 calendar_exception_set,
94 approval_tolerance_positive,
95 approval_tolerance_negative,
96 cost_tolerance_positive,
97 cost_tolerance_negative,
98 hit_miss_tolerance_positive,
99 hit_miss_tolerance_negative,
100 abc_initialization_status,
101 description,
102 attribute_category,
103 attribute1,
104 attribute2,
105 attribute3,
106 attribute4,
107 attribute5,
108 attribute6,
109 attribute7,
110 attribute8,
111 attribute9,
112 attribute10,
113 attribute11,
114 attribute12,
115 attribute13,
116 attribute14,
117 attribute15,
118 maximum_auto_recounts,
119 serial_count_option,
120 serial_detail_option,
121 serial_adjustment_option,
122 serial_discrepancy_option
123 , Container_Enabled_Flag
124 , Container_Adjustment_Option
125 , Container_Discrepancy_Option
126 )
127 VALUES (
128 X_Cycle_Count_Header_Id,
129 X_Organization_Id,
130 X_Last_Update_Date,
131 X_Last_Updated_By,
132 X_Creation_Date,
133 X_Created_By,
134 X_Last_Update_Login,
135 X_Cycle_Count_Header_Name,
136 X_Inventory_Adjustment_Account,
137 X_Orientation_Code,
138 X_Abc_Assignment_Group_Id,
139 X_Onhand_Visible_Flag,
140 X_Days_Until_Late,
141 X_Autoschedule_Enabled_Flag,
142 X_Schedule_Interval_Time,
143 X_Zero_Count_Flag,
144 X_Header_Last_Schedule_Date,
145 X_Header_Next_Schedule_Date,
146 X_Disable_Date,
147 X_Approval_Option_Code,
148 X_Automatic_Recount_Flag,
149 X_Next_User_Count_Sequence,
150 X_Unscheduled_Count_Entry,
151 X_Cycle_Count_Calendar,
152 X_Calendar_Exception_Set,
153 X_Approval_Tolerance_Positive,
154 X_Approval_Tolerance_Negative,
155 X_Cost_Tolerance_Positive,
156 X_Cost_Tolerance_Negative,
157 X_Hit_Miss_Tolerance_Positive,
158 X_Hit_Miss_Tolerance_Negative,
159 X_Abc_Initialization_Status,
160 X_Description,
161 X_Attribute_Category,
162 X_Attribute1,
163 X_Attribute2,
164 X_Attribute3,
165 X_Attribute4,
166 X_Attribute5,
167 X_Attribute6,
168 X_Attribute7,
169 X_Attribute8,
170 X_Attribute9,
171 X_Attribute10,
172 X_Attribute11,
173 X_Attribute12,
174 X_Attribute13,
175 X_Attribute14,
176 X_Attribute15,
177 X_Maximum_Auto_Recounts,
178 X_Serial_Count_Option,
179 X_Serial_Detail_Option,
180 X_Serial_Adjustment_Option,
181 X_Serial_Discrepancy_Option
182 , X_Container_Enabled_Flag
183 , X_Container_Adjustment_Option
184 , X_Container_Discrepancy_Option
185 );
186
187 OPEN C;
188 FETCH C INTO X_Rowid;
189 if (C%NOTFOUND) then
190 CLOSE C;
191 Raise NO_DATA_FOUND;
192 end if;
193 CLOSE C;
194 END Insert_Row;
195
196
197 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
198 X_Cycle_Count_Header_Id NUMBER,
199 X_Organization_Id NUMBER,
200 X_Cycle_Count_Header_Name VARCHAR2,
201 X_Inventory_Adjustment_Account NUMBER,
202 X_Orientation_Code NUMBER,
203 X_Abc_Assignment_Group_Id NUMBER,
204 X_Onhand_Visible_Flag NUMBER,
205 X_Days_Until_Late NUMBER,
206 X_Autoschedule_Enabled_Flag NUMBER,
207 X_Schedule_Interval_Time NUMBER,
208 X_Zero_Count_Flag NUMBER,
209 X_Header_Last_Schedule_Date DATE,
210 X_Header_Next_Schedule_Date DATE,
211 X_Disable_Date DATE,
212 X_Approval_Option_Code NUMBER,
213 X_Automatic_Recount_Flag NUMBER,
214 X_Next_User_Count_Sequence NUMBER,
215 X_Unscheduled_Count_Entry NUMBER,
216 X_Cycle_Count_Calendar VARCHAR2,
217 X_Calendar_Exception_Set NUMBER,
218 X_Approval_Tolerance_Positive NUMBER,
219 X_Approval_Tolerance_Negative NUMBER,
220 X_Cost_Tolerance_Positive NUMBER,
221 X_Cost_Tolerance_Negative NUMBER,
222 X_Hit_Miss_Tolerance_Positive NUMBER,
223 X_Hit_Miss_Tolerance_Negative NUMBER,
224 X_Abc_Initialization_Status NUMBER,
225 X_Description VARCHAR2,
226 X_Attribute_Category VARCHAR2,
227 X_Attribute1 VARCHAR2,
228 X_Attribute2 VARCHAR2,
229 X_Attribute3 VARCHAR2,
230 X_Attribute4 VARCHAR2,
231 X_Attribute5 VARCHAR2,
232 X_Attribute6 VARCHAR2,
233 X_Attribute7 VARCHAR2,
234 X_Attribute8 VARCHAR2,
235 X_Attribute9 VARCHAR2,
236 X_Attribute10 VARCHAR2,
237 X_Attribute11 VARCHAR2,
238 X_Attribute12 VARCHAR2,
239 X_Attribute13 VARCHAR2,
240 X_Attribute14 VARCHAR2,
241 X_Attribute15 VARCHAR2,
242 X_Maximum_Auto_Recounts NUMBER,
243 X_Serial_Count_Option NUMBER,
244 X_Serial_Detail_Option NUMBER,
245 X_Serial_Adjustment_Option NUMBER,
246 X_Serial_Discrepancy_Option NUMBER
247 , X_Container_Enabled_Flag NUMBER DEFAULT NULL
248 , X_Container_Adjustment_Option NUMBER DEFAULT NULL
249 , X_Container_Discrepancy_Option NUMBER DEFAULT NULL
250 ) IS
251 CURSOR C IS
252 SELECT *
253 FROM mtl_cycle_count_headers
254 WHERE rowid = X_Rowid
255 FOR UPDATE of Cycle_Count_Header_Id NOWAIT;
256 Recinfo C%ROWTYPE;
257
258 BEGIN
259 OPEN C;
260 FETCH C INTO Recinfo;
261 if (C%NOTFOUND) then
262 CLOSE C;
263 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
264 APP_EXCEPTION.Raise_Exception;
265 end if;
266 CLOSE C;
267 if (
268 (Recinfo.cycle_count_header_id = X_Cycle_Count_Header_Id)
269 AND (Recinfo.organization_id = X_Organization_Id)
270 AND (Recinfo.cycle_count_header_name = X_Cycle_Count_Header_Name)
271 AND (Recinfo.inventory_adjustment_account = X_Inventory_Adjustment_Account)
272 AND (Recinfo.orientation_code = X_Orientation_Code)
273 AND ( (Recinfo.abc_assignment_group_id = X_Abc_Assignment_Group_Id)
274 OR ( (Recinfo.abc_assignment_group_id IS NULL)
275 AND (X_Abc_Assignment_Group_Id IS NULL)))
276 AND ( (Recinfo.onhand_visible_flag = X_Onhand_Visible_Flag)
277 OR ( (Recinfo.onhand_visible_flag IS NULL)
278 AND (X_Onhand_Visible_Flag IS NULL)))
279 AND ( (Recinfo.days_until_late = X_Days_Until_Late)
280 OR ( (Recinfo.days_until_late IS NULL)
281 AND (X_Days_Until_Late IS NULL)))
282 AND (Recinfo.autoschedule_enabled_flag = X_Autoschedule_Enabled_Flag)
283 AND ( (Recinfo.schedule_interval_time = X_Schedule_Interval_Time)
284 OR ( (Recinfo.schedule_interval_time IS NULL)
285 AND (X_Schedule_Interval_Time IS NULL)))
286 AND ( (Recinfo.zero_count_flag = X_Zero_Count_Flag)
287 OR ( (Recinfo.zero_count_flag IS NULL)
288 AND (X_Zero_Count_Flag IS NULL)))
289 AND ( (Recinfo.header_last_schedule_date = X_Header_Last_Schedule_Date)
290 OR ( (Recinfo.header_last_schedule_date IS NULL)
291 AND (X_Header_Last_Schedule_Date IS NULL)))
292 AND ( (Recinfo.header_next_schedule_date = X_Header_Next_Schedule_Date)
293 OR ( (Recinfo.header_next_schedule_date IS NULL)
294 AND (X_Header_Next_Schedule_Date IS NULL)))
295 AND ( (Recinfo.disable_date = X_Disable_Date)
296 OR ( (Recinfo.disable_date IS NULL)
297 AND (X_Disable_Date IS NULL)))
298 AND ( (Recinfo.approval_option_code = X_Approval_Option_Code)
299 OR ( (Recinfo.approval_option_code IS NULL)
300 AND (X_Approval_Option_Code IS NULL)))
301 AND ( (Recinfo.automatic_recount_flag = X_Automatic_Recount_Flag)
302 OR ( (Recinfo.automatic_recount_flag IS NULL)
303 AND (X_Automatic_Recount_Flag IS NULL)))
304 AND ( (Recinfo.next_user_count_sequence = X_Next_User_Count_Sequence)
305 OR ( (Recinfo.next_user_count_sequence IS NULL)
306 AND (X_Next_User_Count_Sequence IS NULL)))
307 AND ( (Recinfo.unscheduled_count_entry = X_Unscheduled_Count_Entry)
308 OR ( (Recinfo.unscheduled_count_entry IS NULL)
309 AND (X_Unscheduled_Count_Entry IS NULL)))
310 AND ( (Recinfo.cycle_count_calendar = X_Cycle_Count_Calendar)
311 OR ( (Recinfo.cycle_count_calendar IS NULL)
312 AND (X_Cycle_Count_Calendar IS NULL)))
313 AND ( (Recinfo.calendar_exception_set = X_Calendar_Exception_Set)
314 OR ( (Recinfo.calendar_exception_set IS NULL)
315 AND (X_Calendar_Exception_Set IS NULL)))
316 AND ( (Recinfo.approval_tolerance_positive = X_Approval_Tolerance_Positive)
317 OR ( (Recinfo.approval_tolerance_positive IS NULL)
318 AND (X_Approval_Tolerance_Positive IS NULL)))
319 AND ( (Recinfo.approval_tolerance_negative = X_Approval_Tolerance_Negative)
320 OR ( (Recinfo.approval_tolerance_negative IS NULL)
321 AND (X_Approval_Tolerance_Negative IS NULL)))
322 AND ( (Recinfo.cost_tolerance_positive = X_Cost_Tolerance_Positive)
323 OR ( (Recinfo.cost_tolerance_positive IS NULL)
324 AND (X_Cost_Tolerance_Positive IS NULL)))
325 AND ( (Recinfo.cost_tolerance_negative = X_Cost_Tolerance_Negative)
326 OR ( (Recinfo.cost_tolerance_negative IS NULL)
327 AND (X_Cost_Tolerance_Negative IS NULL)))
328 AND ( (Recinfo.hit_miss_tolerance_positive = X_Hit_Miss_Tolerance_Positive)
329 OR ( (Recinfo.hit_miss_tolerance_positive IS NULL)
330 AND (X_Hit_Miss_Tolerance_Positive IS NULL)))
331 AND ( (Recinfo.hit_miss_tolerance_negative = X_Hit_Miss_Tolerance_Negative)
332 OR ( (Recinfo.hit_miss_tolerance_negative IS NULL)
333 AND (X_Hit_Miss_Tolerance_Negative IS NULL)))
334 AND ( (Recinfo.abc_initialization_status = X_Abc_Initialization_Status)
335 OR ( (Recinfo.abc_initialization_status IS NULL)
336 AND (X_Abc_Initialization_Status IS NULL)))
337 AND ( (Recinfo.description = X_Description)
338 OR ( (Recinfo.description IS NULL)
339 AND (X_Description IS NULL)))
340 AND ( (Recinfo.attribute_category = X_Attribute_Category)
341 OR ( (Recinfo.attribute_category IS NULL)
342 AND (X_Attribute_Category IS NULL)))
343 AND ( (Recinfo.attribute1 = X_Attribute1)
344 OR ( (Recinfo.attribute1 IS NULL)
345 AND (X_Attribute1 IS NULL)))
346 AND ( (Recinfo.attribute2 = X_Attribute2)
347 OR ( (Recinfo.attribute2 IS NULL)
348 AND (X_Attribute2 IS NULL)))
349 AND ( (Recinfo.attribute3 = X_Attribute3)
350 OR ( (Recinfo.attribute3 IS NULL)
351 AND (X_Attribute3 IS NULL)))
352 AND ( (Recinfo.attribute4 = X_Attribute4)
353 OR ( (Recinfo.attribute4 IS NULL)
354 AND (X_Attribute4 IS NULL)))
355 AND ( (Recinfo.attribute5 = X_Attribute5)
356 OR ( (Recinfo.attribute5 IS NULL)
357 AND (X_Attribute5 IS NULL)))
358 AND ( (Recinfo.attribute6 = X_Attribute6)
359 OR ( (Recinfo.attribute6 IS NULL)
360 AND (X_Attribute6 IS NULL)))
361 AND ( (Recinfo.attribute7 = X_Attribute7)
362 OR ( (Recinfo.attribute7 IS NULL)
363 AND (X_Attribute7 IS NULL)))
364 AND ( (Recinfo.attribute8 = X_Attribute8)
365 OR ( (Recinfo.attribute8 IS NULL)
366 AND (X_Attribute8 IS NULL)))
367 AND ( (Recinfo.attribute9 = X_Attribute9)
368 OR ( (Recinfo.attribute9 IS NULL)
369 AND (X_Attribute9 IS NULL)))
370 AND ( (Recinfo.attribute10 = X_Attribute10)
371 OR ( (Recinfo.attribute10 IS NULL)
372 AND (X_Attribute10 IS NULL)))
373 AND ( (Recinfo.attribute11 = X_Attribute11)
374 OR ( (Recinfo.attribute11 IS NULL)
375 AND (X_Attribute11 IS NULL)))
376 AND ( (Recinfo.attribute12 = X_Attribute12)
377 OR ( (Recinfo.attribute12 IS NULL)
378 AND (X_Attribute12 IS NULL)))
379 AND ( (Recinfo.attribute13 = X_Attribute13)
380 OR ( (Recinfo.attribute13 IS NULL)
381 AND (X_Attribute13 IS NULL)))
382 AND ( (Recinfo.attribute14 = X_Attribute14)
383 OR ( (Recinfo.attribute14 IS NULL)
384 AND (X_Attribute14 IS NULL)))
385 AND ( (Recinfo.attribute15 = X_Attribute15)
386 OR ( (Recinfo.attribute15 IS NULL)
387 AND (X_Attribute15 IS NULL)))
388 AND ( (Recinfo.maximum_auto_recounts = X_Maximum_Auto_Recounts)
389 OR ( (Recinfo.maximum_auto_recounts IS NULL)
390 AND (X_Maximum_Auto_Recounts IS NULL)))
391 AND ( (Recinfo.serial_count_option = X_Serial_Count_Option)
392 OR ( (Recinfo.serial_count_option IS NULL)
393 AND ( X_Serial_Count_Option IS NULL)))
394 AND ( (Recinfo.serial_detail_option = X_Serial_Detail_Option)
395 OR ( (Recinfo.serial_detail_option IS NULL)
396 AND ( X_Serial_Detail_Option IS NULL)))
397 AND ( (Recinfo.serial_adjustment_option = X_Serial_Adjustment_Option)
398 OR ( (Recinfo.serial_adjustment_option IS NULL)
399 AND ( X_Serial_Adjustment_Option IS NULL)))
400 AND ( (Recinfo.serial_discrepancy_option = X_Serial_Discrepancy_Option)
401 OR ( (Recinfo.serial_discrepancy_option IS NULL)
402 AND ( X_Serial_Discrepancy_Option IS NULL)))
403 AND ( (Recinfo.container_enabled_flag = X_container_enabled_flag)
404 OR ( (Recinfo.container_enabled_flag IS NULL)
405 AND ( X_container_enabled_flag IS NULL)))
406 AND ( (Recinfo.container_adjustment_option = X_Container_Adjustment_Option)
407 OR ( (Recinfo.container_adjustment_option IS NULL)
408 AND ( X_Container_Adjustment_Option IS NULL)))
409 AND ( (Recinfo.container_discrepancy_option = X_Container_Discrepancy_Option)
410 OR ( (Recinfo.container_discrepancy_option IS NULL)
411 AND ( X_Container_Discrepancy_Option IS NULL)))
412 ) then
413 return;
414 else
415 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
416 APP_EXCEPTION.Raise_Exception;
417 end if;
418 END Lock_Row;
419
420
421 PROCEDURE Update_Row(X_Rowid VARCHAR2,
422 X_Cycle_Count_Header_Id NUMBER,
423 X_Organization_Id NUMBER,
424 X_Last_Update_Date DATE,
425 X_Last_Updated_By NUMBER,
426 X_Last_Update_Login NUMBER,
427 X_Cycle_Count_Header_Name VARCHAR2,
428 X_Inventory_Adjustment_Account NUMBER,
429 X_Orientation_Code NUMBER,
430 X_Abc_Assignment_Group_Id NUMBER,
431 X_Onhand_Visible_Flag NUMBER,
432 X_Days_Until_Late NUMBER,
433 X_Autoschedule_Enabled_Flag NUMBER,
434 X_Schedule_Interval_Time NUMBER,
435 X_Zero_Count_Flag NUMBER,
436 X_Header_Last_Schedule_Date DATE,
437 X_Header_Next_Schedule_Date DATE,
438 X_Disable_Date DATE,
439 X_Approval_Option_Code NUMBER,
440 X_Automatic_Recount_Flag NUMBER,
441 X_Next_User_Count_Sequence NUMBER,
442 X_Unscheduled_Count_Entry NUMBER,
443 X_Cycle_Count_Calendar VARCHAR2,
444 X_Calendar_Exception_Set NUMBER,
445 X_Approval_Tolerance_Positive NUMBER,
446 X_Approval_Tolerance_Negative NUMBER,
447 X_Cost_Tolerance_Positive NUMBER,
448 X_Cost_Tolerance_Negative NUMBER,
449 X_Hit_Miss_Tolerance_Positive NUMBER,
450 X_Hit_Miss_Tolerance_Negative NUMBER,
451 X_Abc_Initialization_Status NUMBER,
452 X_Description VARCHAR2,
453 X_Attribute_Category VARCHAR2,
454 X_Attribute1 VARCHAR2,
455 X_Attribute2 VARCHAR2,
456 X_Attribute3 VARCHAR2,
457 X_Attribute4 VARCHAR2,
458 X_Attribute5 VARCHAR2,
459 X_Attribute6 VARCHAR2,
460 X_Attribute7 VARCHAR2,
461 X_Attribute8 VARCHAR2,
462 X_Attribute9 VARCHAR2,
463 X_Attribute10 VARCHAR2,
464 X_Attribute11 VARCHAR2,
465 X_Attribute12 VARCHAR2,
466 X_Attribute13 VARCHAR2,
467 X_Attribute14 VARCHAR2,
468 X_Attribute15 VARCHAR2,
469 X_Maximum_Auto_Recounts NUMBER,
470 X_Serial_Count_Option NUMBER,
471 X_Serial_Detail_Option NUMBER,
472 X_Serial_Adjustment_Option NUMBER,
473 X_Serial_Discrepancy_Option NUMBER
474 , X_Container_Enabled_Flag NUMBER DEFAULT NULL
475 , X_Container_Adjustment_Option NUMBER DEFAULT NULL
476 , X_Container_Discrepancy_Option NUMBER DEFAULT NULL
477 ) IS
478
479 BEGIN
480 UPDATE mtl_cycle_count_headers
481 SET
482 cycle_count_header_id = X_Cycle_Count_Header_Id,
483 organization_id = X_Organization_Id,
484 last_update_date = X_Last_Update_Date,
485 last_updated_by = X_Last_Updated_By,
486 last_update_login = X_Last_Update_Login,
487 cycle_count_header_name = X_Cycle_Count_Header_Name,
488 inventory_adjustment_account = X_Inventory_Adjustment_Account,
489 orientation_code = X_Orientation_Code,
490 abc_assignment_group_id = X_Abc_Assignment_Group_Id,
491 onhand_visible_flag = X_Onhand_Visible_Flag,
492 days_until_late = X_Days_Until_Late,
493 autoschedule_enabled_flag = X_Autoschedule_Enabled_Flag,
494 schedule_interval_time = X_Schedule_Interval_Time,
495 zero_count_flag = X_Zero_Count_Flag,
496 header_last_schedule_date = X_Header_Last_Schedule_Date,
497 header_next_schedule_date = X_Header_Next_Schedule_Date,
498 disable_date = X_Disable_Date,
499 approval_option_code = X_Approval_Option_Code,
500 automatic_recount_flag = X_Automatic_Recount_Flag,
501 next_user_count_sequence = X_Next_User_Count_Sequence,
502 unscheduled_count_entry = X_Unscheduled_Count_Entry,
503 cycle_count_calendar = X_Cycle_Count_Calendar,
504 calendar_exception_set = X_Calendar_Exception_Set,
505 approval_tolerance_positive = X_Approval_Tolerance_Positive,
506 approval_tolerance_negative = X_Approval_Tolerance_Negative,
507 cost_tolerance_positive = X_Cost_Tolerance_Positive,
508 cost_tolerance_negative = X_Cost_Tolerance_Negative,
509 hit_miss_tolerance_positive = X_Hit_Miss_Tolerance_Positive,
510 hit_miss_tolerance_negative = X_Hit_Miss_Tolerance_Negative,
511 abc_initialization_status = X_Abc_Initialization_Status,
512 description = X_Description,
513 attribute_category = X_Attribute_Category,
514 attribute1 = X_Attribute1,
515 attribute2 = X_Attribute2,
516 attribute3 = X_Attribute3,
517 attribute4 = X_Attribute4,
518 attribute5 = X_Attribute5,
519 attribute6 = X_Attribute6,
520 attribute7 = X_Attribute7,
521 attribute8 = X_Attribute8,
522 attribute9 = X_Attribute9,
523 attribute10 = X_Attribute10,
524 attribute11 = X_Attribute11,
525 attribute12 = X_Attribute12,
526 attribute13 = X_Attribute13,
527 attribute14 = X_Attribute14,
528 attribute15 = X_Attribute15,
529 maximum_auto_recounts = X_Maximum_Auto_Recounts,
530 serial_count_option = X_Serial_Count_Option,
531 serial_detail_option = X_Serial_Detail_Option,
532 serial_adjustment_option = X_Serial_Adjustment_Option,
533 serial_discrepancy_option = X_Serial_Discrepancy_Option
534 , Container_Enabled_Flag = X_Container_Enabled_Flag
535 , Container_Adjustment_Option = X_Container_Adjustment_Option
536 , Container_Discrepancy_Option = X_Container_Discrepancy_Option
537 WHERE rowid = X_Rowid;
538
539 if (SQL%NOTFOUND) then
540 Raise NO_DATA_FOUND;
541 end if;
542 END Update_Row;
543 PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
544 BEGIN
545 DELETE FROM mtl_cycle_count_headers
546 WHERE rowid = X_Rowid;
547
548 if (SQL%NOTFOUND) then
549 Raise NO_DATA_FOUND;
550 end if;
551 END Delete_Row;
552
553
554 END MTL_CYCLE_COUNT_HEADERS_PKG;